DBA Data[Home] [Help]

APPS.WSM_JOBPURGE_GRP dependencies on WSM_COPY_OP_NETWORKS

Line 627: x_purge_rec.table_name := 'WSM_COPY_OP_NETWORKS';

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

Line 632: from WSM_COPY_OP_NETWORKS

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:

Line 637: DELETE FROM WSM_COPY_OP_NETWORKS

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;