157: t_item_no mtl_system_items.segment1%TYPE;
158:
159: CURSOR get_item_ind(i_item_no VARCHAR2) IS
160: SELECT dualum_ind, lot_ctl
161: FROM ic_item_mst
162: WHERE item_no = i_item_no;
163:
164: t_dualum_ind ic_item_mst.dualum_ind%TYPE;
165: t_lot_ctl ic_item_mst.lot_ctl%TYPE;
160: SELECT dualum_ind, lot_ctl
161: FROM ic_item_mst
162: WHERE item_no = i_item_no;
163:
164: t_dualum_ind ic_item_mst.dualum_ind%TYPE;
165: t_lot_ctl ic_item_mst.lot_ctl%TYPE;
166:
167: affect_inv EXCEPTION;
168: exp_wrong_item EXCEPTION;
161: FROM ic_item_mst
162: WHERE item_no = i_item_no;
163:
164: t_dualum_ind ic_item_mst.dualum_ind%TYPE;
165: t_lot_ctl ic_item_mst.lot_ctl%TYPE;
166:
167: affect_inv EXCEPTION;
168: exp_wrong_item EXCEPTION;
169: no_lot_data EXCEPTION;