[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
vehicle_allocation_id
,effective_start_date
,effective_end_date
,assignment_id
,business_group_id
,across_assignments
,vehicle_repository_id
,usage_type
,capital_contribution
,private_contribution
,default_vehicle
,fuel_card
,fuel_card_number
,calculation_method
,rates_table_id
,element_type_id
,private_use_flag
,insurance_number
,insurance_expiry_date
,val_attribute_category
,val_attribute1
,val_attribute2
,val_attribute3
,val_attribute4
,val_attribute5
,val_attribute6
,val_attribute7
,val_attribute8
,val_attribute9
,val_attribute10
,val_attribute11
,val_attribute12
,val_attribute13
,val_attribute14
,val_attribute15
,val_attribute16
,val_attribute17
,val_attribute18
,val_attribute19
,val_attribute20
,val_information_category
,val_information1
,val_information2
,val_information3
,val_information4
,val_information5
,val_information6
,val_information7
,val_information8
,val_information9
,val_information10
,val_information11
,val_information12
,val_information13
,val_information14
,val_information15
,val_information16
,val_information17
,val_information18
,val_information19
,val_information20
,object_version_number
,fuel_benefit
,sliding_rates_info
from pqp_vehicle_allocations_f
where vehicle_allocation_id = p_vehicle_allocation_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 pqp_vehicle_allocations_f t
set t.effective_end_date = p_new_effective_end_date
, t.object_version_number = l_object_version_number
where t.vehicle_allocation_id = p_base_key_value
and p_effective_date
between t.effective_start_date and t.effective_end_date;
select
vehicle_allocation_id
,effective_start_date
,effective_end_date
,assignment_id
,business_group_id
,across_assignments
,vehicle_repository_id
,usage_type
,capital_contribution
,private_contribution
,default_vehicle
,fuel_card
,fuel_card_number
,calculation_method
,rates_table_id
,element_type_id
,private_use_flag
,insurance_number
,insurance_expiry_date
,val_attribute_category
,val_attribute1
,val_attribute2
,val_attribute3
,val_attribute4
,val_attribute5
,val_attribute6
,val_attribute7
,val_attribute8
,val_attribute9
,val_attribute10
,val_attribute11
,val_attribute12
,val_attribute13
,val_attribute14
,val_attribute15
,val_attribute16
,val_attribute17
,val_attribute18
,val_attribute19
,val_attribute20
,val_information_category
,val_information1
,val_information2
,val_information3
,val_information4
,val_information5
,val_information6
,val_information7
,val_information8
,val_information9
,val_information10
,val_information11
,val_information12
,val_information13
,val_information14
,val_information15
,val_information16
,val_information17
,val_information18
,val_information19
,val_information20
,object_version_number
,fuel_benefit
,sliding_rates_info
from pqp_vehicle_allocations_f
where vehicle_allocation_id = p_vehicle_allocation_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;