APPS.FND_ADG_OBJECT dependencies on DBA_PROCEDURES

Line 810: from dba_procedures a

806: p_spec_code in out nocopy clob)
807: as
808: cursor c1(c_owner varchar2, c_package_name varchar2)
809: is select a.authid
810: from dba_procedures a
811: where a.owner = c_owner
812: and a.object_name = c_package_name
813: and a.object_type = 'PACKAGE';
814:

Line 825: from dba_procedures a

821: order by a.owner,a.package_name;
822:
823: cursor c3(c_owner varchar2, c_package_name varchar2, c_method_name varchar2)
824: is select nvl(a.overload,0) overload
825: from dba_procedures a
826: where a.owner = c_owner
827: and a.object_name = c_package_name
828: and a.procedure_name = c_method_name
829: and a.object_type = 'PACKAGE'

Line 946: from dba_procedures a

942: order by a.owner,a.package_name;
943:
944: cursor c3(c_owner varchar2, c_package_name varchar2, c_method_name varchar2)
945: is select nvl(a.overload,0) overload
946: from dba_procedures a
947: where a.owner = c_owner
948: and a.object_name = c_package_name
949: and a.procedure_name = c_method_name
950: and a.object_type = 'PACKAGE'

Line 1052: from dba_procedures a

1048: begin
1049:
1050: select count(*)
1051: into l_count1
1052: from dba_procedures a
1053: where a.owner = p_owner
1054: and a.object_name = p_package
1055: and a.procedure_name = p_method
1056: and a.object_type = 'PACKAGE'