1 PACKAGE LNS_FEE_ASSIGNMENTS_PKG AS
2 /* $Header: LNS_FASGM_TBLH_S.pls 120.2 2005/08/22 05:38:51 hikumar noship $ */
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 );
30
31 /* Update_Row procedure */
32 PROCEDURE Update_Row(
33 P_FEE_ASSIGNMENT_ID IN NUMBER
34 ,P_LOAN_ID IN NUMBER
35 ,P_FEE_ID IN NUMBER
36 ,P_FEE_TYPE IN VARCHAR2
37 ,P_FEE IN NUMBER
38 ,P_FEE_BASIS IN VARCHAR2
39 ,P_NUMBER_GRACE_DAYS IN NUMBER
40 ,P_LAST_UPDATED_BY IN NUMBER
41 ,P_LAST_UPDATE_DATE IN DATE
42 ,P_LAST_UPDATE_LOGIN IN NUMBER
43 ,P_OBJECT_VERSION_NUMBER IN NUMBER
44 ,P_COLLECTED_THIRD_PARTY_FLAG IN VARCHAR2
45 ,P_BILLING_OPTION IN VARCHAR2
46 ,P_RATE_TYPE IN VARCHAR2
47 ,P_BEGIN_INSTALLMENT_NUMBER IN NUMBER
48 ,P_END_INSTALLMENT_NUMBER IN NUMBER
49 ,P_NUMBER_OF_PAYMENTS IN NUMBER
50 ,P_START_DATE_ACTIVE IN DATE
51 ,P_END_DATE_ACTIVE IN DATE
52 ,P_DISB_HEADER_ID IN NUMBER
53 ,P_DELETE_DISABLED_FLAG IN VARCHAR2
54 );
55
56 /* Delete_Row procedure */
57 PROCEDURE Delete_Row(P_FEE_ASSIGNMENT_ID IN NUMBER);
58
59 /* Lock_Row procedure */
60 PROCEDURE Lock_Row(
61 P_FEE_ASSIGNMENT_ID IN NUMBER
62 ,P_LOAN_ID IN NUMBER
63 ,P_FEE_ID IN NUMBER
64 ,P_FEE_TYPE IN VARCHAR2
65 ,P_FEE IN NUMBER
66 ,P_FEE_BASIS IN VARCHAR2
67 ,P_NUMBER_GRACE_DAYS IN NUMBER
68 ,P_CREATED_BY IN NUMBER
69 ,P_CREATION_DATE IN DATE
70 ,P_LAST_UPDATED_BY IN NUMBER
71 ,P_LAST_UPDATE_DATE IN DATE
72 ,P_LAST_UPDATE_LOGIN IN NUMBER
73 ,P_OBJECT_VERSION_NUMBER IN NUMBER
74 ,P_COLLECTED_THIRD_PARTY_FLAG IN VARCHAR2
75 ,P_BILLING_OPTION IN VARCHAR2
76 ,P_RATE_TYPE IN VARCHAR2
77 ,P_BEGIN_INSTALLMENT_NUMBER IN NUMBER
78 ,P_END_INSTALLMENT_NUMBER IN NUMBER
79 ,P_NUMBER_OF_PAYMENTS IN NUMBER
80 ,P_START_DATE_ACTIVE IN DATE
81 ,P_END_DATE_ACTIVE IN DATE
82 ,P_DISB_HEADER_ID IN NUMBER
83 ,P_DELETE_DISABLED_FLAG IN VARCHAR2
84 );
85 END;
86