1 PACKAGE LNS_FEE_SCHEDULES_PKG AUTHID CURRENT_USER AS
2 /* $Header: LNS_FEESC_TBLH_S.pls 120.1.12010000.2 2010/02/24 01:47:29 mbolli ship $ */
3
4 /* Insert_Row procedure */
5 PROCEDURE Insert_Row(
6 X_FEE_SCHEDULE_ID IN OUT NOCOPY NUMBER
7 ,P_FEE_ID IN NUMBER DEFAULT NULL
8 ,P_LOAN_ID IN NUMBER
9 ,P_FEE_AMOUNT IN NUMBER
10 ,P_FEE_INSTALLMENT IN NUMBER
11 ,P_FEE_DESCRIPTION IN VARCHAR2 DEFAULT NULL
12 ,P_ACTIVE_FLAG IN VARCHAR2 DEFAULT NULL
13 ,P_BILLED_FLAG IN VARCHAR2 DEFAULT NULL
14 ,P_FEE_WAIVABLE_FLAG IN VARCHAR2 DEFAULT NULL
15 ,P_WAIVED_AMOUNT IN NUMBER DEFAULT NULL
16 ,P_CREATED_BY IN NUMBER DEFAULT NULL
17 ,P_CREATION_DATE IN DATE DEFAULT NULL
18 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
19 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
20 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
21 ,P_PROGRAM_ID IN NUMBER DEFAULT NULL
22 ,P_REQUEST_ID IN NUMBER DEFAULT NULL
23 ,P_OBJECT_VERSION_NUMBER IN NUMBER
24 ,P_DISB_HEADER_ID IN NUMBER DEFAULT NULL
25 ,P_PHASE IN VARCHAR2 DEFAULT NULL
26 );
27
28 /* Update_Row procedure */
29 PROCEDURE Update_Row(
30 P_FEE_SCHEDULE_ID IN NUMBER
31 ,P_FEE_ID IN NUMBER DEFAULT NULL
32 ,P_LOAN_ID IN NUMBER DEFAULT NULL
33 ,P_FEE_AMOUNT IN NUMBER DEFAULT NULL
34 ,P_FEE_INSTALLMENT IN NUMBER DEFAULT NULL
35 ,P_FEE_DESCRIPTION IN VARCHAR2 DEFAULT NULL
36 ,P_ACTIVE_FLAG IN VARCHAR2 DEFAULT NULL
37 ,P_BILLED_FLAG IN VARCHAR2 DEFAULT NULL
38 ,P_FEE_WAIVABLE_FLAG IN VARCHAR2 DEFAULT NULL
39 ,P_WAIVED_AMOUNT IN NUMBER DEFAULT NULL
40 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
41 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
42 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
43 ,P_PROGRAM_ID IN NUMBER DEFAULT NULL
44 ,P_REQUEST_ID IN NUMBER DEFAULT NULL
45 ,P_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL
46 ,P_DISB_HEADER_ID IN NUMBER DEFAULT NULL
47 ,P_PHASE IN VARCHAR2 DEFAULT NULL
48 );
49
50 /* Delete_Row procedure */
51 PROCEDURE Delete_Row(P_FEE_SCHEDULE_ID IN NUMBER);
52
53 /* Lock_Row procedure */
54 PROCEDURE Lock_Row(
55 P_FEE_SCHEDULE_ID IN NUMBER
56 ,P_FEE_ID IN NUMBER DEFAULT NULL
57 ,P_LOAN_ID IN NUMBER DEFAULT NULL
58 ,P_FEE_AMOUNT IN NUMBER DEFAULT NULL
59 ,P_FEE_INSTALLMENT IN NUMBER DEFAULT NULL
60 ,P_FEE_DESCRIPTION IN VARCHAR2 DEFAULT NULL
61 ,P_ACTIVE_FLAG IN VARCHAR2 DEFAULT NULL
62 ,P_BILLED_FLAG IN VARCHAR2 DEFAULT NULL
63 ,P_FEE_WAIVABLE_FLAG IN VARCHAR2 DEFAULT NULL
64 ,P_WAIVED_AMOUNT IN NUMBER DEFAULT NULL
65 ,P_CREATED_BY IN NUMBER DEFAULT NULL
66 ,P_CREATION_DATE IN DATE DEFAULT NULL
67 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
68 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
69 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
70 ,P_PROGRAM_ID IN NUMBER DEFAULT NULL
71 ,P_REQUEST_ID IN NUMBER DEFAULT NULL
72 ,P_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL
73 ,P_DISB_HEADER_ID IN NUMBER DEFAULT NULL
74 ,P_PHASE IN VARCHAR2 DEFAULT NULL
75 );
76 END;
77