APPS.JTF_DIAGNOSTIC_ADAPTUTIL dependencies on ALL_OBJECTS

Line 77: -- queries the all_objects data dictionary to check if the

73:
74:
75: -----------------------------------------------------------
76: -- checkValidPackage takes in the test package name and
77: -- queries the all_objects data dictionary to check if the
78: -- package and package body for the specified package exist
79: -- and are marked as valid objects
80: -- returns '1' if valid and '0' if not valid
81: -----------------------------------------------------------

Line 91: select y.status into s_status from all_objects y

87: b_false NUMBER :=0;
88: BEGIN
89:
90: -- OWNER CHANGE
91: select y.status into s_status from all_objects y
92: where y.object_name = UPPER(packageName)
93: and y.object_type = 'PACKAGE'
94: and upper(y.owner) in ('APPS', 'JTF', 'APPLSYS');
95:

Line 96: select y.status into b_status from all_objects y

92: where y.object_name = UPPER(packageName)
93: and y.object_type = 'PACKAGE'
94: and upper(y.owner) in ('APPS', 'JTF', 'APPLSYS');
95:
96: select y.status into b_status from all_objects y
97: where y.object_name = UPPER(packageName)
98: and y.object_type = 'PACKAGE BODY'
99: and upper(y.owner) in ('APPS', 'JTF', 'APPLSYS');
100:

Line 113: -- queries the all_objects data dictionary to check if the

109: END checkValidPackage;
110:
111: -----------------------------------------------------------
112: -- checkPackageExists takes in the test package name and
113: -- queries the all_objects data dictionary to check if the
114: -- package and package body for the specified package exist
115: -- returns '1' if exists '0' if doesnt exist.
116: -----------------------------------------------------------
117:

Line 124: select y.owner into v_pspec from all_objects y

120: v_pbody VARCHAR2(100);
121: b_true NUMBER := 1;
122: b_false NUMBER :=0;
123: BEGIN
124: select y.owner into v_pspec from all_objects y
125: where y.object_name = UPPER(packageName)
126: and y.object_type = 'PACKAGE'
127: and upper(y.owner) in ('APPS', 'JTF', 'APPLSYS');
128:

Line 129: select y.owner into v_pbody from all_objects y

125: where y.object_name = UPPER(packageName)
126: and y.object_type = 'PACKAGE'
127: and upper(y.owner) in ('APPS', 'JTF', 'APPLSYS');
128:
129: select y.owner into v_pbody from all_objects y
130: where y.object_name = UPPER(packageName)
131: and y.object_type = 'PACKAGE BODY'
132: and upper(y.owner) in ('APPS', 'JTF', 'APPLSYS');
133:

Line 539: from all_arguments a, all_objects b

535: v_size NUMBER := 0;
536: cursor testNameCursor IS
537:
538: select distinct a.package_name, a.object_name
539: from all_arguments a, all_objects b
540: where
541: -- a.owner like 'APPS' and b.owner like 'APPS'
542: -- and a.object_id = b.object_id
543: a.object_id = b.object_id