APPS.EGO_EXT_FWK_PUB dependencies on EGO_ACTION_GROUPS_TL

Line 12786: INSERT INTO EGO_ACTION_GROUPS_TL

12782: ,g_current_user_id
12783: ,g_current_login_id
12784: );
12785:
12786: INSERT INTO EGO_ACTION_GROUPS_TL
12787: (
12788: ACTION_GROUP_ID
12789: ,DISPLAY_NAME
12790: ,DESCRIPTION

Line 12895: UPDATE EGO_ACTION_GROUPS_TL

12891:
12892: WHERE
12893: ACTION_GROUP_ID = p_action_group_id;
12894:
12895: UPDATE EGO_ACTION_GROUPS_TL
12896: SET
12897: DESCRIPTION = p_description
12898: , DISPLAY_NAME = p_display_name
12899: , LAST_UPDATE_DATE = l_Sysdate

Line 12982: DELETE FROM EGO_ACTION_GROUPS_TL

12978: DELETE FROM EGO_ACTION_GROUPS_B
12979: WHERE
12980: ACTION_GROUP_ID = p_action_group_id;
12981:
12982: DELETE FROM EGO_ACTION_GROUPS_TL
12983: WHERE
12984: ACTION_GROUP_ID = p_action_group_id;
12985:
12986: -- Standard check of p_commit

Line 13333: delete from EGO_ACTION_GROUPS_TL T

13329:
13330: PROCEDURE Add_Language_for_Action_Group IS
13331: BEGIN
13332:
13333: delete from EGO_ACTION_GROUPS_TL T
13334: where not exists
13335: (select NULL
13336: from EGO_ACTION_GROUPS_B B
13337: where B.ACTION_GROUP_ID = T.ACTION_GROUP_ID

Line 13340: update EGO_ACTION_GROUPS_TL T set (

13336: from EGO_ACTION_GROUPS_B B
13337: where B.ACTION_GROUP_ID = T.ACTION_GROUP_ID
13338: );
13339:
13340: update EGO_ACTION_GROUPS_TL T set (
13341: DISPLAY_NAME,
13342: DESCRIPTION
13343: ) = (select
13344: B.DISPLAY_NAME,

Line 13346: from EGO_ACTION_GROUPS_TL B

13342: DESCRIPTION
13343: ) = (select
13344: B.DISPLAY_NAME,
13345: B.DESCRIPTION
13346: from EGO_ACTION_GROUPS_TL B
13347: where B.ACTION_GROUP_ID = T.ACTION_GROUP_ID
13348: and B.LANGUAGE = T.SOURCE_LANG)
13349: where (
13350: T.ACTION_GROUP_ID,

Line 13355: from EGO_ACTION_GROUPS_TL SUBB, EGO_ACTION_GROUPS_TL SUBT

13351: T.LANGUAGE
13352: ) in (select
13353: SUBT.ACTION_GROUP_ID,
13354: SUBT.LANGUAGE
13355: from EGO_ACTION_GROUPS_TL SUBB, EGO_ACTION_GROUPS_TL SUBT
13356: where SUBB.ACTION_GROUP_ID = SUBT.ACTION_GROUP_ID
13357: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
13358: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
13359: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 13364: insert into EGO_ACTION_GROUPS_TL (

13360: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
13361: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
13362: ));
13363:
13364: insert into EGO_ACTION_GROUPS_TL (
13365: ACTION_GROUP_ID,
13366: DISPLAY_NAME,
13367: DESCRIPTION,
13368: CREATED_BY,

Line 13386: from EGO_ACTION_GROUPS_TL B, FND_LANGUAGES L

13382: B.LAST_UPDATE_DATE,
13383: B.LAST_UPDATE_LOGIN,
13384: L.LANGUAGE_CODE,
13385: B.SOURCE_LANG
13386: from EGO_ACTION_GROUPS_TL B, FND_LANGUAGES L
13387: where L.INSTALLED_FLAG in ('I', 'B')
13388: and B.LANGUAGE = userenv('LANG')
13389: and not exists
13390: (select NULL

Line 13391: from EGO_ACTION_GROUPS_TL T

13387: where L.INSTALLED_FLAG in ('I', 'B')
13388: and B.LANGUAGE = userenv('LANG')
13389: and not exists
13390: (select NULL
13391: from EGO_ACTION_GROUPS_TL T
13392: where T.ACTION_GROUP_ID = B.ACTION_GROUP_ID
13393: and T.LANGUAGE = L.LANGUAGE_CODE);
13394:
13395: END Add_Language_for_Action_Group;

Line 13679: ELSIF (p_tl_table_name = 'EGO_ACTION_GROUPS_TL') THEN

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
13682: Add_Language_for_Function;
13683: ELSIF (p_tl_table_name = 'EGO_FUNC_PARAMS_TL') THEN