APPS.EGO_PAGES_BULKLOAD_PVT dependencies on EGO_OBJ_ATTR_GRP_ASSOCS_V

Line 637: FROM ego_obj_attr_grp_assocs_v

633:
634: UPDATE ego_page_entries_interface epi
635: SET ( old_attr_group_id, old_attr_group_name ) = (SELECT attr_group_id,
636: attr_group_name
637: FROM ego_obj_attr_grp_assocs_v
638: WHERE association_id = epi.old_association_id),
639: last_updated_by = G_USER_ID,
640: last_update_date = SYSDATE,
641: last_update_login = G_LOGIN_ID

Line 655: FROM ego_obj_attr_grp_assocs_v

651:
652: UPDATE ego_page_entries_interface epi
653: SET ( new_attr_group_id, new_attr_group_name ) = (SELECT attr_group_id,
654: attr_group_name
655: FROM ego_obj_attr_grp_assocs_v
656: WHERE association_id = epi.new_association_id),
657: last_updated_by = G_USER_ID,
658: last_update_date = SYSDATE,
659: last_update_login = G_LOGIN_ID

Line 673: FROM ego_obj_attr_grp_assocs_v

669:
670: UPDATE ego_page_entries_interface epi
671: SET ( old_association_id, old_attr_group_name ) = (SELECT association_id,
672: attr_group_name
673: FROM ego_obj_attr_grp_assocs_v
674: WHERE attr_group_id = epi.old_attr_group_id
675: AND classification_code = epi.classification_code),
676: last_updated_by = G_USER_ID,
677: last_update_date = SYSDATE,

Line 694: FROM ego_obj_attr_grp_assocs_v

690:
691: UPDATE ego_page_entries_interface epi
692: SET ( new_association_id, new_attr_group_name ) = (SELECT association_id,
693: attr_group_name
694: FROM ego_obj_attr_grp_assocs_v
695: WHERE attr_group_id = epi.new_attr_group_id),
696: last_updated_by = G_USER_ID,
697: last_update_date = SYSDATE,
698: last_update_login = G_LOGIN_ID

Line 897: FROM ego_obj_attr_grp_assocs_v

893: /*Sets the old_attr_group_id and old_attr_group_name, if the old_association_id is given*/
894: IF (p_ent_tbl(i).old_association_id IS NOT NULL) THEN
895: BEGIN
896: SELECT attr_group_id,attr_group_name INTO p_ent_tbl(i).old_attr_group_id, p_ent_tbl(i).old_attr_group_name
897: FROM ego_obj_attr_grp_assocs_v
898: WHERE association_id = p_ent_tbl(i).old_association_id;
899: EXCEPTION
900: WHEN NO_DATA_FOUND THEN
901: x_return_status := G_RET_STS_ERROR;

Line 929: FROM ego_obj_attr_grp_assocs_v

925: /*Sets the new_attr_group_id and new_attr_group_name, if the new_association_id is given*/
926: IF (p_ent_tbl(i).old_association_id IS NOT NULL) THEN
927: BEGIN
928: SELECT attr_group_id,attr_group_name INTO p_ent_tbl(i).new_attr_group_id, p_ent_tbl(i).new_attr_group_name
929: FROM ego_obj_attr_grp_assocs_v
930: WHERE association_id = p_ent_tbl(i).new_association_id;
931: EXCEPTION
932: WHEN NO_DATA_FOUND THEN
933: x_return_status := G_RET_STS_ERROR;

Line 961: FROM ego_obj_attr_grp_assocs_v

957: /*Sets the old_attr_group_name and old_association_id, if the old_attr_group_id is given*/
958: IF (p_ent_tbl(i).old_attr_group_id IS NOT NULL AND p_ent_tbl(i).old_attr_group_name IS NULL AND p_ent_tbl(i).old_association_id IS NULL) THEN
959: BEGIN
960: SELECT association_id,attr_group_name INTO p_ent_tbl(i).old_association_id, p_ent_tbl(i).old_attr_group_name
961: FROM ego_obj_attr_grp_assocs_v
962: WHERE attr_group_id = p_ent_tbl(i).old_attr_group_id
963: AND classification_code = p_ent_tbl(i).classification_code;
964: EXCEPTION
965: WHEN NO_DATA_FOUND THEN

Line 994: FROM ego_obj_attr_grp_assocs_v

990: /*Sets the new_attr_group_name and new_association_id, if the new_attr_group_id is given*/
991: IF (p_ent_tbl(i).new_attr_group_id IS NOT NULL AND p_ent_tbl(i).new_attr_group_name IS NULL AND p_ent_tbl(i).new_association_id IS NULL) THEN
992: BEGIN
993: SELECT association_id,attr_group_name INTO p_ent_tbl(i).new_association_id, p_ent_tbl(i).new_attr_group_name
994: FROM ego_obj_attr_grp_assocs_v
995: WHERE attr_group_id = p_ent_tbl(i).new_attr_group_id
996: AND classification_code = p_ent_tbl(i).classification_code;
997: EXCEPTION
998: WHEN NO_DATA_FOUND THEN