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_UTILITY_PUB

Line 768: ,lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', decode(ps.customer_trx_id, principal_trx_Id, 'PRIN', interest_trx_id, 'INT', fee_trx_id, 'FEE')) line_type

764: ,trx_number
765: ,tty.name
766: ,amount_due_remaining
767: ,am.due_date
768: ,lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', decode(ps.customer_trx_id, principal_trx_Id, 'PRIN', interest_trx_id, 'INT', fee_trx_id, 'FEE')) line_type
769: ,ps.TRX_DATE
770: ,ps.GL_DATE
771: from lns_amortization_scheds am
772: ,ar_payment_schedules ps

Line 970: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName(l_payoff_tbl2(k).PAYOFF_PURPOSE);

966: i := i + 1;
967: l_invoices_tbl(i).CUST_TRX_ID := null;
968: l_invoices_tbl(i).INSTALLMENT_NUMBER := l_installment;
969: l_invoices_tbl(i).INVOICE_NUMBER := l_invoice_number;
970: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName(l_payoff_tbl2(k).PAYOFF_PURPOSE);
971: l_invoices_tbl(i).REMAINING_AMOUNT := l_payoff_tbl2(k).unbilled_amount;
972: l_invoices_tbl(i).DUE_DATE := p_payoff_date;
973: l_invoices_tbl(i).TRX_DATE := l_trx_date;
974: l_invoices_tbl(i).GL_DATE := l_gl_date;

Line 975: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', l_payoff_tbl2(k).PAYOFF_PURPOSE);

971: l_invoices_tbl(i).REMAINING_AMOUNT := l_payoff_tbl2(k).unbilled_amount;
972: l_invoices_tbl(i).DUE_DATE := p_payoff_date;
973: l_invoices_tbl(i).TRX_DATE := l_trx_date;
974: l_invoices_tbl(i).GL_DATE := l_gl_date;
975: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', l_payoff_tbl2(k).PAYOFF_PURPOSE);
976: l_invoices_tbl(i).BILLED_FLAG := 'N';
977: /*
978: elsif l_payoff_tbl2(k).unbilled_amount < 0 and l_payoff_tbl2(k).PAYOFF_PURPOSE = 'INT' then
979:

Line 1001: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', l_payoff_tbl2(k).PAYOFF_PURPOSE);

997: l_invoices_tbl(i).INVOICE_NUMBER := l_invoice_number;
998: l_invoices_tbl(i).DUE_DATE := p_payoff_date;
999: l_invoices_tbl(i).TRANSACTION_TYPE := l_credit_name;
1000: l_invoices_tbl(i).REMAINING_AMOUNT := - l_last_interest;
1001: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', l_payoff_tbl2(k).PAYOFF_PURPOSE);
1002: l_invoices_tbl(i).BILLED_FLAG := 'N';
1003:
1004: if l_last_interest + l_payoff_tbl2(k).unbilled_amount > 0 then
1005: -- new interest document

Line 1011: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName(l_payoff_tbl2(k).PAYOFF_PURPOSE);

1007: l_invoices_tbl(i).CUST_TRX_ID := null;
1008: l_invoices_tbl(i).INSTALLMENT_NUMBER := l_installment;
1009: l_invoices_tbl(i).INVOICE_NUMBER := l_invoice_number;
1010: l_invoices_tbl(i).DUE_DATE := p_payoff_date;
1011: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName(l_payoff_tbl2(k).PAYOFF_PURPOSE);
1012: l_invoices_tbl(i).REMAINING_AMOUNT := l_last_interest + l_payoff_tbl2(k).unbilled_amount;
1013: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', l_payoff_tbl2(k).PAYOFF_PURPOSE);
1014: l_invoices_tbl(i).BILLED_FLAG := 'N';
1015: end if;

Line 1013: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', l_payoff_tbl2(k).PAYOFF_PURPOSE);

1009: l_invoices_tbl(i).INVOICE_NUMBER := l_invoice_number;
1010: l_invoices_tbl(i).DUE_DATE := p_payoff_date;
1011: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName(l_payoff_tbl2(k).PAYOFF_PURPOSE);
1012: l_invoices_tbl(i).REMAINING_AMOUNT := l_last_interest + l_payoff_tbl2(k).unbilled_amount;
1013: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', l_payoff_tbl2(k).PAYOFF_PURPOSE);
1014: l_invoices_tbl(i).BILLED_FLAG := 'N';
1015: end if;
1016: */
1017: end if;

Line 1036: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName('FEE');

