APPS.EGO_EXT_FWK_PUB dependencies on EGO_FUNC_PARAMS_TL

Line 12856: INSERT INTO EGO_FUNC_PARAMS_TL

12852: ,g_current_user_id
12853: ,g_current_login_id
12854: );
12855:
12856: INSERT INTO EGO_FUNC_PARAMS_TL
12857: (
12858: FUNC_PARAM_ID
12859: ,DISPLAY_NAME
12860: ,LANGUAGE

Line 12960: UPDATE EGO_FUNC_PARAMS_TL

12956: ,LAST_UPDATE_LOGIN = g_current_login_id
12957: WHERE
12958: FUNC_PARAM_ID = p_function_param_id;
12959:
12960: UPDATE EGO_FUNC_PARAMS_TL
12961: SET
12962: DISPLAY_NAME = p_display_name
12963: ,LAST_UPDATE_DATE = l_Sysdate
12964: ,LAST_UPDATED_BY = g_current_user_id

Line 13042: DELETE FROM EGO_FUNC_PARAMS_TL

13038: DELETE FROM EGO_FUNC_PARAMS_B
13039: WHERE
13040: FUNC_PARAM_ID = p_function_param_id;
13041:
13042: DELETE FROM EGO_FUNC_PARAMS_TL
13043: WHERE
13044: FUNC_PARAM_ID = p_function_param_id;
13045:
13046: DELETE FROM EGO_MAPPINGS_B

Line 14443: delete from EGO_FUNC_PARAMS_TL T

14439:
14440: PROCEDURE Add_Language_for_Func_Param IS
14441: BEGIN
14442:
14443: delete from EGO_FUNC_PARAMS_TL T
14444: where not exists
14445: (select NULL
14446: from EGO_FUNC_PARAMS_B B
14447: where B.FUNC_PARAM_ID = T.FUNC_PARAM_ID

Line 14450: update EGO_FUNC_PARAMS_TL T set (

14446: from EGO_FUNC_PARAMS_B B
14447: where B.FUNC_PARAM_ID = T.FUNC_PARAM_ID
14448: );
14449:
14450: update EGO_FUNC_PARAMS_TL T set (
14451: DISPLAY_NAME,
14452: DESCRIPTION
14453: ) = (select
14454: B.DISPLAY_NAME,

Line 14456: from EGO_FUNC_PARAMS_TL B

14452: DESCRIPTION
14453: ) = (select
14454: B.DISPLAY_NAME,
14455: B.DESCRIPTION
14456: from EGO_FUNC_PARAMS_TL B
14457: where B.FUNC_PARAM_ID = T.FUNC_PARAM_ID
14458: and B.LANGUAGE = T.SOURCE_LANG)
14459: where (
14460: T.FUNC_PARAM_ID,

Line 14465: from EGO_FUNC_PARAMS_TL SUBB, EGO_FUNC_PARAMS_TL SUBT

14461: T.LANGUAGE
14462: ) in (select
14463: SUBT.FUNC_PARAM_ID,
14464: SUBT.LANGUAGE
14465: from EGO_FUNC_PARAMS_TL SUBB, EGO_FUNC_PARAMS_TL SUBT
14466: where SUBB.FUNC_PARAM_ID = SUBT.FUNC_PARAM_ID
14467: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
14468: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
14469: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 14474: insert into EGO_FUNC_PARAMS_TL (

14470: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
14471: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
14472: ));
14473:
14474: insert into EGO_FUNC_PARAMS_TL (
14475: FUNC_PARAM_ID,
14476: DISPLAY_NAME,
14477: DESCRIPTION,
14478: CREATED_BY,

Line 14496: from EGO_FUNC_PARAMS_TL B, FND_LANGUAGES L

14492: B.LAST_UPDATE_DATE,
14493: B.LAST_UPDATE_LOGIN,
14494: L.LANGUAGE_CODE,
14495: B.SOURCE_LANG
14496: from EGO_FUNC_PARAMS_TL B, FND_LANGUAGES L
14497: where L.INSTALLED_FLAG in ('I', 'B')
14498: and B.LANGUAGE = userenv('LANG')
14499: and not exists
14500: (select NULL

Line 14501: from EGO_FUNC_PARAMS_TL T

14497: where L.INSTALLED_FLAG in ('I', 'B')
14498: and B.LANGUAGE = userenv('LANG')
14499: and not exists
14500: (select NULL
14501: from EGO_FUNC_PARAMS_TL T
14502: where T.FUNC_PARAM_ID = B.FUNC_PARAM_ID
14503: and T.LANGUAGE = L.LANGUAGE_CODE);
14504:
14505: END Add_Language_for_Func_Param;

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

14731: ELSIF (p_tl_table_name = 'EGO_ACTION_GROUPS_TL') THEN
14732: Add_Language_for_Action_Group;
14733: ELSIF (p_tl_table_name = 'EGO_FUNCTIONS_TL') THEN
14734: Add_Language_for_Function;
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