eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_VEHICLE_ALLOCATIONS_SWI SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 268


PROCEDURE delete_vehicle_allocation
  (p_validate                     in     number    default hr_api.g_false_num
  ,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
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 286


  l_proc    varchar2(72) := g_package ||'delete_vehicle_allocation';

Line: 292


  savepoint delete_vehicle_allocation_swi;

Line: 313


  pqp_vehicle_allocations_api.delete_vehicle_allocation
    (p_validate                     => l_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_effective_start_date         => p_effective_start_date
    ,p_effective_end_date           => p_effective_end_date
    );

Line: 344


    rollback to delete_vehicle_allocation_swi;

Line: 361


    rollback to delete_vehicle_allocation_swi;

Line: 375


end delete_vehicle_allocation;

Line: 379


PROCEDURE update_vehicle_allocation
  (p_validate                     in     number    default hr_api.g_false_num
  ,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_val_information1             in     varchar2  default hr_api.g_varchar2
  ,p_val_information2             in     varchar2  default hr_api.g_varchar2
  ,p_val_information3             in     varchar2  default hr_api.g_varchar2
  ,p_val_information4             in     varchar2  default hr_api.g_varchar2
  ,p_val_information5             in     varchar2  default hr_api.g_varchar2
  ,p_val_information6             in     varchar2  default hr_api.g_varchar2
  ,p_val_information7             in     varchar2  default hr_api.g_varchar2
  ,p_val_information8             in     varchar2  default hr_api.g_varchar2
  ,p_val_information9             in     varchar2  default hr_api.g_varchar2
  ,p_val_information10            in     varchar2  default hr_api.g_varchar2
  ,p_val_information11            in     varchar2  default hr_api.g_varchar2
  ,p_val_information12            in     varchar2  default hr_api.g_varchar2
  ,p_val_information13            in     varchar2  default hr_api.g_varchar2
  ,p_val_information14            in     varchar2  default hr_api.g_varchar2
  ,p_val_information15            in     varchar2  default hr_api.g_varchar2
  ,p_val_information16            in     varchar2  default hr_api.g_varchar2
  ,p_val_information17            in     varchar2  default hr_api.g_varchar2
  ,p_val_information18            in     varchar2  default hr_api.g_varchar2
  ,p_val_information19            in     varchar2  default hr_api.g_varchar2
  ,p_val_information20            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
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 457


  l_proc    varchar2(72) := g_package ||'update_vehicle_allocation';

Line: 463


  savepoint update_vehicle_allocation_swi;

Line: 496


  pqp_vehicle_allocations_api.update_vehicle_allocation
    (p_validate                     => l_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_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
    );

Line: 587


    rollback to update_vehicle_allocation_swi;

Line: 604


    rollback to update_vehicle_allocation_swi;

Line: 617


end update_vehicle_allocation;