[Home] [Help]
269:
270: TYPE xfer_rec_typ IS RECORD
271: (
272: action_code NUMBER(2)
273: , transfer_no ic_xfer_mst.transfer_no%TYPE
274: , orgn_code ic_xfer_mst.orgn_code%TYPE
275: , item_no ic_item_mst.item_no%TYPE
276: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
277: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
270: TYPE xfer_rec_typ IS RECORD
271: (
272: action_code NUMBER(2)
273: , transfer_no ic_xfer_mst.transfer_no%TYPE
274: , orgn_code ic_xfer_mst.orgn_code%TYPE
275: , item_no ic_item_mst.item_no%TYPE
276: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
277: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
278: , release_reason_code ic_xfer_mst.release_reason_code%TYPE DEFAULT NULL
274: , orgn_code ic_xfer_mst.orgn_code%TYPE
275: , item_no ic_item_mst.item_no%TYPE
276: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
277: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
278: , release_reason_code ic_xfer_mst.release_reason_code%TYPE DEFAULT NULL
279: , receive_reason_code ic_xfer_mst.receive_reason_code%TYPE DEFAULT NULL
280: , cancel_reason_code ic_xfer_mst.cancel_reason_code%TYPE DEFAULT NULL
281: , from_warehouse ic_xfer_mst.from_warehouse%TYPE DEFAULT NULL
282: , from_location ic_xfer_mst.from_location%TYPE DEFAULT NULL
275: , item_no ic_item_mst.item_no%TYPE
276: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
277: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
278: , release_reason_code ic_xfer_mst.release_reason_code%TYPE DEFAULT NULL
279: , receive_reason_code ic_xfer_mst.receive_reason_code%TYPE DEFAULT NULL
280: , cancel_reason_code ic_xfer_mst.cancel_reason_code%TYPE DEFAULT NULL
281: , from_warehouse ic_xfer_mst.from_warehouse%TYPE DEFAULT NULL
282: , from_location ic_xfer_mst.from_location%TYPE DEFAULT NULL
283: , to_warehouse ic_xfer_mst.to_warehouse%TYPE DEFAULT NULL
276: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
277: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
278: , release_reason_code ic_xfer_mst.release_reason_code%TYPE DEFAULT NULL
279: , receive_reason_code ic_xfer_mst.receive_reason_code%TYPE DEFAULT NULL
280: , cancel_reason_code ic_xfer_mst.cancel_reason_code%TYPE DEFAULT NULL
281: , from_warehouse ic_xfer_mst.from_warehouse%TYPE DEFAULT NULL
282: , from_location ic_xfer_mst.from_location%TYPE DEFAULT NULL
283: , to_warehouse ic_xfer_mst.to_warehouse%TYPE DEFAULT NULL
284: , to_location ic_xfer_mst.to_location%TYPE DEFAULT NULL
277: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
278: , release_reason_code ic_xfer_mst.release_reason_code%TYPE DEFAULT NULL
279: , receive_reason_code ic_xfer_mst.receive_reason_code%TYPE DEFAULT NULL
280: , cancel_reason_code ic_xfer_mst.cancel_reason_code%TYPE DEFAULT NULL
281: , from_warehouse ic_xfer_mst.from_warehouse%TYPE DEFAULT NULL
282: , from_location ic_xfer_mst.from_location%TYPE DEFAULT NULL
283: , to_warehouse ic_xfer_mst.to_warehouse%TYPE DEFAULT NULL
284: , to_location ic_xfer_mst.to_location%TYPE DEFAULT NULL
285: , release_quantity1 ic_xfer_mst.release_quantity1%TYPE DEFAULT 0
278: , release_reason_code ic_xfer_mst.release_reason_code%TYPE DEFAULT NULL
279: , receive_reason_code ic_xfer_mst.receive_reason_code%TYPE DEFAULT NULL
280: , cancel_reason_code ic_xfer_mst.cancel_reason_code%TYPE DEFAULT NULL
281: , from_warehouse ic_xfer_mst.from_warehouse%TYPE DEFAULT NULL
282: , from_location ic_xfer_mst.from_location%TYPE DEFAULT NULL
283: , to_warehouse ic_xfer_mst.to_warehouse%TYPE DEFAULT NULL
284: , to_location ic_xfer_mst.to_location%TYPE DEFAULT NULL
285: , release_quantity1 ic_xfer_mst.release_quantity1%TYPE DEFAULT 0
286: , release_quantity2 ic_xfer_mst.release_quantity2%TYPE DEFAULT 0
279: , receive_reason_code ic_xfer_mst.receive_reason_code%TYPE DEFAULT NULL
280: , cancel_reason_code ic_xfer_mst.cancel_reason_code%TYPE DEFAULT NULL
281: , from_warehouse ic_xfer_mst.from_warehouse%TYPE DEFAULT NULL
282: , from_location ic_xfer_mst.from_location%TYPE DEFAULT NULL
283: , to_warehouse ic_xfer_mst.to_warehouse%TYPE DEFAULT NULL
284: , to_location ic_xfer_mst.to_location%TYPE DEFAULT NULL
285: , release_quantity1 ic_xfer_mst.release_quantity1%TYPE DEFAULT 0
286: , release_quantity2 ic_xfer_mst.release_quantity2%TYPE DEFAULT 0
287: , release_uom1 ic_xfer_mst.release_uom1%TYPE
280: , cancel_reason_code ic_xfer_mst.cancel_reason_code%TYPE DEFAULT NULL
281: , from_warehouse ic_xfer_mst.from_warehouse%TYPE DEFAULT NULL
282: , from_location ic_xfer_mst.from_location%TYPE DEFAULT NULL
283: , to_warehouse ic_xfer_mst.to_warehouse%TYPE DEFAULT NULL
284: , to_location ic_xfer_mst.to_location%TYPE DEFAULT NULL
285: , release_quantity1 ic_xfer_mst.release_quantity1%TYPE DEFAULT 0
286: , release_quantity2 ic_xfer_mst.release_quantity2%TYPE DEFAULT 0
287: , release_uom1 ic_xfer_mst.release_uom1%TYPE
288: , release_uom2 ic_xfer_mst.release_uom2%TYPE
281: , from_warehouse ic_xfer_mst.from_warehouse%TYPE DEFAULT NULL
282: , from_location ic_xfer_mst.from_location%TYPE DEFAULT NULL
283: , to_warehouse ic_xfer_mst.to_warehouse%TYPE DEFAULT NULL
284: , to_location ic_xfer_mst.to_location%TYPE DEFAULT NULL
285: , release_quantity1 ic_xfer_mst.release_quantity1%TYPE DEFAULT 0
286: , release_quantity2 ic_xfer_mst.release_quantity2%TYPE DEFAULT 0
287: , release_uom1 ic_xfer_mst.release_uom1%TYPE
288: , release_uom2 ic_xfer_mst.release_uom2%TYPE
289: , receive_quantity1 ic_xfer_mst.receive_quantity1%TYPE DEFAULT 0
282: , from_location ic_xfer_mst.from_location%TYPE DEFAULT NULL
283: , to_warehouse ic_xfer_mst.to_warehouse%TYPE DEFAULT NULL
284: , to_location ic_xfer_mst.to_location%TYPE DEFAULT NULL
285: , release_quantity1 ic_xfer_mst.release_quantity1%TYPE DEFAULT 0
286: , release_quantity2 ic_xfer_mst.release_quantity2%TYPE DEFAULT 0
287: , release_uom1 ic_xfer_mst.release_uom1%TYPE
288: , release_uom2 ic_xfer_mst.release_uom2%TYPE
289: , receive_quantity1 ic_xfer_mst.receive_quantity1%TYPE DEFAULT 0
290: , receive_quantity2 ic_xfer_mst.receive_quantity2%TYPE DEFAULT 0
283: , to_warehouse ic_xfer_mst.to_warehouse%TYPE DEFAULT NULL
284: , to_location ic_xfer_mst.to_location%TYPE DEFAULT NULL
285: , release_quantity1 ic_xfer_mst.release_quantity1%TYPE DEFAULT 0
286: , release_quantity2 ic_xfer_mst.release_quantity2%TYPE DEFAULT 0
287: , release_uom1 ic_xfer_mst.release_uom1%TYPE
288: , release_uom2 ic_xfer_mst.release_uom2%TYPE
289: , receive_quantity1 ic_xfer_mst.receive_quantity1%TYPE DEFAULT 0
290: , receive_quantity2 ic_xfer_mst.receive_quantity2%TYPE DEFAULT 0
291: , scheduled_release_date ic_xfer_mst.scheduled_release_date%TYPE
284: , to_location ic_xfer_mst.to_location%TYPE DEFAULT NULL
285: , release_quantity1 ic_xfer_mst.release_quantity1%TYPE DEFAULT 0
286: , release_quantity2 ic_xfer_mst.release_quantity2%TYPE DEFAULT 0
287: , release_uom1 ic_xfer_mst.release_uom1%TYPE
288: , release_uom2 ic_xfer_mst.release_uom2%TYPE
289: , receive_quantity1 ic_xfer_mst.receive_quantity1%TYPE DEFAULT 0
290: , receive_quantity2 ic_xfer_mst.receive_quantity2%TYPE DEFAULT 0
291: , scheduled_release_date ic_xfer_mst.scheduled_release_date%TYPE
292: , actual_release_date ic_xfer_mst.actual_release_date%TYPE
285: , release_quantity1 ic_xfer_mst.release_quantity1%TYPE DEFAULT 0
286: , release_quantity2 ic_xfer_mst.release_quantity2%TYPE DEFAULT 0
287: , release_uom1 ic_xfer_mst.release_uom1%TYPE
288: , release_uom2 ic_xfer_mst.release_uom2%TYPE
289: , receive_quantity1 ic_xfer_mst.receive_quantity1%TYPE DEFAULT 0
290: , receive_quantity2 ic_xfer_mst.receive_quantity2%TYPE DEFAULT 0
291: , scheduled_release_date ic_xfer_mst.scheduled_release_date%TYPE
292: , actual_release_date ic_xfer_mst.actual_release_date%TYPE
293: , scheduled_receive_date ic_xfer_mst.scheduled_receive_date%TYPE
286: , release_quantity2 ic_xfer_mst.release_quantity2%TYPE DEFAULT 0
287: , release_uom1 ic_xfer_mst.release_uom1%TYPE
288: , release_uom2 ic_xfer_mst.release_uom2%TYPE
289: , receive_quantity1 ic_xfer_mst.receive_quantity1%TYPE DEFAULT 0
290: , receive_quantity2 ic_xfer_mst.receive_quantity2%TYPE DEFAULT 0
291: , scheduled_release_date ic_xfer_mst.scheduled_release_date%TYPE
292: , actual_release_date ic_xfer_mst.actual_release_date%TYPE
293: , scheduled_receive_date ic_xfer_mst.scheduled_receive_date%TYPE
294: , actual_receive_date ic_xfer_mst.actual_receive_date%TYPE
287: , release_uom1 ic_xfer_mst.release_uom1%TYPE
288: , release_uom2 ic_xfer_mst.release_uom2%TYPE
289: , receive_quantity1 ic_xfer_mst.receive_quantity1%TYPE DEFAULT 0
290: , receive_quantity2 ic_xfer_mst.receive_quantity2%TYPE DEFAULT 0
291: , scheduled_release_date ic_xfer_mst.scheduled_release_date%TYPE
292: , actual_release_date ic_xfer_mst.actual_release_date%TYPE
293: , scheduled_receive_date ic_xfer_mst.scheduled_receive_date%TYPE
294: , actual_receive_date ic_xfer_mst.actual_receive_date%TYPE
295: , cancel_date ic_xfer_mst.cancel_date%TYPE
288: , release_uom2 ic_xfer_mst.release_uom2%TYPE
289: , receive_quantity1 ic_xfer_mst.receive_quantity1%TYPE DEFAULT 0
290: , receive_quantity2 ic_xfer_mst.receive_quantity2%TYPE DEFAULT 0
291: , scheduled_release_date ic_xfer_mst.scheduled_release_date%TYPE
292: , actual_release_date ic_xfer_mst.actual_release_date%TYPE
293: , scheduled_receive_date ic_xfer_mst.scheduled_receive_date%TYPE
294: , actual_receive_date ic_xfer_mst.actual_receive_date%TYPE
295: , cancel_date ic_xfer_mst.cancel_date%TYPE
296: , comments ic_xfer_mst.comments%TYPE DEFAULT NULL
289: , receive_quantity1 ic_xfer_mst.receive_quantity1%TYPE DEFAULT 0
290: , receive_quantity2 ic_xfer_mst.receive_quantity2%TYPE DEFAULT 0
291: , scheduled_release_date ic_xfer_mst.scheduled_release_date%TYPE
292: , actual_release_date ic_xfer_mst.actual_release_date%TYPE
293: , scheduled_receive_date ic_xfer_mst.scheduled_receive_date%TYPE
294: , actual_receive_date ic_xfer_mst.actual_receive_date%TYPE
295: , cancel_date ic_xfer_mst.cancel_date%TYPE
296: , comments ic_xfer_mst.comments%TYPE DEFAULT NULL
297: , attribute1 ic_lots_mst.attribute1%TYPE DEFAULT NULL
290: , receive_quantity2 ic_xfer_mst.receive_quantity2%TYPE DEFAULT 0
291: , scheduled_release_date ic_xfer_mst.scheduled_release_date%TYPE
292: , actual_release_date ic_xfer_mst.actual_release_date%TYPE
293: , scheduled_receive_date ic_xfer_mst.scheduled_receive_date%TYPE
294: , actual_receive_date ic_xfer_mst.actual_receive_date%TYPE
295: , cancel_date ic_xfer_mst.cancel_date%TYPE
296: , comments ic_xfer_mst.comments%TYPE DEFAULT NULL
297: , attribute1 ic_lots_mst.attribute1%TYPE DEFAULT NULL
298: , attribute2 ic_lots_mst.attribute2%TYPE DEFAULT NULL
291: , scheduled_release_date ic_xfer_mst.scheduled_release_date%TYPE
292: , actual_release_date ic_xfer_mst.actual_release_date%TYPE
293: , scheduled_receive_date ic_xfer_mst.scheduled_receive_date%TYPE
294: , actual_receive_date ic_xfer_mst.actual_receive_date%TYPE
295: , cancel_date ic_xfer_mst.cancel_date%TYPE
296: , comments ic_xfer_mst.comments%TYPE DEFAULT NULL
297: , attribute1 ic_lots_mst.attribute1%TYPE DEFAULT NULL
298: , attribute2 ic_lots_mst.attribute2%TYPE DEFAULT NULL
299: , attribute3 ic_lots_mst.attribute3%TYPE DEFAULT NULL
292: , actual_release_date ic_xfer_mst.actual_release_date%TYPE
293: , scheduled_receive_date ic_xfer_mst.scheduled_receive_date%TYPE
294: , actual_receive_date ic_xfer_mst.actual_receive_date%TYPE
295: , cancel_date ic_xfer_mst.cancel_date%TYPE
296: , comments ic_xfer_mst.comments%TYPE DEFAULT NULL
297: , attribute1 ic_lots_mst.attribute1%TYPE DEFAULT NULL
298: , attribute2 ic_lots_mst.attribute2%TYPE DEFAULT NULL
299: , attribute3 ic_lots_mst.attribute3%TYPE DEFAULT NULL
300: , attribute4 ic_lots_mst.attribute4%TYPE DEFAULT NULL
398: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
399: , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE
400: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE
401: , p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE
402: , p_ic_xfer_mst_row OUT NOCOPY ic_xfer_mst%ROWTYPE
403: , x_ic_xfer_mst_row OUT NOCOPY ic_xfer_mst%ROWTYPE
404: , x_return_status OUT NOCOPY VARCHAR2
405: , x_msg_count OUT NOCOPY NUMBER
406: , x_msg_data OUT NOCOPY VARCHAR2
399: , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE
400: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE
401: , p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE
402: , p_ic_xfer_mst_row OUT NOCOPY ic_xfer_mst%ROWTYPE
403: , x_ic_xfer_mst_row OUT NOCOPY ic_xfer_mst%ROWTYPE
404: , x_return_status OUT NOCOPY VARCHAR2
405: , x_msg_count OUT NOCOPY NUMBER
406: , x_msg_data OUT NOCOPY VARCHAR2
407: );