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_PAYOFF_PUB

Line 1: PACKAGE BODY LNS_PAYOFF_PUB AS

1: PACKAGE BODY LNS_PAYOFF_PUB AS
2: /* $Header: LNS_PAYOFF_B.pls 120.10.12020000.3 2012/08/16 19:25:44 scherkas ship $ */
3:
4: --------------------------------------------
5: -- declaration of global variables and types

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'LNS_PAYOFF_PUB';

7: G_DEBUG_COUNT NUMBER := 0;
8: G_DEBUG BOOLEAN := FALSE;
9: G_FILE_NAME CONSTANT VARCHAR2(30) := 'LNS_PAYOFF_B.pls';
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'LNS_PAYOFF_PUB';
12:
13: --------------------------------------------
14: -- internal package routines
15: --------------------------------------------

Line 72: ,p_cash_receipt_ids in LNS_PAYOFF_PUB.CASH_RECEIPT_TBL

68: procedure processPayoff(p_api_version IN NUMBER
69: ,p_init_msg_list IN VARCHAR2
70: ,p_loan_id in number
71: ,p_payoff_date in date
72: ,p_cash_receipt_ids in LNS_PAYOFF_PUB.CASH_RECEIPT_TBL
73: ,x_return_status OUT NOCOPY VARCHAR2
74: ,x_msg_count OUT NOCOPY NUMBER
75: ,x_msg_data OUT NOCOPY VARCHAR2)
76: is

Line 84: l_invoices_tbl LNS_PAYOFF_PUB.INVOICE_DETAILS_TBL;

80: l_msg_count NUMBER;
81: l_msg_data VARCHAR2(32767);
82: l_payoff_tbl2 LNS_FINANCIALS.PAYOFF_TBL2;
83: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
84: l_invoices_tbl LNS_PAYOFF_PUB.INVOICE_DETAILS_TBL;
85: l_cash_receipt_ids LNS_PAYOFF_PUB.CASH_RECEIPT_TBL;
86: l_add_cash_receipt_ids LNS_PAYOFF_PUB.CASH_RECEIPT_TBL; -- for unapplied crs on last interest document only
87: l_bill_headers_tbl LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL; -- for invoice creation
88: l_bill_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL; -- for invoice creation

Line 85: l_cash_receipt_ids LNS_PAYOFF_PUB.CASH_RECEIPT_TBL;

81: l_msg_data VARCHAR2(32767);
82: l_payoff_tbl2 LNS_FINANCIALS.PAYOFF_TBL2;
83: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
84: l_invoices_tbl LNS_PAYOFF_PUB.INVOICE_DETAILS_TBL;
85: l_cash_receipt_ids LNS_PAYOFF_PUB.CASH_RECEIPT_TBL;
86: l_add_cash_receipt_ids LNS_PAYOFF_PUB.CASH_RECEIPT_TBL; -- for unapplied crs on last interest document only
87: l_bill_headers_tbl LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL; -- for invoice creation
88: l_bill_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL; -- for invoice creation
89: l_cm_line_tbl AR_CREDIT_MEMO_API_PUB.Cm_Line_Tbl_Type_Cover%type;

Line 86: l_add_cash_receipt_ids LNS_PAYOFF_PUB.CASH_RECEIPT_TBL; -- for unapplied crs on last interest document only

82: l_payoff_tbl2 LNS_FINANCIALS.PAYOFF_TBL2;
83: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
84: l_invoices_tbl LNS_PAYOFF_PUB.INVOICE_DETAILS_TBL;
85: l_cash_receipt_ids LNS_PAYOFF_PUB.CASH_RECEIPT_TBL;
86: l_add_cash_receipt_ids LNS_PAYOFF_PUB.CASH_RECEIPT_TBL; -- for unapplied crs on last interest document only
87: l_bill_headers_tbl LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL; -- for invoice creation
88: l_bill_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL; -- for invoice creation
89: l_cm_line_tbl AR_CREDIT_MEMO_API_PUB.Cm_Line_Tbl_Type_Cover%type;
90: l_total_payoff_amount number;

