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_PAYOFF_PUB dependencies on LNS_LOAN_CANCELLATIONS

Line 1837: from LNS_LOAN_CANCELLATIONS

1833: l_payoff_tbl2 LNS_FINANCIALS.PAYOFF_TBL2;
1834:
1835: CURSOR pending_count_cur(P_LOAN_ID number) IS
1836: select count(1)
1837: from LNS_LOAN_CANCELLATIONS
1838: where loan_id = P_LOAN_ID and
1839: STATUS = 'PENDING';
1840:
1841: CURSOR cancel_request_cur(P_LOAN_CANCELLATION_ID number) IS

Line 1843: from LNS_LOAN_CANCELLATIONS

1839: STATUS = 'PENDING';
1840:
1841: CURSOR cancel_request_cur(P_LOAN_CANCELLATION_ID number) IS
1842: select STATUS, CANCELLATION_DATE
1843: from LNS_LOAN_CANCELLATIONS
1844: where LOAN_CANCELLATION_ID = P_LOAN_CANCELLATION_ID;
1845:
1846: CURSOR loan_details_cur(P_LOAN_ID number) IS
1847: select LOAN_STATUS

Line 2097: from LNS_LOAN_CANCELLATIONS

2093: CURSOR cancel_request_cur(P_LOAN_CANCELLATION_ID number) IS
2094: select LOAN_ID,
2095: STATUS,
2096: CANCELLATION_DATE
2097: from LNS_LOAN_CANCELLATIONS
2098: where LOAN_CANCELLATION_ID = P_LOAN_CANCELLATION_ID;
2099:
2100: CURSOR cancel_details_cur(P_LOAN_CANCELLATION_ID number) IS
2101: select PURPOSE_CODE

Line 2394: select LNS_LOAN_CANCELLATIONS_S.NEXTVAL into p_LOAN_CANCELLATION_ID from dual;

2390: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_description = ' || l_description);
2391:
2392: if p_action = 'INSERT' then
2393: if p_LOAN_CANCELLATION_ID is null then
2394: select LNS_LOAN_CANCELLATIONS_S.NEXTVAL into p_LOAN_CANCELLATION_ID from dual;
2395: end if;
2396:
2397: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Inserting into LNS_LOAN_CANCELLATIONS...');
2398: insert into LNS_LOAN_CANCELLATIONS

Line 2397: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Inserting into LNS_LOAN_CANCELLATIONS...');

2393: if p_LOAN_CANCELLATION_ID is null then
2394: select LNS_LOAN_CANCELLATIONS_S.NEXTVAL into p_LOAN_CANCELLATION_ID from dual;
2395: end if;
2396:
2397: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Inserting into LNS_LOAN_CANCELLATIONS...');
2398: insert into LNS_LOAN_CANCELLATIONS
2399: (LOAN_CANCELLATION_ID
2400: ,LOAN_ID
2401: ,DESCRIPTION

Line 2398: insert into LNS_LOAN_CANCELLATIONS

2394: select LNS_LOAN_CANCELLATIONS_S.NEXTVAL into p_LOAN_CANCELLATION_ID from dual;
2395: end if;
2396:
2397: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Inserting into LNS_LOAN_CANCELLATIONS...');
2398: insert into LNS_LOAN_CANCELLATIONS
2399: (LOAN_CANCELLATION_ID
2400: ,LOAN_ID
2401: ,DESCRIPTION
2402: ,STATUS

Line 2428: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating into LNS_LOAN_CANCELLATIONS...');

2424: ,lns_utility_pub.last_updated_by
2425: ,lns_utility_pub.LAST_UPDATE_LOGIN);
2426: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
2427: else
2428: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating into LNS_LOAN_CANCELLATIONS...');
2429: update LNS_LOAN_CANCELLATIONS set
2430: DESCRIPTION = l_description
2431: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
2432: ,LAST_UPDATE_DATE = sysdate

Line 2429: update LNS_LOAN_CANCELLATIONS set

2425: ,lns_utility_pub.LAST_UPDATE_LOGIN);
2426: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
2427: else
2428: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating into LNS_LOAN_CANCELLATIONS...');
2429: update LNS_LOAN_CANCELLATIONS set
2430: DESCRIPTION = l_description
2431: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
2432: ,LAST_UPDATE_DATE = sysdate
2433: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

