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_FP_CI_MERGE dependencies on PA_PROJ_FP_OPTIONS

Line 856: l_s_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

852: l_source_version_id pa_budget_versions.budget_version_id%TYPE;
853: l_counter NUMBER := 0;
854: l_task_id NUMBER;
855: l_s_version_id pa_budget_versions.budget_version_id%TYPE;
856: l_s_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
857: l_s_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
858: l_s_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
859: l_s_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
860: l_s_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;

Line 857: l_s_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

853: l_counter NUMBER := 0;
854: l_task_id NUMBER;
855: l_s_version_id pa_budget_versions.budget_version_id%TYPE;
856: l_s_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
857: l_s_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
858: l_s_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
859: l_s_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
860: l_s_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
861: l_s_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;

Line 858: l_s_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;

854: l_task_id NUMBER;
855: l_s_version_id pa_budget_versions.budget_version_id%TYPE;
856: l_s_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
857: l_s_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
858: l_s_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
859: l_s_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
860: l_s_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
861: l_s_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
862: l_s_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;

Line 859: l_s_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;

855: l_s_version_id pa_budget_versions.budget_version_id%TYPE;
856: l_s_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
857: l_s_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
858: l_s_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
859: l_s_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
860: l_s_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
861: l_s_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
862: l_s_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
863: l_s_version_type pa_budget_versions.version_type%TYPE;

Line 860: l_s_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;

856: l_s_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
857: l_s_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
858: l_s_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
859: l_s_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
860: l_s_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
861: l_s_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
862: l_s_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
863: l_s_version_type pa_budget_versions.version_type%TYPE;
864: l_s_ci_id pa_budget_versions.ci_id%TYPE;

Line 866: l_t_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

862: l_s_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
863: l_s_version_type pa_budget_versions.version_type%TYPE;
864: l_s_ci_id pa_budget_versions.ci_id%TYPE;
865: l_t_version_id pa_budget_versions.budget_version_id%TYPE;
866: l_t_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
867: l_t_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
868: l_t_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
869: l_t_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
870: l_t_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;

Line 867: l_t_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;

863: l_s_version_type pa_budget_versions.version_type%TYPE;
864: l_s_ci_id pa_budget_versions.ci_id%TYPE;
865: l_t_version_id pa_budget_versions.budget_version_id%TYPE;
866: l_t_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
867: l_t_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
868: l_t_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
869: l_t_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
870: l_t_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
871: l_t_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;

Line 868: l_t_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;

864: l_s_ci_id pa_budget_versions.ci_id%TYPE;
865: l_t_version_id pa_budget_versions.budget_version_id%TYPE;
866: l_t_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
867: l_t_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
868: l_t_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
869: l_t_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
870: l_t_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
871: l_t_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
872: l_t_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;

Line 869: l_t_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

865: l_t_version_id pa_budget_versions.budget_version_id%TYPE;
866: l_t_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
867: l_t_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
868: l_t_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
869: l_t_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
870: l_t_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
871: l_t_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
872: l_t_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
873: l_t_version_type pa_budget_versions.version_type%TYPE;

Line 870: l_t_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;

866: l_t_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
867: l_t_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
868: l_t_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
869: l_t_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
870: l_t_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
871: l_t_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
872: l_t_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
873: l_t_version_type pa_budget_versions.version_type%TYPE;
874: l_t_ci_id pa_budget_versions.ci_id%TYPE;

Line 877: l_target_plan_type_p_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

873: l_t_version_type pa_budget_versions.version_type%TYPE;
874: l_t_ci_id pa_budget_versions.ci_id%TYPE;
875: l_source_ver_type pa_budget_versions.version_type%TYPE;
876: l_target_ver_type pa_budget_versions.version_type%TYPE;
877: l_target_plan_type_p_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
878:
879: --Defining Local PL/SQL variables for source version
880: l_source_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
881: l_s_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 975: FROM pa_proj_fp_options po

