227: num_rows => x_num_rows);
228: end if;
229: /* end fix for bug#4774572*/
230:
231: x_purge_rec.table_name := 'WIP_SHOP_FLOOR_STATUSES';
232: if (p_option = REPORT_ONLY) then
233: select count(*) into x_num_rows from WIP_SHOP_FLOOR_STATUSES where
234: WIP_ENTITY_ID= x_purge_rec.wip_entity_id;
235: else
229: /* end fix for bug#4774572*/
230:
231: x_purge_rec.table_name := 'WIP_SHOP_FLOOR_STATUSES';
232: if (p_option = REPORT_ONLY) then
233: select count(*) into x_num_rows from WIP_SHOP_FLOOR_STATUSES where
234: WIP_ENTITY_ID= x_purge_rec.wip_entity_id;
235: else
236: DELETE FROM WIP_SHOP_FLOOR_STATUSES
237: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
232: if (p_option = REPORT_ONLY) then
233: select count(*) into x_num_rows from WIP_SHOP_FLOOR_STATUSES where
234: WIP_ENTITY_ID= x_purge_rec.wip_entity_id;
235: else
236: DELETE FROM WIP_SHOP_FLOOR_STATUSES
237: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
238: x_num_rows := SQL%ROWCOUNT;
239: end if;
240: