1 PACKAGE LNS_AMORTIZATION_LINES_PKG AUTHID CURRENT_USER AS
2 /* $Header: LNS_AMLNS_TBLH_S.pls 120.1 2011/01/05 21:23:36 scherkas ship $ */
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 ,P_LINE_DETAILS IN VARCHAR2 DEFAULT NULL
22 );
23
24 /* Update_Row procedure */
25 PROCEDURE Update_Row(
26 P_AMORTIZATION_LINE_ID IN NUMBER
27 ,P_AMORTIZATION_SCHEDULE_ID IN NUMBER DEFAULT NULL
28 ,P_LOAN_ID IN NUMBER DEFAULT NULL
29 ,P_LINE_TYPE IN VARCHAR2 DEFAULT NULL
30 ,P_AMOUNT IN NUMBER DEFAULT NULL
31 ,P_CUST_TRX_ID IN NUMBER DEFAULT NULL
32 ,P_CUST_TRX_LINE_ID IN NUMBER DEFAULT NULL
33 ,P_FEE_ID IN NUMBER DEFAULT NULL
34 ,P_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL
35 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
36 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
37 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
38 ,P_FEE_SCHEDULE_ID IN NUMBER DEFAULT NULL
39 ,P_LINE_DETAILS IN VARCHAR2 DEFAULT NULL
40 );
41
42 /* Delete_Row procedure */
43 PROCEDURE Delete_Row(P_AMORTIZATION_LINE_ID IN NUMBER);
44
45 /* Lock_Row procedure */
46 PROCEDURE Lock_Row(
47 P_AMORTIZATION_LINE_ID IN NUMBER
48 ,P_AMORTIZATION_SCHEDULE_ID IN NUMBER DEFAULT NULL
49 ,P_LOAN_ID IN NUMBER DEFAULT NULL
50 ,P_LINE_TYPE IN VARCHAR2 DEFAULT NULL
51 ,P_AMOUNT IN NUMBER DEFAULT NULL
52 ,P_CUST_TRX_ID IN NUMBER DEFAULT NULL
53 ,P_CUST_TRX_LINE_ID IN NUMBER DEFAULT NULL
54 ,P_FEE_ID IN NUMBER DEFAULT NULL
55 ,P_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL
56 ,P_CREATION_DATE IN DATE DEFAULT NULL
57 ,P_CREATED_BY IN NUMBER DEFAULT NULL
58 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
59 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
60 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
61 ,P_FEE_SCHEDULE_ID IN NUMBER DEFAULT NULL
62 ,P_LINE_DETAILS IN VARCHAR2 DEFAULT NULL
63 );
64 END;
65