APPS.EGO_EXT_FWK_PUB dependencies on EGO_FUNCTIONS_TL

Line 11173: INSERT INTO EGO_FUNCTIONS_TL

11169: ,g_current_user_id
11170: ,g_current_login_id
11171: );
11172:
11173: INSERT INTO EGO_FUNCTIONS_TL
11174: (
11175: FUNCTION_ID
11176: ,DISPLAY_NAME
11177: ,DESCRIPTION

Line 11283: UPDATE EGO_FUNCTIONS_TL

11279:
11280: WHERE
11281: FUNCTION_ID = p_function_id;
11282:
11283: UPDATE EGO_FUNCTIONS_TL
11284: SET
11285: DISPLAY_NAME = p_display_name
11286: , DESCRIPTION = p_description
11287: , LAST_UPDATE_DATE = l_Sysdate

Line 11401: DELETE FROM EGO_FUNCTIONS_TL

11397: DELETE FROM EGO_FUNCTIONS_B
11398: WHERE
11399: FUNCTION_ID = p_function_id;
11400:
11401: DELETE FROM EGO_FUNCTIONS_TL
11402: WHERE
11403: FUNCTION_ID = p_function_id;
11404:
11405: -- Standard check of p_commit

Line 14374: delete from EGO_FUNCTIONS_TL T

14370:
14371: PROCEDURE Add_Language_for_Function IS
14372: BEGIN
14373:
14374: delete from EGO_FUNCTIONS_TL T
14375: where not exists
14376: (select NULL
14377: from EGO_FUNCTIONS_B B
14378: where B.FUNCTION_ID = T.FUNCTION_ID

Line 14381: update EGO_FUNCTIONS_TL T set (

14377: from EGO_FUNCTIONS_B B
14378: where B.FUNCTION_ID = T.FUNCTION_ID
14379: );
14380:
14381: update EGO_FUNCTIONS_TL T set (
14382: DISPLAY_NAME,
14383: DESCRIPTION
14384: ) = (select
14385: B.DISPLAY_NAME,

Line 14387: from EGO_FUNCTIONS_TL B

14383: DESCRIPTION
14384: ) = (select
14385: B.DISPLAY_NAME,
14386: B.DESCRIPTION
14387: from EGO_FUNCTIONS_TL B
14388: where B.FUNCTION_ID = T.FUNCTION_ID
14389: and B.LANGUAGE = T.SOURCE_LANG)
14390: where (
14391: T.FUNCTION_ID,

Line 14396: from EGO_FUNCTIONS_TL SUBB, EGO_FUNCTIONS_TL SUBT

14392: T.LANGUAGE
14393: ) in (select
14394: SUBT.FUNCTION_ID,
14395: SUBT.LANGUAGE
14396: from EGO_FUNCTIONS_TL SUBB, EGO_FUNCTIONS_TL SUBT
14397: where SUBB.FUNCTION_ID = SUBT.FUNCTION_ID
14398: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
14399: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
14400: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 14405: insert into EGO_FUNCTIONS_TL (

14401: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
14402: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
14403: ));
14404:
14405: insert into EGO_FUNCTIONS_TL (
14406: CREATION_DATE,
14407: LAST_UPDATED_BY,
14408: LAST_UPDATE_DATE,
14409: LAST_UPDATE_LOGIN,

Line 14427: from EGO_FUNCTIONS_TL B, FND_LANGUAGES L

14423: B.DISPLAY_NAME,
14424: B.DESCRIPTION,
14425: L.LANGUAGE_CODE,
14426: B.SOURCE_LANG
14427: from EGO_FUNCTIONS_TL B, FND_LANGUAGES L
14428: where L.INSTALLED_FLAG in ('I', 'B')
14429: and B.LANGUAGE = userenv('LANG')
14430: and not exists
14431: (select NULL

Line 14432: from EGO_FUNCTIONS_TL T

14428: where L.INSTALLED_FLAG in ('I', 'B')
14429: and B.LANGUAGE = userenv('LANG')
14430: and not exists
14431: (select NULL
14432: from EGO_FUNCTIONS_TL T
14433: where T.FUNCTION_ID = B.FUNCTION_ID
14434: and T.LANGUAGE = L.LANGUAGE_CODE);
14435:
14436: END Add_Language_for_Function;

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

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