APPS.GMIVILC dependencies on IC_ITEM_MST

Line 76: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE

72: PROCEDURE Validate_Lot_Conversion
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

Line 113: WHERE item_id = p_ic_item_mst_row.item_id and

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:
117: CURSOR Cur_trans_cmp IS

Line 120: WHERE item_id = p_ic_item_mst_row.item_id and

116:
117: CURSOR Cur_trans_cmp IS
118: SELECT count(*)
119: FROM ic_tran_cmp
120: WHERE item_id = p_ic_item_mst_row.item_id and
121: lot_id = x_lot_id;
122:
123: CURSOR Cur_trans_pnd IS
124: SELECT count(*)

Line 126: WHERE item_id = p_ic_item_mst_row.item_id and

122:
123: CURSOR Cur_trans_pnd IS
124: SELECT count(*)
125: FROM ic_tran_pnd
126: WHERE item_id = p_ic_item_mst_row.item_id and
127: lot_id = x_lot_id;
128:
129: CURSOR Cur_journal IS
130: SELECT count(1)

Line 133: AND a.item_id = p_ic_item_mst_row.item_id

129: CURSOR Cur_journal IS
130: SELECT count(1)
131: FROM ic_jrnl_mst m, ic_adjs_jnl a
132: WHERE m.journal_id = a.journal_id
133: AND a.item_id = p_ic_item_mst_row.item_id
134: AND a.lot_id = x_lot_id;
135:
136:
137: BEGIN

Line 149: IF p_ic_item_mst_row.item_id = 0 OR

145:
146: l_rec_to_um :=p_item_cnv_rec.to_uom;
147: l_rec_from_um :=p_item_cnv_rec.from_uom;
148:
149: IF p_ic_item_mst_row.item_id = 0 OR
150: p_ic_item_mst_row.delete_mark = 1
151: THEN
152: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');
153: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_cnv_rec.item_no);

Line 150: p_ic_item_mst_row.delete_mark = 1

146: l_rec_to_um :=p_item_cnv_rec.to_uom;
147: l_rec_from_um :=p_item_cnv_rec.from_uom;
148:
149: IF p_ic_item_mst_row.item_id = 0 OR
150: p_ic_item_mst_row.delete_mark = 1
151: THEN
152: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');
153: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_cnv_rec.item_no);
154: FND_MSG_PUB.Add;

Line 156: ELSIF p_ic_item_mst_row.inactive_ind = 1

152: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');
153: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_cnv_rec.item_no);
154: FND_MSG_PUB.Add;
155: RAISE FND_API.G_EXC_ERROR;
156: ELSIF p_ic_item_mst_row.inactive_ind = 1
157: AND GMIGUTL.IC$API_ALLOW_INACTIVE = 0
158: THEN
159: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');
160: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_cnv_rec.item_no);

Line 239: item_std.um_code=p_ic_item_mst_row.item_um AND

235: from_std.um_code=l_rec_from_um AND
236: from_type.delete_mark=0 AND
237: from_std.delete_mark=0 AND
238: item_type.um_type=item_std.um_type AND
239: item_std.um_code=p_ic_item_mst_row.item_um AND
240: item_type.delete_mark=0 AND
241: item_std.delete_mark=0 AND
242: to_type.um_type=to_std.um_type AND
243: to_std.um_code=l_rec_to_um AND

Line 304: l_factor := GMICUOM.uom_conversion(pitem_id => p_ic_item_mst_row.item_id

300:
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

Line 333: l_factor := GMICUOM.uom_conversion(pitem_id => p_ic_item_mst_row.item_id

329:
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

Line 397: x_ic_item_cnv_row.item_id := p_ic_item_mst_row.item_id;

393:
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;