Doc

Details

Grants

References

Dependencies

Code




Method Summary
 del_Cartera( paramCarteraiD IN Cartera . CarteraId % TYPE , paramClienteId IN Cartera . ClienteId % TYPE , RSP OUT NOCOPY VARCHAR2 )
          
 del_Cliente( paramClienteiD IN Cliente . ClienteId % TYPE , RSP OUT NOCOPY VARCHAR2 )
          
 ins_Cartera( paramClienteId IN Cartera . ClienteId % TYPE , paramCarteraDescricion IN Cartera . CarteraDescripcion % TYPE , RSP OUT NOCOPY VARCHAR2 )
          
 ins_Cliente( paramNombre IN Cliente . Nombre % TYPE , paramNIF IN Cliente . NIF % TYPE , paramEmail IN Cliente . Email % TYPE , RSP OUT NOCOPY VARCHAR2 )
          
 upd_Cartera( paramCarteraiD IN Cartera . CarteraId % TYPE , paramClienteId IN Cartera . ClienteId % TYPE , paramCarteraDescricion IN Cartera . CarteraDescripcion % TYPE , RSP OUT NOCOPY VARCHAR2 )
          
 upd_Cliente( paramClienteiD IN Cliente . ClienteId % TYPE , paramNombre IN Cliente . Nombre % TYPE , paramNIF IN Cliente . NIF % TYPE , paramEmail IN Cliente . Email % TYPE , RSP OUT NOCOPY VARCHAR2 )
          

Method Detail

del_Cartera

          del_Cartera( paramCarteraiD IN Cartera . CarteraId % TYPE , paramClienteId IN Cartera . ClienteId % TYPE , RSP OUT NOCOPY VARCHAR2 ) 
          

del_Cliente

          del_Cliente( paramClienteiD IN Cliente . ClienteId % TYPE , RSP OUT NOCOPY VARCHAR2 ) 
          

ins_Cartera

          ins_Cartera( paramClienteId IN Cartera . ClienteId % TYPE , paramCarteraDescricion IN Cartera . CarteraDescripcion % TYPE , RSP OUT NOCOPY VARCHAR2 ) 
          

ins_Cliente

          ins_Cliente( paramNombre IN Cliente . Nombre % TYPE , paramNIF IN Cliente . NIF % TYPE , paramEmail IN Cliente . Email % TYPE , RSP OUT NOCOPY VARCHAR2 ) 
          

upd_Cartera

          upd_Cartera( paramCarteraiD IN Cartera . CarteraId % TYPE , paramClienteId IN Cartera . ClienteId % TYPE , paramCarteraDescricion IN Cartera . CarteraDescripcion % TYPE , RSP OUT NOCOPY VARCHAR2 ) 
          

upd_Cliente

          upd_Cliente( paramClienteiD IN Cliente . ClienteId % TYPE , paramNombre IN Cliente . Nombre % TYPE , paramNIF IN Cliente . NIF % TYPE , paramEmail IN Cliente . Email % TYPE , RSP OUT NOCOPY VARCHAR2 ) 
          

NAME VALUE
OWNER CARTERAINVERSION_USER
OBJECT_NAME TABLASMANTENIMIENTO
SUBOBJECT_NAME null
OBJECT_ID 28296
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
TABLASMANTENIMIENTO CARTERAINVERSION_USER PACKAGE BODY 28297 VALID PACKAGE
NAME OWNER TYPE OBJECT_ID STATUS TYPE_LINK
CARTERA CARTERAINVERSION_USER TABLE 28253 VALID TABLE
CLIENTE CARTERAINVERSION_USER TABLE 28256 VALID TABLE
PACKAGE                         "TABLASMANTENIMIENTO" AS

PROCEDURE ins_Cliente
(
  paramNombre				IN Cliente.Nombre%TYPE,
  paramNIF					IN Cliente.NIF%TYPE,
  paramEmail  				IN Cliente.Email%TYPE,
  RSP						OUT NOCOPY VARCHAR2
);

PROCEDURE upd_Cliente
(
  paramClienteiD		    IN Cliente.ClienteId%TYPE,
  paramNombre				IN Cliente.Nombre%TYPE,
  paramNIF					IN Cliente.NIF%TYPE,
  paramEmail  				IN Cliente.Email%TYPE,
  RSP						OUT NOCOPY VARCHAR2
);


PROCEDURE del_Cliente
(
  paramClienteiD		    IN Cliente.ClienteId%TYPE,
  RSP						OUT NOCOPY VARCHAR2
);

PROCEDURE ins_Cartera
(
  paramClienteId				IN Cartera.ClienteId%TYPE,
  paramCarteraDescricion		IN Cartera.CarteraDescripcion%TYPE,
  RSP							OUT NOCOPY VARCHAR2
);

PROCEDURE upd_Cartera
(
  paramCarteraiD		    IN Cartera.CarteraId%TYPE,
  paramClienteId		  	IN Cartera.ClienteId%TYPE,
  paramCarteraDescricion	IN Cartera.CarteraDescripcion%TYPE,
  RSP						OUT NOCOPY VARCHAR2
);

PROCEDURE del_Cartera
(
  paramCarteraiD		    IN Cartera.CarteraId%TYPE,
  paramClienteId		  	IN Cartera.ClienteId%TYPE,
  RSP						        OUT NOCOPY VARCHAR2
);

END TABLASMANTENIMIENTO;