DBA Data[Home] [Help]

APPS.PQP_VEHICLE_ALLOCATIONS_API SQL Statements

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

Line: 458

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';
Line: 535

  savepoint update_vehicle_allocation;
Line: 552

  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

  ) ;
Line: 697

 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

    );
Line: 771

  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
  ) ;
Line: 867

    rollback to update_vehicle_allocation;
Line: 880

     rollback to update_vehicle_allocation;
Line: 885

END update_vehicle_allocation;
Line: 890

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';
Line: 909

  savepoint delete_vehicle_allocation;
Line: 920

  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
  ) ;
Line: 948

   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
  );
Line: 960

  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

  ) ;
Line: 999

    rollback to delete_vehicle_allocation;
Line: 1014

    rollback to delete_vehicle_allocation;
Line: 1022

  END delete_vehicle_allocation;