APPS.EGO_EXT_FWK_PUB dependencies on EGO_OBJ_AG_ASSOCS_B

Line 1085: FROM EGO_OBJ_AG_ASSOCS_B

1081:
1082: IF p_object_id IS NOT NULL THEN
1083: SELECT ASSOCIATION_ID
1084: INTO l_association_id
1085: FROM EGO_OBJ_AG_ASSOCS_B
1086: WHERE OBJECT_ID = p_object_id
1087: AND CLASSIFICATION_CODE = p_classification_code
1088: AND ATTR_GROUP_ID = p_attr_group_id;
1089: END IF;

Line 1178: FROM EGO_OBJ_AG_ASSOCS_B

1174: ,p_attr_group_name);
1175:
1176: SELECT COUNT(*)
1177: INTO l_assocs_num
1178: FROM EGO_OBJ_AG_ASSOCS_B
1179: WHERE ATTR_GROUP_ID = l_attr_group_id
1180: AND ENABLED_FLAG = 'Y';
1181:
1182: IF (l_assocs_num > 0) OR (l_change_assocs_exist = TRUE) THEN

Line 1818: FROM EGO_OBJ_AG_ASSOCS_B

1814: BEGIN
1815:
1816: SELECT DISTINCT DATA_LEVEL
1817: INTO l_data_level
1818: FROM EGO_OBJ_AG_ASSOCS_B
1819: WHERE ATTR_GROUP_ID = p_attr_group_id
1820: AND OBJECT_ID = p_object_id
1821: AND ROWNUM < 2;
1822:

Line 9300: FROM EGO_OBJ_AG_ASSOCS_B

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
9300: FROM EGO_OBJ_AG_ASSOCS_B
9301: WHERE classification_code = p_classification_code
9302: AND attr_group_id = cp_attr_group_id
9303: AND data_level_id = dl_meta.data_level_id
9304: );

Line 9412: INSERT INTO EGO_OBJ_AG_ASSOCS_B

9408:
9409: IF(x_association_id IS NOT NULL) THEN
9410: -- used only for the creation of single association
9411: -- it is assumed that when the user is passing p_association_id , it is for a single association record
9412: INSERT INTO EGO_OBJ_AG_ASSOCS_B
9413: (
9414: ASSOCIATION_ID
9415: ,OBJECT_ID
9416: ,CLASSIFICATION_CODE

Line 9455: INSERT INTO EGO_OBJ_AG_ASSOCS_B

9451: LOOP
9452: FETCH data_level_merge INTO cursor_rec;
9453: EXIT WHEN data_level_merge%NOTFOUND;
9454:
9455: INSERT INTO EGO_OBJ_AG_ASSOCS_B
9456: (
9457: ASSOCIATION_ID,
9458: OBJECT_ID,
9459: CLASSIFICATION_CODE,

Line 9785: UPDATE EGO_OBJ_AG_ASSOCS_B

9781: --bug 5513610
9782: /*DELETE FROM EGO_PAGE_ENTRIES_B
9783: WHERE ASSOCIATION_ID = p_association_id;*/
9784:
9785: UPDATE EGO_OBJ_AG_ASSOCS_B
9786: SET ENABLED_FLAG = p_enabled_flag,
9787: VIEW_PRIVILEGE_ID = p_view_privilege_id,
9788: EDIT_PRIVILEGE_ID = p_edit_privilege_id,
9789: LAST_UPDATE_DATE = l_Sysdate,

Line 10034: FROM ego_obj_ag_assocs_b

10030: SELECT *
10031: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V
10032: WHERE (object_id, classification_code, attr_group_id) IN
10033: (SELECT object_id, classification_code, attr_group_id
10034: FROM ego_obj_ag_assocs_b
10035: where association_id = cp_association_id);
10036:
10037: BEGIN
10038: code_debug(l_api_name||' started for association '||p_association_id);

Line 10061: DELETE FROM EGO_OBJ_AG_ASSOCS_B

10057: code_debug(l_api_name||' deleting association forcefully ');
10058: --delete association blindly
10059: FOR cr IN get_assoc_records(cp_association_id => p_association_id) LOOP
10060: code_debug(l_api_name||' deleting association forcefully for assoc : '||cr.association_id);
10061: DELETE FROM EGO_OBJ_AG_ASSOCS_B
10062: WHERE association_id = cr.association_id;
10063: END LOOP;
10064: l_is_ok_to_delete := TRUE;
10065: ELSE

Line 10163: DELETE FROM EGO_OBJ_AG_ASSOCS_B

10159: code_debug(l_api_name||' deleting association as conditions are met for assoc :'||cr.association_id);
10160: DELETE FROM EGO_PAGE_ENTRIES_B
10161: WHERE ASSOCIATION_ID = cr.association_id;
10162:
10163: DELETE FROM EGO_OBJ_AG_ASSOCS_B
10164: WHERE ASSOCIATION_ID = cr.association_id;
10165: ELSE
10166: code_debug(l_api_name||' CANNOT delete as prod specific conditions are not met for :'||cr.association_id);
10167: EXIT;