APPS.OEXPURGE dependencies on SO_PICKING_CANCELLATIONS

Line 1127: FROM so_picking_cancellations

1123: syntax_required NUMBER := 0;
1124:
1125: CURSOR SO_LOCK_RECORDS IS
1126: SELECT picking_line_id -- Lock rows to be purged
1127: FROM so_picking_cancellations
1128: WHERE picking_line_id = p_picking_line_id
1129: FOR UPDATE NOWAIT;
1130: BEGIN
1131: OPEN SO_LOCK_RECORDS;

Line 1134: DELETE FROM so_picking_cancellations

1130: BEGIN
1131: OPEN SO_LOCK_RECORDS;
1132: CLOSE SO_LOCK_RECORDS;
1133:
1134: DELETE FROM so_picking_cancellations
1135: WHERE picking_line_id = p_picking_line_id;
1136:
1137: RETURN SQLCODE;
1138:

Line 1146: 'OEPUR: SO_PICKING_CANCELLATIONS',

1142: ROLLBACK;
1143: so_record_errors( return_status,
1144: p_request_id,
1145: p_picking_line_id,
1146: 'OEPUR: SO_PICKING_CANCELLATIONS',
1147: NULL );
1148: CLOSE SO_LOCK_RECORDS;
1149: RETURN return_status;
1150: