1 PACKAGE LNS_DISB_HEADERS_PKG AUTHID CURRENT_USER AS
2 /* $Header: LNS_DSBHR_TBLH_S.pls 120.2.12010000.2 2010/03/19 08:38:29 gparuchu ship $ */
3
4 /* Insert_Row procedure */
5 PROCEDURE Insert_Row(
6 X_DISB_HEADER_ID IN OUT NOCOPY NUMBER
7 ,P_LOAN_ID IN NUMBER
8 ,P_ACTIVITY_CODE IN VARCHAR2 DEFAULT NULL
9 ,P_DISBURSEMENT_NUMBER IN NUMBER DEFAULT NULL
10 ,P_HEADER_AMOUNT IN NUMBER DEFAULT NULL
11 ,P_HEADER_PERCENT IN NUMBER DEFAULT NULL
12 ,P_STATUS IN VARCHAR2 DEFAULT NULL
13 ,P_TARGET_DATE IN DATE DEFAULT NULL
14 ,P_PAYMENT_REQUEST_DATE IN DATE DEFAULT NULL
15 ,P_OBJECT_VERSION_NUMBER IN NUMBER
16 ,P_CREATION_DATE IN DATE DEFAULT NULL
17 ,P_CREATED_BY IN NUMBER DEFAULT NULL
18 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
19 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
20 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
21 ,P_AUTOFUNDING_FLAG IN VARCHAR2 DEFAULT NULL
22 ,P_DESCRIPTION IN VARCHAR2 DEFAULT NULL
23 ,P_PHASE IN VARCHAR2 DEFAULT NULL
24 );
25
26 /* Update_Row procedure */
27 PROCEDURE Update_Row(
28 P_DISB_HEADER_ID IN NUMBER
29 ,P_LOAN_ID IN NUMBER DEFAULT NULL
30 ,P_ACTIVITY_CODE IN VARCHAR2 DEFAULT NULL
31 ,P_DISBURSEMENT_NUMBER IN NUMBER DEFAULT NULL
32 ,P_HEADER_AMOUNT IN NUMBER DEFAULT NULL
33 ,P_HEADER_PERCENT IN NUMBER DEFAULT NULL
34 ,P_STATUS IN VARCHAR2 DEFAULT NULL
35 ,P_TARGET_DATE IN DATE DEFAULT NULL
36 ,P_PAYMENT_REQUEST_DATE IN DATE DEFAULT NULL
37 ,P_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL
38 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
39 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
40 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
41 ,P_AUTOFUNDING_FLAG IN VARCHAR2 DEFAULT NULL
42 ,P_DESCRIPTION IN VARCHAR2 DEFAULT NULL
43 ,P_PHASE IN VARCHAR2 DEFAULT NULL
44 );
45
46 /* Delete_Row procedure */
47 PROCEDURE Delete_Row(P_DISB_HEADER_ID IN NUMBER);
48
49 /* Lock_Row procedure */
50 PROCEDURE Lock_Row(
51 P_DISB_HEADER_ID IN NUMBER
52 ,P_LOAN_ID IN NUMBER DEFAULT NULL
53 ,P_ACTIVITY_CODE IN VARCHAR2 DEFAULT NULL
54 ,P_DISBURSEMENT_NUMBER IN NUMBER DEFAULT NULL
55 ,P_HEADER_AMOUNT IN NUMBER DEFAULT NULL
56 ,P_HEADER_PERCENT IN NUMBER DEFAULT NULL
57 ,P_STATUS IN VARCHAR2 DEFAULT NULL
58 ,P_TARGET_DATE IN DATE DEFAULT NULL
59 ,P_PAYMENT_REQUEST_DATE IN DATE DEFAULT NULL
60 ,P_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL
61 ,P_CREATION_DATE IN DATE DEFAULT NULL
62 ,P_CREATED_BY IN NUMBER DEFAULT NULL
63 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
64 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
65 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
66 ,P_AUTOFUNDING_FLAG IN VARCHAR2 DEFAULT NULL
67 ,P_DESCRIPTION IN VARCHAR2 DEFAULT NULL
68 ,P_PHASE IN VARCHAR2 DEFAULT NULL
69 );
70 END;
71