APPS.EGO_EXT_FWK_PUB dependencies on EGO_ACTION_GROUPS_TL

Line 13758: INSERT INTO EGO_ACTION_GROUPS_TL

13754: ,g_current_user_id
13755: ,g_current_login_id
13756: );
13757:
13758: INSERT INTO EGO_ACTION_GROUPS_TL
13759: (
13760: ACTION_GROUP_ID
13761: ,DISPLAY_NAME
13762: ,DESCRIPTION

Line 13867: UPDATE EGO_ACTION_GROUPS_TL

13863:
13864: WHERE
13865: ACTION_GROUP_ID = p_action_group_id;
13866:
13867: UPDATE EGO_ACTION_GROUPS_TL
13868: SET
13869: DESCRIPTION = p_description
13870: , DISPLAY_NAME = p_display_name
13871: , LAST_UPDATE_DATE = l_Sysdate

Line 13954: DELETE FROM EGO_ACTION_GROUPS_TL

13950: DELETE FROM EGO_ACTION_GROUPS_B
13951: WHERE
13952: ACTION_GROUP_ID = p_action_group_id;
13953:
13954: DELETE FROM EGO_ACTION_GROUPS_TL
13955: WHERE
13956: ACTION_GROUP_ID = p_action_group_id;
13957:
13958: -- Standard check of p_commit

Line 14305: delete from EGO_ACTION_GROUPS_TL T

14301:
14302: PROCEDURE Add_Language_for_Action_Group IS
14303: BEGIN
14304:
14305: delete from EGO_ACTION_GROUPS_TL T
14306: where not exists
14307: (select NULL
14308: from EGO_ACTION_GROUPS_B B
14309: where B.ACTION_GROUP_ID = T.ACTION_GROUP_ID

Line 14312: update EGO_ACTION_GROUPS_TL T set (

14308: from EGO_ACTION_GROUPS_B B
14309: where B.ACTION_GROUP_ID = T.ACTION_GROUP_ID
14310: );
14311:
14312: update EGO_ACTION_GROUPS_TL T set (
14313: DISPLAY_NAME,
14314: DESCRIPTION
14315: ) = (select
14316: B.DISPLAY_NAME,

Line 14318: from EGO_ACTION_GROUPS_TL B

14314: DESCRIPTION
14315: ) = (select
14316: B.DISPLAY_NAME,
14317: B.DESCRIPTION
14318: from EGO_ACTION_GROUPS_TL B
14319: where B.ACTION_GROUP_ID = T.ACTION_GROUP_ID
14320: and B.LANGUAGE = T.SOURCE_LANG)
14321: where (
14322: T.ACTION_GROUP_ID,

Line 14327: from EGO_ACTION_GROUPS_TL SUBB, EGO_ACTION_GROUPS_TL SUBT

14323: T.LANGUAGE
14324: ) in (select
14325: SUBT.ACTION_GROUP_ID,
14326: SUBT.LANGUAGE
14327: from EGO_ACTION_GROUPS_TL SUBB, EGO_ACTION_GROUPS_TL SUBT
14328: where SUBB.ACTION_GROUP_ID = SUBT.ACTION_GROUP_ID
14329: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
14330: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
14331: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 14336: insert into EGO_ACTION_GROUPS_TL (

14332: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
14333: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
14334: ));
14335:
14336: insert into EGO_ACTION_GROUPS_TL (
14337: ACTION_GROUP_ID,
14338: DISPLAY_NAME,
14339: DESCRIPTION,
14340: CREATED_BY,

Line 14358: from EGO_ACTION_GROUPS_TL B, FND_LANGUAGES L

14354: B.LAST_UPDATE_DATE,
14355: B.LAST_UPDATE_LOGIN,
14356: L.LANGUAGE_CODE,
14357: B.SOURCE_LANG
14358: from EGO_ACTION_GROUPS_TL B, FND_LANGUAGES L
14359: where L.INSTALLED_FLAG in ('I', 'B')
14360: and B.LANGUAGE = userenv('LANG')
14361: and not exists
14362: (select NULL

Line 14363: from EGO_ACTION_GROUPS_TL T

14359: where L.INSTALLED_FLAG in ('I', 'B')
14360: and B.LANGUAGE = userenv('LANG')
14361: and not exists
14362: (select NULL
14363: from EGO_ACTION_GROUPS_TL T
14364: where T.ACTION_GROUP_ID = B.ACTION_GROUP_ID
14365: and T.LANGUAGE = L.LANGUAGE_CODE);
14366:
14367: END Add_Language_for_Action_Group;

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

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