APPS.ECX_DIAGNOSTICS_TEST dependencies on ALL_OBJECTS

Line 35: from all_objects

31: cursor cur_get_pkg_dtls
32: is
33: select status,
34: object_type
35: from all_objects
36: where object_type in ('PACKAGE', 'PACKAGE BODY')
37: and object_name = v_rec_package_details.package_name
38: and owner =v_rec_package_details.schema_name;
39: v_get_pkg_dtls cur_get_pkg_dtls%rowtype;

Line 87: from all_objects

83: */
84: cursor cur_get_standalone_proc_dtls
85: is
86: select status
87: from all_objects
88: where object_type = 'PROCEDURE'
89: and object_name = v_rec_package_details.procedure_name
90: and owner =v_rec_package_details.schema_name;
91:

Line 154: all_objects ao

150: select aa.argument_name,
151: aa.data_type,
152: aa.in_out
153: from all_arguments aa,
154: all_objects ao
155: where ao.object_id = aa.object_id
156: and aa.object_name =v_rec_package_details.procedure_name
157: and aa.owner =v_rec_package_details.schema_name
158: and nvl(aa.overload,1) =overloadnum

Line 172: all_objects ao

168: cursor cur_get_overload_num
169: is
170: select distinct nvl(overload, 1) overloadnum
171: from all_arguments aa,
172: all_objects ao
173: where ao.object_id = aa.object_id
174: and aa.object_name =v_rec_package_details.procedure_name
175: and aa.owner =v_rec_package_details.schema_name
176: and ao.object_name = v_rec_package_details.package_name

Line 194: all_objects ao

190: select aa.argument_name,
191: aa.data_type,
192: aa.in_out
193: from all_arguments aa,
194: all_objects ao
195: where ao.object_id = aa.object_id
196: and ao.object_name =v_rec_package_details.procedure_name
197: and ao.owner =v_rec_package_details.schema_name
198: and ao.object_type = 'PROCEDURE'