[Home] [Help]
994: WHERE APPLICATION_ID = p_application_id
995: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
996: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name;
997:
998: DELETE FROM EGO_ATTR_GROUP_DL
999: WHERE ATTR_GROUP_ID = (SELECT ATTR_GROUP_ID
1000: FROM EGO_ATTR_GROUPS_V
1001: WHERE APPLICATION_ID = p_application_id
1002: AND ATTR_GROUP_TYPE = p_attr_group_type
4728: END IF;
4729: code_debug(l_api_name ||' Post Event '||l_raise_post_event);
4730:
4731: IF p_transaction_type = 'CREATE' THEN
4732: INSERT INTO EGO_ATTR_GROUP_DL
4733: (attr_group_id
4734: ,data_level_id
4735: ,defaulting
4736: ,view_privilege_id
4757: ,NVL(p_last_update_date, SYSDATE)
4758: ,G_CURRENT_LOGIN_ID
4759: );
4760: ELSE
4761: UPDATE EGO_ATTR_GROUP_DL
4762: SET defaulting = l_defaulting
4763: ,view_privilege_id = l_view_priv_id
4764: ,edit_privilege_id = l_edit_priv_id
4765: ,raise_pre_event = l_raise_pre_event
8332:
8333: CURSOR data_level_merge (cp_attr_group_id IN NUMBER
8334: ,cp_classification_code IN VARCHAR2) IS
8335: SELECT attr_grp_dl.data_level_id data_level_id, dl_meta.data_level_name data_level_name
8336: FROM ego_data_level_b dl_meta, ego_attr_group_dl attr_grp_dl
8337: WHERE attr_grp_dl.data_level_id = dl_meta.data_level_id
8338: AND attr_grp_dl.attr_group_id = cp_attr_group_id
8339: AND NOT EXISTS
8340: (SELECT 1
14375: RETURN VARCHAR2 IS
14376:
14377: CURSOR c_data_levels(p_attr_grp_id IN NUMBER) IS
14378: SELECT DL_TL.user_data_level_name data_level_name
14379: FROM EGO_ATTR_GROUP_DL AG_DL, EGO_DATA_LEVEL_B DL_B, EGO_DATA_LEVEL_TL DL_TL
14380: WHERE AG_DL.data_level_id = DL_B.data_level_id
14381: AND DL_B.data_level_id = DL_TL.data_level_id
14382: AND UserEnv('LANG')=LANGUAGE
14383: AND AG_DL.attr_group_id = p_attr_grp_id;