Line 497: lns_payoff_pub.getLoanInvoices(p_api_version => 1

493:
494: --3. getLoanInvoices (should return newly created documents)
495: -- pass payoff_date = null to avoid recalculating payoff amounts
496: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - getting loan invoices');
497: lns_payoff_pub.getLoanInvoices(p_api_version => 1
498: ,p_init_msg_list => p_init_msg_list
499: ,p_loan_ID => p_loan_id
500: ,p_payoff_date => null
501: ,x_invoices_tbl => l_invoices_tbl

Line 629: lns_payoff_pub.apply_receipt(p_cash_receipt_id => l_cash_receipt_ids(j).CASH_RECEIPT_ID

625: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - applying cash : ' || l_amount_to_apply);
626: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - applying cash from: ' || l_receipt_amount_from);
627: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - exchange rate: ' || l_trans_to_receipt_rate);
628:
629: lns_payoff_pub.apply_receipt(p_cash_receipt_id => l_cash_receipt_ids(j).CASH_RECEIPT_ID
630: ,p_payment_schedule_id => l_invoices_tbl(k).payment_schedule_id
631: ,p_apply_amount => l_amount_to_apply -- in loan currency
632: ,p_apply_date => p_payoff_date
633: ,p_apply_amount_from => l_receipt_amount_from -- in receipt currency

Line 752: ,x_invoices_tbl OUT NOCOPY LNS_PAYOFF_PUB.INVOICE_DETAILS_TBL

748: procedure getLoanInvoices(p_api_version IN NUMBER
749: ,p_init_msg_list IN VARCHAR2
750: ,p_loan_id in number
751: ,p_payoff_date in date
752: ,x_invoices_tbl OUT NOCOPY LNS_PAYOFF_PUB.INVOICE_DETAILS_TBL
753: ,x_return_status OUT NOCOPY VARCHAR2
754: ,x_msg_count OUT NOCOPY NUMBER
755: ,x_msg_data OUT NOCOPY VARCHAR2)
756:

Line 821: l_invoices_tbl LNS_PAYOFF_PUB.INVOICE_DETAILS_TBL;

817: l_return_status VARCHAR2(1);
818: l_msg_count NUMBER;
819: l_msg_data VARCHAR2(32767);
820:
821: l_invoices_tbl LNS_PAYOFF_PUB.INVOICE_DETAILS_TBL;
822: l_payoff_tbl2 LNS_FINANCIALS.PAYOFF_TBL2;
823: i number;
824: l_cust_trx_id number;
825: l_payment_schedule_id number;

Line 1407: ,x_invoices_tbl OUT NOCOPY LNS_PAYOFF_PUB.LOAN_CANCEL_DETAILS_TBL

1403: procedure getInvoicesForLoanCancellation(p_api_version IN NUMBER
1404: ,p_init_msg_list IN VARCHAR2
1405: ,p_loan_id IN NUMBER
1406: ,p_cancellation_date IN DATE
1407: ,x_invoices_tbl OUT NOCOPY LNS_PAYOFF_PUB.LOAN_CANCEL_DETAILS_TBL
1408: ,x_return_status OUT NOCOPY VARCHAR2
1409: ,x_msg_count OUT NOCOPY NUMBER
1410: ,x_msg_data OUT NOCOPY VARCHAR2)
1411: is

Line 1419: l_invoices_tbl LNS_PAYOFF_PUB.LOAN_CANCEL_DETAILS_TBL;

1415: l_return_status VARCHAR2(1);
1416: l_msg_count NUMBER;
1417: l_msg_data VARCHAR2(32767);
1418:
1419: l_invoices_tbl LNS_PAYOFF_PUB.LOAN_CANCEL_DETAILS_TBL;
1420: l_payoff_tbl2 LNS_FINANCIALS.PAYOFF_TBL2;
1421: i number;
1422: l_cust_trx_id number;
1423: l_payment_schedule_id number;

Line 1803: ,p_invoices_tbl IN LNS_PAYOFF_PUB.LOAN_CANCEL_DETAILS_TBL)

1799:
1800: procedure validateLoanCancelRequest(p_loan_id IN NUMBER
1801: ,p_cancellation_date IN DATE
1802: ,p_LOAN_CANCELLATION_ID IN NUMBER
1803: ,p_invoices_tbl IN LNS_PAYOFF_PUB.LOAN_CANCEL_DETAILS_TBL)
1804: is
1805:
1806: l_api_name varchar2(50);
1807: l_return_status VARCHAR2(1);

Line 2307: ,p_cancel_details_tbl IN OUT NOCOPY LNS_PAYOFF_PUB.LOAN_CANCEL_DETAILS_TBL

2303: ,p_cancellation_date IN DATE
2304: ,p_disable_billing IN VARCHAR2
2305: ,p_action IN VARCHAR2
2306: ,p_LOAN_CANCELLATION_ID IN OUT NOCOPY NUMBER
2307: ,p_cancel_details_tbl IN OUT NOCOPY LNS_PAYOFF_PUB.LOAN_CANCEL_DETAILS_TBL
2308: ,x_return_status OUT NOCOPY VARCHAR2
2309: ,x_msg_count OUT NOCOPY NUMBER
2310: ,x_msg_data OUT NOCOPY VARCHAR2)
2311: is

Line 2648: l_invoices_tbl LNS_PAYOFF_PUB.LOAN_CANCEL_DETAILS_TBL;

2644:
2645: l_bill_headers_tbl LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL; -- for invoice creation
2646: l_bill_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL; -- for invoice creation
2647: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type; -- to update the loan header
2648: l_invoices_tbl LNS_PAYOFF_PUB.LOAN_CANCEL_DETAILS_TBL;
2649: l_reverse_tbl LNS_BILLING_BATCH_PUB.REVERSE_TBL;
2650: l_cm_line_tbl AR_CREDIT_MEMO_API_PUB.Cm_Line_Tbl_Type_Cover%type;
2651:
2652: -- query loan info

Line 3902: END LNS_PAYOFF_PUB;

3898: end;
3899:
3900:
3901:
3902: END LNS_PAYOFF_PUB;