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.16.12020000.2 2012/07/19 21:00:33 scherkas ship $ */
3:
4: PROCEDURE Insert_Row (
5: X_TERM_ID IN OUT NOCOPY NUMBER,

Line 2: /*$Header: LNS_TERMS_TBLH_B.pls 120.16.12020000.2 2012/07/19 21:00:33 scherkas ship $ */

1: PACKAGE BODY LNS_TERMS_PKG AS
2: /*$Header: LNS_TERMS_TBLH_B.pls 120.16.12020000.2 2012/07/19 21:00:33 scherkas ship $ */
3:
4: PROCEDURE Insert_Row (
5: X_TERM_ID IN OUT NOCOPY NUMBER,
6: X_LOAN_ID IN NUMBER,

Line 76: INSERT INTO LNS_TERMS

72: ) IS
73:
74: BEGIN
75:
76: INSERT INTO LNS_TERMS
77: (
78: TERM_ID
79: ,LOAN_ID
80: ,LAST_UPDATE_DATE

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

146: ,CAPITALIZE_INT
147: ,CALC_EARLY_PAY_CR
148: ,FLUCTUATE_EQ_PAY_AMOUNT
149: ) VALUES (
150: DECODE( X_TERM_ID, FND_API.G_MISS_NUM, LNS_TERMS_S.NEXTVAL, NULL, LNS_TERMS_S.NEXTVAL, X_TERM_ID )
151: ,DECODE( X_LOAN_ID, FND_API.G_MISS_NUM, NULL, X_LOAN_ID )
152: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
153: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
154: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

Line 305: p_table_name => 'LNS_TERMS'

301: --Call to record history
302: LNS_LOAN_HISTORY_PUB.log_record_pre(
303: p_id => X_TERM_ID,
304: p_primary_key_name => 'TERM_ID',
305: p_table_name => 'LNS_TERMS'
306: );
307:
308: UPDATE LNS_TERMS SET
309: TERM_ID = DECODE( X_TERM_ID, NULL, TERM_ID, FND_API.G_MISS_NUM, NULL, X_TERM_ID )

Line 308: UPDATE LNS_TERMS SET

304: p_primary_key_name => 'TERM_ID',
305: p_table_name => 'LNS_TERMS'
306: );
307:
308: UPDATE LNS_TERMS SET
309: TERM_ID = DECODE( X_TERM_ID, NULL, TERM_ID, FND_API.G_MISS_NUM, NULL, X_TERM_ID )
310: ,LOAN_ID = DECODE( X_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, X_LOAN_ID )
311: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
312: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

Line 390: p_table_name => 'LNS_TERMS',

386: --Call to record history
387: LNS_LOAN_HISTORY_PUB.log_record_post(
388: p_id => X_TERM_ID,
389: p_primary_key_name => 'TERM_ID',
390: p_table_name => 'LNS_TERMS',
391: p_loan_id => X_LOAN_ID
392: );
393: END Update_Row;
394:

Line 470: CURSOR C IS SELECT * FROM LNS_TERMS

466: X_CALC_EARLY_PAY_CR IN VARCHAR2,
467: X_FLUCTUATE_EQ_PAY_AMOUNT IN VARCHAR2
468:
469: ) IS
470: CURSOR C IS SELECT * FROM LNS_TERMS
471: WHERE rowid = x_rowid
472: FOR UPDATE of LOAN_ID NOWAIT;
473: Recinfo C%ROWTYPE;
474: BEGIN

Line 703: FROM LNS_TERMS

699: X_CUSTOM_SCHED_DESC,
700: X_CAPITALIZE_INT,
701: X_CALC_EARLY_PAY_CR,
702: X_FLUCTUATE_EQ_PAY_AMOUNT
703: FROM LNS_TERMS
704: WHERE TERM_ID = X_TERM_ID;
705:
706: EXCEPTION
707: WHEN NO_DATA_FOUND THEN

Line 722: DELETE FROM LNS_TERMS

718: ) IS
719:
720: BEGIN
721:
722: DELETE FROM LNS_TERMS
723: WHERE TERM_ID = X_TERM_ID;
724:
725: IF ( SQL%NOTFOUND ) THEN
726: RAISE NO_DATA_FOUND;

Line 731: END LNS_TERMS_PKG;

727: END IF;
728:
729: END Delete_Row;
730:
731: END LNS_TERMS_PKG;