DBA Data[Home] [Help]

APPS.WIP_WICTPG dependencies on WIP_OPERATION_OVERHEADS

Line 249: x_purge_rec.table_name := 'WIP_OPERATION_OVERHEADS';

245: num_rows => x_num_rows);
246: end if;
247:
248: /* Fix for bug 2146528*/
249: x_purge_rec.table_name := 'WIP_OPERATION_OVERHEADS';
250: if (p_option = REPORT_ONLY) then
251: select count(*) into x_num_rows from WIP_OPERATION_OVERHEADS
252: where WIP_ENTITY_ID=to_char(x_purge_rec.wip_entity_id);
253: else

Line 251: select count(*) into x_num_rows from WIP_OPERATION_OVERHEADS

247:
248: /* Fix for bug 2146528*/
249: x_purge_rec.table_name := 'WIP_OPERATION_OVERHEADS';
250: if (p_option = REPORT_ONLY) then
251: select count(*) into x_num_rows from WIP_OPERATION_OVERHEADS
252: where WIP_ENTITY_ID=to_char(x_purge_rec.wip_entity_id);
253: else
254: DELETE FROM WIP_OPERATION_OVERHEADS
255: WHERE WIP_ENTITY_ID = to_char(x_purge_rec.wip_entity_id);

Line 254: DELETE FROM WIP_OPERATION_OVERHEADS

250: if (p_option = REPORT_ONLY) then
251: select count(*) into x_num_rows from WIP_OPERATION_OVERHEADS
252: where WIP_ENTITY_ID=to_char(x_purge_rec.wip_entity_id);
253: else
254: DELETE FROM WIP_OPERATION_OVERHEADS
255: WHERE WIP_ENTITY_ID = to_char(x_purge_rec.wip_entity_id);
256: x_num_rows := SQL%ROWCOUNT;
257: end if;
258: