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: -- Note
41: ------------------------------------------------------------
42:

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

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

Line 681: FROM ozf_object_fund_summary

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

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

1098:
1099:
1100: --Total committed amount in offer currency
1101: -- Ribha, changed cursor query to avoid using ozf_object_checkbook_v (non mergeable view)
1102: -- Ribha: use ozf_object_fund_summary instead of ozf_object_checkbook_v
1103: CURSOR l_budget_csr (p_object_id IN NUMBER) IS
1104: SELECT fund_id,SUM(NVL(plan_curr_committed_amt,0)) total_amt
1105: FROM ozf_object_fund_summary
1106: WHERE object_id = p_object_id

Line 1105: FROM ozf_object_fund_summary

1101: -- Ribha, changed cursor query to avoid using ozf_object_checkbook_v (non mergeable view)
1102: -- Ribha: use ozf_object_fund_summary instead of ozf_object_checkbook_v
1103: CURSOR l_budget_csr (p_object_id IN NUMBER) IS
1104: SELECT fund_id,SUM(NVL(plan_curr_committed_amt,0)) total_amt
1105: FROM ozf_object_fund_summary
1106: WHERE object_id = p_object_id
1107: AND object_type = 'OFFR'
1108: --AND NVL(recal_flag,'N') ='N'
1109: GROUP BY fund_id;

Line 1168: FROM ozf_object_fund_summary

1164: p_object_id IN NUMBER
1165: ,p_budget_id IN NUMBER
1166: ) IS
1167: SELECT NVL(plan_curr_recal_committed_amt,0)- NVL(PLAN_CURR_UTILIZED_AMT,0)
1168: FROM ozf_object_fund_summary
1169: WHERE object_id = p_object_id
1170: AND fund_id = p_budget_id
1171: AND object_type = 'OFFR';
1172:

Line 2146: FROM ozf_object_fund_summary

2142: SELECT object_type, object_id
2143: ,NVL(committed_amt,0) - NVL(earned_amt,0) amount
2144: ,NVL(plan_curr_committed_amt,0) - NVL(plan_curr_utilized_amt,0) plan_curr_amount
2145: ,fund_currency,object_currency
2146: FROM ozf_object_fund_summary
2147: WHERE fund_id = p_fund_id;
2148:
2149: CURSOR c_campaign(p_object_id IN NUMBER) IS
2150: SELECT status_code