DBA Data[Home] [Help]

APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_FUNDING_PVT

Line 2272: l_amount := okl_funding_pvt.get_chr_funded_adjs(p_contract_id);

2268: OPEN C (p_contract_id);
2269: FETCH C INTO l_amount;
2270: CLOSE C;
2271: */
2272: l_amount := okl_funding_pvt.get_chr_funded_adjs(p_contract_id);
2273: --end:| 21-Sep-07 cklee Bug: 6438934 |
2274:
2275: RETURN l_amount;
2276: EXCEPTION

Line 2334: l_amount := okl_funding_pvt.get_amount_prefunded(p_contract_id);

2330: /*
2331: OPEN C (p_contract_id);
2332: FETCH C INTO l_amount;
2333: CLOSE C;*/
2334: l_amount := okl_funding_pvt.get_amount_prefunded(p_contract_id);
2335: --end:| 21-Sep-07 cklee Bug: 6438934 |
2336:
2337: RETURN l_amount;
2338: EXCEPTION

Line 2393: l_amount := okl_funding_pvt.get_total_funded(p_contract_id);

2389: --start:| 21-Sep-07 cklee Bug: 6438934 |
2390: /* OPEN C (p_contract_id);
2391: FETCH C INTO l_amount;
2392: CLOSE C;*/
2393: l_amount := okl_funding_pvt.get_total_funded(p_contract_id);
2394: --end:| 21-Sep-07 cklee Bug: 6438934 |
2395:
2396: RETURN l_amount;
2397: EXCEPTION

Line 2452: l_amount := okl_funding_pvt.get_total_retention(p_contract_id);

2448: /*
2449: OPEN C (p_contract_id);
2450: FETCH C INTO l_amount;
2451: CLOSE C;*/
2452: l_amount := okl_funding_pvt.get_total_retention(p_contract_id);
2453: --end:| 21-Sep-07 cklee Bug: 6438934 |
2454:
2455: RETURN l_amount;
2456:

Line 13743: ln_contract_funded_amount := okl_funding_pvt.get_total_funded(p_contract_id => p_contract_id);

13739: --AND trx_status_code = 'ENTERED'
13740: --AND FUNDING_TYPE_CODE IN ('PREFUNDING', 'ASSET', 'EXPENSE');
13741:
13742: BEGIN
13743: ln_contract_funded_amount := okl_funding_pvt.get_total_funded(p_contract_id => p_contract_id);
13744:
13745: IF (p_contract_line_id IS NOT NULL AND p_contract_line_id <> OKL_API.G_MISS_NUM) THEN
13746: OPEN c_get_fund_amount(p_contract_line_id => p_contract_line_id);
13747: FETCH c_get_fund_amount INTO ln_fund_amount;