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_EXT_LOAN_PUB dependencies on LNS_LOAN_EXTENSIONS

Line 112: from lns_loan_extensions

108: +-----------------------------------------------------------------------*/
109:
110: CURSOR extn_count_cur(P_LOAN_ID number) IS
111: select count(1)
112: from lns_loan_extensions
113: where loan_id = P_LOAN_ID and
114: STATUS = 'PENDING';
115:
116: CURSOR extn_details_cur(P_LOAN_EXT_ID number) IS

Line 118: from lns_loan_extensions

114: STATUS = 'PENDING';
115:
116: CURSOR extn_details_cur(P_LOAN_EXT_ID number) IS
117: select STATUS
118: from lns_loan_extensions
119: where LOAN_EXT_ID = P_LOAN_EXT_ID;
120:
121: CURSOR loan_details_cur(P_LOAN_ID number) IS
122: select LOAN_STATUS, nvl(custom_payments_flag, 'N'), nvl(CURRENT_PHASE, 'TERM')

Line 319: from lns_loan_extensions ext

315: ext.EXT_RATE,
316: ext.EXT_SPREAD,
317: ext.EXT_IO_FLAG,
318: ext.STATUS
319: from lns_loan_extensions ext
320: where ext.LOAN_EXT_ID = P_LOAN_EXT_ID;
321:
322: CURSOR loan_details_cur(P_LOAN_EXT_ID number) IS
323: select loan.LOAN_STATUS, nvl(loan.custom_payments_flag, 'N'), nvl(loan.CURRENT_PHASE, 'TERM')

Line 325: lns_loan_extensions ext

321:
322: CURSOR loan_details_cur(P_LOAN_EXT_ID number) IS
323: select loan.LOAN_STATUS, nvl(loan.custom_payments_flag, 'N'), nvl(loan.CURRENT_PHASE, 'TERM')
324: from lns_loan_headers_all loan,
325: lns_loan_extensions ext
326: where ext.LOAN_EXT_ID = P_LOAN_EXT_ID and
327: ext.loan_id = loan.loan_id;
328:
329: BEGIN

Line 476: | This procedure inserts/updates loan extension in lns_loan_extensions table

472: /*========================================================================
473: | PUBLIC PROCEDURE SAVE_LOAN_EXTENSION
474: |
475: | DESCRIPTION
476: | This procedure inserts/updates loan extension in lns_loan_extensions table
477: |
478: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
479: | None
480: |

Line 604: lns_loan_extensions

600: BEGIN
601: SELECT
602: 'Y' into l_is_exist
603: FROM
604: lns_loan_extensions
605: WHERE
606: loan_ext_id = P_LOAN_EXT_REC.LOAN_EXT_ID;
607:
608: EXCEPTION

Line 617: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting into lns_loan_extensions...');

613: --if (P_LOAN_EXT_REC.LOAN_EXT_ID is null) then
614:
615: if (l_is_exist <> 'Y') then
616:
617: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting into lns_loan_extensions...');
618:
619: if P_LOAN_EXT_REC.LOAN_EXT_ID is null then
620: select lns_loan_extensions_s.NEXTVAL into P_LOAN_EXT_REC.LOAN_EXT_ID from dual;
621: end if;

Line 620: select lns_loan_extensions_s.NEXTVAL into P_LOAN_EXT_REC.LOAN_EXT_ID from dual;

616:
617: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting into lns_loan_extensions...');
618:
619: if P_LOAN_EXT_REC.LOAN_EXT_ID is null then
620: select lns_loan_extensions_s.NEXTVAL into P_LOAN_EXT_REC.LOAN_EXT_ID from dual;
621: end if;
622:
623: insert into lns_loan_extensions(
624: LOAN_EXT_ID,

Line 623: insert into lns_loan_extensions(

619: if P_LOAN_EXT_REC.LOAN_EXT_ID is null then
620: select lns_loan_extensions_s.NEXTVAL into P_LOAN_EXT_REC.LOAN_EXT_ID from dual;
621: end if;
622:
623: insert into lns_loan_extensions(
624: LOAN_EXT_ID,
625: LOAN_ID,
626: DESCRIPTION,
627: OLD_TERM,

Line 700: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_loan_extensions...');

696: LNS_UTILITY_PUB.LAST_UPDATE_LOGIN);
697:
698: else
699:
700: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_loan_extensions...');
701:
702: update LNS_LOAN_EXTENSIONS set
703: DESCRIPTION = P_LOAN_EXT_REC.DESCRIPTION,
704: OLD_TERM = l_NEW_TERM_REC.OLD_TERM,

Line 702: update LNS_LOAN_EXTENSIONS set

698: else
699:
700: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_loan_extensions...');
701:
702: update LNS_LOAN_EXTENSIONS set
703: DESCRIPTION = P_LOAN_EXT_REC.DESCRIPTION,
704: OLD_TERM = l_NEW_TERM_REC.OLD_TERM,
705: OLD_TERM_PERIOD = l_NEW_TERM_REC.OLD_TERM_PERIOD,
706: OLD_BALLOON_TYPE = l_NEW_TERM_REC.OLD_BALLOON_TYPE,

Line 783: | lns_loan_headers_all from lns_loan_extensions table

Line 888: from lns_loan_extensions ext,

884: ext.EXT_INDEX_DATE,
885: loan.OBJECT_VERSION_NUMBER,
886: term.term_id,
887: nvl(loan.custom_payments_flag, 'N')
888: from lns_loan_extensions ext,
889: lns_loan_headers_all loan,
890: lns_terms term
891: where ext.LOAN_EXT_ID = P_LOAN_EXT_ID and
892: loan.LOAN_ID = ext.LOAN_ID and

Line 1123: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_LOAN_EXTENSIONS...');

1119: -- fix for bug 6724561
1120: l_last_billed_installment := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(l_LOAN_ID);
1121: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_last_billed_installment: ' || l_last_billed_installment);
1122:
1123: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_LOAN_EXTENSIONS...');
1124:
1125: update LNS_LOAN_EXTENSIONS
1126: set STATUS = 'APPROVED',
1127: APPR_REJECT_DATE = sysdate,

Line 1125: update LNS_LOAN_EXTENSIONS

1121: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_last_billed_installment: ' || l_last_billed_installment);
1122:
1123: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_LOAN_EXTENSIONS...');
1124:
1125: update LNS_LOAN_EXTENSIONS
1126: set STATUS = 'APPROVED',
1127: APPR_REJECT_DATE = sysdate,
1128: APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID,
1129: LAST_UPDATE_DATE = sysdate,

Line 1278: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_LOAN_EXTENSIONS...');

1274: -- START OF BODY OF API
1275:
1276: VALIDATE_EXTN(P_LOAN_EXT_ID, 'REJECT');
1277:
1278: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_LOAN_EXTENSIONS...');
1279:
1280: update LNS_LOAN_EXTENSIONS
1281: set STATUS = 'REJECTED',
1282: APPR_REJECT_DATE = sysdate,

Line 1280: update LNS_LOAN_EXTENSIONS

1276: VALIDATE_EXTN(P_LOAN_EXT_ID, 'REJECT');
1277:
1278: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_LOAN_EXTENSIONS...');
1279:
1280: update LNS_LOAN_EXTENSIONS
1281: set STATUS = 'REJECTED',
1282: APPR_REJECT_DATE = sysdate,
1283: APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID,
1284: LAST_UPDATE_DATE = sysdate,