The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_vehicle_allocation
(p_validate in boolean
,p_effective_date in date
,p_datetrack_mode in varchar2
,p_vehicle_allocation_id in number
,p_object_version_number in out nocopy number
,p_assignment_id in number
,p_business_group_id in number
,p_vehicle_repository_id in number
,p_across_assignments in varchar2
,p_usage_type in varchar2
,p_capital_contribution in number
,p_private_contribution in number
,p_default_vehicle in varchar2
,p_fuel_card in varchar2
,p_fuel_card_number in varchar2
,p_calculation_method in varchar2
,p_rates_table_id in number
,p_element_type_id in number
,p_private_use_flag in varchar2
,p_insurance_number in varchar2
,p_insurance_expiry_date in date
,p_val_attribute_category in varchar2
,p_val_attribute1 in varchar2
,p_val_attribute2 in varchar2
,p_val_attribute3 in varchar2
,p_val_attribute4 in varchar2
,p_val_attribute5 in varchar2
,p_val_attribute6 in varchar2
,p_val_attribute7 in varchar2
,p_val_attribute8 in varchar2
,p_val_attribute9 in varchar2
,p_val_attribute10 in varchar2
,p_val_attribute11 in varchar2
,p_val_attribute12 in varchar2
,p_val_attribute13 in varchar2
,p_val_attribute14 in varchar2
,p_val_attribute15 in varchar2
,p_val_attribute16 in varchar2
,p_val_attribute17 in varchar2
,p_val_attribute18 in varchar2
,p_val_attribute19 in varchar2
,p_val_attribute20 in varchar2
,p_val_information_category in varchar2
,p_val_information1 in varchar2
,p_val_information2 in varchar2
,p_val_information3 in varchar2
,p_val_information4 in varchar2
,p_val_information5 in varchar2
,p_val_information6 in varchar2
,p_val_information7 in varchar2
,p_val_information8 in varchar2
,p_val_information9 in varchar2
,p_val_information10 in varchar2
,p_val_information11 in varchar2
,p_val_information12 in varchar2
,p_val_information13 in varchar2
,p_val_information14 in varchar2
,p_val_information15 in varchar2
,p_val_information16 in varchar2
,p_val_information17 in varchar2
,p_val_information18 in varchar2
,p_val_information19 in varchar2
,p_val_information20 in varchar2
,p_fuel_benefit in varchar2
,p_sliding_rates_info in varchar2
,p_effective_start_date out nocopy date
,p_effective_end_date out nocopy date
)
IS
l_proc varchar2(72) := g_package||'update_vehicle_allocation';
savepoint update_vehicle_allocation;
PQP_VEHICLE_ALLOCATIONS_BK2.update_vehicle_allocation_b
(p_effective_date => l_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_vehicle_allocation_id => p_vehicle_allocation_id
,p_object_version_number => p_object_version_number
,p_assignment_id => p_assignment_id
,p_business_group_id => p_business_group_id
,p_vehicle_repository_id => p_vehicle_repository_id
,p_across_assignments => p_across_assignments
,p_usage_type => p_usage_type
,p_capital_contribution => p_capital_contribution
,p_private_contribution => p_private_contribution
,p_default_vehicle => p_default_vehicle
,p_fuel_card => l_fuel_card
,p_fuel_card_number => p_fuel_card_number
,p_calculation_method => p_calculation_method
,p_rates_table_id => p_rates_table_id
,p_element_type_id => p_element_type_id
,p_private_use_flag => p_private_use_flag
,p_insurance_number => p_insurance_number
,p_insurance_expiry_date => p_insurance_expiry_date
,p_val_attribute_category => p_val_attribute_category
,p_val_attribute1 => p_val_attribute1
,p_val_attribute2 => p_val_attribute2
,p_val_attribute3 => p_val_attribute3
,p_val_attribute4 => p_val_attribute4
,p_val_attribute5 => p_val_attribute5
,p_val_attribute6 => p_val_attribute6
,p_val_attribute7 => p_val_attribute7
,p_val_attribute8 => p_val_attribute8
,p_val_attribute9 => p_val_attribute9
,p_val_attribute10 => p_val_attribute10
,p_val_attribute11 => p_val_attribute11
,p_val_attribute12 => p_val_attribute12
,p_val_attribute13 => p_val_attribute13
,p_val_attribute14 => p_val_attribute14
,p_val_attribute15 => p_val_attribute15
,p_val_attribute16 => p_val_attribute16
,p_val_attribute17 => p_val_attribute17
,p_val_attribute18 => p_val_attribute18
,p_val_attribute19 => p_val_attribute19
,p_val_attribute20 => p_val_attribute20
,p_val_information_category => p_val_information_category
,p_val_information1 => p_val_information1
,p_val_information2 => p_val_information2
,p_val_information3 => p_val_information3
,p_val_information4 => p_val_information4
,p_val_information5 => p_val_information5
,p_val_information6 => p_val_information6
,p_val_information7 => p_val_information7
,p_val_information8 => p_val_information8
,p_val_information9 => p_val_information9
,p_val_information10 => p_val_information10
,p_val_information11 => p_val_information11
,p_val_information12 => p_val_information12
,p_val_information13 => p_val_information13
,p_val_information14 => p_val_information14
,p_val_information15 => p_val_information15
,p_val_information16 => p_val_information16
,p_val_information17 => p_val_information17
,p_val_information18 => p_val_information18
,p_val_information19 => p_val_information19
,p_val_information20 => p_val_information20
,p_fuel_benefit => p_fuel_benefit
,p_sliding_rates_info =>p_sliding_rates_info
) ;
pqp_veh_multi_alloc.update_veh_multi_alloc
( p_validate => p_validate
,p_effective_date => l_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_vehicle_allocation_id => p_vehicle_allocation_id
,p_object_version_number => p_object_version_number
,p_assignment_id => p_assignment_id
,p_business_group_id => p_business_group_id
,p_vehicle_repository_id => p_vehicle_repository_id
,p_across_assignments => p_across_assignments
,p_usage_type => p_usage_type
,p_capital_contribution => p_capital_contribution
,p_private_contribution => p_private_contribution
,p_default_vehicle => p_default_vehicle
,p_fuel_card => l_fuel_card
,p_fuel_card_number => p_fuel_card_number
,p_calculation_method => p_calculation_method
,p_rates_table_id => p_rates_table_id
,p_element_type_id => p_element_type_id
,p_private_use_flag => p_private_use_flag
,p_insurance_number => p_insurance_number
,p_insurance_expiry_date => p_insurance_expiry_date
,p_val_attribute_category => p_val_attribute_category
,p_val_attribute1 => p_val_attribute1
,p_val_attribute2 => p_val_attribute2
,p_val_attribute3 => p_val_attribute3
,p_val_attribute4 => p_val_attribute4
,p_val_attribute5 => p_val_attribute5
,p_val_attribute6 => p_val_attribute6
,p_val_attribute7 => p_val_attribute7
,p_val_attribute8 => p_val_attribute8
,p_val_attribute9 => p_val_attribute9
,p_val_attribute10 => p_val_attribute10
,p_val_attribute11 => p_val_attribute11
,p_val_attribute12 => p_val_attribute12
,p_val_attribute13 => p_val_attribute13
,p_val_attribute14 => p_val_attribute14
,p_val_attribute15 => p_val_attribute15
,p_val_attribute16 => p_val_attribute16
,p_val_attribute17 => p_val_attribute17
,p_val_attribute18 => p_val_attribute18
,p_val_attribute19 => p_val_attribute19
,p_val_attribute20 => p_val_attribute20
,p_val_information_category => p_val_information_category
,p_val_information1 => p_val_information1
,p_val_information2 => p_val_information2
,p_val_information3 => p_val_information3
,p_val_information4 => p_val_information4
,p_val_information5 => p_val_information5
,p_val_information6 => p_val_information6
,p_val_information7 => p_val_information7
,p_val_information8 => p_val_information8
,p_val_information9 => p_val_information9
,p_val_information10 => p_val_information10
,p_val_information11 => p_val_information11
,p_val_information12 => p_val_information12
,p_val_information13 => p_val_information13
,p_val_information14 => p_val_information14
,p_val_information15 => p_val_information15
,p_val_information16 => p_val_information16
,p_val_information17 => p_val_information17
,p_val_information18 => p_val_information18
,p_val_information19 => p_val_information19
,p_val_information20 => p_val_information20
,p_fuel_benefit => p_fuel_benefit
,p_sliding_rates_info =>p_sliding_rates_info
);
PQP_VEHICLE_ALLOCATIONS_BK2.update_vehicle_allocation_a
(p_effective_date => l_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_vehicle_allocation_id => p_vehicle_allocation_id
,p_object_version_number => p_object_version_number
,p_assignment_id => p_assignment_id
,p_business_group_id => p_business_group_id
,p_vehicle_repository_id => p_vehicle_repository_id
,p_across_assignments => p_across_assignments
,p_usage_type => p_usage_type
,p_capital_contribution => p_capital_contribution
,p_private_contribution => p_private_contribution
,p_default_vehicle => p_default_vehicle
,p_fuel_card => l_fuel_card
,p_fuel_card_number => p_fuel_card_number
,p_calculation_method => p_calculation_method
,p_rates_table_id => p_rates_table_id
,p_element_type_id => p_element_type_id
,p_private_use_flag => p_private_use_flag
,p_insurance_number => p_insurance_number
,p_insurance_expiry_date => p_insurance_expiry_date
,p_val_attribute_category => p_val_attribute_category
,p_val_attribute1 => p_val_attribute1
,p_val_attribute2 => p_val_attribute2
,p_val_attribute3 => p_val_attribute3
,p_val_attribute4 => p_val_attribute4
,p_val_attribute5 => p_val_attribute5
,p_val_attribute6 => p_val_attribute6
,p_val_attribute7 => p_val_attribute7
,p_val_attribute8 => p_val_attribute8
,p_val_attribute9 => p_val_attribute9
,p_val_attribute10 => p_val_attribute10
,p_val_attribute11 => p_val_attribute11
,p_val_attribute12 => p_val_attribute12
,p_val_attribute13 => p_val_attribute13
,p_val_attribute14 => p_val_attribute14
,p_val_attribute15 => p_val_attribute15
,p_val_attribute16 => p_val_attribute16
,p_val_attribute17 => p_val_attribute17
,p_val_attribute18 => p_val_attribute18
,p_val_attribute19 => p_val_attribute19
,p_val_attribute20 => p_val_attribute20
,p_val_information_category => p_val_information_category
,p_val_information1 => p_val_information1
,p_val_information2 => p_val_information2
,p_val_information3 => p_val_information3
,p_val_information4 => p_val_information4
,p_val_information5 => p_val_information5
,p_val_information6 => p_val_information6
,p_val_information7 => p_val_information7
,p_val_information8 => p_val_information8
,p_val_information9 => p_val_information9
,p_val_information10 => p_val_information10
,p_val_information11 => p_val_information11
,p_val_information12 => p_val_information12
,p_val_information13 => p_val_information13
,p_val_information14 => p_val_information14
,p_val_information15 => p_val_information15
,p_val_information16 => p_val_information16
,p_val_information17 => p_val_information17
,p_val_information18 => p_val_information18
,p_val_information19 => p_val_information19
,p_val_information20 => p_val_information20
,p_fuel_benefit => p_fuel_benefit
,p_sliding_rates_info => p_sliding_rates_info
,p_effective_start_date => p_effective_start_date
,p_effective_end_date => p_effective_end_date
) ;
rollback to update_vehicle_allocation;
rollback to update_vehicle_allocation;
END update_vehicle_allocation;
procedure delete_vehicle_allocation
(p_validate in boolean
,p_effective_date in date
,p_datetrack_mode in varchar2
,p_vehicle_allocation_id in number
,p_object_version_number in out nocopy number
,p_effective_start_date out nocopy date
,p_effective_end_date out nocopy date
) IS
l_proc varchar2(72) := g_package||'delete_vehicle_allocation';
savepoint delete_vehicle_allocation;
PQP_VEHICLE_ALLOCATIONS_BK3.DELETE_VEHICLE_ALLOCATION_b
(p_validate =>p_validate
,p_effective_date =>l_effective_date
,p_datetrack_mode =>p_datetrack_mode
,p_vehicle_allocation_id =>p_vehicle_allocation_id
,p_object_version_number =>p_object_version_number
) ;
pqp_veh_multi_alloc.delete_veh_multi_alloc
(p_validate =>p_validate
,p_effective_date =>l_effective_date
,p_datetrack_mode =>p_datetrack_mode
,p_vehicle_allocation_id =>p_vehicle_allocation_id
);
PQP_VEHICLE_ALLOCATIONS_BK3.delete_vehicle_allocation_a
(p_validate =>p_validate
,p_effective_date =>l_effective_date
,p_datetrack_mode =>p_datetrack_mode
,p_vehicle_allocation_id =>p_vehicle_allocation_id
,p_object_version_number =>p_object_version_number
,p_effective_start_date => p_effective_start_date
,p_effective_end_date =>p_effective_end_date
) ;
rollback to delete_vehicle_allocation;
rollback to delete_vehicle_allocation;
END delete_vehicle_allocation;