APPS.PA_FP_VIEW_PLANS_UTIL dependencies on PA_RESOURCE_LISTS

Line 406: from pa_resource_lists

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

Line 439: from pa_resource_lists

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

Line 460: from pa_resource_lists

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

Line 540: from pa_resource_lists

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

Line 669: from pa_resource_lists

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

Line 4980: l_group_resource_type_id pa_resource_lists.group_resource_type_id%TYPE;

4976: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4977: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4978: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
4979:
4980: l_group_resource_type_id pa_resource_lists.group_resource_type_id%TYPE;
4981: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE; -- bug 3081511
4982: l_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
4983: l_prj_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
4984: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

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

4977: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4978: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
4979:
4980: l_group_resource_type_id pa_resource_lists.group_resource_type_id%TYPE;
4981: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE; -- bug 3081511
4982: l_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
4983: l_prj_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
4984: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4985: l_version_type pa_budget_versions.version_type%TYPE;

Line 4987: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;

4983: l_prj_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
4984: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4985: l_version_type pa_budget_versions.version_type%TYPE;
4986: l_resource_level VARCHAR2(1); -- used to store temp value of return variable
4987: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
4988:
4989: cursor c1(c_fp_opt_id number,
4990: c_ver_type varchar2) is
4991: select fpe.task_id,

Line 5019: pa_resource_lists_all_bg rl

5015: into l_group_resource_type_id,
5016: l_uncategorized_flag,
5017: l_resource_list_id
5018: from pa_budget_versions bv,
5019: pa_resource_lists_all_bg rl
5020: where bv.budget_version_id = p_budget_version_id
5021: and bv.resource_list_id = rl.resource_list_id;
5022:
5023: if l_group_resource_type_id = 0 then