DBA Data[Home] [Help]

APPS.GMICUOM dependencies on SY_UOMS_TYP

Line 277: l_cur_um_type sy_uoms_typ.um_type%TYPE;

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;

Line 278: l_new_um_type sy_uoms_typ.um_type%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 */

Line 279: l_inv_um_type sy_uoms_typ.um_type%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 */
283: l_new_uom_factor ic_item_cnv.type_factor%TYPE;

Line 328: v_um_type sy_uoms_typ.um_type%TYPE) IS

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

Line 715: l_cur_um_type sy_uoms_typ.um_type%TYPE;

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;

Line 716: l_new_um_type sy_uoms_typ.um_type%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;

Line 717: l_inv_um_type sy_uoms_typ.um_type%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;

Line 755: v_um_type sy_uoms_typ.um_type%TYPE) IS

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