971:
972: --Get number of approved plan types
973: SELECT count(*)
974: INTO l_target_plan_types_cnt
975: FROM pa_proj_fp_options po
976: WHERE
977: project_id = p_project_id
978: and fin_plan_option_level_code = 'PLAN_TYPE'
979: and (NVL(po.approved_rev_plan_type_flag,'N') = 'Y'

Line 3293: FUNCTION get_task_id(p_planning_level IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE,

3289:
3290:
3291: -- Start of functions to be used only in implement_ci_into_single_ver API
3292:
3293: FUNCTION get_task_id(p_planning_level IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE,
3294: p_task_id IN pa_resource_assignments.task_id%TYPE)
3295: RETURN NUMBER IS
3296: l_temp NUMBER;
3297: BEGIN

Line 3332: p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE

3328:
3329: FUNCTION get_mapped_ra_id(p_task_id IN pa_resource_assignments.task_id%TYPE,
3330: p_rlm_id IN pa_resource_assignments.resource_list_member_id%TYPE,
3331: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
3332: p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
3333: )
3334: RETURN NUMBER IS
3335: l_index NUMBER;
3336: l_task_id pa_tasks.task_id%TYPE;

Line 3376: p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE

3372:
3373: FUNCTION get_mapped_dml_code(p_task_id IN pa_resource_assignments.task_id%TYPE,
3374: p_rlm_id IN pa_resource_assignments.resource_list_member_id%TYPE,
3375: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
3376: p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
3377:
3378: )
3379: RETURN VARCHAR2 IS
3380: l_index NUMBER;

Line 3500: l_src_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

3496: l_total_amt pa_budget_versions.total_project_revenue%TYPE;
3497: l_total_amt_in_pfc pa_budget_lines.revenue%TYPE;
3498: l_total_amt_in_pc pa_budget_lines.project_revenue%TYPE;
3499:
3500: l_src_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3501: l_src_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
3502: l_src_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
3503: l_src_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
3504: l_src_report_lbr_hrs_frm_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

Line 3501: l_src_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

3497: l_total_amt_in_pfc pa_budget_lines.revenue%TYPE;
3498: l_total_amt_in_pc pa_budget_lines.project_revenue%TYPE;
3499:
3500: l_src_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3501: l_src_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
3502: l_src_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
3503: l_src_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
3504: l_src_report_lbr_hrs_frm_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
3505:

Line 3502: l_src_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

3498: l_total_amt_in_pc pa_budget_lines.project_revenue%TYPE;
3499:
3500: l_src_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3501: l_src_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
3502: l_src_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
3503: l_src_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
3504: l_src_report_lbr_hrs_frm_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
3505:
3506:

Line 3503: l_src_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

3499:
3500: l_src_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3501: l_src_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
3502: l_src_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
3503: l_src_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
3504: l_src_report_lbr_hrs_frm_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
3505:
3506:
3507: l_targ_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 3504: l_src_report_lbr_hrs_frm_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

3500: l_src_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3501: l_src_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
3502: l_src_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
3503: l_src_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
3504: l_src_report_lbr_hrs_frm_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
3505:
3506:
3507: l_targ_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3508: l_targ_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

Line 3507: l_targ_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

3503: l_src_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
3504: l_src_report_lbr_hrs_frm_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
3505:
3506:
3507: l_targ_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3508: l_targ_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
3509:
3510: l_targ_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
3511: L_REPORT_COST_USING pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

Line 3508: l_targ_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

3504: l_src_report_lbr_hrs_frm_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
3505:
3506:
3507: l_targ_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3508: l_targ_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
3509:
3510: l_targ_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
3511: L_REPORT_COST_USING pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
3512: l_targ_app_rev_flag pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

Line 3510: l_targ_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

3506:
3507: l_targ_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3508: l_targ_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
3509:
3510: l_targ_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
3511: L_REPORT_COST_USING pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
3512: l_targ_app_rev_flag pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
3513: l_copy_pfc_for_txn_amt_flag VARCHAR2(1);
3514:

Line 3511: L_REPORT_COST_USING pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

3507: l_targ_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3508: l_targ_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
3509:
3510: l_targ_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
3511: L_REPORT_COST_USING pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
3512: l_targ_app_rev_flag pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
3513: l_copy_pfc_for_txn_amt_flag VARCHAR2(1);
3514:
3515: l_project_id pa_proj_fp_options.project_id%TYPE;

Line 3512: l_targ_app_rev_flag pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

3508: l_targ_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
3509:
3510: l_targ_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
3511: L_REPORT_COST_USING pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
3512: l_targ_app_rev_flag pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
3513: l_copy_pfc_for_txn_amt_flag VARCHAR2(1);
3514:
3515: l_project_id pa_proj_fp_options.project_id%TYPE;
3516:

Line 3515: l_project_id pa_proj_fp_options.project_id%TYPE;

3511: L_REPORT_COST_USING pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
3512: l_targ_app_rev_flag pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
3513: l_copy_pfc_for_txn_amt_flag VARCHAR2(1);
3514:
3515: l_project_id pa_proj_fp_options.project_id%TYPE;
3516:
3517: l_txn_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
3518: l_src_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
3519: l_targ_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;

Line 3518: l_src_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;

3514:
3515: l_project_id pa_proj_fp_options.project_id%TYPE;
3516:
3517: l_txn_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
3518: l_src_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
3519: l_targ_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
3520: l_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;
3521: l_targ_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
3522: l_src_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;

Line 3519: l_targ_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;

3515: l_project_id pa_proj_fp_options.project_id%TYPE;
3516:
3517: l_txn_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
3518: l_src_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
3519: l_targ_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
3520: l_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;
3521: l_targ_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
3522: l_src_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
3523:

Line 3520: l_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;

3516:
3517: l_txn_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
3518: l_src_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
3519: l_targ_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
3520: l_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;
3521: l_targ_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
3522: l_src_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
3523:
3524: l_txn_source_id_tbl system.PA_NUM_TBL_TYPE:= system.PA_NUM_TBL_TYPE();

Line 3521: l_targ_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;

3517: l_txn_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
3518: l_src_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
3519: l_targ_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
3520: l_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;
3521: l_targ_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
3522: l_src_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
3523:
3524: l_txn_source_id_tbl system.PA_NUM_TBL_TYPE:= system.PA_NUM_TBL_TYPE();
3525: l_res_list_member_id_tbl system.PA_NUM_TBL_TYPE:= system.PA_NUM_TBL_TYPE();

Line 3522: l_src_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;

3518: l_src_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
3519: l_targ_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
3520: l_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;
3521: l_targ_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
3522: l_src_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
3523:
3524: l_txn_source_id_tbl system.PA_NUM_TBL_TYPE:= system.PA_NUM_TBL_TYPE();
3525: l_res_list_member_id_tbl system.PA_NUM_TBL_TYPE:= system.PA_NUM_TBL_TYPE();
3526: l_rbs_element_id_prm_tbl system.PA_NUM_TBL_TYPE:= system.PA_NUM_TBL_TYPE();

Line 3837: L_TARG_APP_COST_FLAG pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;

3833: l_ci_rev_version_id pa_budget_versions.budget_version_id%TYPE;
3834: l_ci_all_version_id pa_budget_versions.budget_version_id%TYPE;
3835:
3836: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
3837: L_TARG_APP_COST_FLAG pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;
3838:
3839: L_SAME_MULTI_CURR_FLAG VARCHAR2(1);
3840: l_amt_used_for_rate_calc NUMBER;
3841:

Line 3868: l_baselined_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

3864: l_impl_pc_raw_cost pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE;
3865: l_impl_pc_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;
3866: l_impl_pc_burd_cost pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE;
3867: l_target_version_type pa_budget_versions.version_type%TYPE;
3868: l_baselined_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3869: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
3870: l_orig_record_version_number pa_budget_versions.record_version_number%TYPE;
3871: l_fc_version_created_flag VARCHAR2(1);
3872: l_targ_lab_qty_before_merge pa_budget_versions.labor_quantity%TYPE;

Line 4098: -- Select the details required from pa_proj_fp_options so that they can be used in the later part of the code

4094: pa_debug.g_err_stage:= 'Fetching l_baseline_funding_flag :'||l_baseline_funding_flag;
4095: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
4096: END IF;
4097:
4098: -- Select the details required from pa_proj_fp_options so that they can be used in the later part of the code
4099: SELECT proj_fp_options_id,
4100: plan_in_multi_curr_flag,
4101: nvl(cost_time_phased_code,nvl(revenue_time_phased_code,all_time_phased_code)),
4102: margin_derived_from_code,

Line 4121: FROM pa_proj_fp_options

4117: l_targ_resource_list_id,
4118: l_rbs_version_id,
4119: l_targ_plan_level_code,
4120: l_retain_manual_lines_flag -- bug 3934574
4121: FROM pa_proj_fp_options
4122: WHERE fin_plan_version_id = p_budget_version_id
4123: AND fin_plan_type_id = p_fin_plan_type_id;
4124:
4125: /*l_copy_pfc_for_txn_amt_flag will be set to Y if the amounts can be entered only in project functinal

Line 4540: FROM pa_proj_fp_options

4536: l_src_time_phased_code,
4537: l_src_report_lbr_hrs_frm_code,
4538: l_src_resource_list_id,
4539: l_src_plan_level_code
4540: FROM pa_proj_fp_options
4541: WHERE fin_plan_version_id = l_src_ver_id_tbl(j);
4542:
4543: IF P_PA_debug_mode = 'Y' THEN
4544: pa_debug.g_err_stage:='Fetching l_src_proj_fp_options_id'||l_src_proj_fp_options_id;

Line 12298: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

12294: X_Err_Code NUMBER;
12295:
12296: l_new_cw_version_id pa_budget_versions.budget_version_id%TYPE;
12297: l_baseline_version_id pa_budget_versions.budget_version_id%TYPE;
12298: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
12299: -- Variable to be used for calling FP_CI_LINK_CONTROL_ITEMS
12300: l_rev_ppl_quantity NUMBER;
12301: l_rev_equip_quantity NUMBER;
12302: l_impl_pfc_revenue NUMBER;