623: p_purge_rec => x_purge_rec,
624: num_rows => x_num_rows);
625: end if;
626:
627: x_purge_rec.table_name := 'WSM_COPY_OP_NETWORKS';
628:
629: if (p_option = REPORT_ONLY) then
630: select count(*)
631: into x_num_rows
628:
629: if (p_option = REPORT_ONLY) then
630: select count(*)
631: into x_num_rows
632: from WSM_COPY_OP_NETWORKS
633: where wip_entity_id = x_purge_rec.wip_entity_id;
634:
635: else
636:
633: where wip_entity_id = x_purge_rec.wip_entity_id;
634:
635: else
636:
637: DELETE FROM WSM_COPY_OP_NETWORKS
638: WHERE wip_entity_id = x_purge_rec.wip_entity_id;
639: x_num_rows := SQL%ROWCOUNT;
640:
641: end if;