SYSTEM.AD_APPS_PRIVATE dependencies on DBA_VIEWS

Line 782: select text into view_text from dba_views

778: begin
779:
780: temp_len := 0;
781:
782: select text into view_text from dba_views
783: where owner = upper(copy_view_internal.from_schema)
784: and view_name = copy_view_internal.view_name;
785:
786: if view_text is null then

Line 860: from dba_views dv

856: -- handle case where view text > 32 K
857: --
858: select dv.text_length
859: into view_size
860: from dba_views dv
861: where dv.view_name= copy_view_internal.view_name
862: and dv.owner= upper(copy_view_internal.from_schema);
863:
864: -- Compare against 24000, since the actual 'create view'

Line 988: -- create select statement to get value from dba_views

984:
985: position := 0;
986: val_length := value_max_size;
987:
988: -- create select statement to get value from dba_views
989:
990: c := sys.dbms_sys_sql.open_cursor;
991: statement := 'select text into :view_text from dba_views '||
992: 'where owner='''||copy_huge_view.fromschema||''' '||

Line 991: statement := 'select text into :view_text from dba_views '||

987:
988: -- create select statement to get value from dba_views
989:
990: c := sys.dbms_sys_sql.open_cursor;
991: statement := 'select text into :view_text from dba_views '||
992: 'where owner='''||copy_huge_view.fromschema||''' '||
993: 'and view_name='''||copy_huge_view.view_name||'''';
994:
995: sys.dbms_sys_sql.parse(c, statement, dbms_sql.native);

Line 1124: statement1 := 'select text into :view_text from dba_views '||

1120:
1121: -- create select statement
1122:
1123: c1 := sys.dbms_sys_sql.open_cursor;
1124: statement1 := 'select text into :view_text from dba_views '||
1125: 'where owner=upper('''||fromschema||''') '||
1126: 'and view_name=upper('''||view_name||''') '||
1127: 'and text_length='||from_len;
1128:

Line 1147: statement2 := 'select text into :view_text from dba_views '||

1143:
1144: -- create select statement
1145:
1146: c2 := sys.dbms_sys_sql.open_cursor;
1147: statement2 := 'select text into :view_text from dba_views '||
1148: 'where owner=upper('''||toschema||''') '||
1149: 'and view_name=upper('''||view_name||''') '||
1150: 'and text_length='||to_len;
1151:

Line 2347: from dba_views v1, dba_views v2

2343: -- Do not copy obsolete views left over by AutoInstall( 'AI9%' or 'AI1%')
2344: cursor view_cur is
2345: select v1.view_name, v1.text_length source_len,
2346: v2.text_length dest_len
2347: from dba_views v1, dba_views v2
2348: where v1.owner = upper(fromschema)
2349: and v1.view_name not like 'AI9%'
2350: and v1.view_name not like 'AI1%'
2351: and v2.owner (+) = upper(toschema)