DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS dependencies on USER_OBJECTS

Line 3645: FROM user_objects uo

3641: CURSOR c_objs IS
3642: SELECT uo.object_name name,
3643: uo.object_type type,
3644: uo.status status
3645: FROM user_objects uo
3646: WHERE (uo.object_name LIKE 'WF%'
3647: OR uo.object_name LIKE 'ECX%'
3648: OR uo.object_name LIKE 'FND_SVC_%')
3649: AND uo.object_type IN ('PACKAGE', 'PACKAGE BODY')

Line 3715: FROM user_objects

3711: AND object_type = 'PACKAGE'
3712: AND (owner in ('SYS', 'SYSTEM') OR owner = g_qowner)
3713: UNION
3714: SELECT status, user
3715: FROM user_objects
3716: WHERE object_name = 'XMLDOM'
3717: AND object_type = 'PACKAGE';
3718:
3719: CURSOR c_java IS

Line 3727: FROM user_objects

3723: AND object_name like '%xmlparser%'
3724: AND (owner in ('SYS', 'SYSTEM') OR owner = g_qowner)
3725: UNION
3726: SELECT object_name, status, user
3727: FROM user_objects
3728: WHERE object_type = 'JAVA RESOURCE'
3729: AND object_name like '%xmlparser%';
3730:
3731: dom_rec c_dom%ROWTYPE;