APPS.WSM_JOBPURGE_GRP dependencies on WSM_COPY_REQUIREMENT_OPS

Line 721: x_purge_rec.table_name := 'WSM_COPY_REQUIREMENT_OPS';

717: num_rows => x_num_rows);
718: end if;
719:
720:
721: x_purge_rec.table_name := 'WSM_COPY_REQUIREMENT_OPS';
722:
723: if (p_option = REPORT_ONLY) then
724: select count(*)
725: into x_num_rows

Line 726: from WSM_COPY_REQUIREMENT_OPS

722:
723: if (p_option = REPORT_ONLY) then
724: select count(*)
725: into x_num_rows
726: from WSM_COPY_REQUIREMENT_OPS
727: where wip_entity_id = x_purge_rec.wip_entity_id;
728:
729: else
730:

Line 731: DELETE FROM WSM_COPY_REQUIREMENT_OPS

727: where wip_entity_id = x_purge_rec.wip_entity_id;
728:
729: else
730:
731: DELETE FROM WSM_COPY_REQUIREMENT_OPS
732: WHERE wip_entity_id = x_purge_rec.wip_entity_id;
733: x_num_rows := SQL%ROWCOUNT;
734:
735: end if;