APPS.EGO_PAGES_BULKLOAD_PVT dependencies on EGO_OBJ_AG_ASSOCS_B

Line 434: FROM EGO_OBJ_AG_ASSOCS_B

430:
431: /*Sets the old_association_id*/
432: UPDATE ego_page_entries_interface epi
433: SET old_association_id = (SELECT association_id
434: FROM EGO_OBJ_AG_ASSOCS_B
435: WHERE classification_code IN ( SELECT PARENT_CATALOG_GROUP_ID
436: FROM EGO_ITEM_CAT_DENORM_HIER
437: WHERE CHILD_CATALOG_GROUP_ID = epi.classification_code)
438: AND attr_group_id = epi.old_attr_group_id

Line 459: FROM EGO_OBJ_AG_ASSOCS_B

455:
456: /*Sets the new_association_id*/
457: UPDATE ego_page_entries_interface epi
458: SET new_association_id = (SELECT association_id
459: FROM EGO_OBJ_AG_ASSOCS_B
460: WHERE classification_code IN ( SELECT PARENT_CATALOG_GROUP_ID
461: FROM EGO_ITEM_CAT_DENORM_HIER
462: WHERE CHILD_CATALOG_GROUP_ID = epi.classification_code)
463: AND attr_group_id = epi.new_attr_group_id

Line 1249: FROM EGO_OBJ_AG_ASSOCS_B

1245: /*Sets the old_attr_group_id*/
1246: IF (p_ent_tbl(i).old_attr_group_id IS NOT NULL AND p_ent_tbl(i).classification_code IS NOT NULL) THEN
1247: BEGIN
1248: SELECT association_id INTO p_ent_tbl(i).old_association_id
1249: FROM EGO_OBJ_AG_ASSOCS_B
1250: WHERE classification_code = p_ent_tbl(i).classification_code
1251: AND attr_group_id = p_ent_tbl(i).old_attr_group_id;
1252: EXCEPTION
1253: WHEN NO_DATA_FOUND THEN

Line 1283: FROM EGO_OBJ_AG_ASSOCS_B

1279: /*Sets the new_attr_group_id*/
1280: IF (p_ent_tbl(i).new_attr_group_id IS NOT NULL AND p_ent_tbl(i).classification_code IS NOT NULL) THEN
1281: BEGIN
1282: SELECT association_id INTO p_ent_tbl(i).new_association_id
1283: FROM EGO_OBJ_AG_ASSOCS_B
1284: WHERE classification_code = p_ent_tbl(i).classification_code
1285: AND attr_group_id = p_ent_tbl(i).new_attr_group_id;
1286: EXCEPTION
1287: WHEN NO_DATA_FOUND THEN