Line 2662: LNS_LOAN_CANCELLATIONS cncl

2658: loan.LOAN_CLASS_CODE,
2659: nvl(loan.DISABLE_BILLING_FLAG, 'N')
2660: from lns_loan_headers loan,
2661: LNS_SYSTEM_OPTIONS sys,
2662: LNS_LOAN_CANCELLATIONS cncl
2663: where cncl.LOAN_CANCELLATION_ID = P_LOAN_CANCELLATION_ID and
2664: cncl.LOAN_ID = loan.LOAN_ID and
2665: loan.org_id = sys.org_id;
2666:

Line 3096: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCELLATIONS...');

3092:
3093: end loop;
3094:
3095: -- update cancellation record
3096: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCELLATIONS...');
3097: update LNS_LOAN_CANCELLATIONS set
3098: STATUS = 'APPROVED'
3099: ,APPR_REJECT_DATE = sysdate
3100: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID

Line 3097: update LNS_LOAN_CANCELLATIONS set

3093: end loop;
3094:
3095: -- update cancellation record
3096: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCELLATIONS...');
3097: update LNS_LOAN_CANCELLATIONS set
3098: STATUS = 'APPROVED'
3099: ,APPR_REJECT_DATE = sysdate
3100: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID
3101: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1

Line 3186: from LNS_LOAN_HEADERS loan, LNS_LOAN_CANCELLATIONS cncl

3182: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type; -- to update the loan header
3183:
3184: CURSOR loan_version_cur(p_LOAN_CANCELLATION_ID number) IS
3185: select loan.LOAN_ID, loan.OBJECT_VERSION_NUMBER
3186: from LNS_LOAN_HEADERS loan, LNS_LOAN_CANCELLATIONS cncl
3187: where cncl.LOAN_CANCELLATION_ID = p_LOAN_CANCELLATION_ID and
3188: cncl.LOAN_ID = loan.LOAN_ID;
3189:
3190: begin

Line 3225: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCELLATIONS...');

3221: validateLoanCancelRequest(P_LOAN_CANCELLATION_ID => p_LOAN_CANCELLATION_ID
3222: ,p_action => 'REJECT');
3223:
3224: -- update cancellation record
3225: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCELLATIONS...');
3226: update LNS_LOAN_CANCELLATIONS set
3227: STATUS = 'REJECTED'
3228: ,APPR_REJECT_DATE = sysdate
3229: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID

Line 3226: update LNS_LOAN_CANCELLATIONS set

3222: ,p_action => 'REJECT');
3223:
3224: -- update cancellation record
3225: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCELLATIONS...');
3226: update LNS_LOAN_CANCELLATIONS set
3227: STATUS = 'REJECTED'
3228: ,APPR_REJECT_DATE = sysdate
3229: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID
3230: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1

Line 3764: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCELLATIONS...');

3760:
3761: end if;
3762:
3763: -- update split record
3764: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCELLATIONS...');
3765: update LNS_LOAN_SPLITS set
3766: NEW_AM_SCHED_ID = l_new_am_sched_id
3767: ,NEW_LOAN_ID = l_new_loan_id
3768: ,LOAN_NUMBER = l_LOAN_NUMBER

Line 3867: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCELLATIONS...');

3863: --validateLoanCancelRequest(P_LOAN_CANCELLATION_ID => p_LOAN_CANCELLATION_ID
3864: -- ,p_action => 'REJECT');
3865:
3866: -- update split record
3867: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCELLATIONS...');
3868: update LNS_LOAN_SPLITS set
3869: STATUS = 'REJECTED'
3870: ,APPR_REJECT_DATE = sysdate
3871: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID