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_OPERATIONS

Line 158: x_purge_rec.table_name := 'WIP_OPERATIONS';

154: x_purge_rec.info_type := ROWS_AFFECTED;
155: x_purge_rec.entity_name := p_purge_request.wip_entity_name;
156: x_purge_rec.line_code := p_purge_request.line_code;
157:
158: x_purge_rec.table_name := 'WIP_OPERATIONS';
159: if (p_option = REPORT_ONLY) then
160: select count(*) into x_num_rows from WIP_OPERATIONS where
161: WIP_ENTITY_ID= x_purge_rec.wip_entity_id;
162: else

Line 160: select count(*) into x_num_rows from WIP_OPERATIONS where

156: x_purge_rec.line_code := p_purge_request.line_code;
157:
158: x_purge_rec.table_name := 'WIP_OPERATIONS';
159: if (p_option = REPORT_ONLY) then
160: select count(*) into x_num_rows from WIP_OPERATIONS where
161: WIP_ENTITY_ID= x_purge_rec.wip_entity_id;
162: else
163: DELETE FROM WIP_OPERATIONS
164: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;

Line 163: DELETE FROM WIP_OPERATIONS

159: if (p_option = REPORT_ONLY) then
160: select count(*) into x_num_rows from WIP_OPERATIONS where
161: WIP_ENTITY_ID= x_purge_rec.wip_entity_id;
162: else
163: DELETE FROM WIP_OPERATIONS
164: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
165: x_num_rows := SQL%ROWCOUNT;
166: end if;
167:

Line 355: x_purge_rec.table_name := 'WIP_OPERATIONS';

351: x_purge_rec.info_type := ROWS_AFFECTED;
352: x_purge_rec.entity_name := p_purge_request.wip_entity_name;
353: x_purge_rec.line_code := p_purge_request.line_code;
354:
355: x_purge_rec.table_name := 'WIP_OPERATIONS';
356: if (p_option = REPORT_ONLY) then
357: select count(*) into x_num_rows from WIP_OPERATIONS
358: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
359: AND REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id

Line 357: select count(*) into x_num_rows from WIP_OPERATIONS

353: x_purge_rec.line_code := p_purge_request.line_code;
354:
355: x_purge_rec.table_name := 'WIP_OPERATIONS';
356: if (p_option = REPORT_ONLY) then
357: select count(*) into x_num_rows from WIP_OPERATIONS
358: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
359: AND REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id
360: AND ORGANIZATION_ID = x_purge_rec.org_id;
361: else

Line 362: DELETE FROM WIP_OPERATIONS

358: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
359: AND REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id
360: AND ORGANIZATION_ID = x_purge_rec.org_id;
361: else
362: DELETE FROM WIP_OPERATIONS
363: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
364: AND REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id
365: AND ORGANIZATION_ID = x_purge_rec.org_id;
366: x_num_rows := SQL%ROWCOUNT;