eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMI_ITEM_LOT_CONV_PUB dependencies on IC_LOTS_MST

Line 85: l_ic_lots_mst_rec ic_lots_mst%ROWTYPE;

81: l_factor NUMBER;
82: l_type_factorrev NUMBER;
83: l_ic_item_cnv_rec ic_item_cnv%ROWTYPE;
84: l_ic_item_mst_rec ic_item_mst%ROWTYPE;
85: l_ic_lots_mst_rec ic_lots_mst%ROWTYPE;
86: l_item_cnv_rec item_cnv_rec_typ;
87: l_ic_item_cpg_rec ic_item_cpg%ROWTYPE;
88: l_ic_lots_cpg_rec ic_lots_cpg%ROWTYPE;
89: l_sy_uoms_mst_rec_um1 sy_uoms_mst%ROWTYPE;

Line 202: , x_ic_lots_mst => l_ic_lots_mst_rec

198:
199: GMI_GLOBAL_GRP.Get_Lot ( p_item_id => l_ic_item_mst_rec.item_id
200: , p_lot_no => l_item_cnv_rec.lot_no
201: , p_sublot_no => l_item_cnv_rec.sublot_no
202: , x_ic_lots_mst => l_ic_lots_mst_rec
203: , x_ic_lots_cpg => l_ic_lots_cpg_rec
204: );
205:
206: IF (l_ic_lots_mst_rec.lot_id = -1) OR

Line 206: IF (l_ic_lots_mst_rec.lot_id = -1) OR

202: , x_ic_lots_mst => l_ic_lots_mst_rec
203: , x_ic_lots_cpg => l_ic_lots_cpg_rec
204: );
205:
206: IF (l_ic_lots_mst_rec.lot_id = -1) OR
207: (l_ic_lots_mst_rec.delete_mark = 1) OR
208: (l_ic_lots_mst_rec.inactive_ind = 1)
209: THEN
210: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');

Line 207: (l_ic_lots_mst_rec.delete_mark = 1) OR

203: , x_ic_lots_cpg => l_ic_lots_cpg_rec
204: );
205:
206: IF (l_ic_lots_mst_rec.lot_id = -1) OR
207: (l_ic_lots_mst_rec.delete_mark = 1) OR
208: (l_ic_lots_mst_rec.inactive_ind = 1)
209: THEN
210: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
211: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);

Line 208: (l_ic_lots_mst_rec.inactive_ind = 1)

204: );
205:
206: IF (l_ic_lots_mst_rec.lot_id = -1) OR
207: (l_ic_lots_mst_rec.delete_mark = 1) OR
208: (l_ic_lots_mst_rec.inactive_ind = 1)
209: THEN
210: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
211: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
212: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);

Line 385: ,plot_id => l_ic_lots_mst_rec.lot_id

381:
382: IF (l_from_um <> l_sy_uoms_typ_rec_from.std_um)
383: THEN
384: l_factor := GMICUOM.uom_conversion(pitem_id => l_ic_item_mst_rec.item_id
385: ,plot_id => l_ic_lots_mst_rec.lot_id
386: ,pcur_qty => l_factor
387: ,pcur_uom => l_from_um
388: ,pnew_uom => l_from_std_um
389: ,patomic => 0

Line 410: ,plot_id => l_ic_lots_mst_rec.lot_id

406:
407: IF (l_item_cnv_rec.to_uom <> l_sy_uoms_typ_rec_to.std_um)
408: THEN
409: l_factor := GMICUOM.uom_conversion(pitem_id => l_ic_item_mst_rec.item_id
410: ,plot_id => l_ic_lots_mst_rec.lot_id
411: ,pcur_qty => l_factor
412: ,pcur_uom => l_to_std_um
413: ,pnew_uom => l_to_um
414: ,patomic => 0

Line 436: l_ic_item_cnv_rec.lot_id := l_ic_lots_mst_rec.lot_id;

432:
433: -- Set up PL/SQL record and insert item/lot conversion into IC_ITEM_CNV
434:
435: l_ic_item_cnv_rec.item_id := l_ic_item_mst_rec.item_id;
436: l_ic_item_cnv_rec.lot_id := l_ic_lots_mst_rec.lot_id;
437: l_ic_item_cnv_rec.um_type := l_um_type;
438: l_ic_item_cnv_rec.type_factor := l_factor;
439: l_ic_item_cnv_rec.last_update_date := SYSDATE;
440: l_ic_item_cnv_rec.last_updated_by := l_user_id;