273: ===================== */
274: l_item_invum_code uomcode_type;
275: l_cur_uom_code uomcode_type;
276: l_new_uom_code uomcode_type;
277: l_cur_um_type sy_uoms_typ.um_type%TYPE;
278: l_new_um_type sy_uoms_typ.um_type%TYPE;
279: l_inv_um_type sy_uoms_typ.um_type%TYPE;
280: l_cur_uom_factor ic_item_cnv.type_factor%TYPE;
281: l_cur_conv_factor ic_item_cnv.type_factor%TYPE;
274: l_item_invum_code uomcode_type;
275: l_cur_uom_code uomcode_type;
276: l_new_uom_code uomcode_type;
277: l_cur_um_type sy_uoms_typ.um_type%TYPE;
278: l_new_um_type sy_uoms_typ.um_type%TYPE;
279: l_inv_um_type sy_uoms_typ.um_type%TYPE;
280: l_cur_uom_factor ic_item_cnv.type_factor%TYPE;
281: l_cur_conv_factor ic_item_cnv.type_factor%TYPE;
282: l_cur_conv_factorrev ic_item_cnv.type_factor%TYPE; /* Bug 2844068 */
275: l_cur_uom_code uomcode_type;
276: l_new_uom_code uomcode_type;
277: l_cur_um_type sy_uoms_typ.um_type%TYPE;
278: l_new_um_type sy_uoms_typ.um_type%TYPE;
279: l_inv_um_type sy_uoms_typ.um_type%TYPE;
280: l_cur_uom_factor ic_item_cnv.type_factor%TYPE;
281: l_cur_conv_factor ic_item_cnv.type_factor%TYPE;
282: l_cur_conv_factorrev ic_item_cnv.type_factor%TYPE; /* Bug 2844068 */
283: l_new_uom_factor ic_item_cnv.type_factor%TYPE;
324: /* Bug 2844068 */
325: /* Added type_factorrev to the query */
326: CURSOR get_conversion_factor(v_item_id itm_surg_type,
327: v_lot_id lot_surg_type,
328: v_um_type sy_uoms_typ.um_type%TYPE) IS
329: SELECT type_factor, type_factorrev
330: FROM ic_item_cnv
331: WHERE item_id = v_item_id
332: AND lot_id = v_lot_id
711: =====================*/
712: l_item_invum_code uomcode_type;
713: l_cur_uom_code uomcode_type;
714: l_new_uom_code uomcode_type;
715: l_cur_um_type sy_uoms_typ.um_type%TYPE;
716: l_new_um_type sy_uoms_typ.um_type%TYPE;
717: l_inv_um_type sy_uoms_typ.um_type%TYPE;
718: l_cur_uom_factor ic_item_cnv.type_factor%TYPE;
719: l_cur_conv_factor ic_item_cnv.type_factor%TYPE;
712: l_item_invum_code uomcode_type;
713: l_cur_uom_code uomcode_type;
714: l_new_uom_code uomcode_type;
715: l_cur_um_type sy_uoms_typ.um_type%TYPE;
716: l_new_um_type sy_uoms_typ.um_type%TYPE;
717: l_inv_um_type sy_uoms_typ.um_type%TYPE;
718: l_cur_uom_factor ic_item_cnv.type_factor%TYPE;
719: l_cur_conv_factor ic_item_cnv.type_factor%TYPE;
720: l_new_uom_factor ic_item_cnv.type_factor%TYPE;
713: l_cur_uom_code uomcode_type;
714: l_new_uom_code uomcode_type;
715: l_cur_um_type sy_uoms_typ.um_type%TYPE;
716: l_new_um_type sy_uoms_typ.um_type%TYPE;
717: l_inv_um_type sy_uoms_typ.um_type%TYPE;
718: l_cur_uom_factor ic_item_cnv.type_factor%TYPE;
719: l_cur_conv_factor ic_item_cnv.type_factor%TYPE;
720: l_new_uom_factor ic_item_cnv.type_factor%TYPE;
721: l_new_conv_factor ic_item_cnv.type_factor%TYPE;
751: WHERE item_id = v_item_id;
752:
753: CURSOR get_conversion_factor(v_item_id itm_surg_type,
754: v_lot_id lot_surg_type,
755: v_um_type sy_uoms_typ.um_type%TYPE) IS
756: SELECT type_factor
757: FROM ic_item_cnv
758: WHERE item_id = v_item_id
759: AND lot_id = v_lot_id