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_RESOURCE_LISTS_ALL_BG

Line 455: x_uncategorized_flag OUT NOCOPY pa_resource_lists_all_bg.uncategorized_flag%TYPE, --File.Sql.39 bug 4440895

451: x_multi_curr_flag OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE, --File.Sql.39 bug 4440895
452: x_fin_plan_level_code OUT NOCOPY pa_proj_fp_options.all_fin_plan_level_code%TYPE, --File.Sql.39 bug 4440895
453: x_resource_list_id OUT NOCOPY pa_proj_fp_options.all_resource_list_id%TYPE, --File.Sql.39 bug 4440895
454: x_time_phased_code OUT NOCOPY pa_proj_fp_options.all_time_phased_code%TYPE, --File.Sql.39 bug 4440895
455: x_uncategorized_flag OUT NOCOPY pa_resource_lists_all_bg.uncategorized_flag%TYPE, --File.Sql.39 bug 4440895
456: x_group_res_type_id OUT NOCOPY pa_resource_lists_all_bg.group_resource_type_id%TYPE, --File.Sql.39 bug 4440895
457: x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE, --File.Sql.39 bug 4440895
458: x_ci_id OUT NOCOPY pa_budget_versions.ci_id%TYPE, --File.Sql.39 bug 4440895
459: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 456: x_group_res_type_id OUT NOCOPY pa_resource_lists_all_bg.group_resource_type_id%TYPE, --File.Sql.39 bug 4440895

452: x_fin_plan_level_code OUT NOCOPY pa_proj_fp_options.all_fin_plan_level_code%TYPE, --File.Sql.39 bug 4440895
453: x_resource_list_id OUT NOCOPY pa_proj_fp_options.all_resource_list_id%TYPE, --File.Sql.39 bug 4440895
454: x_time_phased_code OUT NOCOPY pa_proj_fp_options.all_time_phased_code%TYPE, --File.Sql.39 bug 4440895
455: x_uncategorized_flag OUT NOCOPY pa_resource_lists_all_bg.uncategorized_flag%TYPE, --File.Sql.39 bug 4440895
456: x_group_res_type_id OUT NOCOPY pa_resource_lists_all_bg.group_resource_type_id%TYPE, --File.Sql.39 bug 4440895
457: x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE, --File.Sql.39 bug 4440895
458: x_ci_id OUT NOCOPY pa_budget_versions.ci_id%TYPE, --File.Sql.39 bug 4440895
459: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
460: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 553: FROM pa_resource_lists_all_bg pr

549: NVL(pr.group_resource_type_id,0)
550: INTO
551: x_uncategorized_flag,
552: x_group_res_type_id
553: FROM pa_resource_lists_all_bg pr
554: WHERE pr.resource_list_id = x_resource_list_id;
555:
556: EXCEPTION
557: WHEN OTHERS THEN

Line 607: l_s_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;

603: l_s_multi_curr_flag pa_proj_fp_options. plan_in_multi_curr_flag%TYPE;
604: l_s_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
605: l_s_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
606: l_s_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
607: l_s_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
608: l_s_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
609: l_s_version_type pa_budget_versions.version_type%TYPE;
610: l_s_ci_id pa_budget_versions.ci_id%TYPE;
611:

Line 608: l_s_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;

604: l_s_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
605: l_s_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
606: l_s_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
607: l_s_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
608: l_s_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
609: l_s_version_type pa_budget_versions.version_type%TYPE;
610: l_s_ci_id pa_budget_versions.ci_id%TYPE;
611:
612: --Defining Local variables for target version

Line 619: l_t_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;

615: l_t_multi_curr_flag pa_proj_fp_options. plan_in_multi_curr_flag%TYPE;
616: l_t_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
617: l_t_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
618: l_t_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
619: l_t_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
620: l_t_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
621: l_t_version_type pa_budget_versions.version_type%TYPE;
622: l_t_ci_id pa_budget_versions.ci_id%TYPE;
623:

Line 620: l_t_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;

616: l_t_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
617: l_t_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
618: l_t_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
619: l_t_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
620: l_t_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
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

Line 9164: l_ci_resource_list_id1 pa_resource_lists_all_bg.resource_list_id%TYPE;

9160: --End of variables used for debugging
9161: l_cost_ci_version_id pa_budget_versions.budget_version_id%TYPE;
9162: l_rev_ci_version_id pa_budget_versions.budget_version_id%TYPE;
9163: l_all_ci_version_id pa_budget_versions.budget_version_id%TYPE;
9164: l_ci_resource_list_id1 pa_resource_lists_all_bg.resource_list_id%TYPE;
9165: l_ci_resource_list_id2 pa_resource_lists_all_bg.resource_list_id%TYPE;
9166: l_targ_resource_list_id1 pa_resource_lists_all_bg.resource_list_id%TYPE;
9167: l_targ_resource_list_id2 pa_resource_lists_all_bg.resource_list_id%TYPE;
9168: l_dummy VARCHAR2(1);

Line 9165: l_ci_resource_list_id2 pa_resource_lists_all_bg.resource_list_id%TYPE;

9161: l_cost_ci_version_id pa_budget_versions.budget_version_id%TYPE;
9162: l_rev_ci_version_id pa_budget_versions.budget_version_id%TYPE;
9163: l_all_ci_version_id pa_budget_versions.budget_version_id%TYPE;
9164: l_ci_resource_list_id1 pa_resource_lists_all_bg.resource_list_id%TYPE;
9165: l_ci_resource_list_id2 pa_resource_lists_all_bg.resource_list_id%TYPE;
9166: l_targ_resource_list_id1 pa_resource_lists_all_bg.resource_list_id%TYPE;
9167: l_targ_resource_list_id2 pa_resource_lists_all_bg.resource_list_id%TYPE;
9168: l_dummy VARCHAR2(1);
9169:

Line 9166: l_targ_resource_list_id1 pa_resource_lists_all_bg.resource_list_id%TYPE;

9162: l_rev_ci_version_id pa_budget_versions.budget_version_id%TYPE;
9163: l_all_ci_version_id pa_budget_versions.budget_version_id%TYPE;
9164: l_ci_resource_list_id1 pa_resource_lists_all_bg.resource_list_id%TYPE;
9165: l_ci_resource_list_id2 pa_resource_lists_all_bg.resource_list_id%TYPE;
9166: l_targ_resource_list_id1 pa_resource_lists_all_bg.resource_list_id%TYPE;
9167: l_targ_resource_list_id2 pa_resource_lists_all_bg.resource_list_id%TYPE;
9168: l_dummy VARCHAR2(1);
9169:
9170: CURSOR c_ci_merge_csr(c_version_type pa_budget_Versions.version_type%TYPE,

Line 9167: l_targ_resource_list_id2 pa_resource_lists_all_bg.resource_list_id%TYPE;

9163: l_all_ci_version_id pa_budget_versions.budget_version_id%TYPE;
9164: l_ci_resource_list_id1 pa_resource_lists_all_bg.resource_list_id%TYPE;
9165: l_ci_resource_list_id2 pa_resource_lists_all_bg.resource_list_id%TYPE;
9166: l_targ_resource_list_id1 pa_resource_lists_all_bg.resource_list_id%TYPE;
9167: l_targ_resource_list_id2 pa_resource_lists_all_bg.resource_list_id%TYPE;
9168: l_dummy VARCHAR2(1);
9169:
9170: CURSOR c_ci_merge_csr(c_version_type pa_budget_Versions.version_type%TYPE,
9171: c_ci_version_id pa_budget_Versions.budget_Version_id%TYPE,