APPS.PA_ALLOC_UTILS dependencies on PA_ALLOC_UTILS

Line 1: PACKAGE BODY PA_ALLOC_UTILS AS

1: PACKAGE BODY PA_ALLOC_UTILS AS
2: /* $Header: PAXALUTB.pls 120.1.12010000.3 2009/11/30 12:30:37 rrambati ship $ */
3:
4: ------------------------------------------------------------------------
5: --- is_resource_in_rules

Line 606: Select pa_alloc_utils.Get_Resource_Name_TL (RBS_ELEMENT_NAME_ID)

602: Into X_name
603: from pa_resource_list_members prlm
604: where prlm.resource_list_member_id = p_resource_id;
605: Elsif l_source_res_struct_type = 'RBS' Then
606: Select pa_alloc_utils.Get_Resource_Name_TL (RBS_ELEMENT_NAME_ID)
607: Into X_name
608: From pa_rbs_elements
609: Where rbs_element_id = p_resource_id
610: And rownum = 1;

Line 620: select pa_alloc_utils.Get_Resource_Name_TL (RBS_ELEMENT_NAME_ID)

616: Into X_name
617: from pa_resource_list_members prlm
618: where prlm.resource_list_member_id = p_resource_id;
619: Elsif l_basis_res_struct_type = 'RBS' Then
620: select pa_alloc_utils.Get_Resource_Name_TL (RBS_ELEMENT_NAME_ID)
621: Into X_name
622: from pa_rbs_elements
623: where rbs_element_id = p_resource_id
624: and rownum = 1;

Line 812: IS SELECT pa_alloc_utils.Get_Resource_Name_TL(ele.rbs_element_name_id) Resource_Name

808: from pa_resource_list_members slf , pa_resource_list_members prt
809: Where prt.resource_list_member_id (+) = slf.parent_member_id
810: and slf.resource_list_member_id = p_resource_id;
811: Cursor c_element_name
812: IS SELECT pa_alloc_utils.Get_Resource_Name_TL(ele.rbs_element_name_id) Resource_Name
813: FROM pa_rbs_elements ele
814: CONNECT BY PRIOR ele.parent_element_id = ele.rbs_element_id
815: START WITH ele.rbs_element_id = p_resource_id
816: ORDER BY ele.rbs_level DESC;

Line 909: END pa_alloc_utils ;

905: Return Null;
906: End Get_Resource_Name_TL;
907:
908:
909: END pa_alloc_utils ;