APPS.EGO_TL_LANG_ENABLE_PUB dependencies on MTL_CATEGORIES_TL

Line 54: insert into MTL_CATEGORIES_TL (

50: begin
51:
52: --insert new row in all installed languages in the TL table
53: --IF no rows in those installed languages already exist
54: insert into MTL_CATEGORIES_TL (
55: CATEGORY_ID,
56: LANGUAGE,
57: SOURCE_LANG,
58: DESCRIPTION,

Line 74: from FND_LANGUAGES L, MTL_CATEGORIES_TL TL

70: TL.LAST_UPDATED_BY,
71: TL.CREATION_DATE,
72: TL.CREATED_BY,
73: TL.LAST_UPDATE_LOGIN
74: from FND_LANGUAGES L, MTL_CATEGORIES_TL TL
75: where L.INSTALLED_FLAG in ('I', 'B')
76: and TL.CATEGORY_ID = X_CATEGORY_ID
77: and not exists
78: ( select NULL

Line 79: from MTL_CATEGORIES_TL T

75: where L.INSTALLED_FLAG in ('I', 'B')
76: and TL.CATEGORY_ID = X_CATEGORY_ID
77: and not exists
78: ( select NULL
79: from MTL_CATEGORIES_TL T
80: where T.CATEGORY_ID = X_CATEGORY_ID
81: and T.LANGUAGE = L.LANGUAGE_CODE );
82:
83: end handle_category_language_rows;