APPS.EGO_EXT_FWK_PUB dependencies on EGO_ACTIONS_TL

Line 10593: INSERT INTO EGO_ACTIONS_TL

10589: ,g_current_user_id
10590: ,g_current_login_id
10591: );
10592:
10593: INSERT INTO EGO_ACTIONS_TL
10594: (
10595: ACTION_ID
10596: ,DESCRIPTION
10597: ,LANGUAGE

Line 10891: UPDATE EGO_ACTIONS_TL

10887: , ENABLE_KEY_ATTRIBUTES = p_enable_key_attrs
10888: WHERE
10889: ACTION_ID = p_action_id;
10890:
10891: UPDATE EGO_ACTIONS_TL
10892: SET
10893: DESCRIPTION = p_description
10894: , LAST_UPDATE_DATE = l_Sysdate
10895: , LAST_UPDATED_BY = g_current_user_id

Line 11010: DELETE FROM EGO_ACTIONS_TL

11006: DELETE FROM EGO_ACTIONS_B
11007: WHERE
11008: ACTION_ID = p_action_id;
11009:
11010: DELETE FROM EGO_ACTIONS_TL
11011: WHERE
11012: ACTION_ID = p_action_id;
11013:
11014: SELECT COUNT(*)

Line 13268: delete from EGO_ACTIONS_TL T

13264: PROCEDURE Add_Language_for_Action IS
13265:
13266: BEGIN
13267:
13268: delete from EGO_ACTIONS_TL T
13269: where not exists
13270: (select NULL
13271: from EGO_ACTIONS_B B
13272: where B.ACTION_ID = T.ACTION_ID

Line 13275: update EGO_ACTIONS_TL T set (

13271: from EGO_ACTIONS_B B
13272: where B.ACTION_ID = T.ACTION_ID
13273: );
13274:
13275: update EGO_ACTIONS_TL T set (
13276: DESCRIPTION
13277: ) = (select
13278: B.DESCRIPTION
13279: from EGO_ACTIONS_TL B

Line 13279: from EGO_ACTIONS_TL B

13275: update EGO_ACTIONS_TL T set (
13276: DESCRIPTION
13277: ) = (select
13278: B.DESCRIPTION
13279: from EGO_ACTIONS_TL B
13280: where B.ACTION_ID = T.ACTION_ID
13281: and B.LANGUAGE = T.SOURCE_LANG)
13282: where (
13283: T.ACTION_ID,

Line 13288: from EGO_ACTIONS_TL SUBB, EGO_ACTIONS_TL SUBT

13284: T.LANGUAGE
13285: ) in (select
13286: SUBT.ACTION_ID,
13287: SUBT.LANGUAGE
13288: from EGO_ACTIONS_TL SUBB, EGO_ACTIONS_TL SUBT
13289: where SUBB.ACTION_ID = SUBT.ACTION_ID
13290: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
13291: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
13292: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 13296: insert into EGO_ACTIONS_TL (

13292: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
13293: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
13294: ));
13295:
13296: insert into EGO_ACTIONS_TL (
13297: ACTION_ID,
13298: DESCRIPTION,
13299: CREATED_BY,
13300: CREATION_DATE,

Line 13316: from EGO_ACTIONS_TL B, FND_LANGUAGES L

13312: B.LAST_UPDATE_DATE,
13313: B.LAST_UPDATE_LOGIN,
13314: L.LANGUAGE_CODE,
13315: B.SOURCE_LANG
13316: from EGO_ACTIONS_TL B, FND_LANGUAGES L
13317: where L.INSTALLED_FLAG in ('I', 'B')
13318: and B.LANGUAGE = userenv('LANG')
13319: and not exists
13320: (select NULL

Line 13321: from EGO_ACTIONS_TL T

13317: where L.INSTALLED_FLAG in ('I', 'B')
13318: and B.LANGUAGE = userenv('LANG')
13319: and not exists
13320: (select NULL
13321: from EGO_ACTIONS_TL T
13322: where T.ACTION_ID = B.ACTION_ID
13323: and T.LANGUAGE = L.LANGUAGE_CODE);
13324:
13325: END Add_Language_for_Action;

Line 13677: IF (p_tl_table_name = 'EGO_ACTIONS_TL') THEN

13673: ) IS
13674:
13675: BEGIN
13676:
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