[Home] [Help]
PACKAGE BODY: APPS.RCV_ASN_INTERFACE_TRX_INS_PKG
Source
1 PACKAGE BODY RCV_ASN_INTERFACE_TRX_INS_PKG as
2 /* $Header: RCVTIR8B.pls 120.4.12010000.3 2008/10/09 17:58:00 vthevark ship $ */
3
4 PROCEDURE INSERT_ROW(X_ROWID IN OUT NOCOPY VARCHAR2,
5 X_INTERFACE_TRANSACTION_ID IN OUT NOCOPY NUMBER,
6 X_GROUP_ID IN NUMBER,
7 X_LAST_UPDATE_DATE IN DATE,
8 X_LAST_UPDATED_BY IN NUMBER,
9 X_CREATION_DATE IN DATE,
10 X_CREATED_BY IN NUMBER,
11 X_LAST_UPDATE_LOGIN IN NUMBER,
12 X_REQUEST_ID IN NUMBER,
13 X_PROGRAM_APPLICATION_ID IN NUMBER,
14 X_PROGRAM_ID IN NUMBER,
15 X_PROGRAM_UPDATE_DATE IN DATE,
16 X_TRANSACTION_TYPE IN VARCHAR2,
17 X_TRANSACTION_DATE IN DATE,
18 X_PROCESSING_STATUS_CODE IN VARCHAR2,
19 X_PROCESSING_MODE_CODE IN VARCHAR2,
20 X_PROCESSING_REQUEST_ID IN NUMBER,
21 X_TRANSACTION_STATUS_CODE IN VARCHAR2,
22 X_CATEGORY_ID IN NUMBER,
23 X_QUANTITY IN NUMBER,
24 X_UNIT_OF_MEASURE IN VARCHAR2,
25 X_INTERFACE_SOURCE_CODE IN VARCHAR2,
26 X_INTERFACE_SOURCE_LINE_ID IN NUMBER,
27 X_INV_TRANSACTION_ID IN NUMBER,
28 X_ITEM_ID IN NUMBER,
29 X_ITEM_DESCRIPTION IN VARCHAR2,
30 X_ITEM_REVISION IN VARCHAR2,
31 X_UOM_CODE IN VARCHAR2,
32 X_EMPLOYEE_ID IN NUMBER,
33 X_AUTO_TRANSACT_CODE IN VARCHAR2,
34 X_SHIPMENT_HEADER_ID IN NUMBER,
35 X_SHIPMENT_LINE_ID IN NUMBER,
36 X_SHIP_TO_LOCATION_ID IN NUMBER,
37 X_PRIMARY_QUANTITY IN NUMBER,
38 X_PRIMARY_UNIT_OF_MEASURE IN VARCHAR2,
39 X_RECEIPT_SOURCE_CODE IN VARCHAR2,
40 X_VENDOR_ID IN NUMBER,
41 X_VENDOR_SITE_ID IN NUMBER,
42 X_FROM_ORGANIZATION_ID IN NUMBER,
43 X_FROM_SUBINVENTORY IN VARCHAR2,
44 X_TO_ORGANIZATION_ID IN NUMBER,
45 X_INTRANSIT_OWNING_ORG_ID IN NUMBER,
46 X_ROUTING_HEADER_ID IN NUMBER,
47 X_ROUTING_STEP_ID IN NUMBER,
48 X_SOURCE_DOCUMENT_CODE IN VARCHAR2,
49 X_PARENT_TRANSACTION_ID IN NUMBER,
50 X_PO_HEADER_ID IN NUMBER,
51 X_PO_REVISION_NUM IN NUMBER,
52 X_PO_RELEASE_ID IN NUMBER,
53 X_PO_LINE_ID IN NUMBER,
54 X_PO_LINE_LOCATION_ID IN NUMBER,
55 X_PO_UNIT_PRICE IN NUMBER,
56 X_CURRENCY_CODE IN VARCHAR2,
57 X_CURRENCY_CONVERSION_TYPE IN VARCHAR2,
58 X_CURRENCY_CONVERSION_RATE IN NUMBER,
59 X_CURRENCY_CONVERSION_DATE IN DATE,
60 X_PO_DISTRIBUTION_ID IN NUMBER,
61 X_REQUISITION_LINE_ID IN NUMBER,
62 X_REQ_DISTRIBUTION_ID IN NUMBER,
63 X_CHARGE_ACCOUNT_ID IN NUMBER,
64 X_SUBSTITUTE_UNORDERED_CODE IN VARCHAR2,
65 X_RECEIPT_EXCEPTION_FLAG IN VARCHAR2,
66 X_ACCRUAL_STATUS_CODE IN VARCHAR2,
67 X_INSPECTION_STATUS_CODE IN VARCHAR2,
68 X_INSPECTION_QUALITY_CODE IN VARCHAR2,
69 X_DESTINATION_TYPE_CODE IN VARCHAR2,
70 X_DELIVER_TO_PERSON_ID IN NUMBER,
71 X_LOCATION_ID IN NUMBER,
72 X_DELIVER_TO_LOCATION_ID IN NUMBER,
73 X_SUBINVENTORY IN VARCHAR2,
74 X_LOCATOR_ID IN NUMBER,
75 X_WIP_ENTITY_ID IN NUMBER,
76 X_WIP_LINE_ID IN NUMBER,
77 X_DEPARTMENT_CODE IN VARCHAR2,
78 X_WIP_REPETITIVE_SCHEDULE_ID IN NUMBER,
79 X_WIP_OPERATION_SEQ_NUM IN NUMBER,
80 X_WIP_RESOURCE_SEQ_NUM IN NUMBER,
81 X_BOM_RESOURCE_ID IN NUMBER,
82 X_SHIPMENT_NUM IN VARCHAR2,
83 X_FREIGHT_CARRIER_CODE IN VARCHAR2,
84 X_BILL_OF_LADING IN VARCHAR2,
85 X_PACKING_SLIP IN VARCHAR2,
86 X_SHIPPED_DATE IN DATE,
87 X_EXPECTED_RECEIPT_DATE IN DATE,
88 X_ACTUAL_COST IN NUMBER,
89 X_TRANSFER_COST IN NUMBER,
90 X_TRANSPORTATION_COST IN NUMBER,
91 X_TRANSPORTATION_ACCOUNT_ID IN NUMBER,
92 X_NUM_OF_CONTAINERS IN NUMBER,
93 X_WAYBILL_AIRBILL_NUM IN VARCHAR2,
94 X_VENDOR_ITEM_NUM IN VARCHAR2,
95 X_VENDOR_LOT_NUM IN VARCHAR2,
96 X_RMA_REFERENCE IN VARCHAR2,
97 X_COMMENTS IN VARCHAR2,
98 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
99 X_ATTRIBUTE1 IN VARCHAR2,
100 X_ATTRIBUTE2 IN VARCHAR2,
101 X_ATTRIBUTE3 IN VARCHAR2,
102 X_ATTRIBUTE4 IN VARCHAR2,
103 X_ATTRIBUTE5 IN VARCHAR2,
104 X_ATTRIBUTE6 IN VARCHAR2,
105 X_ATTRIBUTE7 IN VARCHAR2,
106 X_ATTRIBUTE8 IN VARCHAR2,
107 X_ATTRIBUTE9 IN VARCHAR2,
108 X_ATTRIBUTE10 IN VARCHAR2,
109 X_ATTRIBUTE11 IN VARCHAR2,
110 X_ATTRIBUTE12 IN VARCHAR2,
111 X_ATTRIBUTE13 IN VARCHAR2,
112 X_ATTRIBUTE14 IN VARCHAR2,
113 X_ATTRIBUTE15 IN VARCHAR2,
114 X_SHIP_HEAD_ATTRIBUTE_CATEGORY IN VARCHAR2,
115 X_SHIP_HEAD_ATTRIBUTE1 IN VARCHAR2,
116 X_SHIP_HEAD_ATTRIBUTE2 IN VARCHAR2,
117 X_SHIP_HEAD_ATTRIBUTE3 IN VARCHAR2,
118 X_SHIP_HEAD_ATTRIBUTE4 IN VARCHAR2,
119 X_SHIP_HEAD_ATTRIBUTE5 IN VARCHAR2,
120 X_SHIP_HEAD_ATTRIBUTE6 IN VARCHAR2,
121 X_SHIP_HEAD_ATTRIBUTE7 IN VARCHAR2,
122 X_SHIP_HEAD_ATTRIBUTE8 IN VARCHAR2,
123 X_SHIP_HEAD_ATTRIBUTE9 IN VARCHAR2,
124 X_SHIP_HEAD_ATTRIBUTE10 IN VARCHAR2,
125 X_SHIP_HEAD_ATTRIBUTE11 IN VARCHAR2,
126 X_SHIP_HEAD_ATTRIBUTE12 IN VARCHAR2,
127 X_SHIP_HEAD_ATTRIBUTE13 IN VARCHAR2,
128 X_SHIP_HEAD_ATTRIBUTE14 IN VARCHAR2,
129 X_SHIP_HEAD_ATTRIBUTE15 IN VARCHAR2,
130 X_SHIP_LINE_ATTRIBUTE_CATEGORY IN VARCHAR2,
131 X_SHIP_LINE_ATTRIBUTE1 IN VARCHAR2,
132 X_SHIP_LINE_ATTRIBUTE2 IN VARCHAR2,
133 X_SHIP_LINE_ATTRIBUTE3 IN VARCHAR2,
134 X_SHIP_LINE_ATTRIBUTE4 IN VARCHAR2,
135 X_SHIP_LINE_ATTRIBUTE5 IN VARCHAR2,
136 X_SHIP_LINE_ATTRIBUTE6 IN VARCHAR2,
137 X_SHIP_LINE_ATTRIBUTE7 IN VARCHAR2,
138 X_SHIP_LINE_ATTRIBUTE8 IN VARCHAR2,
139 X_SHIP_LINE_ATTRIBUTE9 IN VARCHAR2,
140 X_SHIP_LINE_ATTRIBUTE10 IN VARCHAR2,
141 X_SHIP_LINE_ATTRIBUTE11 IN VARCHAR2,
142 X_SHIP_LINE_ATTRIBUTE12 IN VARCHAR2,
143 X_SHIP_LINE_ATTRIBUTE13 IN VARCHAR2,
144 X_SHIP_LINE_ATTRIBUTE14 IN VARCHAR2,
145 X_SHIP_LINE_ATTRIBUTE15 IN VARCHAR2,
146 X_USSGL_TRANSACTION_CODE IN VARCHAR2,
147 X_GOVERNMENT_CONTEXT IN VARCHAR2,
148 X_REASON_ID IN NUMBER,
149 X_DESTINATION_CONTEXT IN VARCHAR2,
150 X_SOURCE_DOC_QUANTITY IN NUMBER,
151 X_SOURCE_DOC_UNIT_OF_MEASURE IN VARCHAR2,
152 X_MOVEMENT_ID IN NUMBER,
153 X_HEADER_INTERFACE_ID IN NUMBER,
154 X_VENDOR_CUM_SHIPPED_QTY IN NUMBER,
155 X_ITEM_NUM IN VARCHAR2,
156 X_DOCUMENT_NUM IN VARCHAR2,
157 X_DOCUMENT_LINE_NUM IN NUMBER,
158 X_TRUCK_NUM IN VARCHAR2,
159 X_SHIP_TO_LOCATION_CODE IN VARCHAR2,
160 X_CONTAINER_NUM IN VARCHAR2,
161 X_SUBSTITUTE_ITEM_NUM IN VARCHAR2,
162 X_NOTICE_UNIT_PRICE IN NUMBER,
163 X_ITEM_CATEGORY IN VARCHAR2,
164 X_LOCATION_CODE IN VARCHAR2,
165 X_VENDOR_NAME IN VARCHAR2,
166 X_VENDOR_NUM IN VARCHAR2,
167 X_VENDOR_SITE_CODE IN VARCHAR2,
168 X_FROM_ORGANIZATION_CODE IN VARCHAR2,
169 X_TO_ORGANIZATION_CODE IN VARCHAR2,
170 X_INTRANSIT_OWNING_ORG_CODE IN VARCHAR2,
171 X_ROUTING_CODE IN VARCHAR2,
172 X_ROUTING_STEP IN VARCHAR2,
173 X_RELEASE_NUM IN NUMBER,
174 X_DOCUMENT_SHIPMENT_LINE_NUM IN NUMBER,
175 X_DOCUMENT_DISTRIBUTION_NUM IN NUMBER,
176 X_DELIVER_TO_PERSON_NAME IN VARCHAR2,
177 X_DELIVER_TO_LOCATION_CODE IN VARCHAR2,
178 X_USE_MTL_LOT IN NUMBER,
179 X_USE_MTL_SERIAL IN NUMBER,
180 X_LOCATOR IN VARCHAR2,
181 X_REASON_NAME IN VARCHAR2,
182 X_VALIDATION_FLAG IN VARCHAR2,
183 X_SUBSTITUTE_ITEM_ID IN NUMBER,
184 X_QUANTITY_SHIPPED IN NUMBER,
185 X_QUANTITY_INVOICED IN NUMBER,
186 X_TAX_NAME IN VARCHAR2,
187 X_TAX_AMOUNT IN NUMBER,
188 X_REQ_NUM IN VARCHAR2,
189 X_REQ_LINE_NUM IN NUMBER,
190 X_REQ_DISTRIBUTION_NUM IN NUMBER,
191 X_WIP_ENTITY_NAME IN VARCHAR2,
192 X_WIP_LINE_CODE IN VARCHAR2,
193 X_RESOURCE_CODE IN VARCHAR2,
194 X_SHIPMENT_LINE_STATUS_CODE IN VARCHAR2,
195 X_BARCODE_LABEL IN VARCHAR2,
196 X_COUNTRY_OF_ORIGIN_CODE IN VARCHAR2,
197 X_FROM_LOCATOR_ID IN NUMBER,
198 X_QA_COLLECTION_ID IN NUMBER,
199 X_OE_ORDER_HEADER_ID IN NUMBER,
200 X_OE_ORDER_LINE_ID IN NUMBER,
201 X_CUSTOMER_ID IN NUMBER,
202 X_CUSTOMER_SITE_ID IN NUMBER,
203 X_CUSTOMER_ITEM_NUM IN VARCHAR2,
204 X_CREATE_DEBIT_MEMO_FLAG IN VARCHAR2,
205 X_PUT_AWAY_RULE_ID IN NUMBER,
206 X_PUT_AWAY_STRATEGY_ID IN NUMBER,
207 X_LPN_ID IN NUMBER,
208 X_TRANSFER_LPN_ID IN NUMBER,
209 X_COST_GROUP_ID IN NUMBER,
210 X_MOBILE_TXN IN VARCHAR2,
211 X_MMTT_TEMP_ID IN NUMBER,
212 X_TRANSFER_COST_GROUP_ID IN NUMBER,
213 X_SECONDARY_QUANTITY IN NUMBER,
214 X_SECONDARY_UNIT_OF_MEASURE IN VARCHAR2,
215 X_SECONDARY_UOM_CODE IN VARCHAR2,
216 X_QC_GRADE IN VARCHAR2,
217 X_OE_ORDER_NUM IN NUMBER,
218 X_OE_ORDER_LINE_NUM IN NUMBER,
219 X_CUSTOMER_ACCOUNT_NUMBER IN NUMBER,
220 X_CUSTOMER_PARTY_NAME IN VARCHAR2,
221 X_SOURCE_TRANSACTION_NUM IN VARCHAR2,
222 X_PARENT_SOURCE_TXN_NUM IN VARCHAR2,
223 X_PARENT_INTERFACE_TXN_ID IN NUMBER,
224 X_CUSTOMER_ITEM_ID IN NUMBER,
225 X_INTERFACE_AVAIL_QTY IN NUMBER,
226 X_INTERFACE_TRANS_QTY IN NUMBER,
227 X_FROM_LOCATOR IN VARCHAR2,
228 X_LPN_GROUP_ID IN NUMBER,
229 X_ORDER_TRANSACTION_ID IN NUMBER,
230 X_LICENSE_PLATE_NUMBER IN VARCHAR2,
231 X_TFR_LICENSE_PLATE_NUMBER IN VARCHAR2,
232 X_AMOUNT IN NUMBER,
233 X_JOB_ID IN NUMBER,
234 X_PROJECT_ID IN NUMBER,
235 X_TASK_ID IN NUMBER,
236 X_ASN_ATTACH_ID IN NUMBER,
237 X_TIMECARD_ID IN NUMBER,
238 X_TIMECARD_OVN IN NUMBER,
239 X_INTERFACE_AVAIL_AMT IN NUMBER,
240 X_INTERFACE_TRANS_AMT IN NUMBER,
241 P_ORG_ID IN MO_GLOB_ORG_ACCESS_TMP.ORGANIZATION_ID%TYPE, --<R12 MOAC>
242 /* Added the following columns for complex work */
243 P_MATCHING_BASIS IN VARCHAR2 DEFAULT NULL ,
244 P_AMOUNT_SHIPPED IN NUMBER DEFAULT NULL,
245 P_REQUESTED_AMOUNT IN NUMBER DEFAULT NULL,
249 X_LCM_SHIPMENT_LINE_ID IN NUMBER DEFAULT NULL, -- lcm changes
246 P_MATERIAL_STORED_AMOUNT IN NUMBER DEFAULT NULL,
247 P_REPLENISH_ORDER_LINE_ID IN NUMBER DEFAULT NULL,
248 P_EXPRESS_TRANSACTION IN VARCHAR2 DEFAULT NULL,
250 X_UNIT_LANDED_COST IN NUMBER DEFAULT NULL -- lcm changes
251 ) IS
252 CURSOR C IS SELECT rowid FROM RCV_TRANSACTIONS_INTERFACE
253 WHERE interface_transaction_id = X_Interface_Transaction_Id;
254
255 CURSOR C2 IS SELECT rcv_transactions_interface_s.nextval FROM sys.dual;
256
257 BEGIN
258 if (X_Interface_Transaction_Id is NULL) then
259 OPEN C2;
260 FETCH C2 INTO X_Interface_Transaction_Id;
261 CLOSE C2;
262 end if;
263
264 INSERT INTO RCV_TRANSACTIONS_INTERFACE(
265 INTERFACE_TRANSACTION_ID,
266 GROUP_ID,
267 LAST_UPDATE_DATE,
268 LAST_UPDATED_BY,
269 CREATION_DATE,
270 CREATED_BY,
271 LAST_UPDATE_LOGIN,
272 REQUEST_ID,
273 PROGRAM_APPLICATION_ID,
274 PROGRAM_ID,
275 PROGRAM_UPDATE_DATE,
276 TRANSACTION_TYPE,
277 TRANSACTION_DATE,
278 PROCESSING_STATUS_CODE,
279 PROCESSING_MODE_CODE,
280 PROCESSING_REQUEST_ID,
281 TRANSACTION_STATUS_CODE,
282 CATEGORY_ID,
283 QUANTITY,
284 UNIT_OF_MEASURE,
285 INTERFACE_SOURCE_CODE,
286 INTERFACE_SOURCE_LINE_ID,
287 INV_TRANSACTION_ID,
288 ITEM_ID,
289 ITEM_DESCRIPTION,
290 ITEM_REVISION,
291 UOM_CODE,
292 EMPLOYEE_ID,
293 AUTO_TRANSACT_CODE,
294 SHIPMENT_HEADER_ID,
295 SHIPMENT_LINE_ID,
296 SHIP_TO_LOCATION_ID,
297 PRIMARY_QUANTITY,
298 PRIMARY_UNIT_OF_MEASURE,
299 RECEIPT_SOURCE_CODE,
300 VENDOR_ID,
301 VENDOR_SITE_ID,
302 FROM_ORGANIZATION_ID,
303 TO_ORGANIZATION_ID,
304 INTRANSIT_OWNING_ORG_ID,
305 ROUTING_HEADER_ID,
306 ROUTING_STEP_ID,
307 SOURCE_DOCUMENT_CODE,
308 PARENT_TRANSACTION_ID,
309 PO_HEADER_ID,
310 PO_REVISION_NUM,
311 PO_RELEASE_ID,
312 PO_LINE_ID,
313 PO_LINE_LOCATION_ID,
314 PO_UNIT_PRICE,
315 CURRENCY_CODE,
316 CURRENCY_CONVERSION_TYPE,
317 CURRENCY_CONVERSION_RATE,
318 CURRENCY_CONVERSION_DATE,
319 PO_DISTRIBUTION_ID,
320 REQUISITION_LINE_ID,
321 REQ_DISTRIBUTION_ID,
322 CHARGE_ACCOUNT_ID,
323 SUBSTITUTE_UNORDERED_CODE,
324 RECEIPT_EXCEPTION_FLAG,
325 ACCRUAL_STATUS_CODE,
326 INSPECTION_STATUS_CODE,
327 INSPECTION_QUALITY_CODE,
328 DESTINATION_TYPE_CODE,
329 DELIVER_TO_PERSON_ID,
330 LOCATION_ID,
331 DELIVER_TO_LOCATION_ID,
332 FROM_SUBINVENTORY,
333 SUBINVENTORY,
334 FROM_LOCATOR_ID,
335 LOCATOR_ID,
336 WIP_ENTITY_ID,
337 WIP_LINE_ID,
338 DEPARTMENT_CODE,
339 WIP_REPETITIVE_SCHEDULE_ID,
340 WIP_OPERATION_SEQ_NUM,
341 WIP_RESOURCE_SEQ_NUM,
342 BOM_RESOURCE_ID,
343 SHIPMENT_NUM,
344 FREIGHT_CARRIER_CODE,
345 BILL_OF_LADING,
346 PACKING_SLIP,
347 SHIPPED_DATE,
348 EXPECTED_RECEIPT_DATE,
349 ACTUAL_COST,
350 TRANSFER_COST,
351 TRANSPORTATION_COST,
352 TRANSPORTATION_ACCOUNT_ID,
353 NUM_OF_CONTAINERS,
354 WAYBILL_AIRBILL_NUM,
355 VENDOR_ITEM_NUM,
356 VENDOR_LOT_NUM,
357 RMA_REFERENCE,
358 COMMENTS,
359 ATTRIBUTE_CATEGORY,
360 ATTRIBUTE1,
361 ATTRIBUTE2,
362 ATTRIBUTE3,
363 ATTRIBUTE4,
364 ATTRIBUTE5,
368 ATTRIBUTE9,
365 ATTRIBUTE6,
366 ATTRIBUTE7,
367 ATTRIBUTE8,
369 ATTRIBUTE10,
370 ATTRIBUTE11,
371 ATTRIBUTE12,
372 ATTRIBUTE13,
373 ATTRIBUTE14,
374 ATTRIBUTE15,
375 SHIP_HEAD_ATTRIBUTE_CATEGORY,
376 SHIP_HEAD_ATTRIBUTE1,
377 SHIP_HEAD_ATTRIBUTE2,
378 SHIP_HEAD_ATTRIBUTE3,
379 SHIP_HEAD_ATTRIBUTE4,
380 SHIP_HEAD_ATTRIBUTE5,
381 SHIP_HEAD_ATTRIBUTE6,
382 SHIP_HEAD_ATTRIBUTE7,
383 SHIP_HEAD_ATTRIBUTE8,
384 SHIP_HEAD_ATTRIBUTE9,
385 SHIP_HEAD_ATTRIBUTE10,
386 SHIP_HEAD_ATTRIBUTE11,
387 SHIP_HEAD_ATTRIBUTE12,
388 SHIP_HEAD_ATTRIBUTE13,
389 SHIP_HEAD_ATTRIBUTE14,
390 SHIP_HEAD_ATTRIBUTE15,
391 SHIP_LINE_ATTRIBUTE_CATEGORY,
392 SHIP_LINE_ATTRIBUTE1,
393 SHIP_LINE_ATTRIBUTE2,
394 SHIP_LINE_ATTRIBUTE3,
395 SHIP_LINE_ATTRIBUTE4,
396 SHIP_LINE_ATTRIBUTE5,
397 SHIP_LINE_ATTRIBUTE6,
398 SHIP_LINE_ATTRIBUTE7,
399 SHIP_LINE_ATTRIBUTE8,
400 SHIP_LINE_ATTRIBUTE9,
401 SHIP_LINE_ATTRIBUTE10,
402 SHIP_LINE_ATTRIBUTE11,
403 SHIP_LINE_ATTRIBUTE12,
404 SHIP_LINE_ATTRIBUTE13,
405 SHIP_LINE_ATTRIBUTE14,
406 SHIP_LINE_ATTRIBUTE15,
407 USSGL_TRANSACTION_CODE,
408 GOVERNMENT_CONTEXT,
409 REASON_ID,
410 DESTINATION_CONTEXT,
411 SOURCE_DOC_QUANTITY,
412 SOURCE_DOC_UNIT_OF_MEASURE,
413 MOVEMENT_ID,
414 HEADER_INTERFACE_ID,
415 VENDOR_CUM_SHIPPED_QTY,
416 ITEM_NUM,
417 DOCUMENT_NUM,
418 DOCUMENT_LINE_NUM,
419 TRUCK_NUM,
420 SHIP_TO_LOCATION_CODE,
421 CONTAINER_NUM,
422 SUBSTITUTE_ITEM_NUM,
423 NOTICE_UNIT_PRICE,
424 ITEM_CATEGORY,
425 LOCATION_CODE,
426 VENDOR_NAME,
427 VENDOR_NUM,
428 VENDOR_SITE_CODE,
429 FROM_ORGANIZATION_CODE,
430 TO_ORGANIZATION_CODE,
431 INTRANSIT_OWNING_ORG_CODE,
432 ROUTING_CODE,
433 ROUTING_STEP,
434 RELEASE_NUM,
435 DOCUMENT_SHIPMENT_LINE_NUM,
436 DOCUMENT_DISTRIBUTION_NUM,
437 DELIVER_TO_PERSON_NAME,
438 DELIVER_TO_LOCATION_CODE,
439 USE_MTL_LOT,
440 USE_MTL_SERIAL,
441 LOCATOR,
442 REASON_NAME,
443 VALIDATION_FLAG,
444 SUBSTITUTE_ITEM_ID,
445 QUANTITY_SHIPPED,
446 QUANTITY_INVOICED,
447 TAX_NAME,
448 TAX_AMOUNT,
449 REQ_NUM,
450 REQ_LINE_NUM,
451 REQ_DISTRIBUTION_NUM,
452 WIP_ENTITY_NAME,
453 WIP_LINE_CODE,
454 RESOURCE_CODE,
455 SHIPMENT_LINE_STATUS_CODE,
456 BARCODE_LABEL,
457 COUNTRY_OF_ORIGIN_CODE,
458 QA_COLLECTION_ID,
459 OE_ORDER_HEADER_ID,
460 OE_ORDER_LINE_ID,
461 CUSTOMER_ID,
462 CUSTOMER_SITE_ID,
463 CUSTOMER_ITEM_NUM,
464 CREATE_DEBIT_MEMO_FLAG,
465 PUT_AWAY_RULE_ID,
466 PUT_AWAY_STRATEGY_ID,
467 LPN_ID,
468 TRANSFER_LPN_ID,
469 COST_GROUP_ID,
470 MOBILE_TXN,
471 MMTT_TEMP_ID,
472 TRANSFER_COST_GROUP_ID,
473 SECONDARY_QUANTITY,
474 SECONDARY_UNIT_OF_MEASURE,
475 SECONDARY_UOM_CODE,
476 QC_GRADE,
477 OE_ORDER_NUM,
478 OE_ORDER_LINE_NUM,
479 CUSTOMER_ACCOUNT_NUMBER,
480 CUSTOMER_PARTY_NAME,
481 SOURCE_TRANSACTION_NUM,
482 PARENT_SOURCE_TRANSACTION_NUM,
483 PARENT_INTERFACE_TXN_ID,
484 CUSTOMER_ITEM_ID,
485 INTERFACE_AVAILABLE_QTY,
489 ORDER_TRANSACTION_ID,
486 INTERFACE_TRANSACTION_QTY,
487 FROM_LOCATOR,
488 LPN_GROUP_ID,
490 LICENSE_PLATE_NUMBER,
491 TRANSFER_LICENSE_PLATE_NUMBER,
492 AMOUNT,
493 JOB_ID,
494 PROJECT_ID,
495 TASK_ID,
496 ASN_ATTACH_ID,
497 TIMECARD_ID,
498 TIMECARD_OVN,
499 INTERFACE_AVAILABLE_AMT,
500 INTERFACE_TRANSACTION_AMT,
501 ORG_ID, --<R12 MOAC>
502 MATCHING_BASIS ,
503 AMOUNT_SHIPPED ,
504 REQUESTED_AMOUNT,
505 MATERIAL_STORED_AMOUNT,
506 REPLENISH_ORDER_LINE_ID,
507 EXPRESS_TRANSACTION, --Bug 5550783
508 LCM_SHIPMENT_LINE_ID, -- lcm changes
509 UNIT_LANDED_COST -- lcm changes
510 )
511 VALUES (
512 X_INTERFACE_TRANSACTION_ID,
513 X_GROUP_ID,
514 X_LAST_UPDATE_DATE,
515 X_LAST_UPDATED_BY,
516 X_CREATION_DATE,
517 X_CREATED_BY,
518 X_LAST_UPDATE_LOGIN,
519 X_REQUEST_ID,
520 X_PROGRAM_APPLICATION_ID,
521 X_PROGRAM_ID,
522 X_PROGRAM_UPDATE_DATE,
523 X_TRANSACTION_TYPE,
524 X_TRANSACTION_DATE,
525 X_PROCESSING_STATUS_CODE,
526 X_PROCESSING_MODE_CODE,
527 X_PROCESSING_REQUEST_ID,
528 X_TRANSACTION_STATUS_CODE,
529 X_CATEGORY_ID,
530 X_QUANTITY,
531 X_UNIT_OF_MEASURE,
532 X_INTERFACE_SOURCE_CODE,
533 X_INTERFACE_SOURCE_LINE_ID,
534 X_INV_TRANSACTION_ID,
535 X_ITEM_ID,
536 X_ITEM_DESCRIPTION,
537 X_ITEM_REVISION,
538 X_UOM_CODE,
539 X_EMPLOYEE_ID,
540 X_AUTO_TRANSACT_CODE,
541 X_SHIPMENT_HEADER_ID,
542 X_SHIPMENT_LINE_ID,
543 X_SHIP_TO_LOCATION_ID,
544 X_PRIMARY_QUANTITY,
545 X_PRIMARY_UNIT_OF_MEASURE,
546 X_RECEIPT_SOURCE_CODE,
547 X_VENDOR_ID,
548 X_VENDOR_SITE_ID,
549 X_FROM_ORGANIZATION_ID,
550 X_TO_ORGANIZATION_ID,
551 X_INTRANSIT_OWNING_ORG_ID,
552 X_ROUTING_HEADER_ID,
553 X_ROUTING_STEP_ID,
554 X_SOURCE_DOCUMENT_CODE,
555 X_PARENT_TRANSACTION_ID,
556 X_PO_HEADER_ID,
557 X_PO_REVISION_NUM,
558 X_PO_RELEASE_ID,
559 X_PO_LINE_ID,
560 X_PO_LINE_LOCATION_ID,
561 X_PO_UNIT_PRICE,
562 X_CURRENCY_CODE,
563 X_CURRENCY_CONVERSION_TYPE,
564 X_CURRENCY_CONVERSION_RATE,
565 X_CURRENCY_CONVERSION_DATE,
566 X_PO_DISTRIBUTION_ID,
567 X_REQUISITION_LINE_ID,
568 X_REQ_DISTRIBUTION_ID,
569 X_CHARGE_ACCOUNT_ID,
570 X_SUBSTITUTE_UNORDERED_CODE,
571 X_RECEIPT_EXCEPTION_FLAG,
572 X_ACCRUAL_STATUS_CODE,
573 X_INSPECTION_STATUS_CODE,
574 X_INSPECTION_QUALITY_CODE,
575 X_DESTINATION_TYPE_CODE,
576 X_DELIVER_TO_PERSON_ID,
577 X_LOCATION_ID,
578 X_DELIVER_TO_LOCATION_ID,
579 X_FROM_SUBINVENTORY,
580 X_SUBINVENTORY,
581 X_FROM_LOCATOR_ID,
582 X_LOCATOR_ID,
583 X_WIP_ENTITY_ID,
584 X_WIP_LINE_ID,
585 X_DEPARTMENT_CODE,
586 X_WIP_REPETITIVE_SCHEDULE_ID,
587 X_WIP_OPERATION_SEQ_NUM,
588 X_WIP_RESOURCE_SEQ_NUM,
589 X_BOM_RESOURCE_ID,
590 X_SHIPMENT_NUM,
591 X_FREIGHT_CARRIER_CODE,
592 X_BILL_OF_LADING,
593 X_PACKING_SLIP,
594 X_SHIPPED_DATE,
595 X_EXPECTED_RECEIPT_DATE,
596 X_ACTUAL_COST,
597 X_TRANSFER_COST,
598 X_TRANSPORTATION_COST,
599 X_TRANSPORTATION_ACCOUNT_ID,
600 X_NUM_OF_CONTAINERS,
601 X_WAYBILL_AIRBILL_NUM,
602 X_VENDOR_ITEM_NUM,
603 X_VENDOR_LOT_NUM,
604 X_RMA_REFERENCE,
605 X_COMMENTS,
606 X_ATTRIBUTE_CATEGORY,
607 X_ATTRIBUTE1,
608 X_ATTRIBUTE2,
609 X_ATTRIBUTE3,
610 X_ATTRIBUTE4,
611 X_ATTRIBUTE5,
612 X_ATTRIBUTE6,
616 X_ATTRIBUTE10,
613 X_ATTRIBUTE7,
614 X_ATTRIBUTE8,
615 X_ATTRIBUTE9,
617 X_ATTRIBUTE11,
618 X_ATTRIBUTE12,
619 X_ATTRIBUTE13,
620 X_ATTRIBUTE14,
621 X_ATTRIBUTE15,
622 X_SHIP_HEAD_ATTRIBUTE_CATEGORY,
623 X_SHIP_HEAD_ATTRIBUTE1,
624 X_SHIP_HEAD_ATTRIBUTE2,
625 X_SHIP_HEAD_ATTRIBUTE3,
626 X_SHIP_HEAD_ATTRIBUTE4,
627 X_SHIP_HEAD_ATTRIBUTE5,
628 X_SHIP_HEAD_ATTRIBUTE6,
629 X_SHIP_HEAD_ATTRIBUTE7,
630 X_SHIP_HEAD_ATTRIBUTE8,
631 X_SHIP_HEAD_ATTRIBUTE9,
632 X_SHIP_HEAD_ATTRIBUTE10,
633 X_SHIP_HEAD_ATTRIBUTE11,
634 X_SHIP_HEAD_ATTRIBUTE12,
635 X_SHIP_HEAD_ATTRIBUTE13,
636 X_SHIP_HEAD_ATTRIBUTE14,
637 X_SHIP_HEAD_ATTRIBUTE15,
638 X_SHIP_LINE_ATTRIBUTE_CATEGORY,
639 X_SHIP_LINE_ATTRIBUTE1,
640 X_SHIP_LINE_ATTRIBUTE2,
641 X_SHIP_LINE_ATTRIBUTE3,
642 X_SHIP_LINE_ATTRIBUTE4,
643 X_SHIP_LINE_ATTRIBUTE5,
644 X_SHIP_LINE_ATTRIBUTE6,
645 X_SHIP_LINE_ATTRIBUTE7,
646 X_SHIP_LINE_ATTRIBUTE8,
647 X_SHIP_LINE_ATTRIBUTE9,
648 X_SHIP_LINE_ATTRIBUTE10,
649 X_SHIP_LINE_ATTRIBUTE11,
650 X_SHIP_LINE_ATTRIBUTE12,
651 X_SHIP_LINE_ATTRIBUTE13,
652 X_SHIP_LINE_ATTRIBUTE14,
653 X_SHIP_LINE_ATTRIBUTE15,
654 X_USSGL_TRANSACTION_CODE,
655 X_GOVERNMENT_CONTEXT,
656 X_REASON_ID,
657 X_DESTINATION_CONTEXT,
658 X_SOURCE_DOC_QUANTITY,
659 X_SOURCE_DOC_UNIT_OF_MEASURE,
660 X_MOVEMENT_ID,
661 X_HEADER_INTERFACE_ID,
662 X_VENDOR_CUM_SHIPPED_QTY,
663 X_ITEM_NUM,
664 X_DOCUMENT_NUM,
665 X_DOCUMENT_LINE_NUM,
666 X_TRUCK_NUM,
667 X_SHIP_TO_LOCATION_CODE,
668 X_CONTAINER_NUM,
669 X_SUBSTITUTE_ITEM_NUM,
670 X_NOTICE_UNIT_PRICE,
671 X_ITEM_CATEGORY,
672 X_LOCATION_CODE,
673 X_VENDOR_NAME,
674 X_VENDOR_NUM,
675 X_VENDOR_SITE_CODE,
676 X_FROM_ORGANIZATION_CODE,
677 X_TO_ORGANIZATION_CODE,
678 X_INTRANSIT_OWNING_ORG_CODE,
679 X_ROUTING_CODE,
680 X_ROUTING_STEP,
681 X_RELEASE_NUM,
682 X_DOCUMENT_SHIPMENT_LINE_NUM,
683 X_DOCUMENT_DISTRIBUTION_NUM,
684 X_DELIVER_TO_PERSON_NAME,
685 X_DELIVER_TO_LOCATION_CODE,
686 X_USE_MTL_LOT,
687 X_USE_MTL_SERIAL,
688 X_LOCATOR,
689 X_REASON_NAME,
690 X_VALIDATION_FLAG,
691 X_SUBSTITUTE_ITEM_ID,
692 X_QUANTITY_SHIPPED,
693 X_QUANTITY_INVOICED,
694 X_TAX_NAME,
695 X_TAX_AMOUNT,
696 X_REQ_NUM,
697 X_REQ_LINE_NUM,
698 X_REQ_DISTRIBUTION_NUM,
699 X_WIP_ENTITY_NAME,
700 X_WIP_LINE_CODE,
701 X_RESOURCE_CODE,
702 X_SHIPMENT_LINE_STATUS_CODE,
703 X_BARCODE_LABEL,
704 X_COUNTRY_OF_ORIGIN_CODE,
705 X_QA_COLLECTION_ID,
706 X_OE_ORDER_HEADER_ID,
707 X_OE_ORDER_LINE_ID,
708 X_CUSTOMER_ID,
709 X_CUSTOMER_SITE_ID,
710 X_CUSTOMER_ITEM_NUM,
711 X_CREATE_DEBIT_MEMO_FLAG,
712 X_PUT_AWAY_RULE_ID,
713 X_PUT_AWAY_STRATEGY_ID,
714 X_LPN_ID,
715 X_TRANSFER_LPN_ID,
716 X_COST_GROUP_ID,
717 X_MOBILE_TXN,
718 X_MMTT_TEMP_ID,
719 X_TRANSFER_COST_GROUP_ID,
720 X_SECONDARY_QUANTITY,
721 X_SECONDARY_UNIT_OF_MEASURE,
722 X_SECONDARY_UOM_CODE,
723 X_QC_GRADE,
724 X_OE_ORDER_NUM,
725 X_OE_ORDER_LINE_NUM,
726 X_CUSTOMER_ACCOUNT_NUMBER,
727 X_CUSTOMER_PARTY_NAME,
728 X_SOURCE_TRANSACTION_NUM,
729 X_PARENT_SOURCE_TXN_NUM,
730 X_PARENT_INTERFACE_TXN_ID,
731 X_CUSTOMER_ITEM_ID,
732 X_INTERFACE_AVAIL_QTY,
733 X_INTERFACE_TRANS_QTY,
734 X_FROM_LOCATOR,
735 X_LPN_GROUP_ID,
736 X_ORDER_TRANSACTION_ID,
737 X_LICENSE_PLATE_NUMBER,
738 X_TFR_LICENSE_PLATE_NUMBER,
739 X_AMOUNT,
740 X_JOB_ID,
741 X_PROJECT_ID,
742 X_TASK_ID,
743 X_ASN_ATTACH_ID,
744 X_TIMECARD_ID,
745 X_TIMECARD_OVN,
746 X_INTERFACE_AVAIL_AMT,
747 X_INTERFACE_TRANS_AMT,
748 P_ORG_ID, --<R12 MOAC>
749 /* Added the following columns for complex work */
750 P_MATCHING_BASIS ,
751 P_AMOUNT_SHIPPED ,
752 P_REQUESTED_AMOUNT ,
753 P_MATERIAL_STORED_AMOUNT,
754 P_REPLENISH_ORDER_LINE_ID,
755 P_EXPRESS_TRANSACTION, --Bug 5550783
756 X_LCM_SHIPMENT_LINE_ID, -- lcm changes
757 X_UNIT_LANDED_COST -- lcm changes
758 );
759
760 OPEN C;
761 FETCH C INTO X_Rowid;
762 if (C%NOTFOUND) then
763 CLOSE C;
764 Raise NO_DATA_FOUND;
765 end if;
766 CLOSE C;
767 END INSERT_ROW;
768 END RCV_ASN_INTERFACE_TRX_INS_PKG;