APPS.WSM_JOBPURGE_GRP dependencies on WSM_JOB_SECONDARY_QUANTITIES

Line 559: x_purge_rec.table_name := 'WSM_JOB_SECONDARY_QUANTITIES';

555: num_rows => x_num_rows
556: );
557: END IF;
558:
559: x_purge_rec.table_name := 'WSM_JOB_SECONDARY_QUANTITIES';
560: IF (p_option = REPORT_ONLY) THEN
561: SELECT COUNT(*)
562: INTO x_num_rows
563: FROM WSM_JOB_SECONDARY_QUANTITIES

Line 563: FROM WSM_JOB_SECONDARY_QUANTITIES

559: x_purge_rec.table_name := 'WSM_JOB_SECONDARY_QUANTITIES';
560: IF (p_option = REPORT_ONLY) THEN
561: SELECT COUNT(*)
562: INTO x_num_rows
563: FROM WSM_JOB_SECONDARY_QUANTITIES
564: WHERE wip_entity_id = x_purge_rec.wip_entity_id;
565: ELSE
566: DELETE FROM WSM_JOB_SECONDARY_QUANTITIES
567: WHERE wip_entity_id = x_purge_rec.wip_entity_id;

Line 566: DELETE FROM WSM_JOB_SECONDARY_QUANTITIES

562: INTO x_num_rows
563: FROM WSM_JOB_SECONDARY_QUANTITIES
564: WHERE wip_entity_id = x_purge_rec.wip_entity_id;
565: ELSE
566: DELETE FROM WSM_JOB_SECONDARY_QUANTITIES
567: WHERE wip_entity_id = x_purge_rec.wip_entity_id;
568: x_num_rows := SQL%ROWCOUNT;
569: END IF;
570: