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_S

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 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 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 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