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_FINANCIALS dependencies on LNS_BILLING_UTIL_PUB

Line 697: ,p_installment_number => lns_billing_util_pub.last_payment_number(p_loan_id)

693: preProcessInstallment(p_api_version => 1.0
694: ,p_init_msg_list => p_init_msg_list
695: ,p_commit => FND_API.G_FALSE --p_commit
696: ,p_loan_ID => p_loan_id
697: ,p_installment_number => lns_billing_util_pub.last_payment_number(p_loan_id)
698: ,x_amortization_rec => l_amortization_rec
699: ,x_return_status => l_return_status
700: ,x_msg_count => l_msg_count
701: ,x_msg_data => l_msg_data);

Line 874: l_last_installment_billed := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT_3(p_loan_id, 'TERM');

870: then
871:
872: l_num_records := l_amort_tbl.count;
873: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - amortization returns # records '|| l_num_records);
874: l_last_installment_billed := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT_3(p_loan_id, 'TERM');
875: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - last installment billed '|| l_last_installment_billed);
876:
877: -- copy the records not billed to a temp collection
878: m := 0;

Line 1652: ,p_installment_number => lns_billing_util_pub.last_payment_number(p_loan_id)

1648: preProcessInstallment(p_api_version => 1.0
1649: ,p_init_msg_list => p_init_msg_list
1650: ,p_commit => p_commit
1651: ,p_loan_ID => p_loan_id
1652: ,p_installment_number => lns_billing_util_pub.last_payment_number(p_loan_id)
1653: ,x_amortization_rec => l_amortization_rec
1654: ,x_return_status => l_return_status
1655: ,x_msg_count => l_msg_count
1656: ,x_msg_data => l_msg_data);

Line 7021: l_last_installment_billed := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT_3(p_loan_id, 'OPEN');

7017: l_loan_details.LOAN_STATUS NOT IN ('INCOMPLETE','DELETED','REJECTED','PENDING','APPROVED')
7018: then
7019: l_num_records := l_amort_tbl.count;
7020: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - amortization returns # records '|| l_num_records);
7021: l_last_installment_billed := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT_3(p_loan_id, 'OPEN');
7022: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - last installment billed '|| l_last_installment_billed);
7023:
7024: -- copy the records not billed to a temp collection
7025: m := 0;

Line 7673: ,LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id, p_phase) LAST_PAY_NUM

7669: ,decode(p_phase, 'TERM', trunc(h.loan_maturity_date), 'OPEN', trunc(h.open_maturity_date), trunc(h.loan_maturity_date)) MATURITY_DATE
7670: ,NVL(t.reamortize_over_payment, 'N')
7671: ,NVL(t.reamortize_under_payment, 'N')
7672: ,NVL(t.reamortize_with_interest, 'N')
7673: ,LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id, p_phase) LAST_PAY_NUM
7674: --,decode(p_based_on_terms, 'CURRENT', LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id),'ORIGINAL', 1) LAST_PAY_NUM
7675: ,decode(nvl(t.day_count_method, 'PERIODIC30_360'), 'PERIODIC30_360', '30/360', t.day_count_method) DAY_COUNT
7676: ,decode(p_phase, 'TERM', decode(trunc(t.first_payment_date) - trunc(h.loan_start_date), 0, 'N', 'Y')
7677: , 'OPEN', decode(trunc(t.open_first_payment_date) - trunc(h.open_loan_start_date), 0, 'N', 'Y')

Line 7674: --,decode(p_based_on_terms, 'CURRENT', LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id),'ORIGINAL', 1) LAST_PAY_NUM

7670: ,NVL(t.reamortize_over_payment, 'N')
7671: ,NVL(t.reamortize_under_payment, 'N')
7672: ,NVL(t.reamortize_with_interest, 'N')
7673: ,LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id, p_phase) LAST_PAY_NUM
7674: --,decode(p_based_on_terms, 'CURRENT', LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id),'ORIGINAL', 1) LAST_PAY_NUM
7675: ,decode(nvl(t.day_count_method, 'PERIODIC30_360'), 'PERIODIC30_360', '30/360', t.day_count_method) DAY_COUNT
7676: ,decode(p_phase, 'TERM', decode(trunc(t.first_payment_date) - trunc(h.loan_start_date), 0, 'N', 'Y')
7677: , 'OPEN', decode(trunc(t.open_first_payment_date) - trunc(h.open_loan_start_date), 0, 'N', 'Y')
7678: , decode(trunc(t.first_payment_date) - trunc(h.loan_start_date), 0, 'N', 'Y')) ARREARS

Line 7766: select decode(LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(lnh.loan_id),

7762:
7763: -- this cursor will get the last time the loan interest was accrued
7764: -- fix for bug 7423644: removed condition interest_trx_id is not null
7765: cursor c_last_interest_accrual(p_loan_id NUMBER) is
7766: select decode(LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(lnh.loan_id),
7767: 0,
7768: decode(lnh.current_phase, 'TERM', lnh.loan_start_date, 'OPEN', lnh.open_loan_start_date),
7769: (select max(due_date)
7770: from lns_amortization_scheds

Line 10031: l_last_installment := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);

10027: else
10028:
10029: begin
10030:
10031: l_last_installment := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);
10032:
10033: if l_last_installment = 0
10034: then l_last_installment := 1;
10035: end if;

Line 10798: LNS_BILLING_UTIL_PUB.LOAN_BALANCE_BY_DATE(P_LOAN_ID, activity_date) --min(balance_by_activity_date) ending_balance

10794: where loan_id = p_loan_id
10795: union all
10796: select trunc(activity_date) activity_date,
10797: sum(activity_amount) activity_amount,
10798: LNS_BILLING_UTIL_PUB.LOAN_BALANCE_BY_DATE(P_LOAN_ID, activity_date) --min(balance_by_activity_date) ending_balance
10799: from LNS_REC_ACT_CASH_CM_V rav
10800: where rav.loan_id = p_loan_id and
10801: line_type_code = 'PRIN' and
10802: (activity_code in ('PMT', 'ADJ') or (activity_code = 'CM' and activity_number like 'NET%'))

Line 10838: --LNS_BILLING_UTIL_PUB.LOAN_BALANCE_BY_DATE(P_LOAN_ID IN NUMBER, P_DATE IN DATE) function

10834: l_loan_phase varchar2(30);
10835:
10836: begin
10837:
10838: --LNS_BILLING_UTIL_PUB.LOAN_BALANCE_BY_DATE(P_LOAN_ID IN NUMBER, P_DATE IN DATE) function
10839: l_api_name := 'getAverageDailyBalance';
10840: l_balance_days := 0;
10841: l_num_days := 0;
10842: l_total_days := 0;