APPS.GMIVITM dependencies on IC_LOTS_STS

Line 377: l_ic_lots_sts_row ic_lots_sts%ROWTYPE;

373: l_sy_uoms_mst_row sy_uoms_mst%ROWTYPE;
374: l_sy_uoms_typ_row sy_uoms_typ%ROWTYPE;
375: l_qc_grad_mst_row qc_grad_mst%ROWTYPE;
376: l_qc_actn_mst_row qc_actn_mst%ROWTYPE;
377: l_ic_lots_sts_row ic_lots_sts%ROWTYPE;
378: l_api_name VARCHAR2(30) := 'Validate Item';
379: BEGIN
380:
381: /* Standard call to check for call compatibility. */

Line 652: IF GMIGUTL.v_lot_status(UPPER(p_item_rec.lot_status), l_ic_lots_sts_row)

648: IF x_ic_item_mst_row.status_ctl = 1
649: THEN
650: IF NVL(p_item_rec.lot_status, ' ') <> ' '
651: THEN
652: IF GMIGUTL.v_lot_status(UPPER(p_item_rec.lot_status), l_ic_lots_sts_row)
653: THEN
654: x_ic_item_mst_row.lot_status := l_ic_lots_sts_row.lot_status;
655: END IF;
656: END IF;

Line 654: x_ic_item_mst_row.lot_status := l_ic_lots_sts_row.lot_status;

650: IF NVL(p_item_rec.lot_status, ' ') <> ' '
651: THEN
652: IF GMIGUTL.v_lot_status(UPPER(p_item_rec.lot_status), l_ic_lots_sts_row)
653: THEN
654: x_ic_item_mst_row.lot_status := l_ic_lots_sts_row.lot_status;
655: END IF;
656: END IF;
657:
658: IF x_ic_item_mst_row.lot_status IS NULL