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.5.12010000.2 2008/12/22 10:45:41 gparuchu 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 511: lns_payoff_pub.getLoanInvoices(p_api_version => 1

507:
508: --3. getLoanInvoices (should return newly created documents)
509: -- pass payoff_date = null to avoid recalculating payoff amounts
510: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - getting loan invoices');
511: lns_payoff_pub.getLoanInvoices(p_api_version => 1
512: ,p_init_msg_list => p_init_msg_list
513: ,p_loan_ID => p_loan_id
514: ,p_payoff_date => null
515: ,x_invoices_tbl => l_invoices_tbl

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

642: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - applying cash : ' || l_amount_to_apply);
643: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - applying cash from: ' || l_receipt_amount_from);
644: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - exchange rate: ' || l_trans_to_receipt_rate);
645:
646: lns_payoff_pub.apply_receipt(p_cash_receipt_id => l_cash_receipt_ids(j).CASH_RECEIPT_ID
647: ,p_payment_schedule_id => l_invoices_tbl(k).payment_schedule_id
648: ,p_apply_amount => l_amount_to_apply -- in loan currency
649: ,p_apply_date => p_payoff_date
650: ,p_apply_amount_from => l_receipt_amount_from -- in receipt currency

Line 842: ,x_invoices_tbl OUT NOCOPY LNS_PAYOFF_PUB.INVOICE_DETAILS_TBL

838: procedure getLoanInvoices(p_api_version IN NUMBER
839: ,p_init_msg_list IN VARCHAR2
840: ,p_loan_id in number
841: ,p_payoff_date in date
842: ,x_invoices_tbl OUT NOCOPY LNS_PAYOFF_PUB.INVOICE_DETAILS_TBL
843: ,x_return_status OUT NOCOPY VARCHAR2
844: ,x_msg_count OUT NOCOPY NUMBER
845: ,x_msg_data OUT NOCOPY VARCHAR2)
846:

Line 905: l_invoices_tbl LNS_PAYOFF_PUB.INVOICE_DETAILS_TBL;

901: l_return_status VARCHAR2(1);
902: l_msg_count NUMBER;
903: l_msg_data VARCHAR2(32767);
904:
905: l_invoices_tbl LNS_PAYOFF_PUB.INVOICE_DETAILS_TBL;
906: l_payoff_tbl2 LNS_FINANCIALS.PAYOFF_TBL2;
907: i number;
908: l_cust_trx_id number;
909: l_payment_schedule_id number;

Line 1449: END LNS_PAYOFF_PUB;

1445: end if;
1446:
1447: END getConvertedReceiptAmount;
1448:
1449: END LNS_PAYOFF_PUB;