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 98: WHERE fund_id = (SELECT budget_source_id FROM ozf_act_budgets

94:
95: CURSOR get_fund_org_csr(p_id in number) IS
96: SELECT org_id
97: FROM ozf_funds_all_b
98: WHERE fund_id = (SELECT budget_source_id FROM ozf_act_budgets
99: WHERE activity_budget_id = p_id);
100:
101: BEGIN
102:

Line 328: FROM ozf_request_headers_all_b req, ozf_act_budgets act

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

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

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

Line 418: FROM ozf_act_budgets

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

Line 545: FROM ozf_act_budgets act, ozf_funds_all_b fund

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

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

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

Line 1429: (SELECT budget_source_id FROM ozf_act_budgets

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

Line 1945: (SELECT budget_source_id FROM ozf_act_budgets

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

Line 2286: FROM ozf_act_budgets

2282: l_mode_market VARCHAR2(20);
2283:
2284: CURSOR c_get_fund_info IS
2285: SELECT budget_source_id
2286: FROM ozf_act_budgets
2287: WHERE activity_budget_id = p_actbudget_id;
2288:
2289: CURSOR c_get_offer_type IS
2290: SELECT offer_type

Line 2797: FROM ozf_act_budgets

2793: l_strBody VARCHAR2(2000);
2794:
2795: CURSOR c_total_amount IS
2796: SELECT SUM(NVL(request_amount,0))
2797: FROM ozf_act_budgets
2798: WHERE act_budget_used_by_id= p_object_id
2799: AND arc_act_budget_used_by = p_object_type;
2800:
2801: BEGIN

Line 2953: FROM ozf_act_budgets

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

Line 2968: FROM ozf_act_budgets , ozf_funds_all_tl fun

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

Line 2975: FROM ozf_act_budgets , ozf_fund_details_v fun

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

Line 3318: UPDATE ozf_act_budgets

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

Line 3327: UPDATE ozf_act_budgets

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

Line 3439: from ozf_act_budgets

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

Line 3448: from ozf_act_budgets

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