The following lines contain the word 'select', 'insert', 'update' or 'delete':
select extension_id
from hz_org_profiles_ext_b
where organization_profile_id = p_ext_object_id
and attr_group_id = p_attr_group_id;
select extension_id
from hz_per_profiles_ext_b
where person_profile_id = p_ext_object_id
and attr_group_id = p_attr_group_id;
select extension_id
from hz_party_sites_ext_b
where party_site_id = p_ext_object_id
and attr_group_id = p_attr_group_id;
select extension_id
from hz_locations_ext_b
where location_id = p_ext_object_id
and attr_group_id = p_attr_group_id;
/*select EGO_ATTR_GROUP_REQUEST_OBJ(
ATTR_GROUP_ID,
APPLICATION_ID,
ATTR_GROUP_TYPE,
ATTR_GROUP_NAME,
NULL,
NULL,
NULL,
NULL)*/
select EGO_USER_ATTRS_DATA_PUB.Build_Attr_Group_Request_Obj(
ATTR_GROUP_ID,
APPLICATION_ID,
ATTR_GROUP_TYPE,
ATTR_GROUP_NAME,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL)
--End bug 6503079
from ego_obj_attr_grp_assocs_v
where object_name = p_ext_object_name;
hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);