38: --4247057 begin
39: ' from :l_source_table where interface_id = :interface_id_2 ';
40: --4247057 End
41:
42: x_cursor_id := dbms_sql.open_cursor;
43:
44: n_errors := current_errors.count;
45:
46: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native);
42: x_cursor_id := dbms_sql.open_cursor;
43:
44: n_errors := current_errors.count;
45:
46: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native);
47: WHILE (error_no <= n_errors) LOOP
48: dbms_sql.bind_variable(x_cursor_id, ':interface_id_1',
49: current_errors(error_no).interface_id);
50: dbms_sql.bind_variable(x_cursor_id, ':error_type',
44: n_errors := current_errors.count;
45:
46: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native);
47: WHILE (error_no <= n_errors) LOOP
48: dbms_sql.bind_variable(x_cursor_id, ':interface_id_1',
49: current_errors(error_no).interface_id);
50: dbms_sql.bind_variable(x_cursor_id, ':error_type',
51: current_errors(error_no).error_type);
52: dbms_sql.bind_variable(x_cursor_id, ':error',
46: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native);
47: WHILE (error_no <= n_errors) LOOP
48: dbms_sql.bind_variable(x_cursor_id, ':interface_id_1',
49: current_errors(error_no).interface_id);
50: dbms_sql.bind_variable(x_cursor_id, ':error_type',
51: current_errors(error_no).error_type);
52: dbms_sql.bind_variable(x_cursor_id, ':error',
53: current_errors(error_no).error);
54: dbms_sql.bind_variable(x_cursor_id, ':interface_id_2',
48: dbms_sql.bind_variable(x_cursor_id, ':interface_id_1',
49: current_errors(error_no).interface_id);
50: dbms_sql.bind_variable(x_cursor_id, ':error_type',
51: current_errors(error_no).error_type);
52: dbms_sql.bind_variable(x_cursor_id, ':error',
53: current_errors(error_no).error);
54: dbms_sql.bind_variable(x_cursor_id, ':interface_id_2',
55: current_errors(error_no).interface_id);
56: --4247057 Begin
50: dbms_sql.bind_variable(x_cursor_id, ':error_type',
51: current_errors(error_no).error_type);
52: dbms_sql.bind_variable(x_cursor_id, ':error',
53: current_errors(error_no).error);
54: dbms_sql.bind_variable(x_cursor_id, ':interface_id_2',
55: current_errors(error_no).interface_id);
56: --4247057 Begin
57: dbms_sql.bind_variable(x_cursor_id, ':l_source_table', p_source_interface_table);
58: --4247057 End
53: current_errors(error_no).error);
54: dbms_sql.bind_variable(x_cursor_id, ':interface_id_2',
55: current_errors(error_no).interface_id);
56: --4247057 Begin
57: dbms_sql.bind_variable(x_cursor_id, ':l_source_table', p_source_interface_table);
58: --4247057 End
59:
60: x_dummy := dbms_sql.execute(x_cursor_id);
61: error_no := error_no + 1;
56: --4247057 Begin
57: dbms_sql.bind_variable(x_cursor_id, ':l_source_table', p_source_interface_table);
58: --4247057 End
59:
60: x_dummy := dbms_sql.execute(x_cursor_id);
61: error_no := error_no + 1;
62:
63: END LOOP;
64: dbms_sql.close_cursor(x_cursor_id);
60: x_dummy := dbms_sql.execute(x_cursor_id);
61: error_no := error_no + 1;
62:
63: END LOOP;
64: dbms_sql.close_cursor(x_cursor_id);
65: current_errors.delete;
66:
67: end load_errors;
68:
234: x_statement := 'update :l_table set :l_column = :l_default where rowid = :x_row_id and :l_column is null and :l_condition' ;
235:
236:
237: -- Bug 4247057 end
238: x_cursor_id := dbms_sql.open_cursor ;
239: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
240: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', p_current_rowid) ;
241: -- Bug 4247057 begin
242: dbms_sql.bind_variable(x_cursor_id, ':l_table', p_table_name);
235:
236:
237: -- Bug 4247057 end
238: x_cursor_id := dbms_sql.open_cursor ;
239: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
240: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', p_current_rowid) ;
241: -- Bug 4247057 begin
242: dbms_sql.bind_variable(x_cursor_id, ':l_table', p_table_name);
243: dbms_sql.bind_variable(x_cursor_id, ':l_column', p_column);
236:
237: -- Bug 4247057 end
238: x_cursor_id := dbms_sql.open_cursor ;
239: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
240: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', p_current_rowid) ;
241: -- Bug 4247057 begin
242: dbms_sql.bind_variable(x_cursor_id, ':l_table', p_table_name);
243: dbms_sql.bind_variable(x_cursor_id, ':l_column', p_column);
244: dbms_sql.bind_variable(x_cursor_id, ':l_default', replace(p_default_value_expression, ' ', ' '));
238: x_cursor_id := dbms_sql.open_cursor ;
239: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
240: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', p_current_rowid) ;
241: -- Bug 4247057 begin
242: dbms_sql.bind_variable(x_cursor_id, ':l_table', p_table_name);
243: dbms_sql.bind_variable(x_cursor_id, ':l_column', p_column);
244: dbms_sql.bind_variable(x_cursor_id, ':l_default', replace(p_default_value_expression, ' ', ' '));
245: dbms_sql.bind_variable(x_cursor_id, ':l_condition', replace(p_condition, ' ', ' '));
246: -- Bug 4247057 end
239: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
240: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', p_current_rowid) ;
241: -- Bug 4247057 begin
242: dbms_sql.bind_variable(x_cursor_id, ':l_table', p_table_name);
243: dbms_sql.bind_variable(x_cursor_id, ':l_column', p_column);
244: dbms_sql.bind_variable(x_cursor_id, ':l_default', replace(p_default_value_expression, ' ', ' '));
245: dbms_sql.bind_variable(x_cursor_id, ':l_condition', replace(p_condition, ' ', ' '));
246: -- Bug 4247057 end
247:
240: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', p_current_rowid) ;
241: -- Bug 4247057 begin
242: dbms_sql.bind_variable(x_cursor_id, ':l_table', p_table_name);
243: dbms_sql.bind_variable(x_cursor_id, ':l_column', p_column);
244: dbms_sql.bind_variable(x_cursor_id, ':l_default', replace(p_default_value_expression, ' ', ' '));
245: dbms_sql.bind_variable(x_cursor_id, ':l_condition', replace(p_condition, ' ', ' '));
246: -- Bug 4247057 end
247:
248: x_dummy := dbms_sql.execute(x_cursor_id) ;
241: -- Bug 4247057 begin
242: dbms_sql.bind_variable(x_cursor_id, ':l_table', p_table_name);
243: dbms_sql.bind_variable(x_cursor_id, ':l_column', p_column);
244: dbms_sql.bind_variable(x_cursor_id, ':l_default', replace(p_default_value_expression, ' ', ' '));
245: dbms_sql.bind_variable(x_cursor_id, ':l_condition', replace(p_condition, ' ', ' '));
246: -- Bug 4247057 end
247:
248: x_dummy := dbms_sql.execute(x_cursor_id) ;
249: dbms_sql.close_cursor(x_cursor_id) ;
244: dbms_sql.bind_variable(x_cursor_id, ':l_default', replace(p_default_value_expression, ' ', ' '));
245: dbms_sql.bind_variable(x_cursor_id, ':l_condition', replace(p_condition, ' ', ' '));
246: -- Bug 4247057 end
247:
248: x_dummy := dbms_sql.execute(x_cursor_id) ;
249: dbms_sql.close_cursor(x_cursor_id) ;
250:
251: exception when others then
252: record_error(p_interface_id,
245: dbms_sql.bind_variable(x_cursor_id, ':l_condition', replace(p_condition, ' ', ' '));
246: -- Bug 4247057 end
247:
248: x_dummy := dbms_sql.execute(x_cursor_id) ;
249: dbms_sql.close_cursor(x_cursor_id) ;
250:
251: exception when others then
252: record_error(p_interface_id,
253: 'EAM_INT_UTILS: ORA-' || -sqlcode || ' : ' || x_statement,
267:
268: x_cursor_id integer;
269: n_rows_fetched integer;
270: begin
271: x_cursor_id := dbms_sql.open_cursor;
272: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native);
273: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', p_current_rowid);
274:
275: --4247057 begin
268: x_cursor_id integer;
269: n_rows_fetched integer;
270: begin
271: x_cursor_id := dbms_sql.open_cursor;
272: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native);
273: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', p_current_rowid);
274:
275: --4247057 begin
276: dbms_sql.bind_variable(x_cursor_id, ':l_table', p_table_name);
269: n_rows_fetched integer;
270: begin
271: x_cursor_id := dbms_sql.open_cursor;
272: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native);
273: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', p_current_rowid);
274:
275: --4247057 begin
276: dbms_sql.bind_variable(x_cursor_id, ':l_table', p_table_name);
277: dbms_sql.bind_variable(x_cursor_id, ':l_where', replace(p_where_clause, ' ', ' '));
272: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native);
273: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', p_current_rowid);
274:
275: --4247057 begin
276: dbms_sql.bind_variable(x_cursor_id, ':l_table', p_table_name);
277: dbms_sql.bind_variable(x_cursor_id, ':l_where', replace(p_where_clause, ' ', ' '));
278: --4247057 end
279:
280: n_rows_fetched := dbms_sql.execute_and_fetch(x_cursor_id);
273: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', p_current_rowid);
274:
275: --4247057 begin
276: dbms_sql.bind_variable(x_cursor_id, ':l_table', p_table_name);
277: dbms_sql.bind_variable(x_cursor_id, ':l_where', replace(p_where_clause, ' ', ' '));
278: --4247057 end
279:
280: n_rows_fetched := dbms_sql.execute_and_fetch(x_cursor_id);
281: dbms_sql.close_cursor(x_cursor_id);
276: dbms_sql.bind_variable(x_cursor_id, ':l_table', p_table_name);
277: dbms_sql.bind_variable(x_cursor_id, ':l_where', replace(p_where_clause, ' ', ' '));
278: --4247057 end
279:
280: n_rows_fetched := dbms_sql.execute_and_fetch(x_cursor_id);
281: dbms_sql.close_cursor(x_cursor_id);
282:
283: return (n_rows_fetched > 0);
284:
277: dbms_sql.bind_variable(x_cursor_id, ':l_where', replace(p_where_clause, ' ', ' '));
278: --4247057 end
279:
280: n_rows_fetched := dbms_sql.execute_and_fetch(x_cursor_id);
281: dbms_sql.close_cursor(x_cursor_id);
282:
283: return (n_rows_fetched > 0);
284:
285: exception when others then