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.

APPS.XTR_AUDIT dependencies on DBMS_SQL

Line 268: -- Now set up dbms_sql cursor

264: END LOOP;
265: v_sql := v_sql||'1,2,3'; -- Add B/A, "updated_on, updated_by" to SORT BY clause
266:
267: --
268: -- Now set up dbms_sql cursor
269: --
270: v_cursor := dbms_sql.open_cursor;
271: dbms_sql.parse(v_cursor,v_sql,native);
272: dbms_sql.define_column(v_cursor,1,v_new_letter, 1);

Line 270: v_cursor := dbms_sql.open_cursor;

266:
267: --
268: -- Now set up dbms_sql cursor
269: --
270: v_cursor := dbms_sql.open_cursor;
271: dbms_sql.parse(v_cursor,v_sql,native);
272: dbms_sql.define_column(v_cursor,1,v_new_letter, 1);
273: dbms_sql.define_column(v_cursor,2,v_new_updated_on);
274: dbms_sql.define_column(v_cursor,3,v_new_updated_by,30);

Line 271: dbms_sql.parse(v_cursor,v_sql,native);

267: --
268: -- Now set up dbms_sql cursor
269: --
270: v_cursor := dbms_sql.open_cursor;
271: dbms_sql.parse(v_cursor,v_sql,native);
272: dbms_sql.define_column(v_cursor,1,v_new_letter, 1);
273: dbms_sql.define_column(v_cursor,2,v_new_updated_on);
274: dbms_sql.define_column(v_cursor,3,v_new_updated_by,30);
275: dbms_sql.define_column(v_cursor,4,v_new_created_on);

Line 272: dbms_sql.define_column(v_cursor,1,v_new_letter, 1);

268: -- Now set up dbms_sql cursor
269: --
270: v_cursor := dbms_sql.open_cursor;
271: dbms_sql.parse(v_cursor,v_sql,native);
272: dbms_sql.define_column(v_cursor,1,v_new_letter, 1);
273: dbms_sql.define_column(v_cursor,2,v_new_updated_on);
274: dbms_sql.define_column(v_cursor,3,v_new_updated_by,30);
275: dbms_sql.define_column(v_cursor,4,v_new_created_on);
276: dbms_sql.define_column(v_cursor,5,v_new_created_by,30);

Line 273: dbms_sql.define_column(v_cursor,2,v_new_updated_on);

269: --
270: v_cursor := dbms_sql.open_cursor;
271: dbms_sql.parse(v_cursor,v_sql,native);
272: dbms_sql.define_column(v_cursor,1,v_new_letter, 1);
273: dbms_sql.define_column(v_cursor,2,v_new_updated_on);
274: dbms_sql.define_column(v_cursor,3,v_new_updated_by,30);
275: dbms_sql.define_column(v_cursor,4,v_new_created_on);
276: dbms_sql.define_column(v_cursor,5,v_new_created_by,30);
277:

Line 274: dbms_sql.define_column(v_cursor,3,v_new_updated_by,30);

270: v_cursor := dbms_sql.open_cursor;
271: dbms_sql.parse(v_cursor,v_sql,native);
272: dbms_sql.define_column(v_cursor,1,v_new_letter, 1);
273: dbms_sql.define_column(v_cursor,2,v_new_updated_on);
274: dbms_sql.define_column(v_cursor,3,v_new_updated_by,30);
275: dbms_sql.define_column(v_cursor,4,v_new_created_on);
276: dbms_sql.define_column(v_cursor,5,v_new_created_by,30);
277:
278: -- Its weird how come this next bit works !!??

Line 275: dbms_sql.define_column(v_cursor,4,v_new_created_on);

271: dbms_sql.parse(v_cursor,v_sql,native);
272: dbms_sql.define_column(v_cursor,1,v_new_letter, 1);
273: dbms_sql.define_column(v_cursor,2,v_new_updated_on);
274: dbms_sql.define_column(v_cursor,3,v_new_updated_by,30);
275: dbms_sql.define_column(v_cursor,4,v_new_created_on);
276: dbms_sql.define_column(v_cursor,5,v_new_created_by,30);
277:
278: -- Its weird how come this next bit works !!??
279: FOR v_counter IN 1..v_num_col LOOP

Line 276: dbms_sql.define_column(v_cursor,5,v_new_created_by,30);

272: dbms_sql.define_column(v_cursor,1,v_new_letter, 1);
273: dbms_sql.define_column(v_cursor,2,v_new_updated_on);
274: dbms_sql.define_column(v_cursor,3,v_new_updated_by,30);
275: dbms_sql.define_column(v_cursor,4,v_new_created_on);
276: dbms_sql.define_column(v_cursor,5,v_new_created_by,30);
277:
278: -- Its weird how come this next bit works !!??
279: FOR v_counter IN 1..v_num_col LOOP
280: dbms_sql.define_column( v_cursor, v_counter+5, v_var1, 100);

Line 280: dbms_sql.define_column( v_cursor, v_counter+5, v_var1, 100);

276: dbms_sql.define_column(v_cursor,5,v_new_created_by,30);
277:
278: -- Its weird how come this next bit works !!??
279: FOR v_counter IN 1..v_num_col LOOP
280: dbms_sql.define_column( v_cursor, v_counter+5, v_var1, 100);
281: END LOOP;
282:
283: v_rows_processed := dbms_sql.execute( v_cursor );
284:

