[Home] [Help]
PACKAGE BODY: APPS.MTL_TRANSACTION_LOTS_INTF_PKG
Source
1 package body MTL_TRANSACTION_LOTS_INTF_PKG as
2 /* $Header: INVMTLIB.pls 120.1 2005/10/18 18:39:38 cjandhya noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out nocopy ROWID,
5 X_TRANSACTION_INTERFACE_ID in NUMBER,
6 X_EXPIRATION_ACTION_CODE in VARCHAR2,
7 X_EXPIRATION_ACTION_DATE in DATE,
8 X_HOLD_DATE in DATE,
9 X_ORIGINATION_TYPE in NUMBER,
10 X_PARENT_LOT_NUMBER in VARCHAR2,
11 X_REASON_ID in NUMBER,
12 X_SOURCE_CODE in VARCHAR2,
13 X_SOURCE_LINE_ID in NUMBER,
14 X_REQUEST_ID in NUMBER,
15 X_LOT_EXPIRATION_DATE in DATE,
16 X_TRANSACTION_QUANTITY in NUMBER,
17 X_PRIMARY_QUANTITY in NUMBER,
18 X_SERIAL_TRANSACTION_TEMP_ID in NUMBER,
19 X_ERROR_CODE in VARCHAR2,
20 X_PROCESS_FLAG in VARCHAR2,
21 X_DESCRIPTION in VARCHAR2,
22 X_VENDOR_NAME in VARCHAR2,
23 X_SUPPLIER_LOT_NUMBER in VARCHAR2,
24 X_ORIGINATION_DATE in DATE,
25 X_DATE_CODE in VARCHAR2,
26 X_GRADE_CODE in VARCHAR2,
27 X_CHANGE_DATE in DATE,
28 X_MATURITY_DATE in DATE,
29 X_STATUS_ID in NUMBER,
30 X_RETEST_DATE in DATE,
31 X_AGE in NUMBER,
32 X_ITEM_SIZE in NUMBER,
33 X_COLOR in VARCHAR2,
34 X_VOLUME in NUMBER,
35 X_VOLUME_UOM in VARCHAR2,
36 X_PLACE_OF_ORIGIN in VARCHAR2,
37 X_BEST_BY_DATE in DATE,
38 X_LENGTH in NUMBER,
39 X_LENGTH_UOM in VARCHAR2,
40 X_RECYCLED_CONTENT in NUMBER,
41 X_THICKNESS in NUMBER,
42 X_THICKNESS_UOM in VARCHAR2,
43 X_WIDTH in NUMBER,
44 X_WIDTH_UOM in VARCHAR2,
45 X_CURL_WRINKLE_FOLD in VARCHAR2,
46 X_LOT_ATTRIBUTE_CATEGORY in VARCHAR2,
47 X_C_ATTRIBUTE1 in VARCHAR2,
48 X_C_ATTRIBUTE2 in VARCHAR2,
49 X_C_ATTRIBUTE3 in VARCHAR2,
50 X_C_ATTRIBUTE4 in VARCHAR2,
51 X_C_ATTRIBUTE5 in VARCHAR2,
52 X_C_ATTRIBUTE6 in VARCHAR2,
53 X_C_ATTRIBUTE7 in VARCHAR2,
54 X_C_ATTRIBUTE8 in VARCHAR2,
55 X_C_ATTRIBUTE9 in VARCHAR2,
56 X_C_ATTRIBUTE10 in VARCHAR2,
57 X_C_ATTRIBUTE11 in VARCHAR2,
58 X_C_ATTRIBUTE12 in VARCHAR2,
59 X_C_ATTRIBUTE13 in VARCHAR2,
60 X_C_ATTRIBUTE14 in VARCHAR2,
61 X_C_ATTRIBUTE15 in VARCHAR2,
62 X_C_ATTRIBUTE16 in VARCHAR2,
63 X_C_ATTRIBUTE17 in VARCHAR2,
64 X_C_ATTRIBUTE18 in VARCHAR2,
65 X_C_ATTRIBUTE19 in VARCHAR2,
66 X_C_ATTRIBUTE20 in VARCHAR2,
67 X_D_ATTRIBUTE1 in DATE,
68 X_D_ATTRIBUTE2 in DATE,
69 X_D_ATTRIBUTE3 in DATE,
70 X_D_ATTRIBUTE4 in DATE,
71 X_D_ATTRIBUTE5 in DATE,
72 X_D_ATTRIBUTE6 in DATE,
73 X_D_ATTRIBUTE7 in DATE,
74 X_D_ATTRIBUTE8 in DATE,
75 X_D_ATTRIBUTE9 in DATE,
76 X_D_ATTRIBUTE10 in DATE,
77 X_N_ATTRIBUTE1 in NUMBER,
78 X_N_ATTRIBUTE2 in NUMBER,
79 X_N_ATTRIBUTE3 in NUMBER,
80 X_N_ATTRIBUTE4 in NUMBER,
81 X_N_ATTRIBUTE5 in NUMBER,
82 X_N_ATTRIBUTE6 in NUMBER,
83 X_N_ATTRIBUTE7 in NUMBER,
84 X_N_ATTRIBUTE8 in NUMBER,
85 X_N_ATTRIBUTE9 in NUMBER,
86 X_N_ATTRIBUTE10 in NUMBER,
87 X_VENDOR_ID in NUMBER,
88 X_TERRITORY_CODE in VARCHAR2,
89 X_PRODUCT_CODE in VARCHAR2,
90 X_PRODUCT_TRANSACTION_ID in NUMBER,
91 X_SECONDARY_TRANSACTION_QUANTI in NUMBER,
92 X_SUBLOT_NUM in VARCHAR2,
93 X_REASON_CODE in VARCHAR2,
94 X_ATTRIBUTE_CATEGORY in VARCHAR2,
95 X_ATTRIBUTE1 in VARCHAR2,
96 X_ATTRIBUTE2 in VARCHAR2,
97 X_ATTRIBUTE3 in VARCHAR2,
98 X_ATTRIBUTE4 in VARCHAR2,
99 X_ATTRIBUTE5 in VARCHAR2,
100 X_ATTRIBUTE6 in VARCHAR2,
101 X_ATTRIBUTE7 in VARCHAR2,
102 X_ATTRIBUTE8 in VARCHAR2,
103 X_ATTRIBUTE9 in VARCHAR2,
104 X_ATTRIBUTE10 in VARCHAR2,
105 X_ATTRIBUTE11 in VARCHAR2,
106 X_ATTRIBUTE12 in VARCHAR2,
107 X_ATTRIBUTE13 in VARCHAR2,
108 X_ATTRIBUTE14 in VARCHAR2,
109 X_ATTRIBUTE15 in VARCHAR2,
110 X_LOT_NUMBER in VARCHAR2,
111 X_CREATION_DATE in DATE,
112 X_CREATED_BY in NUMBER,
113 X_LAST_UPDATE_DATE in DATE,
114 X_LAST_UPDATED_BY in NUMBER,
115 X_LAST_UPDATE_LOGIN in NUMBER,
116 X_PARENT_OBJECT_TYPE IN NUMBER,
117 X_PARENT_OBJECT_ID IN NUMBER,
118 X_PARENT_OBJECT_NUMBER IN VARCHAR2,
119 X_PARENT_OBJECT_TYPE2 IN NUMBER,
120 X_PARENT_OBJECT_ID2 IN NUMBER,
121 X_PARENT_OBJECT_NUMBER2 IN VARCHAR2,
122 X_PARENT_ITEM_ID IN NUMBER
123 ) IS
124 l_transaction_interface_id NUMBER;
125 l_transaction_quantity NUMBER;
126 BEGIN
127 --SELECT mtl_material_transactions_s.NEXTVAL
128 --INTO l_transaction_interface_id FROM dual;
129 --l_transaction_quantity := 10;
130
131 insert into MTL_TRANSACTION_LOTS_INTERFACE (
132 EXPIRATION_ACTION_CODE,
133 EXPIRATION_ACTION_DATE,
134 HOLD_DATE,
135 ORIGINATION_TYPE,
136 PARENT_LOT_NUMBER,
137 REASON_ID,
138 TRANSACTION_INTERFACE_ID,
139 SOURCE_CODE,
140 SOURCE_LINE_ID,
141 REQUEST_ID,
142 LOT_EXPIRATION_DATE,
143 TRANSACTION_QUANTITY,
144 PRIMARY_QUANTITY,
145 SERIAL_TRANSACTION_TEMP_ID,
146 ERROR_CODE,
147 PROCESS_FLAG,
148 DESCRIPTION,
149 VENDOR_NAME,
150 SUPPLIER_LOT_NUMBER,
151 ORIGINATION_DATE,
152 DATE_CODE,
153 GRADE_CODE,
154 CHANGE_DATE,
155 MATURITY_DATE,
156 STATUS_ID,
157 RETEST_DATE,
158 AGE,
159 ITEM_SIZE,
160 COLOR,
161 VOLUME,
162 VOLUME_UOM,
163 PLACE_OF_ORIGIN,
164 BEST_BY_DATE,
165 LENGTH,
166 LENGTH_UOM,
167 RECYCLED_CONTENT,
168 THICKNESS,
169 THICKNESS_UOM,
170 WIDTH,
171 WIDTH_UOM,
172 CURL_WRINKLE_FOLD,
173 LOT_ATTRIBUTE_CATEGORY,
174 C_ATTRIBUTE1,
175 C_ATTRIBUTE2,
176 C_ATTRIBUTE3,
177 C_ATTRIBUTE4,
178 C_ATTRIBUTE5,
179 C_ATTRIBUTE6,
180 C_ATTRIBUTE7,
181 C_ATTRIBUTE8,
182 C_ATTRIBUTE9,
183 C_ATTRIBUTE10,
184 C_ATTRIBUTE11,
185 C_ATTRIBUTE12,
186 C_ATTRIBUTE13,
187 C_ATTRIBUTE14,
188 C_ATTRIBUTE15,
189 C_ATTRIBUTE16,
190 C_ATTRIBUTE17,
191 C_ATTRIBUTE18,
192 C_ATTRIBUTE19,
193 C_ATTRIBUTE20,
194 D_ATTRIBUTE1,
195 D_ATTRIBUTE2,
196 D_ATTRIBUTE3,
197 D_ATTRIBUTE4,
198 D_ATTRIBUTE5,
199 D_ATTRIBUTE6,
200 D_ATTRIBUTE7,
201 D_ATTRIBUTE8,
202 D_ATTRIBUTE9,
203 D_ATTRIBUTE10,
204 N_ATTRIBUTE1,
205 N_ATTRIBUTE2,
206 N_ATTRIBUTE3,
207 N_ATTRIBUTE4,
208 N_ATTRIBUTE5,
209 N_ATTRIBUTE6,
210 N_ATTRIBUTE7,
211 N_ATTRIBUTE8,
212 N_ATTRIBUTE9,
213 N_ATTRIBUTE10,
214 VENDOR_ID,
215 TERRITORY_CODE,
216 PRODUCT_CODE,
217 PRODUCT_TRANSACTION_ID,
218 SECONDARY_TRANSACTION_QUANTITY,
219 SUBLOT_NUM,
220 REASON_CODE,
221 ATTRIBUTE_CATEGORY,
222 ATTRIBUTE1,
223 ATTRIBUTE2,
224 ATTRIBUTE3,
225 ATTRIBUTE4,
226 ATTRIBUTE5,
227 ATTRIBUTE6,
228 ATTRIBUTE7,
229 ATTRIBUTE8,
230 ATTRIBUTE9,
231 ATTRIBUTE10,
232 ATTRIBUTE11,
233 ATTRIBUTE12,
234 ATTRIBUTE13,
235 ATTRIBUTE14,
236 ATTRIBUTE15,
237 LOT_NUMBER,
238 CREATION_DATE,
239 CREATED_BY,
240 LAST_UPDATE_DATE,
241 LAST_UPDATED_BY,
242 LAST_UPDATE_LOGIN,
243 PARENT_OBJECT_TYPE,
244 PARENT_OBJECT_ID,
245 PARENT_OBJECT_NUMBER,
246 PARENT_OBJECT_TYPE2,
247 PARENT_OBJECT_ID2,
248 PARENT_OBJECT_NUMBER2,
249 PARENT_ITEM_ID
250 ) values (
251 X_EXPIRATION_ACTION_CODE,
252 X_EXPIRATION_ACTION_DATE,
253 X_HOLD_DATE,
254 X_ORIGINATION_TYPE,
255 X_PARENT_LOT_NUMBER,
256 X_REASON_ID,
257 X_TRANSACTION_INTERFACE_ID,
258 X_SOURCE_CODE,
259 X_SOURCE_LINE_ID,
260 X_REQUEST_ID,
261 X_LOT_EXPIRATION_DATE,
262 X_TRANSACTION_QUANTITY,
263 X_PRIMARY_QUANTITY,
264 X_SERIAL_TRANSACTION_TEMP_ID,
265 X_ERROR_CODE,
266 X_PROCESS_FLAG,
267 X_DESCRIPTION,
268 X_VENDOR_NAME,
269 X_SUPPLIER_LOT_NUMBER,
270 X_ORIGINATION_DATE,
271 X_DATE_CODE,
272 X_GRADE_CODE,
273 X_CHANGE_DATE,
274 X_MATURITY_DATE,
275 X_STATUS_ID,
276 X_RETEST_DATE,
277 X_AGE,
278 X_ITEM_SIZE,
279 X_COLOR,
280 X_VOLUME,
281 X_VOLUME_UOM,
282 X_PLACE_OF_ORIGIN,
283 X_BEST_BY_DATE,
284 X_LENGTH,
285 X_LENGTH_UOM,
286 X_RECYCLED_CONTENT,
287 X_THICKNESS,
288 X_THICKNESS_UOM,
289 X_WIDTH,
290 X_WIDTH_UOM,
291 X_CURL_WRINKLE_FOLD,
292 X_LOT_ATTRIBUTE_CATEGORY,
293 X_C_ATTRIBUTE1,
294 X_C_ATTRIBUTE2,
295 X_C_ATTRIBUTE3,
296 X_C_ATTRIBUTE4,
297 X_C_ATTRIBUTE5,
298 X_C_ATTRIBUTE6,
299 X_C_ATTRIBUTE7,
300 X_C_ATTRIBUTE8,
301 X_C_ATTRIBUTE9,
302 X_C_ATTRIBUTE10,
303 X_C_ATTRIBUTE11,
304 X_C_ATTRIBUTE12,
305 X_C_ATTRIBUTE13,
306 X_C_ATTRIBUTE14,
307 X_C_ATTRIBUTE15,
308 X_C_ATTRIBUTE16,
309 X_C_ATTRIBUTE17,
310 X_C_ATTRIBUTE18,
311 X_C_ATTRIBUTE19,
312 X_C_ATTRIBUTE20,
313 X_D_ATTRIBUTE1,
314 X_D_ATTRIBUTE2,
315 X_D_ATTRIBUTE3,
316 X_D_ATTRIBUTE4,
317 X_D_ATTRIBUTE5,
318 X_D_ATTRIBUTE6,
319 X_D_ATTRIBUTE7,
320 X_D_ATTRIBUTE8,
321 X_D_ATTRIBUTE9,
322 X_D_ATTRIBUTE10,
323 X_N_ATTRIBUTE1,
324 X_N_ATTRIBUTE2,
325 X_N_ATTRIBUTE3,
326 X_N_ATTRIBUTE4,
327 X_N_ATTRIBUTE5,
328 X_N_ATTRIBUTE6,
329 X_N_ATTRIBUTE7,
330 X_N_ATTRIBUTE8,
331 X_N_ATTRIBUTE9,
332 X_N_ATTRIBUTE10,
333 X_VENDOR_ID,
334 X_TERRITORY_CODE,
335 X_PRODUCT_CODE,
336 X_PRODUCT_TRANSACTION_ID,
337 X_SECONDARY_TRANSACTION_QUANTI,
338 X_SUBLOT_NUM,
339 X_REASON_CODE,
340 X_ATTRIBUTE_CATEGORY,
341 X_ATTRIBUTE1,
342 X_ATTRIBUTE2,
343 X_ATTRIBUTE3,
344 X_ATTRIBUTE4,
345 X_ATTRIBUTE5,
346 X_ATTRIBUTE6,
347 X_ATTRIBUTE7,
348 X_ATTRIBUTE8,
349 X_ATTRIBUTE9,
350 X_ATTRIBUTE10,
351 X_ATTRIBUTE11,
352 X_ATTRIBUTE12,
353 X_ATTRIBUTE13,
354 X_ATTRIBUTE14,
355 X_ATTRIBUTE15,
356 X_LOT_NUMBER,
357 sysdate,
358 fnd_global.user_id,
359 sysdate,
360 fnd_global.user_id,
361 fnd_global.login_id,
362 X_PARENT_OBJECT_TYPE,
363 X_PARENT_OBJECT_ID,
364 X_PARENT_OBJECT_NUMBER,
365 X_PARENT_OBJECT_TYPE2,
366 X_PARENT_OBJECT_ID2,
367 X_PARENT_OBJECT_NUMBER2,
368 X_PARENT_ITEM_ID
369 ) returning ROWID INTO x_rowid;
370
371 end INSERT_ROW;
372
373 procedure LOCK_ROW (
374 X_ROWID IN ROWID,
375 X_TRANSACTION_INTERFACE_ID in NUMBER,
376 X_EXPIRATION_ACTION_CODE in VARCHAR2,
377 X_EXPIRATION_ACTION_DATE in DATE,
378 X_HOLD_DATE in DATE,
379 X_ORIGINATION_TYPE in NUMBER,
380 X_PARENT_LOT_NUMBER in VARCHAR2,
381 X_REASON_ID in NUMBER,
382 X_SOURCE_CODE in VARCHAR2,
383 X_SOURCE_LINE_ID in NUMBER,
384 X_REQUEST_ID in NUMBER,
385 X_LOT_EXPIRATION_DATE in DATE,
386 X_TRANSACTION_QUANTITY in NUMBER,
387 X_PRIMARY_QUANTITY in NUMBER,
388 X_SERIAL_TRANSACTION_TEMP_ID in NUMBER,
389 X_ERROR_CODE in VARCHAR2,
390 X_PROCESS_FLAG in VARCHAR2,
391 X_DESCRIPTION in VARCHAR2,
392 X_VENDOR_NAME in VARCHAR2,
393 X_SUPPLIER_LOT_NUMBER in VARCHAR2,
394 X_ORIGINATION_DATE in DATE,
395 X_DATE_CODE in VARCHAR2,
396 X_GRADE_CODE in VARCHAR2,
397 X_CHANGE_DATE in DATE,
398 X_MATURITY_DATE in DATE,
399 X_STATUS_ID in NUMBER,
400 X_RETEST_DATE in DATE,
401 X_AGE in NUMBER,
402 X_ITEM_SIZE in NUMBER,
403 X_COLOR in VARCHAR2,
404 X_VOLUME in NUMBER,
405 X_VOLUME_UOM in VARCHAR2,
406 X_PLACE_OF_ORIGIN in VARCHAR2,
407 X_BEST_BY_DATE in DATE,
408 X_LENGTH in NUMBER,
409 X_LENGTH_UOM in VARCHAR2,
410 X_RECYCLED_CONTENT in NUMBER,
411 X_THICKNESS in NUMBER,
412 X_THICKNESS_UOM in VARCHAR2,
413 X_WIDTH in NUMBER,
414 X_WIDTH_UOM in VARCHAR2,
415 X_CURL_WRINKLE_FOLD in VARCHAR2,
416 X_LOT_ATTRIBUTE_CATEGORY in VARCHAR2,
417 X_C_ATTRIBUTE1 in VARCHAR2,
418 X_C_ATTRIBUTE2 in VARCHAR2,
419 X_C_ATTRIBUTE3 in VARCHAR2,
420 X_C_ATTRIBUTE4 in VARCHAR2,
421 X_C_ATTRIBUTE5 in VARCHAR2,
422 X_C_ATTRIBUTE6 in VARCHAR2,
423 X_C_ATTRIBUTE7 in VARCHAR2,
424 X_C_ATTRIBUTE8 in VARCHAR2,
425 X_C_ATTRIBUTE9 in VARCHAR2,
426 X_C_ATTRIBUTE10 in VARCHAR2,
427 X_C_ATTRIBUTE11 in VARCHAR2,
428 X_C_ATTRIBUTE12 in VARCHAR2,
429 X_C_ATTRIBUTE13 in VARCHAR2,
430 X_C_ATTRIBUTE14 in VARCHAR2,
431 X_C_ATTRIBUTE15 in VARCHAR2,
432 X_C_ATTRIBUTE16 in VARCHAR2,
433 X_C_ATTRIBUTE17 in VARCHAR2,
434 X_C_ATTRIBUTE18 in VARCHAR2,
435 X_C_ATTRIBUTE19 in VARCHAR2,
436 X_C_ATTRIBUTE20 in VARCHAR2,
437 X_D_ATTRIBUTE1 in DATE,
438 X_D_ATTRIBUTE2 in DATE,
439 X_D_ATTRIBUTE3 in DATE,
440 X_D_ATTRIBUTE4 in DATE,
441 X_D_ATTRIBUTE5 in DATE,
442 X_D_ATTRIBUTE6 in DATE,
443 X_D_ATTRIBUTE7 in DATE,
444 X_D_ATTRIBUTE8 in DATE,
445 X_D_ATTRIBUTE9 in DATE,
446 X_D_ATTRIBUTE10 in DATE,
447 X_N_ATTRIBUTE1 in NUMBER,
448 X_N_ATTRIBUTE2 in NUMBER,
449 X_N_ATTRIBUTE3 in NUMBER,
450 X_N_ATTRIBUTE4 in NUMBER,
454 X_N_ATTRIBUTE8 in NUMBER,
451 X_N_ATTRIBUTE5 in NUMBER,
452 X_N_ATTRIBUTE6 in NUMBER,
453 X_N_ATTRIBUTE7 in NUMBER,
455 X_N_ATTRIBUTE9 in NUMBER,
456 X_N_ATTRIBUTE10 in NUMBER,
457 X_VENDOR_ID in NUMBER,
458 X_TERRITORY_CODE in VARCHAR2,
459 X_PRODUCT_CODE in VARCHAR2,
460 X_PRODUCT_TRANSACTION_ID in NUMBER,
461 X_SECONDARY_TRANSACTION_QUANTI in NUMBER,
462 X_SUBLOT_NUM in VARCHAR2,
463 X_REASON_CODE in VARCHAR2,
464 X_ATTRIBUTE_CATEGORY in VARCHAR2,
465 X_ATTRIBUTE1 in VARCHAR2,
466 X_ATTRIBUTE2 in VARCHAR2,
467 X_ATTRIBUTE3 in VARCHAR2,
468 X_ATTRIBUTE4 in VARCHAR2,
469 X_ATTRIBUTE5 in VARCHAR2,
470 X_ATTRIBUTE6 in VARCHAR2,
471 X_ATTRIBUTE7 in VARCHAR2,
472 X_ATTRIBUTE8 in VARCHAR2,
473 X_ATTRIBUTE9 in VARCHAR2,
474 X_ATTRIBUTE10 in VARCHAR2,
475 X_ATTRIBUTE11 in VARCHAR2,
476 X_ATTRIBUTE12 in VARCHAR2,
477 X_ATTRIBUTE13 in VARCHAR2,
478 X_ATTRIBUTE14 in VARCHAR2,
479 X_ATTRIBUTE15 in VARCHAR2,
480 X_LOT_NUMBER in VARCHAR2,
481 X_PARENT_OBJECT_TYPE IN NUMBER,
482 X_PARENT_OBJECT_ID IN NUMBER,
483 X_PARENT_OBJECT_NUMBER IN VARCHAR2,
484 X_PARENT_OBJECT_TYPE2 IN NUMBER,
485 X_PARENT_OBJECT_ID2 IN NUMBER,
486 X_PARENT_OBJECT_NUMBER2 IN VARCHAR2,
487 X_PARENT_ITEM_ID IN NUMBER
488 ) is
489 cursor c is SELECT
490 transaction_interface_id,
491 EXPIRATION_ACTION_CODE,
492 EXPIRATION_ACTION_DATE,
493 HOLD_DATE,
494 ORIGINATION_TYPE,
495 PARENT_LOT_NUMBER,
496 REASON_ID,
497 SOURCE_CODE,
498 SOURCE_LINE_ID,
499 REQUEST_ID,
500 LOT_EXPIRATION_DATE,
501 TRANSACTION_QUANTITY,
502 PRIMARY_QUANTITY,
503 SERIAL_TRANSACTION_TEMP_ID,
504 ERROR_CODE,
505 PROCESS_FLAG,
506 DESCRIPTION,
507 VENDOR_NAME,
508 SUPPLIER_LOT_NUMBER,
509 ORIGINATION_DATE,
510 DATE_CODE,
511 GRADE_CODE,
512 CHANGE_DATE,
513 MATURITY_DATE,
514 STATUS_ID,
515 RETEST_DATE,
516 AGE,
517 ITEM_SIZE,
518 COLOR,
519 VOLUME,
520 VOLUME_UOM,
521 PLACE_OF_ORIGIN,
522 BEST_BY_DATE,
523 LENGTH,
524 LENGTH_UOM,
525 RECYCLED_CONTENT,
526 THICKNESS,
527 THICKNESS_UOM,
528 WIDTH,
529 WIDTH_UOM,
530 CURL_WRINKLE_FOLD,
531 LOT_ATTRIBUTE_CATEGORY,
532 C_ATTRIBUTE1,
533 C_ATTRIBUTE2,
534 C_ATTRIBUTE3,
535 C_ATTRIBUTE4,
536 C_ATTRIBUTE5,
537 C_ATTRIBUTE6,
538 C_ATTRIBUTE7,
539 C_ATTRIBUTE8,
540 C_ATTRIBUTE9,
541 C_ATTRIBUTE10,
542 C_ATTRIBUTE11,
543 C_ATTRIBUTE12,
544 C_ATTRIBUTE13,
545 C_ATTRIBUTE14,
546 C_ATTRIBUTE15,
547 C_ATTRIBUTE16,
548 C_ATTRIBUTE17,
549 C_ATTRIBUTE18,
550 C_ATTRIBUTE19,
551 C_ATTRIBUTE20,
552 D_ATTRIBUTE1,
553 D_ATTRIBUTE2,
554 D_ATTRIBUTE3,
555 D_ATTRIBUTE4,
556 D_ATTRIBUTE5,
557 D_ATTRIBUTE6,
558 D_ATTRIBUTE7,
559 D_ATTRIBUTE8,
560 D_ATTRIBUTE9,
561 D_ATTRIBUTE10,
562 N_ATTRIBUTE1,
563 N_ATTRIBUTE2,
564 N_ATTRIBUTE3,
565 N_ATTRIBUTE4,
566 N_ATTRIBUTE5,
567 N_ATTRIBUTE6,
568 N_ATTRIBUTE7,
569 N_ATTRIBUTE8,
570 N_ATTRIBUTE9,
571 N_ATTRIBUTE10,
572 VENDOR_ID,
573 TERRITORY_CODE,
574 PRODUCT_CODE,
575 PRODUCT_TRANSACTION_ID,
576 SECONDARY_TRANSACTION_QUANTITY,
577 SUBLOT_NUM,
578 REASON_CODE,
579 ATTRIBUTE_CATEGORY,
580 ATTRIBUTE1,
581 ATTRIBUTE2,
582 ATTRIBUTE3,
583 ATTRIBUTE4,
584 ATTRIBUTE5,
585 ATTRIBUTE6,
586 ATTRIBUTE7,
587 ATTRIBUTE8,
588 ATTRIBUTE9,
589 ATTRIBUTE10,
590 ATTRIBUTE11,
591 ATTRIBUTE12,
592 ATTRIBUTE13,
593 ATTRIBUTE14,
594 ATTRIBUTE15,
595 LOT_NUMBER,
596 PARENT_OBJECT_TYPE,
597 PARENT_OBJECT_ID,
598 PARENT_OBJECT_NUMBER,
599 PARENT_OBJECT_TYPE2,
600 PARENT_OBJECT_ID2,
601 PARENT_OBJECT_NUMBER2,
602 PARENT_ITEM_ID
603 from MTL_TRANSACTION_LOTS_INTERFACE
604 where ROWID = X_ROWID
605 for update of TRANSACTION_INTERFACE_ID nowait;
606 recinfo c%rowtype;
607
608
609 begin
610 open c;
611 fetch c into recinfo;
612 if (c%notfound) then
613 close c;
614 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
615 app_exception.raise_exception;
616 end if;
617 close c;
618 if (
619 ((recinfo.TRANSACTION_INTERFACE_ID = X_TRANSACTION_INTERFACE_ID)
620 OR ((recinfo.TRANSACTION_INTERFACE_ID is null) AND (X_TRANSACTION_INTERFACE_ID is null)))
621 AND ((recinfo.EXPIRATION_ACTION_CODE = X_EXPIRATION_ACTION_CODE)
622 OR ((recinfo.EXPIRATION_ACTION_CODE is null) AND (X_EXPIRATION_ACTION_CODE is null)))
623 AND ((recinfo.EXPIRATION_ACTION_DATE = X_EXPIRATION_ACTION_DATE)
624 OR ((recinfo.EXPIRATION_ACTION_DATE is null) AND (X_EXPIRATION_ACTION_DATE is null)))
625 AND ((recinfo.HOLD_DATE = X_HOLD_DATE)
626 OR ((recinfo.HOLD_DATE is null) AND (X_HOLD_DATE is null)))
627 AND ((recinfo.ORIGINATION_TYPE = X_ORIGINATION_TYPE)
628 OR ((recinfo.ORIGINATION_TYPE is null) AND (X_ORIGINATION_TYPE is null)))
632 OR ((recinfo.REASON_ID is null) AND (X_REASON_ID is null)))
629 AND ((recinfo.PARENT_LOT_NUMBER = X_PARENT_LOT_NUMBER)
630 OR ((recinfo.PARENT_LOT_NUMBER is null) AND (X_PARENT_LOT_NUMBER is null)))
631 AND ((recinfo.REASON_ID = X_REASON_ID)
633 AND ((recinfo.SOURCE_CODE = X_SOURCE_CODE)
634 OR ((recinfo.SOURCE_CODE is null) AND (X_SOURCE_CODE is null)))
635 AND ((recinfo.SOURCE_LINE_ID = X_SOURCE_LINE_ID)
636 OR ((recinfo.SOURCE_LINE_ID is null) AND (X_SOURCE_LINE_ID is null)))
637 AND ((recinfo.REQUEST_ID = X_REQUEST_ID)
638 OR ((recinfo.REQUEST_ID is null) AND (X_REQUEST_ID is null)))
639 AND ((recinfo.LOT_EXPIRATION_DATE = X_LOT_EXPIRATION_DATE)
640 OR ((recinfo.LOT_EXPIRATION_DATE is null) AND (X_LOT_EXPIRATION_DATE is null)))
641 AND (recinfo.TRANSACTION_QUANTITY = X_TRANSACTION_QUANTITY)
642 AND ((recinfo.PRIMARY_QUANTITY = X_PRIMARY_QUANTITY)
643 OR ((recinfo.PRIMARY_QUANTITY is null) AND (X_PRIMARY_QUANTITY is null)))
644 AND ((recinfo.SERIAL_TRANSACTION_TEMP_ID = X_SERIAL_TRANSACTION_TEMP_ID)
645 OR ((recinfo.SERIAL_TRANSACTION_TEMP_ID is null) AND (X_SERIAL_TRANSACTION_TEMP_ID is null)))
646 AND ((recinfo.ERROR_CODE = X_ERROR_CODE)
647 OR ((recinfo.ERROR_CODE is null) AND (X_ERROR_CODE is null)))
648 AND ((recinfo.PROCESS_FLAG = X_PROCESS_FLAG)
649 OR ((recinfo.PROCESS_FLAG is null) AND (X_PROCESS_FLAG is null)))
650 AND ((recinfo.DESCRIPTION = X_DESCRIPTION)
651 OR ((recinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
652 AND ((recinfo.VENDOR_NAME = X_VENDOR_NAME)
653 OR ((recinfo.VENDOR_NAME is null) AND (X_VENDOR_NAME is null)))
654 AND ((recinfo.SUPPLIER_LOT_NUMBER = X_SUPPLIER_LOT_NUMBER)
655 OR ((recinfo.SUPPLIER_LOT_NUMBER is null) AND (X_SUPPLIER_LOT_NUMBER is null)))
656 AND ((recinfo.ORIGINATION_DATE = X_ORIGINATION_DATE)
657 OR ((recinfo.ORIGINATION_DATE is null) AND (X_ORIGINATION_DATE is null)))
658 AND ((recinfo.DATE_CODE = X_DATE_CODE)
659 OR ((recinfo.DATE_CODE is null) AND (X_DATE_CODE is null)))
660 AND ((recinfo.GRADE_CODE = X_GRADE_CODE)
661 OR ((recinfo.GRADE_CODE is null) AND (X_GRADE_CODE is null)))
662 AND ((recinfo.CHANGE_DATE = X_CHANGE_DATE)
663 OR ((recinfo.CHANGE_DATE is null) AND (X_CHANGE_DATE is null)))
664 AND ((recinfo.MATURITY_DATE = X_MATURITY_DATE)
665 OR ((recinfo.MATURITY_DATE is null) AND (X_MATURITY_DATE is null)))
666 AND ((recinfo.STATUS_ID = X_STATUS_ID)
667 OR ((recinfo.STATUS_ID is null) AND (X_STATUS_ID is null)))
668 AND ((recinfo.RETEST_DATE = X_RETEST_DATE)
669 OR ((recinfo.RETEST_DATE is null) AND (X_RETEST_DATE is null)))
670 AND ((recinfo.AGE = X_AGE)
671 OR ((recinfo.AGE is null) AND (X_AGE is null)))
672 AND ((recinfo.ITEM_SIZE = X_ITEM_SIZE)
673 OR ((recinfo.ITEM_SIZE is null) AND (X_ITEM_SIZE is null)))
674 AND ((recinfo.COLOR = X_COLOR)
675 OR ((recinfo.COLOR is null) AND (X_COLOR is null)))
676 AND ((recinfo.VOLUME = X_VOLUME)
677 OR ((recinfo.VOLUME is null) AND (X_VOLUME is null)))
678 AND ((recinfo.VOLUME_UOM = X_VOLUME_UOM)
679 OR ((recinfo.VOLUME_UOM is null) AND (X_VOLUME_UOM is null)))
680 AND ((recinfo.PLACE_OF_ORIGIN = X_PLACE_OF_ORIGIN)
681 OR ((recinfo.PLACE_OF_ORIGIN is null) AND (X_PLACE_OF_ORIGIN is null)))
682 AND ((recinfo.BEST_BY_DATE = X_BEST_BY_DATE)
683 OR ((recinfo.BEST_BY_DATE is null) AND (X_BEST_BY_DATE is null)))
684 AND ((recinfo.LENGTH = X_LENGTH)
685 OR ((recinfo.LENGTH is null) AND (X_LENGTH is null)))
686 AND ((recinfo.LENGTH_UOM = X_LENGTH_UOM)
687 OR ((recinfo.LENGTH_UOM is null) AND (X_LENGTH_UOM is null)))
688 AND ((recinfo.RECYCLED_CONTENT = X_RECYCLED_CONTENT)
689 OR ((recinfo.RECYCLED_CONTENT is null) AND (X_RECYCLED_CONTENT is null)))
690 AND ((recinfo.THICKNESS = X_THICKNESS)
691 OR ((recinfo.THICKNESS is null) AND (X_THICKNESS is null)))
692 AND ((recinfo.THICKNESS_UOM = X_THICKNESS_UOM)
693 OR ((recinfo.THICKNESS_UOM is null) AND (X_THICKNESS_UOM is null)))
694 AND ((recinfo.WIDTH = X_WIDTH)
695 OR ((recinfo.WIDTH is null) AND (X_WIDTH is null)))
696 AND ((recinfo.WIDTH_UOM = X_WIDTH_UOM)
697 OR ((recinfo.WIDTH_UOM is null) AND (X_WIDTH_UOM is null)))
698 AND ((recinfo.CURL_WRINKLE_FOLD = X_CURL_WRINKLE_FOLD)
699 OR ((recinfo.CURL_WRINKLE_FOLD is null) AND (X_CURL_WRINKLE_FOLD is null)))
700 AND ((recinfo.LOT_ATTRIBUTE_CATEGORY = X_LOT_ATTRIBUTE_CATEGORY)
701 OR ((recinfo.LOT_ATTRIBUTE_CATEGORY is null) AND (X_LOT_ATTRIBUTE_CATEGORY is null)))
702 AND ((recinfo.C_ATTRIBUTE1 = X_C_ATTRIBUTE1)
703 OR ((recinfo.C_ATTRIBUTE1 is null) AND (X_C_ATTRIBUTE1 is null)))
704 AND ((recinfo.C_ATTRIBUTE2 = X_C_ATTRIBUTE2)
705 OR ((recinfo.C_ATTRIBUTE2 is null) AND (X_C_ATTRIBUTE2 is null)))
706 AND ((recinfo.C_ATTRIBUTE3 = X_C_ATTRIBUTE3)
707 OR ((recinfo.C_ATTRIBUTE3 is null) AND (X_C_ATTRIBUTE3 is null)))
708 AND ((recinfo.C_ATTRIBUTE4 = X_C_ATTRIBUTE4)
709 OR ((recinfo.C_ATTRIBUTE4 is null) AND (X_C_ATTRIBUTE4 is null)))
710 AND ((recinfo.C_ATTRIBUTE5 = X_C_ATTRIBUTE5)
711 OR ((recinfo.C_ATTRIBUTE5 is null) AND (X_C_ATTRIBUTE5 is null)))
712 AND ((recinfo.C_ATTRIBUTE6 = X_C_ATTRIBUTE6)
713 OR ((recinfo.C_ATTRIBUTE6 is null) AND (X_C_ATTRIBUTE6 is null)))
714 AND ((recinfo.C_ATTRIBUTE7 = X_C_ATTRIBUTE7)
715 OR ((recinfo.C_ATTRIBUTE7 is null) AND (X_C_ATTRIBUTE7 is null)))
716 AND ((recinfo.C_ATTRIBUTE8 = X_C_ATTRIBUTE8)
717 OR ((recinfo.C_ATTRIBUTE8 is null) AND (X_C_ATTRIBUTE8 is null)))
718 AND ((recinfo.C_ATTRIBUTE9 = X_C_ATTRIBUTE9)
719 OR ((recinfo.C_ATTRIBUTE9 is null) AND (X_C_ATTRIBUTE9 is null)))
720 AND ((recinfo.C_ATTRIBUTE10 = X_C_ATTRIBUTE10)
724 AND ((recinfo.C_ATTRIBUTE12 = X_C_ATTRIBUTE12)
721 OR ((recinfo.C_ATTRIBUTE10 is null) AND (X_C_ATTRIBUTE10 is null)))
722 AND ((recinfo.C_ATTRIBUTE11 = X_C_ATTRIBUTE11)
723 OR ((recinfo.C_ATTRIBUTE11 is null) AND (X_C_ATTRIBUTE11 is null)))
725 OR ((recinfo.C_ATTRIBUTE12 is null) AND (X_C_ATTRIBUTE12 is null)))
726 AND ((recinfo.C_ATTRIBUTE13 = X_C_ATTRIBUTE13)
727 OR ((recinfo.C_ATTRIBUTE13 is null) AND (X_C_ATTRIBUTE13 is null)))
728 AND ((recinfo.C_ATTRIBUTE14 = X_C_ATTRIBUTE14)
729 OR ((recinfo.C_ATTRIBUTE14 is null) AND (X_C_ATTRIBUTE14 is null)))
730 AND ((recinfo.C_ATTRIBUTE15 = X_C_ATTRIBUTE15)
731 OR ((recinfo.C_ATTRIBUTE15 is null) AND (X_C_ATTRIBUTE15 is null)))
732 AND ((recinfo.C_ATTRIBUTE16 = X_C_ATTRIBUTE16)
733 OR ((recinfo.C_ATTRIBUTE16 is null) AND (X_C_ATTRIBUTE16 is null)))
734 AND ((recinfo.C_ATTRIBUTE17 = X_C_ATTRIBUTE17)
735 OR ((recinfo.C_ATTRIBUTE17 is null) AND (X_C_ATTRIBUTE17 is null)))
736 AND ((recinfo.C_ATTRIBUTE18 = X_C_ATTRIBUTE18)
737 OR ((recinfo.C_ATTRIBUTE18 is null) AND (X_C_ATTRIBUTE18 is null)))
738 AND ((recinfo.C_ATTRIBUTE19 = X_C_ATTRIBUTE19)
739 OR ((recinfo.C_ATTRIBUTE19 is null) AND (X_C_ATTRIBUTE19 is null)))
740 AND ((recinfo.C_ATTRIBUTE20 = X_C_ATTRIBUTE20)
741 OR ((recinfo.C_ATTRIBUTE20 is null) AND (X_C_ATTRIBUTE20 is null)))
742 AND ((recinfo.D_ATTRIBUTE1 = X_D_ATTRIBUTE1)
743 OR ((recinfo.D_ATTRIBUTE1 is null) AND (X_D_ATTRIBUTE1 is null)))
744 AND ((recinfo.D_ATTRIBUTE2 = X_D_ATTRIBUTE2)
745 OR ((recinfo.D_ATTRIBUTE2 is null) AND (X_D_ATTRIBUTE2 is null)))
746 AND ((recinfo.D_ATTRIBUTE3 = X_D_ATTRIBUTE3)
747 OR ((recinfo.D_ATTRIBUTE3 is null) AND (X_D_ATTRIBUTE3 is null)))
748 AND ((recinfo.D_ATTRIBUTE4 = X_D_ATTRIBUTE4)
749 OR ((recinfo.D_ATTRIBUTE4 is null) AND (X_D_ATTRIBUTE4 is null)))
750 AND ((recinfo.D_ATTRIBUTE5 = X_D_ATTRIBUTE5)
751 OR ((recinfo.D_ATTRIBUTE5 is null) AND (X_D_ATTRIBUTE5 is null)))
752 AND ((recinfo.D_ATTRIBUTE6 = X_D_ATTRIBUTE6)
753 OR ((recinfo.D_ATTRIBUTE6 is null) AND (X_D_ATTRIBUTE6 is null)))
754 AND ((recinfo.D_ATTRIBUTE7 = X_D_ATTRIBUTE7)
755 OR ((recinfo.D_ATTRIBUTE7 is null) AND (X_D_ATTRIBUTE7 is null)))
756 AND ((recinfo.D_ATTRIBUTE8 = X_D_ATTRIBUTE8)
757 OR ((recinfo.D_ATTRIBUTE8 is null) AND (X_D_ATTRIBUTE8 is null)))
758 AND ((recinfo.D_ATTRIBUTE9 = X_D_ATTRIBUTE9)
759 OR ((recinfo.D_ATTRIBUTE9 is null) AND (X_D_ATTRIBUTE9 is null)))
760 AND ((recinfo.D_ATTRIBUTE10 = X_D_ATTRIBUTE10)
761 OR ((recinfo.D_ATTRIBUTE10 is null) AND (X_D_ATTRIBUTE10 is null)))
762 AND ((recinfo.N_ATTRIBUTE1 = X_N_ATTRIBUTE1)
763 OR ((recinfo.N_ATTRIBUTE1 is null) AND (X_N_ATTRIBUTE1 is null)))
764 AND ((recinfo.N_ATTRIBUTE2 = X_N_ATTRIBUTE2)
765 OR ((recinfo.N_ATTRIBUTE2 is null) AND (X_N_ATTRIBUTE2 is null)))
766 AND ((recinfo.N_ATTRIBUTE3 = X_N_ATTRIBUTE3)
767 OR ((recinfo.N_ATTRIBUTE3 is null) AND (X_N_ATTRIBUTE3 is null)))
768 AND ((recinfo.N_ATTRIBUTE4 = X_N_ATTRIBUTE4)
769 OR ((recinfo.N_ATTRIBUTE4 is null) AND (X_N_ATTRIBUTE4 is null)))
770 AND ((recinfo.N_ATTRIBUTE5 = X_N_ATTRIBUTE5)
771 OR ((recinfo.N_ATTRIBUTE5 is null) AND (X_N_ATTRIBUTE5 is null)))
772 AND ((recinfo.N_ATTRIBUTE6 = X_N_ATTRIBUTE6)
773 OR ((recinfo.N_ATTRIBUTE6 is null) AND (X_N_ATTRIBUTE6 is null)))
774 AND ((recinfo.N_ATTRIBUTE7 = X_N_ATTRIBUTE7)
775 OR ((recinfo.N_ATTRIBUTE7 is null) AND (X_N_ATTRIBUTE7 is null)))
776 AND ((recinfo.N_ATTRIBUTE8 = X_N_ATTRIBUTE8)
777 OR ((recinfo.N_ATTRIBUTE8 is null) AND (X_N_ATTRIBUTE8 is null)))
778 AND ((recinfo.N_ATTRIBUTE9 = X_N_ATTRIBUTE9)
779 OR ((recinfo.N_ATTRIBUTE9 is null) AND (X_N_ATTRIBUTE9 is null)))
780 AND ((recinfo.N_ATTRIBUTE10 = X_N_ATTRIBUTE10)
781 OR ((recinfo.N_ATTRIBUTE10 is null) AND (X_N_ATTRIBUTE10 is null)))
782 AND ((recinfo.VENDOR_ID = X_VENDOR_ID)
783 OR ((recinfo.VENDOR_ID is null) AND (X_VENDOR_ID is null)))
784 AND ((recinfo.TERRITORY_CODE = X_TERRITORY_CODE)
785 OR ((recinfo.TERRITORY_CODE is null) AND (X_TERRITORY_CODE is null)))
786 AND ((recinfo.PRODUCT_CODE = X_PRODUCT_CODE)
787 OR ((recinfo.PRODUCT_CODE is null) AND (X_PRODUCT_CODE is null)))
788 AND ((recinfo.PRODUCT_TRANSACTION_ID = X_PRODUCT_TRANSACTION_ID)
789 OR ((recinfo.PRODUCT_TRANSACTION_ID is null) AND (X_PRODUCT_TRANSACTION_ID is null)))
790 AND ((recinfo.SECONDARY_TRANSACTION_QUANTITY = X_SECONDARY_TRANSACTION_QUANTI)
791 OR ((recinfo.SECONDARY_TRANSACTION_QUANTITY is null) AND (X_SECONDARY_TRANSACTION_QUANTI is null)))
792 AND ((recinfo.SUBLOT_NUM = X_SUBLOT_NUM)
793 OR ((recinfo.SUBLOT_NUM is null) AND (X_SUBLOT_NUM is null)))
794 AND ((recinfo.REASON_CODE = X_REASON_CODE)
795 OR ((recinfo.REASON_CODE is null) AND (X_REASON_CODE is null)))
796 AND ((recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
797 OR ((recinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))
798 AND ((recinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
799 OR ((recinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null)))
800 AND ((recinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
801 OR ((recinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null)))
802 AND ((recinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
803 OR ((recinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null)))
804 AND ((recinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
805 OR ((recinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null)))
806 AND ((recinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
807 OR ((recinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null)))
808 AND ((recinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
809 OR ((recinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null)))
810 AND ((recinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
814 AND ((recinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
811 OR ((recinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null)))
812 AND ((recinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
813 OR ((recinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null)))
815 OR ((recinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null)))
816 AND ((recinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
817 OR ((recinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null)))
818 AND ((recinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
819 OR ((recinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null)))
820 AND ((recinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
821 OR ((recinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null)))
822 AND ((recinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
823 OR ((recinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null)))
824 AND ((recinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
825 OR ((recinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null)))
826 AND ((recinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
827 OR ((recinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null)))
828 AND ((recinfo.lot_number = X_lot_number)
829 OR ((recinfo.lot_number is null) AND (X_lot_number is null)))
830 AND ((recinfo.PARENT_OBJECT_TYPE = X_PARENT_OBJECT_TYPE)
831 OR ((recinfo.PARENT_OBJECT_TYPE is null) AND (X_PARENT_OBJECT_TYPE is null)))
832 AND ((recinfo.PARENT_OBJECT_ID = X_PARENT_OBJECT_ID)
833 OR ((recinfo.PARENT_OBJECT_ID is null) AND (X_PARENT_OBJECT_ID is null)))
834 AND ((recinfo.PARENT_OBJECT_NUMBER = X_PARENT_OBJECT_NUMBER)
835 OR ((recinfo.PARENT_OBJECT_NUMBER is null) AND (X_PARENT_OBJECT_NUMBER is null)))
836 AND ((recinfo.PARENT_OBJECT_TYPE2 = X_PARENT_OBJECT_TYPE2)
837 OR ((recinfo.PARENT_OBJECT_TYPE2 is null) AND (X_PARENT_OBJECT_TYPE2 is null)))
838 AND ((recinfo.PARENT_OBJECT_ID2 = X_PARENT_OBJECT_ID2)
839 OR ((recinfo.PARENT_OBJECT_ID2 is null) AND (X_PARENT_OBJECT_ID2 is null)))
840 AND ((recinfo.PARENT_OBJECT_NUMBER2 = X_PARENT_OBJECT_NUMBER2)
841 OR ((recinfo.PARENT_OBJECT_NUMBER2 is null) AND (X_PARENT_OBJECT_NUMBER2 is null)))
842 AND ((recinfo.PARENT_ITEM_ID = X_PARENT_ITEM_ID)
843 OR ((recinfo.PARENT_ITEM_ID is null) AND (X_PARENT_ITEM_ID is null)))
844 ) then
845 null;
846 else
847 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
848 app_exception.raise_exception;
849 end if;
850
851 return;
852 end LOCK_ROW;
853
854 procedure UPDATE_ROW (
855 X_ROWID IN ROWID,
856 X_TRANSACTION_INTERFACE_ID in NUMBER,
857 X_EXPIRATION_ACTION_CODE in VARCHAR2,
858 X_EXPIRATION_ACTION_DATE in DATE,
859 X_HOLD_DATE in DATE,
860 X_ORIGINATION_TYPE in NUMBER,
861 X_PARENT_LOT_NUMBER in VARCHAR2,
862 X_REASON_ID in NUMBER,
863 X_SOURCE_CODE in VARCHAR2,
864 X_SOURCE_LINE_ID in NUMBER,
865 X_REQUEST_ID in NUMBER,
866 X_LOT_EXPIRATION_DATE in DATE,
867 X_TRANSACTION_QUANTITY in NUMBER,
868 X_PRIMARY_QUANTITY in NUMBER,
869 X_SERIAL_TRANSACTION_TEMP_ID in NUMBER,
870 X_ERROR_CODE in VARCHAR2,
871 X_PROCESS_FLAG in VARCHAR2,
872 X_DESCRIPTION in VARCHAR2,
873 X_VENDOR_NAME in VARCHAR2,
874 X_SUPPLIER_LOT_NUMBER in VARCHAR2,
875 X_ORIGINATION_DATE in DATE,
876 X_DATE_CODE in VARCHAR2,
877 X_GRADE_CODE in VARCHAR2,
878 X_CHANGE_DATE in DATE,
879 X_MATURITY_DATE in DATE,
880 X_STATUS_ID in NUMBER,
881 X_RETEST_DATE in DATE,
882 X_AGE in NUMBER,
883 X_ITEM_SIZE in NUMBER,
884 X_COLOR in VARCHAR2,
885 X_VOLUME in NUMBER,
886 X_VOLUME_UOM in VARCHAR2,
887 X_PLACE_OF_ORIGIN in VARCHAR2,
888 X_BEST_BY_DATE in DATE,
889 X_LENGTH in NUMBER,
890 X_LENGTH_UOM in VARCHAR2,
891 X_RECYCLED_CONTENT in NUMBER,
892 X_THICKNESS in NUMBER,
893 X_THICKNESS_UOM in VARCHAR2,
894 X_WIDTH in NUMBER,
895 X_WIDTH_UOM in VARCHAR2,
896 X_CURL_WRINKLE_FOLD in VARCHAR2,
897 X_LOT_ATTRIBUTE_CATEGORY in VARCHAR2,
898 X_C_ATTRIBUTE1 in VARCHAR2,
899 X_C_ATTRIBUTE2 in VARCHAR2,
900 X_C_ATTRIBUTE3 in VARCHAR2,
901 X_C_ATTRIBUTE4 in VARCHAR2,
902 X_C_ATTRIBUTE5 in VARCHAR2,
903 X_C_ATTRIBUTE6 in VARCHAR2,
904 X_C_ATTRIBUTE7 in VARCHAR2,
905 X_C_ATTRIBUTE8 in VARCHAR2,
906 X_C_ATTRIBUTE9 in VARCHAR2,
907 X_C_ATTRIBUTE10 in VARCHAR2,
908 X_C_ATTRIBUTE11 in VARCHAR2,
909 X_C_ATTRIBUTE12 in VARCHAR2,
910 X_C_ATTRIBUTE13 in VARCHAR2,
911 X_C_ATTRIBUTE14 in VARCHAR2,
912 X_C_ATTRIBUTE15 in VARCHAR2,
913 X_C_ATTRIBUTE16 in VARCHAR2,
914 X_C_ATTRIBUTE17 in VARCHAR2,
915 X_C_ATTRIBUTE18 in VARCHAR2,
916 X_C_ATTRIBUTE19 in VARCHAR2,
917 X_C_ATTRIBUTE20 in VARCHAR2,
918 X_D_ATTRIBUTE1 in DATE,
919 X_D_ATTRIBUTE2 in DATE,
920 X_D_ATTRIBUTE3 in DATE,
921 X_D_ATTRIBUTE4 in DATE,
922 X_D_ATTRIBUTE5 in DATE,
923 X_D_ATTRIBUTE6 in DATE,
924 X_D_ATTRIBUTE7 in DATE,
925 X_D_ATTRIBUTE8 in DATE,
926 X_D_ATTRIBUTE9 in DATE,
927 X_D_ATTRIBUTE10 in DATE,
928 X_N_ATTRIBUTE1 in NUMBER,
929 X_N_ATTRIBUTE2 in NUMBER,
930 X_N_ATTRIBUTE3 in NUMBER,
931 X_N_ATTRIBUTE4 in NUMBER,
932 X_N_ATTRIBUTE5 in NUMBER,
933 X_N_ATTRIBUTE6 in NUMBER,
934 X_N_ATTRIBUTE7 in NUMBER,
935 X_N_ATTRIBUTE8 in NUMBER,
936 X_N_ATTRIBUTE9 in NUMBER,
937 X_N_ATTRIBUTE10 in NUMBER,
938 X_VENDOR_ID in NUMBER,
939 X_TERRITORY_CODE in VARCHAR2,
940 X_PRODUCT_CODE in VARCHAR2,
941 X_PRODUCT_TRANSACTION_ID in NUMBER,
942 X_SECONDARY_TRANSACTION_QUANTI in NUMBER,
943 X_SUBLOT_NUM in VARCHAR2,
944 X_REASON_CODE in VARCHAR2,
945 X_ATTRIBUTE_CATEGORY in VARCHAR2,
946 X_ATTRIBUTE1 in VARCHAR2,
947 X_ATTRIBUTE2 in VARCHAR2,
948 X_ATTRIBUTE3 in VARCHAR2,
949 X_ATTRIBUTE4 in VARCHAR2,
953 X_ATTRIBUTE8 in VARCHAR2,
950 X_ATTRIBUTE5 in VARCHAR2,
951 X_ATTRIBUTE6 in VARCHAR2,
952 X_ATTRIBUTE7 in VARCHAR2,
954 X_ATTRIBUTE9 in VARCHAR2,
955 X_ATTRIBUTE10 in VARCHAR2,
956 X_ATTRIBUTE11 in VARCHAR2,
957 X_ATTRIBUTE12 in VARCHAR2,
958 X_ATTRIBUTE13 in VARCHAR2,
959 X_ATTRIBUTE14 in VARCHAR2,
960 X_ATTRIBUTE15 in VARCHAR2,
961 X_LOT_NUMBER in VARCHAR2,
962 X_LAST_UPDATE_DATE in DATE,
963 X_LAST_UPDATED_BY in NUMBER,
964 X_LAST_UPDATE_LOGIN in NUMBER,
965 X_PARENT_OBJECT_TYPE IN NUMBER,
966 X_PARENT_OBJECT_ID IN NUMBER,
967 X_PARENT_OBJECT_NUMBER IN VARCHAR2,
968 X_PARENT_OBJECT_TYPE2 IN NUMBER,
969 X_PARENT_OBJECT_ID2 IN NUMBER,
970 X_PARENT_OBJECT_NUMBER2 IN VARCHAR2,
971 X_PARENT_ITEM_ID IN NUMBER
972 ) is
973 begin
974 update MTL_TRANSACTION_LOTS_INTERFACE SET
975 TRANSACTION_INTERFACE_ID=X_TRANSACTION_INTERFACE_ID,
976 EXPIRATION_ACTION_CODE = X_EXPIRATION_ACTION_CODE,
977 EXPIRATION_ACTION_DATE = X_EXPIRATION_ACTION_DATE,
978 HOLD_DATE = X_HOLD_DATE,
979 ORIGINATION_TYPE = X_ORIGINATION_TYPE,
980 PARENT_LOT_NUMBER = X_PARENT_LOT_NUMBER,
981 REASON_ID = X_REASON_ID,
982 SOURCE_CODE = X_SOURCE_CODE,
983 SOURCE_LINE_ID = X_SOURCE_LINE_ID,
984 REQUEST_ID = X_REQUEST_ID,
985 LOT_EXPIRATION_DATE = X_LOT_EXPIRATION_DATE,
986 TRANSACTION_QUANTITY = X_TRANSACTION_QUANTITY,
987 PRIMARY_QUANTITY = X_PRIMARY_QUANTITY,
988 SERIAL_TRANSACTION_TEMP_ID = X_SERIAL_TRANSACTION_TEMP_ID,
989 ERROR_CODE = X_ERROR_CODE,
990 PROCESS_FLAG = X_PROCESS_FLAG,
991 DESCRIPTION = X_DESCRIPTION,
992 VENDOR_NAME = X_VENDOR_NAME,
993 SUPPLIER_LOT_NUMBER = X_SUPPLIER_LOT_NUMBER,
994 ORIGINATION_DATE = X_ORIGINATION_DATE,
995 DATE_CODE = X_DATE_CODE,
996 GRADE_CODE = X_GRADE_CODE,
997 CHANGE_DATE = X_CHANGE_DATE,
998 MATURITY_DATE = X_MATURITY_DATE,
999 STATUS_ID = X_STATUS_ID,
1000 RETEST_DATE = X_RETEST_DATE,
1001 AGE = X_AGE,
1002 ITEM_SIZE = X_ITEM_SIZE,
1003 COLOR = X_COLOR,
1004 VOLUME = X_VOLUME,
1005 VOLUME_UOM = X_VOLUME_UOM,
1006 PLACE_OF_ORIGIN = X_PLACE_OF_ORIGIN,
1007 BEST_BY_DATE = X_BEST_BY_DATE,
1008 LENGTH = X_LENGTH,
1009 LENGTH_UOM = X_LENGTH_UOM,
1010 RECYCLED_CONTENT = X_RECYCLED_CONTENT,
1011 THICKNESS = X_THICKNESS,
1012 THICKNESS_UOM = X_THICKNESS_UOM,
1013 WIDTH = X_WIDTH,
1014 WIDTH_UOM = X_WIDTH_UOM,
1015 CURL_WRINKLE_FOLD = X_CURL_WRINKLE_FOLD,
1016 LOT_ATTRIBUTE_CATEGORY = X_LOT_ATTRIBUTE_CATEGORY,
1017 C_ATTRIBUTE1 = X_C_ATTRIBUTE1,
1018 C_ATTRIBUTE2 = X_C_ATTRIBUTE2,
1019 C_ATTRIBUTE3 = X_C_ATTRIBUTE3,
1020 C_ATTRIBUTE4 = X_C_ATTRIBUTE4,
1021 C_ATTRIBUTE5 = X_C_ATTRIBUTE5,
1022 C_ATTRIBUTE6 = X_C_ATTRIBUTE6,
1023 C_ATTRIBUTE7 = X_C_ATTRIBUTE7,
1024 C_ATTRIBUTE8 = X_C_ATTRIBUTE8,
1025 C_ATTRIBUTE9 = X_C_ATTRIBUTE9,
1026 C_ATTRIBUTE10 = X_C_ATTRIBUTE10,
1027 C_ATTRIBUTE11 = X_C_ATTRIBUTE11,
1028 C_ATTRIBUTE12 = X_C_ATTRIBUTE12,
1029 C_ATTRIBUTE13 = X_C_ATTRIBUTE13,
1030 C_ATTRIBUTE14 = X_C_ATTRIBUTE14,
1031 C_ATTRIBUTE15 = X_C_ATTRIBUTE15,
1032 C_ATTRIBUTE16 = X_C_ATTRIBUTE16,
1033 C_ATTRIBUTE17 = X_C_ATTRIBUTE17,
1034 C_ATTRIBUTE18 = X_C_ATTRIBUTE18,
1035 C_ATTRIBUTE19 = X_C_ATTRIBUTE19,
1036 C_ATTRIBUTE20 = X_C_ATTRIBUTE20,
1037 D_ATTRIBUTE1 = X_D_ATTRIBUTE1,
1038 D_ATTRIBUTE2 = X_D_ATTRIBUTE2,
1039 D_ATTRIBUTE3 = X_D_ATTRIBUTE3,
1040 D_ATTRIBUTE4 = X_D_ATTRIBUTE4,
1041 D_ATTRIBUTE5 = X_D_ATTRIBUTE5,
1042 D_ATTRIBUTE6 = X_D_ATTRIBUTE6,
1043 D_ATTRIBUTE7 = X_D_ATTRIBUTE7,
1044 D_ATTRIBUTE8 = X_D_ATTRIBUTE8,
1045 D_ATTRIBUTE9 = X_D_ATTRIBUTE9,
1046 D_ATTRIBUTE10 = X_D_ATTRIBUTE10,
1047 N_ATTRIBUTE1 = X_N_ATTRIBUTE1,
1048 N_ATTRIBUTE2 = X_N_ATTRIBUTE2,
1049 N_ATTRIBUTE3 = X_N_ATTRIBUTE3,
1050 N_ATTRIBUTE4 = X_N_ATTRIBUTE4,
1051 N_ATTRIBUTE5 = X_N_ATTRIBUTE5,
1052 N_ATTRIBUTE6 = X_N_ATTRIBUTE6,
1053 N_ATTRIBUTE7 = X_N_ATTRIBUTE7,
1054 N_ATTRIBUTE8 = X_N_ATTRIBUTE8,
1055 N_ATTRIBUTE9 = X_N_ATTRIBUTE9,
1056 N_ATTRIBUTE10 = X_N_ATTRIBUTE10,
1057 VENDOR_ID = X_VENDOR_ID,
1058 TERRITORY_CODE = X_TERRITORY_CODE,
1059 PRODUCT_CODE = X_PRODUCT_CODE,
1060 PRODUCT_TRANSACTION_ID = X_PRODUCT_TRANSACTION_ID,
1061 SECONDARY_TRANSACTION_QUANTITY = X_SECONDARY_TRANSACTION_QUANTI,
1062 SUBLOT_NUM = X_SUBLOT_NUM,
1063 REASON_CODE = X_REASON_CODE,
1064 ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
1065 ATTRIBUTE1 = X_ATTRIBUTE1,
1066 ATTRIBUTE2 = X_ATTRIBUTE2,
1067 ATTRIBUTE3 = X_ATTRIBUTE3,
1068 ATTRIBUTE4 = X_ATTRIBUTE4,
1069 ATTRIBUTE5 = X_ATTRIBUTE5,
1070 ATTRIBUTE6 = X_ATTRIBUTE6,
1071 ATTRIBUTE7 = X_ATTRIBUTE7,
1072 ATTRIBUTE8 = X_ATTRIBUTE8,
1073 ATTRIBUTE9 = X_ATTRIBUTE9,
1074 ATTRIBUTE10 = X_ATTRIBUTE10,
1075 ATTRIBUTE11 = X_ATTRIBUTE11,
1076 ATTRIBUTE12 = X_ATTRIBUTE12,
1077 ATTRIBUTE13 = X_ATTRIBUTE13,
1078 ATTRIBUTE14 = X_ATTRIBUTE14,
1079 ATTRIBUTE15 = X_ATTRIBUTE15,
1080 lot_number = x_lot_number,
1081 LAST_UPDATE_DATE = sysdate,
1082 LAST_UPDATED_BY = fnd_global.user_id,
1083 LAST_UPDATE_LOGIN = fnd_global.login_id,
1084 PARENT_OBJECT_TYPE = X_PARENT_OBJECT_TYPE,
1085 PARENT_OBJECT_ID = X_PARENT_OBJECT_ID,
1086 PARENT_OBJECT_NUMBER = X_PARENT_OBJECT_NUMBER,
1087 PARENT_OBJECT_TYPE2 = X_PARENT_OBJECT_TYPE2,
1088 PARENT_OBJECT_ID2 = X_PARENT_OBJECT_ID2,
1089 PARENT_OBJECT_NUMBER2 = X_PARENT_OBJECT_NUMBER2,
1090 PARENT_ITEM_ID = X_PARENT_ITEM_ID
1091 where ROWID = X_ROWID;
1092
1093 if (sql%notfound) then
1097 HOLD_DATE,
1094 insert into MTL_TRANSACTION_LOTS_INTERFACE (
1095 EXPIRATION_ACTION_CODE,
1096 EXPIRATION_ACTION_DATE,
1098 ORIGINATION_TYPE,
1099 PARENT_LOT_NUMBER,
1100 REASON_ID,
1101 TRANSACTION_INTERFACE_ID,
1102 SOURCE_CODE,
1103 SOURCE_LINE_ID,
1104 REQUEST_ID,
1105 LOT_EXPIRATION_DATE,
1106 TRANSACTION_QUANTITY,
1107 PRIMARY_QUANTITY,
1108 SERIAL_TRANSACTION_TEMP_ID,
1109 ERROR_CODE,
1110 PROCESS_FLAG,
1111 DESCRIPTION,
1112 VENDOR_NAME,
1113 SUPPLIER_LOT_NUMBER,
1114 ORIGINATION_DATE,
1115 DATE_CODE,
1116 GRADE_CODE,
1117 CHANGE_DATE,
1118 MATURITY_DATE,
1119 STATUS_ID,
1120 RETEST_DATE,
1121 AGE,
1122 ITEM_SIZE,
1123 COLOR,
1124 VOLUME,
1125 VOLUME_UOM,
1126 PLACE_OF_ORIGIN,
1127 BEST_BY_DATE,
1128 LENGTH,
1129 LENGTH_UOM,
1130 RECYCLED_CONTENT,
1131 THICKNESS,
1132 THICKNESS_UOM,
1133 WIDTH,
1134 WIDTH_UOM,
1135 CURL_WRINKLE_FOLD,
1136 LOT_ATTRIBUTE_CATEGORY,
1137 C_ATTRIBUTE1,
1138 C_ATTRIBUTE2,
1139 C_ATTRIBUTE3,
1140 C_ATTRIBUTE4,
1141 C_ATTRIBUTE5,
1142 C_ATTRIBUTE6,
1143 C_ATTRIBUTE7,
1144 C_ATTRIBUTE8,
1145 C_ATTRIBUTE9,
1146 C_ATTRIBUTE10,
1147 C_ATTRIBUTE11,
1148 C_ATTRIBUTE12,
1149 C_ATTRIBUTE13,
1150 C_ATTRIBUTE14,
1151 C_ATTRIBUTE15,
1152 C_ATTRIBUTE16,
1153 C_ATTRIBUTE17,
1154 C_ATTRIBUTE18,
1155 C_ATTRIBUTE19,
1156 C_ATTRIBUTE20,
1157 D_ATTRIBUTE1,
1158 D_ATTRIBUTE2,
1159 D_ATTRIBUTE3,
1160 D_ATTRIBUTE4,
1161 D_ATTRIBUTE5,
1162 D_ATTRIBUTE6,
1163 D_ATTRIBUTE7,
1164 D_ATTRIBUTE8,
1165 D_ATTRIBUTE9,
1166 D_ATTRIBUTE10,
1167 N_ATTRIBUTE1,
1168 N_ATTRIBUTE2,
1169 N_ATTRIBUTE3,
1170 N_ATTRIBUTE4,
1171 N_ATTRIBUTE5,
1172 N_ATTRIBUTE6,
1173 N_ATTRIBUTE7,
1174 N_ATTRIBUTE8,
1175 N_ATTRIBUTE9,
1176 N_ATTRIBUTE10,
1177 VENDOR_ID,
1178 TERRITORY_CODE,
1179 PRODUCT_CODE,
1180 PRODUCT_TRANSACTION_ID,
1181 SECONDARY_TRANSACTION_QUANTITY,
1182 SUBLOT_NUM,
1183 REASON_CODE,
1184 ATTRIBUTE_CATEGORY,
1185 ATTRIBUTE1,
1186 ATTRIBUTE2,
1187 ATTRIBUTE3,
1188 ATTRIBUTE4,
1189 ATTRIBUTE5,
1190 ATTRIBUTE6,
1191 ATTRIBUTE7,
1192 ATTRIBUTE8,
1193 ATTRIBUTE9,
1194 ATTRIBUTE10,
1195 ATTRIBUTE11,
1196 ATTRIBUTE12,
1197 ATTRIBUTE13,
1198 ATTRIBUTE14,
1199 ATTRIBUTE15,
1200 LOT_NUMBER,
1201 CREATION_DATE,
1202 CREATED_BY,
1203 LAST_UPDATE_DATE,
1204 LAST_UPDATED_BY,
1205 LAST_UPDATE_LOGIN,
1206 PARENT_OBJECT_TYPE,
1207 PARENT_OBJECT_ID,
1208 PARENT_OBJECT_NUMBER,
1209 PARENT_OBJECT_TYPE2,
1210 PARENT_OBJECT_ID2,
1211 PARENT_OBJECT_NUMBER2,
1212 PARENT_ITEM_ID
1213 ) values (
1214 X_EXPIRATION_ACTION_CODE,
1215 X_EXPIRATION_ACTION_DATE,
1216 X_HOLD_DATE,
1217 X_ORIGINATION_TYPE,
1218 X_PARENT_LOT_NUMBER,
1219 X_REASON_ID,
1220 X_TRANSACTION_INTERFACE_ID,
1221 X_SOURCE_CODE,
1222 X_SOURCE_LINE_ID,
1223 X_REQUEST_ID,
1224 X_LOT_EXPIRATION_DATE,
1225 X_TRANSACTION_QUANTITY,
1226 X_PRIMARY_QUANTITY,
1227 X_SERIAL_TRANSACTION_TEMP_ID,
1228 X_ERROR_CODE,
1229 X_PROCESS_FLAG,
1230 X_DESCRIPTION,
1231 X_VENDOR_NAME,
1232 X_SUPPLIER_LOT_NUMBER,
1233 X_ORIGINATION_DATE,
1234 X_DATE_CODE,
1235 X_GRADE_CODE,
1236 X_CHANGE_DATE,
1237 X_MATURITY_DATE,
1238 X_STATUS_ID,
1239 X_RETEST_DATE,
1240 X_AGE,
1241 X_ITEM_SIZE,
1242 X_COLOR,
1243 X_VOLUME,
1244 X_VOLUME_UOM,
1245 X_PLACE_OF_ORIGIN,
1246 X_BEST_BY_DATE,
1247 X_LENGTH,
1248 X_LENGTH_UOM,
1249 X_RECYCLED_CONTENT,
1250 X_THICKNESS,
1251 X_THICKNESS_UOM,
1252 X_WIDTH,
1253 X_WIDTH_UOM,
1254 X_CURL_WRINKLE_FOLD,
1255 X_LOT_ATTRIBUTE_CATEGORY,
1256 X_C_ATTRIBUTE1,
1257 X_C_ATTRIBUTE2,
1258 X_C_ATTRIBUTE3,
1259 X_C_ATTRIBUTE4,
1260 X_C_ATTRIBUTE5,
1261 X_C_ATTRIBUTE6,
1262 X_C_ATTRIBUTE7,
1263 X_C_ATTRIBUTE8,
1264 X_C_ATTRIBUTE9,
1265 X_C_ATTRIBUTE10,
1266 X_C_ATTRIBUTE11,
1267 X_C_ATTRIBUTE12,
1268 X_C_ATTRIBUTE13,
1269 X_C_ATTRIBUTE14,
1270 X_C_ATTRIBUTE15,
1271 X_C_ATTRIBUTE16,
1272 X_C_ATTRIBUTE17,
1273 X_C_ATTRIBUTE18,
1274 X_C_ATTRIBUTE19,
1275 X_C_ATTRIBUTE20,
1276 X_D_ATTRIBUTE1,
1277 X_D_ATTRIBUTE2,
1278 X_D_ATTRIBUTE3,
1279 X_D_ATTRIBUTE4,
1280 X_D_ATTRIBUTE5,
1281 X_D_ATTRIBUTE6,
1282 X_D_ATTRIBUTE7,
1283 X_D_ATTRIBUTE8,
1284 X_D_ATTRIBUTE9,
1285 X_D_ATTRIBUTE10,
1286 X_N_ATTRIBUTE1,
1287 X_N_ATTRIBUTE2,
1288 X_N_ATTRIBUTE3,
1289 X_N_ATTRIBUTE4,
1290 X_N_ATTRIBUTE5,
1291 X_N_ATTRIBUTE6,
1292 X_N_ATTRIBUTE7,
1293 X_N_ATTRIBUTE8,
1294 X_N_ATTRIBUTE9,
1295 X_N_ATTRIBUTE10,
1296 X_VENDOR_ID,
1297 X_TERRITORY_CODE,
1298 X_PRODUCT_CODE,
1299 X_PRODUCT_TRANSACTION_ID,
1300 X_SECONDARY_TRANSACTION_QUANTI,
1301 X_SUBLOT_NUM,
1302 X_REASON_CODE,
1306 X_ATTRIBUTE3,
1303 X_ATTRIBUTE_CATEGORY,
1304 X_ATTRIBUTE1,
1305 X_ATTRIBUTE2,
1307 X_ATTRIBUTE4,
1308 X_ATTRIBUTE5,
1309 X_ATTRIBUTE6,
1310 X_ATTRIBUTE7,
1311 X_ATTRIBUTE8,
1312 X_ATTRIBUTE9,
1313 X_ATTRIBUTE10,
1314 X_ATTRIBUTE11,
1315 X_ATTRIBUTE12,
1316 X_ATTRIBUTE13,
1317 X_ATTRIBUTE14,
1318 X_ATTRIBUTE15,
1319 x_lot_number,
1320 sysdate,
1321 fnd_global.user_id,
1322 sysdate,
1323 fnd_global.user_id,
1324 fnd_global.login_id,
1325 X_PARENT_OBJECT_TYPE,
1326 X_PARENT_OBJECT_ID,
1327 X_PARENT_OBJECT_NUMBER,
1328 X_PARENT_OBJECT_TYPE2,
1329 X_PARENT_OBJECT_ID2,
1330 X_PARENT_OBJECT_NUMBER2,
1331 X_PARENT_ITEM_ID
1332 );
1333 end if;
1334
1335 end UPDATE_ROW;
1336
1337 procedure DELETE_ROW (
1338 X_ROWID IN ROWID
1339 ) is
1340 begin
1341
1342 delete from MTL_TRANSACTION_LOTS_INTERFACE
1343 where ROWID = X_ROWID;
1344
1345 if (sql%notfound) then
1346 raise no_data_found;
1347 end if;
1348 end DELETE_ROW;
1349
1350 end MTL_TRANSACTION_LOTS_INTF_PKG;