1032: l_invoices_tbl(i).INVOICE_NUMBER := l_invoice_number;
1033: l_invoices_tbl(i).DUE_DATE := p_payoff_date;
1034: l_invoices_tbl(i).TRX_DATE := l_trx_date;
1035: l_invoices_tbl(i).GL_DATE := l_gl_date;
1036: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName('FEE');
1037: l_invoices_tbl(i).REMAINING_AMOUNT := l_fee_amount;
1038: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', 'FEE') || ' - ' || l_fee_name;
1039: l_invoices_tbl(i).BILLED_FLAG := 'N';
1040: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - fee found');

Line 1038: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', 'FEE') || ' - ' || l_fee_name;

1034: l_invoices_tbl(i).TRX_DATE := l_trx_date;
1035: l_invoices_tbl(i).GL_DATE := l_gl_date;
1036: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName('FEE');
1037: l_invoices_tbl(i).REMAINING_AMOUNT := l_fee_amount;
1038: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', 'FEE') || ' - ' || l_fee_name;
1039: l_invoices_tbl(i).BILLED_FLAG := 'N';
1040: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - fee found');
1041: end loop;
1042: close c_fees;

Line 1509: ,lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', decode(ps.customer_trx_id, principal_trx_Id, 'PRIN', interest_trx_id, 'INT', fee_trx_id, 'FEE')) line_type

1505: ,trx_number
1506: ,tty.name
1507: ,amount_due_remaining
1508: ,decode(ps.customer_trx_id, principal_trx_Id, 'PRIN', interest_trx_id, 'INT', fee_trx_id, 'FEE')
1509: ,lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', decode(ps.customer_trx_id, principal_trx_Id, 'PRIN', interest_trx_id, 'INT', fee_trx_id, 'FEE')) line_type
1510: ,ps.due_date
1511: ,ps.TRX_DATE
1512: ,ps.GL_DATE
1513: from lns_amortization_scheds am

Line 1676: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', 'PRIN');

1672: l_invoices_tbl(i).DUE_DATE := p_cancellation_date;
1673: l_invoices_tbl(i).TRX_DATE := p_cancellation_date;
1674: l_invoices_tbl(i).GL_DATE := p_cancellation_date;
1675: l_invoices_tbl(i).PURPOSE_CODE := 'PRIN';
1676: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', 'PRIN');
1677: l_invoices_tbl(i).LOAN_LINE_ID := l_loan_line_id;
1678: l_invoices_tbl(i).AMOUNT_TO_PROCESS := round(l_remaining_prin * (l_remaining_amt/l_funded_amount), l_precision);
1679: l_invoices_tbl(i).PERCENT_TO_PROCESS := round(l_remaining_amt*100/l_funded_amount, 4);
1680: l_invoices_tbl(i).BILLED_FLAG := 'N';

Line 1700: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName(l_payoff_tbl2(k).PAYOFF_PURPOSE);

1696: i := i + 1;
1697: l_invoices_tbl(i).CUST_TRX_ID := null;
1698: l_invoices_tbl(i).INSTALLMENT_NUMBER := l_installment;
1699: l_invoices_tbl(i).INVOICE_NUMBER := l_invoice_number;
1700: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName(l_payoff_tbl2(k).PAYOFF_PURPOSE);
1701: l_invoices_tbl(i).REMAINING_AMOUNT := l_payoff_tbl2(k).unbilled_amount;
1702: l_invoices_tbl(i).DUE_DATE := p_cancellation_date;
1703: l_invoices_tbl(i).TRX_DATE := l_trx_date;
1704: l_invoices_tbl(i).GL_DATE := l_gl_date;

Line 1706: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', l_payoff_tbl2(k).PAYOFF_PURPOSE);

1702: l_invoices_tbl(i).DUE_DATE := p_cancellation_date;
1703: l_invoices_tbl(i).TRX_DATE := l_trx_date;
1704: l_invoices_tbl(i).GL_DATE := l_gl_date;
1705: l_invoices_tbl(i).PURPOSE_CODE := l_payoff_tbl2(k).PAYOFF_PURPOSE;
1706: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', l_payoff_tbl2(k).PAYOFF_PURPOSE);
1707: l_invoices_tbl(i).PERCENT_TO_PROCESS := 100 - l_sum_percent;
1708: l_invoices_tbl(i).AMOUNT_TO_PROCESS := round((l_payoff_tbl2(k).unbilled_amount-l_sum_amount), l_precision);
1709: l_invoices_tbl(i).BILLED_FLAG := 'N';
1710: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Adding ' || l_invoices_tbl(i).PURPOSE ||

Line 1730: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName('FEE');

