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_BUDGETAPPROVAL_PVT dependencies on OZF_ACT_BUDGETS

Line 94: WHERE fund_id = (SELECT budget_source_id FROM ozf_act_budgets

90:
91: CURSOR get_fund_org_csr(p_id in number) IS
92: SELECT org_id
93: FROM ozf_funds_all_b
94: WHERE fund_id = (SELECT budget_source_id FROM ozf_act_budgets
95: WHERE activity_budget_id = p_id);
96:
97: BEGIN
98:

Line 324: FROM ozf_request_headers_all_b req, ozf_act_budgets act

320: l_request_header_id NUMBER;
321:
322: CURSOR c_req_rec (p_act_budget_id IN NUMBER )IS
323: SELECT req.request_header_id
324: FROM ozf_request_headers_all_b req, ozf_act_budgets act
325: WHERE req.offer_id = act.act_budget_used_by_id
326: AND act.activity_budget_id = p_act_budget_id;
327:
328: BEGIN

Line 407: FROM ozf_act_budgets act, ams_campaigns_vl camp, pv_resource_info_v rsc

403: CURSOR c_partner_name IS
404: SELECT act.request_amount,NVL(rsc.partner_party_name,'Partner')
405: , NVL(camp.description,''),
406: camp.source_code, TO_CHAR(camp.actual_exec_start_date),TO_CHAR(camp.actual_exec_end_date),camp.campaign_name
407: FROM ozf_act_budgets act, ams_campaigns_vl camp, pv_resource_info_v rsc
408: WHERE act.activity_budget_id = p_act_budget_rec.activity_budget_id
409: AND act.act_budget_used_by_id = camp.campaign_id
410: AND act.requester_Id = rsc.rsc_resource_id(+);
411:

Line 414: FROM ozf_act_budgets

410: AND act.requester_Id = rsc.rsc_resource_id(+);
411:
412: CURSOR c_approved_amt IS
413: SELECT SUM(approved_amount)
414: FROM ozf_act_budgets
415: WHERE act_budget_used_by_id = p_act_budget_rec.act_budget_used_by_id
416: AND arc_act_budget_used_by = 'CAMP'
417: AND budget_source_type = 'FUND'
418: AND status_code = 'APPROVED';

Line 541: FROM ozf_act_budgets act, ozf_funds_all_b fund

537: CURSOR c_get_actbudgets IS
538: SELECT act.activity_budget_id, act.budget_source_id,
539: (fund.committed_amt - act.request_amount) committed_amt,
540: fund.object_version_number
541: FROM ozf_act_budgets act, ozf_funds_all_b fund
542: WHERE act.arc_act_budget_used_by = 'OFFR'
543: AND act.act_budget_used_by_id = p_offer_id
544: AND act.transfer_type = 'REQUEST'
545: AND act.status_code = 'APPROVED'

Line 553: FROM ozf_act_budgets act, ozf_fund_details_v fund, ozf_funds_utilized_all_b util

549: SELECT act.activity_budget_id, act.budget_source_id,
550: (fund.committed_amt - act.request_amount) committed_amt,
551: fund.object_version_number, util.object_version_number util_object_version,
552: util.utilization_id
553: FROM ozf_act_budgets act, ozf_fund_details_v fund, ozf_funds_utilized_all_b util
554: WHERE act.arc_act_budget_used_by = 'OFFR'
555: AND act.act_budget_used_by_id = p_offer_id
556: AND act.transfer_type = 'REQUEST'
557: AND act.status_code = 'APPROVED'

Line 1425: (SELECT budget_source_id FROM ozf_act_budgets

1421: ,decode(level_type_code, 'PRODUCT', 'PRICING_ATTRIBUTE1', 'PRICING_ATTRIBUTE2') attribute
1422: FROM ams_act_products
1423: WHERE act_product_used_by_id
1424: IN
1425: (SELECT budget_source_id FROM ozf_act_budgets
1426: WHERE arc_act_budget_used_by = 'OFFR'
1427: AND act_budget_used_by_id = p_object_id
1428: AND transfer_type = 'REQUEST'
1429: AND status_code = 'APPROVED')

Line 1941: (SELECT budget_source_id FROM ozf_act_budgets

1937: SELECT distinct market_segment_id, segment_type, exclude_flag
1938: FROM ams_act_market_segments
1939: WHERE act_market_segment_used_by_id
1940: IN
1941: (SELECT budget_source_id FROM ozf_act_budgets
1942: WHERE arc_act_budget_used_by = 'OFFR'
1943: AND act_budget_used_by_id = p_object_id
1944: AND transfer_type = 'REQUEST'
1945: AND status_code = 'APPROVED')

Line 2282: FROM ozf_act_budgets

2278: l_mode_market VARCHAR2(20);
2279:
2280: CURSOR c_get_fund_info IS
2281: SELECT budget_source_id
2282: FROM ozf_act_budgets
2283: WHERE activity_budget_id = p_actbudget_id;
2284:
2285: CURSOR c_get_offer_type IS
2286: SELECT offer_type

Line 2793: FROM ozf_act_budgets

2789: l_strBody VARCHAR2(2000);
2790:
2791: CURSOR c_total_amount IS
2792: SELECT SUM(NVL(request_amount,0))
2793: FROM ozf_act_budgets
2794: WHERE act_budget_used_by_id= p_object_id
2795: AND arc_act_budget_used_by = p_object_type;
2796:
2797: BEGIN

Line 2949: FROM ozf_act_budgets

2945: l_cnt NUMBER := 0 ;
2946:
2947: CURSOR c_get_requests IS
2948: SELECT activity_budget_id, act_budget_used_by_id,arc_act_budget_used_by,requester_id
2949: FROM ozf_act_budgets
2950: WHERE arc_act_budget_used_by = p_object_type
2951: AND act_budget_used_by_id = p_object_id
2952: AND transfer_type = 'REQUEST';
2953: -- AND status_code = 'PENDING'; -- should it be pending validation?

Line 2964: FROM ozf_act_budgets , ozf_funds_all_tl fun

2960:
2961: --kdass 09-DEC-2005 bug 4870218 - SQL ID# 14892629
2962: CURSOR c_get_budget_name(p_activity_id IN NUMBER) IS
2963: SELECT fun.short_name
2964: FROM ozf_act_budgets , ozf_funds_all_tl fun
2965: WHERE activity_budget_id = p_activity_id
2966: AND budget_source_id = fun.fund_id
2967: AND USERENV('LANG') IN (fun.language, fun.source_lang);
2968: /*

Line 2971: FROM ozf_act_budgets , ozf_fund_details_v fun

2967: AND USERENV('LANG') IN (fun.language, fun.source_lang);
2968: /*
2969: CURSOR c_get_budget_name(p_activity_id IN NUMBER) IS
2970: SELECT fun.short_name
2971: FROM ozf_act_budgets , ozf_fund_details_v fun
2972: WHERE activity_budget_id = p_activity_id
2973: AND budget_source_id = fun.fund_id;
2974: */
2975:

Line 3314: UPDATE ozf_act_budgets

3310: WHERE qp_list_header_id = l_modifier_list_rec.qp_list_header_id;
3311:
3312: --kdass 05-DEC-2005 bug 4662453 - reverting budget line status from pending validation to draft
3313: IF p_actbudget_id IS NOT NULL THEN
3314: UPDATE ozf_act_budgets
3315: SET status_code = 'DRAFT'
3316: ,user_status_id = OZF_Utility_PVT.get_default_user_status ('OZF_BUDGETSOURCE_STATUS', 'DRAFT')
3317: ,object_version_number = object_version_number + 1
3318: WHERE activity_budget_id = p_actbudget_id

Line 3323: UPDATE ozf_act_budgets

3319: AND status_code = 'PENDING';
3320: ELSE
3321: FOR request_rec IN c_get_requests
3322: LOOP
3323: UPDATE ozf_act_budgets
3324: SET status_code = 'DRAFT'
3325: ,user_status_id = OZF_Utility_PVT.get_default_user_status ('OZF_BUDGETSOURCE_STATUS', 'DRAFT')
3326: ,object_version_number = object_version_number + 1
3327: WHERE activity_budget_id = request_rec.activity_budget_id

Line 3435: from ozf_act_budgets

3431: -- Cursor to find fund details
3432: CURSOR c_act_budgets(p_object_type VARCHAR2,p_object_id NUMBER)
3433: IS
3434: select activity_budget_id
3435: from ozf_act_budgets
3436: where act_budget_used_by_id = p_object_id
3437: and arc_act_budget_used_by = p_object_type
3438: and transfer_type = 'REQUEST'
3439: and status_code = 'NEW';

Line 3444: from ozf_act_budgets

3440:
3441: CURSOR c_total_budgets(p_object_type VARCHAR2,p_object_id NUMBER)
3442: IS
3443: select NVL(SUM(request_amount),0)
3444: from ozf_act_budgets
3445: where act_budget_used_by_id = p_object_id
3446: and arc_act_budget_used_by = p_object_type
3447: and transfer_type = 'REQUEST';
3448: