[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select legislation_code
from per_business_groups pbg
where pbg.business_group_id = p_business_group_id;
Procedure update_pl_vehicle_allocation
(p_validate in boolean default false
,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 default hr_api.g_number
,p_business_group_id in number default hr_api.g_number
,p_vehicle_repository_id in number default hr_api.g_number
,p_across_assignments in varchar2 default hr_api.g_varchar2
,p_usage_type in varchar2 default hr_api.g_varchar2
,p_capital_contribution in number default hr_api.g_number
,p_private_contribution in number default hr_api.g_number
,p_default_vehicle in varchar2 default hr_api.g_varchar2
,p_fuel_card in varchar2 default hr_api.g_varchar2
,p_fuel_card_number in varchar2 default hr_api.g_varchar2
,p_calculation_method in varchar2 default hr_api.g_varchar2
,p_rates_table_id in number default hr_api.g_number
,p_element_type_id in number default hr_api.g_number
,p_private_use_flag in varchar2 default hr_api.g_varchar2
,p_insurance_number in varchar2 default hr_api.g_varchar2
,p_insurance_expiry_date in date default hr_api.g_date
,p_val_attribute_category in varchar2 default hr_api.g_varchar2
,p_val_attribute1 in varchar2 default hr_api.g_varchar2
,p_val_attribute2 in varchar2 default hr_api.g_varchar2
,p_val_attribute3 in varchar2 default hr_api.g_varchar2
,p_val_attribute4 in varchar2 default hr_api.g_varchar2
,p_val_attribute5 in varchar2 default hr_api.g_varchar2
,p_val_attribute6 in varchar2 default hr_api.g_varchar2
,p_val_attribute7 in varchar2 default hr_api.g_varchar2
,p_val_attribute8 in varchar2 default hr_api.g_varchar2
,p_val_attribute9 in varchar2 default hr_api.g_varchar2
,p_val_attribute10 in varchar2 default hr_api.g_varchar2
,p_val_attribute11 in varchar2 default hr_api.g_varchar2
,p_val_attribute12 in varchar2 default hr_api.g_varchar2
,p_val_attribute13 in varchar2 default hr_api.g_varchar2
,p_val_attribute14 in varchar2 default hr_api.g_varchar2
,p_val_attribute15 in varchar2 default hr_api.g_varchar2
,p_val_attribute16 in varchar2 default hr_api.g_varchar2
,p_val_attribute17 in varchar2 default hr_api.g_varchar2
,p_val_attribute18 in varchar2 default hr_api.g_varchar2
,p_val_attribute19 in varchar2 default hr_api.g_varchar2
,p_val_attribute20 in varchar2 default hr_api.g_varchar2
,p_val_information_category in varchar2 default hr_api.g_varchar2
,p_agreement_description in varchar2 default hr_api.g_varchar2
,p_month_mileage_limit_by_law in varchar2 default hr_api.g_varchar2
,p_month_mileage_limit_by_emp in varchar2 default hr_api.g_varchar2
,p_other_conditions in varchar2 default hr_api.g_varchar2
,p_fuel_benefit in varchar2 default hr_api.g_varchar2
,p_sliding_rates_info in varchar2 default hr_api.g_varchar2
,p_effective_start_date out nocopy date
,p_effective_end_date out nocopy date
) is
l_proc varchar2(72);
select legislation_code
from per_business_groups pbg
where pbg.business_group_id = p_business_group_id;
l_proc := g_package||'update_pl_vehicle_allocation';
PQP_VEHICLE_ALLOCATIONS_API.update_vehicle_allocation
(p_validate => p_validate
,p_effective_date => p_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 => p_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_agreement_description
,p_val_information2 => p_month_mileage_limit_by_law
,p_val_information3 => p_month_mileage_limit_by_emp
,p_val_information4 => p_other_conditions
,p_val_information5 => null
,p_val_information6 => null
,p_val_information7 => null
,p_val_information8 => null
,p_val_information9 => null
,p_val_information10 => null
,p_val_information11 => null
,p_val_information12 => null
,p_val_information13 => null
,p_val_information14 => null
,p_val_information15 => null
,p_val_information16 => null
,p_val_information17 => null
,p_val_information18 => null
,p_val_information19 => null
,p_val_information20 => null
,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
);
End Update_pl_vehicle_allocation;