DBA Data[Home] [Help]

APPS.WIP_WICTPG dependencies on WIP_REQ_OPERATION_COST_DETAILS

Line 266: x_purge_rec.table_name := 'WIP_REQ_OPERATION_COST_DETAILS';

262: p_purge_rec => x_purge_rec,
263: num_rows => x_num_rows);
264: end if;
265:
266: x_purge_rec.table_name := 'WIP_REQ_OPERATION_COST_DETAILS';
267:
268: if (p_option = REPORT_ONLY) then
269: select count(*) into x_num_rows from WIP_REQ_OPERATION_COST_DETAILS
270: where WIP_ENTITY_ID=to_char(x_purge_rec.wip_entity_id);

Line 269: select count(*) into x_num_rows from WIP_REQ_OPERATION_COST_DETAILS

265:
266: x_purge_rec.table_name := 'WIP_REQ_OPERATION_COST_DETAILS';
267:
268: if (p_option = REPORT_ONLY) then
269: select count(*) into x_num_rows from WIP_REQ_OPERATION_COST_DETAILS
270: where WIP_ENTITY_ID=to_char(x_purge_rec.wip_entity_id);
271: else
272: DELETE FROM WIP_REQ_OPERATION_COST_DETAILS
273: WHERE WIP_ENTITY_ID = to_char(x_purge_rec.wip_entity_id);

Line 272: DELETE FROM WIP_REQ_OPERATION_COST_DETAILS

268: if (p_option = REPORT_ONLY) then
269: select count(*) into x_num_rows from WIP_REQ_OPERATION_COST_DETAILS
270: where WIP_ENTITY_ID=to_char(x_purge_rec.wip_entity_id);
271: else
272: DELETE FROM WIP_REQ_OPERATION_COST_DETAILS
273: WHERE WIP_ENTITY_ID = to_char(x_purge_rec.wip_entity_id);
274: x_num_rows := SQL%ROWCOUNT;
275: end if;
276: