APPS.EGO_EXT_FWK_PUB dependencies on EGO_FUNC_PARAMS_TL

Line 11884: INSERT INTO EGO_FUNC_PARAMS_TL

11880: ,g_current_user_id
11881: ,g_current_login_id
11882: );
11883:
11884: INSERT INTO EGO_FUNC_PARAMS_TL
11885: (
11886: FUNC_PARAM_ID
11887: ,DISPLAY_NAME
11888: ,LANGUAGE

Line 11988: UPDATE EGO_FUNC_PARAMS_TL

11984: ,LAST_UPDATE_LOGIN = g_current_login_id
11985: WHERE
11986: FUNC_PARAM_ID = p_function_param_id;
11987:
11988: UPDATE EGO_FUNC_PARAMS_TL
11989: SET
11990: DISPLAY_NAME = p_display_name
11991: ,LAST_UPDATE_DATE = l_Sysdate
11992: ,LAST_UPDATED_BY = g_current_user_id

Line 12070: DELETE FROM EGO_FUNC_PARAMS_TL

12066: DELETE FROM EGO_FUNC_PARAMS_B
12067: WHERE
12068: FUNC_PARAM_ID = p_function_param_id;
12069:
12070: DELETE FROM EGO_FUNC_PARAMS_TL
12071: WHERE
12072: FUNC_PARAM_ID = p_function_param_id;
12073:
12074: DELETE FROM EGO_MAPPINGS_B

Line 13471: delete from EGO_FUNC_PARAMS_TL T

13467:
13468: PROCEDURE Add_Language_for_Func_Param IS
13469: BEGIN
13470:
13471: delete from EGO_FUNC_PARAMS_TL T
13472: where not exists
13473: (select NULL
13474: from EGO_FUNC_PARAMS_B B
13475: where B.FUNC_PARAM_ID = T.FUNC_PARAM_ID

Line 13478: update EGO_FUNC_PARAMS_TL T set (

13474: from EGO_FUNC_PARAMS_B B
13475: where B.FUNC_PARAM_ID = T.FUNC_PARAM_ID
13476: );
13477:
13478: update EGO_FUNC_PARAMS_TL T set (
13479: DISPLAY_NAME,
13480: DESCRIPTION
13481: ) = (select
13482: B.DISPLAY_NAME,

Line 13484: from EGO_FUNC_PARAMS_TL B

13480: DESCRIPTION
13481: ) = (select
13482: B.DISPLAY_NAME,
13483: B.DESCRIPTION
13484: from EGO_FUNC_PARAMS_TL B
13485: where B.FUNC_PARAM_ID = T.FUNC_PARAM_ID
13486: and B.LANGUAGE = T.SOURCE_LANG)
13487: where (
13488: T.FUNC_PARAM_ID,

Line 13493: from EGO_FUNC_PARAMS_TL SUBB, EGO_FUNC_PARAMS_TL SUBT

13489: T.LANGUAGE
13490: ) in (select
13491: SUBT.FUNC_PARAM_ID,
13492: SUBT.LANGUAGE
13493: from EGO_FUNC_PARAMS_TL SUBB, EGO_FUNC_PARAMS_TL SUBT
13494: where SUBB.FUNC_PARAM_ID = SUBT.FUNC_PARAM_ID
13495: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
13496: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
13497: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 13502: insert into EGO_FUNC_PARAMS_TL (

13498: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
13499: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
13500: ));
13501:
13502: insert into EGO_FUNC_PARAMS_TL (
13503: FUNC_PARAM_ID,
13504: DISPLAY_NAME,
13505: DESCRIPTION,
13506: CREATED_BY,

Line 13524: from EGO_FUNC_PARAMS_TL B, FND_LANGUAGES L

13520: B.LAST_UPDATE_DATE,
13521: B.LAST_UPDATE_LOGIN,
13522: L.LANGUAGE_CODE,
13523: B.SOURCE_LANG
13524: from EGO_FUNC_PARAMS_TL B, FND_LANGUAGES L
13525: where L.INSTALLED_FLAG in ('I', 'B')
13526: and B.LANGUAGE = userenv('LANG')
13527: and not exists
13528: (select NULL

Line 13529: from EGO_FUNC_PARAMS_TL T

13525: where L.INSTALLED_FLAG in ('I', 'B')
13526: and B.LANGUAGE = userenv('LANG')
13527: and not exists
13528: (select NULL
13529: from EGO_FUNC_PARAMS_TL T
13530: where T.FUNC_PARAM_ID = B.FUNC_PARAM_ID
13531: and T.LANGUAGE = L.LANGUAGE_CODE);
13532:
13533: END Add_Language_for_Func_Param;

Line 13683: ELSIF (p_tl_table_name = 'EGO_FUNC_PARAMS_TL') THEN

13679: ELSIF (p_tl_table_name = 'EGO_ACTION_GROUPS_TL') THEN
13680: Add_Language_for_Action_Group;
13681: ELSIF (p_tl_table_name = 'EGO_FUNCTIONS_TL') THEN
13682: Add_Language_for_Function;
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