Doc
Details
Grants
References
Dependencies
Code
Doc
Details
Grants
References
Dependencies
Code
SUMMARY: FIELD | TYPE | METHOD |
Method Summary | |
| Cons_1_Cartera_Cliente( paramClienteId IN Cliente . ClienteId % TYPE , paramFechaCierre IN AccionHistorico . FechaCierre % TYPE ) |
| Cons_2_0_Clientes_Anual( paramYear IN NUMBER ) |
| Cons_2_1_Clientes_Anual( paramYear IN NUMBER , paramClienteId IN OUT Cliente . ClienteId % TYPE , paramNombre OUT Cliente . Nombre % TYPE , paramTotalComprasCargadas OUT NUMBER , paramTotalVentasCargadas OUT NUMBER , paramTotalComprasEjecutadas OUT NUMBER , paramTotalVentasEjecutadas OUT NUMBER , paramImporteComprasEjec OUT NUMBER , paramValorMedioComprasEjec OUT NUMBER , paramImporteVentasEjec OUT NUMBER , paramValorMedioVentasEjec OUT NUMBER , paramTotalComprasCanceladas OUT NUMBER , paramTotalVentasCanceladas OUT NUMBER ) |
| Cons_3_0_Acciones_Anual( paramYear IN NUMBER ) |
| Cons_3_1_Acciones_Anual( paramYear IN NUMBER , paramISINId IN OUT Accion . ISINId % TYPE , paramTicker OUT Accion . Ticker % TYPE , paramTickerDescripcion OUT Accion . TickerDescripcion % TYPE , paramTotalComprasEjec OUT NUMBER , paramValorComprasEjec OUT NUMBER , paramValorMedioComprasEjec OUT NUMBER , paramTotalVentasEjec OUT NUMBER , paramValorVentasEjec OUT NUMBER ) |
| Cons_4_Top10Accion( paramTop in number default 10 ) |
Method Detail |
Cons_1_Cartera_Cliente( paramClienteId IN Cliente . ClienteId % TYPE , paramFechaCierre IN AccionHistorico . FechaCierre % TYPE )
Cons_2_0_Clientes_Anual( paramYear IN NUMBER )
Cons_2_1_Clientes_Anual( paramYear IN NUMBER , paramClienteId IN OUT Cliente . ClienteId % TYPE , paramNombre OUT Cliente . Nombre % TYPE , paramTotalComprasCargadas OUT NUMBER , paramTotalVentasCargadas OUT NUMBER , paramTotalComprasEjecutadas OUT NUMBER , paramTotalVentasEjecutadas OUT NUMBER , paramImporteComprasEjec OUT NUMBER , paramValorMedioComprasEjec OUT NUMBER , paramImporteVentasEjec OUT NUMBER , paramValorMedioVentasEjec OUT NUMBER , paramTotalComprasCanceladas OUT NUMBER , paramTotalVentasCanceladas OUT NUMBER )
Cons_3_0_Acciones_Anual( paramYear IN NUMBER )
Cons_3_1_Acciones_Anual( paramYear IN NUMBER , paramISINId IN OUT Accion . ISINId % TYPE , paramTicker OUT Accion . Ticker % TYPE , paramTickerDescripcion OUT Accion . TickerDescripcion % TYPE , paramTotalComprasEjec OUT NUMBER , paramValorComprasEjec OUT NUMBER , paramValorMedioComprasEjec OUT NUMBER , paramTotalVentasEjec OUT NUMBER , paramValorVentasEjec OUT NUMBER )
Cons_4_Top10Accion( paramTop in number default 10 )
SUMMARY: FIELD | TYPE | METHOD |
NAME | VALUE |
---|---|
OWNER | CARTERAINVERSION_USER |
OBJECT_NAME | CONSULTAS |
SUBOBJECT_NAME | null |
OBJECT_ID | 28300 |
DATA_OBJECT_ID | null |
OBJECT_TYPE | PACKAGE |
CREATED | 11/06/15 |
LAST_DDL_TIME | 11/06/15 |
TIMESTAMP | 2015-06-11:22:56:08 |
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 |
---|---|---|---|---|---|
CONSULTAS | CARTERAINVERSION_USER | PACKAGE BODY | 28301 | VALID | PACKAGE |
NAME | OWNER | TYPE | OBJECT_ID | STATUS | TYPE_LINK |
---|---|---|---|---|---|
ACCIONHISTORICO | CARTERAINVERSION_USER | TABLE | 28251 | VALID | TABLE |
ACCION | CARTERAINVERSION_USER | TABLE | 28248 | VALID | TABLE |
CLIENTE | CARTERAINVERSION_USER | TABLE | 28256 | VALID | TABLE |
PACKAGE CONSULTAS AS PROCEDURE Cons_1_Cartera_Cliente ( paramClienteId IN Cliente.ClienteId%TYPE, paramFechaCierre IN AccionHistorico.FechaCierre%TYPE ) ; PROCEDURE Cons_2_0_Clientes_Anual ( paramYear IN NUMBER ) ; PROCEDURE Cons_2_1_Clientes_Anual ( paramYear IN NUMBER, paramClienteId IN OUT Cliente.ClienteId%TYPE, paramNombre OUT Cliente.Nombre%TYPE, paramTotalComprasCargadas OUT NUMBER, paramTotalVentasCargadas OUT NUMBER, paramTotalComprasEjecutadas OUT NUMBER, paramTotalVentasEjecutadas OUT NUMBER, paramImporteComprasEjec OUT NUMBER, paramValorMedioComprasEjec OUT NUMBER, paramImporteVentasEjec OUT NUMBER, paramValorMedioVentasEjec OUT NUMBER, paramTotalComprasCanceladas OUT NUMBER, paramTotalVentasCanceladas OUT NUMBER ); PROCEDURE Cons_3_0_Acciones_Anual ( paramYear IN NUMBER ); PROCEDURE Cons_3_1_Acciones_Anual (paramYear IN NUMBER, paramISINId IN OUT Accion.ISINId%TYPE, paramTicker OUT Accion.Ticker%TYPE, paramTickerDescripcion OUT Accion.TickerDescripcion%TYPE, paramTotalComprasEjec OUT NUMBER, paramValorComprasEjec OUT NUMBER, paramValorMedioComprasEjec OUT NUMBER, paramTotalVentasEjec OUT NUMBER, paramValorVentasEjec OUT NUMBER ); PROCEDURE Cons_4_Top10Accion ( paramTop in number default 10 ); END CONSULTAS;