APPS.EGO_EXT_FWK_PUB dependencies on EGO_FUNCTIONS_TL

Line 10203: INSERT INTO EGO_FUNCTIONS_TL

10199: ,g_current_user_id
10200: ,g_current_login_id
10201: );
10202:
10203: INSERT INTO EGO_FUNCTIONS_TL
10204: (
10205: FUNCTION_ID
10206: ,DISPLAY_NAME
10207: ,DESCRIPTION

Line 10313: UPDATE EGO_FUNCTIONS_TL

10309:
10310: WHERE
10311: FUNCTION_ID = p_function_id;
10312:
10313: UPDATE EGO_FUNCTIONS_TL
10314: SET
10315: DISPLAY_NAME = p_display_name
10316: , DESCRIPTION = p_description
10317: , LAST_UPDATE_DATE = l_Sysdate

Line 10431: DELETE FROM EGO_FUNCTIONS_TL

10427: DELETE FROM EGO_FUNCTIONS_B
10428: WHERE
10429: FUNCTION_ID = p_function_id;
10430:
10431: DELETE FROM EGO_FUNCTIONS_TL
10432: WHERE
10433: FUNCTION_ID = p_function_id;
10434:
10435: -- Standard check of p_commit

Line 13402: delete from EGO_FUNCTIONS_TL T

13398:
13399: PROCEDURE Add_Language_for_Function IS
13400: BEGIN
13401:
13402: delete from EGO_FUNCTIONS_TL T
13403: where not exists
13404: (select NULL
13405: from EGO_FUNCTIONS_B B
13406: where B.FUNCTION_ID = T.FUNCTION_ID

Line 13409: update EGO_FUNCTIONS_TL T set (

13405: from EGO_FUNCTIONS_B B
13406: where B.FUNCTION_ID = T.FUNCTION_ID
13407: );
13408:
13409: update EGO_FUNCTIONS_TL T set (
13410: DISPLAY_NAME,
13411: DESCRIPTION
13412: ) = (select
13413: B.DISPLAY_NAME,

Line 13415: from EGO_FUNCTIONS_TL B

13411: DESCRIPTION
13412: ) = (select
13413: B.DISPLAY_NAME,
13414: B.DESCRIPTION
13415: from EGO_FUNCTIONS_TL B
13416: where B.FUNCTION_ID = T.FUNCTION_ID
13417: and B.LANGUAGE = T.SOURCE_LANG)
13418: where (
13419: T.FUNCTION_ID,

Line 13424: from EGO_FUNCTIONS_TL SUBB, EGO_FUNCTIONS_TL SUBT

13420: T.LANGUAGE
13421: ) in (select
13422: SUBT.FUNCTION_ID,
13423: SUBT.LANGUAGE
13424: from EGO_FUNCTIONS_TL SUBB, EGO_FUNCTIONS_TL SUBT
13425: where SUBB.FUNCTION_ID = SUBT.FUNCTION_ID
13426: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
13427: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
13428: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 13433: insert into EGO_FUNCTIONS_TL (

13429: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
13430: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
13431: ));
13432:
13433: insert into EGO_FUNCTIONS_TL (
13434: CREATION_DATE,
13435: LAST_UPDATED_BY,
13436: LAST_UPDATE_DATE,
13437: LAST_UPDATE_LOGIN,

Line 13455: from EGO_FUNCTIONS_TL B, FND_LANGUAGES L

13451: B.DISPLAY_NAME,
13452: B.DESCRIPTION,
13453: L.LANGUAGE_CODE,
13454: B.SOURCE_LANG
13455: from EGO_FUNCTIONS_TL B, FND_LANGUAGES L
13456: where L.INSTALLED_FLAG in ('I', 'B')
13457: and B.LANGUAGE = userenv('LANG')
13458: and not exists
13459: (select NULL

Line 13460: from EGO_FUNCTIONS_TL T

13456: where L.INSTALLED_FLAG in ('I', 'B')
13457: and B.LANGUAGE = userenv('LANG')
13458: and not exists
13459: (select NULL
13460: from EGO_FUNCTIONS_TL T
13461: where T.FUNCTION_ID = B.FUNCTION_ID
13462: and T.LANGUAGE = L.LANGUAGE_CODE);
13463:
13464: END Add_Language_for_Function;

Line 13681: ELSIF (p_tl_table_name = 'EGO_FUNCTIONS_TL') THEN

13677: IF (p_tl_table_name = 'EGO_ACTIONS_TL') THEN
13678: Add_Language_for_Action;
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