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_CANCEL_DETAILS

Line 2104: from LNS_LOAN_CANCEL_DETAILS

2100: CURSOR cancel_details_cur(P_LOAN_CANCELLATION_ID number) IS
2101: select PURPOSE_CODE
2102: ,BILLED_FLAG
2103: ,AMOUNT_TO_PROCESS
2104: from LNS_LOAN_CANCEL_DETAILS
2105: where LOAN_CANCELLATION_ID = P_LOAN_CANCELLATION_ID;
2106:
2107: begin
2108:

Line 2463: select LNS_LOAN_CANCEL_DETAILS_S.NEXTVAL into l_LOAN_CANCEL_DETAIL_ID from dual;

2459: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ACTION = ' || p_cancel_details_tbl(i).ACTION);
2460:
2461: if p_action = 'INSERT' then
2462: if p_cancel_details_tbl(i).LOAN_CANCEL_DETAIL_ID is null then
2463: select LNS_LOAN_CANCEL_DETAILS_S.NEXTVAL into l_LOAN_CANCEL_DETAIL_ID from dual;
2464: p_cancel_details_tbl(i).LOAN_CANCEL_DETAIL_ID := l_LOAN_CANCEL_DETAIL_ID;
2465: end if;
2466:
2467: p_cancel_details_tbl(i).REMAINING_AMOUNT := round(p_cancel_details_tbl(i).REMAINING_AMOUNT, l_precision);

Line 2469: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Inserting into LNS_LOAN_CANCEL_DETAILS...');

2465: end if;
2466:
2467: p_cancel_details_tbl(i).REMAINING_AMOUNT := round(p_cancel_details_tbl(i).REMAINING_AMOUNT, l_precision);
2468: p_cancel_details_tbl(i).AMOUNT_TO_PROCESS := round(p_cancel_details_tbl(i).AMOUNT_TO_PROCESS, l_precision);
2469: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Inserting into LNS_LOAN_CANCEL_DETAILS...');
2470: insert into LNS_LOAN_CANCEL_DETAILS
2471: (LOAN_CANCEL_DETAIL_ID
2472: ,LOAN_CANCELLATION_ID
2473: ,LOAN_ID

Line 2470: insert into LNS_LOAN_CANCEL_DETAILS

2466:
2467: p_cancel_details_tbl(i).REMAINING_AMOUNT := round(p_cancel_details_tbl(i).REMAINING_AMOUNT, l_precision);
2468: p_cancel_details_tbl(i).AMOUNT_TO_PROCESS := round(p_cancel_details_tbl(i).AMOUNT_TO_PROCESS, l_precision);
2469: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Inserting into LNS_LOAN_CANCEL_DETAILS...');
2470: insert into LNS_LOAN_CANCEL_DETAILS
2471: (LOAN_CANCEL_DETAIL_ID
2472: ,LOAN_CANCELLATION_ID
2473: ,LOAN_ID
2474: ,INVOICE_NUMBER

Line 2528: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating into LNS_LOAN_CANCEL_DETAILS...');

2524: ,lns_utility_pub.last_updated_by
2525: ,lns_utility_pub.LAST_UPDATE_LOGIN);
2526: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
2527: else
2528: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating into LNS_LOAN_CANCEL_DETAILS...');
2529: update LNS_LOAN_CANCEL_DETAILS set
2530: PERCENT_TO_PROCESS = p_cancel_details_tbl(i).PERCENT_TO_PROCESS
2531: ,AMOUNT_TO_PROCESS = p_cancel_details_tbl(i).AMOUNT_TO_PROCESS
2532: ,ACTION = p_cancel_details_tbl(i).ACTION

Line 2529: update LNS_LOAN_CANCEL_DETAILS set

2525: ,lns_utility_pub.LAST_UPDATE_LOGIN);
2526: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
2527: else
2528: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating into LNS_LOAN_CANCEL_DETAILS...');
2529: update LNS_LOAN_CANCEL_DETAILS set
2530: PERCENT_TO_PROCESS = p_cancel_details_tbl(i).PERCENT_TO_PROCESS
2531: ,AMOUNT_TO_PROCESS = p_cancel_details_tbl(i).AMOUNT_TO_PROCESS
2532: ,ACTION = p_cancel_details_tbl(i).ACTION
2533: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1

Line 2682: from LNS_LOAN_CANCEL_DETAILS

2678: ,ACTION
2679: ,LOAN_LINE_ID
2680: ,PAYMENT_SCHEDULE_ID
2681: ,CUST_TRX_ID
2682: from LNS_LOAN_CANCEL_DETAILS
2683: where LOAN_CANCELLATION_ID = P_LOAN_CANCELLATION_ID;
2684:
2685: CURSOR loan_version_cur(P_LOAN_ID number) IS
2686: select OBJECT_VERSION_NUMBER

Line 2902: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCEL_DETAILS...');

2898: if l_adj_id is null and l_adj_number is null then
2899: RAISE FND_API.G_EXC_ERROR;
2900: end if;
2901:
2902: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCEL_DETAILS...');
2903: update LNS_LOAN_CANCEL_DETAILS set
2904: ADJUSTMENT_NUMBER = l_adj_number
2905: ,ADJUSTMENT_ID = l_adj_id
2906: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1

Line 2903: update LNS_LOAN_CANCEL_DETAILS set

2899: RAISE FND_API.G_EXC_ERROR;
2900: end if;
2901:
2902: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCEL_DETAILS...');
2903: update LNS_LOAN_CANCEL_DETAILS set
2904: ADJUSTMENT_NUMBER = l_adj_number
2905: ,ADJUSTMENT_ID = l_adj_id
2906: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
2907: ,LAST_UPDATE_DATE = sysdate

Line 3000: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCEL_DETAILS...');

2996: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'PAYMENT_SCHEDULE_ID = ' || l_invoices_tbl(i).PAYMENT_SCHEDULE_ID);
2997: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || l_invoices_tbl(i).TRX_DATE);
2998: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || l_invoices_tbl(i).GL_DATE);
2999:
3000: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCEL_DETAILS...');
3001: update LNS_LOAN_CANCEL_DETAILS set
3002: CUST_TRX_ID = l_invoices_tbl(i).CUST_TRX_ID
3003: ,PAYMENT_SCHEDULE_ID = l_invoices_tbl(i).PAYMENT_SCHEDULE_ID
3004: ,TRX_DATE = l_invoices_tbl(i).TRX_DATE

Line 3001: update LNS_LOAN_CANCEL_DETAILS set

2997: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'TRX_DATE = ' || l_invoices_tbl(i).TRX_DATE);
2998: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'GL_DATE = ' || l_invoices_tbl(i).GL_DATE);
2999:
3000: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCEL_DETAILS...');
3001: update LNS_LOAN_CANCEL_DETAILS set
3002: CUST_TRX_ID = l_invoices_tbl(i).CUST_TRX_ID
3003: ,PAYMENT_SCHEDULE_ID = l_invoices_tbl(i).PAYMENT_SCHEDULE_ID
3004: ,TRX_DATE = l_invoices_tbl(i).TRX_DATE
3005: ,GL_DATE = l_invoices_tbl(i).GL_DATE