APPS.EGO_EXT_FWK_PUB dependencies on EGO_PAGES_TL

Line 10302: INSERT INTO EGO_PAGES_TL

10298: ,g_current_user_id
10299: ,g_current_login_id
10300: );
10301:
10302: INSERT INTO EGO_PAGES_TL
10303: (
10304: PAGE_ID
10305: ,DISPLAY_NAME
10306: ,DESCRIPTION

Line 10420: UPDATE EGO_PAGES_TL

10416:
10417: END IF;
10418:
10419: -- We update the TL information whether or not we're in NLS mode
10420: UPDATE EGO_PAGES_TL
10421: SET DISPLAY_NAME = p_display_name,
10422: DESCRIPTION = p_description,
10423: LAST_UPDATED_BY = g_current_user_id,
10424: LAST_UPDATE_DATE = l_Sysdate,

Line 10590: DELETE FROM EGO_PAGES_TL

10586:
10587: DELETE FROM EGO_PAGES_B
10588: WHERE PAGE_ID = p_page_id;
10589:
10590: DELETE FROM EGO_PAGES_TL
10591: WHERE PAGE_ID = p_page_id;
10592:
10593: -- Standard check of p_commit
10594: IF FND_API.To_Boolean(p_commit) THEN

Line 14512: delete from EGO_PAGES_TL T

14508:
14509: PROCEDURE Add_Language_for_Pages IS
14510: BEGIN
14511:
14512: delete from EGO_PAGES_TL T
14513: where not exists
14514: (select NULL
14515: from EGO_PAGES_B B
14516: where B.PAGE_ID = T.PAGE_ID

Line 14519: update EGO_PAGES_TL T set (

14515: from EGO_PAGES_B B
14516: where B.PAGE_ID = T.PAGE_ID
14517: );
14518:
14519: update EGO_PAGES_TL T set (
14520: DISPLAY_NAME,
14521: DESCRIPTION
14522: ) = (select
14523: B.DISPLAY_NAME,

Line 14525: from EGO_PAGES_TL B

14521: DESCRIPTION
14522: ) = (select
14523: B.DISPLAY_NAME,
14524: B.DESCRIPTION
14525: from EGO_PAGES_TL B
14526: where B.PAGE_ID = T.PAGE_ID
14527: and B.LANGUAGE = T.SOURCE_LANG)
14528: where (
14529: T.PAGE_ID,

Line 14534: from EGO_PAGES_TL SUBB, EGO_PAGES_TL SUBT

14530: T.LANGUAGE
14531: ) in (select
14532: SUBT.PAGE_ID,
14533: SUBT.LANGUAGE
14534: from EGO_PAGES_TL SUBB, EGO_PAGES_TL SUBT
14535: where SUBB.PAGE_ID = SUBT.PAGE_ID
14536: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
14537: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
14538: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 14543: insert into EGO_PAGES_TL (

14539: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
14540: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
14541: ));
14542:
14543: insert into EGO_PAGES_TL (
14544: PAGE_ID,
14545: DISPLAY_NAME,
14546: DESCRIPTION,
14547: CREATED_BY,

Line 14565: from EGO_PAGES_TL B, FND_LANGUAGES L

14561: B.LAST_UPDATE_DATE,
14562: B.LAST_UPDATE_LOGIN,
14563: L.LANGUAGE_CODE,
14564: B.SOURCE_LANG
14565: from EGO_PAGES_TL B, FND_LANGUAGES L
14566: where L.INSTALLED_FLAG in ('I', 'B')
14567: and B.LANGUAGE = userenv('LANG')
14568: and not exists
14569: (select NULL

Line 14570: from EGO_PAGES_TL T

14566: where L.INSTALLED_FLAG in ('I', 'B')
14567: and B.LANGUAGE = userenv('LANG')
14568: and not exists
14569: (select NULL
14570: from EGO_PAGES_TL T
14571: where T.PAGE_ID = B.PAGE_ID
14572: and T.LANGUAGE = L.LANGUAGE_CODE);
14573:
14574: END Add_Language_for_Pages;

Line 14737: ELSIF (p_tl_table_name = 'EGO_PAGES_TL') THEN

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
14740: Add_Language_for_Data_level;
14741: ELSIF (p_tl_table_name = 'EGO_FLEX_VALUE_VERSION_TL') THEN