eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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.1 2005/07/13 13:50:34 scherkas noship $ */
3:
4: /* Insert_Row procedure */
5: PROCEDURE Insert_Row(

Line 57: INSERT INTO LNS_AMORTIZATION_SCHEDS

53: ,P_PRINCIPAL_BALANCE IN NUMBER
54: ,P_PHASE IN VARCHAR2
55: ) IS
56: BEGIN
57: INSERT INTO LNS_AMORTIZATION_SCHEDS
58: (
59: AMORTIZATION_SCHEDULE_ID
60: ,LOAN_ID
61: ,PAYMENT_NUMBER

Line 109: 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)

105: ,STATEMENT_XML
106: ,PRINCIPAL_BALANCE
107: ,PHASE
108: ) VALUES (
109: 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)
110: ,DECODE(P_LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
111: ,DECODE(P_PAYMENT_NUMBER, FND_API.G_MISS_NUM, NULL, P_PAYMENT_NUMBER)
112: ,DECODE(P_DUE_DATE, FND_API.G_MISS_DATE, NULL, P_DUE_DATE)
113: ,DECODE(P_LATE_DATE, FND_API.G_MISS_DATE, NULL, P_LATE_DATE)

Line 214: UPDATE LNS_AMORTIZATION_SCHEDS SET

210: ,P_PRINCIPAL_BALANCE IN NUMBER
211: ,P_PHASE IN VARCHAR2
212: ) IS
213: BEGIN
214: UPDATE LNS_AMORTIZATION_SCHEDS SET
215: LOAN_ID = DECODE(P_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
216: ,PAYMENT_NUMBER = DECODE(P_PAYMENT_NUMBER, NULL, PAYMENT_NUMBER, FND_API.G_MISS_NUM, NULL, P_PAYMENT_NUMBER)
217: ,DUE_DATE = DECODE(P_DUE_DATE, NULL, DUE_DATE, FND_API.G_MISS_DATE, NULL, P_DUE_DATE)
218: ,LATE_DATE = DECODE(P_LATE_DATE, NULL, LATE_DATE, FND_API.G_MISS_DATE, NULL, P_LATE_DATE)

Line 273: UPDATE LNS_AMORTIZATION_SCHEDS SET

269: P_AMORTIZATION_SCHEDULE_ID IN NUMBER
270: ,P_STATEMENT_XML IN CLOB
271: ) IS
272: BEGIN
273: UPDATE LNS_AMORTIZATION_SCHEDS SET
274: STATEMENT_XML = P_STATEMENT_XML
275: WHERE AMORTIZATION_SCHEDULE_ID = P_AMORTIZATION_SCHEDULE_ID;
276:
277: if (sql%notfound) then

Line 285: DELETE FROM LNS_AMORTIZATION_SCHEDS

281:
282: /* Delete_Row procedure */
283: PROCEDURE Delete_Row(P_AMORTIZATION_SCHEDULE_ID IN NUMBER) IS
284: BEGIN
285: DELETE FROM LNS_AMORTIZATION_SCHEDS
286: WHERE AMORTIZATION_SCHEDULE_ID = P_AMORTIZATION_SCHEDULE_ID;
287:
288: if (sql%notfound) then
289: raise no_data_found;

Line 345: CURSOR C IS SELECT * FROM LNS_AMORTIZATION_SCHEDS

341: ,P_STATEMENT_XML IN CLOB
342: ,P_PRINCIPAL_BALANCE IN NUMBER
343: ,P_PHASE IN VARCHAR2
344: ) IS
345: CURSOR C IS SELECT * FROM LNS_AMORTIZATION_SCHEDS
346: WHERE AMORTIZATION_SCHEDULE_ID = P_AMORTIZATION_SCHEDULE_ID
347: FOR UPDATE of AMORTIZATION_SCHEDULE_ID NOWAIT;
348: Recinfo C%ROWTYPE;
349: BEGIN