APPS.WSM_JOBPURGE_GRP dependencies on WSM_COPY_OP_RESOURCES

Line 650: x_purge_rec.table_name := 'WSM_COPY_OP_RESOURCES';

646: p_purge_rec => x_purge_rec,
647: num_rows => x_num_rows);
648: end if;
649:
650: x_purge_rec.table_name := 'WSM_COPY_OP_RESOURCES';
651:
652: if (p_option = REPORT_ONLY) then
653: select count(*)
654: into x_num_rows

Line 655: from WSM_COPY_OP_RESOURCES

651:
652: if (p_option = REPORT_ONLY) then
653: select count(*)
654: into x_num_rows
655: from WSM_COPY_OP_RESOURCES
656: where wip_entity_id = x_purge_rec.wip_entity_id;
657:
658: else
659:

Line 660: DELETE FROM WSM_COPY_OP_RESOURCES

656: where wip_entity_id = x_purge_rec.wip_entity_id;
657:
658: else
659:
660: DELETE FROM WSM_COPY_OP_RESOURCES
661: WHERE wip_entity_id = x_purge_rec.wip_entity_id;
662: x_num_rows := SQL%ROWCOUNT;
663:
664: end if;