APPS.WSM_JOBPURGE_GRP dependencies on WSM_COPY_OP_RESOURCE_INSTANCES

Line 673: x_purge_rec.table_name := 'WSM_COPY_OP_RESOURCE_INSTANCES';

669: p_purge_rec => x_purge_rec,
670: num_rows => x_num_rows);
671: end if;
672:
673: x_purge_rec.table_name := 'WSM_COPY_OP_RESOURCE_INSTANCES';
674:
675: if (p_option = REPORT_ONLY) then
676: select count(*)
677: into x_num_rows

Line 678: from WSM_COPY_OP_RESOURCE_INSTANCES

674:
675: if (p_option = REPORT_ONLY) then
676: select count(*)
677: into x_num_rows
678: from WSM_COPY_OP_RESOURCE_INSTANCES
679: where wip_entity_id = x_purge_rec.wip_entity_id;
680:
681: else
682:

Line 683: DELETE FROM WSM_COPY_OP_RESOURCE_INSTANCES

679: where wip_entity_id = x_purge_rec.wip_entity_id;
680:
681: else
682:
683: DELETE FROM WSM_COPY_OP_RESOURCE_INSTANCES
684: WHERE wip_entity_id = x_purge_rec.wip_entity_id;
685: x_num_rows := SQL%ROWCOUNT;
686:
687: end if;