[Home] [Help]
1034: WHERE APPLICATION_ID = p_application_id
1035: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
1036: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name;
1037:
1038: DELETE FROM EGO_ATTR_GROUP_DL
1039: WHERE ATTR_GROUP_ID = (SELECT ATTR_GROUP_ID
1040: FROM EGO_ATTR_GROUPS_V
1041: WHERE APPLICATION_ID = p_application_id
1042: AND ATTR_GROUP_TYPE = p_attr_group_type
4864: END IF;
4865: code_debug(l_api_name ||' Post Event '||l_raise_post_event);
4866:
4867: IF p_transaction_type = 'CREATE' THEN
4868: INSERT INTO EGO_ATTR_GROUP_DL
4869: (attr_group_id
4870: ,data_level_id
4871: ,defaulting
4872: ,view_privilege_id
4893: ,NVL(p_last_update_date, SYSDATE)
4894: ,G_CURRENT_LOGIN_ID
4895: );
4896: ELSE
4897: UPDATE EGO_ATTR_GROUP_DL
4898: SET defaulting = l_defaulting
4899: ,view_privilege_id = l_view_priv_id
4900: ,edit_privilege_id = l_edit_priv_id
4901: ,raise_pre_event = l_raise_pre_event
9291:
9292: CURSOR data_level_merge (cp_attr_group_id IN NUMBER
9293: ,cp_classification_code IN VARCHAR2) IS
9294: SELECT attr_grp_dl.data_level_id data_level_id, dl_meta.data_level_name data_level_name
9295: FROM ego_data_level_b dl_meta, ego_attr_group_dl attr_grp_dl
9296: WHERE attr_grp_dl.data_level_id = dl_meta.data_level_id
9297: AND attr_grp_dl.attr_group_id = cp_attr_group_id
9298: AND NOT EXISTS
9299: (SELECT 1
15445: RETURN VARCHAR2 IS
15446:
15447: CURSOR c_data_levels(p_attr_grp_id IN NUMBER) IS
15448: SELECT DL_TL.user_data_level_name data_level_name
15449: FROM EGO_ATTR_GROUP_DL AG_DL, EGO_DATA_LEVEL_B DL_B, EGO_DATA_LEVEL_TL DL_TL
15450: WHERE AG_DL.data_level_id = DL_B.data_level_id
15451: AND DL_B.data_level_id = DL_TL.data_level_id
15452: AND UserEnv('LANG')=LANGUAGE
15453: AND AG_DL.attr_group_id = p_attr_grp_id;