APPS.GMIVILC dependencies on IC_LOTS_MST

Line 77: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE

73: ( p_api_version IN NUMBER
74: , p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
75: , p_item_cnv_rec IN GMIGAPI.conv_rec_typ
76: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
77: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE
78: , x_ic_item_cnv_row OUT NOCOPY ic_item_cnv%ROWTYPE
79: , x_return_status OUT NOCOPY VARCHAR2
80: , x_msg_count OUT NOCOPY NUMBER
81: , x_msg_data OUT NOCOPY VARCHAR2

Line 112: FROM ic_lots_mst

108: x_lot_id NUMBER;
109:
110: CURSOR Cur_get_lotid IS
111: SELECT lot_id
112: FROM ic_lots_mst
113: WHERE item_id = p_ic_item_mst_row.item_id and
114: lot_no = p_item_cnv_rec.lot_no and
115: sublot_no = p_item_cnv_rec.sublot_no;
116:

Line 167: p_ic_lots_mst_row.delete_mark = 1 OR

163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165:
166: IF
167: p_ic_lots_mst_row.delete_mark = 1 OR
168: p_ic_lots_mst_row.inactive_ind = 1 AND GMIGUTL.IC$API_ALLOW_INACTIVE = 0
169: THEN
170: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
171: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);

Line 168: p_ic_lots_mst_row.inactive_ind = 1 AND GMIGUTL.IC$API_ALLOW_INACTIVE = 0

164: END IF;
165:
166: IF
167: p_ic_lots_mst_row.delete_mark = 1 OR
168: p_ic_lots_mst_row.inactive_ind = 1 AND GMIGUTL.IC$API_ALLOW_INACTIVE = 0
169: THEN
170: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
171: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
172: FND_MESSAGE.SET_TOKEN('LOT_NO', p_item_cnv_rec.lot_no);

Line 305: ,plot_id => p_ic_lots_mst_row.lot_id

301: IF (l_from_um <> l_from_std_um)
302: THEN
303:
304: l_factor := GMICUOM.uom_conversion(pitem_id => p_ic_item_mst_row.item_id
305: ,plot_id => p_ic_lots_mst_row.lot_id
306: ,pcur_qty => l_factor
307: ,pcur_uom => l_from_um
308: ,pnew_uom => l_from_std_um
309: ,patomic => 0

Line 334: ,plot_id => p_ic_lots_mst_row.lot_id

330: IF (l_rec_to_um <> l_to_std_um)
331: THEN
332:
333: l_factor := GMICUOM.uom_conversion(pitem_id => p_ic_item_mst_row.item_id
334: ,plot_id => p_ic_lots_mst_row.lot_id
335: ,pcur_qty => l_factor
336: ,pcur_uom => l_to_std_um
337: ,pnew_uom => l_to_um
338: ,patomic => 0

Line 365: IF (p_ic_lots_mst_row.lot_id > 0) THEN

361:
362: /* Bug 2880585 - Check for transaction activity before */
363: /* creating a new conversion. */
364:
365: IF (p_ic_lots_mst_row.lot_id > 0) THEN
366: OPEN Cur_get_lotid;
367: FETCH Cur_get_lotid INTO X_lot_id;
368: CLOSE Cur_get_lotid;
369: OPEN Cur_trans_cmp;

Line 398: x_ic_item_cnv_row.lot_id := p_ic_lots_mst_row.lot_id;

394:
395: /* Set up PL/SQL record for insertion into IC_ITEM_CNV */
396:
397: x_ic_item_cnv_row.item_id := p_ic_item_mst_row.item_id;
398: x_ic_item_cnv_row.lot_id := p_ic_lots_mst_row.lot_id;
399: x_ic_item_cnv_row.um_type := l_um_type;
400: x_ic_item_cnv_row.type_factor := l_factor;
401: x_ic_item_cnv_row.last_update_date := SYSDATE;
402: x_ic_item_cnv_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;