Doc

Details

Grants

References

Dependencies

Code




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

          del_OrdenTrading( paramOrdenTradingiD IN OrdenTrading . OrdenTradingId % TYPE , RSP OUT NOCOPY VARCHAR2 ) 
          

exe_OrdenTrading

          exe_OrdenTrading( paramOrdenTradingiD IN OrdenTrading . OrdenTradingId % TYPE , RSP OUT NOCOPY VARCHAR2 ) 
          

ins_AccionHistorico

          ins_AccionHistorico( paramISINId IN AccionHistorico . ISINId % TYPE , paramFechaCierre IN AccionHistorico . FechaCierre % TYPE , paramValorCierre IN AccionHistorico . ValorCierre % TYPE , RSP OUT NOCOPY VARCHAR2 ) 
          

ins_ClienteHistorico

          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

          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

          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

          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

          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

          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 ) 
          

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;