DBA Data[Home] [Help]

APPS.WSM_JOBPURGE_GRP dependencies on WSM_OP_SECONDARY_QUANTITIES

Line 521: x_purge_rec.table_name := 'WSM_OP_SECONDARY_QUANTITIES';

517: num_rows => x_num_rows
518: );
519: END IF;
520:
521: x_purge_rec.table_name := 'WSM_OP_SECONDARY_QUANTITIES';
522: IF (p_option = REPORT_ONLY) THEN
523: SELECT COUNT(*)
524: INTO x_num_rows
525: FROM WSM_OP_SECONDARY_QUANTITIES

Line 525: FROM WSM_OP_SECONDARY_QUANTITIES

521: x_purge_rec.table_name := 'WSM_OP_SECONDARY_QUANTITIES';
522: IF (p_option = REPORT_ONLY) THEN
523: SELECT COUNT(*)
524: INTO x_num_rows
525: FROM WSM_OP_SECONDARY_QUANTITIES
526: WHERE wip_entity_id = x_purge_rec.wip_entity_id;
527: ELSE
528: DELETE FROM WSM_OP_SECONDARY_QUANTITIES
529: WHERE wip_entity_id = x_purge_rec.wip_entity_id;

Line 528: DELETE FROM WSM_OP_SECONDARY_QUANTITIES

524: INTO x_num_rows
525: FROM WSM_OP_SECONDARY_QUANTITIES
526: WHERE wip_entity_id = x_purge_rec.wip_entity_id;
527: ELSE
528: DELETE FROM WSM_OP_SECONDARY_QUANTITIES
529: WHERE wip_entity_id = x_purge_rec.wip_entity_id;
530: x_num_rows := SQL%ROWCOUNT;
531: END IF;
532: