1 PACKAGE LNS_AMORTIZATION_LINES_PKG AS
2 /* $Header: LNS_AMLNS_TBLH_S.pls 120.0 2005/05/31 17:27:35 appldev noship $ */
3
4 /* Insert_Row procedure */
5 PROCEDURE Insert_Row(
6 X_AMORTIZATION_LINE_ID IN OUT NOCOPY NUMBER
7 ,P_AMORTIZATION_SCHEDULE_ID IN NUMBER
8 ,P_LOAN_ID IN NUMBER
9 ,P_LINE_TYPE IN VARCHAR2 DEFAULT NULL
10 ,P_AMOUNT IN NUMBER DEFAULT NULL
11 ,P_CUST_TRX_ID IN NUMBER DEFAULT NULL
12 ,P_CUST_TRX_LINE_ID IN NUMBER DEFAULT NULL
13 ,P_FEE_ID IN NUMBER DEFAULT NULL
14 ,P_OBJECT_VERSION_NUMBER IN NUMBER
15 ,P_CREATION_DATE IN DATE DEFAULT NULL
16 ,P_CREATED_BY IN NUMBER DEFAULT NULL
17 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
18 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
19 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
20 ,P_FEE_SCHEDULE_ID IN NUMBER DEFAULT NULL
21 );
22
23 /* Update_Row procedure */
24 PROCEDURE Update_Row(
25 P_AMORTIZATION_LINE_ID IN NUMBER
26 ,P_AMORTIZATION_SCHEDULE_ID IN NUMBER DEFAULT NULL
27 ,P_LOAN_ID IN NUMBER DEFAULT NULL
28 ,P_LINE_TYPE IN VARCHAR2 DEFAULT NULL
29 ,P_AMOUNT IN NUMBER DEFAULT NULL
30 ,P_CUST_TRX_ID IN NUMBER DEFAULT NULL
31 ,P_CUST_TRX_LINE_ID IN NUMBER DEFAULT NULL
32 ,P_FEE_ID IN NUMBER DEFAULT NULL
33 ,P_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL
34 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
35 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
36 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
37 ,P_FEE_SCHEDULE_ID IN NUMBER DEFAULT NULL
38 );
39
40 /* Delete_Row procedure */
41 PROCEDURE Delete_Row(P_AMORTIZATION_LINE_ID IN NUMBER);
42
43 /* Lock_Row procedure */
44 PROCEDURE Lock_Row(
45 P_AMORTIZATION_LINE_ID IN NUMBER
46 ,P_AMORTIZATION_SCHEDULE_ID IN NUMBER DEFAULT NULL
47 ,P_LOAN_ID IN NUMBER DEFAULT NULL
48 ,P_LINE_TYPE IN VARCHAR2 DEFAULT NULL
49 ,P_AMOUNT IN NUMBER DEFAULT NULL
50 ,P_CUST_TRX_ID IN NUMBER DEFAULT NULL
51 ,P_CUST_TRX_LINE_ID IN NUMBER DEFAULT NULL
52 ,P_FEE_ID IN NUMBER DEFAULT NULL
53 ,P_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL
54 ,P_CREATION_DATE IN DATE DEFAULT NULL
55 ,P_CREATED_BY IN NUMBER DEFAULT NULL
56 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
57 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
58 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
59 ,P_FEE_SCHEDULE_ID IN NUMBER DEFAULT NULL
60 );
61 END;
62