DBA Data[Home] [Help]

APPS.ASG_COMPILE_PKG dependencies on USER_OBJECTS

Line 161: select object_name, object_type from user_objects

157:
158: -- compile package specifications first, then views, then bodies
159: -- this is because a view could reference a package header
160: cursor c1 is
161: select object_name, object_type from user_objects
162: where status = 'INVALID'
163: and object_type = 'PACKAGE' ;
164:
165: cursor c2 is

Line 166: select object_name, object_type from user_objects

162: where status = 'INVALID'
163: and object_type = 'PACKAGE' ;
164:
165: cursor c2 is
166: select object_name, object_type from user_objects
167: where status = 'INVALID'
168: and object_type = 'VIEW' ;
169:
170: --