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 603: lns_loan_extensions

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

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

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

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

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

Line 622: insert into lns_loan_extensions(

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

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

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

Line 699: update LNS_LOAN_EXTENSIONS set

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

Line 779: | lns_loan_headers_all from lns_loan_extensions table

Line 888: from lns_loan_extensions ext,

884: nvl(loan.custom_payments_flag, 'N'),
885: ext.DESCRIPTION,
886: ext.EXT_TERM,
887: ext.EXT_TERM_PERIOD
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 1121: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_LOAN_EXTENSIONS...');

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

Line 1123: update LNS_LOAN_EXTENSIONS

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

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

1266: -- START OF BODY OF API
1267:
1268: VALIDATE_EXTN(P_LOAN_EXT_ID, 'REJECT');
1269:
1270: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_LOAN_EXTENSIONS...');
1271:
1272: update LNS_LOAN_EXTENSIONS
1273: set STATUS = 'REJECTED',
1274: APPR_REJECT_DATE = sysdate,

Line 1272: update LNS_LOAN_EXTENSIONS

1268: VALIDATE_EXTN(P_LOAN_EXT_ID, 'REJECT');
1269:
1270: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_LOAN_EXTENSIONS...');
1271:
1272: update LNS_LOAN_EXTENSIONS
1273: set STATUS = 'REJECTED',
1274: APPR_REJECT_DATE = sysdate,
1275: APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID,
1276: LAST_UPDATE_DATE = sysdate,