APPS.OEXPURGE dependencies on SO_PICKING_BATCHES

Line 1090: FROM so_picking_batches

1086: syntax_required NUMBER := 0;
1087:
1088: CURSOR SO_LOCK_RECORDS IS
1089: SELECT batch_id -- Lock rows to be purged
1090: FROM so_picking_batches
1091: WHERE batch_id = p_batch_id
1092: AND header_id = p_header_id
1093: FOR UPDATE NOWAIT;
1094: BEGIN

Line 1098: DELETE FROM so_picking_batches

1094: BEGIN
1095: OPEN SO_LOCK_RECORDS;
1096: CLOSE SO_LOCK_RECORDS;
1097:
1098: DELETE FROM so_picking_batches
1099: WHERE batch_id = p_batch_id
1100: AND header_id = p_header_id;
1101:
1102: RETURN SQLCODE;

Line 1111: 'OEPUR: SO_PICKING_BATCHES',

1107: ROLLBACK;
1108: so_record_errors( return_status,
1109: p_request_id,
1110: p_batch_id,
1111: 'OEPUR: SO_PICKING_BATCHES',
1112: NULL );
1113: CLOSE SO_LOCK_RECORDS;
1114: RETURN return_status;
1115: