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_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 982: FROM pa_proj_fp_options po

978:
979: --Get number of approved plan types
980: SELECT count(*)
981: INTO l_target_plan_types_cnt
982: FROM pa_proj_fp_options po
983: WHERE
984: project_id = p_project_id
985: and fin_plan_option_level_code = 'PLAN_TYPE'
986: and (NVL(po.approved_rev_plan_type_flag,'N') = 'Y'

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

2645:
2646:
2647: -- Start of functions to be used only in implement_ci_into_single_ver API
2648:
2649: FUNCTION get_task_id(p_planning_level IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE,
2650: p_task_id IN pa_resource_assignments.task_id%TYPE)
2651: RETURN NUMBER IS
2652: l_temp NUMBER;
2653: BEGIN

Line 2688: p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE

2684:
2685: FUNCTION get_mapped_ra_id(p_task_id IN pa_resource_assignments.task_id%TYPE,
2686: p_rlm_id IN pa_resource_assignments.resource_list_member_id%TYPE,
2687: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
2688: p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
2689: )
2690: RETURN NUMBER IS
2691: l_index NUMBER;
2692: l_task_id pa_tasks.task_id%TYPE;

Line 2732: p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE

2728:
2729: FUNCTION get_mapped_dml_code(p_task_id IN pa_resource_assignments.task_id%TYPE,
2730: p_rlm_id IN pa_resource_assignments.resource_list_member_id%TYPE,
2731: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
2732: p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
2733:
2734: )
2735: RETURN VARCHAR2 IS
2736: l_index NUMBER;

Line 2856: l_src_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

2852: l_total_amt pa_budget_versions.total_project_revenue%TYPE;
2853: l_total_amt_in_pfc pa_budget_lines.revenue%TYPE;
2854: l_total_amt_in_pc pa_budget_lines.project_revenue%TYPE;
2855:
2856: l_src_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2857: l_src_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
2858: l_src_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
2859: l_src_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2860: l_src_report_lbr_hrs_frm_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

Line 2857: l_src_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

2853: l_total_amt_in_pfc pa_budget_lines.revenue%TYPE;
2854: l_total_amt_in_pc pa_budget_lines.project_revenue%TYPE;
2855:
2856: l_src_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2857: l_src_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
2858: l_src_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
2859: l_src_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2860: l_src_report_lbr_hrs_frm_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
2861:

Line 2858: l_src_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

2854: l_total_amt_in_pc pa_budget_lines.project_revenue%TYPE;
2855:
2856: l_src_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2857: l_src_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
2858: l_src_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
2859: l_src_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2860: l_src_report_lbr_hrs_frm_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
2861:
2862:

Line 2859: l_src_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

2855:
2856: l_src_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2857: l_src_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
2858: l_src_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
2859: l_src_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2860: l_src_report_lbr_hrs_frm_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
2861:
2862:
2863: l_targ_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 2860: l_src_report_lbr_hrs_frm_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

2856: l_src_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2857: l_src_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
2858: l_src_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
2859: l_src_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2860: l_src_report_lbr_hrs_frm_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
2861:
2862:
2863: l_targ_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2864: l_targ_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

Line 2863: l_targ_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

2859: l_src_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2860: l_src_report_lbr_hrs_frm_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
2861:
2862:
2863: l_targ_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2864: l_targ_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
2865:
2866: l_targ_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2867: L_REPORT_COST_USING pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

Line 2864: l_targ_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

2860: l_src_report_lbr_hrs_frm_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
2861:
2862:
2863: l_targ_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2864: l_targ_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
2865:
2866: l_targ_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2867: L_REPORT_COST_USING pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
2868: l_targ_app_rev_flag pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

Line 2866: l_targ_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

2862:
2863: l_targ_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2864: l_targ_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
2865:
2866: l_targ_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2867: L_REPORT_COST_USING pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
2868: l_targ_app_rev_flag pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
2869: l_copy_pfc_for_txn_amt_flag VARCHAR2(1);
2870:

Line 2867: L_REPORT_COST_USING pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

2863: l_targ_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2864: l_targ_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
2865:
2866: l_targ_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2867: L_REPORT_COST_USING pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
2868: l_targ_app_rev_flag pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
2869: l_copy_pfc_for_txn_amt_flag VARCHAR2(1);
2870:
2871: l_project_id pa_proj_fp_options.project_id%TYPE;

Line 2868: l_targ_app_rev_flag pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

2864: l_targ_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
2865:
2866: l_targ_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
2867: L_REPORT_COST_USING pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
2868: l_targ_app_rev_flag pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
2869: l_copy_pfc_for_txn_amt_flag VARCHAR2(1);
2870:
2871: l_project_id pa_proj_fp_options.project_id%TYPE;
2872:

Line 2871: l_project_id pa_proj_fp_options.project_id%TYPE;

2867: L_REPORT_COST_USING pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
2868: l_targ_app_rev_flag pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
2869: l_copy_pfc_for_txn_amt_flag VARCHAR2(1);
2870:
2871: l_project_id pa_proj_fp_options.project_id%TYPE;
2872:
2873: l_txn_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
2874: l_src_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
2875: l_targ_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;

Line 2874: l_src_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;

2870:
2871: l_project_id pa_proj_fp_options.project_id%TYPE;
2872:
2873: l_txn_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
2874: l_src_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
2875: l_targ_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
2876: l_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;
2877: l_targ_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2878: l_src_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;

Line 2875: l_targ_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;

2871: l_project_id pa_proj_fp_options.project_id%TYPE;
2872:
2873: l_txn_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
2874: l_src_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
2875: l_targ_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
2876: l_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;
2877: l_targ_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2878: l_src_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2879:

Line 2876: l_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;

2872:
2873: l_txn_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
2874: l_src_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
2875: l_targ_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
2876: l_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;
2877: l_targ_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2878: l_src_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2879:
2880: l_txn_source_id_tbl system.PA_NUM_TBL_TYPE:= system.PA_NUM_TBL_TYPE();

Line 2877: l_targ_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;

2873: l_txn_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
2874: l_src_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
2875: l_targ_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
2876: l_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;
2877: l_targ_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2878: l_src_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2879:
2880: l_txn_source_id_tbl system.PA_NUM_TBL_TYPE:= system.PA_NUM_TBL_TYPE();
2881: l_res_list_member_id_tbl system.PA_NUM_TBL_TYPE:= system.PA_NUM_TBL_TYPE();

Line 2878: l_src_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;

2874: l_src_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
2875: l_targ_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
2876: l_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;
2877: l_targ_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2878: l_src_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2879:
2880: l_txn_source_id_tbl system.PA_NUM_TBL_TYPE:= system.PA_NUM_TBL_TYPE();
2881: l_res_list_member_id_tbl system.PA_NUM_TBL_TYPE:= system.PA_NUM_TBL_TYPE();
2882: l_rbs_element_id_prm_tbl system.PA_NUM_TBL_TYPE:= system.PA_NUM_TBL_TYPE();

Line 3197: L_TARG_APP_COST_FLAG pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;

3193: l_ci_rev_version_id pa_budget_versions.budget_version_id%TYPE;
3194: l_ci_all_version_id pa_budget_versions.budget_version_id%TYPE;
3195:
3196: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
3197: L_TARG_APP_COST_FLAG pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;
3198:
3199: L_SAME_MULTI_CURR_FLAG VARCHAR2(1);
3200: l_amt_used_for_rate_calc NUMBER;
3201:

Line 3228: l_baselined_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

3224: l_impl_pc_raw_cost pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE;
3225: l_impl_pc_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;
3226: l_impl_pc_burd_cost pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE;
3227: l_target_version_type pa_budget_versions.version_type%TYPE;
3228: l_baselined_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3229: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
3230: l_orig_record_version_number pa_budget_versions.record_version_number%TYPE;
3231: l_fc_version_created_flag VARCHAR2(1);
3232: l_targ_lab_qty_before_merge pa_budget_versions.labor_quantity%TYPE;

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

3461: pa_debug.g_err_stage:= 'Fetching l_baseline_funding_flag :'||l_baseline_funding_flag;
3462: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3463: END IF;
3464:
3465: -- Select the details required from pa_proj_fp_options so that they can be used in the later part of the code
3466: SELECT proj_fp_options_id,
3467: plan_in_multi_curr_flag,
3468: nvl(cost_time_phased_code,nvl(revenue_time_phased_code,all_time_phased_code)),
3469: margin_derived_from_code,

Line 3488: FROM pa_proj_fp_options

3484: l_targ_resource_list_id,
3485: l_rbs_version_id,
3486: l_targ_plan_level_code,
3487: l_retain_manual_lines_flag -- bug 3934574
3488: FROM pa_proj_fp_options
3489: WHERE fin_plan_version_id = p_budget_version_id
3490: AND fin_plan_type_id = p_fin_plan_type_id;
3491:
3492: /*l_copy_pfc_for_txn_amt_flag will be set to Y if the amounts can be entered only in project functinal

Line 3921: FROM pa_proj_fp_options

3917: l_src_time_phased_code,
3918: l_src_report_lbr_hrs_frm_code,
3919: l_src_resource_list_id,
3920: l_src_plan_level_code
3921: FROM pa_proj_fp_options
3922: WHERE fin_plan_version_id = l_src_ver_id_tbl(j);
3923:
3924: IF P_PA_debug_mode = 'Y' THEN
3925: pa_debug.g_err_stage:='Fetching l_src_proj_fp_options_id'||l_src_proj_fp_options_id;

Line 11774: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

11770: X_Err_Code NUMBER;
11771:
11772: l_new_cw_version_id pa_budget_versions.budget_version_id%TYPE;
11773: l_baseline_version_id pa_budget_versions.budget_version_id%TYPE;
11774: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
11775: -- Variable to be used for calling FP_CI_LINK_CONTROL_ITEMS
11776: l_rev_ppl_quantity NUMBER;
11777: l_rev_equip_quantity NUMBER;
11778: l_impl_pfc_revenue NUMBER;