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

Line 2909: l_target_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;

2905: l_add_projfunc_cur_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
2906: l_ta_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2907: l_target_budget_version_id pa_resource_assignments.budget_version_id%TYPE;
2908: l_target_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
2909: l_target_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2910: l_source_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2911: l_source_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2912: l_target_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2913:

Line 2910: l_source_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;

2906: l_ta_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2907: l_target_budget_version_id pa_resource_assignments.budget_version_id%TYPE;
2908: l_target_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
2909: l_target_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2910: l_source_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2911: l_source_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2912: l_target_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2913:
2914: l_element_version_index NUMBER;

Line 2911: l_source_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

2907: l_target_budget_version_id pa_resource_assignments.budget_version_id%TYPE;
2908: l_target_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
2909: l_target_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2910: l_source_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2911: l_source_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2912: l_target_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2913:
2914: l_element_version_index NUMBER;
2915: -- NEW plsql table to hold the ordered src date

Line 2912: l_target_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

2908: l_target_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
2909: l_target_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2910: l_source_workplan_costs_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
2911: l_source_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2912: l_target_cost_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2913:
2914: l_element_version_index NUMBER;
2915: -- NEW plsql table to hold the ordered src date
2916: l_adj_src_t_start_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

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

2950: l_tar_proj_cur_code VARCHAR2(15);
2951:
2952: CURSOR get_target_project_info (p_target_element_version_id IN NUMBER) IS
2953: select pev.parent_structure_version_id structure_version_id, bv.budget_version_id, fpo.track_workplan_costs_flag
2954: from pa_proj_element_versions pev, pa_budget_versions bv, pa_proj_fp_options fpo
2955: where bv.project_structure_version_id = pev.parent_structure_version_id
2956: and bv.project_id = fpo.project_id
2957: and bv.fin_plan_type_id = fpo.fin_plan_type_id
2958: and bv.budget_version_id = fpo.fin_plan_version_id

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

3329:
3330: -- Bug 3974569.
3331: CURSOR c_get_bv_and_rbs_id(c_evid NUMBER) IS
3332: SELECT bv.budget_version_id, pfo.rbs_version_id
3333: FROM pa_proj_element_versions pev, pa_budget_versions bv, pa_proj_fp_options pfo
3334: WHERE pev.element_version_id = c_evid
3335: AND bv.project_structure_version_id = pev.parent_structure_version_id
3336: AND pfo.fin_plan_version_id = bv.budget_version_id;
3337:

Line 3340: from pa_proj_fp_options

3336: AND pfo.fin_plan_version_id = bv.budget_version_id;
3337:
3338: CURSOR get_multi_cur_flag(c_project_id NUMBER) IS
3339: select nvl(PLAN_IN_MULTI_CURR_FLAG, 'N'), nvl(track_workplan_costs_flag, 'N'), nvl(cost_time_phased_code, 'N')
3340: from pa_proj_fp_options
3341: where fin_plan_type_id = (select fin_plan_type_id
3342: from pa_fin_plan_types_b
3343: where use_for_workplan_flag = 'Y')
3344: and project_id = c_project_id

Line 5029: RETURN pa_proj_fp_options.all_resource_list_id%TYPE

5025: FUNCTION Get_WP_Resource_List_Id(
5026:
5027: p_project_id IN NUMBER)
5028:
5029: RETURN pa_proj_fp_options.all_resource_list_id%TYPE
5030:
5031: IS
5032:
5033: L_FuncProc varchar2(250) ;

Line 5039: from pa_proj_fp_options

5035: CURSOR get_res_list_id IS
5036:
5037: select cost_Resource_list_id
5038:
5039: from pa_proj_fp_options
5040:
5041: where fin_plan_type_id = (select fin_plan_type_id
5042:
5043: from pa_fin_plan_types_b