517: num_rows => x_num_rows
518: );
519: END IF;
520:
521: x_purge_rec.table_name := 'WSM_OP_SECONDARY_QUANTITIES';
522: IF (p_option = REPORT_ONLY) THEN
523: SELECT COUNT(*)
524: INTO x_num_rows
525: FROM WSM_OP_SECONDARY_QUANTITIES
521: x_purge_rec.table_name := 'WSM_OP_SECONDARY_QUANTITIES';
522: IF (p_option = REPORT_ONLY) THEN
523: SELECT COUNT(*)
524: INTO x_num_rows
525: FROM WSM_OP_SECONDARY_QUANTITIES
526: WHERE wip_entity_id = x_purge_rec.wip_entity_id;
527: ELSE
528: DELETE FROM WSM_OP_SECONDARY_QUANTITIES
529: WHERE wip_entity_id = x_purge_rec.wip_entity_id;
524: INTO x_num_rows
525: FROM WSM_OP_SECONDARY_QUANTITIES
526: WHERE wip_entity_id = x_purge_rec.wip_entity_id;
527: ELSE
528: DELETE FROM WSM_OP_SECONDARY_QUANTITIES
529: WHERE wip_entity_id = x_purge_rec.wip_entity_id;
530: x_num_rows := SQL%ROWCOUNT;
531: END IF;
532: