APPS.LNS_TERMS_PKG dependencies on LNS_TERMS

Line 1: PACKAGE BODY LNS_TERMS_PKG AS

1: PACKAGE BODY LNS_TERMS_PKG AS
2: /*$Header: LNS_TERMS_TBLH_B.pls 120.5.12010000.7 2009/01/12 20:22:35 scherkas ship $ */
3:
4: PROCEDURE Insert_Row (
5: X_TERM_ID IN OUT NOCOPY NUMBER,

Line 2: /*$Header: LNS_TERMS_TBLH_B.pls 120.5.12010000.7 2009/01/12 20:22:35 scherkas ship $ */

1: PACKAGE BODY LNS_TERMS_PKG AS
2: /*$Header: LNS_TERMS_TBLH_B.pls 120.5.12010000.7 2009/01/12 20:22:35 scherkas ship $ */
3:
4: PROCEDURE Insert_Row (
5: X_TERM_ID IN OUT NOCOPY NUMBER,
6: X_LOAN_ID IN NUMBER,

Line 68: INSERT INTO LNS_TERMS

64: ) IS
65:
66: BEGIN
67:
68: INSERT INTO LNS_TERMS
69: (
70: TERM_ID
71: ,LOAN_ID
72: ,LAST_UPDATE_DATE

Line 134: DECODE( X_TERM_ID, FND_API.G_MISS_NUM, LNS_TERMS_S.NEXTVAL, NULL, LNS_TERMS_S.NEXTVAL, X_TERM_ID )

130: ,PRIN_PAYMENT_FREQUENCY
131: ,PENAL_INT_RATE
132: ,PENAL_INT_GRACE_DAYS
133: ) VALUES (
134: DECODE( X_TERM_ID, FND_API.G_MISS_NUM, LNS_TERMS_S.NEXTVAL, NULL, LNS_TERMS_S.NEXTVAL, X_TERM_ID )
135: ,DECODE( X_LOAN_ID, FND_API.G_MISS_NUM, NULL, X_LOAN_ID )
136: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
137: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
138: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

Line 273: p_table_name => 'LNS_TERMS'

269: --Call to record history
270: LNS_LOAN_HISTORY_PUB.log_record_pre(
271: p_id => X_TERM_ID,
272: p_primary_key_name => 'TERM_ID',
273: p_table_name => 'LNS_TERMS'
274: );
275:
276: UPDATE LNS_TERMS SET
277: TERM_ID = DECODE( X_TERM_ID, NULL, TERM_ID, FND_API.G_MISS_NUM, NULL, X_TERM_ID )

Line 276: UPDATE LNS_TERMS SET

272: p_primary_key_name => 'TERM_ID',
273: p_table_name => 'LNS_TERMS'
274: );
275:
276: UPDATE LNS_TERMS SET
277: TERM_ID = DECODE( X_TERM_ID, NULL, TERM_ID, FND_API.G_MISS_NUM, NULL, X_TERM_ID )
278: ,LOAN_ID = DECODE( X_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, X_LOAN_ID )
279: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
280: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

Line 350: p_table_name => 'LNS_TERMS',

346: --Call to record history
347: LNS_LOAN_HISTORY_PUB.log_record_post(
348: p_id => X_TERM_ID,
349: p_primary_key_name => 'TERM_ID',
350: p_table_name => 'LNS_TERMS',
351: p_loan_id => X_LOAN_ID
352: );
353: END Update_Row;
354:

Line 422: CURSOR C IS SELECT * FROM LNS_TERMS

418: X_PENAL_INT_RATE IN NUMBER,
419: X_PENAL_INT_GRACE_DAYS IN NUMBER
420:
421: ) IS
422: CURSOR C IS SELECT * FROM LNS_TERMS
423: WHERE rowid = x_rowid
424: FOR UPDATE of LOAN_ID NOWAIT;
425: Recinfo C%ROWTYPE;
426: BEGIN

Line 631: FROM LNS_TERMS

627: X_PRIN_FIRST_PAY_DATE,
628: X_PRIN_PAYMENT_FREQUENCY,
629: X_PENAL_INT_RATE,
630: X_PENAL_INT_GRACE_DAYS
631: FROM LNS_TERMS
632: WHERE TERM_ID = X_TERM_ID;
633:
634: EXCEPTION
635: WHEN NO_DATA_FOUND THEN

Line 650: DELETE FROM LNS_TERMS

646: ) IS
647:
648: BEGIN
649:
650: DELETE FROM LNS_TERMS
651: WHERE TERM_ID = X_TERM_ID;
652:
653: IF ( SQL%NOTFOUND ) THEN
654: RAISE NO_DATA_FOUND;

Line 659: END LNS_TERMS_PKG;

655: END IF;
656:
657: END Delete_Row;
658:
659: END LNS_TERMS_PKG;