APPS.GMI_TRANS_ENGINE_PVT dependencies on IC_ITEM_MST

Line 224: ic_item_mst

220: CURSOR Cur_status_ctl(pitem_id NUMBER) IS
221: SELECT
222: status_ctl
223: FROM
224: ic_item_mst
225: WHERE
226: item_id = pitem_id;
227: --END Bug# 2341493
228:

Line 842: l_item_mst_rec ic_item_mst%ROWTYPE;

838: l_return_status VARCHAR2(1);
839: l_trans_id IC_TRAN_PND.TRANS_ID%TYPE;
840: l_tran_row IC_TRAN_PND%ROWTYPE;
841: -- TKW B3415691 (Pls refer to 3599127)
842: l_item_mst_rec ic_item_mst%ROWTYPE;
843:
844: /* TKW B3415691 - Enhancement for Serono (Pls refer to B3599127) */
845: /* Added two cursors to get lot_status and qc_grade */
846: CURSOR Cur_lot_status(

Line 952: IF NOT gmivdbl.ic_item_mst_select (

948: /* Added code to ensure the completed transaction reflected
949: the lot status and qc grade of the lot in ic_loct_inv
950: at the time the transaction took place */
951: l_item_mst_rec.item_id := l_tran_rec.item_id;
952: IF NOT gmivdbl.ic_item_mst_select (
953: p_ic_item_mst_row => l_item_mst_rec,
954: x_ic_item_mst_row => l_item_mst_rec
955: ) THEN
956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 953: p_ic_item_mst_row => l_item_mst_rec,

949: the lot status and qc grade of the lot in ic_loct_inv
950: at the time the transaction took place */
951: l_item_mst_rec.item_id := l_tran_rec.item_id;
952: IF NOT gmivdbl.ic_item_mst_select (
953: p_ic_item_mst_row => l_item_mst_rec,
954: x_ic_item_mst_row => l_item_mst_rec
955: ) THEN
956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
957: END IF;

Line 954: x_ic_item_mst_row => l_item_mst_rec

950: at the time the transaction took place */
951: l_item_mst_rec.item_id := l_tran_rec.item_id;
952: IF NOT gmivdbl.ic_item_mst_select (
953: p_ic_item_mst_row => l_item_mst_rec,
954: x_ic_item_mst_row => l_item_mst_rec
955: ) THEN
956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
957: END IF;
958:

Line 1181: FROM ic_item_mst

1177:
1178: CURSOR c_get_noninv_ind ( p_item_id IN NUMBER)
1179: IS
1180: SELECT noninv_ind
1181: FROM ic_item_mst
1182: WHERE item_id = p_item_id;
1183:
1184: l_noninv NUMBER;
1185: