DBA Data[Home] [Help]

APPS.OKL_CO_WF dependencies on OKL_SEEDED_FUNCTIONS_PVT

Line 1443: l_case_total := l_case_total + NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_oec(p_chr_id => cur.id, p_line_id => NULL),0)

1439:
1440: l_case_total number := 0;
1441: BEGIN
1442: FOR cur IN l_contract_csr(p_case_number) LOOP
1443: l_case_total := l_case_total + NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_oec(p_chr_id => cur.id, p_line_id => NULL),0)
1444: - NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_tradein(p_chr_id => cur.id, p_line_id => NULL),0)
1445: - NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_capital_reduction(p_chr_id => cur.id, p_line_id => NULL),0)
1446: + NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_fees_capitalized(p_chr_id => cur.id, p_line_id => NULL),0);
1447: END LOOP;

Line 1444: - NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_tradein(p_chr_id => cur.id, p_line_id => NULL),0)

1440: l_case_total number := 0;
1441: BEGIN
1442: FOR cur IN l_contract_csr(p_case_number) LOOP
1443: l_case_total := l_case_total + NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_oec(p_chr_id => cur.id, p_line_id => NULL),0)
1444: - NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_tradein(p_chr_id => cur.id, p_line_id => NULL),0)
1445: - NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_capital_reduction(p_chr_id => cur.id, p_line_id => NULL),0)
1446: + NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_fees_capitalized(p_chr_id => cur.id, p_line_id => NULL),0);
1447: END LOOP;
1448: RETURN l_case_total;

Line 1445: - NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_capital_reduction(p_chr_id => cur.id, p_line_id => NULL),0)

1441: BEGIN
1442: FOR cur IN l_contract_csr(p_case_number) LOOP
1443: l_case_total := l_case_total + NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_oec(p_chr_id => cur.id, p_line_id => NULL),0)
1444: - NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_tradein(p_chr_id => cur.id, p_line_id => NULL),0)
1445: - NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_capital_reduction(p_chr_id => cur.id, p_line_id => NULL),0)
1446: + NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_fees_capitalized(p_chr_id => cur.id, p_line_id => NULL),0);
1447: END LOOP;
1448: RETURN l_case_total;
1449: END get_case_total_value;

Line 1446: + NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_fees_capitalized(p_chr_id => cur.id, p_line_id => NULL),0);

1442: FOR cur IN l_contract_csr(p_case_number) LOOP
1443: l_case_total := l_case_total + NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_oec(p_chr_id => cur.id, p_line_id => NULL),0)
1444: - NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_tradein(p_chr_id => cur.id, p_line_id => NULL),0)
1445: - NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_capital_reduction(p_chr_id => cur.id, p_line_id => NULL),0)
1446: + NVL(OKL_SEEDED_FUNCTIONS_PVT.contract_fees_capitalized(p_chr_id => cur.id, p_line_id => NULL),0);
1447: END LOOP;
1448: RETURN l_case_total;
1449: END get_case_total_value;
1450: