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_WEBADI_UTILS dependencies on PA_RESOURCE_LISTS

Line 34: l_uncategorized_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;

30: IS
31: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
32: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
33: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
34: l_uncategorized_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
35: l_group_resource_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
36: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
37: l_project_id pa_proj_fp_options.project_id%TYPE;
38: l_cost_layout_code pa_proj_fp_options.cost_layout_code%TYPE;

Line 35: l_group_resource_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;

31: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
32: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
33: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
34: l_uncategorized_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
35: l_group_resource_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
36: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
37: l_project_id pa_proj_fp_options.project_id%TYPE;
38: l_cost_layout_code pa_proj_fp_options.cost_layout_code%TYPE;
39: l_revenue_layout_code pa_proj_fp_options.revenue_layout_code%TYPE;

Line 69: -- 4497318.Perf Fix: The View name pa_resource_lists is reolaced by Table name pa_resource_lists_all_bg in the FROM clause.

65:
66:
67: BEGIN
68:
69: -- 4497318.Perf Fix: The View name pa_resource_lists is reolaced by Table name pa_resource_lists_all_bg in the FROM clause.
70: SELECT a.GROUP_RESOURCE_TYPE_ID,a.UNCATEGORIZED_FLAG,b.current_working_flag
71: INTO l_group_resource_type_id,l_uncategorized_flag,l_current_working_flag
72: FROM pa_resource_lists_all_bg a, pa_budget_versions b
73: WHERE b.budget_version_id = p_budget_version_id

Line 72: FROM pa_resource_lists_all_bg a, pa_budget_versions b

68:
69: -- 4497318.Perf Fix: The View name pa_resource_lists is reolaced by Table name pa_resource_lists_all_bg in the FROM clause.
70: SELECT a.GROUP_RESOURCE_TYPE_ID,a.UNCATEGORIZED_FLAG,b.current_working_flag
71: INTO l_group_resource_type_id,l_uncategorized_flag,l_current_working_flag
72: FROM pa_resource_lists_all_bg a, pa_budget_versions b
73: WHERE b.budget_version_id = p_budget_version_id
74: AND a.RESOURCE_LIST_ID = b.resource_list_id;
75:
76: SELECT FIN_PLAN_PREFERENCE_CODE

Line 602: l_uncategorized_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;

598: l_rlm_id_alias NUMBER;
599: l_project_id NUMBER;
600: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
601: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
602: l_uncategorized_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
603: l_group_resource_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
604: l_row_id ROWID;
605: ll_error_flag VARCHAR2(1);
606: l_track_as_labor_flag PA_RESOURCE_LIST_MEMBERS.TRACK_AS_LABOR_FLAG%TYPE;

Line 603: l_group_resource_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;

599: l_project_id NUMBER;
600: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
601: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
602: l_uncategorized_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
603: l_group_resource_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
604: l_row_id ROWID;
605: ll_error_flag VARCHAR2(1);
606: l_track_as_labor_flag PA_RESOURCE_LIST_MEMBERS.TRACK_AS_LABOR_FLAG%TYPE;
607: l_dummy_res_list_id NUMBER;

Line 623: -- 4497318.Perf Fix.The View name pa_resource_lists is replaced by Table name pa_resource_lists_all_bg in the FROM clause.

619: into l_resource_list_id,l_project_id
620: from pa_budget_versions
621: where budget_version_id = p_budget_version_id;
622:
623: -- 4497318.Perf Fix.The View name pa_resource_lists is replaced by Table name pa_resource_lists_all_bg in the FROM clause.
624: SELECT GROUP_RESOURCE_TYPE_ID,UNCATEGORIZED_FLAG
625: INTO l_group_resource_type_id,l_uncategorized_flag
626: FROM pa_resource_lists_all_bg
627: WHERE RESOURCE_LIST_ID = l_resource_list_id;

Line 626: FROM pa_resource_lists_all_bg

622:
623: -- 4497318.Perf Fix.The View name pa_resource_lists is replaced by Table name pa_resource_lists_all_bg in the FROM clause.
624: SELECT GROUP_RESOURCE_TYPE_ID,UNCATEGORIZED_FLAG
625: INTO l_group_resource_type_id,l_uncategorized_flag
626: FROM pa_resource_lists_all_bg
627: WHERE RESOURCE_LIST_ID = l_resource_list_id;
628:
629: If l_uncategorized_flag <> 'Y' Then
630: -- check if plan by resource or by non-resource

Line 775: ,pa_resource_lists_all_bg prl

771: FROM pa_tasks pt
772: ,pa_resource_assignments pra
773: ,pa_resource_list_members prlm
774: ,pa_resource_list_members prlm_parent
775: ,pa_resource_lists_all_bg prl
776: WHERE pra.resource_assignment_id = c_resource_assignment_id
777: AND pra.project_id = pt.project_id
778: AND pra.task_id = pt.task_id
779: AND prlm.resource_list_member_id = pra.resource_list_member_id

Line 799: ,pa_resource_lists_all_bg prl

795: ,prlm.resource_id
796: FROM pa_resource_assignments pra
797: ,pa_resource_list_members prlm
798: ,pa_resource_list_members prlm_parent
799: ,pa_resource_lists_all_bg prl
800: WHERE pra.resource_assignment_id = c_resource_assignment_id
801: AND prlm.resource_list_member_id = pra.resource_list_member_id
802: AND prl.resource_list_id = prlm.resource_list_id
803: AND prlm.parent_member_id = prlm_parent.resource_list_member_id(+);