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.WIP_WICTPG dependencies on WIP_OPERATION_RESOURCES

Line 193: x_purge_rec.table_name := 'WIP_OPERATION_RESOURCES';

189: p_purge_rec => x_purge_rec,
190: num_rows => x_num_rows);
191: end if;
192:
193: x_purge_rec.table_name := 'WIP_OPERATION_RESOURCES';
194: if (p_option = REPORT_ONLY) then
195: select count(*) into x_num_rows from WIP_OPERATION_RESOURCES where
196: WIP_ENTITY_ID= x_purge_rec.wip_entity_id;
197: else

Line 195: select count(*) into x_num_rows from WIP_OPERATION_RESOURCES where

191: end if;
192:
193: x_purge_rec.table_name := 'WIP_OPERATION_RESOURCES';
194: if (p_option = REPORT_ONLY) then
195: select count(*) into x_num_rows from WIP_OPERATION_RESOURCES where
196: WIP_ENTITY_ID= x_purge_rec.wip_entity_id;
197: else
198: DELETE FROM WIP_OPERATION_RESOURCES
199: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;

Line 198: DELETE FROM WIP_OPERATION_RESOURCES

194: if (p_option = REPORT_ONLY) then
195: select count(*) into x_num_rows from WIP_OPERATION_RESOURCES where
196: WIP_ENTITY_ID= x_purge_rec.wip_entity_id;
197: else
198: DELETE FROM WIP_OPERATION_RESOURCES
199: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
200: x_num_rows := SQL%ROWCOUNT;
201: end if;
202:

Line 396: x_purge_rec.table_name := 'WIP_OPERATION_RESOURCES';

392: p_purge_rec => x_purge_rec,
393: num_rows => x_num_rows);
394: end if;
395:
396: x_purge_rec.table_name := 'WIP_OPERATION_RESOURCES';
397: if (p_option = REPORT_ONLY) then
398: select count(*) into x_num_rows from WIP_OPERATION_RESOURCES
399: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
400: AND REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id;

Line 398: select count(*) into x_num_rows from WIP_OPERATION_RESOURCES

394: end if;
395:
396: x_purge_rec.table_name := 'WIP_OPERATION_RESOURCES';
397: if (p_option = REPORT_ONLY) then
398: select count(*) into x_num_rows from WIP_OPERATION_RESOURCES
399: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
400: AND REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id;
401: else
402: DELETE FROM WIP_OPERATION_RESOURCES

Line 402: DELETE FROM WIP_OPERATION_RESOURCES

398: select count(*) into x_num_rows from WIP_OPERATION_RESOURCES
399: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
400: AND REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id;
401: else
402: DELETE FROM WIP_OPERATION_RESOURCES
403: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
404: AND REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id;
405: x_num_rows := SQL%ROWCOUNT;
406: end if;