APPS.LNS_AMORTIZATION_SCHEDS_PKG dependencies on LNS_AMORTIZATION_SCHEDS_S

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