APPS.EGO_EXT_FWK_PUB dependencies on EGO_ACTIONS_TL

Line 11563: INSERT INTO EGO_ACTIONS_TL

11559: ,g_current_user_id
11560: ,g_current_login_id
11561: );
11562:
11563: INSERT INTO EGO_ACTIONS_TL
11564: (
11565: ACTION_ID
11566: ,DESCRIPTION
11567: ,LANGUAGE

Line 11861: UPDATE EGO_ACTIONS_TL

11857: , ENABLE_KEY_ATTRIBUTES = p_enable_key_attrs
11858: WHERE
11859: ACTION_ID = p_action_id;
11860:
11861: UPDATE EGO_ACTIONS_TL
11862: SET
11863: DESCRIPTION = p_description
11864: , LAST_UPDATE_DATE = l_Sysdate
11865: , LAST_UPDATED_BY = g_current_user_id

Line 11980: DELETE FROM EGO_ACTIONS_TL

11976: DELETE FROM EGO_ACTIONS_B
11977: WHERE
11978: ACTION_ID = p_action_id;
11979:
11980: DELETE FROM EGO_ACTIONS_TL
11981: WHERE
11982: ACTION_ID = p_action_id;
11983:
11984: SELECT COUNT(*)

Line 14240: delete from EGO_ACTIONS_TL T

14236: PROCEDURE Add_Language_for_Action IS
14237:
14238: BEGIN
14239:
14240: delete from EGO_ACTIONS_TL T
14241: where not exists
14242: (select NULL
14243: from EGO_ACTIONS_B B
14244: where B.ACTION_ID = T.ACTION_ID

Line 14247: update EGO_ACTIONS_TL T set (

14243: from EGO_ACTIONS_B B
14244: where B.ACTION_ID = T.ACTION_ID
14245: );
14246:
14247: update EGO_ACTIONS_TL T set (
14248: DESCRIPTION
14249: ) = (select
14250: B.DESCRIPTION
14251: from EGO_ACTIONS_TL B

Line 14251: from EGO_ACTIONS_TL B

14247: update EGO_ACTIONS_TL T set (
14248: DESCRIPTION
14249: ) = (select
14250: B.DESCRIPTION
14251: from EGO_ACTIONS_TL B
14252: where B.ACTION_ID = T.ACTION_ID
14253: and B.LANGUAGE = T.SOURCE_LANG)
14254: where (
14255: T.ACTION_ID,

Line 14260: from EGO_ACTIONS_TL SUBB, EGO_ACTIONS_TL SUBT

14256: T.LANGUAGE
14257: ) in (select
14258: SUBT.ACTION_ID,
14259: SUBT.LANGUAGE
14260: from EGO_ACTIONS_TL SUBB, EGO_ACTIONS_TL SUBT
14261: where SUBB.ACTION_ID = SUBT.ACTION_ID
14262: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
14263: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
14264: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 14268: insert into EGO_ACTIONS_TL (

14264: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
14265: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
14266: ));
14267:
14268: insert into EGO_ACTIONS_TL (
14269: ACTION_ID,
14270: DESCRIPTION,
14271: CREATED_BY,
14272: CREATION_DATE,

Line 14288: from EGO_ACTIONS_TL B, FND_LANGUAGES L

14284: B.LAST_UPDATE_DATE,
14285: B.LAST_UPDATE_LOGIN,
14286: L.LANGUAGE_CODE,
14287: B.SOURCE_LANG
14288: from EGO_ACTIONS_TL B, FND_LANGUAGES L
14289: where L.INSTALLED_FLAG in ('I', 'B')
14290: and B.LANGUAGE = userenv('LANG')
14291: and not exists
14292: (select NULL

Line 14293: from EGO_ACTIONS_TL T

14289: where L.INSTALLED_FLAG in ('I', 'B')
14290: and B.LANGUAGE = userenv('LANG')
14291: and not exists
14292: (select NULL
14293: from EGO_ACTIONS_TL T
14294: where T.ACTION_ID = B.ACTION_ID
14295: and T.LANGUAGE = L.LANGUAGE_CODE);
14296:
14297: END Add_Language_for_Action;

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

14725: ) IS
14726:
14727: BEGIN
14728:
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