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 649: l_s_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

645: l_t_version_type pa_budget_versions.version_type%TYPE;
646: l_t_ci_id pa_budget_versions.ci_id%TYPE;
647:
648: --Defining Local PL/SQL variables for source version
649: l_s_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
650: l_s_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
651: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
652: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
653: l_s_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 650: l_s_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

646: l_t_ci_id pa_budget_versions.ci_id%TYPE;
647:
648: --Defining Local PL/SQL variables for source version
649: l_s_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
650: l_s_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
651: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
652: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
653: l_s_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
654: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 651: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

647:
648: --Defining Local PL/SQL variables for source version
649: l_s_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
650: l_s_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
651: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
652: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
653: l_s_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
654: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
655: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

Line 652: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

648: --Defining Local PL/SQL variables for source version
649: l_s_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
650: l_s_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
651: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
652: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
653: l_s_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
654: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
655: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
656: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 653: l_s_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

649: l_s_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
650: l_s_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
651: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
652: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
653: l_s_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
654: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
655: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
656: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
657: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 654: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

650: l_s_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
651: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
652: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
653: l_s_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
654: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
655: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
656: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
657: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
658: l_s_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 655: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

651: l_s_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
652: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
653: l_s_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
654: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
655: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
656: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
657: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
658: l_s_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
659:

Line 656: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

652: l_s_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
653: l_s_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
654: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
655: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
656: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
657: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
658: l_s_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
659:
660: --Defining Local PL/SQL variables for target version

Line 657: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

653: l_s_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
654: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
655: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
656: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
657: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
658: l_s_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
659:
660: --Defining Local PL/SQL variables for target version
661: l_t_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 658: l_s_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

654: l_s_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
655: l_s_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
656: l_s_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
657: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
658: l_s_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
659:
660: --Defining Local PL/SQL variables for target version
661: l_t_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
662: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 661: l_t_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

657: l_s_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
658: l_s_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
659:
660: --Defining Local PL/SQL variables for target version
661: l_t_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
662: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
663: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
664: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
665: l_t_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 662: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

658: l_s_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
659:
660: --Defining Local PL/SQL variables for target version
661: l_t_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
662: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
663: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
664: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
665: l_t_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
666: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 663: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

659:
660: --Defining Local PL/SQL variables for target version
661: l_t_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
662: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
663: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
664: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
665: l_t_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
666: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
667: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

Line 664: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

660: --Defining Local PL/SQL variables for target version
661: l_t_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
662: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
663: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
664: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
665: l_t_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
666: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
667: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
668: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

Line 665: l_t_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

661: l_t_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
662: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
663: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
664: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
665: l_t_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
666: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
667: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
668: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
669: l_t_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 666: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

662: l_t_fin_plan_pref_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
663: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
664: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
665: l_t_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
666: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
667: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
668: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
669: l_t_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
670: l_t_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 667: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

663: l_t_multi_curr_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
664: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
665: l_t_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
666: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
667: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
668: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
669: l_t_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
670: l_t_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
671: l_s_agreement_id pa_budget_versions.agreement_id%TYPE;

Line 668: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

664: l_t_time_phased_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
665: l_t_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
666: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
667: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
668: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
669: l_t_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
670: l_t_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
671: l_s_agreement_id pa_budget_versions.agreement_id%TYPE;
672: l_t_agreement_id pa_budget_versions.agreement_id%TYPE;

Line 669: l_t_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

665: l_t_resource_list_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
666: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
667: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
668: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
669: l_t_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
670: l_t_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
671: l_s_agreement_id pa_budget_versions.agreement_id%TYPE;
672: l_t_agreement_id pa_budget_versions.agreement_id%TYPE;
673: --Other Local Variables

Line 670: l_t_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

666: l_t_fin_plan_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
667: l_t_uncategorized_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
668: l_t_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
669: l_t_group_res_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
670: l_t_ci_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
671: l_s_agreement_id pa_budget_versions.agreement_id%TYPE;
672: l_t_agreement_id pa_budget_versions.agreement_id%TYPE;
673: --Other Local Variables
674: l_merge_possible_code VARCHAR2(1);

Line 685: l_s_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

681: l_ci_type_name pa_ci_types_tl.short_name%type;
682: l_count number;
683: l_token_ci_id pa_control_items.ci_id%type;
684: l_tsk_plan_level_mismatch VARCHAR2(1) := 'N';
685: l_s_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
686: l_t_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
687: l_s_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
688: l_t_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
689: l_targ_pt_name pa_fin_plan_types_tl.name%TYPE;

