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 723: ,p_installment_number => lns_billing_util_pub.last_payment_number(p_loan_id)

719: preProcessInstallment(p_api_version => 1.0
720: ,p_init_msg_list => p_init_msg_list
721: ,p_commit => FND_API.G_FALSE --p_commit
722: ,p_loan_ID => p_loan_id
723: ,p_installment_number => lns_billing_util_pub.last_payment_number(p_loan_id)
724: ,x_amortization_rec => l_amortization_rec
725: ,x_return_status => l_return_status
726: ,x_msg_count => l_msg_count
727: ,x_msg_data => l_msg_data);

Line 923: l_last_installment_billed := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT(p_loan_id);

919: if p_based_on_terms = 'CURRENT' then
920:
921: l_num_records := l_amort_tbl.count;
922: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - amortization returns # records '|| l_num_records);
923: l_last_installment_billed := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT(p_loan_id);
924: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - last installment billed '|| l_last_installment_billed);
925:
926: -- copy the records not billed to a temp collection
927: m := 0;

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

1718: preProcessInstallment(p_api_version => 1.0
1719: ,p_init_msg_list => p_init_msg_list
1720: ,p_commit => p_commit
1721: ,p_loan_ID => p_loan_id
1722: ,p_installment_number => lns_billing_util_pub.last_payment_number(p_loan_id)
1723: ,x_amortization_rec => l_amortization_rec
1724: ,x_return_status => l_return_status
1725: ,x_msg_count => l_msg_count
1726: ,x_msg_data => l_msg_data);

Line 6151: l_last_installment_billed := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT(p_loan_id);

6147: if p_based_on_terms = 'CURRENT' then
6148:
6149: l_num_records := l_amort_tbl.count;
6150: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - amortization returns # records '|| l_num_records);
6151: l_last_installment_billed := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT(p_loan_id);
6152: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - last installment billed '|| l_last_installment_billed);
6153:
6154: -- copy the records not billed to a temp collection
6155: m := 0;

Line 6796: ,LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id) LAST_PAY_NUM

6792: ,decode(p_phase, 'TERM', trunc(h.loan_maturity_date), 'OPEN', trunc(h.open_maturity_date), trunc(h.loan_maturity_date)) MATURITY_DATE
6793: ,NVL(t.reamortize_over_payment, 'N')
6794: ,NVL(t.reamortize_under_payment, 'N')
6795: ,NVL(t.reamortize_with_interest, 'N')
6796: ,LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id) LAST_PAY_NUM
6797: --,decode(p_based_on_terms, 'CURRENT', LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id),'ORIGINAL', 1) LAST_PAY_NUM
6798: ,decode(nvl(t.day_count_method, 'PERIODIC30_360'), 'PERIODIC30_360', '30/360', t.day_count_method) DAY_COUNT
6799: ,decode(p_phase, 'TERM', decode(trunc(t.first_payment_date) - trunc(h.loan_start_date), 0, 'N', 'Y')
6800: , 'OPEN', decode(trunc(t.open_first_payment_date) - trunc(h.open_loan_start_date), 0, 'N', 'Y')

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

6793: ,NVL(t.reamortize_over_payment, 'N')
6794: ,NVL(t.reamortize_under_payment, 'N')
6795: ,NVL(t.reamortize_with_interest, 'N')
6796: ,LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id) LAST_PAY_NUM
6797: --,decode(p_based_on_terms, 'CURRENT', LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id),'ORIGINAL', 1) LAST_PAY_NUM
6798: ,decode(nvl(t.day_count_method, 'PERIODIC30_360'), 'PERIODIC30_360', '30/360', t.day_count_method) DAY_COUNT
6799: ,decode(p_phase, 'TERM', decode(trunc(t.first_payment_date) - trunc(h.loan_start_date), 0, 'N', 'Y')
6800: , 'OPEN', decode(trunc(t.open_first_payment_date) - trunc(h.open_loan_start_date), 0, 'N', 'Y')
6801: , decode(trunc(t.first_payment_date) - trunc(h.loan_start_date), 0, 'N', 'Y')) ARREARS

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

6896:
6897: -- this cursor will get the last time the loan interest was accrued
6898: -- fix for bug 7423644: removed condition interest_trx_id is not null
6899: cursor c_last_interest_accrual(p_loan_id NUMBER) is
6900: select decode(LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(lnh.loan_id),
6901: 0,
6902: decode(lnh.current_phase, 'TERM', lnh.loan_start_date, 'OPEN', lnh.open_loan_start_date),
6903: (select max(due_date)
6904: from lns_amortization_scheds

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

8958: else
8959:
8960: begin
8961:
8962: l_last_installment := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);
8963:
8964: if l_last_installment = 0
8965: then l_last_installment := 1;
8966: end if;

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

9594: where loan_id = p_loan_id
9595: union all
9596: select trunc(activity_date) activity_date,
9597: sum(activity_amount) activity_amount,
9598: LNS_BILLING_UTIL_PUB.LOAN_BALANCE_BY_DATE(P_LOAN_ID, activity_date) --min(balance_by_activity_date) ending_balance
9599: from LNS_REC_ACT_CASH_CM_V rav
9600: where rav.loan_id = p_loan_id and
9601: line_type_code = 'PRIN' and
9602: (activity_code in ('PMT', 'ADJ') or (activity_code = 'CM' and activity_number like 'NET%'))

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

9634: l_loan_phase varchar2(30);
9635:
9636: begin
9637:
9638: --LNS_BILLING_UTIL_PUB.LOAN_BALANCE_BY_DATE(P_LOAN_ID IN NUMBER, P_DATE IN DATE) function
9639: l_api_name := 'getAverageDailyBalance';
9640: l_balance_days := 0;
9641: l_num_days := 0;
9642: l_total_days := 0;