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_PLSQL_DATATYPES

Line 880: l_source_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

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;
882: l_s_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
883: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
884: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 881: l_s_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

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;
882: l_s_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
883: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
884: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
885: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

Line 882: l_s_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

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;
882: l_s_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
883: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
884: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
885: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
886: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 883: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

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;
882: l_s_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
883: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
884: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
885: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
886: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
887: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 884: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

880: l_source_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
881: l_s_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
882: l_s_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
883: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
884: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
885: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
886: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
887: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
888: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 885: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

881: l_s_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
882: l_s_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
883: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
884: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
885: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
886: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
887: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
888: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
889: l_source_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 886: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

882: l_s_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
883: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
884: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
885: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
886: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
887: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
888: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
889: l_source_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
890:

Line 887: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

883: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
884: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
885: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
886: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
887: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
888: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
889: l_source_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
890:
891: --Defining Local PL/SQL variables for target version

Line 888: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

884: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
885: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
886: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
887: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
888: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
889: l_source_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
890:
891: --Defining Local PL/SQL variables for target version
892: l_target_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 889: l_source_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

885: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
886: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
887: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
888: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
889: l_source_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
890:
891: --Defining Local PL/SQL variables for target version
892: l_target_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
893: l_t_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 892: l_target_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

888: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
889: l_source_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
890:
891: --Defining Local PL/SQL variables for target version
892: l_target_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
893: l_t_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
894: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
895: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
896: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 893: l_t_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

889: l_source_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
890:
891: --Defining Local PL/SQL variables for target version
892: l_target_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
893: l_t_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
894: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
895: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
896: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
897: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

Line 894: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

890:
891: --Defining Local PL/SQL variables for target version
892: l_target_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
893: l_t_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
894: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
895: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
896: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
897: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
898: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 895: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

891: --Defining Local PL/SQL variables for target version
892: l_target_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
893: l_t_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
894: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
895: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
896: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
897: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
898: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
899: l_t_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 896: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

892: l_target_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
893: l_t_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
894: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
895: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
896: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
897: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
898: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
899: l_t_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
900: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 897: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

893: l_t_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
894: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
895: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
896: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
897: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
898: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
899: l_t_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
900: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
901: l_target_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 898: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

894: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
895: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
896: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
897: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
898: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
899: l_t_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
900: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
901: l_target_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
902:

Line 899: l_t_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

895: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
896: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
897: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
898: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
899: l_t_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
900: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
901: l_target_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
902:
903: --Other Local Variables

Line 900: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

896: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
897: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
898: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
899: l_t_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
900: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
901: l_target_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
902:
903: --Other Local Variables
904: l_merge_possible_code_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

Line 901: l_target_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

897: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
898: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
899: l_t_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
900: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
901: l_target_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
902:
903: --Other Local Variables
904: l_merge_possible_code_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
905: l_count_merged_versions NUMBER := 0;

Line 904: l_merge_possible_code_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

900: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
901: l_target_fp_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
902:
903: --Other Local Variables
904: l_merge_possible_code_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
905: l_count_merged_versions NUMBER := 0;
906: l_copy_version_flag VARCHAR2(1);
907: l_copy_possible_flag VARCHAR2(1);
908: l_debug_mode VARCHAR2(30);

Line 3255: l_CI_ID_Tab PA_PLSQL_DATATYPES.IdTabTyp;

3251: l_partial_impl_rev_amt NUMBER;
3252: l_partial_rev_impl_flag VARCHAR2(1);
3253:
3254: --Variable used for passing ci id to the change management baseline API.
3255: l_CI_ID_Tab PA_PLSQL_DATATYPES.IdTabTyp;
3256: l_temp NUMBER;
3257: X_Err_Code NUMBER;
3258: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
3259:

Line 11769: l_CI_ID_Tab PA_PLSQL_DATATYPES.IdTabTyp;

11765:
11766: l_project_id pa_projects_all.project_id%TYPE;
11767:
11768: --Variable used for passing ci id to the change management baseline API.
11769: l_CI_ID_Tab PA_PLSQL_DATATYPES.IdTabTyp;
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;

Line 12592: l_ci_bv_merge_possible_map_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

12588: l_ci_number SYSTEM.pa_varchar2_100_tbl_type :=SYSTEM.pa_varchar2_100_tbl_type();
12589: l_plan_type_collection VARCHAR2(2000);
12590: l_ci_number_collection VARCHAR2(2000);
12591: l_partial_impl_succeeded VARCHAR2(1);
12592: l_ci_bv_merge_possible_map_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
12593: l_index NUMBER;
12594: l_cost_ci_version_id pa_budget_Versions.budget_version_id%TYPE;
12595: l_rev_ci_version_id pa_budget_Versions.budget_version_id%TYPE;
12596: l_all_ci_version_id pa_budget_Versions.budget_version_id%TYPE;