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.PA_TASK_ASSIGNMENT_UTILS dependencies on PA_PROJ_FP_OPTIONS

Line 2794: l_target_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;

2790: l_add_projfunc_cur_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
2791: l_ta_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2792: l_target_budget_version_id pa_resource_assignments.budget_version_id%TYPE;
2793: l_target_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
2794: l_target_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2795: l_source_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2796: l_source_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2797: l_target_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2798:

Line 2795: l_source_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;

2791: l_ta_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2792: l_target_budget_version_id pa_resource_assignments.budget_version_id%TYPE;
2793: l_target_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
2794: l_target_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2795: l_source_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2796: l_source_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2797: l_target_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2798:
2799: l_element_version_index NUMBER;

Line 2796: l_source_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

2792: l_target_budget_version_id pa_resource_assignments.budget_version_id%TYPE;
2793: l_target_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
2794: l_target_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2795: l_source_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2796: l_source_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2797: l_target_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2798:
2799: l_element_version_index NUMBER;
2800: -- NEW plsql table to hold the ordered src date

Line 2797: l_target_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

2793: l_target_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
2794: l_target_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2795: l_source_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2796: l_source_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2797: l_target_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2798:
2799: l_element_version_index NUMBER;
2800: -- NEW plsql table to hold the ordered src date
2801: l_adj_src_t_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 2839: from pa_proj_element_versions pev, pa_budget_versions bv, pa_proj_fp_options fpo

2835: l_tar_proj_cur_code VARCHAR2(15);
2836:
2837: CURSOR get_target_project_info (p_target_element_version_id IN NUMBER) IS
2838: select pev.parent_structure_version_id structure_version_id, bv.budget_version_id, fpo.track_workplan_costs_flag
2839: from pa_proj_element_versions pev, pa_budget_versions bv, pa_proj_fp_options fpo
2840: where bv.project_structure_version_id = pev.parent_structure_version_id
2841: and bv.project_id = fpo.project_id
2842: and bv.fin_plan_type_id = fpo.fin_plan_type_id
2843: and bv.budget_version_id = fpo.fin_plan_version_id

Line 3218: FROM pa_proj_element_versions pev, pa_budget_versions bv, pa_proj_fp_options pfo

3214:
3215: -- Bug 3974569.
3216: CURSOR c_get_bv_and_rbs_id(c_evid NUMBER) IS
3217: SELECT bv.budget_version_id, pfo.rbs_version_id
3218: FROM pa_proj_element_versions pev, pa_budget_versions bv, pa_proj_fp_options pfo
3219: WHERE pev.element_version_id = c_evid
3220: AND bv.project_structure_version_id = pev.parent_structure_version_id
3221: AND pfo.fin_plan_version_id = bv.budget_version_id;
3222:

Line 3225: from pa_proj_fp_options

3221: AND pfo.fin_plan_version_id = bv.budget_version_id;
3222:
3223: CURSOR get_multi_cur_flag(c_project_id NUMBER) IS
3224: select nvl(PLAN_IN_MULTI_CURR_FLAG, 'N'), nvl(track_workplan_costs_flag, 'N'), nvl(cost_time_phased_code, 'N')
3225: from pa_proj_fp_options
3226: where fin_plan_type_id = (select fin_plan_type_id
3227: from pa_fin_plan_types_b
3228: where use_for_workplan_flag = 'Y')
3229: and project_id = c_project_id

Line 4913: RETURN pa_proj_fp_options.all_resource_list_id%TYPE

4909: FUNCTION Get_WP_Resource_List_Id(
4910:
4911: p_project_id IN NUMBER)
4912:
4913: RETURN pa_proj_fp_options.all_resource_list_id%TYPE
4914:
4915: IS
4916:
4917: L_FuncProc varchar2(250) ;

Line 4923: from pa_proj_fp_options

4919: CURSOR get_res_list_id IS
4920:
4921: select cost_Resource_list_id
4922:
4923: from pa_proj_fp_options
4924:
4925: where fin_plan_type_id = (select fin_plan_type_id
4926:
4927: from pa_fin_plan_types_b