DBA Data[Home] [Help]

APPS.PA_ALLOC_UTILS dependencies on PA_RBS_HEADERS_V

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

445: API Desc : Return 'Y' if RBS is used in Allocations.
446: API Created Date : 19-Mar-04
447: API Created By : Vthakkar
448: */
449: FUNCTION Is_RBS_In_Rules ( P_RBS_ID IN pa_rbs_headers_v.RBS_HEADER_ID%Type ) RETURN VARCHAR2
450: IS
451: l_exists Varchar2(1) := 'N';
452: BEGIN
453: /* Checking PA_ALLOC_RULES_ALL */

Line 769: From pa_rbs_headers_v

765: Where RESOURCE_LIST_ID = p_resource_list_id;
766: Elsif Nvl(p_Resource_Struct_Type,'RL') = 'RBS' Then
767: Select Name
768: Into X_Resource_List_Name
769: From pa_rbs_headers_v
770: Where RBS_HEADER_ID = p_resource_list_id;
771: End If;
772: Return X_Resource_List_Name;
773: Exception