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.

SYSTEM.AD_APPS_PRIVATE dependencies on DBMS_SYS_SQL

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

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

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

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);
996: sys.dbms_sys_sql.define_column_long(c,1);
997: rows_processed := sys.dbms_sys_sql.execute(c);
998:
999: if sys.dbms_sys_sql.fetch_rows(c) > 0 then

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

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);
996: sys.dbms_sys_sql.define_column_long(c,1);
997: rows_processed := sys.dbms_sys_sql.execute(c);
998:
999: if sys.dbms_sys_sql.fetch_rows(c) > 0 then
1000: while val_length = value_max_size loop

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

993: 'and view_name='''||copy_huge_view.view_name||'''';
994:
995: sys.dbms_sys_sql.parse(c, statement, dbms_sql.native);
996: sys.dbms_sys_sql.define_column_long(c,1);
997: rows_processed := sys.dbms_sys_sql.execute(c);
998:
999: if sys.dbms_sys_sql.fetch_rows(c) > 0 then
1000: while val_length = value_max_size loop
1001: sys.dbms_sys_sql.column_value_long(c,1,value_max_size,position,

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

995: sys.dbms_sys_sql.parse(c, statement, dbms_sql.native);
996: sys.dbms_sys_sql.define_column_long(c,1);
997: rows_processed := sys.dbms_sys_sql.execute(c);
998:
999: if sys.dbms_sys_sql.fetch_rows(c) > 0 then
1000: while val_length = value_max_size loop
1001: sys.dbms_sys_sql.column_value_long(c,1,value_max_size,position,
1002: curr_value,val_length);
1003:

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

997: rows_processed := sys.dbms_sys_sql.execute(c);
998:
999: if sys.dbms_sys_sql.fetch_rows(c) > 0 then
1000: while val_length = value_max_size loop
1001: sys.dbms_sys_sql.column_value_long(c,1,value_max_size,position,
1002: curr_value,val_length);
1003:
1004: row_count := row_count + 1;
1005:

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

1008:
1009: position := position + val_length;
1010: end loop;
1011: else
1012: sys.dbms_sys_sql.close_cursor(c);
1013: ad_apps_private.error_buf := 'statement='||statement||
1014: ':'||ad_apps_private.error_buf;
1015: raise no_data_found;
1016: end if;

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

1014: ':'||ad_apps_private.error_buf;
1015: raise no_data_found;
1016: end if;
1017:
1018: sys.dbms_sys_sql.close_cursor(c);
1019:
1020: --
1021: -- Execute create view statement using apps_array_ddl
1022: --

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

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

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

1125: 'where owner=upper('''||fromschema||''') '||
1126: 'and view_name=upper('''||view_name||''') '||
1127: 'and text_length='||from_len;
1128:
1129: sys.dbms_sys_sql.parse(c1, statement1, dbms_sql.native);
1130: sys.dbms_sys_sql.define_column_long(c1,1);
1131: rows_processed := sys.dbms_sys_sql.execute(c1);
1132:
1133: if sys.dbms_sys_sql.fetch_rows(c1) <= 0 then

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

1126: 'and view_name=upper('''||view_name||''') '||
1127: 'and text_length='||from_len;
1128:
1129: sys.dbms_sys_sql.parse(c1, statement1, dbms_sql.native);
1130: sys.dbms_sys_sql.define_column_long(c1,1);
1131: rows_processed := sys.dbms_sys_sql.execute(c1);
1132:
1133: if sys.dbms_sys_sql.fetch_rows(c1) <= 0 then
1134: sys.dbms_sys_sql.close_cursor(c1);

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

1127: 'and text_length='||from_len;
1128:
1129: sys.dbms_sys_sql.parse(c1, statement1, dbms_sql.native);
1130: sys.dbms_sys_sql.define_column_long(c1,1);
1131: rows_processed := sys.dbms_sys_sql.execute(c1);
1132:
1133: if sys.dbms_sys_sql.fetch_rows(c1) <= 0 then
1134: sys.dbms_sys_sql.close_cursor(c1);
1135: extra_err_info := ' ';

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

1129: sys.dbms_sys_sql.parse(c1, statement1, dbms_sql.native);
1130: sys.dbms_sys_sql.define_column_long(c1,1);
1131: rows_processed := sys.dbms_sys_sql.execute(c1);
1132:
1133: if sys.dbms_sys_sql.fetch_rows(c1) <= 0 then
1134: sys.dbms_sys_sql.close_cursor(c1);
1135: extra_err_info := ' ';
1136: raise no_data_found;
1137: end if;

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

1130: sys.dbms_sys_sql.define_column_long(c1,1);
1131: rows_processed := sys.dbms_sys_sql.execute(c1);
1132:
1133: if sys.dbms_sys_sql.fetch_rows(c1) <= 0 then
1134: sys.dbms_sys_sql.close_cursor(c1);
1135: extra_err_info := ' ';
1136: raise no_data_found;
1137: end if;
1138:

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

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

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

1148: 'where owner=upper('''||toschema||''') '||
1149: 'and view_name=upper('''||view_name||''') '||
1150: 'and text_length='||to_len;
1151:
1152: sys.dbms_sys_sql.parse(c2, statement2, dbms_sql.native);
1153: sys.dbms_sys_sql.define_column_long(c2,1);
1154: rows_processed := sys.dbms_sys_sql.execute(c2);
1155:
1156: if sys.dbms_sys_sql.fetch_rows(c2) <= 0 then

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

1149: 'and view_name=upper('''||view_name||''') '||
1150: 'and text_length='||to_len;
1151:
1152: sys.dbms_sys_sql.parse(c2, statement2, dbms_sql.native);
1153: sys.dbms_sys_sql.define_column_long(c2,1);
1154: rows_processed := sys.dbms_sys_sql.execute(c2);
1155:
1156: if sys.dbms_sys_sql.fetch_rows(c2) <= 0 then
1157: sys.dbms_sys_sql.close_cursor(c2);

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

1150: 'and text_length='||to_len;
1151:
1152: sys.dbms_sys_sql.parse(c2, statement2, dbms_sql.native);
1153: sys.dbms_sys_sql.define_column_long(c2,1);
1154: rows_processed := sys.dbms_sys_sql.execute(c2);
1155:
1156: if sys.dbms_sys_sql.fetch_rows(c2) <= 0 then
1157: sys.dbms_sys_sql.close_cursor(c2);
1158: extra_err_info := ' ';

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

1152: sys.dbms_sys_sql.parse(c2, statement2, dbms_sql.native);
1153: sys.dbms_sys_sql.define_column_long(c2,1);
1154: rows_processed := sys.dbms_sys_sql.execute(c2);
1155:
1156: if sys.dbms_sys_sql.fetch_rows(c2) <= 0 then
1157: sys.dbms_sys_sql.close_cursor(c2);
1158: extra_err_info := ' ';
1159: raise no_data_found;
1160: end if;

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

1153: sys.dbms_sys_sql.define_column_long(c2,1);
1154: rows_processed := sys.dbms_sys_sql.execute(c2);
1155:
1156: if sys.dbms_sys_sql.fetch_rows(c2) <= 0 then
1157: sys.dbms_sys_sql.close_cursor(c2);
1158: extra_err_info := ' ';
1159: raise no_data_found;
1160: end if;
1161:

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

1164: while val_length1 = max_easy_len loop
1165:
1166: -- Get chunk of source view text
1167:
1168: sys.dbms_sys_sql.column_value_long(c1, 1, max_easy_len, position1,
1169: src_vw_text, val_length1);
1170:
1171: position1 := position1 + val_length1;
1172:

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

1171: position1 := position1 + val_length1;
1172:
1173: -- Get chunk of destination view text
1174:
1175: sys.dbms_sys_sql.column_value_long(c2, 1, max_easy_len, position2,
1176: dst_vw_text, val_length2);
1177:
1178: position2 := position2 + val_length2;
1179:

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

1182: if src_vw_text <> dst_vw_text then
1183:
1184: -- views not equal
1185:
1186: sys.dbms_sys_sql.close_cursor(c1);
1187: sys.dbms_sys_sql.close_cursor(c2);
1188: return;
1189: end if;
1190:

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

1183:
1184: -- views not equal
1185:
1186: sys.dbms_sys_sql.close_cursor(c1);
1187: sys.dbms_sys_sql.close_cursor(c2);
1188: return;
1189: end if;
1190:
1191: end loop;

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

1191: end loop;
1192:
1193: -- If we got this far, the views are equal
1194:
1195: sys.dbms_sys_sql.close_cursor(c1);
1196: sys.dbms_sys_sql.close_cursor(c2);
1197:
1198: local_equal := 'TRUE';
1199: equal := local_equal;

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

1192:
1193: -- If we got this far, the views are equal
1194:
1195: sys.dbms_sys_sql.close_cursor(c1);
1196: sys.dbms_sys_sql.close_cursor(c2);
1197:
1198: local_equal := 'TRUE';
1199: equal := local_equal;
1200: return;