APPS.EGO_EXT_FWK_PUB dependencies on EGO_OBJ_AG_ASSOCS_B

Line 1045: FROM EGO_OBJ_AG_ASSOCS_B

1041:
1042: IF p_object_id IS NOT NULL THEN
1043: SELECT ASSOCIATION_ID
1044: INTO l_association_id
1045: FROM EGO_OBJ_AG_ASSOCS_B
1046: WHERE OBJECT_ID = p_object_id
1047: AND CLASSIFICATION_CODE = p_classification_code
1048: AND ATTR_GROUP_ID = p_attr_group_id;
1049: END IF;

Line 1138: FROM EGO_OBJ_AG_ASSOCS_B

1134: ,p_attr_group_name);
1135:
1136: SELECT COUNT(*)
1137: INTO l_assocs_num
1138: FROM EGO_OBJ_AG_ASSOCS_B
1139: WHERE ATTR_GROUP_ID = l_attr_group_id
1140: AND ENABLED_FLAG = 'Y';
1141:
1142: IF (l_assocs_num > 0) OR (l_change_assocs_exist = TRUE) THEN

Line 1736: FROM EGO_OBJ_AG_ASSOCS_B

1732: BEGIN
1733:
1734: SELECT DISTINCT DATA_LEVEL
1735: INTO l_data_level
1736: FROM EGO_OBJ_AG_ASSOCS_B
1737: WHERE ATTR_GROUP_ID = p_attr_group_id
1738: AND OBJECT_ID = p_object_id
1739: AND ROWNUM < 2;
1740:

Line 8341: FROM EGO_OBJ_AG_ASSOCS_B

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
8341: FROM EGO_OBJ_AG_ASSOCS_B
8342: WHERE classification_code = p_classification_code
8343: AND attr_group_id = cp_attr_group_id
8344: AND data_level_id = dl_meta.data_level_id
8345: );

Line 8448: INSERT INTO EGO_OBJ_AG_ASSOCS_B

8444:
8445: IF(x_association_id IS NOT NULL) THEN
8446: -- used only for the creation of single association
8447: -- it is assumed that when the user is passing p_association_id , it is for a single association record
8448: INSERT INTO EGO_OBJ_AG_ASSOCS_B
8449: (
8450: ASSOCIATION_ID
8451: ,OBJECT_ID
8452: ,CLASSIFICATION_CODE

Line 8490: INSERT INTO EGO_OBJ_AG_ASSOCS_B

8486: LOOP
8487: FETCH data_level_merge INTO cursor_rec;
8488: EXIT WHEN data_level_merge%NOTFOUND;
8489:
8490: INSERT INTO EGO_OBJ_AG_ASSOCS_B
8491: (
8492: ASSOCIATION_ID,
8493: OBJECT_ID,
8494: CLASSIFICATION_CODE,

Line 8815: UPDATE EGO_OBJ_AG_ASSOCS_B

8811: --bug 5513610
8812: /*DELETE FROM EGO_PAGE_ENTRIES_B
8813: WHERE ASSOCIATION_ID = p_association_id;*/
8814:
8815: UPDATE EGO_OBJ_AG_ASSOCS_B
8816: SET ENABLED_FLAG = p_enabled_flag,
8817: VIEW_PRIVILEGE_ID = p_view_privilege_id,
8818: EDIT_PRIVILEGE_ID = p_edit_privilege_id,
8819: LAST_UPDATE_DATE = l_Sysdate,

Line 9064: FROM ego_obj_ag_assocs_b

9060: SELECT *
9061: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V
9062: WHERE (object_id, classification_code, attr_group_id) IN
9063: (SELECT object_id, classification_code, attr_group_id
9064: FROM ego_obj_ag_assocs_b
9065: where association_id = cp_association_id);
9066:
9067: BEGIN
9068: code_debug(l_api_name||' started for association '||p_association_id);

Line 9091: DELETE FROM EGO_OBJ_AG_ASSOCS_B

9087: code_debug(l_api_name||' deleting association forcefully ');
9088: --delete association blindly
9089: FOR cr IN get_assoc_records(cp_association_id => p_association_id) LOOP
9090: code_debug(l_api_name||' deleting association forcefully for assoc : '||cr.association_id);
9091: DELETE FROM EGO_OBJ_AG_ASSOCS_B
9092: WHERE association_id = cr.association_id;
9093: END LOOP;
9094: l_is_ok_to_delete := TRUE;
9095: ELSE

Line 9193: DELETE FROM EGO_OBJ_AG_ASSOCS_B

9189: code_debug(l_api_name||' deleting association as conditions are met for assoc :'||cr.association_id);
9190: DELETE FROM EGO_PAGE_ENTRIES_B
9191: WHERE ASSOCIATION_ID = cr.association_id;
9192:
9193: DELETE FROM EGO_OBJ_AG_ASSOCS_B
9194: WHERE ASSOCIATION_ID = cr.association_id;
9195: ELSE
9196: code_debug(l_api_name||' CANNOT delete as prod specific conditions are not met for :'||cr.association_id);
9197: EXIT;