DBA Data[Home] [Help]

APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_CREDIT_PUB

Line 10437: IF (OKL_CREDIT_PUB.get_creditline_by_chrid(r_ast.KHR_ID) = p_contract_id) THEN

10433: BEGIN
10434:
10435: FOR r_ast IN c_disb_tot LOOP
10436:
10437: IF (OKL_CREDIT_PUB.get_creditline_by_chrid(r_ast.KHR_ID) = p_contract_id) THEN
10438: l_disbursement_tot := l_disbursement_tot + NVL(r_ast.AMOUNT,0);
10439: END IF;
10440:
10441: END LOOP;

Line 10446: IF (OKL_CREDIT_PUB.get_creditline_by_chrid(r_pst.KHR_ID) = p_contract_id) THEN

10442:
10443: -- START: cklee - bug#4655437 10/06/2005
10444: FOR r_pst IN c_principal_payments_tot LOOP
10445:
10446: IF (OKL_CREDIT_PUB.get_creditline_by_chrid(r_pst.KHR_ID) = p_contract_id) THEN
10447: l_payment_tot := l_payment_tot + NVL(r_pst.AMOUNT,0);
10448: END IF;
10449:
10450: END LOOP;

Line 10664: IF (OKL_CREDIT_PUB.get_creditline_by_chrid(r_ast.KHR_ID) = p_contract_id) THEN

10660: BEGIN
10661:
10662: FOR r_ast IN c_disb_tot LOOP
10663:
10664: IF (OKL_CREDIT_PUB.get_creditline_by_chrid(r_ast.KHR_ID) = p_contract_id) THEN
10665: l_disbursement_tot := l_disbursement_tot + NVL(r_ast.AMOUNT,0);
10666: END IF;
10667:
10668: END LOOP;

Line 10737: IF (OKL_CREDIT_PUB.get_creditline_by_chrid(x_contract_invoice_tbl(i).KHR_ID) = p_contract_id) THEN

10733: --rkuttiya added for bug 6313562
10734: IF x_contract_invoice_tbl.count > 0 THEN
10735: i := x_contract_invoice_tbl.FIRST;
10736: LOOP
10737: IF (OKL_CREDIT_PUB.get_creditline_by_chrid(x_contract_invoice_tbl(i).KHR_ID) = p_contract_id) THEN
10738: l_payment_tot := l_payment_tot + NVL(x_contract_invoice_tbl(i).AMOUNT, 0);
10739: END IF;
10740: EXIT WHEN i = x_contract_invoice_tbl.LAST;
10741: i := x_contract_invoice_tbl.NEXT(i);