Line 686: l_t_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

682: l_count number;
683: l_token_ci_id pa_control_items.ci_id%type;
684: l_tsk_plan_level_mismatch VARCHAR2(1) := 'N';
685: l_s_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
686: l_t_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
687: l_s_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
688: l_t_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
689: l_targ_pt_name pa_fin_plan_types_tl.name%TYPE;
690: l_src_ci_number pa_control_items.ci_number%TYPE;

Line 687: l_s_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

683: l_token_ci_id pa_control_items.ci_id%type;
684: l_tsk_plan_level_mismatch VARCHAR2(1) := 'N';
685: l_s_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
686: l_t_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
687: l_s_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
688: l_t_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
689: l_targ_pt_name pa_fin_plan_types_tl.name%TYPE;
690: l_src_ci_number pa_control_items.ci_number%TYPE;
691: l_module_name varchar2(30) := 'check is possible';

Line 688: l_t_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

684: l_tsk_plan_level_mismatch VARCHAR2(1) := 'N';
685: l_s_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
686: l_t_task_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
687: l_s_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
688: l_t_fin_plan_level_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
689: l_targ_pt_name pa_fin_plan_types_tl.name%TYPE;
690: l_src_ci_number pa_control_items.ci_number%TYPE;
691: l_module_name varchar2(30) := 'check is possible';
692:

Line 3232: l_ci_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

3228: FROM pa_budget_versions
3229: WHERE project_id = p_project_id AND
3230: nvl(ci_id,-1) = p_ci_id;
3231:
3232: l_ci_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
3233: l_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
3234: l_fin_plan_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
3235: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3236: l_curr_work_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;

Line 3233: l_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

3229: WHERE project_id = p_project_id AND
3230: nvl(ci_id,-1) = p_ci_id;
3231:
3232: l_ci_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
3233: l_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
3234: l_fin_plan_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
3235: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3236: l_curr_work_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;
3237: l_attr_same_flag VARCHAR2(1);

Line 3234: l_fin_plan_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

3230: nvl(ci_id,-1) = p_ci_id;
3231:
3232: l_ci_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
3233: l_version_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
3234: l_fin_plan_type_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
3235: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3236: l_curr_work_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;
3237: l_attr_same_flag VARCHAR2(1);
3238:

Line 4009: x_s_task_id_tbl OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

4005: p_s_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
4006: p_t_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
4007: p_calling_mode in varchar2,
4008: x_tsk_plan_level_mismatch OUT NOCOPY varchar2, --File.Sql.39 bug 4440895
4009: x_s_task_id_tbl OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
4010: x_t_task_id_tbl OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
4011: x_s_fin_plan_level_tbl OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
4012: x_t_fin_plan_level_tbl OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
4013: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 4010: x_t_task_id_tbl OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

4006: p_t_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
4007: p_calling_mode in varchar2,
4008: x_tsk_plan_level_mismatch OUT NOCOPY varchar2, --File.Sql.39 bug 4440895
4009: x_s_task_id_tbl OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
4010: x_t_task_id_tbl OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
4011: x_s_fin_plan_level_tbl OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
4012: x_t_fin_plan_level_tbl OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
4013: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4014: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 4011: x_s_fin_plan_level_tbl OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

4007: p_calling_mode in varchar2,
4008: x_tsk_plan_level_mismatch OUT NOCOPY varchar2, --File.Sql.39 bug 4440895
4009: x_s_task_id_tbl OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
4010: x_t_task_id_tbl OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
4011: x_s_fin_plan_level_tbl OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
4012: x_t_fin_plan_level_tbl OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
4013: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4014: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4015: x_return_status OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895

Line 4012: x_t_fin_plan_level_tbl OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

4008: x_tsk_plan_level_mismatch OUT NOCOPY varchar2, --File.Sql.39 bug 4440895
4009: x_s_task_id_tbl OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
4010: x_t_task_id_tbl OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
4011: x_s_fin_plan_level_tbl OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
4012: x_t_fin_plan_level_tbl OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
4013: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4014: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4015: x_return_status OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
4016: l_count number;

Line 7564: l_impact_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

7560: 'FINPLAN_COST',
7561: 'FINPLAN_REVENUE')
7562: ORDER BY impact_type_code;
7563:
7564: l_impact_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7565:
7566: BEGIN
7567: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
7568: