APPS.MTL_UOM_CLASSES_TL_PKG dependencies on MTL_UOM_CLASSES_TL

Line 1: package body MTL_UOM_CLASSES_TL_PKG as

1: package body MTL_UOM_CLASSES_TL_PKG as
2: /* $Header: INVUOCSB.pls 120.2 2006/06/16 15:08:15 amohamme noship $ */
3: --
4: /* this version assumes that the userenv('LANG') is the language for the user session */
5: procedure INSERT_ROW (

Line 184: delete from MTL_UOM_CLASSES_TL

180: procedure DELETE_ROW (
181: X_UOM_CLASS in VARCHAR2
182: ) as
183: begin
184: delete from MTL_UOM_CLASSES_TL
185: where UOM_CLASS = X_UOM_CLASS;
186:
187: if (sql%notfound) then
188: raise no_data_found;

Line 238: mtl_uom_classes_tl_pkg.update_row(

234:
235:
236: user_id := fnd_load_util.owner_id(x_owner);
237:
238: mtl_uom_classes_tl_pkg.update_row(
239: X_UOM_CLASS => X_UOM_CLASS,
240: X_UOM_CLASS_TL => X_UOM_CLASS_TL,
241: X_DESCRIPTION => X_DESCRIPTION,
242: X_DISABLE_DATE => X_DISABLE_DATE,

Line 265: mtl_uom_classes_tl_pkg.insert_row(

261: X_LAST_UPDATED_BY => user_id,
262: X_LAST_UPDATE_LOGIN => 0);
263: exception
264: when no_data_found then
265: mtl_uom_classes_tl_pkg.insert_row(
266: X_ROWID => row_id,
267: X_UOM_CLASS => x_uom_class,
268: X_UOM_CLASS_TL => x_uom_class_tl,
269: X_DESCRIPTION => x_description,

Line 310: update mtl_uom_classes_tl set

306: begin
307: -- Translate owner to file_last_updated_by
308: f_luby := fnd_load_util.owner_id(x_owner);
309:
310: update mtl_uom_classes_tl set
311: uom_class_tl = x_uom_class_tl,
312: description = x_description,
313: last_update_date = sysdate,
314: last_updated_by = f_luby,

Line 324: update MTL_UOM_CLASSES_TL T set (

320: --
321: procedure ADD_LANGUAGE
322: as
323: begin
324: update MTL_UOM_CLASSES_TL T set (
325: UOM_CLASS_TL,
326: DESCRIPTION
327: ) = (select
328: B.UOM_CLASS,

Line 330: from MTL_UOM_CLASSES_TL B

326: DESCRIPTION
327: ) = (select
328: B.UOM_CLASS,
329: B.DESCRIPTION
330: from MTL_UOM_CLASSES_TL B
331: where B.UOM_CLASS = T.UOM_CLASS
332: and B.LANGUAGE = T.SOURCE_LANG)
333: where (
334: T.UOM_CLASS,

Line 339: from MTL_UOM_CLASSES_TL SUBB, MTL_UOM_CLASSES_TL SUBT

335: T.LANGUAGE
336: ) in (select
337: SUBT.UOM_CLASS,
338: SUBT.LANGUAGE
339: from MTL_UOM_CLASSES_TL SUBB, MTL_UOM_CLASSES_TL SUBT
340: where SUBB.UOM_CLASS = SUBT.UOM_CLASS
341: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
342: and (SUBB.UOM_CLASS <> SUBT.UOM_CLASS
343: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 348: insert into MTL_UOM_CLASSES_TL (

344: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
345: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
346: ));
347:
348: insert into MTL_UOM_CLASSES_TL (
349: UOM_CLASS,
350: UOM_CLASS_TL,
351: DESCRIPTION,
352: DISABLE_DATE,

Line 412: from MTL_UOM_CLASSES_TL B, FND_LANGUAGES L

408: B.LAST_UPDATE_DATE,
409: B.LAST_UPDATED_BY,
410: L.LANGUAGE_CODE,
411: B.SOURCE_LANG
412: from MTL_UOM_CLASSES_TL B, FND_LANGUAGES L
413: where L.INSTALLED_FLAG in ('I', 'B')
414: and B.LANGUAGE = userenv('LANG')
415: and not exists
416: (select NULL

Line 417: from MTL_UOM_CLASSES_TL T

413: where L.INSTALLED_FLAG in ('I', 'B')
414: and B.LANGUAGE = userenv('LANG')
415: and not exists
416: (select NULL
417: from MTL_UOM_CLASSES_TL T
418: where T.UOM_CLASS = B.UOM_CLASS
419: and T.LANGUAGE = L.LANGUAGE_CODE);
420: end ADD_LANGUAGE;
421:

Line 459: cursor C is select ROWID from MTL_UOM_CLASSES_TL

455: X_LAST_UPDATED_BY in NUMBER,
456: X_LAST_UPDATE_LOGIN in NUMBER,
457: x_language IN VARCHAR2
458: ) as
459: cursor C is select ROWID from MTL_UOM_CLASSES_TL
460: where UOM_CLASS = X_UOM_CLASS
461: and LANGUAGE = x_language
462: ;
463: begin

Line 464: insert into MTL_UOM_CLASSES_TL (

460: where UOM_CLASS = X_UOM_CLASS
461: and LANGUAGE = x_language
462: ;
463: begin
464: insert into MTL_UOM_CLASSES_TL (
465: UOM_CLASS,
466: UOM_CLASS_TL,
467: DESCRIPTION,
468: DISABLE_DATE,

Line 532: from MTL_UOM_CLASSES_TL T

528: from FND_LANGUAGES L
529: where L.INSTALLED_FLAG in ('I', 'B')
530: and not exists
531: (select NULL
532: from MTL_UOM_CLASSES_TL T
533: where T.UOM_CLASS = X_UOM_CLASS
534: and T.LANGUAGE = L.LANGUAGE_CODE);
535:
536: open c;

Line 594: from MTL_UOM_CLASSES_TL

590: ATTRIBUTE13,
591: ATTRIBUTE14,
592: ATTRIBUTE15,
593: decode(LANGUAGE, x_language, 'Y', 'N') BASELANG
594: from MTL_UOM_CLASSES_TL
595: where UOM_CLASS = X_UOM_CLASS
596: and x_language in (LANGUAGE, SOURCE_LANG)
597: for update of UOM_CLASS nowait;
598: begin

Line 680: update MTL_UOM_CLASSES_TL set

676: X_LAST_UPDATE_LOGIN in NUMBER,
677: x_language IN VARCHAR2
678: ) as
679: begin
680: update MTL_UOM_CLASSES_TL set
681: UOM_CLASS_TL = X_UOM_CLASS_TL,
682: DESCRIPTION = X_DESCRIPTION,
683: DISABLE_DATE = X_DISABLE_DATE,
684: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,

Line 714: end MTL_UOM_CLASSES_TL_PKG;

710: end if;
711: end UPDATE_ROW;
712: --
713:
714: end MTL_UOM_CLASSES_TL_PKG;