APPS.IEU_DIAGNOSTICS_PVT dependencies on ALL_OBJECTS

Line 1871: select count(*) into l_temp_count from all_objects where owner = 'APPS' and object_type in('PACKAGE', 'PACKAGE BODY') and status='VALID'and object_name = l_temp_pkg_name;

1867:
1868: l_temp_pkg_name := substr(l_temp_eproc,1, ( instr(l_temp_eproc,'.',1,1)-1));
1869: begin
1870:
1871: select count(*) into l_temp_count from all_objects where owner = 'APPS' and object_type in('PACKAGE', 'PACKAGE BODY') and status='VALID'and object_name = l_temp_pkg_name;
1872:
1873:
1874:
1875: if not(l_temp_count is null) and (l_temp_count <= 0) then

Line 2685: from all_objects

2681: l_temp_pkg_name := substr(l_temp_rproc,1, ( instr(l_temp_rproc,'.',1,1)-1));
2682: begin
2683:
2684: select count(*) into l_temp_count
2685: from all_objects
2686: where owner = 'APPS' and object_type in('PACKAGE', 'PACKAGE BODY')
2687: and status='VALID'and object_name = l_temp_pkg_name;
2688:
2689:

Line 2731: select count(object_name) into l_temp_view_count from all_objects

2727: --DBMS_OUTPUT.put_line('start time== '||t1);
2728:
2729: begin
2730: null;
2731: select count(object_name) into l_temp_view_count from all_objects
2732: where object_name = node.view_name and object_type = 'VIEW'
2733: and status = 'VALID' and owner = 'APPS';
2734:
2735: select tl.application_name into l_appli_name

Line 2849: select count(object_name) into l_temp_view_count from all_objects

2845: null;
2846: else
2847: begin
2848:
2849: select count(object_name) into l_temp_view_count from all_objects
2850: where object_name = l_view_name and object_type = 'VIEW'
2851: and status = 'VALID' and owner = 'APPS';
2852:
2853: select tl.application_name into l_appli_name

Line 3534: select count(object_name) into l_count from all_objects

3530: LOOP
3531: --dbms_output.put_line('in the loop of enum');
3532: begin
3533:
3534: select count(object_name) into l_count from all_objects
3535: where object_name = cur_rec.view_name and object_type = 'VIEW'
3536: and status = 'VALID' and owner = 'APPS';
3537:
3538: if l_count <> 1 then