Line 283: v_rows_processed := dbms_sql.execute( v_cursor );

279: FOR v_counter IN 1..v_num_col LOOP
280: dbms_sql.define_column( v_cursor, v_counter+5, v_var1, 100);
281: END LOOP;
282:
283: v_rows_processed := dbms_sql.execute( v_cursor );
284:
285: --
286: -- Now loop through records in cursor.
287: --

Line 295: EXIT WHEN dbms_sql.fetch_rows(v_cursor) < 1;

291: END LOOP;
292:
293: LOOP
294:
295: EXIT WHEN dbms_sql.fetch_rows(v_cursor) < 1;
296: dbms_sql.column_value(v_cursor,1,v_new_letter);
297: dbms_sql.column_value(v_cursor,2,v_new_updated_on);
298: dbms_sql.column_value(v_cursor,3,v_new_updated_by);
299: dbms_sql.column_value(v_cursor,4,v_new_created_on);

Line 296: dbms_sql.column_value(v_cursor,1,v_new_letter);

292:
293: LOOP
294:
295: EXIT WHEN dbms_sql.fetch_rows(v_cursor) < 1;
296: dbms_sql.column_value(v_cursor,1,v_new_letter);
297: dbms_sql.column_value(v_cursor,2,v_new_updated_on);
298: dbms_sql.column_value(v_cursor,3,v_new_updated_by);
299: dbms_sql.column_value(v_cursor,4,v_new_created_on);
300: dbms_sql.column_value(v_cursor,5,v_new_created_by);

Line 297: dbms_sql.column_value(v_cursor,2,v_new_updated_on);

293: LOOP
294:
295: EXIT WHEN dbms_sql.fetch_rows(v_cursor) < 1;
296: dbms_sql.column_value(v_cursor,1,v_new_letter);
297: dbms_sql.column_value(v_cursor,2,v_new_updated_on);
298: dbms_sql.column_value(v_cursor,3,v_new_updated_by);
299: dbms_sql.column_value(v_cursor,4,v_new_created_on);
300: dbms_sql.column_value(v_cursor,5,v_new_created_by);
301: FOR v_counter IN 1..v_num_col LOOP

Line 298: dbms_sql.column_value(v_cursor,3,v_new_updated_by);

294:
295: EXIT WHEN dbms_sql.fetch_rows(v_cursor) < 1;
296: dbms_sql.column_value(v_cursor,1,v_new_letter);
297: dbms_sql.column_value(v_cursor,2,v_new_updated_on);
298: dbms_sql.column_value(v_cursor,3,v_new_updated_by);
299: dbms_sql.column_value(v_cursor,4,v_new_created_on);
300: dbms_sql.column_value(v_cursor,5,v_new_created_by);
301: FOR v_counter IN 1..v_num_col LOOP
302: dbms_sql.column_value(v_cursor,v_counter + 5,v_var1);

Line 299: dbms_sql.column_value(v_cursor,4,v_new_created_on);

295: EXIT WHEN dbms_sql.fetch_rows(v_cursor) < 1;
296: dbms_sql.column_value(v_cursor,1,v_new_letter);
297: dbms_sql.column_value(v_cursor,2,v_new_updated_on);
298: dbms_sql.column_value(v_cursor,3,v_new_updated_by);
299: dbms_sql.column_value(v_cursor,4,v_new_created_on);
300: dbms_sql.column_value(v_cursor,5,v_new_created_by);
301: FOR v_counter IN 1..v_num_col LOOP
302: dbms_sql.column_value(v_cursor,v_counter + 5,v_var1);
303: v_new(v_counter) := v_var1;

Line 300: dbms_sql.column_value(v_cursor,5,v_new_created_by);

296: dbms_sql.column_value(v_cursor,1,v_new_letter);
297: dbms_sql.column_value(v_cursor,2,v_new_updated_on);
298: dbms_sql.column_value(v_cursor,3,v_new_updated_by);
299: dbms_sql.column_value(v_cursor,4,v_new_created_on);
300: dbms_sql.column_value(v_cursor,5,v_new_created_by);
301: FOR v_counter IN 1..v_num_col LOOP
302: dbms_sql.column_value(v_cursor,v_counter + 5,v_var1);
303: v_new(v_counter) := v_var1;
304: END LOOP;

Line 302: dbms_sql.column_value(v_cursor,v_counter + 5,v_var1);

298: dbms_sql.column_value(v_cursor,3,v_new_updated_by);
299: dbms_sql.column_value(v_cursor,4,v_new_created_on);
300: dbms_sql.column_value(v_cursor,5,v_new_created_by);
301: FOR v_counter IN 1..v_num_col LOOP
302: dbms_sql.column_value(v_cursor,v_counter + 5,v_var1);
303: v_new(v_counter) := v_var1;
304: END LOOP;
305:
306: --

Line 419: dbms_sql.close_cursor(v_cursor);

415: v_old(v_counter) := v_new(v_counter);
416: END LOOP;
417: v_rec_num := v_rec_num + 1;
418: END LOOP;
419: dbms_sql.close_cursor(v_cursor);
420: --
421: END XTR_AUDIT_RETRIEVE;
422:
423: PROCEDURE XTR_TERM_ACTIONS_RETRIEVE(p_audit_requested_by IN VARCHAR2,