Doc
Details
Grants
References
Dependencies
Code
Doc
Details
Grants
References
Dependencies
Code
SUMMARY: FIELD | TYPE | METHOD |
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( 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 )
SUMMARY: FIELD | TYPE | METHOD |
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;