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
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
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
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:
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: