eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTL_UNITS_OF_MEASURE_TL_PKG dependencies on MTL_UNITS_OF_MEASURE_TL

Line 1: package body MTL_UNITS_OF_MEASURE_TL_PKG as

1: package body MTL_UNITS_OF_MEASURE_TL_PKG as
2: /* $Header: INVUOMSB.pls 120.2 2006/05/17 17:55:10 satkumar noship $ */
3: procedure INSERT_ROW (
4: X_ROW_ID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5: X_UNIT_OF_MEASURE in VARCHAR2,

Line 204: delete from MTL_UNITS_OF_MEASURE_TL

200: procedure DELETE_ROW (
201: X_UNIT_OF_MEASURE in VARCHAR2
202: ) as
203: begin
204: delete from MTL_UNITS_OF_MEASURE_TL
205: where UNIT_OF_MEASURE = X_UNIT_OF_MEASURE;
206:
207: if (sql%notfound) then
208: raise no_data_found;

Line 258: mtl_units_of_measure_tl_pkg.update_row(

254: from fnd_application
255: where application_short_name = X_APPL_SHORT_NAME;
256: end if;
257:
258: mtl_units_of_measure_tl_pkg.update_row(
259: x_unit_of_measure => x_unit_of_measure,
260: x_unit_of_measure_tl => x_unit_of_measure_tl,
261: x_uom_code => x_uom_code,
262: x_uom_class => x_uom_class,

Line 288: mtl_units_of_measure_tl_pkg.insert_row(

284: x_last_updated_by => user_id,
285: x_last_update_login => 0);
286: Exception
287: when no_data_found then
288: mtl_units_of_measure_tl_pkg.insert_row(
289: x_row_id => row_id,
290: x_unit_of_measure => x_unit_of_measure,
291: x_unit_of_measure_tl => x_unit_of_measure_tl,
292: x_attribute_category => x_attribute_category,

Line 333: update mtl_units_of_measure_tl set

329: ) as
330: BEGIN
331:
332:
333: update mtl_units_of_measure_tl set
334: unit_of_measure_tl = X_UNIT_OF_MEASURE_TL,
335: description = X_DESCRIPTION,
336: LAST_UPDATE_DATE = sysdate,
337: LAST_UPDATED_BY = decode(x_owner, 'SEED', 1, 0),

Line 348: update MTL_UNITS_OF_MEASURE_TL T set (

344: procedure ADD_LANGUAGE
345: as
346: BEGIN
347:
348: update MTL_UNITS_OF_MEASURE_TL T set (
349: UNIT_OF_MEASURE_TL,
350: DESCRIPTION
351: ) = (select
352: B.UNIT_OF_MEASURE,

Line 354: from MTL_UNITS_OF_MEASURE_TL B

350: DESCRIPTION
351: ) = (select
352: B.UNIT_OF_MEASURE,
353: B.DESCRIPTION
354: from MTL_UNITS_OF_MEASURE_TL B
355: where B.UNIT_OF_MEASURE = T.UNIT_OF_MEASURE
356: and B.LANGUAGE = T.SOURCE_LANG)
357: where (
358: T.UNIT_OF_MEASURE,

Line 363: from MTL_UNITS_OF_MEASURE_TL SUBB, MTL_UNITS_OF_MEASURE_TL SUBT

359: T.LANGUAGE
360: ) in (select
361: SUBT.UNIT_OF_MEASURE,
362: SUBT.LANGUAGE
363: from MTL_UNITS_OF_MEASURE_TL SUBB, MTL_UNITS_OF_MEASURE_TL SUBT
364: where SUBB.UNIT_OF_MEASURE = SUBT.UNIT_OF_MEASURE
365: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
366: and (SUBB.UNIT_OF_MEASURE_TL <> SUBT.UNIT_OF_MEASURE_TL
367: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 372: insert into MTL_UNITS_OF_MEASURE_TL (

368: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
369: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
370: ));
371:
372: insert into MTL_UNITS_OF_MEASURE_TL (
373: UNIT_OF_MEASURE,
374: UNIT_OF_MEASURE_TL,
375: ATTRIBUTE1,
376: ATTRIBUTE2,

Line 442: from MTL_UNITS_OF_MEASURE_TL B, FND_LANGUAGES L

438: B.UOM_CODE,
439: B.UOM_CLASS,
440: L.LANGUAGE_CODE,
441: B.SOURCE_LANG
442: from MTL_UNITS_OF_MEASURE_TL B, FND_LANGUAGES L
443: where L.INSTALLED_FLAG in ('I', 'B')
444: and B.LANGUAGE = userenv('LANG')
445: and not exists
446: (select NULL

Line 447: from MTL_UNITS_OF_MEASURE_TL T

443: where L.INSTALLED_FLAG in ('I', 'B')
444: and B.LANGUAGE = userenv('LANG')
445: and not exists
446: (select NULL
447: from MTL_UNITS_OF_MEASURE_TL T
448: where T.UNIT_OF_MEASURE = B.UNIT_OF_MEASURE
449: and T.LANGUAGE = L.LANGUAGE_CODE);
450:
451:

Line 493: cursor C is select ROWID from MTL_UNITS_OF_MEASURE_TL

489: X_PROGRAM_ID in NUMBER,
490: X_PROGRAM_UPDATE_DATE in DATE,
491: x_language IN VARCHAR2
492: ) as
493: cursor C is select ROWID from MTL_UNITS_OF_MEASURE_TL
494: where UNIT_OF_MEASURE = X_UNIT_OF_MEASURE
495: and LANGUAGE = x_language
496: ;
497: begin

Line 498: insert into MTL_UNITS_OF_MEASURE_TL (

494: where UNIT_OF_MEASURE = X_UNIT_OF_MEASURE
495: and LANGUAGE = x_language
496: ;
497: begin
498: insert into MTL_UNITS_OF_MEASURE_TL (
499: UNIT_OF_MEASURE,
500: UNIT_OF_MEASURE_TL,
501: UOM_CODE,
502: UOM_CLASS,

Line 572: from MTL_UNITS_OF_MEASURE_TL T

568: from FND_LANGUAGES L
569: where L.INSTALLED_FLAG in ('I', 'B')
570: and not exists
571: (select NULL
572: from MTL_UNITS_OF_MEASURE_TL T
573: where T.UNIT_OF_MEASURE = X_UNIT_OF_MEASURE
574: and T.LANGUAGE = L.LANGUAGE_CODE);
575:
576: open c;

Line 639: from MTL_UNITS_OF_MEASURE_TL

635: ATTRIBUTE14,
636: ATTRIBUTE15,
637: BASE_UOM_FLAG,
638: decode(LANGUAGE, x_language, 'Y', 'N') BASELANG
639: from MTL_UNITS_OF_MEASURE_TL
640: where UNIT_OF_MEASURE = X_UNIT_OF_MEASURE
641: and x_language in (LANGUAGE, SOURCE_LANG)
642: for update of UNIT_OF_MEASURE nowait;
643: begin

Line 731: update MTL_UNITS_OF_MEASURE_TL set

727: x_language IN VARCHAR2
728: ) as
729: BEGIN
730:
731: update MTL_UNITS_OF_MEASURE_TL set
732: UOM_CODE = X_UOM_CODE,
733: UOM_CLASS = X_UOM_CLASS,
734: UNIT_OF_MEASURE_TL = X_UNIT_OF_MEASURE_TL,
735: DESCRIPTION = X_DESCRIPTION,

Line 790: SELECT COUNT(1) INTO l_row_cnt from MTL_UNITS_OF_MEASURE_TL T

786: -- USE THE FACT THAT UNIT_OF_MEASURE WILL BE UNIQUE FOR THAT LANGUAGE
787: -- This validation is to ensure that unit_of_measure_tl will also be
788: -- UNIQUE IN the table
789:
790: SELECT COUNT(1) INTO l_row_cnt from MTL_UNITS_OF_MEASURE_TL T
791: where unit_of_measure_tl = x_unit_of_measure_tl
792: AND UNIT_OF_MEASURE <> x_unit_of_measure
793: AND X_language in (LANGUAGE, SOURCE_LANG);
794:

Line 814: end MTL_UNITS_OF_MEASURE_TL_PKG;

810:
811: END validate_translated_row;
812:
813:
814: end MTL_UNITS_OF_MEASURE_TL_PKG;