APPS.ITG_SYNCUOMINBOUND_PVT dependencies on MTL_UOM_CLASSES_TL

Line 301: UPDATE mtl_uom_classes_tl

297: ITG_MSG.null_disable_date;
298: RAISE FND_API.G_EXC_ERROR;
299: END IF;
300: g_action := 'UOMClass disable';
301: UPDATE mtl_uom_classes_tl
302: SET disable_date = p_cls_rec.disable_date,
303: last_update_date = p_cls_rec.last_update_date,
304: last_updated_by = p_cls_rec.last_updated_by,
305: --uom_class_tl = p_cls_rec.uom_class_tl, /*null update fails*/

Line 321: UPDATE mtl_uom_classes_tl

317: p_cls_rec IN mtl_uom_classes%ROWTYPE
318: ) IS
319: BEGIN
320: g_action := 'UOMClass update';
321: UPDATE mtl_uom_classes_tl
322: SET description = p_cls_rec.description,
323: disable_date = p_cls_rec.disable_date,
324: last_update_date = p_cls_rec.last_update_date,
325: last_updated_by = p_cls_rec.last_updated_by,

Line 342: INSERT INTO mtl_uom_classes_tl (

338: p_cls_rec IN mtl_uom_classes%ROWTYPE
339: ) IS
340: BEGIN
341: g_action := 'UOMClass insert';
342: INSERT INTO mtl_uom_classes_tl (
343: uom_class,
344: uom_class_tl,
345: disable_date,
346: description,

Line 367: FROM mtl_uom_classes_tl t

363: FROM fnd_languages l
364: WHERE l.installed_flag IN ('I', 'B')
365: AND NOT EXISTS
366: (SELECT NULL
367: FROM mtl_uom_classes_tl t
368: WHERE t.uom_class = p_cls_rec.uom_class
369: AND t.language = l.language_code);
370: END insert_uom_class;
371: