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.WSM_JOBPURGE_GRP dependencies on WSM_SERIAL_TXN_INTERFACE

Line 256: FROM WSM_SERIAL_TXN_INTERFACE

252: -- Bug 4722718 : Purge the Serial txn interface rows as well...
253: IF (p_option = REPORT_ONLY) THEN
254: SELECT count(*)
255: INTO x_tmp_num_rows
256: FROM WSM_SERIAL_TXN_INTERFACE
257: WHERE header_id = x_header_id
258: AND transaction_type_id = 3;
259: ELSE
260: DELETE FROM WSM_SERIAL_TXN_INTERFACE

Line 260: DELETE FROM WSM_SERIAL_TXN_INTERFACE

256: FROM WSM_SERIAL_TXN_INTERFACE
257: WHERE header_id = x_header_id
258: AND transaction_type_id = 3;
259: ELSE
260: DELETE FROM WSM_SERIAL_TXN_INTERFACE
261: WHERE header_id = x_header_id
262: AND transaction_type_id = 3;
263: x_tmp_num_rows := SQL%ROWCOUNT;
264: END IF;

Line 345: FROM WSM_SERIAL_TXN_INTERFACE

341: -- Bug 4722718 : Purge the Serial txn interface rows as well...
342: IF (p_option = REPORT_ONLY) THEN
343: SELECT count(*)
344: INTO x_tmp_num_rows
345: FROM WSM_SERIAL_TXN_INTERFACE
346: WHERE header_id = x_header_id
347: AND transaction_type_id = 1;
348: ELSE
349: DELETE FROM WSM_SERIAL_TXN_INTERFACE

Line 349: DELETE FROM WSM_SERIAL_TXN_INTERFACE

345: FROM WSM_SERIAL_TXN_INTERFACE
346: WHERE header_id = x_header_id
347: AND transaction_type_id = 1;
348: ELSE
349: DELETE FROM WSM_SERIAL_TXN_INTERFACE
350: WHERE header_id = x_header_id
351: AND transaction_type_id = 1;
352: x_tmp_num_rows := SQL%ROWCOUNT;
353: END IF;

Line 424: FROM WSM_SERIAL_TXN_INTERFACE

420: -- Bug 4722718 : Purge the Serial txn interface rows as well...
421: IF (p_option = REPORT_ONLY) THEN
422: SELECT count(*)
423: INTO x_tmp_num_rows
424: FROM WSM_SERIAL_TXN_INTERFACE
425: WHERE header_id = x_header_id
426: AND transaction_type_id = 2;
427: ELSE
428: DELETE FROM WSM_SERIAL_TXN_INTERFACE

Line 428: DELETE FROM WSM_SERIAL_TXN_INTERFACE

424: FROM WSM_SERIAL_TXN_INTERFACE
425: WHERE header_id = x_header_id
426: AND transaction_type_id = 2;
427: ELSE
428: DELETE FROM WSM_SERIAL_TXN_INTERFACE
429: WHERE header_id = x_header_id
430: AND transaction_type_id = 2;
431:
432: x_tmp_num_rows := SQL%ROWCOUNT;

Line 473: x_purge_rec.table_name := 'WSM_SERIAL_TXN_INTERFACE';

469: num_rows => x_num_rows);
470: end if;
471:
472: -- Bug 4722718 : Start
473: x_purge_rec.table_name := 'WSM_SERIAL_TXN_INTERFACE';
474: IF l_serial_intf_rows > 0 THEN
475: before_append_report( p_option => p_option,
476: p_purge_rec => x_purge_rec,
477: num_rows => l_serial_intf_rows);