APPS.EGO_EXT_FWK_PUB dependencies on EGO_DATA_LEVEL_TL

Line 4432: INSERT INTO EGO_DATA_LEVEL_TL

4428: ,NVL(p_last_update_date, SYSDATE)
4429: ,G_CURRENT_LOGIN_ID
4430: );
4431:
4432: INSERT INTO EGO_DATA_LEVEL_TL
4433: (data_level_id
4434: ,user_data_level_name
4435: ,language
4436: ,source_lang

Line 4470: UPDATE EGO_DATA_LEVEL_TL

4466: fnd_message.set_name(G_APP_NAME, 'EGO_EF_INVALID_DATA_LEVEL');
4467: FND_MSG_PUB.Add;
4468: RAISE FND_API.G_EXC_ERROR;
4469: END IF;
4470: UPDATE EGO_DATA_LEVEL_TL
4471: SET user_data_level_name = NVL(p_user_data_level_name, p_data_level_name)
4472: ,source_lang = userenv('LANG') -- Bug 6964013
4473: ,last_updated_by = NVL(p_last_updated_by, G_CURRENT_USER_ID)
4474: ,last_update_date = NVL(p_last_update_date, SYSDATE)

Line 14581: DELETE FROM EGO_DATA_LEVEL_TL T

14577:
14578: PROCEDURE Add_Language_for_Data_level IS
14579: BEGIN
14580:
14581: DELETE FROM EGO_DATA_LEVEL_TL T
14582: WHERE NOT EXISTS
14583: (SELECT NULL
14584: FROM EGO_DATA_LEVEL_B B
14585: WHERE B.DATA_LEVEL_ID = T.DATA_LEVEL_ID

Line 14588: UPDATE EGO_DATA_LEVEL_TL T

14584: FROM EGO_DATA_LEVEL_B B
14585: WHERE B.DATA_LEVEL_ID = T.DATA_LEVEL_ID
14586: );
14587:
14588: UPDATE EGO_DATA_LEVEL_TL T
14589: SET (USER_DATA_LEVEL_NAME
14590: )
14591: =
14592: (SELECT B.USER_DATA_LEVEL_NAME

Line 14593: FROM EGO_DATA_LEVEL_TL B

14589: SET (USER_DATA_LEVEL_NAME
14590: )
14591: =
14592: (SELECT B.USER_DATA_LEVEL_NAME
14593: FROM EGO_DATA_LEVEL_TL B
14594: WHERE B.DATA_LEVEL_ID = T.DATA_LEVEL_ID
14595: AND B.LANGUAGE = T.SOURCE_LANG)
14596: WHERE (
14597: T.DATA_LEVEL_ID,

Line 14604: from EGO_DATA_LEVEL_TL SUBB, EGO_DATA_LEVEL_TL SUBT

14600: IN
14601: (SELECT
14602: SUBT.DATA_LEVEL_ID,
14603: SUBT.LANGUAGE
14604: from EGO_DATA_LEVEL_TL SUBB, EGO_DATA_LEVEL_TL SUBT
14605: where SUBB.DATA_LEVEL_ID = SUBT.DATA_LEVEL_ID
14606: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
14607: and SUBB.USER_DATA_LEVEL_NAME <> SUBT.USER_DATA_LEVEL_NAME
14608: );

Line 14610: INSERT INTO EGO_DATA_LEVEL_TL (

14606: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
14607: and SUBB.USER_DATA_LEVEL_NAME <> SUBT.USER_DATA_LEVEL_NAME
14608: );
14609:
14610: INSERT INTO EGO_DATA_LEVEL_TL (
14611: DATA_LEVEL_ID,
14612: USER_DATA_LEVEL_NAME,
14613: CREATED_BY,
14614: CREATION_DATE,

Line 14630: from EGO_DATA_LEVEL_TL B, FND_LANGUAGES L

14626: B.LAST_UPDATE_DATE,
14627: B.LAST_UPDATE_LOGIN,
14628: L.LANGUAGE_CODE,
14629: B.SOURCE_LANG
14630: from EGO_DATA_LEVEL_TL B, FND_LANGUAGES L
14631: where L.INSTALLED_FLAG in ('I', 'B')
14632: and B.LANGUAGE = userenv('LANG')
14633: and not exists
14634: (select NULL

Line 14635: from EGO_DATA_LEVEL_TL T

14631: where L.INSTALLED_FLAG in ('I', 'B')
14632: and B.LANGUAGE = userenv('LANG')
14633: and not exists
14634: (select NULL
14635: from EGO_DATA_LEVEL_TL T
14636: where T.DATA_LEVEL_ID = B.DATA_LEVEL_ID
14637: and T.LANGUAGE = L.LANGUAGE_CODE);
14638:
14639: END Add_Language_for_Data_level;

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

14735: ELSIF (p_tl_table_name = 'EGO_FUNC_PARAMS_TL') THEN
14736: Add_Language_for_Func_Param;
14737: ELSIF (p_tl_table_name = 'EGO_PAGES_TL') THEN
14738: Add_Language_for_Pages;
14739: ELSIF (p_tl_table_name = 'EGO_DATA_LEVEL_TL') THEN
14740: Add_Language_for_Data_level;
14741: ELSIF (p_tl_table_name = 'EGO_FLEX_VALUE_VERSION_TL') THEN
14742: Add_Language_for_Flex_Value;
14743: END IF;

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

15445: RETURN VARCHAR2 IS
15446:
15447: CURSOR c_data_levels(p_attr_grp_id IN NUMBER) IS
15448: SELECT DL_TL.user_data_level_name data_level_name
15449: FROM EGO_ATTR_GROUP_DL AG_DL, EGO_DATA_LEVEL_B DL_B, EGO_DATA_LEVEL_TL DL_TL
15450: WHERE AG_DL.data_level_id = DL_B.data_level_id
15451: AND DL_B.data_level_id = DL_TL.data_level_id
15452: AND UserEnv('LANG')=LANGUAGE
15453: AND AG_DL.attr_group_id = p_attr_grp_id;