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_CONTROL_ITEMS_UTILS dependencies on PA_PLSQL_DATATYPES

Line 625: l_s_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

621: l_t_version_type pa_budget_versions.version_type%TYPE;
622: l_t_ci_id pa_budget_versions.ci_id%TYPE;
623:
624: --Defining Local PL/SQL variables for source version
625: l_s_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
626: l_s_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
627: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
628: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
629: l_s_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 626: l_s_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

622: l_t_ci_id pa_budget_versions.ci_id%TYPE;
623:
624: --Defining Local PL/SQL variables for source version
625: l_s_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
626: l_s_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
627: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
628: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
629: l_s_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
630: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 627: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

623:
624: --Defining Local PL/SQL variables for source version
625: l_s_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
626: l_s_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
627: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
628: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
629: l_s_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
630: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
631: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

Line 628: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

624: --Defining Local PL/SQL variables for source version
625: l_s_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
626: l_s_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
627: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
628: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
629: l_s_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
630: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
631: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
632: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 629: l_s_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

625: l_s_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
626: l_s_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
627: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
628: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
629: l_s_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
630: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
631: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
632: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
633: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 630: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

626: l_s_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
627: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
628: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
629: l_s_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
630: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
631: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
632: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
633: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
634: l_s_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 631: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

627: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
628: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
629: l_s_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
630: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
631: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
632: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
633: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
634: l_s_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
635:

Line 632: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

628: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
629: l_s_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
630: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
631: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
632: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
633: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
634: l_s_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
635:
636: --Defining Local PL/SQL variables for target version

Line 633: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

629: l_s_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
630: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
631: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
632: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
633: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
634: l_s_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
635:
636: --Defining Local PL/SQL variables for target version
637: l_t_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 634: l_s_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

630: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
631: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
632: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
633: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
634: l_s_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
635:
636: --Defining Local PL/SQL variables for target version
637: l_t_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
638: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 637: l_t_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

633: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
634: l_s_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
635:
636: --Defining Local PL/SQL variables for target version
637: l_t_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
638: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
639: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
640: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
641: l_t_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 638: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

634: l_s_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
635:
636: --Defining Local PL/SQL variables for target version
637: l_t_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
638: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
639: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
640: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
641: l_t_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
642: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 639: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

635:
636: --Defining Local PL/SQL variables for target version
637: l_t_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
638: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
639: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
640: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
641: l_t_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
642: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
643: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

Line 640: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

636: --Defining Local PL/SQL variables for target version
637: l_t_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
638: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
639: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
640: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
641: l_t_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
642: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
643: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
644: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 641: l_t_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

637: l_t_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
638: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
639: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
640: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
641: l_t_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
642: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
643: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
644: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
645: l_t_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 642: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

638: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
639: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
640: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
641: l_t_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
642: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
643: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
644: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
645: l_t_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
646: l_t_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 643: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

639: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
640: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
641: l_t_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
642: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
643: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
644: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
645: l_t_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
646: l_t_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
647: l_s_agreement_id pa_budget_versions.agreement_id%TYPE;

Line 644: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

640: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
641: l_t_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
642: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
643: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
644: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
645: l_t_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
646: l_t_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
647: l_s_agreement_id pa_budget_versions.agreement_id%TYPE;
648: l_t_agreement_id pa_budget_versions.agreement_id%TYPE;

Line 645: l_t_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

641: l_t_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
642: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
643: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
644: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
645: l_t_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
646: l_t_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
647: l_s_agreement_id pa_budget_versions.agreement_id%TYPE;
648: l_t_agreement_id pa_budget_versions.agreement_id%TYPE;
649: --Other Local Variables

Line 646: l_t_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

642: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
643: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
644: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
645: l_t_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
646: l_t_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
647: l_s_agreement_id pa_budget_versions.agreement_id%TYPE;
648: l_t_agreement_id pa_budget_versions.agreement_id%TYPE;
649: --Other Local Variables
650: l_merge_possible_code VARCHAR2(1);

Line 661: l_s_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

657: l_ci_type_name pa_ci_types_tl.short_name%type;
658: l_count number;
659: l_token_ci_id pa_control_items.ci_id%type;
660: l_tsk_plan_level_mismatch VARCHAR2(1) := 'N';
661: l_s_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
662: l_t_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
663: l_s_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
664: l_t_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
665: l_targ_pt_name pa_fin_plan_types_tl.name%TYPE;

