eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_FUND_ADJUSTMENT_PVT dependencies on OZF_OBJECT_FUND_SUMMARY

Line 437: -- 08/05/2005 feliu Use ozf_object_fund_summary table to get committed budgets.

433: -- PURPOSE
434: -- API to automaticaly populate the parent_source_id ( fund_id), parent_src_curr, parent_src_apprv_amt
435: -- HISTORY
436: -- 04/27/2001 mpande Created.
437: -- 08/05/2005 feliu Use ozf_object_fund_summary table to get committed budgets.
438: ---------------------------------------------------------------------
439:
440: PROCEDURE get_parent_src (
441: p_budget_source_type IN VARCHAR2

Line 457: FROM ozf_object_fund_summary

453: SELECT fund_id parent_source
454: ,fund_currency parent_curr
455: ,NVL(committed_amt,0)-NVL(utilized_amt,0) total_amount
456: ,NVL(univ_curr_committed_amt,0)-NVL(univ_curr_utilized_amt,0) total_acctd_amount
457: FROM ozf_object_fund_summary
458: WHERE object_id =p_budget_source_id
459: AND object_type = p_budget_source_type;
460:
461:

Line 491: FROM ozf_object_fund_summary

487: ORDER BY parent_source;
488: */
489: CURSOR c_total_acct_amt IS
490: SELECT SUM(NVL(univ_curr_committed_amt,0) - NVL(univ_curr_utilized_amt,0))
491: FROM ozf_object_fund_summary
492: WHERE object_id =p_budget_source_id
493: AND object_type = p_budget_source_type;
494:
495: /*

Line 1593: FROM ozf_object_fund_summary

1589: l_total_distribution NUMBER;
1590:
1591: CURSOR c_approved_amount (p_offer_id NUMBER) IS
1592: SELECT SUM(NVL(plan_curr_committed_amt,0))
1593: FROM ozf_object_fund_summary
1594: WHERE object_id =p_offer_id
1595: AND object_type = 'OFFR';
1596:
1597: /* Fix for the bug#3047142

Line 2373: FROM ozf_object_fund_summary

2369: CURSOR c_prod_budgets (p_offer_id IN NUMBER) IS
2370: SELECT NVL(plan_curr_committed_amt,0) approved_amount
2371: ,fund_id
2372: ,fund_currency currency_code
2373: FROM ozf_object_fund_summary
2374: WHERE object_id =p_offer_id
2375: AND object_type = 'OFFR';
2376:
2377: /*

Line 2408: FROM ozf_object_fund_summary

2404: --kdass 08-Jun-2005 Bug 4415878 SQL Repository Fix - changed the cursor query
2405: -- get total committed and utilized amount
2406: CURSOR c_committed_budgets(p_offer_id IN NUMBER) IS
2407: SELECT SUM(NVL(plan_curr_committed_amt,0))
2408: FROM ozf_object_fund_summary
2409: WHERE object_id =p_offer_id
2410: AND object_type = 'OFFR';
2411: /*
2412: SELECT SUM (approved_amount)

Line 2814: FROM ozf_object_fund_summary

2810: CURSOR c_prod_budgets (p_offer_id IN NUMBER) IS
2811: SELECT NVL(plan_curr_committed_amt,0) approved_amount
2812: ,fund_id
2813: ,fund_currency currency_code
2814: FROM ozf_object_fund_summary
2815: WHERE object_id =p_offer_id
2816: AND object_type = 'OFFR';
2817:
2818: /*

Line 2850: FROM ozf_object_fund_summary

2846: --kdass 08-Jun-2005 Bug 4415878 SQL Repository Fix - changed the cursor query
2847: -- get total committed and utilized amount
2848: CURSOR c_committed_budgets(p_offer_id IN NUMBER) IS
2849: SELECT SUM(NVL(plan_curr_committed_amt,0))
2850: FROM ozf_object_fund_summary
2851: WHERE object_id =p_offer_id
2852: AND object_type = 'OFFR';
2853: /*
2854: SELECT SUM (approved_amount)

Line 3576: -- Ribha: use ozf_object_fund_summary instead of ozf_object_checkbook_v

3572: WHERE qp_list_header_id = p_qp_list_header_id;
3573:
3574: --get total committed remaining.
3575: ---Ribha commented this. Dont use ozf_object_checkbook_v (non mergeable view)
3576: -- Ribha: use ozf_object_fund_summary instead of ozf_object_checkbook_v
3577: CURSOR c_budget_committed(p_qp_list_header_id IN NUMBER) IS
3578: SELECT SUM(NVL(plan_curr_committed_amt,0) - NVL(plan_curr_utilized_amt,0))
3579: from ozf_object_fund_summary
3580: WHERE object_type = 'OFFR'

Line 3579: from ozf_object_fund_summary

3575: ---Ribha commented this. Dont use ozf_object_checkbook_v (non mergeable view)
3576: -- Ribha: use ozf_object_fund_summary instead of ozf_object_checkbook_v
3577: CURSOR c_budget_committed(p_qp_list_header_id IN NUMBER) IS
3578: SELECT SUM(NVL(plan_curr_committed_amt,0) - NVL(plan_curr_utilized_amt,0))
3579: from ozf_object_fund_summary
3580: WHERE object_type = 'OFFR'
3581: AND object_id = p_qp_list_header_id;
3582:
3583: -- get parent campaign id

Line 3617: FROM ozf_object_fund_summary

3613: CURSOR c_source_fund(p_qp_list_header_id IN NUMBER) IS
3614: SELECT fund_id
3615: ,fund_currency
3616: ,NVL(committed_amt,0)-NVL(utilized_amt,0) committed_amt
3617: FROM ozf_object_fund_summary
3618: WHERE object_id =p_qp_list_header_id
3619: AND object_type = 'OFFR';
3620:
3621: /*

Line 4131: FROM ozf_object_fund_summary

4127: CURSOR c_req_budgets (p_offer_id IN NUMBER) IS
4128: SELECT NVL(plan_curr_committed_amt,0) approved_amount
4129: ,fund_id
4130: ,fund_currency currency_code
4131: FROM ozf_object_fund_summary
4132: WHERE object_id =p_offer_id
4133: AND object_type = 'OFFR';
4134:
4135: /*

Line 4166: FROM ozf_object_fund_summary

4162: --kdass 08-Jun-2005 Bug 4415878 SQL Repository Fix - changed the cursor query
4163: -- get total committed and utilized amount
4164: CURSOR c_committed_budgets(p_offer_id IN NUMBER) IS
4165: SELECT SUM(NVL(plan_curr_committed_amt,0))
4166: FROM ozf_object_fund_summary
4167: WHERE object_id =p_offer_id
4168: AND object_type = 'OFFR';
4169:
4170: /*