DBA Data[Home] [Help]

APPS.GMIGAPI dependencies on IC_XFER_MST

Line 273: , transfer_no ic_xfer_mst.transfer_no%TYPE

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

Line 274: , orgn_code ic_xfer_mst.orgn_code%TYPE

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

Line 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

Line 279: , receive_reason_code ic_xfer_mst.receive_reason_code%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

Line 280: , cancel_reason_code ic_xfer_mst.cancel_reason_code%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

Line 281: , from_warehouse ic_xfer_mst.from_warehouse%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

Line 282: , from_location ic_xfer_mst.from_location%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
286: , release_quantity2 ic_xfer_mst.release_quantity2%TYPE DEFAULT 0

Line 283: , to_warehouse ic_xfer_mst.to_warehouse%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
287: , release_uom1 ic_xfer_mst.release_uom1%TYPE

Line 284: , to_location ic_xfer_mst.to_location%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
288: , release_uom2 ic_xfer_mst.release_uom2%TYPE

Line 285: , release_quantity1 ic_xfer_mst.release_quantity1%TYPE DEFAULT 0

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

Line 286: , release_quantity2 ic_xfer_mst.release_quantity2%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

Line 287: , release_uom1 ic_xfer_mst.release_uom1%TYPE

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

Line 288: , release_uom2 ic_xfer_mst.release_uom2%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

Line 289: , receive_quantity1 ic_xfer_mst.receive_quantity1%TYPE DEFAULT 0

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

Line 290: , receive_quantity2 ic_xfer_mst.receive_quantity2%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
294: , actual_receive_date ic_xfer_mst.actual_receive_date%TYPE

Line 291: , scheduled_release_date ic_xfer_mst.scheduled_release_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

Line 292: , actual_release_date ic_xfer_mst.actual_release_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

Line 293: , scheduled_receive_date ic_xfer_mst.scheduled_receive_date%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
297: , attribute1 ic_lots_mst.attribute1%TYPE DEFAULT NULL

Line 294: , actual_receive_date ic_xfer_mst.actual_receive_date%TYPE

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

Line 295: , cancel_date ic_xfer_mst.cancel_date%TYPE

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

Line 296: , comments ic_xfer_mst.comments%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

Line 402: , p_ic_xfer_mst_row OUT NOCOPY ic_xfer_mst%ROWTYPE

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

Line 403: , x_ic_xfer_mst_row OUT NOCOPY ic_xfer_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
407: );