DBA Data[Home] [Help]

APPS.EGO_EXT_FWK_PUB dependencies on EGO_ACTN_GRP_ENTRIES_B

Line 12974: DELETE FROM EGO_ACTN_GRP_ENTRIES_B

12970: END IF;
12971:
12972: -- If there are Actions in this Action Group, we delete their entries
12973: -- in the Action_Group_Entries table (but we don't delete the Actions).
12974: DELETE FROM EGO_ACTN_GRP_ENTRIES_B
12975: WHERE
12976: ACTION_GROUP_ID = p_action_group_id;
12977:
12978: DELETE FROM EGO_ACTION_GROUPS_B

Line 13063: FROM EGO_ACTN_GRP_ENTRIES_B

13059: END IF;
13060:
13061: SELECT COUNT(ACTION_ID)
13062: INTO l_exist_action_count
13063: FROM EGO_ACTN_GRP_ENTRIES_B
13064: WHERE ACTION_GROUP_ID = p_action_group_id
13065: AND ACTION_ID = p_action_id;
13066:
13067: IF (l_exist_action_count = 0) THEN

Line 13068: INSERT INTO EGO_ACTN_GRP_ENTRIES_B

13064: WHERE ACTION_GROUP_ID = p_action_group_id
13065: AND ACTION_ID = p_action_id;
13066:
13067: IF (l_exist_action_count = 0) THEN
13068: INSERT INTO EGO_ACTN_GRP_ENTRIES_B
13069: (
13070: ACTION_GROUP_ID
13071: ,ACTION_ID
13072: ,SEQUENCE

Line 13161: UPDATE EGO_ACTN_GRP_ENTRIES_B

13157: IF FND_API.To_Boolean(p_init_msg_list) THEN
13158: FND_MSG_PUB.Initialize;
13159: END IF;
13160:
13161: UPDATE EGO_ACTN_GRP_ENTRIES_B
13162: SET SEQUENCE = p_sequence
13163: WHERE ACTION_GROUP_ID = p_action_group_id
13164: AND ACTION_ID = p_action_id;
13165:

Line 13231: DELETE FROM EGO_ACTN_GRP_ENTRIES_B

13227: IF FND_API.To_Boolean(p_init_msg_list) THEN
13228: FND_MSG_PUB.Initialize;
13229: END IF;
13230:
13231: DELETE FROM EGO_ACTN_GRP_ENTRIES_B
13232: WHERE
13233: ACTION_GROUP_ID = p_action_group_id AND
13234: ACTION_ID = p_action_id;
13235: