DBA Data[Home] [Help]

APPS.LNS_CUSTOM_PUB dependencies on LNS_BILLING_UTIL_PUB

Line 166: l_last_installment_billed := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);

162: -- loan is customized
163: l_skip_update := false;
164:
165: -- check to see if the loan has ever been billed
166: l_last_installment_billed := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);
167: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - last installment ' || l_last_installment_billed);
168:
169: if l_last_installment_billed > 0 then
170: FND_MESSAGE.Set_Name('LNS', 'LNS_LOAN_ALREADY_BILLED');

Line 1443: ,decode(p_based_on_terms, 'CURRENT', LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id), 0)

1439: ,trunc(h.loan_start_date)
1440: ,h.funded_amount
1441: ,lns_financials.getRemainingBalance(p_loan_id)
1442: ,trunc(h.loan_maturity_date)
1443: ,decode(p_based_on_terms, 'CURRENT', LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id), 0)
1444: -- ,decode(p_based_on_terms, 'CURRENT', LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT(p_loan_id), -1)
1445: ,decode(nvl(t.day_count_method, 'PERIODIC30_360'), 'PERIODIC30_360', '30/360', t.day_count_method)
1446: ,nvl(h.custom_payments_flag, 'N')
1447: ,h.loan_status

Line 1444: -- ,decode(p_based_on_terms, 'CURRENT', LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT(p_loan_id), -1)

1440: ,h.funded_amount
1441: ,lns_financials.getRemainingBalance(p_loan_id)
1442: ,trunc(h.loan_maturity_date)
1443: ,decode(p_based_on_terms, 'CURRENT', LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id), 0)
1444: -- ,decode(p_based_on_terms, 'CURRENT', LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT(p_loan_id), -1)
1445: ,decode(nvl(t.day_count_method, 'PERIODIC30_360'), 'PERIODIC30_360', '30/360', t.day_count_method)
1446: ,nvl(h.custom_payments_flag, 'N')
1447: ,h.loan_status
1448: ,h.loan_currency