[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pos_hz_location_bo(hz.location_id,
hz.last_update_date,
hz.last_updated_by,
hz.creation_date,
hz.created_by,
hz.last_update_login,
hz.request_id,
hz.program_application_id,
hz.program_id,
hz.program_update_date,
hz.wh_update_date,
hz.attribute_category,
hz.attribute1,
hz.attribute2,
hz.attribute3,
hz.attribute4,
hz.attribute5,
hz.attribute6,
hz.attribute7,
hz.attribute8,
hz.attribute9,
hz.attribute10,
hz.attribute11,
hz.attribute12,
hz.attribute13,
hz.attribute14,
hz.attribute15,
hz.attribute16,
hz.attribute17,
hz.attribute18,
hz.attribute19,
hz.attribute20,
hz.global_attribute_category,
hz.global_attribute1,
hz.global_attribute2,
hz.global_attribute3,
hz.global_attribute4,
hz.global_attribute5,
hz.global_attribute6,
hz.global_attribute7,
hz.global_attribute8,
hz.global_attribute9,
hz.global_attribute10,
hz.global_attribute11,
hz.global_attribute12,
hz.global_attribute13,
hz.global_attribute14,
hz.global_attribute15,
hz.global_attribute16,
hz.global_attribute17,
hz.global_attribute18,
hz.global_attribute19,
hz.global_attribute20,
hz.orig_system_reference,
hz.country,
hz.address1,
hz.address2,
hz.address3,
hz.address4,
hz.city,
hz.postal_code,
hz.state,
hz.province,
hz.county,
hz.address_key,
hz.address_style,
hz.validated_flag,
hz.address_lines_phonetic,
hz.apartment_flag,
hz.po_box_number,
hz.house_number,
hz.street_suffix,
hz.apartment_number,
hz.secondary_suffix_element,
hz.street,
hz.rural_route_type,
hz.rural_route_number,
hz.street_number,
hz.building,
hz.floor,
hz.suite,
hz.room,
hz.postal_plus4_code,
hz.time_zone,
hz.overseas_address_flag,
hz.post_office,
hz.position,
hz.delivery_point_code,
hz.location_directions,
hz.address_effective_date,
hz.address_expiration_date,
hz.address_error_code,
hz.clli_code,
hz.dodaac,
hz.trailing_directory_code,
hz.language,
hz.life_cycle_status,
hz.short_description,
hz.description,
hz.content_source_type,
hz.loc_hierarchy_id,
hz.sales_tax_geocode,
hz.sales_tax_inside_city_limits,
hz.fa_location_id,
hz.object_version_number,
hz.created_by_module,
hz.application_id,
hz.timezone_id,
hz.geometry_status_code,
hz.actual_content_source,
hz.validation_status_code,
hz.date_validated,
hz.do_not_validate_flag,
NULL)
BULK COLLECT INTO l_pos_hz_location_bo
FROM hz_locations hz,
ap_suppliers ap,
ap_supplier_sites_all ss
WHERE ap.party_id = p_party_id
AND ss.vendor_id = ap.vendor_id
AND hz.location_id = ss.location_id;
p_create_update_flag IN VARCHAR2,
x_location_id OUT NOCOPY NUMBER,
x_object_version_number OUT NOCOPY NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2) IS
p_location_rec hz_location_v2pub.location_rec_type;
IF p_create_update_flag = 'C' THEN
hz_location_v2pub.create_location(p_init_msg_list,
p_location_rec,
x_location_id,
x_return_status,
x_msg_count,
x_msg_data);
ELSIF p_create_update_flag = 'U' THEN
hz_location_v2pub.update_location(p_init_msg_list,
p_location_rec,
x_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);
* @rep:displayname Update Vendor Contact
* @rep:catagory BUSSINESS_ENTITY AP_SUPPLIER
*/
/*PROCEDURE update_hz_location_bo(p_api_version IN NUMBER DEFAULT NULL,
p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
p_location_rec IN hz_location_v2pub.location_rec_type,
x_object_version_number IN OUT NOCOPY NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2) IS
BEGIN
hz_location_v2pub.update_location(p_init_msg_list,
p_location_rec,
x_object_version_number,
x_return_status,
x_msg_count,
x_msg_data);
END update_hz_location_bo;