Line 662: l_t_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

658: l_count number;
659: l_token_ci_id pa_control_items.ci_id%type;
660: l_tsk_plan_level_mismatch VARCHAR2(1) := 'N';
661: l_s_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
662: l_t_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
663: l_s_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
664: l_t_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
665: l_targ_pt_name pa_fin_plan_types_tl.name%TYPE;
666: l_src_ci_number pa_control_items.ci_number%TYPE;

Line 663: l_s_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

659: l_token_ci_id pa_control_items.ci_id%type;
660: l_tsk_plan_level_mismatch VARCHAR2(1) := 'N';
661: l_s_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
662: l_t_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
663: l_s_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
664: l_t_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
665: l_targ_pt_name pa_fin_plan_types_tl.name%TYPE;
666: l_src_ci_number pa_control_items.ci_number%TYPE;
667: l_module_name varchar2(30) := 'check is possible';

Line 664: l_t_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

660: l_tsk_plan_level_mismatch VARCHAR2(1) := 'N';
661: l_s_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
662: l_t_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
663: l_s_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
664: l_t_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
665: l_targ_pt_name pa_fin_plan_types_tl.name%TYPE;
666: l_src_ci_number pa_control_items.ci_number%TYPE;
667: l_module_name varchar2(30) := 'check is possible';
668: BEGIN

Line 3183: l_ci_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

3179: FROM pa_budget_versions
3180: WHERE project_id = p_project_id AND
3181: nvl(ci_id,-1) = p_ci_id;
3182:
3183: l_ci_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
3184: l_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
3185: l_fin_plan_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
3186: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3187: l_curr_work_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;

Line 3184: l_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

3180: WHERE project_id = p_project_id AND
3181: nvl(ci_id,-1) = p_ci_id;
3182:
3183: l_ci_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
3184: l_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
3185: l_fin_plan_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
3186: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3187: l_curr_work_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;
3188: l_attr_same_flag VARCHAR2(1);

Line 3185: l_fin_plan_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

3181: nvl(ci_id,-1) = p_ci_id;
3182:
3183: l_ci_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
3184: l_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
3185: l_fin_plan_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
3186: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3187: l_curr_work_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;
3188: l_attr_same_flag VARCHAR2(1);
3189:

Line 3960: x_s_task_id_tbl OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

3956: p_s_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3957: p_t_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3958: p_calling_mode in varchar2,
3959: x_tsk_plan_level_mismatch OUT NOCOPY varchar2, --File.Sql.39 bug 4440895
3960: x_s_task_id_tbl OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
3961: x_t_task_id_tbl OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
3962: x_s_fin_plan_level_tbl OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
3963: x_t_fin_plan_level_tbl OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
3964: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3961: x_t_task_id_tbl OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

3957: p_t_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3958: p_calling_mode in varchar2,
3959: x_tsk_plan_level_mismatch OUT NOCOPY varchar2, --File.Sql.39 bug 4440895
3960: x_s_task_id_tbl OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
3961: x_t_task_id_tbl OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
3962: x_s_fin_plan_level_tbl OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
3963: x_t_fin_plan_level_tbl OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
3964: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3965: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 3962: x_s_fin_plan_level_tbl OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

3958: p_calling_mode in varchar2,
3959: x_tsk_plan_level_mismatch OUT NOCOPY varchar2, --File.Sql.39 bug 4440895
3960: x_s_task_id_tbl OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
3961: x_t_task_id_tbl OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
3962: x_s_fin_plan_level_tbl OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
3963: x_t_fin_plan_level_tbl OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
3964: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3965: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3966: x_return_status OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895

Line 3963: x_t_fin_plan_level_tbl OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

3959: x_tsk_plan_level_mismatch OUT NOCOPY varchar2, --File.Sql.39 bug 4440895
3960: x_s_task_id_tbl OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
3961: x_t_task_id_tbl OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
3962: x_s_fin_plan_level_tbl OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
3963: x_t_fin_plan_level_tbl OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
3964: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3965: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3966: x_return_status OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
3967: l_count number;

Line 7492: l_impact_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

7488: 'FINPLAN_COST',
7489: 'FINPLAN_REVENUE')
7490: ORDER BY impact_type_code;
7491:
7492: l_impact_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7493:
7494: BEGIN
7495: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
7496: