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

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

475: x_multi_curr_flag OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE, --File.Sql.39 bug 4440895
476: x_fin_plan_level_code OUT NOCOPY pa_proj_fp_options.all_fin_plan_level_code%TYPE, --File.Sql.39 bug 4440895
477: x_resource_list_id OUT NOCOPY pa_proj_fp_options.all_resource_list_id%TYPE, --File.Sql.39 bug 4440895
478: x_time_phased_code OUT NOCOPY pa_proj_fp_options.all_time_phased_code%TYPE, --File.Sql.39 bug 4440895
479: x_uncategorized_flag OUT NOCOPY pa_resource_lists_all_bg.uncategorized_flag%TYPE, --File.Sql.39 bug 4440895
480: x_group_res_type_id OUT NOCOPY pa_resource_lists_all_bg.group_resource_type_id%TYPE, --File.Sql.39 bug 4440895
481: x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE, --File.Sql.39 bug 4440895
482: x_ci_id OUT NOCOPY pa_budget_versions.ci_id%TYPE, --File.Sql.39 bug 4440895
483: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

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

476: x_fin_plan_level_code OUT NOCOPY pa_proj_fp_options.all_fin_plan_level_code%TYPE, --File.Sql.39 bug 4440895
477: x_resource_list_id OUT NOCOPY pa_proj_fp_options.all_resource_list_id%TYPE, --File.Sql.39 bug 4440895
478: x_time_phased_code OUT NOCOPY pa_proj_fp_options.all_time_phased_code%TYPE, --File.Sql.39 bug 4440895
479: x_uncategorized_flag OUT NOCOPY pa_resource_lists_all_bg.uncategorized_flag%TYPE, --File.Sql.39 bug 4440895
480: x_group_res_type_id OUT NOCOPY pa_resource_lists_all_bg.group_resource_type_id%TYPE, --File.Sql.39 bug 4440895
481: x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE, --File.Sql.39 bug 4440895
482: x_ci_id OUT NOCOPY pa_budget_versions.ci_id%TYPE, --File.Sql.39 bug 4440895
483: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
484: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 577: FROM pa_resource_lists_all_bg pr

573: NVL(pr.group_resource_type_id,0)
574: INTO
575: x_uncategorized_flag,
576: x_group_res_type_id
577: FROM pa_resource_lists_all_bg pr
578: WHERE pr.resource_list_id = x_resource_list_id;
579:
580: EXCEPTION
581: WHEN OTHERS THEN

Line 631: l_s_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;

627: l_s_multi_curr_flag pa_proj_fp_options. plan_in_multi_curr_flag%TYPE;
628: l_s_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
629: l_s_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
630: l_s_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
631: l_s_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
632: l_s_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
633: l_s_version_type pa_budget_versions.version_type%TYPE;
634: l_s_ci_id pa_budget_versions.ci_id%TYPE;
635:

Line 632: l_s_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;

628: l_s_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
629: l_s_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
630: l_s_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
631: l_s_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
632: l_s_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
633: l_s_version_type pa_budget_versions.version_type%TYPE;
634: l_s_ci_id pa_budget_versions.ci_id%TYPE;
635:
636: --Defining Local variables for target version

Line 643: l_t_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;

639: l_t_multi_curr_flag pa_proj_fp_options. plan_in_multi_curr_flag%TYPE;
640: l_t_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
641: l_t_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
642: l_t_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
643: l_t_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
644: l_t_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
645: l_t_version_type pa_budget_versions.version_type%TYPE;
646: l_t_ci_id pa_budget_versions.ci_id%TYPE;
647:

Line 644: l_t_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;

640: l_t_time_phased_code pa_proj_fp_options. all_time_phased_code%TYPE;
641: l_t_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
642: l_t_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
643: l_t_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag %TYPE;
644: l_t_group_res_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
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

Line 1832: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;

1828: l_return_status VARCHAR2(2000);
1829: l_debug_mode VARCHAR2(30);
1830: l_module_name VARCHAR2(100) := 'pa.plsql.Pa_Fp_Control_Items_Utils';
1831:
1832: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
1833: l_group_resource_type_id pa_resource_lists.group_resource_type_id%TYPE;
1834: l_resource_list_id pa_resource_lists.resource_list_id%TYPE;
1835: l_grouped_flag VARCHAR2(1); --indicates if resource_list is grouped
1836:

Line 1833: l_group_resource_type_id pa_resource_lists.group_resource_type_id%TYPE;

1829: l_debug_mode VARCHAR2(30);
1830: l_module_name VARCHAR2(100) := 'pa.plsql.Pa_Fp_Control_Items_Utils';
1831:
1832: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
1833: l_group_resource_type_id pa_resource_lists.group_resource_type_id%TYPE;
1834: l_resource_list_id pa_resource_lists.resource_list_id%TYPE;
1835: l_grouped_flag VARCHAR2(1); --indicates if resource_list is grouped
1836:
1837: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 1834: l_resource_list_id pa_resource_lists.resource_list_id%TYPE;

1830: l_module_name VARCHAR2(100) := 'pa.plsql.Pa_Fp_Control_Items_Utils';
1831:
1832: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
1833: l_group_resource_type_id pa_resource_lists.group_resource_type_id%TYPE;
1834: l_resource_list_id pa_resource_lists.resource_list_id%TYPE;
1835: l_grouped_flag VARCHAR2(1); --indicates if resource_list is grouped
1836:
1837: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1838:

Line 9322: l_ci_resource_list_id1 pa_resource_lists_all_bg.resource_list_id%TYPE;

9318: --End of variables used for debugging
9319: l_cost_ci_version_id pa_budget_versions.budget_version_id%TYPE;
9320: l_rev_ci_version_id pa_budget_versions.budget_version_id%TYPE;
9321: l_all_ci_version_id pa_budget_versions.budget_version_id%TYPE;
9322: l_ci_resource_list_id1 pa_resource_lists_all_bg.resource_list_id%TYPE;
9323: l_ci_resource_list_id2 pa_resource_lists_all_bg.resource_list_id%TYPE;
9324: l_targ_resource_list_id1 pa_resource_lists_all_bg.resource_list_id%TYPE;
9325: l_targ_resource_list_id2 pa_resource_lists_all_bg.resource_list_id%TYPE;
9326: l_dummy VARCHAR2(1);

Line 9323: l_ci_resource_list_id2 pa_resource_lists_all_bg.resource_list_id%TYPE;

9319: l_cost_ci_version_id pa_budget_versions.budget_version_id%TYPE;
9320: l_rev_ci_version_id pa_budget_versions.budget_version_id%TYPE;
9321: l_all_ci_version_id pa_budget_versions.budget_version_id%TYPE;
9322: l_ci_resource_list_id1 pa_resource_lists_all_bg.resource_list_id%TYPE;
9323: l_ci_resource_list_id2 pa_resource_lists_all_bg.resource_list_id%TYPE;
9324: l_targ_resource_list_id1 pa_resource_lists_all_bg.resource_list_id%TYPE;
9325: l_targ_resource_list_id2 pa_resource_lists_all_bg.resource_list_id%TYPE;
9326: l_dummy VARCHAR2(1);
9327:

Line 9324: l_targ_resource_list_id1 pa_resource_lists_all_bg.resource_list_id%TYPE;

9320: l_rev_ci_version_id pa_budget_versions.budget_version_id%TYPE;
9321: l_all_ci_version_id pa_budget_versions.budget_version_id%TYPE;
9322: l_ci_resource_list_id1 pa_resource_lists_all_bg.resource_list_id%TYPE;
9323: l_ci_resource_list_id2 pa_resource_lists_all_bg.resource_list_id%TYPE;
9324: l_targ_resource_list_id1 pa_resource_lists_all_bg.resource_list_id%TYPE;
9325: l_targ_resource_list_id2 pa_resource_lists_all_bg.resource_list_id%TYPE;
9326: l_dummy VARCHAR2(1);
9327:
9328: CURSOR c_ci_merge_csr(c_version_type pa_budget_Versions.version_type%TYPE,

Line 9325: l_targ_resource_list_id2 pa_resource_lists_all_bg.resource_list_id%TYPE;

9321: l_all_ci_version_id pa_budget_versions.budget_version_id%TYPE;
9322: l_ci_resource_list_id1 pa_resource_lists_all_bg.resource_list_id%TYPE;
9323: l_ci_resource_list_id2 pa_resource_lists_all_bg.resource_list_id%TYPE;
9324: l_targ_resource_list_id1 pa_resource_lists_all_bg.resource_list_id%TYPE;
9325: l_targ_resource_list_id2 pa_resource_lists_all_bg.resource_list_id%TYPE;
9326: l_dummy VARCHAR2(1);
9327:
9328: CURSOR c_ci_merge_csr(c_version_type pa_budget_Versions.version_type%TYPE,
9329: c_ci_version_id pa_budget_Versions.budget_Version_id%TYPE,