DBA Data[Home] [Help]

APPS.WSM_JOBPURGE_GRP dependencies on WSM_COPY_OPERATIONS

Line 604: x_purge_rec.table_name := 'WSM_COPY_OPERATIONS';

600: end if;
601: END IF;
602: -- IF Clause added for Bug 4918553
603:
604: x_purge_rec.table_name := 'WSM_COPY_OPERATIONS';
605:
606: if (p_option = REPORT_ONLY) then
607: select count(*)
608: into x_num_rows

Line 609: from WSM_COPY_OPERATIONS

605:
606: if (p_option = REPORT_ONLY) then
607: select count(*)
608: into x_num_rows
609: from WSM_COPY_OPERATIONS
610: where wip_entity_id = x_purge_rec.wip_entity_id;
611:
612: else
613:

Line 614: DELETE FROM WSM_COPY_OPERATIONS

610: where wip_entity_id = x_purge_rec.wip_entity_id;
611:
612: else
613:
614: DELETE FROM WSM_COPY_OPERATIONS
615: WHERE wip_entity_id = x_purge_rec.wip_entity_id;
616: x_num_rows := SQL%ROWCOUNT;
617:
618: end if;