1 PACKAGE LNS_LOAN_DOCUMENTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: LNS_LNDOC_TBLH_S.pls 120.0.12010000.2 2009/05/25 10:24:13 gparuchu ship $ */
3
4 /* Insert_Row procedure */
5 PROCEDURE Insert_Row(
6 X_DOCUMENT_ID IN OUT NOCOPY NUMBER
7 ,P_SOURCE_ID IN NUMBER
8 ,P_SOURCE_TABLE IN VARCHAR2
9 ,P_DOCUMENT_TYPE IN VARCHAR2
10 ,P_VERSION IN NUMBER
11 ,P_DOCUMENT_XML IN CLOB
12 ,P_CREATION_DATE IN DATE DEFAULT NULL
13 ,P_CREATED_BY IN NUMBER DEFAULT NULL
14 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
15 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
16 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
17 ,P_PROGRAM_UPDATE_DATE IN DATE DEFAULT NULL
18 ,P_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT NULL
19 ,P_PROGRAM_ID IN NUMBER DEFAULT NULL
20 ,P_REQUEST_ID IN NUMBER DEFAULT NULL
21 ,P_OBJECT_VERSION_NUMBER IN NUMBER
22 ,P_REASON IN VARCHAR2 DEFAULT NULL
23 );
24
25 /* Update_Row procedure */
26 PROCEDURE Update_Row(
27 X_DOCUMENT_ID IN OUT NOCOPY NUMBER
28 ,P_SOURCE_ID IN NUMBER
29 ,P_SOURCE_TABLE IN VARCHAR2
30 ,P_DOCUMENT_TYPE IN VARCHAR2
31 ,P_VERSION IN NUMBER
32 ,P_DOCUMENT_XML IN CLOB
33 ,P_CREATION_DATE IN DATE DEFAULT NULL
34 ,P_CREATED_BY IN NUMBER DEFAULT NULL
35 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
36 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
37 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
38 ,P_PROGRAM_UPDATE_DATE IN DATE DEFAULT NULL
39 ,P_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT NULL
40 ,P_PROGRAM_ID IN NUMBER DEFAULT NULL
41 ,P_REQUEST_ID IN NUMBER DEFAULT NULL
42 ,P_OBJECT_VERSION_NUMBER IN NUMBER
43 ,P_REASON IN VARCHAR2 DEFAULT NULL
44 );
45
46 END LNS_LOAN_DOCUMENTS_PKG;
47
[Home] [Help]