145: x_msg_count OUT nocopy NUMBER,
146: x_msg_data OUT nocopy VARCHAR2
147: )
148: IS
149: l_obj_ver hz_locations.object_version_number%TYPE;
150:
151: CURSOR l_cur IS
152: SELECT object_version_number,location_id
153: from hz_locations
149: l_obj_ver hz_locations.object_version_number%TYPE;
150:
151: CURSOR l_cur IS
152: SELECT object_version_number,location_id
153: from hz_locations
154: where location_id =
155: (SELECT location_id
156: FROM hz_party_sites
157: WHERE party_site_id = p_request_rec.party_site_id