APPS.OEXPURGE dependencies on SO_PICKING_HEADERS

Line 1166: FROM so_picking_headers

1162:
1163: CURSOR purge_picking IS
1164: SELECT picking_header_id,
1165: batch_id
1166: FROM so_picking_headers
1167: WHERE order_header_id = p_header_id;
1168: BEGIN
1169: OPEN purge_picking;
1170:

Line 1179: FROM so_picking_headers

1175: OR purge_picking%NOTFOUND IS NULL; -- empty cursor
1176:
1177: SELECT order_header_id -- Lock rows to be purged
1178: INTO syntax_required
1179: FROM so_picking_headers
1180: WHERE picking_header_id = v_picking_header_id
1181: AND batch_id = v_batch_id
1182: FOR UPDATE NOWAIT;
1183:

Line 1199: DELETE FROM so_picking_headers

1195: p_request_id );
1196: END IF;
1197:
1198: IF return_status > -1 THEN
1199: DELETE FROM so_picking_headers
1200: WHERE picking_header_id = v_picking_header_id
1201: AND batch_id = v_batch_id;
1202: ELSE
1203: EXIT; -- abort additional processing

Line 1218: 'OEPUR: SO_PICKING_HEADERS',

1214: ROLLBACK;
1215: so_record_errors( return_status,
1216: p_request_id,
1217: v_picking_header_id,
1218: 'OEPUR: SO_PICKING_HEADERS',
1219: NULL );
1220: CLOSE purge_picking;
1221: RETURN return_status;
1222: