APPS.EGO_EXT_FWK_PUB dependencies on EGO_DATA_LEVEL_TL

Line 4307: INSERT INTO EGO_DATA_LEVEL_TL

4303: ,NVL(p_last_update_date, SYSDATE)
4304: ,G_CURRENT_LOGIN_ID
4305: );
4306:
4307: INSERT INTO EGO_DATA_LEVEL_TL
4308: (data_level_id
4309: ,user_data_level_name
4310: ,language
4311: ,source_lang

Line 4345: UPDATE EGO_DATA_LEVEL_TL

4341: fnd_message.set_name(G_APP_NAME, 'EGO_EF_INVALID_DATA_LEVEL');
4342: FND_MSG_PUB.Add;
4343: RAISE FND_API.G_EXC_ERROR;
4344: END IF;
4345: UPDATE EGO_DATA_LEVEL_TL
4346: SET user_data_level_name = NVL(p_user_data_level_name, p_data_level_name)
4347: ,source_lang = userenv('LANG') -- Bug 6964013
4348: ,last_updated_by = NVL(p_last_updated_by, G_CURRENT_USER_ID)
4349: ,last_update_date = NVL(p_last_update_date, SYSDATE)

Line 13609: DELETE FROM EGO_DATA_LEVEL_TL T

13605:
13606: PROCEDURE Add_Language_for_Data_level IS
13607: BEGIN
13608:
13609: DELETE FROM EGO_DATA_LEVEL_TL T
13610: WHERE NOT EXISTS
13611: (SELECT NULL
13612: FROM EGO_DATA_LEVEL_B B
13613: WHERE B.DATA_LEVEL_ID = T.DATA_LEVEL_ID

Line 13616: UPDATE EGO_DATA_LEVEL_TL T

13612: FROM EGO_DATA_LEVEL_B B
13613: WHERE B.DATA_LEVEL_ID = T.DATA_LEVEL_ID
13614: );
13615:
13616: UPDATE EGO_DATA_LEVEL_TL T
13617: SET (USER_DATA_LEVEL_NAME
13618: )
13619: =
13620: (SELECT B.USER_DATA_LEVEL_NAME

Line 13621: FROM EGO_DATA_LEVEL_TL B

13617: SET (USER_DATA_LEVEL_NAME
13618: )
13619: =
13620: (SELECT B.USER_DATA_LEVEL_NAME
13621: FROM EGO_DATA_LEVEL_TL B
13622: WHERE B.DATA_LEVEL_ID = T.DATA_LEVEL_ID
13623: AND B.LANGUAGE = T.SOURCE_LANG)
13624: WHERE (
13625: T.DATA_LEVEL_ID,

Line 13632: from EGO_DATA_LEVEL_TL SUBB, EGO_DATA_LEVEL_TL SUBT

13628: IN
13629: (SELECT
13630: SUBT.DATA_LEVEL_ID,
13631: SUBT.LANGUAGE
13632: from EGO_DATA_LEVEL_TL SUBB, EGO_DATA_LEVEL_TL SUBT
13633: where SUBB.DATA_LEVEL_ID = SUBT.DATA_LEVEL_ID
13634: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
13635: and SUBB.USER_DATA_LEVEL_NAME <> SUBT.USER_DATA_LEVEL_NAME
13636: );

Line 13638: INSERT INTO EGO_DATA_LEVEL_TL (

13634: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
13635: and SUBB.USER_DATA_LEVEL_NAME <> SUBT.USER_DATA_LEVEL_NAME
13636: );
13637:
13638: INSERT INTO EGO_DATA_LEVEL_TL (
13639: DATA_LEVEL_ID,
13640: USER_DATA_LEVEL_NAME,
13641: CREATED_BY,
13642: CREATION_DATE,

Line 13658: from EGO_DATA_LEVEL_TL B, FND_LANGUAGES L

13654: B.LAST_UPDATE_DATE,
13655: B.LAST_UPDATE_LOGIN,
13656: L.LANGUAGE_CODE,
13657: B.SOURCE_LANG
13658: from EGO_DATA_LEVEL_TL B, FND_LANGUAGES L
13659: where L.INSTALLED_FLAG in ('I', 'B')
13660: and B.LANGUAGE = userenv('LANG')
13661: and not exists
13662: (select NULL

Line 13663: from EGO_DATA_LEVEL_TL T

13659: where L.INSTALLED_FLAG in ('I', 'B')
13660: and B.LANGUAGE = userenv('LANG')
13661: and not exists
13662: (select NULL
13663: from EGO_DATA_LEVEL_TL T
13664: where T.DATA_LEVEL_ID = B.DATA_LEVEL_ID
13665: and T.LANGUAGE = L.LANGUAGE_CODE);
13666:
13667: END Add_Language_for_Data_level;

Line 13687: ELSIF (p_tl_table_name = 'EGO_DATA_LEVEL_TL') THEN

13683: ELSIF (p_tl_table_name = 'EGO_FUNC_PARAMS_TL') THEN
13684: Add_Language_for_Func_Param;
13685: ELSIF (p_tl_table_name = 'EGO_PAGES_TL') THEN
13686: Add_Language_for_Pages;
13687: ELSIF (p_tl_table_name = 'EGO_DATA_LEVEL_TL') THEN
13688: Add_Language_for_Data_level;
13689: END IF;
13690:
13691: END ADD_LANGUAGE;

Line 14379: FROM EGO_ATTR_GROUP_DL AG_DL, EGO_DATA_LEVEL_B DL_B, EGO_DATA_LEVEL_TL DL_TL

14375: RETURN VARCHAR2 IS
14376:
14377: CURSOR c_data_levels(p_attr_grp_id IN NUMBER) IS
14378: SELECT DL_TL.user_data_level_name data_level_name
14379: FROM EGO_ATTR_GROUP_DL AG_DL, EGO_DATA_LEVEL_B DL_B, EGO_DATA_LEVEL_TL DL_TL
14380: WHERE AG_DL.data_level_id = DL_B.data_level_id
14381: AND DL_B.data_level_id = DL_TL.data_level_id
14382: AND UserEnv('LANG')=LANGUAGE
14383: AND AG_DL.attr_group_id = p_attr_grp_id;