Doc
Details
Grants
References
Dependencies
Code
Doc
Details
Grants
References
Dependencies
Code
SUMMARY: FIELD | TYPE | METHOD |
Method Summary | |
| del_OrdenTrading( paramOrdenTradingiD IN OrdenTrading . OrdenTradingId % TYPE , RSP OUT NOCOPY VARCHAR2 ) |
| exe_OrdenTrading( paramOrdenTradingiD IN OrdenTrading . OrdenTradingId % TYPE , RSP OUT NOCOPY VARCHAR2 ) |
| ins_AccionHistorico( paramISINId IN AccionHistorico . ISINId % TYPE , paramFechaCierre IN AccionHistorico . FechaCierre % TYPE , paramValorCierre IN AccionHistorico . ValorCierre % TYPE , RSP OUT NOCOPY VARCHAR2 ) |
| ins_ClienteHistorico( paramClienteiD IN ClienteHistorico . ClienteId % TYPE , paramMes IN ClienteHistorico . Mes % TYPE , paramANO IN ClienteHistorico . ANO % TYPE , paramImporteInicial IN ClienteHistorico . ImporteInicial % TYPE , paramImporteFinal IN ClienteHistorico . ImporteFinal % TYPE , RSP OUT NOCOPY VARCHAR2 ) |
| ins_OrdenInversion( paramISINId IN OrdenInversion . ISINId % TYPE , paramTipoOrdenId IN OrdenInversion . TipoOrdenId % TYPE , paramTipoOrigenId IN OrdenInversion . TipoOrigenId % TYPE , paramCantidad IN OrdenInversion . Cantidad % TYPE , paramPrecioMinimo IN OrdenInversion . PrecioMinimo % TYPE , paramCarteraId IN OrdenInversion . CarteraId % TYPE , paramClienteId IN OrdenInversion . ClienteId % TYPE , RSP OUT NOCOPY VARCHAR2 , paramFechaIntroduccion IN OrdenInversion . FechaIntroduccion % type : = to_date ( '01/01/00' , 'DD/MM/YY' ) parametros opcionales, van siempre al final |
| ins_OrdenTrading( paramCarteraId IN OrdenTrading . CarteraId % TYPE , paramClienteId IN OrdenTrading . ClienteId % TYPE , paramISINId IN OrdenTrading . ISINId % TYPE , paramTipoOrdenId IN OrdenTrading . TipoOrdenId % TYPE , paramCantidad IN OrdenTrading . Cantidad % TYPE , paramPrecioMinimo IN OrdenTrading . PrecioMinimo % TYPE , paramTradingId IN OrdenTrading . TradingId % TYPE , RSP OUT NOCOPY VARCHAR2 ) parametros opcionales, van siempre al final |
| upd_ClienteHistorico( paramClienteiD IN ClienteHistorico . ClienteId % TYPE , paramMes IN ClienteHistorico . Mes % TYPE , paramANO IN ClienteHistorico . ANO % TYPE , paramImporteInicial IN ClienteHistorico . ImporteInicial % TYPE , paramImporteFinal IN ClienteHistorico . ImporteFinal % TYPE , RSP OUT NOCOPY VARCHAR2 ) |
| upd_OrdenInversion( paramOrdenInversionId IN OrdenInversion . OrdenInversionId % TYPE , paramCarteraId IN OrdenInversion . CarteraId % TYPE , paramClienteId IN OrdenInversion . ClienteId % TYPE , paramCantidad IN OrdenInversion . Cantidad % TYPE , paramEjecucionPrecio IN OrdenInversion . EjecucionPrecio % TYPE , paramEstadoId IN OrdenInversion . EstadoId % TYPE , RSP OUT NOCOPY VARCHAR2 , paramFechaEjecucion IN OrdenInversion . FechaEjecucion % type : = to_date ( '01/01/00' , 'DD/MM/YY' ) parametros opcionales, van siempre al final |
| upd_OrdenTrading( paramOrdenTradingiD IN OrdenTrading . OrdenTradingId % TYPE , paramCarteraId IN OrdenTrading . CarteraId % TYPE , paramClienteId IN OrdenTrading . ClienteId % TYPE , paramISINId IN OrdenTrading . ISINId % TYPE , paramTipoOrdenId IN OrdenTrading . TipoOrdenId % TYPE , paramCantidad IN OrdenTrading . Cantidad % TYPE , paramPrecioMinimo IN OrdenTrading . PrecioMinimo % TYPE , paramTradingId IN OrdenTrading . TradingId % TYPE , RSP OUT NOCOPY VARCHAR2 ) |
Method Detail |
del_OrdenTrading( paramOrdenTradingiD IN OrdenTrading . OrdenTradingId % TYPE , RSP OUT NOCOPY VARCHAR2 )
exe_OrdenTrading( paramOrdenTradingiD IN OrdenTrading . OrdenTradingId % TYPE , RSP OUT NOCOPY VARCHAR2 )
ins_AccionHistorico( paramISINId IN AccionHistorico . ISINId % TYPE , paramFechaCierre IN AccionHistorico . FechaCierre % TYPE , paramValorCierre IN AccionHistorico . ValorCierre % TYPE , RSP OUT NOCOPY VARCHAR2 )
ins_ClienteHistorico( paramClienteiD IN ClienteHistorico . ClienteId % TYPE , paramMes IN ClienteHistorico . Mes % TYPE , paramANO IN ClienteHistorico . ANO % TYPE , paramImporteInicial IN ClienteHistorico . ImporteInicial % TYPE , paramImporteFinal IN ClienteHistorico . ImporteFinal % TYPE , RSP OUT NOCOPY VARCHAR2 )
ins_OrdenInversion( paramISINId IN OrdenInversion . ISINId % TYPE , paramTipoOrdenId IN OrdenInversion . TipoOrdenId % TYPE , paramTipoOrigenId IN OrdenInversion . TipoOrigenId % TYPE , paramCantidad IN OrdenInversion . Cantidad % TYPE , paramPrecioMinimo IN OrdenInversion . PrecioMinimo % TYPE , paramCarteraId IN OrdenInversion . CarteraId % TYPE , paramClienteId IN OrdenInversion . ClienteId % TYPE , RSP OUT NOCOPY VARCHAR2 , paramFechaIntroduccion IN OrdenInversion . FechaIntroduccion % type : = to_date ( '01/01/00' , 'DD/MM/YY' )
ins_OrdenTrading( paramCarteraId IN OrdenTrading . CarteraId % TYPE , paramClienteId IN OrdenTrading . ClienteId % TYPE , paramISINId IN OrdenTrading . ISINId % TYPE , paramTipoOrdenId IN OrdenTrading . TipoOrdenId % TYPE , paramCantidad IN OrdenTrading . Cantidad % TYPE , paramPrecioMinimo IN OrdenTrading . PrecioMinimo % TYPE , paramTradingId IN OrdenTrading . TradingId % TYPE , RSP OUT NOCOPY VARCHAR2 )
upd_ClienteHistorico( paramClienteiD IN ClienteHistorico . ClienteId % TYPE , paramMes IN ClienteHistorico . Mes % TYPE , paramANO IN ClienteHistorico . ANO % TYPE , paramImporteInicial IN ClienteHistorico . ImporteInicial % TYPE , paramImporteFinal IN ClienteHistorico . ImporteFinal % TYPE , RSP OUT NOCOPY VARCHAR2 )
upd_OrdenInversion( paramOrdenInversionId IN OrdenInversion . OrdenInversionId % TYPE , paramCarteraId IN OrdenInversion . CarteraId % TYPE , paramClienteId IN OrdenInversion . ClienteId % TYPE , paramCantidad IN OrdenInversion . Cantidad % TYPE , paramEjecucionPrecio IN OrdenInversion . EjecucionPrecio % TYPE , paramEstadoId IN OrdenInversion . EstadoId % TYPE , RSP OUT NOCOPY VARCHAR2 , paramFechaEjecucion IN OrdenInversion . FechaEjecucion % type : = to_date ( '01/01/00' , 'DD/MM/YY' )
upd_OrdenTrading( paramOrdenTradingiD IN OrdenTrading . OrdenTradingId % TYPE , paramCarteraId IN OrdenTrading . CarteraId % TYPE , paramClienteId IN OrdenTrading . ClienteId % TYPE , paramISINId IN OrdenTrading . ISINId % TYPE , paramTipoOrdenId IN OrdenTrading . TipoOrdenId % TYPE , paramCantidad IN OrdenTrading . Cantidad % TYPE , paramPrecioMinimo IN OrdenTrading . PrecioMinimo % TYPE , paramTradingId IN OrdenTrading . TradingId % TYPE , RSP OUT NOCOPY VARCHAR2 )
SUMMARY: FIELD | TYPE | METHOD |
NAME | VALUE |
---|---|
OWNER | CARTERAINVERSION_USER |
OBJECT_NAME | GESTIONTEST |
SUBOBJECT_NAME | null |
OBJECT_ID | 28298 |
DATA_OBJECT_ID | null |
OBJECT_TYPE | PACKAGE |
CREATED | 11/06/15 |
LAST_DDL_TIME | 11/06/15 |
TIMESTAMP | 2015-06-11:22:56:07 |
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 |
---|---|---|---|---|---|
UPDSITUACIONCARTERA | CARTERAINVERSION_USER | TRIGGER | 28320 | VALID | TRIGGER |
GESTIONTEST | CARTERAINVERSION_USER | PACKAGE BODY | 28299 | VALID | PACKAGE |
NAME | OWNER | TYPE | OBJECT_ID | STATUS | TYPE_LINK |
---|---|---|---|---|---|
ORDENTRADING | CARTERAINVERSION_USER | TABLE | 28276 | VALID | TABLE |
ACCIONHISTORICO | CARTERAINVERSION_USER | TABLE | 28251 | VALID | TABLE |
ORDENINVERSION | CARTERAINVERSION_USER | TABLE | 28270 | VALID | TABLE |
CLIENTEHISTORICO | CARTERAINVERSION_USER | TABLE | 28258 | VALID | TABLE |
PACKAGE "GESTIONTEST" AS PROCEDURE ins_AccionHistorico ( paramISINId IN AccionHistorico.ISINId%TYPE, paramFechaCierre IN AccionHistorico.FechaCierre%TYPE, paramValorCierre IN AccionHistorico.ValorCierre%TYPE, RSP OUT NOCOPY VARCHAR2 ); PROCEDURE ins_OrdenInversion ( paramISINId IN OrdenInversion.ISINId%TYPE, paramTipoOrdenId IN OrdenInversion.TipoOrdenId%TYPE, paramTipoOrigenId IN OrdenInversion.TipoOrigenId%TYPE, paramCantidad IN OrdenInversion.Cantidad%TYPE, paramPrecioMinimo IN OrdenInversion.PrecioMinimo%TYPE, paramCarteraId IN OrdenInversion.CarteraId%TYPE, paramClienteId IN OrdenInversion.ClienteId%TYPE, RSP OUT NOCOPY VARCHAR2, paramFechaIntroduccion IN OrdenInversion.FechaIntroduccion%type := to_date('01/01/00','DD/MM/YY') /* parametros opcionales, van siempre al final */ ); PROCEDURE upd_OrdenInversion ( paramOrdenInversionId IN OrdenInversion.OrdenInversionId%TYPE, paramCarteraId IN OrdenInversion.CarteraId%TYPE, paramClienteId IN OrdenInversion.ClienteId%TYPE, paramCantidad IN OrdenInversion.Cantidad%TYPE, paramEjecucionPrecio IN OrdenInversion.EjecucionPrecio%TYPE, paramEstadoId IN OrdenInversion.EstadoId%TYPE, RSP OUT NOCOPY VARCHAR2, paramFechaEjecucion IN OrdenInversion.FechaEjecucion%type := to_date('01/01/00','DD/MM/YY') /* parametros opcionales, van siempre al final */ ); PROCEDURE ins_OrdenTrading ( paramCarteraId IN OrdenTrading.CarteraId%TYPE, paramClienteId IN OrdenTrading.ClienteId%TYPE, paramISINId IN OrdenTrading.ISINId%TYPE, paramTipoOrdenId IN OrdenTrading.TipoOrdenId%TYPE, paramCantidad IN OrdenTrading.Cantidad%TYPE, paramPrecioMinimo IN OrdenTrading.PrecioMinimo%TYPE, paramTradingId IN OrdenTrading.TradingId%TYPE, RSP OUT NOCOPY VARCHAR2 ); PROCEDURE upd_OrdenTrading ( paramOrdenTradingiD IN OrdenTrading.OrdenTradingId%TYPE, paramCarteraId IN OrdenTrading.CarteraId%TYPE, paramClienteId IN OrdenTrading.ClienteId%TYPE, paramISINId IN OrdenTrading.ISINId%TYPE, paramTipoOrdenId IN OrdenTrading.TipoOrdenId%TYPE, paramCantidad IN OrdenTrading.Cantidad%TYPE, paramPrecioMinimo IN OrdenTrading.PrecioMinimo%TYPE, paramTradingId IN OrdenTrading.TradingId%TYPE, RSP OUT NOCOPY VARCHAR2 ); PROCEDURE del_OrdenTrading ( paramOrdenTradingiD IN OrdenTrading.OrdenTradingId%TYPE, RSP OUT NOCOPY VARCHAR2 ); PROCEDURE exe_OrdenTrading ( paramOrdenTradingiD IN OrdenTrading.OrdenTradingId%TYPE, RSP OUT NOCOPY VARCHAR2 ); PROCEDURE ins_ClienteHistorico ( paramClienteiD IN ClienteHistorico.ClienteId%TYPE, paramMes IN ClienteHistorico.Mes%TYPE, paramANO IN ClienteHistorico.ANO%TYPE, paramImporteInicial IN ClienteHistorico.ImporteInicial%TYPE, paramImporteFinal IN ClienteHistorico.ImporteFinal%TYPE, RSP OUT NOCOPY VARCHAR2 ); PROCEDURE upd_ClienteHistorico ( paramClienteiD IN ClienteHistorico.ClienteId%TYPE, paramMes IN ClienteHistorico.Mes%TYPE, paramANO IN ClienteHistorico.ANO%TYPE, paramImporteInicial IN ClienteHistorico.ImporteInicial%TYPE, paramImporteFinal IN ClienteHistorico.ImporteFinal%TYPE, RSP OUT NOCOPY VARCHAR2 ); END GESTIONTEST;