1 PACKAGE BODY LNS_FUNDING_ADVICES_PKG AS
2 /* $Header: LNS_FUND_TBLH_B.pls 120.1 2006/01/18 13:37:24 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
9 ,P_SUBMISSION_DATE IN DATE
10 ,P_AMOUNT IN NUMBER
11 ,P_CURRENCY IN VARCHAR2
12 ,P_DESCRIPTION IN VARCHAR2
13 ,P_DUE_DATE IN DATE
14 ,P_INVOICE_ID IN NUMBER
15 ,P_INVOICE_NUMBER IN VARCHAR2
16 ,P_PAYMENT_METHOD IN VARCHAR2
17 ,P_STATUS IN VARCHAR2
18 ,P_PAYEE_ID IN NUMBER
19 ,P_PAYEE_SITE_ID IN NUMBER
20 ,P_SITE_CONTACT_ID IN NUMBER
21 ,P_BANK_BRANCH_ID IN NUMBER
22 ,P_BANK_ACCOUNT_ID IN NUMBER
23 ,P_LAST_UPDATE_DATE IN DATE
24 ,P_LAST_UPDATED_BY IN NUMBER
25 ,P_LAST_UPDATE_LOGIN IN NUMBER
26 ,P_CREATION_DATE IN DATE
27 ,P_CREATED_BY IN NUMBER
28 ,P_REQUEST_ID IN NUMBER
29 ,P_AUTOFUNDING_FLAG IN VARCHAR2
30 ,P_OBJECT_VERSION_NUMBER IN NUMBER
31 ,P_FUNDING_DATE IN DATE
32 ) IS
33 BEGIN
34 null;
35 END Insert_Row;
36
37 /* Update_Row procedure */
38 PROCEDURE Update_Row(
39 P_FUNDING_ADVICE_ID IN NUMBER
40 ,P_LOAN_ID IN NUMBER
41 ,P_ADVICE_NUMBER IN VARCHAR2
42 ,P_SUBMISSION_DATE IN DATE
43 ,P_AMOUNT IN NUMBER
44 ,P_CURRENCY IN VARCHAR2
45 ,P_DESCRIPTION IN VARCHAR2
46 ,P_DUE_DATE IN DATE
47 ,P_INVOICE_ID IN NUMBER
48 ,P_INVOICE_NUMBER IN VARCHAR2
49 ,P_PAYMENT_METHOD IN VARCHAR2
50 ,P_STATUS IN VARCHAR2
51 ,P_PAYEE_ID IN NUMBER
52 ,P_PAYEE_SITE_ID IN NUMBER
53 ,P_SITE_CONTACT_ID IN NUMBER
54 ,P_BANK_BRANCH_ID IN NUMBER
55 ,P_BANK_ACCOUNT_ID IN NUMBER
56 ,P_LAST_UPDATE_DATE IN DATE
57 ,P_LAST_UPDATED_BY IN NUMBER
58 ,P_LAST_UPDATE_LOGIN IN NUMBER
59 ,P_REQUEST_ID IN NUMBER
60 ,P_AUTOFUNDING_FLAG IN VARCHAR2
61 ,P_OBJECT_VERSION_NUMBER IN NUMBER
62 ,P_FUNDING_DATE IN DATE
63 ) IS
64 BEGIN
65 null;
66 END Update_Row;
67
68 /* Delete_Row procedure */
69 PROCEDURE Delete_Row(P_FUNDING_ADVICE_ID IN NUMBER) IS
70 BEGIN
71 null;
72 END Delete_Row;
73
74 /* Lock_Row procedure */
75 PROCEDURE Lock_Row(
76 P_FUNDING_ADVICE_ID IN NUMBER
77 ,P_LOAN_ID IN NUMBER
78 ,P_ADVICE_NUMBER IN VARCHAR2
79 ,P_SUBMISSION_DATE IN DATE
80 ,P_AMOUNT IN NUMBER
81 ,P_CURRENCY IN VARCHAR2
82 ,P_DESCRIPTION IN VARCHAR2
83 ,P_DUE_DATE IN DATE
84 ,P_INVOICE_ID IN NUMBER
85 ,P_INVOICE_NUMBER IN VARCHAR2
86 ,P_PAYMENT_METHOD IN VARCHAR2
87 ,P_STATUS IN VARCHAR2
88 ,P_PAYEE_ID IN NUMBER
89 ,P_PAYEE_SITE_ID IN NUMBER
90 ,P_SITE_CONTACT_ID IN NUMBER
91 ,P_BANK_BRANCH_ID IN NUMBER
92 ,P_BANK_ACCOUNT_ID IN NUMBER
93 ,P_LAST_UPDATE_DATE IN DATE
94 ,P_LAST_UPDATED_BY IN NUMBER
95 ,P_LAST_UPDATE_LOGIN IN NUMBER
96 ,P_CREATION_DATE IN DATE
97 ,P_CREATED_BY IN NUMBER
98 ,P_REQUEST_ID IN NUMBER
99 ,P_AUTOFUNDING_FLAG IN VARCHAR2
100 ,P_OBJECT_VERSION_NUMBER IN NUMBER
101 ,P_FUNDING_DATE IN DATE
102 ) IS
103 BEGIN
104 null;
105 END Lock_Row;
106 END;
107