1 PACKAGE LNS_FEE_ASSIGNMENTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: LNS_FASGM_TBLH_S.pls 120.6 2010/06/28 10:33:38 gparuchu ship $ */
3
4 /* Insert_Row procedure */
5 PROCEDURE Insert_Row(
6 X_FEE_ASSIGNMENT_ID IN OUT NOCOPY NUMBER
7 ,P_LOAN_ID IN NUMBER
8 ,P_FEE_ID IN NUMBER
9 ,P_FEE_TYPE IN VARCHAR2
10 ,P_FEE IN NUMBER
11 ,P_FEE_BASIS IN VARCHAR2
12 ,P_NUMBER_GRACE_DAYS IN NUMBER
13 ,P_CREATED_BY IN NUMBER
14 ,P_CREATION_DATE IN DATE
15 ,P_LAST_UPDATED_BY IN NUMBER
16 ,P_LAST_UPDATE_DATE IN DATE
17 ,P_LAST_UPDATE_LOGIN IN NUMBER
18 ,P_OBJECT_VERSION_NUMBER IN NUMBER
19 ,P_COLLECTED_THIRD_PARTY_FLAG IN VARCHAR2
20 ,P_BILLING_OPTION IN VARCHAR2
21 ,P_RATE_TYPE IN VARCHAR2
22 ,P_BEGIN_INSTALLMENT_NUMBER IN NUMBER
23 ,P_END_INSTALLMENT_NUMBER IN NUMBER
24 ,P_NUMBER_OF_PAYMENTS IN NUMBER
25 ,P_START_DATE_ACTIVE IN DATE
26 ,P_END_DATE_ACTIVE IN DATE
27 ,P_DISB_HEADER_ID IN NUMBER
28 ,P_DELETE_DISABLED_FLAG IN VARCHAR2
29 ,P_OPEN_PHASE_FLAG IN VARCHAR2
30 ,P_PHASE IN VARCHAR2
31 ,P_CUSTOM_PROCEDURE IN VARCHAR2
32 );
33
34 /* Update_Row procedure */
35 PROCEDURE Update_Row(
36 P_FEE_ASSIGNMENT_ID IN NUMBER
37 ,P_LOAN_ID IN NUMBER
38 ,P_FEE_ID IN NUMBER
39 ,P_FEE_TYPE IN VARCHAR2
40 ,P_FEE IN NUMBER
41 ,P_FEE_BASIS IN VARCHAR2
42 ,P_NUMBER_GRACE_DAYS IN NUMBER
43 ,P_LAST_UPDATED_BY IN NUMBER
44 ,P_LAST_UPDATE_DATE IN DATE
45 ,P_LAST_UPDATE_LOGIN IN NUMBER
46 ,P_OBJECT_VERSION_NUMBER IN NUMBER
47 ,P_COLLECTED_THIRD_PARTY_FLAG IN VARCHAR2
48 ,P_BILLING_OPTION IN VARCHAR2
49 ,P_RATE_TYPE IN VARCHAR2
50 ,P_BEGIN_INSTALLMENT_NUMBER IN NUMBER
51 ,P_END_INSTALLMENT_NUMBER IN NUMBER
52 ,P_NUMBER_OF_PAYMENTS IN NUMBER
53 ,P_START_DATE_ACTIVE IN DATE
54 ,P_END_DATE_ACTIVE IN DATE
55 ,P_DISB_HEADER_ID IN NUMBER
56 ,P_DELETE_DISABLED_FLAG IN VARCHAR2
57 ,P_OPEN_PHASE_FLAG IN VARCHAR2
58 ,P_PHASE IN VARCHAR2
59 ,P_CUSTOM_PROCEDURE IN VARCHAR2
60 );
61
62 /* Delete_Row procedure */
63 PROCEDURE Delete_Row(P_FEE_ASSIGNMENT_ID IN NUMBER);
64
65 /* Lock_Row procedure */
66 PROCEDURE Lock_Row(
67 P_FEE_ASSIGNMENT_ID IN NUMBER
68 ,P_LOAN_ID IN NUMBER
69 ,P_FEE_ID IN NUMBER
70 ,P_FEE_TYPE IN VARCHAR2
71 ,P_FEE IN NUMBER
72 ,P_FEE_BASIS IN VARCHAR2
73 ,P_NUMBER_GRACE_DAYS IN NUMBER
74 ,P_CREATED_BY IN NUMBER
75 ,P_CREATION_DATE IN DATE
76 ,P_LAST_UPDATED_BY IN NUMBER
77 ,P_LAST_UPDATE_DATE IN DATE
78 ,P_LAST_UPDATE_LOGIN IN NUMBER
79 ,P_OBJECT_VERSION_NUMBER IN NUMBER
80 ,P_COLLECTED_THIRD_PARTY_FLAG IN VARCHAR2
81 ,P_BILLING_OPTION IN VARCHAR2
82 ,P_RATE_TYPE IN VARCHAR2
83 ,P_BEGIN_INSTALLMENT_NUMBER IN NUMBER
84 ,P_END_INSTALLMENT_NUMBER IN NUMBER
85 ,P_NUMBER_OF_PAYMENTS IN NUMBER
86 ,P_START_DATE_ACTIVE IN DATE
87 ,P_END_DATE_ACTIVE IN DATE
88 ,P_DISB_HEADER_ID IN NUMBER
89 ,P_DELETE_DISABLED_FLAG IN VARCHAR2
90 ,P_OPEN_PHASE_FLAG IN VARCHAR2
91 ,P_PHASE IN VARCHAR2
92 ,P_CUSTOM_PROCEDURE IN VARCHAR2
93 );
94 END;
95