Doc

Details

Grants

References

Dependencies

Code




Method Summary
 ins_Accion( paramISINId IN Accion . ISINId % TYPE , paramTicker IN Accion . Ticker % TYPE , paramTickerDescripcion IN Accion . TickerDescripcion % TYPE , paramMercadoId IN Accion . MercadoId % TYPE , RSP OUT NOCOPY VARCHAR2 )
          
 ins_Mercado( paramMercadoId IN Mercado . MercadoId % TYPE , paramMercadoDescripcion IN Mercado . MercadoDescripcion % TYPE , RSP OUT NOCOPY VARCHAR2 )
          
 ins_OrdenEstado( paramEstadoId IN OrdenEstado . EstadoId % TYPE , paramEstadoOrdenDescripcion IN OrdenEstado . EstadoOrdenDescripcion % TYPE , RSP OUT NOCOPY VARCHAR2 )
          
 ins_TipoOrden( paramTipoOrdenId IN TipoOrden . TipoOrdenId % TYPE , paramTipoOrdenDescripcion IN TipoOrden . TipoOrdenDescripcion % TYPE , paramSignoTipoOrden IN TipoOrden . SignoTipoOrden % TYPE , RSP OUT NOCOPY VARCHAR2 )
          
 ins_TipoOrigen( paramTipoOrigenId IN TipoOrigen . TipoOrigenId % TYPE , paramTipoOrigenDescripcion IN TipoOrigen . TipoOrigenDescripcion % TYPE , RSP OUT NOCOPY VARCHAR2 )
          
 ins_Trading( paramTradingId IN Trading . TradingId % TYPE , paramTradingDescripcion IN Trading . TradingDescripcion % TYPE , RSP OUT NOCOPY VARCHAR2 )
          

Method Detail

ins_Accion

          ins_Accion( paramISINId IN Accion . ISINId % TYPE , paramTicker IN Accion . Ticker % TYPE , paramTickerDescripcion IN Accion . TickerDescripcion % TYPE , paramMercadoId IN Accion . MercadoId % TYPE , RSP OUT NOCOPY VARCHAR2 ) 
          

ins_Mercado

          ins_Mercado( paramMercadoId IN Mercado . MercadoId % TYPE , paramMercadoDescripcion IN Mercado . MercadoDescripcion % TYPE , RSP OUT NOCOPY VARCHAR2 ) 
          

ins_OrdenEstado

          ins_OrdenEstado( paramEstadoId IN OrdenEstado . EstadoId % TYPE , paramEstadoOrdenDescripcion IN OrdenEstado . EstadoOrdenDescripcion % TYPE , RSP OUT NOCOPY VARCHAR2 ) 
          

ins_TipoOrden

          ins_TipoOrden( paramTipoOrdenId IN TipoOrden . TipoOrdenId % TYPE , paramTipoOrdenDescripcion IN TipoOrden . TipoOrdenDescripcion % TYPE , paramSignoTipoOrden IN TipoOrden . SignoTipoOrden % TYPE , RSP OUT NOCOPY VARCHAR2 ) 
          

ins_TipoOrigen

          ins_TipoOrigen( paramTipoOrigenId IN TipoOrigen . TipoOrigenId % TYPE , paramTipoOrigenDescripcion IN TipoOrigen . TipoOrigenDescripcion % TYPE , RSP OUT NOCOPY VARCHAR2 ) 
          

ins_Trading

          ins_Trading( paramTradingId IN Trading . TradingId % TYPE , paramTradingDescripcion IN Trading . TradingDescripcion % TYPE , RSP OUT NOCOPY VARCHAR2 ) 
          

NAME VALUE
OWNER CARTERAINVERSION_USER
OBJECT_NAME TABLASAUXILIARES
SUBOBJECT_NAME null
OBJECT_ID 28294
DATA_OBJECT_ID null
OBJECT_TYPE PACKAGE
CREATED 11/06/15
LAST_DDL_TIME 11/06/15
TIMESTAMP 2015-06-11:22:56:06
STATUS VALID
TEMPORARY N
GENERATED N
SECONDARY N
NAMESPACE 1
EDITION_NAME null
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
NAME OWNER TYPE OBJECT_ID STATUS TYPE_LINK
TABLASAUXILIARES CARTERAINVERSION_USER PACKAGE BODY 28295 VALID PACKAGE
NAME OWNER TYPE OBJECT_ID STATUS TYPE_LINK
ORDENESTADO CARTERAINVERSION_USER TABLE 28268 VALID TABLE
MERCADO CARTERAINVERSION_USER TABLE 28266 VALID TABLE
TIPOORIGEN CARTERAINVERSION_USER TABLE 28286 VALID TABLE
TRADING CARTERAINVERSION_USER TABLE 28288 VALID TABLE
ACCION CARTERAINVERSION_USER TABLE 28248 VALID TABLE
TIPOORDEN CARTERAINVERSION_USER TABLE 28284 VALID TABLE
PACKAGE                         "TABLASAUXILIARES" AS

PROCEDURE ins_Mercado
(
  paramMercadoId 			IN Mercado.MercadoId%TYPE,
  paramMercadoDescripcion 	IN Mercado.MercadoDescripcion%TYPE,
  RSP						OUT NOCOPY VARCHAR2
);

PROCEDURE ins_Accion
(
  paramISINId 				IN Accion.ISINId%TYPE,
  paramTicker   	 		IN Accion.Ticker%TYPE,
  paramTickerDescripcion 	IN Accion.TickerDescripcion%TYPE,
  paramMercadoId		 	IN Accion.MercadoId%TYPE,
  RSP						OUT NOCOPY VARCHAR2
);

PROCEDURE ins_TipoOrden
(
  paramTipoOrdenId 				IN TipoOrden.TipoOrdenId%TYPE,
  paramTipoOrdenDescripcion 	IN TipoOrden.TipoOrdenDescripcion%TYPE,
  paramSignoTipoOrden 		    IN TipoOrden.SignoTipoOrden%TYPE,
  RSP							OUT NOCOPY VARCHAR2
);

PROCEDURE ins_OrdenEstado
(
  paramEstadoId 				IN OrdenEstado.EstadoId%TYPE,
  paramEstadoOrdenDescripcion 	IN OrdenEstado.EstadoOrdenDescripcion%TYPE,
  RSP							OUT NOCOPY VARCHAR2
);

PROCEDURE ins_Trading
(
  paramTradingId 			IN Trading.TradingId%TYPE,
  paramTradingDescripcion 	IN Trading.TradingDescripcion%TYPE,
  RSP						OUT NOCOPY VARCHAR2
);

PROCEDURE ins_TipoOrigen
(
  paramTipoOrigenId 			IN TipoOrigen.TipoOrigenId%TYPE,
  paramTipoOrigenDescripcion 	IN TipoOrigen.TipoOrigenDescripcion%TYPE,
  RSP							OUT NOCOPY VARCHAR2
);

END TABLASAUXILIARES;