APPS.PA_FP_VIEW_PLANS_UTIL dependencies on PA_RESOURCE_LISTS

Line 408: from pa_resource_lists

404: -- resource is RESOURCE CHILD: PARENT = RESOURCE GROUP NAME
405: /*
406: select name
407: into l_return_value
408: from pa_resource_lists
409: where resource_list_id = l_resource_list_id;
410: */
411: select alias
412: into l_return_value

Line 441: from pa_resource_lists

437: -- this resource is a RESOURCE CHILD: so PARENT = RESOURCE GROUP NAME
438: /*
439: select name
440: into l_return_value
441: from pa_resource_lists
442: where resource_list_id = l_resource_list_id;
443: */
444: select alias
445: into l_return_value

Line 462: from pa_resource_lists

458: -- this resource is a RESOURCE CHILD: PARENT = RESOURCE GROUP NAME
459: /*
460: select name
461: into l_return_value
462: from pa_resource_lists
463: where resource_list_id = l_resource_list_id;
464: */
465: select alias
466: into l_return_value

Line 542: from pa_resource_lists

538: -- get RESOURCE GROUP NAME
539: /*
540: select name
541: into l_return_value
542: from pa_resource_lists
543: where resource_list_id = l_resource_list_id;
544: */
545: select alias
546: into l_return_value

Line 671: from pa_resource_lists

667: -- make sure that the element is a resource group (ie. does not have parent member)
668: if l_res_parent_member_id = -99 then
669: select name
670: into l_return_value
671: from pa_resource_lists
672: where resource_list_id = l_resource_list_id;
673: end if;
674: end if; -- p_element_type = 'RESOURCE'
675: end if;

Line 5150: l_group_resource_type_id pa_resource_lists.group_resource_type_id%TYPE;

5146: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
5147: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
5148: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
5149:
5150: l_group_resource_type_id pa_resource_lists.group_resource_type_id%TYPE;
5151: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE; -- bug 3081511
5152: l_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
5153: l_prj_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
5154: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 5151: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE; -- bug 3081511

5147: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
5148: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
5149:
5150: l_group_resource_type_id pa_resource_lists.group_resource_type_id%TYPE;
5151: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE; -- bug 3081511
5152: l_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
5153: l_prj_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
5154: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
5155: l_version_type pa_budget_versions.version_type%TYPE;

Line 5157: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;

5153: l_prj_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
5154: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
5155: l_version_type pa_budget_versions.version_type%TYPE;
5156: l_resource_level VARCHAR2(1); -- used to store temp value of return variable
5157: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
5158:
5159: cursor c1(c_fp_opt_id number,
5160: c_ver_type varchar2) is
5161: select fpe.task_id,

Line 5189: pa_resource_lists_all_bg rl

5185: into l_group_resource_type_id,
5186: l_uncategorized_flag,
5187: l_resource_list_id
5188: from pa_budget_versions bv,
5189: pa_resource_lists_all_bg rl
5190: where bv.budget_version_id = p_budget_version_id
5191: and bv.resource_list_id = rl.resource_list_id;
5192:
5193: if l_group_resource_type_id = 0 then