The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
accommodation_id
,accommodation_name
,effective_start_date
,effective_end_date
,business_group_id
,location_id
,accommodation_desc
,accommodation_type
,style
,address_line_1
,address_line_2
,address_line_3
,town_or_city
,country
,postal_code
,region_1
,region_2
,region_3
,telephone_number_1
,telephone_number_2
,telephone_number_3
,floor_number
,floor_area
,floor_area_measure_unit
,main_rooms
,family_size
,suitability_disabled
,rental_value
,rental_value_currency
,owner
,comments
,information_category
,information1
,information2
,information3
,information4
,information5
,information6
,information7
,information8
,information9
,information10
,information11
,information12
,information13
,information14
,information15
,information16
,information17
,information18
,information19
,information20
,information21
,information22
,information23
,information24
,information25
,information26
,information27
,information28
,information29
,information30
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
,object_version_number
from pqh_accommodations_f
where accommodation_id = p_accommodation_id
and p_effective_date
between effective_start_date and effective_end_date;
,p_update out nocopy boolean
,p_update_override out nocopy boolean
,p_update_change_insert out nocopy boolean
) is
--
l_proc varchar2(72) := g_package||'find_dt_upd_modes';
,p_update => p_update
,p_update_override => p_update_override
,p_update_change_insert => p_update_change_insert
);
,p_delete out nocopy boolean
,p_future_change out nocopy boolean
,p_delete_next_change out nocopy boolean
) is
--
l_proc varchar2(72) := g_package||'find_dt_del_modes';
,p_delete => p_delete
,p_future_change => p_future_change
,p_delete_next_change => p_delete_next_change
);
update pqh_accommodations_f t
set t.effective_end_date = p_new_effective_end_date
, t.object_version_number = l_object_version_number
where t.accommodation_id = p_base_key_value
and p_effective_date
between t.effective_start_date and t.effective_end_date;
select
accommodation_id
,accommodation_name
,effective_start_date
,effective_end_date
,business_group_id
,location_id
,accommodation_desc
,accommodation_type
,style
,address_line_1
,address_line_2
,address_line_3
,town_or_city
,country
,postal_code
,region_1
,region_2
,region_3
,telephone_number_1
,telephone_number_2
,telephone_number_3
,floor_number
,floor_area
,floor_area_measure_unit
,main_rooms
,family_size
,suitability_disabled
,rental_value
,rental_value_currency
,owner
,comments
,information_category
,information1
,information2
,information3
,information4
,information5
,information6
,information7
,information8
,information9
,information10
,information11
,information12
,information13
,information14
,information15
,information16
,information17
,information18
,information19
,information20
,information21
,information22
,information23
,information24
,information25
,information26
,information27
,information28
,information29
,information30
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
,object_version_number
from pqh_accommodations_f
where accommodation_id = p_accommodation_id
and p_effective_date
between effective_start_date and effective_end_date
for update nowait;
If (p_datetrack_mode <> hr_api.g_insert) then
--
-- We must select and lock the current row.
--
Open C_Sel1;