[Home] [Help]
1: PACKAGE BODY LNS_AMORTIZATION_LINES_PKG AS
2: /* $Header: LNS_AMLNS_TBLH_B.pls 120.1 2011/01/05 21:24:02 scherkas ship $ */
3:
4: /* Insert_Row procedure */
5: PROCEDURE Insert_Row(
20: ,P_FEE_SCHEDULE_ID IN NUMBER
21: ,P_LINE_DETAILS IN VARCHAR2 DEFAULT NULL
22: ) IS
23: BEGIN
24: INSERT INTO LNS_AMORTIZATION_LINES
25: (
26: AMORTIZATION_LINE_ID
27: ,AMORTIZATION_SCHEDULE_ID
28: ,LOAN_ID
39: ,LAST_UPDATE_LOGIN
40: ,FEE_SCHEDULE_ID
41: ,LINE_DETAILS
42: ) VALUES (
43: DECODE(X_AMORTIZATION_LINE_ID, FND_API.G_MISS_NUM, LNS_AMORTIZATION_LINES_S.NEXTVAL, NULL, LNS_AMORTIZATION_LINES_S.NEXTVAL, X_AMORTIZATION_LINE_ID)
44: ,DECODE(P_AMORTIZATION_SCHEDULE_ID, FND_API.G_MISS_NUM, NULL, P_AMORTIZATION_SCHEDULE_ID)
45: ,DECODE(P_LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
46: ,DECODE(P_LINE_TYPE, FND_API.G_MISS_CHAR, NULL, P_LINE_TYPE)
47: ,DECODE(P_AMOUNT, FND_API.G_MISS_NUM, NULL, P_AMOUNT)
79: ,P_FEE_SCHEDULE_ID IN NUMBER
80: ,P_LINE_DETAILS IN VARCHAR2 DEFAULT NULL
81: ) IS
82: BEGIN
83: UPDATE LNS_AMORTIZATION_LINES SET
84: AMORTIZATION_SCHEDULE_ID = DECODE(P_AMORTIZATION_SCHEDULE_ID, NULL, AMORTIZATION_SCHEDULE_ID, FND_API.G_MISS_NUM, NULL, P_AMORTIZATION_SCHEDULE_ID)
85: ,LOAN_ID = DECODE(P_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
86: ,LINE_TYPE = DECODE(P_LINE_TYPE, NULL, LINE_TYPE, FND_API.G_MISS_CHAR, NULL, P_LINE_TYPE)
87: ,AMOUNT = DECODE(P_AMOUNT, NULL, AMOUNT, FND_API.G_MISS_NUM, NULL, P_AMOUNT)
103:
104: /* Delete_Row procedure */
105: PROCEDURE Delete_Row(P_AMORTIZATION_LINE_ID IN NUMBER) IS
106: BEGIN
107: DELETE FROM LNS_AMORTIZATION_LINES
108: WHERE AMORTIZATION_LINE_ID = P_AMORTIZATION_LINE_ID;
109:
110: if (sql%notfound) then
111: raise no_data_found;
130: ,P_LAST_UPDATE_LOGIN IN NUMBER
131: ,P_FEE_SCHEDULE_ID IN NUMBER
132: ,P_LINE_DETAILS IN VARCHAR2 DEFAULT NULL
133: ) IS
134: CURSOR C IS SELECT * FROM LNS_AMORTIZATION_LINES
135: WHERE AMORTIZATION_LINE_ID = P_AMORTIZATION_LINE_ID
136: FOR UPDATE of AMORTIZATION_LINE_ID NOWAIT;
137: Recinfo C%ROWTYPE;
138: BEGIN