APPS.OZF_FUND_RECONCILE_PVT dependencies on OZF_OBJECT_FUND_SUMMARY

Line 38: -- in ozf_object_fund_summary table, use the stored values instead of conversion.

34: -- 08/04/2008 nirprasa fixed bug 7030415
35: -- 10/08/2008 nirprasa fixed bug 7425189
36: -- 10/08/2008 nirprasa fixed rounding issues, due to currency conversion.
37: -- Since, committed and utilized amounts are already stored in object currency
38: -- in ozf_object_fund_summary table, use the stored values instead of conversion.
39: -- fix is done for bug 7505085.
40: -- 2/17/2010 nepanda Bug 9131648 : multi currency changes
41: -- 28-OCT-2011 APYADAV fix for FP 13252796 Bug 13112685 OFFER RECONCIALTION NOT POPULATING OBJECT_ID,OBJECT_TYPE IN OZF_FUNDS_UTILIZED_A
42: -- 7/10/2012 nepanda Bug 14062938 - budget reconciliation failing for multi currency with error

Line 621: -- 08/24/2005 feliu modified based on new table ozf_object_fund_summary for R12.

617: -- It releases all th ebudget that was requested from a fund to the respective fund by creating transfer records
618: -- and negative committment.
619: -- HISTORY
620: -- 04/30/2001 mpande CREATED
621: -- 08/24/2005 feliu modified based on new table ozf_object_fund_summary for R12.
622: ---------------------------------------------------------------------
623:
624: PROCEDURE reconcile_budget_line (
625: p_budget_used_by_id IN NUMBER

Line 684: FROM ozf_object_fund_summary

680: SELECT fund_id parent_source_id
681: ,fund_currency parent_curr
682: ,NVL(committed_amt,0)-NVL(utilized_amt,0) total_amount
683: ,NVL(plan_curr_committed_amt,0)-NVL(plan_curr_utilized_amt,0) plan_curr_total_amount
684: FROM ozf_object_fund_summary
685: WHERE object_id =p_budget_used_by_id
686: AND object_type = p_budget_used_by_type;
687:
688: CURSOR c_offr_reusable IS

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

1111:
1112:
1113: --Total committed amount in offer currency
1114: -- Ribha, changed cursor query to avoid using ozf_object_checkbook_v (non mergeable view)
1115: -- Ribha: use ozf_object_fund_summary instead of ozf_object_checkbook_v
1116: CURSOR l_budget_csr (p_object_id IN NUMBER) IS
1117: SELECT fund_id,SUM(NVL(plan_curr_committed_amt,0)) total_amt
1118: FROM ozf_object_fund_summary
1119: WHERE object_id = p_object_id

Line 1118: FROM ozf_object_fund_summary

1114: -- Ribha, changed cursor query to avoid using ozf_object_checkbook_v (non mergeable view)
1115: -- Ribha: use ozf_object_fund_summary instead of ozf_object_checkbook_v
1116: CURSOR l_budget_csr (p_object_id IN NUMBER) IS
1117: SELECT fund_id,SUM(NVL(plan_curr_committed_amt,0)) total_amt
1118: FROM ozf_object_fund_summary
1119: WHERE object_id = p_object_id
1120: AND object_type = 'OFFR'
1121: --AND NVL(recal_flag,'N') ='N'
1122: GROUP BY fund_id;

Line 1181: FROM ozf_object_fund_summary

1177: p_object_id IN NUMBER
1178: ,p_budget_id IN NUMBER
1179: ) IS
1180: SELECT NVL(plan_curr_recal_committed_amt,0)- NVL(PLAN_CURR_UTILIZED_AMT,0)
1181: FROM ozf_object_fund_summary
1182: WHERE object_id = p_object_id
1183: AND fund_id = p_budget_id
1184: AND object_type = 'OFFR';
1185:

Line 2194: FROM ozf_object_fund_summary

2190: SELECT object_type, object_id
2191: ,NVL(committed_amt,0) - NVL(earned_amt,0) amount
2192: ,NVL(plan_curr_committed_amt,0) - NVL(plan_curr_utilized_amt,0) plan_curr_amount
2193: ,fund_currency,object_currency
2194: FROM ozf_object_fund_summary
2195: WHERE fund_id = p_fund_id;
2196:
2197: CURSOR c_campaign(p_object_id IN NUMBER) IS
2198: SELECT status_code