APPS.XDP_UTILITIES dependencies on ALL_OBJECTS

Line 1524: from all_objects

1520: lv_lf varchar2(10);
1521: lv_pkg_name varchar2(80) := UPPER(p_pkg_name);
1522: CURSOR lc_status IS
1523: select status, owner
1524: from all_objects
1525: where object_name = lv_pkg_name and
1526: object_type = 'PACKAGE' and
1527: owner = lf_owner and
1528: status <> 'VALID';

Line 1653: from all_objects

1649: lv_lf varchar2(10);
1650: lv_pkg_name varchar2(80) := UPPER(p_pkg_name);
1651: CURSOR lc_status IS
1652: select status, owner
1653: from all_objects
1654: where object_name = lv_pkg_name and
1655: object_type = 'PACKAGE BODY' and
1656: owner = lf_owner and
1657: status <> 'VALID';

Line 2285: FROM all_objects

2281: l_text_line VARCHAR2(32767);
2282:
2283: CURSOR lc_status IS
2284: SELECT status, owner
2285: FROM all_objects
2286: WHERE object_name = lv_pkg_name
2287: AND object_type = p_pkg_type
2288: AND owner = lf_owner
2289: AND status <> 'VALID';