APPS.EGO_EXT_FWK_PUB dependencies on EGO_OBJ_ATTR_GRP_ASSOCS_V

Line 8393: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V

8389: -- SSARNOBA: Why do we have this SELECT INTO statement? We're not using
8390: -- l_variant_exist_count anywhere.
8391: SELECT COUNT(*)
8392: INTO l_variant_exist_count
8393: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V
8394: WHERE OBJECT_ID = p_object_id
8395: AND CLASSIFICATION_CODE = p_classification_code
8396: AND VARIANT = 'Y'
8397: AND EXISTS (SELECT 'X'

Line 9054: l_association_row EGO_OBJ_ATTR_GRP_ASSOCS_V%ROWTYPE;

9050: INDEX BY BINARY_INTEGER;
9051:
9052: l_dummy_rec LOCAL_DEL_ASSOC_CHECK_REC;
9053: l_del_assoc_table LOCAL_DEL_ASSOC_CHECK_TABLE;
9054: l_association_row EGO_OBJ_ATTR_GRP_ASSOCS_V%ROWTYPE;
9055: l_del_assoc_check_index NUMBER;
9056: l_is_ok_to_delete BOOLEAN := TRUE;
9057: l_api_to_call VARCHAR2(999);
9058:

Line 9061: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V

9057: l_api_to_call VARCHAR2(999);
9058:
9059: CURSOR get_assoc_records (cp_association_id IN NUMBER) IS
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);

Line 9872: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V A,

9868: ,EGO_EXT_FWK_PUB.Get_Class_Meaning(A.OBJECT_ID, PE.CLASSIFICATION_CODE)
9869: INTO l_ag_disp_name
9870: ,l_page_disp_name
9871: ,l_class_meaning
9872: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V A,
9873: EGO_PAGE_ENTRIES_V PE
9874: WHERE A.ASSOCIATION_ID = PE.ASSOCIATION_ID
9875: AND PE.PAGE_ID = p_page_id
9876: AND PE.ASSOCIATION_ID = p_association_id;

Line 9999: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V A,

9995: ,EGO_EXT_FWK_PUB.Get_Class_Meaning(A.OBJECT_ID, PE.CLASSIFICATION_CODE)
9996: INTO l_ag_disp_name
9997: ,l_page_disp_name
9998: ,l_class_meaning
9999: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V A,
10000: EGO_PAGE_ENTRIES_V PE
10001: WHERE A.ASSOCIATION_ID = PE.ASSOCIATION_ID
10002: AND PE.PAGE_ID = p_page_id
10003: AND PE.ASSOCIATION_ID = p_new_association_id;