APPS.EGO_TL_LANG_ENABLE_PUB dependencies on MTL_CATEGORY_SETS_TL

Line 13: insert into MTL_CATEGORY_SETS_TL (

9: begin
10:
11: --insert new row in all installed languages in the TL table
12: --IF no rows in those installed languages already exist
13: insert into MTL_CATEGORY_SETS_TL (
14: CATEGORY_SET_ID,
15: LANGUAGE,
16: SOURCE_LANG,
17: CATEGORY_SET_NAME,

Line 35: from FND_LANGUAGES L, MTL_CATEGORY_SETS_TL TL

31: TL.LAST_UPDATED_BY,
32: TL.CREATION_DATE,
33: TL.CREATED_BY,
34: TL.LAST_UPDATE_LOGIN
35: from FND_LANGUAGES L, MTL_CATEGORY_SETS_TL TL
36: where L.INSTALLED_FLAG in ('I', 'B')
37: and TL.CATEGORY_SET_ID = X_CATEGORY_SET_ID
38: and not exists
39: ( select NULL

Line 40: from MTL_CATEGORY_SETS_TL T

36: where L.INSTALLED_FLAG in ('I', 'B')
37: and TL.CATEGORY_SET_ID = X_CATEGORY_SET_ID
38: and not exists
39: ( select NULL
40: from MTL_CATEGORY_SETS_TL T
41: where T.CATEGORY_SET_ID = X_CATEGORY_SET_ID
42: and T.LANGUAGE = L.LANGUAGE_CODE );
43:
44: end handle_catset_language_rows;