APPS.WSM_JOBPURGE_GRP dependencies on WSM_OP_REASON_CODES

Line 502: x_purge_rec.table_name := 'WSM_OP_REASON_CODES';

498:
499: -- IF Clause added for Bug 4918553
500: -- Delete the data from the below tables only if the detail flag is set..
501: IF p_detail_flag THEN
502: x_purge_rec.table_name := 'WSM_OP_REASON_CODES';
503: IF (p_option = REPORT_ONLY) THEN
504: SELECT COUNT(*)
505: INTO x_num_rows
506: FROM WSM_OP_REASON_CODES

Line 506: FROM WSM_OP_REASON_CODES

502: x_purge_rec.table_name := 'WSM_OP_REASON_CODES';
503: IF (p_option = REPORT_ONLY) THEN
504: SELECT COUNT(*)
505: INTO x_num_rows
506: FROM WSM_OP_REASON_CODES
507: WHERE wip_entity_id = x_purge_rec.wip_entity_id;
508: ELSE
509: DELETE FROM WSM_OP_REASON_CODES
510: WHERE wip_entity_id = x_purge_rec.wip_entity_id;

Line 509: DELETE FROM WSM_OP_REASON_CODES

505: INTO x_num_rows
506: FROM WSM_OP_REASON_CODES
507: WHERE wip_entity_id = x_purge_rec.wip_entity_id;
508: ELSE
509: DELETE FROM WSM_OP_REASON_CODES
510: WHERE wip_entity_id = x_purge_rec.wip_entity_id;
511: x_num_rows := SQL%ROWCOUNT;
512: END IF;
513: