DBA Data[Home] [Help]

APPS.EGO_EXT_FWK_PUB dependencies on EGO_ACTN_GRP_ENTRIES_B

Line 13946: DELETE FROM EGO_ACTN_GRP_ENTRIES_B

13942: END IF;
13943:
13944: -- If there are Actions in this Action Group, we delete their entries
13945: -- in the Action_Group_Entries table (but we don't delete the Actions).
13946: DELETE FROM EGO_ACTN_GRP_ENTRIES_B
13947: WHERE
13948: ACTION_GROUP_ID = p_action_group_id;
13949:
13950: DELETE FROM EGO_ACTION_GROUPS_B

Line 14035: FROM EGO_ACTN_GRP_ENTRIES_B

14031: END IF;
14032:
14033: SELECT COUNT(ACTION_ID)
14034: INTO l_exist_action_count
14035: FROM EGO_ACTN_GRP_ENTRIES_B
14036: WHERE ACTION_GROUP_ID = p_action_group_id
14037: AND ACTION_ID = p_action_id;
14038:
14039: IF (l_exist_action_count = 0) THEN

Line 14040: INSERT INTO EGO_ACTN_GRP_ENTRIES_B

14036: WHERE ACTION_GROUP_ID = p_action_group_id
14037: AND ACTION_ID = p_action_id;
14038:
14039: IF (l_exist_action_count = 0) THEN
14040: INSERT INTO EGO_ACTN_GRP_ENTRIES_B
14041: (
14042: ACTION_GROUP_ID
14043: ,ACTION_ID
14044: ,SEQUENCE

Line 14133: UPDATE EGO_ACTN_GRP_ENTRIES_B

14129: IF FND_API.To_Boolean(p_init_msg_list) THEN
14130: FND_MSG_PUB.Initialize;
14131: END IF;
14132:
14133: UPDATE EGO_ACTN_GRP_ENTRIES_B
14134: SET SEQUENCE = p_sequence
14135: WHERE ACTION_GROUP_ID = p_action_group_id
14136: AND ACTION_ID = p_action_id;
14137:

Line 14203: DELETE FROM EGO_ACTN_GRP_ENTRIES_B

14199: IF FND_API.To_Boolean(p_init_msg_list) THEN
14200: FND_MSG_PUB.Initialize;
14201: END IF;
14202:
14203: DELETE FROM EGO_ACTN_GRP_ENTRIES_B
14204: WHERE
14205: ACTION_GROUP_ID = p_action_group_id AND
14206: ACTION_ID = p_action_id;
14207: