APPS.GMIVQTY dependencies on IC_LOTS_STS

Line 107: , p_lot_status IN ic_lots_sts.lot_status%TYPE

103: ( p_item_id IN ic_item_mst.item_id%TYPE
104: , p_lot_id IN ic_lots_mst.lot_id%TYPE
105: , p_whse_code IN ic_whse_mst.whse_code%TYPE
106: , p_location IN ic_loct_mst.location%TYPE
107: , p_lot_status IN ic_lots_sts.lot_status%TYPE
108: )
109: RETURN BOOLEAN
110: IS
111:

Line 495: l_ic_lots_sts_row ic_lots_sts%ROWTYPE;

491: l_ic_loct_inv_row_from ic_loct_inv%ROWTYPE;
492: l_ic_loct_inv_row_to ic_loct_inv%ROWTYPE;
493: l_sy_reas_cds_row sy_reas_cds%ROWTYPE;
494: l_qc_grad_mst_row qc_grad_mst%ROWTYPE;
495: l_ic_lots_sts_row ic_lots_sts%ROWTYPE;
496: l_qty2 NUMBER;
497: l_onhand NUMBER;
498: l_onhand2 NUMBER;
499: l_trans_type NUMBER(2);

Line 1140: IF GMIGUTL.v_lot_status (l_qty_rec.lot_status, l_ic_lots_sts_row)

1136: ELSIF l_qty_rec.lot_status = p_ic_item_mst_row.lot_status
1137: THEN
1138: NULL;
1139: ELSE
1140: IF GMIGUTL.v_lot_status (l_qty_rec.lot_status, l_ic_lots_sts_row)
1141: THEN
1142: NULL;
1143: ELSE
1144: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_STATUS');