APPS.ITG_SYNCUOMINBOUND_PVT dependencies on MTL_UNITS_OF_MEASURE_TL

Line 62: INSERT INTO mtl_units_of_measure_tl (

58: END IF;
59: END IF;
60:
61: g_action := 'UOM insert';
62: INSERT INTO mtl_units_of_measure_tl (
63: unit_of_measure,
64: unit_of_measure_tl,
65: uom_code,
66: uom_class,

Line 93: FROM mtl_units_of_measure_tl t

89: FROM FND_LANGUAGES l
90: WHERE l.installed_flag IN ('I', 'B')
91: AND NOT EXISTS (
92: SELECT NULL
93: FROM mtl_units_of_measure_tl t
94: WHERE (t.unit_of_measure = p_uom_rec.unit_of_measure
95: OR t.uom_code = p_uom_rec.uom_code)
96: AND t.language = l.language_code);
97: END insert_uom;

Line 109: UPDATE mtl_units_of_measure_tl

105: ITG_MSG.null_disable_date;
106: RAISE FND_API.G_EXC_ERROR;
107: END IF;
108:
109: UPDATE mtl_units_of_measure_tl
110: SET disable_date = p_uom_rec.disable_date,
111: last_update_date = p_uom_rec.last_update_date,
112: last_updated_by = p_uom_rec.last_updated_by,
113: --unit_of_measure_tl = p_uom_rec.unit_of_measure_tl, /*null update fails?*/

Line 131: UPDATE mtl_units_of_measure_tl

127: p_uom_rec IN mtl_units_of_measure%ROWTYPE
128: ) IS
129: BEGIN
130: g_action := 'UOM update';
131: UPDATE mtl_units_of_measure_tl
132: SET description = p_uom_rec.description,
133: disable_date = p_uom_rec.disable_date,
134: --unit_of_measure_tl = p_uom_rec.unit_of_measure_tl, /*null update?*/
135: source_lang = USERENV('LANG'),