[Home] [Help]
PACKAGE: APPS.GML_RCV_STD_RCPT_APIS
Source
1 PACKAGE gml_rcv_std_rcpt_apis AUTHID CURRENT_USER AS
2 /* $Header: GMLSTDRS.pls 120.0 2005/05/25 16:42:16 appldev noship $*/
3
4 g_header_intf_id NUMBER := NULL;
5
6 TYPE rcv_enter_receipts_rec_tp IS RECORD
7 (LINE_CHKBOX CHAR(1),
8 SOURCE_TYPE_CODE VARCHAR2(30),
9 RECEIPT_SOURCE_CODE VARCHAR2(30),
10 ORDER_TYPE_CODE VARCHAR2(30),
11 ORDER_TYPE VARCHAR2(80),
12 PO_HEADER_ID NUMBER,
13 PO_NUMBER VARCHAR2(30),
14 PO_LINE_ID NUMBER,
15 PO_LINE_NUMBER NUMBER,
16 PO_LINE_LOCATION_ID NUMBER,
17 PO_SHIPMENT_NUMBER NUMBER,
18 PO_RELEASE_ID NUMBER,
19 PO_RELEASE_NUMBER NUMBER,
20 REQ_HEADER_ID NUMBER,
21 REQ_NUMBER VARCHAR2(80),
22 REQ_LINE_ID NUMBER,
23 REQ_LINE NUMBER,
24 REQ_DISTRIBUTION_ID NUMBER,
25 RCV_SHIPMENT_HEADER_ID NUMBER,
26 RCV_SHIPMENT_NUMBER VARCHAR2(30),
27 RCV_SHIPMENT_LINE_ID NUMBER,
28 RCV_LINE_NUMBER NUMBER,
29 FROM_ORGANIZATION_ID NUMBER,
30 TO_ORGANIZATION_ID NUMBER,
31 VENDOR_ID NUMBER,
32 SOURCE VARCHAR2(255),
33 VENDOR_SITE_ID NUMBER,
34 OUTSIDE_OPERATION_FLAG VARCHAR2(1),
35 ITEM_ID NUMBER,
36 -- bug 2073164
37 -- Added extra column in the rec structure
38 UOM_CODE VARCHAR2(3),
39 PRIMARY_UOM VARCHAR2(25),
40 PRIMARY_UOM_CLASS VARCHAR2(10),
41 ITEM_ALLOWED_UNITS_LOOKUP_CODE NUMBER,
42 ITEM_LOCATOR_CONTROL NUMBER,
43 RESTRICT_LOCATORS_CODE VARCHAR2(1),
44 RESTRICT_SUBINVENTORIES_CODE VARCHAR2(1),
45 SHELF_LIFE_CODE NUMBER,
46 SHELF_LIFE_DAYS NUMBER,
47 SERIAL_NUMBER_CONTROL_CODE NUMBER,
48 LOT_CONTROL_CODE NUMBER,
49 ITEM_REV_CONTROL_FLAG_TO VARCHAR2(1),
50 ITEM_REV_CONTROL_FLAG_FROM VARCHAR2(1),
51 ITEM_NUMBER VARCHAR2(40),
52 ITEM_REVISION VARCHAR2(3),
53 ITEM_DESCRIPTION VARCHAR2(240),
54 ITEM_CATEGORY_ID NUMBER,
55 HAZARD_CLASS VARCHAR2(40),
56 UN_NUMBER VARCHAR2(30),
57 VENDOR_ITEM_NUMBER VARCHAR2(30),
58 SHIP_TO_LOCATION_ID NUMBER,
59 SHIP_TO_LOCATION VARCHAR2(60),
60 PACKING_SLIP VARCHAR2(80),
61 ROUTING_ID NUMBER,
62 ROUTING_NAME VARCHAR2(30),
63 NEED_BY_DATE DATE,
64 EXPECTED_RECEIPT_DATE DATE,
65 ORDERED_QTY NUMBER,
66 ORDERED_UOM VARCHAR2(25),
67 USSGL_TRANSACTION_CODE VARCHAR2(30),
68 GOVERNMENT_CONTEXT VARCHAR2(30),
69 INSPECTION_REQUIRED_FLAG VARCHAR2(1),
70 RECEIPT_REQUIRED_FLAG VARCHAR2(1),
71 ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2(30),
72 UNIT_PRICE NUMBER,
73 CURRENCY_CODE VARCHAR2(30),
74 CURRENCY_CONVERSION_TYPE VARCHAR2(30),
75 CURRENCY_CONVERSION_DATE DATE,
76 CURRENCY_CONVERSION_RATE NUMBER,
77 NOTE_TO_RECEIVER VARCHAR2(240),
78 DESTINATION_TYPE_CODE VARCHAR2(30),
79 DELIVER_TO_PERSON_ID NUMBER,
80 DELIVER_TO_LOCATION_ID NUMBER,
81 DESTINATION_SUBINVENTORY VARCHAR2(10),
82 ATTRIBUTE_CATEGORY VARCHAR2(30),
83 ATTRIBUTE1 VARCHAR2(240),
84 ATTRIBUTE2 VARCHAR2(240),
85 ATTRIBUTE3 VARCHAR2(240),
86 ATTRIBUTE4 VARCHAR2(240),
87 ATTRIBUTE5 VARCHAR2(240),
88 ATTRIBUTE6 VARCHAR2(240),
89 ATTRIBUTE7 VARCHAR2(240),
90 ATTRIBUTE8 VARCHAR2(240),
91 ATTRIBUTE9 VARCHAR2(240),
92 ATTRIBUTE10 VARCHAR2(240),
93 ATTRIBUTE11 VARCHAR2(240),
94 ATTRIBUTE12 VARCHAR2(240),
95 ATTRIBUTE13 VARCHAR2(240),
96 ATTRIBUTE14 VARCHAR2(240),
97 ATTRIBUTE15 VARCHAR2(240),
98 CLOSED_CODE VARCHAR2(30),
99 ASN_TYPE VARCHAR2(30),
100 BILL_OF_LADING VARCHAR2(30),
101 SHIPPED_DATE DATE,
102 FREIGHT_CARRIER_CODE VARCHAR2(30),
103 WAYBILL_AIRBILL_NUM VARCHAR2(80),
104 FREIGHT_BILL_NUM VARCHAR2(35),
105 VENDOR_LOT_NUM VARCHAR2(30),
106 CONTAINER_NUM VARCHAR2(35),
107 TRUCK_NUM VARCHAR2(35),
108 BAR_CODE_LABEL VARCHAR2(35),
109 RATE_TYPE_DISPLAY VARCHAR2(30),
110 MATCH_OPTION VARCHAR2(25),
111 COUNTRY_OF_ORIGIN_CODE VARCHAR2(2),
112 OE_ORDER_HEADER_ID NUMBER,
113 OE_ORDER_NUM NUMBER,
114 OE_ORDER_LINE_ID NUMBER,
115 OE_ORDER_LINE_NUM NUMBER,
116 CUSTOMER_ID NUMBER,
117 CUSTOMER_SITE_ID NUMBER,
118 CUSTOMER_ITEM_NUM VARCHAR2(50),
119 PLL_NOTE_TO_RECEIVER VARCHAR2(240),
120 -- ABOVE FIELDS ARE FROM RCV_ENTER_RECEIPTS_V
121 -- BELOW ARE MAINLY FROM PO_DISTRIBUTIONS
122 PO_DISTRIBUTION_ID NUMBER,
123 QTY_ORDERED NUMBER,
124 WIP_ENTITY_ID NUMBER,
125 WIP_OPERATION_SEQ_NUM NUMBER,
126 WIP_RESOURCE_SEQ_NUM NUMBER,
127 WIP_REPETITIVE_SCHEDULE_ID NUMBER,
128 WIP_LINE_ID NUMBER,
129 BOM_RESOURCE_ID NUMBER,
130 DESTINATION_TYPE VARCHAR2(80),
131 LOCATION VARCHAR2(60),
132 CURRENCY_CONVERSION_RATE_POD NUMBER,
133 CURRENCY_CONVERSION_DATE_POD DATE,
134 PROJECT_ID NUMBER,
135 TASK_ID NUMBER);
136
137
138
139 -- this is the record type for RCV_TRANSACTION Block
140 -- which includes DB items from RCV_ENTER_RECEIPTS_V
141 -- and NON-DB items
142 TYPE rcv_transaction_rec_tp IS RECORD
143 (LINE_CHKBOX CHAR(1)
144 , SOURCE_TYPE_CODE VARCHAR2(30)
145 , RECEIPT_SOURCE_CODE VARCHAR2(30)
146 , ORDER_TYPE_CODE VARCHAR2(30)
147 , ORDER_TYPE VARCHAR2(80)
148 , PO_HEADER_ID NUMBER
149 , PO_NUMBER VARCHAR2(30)
150 , PO_LINE_ID NUMBER
151 , PO_LINE_NUMBER NUMBER
152 , PO_LINE_LOCATION_ID NUMBER
153 , PO_SHIPMENT_NUMBER NUMBER
154 , PO_RELEASE_ID NUMBER
155 , PO_RELEASE_NUMBER NUMBER
156 , REQ_HEADER_ID NUMBER
157 , REQ_NUMBER VARCHAR2(80)
158 , REQ_LINE_ID NUMBER
159 , REQ_LINE NUMBER
160 , REQ_DISTRIBUTION_ID NUMBER
161 , RCV_SHIPMENT_HEADER_ID NUMBER
162 , RCV_SHIPMENT_NUMBER VARCHAR2(30)
163 , RCV_SHIPMENT_LINE_ID NUMBER
164 , RCV_LINE_NUMBER NUMBER
165 , FROM_ORGANIZATION_ID NUMBER
166 , TO_ORGANIZATION_ID NUMBER
167 , VENDOR_ID NUMBER
168 , SOURCE VARCHAR2(255)
169 , VENDOR_SITE_ID NUMBER
170 , OUTSIDE_OPERATION_FLAG VARCHAR2(1)
171 , ITEM_ID NUMBER
172 -- bug 2073164
173 -- Added extra column in the rec structure
174 , UOM_CODE VARCHAR2(3)
175 , PRIMARY_UOM VARCHAR2(25)
176 , PRIMARY_UOM_CLASS VARCHAR2(10)
177 , ITEM_ALLOWED_UNITS_LOOKUP_CODE NUMBER
178 , ITEM_LOCATOR_CONTROL NUMBER
179 , RESTRICT_LOCATORS_CODE VARCHAR2(1)
180 , RESTRICT_SUBINVENTORIES_CODE VARCHAR2(1)
181 , SHELF_LIFE_CODE NUMBER
182 , SHELF_LIFE_DAYS NUMBER
183 , SERIAL_NUMBER_CONTROL_CODE NUMBER
184 , LOT_CONTROL_CODE NUMBER
185 , ITEM_REV_CONTROL_FLAG_TO VARCHAR2(1)
186 , ITEM_REV_CONTROL_FLAG_FROM VARCHAR2(1)
187 , ITEM_NUMBER VARCHAR2(40)
188 , ITEM_REVISION VARCHAR2(3)
189 , ITEM_DESCRIPTION VARCHAR2(240)
190 , ITEM_CATEGORY_ID NUMBER
191 , HAZARD_CLASS VARCHAR2(40)
192 , UN_NUMBER VARCHAR2(30)
193 , VENDOR_ITEM_NUMBER VARCHAR2(30)
194 , SHIP_TO_LOCATION_ID NUMBER
195 , SHIP_TO_LOCATION VARCHAR2(60)
196 , PACKING_SLIP VARCHAR2(30)
197 , ROUTING_ID NUMBER
198 , ROUTING_NAME VARCHAR2(30)
199 , NEED_BY_DATE DATE
200 , EXPECTED_RECEIPT_DATE DATE
201 , ORDERED_QTY NUMBER
202 , ORDERED_UOM VARCHAR2(25)
203 , USSGL_TRANSACTION_CODE VARCHAR2(30)
204 , GOVERNMENT_CONTEXT VARCHAR2(30)
205 , INSPECTION_REQUIRED_FLAG VARCHAR2(1)
206 , RECEIPT_REQUIRED_FLAG VARCHAR2(1)
207 , ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2(30)
208 , UNIT_PRICE NUMBER
209 , CURRENCY_CODE VARCHAR2(15)
210 , CURRENCY_CONVERSION_TYPE VARCHAR2(30)
211 , CURRENCY_CONVERSION_DATE DATE
212 , CURRENCY_CONVERSION_RATE NUMBER
213 , NOTE_TO_RECEIVER VARCHAR2(240)
214 , DESTINATION_TYPE_CODE VARCHAR2(30)
215 , DELIVER_TO_PERSON_ID NUMBER
216 , DELIVER_TO_LOCATION_ID NUMBER
217 , DESTINATION_SUBINVENTORY VARCHAR2(10)
218 , ATTRIBUTE_CATEGORY VARCHAR2(30)
219 , ATTRIBUTE1 VARCHAR2(240)
220 , ATTRIBUTE2 VARCHAR2(240)
221 , ATTRIBUTE3 VARCHAR2(240)
222 , ATTRIBUTE4 VARCHAR2(240)
223 , ATTRIBUTE5 VARCHAR2(240)
224 , ATTRIBUTE6 VARCHAR2(240)
225 , ATTRIBUTE7 VARCHAR2(240)
226 , ATTRIBUTE8 VARCHAR2(240)
227 , ATTRIBUTE9 VARCHAR2(240)
228 , ATTRIBUTE10 VARCHAR2(240)
229 , ATTRIBUTE11 VARCHAR2(240)
230 , ATTRIBUTE12 VARCHAR2(240)
231 , ATTRIBUTE13 VARCHAR2(240)
232 , ATTRIBUTE14 VARCHAR2(240)
233 , ATTRIBUTE15 VARCHAR2(240)
234 , CLOSED_CODE VARCHAR2(30)
235 , ASN_TYPE VARCHAR2(30)
236 , BILL_OF_LADING VARCHAR2(30)
237 , SHIPPED_DATE DATE
238 , FREIGHT_CARRIER_CODE VARCHAR2(30)
239 , WAYBILL_AIRBILL_NUM VARCHAR2(80)
240 , FREIGHT_BILL_NUM VARCHAR2(35)
241 -- vendor_lot_num is defined as a non-db item in form
242 -- however seems it is queried from db only and never changed thereafter ?
243 , VENDOR_LOT_NUM VARCHAR2(30)
244 , CONTAINER_NUM VARCHAR2(35)
245 , TRUCK_NUM VARCHAR2(35)
246 , BAR_CODE_LABEL VARCHAR2(35)
247 , RATE_TYPE_DISPLAY VARCHAR2(30)
251 , OE_ORDER_NUM NUMBER
248 , MATCH_OPTION VARCHAR2(25)
249 , COUNTRY_OF_ORIGIN_CODE VARCHAR2(2)
250 , OE_ORDER_HEADER_ID NUMBER
252 , OE_ORDER_LINE_ID NUMBER
253 , OE_ORDER_LINE_NUM NUMBER
254 , CUSTOMER_ID NUMBER
255 , CUSTOMER_SITE_ID NUMBER
256 , CUSTOMER_ITEM_NUM VARCHAR2(50)
257 -- below are NON-DB Items
258 , interface_transaction_id NUMBER
259 , primary_quantity NUMBER
260 , transaction_qty NUMBER
261 , transaction_uom VARCHAR2(25)
262 , receipt_exception NUMBER
263 , comments VARCHAR2(240)
264 -- this field is set in receiving form ?
265 , reason_id NUMBER
266 , substitute_receipt VARCHAR2(30)
267 , original_item_id NUMBER
268 , locator_id NUMBER
269 , subinventory_dsp VARCHAR2(10)
270 , wip_entity_id NUMBER
271 , wip_line_id NUMBER
272 , department_code NUMBER
273 , wip_repetitive_schedule_id NUMBER
274 , wip_operation_seq_num NUMBER
275 , wip_resource_seq_num NUMBER
276 , bom_resource_id NUMBER
277 , destination_type_code_hold VARCHAR2(30)
278 , po_distribution_id NUMBER
279 , lpn_id NUMBER
280 , transfer_lpn_id NUMBER
281 , cost_group_id NUMBER
282 , transfer_cost_group_id NUMBER
283 , secondary_quantity NUMBER
284 , secondary_uom_code VARCHAR2(3)
285 , secondary_unit_of_measure VARCHAR2(25)
286 );
287
288
289
290 TYPE rcpt_lot_qty_rec IS RECORD
291 (lot_number VARCHAR2(30),
292 txn_quantity NUMBER);
293
294 TYPE rcpt_lot_qty_rec_tb_tp IS TABLE OF rcpt_lot_qty_rec
295 INDEX BY BINARY_INTEGER;
296
297
298 g_rcpt_lot_qty_rec_tb rcpt_lot_qty_rec_tb_tp;
299
300 g_shipment_header_id NUMBER := NULL;
301 g_rcpt_match_table_gross GML_RCV_TXN_INTERFACE.cascaded_trans_tab_type; -- input for matching algorithm
302 g_receipt_detail_index NUMBER := 1; -- index for the row needs to be detailed for matching
303
304 g_dummy_lpn_id NUMBER := NULL; -- dummy lpn_id for normal ASN receipt with the same from and to lpn
305
306
307 g_po_line_location_id NUMBER := 0; -- global variable for testing only ?
308 g_po_distribution_id NUMBER := 0;
309
310
311 /*******************************************************
312 * Name: create_std_rcpt_intf_rec
313 *
314 * Description:
315 *
316 * This API is a wrapper to create record in RCV_TRANSACTIONS_INTERFACE for
317 * different receipt transactions.
318 *
319 * This API takes PO_header_id or Shipment_header_id, item_id, received_qty,
320 * received_UOM, received_location as input. It calls the corresponding API
321 * for different txns (PO, Intransit, RMA, ASN, Int-req).
322 *
323 * The underlying APIs will call the matching algorithm API
324 * to detail the receipt to PO_line_locations.
325 * Then it calls insert API, insert_txn_interface, to inserts PO line
326 * location record into RCV_TRANSACTION_INTERFACE
327 *
328 * Flow:
329 *
330 * 1. query po_startup_value and other initial values
331 * 2. query RCV_ENTER_RECEIPTS_V to populate DB items in rcv_transaction block
332 * before calling matching algorithm
333 * 3. call matching algorithm to detail the receipt
334 * 4. call insert API
335 *
336 * Parameters:
337 *
338 * p_move_order_header_id
339 * p_organization_id
340 * p_shipment_header_id
341 * p_req_header_id
342 * p_po_header_id
343 * p_item_id
344 * p_location_id
345 * p_rcv_qty
346 * p_rcv_uom
347 * p_source_type
348 * p_from_lpn_id
349 * p_lpn_id
350 * p_lot_control_code
351 * p_revision
352 *
353 *******************************************************/
354
355
356 PROCEDURE create_std_rcpt_intf_rec(p_move_order_header_id IN OUT NOCOPY NUMBER,
357 p_organization_id IN NUMBER,
358 p_po_header_id IN NUMBER,
359 p_po_release_number_id IN NUMBER,
360 p_po_line_id IN NUMBER,
361 p_shipment_header_id IN NUMBER,
362 p_req_header_id IN NUMBER,
363 p_oe_order_header_id IN NUMBER,
364 p_item_id IN NUMBER,
365 p_location_id IN NUMBER,
366 p_rcv_qty IN NUMBER,
367 p_rcv_uom IN VARCHAR2,
368 p_rcv_uom_code IN VARCHAR2,
369 p_source_type IN VARCHAR2,
370 p_from_lpn_id IN NUMBER,
371 p_lpn_id IN NUMBER,
372 p_lot_control_code IN NUMBER,
373 p_revision IN VARCHAR2,
374 p_inspect IN NUMBER,
378 p_item_desc IN VARCHAR2 DEFAULT NULL,
375 x_status OUT NOCOPY VARCHAR2,
376 x_message OUT NOCOPY VARCHAR2,
377 p_inv_item_id IN NUMBER DEFAULT NULL,
379 p_project_id IN NUMBER DEFAULT NULL,
380 p_task_id IN NUMBER DEFAULT NULL,
381 p_country_code IN VARCHAR2 DEFAULT NULL
382 );
383
384
385 FUNCTION insert_txn_interface(
386 p_rcv_transaction_rec IN OUT NOCOPY rcv_transaction_rec_tp
387 , p_rcv_rcpt_rec IN OUT NOCOPY rcv_enter_receipts_rec_tp
388 , p_group_id IN NUMBER
389 , p_transaction_type IN VARCHAR2
390 , p_organization_id IN NUMBER
391 , p_location_id IN NUMBER
392 , p_source_type IN VARCHAR2
393 , p_qa_routing_id IN NUMBER DEFAULT -1
394 , p_project_id IN NUMBER DEFAULT NULL
395 , p_task_id IN NUMBER DEFAULT NULL
396 ) RETURN NUMBER;
397
398
399 PROCEDURE rcv_insert_update_header
400 (p_organization_id IN NUMBER,
401 p_shipment_header_id IN OUT NOCOPY NUMBER,
402 p_source_type IN VARCHAR2,
403 p_receipt_num IN OUT NOCOPY VARCHAR2,
404 p_vendor_id IN NUMBER,
405 p_vendor_site_id IN NUMBER,
406 p_shipment_num IN VARCHAR2,
407 p_ship_to_location_id IN NUMBER,
408 p_bill_of_lading IN VARCHAR2,
409 p_packing_slip IN VARCHAR2,
410 p_shipped_date IN DATE,
411 p_freight_carrier_code IN VARCHAR2,
412 p_expected_receipt_date IN DATE,
413 p_num_of_containers IN NUMBER,
414 p_waybill_airbill_num IN VARCHAR2,
415 p_comments IN VARCHAR2,
416 p_ussgl_transaction_code IN VARCHAR2,
417 p_government_context IN VARCHAR2,
418 p_request_id IN NUMBER,
419 p_program_application_id IN NUMBER,
420 p_program_id IN NUMBER,
421 p_program_update_date IN DATE,
422 p_customer_id IN NUMBER,
423 p_customer_site_id IN NUMBER,
424 x_return_status OUT NOCOPY VARCHAR2,
425 x_msg_count OUT NOCOPY NUMBER,
426 x_msg_data OUT NOCOPY VARCHAR2
427 );
428
429 /*
430 PROCEDURE rcv_insert_header_interface
431 (p_organization_id IN NUMBER,
432 p_source_type IN VARCHAR2,
433 p_receipt_num IN OUT NOCOPY VARCHAR2,
434 p_vendor_id IN NUMBER,
435 p_vendor_site_id IN NUMBER,
436 p_shipment_num IN VARCHAR2,
437 p_ship_to_location_id IN NUMBER,
438 p_bill_of_lading IN VARCHAR2,
439 p_packing_slip IN VARCHAR2,
440 p_shipped_date IN DATE,
441 p_freight_carrier_code IN VARCHAR2,
442 p_expected_receipt_date IN DATE,
443 p_num_of_containers IN NUMBER,
444 p_waybill_airbill_num IN VARCHAR2,
445 p_comments IN VARCHAR2,
446 p_ussgl_transaction_code IN VARCHAR2,
447 p_government_context IN VARCHAR2,
448 p_request_id IN NUMBER,
449 p_program_application_id IN NUMBER,
450 p_program_id IN NUMBER,
451 p_program_update_date IN DATE,
452 p_customer_id IN NUMBER,
453 p_customer_site_id IN NUMBER,
454 x_return_status OUT NOCOPY VARCHAR2,
455 x_msg_count OUT NOCOPY NUMBER,
456 x_msg_data OUT NOCOPY VARCHAR2
457 );
458 */
459
460 PROCEDURE rcv_update_rti_from_header
461 (p_shipment_num VARCHAR,
462 p_freight_carrier_code VARCHAR2,
463 p_bill_of_lading VARCHAR2,
464 p_packing_slip VARCHAR2,
465 p_num_of_containers NUMBER,
466 p_waybill_airbill_num VARCHAR2,
467 x_return_status OUT NOCOPY VARCHAR2,
468 x_msg_count OUT NOCOPY NUMBER,
469 x_msg_data OUT NOCOPY VARCHAR2);
470
471
472
473
474
475 PROCEDURE create_move_order(p_move_order_header_id IN OUT NOCOPY NUMBER,
476 p_po_line_location_id IN NUMBER,
477 p_po_distribution_id IN NUMBER,
478 p_shipment_line_id IN NUMBER,
479 p_oe_order_line_id IN NUMBER,
480 p_routing IN VARCHAR2,
481 p_lot_control_code IN NUMBER,
482 p_org_id IN NUMBER,
483 p_item_id IN NUMBER,
484 p_qty IN NUMBER,
485 p_uom_code IN VARCHAR2,
486 p_lpn IN NUMBER,
487 p_project_id IN NUMBER DEFAULT NULL,
488 p_task_id IN NUMBER DEFAULT NULL,
489 p_revision IN VARCHAR2 DEFAULT NULL,
490 p_inspect IN NUMBER,
491 p_txn_source_id IN NUMBER,
492 x_status OUT NOCOPY VARCHAR2,
493 x_message OUT NOCOPY VARCHAR2,
494 p_transfer_org_id IN NUMBER DEFAULT NULL,
498 PROCEDURE create_mo_for_correction(p_move_order_header_id IN OUT NOCOPY NUMBER,
495 p_wms_process_flag IN NUMBER DEFAULT NULL
496 );
497
499 p_po_line_location_id IN NUMBER DEFAULT NULL,
500 p_po_distribution_id IN NUMBER DEFAULT NULL,
501 p_shipment_line_id IN NUMBER DEFAULT NULL,
502 p_oe_order_line_id IN NUMBER DEFAULT NULL,
503 p_routing IN NUMBER,
504 p_lot_control_code IN NUMBER,
505 p_org_id IN NUMBER,
506 p_item_id IN NUMBER,
507 p_qty IN NUMBER,
508 p_uom_code IN VARCHAR2,
509 p_lpn IN NUMBER,
510 p_revision IN VARCHAR2 DEFAULT NULL,
511 p_inspect IN NUMBER,
512 p_txn_source_id IN NUMBER,
513 x_status OUT NOCOPY VARCHAR2,
514 x_message OUT NOCOPY VARCHAR2,
515 p_transfer_org_id IN NUMBER DEFAULT NULL,
516 p_wms_process_flag IN NUMBER DEFAULT NULL
517 );
518
519 PROCEDURE PackUnpack_Container
520 (p_api_version IN NUMBER ,
521 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
522 p_commit IN VARCHAR2 := fnd_api.g_false ,
523 x_return_status OUT NOCOPY VARCHAR2 ,
524 x_msg_count OUT NOCOPY NUMBER ,
525 x_msg_data OUT NOCOPY VARCHAR2 ,
526 p_from_lpn_id IN NUMBER := NULL ,
527 p_lpn_id IN NUMBER ,
528 p_content_lpn_id IN NUMBER := NULL ,
529 p_content_item_id IN NUMBER := NULL ,
530 p_content_item_desc IN VARCHAR2 := NULL ,
531 p_revision IN VARCHAR2 := NULL ,
532 p_lot_number IN VARCHAR2 := NULL ,
533 p_from_serial_number IN VARCHAR2 := NULL ,
534 p_to_serial_number IN VARCHAR2 := NULL ,
535 p_quantity IN NUMBER := NULL ,
536 p_uom IN VARCHAR2 := NULL ,
537 p_organization_id IN NUMBER ,
538 p_subinventory IN VARCHAR2 := NULL ,
539 p_locator_id IN NUMBER := NULL ,
540 p_enforce_wv_constraints IN NUMBER := 2 ,
541 p_operation IN NUMBER ,
542 p_cost_group_id IN NUMBER := NULL ,
543 p_source_type_id IN NUMBER := NULL ,
544 p_source_header_id IN NUMBER := NULL ,
545 p_source_name IN VARCHAR2 := NULL ,
546 p_source_line_id IN NUMBER := NULL ,
547 p_source_line_detail_id IN NUMBER := NULL ,
548 p_homogeneous_container IN NUMBER := 2 ,
549 p_match_locations IN NUMBER := 2 ,
550 p_match_lpn_context IN NUMBER := 2 ,
551 p_match_lot IN NUMBER := 2 ,
552 p_match_cost_groups IN NUMBER := 2 ,
553 p_match_mtl_status IN NUMBER := 2
554 );
555
556
557 PROCEDURE detect_ASN_discrepancy
558 (p_shipment_header_id NUMBER,
559 p_lpn_id NUMBER,
560 p_po_header_id NUMBER,
561 x_discrepancy_flag OUT NOCOPY NUMBER,
562 x_return_status OUT NOCOPY VARCHAR2,
563 x_msg_count OUT NOCOPY NUMBER,
564 x_msg_data OUT NOCOPY VARCHAR2
565 );
566
567
568 PROCEDURE transfer_lpn_contents
569 (p_to_lpn_id IN NUMBER,
570 x_return_status OUT NOCOPY VARCHAR2,
571 x_msg_count OUT NOCOPY NUMBER,
572 x_msg_data OUT NOCOPY VARCHAR2
573 );
574
575
576 -- Check if there are LPNs on this shipment
577 -- If there's LPN on this shipment, lpn_flag = 1, else lpn_flag = 0
578
579 PROCEDURE check_lpn_on_shipment
580 (p_shipment_number IN VARCHAR2,
581 p_from_organization_id IN NUMBER,
582 p_to_organization_id IN NUMBER,
583 x_lpn_flag OUT NOCOPY NUMBER,
584 x_return_status OUT NOCOPY VARCHAR2,
585 x_msg_count OUT NOCOPY NUMBER,
586 x_msg_data OUT NOCOPY VARCHAR2
587 );
588
589
590 -- Check if there are LPNs on this ASN
591 -- If there's LPN on this shipment, lpn_flag = 1, else lpn_flag = 0
592
593 PROCEDURE check_lpn_on_ASN
594 (p_shipment_header_id IN VARCHAR2,
595 x_lpn_flag OUT NOCOPY NUMBER,
596 x_return_status OUT NOCOPY VARCHAR2,
597 x_msg_count OUT NOCOPY NUMBER,
598 x_msg_data OUT NOCOPY VARCHAR2
599 );
600
601
602 PROCEDURE CHECK_LPN_ON_REQ (
603 p_req_num IN VARCHAR2,
604 x_lpn_flag OUT NOCOPY NUMBER,
605 x_return_status OUT NOCOPY VARCHAR2,
606 x_msg_count OUT NOCOPY NUMBER,
607 x_msg_data OUT NOCOPY VARCHAR2
608 );
609
610 PROCEDURE update_LPN_Org
611 (p_organization_id IN NUMBER,
612 p_lpn_id IN NUMBER,
613 x_return_status OUT NOCOPY VARCHAR2,
614 x_msg_count OUT NOCOPY NUMBER,
615 x_msg_data OUT NOCOPY VARCHAR2);
616
617 PROCEDURE remove_lpn_contents
618 (p_lpn_id IN NUMBER,
619 x_return_status OUT NOCOPY VARCHAR2,
620 x_msg_count OUT NOCOPY NUMBER,
621 x_msg_data OUT NOCOPY VARCHAR2,
622 p_routing_id IN NUMBER DEFAULT NULL
623 );
624
625
626 PROCEDURE clear_LPN_for_ship
627 (p_organization_id IN NUMBER,
628 p_shipment_header_id IN NUMBER,
629 x_return_status OUT NOCOPY VARCHAR2,
630 x_msg_count OUT NOCOPY NUMBER,
631 x_msg_data OUT NOCOPY VARCHAR2,
632 p_routing_id IN NUMBER DEFAULT NULL
633 );
634
635
636 PROCEDURE populate_lot_rec
637 (p_lot_number IN VARCHAR2,
638 p_primary_qty IN NUMBER,
639 p_txn_uom_code IN VARCHAR2,
640 p_org_id NUMBER,
641 p_item_id IN NUMBER);
642
643 END gml_rcv_std_rcpt_apis;