1726: l_invoices_tbl(i).INVOICE_NUMBER := l_invoice_number;
1727: l_invoices_tbl(i).DUE_DATE := p_cancellation_date;
1728: l_invoices_tbl(i).TRX_DATE := l_trx_date;
1729: l_invoices_tbl(i).GL_DATE := l_gl_date;
1730: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName('FEE');
1731: l_invoices_tbl(i).REMAINING_AMOUNT := l_fee_amount;
1732: l_invoices_tbl(i).PURPOSE_CODE := 'FEE';
1733: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', 'FEE') || ' - ' || l_fee_name;
1734: l_invoices_tbl(i).PERCENT_TO_PROCESS := 100;

Line 1733: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', 'FEE') || ' - ' || l_fee_name;

1729: l_invoices_tbl(i).GL_DATE := l_gl_date;
1730: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName('FEE');
1731: l_invoices_tbl(i).REMAINING_AMOUNT := l_fee_amount;
1732: l_invoices_tbl(i).PURPOSE_CODE := 'FEE';
1733: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', 'FEE') || ' - ' || l_fee_name;
1734: l_invoices_tbl(i).PERCENT_TO_PROCESS := 100;
1735: l_invoices_tbl(i).AMOUNT_TO_PROCESS := round(l_fee_amount, l_precision);
1736: l_invoices_tbl(i).BILLED_FLAG := 'N';
1737: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Adding ' || l_invoices_tbl(i).PURPOSE ||

Line 2422: ,lns_utility_pub.created_by

2418: ,null
2419: ,null
2420: ,1
2421: ,sysdate
2422: ,lns_utility_pub.created_by
2423: ,sysdate
2424: ,lns_utility_pub.last_updated_by
2425: ,lns_utility_pub.LAST_UPDATE_LOGIN);
2426: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');

Line 2424: ,lns_utility_pub.last_updated_by

2420: ,1
2421: ,sysdate
2422: ,lns_utility_pub.created_by
2423: ,sysdate
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...');

Line 2425: ,lns_utility_pub.LAST_UPDATE_LOGIN);

2421: ,sysdate
2422: ,lns_utility_pub.created_by
2423: ,sysdate
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

Line 2433: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

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
2434: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
2435: where LOAN_CANCELLATION_ID = p_LOAN_CANCELLATION_ID;
2436: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
2437: end if;

Line 2434: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

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
2434: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
2435: where LOAN_CANCELLATION_ID = p_LOAN_CANCELLATION_ID;
2436: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
2437: end if;
2438:

Line 2522: ,lns_utility_pub.created_by

2518: ,null
2519: ,null
2520: ,1
2521: ,sysdate
2522: ,lns_utility_pub.created_by
2523: ,sysdate
2524: ,lns_utility_pub.last_updated_by
2525: ,lns_utility_pub.LAST_UPDATE_LOGIN);
2526: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');

Line 2524: ,lns_utility_pub.last_updated_by

2520: ,1
2521: ,sysdate
2522: ,lns_utility_pub.created_by
2523: ,sysdate
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...');

Line 2525: ,lns_utility_pub.LAST_UPDATE_LOGIN);

2521: ,sysdate
2522: ,lns_utility_pub.created_by
2523: ,sysdate
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

Line 2535: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

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
2534: ,LAST_UPDATE_DATE = sysdate
2535: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
2536: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
2537: where LOAN_CANCEL_DETAIL_ID = p_cancel_details_tbl(i).LOAN_CANCEL_DETAIL_ID;
2538: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
2539: end if;

Line 2536: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

2532: ,ACTION = p_cancel_details_tbl(i).ACTION
2533: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
2534: ,LAST_UPDATE_DATE = sysdate
2535: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
2536: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
2537: where LOAN_CANCEL_DETAIL_ID = p_cancel_details_tbl(i).LOAN_CANCEL_DETAIL_ID;
2538: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
2539: end if;
2540:

Line 2785: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

2781: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Rejecting all remaining pending orig receivables...');
2782: update LNS_LOAN_LINES set
2783: STATUS = 'REJECTED'
2784: ,LAST_UPDATE_DATE = sysdate
2785: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
2786: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
2787: ,APPR_REJECT_DATE = sysdate
2788: ,APPR_REJECT_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
2789: where LOAN_ID = l_loan_id and

Line 2786: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

2782: update LNS_LOAN_LINES set
2783: STATUS = 'REJECTED'
2784: ,LAST_UPDATE_DATE = sysdate
2785: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
2786: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
2787: ,APPR_REJECT_DATE = sysdate
2788: ,APPR_REJECT_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
2789: where LOAN_ID = l_loan_id and
2790: (STATUS is null or STATUS = 'PENDING');

Line 2788: ,APPR_REJECT_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

2784: ,LAST_UPDATE_DATE = sysdate
2785: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
2786: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
2787: ,APPR_REJECT_DATE = sysdate
2788: ,APPR_REJECT_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
2789: where LOAN_ID = l_loan_id and
2790: (STATUS is null or STATUS = 'PENDING');
2791: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
2792: end if;

