APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_BILLING_UTIL_PUB

Line 3649: P_LOAN_REC.NEXT_PAYMENT_NUMBER := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT(P_LOAN_REC.LOAN_ID);

3645:
3646: end if;
3647:
3648: /* getting current payment number */
3649: P_LOAN_REC.NEXT_PAYMENT_NUMBER := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT(P_LOAN_REC.LOAN_ID);
3650:
3651: if P_LOAN_REC.NEXT_PAYMENT_NUMBER = -1 then
3652:
3653: P_LOAN_REC.NEXT_PAYMENT_NUMBER := 0;

Line 4758: and LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) < LNS_FIN_UTILS.getNumberInstallments(head.LOAN_ID, nvl(head.current_phase, 'TERM'))

4754: from LNS_LOAN_HEADERS head,
4755: LNS_TERMS term
4756: where head.LOAN_STATUS in ('ACTIVE', 'DEFAULT', 'DELINQUENT')
4757: and head.loan_id = term.loan_id
4758: and LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) < LNS_FIN_UTILS.getNumberInstallments(head.LOAN_ID, nvl(head.current_phase, 'TERM'))
4759: and (head.BILLED_FLAG is null or head.BILLED_FLAG = 'N')
4760: and head.PRIMARY_BORROWER_ID = nvl(P_BORROWER_ID, head.PRIMARY_BORROWER_ID)
4761: and head.LOAN_ID = nvl(P_LOAN_ID, head.LOAN_ID)
4762: and (trunc(decode(head.CURRENT_PHASE, 'OPEN', term.OPEN_NEXT_PAYMENT_DATE, term.NEXT_PAYMENT_DUE_DATE)) - trunc(sysdate))

Line 5122: LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) + 1,

5118: select
5119: head.LOAN_ID,
5120: head.LOAN_NUMBER,
5121: head.OBJECT_VERSION_NUMBER,
5122: LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) + 1,
5123: head.CUSTOM_PAYMENTS_FLAG
5124: from LNS_LOAN_HEADERS head,
5125: LNS_TERMS term
5126: where head.LOAN_STATUS in ('ACTIVE', 'DEFAULT', 'DELINQUENT')

Line 5129: and LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) < LNS_FIN_UTILS.getNumberInstallments(head.LOAN_ID, nvl(head.current_phase, 'TERM'))

5125: LNS_TERMS term
5126: where head.LOAN_STATUS in ('ACTIVE', 'DEFAULT', 'DELINQUENT')
5127: and head.loan_id = term.loan_id
5128: and (head.BILLED_FLAG = 'Y' or head.BILLED_FLAG is null) -- scherkas; fix for bug 5687852
5129: and LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) < LNS_FIN_UTILS.getNumberInstallments(head.LOAN_ID, nvl(head.current_phase, 'TERM'))
5130: and trunc(decode(head.CURRENT_PHASE, 'OPEN', term.OPEN_NEXT_PAYMENT_DATE, term.NEXT_PAYMENT_DUE_DATE) + nvl(term.NUMBER_GRACE_DAYS, 0)) < trunc(sysdate)
5131: ORDER BY head.LOAN_ID;
5132:
5133: BEGIN

Line 5337: and AMORTIZATION_SCHEDULE_ID = LNS_BILLING_UTIL_PUB.LAST_AMORTIZATION_SCHED(LOAN_ID);

5333: AMORTIZATION_SCHEDULE_ID,
5334: RATE_ID
5335: from LNS_AMORTIZATION_SCHEDS
5336: where LOAN_ID = P_LOAN_ID
5337: and AMORTIZATION_SCHEDULE_ID = LNS_BILLING_UTIL_PUB.LAST_AMORTIZATION_SCHED(LOAN_ID);
5338:
5339: CURSOR trx_to_reverse_cur(P_LOAN_ID number, P_AMORTIZATION_ID number) IS
5340: select
5341: trx.trx_number,

Line 5757: and AMORTIZATION_SCHEDULE_ID = LNS_BILLING_UTIL_PUB.LAST_AMORTIZATION_SCHED(LOAN_ID);

5753: DUE_DATE,
5754: AMORTIZATION_SCHEDULE_ID
5755: from LNS_AMORTIZATION_SCHEDS
5756: where LOAN_ID = P_LOAN_ID
5757: and AMORTIZATION_SCHEDULE_ID = LNS_BILLING_UTIL_PUB.LAST_AMORTIZATION_SCHED(LOAN_ID);
5758:
5759: CURSOR trx_to_reverse_cur(P_LOAN_ID number, P_AMORTIZATION_ID number, p_line_type varchar2) IS
5760: select
5761: trx.trx_number,