SYSTEM.AD_APPS_PRIVATE dependencies on DBA_VIEWS

Line 994: select text into view_text from dba_views

990: begin
991:
992: temp_len := 0;
993:
994: select text into view_text from dba_views
995: where owner = upper(copy_view_internal.from_schema)
996: and view_name = copy_view_internal.view_name;
997:
998: if view_text is null then

Line 1072: from dba_views dv

1068: -- handle case where view text > 32 K
1069: --
1070: select dv.text_length
1071: into view_size
1072: from dba_views dv
1073: where dv.view_name= copy_view_internal.view_name
1074: and dv.owner= upper(copy_view_internal.from_schema);
1075:
1076: -- Compare against 24000, since the actual 'create view'

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

1196:
1197: position := 0;
1198: val_length := value_max_size;
1199:
1200: -- create select statement to get value from dba_views
1201:
1202: c := sys.dbms_sys_sql.open_cursor;
1203: statement := 'select text into :view_text from dba_views '||
1204: 'where owner='''||copy_huge_view.fromschema||''' '||

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

1199:
1200: -- create select statement to get value from dba_views
1201:
1202: c := sys.dbms_sys_sql.open_cursor;
1203: statement := 'select text into :view_text from dba_views '||
1204: 'where owner='''||copy_huge_view.fromschema||''' '||
1205: 'and view_name='''||copy_huge_view.view_name||'''';
1206:
1207: sys.dbms_sys_sql.parse(c, statement, dbms_sql.native);

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

1332:
1333: -- create select statement
1334:
1335: c1 := sys.dbms_sys_sql.open_cursor;
1336: statement1 := 'select text into :view_text from dba_views '||
1337: 'where owner=upper('''||fromschema||''') '||
1338: 'and view_name=upper('''||view_name||''') '||
1339: 'and text_length='||from_len;
1340:

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

1355:
1356: -- create select statement
1357:
1358: c2 := sys.dbms_sys_sql.open_cursor;
1359: statement2 := 'select text into :view_text from dba_views '||
1360: 'where owner=upper('''||toschema||''') '||
1361: 'and view_name=upper('''||view_name||''') '||
1362: 'and text_length='||to_len;
1363:

Line 2627: from dba_views v1, dba_views v2

2623: -- Do not copy obsolete views left over by AutoInstall( 'AI9%' or 'AI1%')
2624: cursor view_cur is
2625: select v1.view_name, v1.text_length source_len,
2626: v2.text_length dest_len
2627: from dba_views v1, dba_views v2
2628: where v1.owner = upper(fromschema)
2629: and v1.view_name not like 'AI9%'
2630: and v1.view_name not like 'AI1%'
2631: and v2.owner (+) = upper(toschema)