372: l_ic_item_cpg_row ic_item_cpg%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:
608:
609: IF NVL(p_item_rec.expaction_code, ' ') <> ' '
610: THEN
611: -- BUG#2461984 VAK
612: IF GMIGUTL.v_expaction_code(UPPER(RTRIM(p_item_rec.expaction_code)),l_qc_actn_mst_row)
613: THEN
614: x_ic_item_mst_row.expaction_code := l_qc_actn_mst_row.action_code;
615: END IF;
616: END IF;
610: THEN
611: -- BUG#2461984 VAK
612: IF GMIGUTL.v_expaction_code(UPPER(RTRIM(p_item_rec.expaction_code)),l_qc_actn_mst_row)
613: THEN
614: x_ic_item_mst_row.expaction_code := l_qc_actn_mst_row.action_code;
615: END IF;
616: END IF;
617:
618: --Jalaj Srivastava Bug 1617398