1 package body MTL_TXN_INTERFACE_PKG as
2 /* $Header: INVTMTIB.pls 120.1 2006/02/24 16:31:23 cjandhya noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out nocopy ROWID ,
5 X_TRANSACTION_INTERFACE_ID in NUMBER,
6 X_PLANNING_ORGANIZATION_ID in NUMBER,
7 X_PLANNING_TP_TYPE in NUMBER,
8 X_XFR_PLANNING_ORGANIZATION_ID in NUMBER,
9 X_TRANSFER_PLANNING_TP_TYPE in NUMBER,
10 X_SECONDARY_UOM_CODE in VARCHAR2,
11 X_SECONDARY_TRANSACTION_QUANTI in NUMBER,
12 X_TRANSACTION_GROUP_ID in NUMBER,
13 X_TRANSACTION_GROUP_SEQ in NUMBER,
14 X_REPRESENTATIVE_LOT_NUMBER in VARCHAR2,
15 X_TRANSACTION_BATCH_ID in NUMBER,
16 X_TRANSACTION_BATCH_SEQ in NUMBER,
17 X_REBUILD_ITEM_ID in NUMBER,
18 X_REBUILD_SERIAL_NUMBER in VARCHAR2,
19 X_REBUILD_ACTIVITY_ID in NUMBER,
20 X_REBUILD_JOB_NAME in VARCHAR2,
21 X_MOVE_TRANSACTION_ID in NUMBER,
22 X_COMPLETION_TRANSACTION_ID in NUMBER,
23 X_WIP_SUPPLY_TYPE in NUMBER,
24 X_XFER_LOC_SEGMENT6 in VARCHAR2,
25 X_XFER_LOC_SEGMENT7 in VARCHAR2,
26 X_XFER_LOC_SEGMENT8 in VARCHAR2,
27 X_XFER_LOC_SEGMENT9 in VARCHAR2,
28 X_XFER_LOC_SEGMENT10 in VARCHAR2,
29 X_XFER_LOC_SEGMENT11 in VARCHAR2,
30 X_XFER_LOC_SEGMENT12 in VARCHAR2,
31 X_XFER_LOC_SEGMENT13 in VARCHAR2,
32 X_XFER_LOC_SEGMENT14 in VARCHAR2,
33 X_XFER_LOC_SEGMENT15 in VARCHAR2,
34 X_XFER_LOC_SEGMENT16 in VARCHAR2,
35 X_XFER_LOC_SEGMENT17 in VARCHAR2,
36 X_XFER_LOC_SEGMENT18 in VARCHAR2,
37 X_XFER_LOC_SEGMENT19 in VARCHAR2,
38 X_XFER_LOC_SEGMENT20 in VARCHAR2,
39 X_SHIPMENT_NUMBER in VARCHAR2,
40 X_TRANSPORTATION_COST in NUMBER,
41 X_TRANSPORTATION_ACCOUNT in NUMBER,
42 X_TRANSFER_COST in NUMBER,
43 X_FREIGHT_CODE in VARCHAR2,
44 X_CONTAINERS in NUMBER,
45 X_WAYBILL_AIRBILL in VARCHAR2,
46 X_EXPECTED_ARRIVAL_DATE in DATE,
47 X_NEW_AVERAGE_COST in NUMBER,
48 X_VALUE_CHANGE in NUMBER,
49 X_PERCENTAGE_CHANGE in NUMBER,
50 X_DEMAND_SOURCE_HEADER_ID in NUMBER,
51 X_DEMAND_SOURCE_LINE in VARCHAR2,
52 X_DEMAND_SOURCE_DELIVERY in VARCHAR2,
53 X_NEGATIVE_REQ_FLAG in NUMBER,
54 X_ERROR_EXPLANATION in VARCHAR2,
55 X_SHIPPABLE_FLAG in VARCHAR2,
56 X_REQUIRED_FLAG in VARCHAR2,
57 X_ATTRIBUTE_CATEGORY in VARCHAR2,
58 X_ATTRIBUTE1 in VARCHAR2,
59 X_ATTRIBUTE2 in VARCHAR2,
60 X_ATTRIBUTE3 in VARCHAR2,
61 X_ATTRIBUTE4 in VARCHAR2,
62 X_ATTRIBUTE5 in VARCHAR2,
63 X_ATTRIBUTE6 in VARCHAR2,
64 X_ATTRIBUTE7 in VARCHAR2,
65 X_ATTRIBUTE8 in VARCHAR2,
66 X_ATTRIBUTE9 in VARCHAR2,
67 X_ATTRIBUTE10 in VARCHAR2,
68 X_ATTRIBUTE11 in VARCHAR2,
69 X_ATTRIBUTE12 in VARCHAR2,
70 X_ATTRIBUTE13 in VARCHAR2,
71 X_ATTRIBUTE14 in VARCHAR2,
72 X_ATTRIBUTE15 in VARCHAR2,
73 X_REQUISITION_DISTRIBUTION_ID in NUMBER,
74 X_MOVEMENT_ID in NUMBER,
75 X_RESERVATION_QUANTITY in NUMBER,
76 X_SHIPPED_QUANTITY in NUMBER,
77 X_INVENTORY_ITEM in VARCHAR2,
78 X_LOCATOR_NAME in VARCHAR2,
79 X_TASK_ID in NUMBER,
80 X_TO_TASK_ID in NUMBER,
81 X_SOURCE_TASK_ID in NUMBER,
82 X_PROJECT_ID in NUMBER,
83 X_TO_PROJECT_ID in NUMBER,
84 X_SOURCE_PROJECT_ID in NUMBER,
85 X_PA_EXPENDITURE_ORG_ID in NUMBER,
86 X_EXPENDITURE_TYPE in VARCHAR2,
87 X_FINAL_COMPLETION_FLAG in VARCHAR2,
88 X_TRANSFER_PERCENTAGE in NUMBER,
89 X_TRANSACTION_SEQUENCE_ID in NUMBER,
90 X_MATERIAL_ACCOUNT in NUMBER,
91 X_MATERIAL_OVERHEAD_ACCOUNT in NUMBER,
92 X_RESOURCE_ACCOUNT in NUMBER,
93 X_OUTSIDE_PROCESSING_ACCOUNT in NUMBER,
94 X_OVERHEAD_ACCOUNT in NUMBER,
95 X_BOM_REVISION in VARCHAR2,
96 X_ROUTING_REVISION in VARCHAR2,
97 X_BOM_REVISION_DATE in DATE,
98 X_ROUTING_REVISION_DATE in DATE,
99 X_ALTERNATE_BOM_DESIGNATOR in VARCHAR2,
100 X_ALTERNATE_ROUTING_DESIGNATOR in VARCHAR2,
101 X_ACCOUNTING_CLASS in VARCHAR2,
102 X_DEMAND_CLASS in VARCHAR2,
103 X_PARENT_ID in NUMBER,
104 X_SUBSTITUTION_TYPE_ID in NUMBER,
105 X_SUBSTITUTION_ITEM_ID in NUMBER,
106 X_SCHEDULE_GROUP in NUMBER,
107 X_BUILD_SEQUENCE in NUMBER,
108 X_SCHEDULE_NUMBER in VARCHAR2,
109 X_SCHEDULED_FLAG in NUMBER,
110 X_FLOW_SCHEDULE in VARCHAR2,
111 X_COST_GROUP_ID in NUMBER,
112 X_KANBAN_CARD_ID in NUMBER,
113 X_QA_COLLECTION_ID in NUMBER,
114 X_OVERCOMPLETION_TRANSACTION_Q in NUMBER,
115 X_OVERCOMPLETION_PRIMARY_QTY in NUMBER,
116 X_OVERCOMPLETION_TRANSACTION_I in NUMBER,
117 X_END_ITEM_UNIT_NUMBER in VARCHAR2,
118 X_SCHEDULED_PAYBACK_DATE in DATE,
119 X_ORG_COST_GROUP_ID in NUMBER,
120 X_COST_TYPE_ID in NUMBER,
121 X_SOURCE_LOT_NUMBER in VARCHAR2,
122 X_TRANSFER_COST_GROUP_ID in NUMBER,
123 X_LPN_ID in NUMBER,
124 X_TRANSFER_LPN_ID in NUMBER,
125 X_CONTENT_LPN_ID in NUMBER,
126 X_XML_DOCUMENT_ID in VARCHAR2,
127 X_ORGANIZATION_TYPE in NUMBER,
128 X_TRANSFER_ORGANIZATION_TYPE in NUMBER,
129 X_OWNING_ORGANIZATION_ID in NUMBER,
130 X_OWNING_TP_TYPE in NUMBER,
131 X_XFR_OWNING_ORGANIZATION_ID in NUMBER,
132 X_TRANSFER_OWNING_TP_TYPE in NUMBER,
133 X_LOC_SEGMENT12 in VARCHAR2,
134 X_LOC_SEGMENT13 in VARCHAR2,
135 X_LOC_SEGMENT14 in VARCHAR2,
136 X_LOC_SEGMENT15 in VARCHAR2,
137 X_LOC_SEGMENT16 in VARCHAR2,
138 X_LOC_SEGMENT17 in VARCHAR2,
139 X_LOC_SEGMENT18 in VARCHAR2,
140 X_LOC_SEGMENT19 in VARCHAR2,
141 X_LOC_SEGMENT20 in VARCHAR2,
142 X_TRANSACTION_SOURCE_ID in NUMBER,
143 X_DSP_SEGMENT1 in VARCHAR2,
144 X_DSP_SEGMENT2 in VARCHAR2,
145 X_DSP_SEGMENT3 in VARCHAR2,
146 X_DSP_SEGMENT4 in VARCHAR2,
147 X_DSP_SEGMENT5 in VARCHAR2,
148 X_DSP_SEGMENT6 in VARCHAR2,
149 X_DSP_SEGMENT7 in VARCHAR2,
150 X_DSP_SEGMENT8 in VARCHAR2,
151 X_DSP_SEGMENT9 in VARCHAR2,
152 X_DSP_SEGMENT10 in VARCHAR2,
153 X_DSP_SEGMENT11 in VARCHAR2,
154 X_DSP_SEGMENT12 in VARCHAR2,
155 X_DSP_SEGMENT13 in VARCHAR2,
156 X_DSP_SEGMENT14 in VARCHAR2,
157 X_DSP_SEGMENT15 in VARCHAR2,
158 X_DSP_SEGMENT16 in VARCHAR2,
159 X_DSP_SEGMENT17 in VARCHAR2,
160 X_DSP_SEGMENT18 in VARCHAR2,
161 X_DSP_SEGMENT19 in VARCHAR2,
162 X_DSP_SEGMENT20 in VARCHAR2,
163 X_DSP_SEGMENT21 in VARCHAR2,
164 X_DSP_SEGMENT22 in VARCHAR2,
165 X_DSP_SEGMENT23 in VARCHAR2,
166 X_DSP_SEGMENT24 in VARCHAR2,
167 X_DSP_SEGMENT25 in VARCHAR2,
168 X_DSP_SEGMENT26 in VARCHAR2,
169 X_DSP_SEGMENT27 in VARCHAR2,
170 X_DSP_SEGMENT28 in VARCHAR2,
171 X_DSP_SEGMENT29 in VARCHAR2,
172 X_DSP_SEGMENT30 in VARCHAR2,
173 X_TRANSACTION_SOURCE_NAME in VARCHAR2,
174 X_TRANSACTION_SOURCE_TYPE_ID in NUMBER,
175 X_TRANSACTION_ACTION_ID in NUMBER,
176 X_TRANSACTION_TYPE_ID in NUMBER,
177 X_REASON_ID in NUMBER,
178 X_TRANSACTION_REFERENCE in VARCHAR2,
179 X_TRANSACTION_COST in NUMBER,
180 X_DISTRIBUTION_ACCOUNT_ID in NUMBER,
181 X_DST_SEGMENT1 in VARCHAR2,
182 X_DST_SEGMENT2 in VARCHAR2,
183 X_DST_SEGMENT3 in VARCHAR2,
184 X_DST_SEGMENT4 in VARCHAR2,
185 X_DST_SEGMENT5 in VARCHAR2,
186 X_DST_SEGMENT6 in VARCHAR2,
187 X_DST_SEGMENT7 in VARCHAR2,
188 X_DST_SEGMENT8 in VARCHAR2,
189 X_DST_SEGMENT9 in VARCHAR2,
190 X_DST_SEGMENT10 in VARCHAR2,
191 X_DST_SEGMENT11 in VARCHAR2,
192 X_DST_SEGMENT12 in VARCHAR2,
193 X_DST_SEGMENT13 in VARCHAR2,
194 X_DST_SEGMENT14 in VARCHAR2,
195 X_DST_SEGMENT15 in VARCHAR2,
196 X_DST_SEGMENT16 in VARCHAR2,
197 X_DST_SEGMENT17 in VARCHAR2,
198 X_DST_SEGMENT18 in VARCHAR2,
199 X_DST_SEGMENT19 in VARCHAR2,
200 X_DST_SEGMENT20 in VARCHAR2,
201 X_DST_SEGMENT21 in VARCHAR2,
202 X_DST_SEGMENT22 in VARCHAR2,
203 X_DST_SEGMENT23 in VARCHAR2,
204 X_DST_SEGMENT24 in VARCHAR2,
205 X_DST_SEGMENT25 in VARCHAR2,
206 X_DST_SEGMENT26 in VARCHAR2,
207 X_DST_SEGMENT27 in VARCHAR2,
208 X_DST_SEGMENT28 in VARCHAR2,
209 X_DST_SEGMENT29 in VARCHAR2,
210 X_DST_SEGMENT30 in VARCHAR2,
211 X_REQUISITION_LINE_ID in NUMBER,
212 X_CURRENCY_CODE in VARCHAR2,
213 X_CURRENCY_CONVERSION_DATE in DATE,
214 X_CURRENCY_CONVERSION_TYPE in VARCHAR2,
215 X_CURRENCY_CONVERSION_RATE in NUMBER,
216 X_USSGL_TRANSACTION_CODE in VARCHAR2,
217 X_WIP_ENTITY_TYPE in NUMBER,
218 X_SCHEDULE_ID in NUMBER,
219 X_EMPLOYEE_CODE in VARCHAR2,
220 X_DEPARTMENT_ID in NUMBER,
221 X_SCHEDULE_UPDATE_CODE in NUMBER,
222 X_SETUP_TEARDOWN_CODE in NUMBER,
223 X_PRIMARY_SWITCH in NUMBER,
224 X_MRP_CODE in NUMBER,
225 X_OPERATION_SEQ_NUM in NUMBER,
226 X_REPETITIVE_LINE_ID in NUMBER,
227 X_PICKING_LINE_ID in NUMBER,
228 X_TRX_SOURCE_LINE_ID in NUMBER,
229 X_TRX_SOURCE_DELIVERY_ID in NUMBER,
230 X_DEMAND_ID in NUMBER,
231 X_CUSTOMER_SHIP_ID in NUMBER,
232 X_LINE_ITEM_NUM in NUMBER,
233 X_RECEIVING_DOCUMENT in VARCHAR2,
234 X_RCV_TRANSACTION_ID in NUMBER,
235 X_SHIP_TO_LOCATION_ID in NUMBER,
236 X_ENCUMBRANCE_ACCOUNT in NUMBER,
237 X_ENCUMBRANCE_AMOUNT in NUMBER,
238 X_VENDOR_LOT_NUMBER in VARCHAR2,
239 X_TRANSFER_SUBINVENTORY in VARCHAR2,
240 X_TRANSFER_ORGANIZATION in NUMBER,
241 X_TRANSFER_LOCATOR in NUMBER,
242 X_XFER_LOC_SEGMENT1 in VARCHAR2,
243 X_XFER_LOC_SEGMENT2 in VARCHAR2,
244 X_XFER_LOC_SEGMENT3 in VARCHAR2,
245 X_XFER_LOC_SEGMENT4 in VARCHAR2,
246 X_XFER_LOC_SEGMENT5 in VARCHAR2,
247 X_TRANSACTION_HEADER_ID in NUMBER,
248 X_SOURCE_CODE in VARCHAR2,
249 X_SOURCE_LINE_ID in NUMBER,
250 X_SOURCE_HEADER_ID in NUMBER,
251 X_PROCESS_FLAG in NUMBER,
252 X_VALIDATION_REQUIRED in NUMBER,
253 X_TRANSACTION_MODE in NUMBER,
254 X_LOCK_FLAG in NUMBER,
255 X_REQUEST_ID in NUMBER,
256 X_INVENTORY_ITEM_ID in NUMBER,
257 X_ITEM_SEGMENT1 in VARCHAR2,
258 X_ITEM_SEGMENT2 in VARCHAR2,
259 X_ITEM_SEGMENT3 in VARCHAR2,
260 X_ITEM_SEGMENT4 in VARCHAR2,
261 X_ITEM_SEGMENT5 in VARCHAR2,
262 X_ITEM_SEGMENT6 in VARCHAR2,
263 X_ITEM_SEGMENT7 in VARCHAR2,
264 X_ITEM_SEGMENT8 in VARCHAR2,
265 X_ITEM_SEGMENT9 in VARCHAR2,
266 X_ITEM_SEGMENT10 in VARCHAR2,
267 X_ITEM_SEGMENT11 in VARCHAR2,
268 X_ITEM_SEGMENT12 in VARCHAR2,
269 X_ITEM_SEGMENT13 in VARCHAR2,
270 X_ITEM_SEGMENT14 in VARCHAR2,
271 X_ITEM_SEGMENT15 in VARCHAR2,
272 X_ITEM_SEGMENT16 in VARCHAR2,
273 X_ITEM_SEGMENT17 in VARCHAR2,
274 X_ITEM_SEGMENT18 in VARCHAR2,
275 X_ITEM_SEGMENT19 in VARCHAR2,
276 X_ITEM_SEGMENT20 in VARCHAR2,
277 X_REVISION in VARCHAR2,
278 X_ORGANIZATION_ID in NUMBER,
279 X_TRANSACTION_QUANTITY in NUMBER,
280 X_PRIMARY_QUANTITY in NUMBER,
281 X_TRANSACTION_UOM in VARCHAR2,
282 X_TRANSACTION_DATE in DATE,
283 X_ACCT_PERIOD_ID in NUMBER,
284 X_SUBINVENTORY_CODE in VARCHAR2,
285 X_LOCATOR_ID in NUMBER,
286 X_LOC_SEGMENT1 in VARCHAR2,
287 X_LOC_SEGMENT2 in VARCHAR2,
288 X_LOC_SEGMENT3 in VARCHAR2,
289 X_LOC_SEGMENT4 in VARCHAR2,
290 X_LOC_SEGMENT5 in VARCHAR2,
291 X_LOC_SEGMENT6 in VARCHAR2,
292 X_LOC_SEGMENT7 in VARCHAR2,
293 X_LOC_SEGMENT8 in VARCHAR2,
294 X_LOC_SEGMENT9 in VARCHAR2,
295 X_LOC_SEGMENT10 in VARCHAR2,
296 X_LOC_SEGMENT11 in VARCHAR2,
297 X_ERROR_CODE in VARCHAR2,
298 X_CREATION_DATE in DATE,
299 X_CREATED_BY in NUMBER,
300 X_LAST_UPDATE_DATE in DATE,
301 X_LAST_UPDATED_BY in NUMBER,
302 X_LAST_UPDATE_LOGIN in NUMBER
303 ) is
304 cursor C is select ROWID from MTL_TRANSACTIONS_INTERFACE
305 where TRANSACTION_INTERFACE_ID = X_TRANSACTION_INTERFACE_ID
306 ;
307 begin
311 XFR_PLANNING_ORGANIZATION_ID,
308 insert into MTL_TRANSACTIONS_INTERFACE (
309 PLANNING_ORGANIZATION_ID,
310 PLANNING_TP_TYPE,
312 TRANSFER_PLANNING_TP_TYPE,
313 SECONDARY_UOM_CODE,
314 SECONDARY_TRANSACTION_QUANTITY,
315 --TRANSACTION_GROUP_ID,
316 --TRANSACTION_GROUP_SEQ,
317 REPRESENTATIVE_LOT_NUMBER,
318 TRANSACTION_BATCH_ID,
319 TRANSACTION_BATCH_SEQ,
320 REBUILD_ITEM_ID,
321 REBUILD_SERIAL_NUMBER,
322 REBUILD_ACTIVITY_ID,
323 REBUILD_JOB_NAME,
324 MOVE_TRANSACTION_ID,
325 COMPLETION_TRANSACTION_ID,
326 WIP_SUPPLY_TYPE,
327 XFER_LOC_SEGMENT6,
328 XFER_LOC_SEGMENT7,
329 XFER_LOC_SEGMENT8,
330 XFER_LOC_SEGMENT9,
331 XFER_LOC_SEGMENT10,
332 XFER_LOC_SEGMENT11,
333 XFER_LOC_SEGMENT12,
334 XFER_LOC_SEGMENT13,
335 XFER_LOC_SEGMENT14,
336 XFER_LOC_SEGMENT15,
337 XFER_LOC_SEGMENT16,
338 XFER_LOC_SEGMENT17,
339 XFER_LOC_SEGMENT18,
340 XFER_LOC_SEGMENT19,
341 XFER_LOC_SEGMENT20,
342 SHIPMENT_NUMBER,
343 TRANSPORTATION_COST,
344 TRANSPORTATION_ACCOUNT,
345 TRANSFER_COST,
346 FREIGHT_CODE,
347 CONTAINERS,
348 WAYBILL_AIRBILL,
349 EXPECTED_ARRIVAL_DATE,
350 NEW_AVERAGE_COST,
351 VALUE_CHANGE,
352 PERCENTAGE_CHANGE,
353 DEMAND_SOURCE_HEADER_ID,
354 DEMAND_SOURCE_LINE,
355 DEMAND_SOURCE_DELIVERY,
356 NEGATIVE_REQ_FLAG,
357 ERROR_EXPLANATION,
358 SHIPPABLE_FLAG,
359 REQUIRED_FLAG,
360 ATTRIBUTE_CATEGORY,
361 ATTRIBUTE1,
362 ATTRIBUTE2,
363 ATTRIBUTE3,
364 ATTRIBUTE4,
365 ATTRIBUTE5,
366 ATTRIBUTE6,
367 ATTRIBUTE7,
368 ATTRIBUTE8,
369 ATTRIBUTE9,
370 ATTRIBUTE10,
371 ATTRIBUTE11,
372 ATTRIBUTE12,
373 ATTRIBUTE13,
374 ATTRIBUTE14,
375 ATTRIBUTE15,
376 REQUISITION_DISTRIBUTION_ID,
377 MOVEMENT_ID,
378 RESERVATION_QUANTITY,
379 SHIPPED_QUANTITY,
380 INVENTORY_ITEM,
381 LOCATOR_NAME,
382 TASK_ID,
383 TO_TASK_ID,
384 SOURCE_TASK_ID,
385 PROJECT_ID,
386 TO_PROJECT_ID,
387 SOURCE_PROJECT_ID,
388 PA_EXPENDITURE_ORG_ID,
389 EXPENDITURE_TYPE,
390 FINAL_COMPLETION_FLAG,
391 TRANSFER_PERCENTAGE,
392 TRANSACTION_SEQUENCE_ID,
393 MATERIAL_ACCOUNT,
394 MATERIAL_OVERHEAD_ACCOUNT,
395 RESOURCE_ACCOUNT,
396 OUTSIDE_PROCESSING_ACCOUNT,
397 OVERHEAD_ACCOUNT,
398 BOM_REVISION,
399 ROUTING_REVISION,
400 BOM_REVISION_DATE,
401 ROUTING_REVISION_DATE,
402 ALTERNATE_BOM_DESIGNATOR,
403 ALTERNATE_ROUTING_DESIGNATOR,
404 ACCOUNTING_CLASS,
405 DEMAND_CLASS,
406 PARENT_ID,
407 SUBSTITUTION_TYPE_ID,
408 SUBSTITUTION_ITEM_ID,
409 SCHEDULE_GROUP,
410 BUILD_SEQUENCE,
411 SCHEDULE_NUMBER,
412 SCHEDULED_FLAG,
413 FLOW_SCHEDULE,
414 COST_GROUP_ID,
415 KANBAN_CARD_ID,
416 QA_COLLECTION_ID,
417 OVERCOMPLETION_TRANSACTION_QTY,
418 OVERCOMPLETION_PRIMARY_QTY,
419 OVERCOMPLETION_TRANSACTION_ID,
420 END_ITEM_UNIT_NUMBER,
421 SCHEDULED_PAYBACK_DATE,
422 ORG_COST_GROUP_ID,
423 COST_TYPE_ID,
424 SOURCE_LOT_NUMBER,
425 TRANSFER_COST_GROUP_ID,
426 LPN_ID,
427 TRANSFER_LPN_ID,
428 CONTENT_LPN_ID,
429 XML_DOCUMENT_ID,
430 ORGANIZATION_TYPE,
431 TRANSFER_ORGANIZATION_TYPE,
432 OWNING_ORGANIZATION_ID,
433 OWNING_TP_TYPE,
434 XFR_OWNING_ORGANIZATION_ID,
435 TRANSFER_OWNING_TP_TYPE,
436 LOC_SEGMENT12,
437 LOC_SEGMENT13,
438 LOC_SEGMENT14,
439 LOC_SEGMENT15,
440 LOC_SEGMENT16,
441 LOC_SEGMENT17,
442 LOC_SEGMENT18,
443 LOC_SEGMENT19,
444 LOC_SEGMENT20,
445 TRANSACTION_SOURCE_ID,
446 DSP_SEGMENT1,
447 DSP_SEGMENT2,
448 DSP_SEGMENT3,
449 DSP_SEGMENT4,
450 DSP_SEGMENT5,
451 DSP_SEGMENT6,
452 DSP_SEGMENT7,
453 DSP_SEGMENT8,
454 DSP_SEGMENT9,
455 DSP_SEGMENT10,
456 DSP_SEGMENT11,
457 DSP_SEGMENT12,
458 DSP_SEGMENT13,
459 DSP_SEGMENT14,
460 DSP_SEGMENT15,
461 DSP_SEGMENT16,
462 DSP_SEGMENT17,
463 DSP_SEGMENT18,
464 DSP_SEGMENT19,
465 DSP_SEGMENT20,
466 DSP_SEGMENT21,
467 DSP_SEGMENT22,
468 DSP_SEGMENT23,
469 DSP_SEGMENT24,
470 DSP_SEGMENT25,
471 DSP_SEGMENT26,
472 DSP_SEGMENT27,
473 DSP_SEGMENT28,
474 DSP_SEGMENT29,
475 DSP_SEGMENT30,
476 TRANSACTION_SOURCE_NAME,
477 TRANSACTION_SOURCE_TYPE_ID,
478 TRANSACTION_ACTION_ID,
479 TRANSACTION_TYPE_ID,
480 REASON_ID,
481 TRANSACTION_REFERENCE,
482 TRANSACTION_COST,
483 DISTRIBUTION_ACCOUNT_ID,
484 DST_SEGMENT1,
485 DST_SEGMENT2,
486 DST_SEGMENT3,
487 DST_SEGMENT4,
488 DST_SEGMENT5,
489 DST_SEGMENT6,
490 DST_SEGMENT7,
491 DST_SEGMENT8,
492 DST_SEGMENT9,
493 DST_SEGMENT10,
494 DST_SEGMENT11,
495 DST_SEGMENT12,
496 DST_SEGMENT13,
497 DST_SEGMENT14,
498 DST_SEGMENT15,
499 DST_SEGMENT16,
500 DST_SEGMENT17,
504 DST_SEGMENT21,
501 DST_SEGMENT18,
502 DST_SEGMENT19,
503 DST_SEGMENT20,
505 DST_SEGMENT22,
506 DST_SEGMENT23,
507 DST_SEGMENT24,
508 DST_SEGMENT25,
509 DST_SEGMENT26,
510 DST_SEGMENT27,
511 DST_SEGMENT28,
512 DST_SEGMENT29,
513 DST_SEGMENT30,
514 REQUISITION_LINE_ID,
515 CURRENCY_CODE,
516 CURRENCY_CONVERSION_DATE,
517 CURRENCY_CONVERSION_TYPE,
518 CURRENCY_CONVERSION_RATE,
519 USSGL_TRANSACTION_CODE,
520 WIP_ENTITY_TYPE,
521 SCHEDULE_ID,
522 EMPLOYEE_CODE,
523 DEPARTMENT_ID,
524 SCHEDULE_UPDATE_CODE,
525 SETUP_TEARDOWN_CODE,
526 PRIMARY_SWITCH,
527 MRP_CODE,
528 OPERATION_SEQ_NUM,
529 REPETITIVE_LINE_ID,
530 PICKING_LINE_ID,
531 TRX_SOURCE_LINE_ID,
532 TRX_SOURCE_DELIVERY_ID,
533 DEMAND_ID,
534 CUSTOMER_SHIP_ID,
535 LINE_ITEM_NUM,
536 RECEIVING_DOCUMENT,
537 RCV_TRANSACTION_ID,
538 SHIP_TO_LOCATION_ID,
539 ENCUMBRANCE_ACCOUNT,
540 ENCUMBRANCE_AMOUNT,
541 VENDOR_LOT_NUMBER,
542 TRANSFER_SUBINVENTORY,
543 TRANSFER_ORGANIZATION,
544 TRANSFER_LOCATOR,
545 XFER_LOC_SEGMENT1,
546 XFER_LOC_SEGMENT2,
547 XFER_LOC_SEGMENT3,
548 XFER_LOC_SEGMENT4,
549 XFER_LOC_SEGMENT5,
550 TRANSACTION_INTERFACE_ID,
551 TRANSACTION_HEADER_ID,
552 SOURCE_CODE,
553 SOURCE_LINE_ID,
554 SOURCE_HEADER_ID,
555 PROCESS_FLAG,
556 VALIDATION_REQUIRED,
557 TRANSACTION_MODE,
558 LOCK_FLAG,
559 REQUEST_ID,
560 INVENTORY_ITEM_ID,
561 ITEM_SEGMENT1,
562 ITEM_SEGMENT2,
563 ITEM_SEGMENT3,
564 ITEM_SEGMENT4,
565 ITEM_SEGMENT5,
566 ITEM_SEGMENT6,
567 ITEM_SEGMENT7,
568 ITEM_SEGMENT8,
569 ITEM_SEGMENT9,
570 ITEM_SEGMENT10,
571 ITEM_SEGMENT11,
572 ITEM_SEGMENT12,
573 ITEM_SEGMENT13,
574 ITEM_SEGMENT14,
575 ITEM_SEGMENT15,
576 ITEM_SEGMENT16,
577 ITEM_SEGMENT17,
578 ITEM_SEGMENT18,
579 ITEM_SEGMENT19,
580 ITEM_SEGMENT20,
581 REVISION,
582 ORGANIZATION_ID,
583 TRANSACTION_QUANTITY,
584 PRIMARY_QUANTITY,
585 TRANSACTION_UOM,
586 TRANSACTION_DATE,
587 ACCT_PERIOD_ID,
588 SUBINVENTORY_CODE,
589 LOCATOR_ID,
590 LOC_SEGMENT1,
591 LOC_SEGMENT2,
592 LOC_SEGMENT3,
593 LOC_SEGMENT4,
594 LOC_SEGMENT5,
595 LOC_SEGMENT6,
596 LOC_SEGMENT7,
597 LOC_SEGMENT8,
598 LOC_SEGMENT9,
599 LOC_SEGMENT10,
600 LOC_SEGMENT11,
601 CREATION_DATE,
602 CREATED_BY,
603 LAST_UPDATE_DATE,
604 LAST_UPDATED_BY,
605 LAST_UPDATE_LOGIN
606 ) values (
607 X_PLANNING_ORGANIZATION_ID,
608 X_PLANNING_TP_TYPE,
609 X_XFR_PLANNING_ORGANIZATION_ID,
610 X_TRANSFER_PLANNING_TP_TYPE,
611 X_SECONDARY_UOM_CODE,
612 X_SECONDARY_TRANSACTION_QUANTI,
613 --X_TRANSACTION_GROUP_ID,
614 --X_TRANSACTION_GROUP_SEQ,
615 X_REPRESENTATIVE_LOT_NUMBER,
616 X_TRANSACTION_BATCH_ID,
617 X_TRANSACTION_BATCH_SEQ,
618 X_REBUILD_ITEM_ID,
619 X_REBUILD_SERIAL_NUMBER,
620 X_REBUILD_ACTIVITY_ID,
621 X_REBUILD_JOB_NAME,
622 X_MOVE_TRANSACTION_ID,
623 X_COMPLETION_TRANSACTION_ID,
624 X_WIP_SUPPLY_TYPE,
625 X_XFER_LOC_SEGMENT6,
626 X_XFER_LOC_SEGMENT7,
627 X_XFER_LOC_SEGMENT8,
628 X_XFER_LOC_SEGMENT9,
629 X_XFER_LOC_SEGMENT10,
630 X_XFER_LOC_SEGMENT11,
631 X_XFER_LOC_SEGMENT12,
632 X_XFER_LOC_SEGMENT13,
633 X_XFER_LOC_SEGMENT14,
634 X_XFER_LOC_SEGMENT15,
635 X_XFER_LOC_SEGMENT16,
636 X_XFER_LOC_SEGMENT17,
637 X_XFER_LOC_SEGMENT18,
638 X_XFER_LOC_SEGMENT19,
639 X_XFER_LOC_SEGMENT20,
640 X_SHIPMENT_NUMBER,
641 X_TRANSPORTATION_COST,
642 X_TRANSPORTATION_ACCOUNT,
643 X_TRANSFER_COST,
644 X_FREIGHT_CODE,
645 X_CONTAINERS,
646 X_WAYBILL_AIRBILL,
647 X_EXPECTED_ARRIVAL_DATE,
648 X_NEW_AVERAGE_COST,
649 X_VALUE_CHANGE,
650 X_PERCENTAGE_CHANGE,
651 X_DEMAND_SOURCE_HEADER_ID,
652 X_DEMAND_SOURCE_LINE,
653 X_DEMAND_SOURCE_DELIVERY,
654 X_NEGATIVE_REQ_FLAG,
655 X_ERROR_EXPLANATION,
656 X_SHIPPABLE_FLAG,
657 X_REQUIRED_FLAG,
658 X_ATTRIBUTE_CATEGORY,
659 X_ATTRIBUTE1,
660 X_ATTRIBUTE2,
661 X_ATTRIBUTE3,
662 X_ATTRIBUTE4,
663 X_ATTRIBUTE5,
664 X_ATTRIBUTE6,
665 X_ATTRIBUTE7,
666 X_ATTRIBUTE8,
667 X_ATTRIBUTE9,
668 X_ATTRIBUTE10,
669 X_ATTRIBUTE11,
670 X_ATTRIBUTE12,
671 X_ATTRIBUTE13,
672 X_ATTRIBUTE14,
673 X_ATTRIBUTE15,
674 X_REQUISITION_DISTRIBUTION_ID,
675 X_MOVEMENT_ID,
676 X_RESERVATION_QUANTITY,
677 X_SHIPPED_QUANTITY,
678 X_INVENTORY_ITEM,
679 X_LOCATOR_NAME,
680 X_TASK_ID,
681 X_TO_TASK_ID,
682 X_SOURCE_TASK_ID,
683 X_PROJECT_ID,
684 X_TO_PROJECT_ID,
685 X_SOURCE_PROJECT_ID,
686 X_PA_EXPENDITURE_ORG_ID,
687 X_EXPENDITURE_TYPE,
688 X_FINAL_COMPLETION_FLAG,
689 X_TRANSFER_PERCENTAGE,
690 X_TRANSACTION_SEQUENCE_ID,
691 X_MATERIAL_ACCOUNT,
692 X_MATERIAL_OVERHEAD_ACCOUNT,
693 X_RESOURCE_ACCOUNT,
694 X_OUTSIDE_PROCESSING_ACCOUNT,
698 X_BOM_REVISION_DATE,
695 X_OVERHEAD_ACCOUNT,
696 X_BOM_REVISION,
697 X_ROUTING_REVISION,
699 X_ROUTING_REVISION_DATE,
700 X_ALTERNATE_BOM_DESIGNATOR,
701 X_ALTERNATE_ROUTING_DESIGNATOR,
702 X_ACCOUNTING_CLASS,
703 X_DEMAND_CLASS,
704 X_PARENT_ID,
705 X_SUBSTITUTION_TYPE_ID,
706 X_SUBSTITUTION_ITEM_ID,
707 X_SCHEDULE_GROUP,
708 X_BUILD_SEQUENCE,
709 X_SCHEDULE_NUMBER,
710 X_SCHEDULED_FLAG,
711 X_FLOW_SCHEDULE,
712 X_COST_GROUP_ID,
713 X_KANBAN_CARD_ID,
714 X_QA_COLLECTION_ID,
715 X_OVERCOMPLETION_TRANSACTION_Q,
716 X_OVERCOMPLETION_PRIMARY_QTY,
717 X_OVERCOMPLETION_TRANSACTION_I,
718 X_END_ITEM_UNIT_NUMBER,
719 X_SCHEDULED_PAYBACK_DATE,
720 X_ORG_COST_GROUP_ID,
721 X_COST_TYPE_ID,
722 X_SOURCE_LOT_NUMBER,
723 X_TRANSFER_COST_GROUP_ID,
724 X_LPN_ID,
725 X_TRANSFER_LPN_ID,
726 X_CONTENT_LPN_ID,
727 X_XML_DOCUMENT_ID,
728 X_ORGANIZATION_TYPE,
729 X_TRANSFER_ORGANIZATION_TYPE,
730 X_OWNING_ORGANIZATION_ID,
731 X_OWNING_TP_TYPE,
732 X_XFR_OWNING_ORGANIZATION_ID,
733 X_TRANSFER_OWNING_TP_TYPE,
734 X_LOC_SEGMENT12,
735 X_LOC_SEGMENT13,
736 X_LOC_SEGMENT14,
737 X_LOC_SEGMENT15,
738 X_LOC_SEGMENT16,
739 X_LOC_SEGMENT17,
740 X_LOC_SEGMENT18,
741 X_LOC_SEGMENT19,
742 X_LOC_SEGMENT20,
743 X_TRANSACTION_SOURCE_ID,
744 X_DSP_SEGMENT1,
745 X_DSP_SEGMENT2,
746 X_DSP_SEGMENT3,
747 X_DSP_SEGMENT4,
748 X_DSP_SEGMENT5,
749 X_DSP_SEGMENT6,
750 X_DSP_SEGMENT7,
751 X_DSP_SEGMENT8,
752 X_DSP_SEGMENT9,
753 X_DSP_SEGMENT10,
754 X_DSP_SEGMENT11,
755 X_DSP_SEGMENT12,
756 X_DSP_SEGMENT13,
757 X_DSP_SEGMENT14,
758 X_DSP_SEGMENT15,
759 X_DSP_SEGMENT16,
760 X_DSP_SEGMENT17,
761 X_DSP_SEGMENT18,
762 X_DSP_SEGMENT19,
763 X_DSP_SEGMENT20,
764 X_DSP_SEGMENT21,
765 X_DSP_SEGMENT22,
766 X_DSP_SEGMENT23,
767 X_DSP_SEGMENT24,
768 X_DSP_SEGMENT25,
769 X_DSP_SEGMENT26,
770 X_DSP_SEGMENT27,
771 X_DSP_SEGMENT28,
772 X_DSP_SEGMENT29,
773 X_DSP_SEGMENT30,
774 X_TRANSACTION_SOURCE_NAME,
775 X_TRANSACTION_SOURCE_TYPE_ID,
776 X_TRANSACTION_ACTION_ID,
777 X_TRANSACTION_TYPE_ID,
778 X_REASON_ID,
779 X_TRANSACTION_REFERENCE,
780 X_TRANSACTION_COST,
781 X_DISTRIBUTION_ACCOUNT_ID,
782 X_DST_SEGMENT1,
783 X_DST_SEGMENT2,
784 X_DST_SEGMENT3,
785 X_DST_SEGMENT4,
786 X_DST_SEGMENT5,
787 X_DST_SEGMENT6,
788 X_DST_SEGMENT7,
789 X_DST_SEGMENT8,
790 X_DST_SEGMENT9,
791 X_DST_SEGMENT10,
792 X_DST_SEGMENT11,
793 X_DST_SEGMENT12,
794 X_DST_SEGMENT13,
795 X_DST_SEGMENT14,
796 X_DST_SEGMENT15,
797 X_DST_SEGMENT16,
798 X_DST_SEGMENT17,
799 X_DST_SEGMENT18,
800 X_DST_SEGMENT19,
801 X_DST_SEGMENT20,
802 X_DST_SEGMENT21,
803 X_DST_SEGMENT22,
804 X_DST_SEGMENT23,
805 X_DST_SEGMENT24,
806 X_DST_SEGMENT25,
807 X_DST_SEGMENT26,
808 X_DST_SEGMENT27,
809 X_DST_SEGMENT28,
810 X_DST_SEGMENT29,
811 X_DST_SEGMENT30,
812 X_REQUISITION_LINE_ID,
813 X_CURRENCY_CODE,
814 X_CURRENCY_CONVERSION_DATE,
815 X_CURRENCY_CONVERSION_TYPE,
816 X_CURRENCY_CONVERSION_RATE,
817 X_USSGL_TRANSACTION_CODE,
818 X_WIP_ENTITY_TYPE,
819 X_SCHEDULE_ID,
820 X_EMPLOYEE_CODE,
821 X_DEPARTMENT_ID,
822 X_SCHEDULE_UPDATE_CODE,
823 X_SETUP_TEARDOWN_CODE,
824 X_PRIMARY_SWITCH,
825 X_MRP_CODE,
826 X_OPERATION_SEQ_NUM,
827 X_REPETITIVE_LINE_ID,
828 X_PICKING_LINE_ID,
829 X_TRX_SOURCE_LINE_ID,
830 X_TRX_SOURCE_DELIVERY_ID,
831 X_DEMAND_ID,
832 X_CUSTOMER_SHIP_ID,
833 X_LINE_ITEM_NUM,
834 X_RECEIVING_DOCUMENT,
835 X_RCV_TRANSACTION_ID,
836 X_SHIP_TO_LOCATION_ID,
837 X_ENCUMBRANCE_ACCOUNT,
838 X_ENCUMBRANCE_AMOUNT,
839 X_VENDOR_LOT_NUMBER,
840 X_TRANSFER_SUBINVENTORY,
841 X_TRANSFER_ORGANIZATION,
842 X_TRANSFER_LOCATOR,
843 X_XFER_LOC_SEGMENT1,
844 X_XFER_LOC_SEGMENT2,
845 X_XFER_LOC_SEGMENT3,
846 X_XFER_LOC_SEGMENT4,
847 X_XFER_LOC_SEGMENT5,
848 X_TRANSACTION_INTERFACE_ID,
849 X_TRANSACTION_HEADER_ID,
850 X_SOURCE_CODE,
851 X_SOURCE_LINE_ID,
852 X_SOURCE_HEADER_ID,
853 X_PROCESS_FLAG,
854 X_VALIDATION_REQUIRED,
855 X_TRANSACTION_MODE,
856 X_LOCK_FLAG,
857 X_REQUEST_ID,
858 X_INVENTORY_ITEM_ID,
859 X_ITEM_SEGMENT1,
860 X_ITEM_SEGMENT2,
861 X_ITEM_SEGMENT3,
862 X_ITEM_SEGMENT4,
863 X_ITEM_SEGMENT5,
864 X_ITEM_SEGMENT6,
865 X_ITEM_SEGMENT7,
866 X_ITEM_SEGMENT8,
867 X_ITEM_SEGMENT9,
868 X_ITEM_SEGMENT10,
869 X_ITEM_SEGMENT11,
870 X_ITEM_SEGMENT12,
871 X_ITEM_SEGMENT13,
872 X_ITEM_SEGMENT14,
873 X_ITEM_SEGMENT15,
874 X_ITEM_SEGMENT16,
875 X_ITEM_SEGMENT17,
876 X_ITEM_SEGMENT18,
877 X_ITEM_SEGMENT19,
878 X_ITEM_SEGMENT20,
879 X_REVISION,
880 X_ORGANIZATION_ID,
881 X_TRANSACTION_QUANTITY,
882 X_PRIMARY_QUANTITY,
883 X_TRANSACTION_UOM,
884 X_TRANSACTION_DATE,
888 X_LOC_SEGMENT1,
885 X_ACCT_PERIOD_ID,
886 X_SUBINVENTORY_CODE,
887 X_LOCATOR_ID,
889 X_LOC_SEGMENT2,
890 X_LOC_SEGMENT3,
891 X_LOC_SEGMENT4,
892 X_LOC_SEGMENT5,
893 X_LOC_SEGMENT6,
894 X_LOC_SEGMENT7,
895 X_LOC_SEGMENT8,
896 X_LOC_SEGMENT9,
897 X_LOC_SEGMENT10,
898 X_LOC_SEGMENT11,
899 sysdate,
900 fnd_global.user_id,
901 sysdate,
902 fnd_global.user_id,
903 fnd_global.login_id
904 );
905
906 open c;
907 fetch c into X_ROWID;
908 if (c%notfound) then
909 close c;
910 raise no_data_found;
911 end if;
912 close c;
913
914 end INSERT_ROW;
915
916 procedure LOCK_ROW (
917 X_TRANSACTION_INTERFACE_ID in NUMBER,
918 X_PLANNING_ORGANIZATION_ID in NUMBER,
919 X_PLANNING_TP_TYPE in NUMBER,
920 X_XFR_PLANNING_ORGANIZATION_ID in NUMBER,
921 X_TRANSFER_PLANNING_TP_TYPE in NUMBER,
922 X_SECONDARY_UOM_CODE in VARCHAR2,
923 X_SECONDARY_TRANSACTION_QUANTI in NUMBER,
924 X_TRANSACTION_GROUP_ID in NUMBER,
925 X_TRANSACTION_GROUP_SEQ in NUMBER,
926 X_REPRESENTATIVE_LOT_NUMBER in VARCHAR2,
927 X_TRANSACTION_BATCH_ID in NUMBER,
928 X_TRANSACTION_BATCH_SEQ in NUMBER,
929 X_REBUILD_ITEM_ID in NUMBER,
930 X_REBUILD_SERIAL_NUMBER in VARCHAR2,
931 X_REBUILD_ACTIVITY_ID in NUMBER,
932 X_REBUILD_JOB_NAME in VARCHAR2,
933 X_MOVE_TRANSACTION_ID in NUMBER,
934 X_COMPLETION_TRANSACTION_ID in NUMBER,
935 X_WIP_SUPPLY_TYPE in NUMBER,
936 X_XFER_LOC_SEGMENT6 in VARCHAR2,
937 X_XFER_LOC_SEGMENT7 in VARCHAR2,
938 X_XFER_LOC_SEGMENT8 in VARCHAR2,
939 X_XFER_LOC_SEGMENT9 in VARCHAR2,
940 X_XFER_LOC_SEGMENT10 in VARCHAR2,
941 X_XFER_LOC_SEGMENT11 in VARCHAR2,
942 X_XFER_LOC_SEGMENT12 in VARCHAR2,
943 X_XFER_LOC_SEGMENT13 in VARCHAR2,
944 X_XFER_LOC_SEGMENT14 in VARCHAR2,
945 X_XFER_LOC_SEGMENT15 in VARCHAR2,
946 X_XFER_LOC_SEGMENT16 in VARCHAR2,
947 X_XFER_LOC_SEGMENT17 in VARCHAR2,
948 X_XFER_LOC_SEGMENT18 in VARCHAR2,
949 X_XFER_LOC_SEGMENT19 in VARCHAR2,
950 X_XFER_LOC_SEGMENT20 in VARCHAR2,
951 X_SHIPMENT_NUMBER in VARCHAR2,
952 X_TRANSPORTATION_COST in NUMBER,
953 X_TRANSPORTATION_ACCOUNT in NUMBER,
954 X_TRANSFER_COST in NUMBER,
955 X_FREIGHT_CODE in VARCHAR2,
956 X_CONTAINERS in NUMBER,
957 X_WAYBILL_AIRBILL in VARCHAR2,
958 X_EXPECTED_ARRIVAL_DATE in DATE,
959 X_NEW_AVERAGE_COST in NUMBER,
960 X_VALUE_CHANGE in NUMBER,
961 X_PERCENTAGE_CHANGE in NUMBER,
962 X_DEMAND_SOURCE_HEADER_ID in NUMBER,
963 X_DEMAND_SOURCE_LINE in VARCHAR2,
964 X_DEMAND_SOURCE_DELIVERY in VARCHAR2,
965 X_NEGATIVE_REQ_FLAG in NUMBER,
966 X_ERROR_EXPLANATION in VARCHAR2,
967 X_SHIPPABLE_FLAG in VARCHAR2,
968 X_REQUIRED_FLAG in VARCHAR2,
969 X_ATTRIBUTE_CATEGORY in VARCHAR2,
970 X_ATTRIBUTE1 in VARCHAR2,
971 X_ATTRIBUTE2 in VARCHAR2,
972 X_ATTRIBUTE3 in VARCHAR2,
973 X_ATTRIBUTE4 in VARCHAR2,
974 X_ATTRIBUTE5 in VARCHAR2,
975 X_ATTRIBUTE6 in VARCHAR2,
976 X_ATTRIBUTE7 in VARCHAR2,
977 X_ATTRIBUTE8 in VARCHAR2,
978 X_ATTRIBUTE9 in VARCHAR2,
979 X_ATTRIBUTE10 in VARCHAR2,
980 X_ATTRIBUTE11 in VARCHAR2,
981 X_ATTRIBUTE12 in VARCHAR2,
982 X_ATTRIBUTE13 in VARCHAR2,
983 X_ATTRIBUTE14 in VARCHAR2,
984 X_ATTRIBUTE15 in VARCHAR2,
985 X_REQUISITION_DISTRIBUTION_ID in NUMBER,
986 X_MOVEMENT_ID in NUMBER,
987 X_RESERVATION_QUANTITY in NUMBER,
988 X_SHIPPED_QUANTITY in NUMBER,
989 X_INVENTORY_ITEM in VARCHAR2,
990 X_LOCATOR_NAME in VARCHAR2,
991 X_TASK_ID in NUMBER,
992 X_TO_TASK_ID in NUMBER,
993 X_SOURCE_TASK_ID in NUMBER,
994 X_PROJECT_ID in NUMBER,
995 X_TO_PROJECT_ID in NUMBER,
996 X_SOURCE_PROJECT_ID in NUMBER,
997 X_PA_EXPENDITURE_ORG_ID in NUMBER,
998 X_EXPENDITURE_TYPE in VARCHAR2,
999 X_FINAL_COMPLETION_FLAG in VARCHAR2,
1000 X_TRANSFER_PERCENTAGE in NUMBER,
1001 X_TRANSACTION_SEQUENCE_ID in NUMBER,
1002 X_MATERIAL_ACCOUNT in NUMBER,
1003 X_MATERIAL_OVERHEAD_ACCOUNT in NUMBER,
1004 X_RESOURCE_ACCOUNT in NUMBER,
1005 X_OUTSIDE_PROCESSING_ACCOUNT in NUMBER,
1006 X_OVERHEAD_ACCOUNT in NUMBER,
1007 X_BOM_REVISION in VARCHAR2,
1008 X_ROUTING_REVISION in VARCHAR2,
1009 X_BOM_REVISION_DATE in DATE,
1010 X_ROUTING_REVISION_DATE in DATE,
1011 X_ALTERNATE_BOM_DESIGNATOR in VARCHAR2,
1012 X_ALTERNATE_ROUTING_DESIGNATOR in VARCHAR2,
1013 X_ACCOUNTING_CLASS in VARCHAR2,
1014 X_DEMAND_CLASS in VARCHAR2,
1015 X_PARENT_ID in NUMBER,
1016 X_SUBSTITUTION_TYPE_ID in NUMBER,
1017 X_SUBSTITUTION_ITEM_ID in NUMBER,
1018 X_SCHEDULE_GROUP in NUMBER,
1019 X_BUILD_SEQUENCE in NUMBER,
1020 X_SCHEDULE_NUMBER in VARCHAR2,
1021 X_SCHEDULED_FLAG in NUMBER,
1022 X_FLOW_SCHEDULE in VARCHAR2,
1023 X_COST_GROUP_ID in NUMBER,
1024 X_KANBAN_CARD_ID in NUMBER,
1025 X_QA_COLLECTION_ID in NUMBER,
1026 X_OVERCOMPLETION_TRANSACTION_Q in NUMBER,
1027 X_OVERCOMPLETION_PRIMARY_QTY in NUMBER,
1028 X_OVERCOMPLETION_TRANSACTION_I in NUMBER,
1029 X_END_ITEM_UNIT_NUMBER in VARCHAR2,
1030 X_SCHEDULED_PAYBACK_DATE in DATE,
1031 X_ORG_COST_GROUP_ID in NUMBER,
1032 X_COST_TYPE_ID in NUMBER,
1033 X_SOURCE_LOT_NUMBER in VARCHAR2,
1034 X_TRANSFER_COST_GROUP_ID in NUMBER,
1035 X_LPN_ID in NUMBER,
1036 X_TRANSFER_LPN_ID in NUMBER,
1037 X_CONTENT_LPN_ID in NUMBER,
1038 X_XML_DOCUMENT_ID in VARCHAR2,
1039 X_ORGANIZATION_TYPE in NUMBER,
1040 X_TRANSFER_ORGANIZATION_TYPE in NUMBER,
1041 X_OWNING_ORGANIZATION_ID in NUMBER,
1042 X_OWNING_TP_TYPE in NUMBER,
1043 X_XFR_OWNING_ORGANIZATION_ID in NUMBER,
1044 X_TRANSFER_OWNING_TP_TYPE in NUMBER,
1048 X_LOC_SEGMENT15 in VARCHAR2,
1045 X_LOC_SEGMENT12 in VARCHAR2,
1046 X_LOC_SEGMENT13 in VARCHAR2,
1047 X_LOC_SEGMENT14 in VARCHAR2,
1049 X_LOC_SEGMENT16 in VARCHAR2,
1050 X_LOC_SEGMENT17 in VARCHAR2,
1051 X_LOC_SEGMENT18 in VARCHAR2,
1052 X_LOC_SEGMENT19 in VARCHAR2,
1053 X_LOC_SEGMENT20 in VARCHAR2,
1054 X_TRANSACTION_SOURCE_ID in NUMBER,
1055 X_DSP_SEGMENT1 in VARCHAR2,
1056 X_DSP_SEGMENT2 in VARCHAR2,
1057 X_DSP_SEGMENT3 in VARCHAR2,
1058 X_DSP_SEGMENT4 in VARCHAR2,
1059 X_DSP_SEGMENT5 in VARCHAR2,
1060 X_DSP_SEGMENT6 in VARCHAR2,
1061 X_DSP_SEGMENT7 in VARCHAR2,
1062 X_DSP_SEGMENT8 in VARCHAR2,
1063 X_DSP_SEGMENT9 in VARCHAR2,
1064 X_DSP_SEGMENT10 in VARCHAR2,
1065 X_DSP_SEGMENT11 in VARCHAR2,
1066 X_DSP_SEGMENT12 in VARCHAR2,
1067 X_DSP_SEGMENT13 in VARCHAR2,
1068 X_DSP_SEGMENT14 in VARCHAR2,
1069 X_DSP_SEGMENT15 in VARCHAR2,
1070 X_DSP_SEGMENT16 in VARCHAR2,
1071 X_DSP_SEGMENT17 in VARCHAR2,
1072 X_DSP_SEGMENT18 in VARCHAR2,
1073 X_DSP_SEGMENT19 in VARCHAR2,
1074 X_DSP_SEGMENT20 in VARCHAR2,
1075 X_DSP_SEGMENT21 in VARCHAR2,
1076 X_DSP_SEGMENT22 in VARCHAR2,
1077 X_DSP_SEGMENT23 in VARCHAR2,
1078 X_DSP_SEGMENT24 in VARCHAR2,
1079 X_DSP_SEGMENT25 in VARCHAR2,
1080 X_DSP_SEGMENT26 in VARCHAR2,
1081 X_DSP_SEGMENT27 in VARCHAR2,
1082 X_DSP_SEGMENT28 in VARCHAR2,
1083 X_DSP_SEGMENT29 in VARCHAR2,
1084 X_DSP_SEGMENT30 in VARCHAR2,
1085 X_TRANSACTION_SOURCE_NAME in VARCHAR2,
1086 X_TRANSACTION_SOURCE_TYPE_ID in NUMBER,
1087 X_TRANSACTION_ACTION_ID in NUMBER,
1088 X_TRANSACTION_TYPE_ID in NUMBER,
1089 X_REASON_ID in NUMBER,
1090 X_TRANSACTION_REFERENCE in VARCHAR2,
1091 X_TRANSACTION_COST in NUMBER,
1092 X_DISTRIBUTION_ACCOUNT_ID in NUMBER,
1093 X_DST_SEGMENT1 in VARCHAR2,
1094 X_DST_SEGMENT2 in VARCHAR2,
1095 X_DST_SEGMENT3 in VARCHAR2,
1096 X_DST_SEGMENT4 in VARCHAR2,
1097 X_DST_SEGMENT5 in VARCHAR2,
1098 X_DST_SEGMENT6 in VARCHAR2,
1099 X_DST_SEGMENT7 in VARCHAR2,
1100 X_DST_SEGMENT8 in VARCHAR2,
1101 X_DST_SEGMENT9 in VARCHAR2,
1102 X_DST_SEGMENT10 in VARCHAR2,
1103 X_DST_SEGMENT11 in VARCHAR2,
1104 X_DST_SEGMENT12 in VARCHAR2,
1105 X_DST_SEGMENT13 in VARCHAR2,
1106 X_DST_SEGMENT14 in VARCHAR2,
1107 X_DST_SEGMENT15 in VARCHAR2,
1108 X_DST_SEGMENT16 in VARCHAR2,
1109 X_DST_SEGMENT17 in VARCHAR2,
1110 X_DST_SEGMENT18 in VARCHAR2,
1111 X_DST_SEGMENT19 in VARCHAR2,
1112 X_DST_SEGMENT20 in VARCHAR2,
1113 X_DST_SEGMENT21 in VARCHAR2,
1114 X_DST_SEGMENT22 in VARCHAR2,
1115 X_DST_SEGMENT23 in VARCHAR2,
1116 X_DST_SEGMENT24 in VARCHAR2,
1117 X_DST_SEGMENT25 in VARCHAR2,
1118 X_DST_SEGMENT26 in VARCHAR2,
1119 X_DST_SEGMENT27 in VARCHAR2,
1120 X_DST_SEGMENT28 in VARCHAR2,
1121 X_DST_SEGMENT29 in VARCHAR2,
1122 X_DST_SEGMENT30 in VARCHAR2,
1123 X_REQUISITION_LINE_ID in NUMBER,
1124 X_CURRENCY_CODE in VARCHAR2,
1125 X_CURRENCY_CONVERSION_DATE in DATE,
1126 X_CURRENCY_CONVERSION_TYPE in VARCHAR2,
1127 X_CURRENCY_CONVERSION_RATE in NUMBER,
1128 X_USSGL_TRANSACTION_CODE in VARCHAR2,
1129 X_WIP_ENTITY_TYPE in NUMBER,
1130 X_SCHEDULE_ID in NUMBER,
1131 X_EMPLOYEE_CODE in VARCHAR2,
1132 X_DEPARTMENT_ID in NUMBER,
1133 X_SCHEDULE_UPDATE_CODE in NUMBER,
1134 X_SETUP_TEARDOWN_CODE in NUMBER,
1135 X_PRIMARY_SWITCH in NUMBER,
1136 X_MRP_CODE in NUMBER,
1137 X_OPERATION_SEQ_NUM in NUMBER,
1138 X_REPETITIVE_LINE_ID in NUMBER,
1139 X_PICKING_LINE_ID in NUMBER,
1140 X_TRX_SOURCE_LINE_ID in NUMBER,
1141 X_TRX_SOURCE_DELIVERY_ID in NUMBER,
1142 X_DEMAND_ID in NUMBER,
1143 X_CUSTOMER_SHIP_ID in NUMBER,
1144 X_LINE_ITEM_NUM in NUMBER,
1145 X_RECEIVING_DOCUMENT in VARCHAR2,
1146 X_RCV_TRANSACTION_ID in NUMBER,
1147 X_SHIP_TO_LOCATION_ID in NUMBER,
1148 X_ENCUMBRANCE_ACCOUNT in NUMBER,
1149 X_ENCUMBRANCE_AMOUNT in NUMBER,
1150 X_VENDOR_LOT_NUMBER in VARCHAR2,
1151 X_TRANSFER_SUBINVENTORY in VARCHAR2,
1152 X_TRANSFER_ORGANIZATION in NUMBER,
1153 X_TRANSFER_LOCATOR in NUMBER,
1154 X_XFER_LOC_SEGMENT1 in VARCHAR2,
1155 X_XFER_LOC_SEGMENT2 in VARCHAR2,
1156 X_XFER_LOC_SEGMENT3 in VARCHAR2,
1157 X_XFER_LOC_SEGMENT4 in VARCHAR2,
1158 X_XFER_LOC_SEGMENT5 in VARCHAR2,
1159 X_TRANSACTION_HEADER_ID in NUMBER,
1160 X_SOURCE_CODE in VARCHAR2,
1161 X_SOURCE_LINE_ID in NUMBER,
1162 X_SOURCE_HEADER_ID in NUMBER,
1163 X_PROCESS_FLAG in NUMBER,
1164 X_VALIDATION_REQUIRED in NUMBER,
1165 X_TRANSACTION_MODE in NUMBER,
1166 X_LOCK_FLAG in NUMBER,
1167 X_REQUEST_ID in NUMBER,
1168 X_INVENTORY_ITEM_ID in NUMBER,
1169 X_ITEM_SEGMENT1 in VARCHAR2,
1170 X_ITEM_SEGMENT2 in VARCHAR2,
1171 X_ITEM_SEGMENT3 in VARCHAR2,
1172 X_ITEM_SEGMENT4 in VARCHAR2,
1173 X_ITEM_SEGMENT5 in VARCHAR2,
1174 X_ITEM_SEGMENT6 in VARCHAR2,
1175 X_ITEM_SEGMENT7 in VARCHAR2,
1176 X_ITEM_SEGMENT8 in VARCHAR2,
1177 X_ITEM_SEGMENT9 in VARCHAR2,
1178 X_ITEM_SEGMENT10 in VARCHAR2,
1179 X_ITEM_SEGMENT11 in VARCHAR2,
1180 X_ITEM_SEGMENT12 in VARCHAR2,
1181 X_ITEM_SEGMENT13 in VARCHAR2,
1182 X_ITEM_SEGMENT14 in VARCHAR2,
1183 X_ITEM_SEGMENT15 in VARCHAR2,
1184 X_ITEM_SEGMENT16 in VARCHAR2,
1185 X_ITEM_SEGMENT17 in VARCHAR2,
1186 X_ITEM_SEGMENT18 in VARCHAR2,
1187 X_ITEM_SEGMENT19 in VARCHAR2,
1188 X_ITEM_SEGMENT20 in VARCHAR2,
1189 X_REVISION in VARCHAR2,
1190 X_ORGANIZATION_ID in NUMBER,
1191 X_TRANSACTION_QUANTITY in NUMBER,
1192 X_PRIMARY_QUANTITY in NUMBER,
1193 X_TRANSACTION_UOM in VARCHAR2,
1194 X_TRANSACTION_DATE in DATE,
1195 X_ACCT_PERIOD_ID in NUMBER,
1196 X_SUBINVENTORY_CODE in VARCHAR2,
1197 X_LOCATOR_ID in NUMBER,
1198 X_LOC_SEGMENT1 in VARCHAR2,
1199 X_LOC_SEGMENT2 in VARCHAR2,
1203 X_LOC_SEGMENT6 in VARCHAR2,
1200 X_LOC_SEGMENT3 in VARCHAR2,
1201 X_LOC_SEGMENT4 in VARCHAR2,
1202 X_LOC_SEGMENT5 in VARCHAR2,
1204 X_LOC_SEGMENT7 in VARCHAR2,
1205 X_LOC_SEGMENT8 in VARCHAR2,
1206 X_LOC_SEGMENT9 in VARCHAR2,
1207 X_LOC_SEGMENT10 in VARCHAR2,
1208 X_LOC_SEGMENT11 in VARCHAR2,
1209 X_ERROR_CODE in VARCHAR2
1210 ) is
1211 cursor c is select
1212 PLANNING_ORGANIZATION_ID,
1213 PLANNING_TP_TYPE,
1214 XFR_PLANNING_ORGANIZATION_ID,
1215 TRANSFER_PLANNING_TP_TYPE,
1216 SECONDARY_UOM_CODE,
1217 SECONDARY_TRANSACTION_QUANTITY,
1218 --TRANSACTION_GROUP_ID,
1219 --TRANSACTION_GROUP_SEQ,
1220 REPRESENTATIVE_LOT_NUMBER,
1221 TRANSACTION_BATCH_ID,
1222 TRANSACTION_BATCH_SEQ,
1223 REBUILD_ITEM_ID,
1224 REBUILD_SERIAL_NUMBER,
1225 REBUILD_ACTIVITY_ID,
1226 REBUILD_JOB_NAME,
1227 MOVE_TRANSACTION_ID,
1228 COMPLETION_TRANSACTION_ID,
1229 WIP_SUPPLY_TYPE,
1230 XFER_LOC_SEGMENT6,
1231 XFER_LOC_SEGMENT7,
1232 XFER_LOC_SEGMENT8,
1233 XFER_LOC_SEGMENT9,
1234 XFER_LOC_SEGMENT10,
1235 XFER_LOC_SEGMENT11,
1236 XFER_LOC_SEGMENT12,
1237 XFER_LOC_SEGMENT13,
1238 XFER_LOC_SEGMENT14,
1239 XFER_LOC_SEGMENT15,
1240 XFER_LOC_SEGMENT16,
1241 XFER_LOC_SEGMENT17,
1242 XFER_LOC_SEGMENT18,
1243 XFER_LOC_SEGMENT19,
1244 XFER_LOC_SEGMENT20,
1245 SHIPMENT_NUMBER,
1246 TRANSPORTATION_COST,
1247 TRANSPORTATION_ACCOUNT,
1248 TRANSFER_COST,
1249 FREIGHT_CODE,
1250 CONTAINERS,
1251 WAYBILL_AIRBILL,
1252 EXPECTED_ARRIVAL_DATE,
1253 NEW_AVERAGE_COST,
1254 VALUE_CHANGE,
1255 PERCENTAGE_CHANGE,
1256 DEMAND_SOURCE_HEADER_ID,
1257 DEMAND_SOURCE_LINE,
1258 DEMAND_SOURCE_DELIVERY,
1259 NEGATIVE_REQ_FLAG,
1260 ERROR_EXPLANATION,
1261 SHIPPABLE_FLAG,
1262 REQUIRED_FLAG,
1263 ATTRIBUTE_CATEGORY,
1264 ATTRIBUTE1,
1265 ATTRIBUTE2,
1266 ATTRIBUTE3,
1267 ATTRIBUTE4,
1268 ATTRIBUTE5,
1269 ATTRIBUTE6,
1270 ATTRIBUTE7,
1271 ATTRIBUTE8,
1272 ATTRIBUTE9,
1273 ATTRIBUTE10,
1274 ATTRIBUTE11,
1275 ATTRIBUTE12,
1276 ATTRIBUTE13,
1277 ATTRIBUTE14,
1278 ATTRIBUTE15,
1279 REQUISITION_DISTRIBUTION_ID,
1280 MOVEMENT_ID,
1281 RESERVATION_QUANTITY,
1282 SHIPPED_QUANTITY,
1283 INVENTORY_ITEM,
1284 LOCATOR_NAME,
1285 TASK_ID,
1286 TO_TASK_ID,
1287 SOURCE_TASK_ID,
1288 PROJECT_ID,
1289 TO_PROJECT_ID,
1290 SOURCE_PROJECT_ID,
1291 PA_EXPENDITURE_ORG_ID,
1292 EXPENDITURE_TYPE,
1293 FINAL_COMPLETION_FLAG,
1294 TRANSFER_PERCENTAGE,
1295 TRANSACTION_SEQUENCE_ID,
1296 MATERIAL_ACCOUNT,
1297 MATERIAL_OVERHEAD_ACCOUNT,
1298 RESOURCE_ACCOUNT,
1299 OUTSIDE_PROCESSING_ACCOUNT,
1300 OVERHEAD_ACCOUNT,
1301 BOM_REVISION,
1302 ROUTING_REVISION,
1303 BOM_REVISION_DATE,
1304 ROUTING_REVISION_DATE,
1305 ALTERNATE_BOM_DESIGNATOR,
1306 ALTERNATE_ROUTING_DESIGNATOR,
1307 ACCOUNTING_CLASS,
1308 DEMAND_CLASS,
1309 PARENT_ID,
1310 SUBSTITUTION_TYPE_ID,
1311 SUBSTITUTION_ITEM_ID,
1312 SCHEDULE_GROUP,
1313 BUILD_SEQUENCE,
1314 SCHEDULE_NUMBER,
1315 SCHEDULED_FLAG,
1316 FLOW_SCHEDULE,
1317 COST_GROUP_ID,
1318 KANBAN_CARD_ID,
1319 QA_COLLECTION_ID,
1320 OVERCOMPLETION_TRANSACTION_QTY,
1321 OVERCOMPLETION_PRIMARY_QTY,
1322 OVERCOMPLETION_TRANSACTION_ID,
1323 END_ITEM_UNIT_NUMBER,
1324 SCHEDULED_PAYBACK_DATE,
1325 ORG_COST_GROUP_ID,
1326 COST_TYPE_ID,
1327 SOURCE_LOT_NUMBER,
1328 TRANSFER_COST_GROUP_ID,
1329 LPN_ID,
1330 TRANSFER_LPN_ID,
1331 CONTENT_LPN_ID,
1332 XML_DOCUMENT_ID,
1333 ORGANIZATION_TYPE,
1334 TRANSFER_ORGANIZATION_TYPE,
1335 OWNING_ORGANIZATION_ID,
1336 OWNING_TP_TYPE,
1337 XFR_OWNING_ORGANIZATION_ID,
1338 TRANSFER_OWNING_TP_TYPE,
1339 LOC_SEGMENT12,
1340 LOC_SEGMENT13,
1341 LOC_SEGMENT14,
1342 LOC_SEGMENT15,
1343 LOC_SEGMENT16,
1344 LOC_SEGMENT17,
1345 LOC_SEGMENT18,
1346 LOC_SEGMENT19,
1347 LOC_SEGMENT20,
1348 TRANSACTION_SOURCE_ID,
1349 DSP_SEGMENT1,
1350 DSP_SEGMENT2,
1351 DSP_SEGMENT3,
1352 DSP_SEGMENT4,
1353 DSP_SEGMENT5,
1354 DSP_SEGMENT6,
1355 DSP_SEGMENT7,
1356 DSP_SEGMENT8,
1357 DSP_SEGMENT9,
1358 DSP_SEGMENT10,
1359 DSP_SEGMENT11,
1360 DSP_SEGMENT12,
1361 DSP_SEGMENT13,
1362 DSP_SEGMENT14,
1363 DSP_SEGMENT15,
1364 DSP_SEGMENT16,
1365 DSP_SEGMENT17,
1366 DSP_SEGMENT18,
1367 DSP_SEGMENT19,
1368 DSP_SEGMENT20,
1369 DSP_SEGMENT21,
1370 DSP_SEGMENT22,
1371 DSP_SEGMENT23,
1372 DSP_SEGMENT24,
1373 DSP_SEGMENT25,
1374 DSP_SEGMENT26,
1375 DSP_SEGMENT27,
1376 DSP_SEGMENT28,
1377 DSP_SEGMENT29,
1378 DSP_SEGMENT30,
1379 TRANSACTION_SOURCE_NAME,
1380 TRANSACTION_SOURCE_TYPE_ID,
1381 TRANSACTION_ACTION_ID,
1382 TRANSACTION_TYPE_ID,
1383 REASON_ID,
1384 TRANSACTION_REFERENCE,
1388 DST_SEGMENT2,
1385 TRANSACTION_COST,
1386 DISTRIBUTION_ACCOUNT_ID,
1387 DST_SEGMENT1,
1389 DST_SEGMENT3,
1390 DST_SEGMENT4,
1391 DST_SEGMENT5,
1392 DST_SEGMENT6,
1393 DST_SEGMENT7,
1394 DST_SEGMENT8,
1395 DST_SEGMENT9,
1396 DST_SEGMENT10,
1397 DST_SEGMENT11,
1398 DST_SEGMENT12,
1399 DST_SEGMENT13,
1400 DST_SEGMENT14,
1401 DST_SEGMENT15,
1402 DST_SEGMENT16,
1403 DST_SEGMENT17,
1404 DST_SEGMENT18,
1405 DST_SEGMENT19,
1406 DST_SEGMENT20,
1407 DST_SEGMENT21,
1408 DST_SEGMENT22,
1409 DST_SEGMENT23,
1410 DST_SEGMENT24,
1411 DST_SEGMENT25,
1412 DST_SEGMENT26,
1413 DST_SEGMENT27,
1414 DST_SEGMENT28,
1415 DST_SEGMENT29,
1416 DST_SEGMENT30,
1417 REQUISITION_LINE_ID,
1418 CURRENCY_CODE,
1419 CURRENCY_CONVERSION_DATE,
1420 CURRENCY_CONVERSION_TYPE,
1421 CURRENCY_CONVERSION_RATE,
1422 USSGL_TRANSACTION_CODE,
1423 WIP_ENTITY_TYPE,
1424 SCHEDULE_ID,
1425 EMPLOYEE_CODE,
1426 DEPARTMENT_ID,
1427 SCHEDULE_UPDATE_CODE,
1428 SETUP_TEARDOWN_CODE,
1429 PRIMARY_SWITCH,
1430 MRP_CODE,
1431 OPERATION_SEQ_NUM,
1432 REPETITIVE_LINE_ID,
1433 PICKING_LINE_ID,
1434 TRX_SOURCE_LINE_ID,
1435 TRX_SOURCE_DELIVERY_ID,
1436 DEMAND_ID,
1437 CUSTOMER_SHIP_ID,
1438 LINE_ITEM_NUM,
1439 RECEIVING_DOCUMENT,
1440 RCV_TRANSACTION_ID,
1441 SHIP_TO_LOCATION_ID,
1442 ENCUMBRANCE_ACCOUNT,
1443 ENCUMBRANCE_AMOUNT,
1444 VENDOR_LOT_NUMBER,
1445 TRANSFER_SUBINVENTORY,
1446 TRANSFER_ORGANIZATION,
1447 TRANSFER_LOCATOR,
1448 XFER_LOC_SEGMENT1,
1449 XFER_LOC_SEGMENT2,
1450 XFER_LOC_SEGMENT3,
1451 XFER_LOC_SEGMENT4,
1452 XFER_LOC_SEGMENT5,
1453 TRANSACTION_HEADER_ID,
1454 SOURCE_CODE,
1455 SOURCE_LINE_ID,
1456 SOURCE_HEADER_ID,
1457 PROCESS_FLAG,
1458 VALIDATION_REQUIRED,
1459 TRANSACTION_MODE,
1460 LOCK_FLAG,
1461 REQUEST_ID,
1462 INVENTORY_ITEM_ID,
1463 ITEM_SEGMENT1,
1464 ITEM_SEGMENT2,
1465 ITEM_SEGMENT3,
1466 ITEM_SEGMENT4,
1467 ITEM_SEGMENT5,
1468 ITEM_SEGMENT6,
1469 ITEM_SEGMENT7,
1470 ITEM_SEGMENT8,
1471 ITEM_SEGMENT9,
1472 ITEM_SEGMENT10,
1473 ITEM_SEGMENT11,
1474 ITEM_SEGMENT12,
1475 ITEM_SEGMENT13,
1476 ITEM_SEGMENT14,
1477 ITEM_SEGMENT15,
1478 ITEM_SEGMENT16,
1479 ITEM_SEGMENT17,
1480 ITEM_SEGMENT18,
1481 ITEM_SEGMENT19,
1482 ITEM_SEGMENT20,
1483 REVISION,
1484 ORGANIZATION_ID,
1485 TRANSACTION_QUANTITY,
1486 PRIMARY_QUANTITY,
1487 TRANSACTION_UOM,
1488 TRANSACTION_DATE,
1489 ACCT_PERIOD_ID,
1490 SUBINVENTORY_CODE,
1491 LOCATOR_ID,
1492 LOC_SEGMENT1,
1493 LOC_SEGMENT2,
1494 LOC_SEGMENT3,
1495 LOC_SEGMENT4,
1496 LOC_SEGMENT5,
1497 LOC_SEGMENT6,
1498 LOC_SEGMENT7,
1499 LOC_SEGMENT8,
1500 LOC_SEGMENT9,
1501 LOC_SEGMENT10,
1502 LOC_SEGMENT11
1503 from MTL_TRANSACTIONS_INTERFACE
1504 where TRANSACTION_INTERFACE_ID = X_TRANSACTION_INTERFACE_ID
1505 for update of TRANSACTION_INTERFACE_ID nowait;
1506 recinfo c%rowtype;
1507
1508
1509 begin
1510 open c;
1511 fetch c into recinfo;
1512 if (c%notfound) then
1513 close c;
1514 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1515 app_exception.raise_exception;
1516 end if;
1517 close c;
1518 if ( ((recinfo.PLANNING_ORGANIZATION_ID = X_PLANNING_ORGANIZATION_ID)
1519 OR ((recinfo.PLANNING_ORGANIZATION_ID is null) AND (X_PLANNING_ORGANIZATION_ID is null)))
1520 AND ((recinfo.PLANNING_TP_TYPE = X_PLANNING_TP_TYPE)
1521 OR ((recinfo.PLANNING_TP_TYPE is null) AND (X_PLANNING_TP_TYPE is null)))
1522 AND ((recinfo.XFR_PLANNING_ORGANIZATION_ID = X_XFR_PLANNING_ORGANIZATION_ID)
1523 OR ((recinfo.XFR_PLANNING_ORGANIZATION_ID is null) AND (X_XFR_PLANNING_ORGANIZATION_ID is null)))
1524 AND ((recinfo.TRANSFER_PLANNING_TP_TYPE = X_TRANSFER_PLANNING_TP_TYPE)
1525 OR ((recinfo.TRANSFER_PLANNING_TP_TYPE is null) AND (X_TRANSFER_PLANNING_TP_TYPE is null)))
1526 AND ((recinfo.SECONDARY_UOM_CODE = X_SECONDARY_UOM_CODE)
1527 OR ((recinfo.SECONDARY_UOM_CODE is null) AND (X_SECONDARY_UOM_CODE is null)))
1528 AND ((recinfo.SECONDARY_TRANSACTION_QUANTITY = X_SECONDARY_TRANSACTION_QUANTI)
1529 OR ((recinfo.SECONDARY_TRANSACTION_QUANTITY is null) AND (X_SECONDARY_TRANSACTION_QUANTI is null)))
1530 --AND ((recinfo.TRANSACTION_GROUP_ID = X_TRANSACTION_GROUP_ID)
1531 -- OR ((recinfo.TRANSACTION_GROUP_ID is null) AND (X_TRANSACTION_GROUP_ID is null)))
1532 --AND ((recinfo.TRANSACTION_GROUP_SEQ = X_TRANSACTION_GROUP_SEQ)
1533 -- OR ((recinfo.TRANSACTION_GROUP_SEQ is null) AND (X_TRANSACTION_GROUP_SEQ is null)))
1534 AND ((recinfo.REPRESENTATIVE_LOT_NUMBER = X_REPRESENTATIVE_LOT_NUMBER)
1535 OR ((recinfo.REPRESENTATIVE_LOT_NUMBER is null) AND (X_REPRESENTATIVE_LOT_NUMBER is null)))
1536 AND ((recinfo.TRANSACTION_BATCH_ID = X_TRANSACTION_BATCH_ID)
1537 OR ((recinfo.TRANSACTION_BATCH_ID is null) AND (X_TRANSACTION_BATCH_ID is null)))
1538 AND ((recinfo.TRANSACTION_BATCH_SEQ = X_TRANSACTION_BATCH_SEQ)
1539 OR ((recinfo.TRANSACTION_BATCH_SEQ is null) AND (X_TRANSACTION_BATCH_SEQ is null)))
1543 OR ((recinfo.REBUILD_SERIAL_NUMBER is null) AND (X_REBUILD_SERIAL_NUMBER is null)))
1540 AND ((recinfo.REBUILD_ITEM_ID = X_REBUILD_ITEM_ID)
1541 OR ((recinfo.REBUILD_ITEM_ID is null) AND (X_REBUILD_ITEM_ID is null)))
1542 AND ((recinfo.REBUILD_SERIAL_NUMBER = X_REBUILD_SERIAL_NUMBER)
1544 AND ((recinfo.REBUILD_ACTIVITY_ID = X_REBUILD_ACTIVITY_ID)
1545 OR ((recinfo.REBUILD_ACTIVITY_ID is null) AND (X_REBUILD_ACTIVITY_ID is null)))
1546 AND ((recinfo.REBUILD_JOB_NAME = X_REBUILD_JOB_NAME)
1547 OR ((recinfo.REBUILD_JOB_NAME is null) AND (X_REBUILD_JOB_NAME is null)))
1548 AND ((recinfo.MOVE_TRANSACTION_ID = X_MOVE_TRANSACTION_ID)
1549 OR ((recinfo.MOVE_TRANSACTION_ID is null) AND (X_MOVE_TRANSACTION_ID is null)))
1550 AND ((recinfo.COMPLETION_TRANSACTION_ID = X_COMPLETION_TRANSACTION_ID)
1551 OR ((recinfo.COMPLETION_TRANSACTION_ID is null) AND (X_COMPLETION_TRANSACTION_ID is null)))
1552 AND ((recinfo.WIP_SUPPLY_TYPE = X_WIP_SUPPLY_TYPE)
1553 OR ((recinfo.WIP_SUPPLY_TYPE is null) AND (X_WIP_SUPPLY_TYPE is null)))
1554 AND ((recinfo.XFER_LOC_SEGMENT6 = X_XFER_LOC_SEGMENT6)
1555 OR ((recinfo.XFER_LOC_SEGMENT6 is null) AND (X_XFER_LOC_SEGMENT6 is null)))
1556 AND ((recinfo.XFER_LOC_SEGMENT7 = X_XFER_LOC_SEGMENT7)
1557 OR ((recinfo.XFER_LOC_SEGMENT7 is null) AND (X_XFER_LOC_SEGMENT7 is null)))
1558 AND ((recinfo.XFER_LOC_SEGMENT8 = X_XFER_LOC_SEGMENT8)
1559 OR ((recinfo.XFER_LOC_SEGMENT8 is null) AND (X_XFER_LOC_SEGMENT8 is null)))
1560 AND ((recinfo.XFER_LOC_SEGMENT9 = X_XFER_LOC_SEGMENT9)
1561 OR ((recinfo.XFER_LOC_SEGMENT9 is null) AND (X_XFER_LOC_SEGMENT9 is null)))
1562 AND ((recinfo.XFER_LOC_SEGMENT10 = X_XFER_LOC_SEGMENT10)
1563 OR ((recinfo.XFER_LOC_SEGMENT10 is null) AND (X_XFER_LOC_SEGMENT10 is null)))
1564 AND ((recinfo.XFER_LOC_SEGMENT11 = X_XFER_LOC_SEGMENT11)
1565 OR ((recinfo.XFER_LOC_SEGMENT11 is null) AND (X_XFER_LOC_SEGMENT11 is null)))
1566 AND ((recinfo.XFER_LOC_SEGMENT12 = X_XFER_LOC_SEGMENT12)
1567 OR ((recinfo.XFER_LOC_SEGMENT12 is null) AND (X_XFER_LOC_SEGMENT12 is null)))
1568 AND ((recinfo.XFER_LOC_SEGMENT13 = X_XFER_LOC_SEGMENT13)
1569 OR ((recinfo.XFER_LOC_SEGMENT13 is null) AND (X_XFER_LOC_SEGMENT13 is null)))
1570 AND ((recinfo.XFER_LOC_SEGMENT14 = X_XFER_LOC_SEGMENT14)
1571 OR ((recinfo.XFER_LOC_SEGMENT14 is null) AND (X_XFER_LOC_SEGMENT14 is null)))
1572 AND ((recinfo.XFER_LOC_SEGMENT15 = X_XFER_LOC_SEGMENT15)
1573 OR ((recinfo.XFER_LOC_SEGMENT15 is null) AND (X_XFER_LOC_SEGMENT15 is null)))
1574 AND ((recinfo.XFER_LOC_SEGMENT16 = X_XFER_LOC_SEGMENT16)
1575 OR ((recinfo.XFER_LOC_SEGMENT16 is null) AND (X_XFER_LOC_SEGMENT16 is null)))
1576 AND ((recinfo.XFER_LOC_SEGMENT17 = X_XFER_LOC_SEGMENT17)
1577 OR ((recinfo.XFER_LOC_SEGMENT17 is null) AND (X_XFER_LOC_SEGMENT17 is null)))
1578 AND ((recinfo.XFER_LOC_SEGMENT18 = X_XFER_LOC_SEGMENT18)
1579 OR ((recinfo.XFER_LOC_SEGMENT18 is null) AND (X_XFER_LOC_SEGMENT18 is null)))
1580 AND ((recinfo.XFER_LOC_SEGMENT19 = X_XFER_LOC_SEGMENT19)
1581 OR ((recinfo.XFER_LOC_SEGMENT19 is null) AND (X_XFER_LOC_SEGMENT19 is null)))
1582 AND ((recinfo.XFER_LOC_SEGMENT20 = X_XFER_LOC_SEGMENT20)
1583 OR ((recinfo.XFER_LOC_SEGMENT20 is null) AND (X_XFER_LOC_SEGMENT20 is null)))
1584 AND ((recinfo.SHIPMENT_NUMBER = X_SHIPMENT_NUMBER)
1585 OR ((recinfo.SHIPMENT_NUMBER is null) AND (X_SHIPMENT_NUMBER is null)))
1586 AND ((recinfo.TRANSPORTATION_COST = X_TRANSPORTATION_COST)
1587 OR ((recinfo.TRANSPORTATION_COST is null) AND (X_TRANSPORTATION_COST is null)))
1588 AND ((recinfo.TRANSPORTATION_ACCOUNT = X_TRANSPORTATION_ACCOUNT)
1589 OR ((recinfo.TRANSPORTATION_ACCOUNT is null) AND (X_TRANSPORTATION_ACCOUNT is null)))
1590 AND ((recinfo.TRANSFER_COST = X_TRANSFER_COST)
1591 OR ((recinfo.TRANSFER_COST is null) AND (X_TRANSFER_COST is null)))
1592 AND ((recinfo.FREIGHT_CODE = X_FREIGHT_CODE)
1593 OR ((recinfo.FREIGHT_CODE is null) AND (X_FREIGHT_CODE is null)))
1594 AND ((recinfo.CONTAINERS = X_CONTAINERS)
1595 OR ((recinfo.CONTAINERS is null) AND (X_CONTAINERS is null)))
1596 AND ((recinfo.WAYBILL_AIRBILL = X_WAYBILL_AIRBILL)
1597 OR ((recinfo.WAYBILL_AIRBILL is null) AND (X_WAYBILL_AIRBILL is null)))
1598 AND ((recinfo.EXPECTED_ARRIVAL_DATE = X_EXPECTED_ARRIVAL_DATE)
1599 OR ((recinfo.EXPECTED_ARRIVAL_DATE is null) AND (X_EXPECTED_ARRIVAL_DATE is null)))
1600 AND ((recinfo.NEW_AVERAGE_COST = X_NEW_AVERAGE_COST)
1601 OR ((recinfo.NEW_AVERAGE_COST is null) AND (X_NEW_AVERAGE_COST is null)))
1602 AND ((recinfo.VALUE_CHANGE = X_VALUE_CHANGE)
1603 OR ((recinfo.VALUE_CHANGE is null) AND (X_VALUE_CHANGE is null)))
1604 AND ((recinfo.PERCENTAGE_CHANGE = X_PERCENTAGE_CHANGE)
1605 OR ((recinfo.PERCENTAGE_CHANGE is null) AND (X_PERCENTAGE_CHANGE is null)))
1606 AND ((recinfo.DEMAND_SOURCE_HEADER_ID = X_DEMAND_SOURCE_HEADER_ID)
1607 OR ((recinfo.DEMAND_SOURCE_HEADER_ID is null) AND (X_DEMAND_SOURCE_HEADER_ID is null)))
1608 AND ((recinfo.DEMAND_SOURCE_LINE = X_DEMAND_SOURCE_LINE)
1609 OR ((recinfo.DEMAND_SOURCE_LINE is null) AND (X_DEMAND_SOURCE_LINE is null)))
1610 AND ((recinfo.DEMAND_SOURCE_DELIVERY = X_DEMAND_SOURCE_DELIVERY)
1611 OR ((recinfo.DEMAND_SOURCE_DELIVERY is null) AND (X_DEMAND_SOURCE_DELIVERY is null)))
1612 AND ((recinfo.NEGATIVE_REQ_FLAG = X_NEGATIVE_REQ_FLAG)
1613 OR ((recinfo.NEGATIVE_REQ_FLAG is null) AND (X_NEGATIVE_REQ_FLAG is null)))
1614 AND ((recinfo.ERROR_EXPLANATION = X_ERROR_EXPLANATION)
1615 OR ((recinfo.ERROR_EXPLANATION is null) AND (X_ERROR_EXPLANATION is null)))
1616 AND ((recinfo.SHIPPABLE_FLAG = X_SHIPPABLE_FLAG)
1617 OR ((recinfo.SHIPPABLE_FLAG is null) AND (X_SHIPPABLE_FLAG is null)))
1618 AND ((recinfo.REQUIRED_FLAG = X_REQUIRED_FLAG)
1619 OR ((recinfo.REQUIRED_FLAG is null) AND (X_REQUIRED_FLAG is null)))
1620 AND ((recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
1624 AND ((recinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
1621 OR ((recinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))
1622 AND ((recinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
1623 OR ((recinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null)))
1625 OR ((recinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null)))
1626 AND ((recinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
1627 OR ((recinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null)))
1628 AND ((recinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
1629 OR ((recinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null)))
1630 AND ((recinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
1631 OR ((recinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null)))
1632 AND ((recinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
1633 OR ((recinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null)))
1634 AND ((recinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
1635 OR ((recinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null)))
1636 AND ((recinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
1637 OR ((recinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null)))
1638 AND ((recinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
1639 OR ((recinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null)))
1640 AND ((recinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
1641 OR ((recinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null)))
1642 AND ((recinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
1643 OR ((recinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null)))
1644 AND ((recinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
1645 OR ((recinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null)))
1646 AND ((recinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
1647 OR ((recinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null)))
1648 AND ((recinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
1649 OR ((recinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null)))
1650 AND ((recinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
1651 OR ((recinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null)))
1652 AND ((recinfo.REQUISITION_DISTRIBUTION_ID = X_REQUISITION_DISTRIBUTION_ID)
1653 OR ((recinfo.REQUISITION_DISTRIBUTION_ID is null) AND (X_REQUISITION_DISTRIBUTION_ID is null)))
1654 AND ((recinfo.MOVEMENT_ID = X_MOVEMENT_ID)
1655 OR ((recinfo.MOVEMENT_ID is null) AND (X_MOVEMENT_ID is null)))
1656 AND ((recinfo.RESERVATION_QUANTITY = X_RESERVATION_QUANTITY)
1657 OR ((recinfo.RESERVATION_QUANTITY is null) AND (X_RESERVATION_QUANTITY is null)))
1658 AND ((recinfo.SHIPPED_QUANTITY = X_SHIPPED_QUANTITY)
1659 OR ((recinfo.SHIPPED_QUANTITY is null) AND (X_SHIPPED_QUANTITY is null)))
1660 AND ((recinfo.INVENTORY_ITEM = X_INVENTORY_ITEM)
1661 OR ((recinfo.INVENTORY_ITEM is null) AND (X_INVENTORY_ITEM is null)))
1662 AND ((recinfo.LOCATOR_NAME = X_LOCATOR_NAME)
1663 OR ((recinfo.LOCATOR_NAME is null) AND (X_LOCATOR_NAME is null)))
1664 AND ((recinfo.TASK_ID = X_TASK_ID)
1665 OR ((recinfo.TASK_ID is null) AND (X_TASK_ID is null)))
1666 AND ((recinfo.TO_TASK_ID = X_TO_TASK_ID)
1667 OR ((recinfo.TO_TASK_ID is null) AND (X_TO_TASK_ID is null)))
1668 AND ((recinfo.SOURCE_TASK_ID = X_SOURCE_TASK_ID)
1669 OR ((recinfo.SOURCE_TASK_ID is null) AND (X_SOURCE_TASK_ID is null)))
1670 AND ((recinfo.PROJECT_ID = X_PROJECT_ID)
1671 OR ((recinfo.PROJECT_ID is null) AND (X_PROJECT_ID is null)))
1672 AND ((recinfo.TO_PROJECT_ID = X_TO_PROJECT_ID)
1673 OR ((recinfo.TO_PROJECT_ID is null) AND (X_TO_PROJECT_ID is null)))
1674 AND ((recinfo.SOURCE_PROJECT_ID = X_SOURCE_PROJECT_ID)
1675 OR ((recinfo.SOURCE_PROJECT_ID is null) AND (X_SOURCE_PROJECT_ID is null)))
1676 AND ((recinfo.PA_EXPENDITURE_ORG_ID = X_PA_EXPENDITURE_ORG_ID)
1677 OR ((recinfo.PA_EXPENDITURE_ORG_ID is null) AND (X_PA_EXPENDITURE_ORG_ID is null)))
1678 AND ((recinfo.EXPENDITURE_TYPE = X_EXPENDITURE_TYPE)
1679 OR ((recinfo.EXPENDITURE_TYPE is null) AND (X_EXPENDITURE_TYPE is null)))
1680 AND ((recinfo.FINAL_COMPLETION_FLAG = X_FINAL_COMPLETION_FLAG)
1681 OR ((recinfo.FINAL_COMPLETION_FLAG is null) AND (X_FINAL_COMPLETION_FLAG is null)))
1682 AND ((recinfo.TRANSFER_PERCENTAGE = X_TRANSFER_PERCENTAGE)
1683 OR ((recinfo.TRANSFER_PERCENTAGE is null) AND (X_TRANSFER_PERCENTAGE is null)))
1684 AND ((recinfo.TRANSACTION_SEQUENCE_ID = X_TRANSACTION_SEQUENCE_ID)
1685 OR ((recinfo.TRANSACTION_SEQUENCE_ID is null) AND (X_TRANSACTION_SEQUENCE_ID is null)))
1686 AND ((recinfo.MATERIAL_ACCOUNT = X_MATERIAL_ACCOUNT)
1687 OR ((recinfo.MATERIAL_ACCOUNT is null) AND (X_MATERIAL_ACCOUNT is null)))
1688 AND ((recinfo.MATERIAL_OVERHEAD_ACCOUNT = X_MATERIAL_OVERHEAD_ACCOUNT)
1689 OR ((recinfo.MATERIAL_OVERHEAD_ACCOUNT is null) AND (X_MATERIAL_OVERHEAD_ACCOUNT is null)))
1690 AND ((recinfo.RESOURCE_ACCOUNT = X_RESOURCE_ACCOUNT)
1691 OR ((recinfo.RESOURCE_ACCOUNT is null) AND (X_RESOURCE_ACCOUNT is null)))
1692 AND ((recinfo.OUTSIDE_PROCESSING_ACCOUNT = X_OUTSIDE_PROCESSING_ACCOUNT)
1693 OR ((recinfo.OUTSIDE_PROCESSING_ACCOUNT is null) AND (X_OUTSIDE_PROCESSING_ACCOUNT is null)))
1694 AND ((recinfo.OVERHEAD_ACCOUNT = X_OVERHEAD_ACCOUNT)
1695 OR ((recinfo.OVERHEAD_ACCOUNT is null) AND (X_OVERHEAD_ACCOUNT is null)))
1696 AND ((recinfo.BOM_REVISION = X_BOM_REVISION)
1697 OR ((recinfo.BOM_REVISION is null) AND (X_BOM_REVISION is null)))
1698 AND ((recinfo.ROUTING_REVISION = X_ROUTING_REVISION)
1699 OR ((recinfo.ROUTING_REVISION is null) AND (X_ROUTING_REVISION is null)))
1700 AND ((recinfo.BOM_REVISION_DATE = X_BOM_REVISION_DATE)
1701 OR ((recinfo.BOM_REVISION_DATE is null) AND (X_BOM_REVISION_DATE is null)))
1702 AND ((recinfo.ROUTING_REVISION_DATE = X_ROUTING_REVISION_DATE)
1703 OR ((recinfo.ROUTING_REVISION_DATE is null) AND (X_ROUTING_REVISION_DATE is null)))
1704 AND ((recinfo.ALTERNATE_BOM_DESIGNATOR = X_ALTERNATE_BOM_DESIGNATOR)
1705 OR ((recinfo.ALTERNATE_BOM_DESIGNATOR is null) AND (X_ALTERNATE_BOM_DESIGNATOR is null)))
1706 AND ((recinfo.ALTERNATE_ROUTING_DESIGNATOR = X_ALTERNATE_ROUTING_DESIGNATOR)
1710 AND ((recinfo.DEMAND_CLASS = X_DEMAND_CLASS)
1707 OR ((recinfo.ALTERNATE_ROUTING_DESIGNATOR is null) AND (X_ALTERNATE_ROUTING_DESIGNATOR is null)))
1708 AND ((recinfo.ACCOUNTING_CLASS = X_ACCOUNTING_CLASS)
1709 OR ((recinfo.ACCOUNTING_CLASS is null) AND (X_ACCOUNTING_CLASS is null)))
1711 OR ((recinfo.DEMAND_CLASS is null) AND (X_DEMAND_CLASS is null)))
1712 AND ((recinfo.PARENT_ID = X_PARENT_ID)
1713 OR ((recinfo.PARENT_ID is null) AND (X_PARENT_ID is null)))
1714 AND ((recinfo.SUBSTITUTION_TYPE_ID = X_SUBSTITUTION_TYPE_ID)
1715 OR ((recinfo.SUBSTITUTION_TYPE_ID is null) AND (X_SUBSTITUTION_TYPE_ID is null)))
1716 AND ((recinfo.SUBSTITUTION_ITEM_ID = X_SUBSTITUTION_ITEM_ID)
1717 OR ((recinfo.SUBSTITUTION_ITEM_ID is null) AND (X_SUBSTITUTION_ITEM_ID is null)))
1718 AND ((recinfo.SCHEDULE_GROUP = X_SCHEDULE_GROUP)
1719 OR ((recinfo.SCHEDULE_GROUP is null) AND (X_SCHEDULE_GROUP is null)))
1720 AND ((recinfo.BUILD_SEQUENCE = X_BUILD_SEQUENCE)
1721 OR ((recinfo.BUILD_SEQUENCE is null) AND (X_BUILD_SEQUENCE is null)))
1722 AND ((recinfo.SCHEDULE_NUMBER = X_SCHEDULE_NUMBER)
1723 OR ((recinfo.SCHEDULE_NUMBER is null) AND (X_SCHEDULE_NUMBER is null)))
1724 AND ((recinfo.SCHEDULED_FLAG = X_SCHEDULED_FLAG)
1725 OR ((recinfo.SCHEDULED_FLAG is null) AND (X_SCHEDULED_FLAG is null)))
1726 AND ((recinfo.FLOW_SCHEDULE = X_FLOW_SCHEDULE)
1727 OR ((recinfo.FLOW_SCHEDULE is null) AND (X_FLOW_SCHEDULE is null)))
1728 AND ((recinfo.COST_GROUP_ID = X_COST_GROUP_ID)
1729 OR ((recinfo.COST_GROUP_ID is null) AND (X_COST_GROUP_ID is null)))
1730 AND ((recinfo.KANBAN_CARD_ID = X_KANBAN_CARD_ID)
1731 OR ((recinfo.KANBAN_CARD_ID is null) AND (X_KANBAN_CARD_ID is null)))
1732 AND ((recinfo.QA_COLLECTION_ID = X_QA_COLLECTION_ID)
1733 OR ((recinfo.QA_COLLECTION_ID is null) AND (X_QA_COLLECTION_ID is null)))
1734 AND ((recinfo.OVERCOMPLETION_TRANSACTION_QTY = X_OVERCOMPLETION_TRANSACTION_Q)
1735 OR ((recinfo.OVERCOMPLETION_TRANSACTION_QTY is null) AND (X_OVERCOMPLETION_TRANSACTION_Q is null)))
1736 AND ((recinfo.OVERCOMPLETION_PRIMARY_QTY = X_OVERCOMPLETION_PRIMARY_QTY)
1737 OR ((recinfo.OVERCOMPLETION_PRIMARY_QTY is null) AND (X_OVERCOMPLETION_PRIMARY_QTY is null)))
1738 AND ((recinfo.OVERCOMPLETION_TRANSACTION_ID = X_OVERCOMPLETION_TRANSACTION_I)
1739 OR ((recinfo.OVERCOMPLETION_TRANSACTION_ID is null) AND (X_OVERCOMPLETION_TRANSACTION_I is null)))
1740 AND ((recinfo.END_ITEM_UNIT_NUMBER = X_END_ITEM_UNIT_NUMBER)
1741 OR ((recinfo.END_ITEM_UNIT_NUMBER is null) AND (X_END_ITEM_UNIT_NUMBER is null)))
1742 AND ((recinfo.SCHEDULED_PAYBACK_DATE = X_SCHEDULED_PAYBACK_DATE)
1743 OR ((recinfo.SCHEDULED_PAYBACK_DATE is null) AND (X_SCHEDULED_PAYBACK_DATE is null)))
1744 AND ((recinfo.ORG_COST_GROUP_ID = X_ORG_COST_GROUP_ID)
1745 OR ((recinfo.ORG_COST_GROUP_ID is null) AND (X_ORG_COST_GROUP_ID is null)))
1746 AND ((recinfo.COST_TYPE_ID = X_COST_TYPE_ID)
1747 OR ((recinfo.COST_TYPE_ID is null) AND (X_COST_TYPE_ID is null)))
1748 AND ((recinfo.SOURCE_LOT_NUMBER = X_SOURCE_LOT_NUMBER)
1749 OR ((recinfo.SOURCE_LOT_NUMBER is null) AND (X_SOURCE_LOT_NUMBER is null)))
1750 AND ((recinfo.TRANSFER_COST_GROUP_ID = X_TRANSFER_COST_GROUP_ID)
1751 OR ((recinfo.TRANSFER_COST_GROUP_ID is null) AND (X_TRANSFER_COST_GROUP_ID is null)))
1752 AND ((recinfo.LPN_ID = X_LPN_ID)
1753 OR ((recinfo.LPN_ID is null) AND (X_LPN_ID is null)))
1754 AND ((recinfo.TRANSFER_LPN_ID = X_TRANSFER_LPN_ID)
1755 OR ((recinfo.TRANSFER_LPN_ID is null) AND (X_TRANSFER_LPN_ID is null)))
1756 AND ((recinfo.CONTENT_LPN_ID = X_CONTENT_LPN_ID)
1757 OR ((recinfo.CONTENT_LPN_ID is null) AND (X_CONTENT_LPN_ID is null)))
1758 AND ((recinfo.XML_DOCUMENT_ID = X_XML_DOCUMENT_ID)
1759 OR ((recinfo.XML_DOCUMENT_ID is null) AND (X_XML_DOCUMENT_ID is null)))
1760 AND ((recinfo.ORGANIZATION_TYPE = X_ORGANIZATION_TYPE)
1761 OR ((recinfo.ORGANIZATION_TYPE is null) AND (X_ORGANIZATION_TYPE is null)))
1762 AND ((recinfo.TRANSFER_ORGANIZATION_TYPE = X_TRANSFER_ORGANIZATION_TYPE)
1763 OR ((recinfo.TRANSFER_ORGANIZATION_TYPE is null) AND (X_TRANSFER_ORGANIZATION_TYPE is null)))
1764 AND ((recinfo.OWNING_ORGANIZATION_ID = X_OWNING_ORGANIZATION_ID)
1765 OR ((recinfo.OWNING_ORGANIZATION_ID is null) AND (X_OWNING_ORGANIZATION_ID is null)))
1766 AND ((recinfo.OWNING_TP_TYPE = X_OWNING_TP_TYPE)
1767 OR ((recinfo.OWNING_TP_TYPE is null) AND (X_OWNING_TP_TYPE is null)))
1768 AND ((recinfo.XFR_OWNING_ORGANIZATION_ID = X_XFR_OWNING_ORGANIZATION_ID)
1769 OR ((recinfo.XFR_OWNING_ORGANIZATION_ID is null) AND (X_XFR_OWNING_ORGANIZATION_ID is null)))
1770 AND ((recinfo.TRANSFER_OWNING_TP_TYPE = X_TRANSFER_OWNING_TP_TYPE)
1771 OR ((recinfo.TRANSFER_OWNING_TP_TYPE is null) AND (X_TRANSFER_OWNING_TP_TYPE is null)))
1772 AND ((recinfo.LOC_SEGMENT12 = X_LOC_SEGMENT12)
1773 OR ((recinfo.LOC_SEGMENT12 is null) AND (X_LOC_SEGMENT12 is null)))
1774 AND ((recinfo.LOC_SEGMENT13 = X_LOC_SEGMENT13)
1775 OR ((recinfo.LOC_SEGMENT13 is null) AND (X_LOC_SEGMENT13 is null)))
1776 AND ((recinfo.LOC_SEGMENT14 = X_LOC_SEGMENT14)
1777 OR ((recinfo.LOC_SEGMENT14 is null) AND (X_LOC_SEGMENT14 is null)))
1778 AND ((recinfo.LOC_SEGMENT15 = X_LOC_SEGMENT15)
1779 OR ((recinfo.LOC_SEGMENT15 is null) AND (X_LOC_SEGMENT15 is null)))
1780 AND ((recinfo.LOC_SEGMENT16 = X_LOC_SEGMENT16)
1781 OR ((recinfo.LOC_SEGMENT16 is null) AND (X_LOC_SEGMENT16 is null)))
1782 AND ((recinfo.LOC_SEGMENT17 = X_LOC_SEGMENT17)
1783 OR ((recinfo.LOC_SEGMENT17 is null) AND (X_LOC_SEGMENT17 is null)))
1784 AND ((recinfo.LOC_SEGMENT18 = X_LOC_SEGMENT18)
1785 OR ((recinfo.LOC_SEGMENT18 is null) AND (X_LOC_SEGMENT18 is null)))
1786 AND ((recinfo.LOC_SEGMENT19 = X_LOC_SEGMENT19)
1787 OR ((recinfo.LOC_SEGMENT19 is null) AND (X_LOC_SEGMENT19 is null)))
1788 AND ((recinfo.LOC_SEGMENT20 = X_LOC_SEGMENT20)
1792 AND ((recinfo.DSP_SEGMENT1 = X_DSP_SEGMENT1)
1789 OR ((recinfo.LOC_SEGMENT20 is null) AND (X_LOC_SEGMENT20 is null)))
1790 AND ((recinfo.TRANSACTION_SOURCE_ID = X_TRANSACTION_SOURCE_ID)
1791 OR ((recinfo.TRANSACTION_SOURCE_ID is null) AND (X_TRANSACTION_SOURCE_ID is null)))
1793 OR ((recinfo.DSP_SEGMENT1 is null) AND (X_DSP_SEGMENT1 is null)))
1794 AND ((recinfo.DSP_SEGMENT2 = X_DSP_SEGMENT2)
1795 OR ((recinfo.DSP_SEGMENT2 is null) AND (X_DSP_SEGMENT2 is null)))
1796 AND ((recinfo.DSP_SEGMENT3 = X_DSP_SEGMENT3)
1797 OR ((recinfo.DSP_SEGMENT3 is null) AND (X_DSP_SEGMENT3 is null)))
1798 AND ((recinfo.DSP_SEGMENT4 = X_DSP_SEGMENT4)
1799 OR ((recinfo.DSP_SEGMENT4 is null) AND (X_DSP_SEGMENT4 is null)))
1800 AND ((recinfo.DSP_SEGMENT5 = X_DSP_SEGMENT5)
1801 OR ((recinfo.DSP_SEGMENT5 is null) AND (X_DSP_SEGMENT5 is null)))
1802 AND ((recinfo.DSP_SEGMENT6 = X_DSP_SEGMENT6)
1803 OR ((recinfo.DSP_SEGMENT6 is null) AND (X_DSP_SEGMENT6 is null)))
1804 AND ((recinfo.DSP_SEGMENT7 = X_DSP_SEGMENT7)
1805 OR ((recinfo.DSP_SEGMENT7 is null) AND (X_DSP_SEGMENT7 is null)))
1806 AND ((recinfo.DSP_SEGMENT8 = X_DSP_SEGMENT8)
1807 OR ((recinfo.DSP_SEGMENT8 is null) AND (X_DSP_SEGMENT8 is null)))
1808 AND ((recinfo.DSP_SEGMENT9 = X_DSP_SEGMENT9)
1809 OR ((recinfo.DSP_SEGMENT9 is null) AND (X_DSP_SEGMENT9 is null)))
1810 AND ((recinfo.DSP_SEGMENT10 = X_DSP_SEGMENT10)
1811 OR ((recinfo.DSP_SEGMENT10 is null) AND (X_DSP_SEGMENT10 is null)))
1812 AND ((recinfo.DSP_SEGMENT11 = X_DSP_SEGMENT11)
1813 OR ((recinfo.DSP_SEGMENT11 is null) AND (X_DSP_SEGMENT11 is null)))
1814 AND ((recinfo.DSP_SEGMENT12 = X_DSP_SEGMENT12)
1815 OR ((recinfo.DSP_SEGMENT12 is null) AND (X_DSP_SEGMENT12 is null)))
1816 AND ((recinfo.DSP_SEGMENT13 = X_DSP_SEGMENT13)
1817 OR ((recinfo.DSP_SEGMENT13 is null) AND (X_DSP_SEGMENT13 is null)))
1818 AND ((recinfo.DSP_SEGMENT14 = X_DSP_SEGMENT14)
1819 OR ((recinfo.DSP_SEGMENT14 is null) AND (X_DSP_SEGMENT14 is null)))
1820 AND ((recinfo.DSP_SEGMENT15 = X_DSP_SEGMENT15)
1821 OR ((recinfo.DSP_SEGMENT15 is null) AND (X_DSP_SEGMENT15 is null)))
1822 AND ((recinfo.DSP_SEGMENT16 = X_DSP_SEGMENT16)
1823 OR ((recinfo.DSP_SEGMENT16 is null) AND (X_DSP_SEGMENT16 is null)))
1824 AND ((recinfo.DSP_SEGMENT17 = X_DSP_SEGMENT17)
1825 OR ((recinfo.DSP_SEGMENT17 is null) AND (X_DSP_SEGMENT17 is null)))
1826 AND ((recinfo.DSP_SEGMENT18 = X_DSP_SEGMENT18)
1827 OR ((recinfo.DSP_SEGMENT18 is null) AND (X_DSP_SEGMENT18 is null)))
1828 AND ((recinfo.DSP_SEGMENT19 = X_DSP_SEGMENT19)
1829 OR ((recinfo.DSP_SEGMENT19 is null) AND (X_DSP_SEGMENT19 is null)))
1830 AND ((recinfo.DSP_SEGMENT20 = X_DSP_SEGMENT20)
1831 OR ((recinfo.DSP_SEGMENT20 is null) AND (X_DSP_SEGMENT20 is null)))
1832 AND ((recinfo.DSP_SEGMENT21 = X_DSP_SEGMENT21)
1833 OR ((recinfo.DSP_SEGMENT21 is null) AND (X_DSP_SEGMENT21 is null)))
1834 AND ((recinfo.DSP_SEGMENT22 = X_DSP_SEGMENT22)
1835 OR ((recinfo.DSP_SEGMENT22 is null) AND (X_DSP_SEGMENT22 is null)))
1836 AND ((recinfo.DSP_SEGMENT23 = X_DSP_SEGMENT23)
1837 OR ((recinfo.DSP_SEGMENT23 is null) AND (X_DSP_SEGMENT23 is null)))
1838 AND ((recinfo.DSP_SEGMENT24 = X_DSP_SEGMENT24)
1839 OR ((recinfo.DSP_SEGMENT24 is null) AND (X_DSP_SEGMENT24 is null)))
1840 AND ((recinfo.DSP_SEGMENT25 = X_DSP_SEGMENT25)
1841 OR ((recinfo.DSP_SEGMENT25 is null) AND (X_DSP_SEGMENT25 is null)))
1842 AND ((recinfo.DSP_SEGMENT26 = X_DSP_SEGMENT26)
1843 OR ((recinfo.DSP_SEGMENT26 is null) AND (X_DSP_SEGMENT26 is null)))
1844 AND ((recinfo.DSP_SEGMENT27 = X_DSP_SEGMENT27)
1845 OR ((recinfo.DSP_SEGMENT27 is null) AND (X_DSP_SEGMENT27 is null)))
1846 AND ((recinfo.DSP_SEGMENT28 = X_DSP_SEGMENT28)
1847 OR ((recinfo.DSP_SEGMENT28 is null) AND (X_DSP_SEGMENT28 is null)))
1848 AND ((recinfo.DSP_SEGMENT29 = X_DSP_SEGMENT29)
1849 OR ((recinfo.DSP_SEGMENT29 is null) AND (X_DSP_SEGMENT29 is null)))
1850 AND ((recinfo.DSP_SEGMENT30 = X_DSP_SEGMENT30)
1851 OR ((recinfo.DSP_SEGMENT30 is null) AND (X_DSP_SEGMENT30 is null)))
1852 AND ((recinfo.TRANSACTION_SOURCE_NAME = X_TRANSACTION_SOURCE_NAME)
1853 OR ((recinfo.TRANSACTION_SOURCE_NAME is null) AND (X_TRANSACTION_SOURCE_NAME is null)))
1854 AND ((recinfo.TRANSACTION_SOURCE_TYPE_ID = X_TRANSACTION_SOURCE_TYPE_ID)
1855 OR ((recinfo.TRANSACTION_SOURCE_TYPE_ID is null) AND (X_TRANSACTION_SOURCE_TYPE_ID is null)))
1856 AND ((recinfo.TRANSACTION_ACTION_ID = X_TRANSACTION_ACTION_ID)
1857 OR ((recinfo.TRANSACTION_ACTION_ID is null) AND (X_TRANSACTION_ACTION_ID is null)))
1858 AND (recinfo.TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID)
1859 AND ((recinfo.REASON_ID = X_REASON_ID)
1860 OR ((recinfo.REASON_ID is null) AND (X_REASON_ID is null)))
1861 AND ((recinfo.TRANSACTION_REFERENCE = X_TRANSACTION_REFERENCE)
1862 OR ((recinfo.TRANSACTION_REFERENCE is null) AND (X_TRANSACTION_REFERENCE is null)))
1863 AND ((recinfo.TRANSACTION_COST = X_TRANSACTION_COST)
1864 OR ((recinfo.TRANSACTION_COST is null) AND (X_TRANSACTION_COST is null)))
1865 AND ((recinfo.DISTRIBUTION_ACCOUNT_ID = X_DISTRIBUTION_ACCOUNT_ID)
1866 OR ((recinfo.DISTRIBUTION_ACCOUNT_ID is null) AND (X_DISTRIBUTION_ACCOUNT_ID is null)))
1867 AND ((recinfo.DST_SEGMENT1 = X_DST_SEGMENT1)
1868 OR ((recinfo.DST_SEGMENT1 is null) AND (X_DST_SEGMENT1 is null)))
1869 AND ((recinfo.DST_SEGMENT2 = X_DST_SEGMENT2)
1870 OR ((recinfo.DST_SEGMENT2 is null) AND (X_DST_SEGMENT2 is null)))
1871 AND ((recinfo.DST_SEGMENT3 = X_DST_SEGMENT3)
1872 OR ((recinfo.DST_SEGMENT3 is null) AND (X_DST_SEGMENT3 is null)))
1873 AND ((recinfo.DST_SEGMENT4 = X_DST_SEGMENT4)
1874 OR ((recinfo.DST_SEGMENT4 is null) AND (X_DST_SEGMENT4 is null)))
1875 AND ((recinfo.DST_SEGMENT5 = X_DST_SEGMENT5)
1879 AND ((recinfo.DST_SEGMENT7 = X_DST_SEGMENT7)
1876 OR ((recinfo.DST_SEGMENT5 is null) AND (X_DST_SEGMENT5 is null)))
1877 AND ((recinfo.DST_SEGMENT6 = X_DST_SEGMENT6)
1878 OR ((recinfo.DST_SEGMENT6 is null) AND (X_DST_SEGMENT6 is null)))
1880 OR ((recinfo.DST_SEGMENT7 is null) AND (X_DST_SEGMENT7 is null)))
1881 AND ((recinfo.DST_SEGMENT8 = X_DST_SEGMENT8)
1882 OR ((recinfo.DST_SEGMENT8 is null) AND (X_DST_SEGMENT8 is null)))
1883 AND ((recinfo.DST_SEGMENT9 = X_DST_SEGMENT9)
1884 OR ((recinfo.DST_SEGMENT9 is null) AND (X_DST_SEGMENT9 is null)))
1885 AND ((recinfo.DST_SEGMENT10 = X_DST_SEGMENT10)
1886 OR ((recinfo.DST_SEGMENT10 is null) AND (X_DST_SEGMENT10 is null)))
1887 AND ((recinfo.DST_SEGMENT11 = X_DST_SEGMENT11)
1888 OR ((recinfo.DST_SEGMENT11 is null) AND (X_DST_SEGMENT11 is null)))
1889 AND ((recinfo.DST_SEGMENT12 = X_DST_SEGMENT12)
1890 OR ((recinfo.DST_SEGMENT12 is null) AND (X_DST_SEGMENT12 is null)))
1891 AND ((recinfo.DST_SEGMENT13 = X_DST_SEGMENT13)
1892 OR ((recinfo.DST_SEGMENT13 is null) AND (X_DST_SEGMENT13 is null)))
1893 AND ((recinfo.DST_SEGMENT14 = X_DST_SEGMENT14)
1894 OR ((recinfo.DST_SEGMENT14 is null) AND (X_DST_SEGMENT14 is null)))
1895 AND ((recinfo.DST_SEGMENT15 = X_DST_SEGMENT15)
1896 OR ((recinfo.DST_SEGMENT15 is null) AND (X_DST_SEGMENT15 is null)))
1897 AND ((recinfo.DST_SEGMENT16 = X_DST_SEGMENT16)
1898 OR ((recinfo.DST_SEGMENT16 is null) AND (X_DST_SEGMENT16 is null)))
1899 AND ((recinfo.DST_SEGMENT17 = X_DST_SEGMENT17)
1900 OR ((recinfo.DST_SEGMENT17 is null) AND (X_DST_SEGMENT17 is null)))
1901 AND ((recinfo.DST_SEGMENT18 = X_DST_SEGMENT18)
1902 OR ((recinfo.DST_SEGMENT18 is null) AND (X_DST_SEGMENT18 is null)))
1903 AND ((recinfo.DST_SEGMENT19 = X_DST_SEGMENT19)
1904 OR ((recinfo.DST_SEGMENT19 is null) AND (X_DST_SEGMENT19 is null)))
1905 AND ((recinfo.DST_SEGMENT20 = X_DST_SEGMENT20)
1906 OR ((recinfo.DST_SEGMENT20 is null) AND (X_DST_SEGMENT20 is null)))
1907 AND ((recinfo.DST_SEGMENT21 = X_DST_SEGMENT21)
1908 OR ((recinfo.DST_SEGMENT21 is null) AND (X_DST_SEGMENT21 is null)))
1909 AND ((recinfo.DST_SEGMENT22 = X_DST_SEGMENT22)
1910 OR ((recinfo.DST_SEGMENT22 is null) AND (X_DST_SEGMENT22 is null)))
1911 AND ((recinfo.DST_SEGMENT23 = X_DST_SEGMENT23)
1912 OR ((recinfo.DST_SEGMENT23 is null) AND (X_DST_SEGMENT23 is null)))
1913 AND ((recinfo.DST_SEGMENT24 = X_DST_SEGMENT24)
1914 OR ((recinfo.DST_SEGMENT24 is null) AND (X_DST_SEGMENT24 is null)))
1915 AND ((recinfo.DST_SEGMENT25 = X_DST_SEGMENT25)
1916 OR ((recinfo.DST_SEGMENT25 is null) AND (X_DST_SEGMENT25 is null)))
1917 AND ((recinfo.DST_SEGMENT26 = X_DST_SEGMENT26)
1918 OR ((recinfo.DST_SEGMENT26 is null) AND (X_DST_SEGMENT26 is null)))
1919 AND ((recinfo.DST_SEGMENT27 = X_DST_SEGMENT27)
1920 OR ((recinfo.DST_SEGMENT27 is null) AND (X_DST_SEGMENT27 is null)))
1921 AND ((recinfo.DST_SEGMENT28 = X_DST_SEGMENT28)
1922 OR ((recinfo.DST_SEGMENT28 is null) AND (X_DST_SEGMENT28 is null)))
1923 AND ((recinfo.DST_SEGMENT29 = X_DST_SEGMENT29)
1924 OR ((recinfo.DST_SEGMENT29 is null) AND (X_DST_SEGMENT29 is null)))
1925 AND ((recinfo.DST_SEGMENT30 = X_DST_SEGMENT30)
1926 OR ((recinfo.DST_SEGMENT30 is null) AND (X_DST_SEGMENT30 is null)))
1927 AND ((recinfo.REQUISITION_LINE_ID = X_REQUISITION_LINE_ID)
1928 OR ((recinfo.REQUISITION_LINE_ID is null) AND (X_REQUISITION_LINE_ID is null)))
1929 AND ((recinfo.CURRENCY_CODE = X_CURRENCY_CODE)
1930 OR ((recinfo.CURRENCY_CODE is null) AND (X_CURRENCY_CODE is null)))
1931 AND ((recinfo.CURRENCY_CONVERSION_DATE = X_CURRENCY_CONVERSION_DATE)
1932 OR ((recinfo.CURRENCY_CONVERSION_DATE is null) AND (X_CURRENCY_CONVERSION_DATE is null)))
1933 AND ((recinfo.CURRENCY_CONVERSION_TYPE = X_CURRENCY_CONVERSION_TYPE)
1934 OR ((recinfo.CURRENCY_CONVERSION_TYPE is null) AND (X_CURRENCY_CONVERSION_TYPE is null)))
1935 AND ((recinfo.CURRENCY_CONVERSION_RATE = X_CURRENCY_CONVERSION_RATE)
1936 OR ((recinfo.CURRENCY_CONVERSION_RATE is null) AND (X_CURRENCY_CONVERSION_RATE is null)))
1937 AND ((recinfo.USSGL_TRANSACTION_CODE = X_USSGL_TRANSACTION_CODE)
1938 OR ((recinfo.USSGL_TRANSACTION_CODE is null) AND (X_USSGL_TRANSACTION_CODE is null)))
1939 AND ((recinfo.WIP_ENTITY_TYPE = X_WIP_ENTITY_TYPE)
1940 OR ((recinfo.WIP_ENTITY_TYPE is null) AND (X_WIP_ENTITY_TYPE is null)))
1941 AND ((recinfo.SCHEDULE_ID = X_SCHEDULE_ID)
1942 OR ((recinfo.SCHEDULE_ID is null) AND (X_SCHEDULE_ID is null)))
1943 AND ((recinfo.EMPLOYEE_CODE = X_EMPLOYEE_CODE)
1944 OR ((recinfo.EMPLOYEE_CODE is null) AND (X_EMPLOYEE_CODE is null)))
1945 AND ((recinfo.DEPARTMENT_ID = X_DEPARTMENT_ID)
1946 OR ((recinfo.DEPARTMENT_ID is null) AND (X_DEPARTMENT_ID is null)))
1947 AND ((recinfo.SCHEDULE_UPDATE_CODE = X_SCHEDULE_UPDATE_CODE)
1948 OR ((recinfo.SCHEDULE_UPDATE_CODE is null) AND (X_SCHEDULE_UPDATE_CODE is null)))
1949 AND ((recinfo.SETUP_TEARDOWN_CODE = X_SETUP_TEARDOWN_CODE)
1950 OR ((recinfo.SETUP_TEARDOWN_CODE is null) AND (X_SETUP_TEARDOWN_CODE is null)))
1951 AND ((recinfo.PRIMARY_SWITCH = X_PRIMARY_SWITCH)
1952 OR ((recinfo.PRIMARY_SWITCH is null) AND (X_PRIMARY_SWITCH is null)))
1953 AND ((recinfo.MRP_CODE = X_MRP_CODE)
1954 OR ((recinfo.MRP_CODE is null) AND (X_MRP_CODE is null)))
1955 AND ((recinfo.OPERATION_SEQ_NUM = X_OPERATION_SEQ_NUM)
1956 OR ((recinfo.OPERATION_SEQ_NUM is null) AND (X_OPERATION_SEQ_NUM is null)))
1957 AND ((recinfo.REPETITIVE_LINE_ID = X_REPETITIVE_LINE_ID)
1958 OR ((recinfo.REPETITIVE_LINE_ID is null) AND (X_REPETITIVE_LINE_ID is null)))
1959 AND ((recinfo.PICKING_LINE_ID = X_PICKING_LINE_ID)
1960 OR ((recinfo.PICKING_LINE_ID is null) AND (X_PICKING_LINE_ID is null)))
1961 AND ((recinfo.TRX_SOURCE_LINE_ID = X_TRX_SOURCE_LINE_ID)
1965 AND ((recinfo.DEMAND_ID = X_DEMAND_ID)
1962 OR ((recinfo.TRX_SOURCE_LINE_ID is null) AND (X_TRX_SOURCE_LINE_ID is null)))
1963 AND ((recinfo.TRX_SOURCE_DELIVERY_ID = X_TRX_SOURCE_DELIVERY_ID)
1964 OR ((recinfo.TRX_SOURCE_DELIVERY_ID is null) AND (X_TRX_SOURCE_DELIVERY_ID is null)))
1966 OR ((recinfo.DEMAND_ID is null) AND (X_DEMAND_ID is null)))
1967 AND ((recinfo.CUSTOMER_SHIP_ID = X_CUSTOMER_SHIP_ID)
1968 OR ((recinfo.CUSTOMER_SHIP_ID is null) AND (X_CUSTOMER_SHIP_ID is null)))
1969 AND ((recinfo.LINE_ITEM_NUM = X_LINE_ITEM_NUM)
1970 OR ((recinfo.LINE_ITEM_NUM is null) AND (X_LINE_ITEM_NUM is null)))
1971 AND ((recinfo.RECEIVING_DOCUMENT = X_RECEIVING_DOCUMENT)
1972 OR ((recinfo.RECEIVING_DOCUMENT is null) AND (X_RECEIVING_DOCUMENT is null)))
1973 AND ((recinfo.RCV_TRANSACTION_ID = X_RCV_TRANSACTION_ID)
1974 OR ((recinfo.RCV_TRANSACTION_ID is null) AND (X_RCV_TRANSACTION_ID is null)))
1975 AND ((recinfo.SHIP_TO_LOCATION_ID = X_SHIP_TO_LOCATION_ID)
1976 OR ((recinfo.SHIP_TO_LOCATION_ID is null) AND (X_SHIP_TO_LOCATION_ID is null)))
1977 AND ((recinfo.ENCUMBRANCE_ACCOUNT = X_ENCUMBRANCE_ACCOUNT)
1978 OR ((recinfo.ENCUMBRANCE_ACCOUNT is null) AND (X_ENCUMBRANCE_ACCOUNT is null)))
1979 AND ((recinfo.ENCUMBRANCE_AMOUNT = X_ENCUMBRANCE_AMOUNT)
1980 OR ((recinfo.ENCUMBRANCE_AMOUNT is null) AND (X_ENCUMBRANCE_AMOUNT is null)))
1981 AND ((recinfo.VENDOR_LOT_NUMBER = X_VENDOR_LOT_NUMBER)
1982 OR ((recinfo.VENDOR_LOT_NUMBER is null) AND (X_VENDOR_LOT_NUMBER is null)))
1983 AND ((recinfo.TRANSFER_SUBINVENTORY = X_TRANSFER_SUBINVENTORY)
1984 OR ((recinfo.TRANSFER_SUBINVENTORY is null) AND (X_TRANSFER_SUBINVENTORY is null)))
1985 AND ((recinfo.TRANSFER_ORGANIZATION = X_TRANSFER_ORGANIZATION)
1986 OR ((recinfo.TRANSFER_ORGANIZATION is null) AND (X_TRANSFER_ORGANIZATION is null)))
1987 AND ((recinfo.TRANSFER_LOCATOR = X_TRANSFER_LOCATOR)
1988 OR ((recinfo.TRANSFER_LOCATOR is null) AND (X_TRANSFER_LOCATOR is null)))
1989 AND ((recinfo.XFER_LOC_SEGMENT1 = X_XFER_LOC_SEGMENT1)
1990 OR ((recinfo.XFER_LOC_SEGMENT1 is null) AND (X_XFER_LOC_SEGMENT1 is null)))
1991 AND ((recinfo.XFER_LOC_SEGMENT2 = X_XFER_LOC_SEGMENT2)
1992 OR ((recinfo.XFER_LOC_SEGMENT2 is null) AND (X_XFER_LOC_SEGMENT2 is null)))
1993 AND ((recinfo.XFER_LOC_SEGMENT3 = X_XFER_LOC_SEGMENT3)
1994 OR ((recinfo.XFER_LOC_SEGMENT3 is null) AND (X_XFER_LOC_SEGMENT3 is null)))
1995 AND ((recinfo.XFER_LOC_SEGMENT4 = X_XFER_LOC_SEGMENT4)
1996 OR ((recinfo.XFER_LOC_SEGMENT4 is null) AND (X_XFER_LOC_SEGMENT4 is null)))
1997 AND ((recinfo.XFER_LOC_SEGMENT5 = X_XFER_LOC_SEGMENT5)
1998 OR ((recinfo.XFER_LOC_SEGMENT5 is null) AND (X_XFER_LOC_SEGMENT5 is null)))
1999 AND ((recinfo.TRANSACTION_HEADER_ID = X_TRANSACTION_HEADER_ID)
2000 OR ((recinfo.TRANSACTION_HEADER_ID is null) AND (X_TRANSACTION_HEADER_ID is null)))
2001 AND (recinfo.SOURCE_CODE = X_SOURCE_CODE)
2002 AND (recinfo.SOURCE_LINE_ID = X_SOURCE_LINE_ID)
2003 AND (recinfo.SOURCE_HEADER_ID = X_SOURCE_HEADER_ID)
2004 AND (recinfo.PROCESS_FLAG = X_PROCESS_FLAG)
2005 AND ((recinfo.VALIDATION_REQUIRED = X_VALIDATION_REQUIRED)
2006 OR ((recinfo.VALIDATION_REQUIRED is null) AND (X_VALIDATION_REQUIRED is null)))
2007 AND (recinfo.TRANSACTION_MODE = X_TRANSACTION_MODE)
2008 AND ((recinfo.LOCK_FLAG = X_LOCK_FLAG)
2009 OR ((recinfo.LOCK_FLAG is null) AND (X_LOCK_FLAG is null)))
2010 AND ((recinfo.REQUEST_ID = X_REQUEST_ID)
2011 OR ((recinfo.REQUEST_ID is null) AND (X_REQUEST_ID is null)))
2012 AND ((recinfo.INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID)
2013 OR ((recinfo.INVENTORY_ITEM_ID is null) AND (X_INVENTORY_ITEM_ID is null)))
2014 AND ((recinfo.ITEM_SEGMENT1 = X_ITEM_SEGMENT1)
2015 OR ((recinfo.ITEM_SEGMENT1 is null) AND (X_ITEM_SEGMENT1 is null)))
2016 AND ((recinfo.ITEM_SEGMENT2 = X_ITEM_SEGMENT2)
2017 OR ((recinfo.ITEM_SEGMENT2 is null) AND (X_ITEM_SEGMENT2 is null)))
2018 AND ((recinfo.ITEM_SEGMENT3 = X_ITEM_SEGMENT3)
2019 OR ((recinfo.ITEM_SEGMENT3 is null) AND (X_ITEM_SEGMENT3 is null)))
2020 AND ((recinfo.ITEM_SEGMENT4 = X_ITEM_SEGMENT4)
2021 OR ((recinfo.ITEM_SEGMENT4 is null) AND (X_ITEM_SEGMENT4 is null)))
2022 AND ((recinfo.ITEM_SEGMENT5 = X_ITEM_SEGMENT5)
2023 OR ((recinfo.ITEM_SEGMENT5 is null) AND (X_ITEM_SEGMENT5 is null)))
2024 AND ((recinfo.ITEM_SEGMENT6 = X_ITEM_SEGMENT6)
2025 OR ((recinfo.ITEM_SEGMENT6 is null) AND (X_ITEM_SEGMENT6 is null)))
2026 AND ((recinfo.ITEM_SEGMENT7 = X_ITEM_SEGMENT7)
2027 OR ((recinfo.ITEM_SEGMENT7 is null) AND (X_ITEM_SEGMENT7 is null)))
2028 AND ((recinfo.ITEM_SEGMENT8 = X_ITEM_SEGMENT8)
2029 OR ((recinfo.ITEM_SEGMENT8 is null) AND (X_ITEM_SEGMENT8 is null)))
2030 AND ((recinfo.ITEM_SEGMENT9 = X_ITEM_SEGMENT9)
2031 OR ((recinfo.ITEM_SEGMENT9 is null) AND (X_ITEM_SEGMENT9 is null)))
2032 AND ((recinfo.ITEM_SEGMENT10 = X_ITEM_SEGMENT10)
2033 OR ((recinfo.ITEM_SEGMENT10 is null) AND (X_ITEM_SEGMENT10 is null)))
2034 AND ((recinfo.ITEM_SEGMENT11 = X_ITEM_SEGMENT11)
2035 OR ((recinfo.ITEM_SEGMENT11 is null) AND (X_ITEM_SEGMENT11 is null)))
2036 AND ((recinfo.ITEM_SEGMENT12 = X_ITEM_SEGMENT12)
2037 OR ((recinfo.ITEM_SEGMENT12 is null) AND (X_ITEM_SEGMENT12 is null)))
2038 AND ((recinfo.ITEM_SEGMENT13 = X_ITEM_SEGMENT13)
2039 OR ((recinfo.ITEM_SEGMENT13 is null) AND (X_ITEM_SEGMENT13 is null)))
2040 AND ((recinfo.ITEM_SEGMENT14 = X_ITEM_SEGMENT14)
2041 OR ((recinfo.ITEM_SEGMENT14 is null) AND (X_ITEM_SEGMENT14 is null)))
2042 AND ((recinfo.ITEM_SEGMENT15 = X_ITEM_SEGMENT15)
2043 OR ((recinfo.ITEM_SEGMENT15 is null) AND (X_ITEM_SEGMENT15 is null)))
2044 AND ((recinfo.ITEM_SEGMENT16 = X_ITEM_SEGMENT16)
2045 OR ((recinfo.ITEM_SEGMENT16 is null) AND (X_ITEM_SEGMENT16 is null)))
2046 AND ((recinfo.ITEM_SEGMENT17 = X_ITEM_SEGMENT17)
2050 AND ((recinfo.ITEM_SEGMENT19 = X_ITEM_SEGMENT19)
2047 OR ((recinfo.ITEM_SEGMENT17 is null) AND (X_ITEM_SEGMENT17 is null)))
2048 AND ((recinfo.ITEM_SEGMENT18 = X_ITEM_SEGMENT18)
2049 OR ((recinfo.ITEM_SEGMENT18 is null) AND (X_ITEM_SEGMENT18 is null)))
2051 OR ((recinfo.ITEM_SEGMENT19 is null) AND (X_ITEM_SEGMENT19 is null)))
2052 AND ((recinfo.ITEM_SEGMENT20 = X_ITEM_SEGMENT20)
2053 OR ((recinfo.ITEM_SEGMENT20 is null) AND (X_ITEM_SEGMENT20 is null)))
2054 AND ((recinfo.REVISION = X_REVISION)
2055 OR ((recinfo.REVISION is null) AND (X_REVISION is null)))
2056 AND (recinfo.ORGANIZATION_ID = X_ORGANIZATION_ID)
2057 AND (recinfo.TRANSACTION_QUANTITY = X_TRANSACTION_QUANTITY)
2058 AND ((recinfo.PRIMARY_QUANTITY = X_PRIMARY_QUANTITY)
2059 OR ((recinfo.PRIMARY_QUANTITY is null) AND (X_PRIMARY_QUANTITY is null)))
2060 AND (recinfo.TRANSACTION_UOM = X_TRANSACTION_UOM)
2061 AND (recinfo.TRANSACTION_DATE = X_TRANSACTION_DATE)
2062 AND ((recinfo.ACCT_PERIOD_ID = X_ACCT_PERIOD_ID)
2063 OR ((recinfo.ACCT_PERIOD_ID is null) AND (X_ACCT_PERIOD_ID is null)))
2064 AND ((recinfo.SUBINVENTORY_CODE = X_SUBINVENTORY_CODE)
2065 OR ((recinfo.SUBINVENTORY_CODE is null) AND (X_SUBINVENTORY_CODE is null)))
2066 AND ((recinfo.LOCATOR_ID = X_LOCATOR_ID)
2067 OR ((recinfo.LOCATOR_ID is null) AND (X_LOCATOR_ID is null)))
2068 AND ((recinfo.LOC_SEGMENT1 = X_LOC_SEGMENT1)
2069 OR ((recinfo.LOC_SEGMENT1 is null) AND (X_LOC_SEGMENT1 is null)))
2070 AND ((recinfo.LOC_SEGMENT2 = X_LOC_SEGMENT2)
2071 OR ((recinfo.LOC_SEGMENT2 is null) AND (X_LOC_SEGMENT2 is null)))
2072 AND ((recinfo.LOC_SEGMENT3 = X_LOC_SEGMENT3)
2073 OR ((recinfo.LOC_SEGMENT3 is null) AND (X_LOC_SEGMENT3 is null)))
2074 AND ((recinfo.LOC_SEGMENT4 = X_LOC_SEGMENT4)
2075 OR ((recinfo.LOC_SEGMENT4 is null) AND (X_LOC_SEGMENT4 is null)))
2076 AND ((recinfo.LOC_SEGMENT5 = X_LOC_SEGMENT5)
2077 OR ((recinfo.LOC_SEGMENT5 is null) AND (X_LOC_SEGMENT5 is null)))
2078 AND ((recinfo.LOC_SEGMENT6 = X_LOC_SEGMENT6)
2079 OR ((recinfo.LOC_SEGMENT6 is null) AND (X_LOC_SEGMENT6 is null)))
2080 AND ((recinfo.LOC_SEGMENT7 = X_LOC_SEGMENT7)
2081 OR ((recinfo.LOC_SEGMENT7 is null) AND (X_LOC_SEGMENT7 is null)))
2082 AND ((recinfo.LOC_SEGMENT8 = X_LOC_SEGMENT8)
2083 OR ((recinfo.LOC_SEGMENT8 is null) AND (X_LOC_SEGMENT8 is null)))
2084 AND ((recinfo.LOC_SEGMENT9 = X_LOC_SEGMENT9)
2085 OR ((recinfo.LOC_SEGMENT9 is null) AND (X_LOC_SEGMENT9 is null)))
2086 AND ((recinfo.LOC_SEGMENT10 = X_LOC_SEGMENT10)
2087 OR ((recinfo.LOC_SEGMENT10 is null) AND (X_LOC_SEGMENT10 is null)))
2088 AND ((recinfo.LOC_SEGMENT11 = X_LOC_SEGMENT11)
2089 OR ((recinfo.LOC_SEGMENT11 is null) AND (X_LOC_SEGMENT11 is null)))
2090 ) then
2091 null;
2092 else
2093 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
2094 app_exception.raise_exception;
2095 end if;
2096
2097 return;
2098 end LOCK_ROW;
2099
2100 procedure UPDATE_ROW (
2101 X_TRANSACTION_INTERFACE_ID in NUMBER,
2102 X_PLANNING_ORGANIZATION_ID in NUMBER,
2103 X_PLANNING_TP_TYPE in NUMBER,
2104 X_XFR_PLANNING_ORGANIZATION_ID in NUMBER,
2105 X_TRANSFER_PLANNING_TP_TYPE in NUMBER,
2106 X_SECONDARY_UOM_CODE in VARCHAR2,
2107 X_SECONDARY_TRANSACTION_QUANTI in NUMBER,
2108 X_TRANSACTION_GROUP_ID in NUMBER,
2109 X_TRANSACTION_GROUP_SEQ in NUMBER,
2110 X_REPRESENTATIVE_LOT_NUMBER in VARCHAR2,
2111 X_TRANSACTION_BATCH_ID in NUMBER,
2112 X_TRANSACTION_BATCH_SEQ in NUMBER,
2113 X_REBUILD_ITEM_ID in NUMBER,
2114 X_REBUILD_SERIAL_NUMBER in VARCHAR2,
2115 X_REBUILD_ACTIVITY_ID in NUMBER,
2116 X_REBUILD_JOB_NAME in VARCHAR2,
2117 X_MOVE_TRANSACTION_ID in NUMBER,
2118 X_COMPLETION_TRANSACTION_ID in NUMBER,
2119 X_WIP_SUPPLY_TYPE in NUMBER,
2120 X_XFER_LOC_SEGMENT6 in VARCHAR2,
2121 X_XFER_LOC_SEGMENT7 in VARCHAR2,
2122 X_XFER_LOC_SEGMENT8 in VARCHAR2,
2123 X_XFER_LOC_SEGMENT9 in VARCHAR2,
2124 X_XFER_LOC_SEGMENT10 in VARCHAR2,
2125 X_XFER_LOC_SEGMENT11 in VARCHAR2,
2126 X_XFER_LOC_SEGMENT12 in VARCHAR2,
2127 X_XFER_LOC_SEGMENT13 in VARCHAR2,
2128 X_XFER_LOC_SEGMENT14 in VARCHAR2,
2129 X_XFER_LOC_SEGMENT15 in VARCHAR2,
2130 X_XFER_LOC_SEGMENT16 in VARCHAR2,
2131 X_XFER_LOC_SEGMENT17 in VARCHAR2,
2132 X_XFER_LOC_SEGMENT18 in VARCHAR2,
2133 X_XFER_LOC_SEGMENT19 in VARCHAR2,
2134 X_XFER_LOC_SEGMENT20 in VARCHAR2,
2135 X_SHIPMENT_NUMBER in VARCHAR2,
2136 X_TRANSPORTATION_COST in NUMBER,
2137 X_TRANSPORTATION_ACCOUNT in NUMBER,
2138 X_TRANSFER_COST in NUMBER,
2139 X_FREIGHT_CODE in VARCHAR2,
2140 X_CONTAINERS in NUMBER,
2141 X_WAYBILL_AIRBILL in VARCHAR2,
2142 X_EXPECTED_ARRIVAL_DATE in DATE,
2143 X_NEW_AVERAGE_COST in NUMBER,
2144 X_VALUE_CHANGE in NUMBER,
2145 X_PERCENTAGE_CHANGE in NUMBER,
2146 X_DEMAND_SOURCE_HEADER_ID in NUMBER,
2147 X_DEMAND_SOURCE_LINE in VARCHAR2,
2148 X_DEMAND_SOURCE_DELIVERY in VARCHAR2,
2149 X_NEGATIVE_REQ_FLAG in NUMBER,
2150 X_ERROR_EXPLANATION in VARCHAR2,
2151 X_SHIPPABLE_FLAG in VARCHAR2,
2152 X_REQUIRED_FLAG in VARCHAR2,
2153 X_ATTRIBUTE_CATEGORY in VARCHAR2,
2154 X_ATTRIBUTE1 in VARCHAR2,
2155 X_ATTRIBUTE2 in VARCHAR2,
2156 X_ATTRIBUTE3 in VARCHAR2,
2157 X_ATTRIBUTE4 in VARCHAR2,
2158 X_ATTRIBUTE5 in VARCHAR2,
2159 X_ATTRIBUTE6 in VARCHAR2,
2160 X_ATTRIBUTE7 in VARCHAR2,
2161 X_ATTRIBUTE8 in VARCHAR2,
2162 X_ATTRIBUTE9 in VARCHAR2,
2163 X_ATTRIBUTE10 in VARCHAR2,
2164 X_ATTRIBUTE11 in VARCHAR2,
2165 X_ATTRIBUTE12 in VARCHAR2,
2166 X_ATTRIBUTE13 in VARCHAR2,
2167 X_ATTRIBUTE14 in VARCHAR2,
2168 X_ATTRIBUTE15 in VARCHAR2,
2169 X_REQUISITION_DISTRIBUTION_ID in NUMBER,
2170 X_MOVEMENT_ID in NUMBER,
2171 X_RESERVATION_QUANTITY in NUMBER,
2175 X_TASK_ID in NUMBER,
2172 X_SHIPPED_QUANTITY in NUMBER,
2173 X_INVENTORY_ITEM in VARCHAR2,
2174 X_LOCATOR_NAME in VARCHAR2,
2176 X_TO_TASK_ID in NUMBER,
2177 X_SOURCE_TASK_ID in NUMBER,
2178 X_PROJECT_ID in NUMBER,
2179 X_TO_PROJECT_ID in NUMBER,
2180 X_SOURCE_PROJECT_ID in NUMBER,
2181 X_PA_EXPENDITURE_ORG_ID in NUMBER,
2182 X_EXPENDITURE_TYPE in VARCHAR2,
2183 X_FINAL_COMPLETION_FLAG in VARCHAR2,
2184 X_TRANSFER_PERCENTAGE in NUMBER,
2185 X_TRANSACTION_SEQUENCE_ID in NUMBER,
2186 X_MATERIAL_ACCOUNT in NUMBER,
2187 X_MATERIAL_OVERHEAD_ACCOUNT in NUMBER,
2188 X_RESOURCE_ACCOUNT in NUMBER,
2189 X_OUTSIDE_PROCESSING_ACCOUNT in NUMBER,
2190 X_OVERHEAD_ACCOUNT in NUMBER,
2191 X_BOM_REVISION in VARCHAR2,
2192 X_ROUTING_REVISION in VARCHAR2,
2193 X_BOM_REVISION_DATE in DATE,
2194 X_ROUTING_REVISION_DATE in DATE,
2195 X_ALTERNATE_BOM_DESIGNATOR in VARCHAR2,
2196 X_ALTERNATE_ROUTING_DESIGNATOR in VARCHAR2,
2197 X_ACCOUNTING_CLASS in VARCHAR2,
2198 X_DEMAND_CLASS in VARCHAR2,
2199 X_PARENT_ID in NUMBER,
2200 X_SUBSTITUTION_TYPE_ID in NUMBER,
2201 X_SUBSTITUTION_ITEM_ID in NUMBER,
2202 X_SCHEDULE_GROUP in NUMBER,
2203 X_BUILD_SEQUENCE in NUMBER,
2204 X_SCHEDULE_NUMBER in VARCHAR2,
2205 X_SCHEDULED_FLAG in NUMBER,
2206 X_FLOW_SCHEDULE in VARCHAR2,
2207 X_COST_GROUP_ID in NUMBER,
2208 X_KANBAN_CARD_ID in NUMBER,
2209 X_QA_COLLECTION_ID in NUMBER,
2210 X_OVERCOMPLETION_TRANSACTION_Q in NUMBER,
2211 X_OVERCOMPLETION_PRIMARY_QTY in NUMBER,
2212 X_OVERCOMPLETION_TRANSACTION_I in NUMBER,
2213 X_END_ITEM_UNIT_NUMBER in VARCHAR2,
2214 X_SCHEDULED_PAYBACK_DATE in DATE,
2215 X_ORG_COST_GROUP_ID in NUMBER,
2216 X_COST_TYPE_ID in NUMBER,
2217 X_SOURCE_LOT_NUMBER in VARCHAR2,
2218 X_TRANSFER_COST_GROUP_ID in NUMBER,
2219 X_LPN_ID in NUMBER,
2220 X_TRANSFER_LPN_ID in NUMBER,
2221 X_CONTENT_LPN_ID in NUMBER,
2222 X_XML_DOCUMENT_ID in VARCHAR2,
2223 X_ORGANIZATION_TYPE in NUMBER,
2224 X_TRANSFER_ORGANIZATION_TYPE in NUMBER,
2225 X_OWNING_ORGANIZATION_ID in NUMBER,
2226 X_OWNING_TP_TYPE in NUMBER,
2227 X_XFR_OWNING_ORGANIZATION_ID in NUMBER,
2228 X_TRANSFER_OWNING_TP_TYPE in NUMBER,
2229 X_LOC_SEGMENT12 in VARCHAR2,
2230 X_LOC_SEGMENT13 in VARCHAR2,
2231 X_LOC_SEGMENT14 in VARCHAR2,
2232 X_LOC_SEGMENT15 in VARCHAR2,
2233 X_LOC_SEGMENT16 in VARCHAR2,
2234 X_LOC_SEGMENT17 in VARCHAR2,
2235 X_LOC_SEGMENT18 in VARCHAR2,
2236 X_LOC_SEGMENT19 in VARCHAR2,
2237 X_LOC_SEGMENT20 in VARCHAR2,
2238 X_TRANSACTION_SOURCE_ID in NUMBER,
2239 X_DSP_SEGMENT1 in VARCHAR2,
2240 X_DSP_SEGMENT2 in VARCHAR2,
2241 X_DSP_SEGMENT3 in VARCHAR2,
2242 X_DSP_SEGMENT4 in VARCHAR2,
2243 X_DSP_SEGMENT5 in VARCHAR2,
2244 X_DSP_SEGMENT6 in VARCHAR2,
2245 X_DSP_SEGMENT7 in VARCHAR2,
2246 X_DSP_SEGMENT8 in VARCHAR2,
2247 X_DSP_SEGMENT9 in VARCHAR2,
2248 X_DSP_SEGMENT10 in VARCHAR2,
2249 X_DSP_SEGMENT11 in VARCHAR2,
2250 X_DSP_SEGMENT12 in VARCHAR2,
2251 X_DSP_SEGMENT13 in VARCHAR2,
2252 X_DSP_SEGMENT14 in VARCHAR2,
2253 X_DSP_SEGMENT15 in VARCHAR2,
2254 X_DSP_SEGMENT16 in VARCHAR2,
2255 X_DSP_SEGMENT17 in VARCHAR2,
2256 X_DSP_SEGMENT18 in VARCHAR2,
2257 X_DSP_SEGMENT19 in VARCHAR2,
2258 X_DSP_SEGMENT20 in VARCHAR2,
2259 X_DSP_SEGMENT21 in VARCHAR2,
2260 X_DSP_SEGMENT22 in VARCHAR2,
2261 X_DSP_SEGMENT23 in VARCHAR2,
2262 X_DSP_SEGMENT24 in VARCHAR2,
2263 X_DSP_SEGMENT25 in VARCHAR2,
2264 X_DSP_SEGMENT26 in VARCHAR2,
2265 X_DSP_SEGMENT27 in VARCHAR2,
2266 X_DSP_SEGMENT28 in VARCHAR2,
2267 X_DSP_SEGMENT29 in VARCHAR2,
2268 X_DSP_SEGMENT30 in VARCHAR2,
2269 X_TRANSACTION_SOURCE_NAME in VARCHAR2,
2270 X_TRANSACTION_SOURCE_TYPE_ID in NUMBER,
2271 X_TRANSACTION_ACTION_ID in NUMBER,
2272 X_TRANSACTION_TYPE_ID in NUMBER,
2273 X_REASON_ID in NUMBER,
2274 X_TRANSACTION_REFERENCE in VARCHAR2,
2275 X_TRANSACTION_COST in NUMBER,
2276 X_DISTRIBUTION_ACCOUNT_ID in NUMBER,
2277 X_DST_SEGMENT1 in VARCHAR2,
2278 X_DST_SEGMENT2 in VARCHAR2,
2279 X_DST_SEGMENT3 in VARCHAR2,
2280 X_DST_SEGMENT4 in VARCHAR2,
2281 X_DST_SEGMENT5 in VARCHAR2,
2282 X_DST_SEGMENT6 in VARCHAR2,
2283 X_DST_SEGMENT7 in VARCHAR2,
2284 X_DST_SEGMENT8 in VARCHAR2,
2285 X_DST_SEGMENT9 in VARCHAR2,
2286 X_DST_SEGMENT10 in VARCHAR2,
2287 X_DST_SEGMENT11 in VARCHAR2,
2288 X_DST_SEGMENT12 in VARCHAR2,
2289 X_DST_SEGMENT13 in VARCHAR2,
2290 X_DST_SEGMENT14 in VARCHAR2,
2291 X_DST_SEGMENT15 in VARCHAR2,
2292 X_DST_SEGMENT16 in VARCHAR2,
2293 X_DST_SEGMENT17 in VARCHAR2,
2294 X_DST_SEGMENT18 in VARCHAR2,
2295 X_DST_SEGMENT19 in VARCHAR2,
2296 X_DST_SEGMENT20 in VARCHAR2,
2297 X_DST_SEGMENT21 in VARCHAR2,
2298 X_DST_SEGMENT22 in VARCHAR2,
2299 X_DST_SEGMENT23 in VARCHAR2,
2300 X_DST_SEGMENT24 in VARCHAR2,
2301 X_DST_SEGMENT25 in VARCHAR2,
2302 X_DST_SEGMENT26 in VARCHAR2,
2303 X_DST_SEGMENT27 in VARCHAR2,
2304 X_DST_SEGMENT28 in VARCHAR2,
2305 X_DST_SEGMENT29 in VARCHAR2,
2306 X_DST_SEGMENT30 in VARCHAR2,
2307 X_REQUISITION_LINE_ID in NUMBER,
2308 X_CURRENCY_CODE in VARCHAR2,
2309 X_CURRENCY_CONVERSION_DATE in DATE,
2310 X_CURRENCY_CONVERSION_TYPE in VARCHAR2,
2311 X_CURRENCY_CONVERSION_RATE in NUMBER,
2312 X_USSGL_TRANSACTION_CODE in VARCHAR2,
2313 X_WIP_ENTITY_TYPE in NUMBER,
2314 X_SCHEDULE_ID in NUMBER,
2315 X_EMPLOYEE_CODE in VARCHAR2,
2316 X_DEPARTMENT_ID in NUMBER,
2317 X_SCHEDULE_UPDATE_CODE in NUMBER,
2318 X_SETUP_TEARDOWN_CODE in NUMBER,
2319 X_PRIMARY_SWITCH in NUMBER,
2320 X_MRP_CODE in NUMBER,
2321 X_OPERATION_SEQ_NUM in NUMBER,
2322 X_REPETITIVE_LINE_ID in NUMBER,
2323 X_PICKING_LINE_ID in NUMBER,
2324 X_TRX_SOURCE_LINE_ID in NUMBER,
2328 X_LINE_ITEM_NUM in NUMBER,
2325 X_TRX_SOURCE_DELIVERY_ID in NUMBER,
2326 X_DEMAND_ID in NUMBER,
2327 X_CUSTOMER_SHIP_ID in NUMBER,
2329 X_RECEIVING_DOCUMENT in VARCHAR2,
2330 X_RCV_TRANSACTION_ID in NUMBER,
2331 X_SHIP_TO_LOCATION_ID in NUMBER,
2332 X_ENCUMBRANCE_ACCOUNT in NUMBER,
2333 X_ENCUMBRANCE_AMOUNT in NUMBER,
2334 X_VENDOR_LOT_NUMBER in VARCHAR2,
2335 X_TRANSFER_SUBINVENTORY in VARCHAR2,
2336 X_TRANSFER_ORGANIZATION in NUMBER,
2337 X_TRANSFER_LOCATOR in NUMBER,
2338 X_XFER_LOC_SEGMENT1 in VARCHAR2,
2339 X_XFER_LOC_SEGMENT2 in VARCHAR2,
2340 X_XFER_LOC_SEGMENT3 in VARCHAR2,
2341 X_XFER_LOC_SEGMENT4 in VARCHAR2,
2342 X_XFER_LOC_SEGMENT5 in VARCHAR2,
2343 X_TRANSACTION_HEADER_ID in NUMBER,
2344 X_SOURCE_CODE in VARCHAR2,
2345 X_SOURCE_LINE_ID in NUMBER,
2346 X_SOURCE_HEADER_ID in NUMBER,
2347 X_PROCESS_FLAG in NUMBER,
2348 X_VALIDATION_REQUIRED in NUMBER,
2349 X_TRANSACTION_MODE in NUMBER,
2350 X_LOCK_FLAG in NUMBER,
2351 X_REQUEST_ID in NUMBER,
2352 X_INVENTORY_ITEM_ID in NUMBER,
2353 X_ITEM_SEGMENT1 in VARCHAR2,
2354 X_ITEM_SEGMENT2 in VARCHAR2,
2355 X_ITEM_SEGMENT3 in VARCHAR2,
2356 X_ITEM_SEGMENT4 in VARCHAR2,
2357 X_ITEM_SEGMENT5 in VARCHAR2,
2358 X_ITEM_SEGMENT6 in VARCHAR2,
2359 X_ITEM_SEGMENT7 in VARCHAR2,
2360 X_ITEM_SEGMENT8 in VARCHAR2,
2361 X_ITEM_SEGMENT9 in VARCHAR2,
2362 X_ITEM_SEGMENT10 in VARCHAR2,
2363 X_ITEM_SEGMENT11 in VARCHAR2,
2364 X_ITEM_SEGMENT12 in VARCHAR2,
2365 X_ITEM_SEGMENT13 in VARCHAR2,
2366 X_ITEM_SEGMENT14 in VARCHAR2,
2367 X_ITEM_SEGMENT15 in VARCHAR2,
2368 X_ITEM_SEGMENT16 in VARCHAR2,
2369 X_ITEM_SEGMENT17 in VARCHAR2,
2370 X_ITEM_SEGMENT18 in VARCHAR2,
2371 X_ITEM_SEGMENT19 in VARCHAR2,
2372 X_ITEM_SEGMENT20 in VARCHAR2,
2373 X_REVISION in VARCHAR2,
2374 X_ORGANIZATION_ID in NUMBER,
2375 X_TRANSACTION_QUANTITY in NUMBER,
2376 X_PRIMARY_QUANTITY in NUMBER,
2377 X_TRANSACTION_UOM in VARCHAR2,
2378 X_TRANSACTION_DATE in DATE,
2379 X_ACCT_PERIOD_ID in NUMBER,
2380 X_SUBINVENTORY_CODE in VARCHAR2,
2381 X_LOCATOR_ID in NUMBER,
2382 X_LOC_SEGMENT1 in VARCHAR2,
2383 X_LOC_SEGMENT2 in VARCHAR2,
2384 X_LOC_SEGMENT3 in VARCHAR2,
2385 X_LOC_SEGMENT4 in VARCHAR2,
2386 X_LOC_SEGMENT5 in VARCHAR2,
2387 X_LOC_SEGMENT6 in VARCHAR2,
2388 X_LOC_SEGMENT7 in VARCHAR2,
2389 X_LOC_SEGMENT8 in VARCHAR2,
2390 X_LOC_SEGMENT9 in VARCHAR2,
2391 X_LOC_SEGMENT10 in VARCHAR2,
2392 X_LOC_SEGMENT11 in VARCHAR2,
2393 X_ERROR_CODE in VARCHAR2,
2394 X_LAST_UPDATE_DATE in DATE,
2395 X_LAST_UPDATED_BY in NUMBER,
2396 X_LAST_UPDATE_LOGIN in NUMBER
2397 ) IS
2398 l_item_id NUMBER := NULL;
2399 l_rowid VARCHAR2(100) := NULL;
2400 begin
2401 update MTL_TRANSACTIONS_INTERFACE set
2402 PLANNING_ORGANIZATION_ID = X_PLANNING_ORGANIZATION_ID,
2403 PLANNING_TP_TYPE = X_PLANNING_TP_TYPE,
2404 XFR_PLANNING_ORGANIZATION_ID = X_XFR_PLANNING_ORGANIZATION_ID,
2405 TRANSFER_PLANNING_TP_TYPE = X_TRANSFER_PLANNING_TP_TYPE,
2406 SECONDARY_UOM_CODE = X_SECONDARY_UOM_CODE,
2407 SECONDARY_TRANSACTION_QUANTITY = X_SECONDARY_TRANSACTION_QUANTI,
2408 --TRANSACTION_GROUP_ID = X_TRANSACTION_GROUP_ID,
2409 --TRANSACTION_GROUP_SEQ = X_TRANSACTION_GROUP_SEQ,
2410 REPRESENTATIVE_LOT_NUMBER = X_REPRESENTATIVE_LOT_NUMBER,
2411 TRANSACTION_BATCH_ID = X_TRANSACTION_BATCH_ID,
2412 TRANSACTION_BATCH_SEQ = X_TRANSACTION_BATCH_SEQ,
2413 REBUILD_ITEM_ID = X_REBUILD_ITEM_ID,
2414 REBUILD_SERIAL_NUMBER = X_REBUILD_SERIAL_NUMBER,
2415 REBUILD_ACTIVITY_ID = X_REBUILD_ACTIVITY_ID,
2416 REBUILD_JOB_NAME = X_REBUILD_JOB_NAME,
2417 MOVE_TRANSACTION_ID = X_MOVE_TRANSACTION_ID,
2418 COMPLETION_TRANSACTION_ID = X_COMPLETION_TRANSACTION_ID,
2419 WIP_SUPPLY_TYPE = X_WIP_SUPPLY_TYPE,
2420 XFER_LOC_SEGMENT6 = X_XFER_LOC_SEGMENT6,
2421 XFER_LOC_SEGMENT7 = X_XFER_LOC_SEGMENT7,
2422 XFER_LOC_SEGMENT8 = X_XFER_LOC_SEGMENT8,
2423 XFER_LOC_SEGMENT9 = X_XFER_LOC_SEGMENT9,
2424 XFER_LOC_SEGMENT10 = X_XFER_LOC_SEGMENT10,
2425 XFER_LOC_SEGMENT11 = X_XFER_LOC_SEGMENT11,
2426 XFER_LOC_SEGMENT12 = X_XFER_LOC_SEGMENT12,
2427 XFER_LOC_SEGMENT13 = X_XFER_LOC_SEGMENT13,
2428 XFER_LOC_SEGMENT14 = X_XFER_LOC_SEGMENT14,
2429 XFER_LOC_SEGMENT15 = X_XFER_LOC_SEGMENT15,
2430 XFER_LOC_SEGMENT16 = X_XFER_LOC_SEGMENT16,
2431 XFER_LOC_SEGMENT17 = X_XFER_LOC_SEGMENT17,
2432 XFER_LOC_SEGMENT18 = X_XFER_LOC_SEGMENT18,
2433 XFER_LOC_SEGMENT19 = X_XFER_LOC_SEGMENT19,
2434 XFER_LOC_SEGMENT20 = X_XFER_LOC_SEGMENT20,
2435 SHIPMENT_NUMBER = X_SHIPMENT_NUMBER,
2436 TRANSPORTATION_COST = X_TRANSPORTATION_COST,
2437 TRANSPORTATION_ACCOUNT = X_TRANSPORTATION_ACCOUNT,
2438 TRANSFER_COST = X_TRANSFER_COST,
2439 FREIGHT_CODE = X_FREIGHT_CODE,
2440 CONTAINERS = X_CONTAINERS,
2441 WAYBILL_AIRBILL = X_WAYBILL_AIRBILL,
2442 EXPECTED_ARRIVAL_DATE = X_EXPECTED_ARRIVAL_DATE,
2443 NEW_AVERAGE_COST = X_NEW_AVERAGE_COST,
2444 VALUE_CHANGE = X_VALUE_CHANGE,
2445 PERCENTAGE_CHANGE = X_PERCENTAGE_CHANGE,
2446 DEMAND_SOURCE_HEADER_ID = X_DEMAND_SOURCE_HEADER_ID,
2447 DEMAND_SOURCE_LINE = X_DEMAND_SOURCE_LINE,
2448 DEMAND_SOURCE_DELIVERY = X_DEMAND_SOURCE_DELIVERY,
2449 NEGATIVE_REQ_FLAG = X_NEGATIVE_REQ_FLAG,
2450 ERROR_EXPLANATION = X_ERROR_EXPLANATION,
2451 SHIPPABLE_FLAG = X_SHIPPABLE_FLAG,
2452 REQUIRED_FLAG = X_REQUIRED_FLAG,
2453 ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
2454 ATTRIBUTE1 = X_ATTRIBUTE1,
2455 ATTRIBUTE2 = X_ATTRIBUTE2,
2456 ATTRIBUTE3 = X_ATTRIBUTE3,
2457 ATTRIBUTE4 = X_ATTRIBUTE4,
2458 ATTRIBUTE5 = X_ATTRIBUTE5,
2459 ATTRIBUTE6 = X_ATTRIBUTE6,
2460 ATTRIBUTE7 = X_ATTRIBUTE7,
2461 ATTRIBUTE8 = X_ATTRIBUTE8,
2462 ATTRIBUTE9 = X_ATTRIBUTE9,
2463 ATTRIBUTE10 = X_ATTRIBUTE10,
2467 ATTRIBUTE14 = X_ATTRIBUTE14,
2464 ATTRIBUTE11 = X_ATTRIBUTE11,
2465 ATTRIBUTE12 = X_ATTRIBUTE12,
2466 ATTRIBUTE13 = X_ATTRIBUTE13,
2468 ATTRIBUTE15 = X_ATTRIBUTE15,
2469 REQUISITION_DISTRIBUTION_ID = X_REQUISITION_DISTRIBUTION_ID,
2470 MOVEMENT_ID = X_MOVEMENT_ID,
2471 RESERVATION_QUANTITY = X_RESERVATION_QUANTITY,
2472 SHIPPED_QUANTITY = X_SHIPPED_QUANTITY,
2473 INVENTORY_ITEM = X_INVENTORY_ITEM,
2474 LOCATOR_NAME = X_LOCATOR_NAME,
2475 TASK_ID = X_TASK_ID,
2476 TO_TASK_ID = X_TO_TASK_ID,
2477 SOURCE_TASK_ID = X_SOURCE_TASK_ID,
2478 PROJECT_ID = X_PROJECT_ID,
2479 TO_PROJECT_ID = X_TO_PROJECT_ID,
2480 SOURCE_PROJECT_ID = X_SOURCE_PROJECT_ID,
2481 PA_EXPENDITURE_ORG_ID = X_PA_EXPENDITURE_ORG_ID,
2482 EXPENDITURE_TYPE = X_EXPENDITURE_TYPE,
2483 FINAL_COMPLETION_FLAG = X_FINAL_COMPLETION_FLAG,
2484 TRANSFER_PERCENTAGE = X_TRANSFER_PERCENTAGE,
2485 TRANSACTION_SEQUENCE_ID = X_TRANSACTION_SEQUENCE_ID,
2486 MATERIAL_ACCOUNT = X_MATERIAL_ACCOUNT,
2487 MATERIAL_OVERHEAD_ACCOUNT = X_MATERIAL_OVERHEAD_ACCOUNT,
2488 RESOURCE_ACCOUNT = X_RESOURCE_ACCOUNT,
2489 OUTSIDE_PROCESSING_ACCOUNT = X_OUTSIDE_PROCESSING_ACCOUNT,
2490 OVERHEAD_ACCOUNT = X_OVERHEAD_ACCOUNT,
2491 BOM_REVISION = X_BOM_REVISION,
2492 ROUTING_REVISION = X_ROUTING_REVISION,
2493 BOM_REVISION_DATE = X_BOM_REVISION_DATE,
2494 ROUTING_REVISION_DATE = X_ROUTING_REVISION_DATE,
2495 ALTERNATE_BOM_DESIGNATOR = X_ALTERNATE_BOM_DESIGNATOR,
2496 ALTERNATE_ROUTING_DESIGNATOR = X_ALTERNATE_ROUTING_DESIGNATOR,
2497 ACCOUNTING_CLASS = X_ACCOUNTING_CLASS,
2498 DEMAND_CLASS = X_DEMAND_CLASS,
2499 PARENT_ID = X_PARENT_ID,
2500 SUBSTITUTION_TYPE_ID = X_SUBSTITUTION_TYPE_ID,
2501 SUBSTITUTION_ITEM_ID = X_SUBSTITUTION_ITEM_ID,
2502 SCHEDULE_GROUP = X_SCHEDULE_GROUP,
2503 BUILD_SEQUENCE = X_BUILD_SEQUENCE,
2504 SCHEDULE_NUMBER = X_SCHEDULE_NUMBER,
2505 SCHEDULED_FLAG = X_SCHEDULED_FLAG,
2506 FLOW_SCHEDULE = X_FLOW_SCHEDULE,
2507 COST_GROUP_ID = X_COST_GROUP_ID,
2508 KANBAN_CARD_ID = X_KANBAN_CARD_ID,
2509 QA_COLLECTION_ID = X_QA_COLLECTION_ID,
2510 OVERCOMPLETION_TRANSACTION_QTY = X_OVERCOMPLETION_TRANSACTION_Q,
2511 OVERCOMPLETION_PRIMARY_QTY = X_OVERCOMPLETION_PRIMARY_QTY,
2512 OVERCOMPLETION_TRANSACTION_ID = X_OVERCOMPLETION_TRANSACTION_I,
2513 END_ITEM_UNIT_NUMBER = X_END_ITEM_UNIT_NUMBER,
2514 SCHEDULED_PAYBACK_DATE = X_SCHEDULED_PAYBACK_DATE,
2515 ORG_COST_GROUP_ID = X_ORG_COST_GROUP_ID,
2516 COST_TYPE_ID = X_COST_TYPE_ID,
2517 SOURCE_LOT_NUMBER = X_SOURCE_LOT_NUMBER,
2518 TRANSFER_COST_GROUP_ID = X_TRANSFER_COST_GROUP_ID,
2519 LPN_ID = X_LPN_ID,
2520 TRANSFER_LPN_ID = X_TRANSFER_LPN_ID,
2521 CONTENT_LPN_ID = X_CONTENT_LPN_ID,
2522 XML_DOCUMENT_ID = X_XML_DOCUMENT_ID,
2523 ORGANIZATION_TYPE = X_ORGANIZATION_TYPE,
2524 TRANSFER_ORGANIZATION_TYPE = X_TRANSFER_ORGANIZATION_TYPE,
2525 OWNING_ORGANIZATION_ID = X_OWNING_ORGANIZATION_ID,
2526 OWNING_TP_TYPE = X_OWNING_TP_TYPE,
2527 XFR_OWNING_ORGANIZATION_ID = X_XFR_OWNING_ORGANIZATION_ID,
2528 TRANSFER_OWNING_TP_TYPE = X_TRANSFER_OWNING_TP_TYPE,
2529 LOC_SEGMENT12 = X_LOC_SEGMENT12,
2530 LOC_SEGMENT13 = X_LOC_SEGMENT13,
2531 LOC_SEGMENT14 = X_LOC_SEGMENT14,
2532 LOC_SEGMENT15 = X_LOC_SEGMENT15,
2533 LOC_SEGMENT16 = X_LOC_SEGMENT16,
2534 LOC_SEGMENT17 = X_LOC_SEGMENT17,
2535 LOC_SEGMENT18 = X_LOC_SEGMENT18,
2536 LOC_SEGMENT19 = X_LOC_SEGMENT19,
2537 LOC_SEGMENT20 = X_LOC_SEGMENT20,
2538 TRANSACTION_SOURCE_ID = X_TRANSACTION_SOURCE_ID,
2539 DSP_SEGMENT1 = X_DSP_SEGMENT1,
2540 DSP_SEGMENT2 = X_DSP_SEGMENT2,
2541 DSP_SEGMENT3 = X_DSP_SEGMENT3,
2542 DSP_SEGMENT4 = X_DSP_SEGMENT4,
2543 DSP_SEGMENT5 = X_DSP_SEGMENT5,
2544 DSP_SEGMENT6 = X_DSP_SEGMENT6,
2545 DSP_SEGMENT7 = X_DSP_SEGMENT7,
2546 DSP_SEGMENT8 = X_DSP_SEGMENT8,
2547 DSP_SEGMENT9 = X_DSP_SEGMENT9,
2548 DSP_SEGMENT10 = X_DSP_SEGMENT10,
2549 DSP_SEGMENT11 = X_DSP_SEGMENT11,
2550 DSP_SEGMENT12 = X_DSP_SEGMENT12,
2551 DSP_SEGMENT13 = X_DSP_SEGMENT13,
2552 DSP_SEGMENT14 = X_DSP_SEGMENT14,
2553 DSP_SEGMENT15 = X_DSP_SEGMENT15,
2554 DSP_SEGMENT16 = X_DSP_SEGMENT16,
2555 DSP_SEGMENT17 = X_DSP_SEGMENT17,
2556 DSP_SEGMENT18 = X_DSP_SEGMENT18,
2557 DSP_SEGMENT19 = X_DSP_SEGMENT19,
2558 DSP_SEGMENT20 = X_DSP_SEGMENT20,
2559 DSP_SEGMENT21 = X_DSP_SEGMENT21,
2560 DSP_SEGMENT22 = X_DSP_SEGMENT22,
2561 DSP_SEGMENT23 = X_DSP_SEGMENT23,
2562 DSP_SEGMENT24 = X_DSP_SEGMENT24,
2563 DSP_SEGMENT25 = X_DSP_SEGMENT25,
2564 DSP_SEGMENT26 = X_DSP_SEGMENT26,
2565 DSP_SEGMENT27 = X_DSP_SEGMENT27,
2566 DSP_SEGMENT28 = X_DSP_SEGMENT28,
2567 DSP_SEGMENT29 = X_DSP_SEGMENT29,
2568 DSP_SEGMENT30 = X_DSP_SEGMENT30,
2569 TRANSACTION_SOURCE_NAME = X_TRANSACTION_SOURCE_NAME,
2570 TRANSACTION_SOURCE_TYPE_ID = X_TRANSACTION_SOURCE_TYPE_ID,
2571 TRANSACTION_ACTION_ID = X_TRANSACTION_ACTION_ID,
2572 TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID,
2573 REASON_ID = X_REASON_ID,
2574 TRANSACTION_REFERENCE = X_TRANSACTION_REFERENCE,
2575 TRANSACTION_COST = X_TRANSACTION_COST,
2576 DISTRIBUTION_ACCOUNT_ID = X_DISTRIBUTION_ACCOUNT_ID,
2577 DST_SEGMENT1 = X_DST_SEGMENT1,
2578 DST_SEGMENT2 = X_DST_SEGMENT2,
2579 DST_SEGMENT3 = X_DST_SEGMENT3,
2580 DST_SEGMENT4 = X_DST_SEGMENT4,
2581 DST_SEGMENT5 = X_DST_SEGMENT5,
2582 DST_SEGMENT6 = X_DST_SEGMENT6,
2583 DST_SEGMENT7 = X_DST_SEGMENT7,
2584 DST_SEGMENT8 = X_DST_SEGMENT8,
2585 DST_SEGMENT9 = X_DST_SEGMENT9,
2586 DST_SEGMENT10 = X_DST_SEGMENT10,
2587 DST_SEGMENT11 = X_DST_SEGMENT11,
2588 DST_SEGMENT12 = X_DST_SEGMENT12,
2589 DST_SEGMENT13 = X_DST_SEGMENT13,
2590 DST_SEGMENT14 = X_DST_SEGMENT14,
2591 DST_SEGMENT15 = X_DST_SEGMENT15,
2595 DST_SEGMENT19 = X_DST_SEGMENT19,
2592 DST_SEGMENT16 = X_DST_SEGMENT16,
2593 DST_SEGMENT17 = X_DST_SEGMENT17,
2594 DST_SEGMENT18 = X_DST_SEGMENT18,
2596 DST_SEGMENT20 = X_DST_SEGMENT20,
2597 DST_SEGMENT21 = X_DST_SEGMENT21,
2598 DST_SEGMENT22 = X_DST_SEGMENT22,
2599 DST_SEGMENT23 = X_DST_SEGMENT23,
2600 DST_SEGMENT24 = X_DST_SEGMENT24,
2601 DST_SEGMENT25 = X_DST_SEGMENT25,
2602 DST_SEGMENT26 = X_DST_SEGMENT26,
2603 DST_SEGMENT27 = X_DST_SEGMENT27,
2604 DST_SEGMENT28 = X_DST_SEGMENT28,
2605 DST_SEGMENT29 = X_DST_SEGMENT29,
2606 DST_SEGMENT30 = X_DST_SEGMENT30,
2607 REQUISITION_LINE_ID = X_REQUISITION_LINE_ID,
2608 CURRENCY_CODE = X_CURRENCY_CODE,
2609 CURRENCY_CONVERSION_DATE = X_CURRENCY_CONVERSION_DATE,
2610 CURRENCY_CONVERSION_TYPE = X_CURRENCY_CONVERSION_TYPE,
2611 CURRENCY_CONVERSION_RATE = X_CURRENCY_CONVERSION_RATE,
2612 USSGL_TRANSACTION_CODE = X_USSGL_TRANSACTION_CODE,
2613 WIP_ENTITY_TYPE = X_WIP_ENTITY_TYPE,
2614 SCHEDULE_ID = X_SCHEDULE_ID,
2615 EMPLOYEE_CODE = X_EMPLOYEE_CODE,
2616 DEPARTMENT_ID = X_DEPARTMENT_ID,
2617 SCHEDULE_UPDATE_CODE = X_SCHEDULE_UPDATE_CODE,
2618 SETUP_TEARDOWN_CODE = X_SETUP_TEARDOWN_CODE,
2619 PRIMARY_SWITCH = X_PRIMARY_SWITCH,
2620 MRP_CODE = X_MRP_CODE,
2621 OPERATION_SEQ_NUM = X_OPERATION_SEQ_NUM,
2622 REPETITIVE_LINE_ID = X_REPETITIVE_LINE_ID,
2623 PICKING_LINE_ID = X_PICKING_LINE_ID,
2624 TRX_SOURCE_LINE_ID = X_TRX_SOURCE_LINE_ID,
2625 TRX_SOURCE_DELIVERY_ID = X_TRX_SOURCE_DELIVERY_ID,
2626 DEMAND_ID = X_DEMAND_ID,
2627 CUSTOMER_SHIP_ID = X_CUSTOMER_SHIP_ID,
2628 LINE_ITEM_NUM = X_LINE_ITEM_NUM,
2629 RECEIVING_DOCUMENT = X_RECEIVING_DOCUMENT,
2630 RCV_TRANSACTION_ID = X_RCV_TRANSACTION_ID,
2631 SHIP_TO_LOCATION_ID = X_SHIP_TO_LOCATION_ID,
2632 ENCUMBRANCE_ACCOUNT = X_ENCUMBRANCE_ACCOUNT,
2633 ENCUMBRANCE_AMOUNT = X_ENCUMBRANCE_AMOUNT,
2634 VENDOR_LOT_NUMBER = X_VENDOR_LOT_NUMBER,
2635 TRANSFER_SUBINVENTORY = X_TRANSFER_SUBINVENTORY,
2636 TRANSFER_ORGANIZATION = X_TRANSFER_ORGANIZATION,
2637 TRANSFER_LOCATOR = X_TRANSFER_LOCATOR,
2638 XFER_LOC_SEGMENT1 = X_XFER_LOC_SEGMENT1,
2639 XFER_LOC_SEGMENT2 = X_XFER_LOC_SEGMENT2,
2640 XFER_LOC_SEGMENT3 = X_XFER_LOC_SEGMENT3,
2641 XFER_LOC_SEGMENT4 = X_XFER_LOC_SEGMENT4,
2642 XFER_LOC_SEGMENT5 = X_XFER_LOC_SEGMENT5,
2643 TRANSACTION_HEADER_ID = X_TRANSACTION_HEADER_ID,
2644 SOURCE_CODE = X_SOURCE_CODE,
2645 SOURCE_LINE_ID = X_SOURCE_LINE_ID,
2646 SOURCE_HEADER_ID = X_SOURCE_HEADER_ID,
2647 PROCESS_FLAG = X_PROCESS_FLAG,
2648 VALIDATION_REQUIRED = X_VALIDATION_REQUIRED,
2649 TRANSACTION_MODE = X_TRANSACTION_MODE,
2650 LOCK_FLAG = X_LOCK_FLAG,
2651 REQUEST_ID = X_REQUEST_ID,
2652 INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,
2653 ITEM_SEGMENT1 = X_ITEM_SEGMENT1,
2654 ITEM_SEGMENT2 = X_ITEM_SEGMENT2,
2655 ITEM_SEGMENT3 = X_ITEM_SEGMENT3,
2656 ITEM_SEGMENT4 = X_ITEM_SEGMENT4,
2657 ITEM_SEGMENT5 = X_ITEM_SEGMENT5,
2658 ITEM_SEGMENT6 = X_ITEM_SEGMENT6,
2659 ITEM_SEGMENT7 = X_ITEM_SEGMENT7,
2660 ITEM_SEGMENT8 = X_ITEM_SEGMENT8,
2661 ITEM_SEGMENT9 = X_ITEM_SEGMENT9,
2662 ITEM_SEGMENT10 = X_ITEM_SEGMENT10,
2663 ITEM_SEGMENT11 = X_ITEM_SEGMENT11,
2664 ITEM_SEGMENT12 = X_ITEM_SEGMENT12,
2665 ITEM_SEGMENT13 = X_ITEM_SEGMENT13,
2666 ITEM_SEGMENT14 = X_ITEM_SEGMENT14,
2667 ITEM_SEGMENT15 = X_ITEM_SEGMENT15,
2668 ITEM_SEGMENT16 = X_ITEM_SEGMENT16,
2669 ITEM_SEGMENT17 = X_ITEM_SEGMENT17,
2670 ITEM_SEGMENT18 = X_ITEM_SEGMENT18,
2671 ITEM_SEGMENT19 = X_ITEM_SEGMENT19,
2672 ITEM_SEGMENT20 = X_ITEM_SEGMENT20,
2673 REVISION = X_REVISION,
2674 ORGANIZATION_ID = X_ORGANIZATION_ID,
2675 TRANSACTION_QUANTITY = X_TRANSACTION_QUANTITY,
2676 PRIMARY_QUANTITY = X_PRIMARY_QUANTITY,
2677 TRANSACTION_UOM = X_TRANSACTION_UOM,
2678 TRANSACTION_DATE = X_TRANSACTION_DATE,
2679 ACCT_PERIOD_ID = X_ACCT_PERIOD_ID,
2680 SUBINVENTORY_CODE = X_SUBINVENTORY_CODE,
2681 LOCATOR_ID = X_LOCATOR_ID,
2682 LOC_SEGMENT1 = X_LOC_SEGMENT1,
2683 LOC_SEGMENT2 = X_LOC_SEGMENT2,
2684 LOC_SEGMENT3 = X_LOC_SEGMENT3,
2685 LOC_SEGMENT4 = X_LOC_SEGMENT4,
2686 LOC_SEGMENT5 = X_LOC_SEGMENT5,
2687 LOC_SEGMENT6 = X_LOC_SEGMENT6,
2688 LOC_SEGMENT7 = X_LOC_SEGMENT7,
2689 LOC_SEGMENT8 = X_LOC_SEGMENT8,
2690 LOC_SEGMENT9 = X_LOC_SEGMENT9,
2691 LOC_SEGMENT10 = X_LOC_SEGMENT10,
2692 LOC_SEGMENT11 = X_LOC_SEGMENT11,
2693 LAST_UPDATE_DATE = sysdate,
2694 LAST_UPDATED_BY = fnd_global.user_id,
2695 LAST_UPDATE_LOGIN = fnd_global.login_id
2696 where TRANSACTION_INTERFACE_ID = x_transaction_interface_id
2697 returning inventory_item_id INTO l_item_id;
2698
2699 IF l_item_id IS NULL THEN
2700 insert_row
2701 (l_rowid,
2702 x_transaction_interface_id,
2703 x_planning_organization_id,
2704 x_planning_tp_type,
2705 x_xfr_planning_organization_id,
2706 x_transfer_planning_tp_type,
2707 x_secondary_uom_code,
2708 x_secondary_transaction_quanti,
2709 x_transaction_group_id,
2710 x_transaction_group_seq,
2711 x_representative_lot_number,
2712 x_transaction_batch_id,
2713 x_transaction_batch_seq,
2714 x_rebuild_item_id,
2715 x_rebuild_serial_number,
2716 x_rebuild_activity_id,
2717 x_rebuild_job_name,
2718 x_move_transaction_id,
2719 x_completion_transaction_id,
2720 x_wip_supply_type,
2721 x_xfer_loc_segment6,
2722 x_xfer_loc_segment7,
2723 x_xfer_loc_segment8,
2724 x_xfer_loc_segment9,
2725 x_xfer_loc_segment10,
2726 x_xfer_loc_segment11,
2727 x_xfer_loc_segment12,
2728 x_xfer_loc_segment13,
2729 x_xfer_loc_segment14,
2730 x_xfer_loc_segment15,
2731 x_xfer_loc_segment16,
2732 x_xfer_loc_segment17,
2736 x_shipment_number,
2733 x_xfer_loc_segment18,
2734 x_xfer_loc_segment19,
2735 x_xfer_loc_segment20,
2737 x_transportation_cost,
2738 x_transportation_account,
2739 x_transfer_cost,
2740 x_freight_code,
2741 x_containers,
2742 x_waybill_airbill,
2743 x_expected_arrival_date,
2744 x_new_average_cost,
2745 x_value_change,
2746 x_percentage_change,
2747 x_demand_source_header_id,
2748 x_demand_source_line,
2749 x_demand_source_delivery,
2750 x_negative_req_flag,
2751 x_error_explanation,
2752 x_shippable_flag,
2753 x_required_flag,
2754 x_attribute_category,
2755 x_attribute1,
2756 x_attribute2,
2757 x_attribute3,
2758 x_attribute4,
2759 x_attribute5,
2760 x_attribute6,
2761 x_attribute7,
2762 x_attribute8,
2763 x_attribute9,
2764 x_attribute10,
2765 x_attribute11,
2766 x_attribute12,
2767 x_attribute13,
2768 x_attribute14,
2769 x_attribute15,
2770 x_requisition_distribution_id,
2771 x_movement_id,
2772 x_reservation_quantity,
2773 x_shipped_quantity,
2774 x_inventory_item,
2775 x_locator_name,
2776 x_task_id,
2777 x_to_task_id,
2778 x_source_task_id,
2779 x_project_id,
2780 x_to_project_id,
2781 x_source_project_id,
2782 x_pa_expenditure_org_id,
2783 x_expenditure_type,
2784 x_final_completion_flag,
2785 x_transfer_percentage,
2786 x_transaction_sequence_id,
2787 x_material_account,
2788 x_material_overhead_account,
2789 x_resource_account,
2790 x_outside_processing_account,
2791 x_overhead_account,
2792 x_bom_revision,
2793 x_routing_revision,
2794 x_bom_revision_date,
2795 x_routing_revision_date,
2796 x_alternate_bom_designator,
2797 x_alternate_routing_designator,
2798 x_accounting_class,
2799 x_demand_class,
2800 x_parent_id,
2801 x_substitution_type_id,
2802 x_substitution_item_id,
2803 x_schedule_group,
2804 x_build_sequence,
2805 x_schedule_number,
2806 x_scheduled_flag,
2807 x_flow_schedule,
2808 x_cost_group_id,
2809 x_kanban_card_id,
2810 x_qa_collection_id,
2811 x_overcompletion_transaction_q,
2812 x_overcompletion_primary_qty,
2813 x_overcompletion_transaction_i,
2814 x_end_item_unit_number,
2815 x_scheduled_payback_date,
2816 x_org_cost_group_id,
2817 x_cost_type_id,
2818 x_source_lot_number,
2819 x_transfer_cost_group_id,
2820 x_lpn_id,
2821 x_transfer_lpn_id,
2822 x_content_lpn_id,
2823 x_xml_document_id,
2824 x_organization_type,
2825 x_transfer_organization_type,
2826 x_owning_organization_id,
2827 x_owning_tp_type,
2828 x_xfr_owning_organization_id,
2829 x_transfer_owning_tp_type,
2830 x_loc_segment12,
2831 x_loc_segment13,
2832 x_loc_segment14,
2833 x_loc_segment15,
2834 x_loc_segment16,
2835 x_loc_segment17,
2836 x_loc_segment18,
2837 x_loc_segment19,
2838 x_loc_segment20,
2839 x_transaction_source_id,
2840 x_dsp_segment1,
2841 x_dsp_segment2,
2842 x_dsp_segment3,
2843 x_dsp_segment4,
2844 x_dsp_segment5,
2845 x_dsp_segment6,
2846 x_dsp_segment7,
2847 x_dsp_segment8,
2848 x_dsp_segment9,
2849 x_dsp_segment10,
2850 x_dsp_segment11,
2851 x_dsp_segment12,
2852 x_dsp_segment13,
2853 x_dsp_segment14,
2854 x_dsp_segment15,
2855 x_dsp_segment16,
2856 x_dsp_segment17,
2857 x_dsp_segment18,
2858 x_dsp_segment19,
2859 x_dsp_segment20,
2860 x_dsp_segment21,
2861 x_dsp_segment22,
2862 x_dsp_segment23,
2863 x_dsp_segment24,
2864 x_dsp_segment25,
2865 x_dsp_segment26,
2866 x_dsp_segment27,
2867 x_dsp_segment28,
2868 x_dsp_segment29,
2869 x_dsp_segment30,
2870 x_transaction_source_name,
2871 x_transaction_source_type_id,
2872 x_transaction_action_id,
2873 x_transaction_type_id,
2874 x_reason_id,
2875 x_transaction_reference,
2876 x_transaction_cost,
2877 x_distribution_account_id,
2878 x_dst_segment1,
2879 x_dst_segment2,
2880 x_dst_segment3,
2881 x_dst_segment4,
2882 x_dst_segment5,
2883 x_dst_segment6,
2884 x_dst_segment7,
2885 x_dst_segment8,
2886 x_dst_segment9,
2887 x_dst_segment10,
2888 x_dst_segment11,
2889 x_dst_segment12,
2890 x_dst_segment13,
2891 x_dst_segment14,
2892 x_dst_segment15,
2893 x_dst_segment16,
2894 x_dst_segment17,
2895 x_dst_segment18,
2896 x_dst_segment19,
2897 x_dst_segment20,
2898 x_dst_segment21,
2899 x_dst_segment22,
2900 x_dst_segment23,
2901 x_dst_segment24,
2902 x_dst_segment25,
2903 x_dst_segment26,
2904 x_dst_segment27,
2905 x_dst_segment28,
2906 x_dst_segment29,
2907 x_dst_segment30,
2908 x_requisition_line_id,
2909 x_currency_code,
2913 x_ussgl_transaction_code,
2910 x_currency_conversion_date,
2911 x_currency_conversion_type,
2912 x_currency_conversion_rate,
2914 x_wip_entity_type,
2915 x_schedule_id,
2916 x_employee_code,
2917 x_department_id,
2918 x_schedule_update_code,
2919 x_setup_teardown_code,
2920 x_primary_switch,
2921 x_mrp_code,
2922 x_operation_seq_num,
2923 x_repetitive_line_id,
2924 x_picking_line_id,
2925 x_trx_source_line_id,
2926 x_trx_source_delivery_id,
2927 x_demand_id,
2928 x_customer_ship_id,
2929 x_line_item_num,
2930 x_receiving_document,
2931 x_rcv_transaction_id,
2932 x_ship_to_location_id,
2933 x_encumbrance_account,
2934 x_encumbrance_amount,
2935 x_vendor_lot_number,
2936 x_transfer_subinventory,
2937 x_transfer_organization,
2938 x_transfer_locator,
2939 x_xfer_loc_segment1,
2940 x_xfer_loc_segment2,
2941 x_xfer_loc_segment3,
2942 x_xfer_loc_segment4,
2943 x_xfer_loc_segment5,
2944 x_transaction_header_id,
2945 x_source_code,
2946 x_source_line_id,
2947 x_source_header_id,
2948 x_process_flag,
2949 x_validation_required,
2950 x_transaction_mode,
2951 x_lock_flag,
2952 x_request_id,
2953 x_inventory_item_id,
2954 x_item_segment1,
2955 x_item_segment2,
2956 x_item_segment3,
2957 x_item_segment4,
2958 x_item_segment5,
2959 x_item_segment6,
2960 x_item_segment7,
2961 x_item_segment8,
2962 x_item_segment9,
2963 x_item_segment10,
2964 x_item_segment11,
2965 x_item_segment12,
2966 x_item_segment13,
2967 x_item_segment14,
2968 x_item_segment15,
2969 x_item_segment16,
2970 x_item_segment17,
2971 x_item_segment18,
2972 x_item_segment19,
2973 x_item_segment20,
2974 x_revision,
2975 x_organization_id,
2976 x_transaction_quantity,
2977 x_primary_quantity,
2978 x_transaction_uom,
2979 x_transaction_date,
2980 x_acct_period_id,
2981 x_subinventory_code,
2982 x_locator_id,
2983 x_loc_segment1,
2984 x_loc_segment2,
2985 x_loc_segment3,
2986 x_loc_segment4,
2987 x_loc_segment5,
2988 x_loc_segment6,
2989 x_loc_segment7,
2990 x_loc_segment8,
2991 x_loc_segment9,
2992 x_loc_segment10,
2993 x_loc_segment11,
2994 x_error_code,
2995 sysdate,
2996 fnd_global.user_id,
2997 sysdate,
2998 fnd_global.user_id,
2999 fnd_global.login_id
3000 );
3001
3002 END IF;
3003
3004
3005 --if (sql%notfound) then
3006 -- raise no_data_found;
3007 --end if;
3008
3009 end UPDATE_ROW;
3010
3011 procedure DELETE_ROW (
3012 X_TRANSACTION_INTERFACE_ID in NUMBER
3013 ) is
3014 begin
3015
3016 delete from MTL_TRANSACTIONS_INTERFACE
3017 where TRANSACTION_INTERFACE_ID = X_TRANSACTION_INTERFACE_ID;
3018
3019 if (sql%notfound) then
3020 raise no_data_found;
3021 end if;
3022 end DELETE_ROW;
3023
3024 end MTL_TXN_INTERFACE_PKG;
[Home] [Help]