APPS.WSM_JOBPURGE_GRP dependencies on WIP_RESOURCE_ACTUAL_TIMES

Line 540: x_purge_rec.table_name := 'WIP_RESOURCE_ACTUAL_TIMES';

536: num_rows => x_num_rows
537: );
538: END IF;
539:
540: x_purge_rec.table_name := 'WIP_RESOURCE_ACTUAL_TIMES';
541: IF (p_option = REPORT_ONLY) THEN
542: SELECT COUNT(*)
543: INTO x_num_rows
544: FROM WIP_RESOURCE_ACTUAL_TIMES

Line 544: FROM WIP_RESOURCE_ACTUAL_TIMES

540: x_purge_rec.table_name := 'WIP_RESOURCE_ACTUAL_TIMES';
541: IF (p_option = REPORT_ONLY) THEN
542: SELECT COUNT(*)
543: INTO x_num_rows
544: FROM WIP_RESOURCE_ACTUAL_TIMES
545: WHERE wip_entity_id = x_purge_rec.wip_entity_id;
546: ELSE
547: DELETE FROM WIP_RESOURCE_ACTUAL_TIMES
548: WHERE wip_entity_id = x_purge_rec.wip_entity_id;

Line 547: DELETE FROM WIP_RESOURCE_ACTUAL_TIMES

543: INTO x_num_rows
544: FROM WIP_RESOURCE_ACTUAL_TIMES
545: WHERE wip_entity_id = x_purge_rec.wip_entity_id;
546: ELSE
547: DELETE FROM WIP_RESOURCE_ACTUAL_TIMES
548: WHERE wip_entity_id = x_purge_rec.wip_entity_id;
549: x_num_rows := SQL%ROWCOUNT;
550: END IF;
551: