APPS.OEXPURGE dependencies on SO_PICKING_LINE_DETAILS

Line 1234: FROM so_picking_line_details

1230: syntax_required NUMBER := 0;
1231:
1232: CURSOR SO_LOCK_RECORDS IS
1233: SELECT picking_line_id -- Lock rows to be purged
1234: FROM so_picking_line_details
1235: WHERE picking_line_id = p_picking_line_id
1236: FOR UPDATE NOWAIT;
1237: BEGIN
1238: OPEN SO_LOCK_RECORDS;

Line 1241: DELETE FROM so_picking_line_details

1237: BEGIN
1238: OPEN SO_LOCK_RECORDS;
1239: CLOSE SO_LOCK_RECORDS;
1240:
1241: DELETE FROM so_picking_line_details
1242: WHERE picking_line_id = p_picking_line_id;
1243:
1244: RETURN SQLCODE;
1245:

Line 1253: 'OEPUR: SO_PICKING_LINE_DETAILS',

1249: ROLLBACK;
1250: so_record_errors( return_status,
1251: p_request_id,
1252: p_picking_line_id,
1253: 'OEPUR: SO_PICKING_LINE_DETAILS',
1254: NULL );
1255: CLOSE SO_LOCK_RECORDS;
1256: RETURN return_status;
1257: