APPS.ASG_COMPILE_PKG dependencies on ALL_OBJECTS

Line 9: PROCEDURE compile_all_objects (schema_name in VARCHAR2) as

5:
6: -- Dec 30, 2003 yazhang add overload method
7: -- JULY 24, 2002 ytian created.
8:
9: PROCEDURE compile_all_objects (schema_name in VARCHAR2) as
10:
11: -- compile package specifications first, then views, then bodies
12: -- this is because a view could reference a package header
13: cursor c1 is

Line 14: select object_name, object_type from all_objects

10:
11: -- compile package specifications first, then views, then bodies
12: -- this is because a view could reference a package header
13: cursor c1 is
14: select object_name, object_type from all_objects
15: where status = 'INVALID'
16: and object_type = 'PACKAGE'
17: and owner=schema_name;
18:

Line 20: select object_name, object_type from all_objects

16: and object_type = 'PACKAGE'
17: and owner=schema_name;
18:
19: cursor c2 is
20: select object_name, object_type from all_objects
21: where status = 'INVALID'
22: and object_type = 'VIEW'
23: and owner=schema_name ;
24:

Line 153: end compile_all_objects;

149: dbms_sql.close_cursor(c);
150: raise;
151: end;
152: end loop; -- loop over all remaining invalid objects
153: end compile_all_objects;
154:
155:
156: PROCEDURE compile_all_objects as
157:

Line 156: PROCEDURE compile_all_objects as

152: end loop; -- loop over all remaining invalid objects
153: end compile_all_objects;
154:
155:
156: PROCEDURE compile_all_objects as
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

Line 295: end compile_all_objects;

291: dbms_sql.close_cursor(c);
292: raise;
293: end;
294: end loop; -- loop over all remaining invalid objects
295: end compile_all_objects;
296:
297:
298: END ASG_COMPILE_PKG;