DBA Data[Home] [Help]

APPS.PQP_VEHICLE_REPOSITORY_API SQL Statements

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

Line: 462

procedure update_vehicle
  (p_validate                     in     boolean
  ,p_effective_date               in     date
  ,p_datetrack_mode               in     varchar2
  ,p_vehicle_repository_id        in     number
  ,p_object_version_number        in out NOCOPY number
  ,p_registration_number          in     varchar2
  ,p_vehicle_type                 in     varchar2
  ,p_vehicle_id_number            in     varchar2
  ,p_business_group_id            in     number
  ,p_make                         in     varchar2
  ,p_engine_capacity_in_cc        in     number
  ,p_fuel_type                    in     varchar2
  ,p_currency_code                in     varchar2
  ,p_vehicle_status               in     varchar2
  ,p_vehicle_inactivity_reason    in     varchar2
  ,p_model                        in     varchar2
  ,p_initial_registration         in     date
  ,p_last_registration_renew_date in     date
  ,p_list_price                   in     number
  ,p_accessory_value_at_startdate in     number
  ,p_accessory_value_added_later  in     number
  ,p_market_value_classic_car     in     number
  ,p_fiscal_ratings               in     number
  ,p_fiscal_ratings_uom           in     varchar2
  ,p_vehicle_provider             in     varchar2
  ,p_vehicle_ownership            in     varchar2
  ,p_shared_vehicle               in     varchar2
  ,p_asset_number                 in     varchar2
  ,p_lease_contract_number        in     varchar2
  ,p_lease_contract_expiry_date   in     date
  ,p_taxation_method              in     varchar2
  ,p_fleet_info                   in     varchar2
  ,p_fleet_transfer_date          in     date
  ,p_color                        in     varchar2
  ,p_seating_capacity             in     number
  ,p_weight                       in     number
  ,p_weight_uom                   in     varchar2
  ,p_model_year                   in     number
  ,p_insurance_number             in     varchar2
  ,p_insurance_expiry_date        in     date
  ,p_comments                     in     varchar2
  ,p_vre_attribute_category       in     varchar2
  ,p_vre_attribute1               in     varchar2
  ,p_vre_attribute2               in     varchar2
  ,p_vre_attribute3               in     varchar2
  ,p_vre_attribute4               in     varchar2
  ,p_vre_attribute5               in     varchar2
  ,p_vre_attribute6               in     varchar2
  ,p_vre_attribute7               in     varchar2
  ,p_vre_attribute8               in     varchar2
  ,p_vre_attribute9               in     varchar2
  ,p_vre_attribute10              in     varchar2
  ,p_vre_attribute11              in     varchar2
  ,p_vre_attribute12              in     varchar2
  ,p_vre_attribute13              in     varchar2
  ,p_vre_attribute14              in     varchar2
  ,p_vre_attribute15              in     varchar2
  ,p_vre_attribute16              in     varchar2
  ,p_vre_attribute17              in     varchar2
  ,p_vre_attribute18              in     varchar2
  ,p_vre_attribute19              in     varchar2
  ,p_vre_attribute20              in     varchar2
 ,p_vre_information_category      in     varchar2
  ,p_vre_information1             in     varchar2
  ,p_vre_information2             in     varchar2
  ,p_vre_information3             in     varchar2
  ,p_vre_information4             in     varchar2
  ,p_vre_information5             in     varchar2
  ,p_vre_information6             in     varchar2
  ,p_vre_information7             in     varchar2
  ,p_vre_information8             in     varchar2
  ,p_vre_information9             in     varchar2
  ,p_vre_information10            in     varchar2
  ,p_vre_information11            in     varchar2
  ,p_vre_information12            in     varchar2
  ,p_vre_information13            in     varchar2
  ,p_vre_information14            in     varchar2
  ,p_vre_information15            in     varchar2
  ,p_vre_information16            in     varchar2
  ,p_vre_information17            in     varchar2
  ,p_vre_information18            in     varchar2
  ,p_vre_information19            in     varchar2
  ,p_vre_information20            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';
Line: 564

  savepoint update_vehicle;
Line: 572

  PQP_VEHICLE_REPOSITORY_BK2.update_vehicle_b
  ( p_effective_date                 =>l_effective_date
  ,p_datetrack_mode                  =>p_datetrack_mode
  ,p_vehicle_repository_id           =>p_vehicle_repository_id
  ,p_object_version_number           =>p_object_version_number
  ,p_registration_number             =>p_registration_number
  ,p_vehicle_type                    =>p_vehicle_type
  ,p_vehicle_id_number               =>p_vehicle_id_number
  ,p_business_group_id               =>p_business_group_id
  ,p_make                            =>p_make
  ,p_engine_capacity_in_cc           =>p_engine_capacity_in_cc
  ,p_fuel_type                       =>p_fuel_type
  ,p_currency_code                   =>l_currency_code
  ,p_vehicle_status                  =>p_vehicle_status
  ,p_vehicle_inactivity_reason       =>p_vehicle_inactivity_reason
  ,p_model                           =>p_model
  ,p_initial_registration            =>p_initial_registration
  ,p_last_registration_renew_date    =>p_last_registration_renew_date
  ,p_list_price                       =>p_list_price
  ,p_accessory_value_at_startdate    =>p_accessory_value_at_startdate
  ,p_accessory_value_added_later     =>p_accessory_value_added_later
  ,p_market_value_classic_car        =>p_market_value_classic_car
  ,p_fiscal_ratings                  =>p_fiscal_ratings
  ,p_fiscal_ratings_uom              =>p_fiscal_ratings_uom
  ,p_vehicle_provider                =>p_vehicle_provider
  ,p_vehicle_ownership               =>p_vehicle_ownership
  ,p_shared_vehicle                  =>p_shared_vehicle
  ,p_asset_number                    =>p_asset_number
  ,p_lease_contract_number           =>p_lease_contract_number
  ,p_lease_contract_expiry_date      =>p_lease_contract_expiry_date
  ,p_taxation_method                 =>p_taxation_method
  ,p_fleet_info                      =>p_fleet_info
  ,p_fleet_transfer_date             =>p_fleet_transfer_date
  ,p_color                           =>p_color
  ,p_seating_capacity                =>p_seating_capacity
  ,p_weight                          =>p_weight
  ,p_weight_uom                      =>p_weight_uom
  ,p_model_year                      =>p_model_year
  ,p_insurance_number                =>p_insurance_number
  ,p_insurance_expiry_date           =>p_insurance_expiry_date
  ,p_comments                        =>p_comments
  ,p_vre_attribute_category          =>p_vre_attribute_category
  ,p_vre_attribute1                  =>p_vre_attribute1
  ,p_vre_attribute2                  =>p_vre_attribute2
  ,p_vre_attribute3                  =>p_vre_attribute3
  ,p_vre_attribute4                  =>p_vre_attribute4
  ,p_vre_attribute5                  =>p_vre_attribute5
  ,p_vre_attribute6                  =>p_vre_attribute6
  ,p_vre_attribute7                  =>p_vre_attribute7
  ,p_vre_attribute8                  =>p_vre_attribute8
  ,p_vre_attribute9                  =>p_vre_attribute9
  ,p_vre_attribute10                 =>p_vre_attribute10
  ,p_vre_attribute11                 =>p_vre_attribute11
  ,p_vre_attribute12                 =>p_vre_attribute12
  ,p_vre_attribute13                 =>p_vre_attribute13
  ,p_vre_attribute14                 =>p_vre_attribute14
  ,p_vre_attribute15                 =>p_vre_attribute15
  ,p_vre_attribute16                 =>p_vre_attribute16
  ,p_vre_attribute17                 =>p_vre_attribute17
  ,p_vre_attribute18                 =>p_vre_attribute18
  ,p_vre_attribute19                 =>p_vre_attribute19
  ,p_vre_attribute20                 =>p_vre_attribute20
  ,p_vre_information_category        =>p_vre_information_category
  ,p_vre_information1                =>p_vre_information1
  ,p_vre_information2                =>p_vre_information2
  ,p_vre_information3                =>p_vre_information3
  ,p_vre_information4                =>p_vre_information4
  ,p_vre_information5                =>p_vre_information5
  ,p_vre_information6                =>p_vre_information6
  ,p_vre_information7                =>p_vre_information7
  ,p_vre_information8                =>p_vre_information8
  ,p_vre_information9                =>p_vre_information9
  ,p_vre_information10               =>p_vre_information10
  ,p_vre_information11               =>p_vre_information11
  ,p_vre_information12               =>p_vre_information12
  ,p_vre_information13               =>p_vre_information13
  ,p_vre_information14               =>p_vre_information14
  ,p_vre_information15               =>p_vre_information15
  ,p_vre_information16               =>p_vre_information16
  ,p_vre_information17               =>p_vre_information17
  ,p_vre_information18               =>p_vre_information18
  ,p_vre_information19               =>p_vre_information19
  ,p_vre_information20               =>p_vre_information20
  ) ;
Line: 756

  PQP_VEHICLE_REPOSITORY_BK2.update_vehicle_a
  ( p_effective_date                  =>l_effective_date
  ,p_datetrack_mode                  =>p_datetrack_mode
  ,p_vehicle_repository_id           =>p_vehicle_repository_id
  ,p_object_version_number           =>p_object_version_number
  ,p_registration_number             =>p_registration_number
  ,p_vehicle_type                    =>p_vehicle_type
  ,p_vehicle_id_number               =>p_vehicle_id_number
  ,p_business_group_id               =>p_business_group_id
  ,p_make                            =>p_make
  ,p_engine_capacity_in_cc           =>p_engine_capacity_in_cc
  ,p_fuel_type                       =>p_fuel_type
  ,p_currency_code                   =>l_currency_code
  ,p_vehicle_status                  =>p_vehicle_status
  ,p_vehicle_inactivity_reason       =>p_vehicle_inactivity_reason
  ,p_model                           =>p_model
  ,p_initial_registration            =>p_initial_registration
  ,p_last_registration_renew_date    =>p_last_registration_renew_date
  ,p_list_price                       =>p_list_price
  ,p_accessory_value_at_startdate    =>p_accessory_value_at_startdate
  ,p_accessory_value_added_later     =>p_accessory_value_added_later
  ,p_market_value_classic_car        =>p_market_value_classic_car
  ,p_fiscal_ratings                  =>p_fiscal_ratings
  ,p_fiscal_ratings_uom              =>p_fiscal_ratings_uom
  ,p_vehicle_provider                =>p_vehicle_provider
  ,p_vehicle_ownership               =>p_vehicle_ownership
  ,p_shared_vehicle                  =>p_shared_vehicle
  ,p_asset_number                    =>p_asset_number
  ,p_lease_contract_number           =>p_lease_contract_number
  ,p_lease_contract_expiry_date      =>p_lease_contract_expiry_date
  ,p_taxation_method                 =>p_taxation_method
  ,p_fleet_info                      =>p_fleet_info
  ,p_fleet_transfer_date             =>p_fleet_transfer_date
  ,p_color                           =>p_color
  ,p_seating_capacity                =>p_seating_capacity
  ,p_weight                          =>p_weight
  ,p_weight_uom                      =>p_weight_uom
  ,p_model_year                      =>p_model_year
  ,p_insurance_number                =>p_insurance_number
  ,p_insurance_expiry_date           =>p_insurance_expiry_date
  ,p_comments                        =>p_comments
  ,p_vre_attribute_category          =>p_vre_attribute_category
  ,p_vre_attribute1                  =>p_vre_attribute1
  ,p_vre_attribute2                  =>p_vre_attribute2
  ,p_vre_attribute3                  =>p_vre_attribute3
  ,p_vre_attribute4                  =>p_vre_attribute4
  ,p_vre_attribute5                  =>p_vre_attribute5
  ,p_vre_attribute6                  =>p_vre_attribute6
  ,p_vre_attribute7                  =>p_vre_attribute7
  ,p_vre_attribute8                  =>p_vre_attribute8
  ,p_vre_attribute9                  =>p_vre_attribute9
  ,p_vre_attribute10                 =>p_vre_attribute10
  ,p_vre_attribute11                 =>p_vre_attribute11
  ,p_vre_attribute12                 =>p_vre_attribute12
  ,p_vre_attribute13                 =>p_vre_attribute13
  ,p_vre_attribute14                 =>p_vre_attribute14
  ,p_vre_attribute15                 =>p_vre_attribute15
  ,p_vre_attribute16                 =>p_vre_attribute16
  ,p_vre_attribute17                 =>p_vre_attribute17
  ,p_vre_attribute18                 =>p_vre_attribute18
  ,p_vre_attribute19                 =>p_vre_attribute19
  ,p_vre_attribute20                 =>p_vre_attribute20
  ,p_vre_information_category        =>p_vre_information_category
  ,p_vre_information1                =>p_vre_information1
  ,p_vre_information2                =>p_vre_information2
  ,p_vre_information3                =>p_vre_information3
  ,p_vre_information4                =>p_vre_information4
  ,p_vre_information5                =>p_vre_information5
  ,p_vre_information6                =>p_vre_information6
  ,p_vre_information7                =>p_vre_information7
  ,p_vre_information8                =>p_vre_information8
  ,p_vre_information9                =>p_vre_information9
  ,p_vre_information10               =>p_vre_information10
  ,p_vre_information11               =>p_vre_information11
  ,p_vre_information12               =>p_vre_information12
  ,p_vre_information13               =>p_vre_information13
  ,p_vre_information14               =>p_vre_information14
  ,p_vre_information15               =>p_vre_information15
  ,p_vre_information16               =>p_vre_information16
  ,p_vre_information17               =>p_vre_information17
  ,p_vre_information18               =>p_vre_information18
  ,p_vre_information19               =>p_vre_information19
  ,p_vre_information20               =>p_vre_information20
  ,p_effective_start_date            =>p_effective_start_date
  ,p_effective_end_date              =>p_effective_end_date
  ) ;
Line: 872

    rollback to update_vehicle;
Line: 885

    rollback to update_vehicle;
Line: 891

END  update_vehicle;
Line: 900

Procedure delete_vehicle
  (p_validate                         in     boolean
  ,p_effective_date                   in     date
  ,p_datetrack_mode                   in     varchar2
  ,p_vehicle_repository_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';
Line: 925

  savepoint delete_vehicle;
Line: 929

  PQP_VEHICLE_REPOSITORY_BK3.delete_vehicle_b
  (p_validate                 =>p_validate
  ,p_effective_date           =>l_effective_date
  ,p_datetrack_mode           =>p_datetrack_mode
  ,p_vehicle_repository_id    =>p_vehicle_repository_id
  ,p_object_version_number    =>p_object_version_number
  ) ;
Line: 958

  PQP_VEHICLE_REPOSITORY_BK3.delete_vehicle_a
  (p_validate                 =>p_validate
  ,p_effective_date           =>l_effective_date
  ,p_datetrack_mode           =>p_datetrack_mode
  ,p_vehicle_repository_id    =>p_vehicle_repository_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: 997

    rollback to delete_vehicle;
Line: 1011

    rollback to delete_vehicle;
Line: 1017

END delete_vehicle;