DBA Data[Home] [Help]

APPS.EAM_INT_UTILS dependencies on DBMS_SQL

Line 42: x_cursor_id := dbms_sql.open_cursor;

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);

Line 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',

Line 48: dbms_sql.bind_variable(x_cursor_id, ':interface_id_1',

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',

Line 50: dbms_sql.bind_variable(x_cursor_id, ':error_type',

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',

Line 52: dbms_sql.bind_variable(x_cursor_id, ':error',

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

Line 54: dbms_sql.bind_variable(x_cursor_id, ':interface_id_2',

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

Line 57: dbms_sql.bind_variable(x_cursor_id, ':l_source_table', p_source_interface_table);

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;

Line 60: x_dummy := dbms_sql.execute(x_cursor_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;
62:
63: END LOOP;
64: dbms_sql.close_cursor(x_cursor_id);

Line 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:

Line 238: x_cursor_id := dbms_sql.open_cursor ;

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);

Line 239: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;

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);

Line 240: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', p_current_rowid) ;

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, ' ', ' '));

Line 242: dbms_sql.bind_variable(x_cursor_id, ':l_table', p_table_name);

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

Line 243: dbms_sql.bind_variable(x_cursor_id, ':l_column', p_column);

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:

Line 244: dbms_sql.bind_variable(x_cursor_id, ':l_default', replace(p_default_value_expression, ' ', ' '));

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) ;

Line 245: dbms_sql.bind_variable(x_cursor_id, ':l_condition', replace(p_condition, ' ', ' '));

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) ;

Line 248: x_dummy := dbms_sql.execute(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,

Line 249: dbms_sql.close_cursor(x_cursor_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,

Line 271: x_cursor_id := dbms_sql.open_cursor;

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

Line 272: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native);

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);

Line 273: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', p_current_rowid);

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, ' ', ' '));

Line 276: dbms_sql.bind_variable(x_cursor_id, ':l_table', p_table_name);

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);

Line 277: dbms_sql.bind_variable(x_cursor_id, ':l_where', replace(p_where_clause, ' ', ' '));

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);

Line 280: n_rows_fetched := dbms_sql.execute_and_fetch(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:

Line 281: dbms_sql.close_cursor(x_cursor_id);

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