APPS.EGO_EXT_FWK_PUB dependencies on EGO_PAGES_TL

Line 9332: INSERT INTO EGO_PAGES_TL

9328: ,g_current_user_id
9329: ,g_current_login_id
9330: );
9331:
9332: INSERT INTO EGO_PAGES_TL
9333: (
9334: PAGE_ID
9335: ,DISPLAY_NAME
9336: ,DESCRIPTION

Line 9450: UPDATE EGO_PAGES_TL

9446:
9447: END IF;
9448:
9449: -- We update the TL information whether or not we're in NLS mode
9450: UPDATE EGO_PAGES_TL
9451: SET DISPLAY_NAME = p_display_name,
9452: DESCRIPTION = p_description,
9453: LAST_UPDATED_BY = g_current_user_id,
9454: LAST_UPDATE_DATE = l_Sysdate,

Line 9620: DELETE FROM EGO_PAGES_TL

9616:
9617: DELETE FROM EGO_PAGES_B
9618: WHERE PAGE_ID = p_page_id;
9619:
9620: DELETE FROM EGO_PAGES_TL
9621: WHERE PAGE_ID = p_page_id;
9622:
9623: -- Standard check of p_commit
9624: IF FND_API.To_Boolean(p_commit) THEN

Line 13540: delete from EGO_PAGES_TL T

13536:
13537: PROCEDURE Add_Language_for_Pages IS
13538: BEGIN
13539:
13540: delete from EGO_PAGES_TL T
13541: where not exists
13542: (select NULL
13543: from EGO_PAGES_B B
13544: where B.PAGE_ID = T.PAGE_ID

Line 13547: update EGO_PAGES_TL T set (

13543: from EGO_PAGES_B B
13544: where B.PAGE_ID = T.PAGE_ID
13545: );
13546:
13547: update EGO_PAGES_TL T set (
13548: DISPLAY_NAME,
13549: DESCRIPTION
13550: ) = (select
13551: B.DISPLAY_NAME,

Line 13553: from EGO_PAGES_TL B

13549: DESCRIPTION
13550: ) = (select
13551: B.DISPLAY_NAME,
13552: B.DESCRIPTION
13553: from EGO_PAGES_TL B
13554: where B.PAGE_ID = T.PAGE_ID
13555: and B.LANGUAGE = T.SOURCE_LANG)
13556: where (
13557: T.PAGE_ID,

Line 13562: from EGO_PAGES_TL SUBB, EGO_PAGES_TL SUBT

13558: T.LANGUAGE
13559: ) in (select
13560: SUBT.PAGE_ID,
13561: SUBT.LANGUAGE
13562: from EGO_PAGES_TL SUBB, EGO_PAGES_TL SUBT
13563: where SUBB.PAGE_ID = SUBT.PAGE_ID
13564: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
13565: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
13566: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 13571: insert into EGO_PAGES_TL (

13567: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
13568: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
13569: ));
13570:
13571: insert into EGO_PAGES_TL (
13572: PAGE_ID,
13573: DISPLAY_NAME,
13574: DESCRIPTION,
13575: CREATED_BY,

Line 13593: from EGO_PAGES_TL B, FND_LANGUAGES L

13589: B.LAST_UPDATE_DATE,
13590: B.LAST_UPDATE_LOGIN,
13591: L.LANGUAGE_CODE,
13592: B.SOURCE_LANG
13593: from EGO_PAGES_TL B, FND_LANGUAGES L
13594: where L.INSTALLED_FLAG in ('I', 'B')
13595: and B.LANGUAGE = userenv('LANG')
13596: and not exists
13597: (select NULL

Line 13598: from EGO_PAGES_TL T

13594: where L.INSTALLED_FLAG in ('I', 'B')
13595: and B.LANGUAGE = userenv('LANG')
13596: and not exists
13597: (select NULL
13598: from EGO_PAGES_TL T
13599: where T.PAGE_ID = B.PAGE_ID
13600: and T.LANGUAGE = L.LANGUAGE_CODE);
13601:
13602: END Add_Language_for_Pages;

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

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
13688: Add_Language_for_Data_level;
13689: END IF;