[Home] [Help]
83: -- x_return_status OUT VARCHAR2
84: --
85: -- NOTES
86: -- This API will create utlizations for camps, schedules,events,offers.event_sche
87: -- in the ozf_Act_budgets table and ozf_Fund_utlized_vl table.
88: -- This API should be called from the cost module of OM only
89: -- HISTORY
90: -- 04/27/2001 Mumu Pande Create.
91: ---------------------------------------------------------------------
106: CURSOR c_parent_source IS
107: SELECT parent_src_id, parent_currency, SUM (amount) total_amount
108: FROM (SELECT a1.parent_source_id parent_src_id, a1.parent_src_curr parent_currency
109: ,NVL (SUM (a1.parent_src_apprvd_amt), 0) amount
110: FROM ozf_act_budgets a1
111: WHERE a1.act_budget_used_by_id = p_budget_used_by_id
112: AND a1.arc_act_budget_used_by = p_budget_used_by_type
113: AND a1.status_code = 'APPROVED'
114: AND a1.transfer_type <> 'UTILIZED'
115: GROUP BY a1.parent_source_id, a1.parent_src_curr
116: UNION
117: SELECT a2.parent_source_id parent_src_id, a2.parent_src_curr parent_currency
118: ,-NVL (SUM (a2.parent_src_apprvd_amt), 0) amount
119: FROM ozf_act_budgets a2
120: WHERE a2.budget_source_id = p_budget_used_by_id
121: AND a2.budget_source_type = p_budget_used_by_type
122: AND a2.status_code = 'APPROVED'
123: GROUP BY a2.parent_source_id, a2.parent_src_curr)
163: SELECT activity_budget_id
164: ,object_version_number
165: ,approved_amount
166: ,parent_src_apprvd_amt
167: FROM ozf_act_budgets
168: WHERE act_budget_used_by_id = p_used_by_id
169: AND arc_act_budget_used_by = p_used_by_type
170:
171: -- AND parent_source_id = p_parent_src_id
591: -- NAME
592: -- Create Fund Utilization
593: -- PURPOSE
594: -- Create utilizations for the utlized amount of that activity
595: -- called only from ozf_Act_budgets API for utlized amount creation
596: -- HISTORY
597: -- 02/23/2001 mpande CREATED
598: -- 02/28/02 feliu Added condition for manual adjustment.
599: ---------------------------------------------------------------------
622: -- NAME
623: -- Create Fund Utilization
624: -- PURPOSE
625: -- Create utilizations for the utlized amount of that activity
626: -- called only from ozf_Act_budgets API for utlized amount creation
627: -- HISTORY
628: -- 02/23/2001 mpande CREATED
629: -- 02/28/02 feliu Added condition for manual adjustment.
630: -- 06/21/2004 yzhao Added x_utilized_amount to return actual utilized amount
719: and status= 'A';
720:
721: -- rimehrot, bug fix 4030022
722: CURSOR c_check_budget_request(p_offer_id IN NUMBER, p_fund_id IN NUMBER) IS
723: SELECT 'X' FROM ozf_act_budgets
724: WHERE act_budget_used_by_id = p_offer_id
725: AND budget_source_id = p_fund_id
726: AND status_code ='APPROVED'
727: AND transfer_type = 'REQUEST';
1378: AND object_type = 'OFFR';
1379:
1380: /* Fix for the bug#3047142
1381: SELECT SUM(DECODE(transfer_type,'REQUEST', NVL(approved_amount,0),NVL(0-approved_original_amount,0)))
1382: FROM ozf_act_budgets
1383: WHERE status_code = 'APPROVED'
1384: AND ((arc_act_budget_used_by = 'OFFR' AND act_budget_used_by_id = l_id and transfer_type ='REQUEST')
1385: OR (budget_source_type = 'OFFR' AND budget_source_id = l_id and transfer_type ='TRANSFER'));
1386:
1384: AND ((arc_act_budget_used_by = 'OFFR' AND act_budget_used_by_id = l_id and transfer_type ='REQUEST')
1385: OR (budget_source_type = 'OFFR' AND budget_source_id = l_id and transfer_type ='TRANSFER'));
1386:
1387: /* SELECT SUM(DECODE(transfer_type,'REQUEST', NVL(approved_amount,0),NVL(0-approved_original_amount,0)))
1388: FROM ozf_act_budgets
1389: WHERE arc_act_budget_used_by = 'OFFR'
1390: AND act_budget_used_by_id = l_id;
1391: */
1392:
1524: x_utilized_amount OUT NOCOPY NUMBER -- added yzhao Jun 21, 2004
1525: ) IS
1526: CURSOR c_act_util_rec (p_used_by_id IN NUMBER, p_used_by_type IN VARCHAR2) IS
1527: SELECT activity_budget_id, object_version_number, approved_amount
1528: FROM ozf_act_budgets
1529: WHERE act_budget_used_by_id = p_used_by_id
1530: AND arc_act_budget_used_by = p_used_by_type
1531: AND transfer_type = 'UTILIZED';
1532: