DBA Data[Home] [Help]

APPS.PA_ALLOC_UTILS dependencies on PA_RBS_HEADERS_V

Line 462: FUNCTION Is_RBS_In_Rules ( P_RBS_ID IN pa_rbs_headers_v.RBS_HEADER_ID%Type ) RETURN VARCHAR2

458: API Desc : Return 'Y' if RBS is used in Allocations.
459: API Created Date : 19-Mar-04
460: API Created By : Vthakkar
461: */
462: FUNCTION Is_RBS_In_Rules ( P_RBS_ID IN pa_rbs_headers_v.RBS_HEADER_ID%Type ) RETURN VARCHAR2
463: IS
464: l_exists Varchar2(1) := 'N';
465: BEGIN
466: /* Checking PA_ALLOC_RULES_ALL */

Line 782: From pa_rbs_headers_v

778: Where RESOURCE_LIST_ID = p_resource_list_id;
779: Elsif Nvl(p_Resource_Struct_Type,'RL') = 'RBS' Then
780: Select Name
781: Into X_Resource_List_Name
782: From pa_rbs_headers_v
783: Where RBS_HEADER_ID = p_resource_list_id;
784: End If;
785: Return X_Resource_List_Name;
786: Exception