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_REQUIREMENT_OPERATIONS

Line 174: x_purge_rec.table_name := 'WIP_REQUIREMENT_OPERATIONS';

170: p_option => p_option,
171: p_purge_rec => x_purge_rec,
172: num_rows => x_num_rows);
173: end if;
174: x_purge_rec.table_name := 'WIP_REQUIREMENT_OPERATIONS';
175: if (p_option = REPORT_ONLY) then
176: select count(*) into x_num_rows from WIP_REQUIREMENT_OPERATIONS where
177: WIP_ENTITY_ID= x_purge_rec.wip_entity_id;
178: else

Line 176: select count(*) into x_num_rows from WIP_REQUIREMENT_OPERATIONS where

172: num_rows => x_num_rows);
173: end if;
174: x_purge_rec.table_name := 'WIP_REQUIREMENT_OPERATIONS';
175: if (p_option = REPORT_ONLY) then
176: select count(*) into x_num_rows from WIP_REQUIREMENT_OPERATIONS where
177: WIP_ENTITY_ID= x_purge_rec.wip_entity_id;
178: else
179: DELETE FROM WIP_REQUIREMENT_OPERATIONS
180: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;

Line 179: DELETE FROM WIP_REQUIREMENT_OPERATIONS

175: if (p_option = REPORT_ONLY) then
176: select count(*) into x_num_rows from WIP_REQUIREMENT_OPERATIONS where
177: WIP_ENTITY_ID= x_purge_rec.wip_entity_id;
178: else
179: DELETE FROM WIP_REQUIREMENT_OPERATIONS
180: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
181: x_num_rows := SQL%ROWCOUNT;
182: end if;
183:

Line 377: x_purge_rec.table_name := 'WIP_REQUIREMENT_OPERATIONS';

373: num_rows => x_num_rows);
374: end if;
375:
376:
377: x_purge_rec.table_name := 'WIP_REQUIREMENT_OPERATIONS';
378: if (p_option = REPORT_ONLY) then
379: select count(*) into x_num_rows from WIP_REQUIREMENT_OPERATIONS
380: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
381: AND REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id;

Line 379: select count(*) into x_num_rows from WIP_REQUIREMENT_OPERATIONS

375:
376:
377: x_purge_rec.table_name := 'WIP_REQUIREMENT_OPERATIONS';
378: if (p_option = REPORT_ONLY) then
379: select count(*) into x_num_rows from WIP_REQUIREMENT_OPERATIONS
380: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
381: AND REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id;
382: else
383: DELETE FROM WIP_REQUIREMENT_OPERATIONS

Line 383: DELETE FROM WIP_REQUIREMENT_OPERATIONS

379: select count(*) into x_num_rows from WIP_REQUIREMENT_OPERATIONS
380: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
381: AND REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id;
382: else
383: DELETE FROM WIP_REQUIREMENT_OPERATIONS
384: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
385: AND REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id;
386: x_num_rows := SQL%ROWCOUNT;
387: end if;