APPS.LNS_AMORTIZATION_SCHEDS_PKG dependencies on LNS_AMORTIZATION_SCHEDS

Line 1: PACKAGE BODY LNS_AMORTIZATION_SCHEDS_PKG AS

1: PACKAGE BODY LNS_AMORTIZATION_SCHEDS_PKG AS
2: /* $Header: LNS_AMSCH_TBLH_B.pls 120.4 2011/10/25 18:13:22 scherkas ship $ */
3:
4: /* Insert_Row procedure */
5: PROCEDURE Insert_Row(

Line 61: INSERT INTO LNS_AMORTIZATION_SCHEDS

57: ,P_CAP_INT_AMOUNT IN NUMBER
58: ,P_CURR_CAP_INT_AMOUNT IN NUMBER DEFAULT NULL
59: ) IS
60: BEGIN
61: INSERT INTO LNS_AMORTIZATION_SCHEDS
62: (
63: AMORTIZATION_SCHEDULE_ID
64: ,LOAN_ID
65: ,PAYMENT_NUMBER

Line 117: DECODE(X_AMORTIZATION_SCHEDULE_ID, FND_API.G_MISS_NUM, LNS_AMORTIZATION_SCHEDS_S.NEXTVAL, NULL, LNS_AMORTIZATION_SCHEDS_S.NEXTVAL, X_AMORTIZATION_SCHEDULE_ID)

113: ,DEFERRED_INT_AMOUNT
114: ,CAP_INT_AMOUNT
115: ,CURR_CAP_INT_AMOUNT
116: ) VALUES (
117: DECODE(X_AMORTIZATION_SCHEDULE_ID, FND_API.G_MISS_NUM, LNS_AMORTIZATION_SCHEDS_S.NEXTVAL, NULL, LNS_AMORTIZATION_SCHEDS_S.NEXTVAL, X_AMORTIZATION_SCHEDULE_ID)
118: ,DECODE(P_LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
119: ,DECODE(P_PAYMENT_NUMBER, FND_API.G_MISS_NUM, NULL, P_PAYMENT_NUMBER)
120: ,DECODE(P_DUE_DATE, FND_API.G_MISS_DATE, NULL, P_DUE_DATE)
121: ,DECODE(P_LATE_DATE, FND_API.G_MISS_DATE, NULL, P_LATE_DATE)

Line 230: UPDATE LNS_AMORTIZATION_SCHEDS SET

226: ,P_CAP_INT_AMOUNT IN NUMBER
227: ,P_CURR_CAP_INT_AMOUNT IN NUMBER DEFAULT NULL
228: ) IS
229: BEGIN
230: UPDATE LNS_AMORTIZATION_SCHEDS SET
231: LOAN_ID = DECODE(P_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
232: ,PAYMENT_NUMBER = DECODE(P_PAYMENT_NUMBER, NULL, PAYMENT_NUMBER, FND_API.G_MISS_NUM, NULL, P_PAYMENT_NUMBER)
233: ,DUE_DATE = DECODE(P_DUE_DATE, NULL, DUE_DATE, FND_API.G_MISS_DATE, NULL, P_DUE_DATE)
234: ,LATE_DATE = DECODE(P_LATE_DATE, NULL, LATE_DATE, FND_API.G_MISS_DATE, NULL, P_LATE_DATE)

Line 293: UPDATE LNS_AMORTIZATION_SCHEDS SET

289: P_AMORTIZATION_SCHEDULE_ID IN NUMBER
290: ,P_STATEMENT_XML IN CLOB
291: ) IS
292: BEGIN
293: UPDATE LNS_AMORTIZATION_SCHEDS SET
294: STATEMENT_XML = P_STATEMENT_XML
295: WHERE AMORTIZATION_SCHEDULE_ID = P_AMORTIZATION_SCHEDULE_ID;
296:
297: if (sql%notfound) then

Line 305: DELETE FROM LNS_AMORTIZATION_SCHEDS

301:
302: /* Delete_Row procedure */
303: PROCEDURE Delete_Row(P_AMORTIZATION_SCHEDULE_ID IN NUMBER) IS
304: BEGIN
305: DELETE FROM LNS_AMORTIZATION_SCHEDS
306: WHERE AMORTIZATION_SCHEDULE_ID = P_AMORTIZATION_SCHEDULE_ID;
307:
308: if (sql%notfound) then
309: raise no_data_found;

Line 369: CURSOR C IS SELECT * FROM LNS_AMORTIZATION_SCHEDS

365: ,P_DEFERRED_INT_AMOUNT IN NUMBER
366: ,P_CAP_INT_AMOUNT IN NUMBER
367: ,P_CURR_CAP_INT_AMOUNT IN NUMBER DEFAULT NULL
368: ) IS
369: CURSOR C IS SELECT * FROM LNS_AMORTIZATION_SCHEDS
370: WHERE AMORTIZATION_SCHEDULE_ID = P_AMORTIZATION_SCHEDULE_ID
371: FOR UPDATE of AMORTIZATION_SCHEDULE_ID NOWAIT;
372: Recinfo C%ROWTYPE;
373: BEGIN