DBA Data[Home] [Help]

PACKAGE: APPS.LNS_DISB_HEADERS_PKG

Source


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