APPS.OKC_UDA_TEMPLATES_UTIL dependencies on EGO_OBJ_AG_ASSOCS_B

Line 715: FROM EGO_OBJ_AG_ASSOCS_B assoc

711: IS
712:
713: CURSOR c_get_assoc_csr IS
714: SELECT data_level, attr_group_id, enabled_flag, view_privilege_id, edit_privilege_id
715: FROM EGO_OBJ_AG_ASSOCS_B assoc
716: WHERE assoc.OBJECT_ID = p_object_id
717: AND assoc.CLASSIFICATION_CODE = p_src_template_code;
718:
719: CURSOR c_gen_association_id IS

Line 1132: FROM EGO_PAGE_ENTRIES_V entries_view, EGO_OBJ_AG_ASSOCS_B assoc

1128: AND pages.object_id = p_object_id;
1129:
1130: CURSOR c_get_page_entries_csr(p_page_id NUMBER) IS
1131: SELECT entries_view.association_id , entries_view.SEQUENCE, assoc.attr_group_id
1132: FROM EGO_PAGE_ENTRIES_V entries_view, EGO_OBJ_AG_ASSOCS_B assoc
1133: WHERE entries_view.OBJECT_ID = p_object_id
1134: AND entries_view.CLASSIFICATION_CODE = p_src_template_code
1135: AND assoc.association_id = entries_view.association_id
1136: AND entries_view. page_id = p_page_id;

Line 1195: FROM EGO_OBJ_AG_ASSOCS_B assoc

1191: FOR c_get_page_entries_csr_rec IN c_get_page_entries_csr(c_get_pages_csr_rec.page_id) LOOP
1192:
1193: BEGIN
1194: SELECT association_id INTO l_association_id
1195: FROM EGO_OBJ_AG_ASSOCS_B assoc
1196: WHERE assoc.OBJECT_ID = p_object_id
1197: AND assoc.CLASSIFICATION_CODE = p_new_template_code
1198: AND assoc.ATTR_GROUP_ID = c_get_page_entries_csr_rec.attr_group_id;
1199:

Line 1538: select ASSOCIATION_ID from EGO_OBJ_AG_ASSOCS_B

1534: WHERE CLASSIFICATION_CODE = p_uda_temp_id
1535: AND OBJECT_ID = p_object_id;
1536:
1537: CURSOR association_ids(p_object_id NUMBER, p_uda_temp_id VARCHAR2) IS
1538: select ASSOCIATION_ID from EGO_OBJ_AG_ASSOCS_B
1539: where object_id = p_object_id
1540: and classification_code = p_uda_temp_id;
1541:
1542: CURSOR c_get_action_id(p_object_id NUMBER, p_uda_temp_id VARCHAR2) IS