1 PACKAGE LNS_FUNDING_ADVICES_PKG AS
2 /* $Header: LNS_FUND_TBLH_S.pls 120.2 2006/01/18 13:36:39 scherkas noship $ */
3
4 /* Insert_Row procedure */
5 PROCEDURE Insert_Row(
6 X_FUNDING_ADVICE_ID IN OUT NOCOPY NUMBER
7 ,P_LOAN_ID IN NUMBER
8 ,P_ADVICE_NUMBER IN VARCHAR2 DEFAULT NULL
9 ,P_SUBMISSION_DATE IN DATE DEFAULT NULL
10 ,P_AMOUNT IN NUMBER DEFAULT NULL
11 ,P_CURRENCY IN VARCHAR2 DEFAULT NULL
12 ,P_DESCRIPTION IN VARCHAR2 DEFAULT NULL
13 ,P_DUE_DATE IN DATE DEFAULT NULL
14 ,P_INVOICE_ID IN NUMBER DEFAULT NULL
15 ,P_INVOICE_NUMBER IN VARCHAR2 DEFAULT NULL
16 ,P_PAYMENT_METHOD IN VARCHAR2 DEFAULT NULL
17 ,P_STATUS IN VARCHAR2 DEFAULT NULL
18 ,P_PAYEE_ID IN NUMBER DEFAULT NULL
19 ,P_PAYEE_SITE_ID IN NUMBER DEFAULT NULL
20 ,P_SITE_CONTACT_ID IN NUMBER DEFAULT NULL
21 ,P_BANK_BRANCH_ID IN NUMBER DEFAULT NULL
22 ,P_BANK_ACCOUNT_ID IN NUMBER DEFAULT NULL
23 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
24 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
25 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
26 ,P_CREATION_DATE IN DATE DEFAULT NULL
27 ,P_CREATED_BY IN NUMBER DEFAULT NULL
28 ,P_REQUEST_ID IN NUMBER DEFAULT NULL
29 ,P_AUTOFUNDING_FLAG IN VARCHAR2 DEFAULT NULL
30 ,P_OBJECT_VERSION_NUMBER IN NUMBER
31 ,P_FUNDING_DATE IN DATE DEFAULT NULL
32 );
33
34 /* Update_Row procedure */
35 PROCEDURE Update_Row(
36 P_FUNDING_ADVICE_ID IN NUMBER
37 ,P_LOAN_ID IN NUMBER DEFAULT NULL
38 ,P_ADVICE_NUMBER IN VARCHAR2 DEFAULT NULL
39 ,P_SUBMISSION_DATE IN DATE DEFAULT NULL
40 ,P_AMOUNT IN NUMBER DEFAULT NULL
41 ,P_CURRENCY IN VARCHAR2 DEFAULT NULL
42 ,P_DESCRIPTION IN VARCHAR2 DEFAULT NULL
43 ,P_DUE_DATE IN DATE DEFAULT NULL
44 ,P_INVOICE_ID IN NUMBER DEFAULT NULL
45 ,P_INVOICE_NUMBER IN VARCHAR2 DEFAULT NULL
46 ,P_PAYMENT_METHOD IN VARCHAR2 DEFAULT NULL
47 ,P_STATUS IN VARCHAR2 DEFAULT NULL
48 ,P_PAYEE_ID IN NUMBER DEFAULT NULL
49 ,P_PAYEE_SITE_ID IN NUMBER DEFAULT NULL
50 ,P_SITE_CONTACT_ID IN NUMBER DEFAULT NULL
51 ,P_BANK_BRANCH_ID IN NUMBER DEFAULT NULL
52 ,P_BANK_ACCOUNT_ID IN NUMBER DEFAULT NULL
53 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
54 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
55 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
56 ,P_REQUEST_ID IN NUMBER DEFAULT NULL
57 ,P_AUTOFUNDING_FLAG IN VARCHAR2 DEFAULT NULL
58 ,P_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL
59 ,P_FUNDING_DATE IN DATE DEFAULT NULL
60 );
61
62 /* Delete_Row procedure */
63 PROCEDURE Delete_Row(P_FUNDING_ADVICE_ID IN NUMBER);
64
65 /* Lock_Row procedure */
66 PROCEDURE Lock_Row(
67 P_FUNDING_ADVICE_ID IN NUMBER
68 ,P_LOAN_ID IN NUMBER DEFAULT NULL
69 ,P_ADVICE_NUMBER IN VARCHAR2 DEFAULT NULL
70 ,P_SUBMISSION_DATE IN DATE DEFAULT NULL
71 ,P_AMOUNT IN NUMBER DEFAULT NULL
72 ,P_CURRENCY IN VARCHAR2 DEFAULT NULL
73 ,P_DESCRIPTION IN VARCHAR2 DEFAULT NULL
74 ,P_DUE_DATE IN DATE DEFAULT NULL
75 ,P_INVOICE_ID IN NUMBER DEFAULT NULL
76 ,P_INVOICE_NUMBER IN VARCHAR2 DEFAULT NULL
77 ,P_PAYMENT_METHOD IN VARCHAR2 DEFAULT NULL
78 ,P_STATUS IN VARCHAR2 DEFAULT NULL
79 ,P_PAYEE_ID IN NUMBER DEFAULT NULL
80 ,P_PAYEE_SITE_ID IN NUMBER DEFAULT NULL
81 ,P_SITE_CONTACT_ID IN NUMBER DEFAULT NULL
82 ,P_BANK_BRANCH_ID IN NUMBER DEFAULT NULL
83 ,P_BANK_ACCOUNT_ID IN NUMBER DEFAULT NULL
84 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
85 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
86 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
87 ,P_CREATION_DATE IN DATE DEFAULT NULL
88 ,P_CREATED_BY IN NUMBER DEFAULT NULL
89 ,P_REQUEST_ID IN NUMBER DEFAULT NULL
90 ,P_AUTOFUNDING_FLAG IN VARCHAR2 DEFAULT NULL
91 ,P_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL
92 ,P_FUNDING_DATE IN DATE DEFAULT NULL
93 );
94 END;
95