Line 2908: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

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
2908: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
2909: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
2910: where LOAN_CANCEL_DETAIL_ID = l_invoices_tbl(i).LOAN_CANCEL_DETAIL_ID;
2911: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
2912:

Line 2909: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

2905: ,ADJUSTMENT_ID = l_adj_id
2906: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
2907: ,LAST_UPDATE_DATE = sysdate
2908: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
2909: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
2910: where LOAN_CANCEL_DETAIL_ID = l_invoices_tbl(i).LOAN_CANCEL_DETAIL_ID;
2911: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
2912:
2913: end if;

Line 3008: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

3004: ,TRX_DATE = l_invoices_tbl(i).TRX_DATE
3005: ,GL_DATE = l_invoices_tbl(i).GL_DATE
3006: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
3007: ,LAST_UPDATE_DATE = sysdate
3008: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
3009: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
3010: where LOAN_CANCEL_DETAIL_ID = l_invoices_tbl(i).LOAN_CANCEL_DETAIL_ID;
3011: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
3012:

Line 3009: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

3005: ,GL_DATE = l_invoices_tbl(i).GL_DATE
3006: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
3007: ,LAST_UPDATE_DATE = sysdate
3008: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
3009: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
3010: where LOAN_CANCEL_DETAIL_ID = l_invoices_tbl(i).LOAN_CANCEL_DETAIL_ID;
3011: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
3012:
3013: exit;

Line 3100: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID

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
3102: ,LAST_UPDATE_DATE = sysdate
3103: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
3104: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

Line 3103: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

3099: ,APPR_REJECT_DATE = sysdate
3100: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID
3101: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
3102: ,LAST_UPDATE_DATE = sysdate
3103: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
3104: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
3105: where LOAN_CANCELLATION_ID = p_LOAN_CANCELLATION_ID;
3106: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
3107:

Line 3104: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

3100: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID
3101: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
3102: ,LAST_UPDATE_DATE = sysdate
3103: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
3104: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
3105: where LOAN_CANCELLATION_ID = p_LOAN_CANCELLATION_ID;
3106: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
3107:
3108: open loan_version_cur(l_loan_id);

Line 3229: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID

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
3231: ,LAST_UPDATE_DATE = sysdate
3232: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
3233: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

Line 3232: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

3228: ,APPR_REJECT_DATE = sysdate
3229: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID
3230: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
3231: ,LAST_UPDATE_DATE = sysdate
3232: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
3233: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
3234: where LOAN_CANCELLATION_ID = p_LOAN_CANCELLATION_ID;
3235: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
3236:

Line 3233: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

3229: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID
3230: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
3231: ,LAST_UPDATE_DATE = sysdate
3232: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
3233: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
3234: where LOAN_CANCELLATION_ID = p_LOAN_CANCELLATION_ID;
3235: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
3236:
3237: open loan_version_cur(p_LOAN_CANCELLATION_ID);

Line 3771: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID

3767: ,NEW_LOAN_ID = l_new_loan_id
3768: ,LOAN_NUMBER = l_LOAN_NUMBER
3769: ,STATUS = 'APPROVED'
3770: ,APPR_REJECT_DATE = sysdate
3771: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID
3772: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
3773: ,LAST_UPDATE_DATE = sysdate
3774: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
3775: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

Line 3774: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

3770: ,APPR_REJECT_DATE = sysdate
3771: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID
3772: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
3773: ,LAST_UPDATE_DATE = sysdate
3774: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
3775: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
3776: where LOAN_SPLIT_ID = p_LOAN_SPLIT_ID;
3777: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
3778:

Line 3775: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

3771: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID
3772: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
3773: ,LAST_UPDATE_DATE = sysdate
3774: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
3775: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
3776: where LOAN_SPLIT_ID = p_LOAN_SPLIT_ID;
3777: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
3778:
3779: -- fix for bug 14491711

Line 3871: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID

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
3872: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
3873: ,LAST_UPDATE_DATE = sysdate
3874: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
3875: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

Line 3874: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

3870: ,APPR_REJECT_DATE = sysdate
3871: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID
3872: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
3873: ,LAST_UPDATE_DATE = sysdate
3874: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
3875: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
3876: where LOAN_SPLIT_ID = p_LOAN_SPLIT_ID;
3877: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
3878:

Line 3875: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

3871: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID
3872: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
3873: ,LAST_UPDATE_DATE = sysdate
3874: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
3875: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
3876: where LOAN_SPLIT_ID = p_LOAN_SPLIT_ID;
3877: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
3878:
3879: -- --------------------------------------------------------------------