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.

[Home] [Help]

APPS.OZF_ACTBUDGETS_PVT dependencies on OZF_REQUEST_HEADERS_ALL_B

Line 3970: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';

3966: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'FUND' THEN
3967: l_table_name := 'OZF_FUNDS_ALL_B';
3968: l_pk_name := 'FUND_ID';
3969: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'SOFT_FUND' THEN
3970: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';
3971: l_pk_name := 'REQUEST_HEADER_ID';
3972: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'SPECIAL_PRICE' THEN
3973: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';
3974: l_pk_name := 'REQUEST_HEADER_ID';

Line 3973: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';

3969: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'SOFT_FUND' THEN
3970: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';
3971: l_pk_name := 'REQUEST_HEADER_ID';
3972: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'SPECIAL_PRICE' THEN
3973: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';
3974: l_pk_name := 'REQUEST_HEADER_ID';
3975: END IF;
3976:
3977: l_pk_value := p_act_budgets_rec.act_budget_used_by_id;

Line 4012: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';

4008: ELSIF p_act_budgets_rec.budget_source_type = 'CSCH' THEN
4009: l_table_name := 'AMS_CAMPAIGN_SCHEDULES_VL';
4010: l_pk_name := 'SCHEDULE_ID';
4011: ELSIF p_act_budgets_rec.budget_source_type = 'SOFT_FUND' THEN
4012: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';
4013: l_pk_name := 'REQUEST_HEADER_ID';
4014: ELSIF p_act_budgets_rec.budget_source_type = 'SPECIAL_PRICE' THEN
4015: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';
4016: l_pk_name := 'REQUEST_HEADER_ID';

Line 4015: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';

4011: ELSIF p_act_budgets_rec.budget_source_type = 'SOFT_FUND' THEN
4012: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';
4013: l_pk_name := 'REQUEST_HEADER_ID';
4014: ELSIF p_act_budgets_rec.budget_source_type = 'SPECIAL_PRICE' THEN
4015: l_table_name := 'OZF_REQUEST_HEADERS_ALL_B';
4016: l_pk_name := 'REQUEST_HEADER_ID';
4017: ELSIF p_act_budgets_rec.budget_source_type = 'FUND' THEN
4018: -- 31-Jan-2001 mpande Removed access from ozf_fund_details_V to ozf_funds_all_vl for cross organzation validation.
4019: -- l_table_name := 'AMS_FUND_DETAILS_V';

Line 5243: FROM ozf_request_headers_all_b

5239: WHERE worksheet_header_id = p_object_id;
5240:
5241: CURSOR c_soft_fund IS
5242: SELECT currency_code
5243: FROM ozf_request_headers_all_b
5244: WHERE request_header_id = p_object_id;
5245:
5246: CURSOR c_special_price IS
5247: SELECT currency_code

Line 5248: FROM ozf_request_headers_all_b

5244: WHERE request_header_id = p_object_id;
5245:
5246: CURSOR c_special_price IS
5247: SELECT currency_code
5248: FROM ozf_request_headers_all_b
5249: WHERE request_header_id = p_object_id;
5250:
5251: BEGIN
5252: x_return_status := fnd_api.g_ret_sts_success;