DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS dependencies on USER_OBJECTS

Line 3294: FROM user_objects uo

3290: CURSOR c_objs IS
3291: SELECT uo.object_name name,
3292: uo.object_type type,
3293: uo.status status
3294: FROM user_objects uo
3295: WHERE (uo.object_name LIKE 'WF%'
3296: OR uo.object_name LIKE 'ECX%'
3297: OR uo.object_name LIKE 'FND_SVC_%')
3298: AND uo.object_type IN ('PACKAGE', 'PACKAGE BODY')

Line 3364: FROM user_objects

3360: AND object_type = 'PACKAGE'
3361: AND (owner in ('SYS', 'SYSTEM') OR owner = g_qowner)
3362: UNION
3363: SELECT status, user
3364: FROM user_objects
3365: WHERE object_name = 'XMLDOM'
3366: AND object_type = 'PACKAGE';
3367:
3368: CURSOR c_java IS

Line 3376: FROM user_objects

3372: AND object_name like '%xmlparser%'
3373: AND (owner in ('SYS', 'SYSTEM') OR owner = g_qowner)
3374: UNION
3375: SELECT object_name, status, user
3376: FROM user_objects
3377: WHERE object_type = 'JAVA RESOURCE'
3378: AND object_name like '%xmlparser%';
3379:
3380: dom_rec c_dom%ROWTYPE;