DBA Data[Home] [Help]

APPS.FND_ADG_OBJECT dependencies on DBA_OBJECTS

Line 1175: from dba_objects a

1171: if ( p_package_name = C_COMPILE_DIRECTIVE_PACKAGE )
1172: then
1173: select count(*)
1174: into l_compile_status
1175: from dba_objects a
1176: where a.owner = p_owner
1177: and a.object_name = p_package_name
1178: and a.object_type = 'PACKAGE'
1179: and a.status = 'INVALID';

Line 1183: from dba_objects a

1179: and a.status = 'INVALID';
1180: else
1181: select count(*)
1182: into l_compile_status
1183: from dba_objects a
1184: where a.owner = p_owner
1185: and a.object_name = p_rpc_package_name
1186: and a.object_type = decode(l_compile_spec,'Y','PACKAGE','PACKAGE BODY')
1187: and a.status = 'INVALID';

Line 1691: from dba_objects a

1687: then
1688:
1689: select count(*)
1690: into l_valid_count
1691: from dba_objects a
1692: where a.owner = f_rec.owner
1693: and a.object_name = f_rec.package_name
1694: and a.object_type in ('PACKAGE','PACKAGE BODY')
1695: and a.status = 'VALID';

Line 1707: from dba_objects a

1703: end if;
1704:
1705: select count(*)
1706: into l_valid_count
1707: from dba_objects a
1708: where a.owner = f_rec.owner
1709: and a.object_name = f_rec.rpc_package_name
1710: and a.object_type in ('PACKAGE','PACKAGE BODY')
1711: and a.status = 'VALID';