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_BILLING_UTIL_PUB

Line 174: and lam.payment_number = LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id)

170: ,ar_payment_schedules trx
171: where rap.cash_receipt_id = rac.cash_receipt_id
172: and rap.applied_customer_trx_id = trx.customer_trx_id
173: and trx.customer_trx_id = lam.interest_trx_id
174: and lam.payment_number = LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id)
175: and lam.reversed_flag = 'N'
176: and lam.reamortization_amount is null
177: and lam.parent_amortization_id is null
178: and lam.loan_id = p_loan_id

Line 289: l_bill_headers_tbl(1).ASSOC_PAYMENT_NUM := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);

285: -- build the header for the loan document(s) to be created
286: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Building Invoice header/lines');
287: l_bill_headers_tbl(1).HEADER_ID := 101;
288: l_bill_headers_tbl(1).LOAN_ID := p_loan_id;
289: l_bill_headers_tbl(1).ASSOC_PAYMENT_NUM := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);
290: l_bill_headers_tbl(1).DUE_DATE := p_payoff_date;
291:
292: -- now build the lines for the loan document(s) to be created
293: for i in 1..l_payoff_tbl2.count

Line 449: and payment_number = LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);

445: where loan_id = p_loan_id
446: and reamortization_amount is null
447: and parent_amortization_id is null
448: --and reversed_flag = 'N'
449: and payment_number = LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);
450:
451: end if;
452: b_recalculate_interest := false;
453: end if;

Line 786: ,LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id)

782: order by payment_number, line_type, amount_due_remaining;
783:
784: cursor c_loanInfo(p_loan_id number) is
785: select loan_number
786: ,LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id)
787: ,current_phase
788: from lns_loan_headers
789: where loan_id = p_loan_id;
790:

Line 798: and payment_number = LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);

794: from lns_amortization_scheds
795: where loan_id = p_loan_id
796: and reversed_flag <> 'Y'
797: and reamortization_amount is null
798: and payment_number = LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);
799:
800: cursor c_fees(p_loan_id number, p_phase varchar2, p_installment number)
801: is
802: select sched.fee_amount

Line 939: LNS_BILLING_UTIL_PUB.GET_TRX_DATE(P_LOAN_ID => p_loan_id,

935: fetch c_loanInfo into l_invoice_number, l_installment, l_phase;
936: close c_loanInfo;
937:
938: -- get trx date
939: LNS_BILLING_UTIL_PUB.GET_TRX_DATE(P_LOAN_ID => p_loan_id,
940: P_DUE_DATE => p_payoff_date,
941: X_TRX_DATE => l_trx_date,
942: X_RA_TERM_ID => l_term_id);
943:

Line 950: LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE(

946: FROM LNS_SYSTEM_OPTIONS
947: WHERE ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID();
948:
949: -- get gl_date
950: LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE(
951: p_gl_date => l_trx_date + nvl(l_day_togl_after_dd, 0),
952: p_trx_date => l_trx_date,
953: p_set_of_books_id => l_sob,
954: x_default_gl_date => l_gl_date);

Line 1459: ,LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id)

1455: curr.currency_code = loan.loan_currency;
1456:
1457: cursor c_loanInfo(p_loan_id number) is
1458: select loan_number
1459: ,LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id)
1460: ,current_phase
1461: ,LOAN_CLASS_CODE
1462: ,FUNDED_AMOUNT
1463: from lns_loan_headers

Line 1610: LNS_BILLING_UTIL_PUB.GET_TRX_DATE(P_LOAN_ID => P_LOAN_ID,

1606: fetch precision_cur into l_precision;
1607: close precision_cur;
1608:
1609: -- get trx date
1610: LNS_BILLING_UTIL_PUB.GET_TRX_DATE(P_LOAN_ID => P_LOAN_ID,
1611: P_DUE_DATE => p_cancellation_date,
1612: X_TRX_DATE => l_trx_date,
1613: X_RA_TERM_ID => l_term_id);
1614:

Line 1620: LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE(

1616: into l_day_togl_after_dd, l_sob
1617: FROM LNS_SYSTEM_OPTIONS
1618: WHERE ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID();
1619:
1620: LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE(
1621: p_gl_date => (l_trx_date + l_day_togl_after_dd),
1622: p_trx_date => l_trx_date,
1623: p_set_of_books_id => l_sob,
1624: x_default_gl_date => l_gl_date);

Line 2922: l_bill_headers_tbl(1).ASSOC_PAYMENT_NUM := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(l_loan_id);

2918:
2919: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Building Invoice header...');
2920: l_bill_headers_tbl(1).HEADER_ID := 101;
2921: l_bill_headers_tbl(1).LOAN_ID := l_loan_id;
2922: l_bill_headers_tbl(1).ASSOC_PAYMENT_NUM := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(l_loan_id);
2923: l_bill_headers_tbl(1).DUE_DATE := l_due_date1;
2924:
2925: if l_disable_billing = 'Y' then
2926: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Re-enabling billing...');

Line 3535: l_BILL_HEADERS_TBL(l_header_counter).ASSOC_PAYMENT_NUM := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(l_loan_id);

3531:
3532: l_header_counter := 1;
3533: l_BILL_HEADERS_TBL(l_header_counter).HEADER_ID := l_header_counter;
3534: l_BILL_HEADERS_TBL(l_header_counter).LOAN_ID := l_loan_id;
3535: l_BILL_HEADERS_TBL(l_header_counter).ASSOC_PAYMENT_NUM := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(l_loan_id);
3536: l_BILL_HEADERS_TBL(l_header_counter).DUE_DATE := l_LOAN_START_DATE;
3537: l_BILL_HEADERS_TBL(l_header_counter).CUST_ACCOUNT_ID := l_CUST_ACCOUNT_ID;
3538: l_BILL_HEADERS_TBL(l_header_counter).BILL_TO_ADDRESS_ID := l_BILL_TO_ACCT_SITE_ID;
3539: