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