eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

SYSTEM.AD_APPS_PRIVATE dependencies on DBMS_SYS_SQL

Line 1202: c := sys.dbms_sys_sql.open_cursor;

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||''' '||
1205: 'and view_name='''||copy_huge_view.view_name||'''';
1206:

Line 1207: sys.dbms_sys_sql.parse(c, statement, dbms_sql.native);

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);
1208: sys.dbms_sys_sql.define_column_long(c,1);
1209: rows_processed := sys.dbms_sys_sql.execute(c);
1210:
1211: if sys.dbms_sys_sql.fetch_rows(c) > 0 then

Line 1208: sys.dbms_sys_sql.define_column_long(c,1);

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);
1208: sys.dbms_sys_sql.define_column_long(c,1);
1209: rows_processed := sys.dbms_sys_sql.execute(c);
1210:
1211: if sys.dbms_sys_sql.fetch_rows(c) > 0 then
1212: while val_length = value_max_size loop

Line 1209: rows_processed := sys.dbms_sys_sql.execute(c);

1205: 'and view_name='''||copy_huge_view.view_name||'''';
1206:
1207: sys.dbms_sys_sql.parse(c, statement, dbms_sql.native);
1208: sys.dbms_sys_sql.define_column_long(c,1);
1209: rows_processed := sys.dbms_sys_sql.execute(c);
1210:
1211: if sys.dbms_sys_sql.fetch_rows(c) > 0 then
1212: while val_length = value_max_size loop
1213: sys.dbms_sys_sql.column_value_long(c,1,value_max_size,position,

Line 1211: if sys.dbms_sys_sql.fetch_rows(c) > 0 then

1207: sys.dbms_sys_sql.parse(c, statement, dbms_sql.native);
1208: sys.dbms_sys_sql.define_column_long(c,1);
1209: rows_processed := sys.dbms_sys_sql.execute(c);
1210:
1211: if sys.dbms_sys_sql.fetch_rows(c) > 0 then
1212: while val_length = value_max_size loop
1213: sys.dbms_sys_sql.column_value_long(c,1,value_max_size,position,
1214: curr_value,val_length);
1215:

Line 1213: sys.dbms_sys_sql.column_value_long(c,1,value_max_size,position,

1209: rows_processed := sys.dbms_sys_sql.execute(c);
1210:
1211: if sys.dbms_sys_sql.fetch_rows(c) > 0 then
1212: while val_length = value_max_size loop
1213: sys.dbms_sys_sql.column_value_long(c,1,value_max_size,position,
1214: curr_value,val_length);
1215:
1216: row_count := row_count + 1;
1217:

Line 1224: sys.dbms_sys_sql.close_cursor(c);

1220:
1221: position := position + val_length;
1222: end loop;
1223: else
1224: sys.dbms_sys_sql.close_cursor(c);
1225: ad_apps_private.error_buf := 'statement='||statement||
1226: ':'||ad_apps_private.error_buf;
1227: raise no_data_found;
1228: end if;

Line 1230: sys.dbms_sys_sql.close_cursor(c);

1226: ':'||ad_apps_private.error_buf;
1227: raise no_data_found;
1228: end if;
1229:
1230: sys.dbms_sys_sql.close_cursor(c);
1231:
1232: --
1233: -- Execute create view statement using apps_array_ddl
1234: --

Line 1335: c1 := sys.dbms_sys_sql.open_cursor;

1331: val_length1 := max_easy_len;
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;

Line 1341: sys.dbms_sys_sql.parse(c1, statement1, dbms_sql.native);

1337: 'where owner=upper('''||fromschema||''') '||
1338: 'and view_name=upper('''||view_name||''') '||
1339: 'and text_length='||from_len;
1340:
1341: sys.dbms_sys_sql.parse(c1, statement1, dbms_sql.native);
1342: sys.dbms_sys_sql.define_column_long(c1,1);
1343: rows_processed := sys.dbms_sys_sql.execute(c1);
1344:
1345: if sys.dbms_sys_sql.fetch_rows(c1) <= 0 then

Line 1342: sys.dbms_sys_sql.define_column_long(c1,1);

1338: 'and view_name=upper('''||view_name||''') '||
1339: 'and text_length='||from_len;
1340:
1341: sys.dbms_sys_sql.parse(c1, statement1, dbms_sql.native);
1342: sys.dbms_sys_sql.define_column_long(c1,1);
1343: rows_processed := sys.dbms_sys_sql.execute(c1);
1344:
1345: if sys.dbms_sys_sql.fetch_rows(c1) <= 0 then
1346: sys.dbms_sys_sql.close_cursor(c1);

Line 1343: rows_processed := sys.dbms_sys_sql.execute(c1);

1339: 'and text_length='||from_len;
1340:
1341: sys.dbms_sys_sql.parse(c1, statement1, dbms_sql.native);
1342: sys.dbms_sys_sql.define_column_long(c1,1);
1343: rows_processed := sys.dbms_sys_sql.execute(c1);
1344:
1345: if sys.dbms_sys_sql.fetch_rows(c1) <= 0 then
1346: sys.dbms_sys_sql.close_cursor(c1);
1347: extra_err_info := ' ';

Line 1345: if sys.dbms_sys_sql.fetch_rows(c1) <= 0 then

1341: sys.dbms_sys_sql.parse(c1, statement1, dbms_sql.native);
1342: sys.dbms_sys_sql.define_column_long(c1,1);
1343: rows_processed := sys.dbms_sys_sql.execute(c1);
1344:
1345: if sys.dbms_sys_sql.fetch_rows(c1) <= 0 then
1346: sys.dbms_sys_sql.close_cursor(c1);
1347: extra_err_info := ' ';
1348: raise no_data_found;
1349: end if;

Line 1346: sys.dbms_sys_sql.close_cursor(c1);

1342: sys.dbms_sys_sql.define_column_long(c1,1);
1343: rows_processed := sys.dbms_sys_sql.execute(c1);
1344:
1345: if sys.dbms_sys_sql.fetch_rows(c1) <= 0 then
1346: sys.dbms_sys_sql.close_cursor(c1);
1347: extra_err_info := ' ';
1348: raise no_data_found;
1349: end if;
1350:

Line 1358: c2 := sys.dbms_sys_sql.open_cursor;

1354: val_length2 := max_easy_len;
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;

Line 1364: sys.dbms_sys_sql.parse(c2, statement2, dbms_sql.native);

1360: 'where owner=upper('''||toschema||''') '||
1361: 'and view_name=upper('''||view_name||''') '||
1362: 'and text_length='||to_len;
1363:
1364: sys.dbms_sys_sql.parse(c2, statement2, dbms_sql.native);
1365: sys.dbms_sys_sql.define_column_long(c2,1);
1366: rows_processed := sys.dbms_sys_sql.execute(c2);
1367:
1368: if sys.dbms_sys_sql.fetch_rows(c2) <= 0 then

Line 1365: sys.dbms_sys_sql.define_column_long(c2,1);

1361: 'and view_name=upper('''||view_name||''') '||
1362: 'and text_length='||to_len;
1363:
1364: sys.dbms_sys_sql.parse(c2, statement2, dbms_sql.native);
1365: sys.dbms_sys_sql.define_column_long(c2,1);
1366: rows_processed := sys.dbms_sys_sql.execute(c2);
1367:
1368: if sys.dbms_sys_sql.fetch_rows(c2) <= 0 then
1369: sys.dbms_sys_sql.close_cursor(c2);

Line 1366: rows_processed := sys.dbms_sys_sql.execute(c2);

1362: 'and text_length='||to_len;
1363:
1364: sys.dbms_sys_sql.parse(c2, statement2, dbms_sql.native);
1365: sys.dbms_sys_sql.define_column_long(c2,1);
1366: rows_processed := sys.dbms_sys_sql.execute(c2);
1367:
1368: if sys.dbms_sys_sql.fetch_rows(c2) <= 0 then
1369: sys.dbms_sys_sql.close_cursor(c2);
1370: extra_err_info := ' ';

Line 1368: if sys.dbms_sys_sql.fetch_rows(c2) <= 0 then

1364: sys.dbms_sys_sql.parse(c2, statement2, dbms_sql.native);
1365: sys.dbms_sys_sql.define_column_long(c2,1);
1366: rows_processed := sys.dbms_sys_sql.execute(c2);
1367:
1368: if sys.dbms_sys_sql.fetch_rows(c2) <= 0 then
1369: sys.dbms_sys_sql.close_cursor(c2);
1370: extra_err_info := ' ';
1371: raise no_data_found;
1372: end if;

Line 1369: sys.dbms_sys_sql.close_cursor(c2);

1365: sys.dbms_sys_sql.define_column_long(c2,1);
1366: rows_processed := sys.dbms_sys_sql.execute(c2);
1367:
1368: if sys.dbms_sys_sql.fetch_rows(c2) <= 0 then
1369: sys.dbms_sys_sql.close_cursor(c2);
1370: extra_err_info := ' ';
1371: raise no_data_found;
1372: end if;
1373:

Line 1380: sys.dbms_sys_sql.column_value_long(c1, 1, max_easy_len, position1,

1376: while val_length1 = max_easy_len loop
1377:
1378: -- Get chunk of source view text
1379:
1380: sys.dbms_sys_sql.column_value_long(c1, 1, max_easy_len, position1,
1381: src_vw_text, val_length1);
1382:
1383: position1 := position1 + val_length1;
1384:

Line 1387: sys.dbms_sys_sql.column_value_long(c2, 1, max_easy_len, position2,

1383: position1 := position1 + val_length1;
1384:
1385: -- Get chunk of destination view text
1386:
1387: sys.dbms_sys_sql.column_value_long(c2, 1, max_easy_len, position2,
1388: dst_vw_text, val_length2);
1389:
1390: position2 := position2 + val_length2;
1391:

Line 1398: sys.dbms_sys_sql.close_cursor(c1);

1394: if src_vw_text <> dst_vw_text then
1395:
1396: -- views not equal
1397:
1398: sys.dbms_sys_sql.close_cursor(c1);
1399: sys.dbms_sys_sql.close_cursor(c2);
1400: return;
1401: end if;
1402:

Line 1399: sys.dbms_sys_sql.close_cursor(c2);

1395:
1396: -- views not equal
1397:
1398: sys.dbms_sys_sql.close_cursor(c1);
1399: sys.dbms_sys_sql.close_cursor(c2);
1400: return;
1401: end if;
1402:
1403: end loop;

Line 1407: sys.dbms_sys_sql.close_cursor(c1);

1403: end loop;
1404:
1405: -- If we got this far, the views are equal
1406:
1407: sys.dbms_sys_sql.close_cursor(c1);
1408: sys.dbms_sys_sql.close_cursor(c2);
1409:
1410: local_equal := 'TRUE';
1411: equal := local_equal;

Line 1408: sys.dbms_sys_sql.close_cursor(c2);

1404:
1405: -- If we got this far, the views are equal
1406:
1407: sys.dbms_sys_sql.close_cursor(c1);
1408: sys.dbms_sys_sql.close_cursor(c2);
1409:
1410: local_equal := 'TRUE';
1411: equal := local_equal;
1412: return;