APPS.MTL_ITEM_CATALOG_GROUPS_UTIL dependencies on MTL_ITEM_CATALOG_GROUPS_TL

Line 114: INSERT INTO MTL_ITEM_CATALOG_GROUPS_TL (

110: P_Catalog_Group_Rec.LAST_UPDATED_BY,
111: P_Catalog_Group_Rec.LAST_UPDATE_LOGIN
112: ) RETURNING ROWID INTO X_ROWID;
113:
114: INSERT INTO MTL_ITEM_CATALOG_GROUPS_TL (
115: ITEM_CATALOG_GROUP_ID,
116: DESCRIPTION,
117: CREATION_DATE,
118: CREATED_BY,

Line 137: FROM MTL_ITEM_CATALOG_GROUPS_TL T

133: USERENV('LANG')
134: FROM FND_LANGUAGES L
135: WHERE L.INSTALLED_FLAG in ('I', 'B')
136: AND NOT EXISTS (SELECT NULL
137: FROM MTL_ITEM_CATALOG_GROUPS_TL T
138: WHERE T.ITEM_CATALOG_GROUP_ID = P_Catalog_Group_Rec.ITEM_CATALOG_GROUP_ID
139: AND T.LANGUAGE = L.LANGUAGE_CODE);
140:
141: --Bug: 4639946

Line 214: FROM MTL_ITEM_CATALOG_GROUPS_TL

210: CURSOR c_get_description_rec IS
211: SELECT
212: DESCRIPTION,
213: DECODE(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
214: FROM MTL_ITEM_CATALOG_GROUPS_TL
215: WHERE ITEM_CATALOG_GROUP_ID = P_Catalog_Group_Rec.ITEM_CATALOG_GROUP_ID
216: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG)
217: FOR UPDATE OF ITEM_CATALOG_GROUP_ID NOWAIT;
218:

Line 415: UPDATE MTL_ITEM_CATALOG_GROUPS_TL

411: RAISE no_data_found;
412: END IF;
413:
414:
415: UPDATE MTL_ITEM_CATALOG_GROUPS_TL
416: SET
417: DESCRIPTION = P_Catalog_Group_Rec.DESCRIPTION,
418: LAST_UPDATE_DATE = P_Catalog_Group_Rec.LAST_UPDATE_DATE,
419: LAST_UPDATED_BY = P_Catalog_Group_Rec.LAST_UPDATED_BY,

Line 450: DELETE FROM MTL_ITEM_CATALOG_GROUPS_TL

446: PROCEDURE DELETE_ROW (X_ITEM_CATALOG_GROUP_ID IN MTL_ITEM_CATALOG_GROUPS.ITEM_CATALOG_GROUP_ID%TYPE)
447: IS
448: BEGIN
449:
450: DELETE FROM MTL_ITEM_CATALOG_GROUPS_TL
451: WHERE ITEM_CATALOG_GROUP_ID = X_ITEM_CATALOG_GROUP_ID;
452:
453: IF (SQL%NOTFOUND) THEN
454: RAISE no_data_found;

Line 469: DELETE FROM MTL_ITEM_CATALOG_GROUPS_TL T

465:
466: PROCEDURE ADD_LANGUAGE IS
467: BEGIN
468:
469: DELETE FROM MTL_ITEM_CATALOG_GROUPS_TL T
470: WHERE NOT EXISTS (SELECT NULL
471: FROM MTL_ITEM_CATALOG_GROUPS_B B
472: WHERE B.ITEM_CATALOG_GROUP_ID = T.ITEM_CATALOG_GROUP_ID);
473:

Line 474: UPDATE MTL_ITEM_CATALOG_GROUPS_TL T

470: WHERE NOT EXISTS (SELECT NULL
471: FROM MTL_ITEM_CATALOG_GROUPS_B B
472: WHERE B.ITEM_CATALOG_GROUP_ID = T.ITEM_CATALOG_GROUP_ID);
473:
474: UPDATE MTL_ITEM_CATALOG_GROUPS_TL T
475: SET (DESCRIPTION) = (SELECT B.DESCRIPTION
476: FROM MTL_ITEM_CATALOG_GROUPS_TL B
477: WHERE B.ITEM_CATALOG_GROUP_ID = T.ITEM_CATALOG_GROUP_ID
478: AND B.LANGUAGE = T.SOURCE_LANG)

Line 476: FROM MTL_ITEM_CATALOG_GROUPS_TL B

472: WHERE B.ITEM_CATALOG_GROUP_ID = T.ITEM_CATALOG_GROUP_ID);
473:
474: UPDATE MTL_ITEM_CATALOG_GROUPS_TL T
475: SET (DESCRIPTION) = (SELECT B.DESCRIPTION
476: FROM MTL_ITEM_CATALOG_GROUPS_TL B
477: WHERE B.ITEM_CATALOG_GROUP_ID = T.ITEM_CATALOG_GROUP_ID
478: AND B.LANGUAGE = T.SOURCE_LANG)
479: WHERE ( T.ITEM_CATALOG_GROUP_ID,T.LANGUAGE)
480: IN (SELECT SUBT.ITEM_CATALOG_GROUP_ID,

Line 482: FROM MTL_ITEM_CATALOG_GROUPS_TL SUBB,

478: AND B.LANGUAGE = T.SOURCE_LANG)
479: WHERE ( T.ITEM_CATALOG_GROUP_ID,T.LANGUAGE)
480: IN (SELECT SUBT.ITEM_CATALOG_GROUP_ID,
481: SUBT.LANGUAGE
482: FROM MTL_ITEM_CATALOG_GROUPS_TL SUBB,
483: MTL_ITEM_CATALOG_GROUPS_TL SUBT
484: WHERE SUBB.ITEM_CATALOG_GROUP_ID = SUBT.ITEM_CATALOG_GROUP_ID
485: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
486: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 483: MTL_ITEM_CATALOG_GROUPS_TL SUBT

479: WHERE ( T.ITEM_CATALOG_GROUP_ID,T.LANGUAGE)
480: IN (SELECT SUBT.ITEM_CATALOG_GROUP_ID,
481: SUBT.LANGUAGE
482: FROM MTL_ITEM_CATALOG_GROUPS_TL SUBB,
483: MTL_ITEM_CATALOG_GROUPS_TL SUBT
484: WHERE SUBB.ITEM_CATALOG_GROUP_ID = SUBT.ITEM_CATALOG_GROUP_ID
485: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
486: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
487: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 490: INSERT INTO MTL_ITEM_CATALOG_GROUPS_TL (

486: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
487: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
488: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)));
489:
490: INSERT INTO MTL_ITEM_CATALOG_GROUPS_TL (
491: ITEM_CATALOG_GROUP_ID,
492: DESCRIPTION,
493: CREATION_DATE,
494: CREATED_BY,

Line 510: FROM MTL_ITEM_CATALOG_GROUPS_TL B,

506: B.LAST_UPDATED_BY,
507: B.LAST_UPDATE_LOGIN,
508: L.LANGUAGE_CODE,
509: B.SOURCE_LANG
510: FROM MTL_ITEM_CATALOG_GROUPS_TL B,
511: FND_LANGUAGES L
512: WHERE L.INSTALLED_FLAG in ('I', 'B')
513: AND B.LANGUAGE = userenv('LANG')
514: AND NOT EXISTS (SELECT NULL

Line 515: FROM MTL_ITEM_CATALOG_GROUPS_TL T

511: FND_LANGUAGES L
512: WHERE L.INSTALLED_FLAG in ('I', 'B')
513: AND B.LANGUAGE = userenv('LANG')
514: AND NOT EXISTS (SELECT NULL
515: FROM MTL_ITEM_CATALOG_GROUPS_TL T
516: WHERE T.ITEM_CATALOG_GROUP_ID = B.ITEM_CATALOG_GROUP_ID
517: AND T.LANGUAGE = L.LANGUAGE_CODE);
518:
519: END ADD_LANGUAGE;