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_ACTBUDGETS_PVT dependencies on OZF_REQUEST_HEADERS_ALL_B

Line 3153: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';

3149: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'FUND' THEN
3150: l_table_name := 'OZF_FUNDS_ALL_B';
3151: l_pk_name := 'FUND_ID';
3152: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'SOFT_FUND' THEN
3153: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';
3154: l_pk_name := 'REQUEST_HEADER_ID';
3155: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'SPECIAL_PRICE' THEN
3156: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';
3157: l_pk_name := 'REQUEST_HEADER_ID';

Line 3156: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';

3152: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'SOFT_FUND' THEN
3153: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';
3154: l_pk_name := 'REQUEST_HEADER_ID';
3155: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'SPECIAL_PRICE' THEN
3156: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';
3157: l_pk_name := 'REQUEST_HEADER_ID';
3158: END IF;
3159:
3160: l_pk_value := p_act_budgets_rec.act_budget_used_by_id;

Line 3195: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';

3191: ELSIF p_act_budgets_rec.budget_source_type = 'CSCH' THEN
3192: l_table_name := 'AMS_CAMPAIGN_SCHEDULES_VL';
3193: l_pk_name := 'SCHEDULE_ID';
3194: ELSIF p_act_budgets_rec.budget_source_type = 'SOFT_FUND' THEN
3195: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';
3196: l_pk_name := 'REQUEST_HEADER_ID';
3197: ELSIF p_act_budgets_rec.budget_source_type = 'SPECIAL_PRICE' THEN
3198: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';
3199: l_pk_name := 'REQUEST_HEADER_ID';

Line 3198: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';

3194: ELSIF p_act_budgets_rec.budget_source_type = 'SOFT_FUND' THEN
3195: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';
3196: l_pk_name := 'REQUEST_HEADER_ID';
3197: ELSIF p_act_budgets_rec.budget_source_type = 'SPECIAL_PRICE' THEN
3198: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';
3199: l_pk_name := 'REQUEST_HEADER_ID';
3200: ELSIF p_act_budgets_rec.budget_source_type = 'FUND' THEN
3201: -- 31-Jan-2001 mpande Removed access from ozf_fund_details_V to ozf_funds_all_vl for cross organzation validation.
3202: -- l_table_name := 'AMS_FUND_DETAILS_V';

Line 4426: FROM ozf_request_headers_all_b

4422: WHERE worksheet_header_id = p_object_id;
4423:
4424: CURSOR c_soft_fund IS
4425: SELECT currency_code
4426: FROM ozf_request_headers_all_b
4427: WHERE request_header_id = p_object_id;
4428:
4429: CURSOR c_special_price IS
4430: SELECT currency_code

Line 4431: FROM ozf_request_headers_all_b

4427: WHERE request_header_id = p_object_id;
4428:
4429: CURSOR c_special_price IS
4430: SELECT currency_code
4431: FROM ozf_request_headers_all_b
4432: WHERE request_header_id = p_object_id;
4433:
4434: BEGIN
4435: x_return_status := fnd_api.g_ret_sts_success;