DBA Data[Home] [Help]

APPS.BOM_VALIDATE dependencies on ALL_OBJECTS

Line 271: schema_name all_objects.owner%type := 'APPS';

267: FUNCTION Object_Exists(p_object_type VARCHAR2,p_object_name VARCHAR2)
268: RETURN VARCHAR2 IS
269: l_exists VARCHAR2(1) := 'N';
270: --- changed datatype for schema_name ,bug 9952014
271: schema_name all_objects.owner%type := 'APPS';
272: CURSOR c_check_object(cp_object_type VARCHAR2, cp_object_name VARCHAR2)IS
273: SELECT 'Y'
274: FROM all_objects
275: WHERE object_type = cp_object_type

Line 274: FROM all_objects

270: --- changed datatype for schema_name ,bug 9952014
271: schema_name all_objects.owner%type := 'APPS';
272: CURSOR c_check_object(cp_object_type VARCHAR2, cp_object_name VARCHAR2)IS
273: SELECT 'Y'
274: FROM all_objects
275: WHERE object_type = cp_object_type
276: AND owner = schema_name
277: AND object_name = cp_object_name
278: AND status = 'VALID';