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 435: -- 08/05/2005 feliu Use ozf_object_fund_summary table to get committed budgets.

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

Line 455: FROM ozf_object_fund_summary

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

Line 489: FROM ozf_object_fund_summary

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

Line 1376: FROM ozf_object_fund_summary

1372: l_total_distribution NUMBER;
1373:
1374: CURSOR c_approved_amount (p_offer_id NUMBER) IS
1375: SELECT SUM(NVL(plan_curr_committed_amt,0))
1376: FROM ozf_object_fund_summary
1377: WHERE object_id =p_offer_id
1378: AND object_type = 'OFFR';
1379:
1380: /* Fix for the bug#3047142

Line 1851: FROM ozf_object_fund_summary

1847: CURSOR c_prod_budgets (p_offer_id IN NUMBER) IS
1848: SELECT NVL(plan_curr_committed_amt,0) approved_amount
1849: ,fund_id
1850: ,fund_currency currency_code
1851: FROM ozf_object_fund_summary
1852: WHERE object_id =p_offer_id
1853: AND object_type = 'OFFR';
1854:
1855: /*

Line 1886: FROM ozf_object_fund_summary

1882: --kdass 08-Jun-2005 Bug 4415878 SQL Repository Fix - changed the cursor query
1883: -- get total committed and utilized amount
1884: CURSOR c_committed_budgets(p_offer_id IN NUMBER) IS
1885: SELECT SUM(NVL(plan_curr_committed_amt,0))
1886: FROM ozf_object_fund_summary
1887: WHERE object_id =p_offer_id
1888: AND object_type = 'OFFR';
1889: /*
1890: SELECT SUM (approved_amount)

Line 2286: FROM ozf_object_fund_summary

2282: CURSOR c_prod_budgets (p_offer_id IN NUMBER) IS
2283: SELECT NVL(plan_curr_committed_amt,0) approved_amount
2284: ,fund_id
2285: ,fund_currency currency_code
2286: FROM ozf_object_fund_summary
2287: WHERE object_id =p_offer_id
2288: AND object_type = 'OFFR';
2289:
2290: /*

Line 2322: FROM ozf_object_fund_summary

2318: --kdass 08-Jun-2005 Bug 4415878 SQL Repository Fix - changed the cursor query
2319: -- get total committed and utilized amount
2320: CURSOR c_committed_budgets(p_offer_id IN NUMBER) IS
2321: SELECT SUM(NVL(plan_curr_committed_amt,0))
2322: FROM ozf_object_fund_summary
2323: WHERE object_id =p_offer_id
2324: AND object_type = 'OFFR';
2325: /*
2326: SELECT SUM (approved_amount)

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

2897: WHERE qp_list_header_id = p_qp_list_header_id;
2898:
2899: --get total committed remaining.
2900: ---Ribha commented this. Dont use ozf_object_checkbook_v (non mergeable view)
2901: -- Ribha: use ozf_object_fund_summary instead of ozf_object_checkbook_v
2902: CURSOR c_budget_committed(p_qp_list_header_id IN NUMBER) IS
2903: SELECT SUM(NVL(plan_curr_committed_amt,0) - NVL(plan_curr_utilized_amt,0))
2904: from ozf_object_fund_summary
2905: WHERE object_type = 'OFFR'

Line 2904: from ozf_object_fund_summary

2900: ---Ribha commented this. Dont use ozf_object_checkbook_v (non mergeable view)
2901: -- Ribha: use ozf_object_fund_summary instead of ozf_object_checkbook_v
2902: CURSOR c_budget_committed(p_qp_list_header_id IN NUMBER) IS
2903: SELECT SUM(NVL(plan_curr_committed_amt,0) - NVL(plan_curr_utilized_amt,0))
2904: from ozf_object_fund_summary
2905: WHERE object_type = 'OFFR'
2906: AND object_id = p_qp_list_header_id;
2907:
2908: -- get parent campaign id

Line 2942: FROM ozf_object_fund_summary

2938: CURSOR c_source_fund(p_qp_list_header_id IN NUMBER) IS
2939: SELECT fund_id
2940: ,fund_currency
2941: ,NVL(committed_amt,0)-NVL(utilized_amt,0) committed_amt
2942: FROM ozf_object_fund_summary
2943: WHERE object_id =p_qp_list_header_id
2944: AND object_type = 'OFFR';
2945:
2946: /*

Line 3453: FROM ozf_object_fund_summary

3449: CURSOR c_req_budgets (p_offer_id IN NUMBER) IS
3450: SELECT NVL(plan_curr_committed_amt,0) approved_amount
3451: ,fund_id
3452: ,fund_currency currency_code
3453: FROM ozf_object_fund_summary
3454: WHERE object_id =p_offer_id
3455: AND object_type = 'OFFR';
3456:
3457: /*

Line 3488: FROM ozf_object_fund_summary

3484: --kdass 08-Jun-2005 Bug 4415878 SQL Repository Fix - changed the cursor query
3485: -- get total committed and utilized amount
3486: CURSOR c_committed_budgets(p_offer_id IN NUMBER) IS
3487: SELECT SUM(NVL(plan_curr_committed_amt,0))
3488: FROM ozf_object_fund_summary
3489: WHERE object_id =p_offer_id
3490: AND object_type = 'OFFR';
3491:
3492: /*