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_VEH_REPOS_EXTRA_INFO_SWI SQL Statements

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

Line: 70


  ,p_program_update_date          in     date
  ,p_veh_repos_extra_info_id         out nocopy   number
  ,p_object_version_number           out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 171


    ,p_program_update_date          => p_program_update_date
    ,p_veh_repos_extra_info_id      => l_veh_repos_extra_info_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 227


PROCEDURE update_veh_repos_extra_info
  (p_validate                     in     number
  ,p_veh_repos_extra_info_id      in     number
  ,p_object_version_number        in out nocopy number
  ,p_vehicle_repository_id        in     number
  ,p_information_type             in     varchar2
  ,p_vrei_attribute_category      in     varchar2
  ,p_vrei_attribute1              in     varchar2
  ,p_vrei_attribute2              in     varchar2
  ,p_vrei_attribute3              in     varchar2
  ,p_vrei_attribute4              in     varchar2
  ,p_vrei_attribute5              in     varchar2
  ,p_vrei_attribute6              in     varchar2
  ,p_vrei_attribute7              in     varchar2
  ,p_vrei_attribute8              in     varchar2
  ,p_vrei_attribute9              in     varchar2
  ,p_vrei_attribute10             in     varchar2
  ,p_vrei_attribute11             in     varchar2
  ,p_vrei_attribute12             in     varchar2
  ,p_vrei_attribute13             in     varchar2
  ,p_vrei_attribute14             in     varchar2
  ,p_vrei_attribute15             in     varchar2
  ,p_vrei_attribute16             in     varchar2
  ,p_vrei_attribute17             in     varchar2
  ,p_vrei_attribute18             in     varchar2
  ,p_vrei_attribute19             in     varchar2
  ,p_vrei_attribute20             in     varchar2
  ,p_vrei_information_category    in     varchar2
  ,p_vrei_information1            in     varchar2
  ,p_vrei_information2            in     varchar2
  ,p_vrei_information3            in     varchar2
  ,p_vrei_information4            in     varchar2
  ,p_vrei_information5            in     varchar2
  ,p_vrei_information6            in     varchar2
  ,p_vrei_information7            in     varchar2
  ,p_vrei_information8            in     varchar2
  ,p_vrei_information9            in     varchar2
  ,p_vrei_information10           in     varchar2
  ,p_vrei_information11           in     varchar2
  ,p_vrei_information12           in     varchar2
  ,p_vrei_information13           in     varchar2
  ,p_vrei_information14           in     varchar2
  ,p_vrei_information15           in     varchar2
  ,p_vrei_information16           in     varchar2
  ,p_vrei_information17           in     varchar2
  ,p_vrei_information18           in     varchar2
  ,p_vrei_information19           in     varchar2
  ,p_vrei_information20           in     varchar2
  ,p_vrei_information21           in     varchar2
  ,p_vrei_information22           in     varchar2
  ,p_vrei_information23           in     varchar2
  ,p_vrei_information24           in     varchar2
  ,p_vrei_information25           in     varchar2
  ,p_vrei_information26           in     varchar2
  ,p_vrei_information27           in     varchar2
  ,p_vrei_information28           in     varchar2
  ,p_vrei_information29           in     varchar2
  ,p_vrei_information30           in     varchar2
  ,p_request_id                   in     number
  ,p_program_application_id       in     number
  ,p_program_id                   in     number
  ,p_program_update_date          in     date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 299


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

Line: 305


  savepoint update_veh_repos_xtra_info_swi;

Line: 326


  pqp_veh_repos_extra_info_api.update_veh_repos_extra_info
    (p_validate                     => l_validate
    ,p_veh_repos_extra_info_id      => p_veh_repos_extra_info_id
    ,p_object_version_number        => p_object_version_number
    ,p_vehicle_repository_id        => p_vehicle_repository_id
    ,p_information_type             => p_information_type
    ,p_vrei_attribute_category      => p_vrei_attribute_category
    ,p_vrei_attribute1              => p_vrei_attribute1
    ,p_vrei_attribute2              => p_vrei_attribute2
    ,p_vrei_attribute3              => p_vrei_attribute3
    ,p_vrei_attribute4              => p_vrei_attribute4
    ,p_vrei_attribute5              => p_vrei_attribute5
    ,p_vrei_attribute6              => p_vrei_attribute6
    ,p_vrei_attribute7              => p_vrei_attribute7
    ,p_vrei_attribute8              => p_vrei_attribute8
    ,p_vrei_attribute9              => p_vrei_attribute9
    ,p_vrei_attribute10             => p_vrei_attribute10
    ,p_vrei_attribute11             => p_vrei_attribute11
    ,p_vrei_attribute12             => p_vrei_attribute12
    ,p_vrei_attribute13             => p_vrei_attribute13
    ,p_vrei_attribute14             => p_vrei_attribute14
    ,p_vrei_attribute15             => p_vrei_attribute15
    ,p_vrei_attribute16             => p_vrei_attribute16
    ,p_vrei_attribute17             => p_vrei_attribute17
    ,p_vrei_attribute18             => p_vrei_attribute18
    ,p_vrei_attribute19             => p_vrei_attribute19
    ,p_vrei_attribute20             => p_vrei_attribute20
    ,p_vrei_information_category    => p_vrei_information_category
    ,p_vrei_information1            => p_vrei_information1
    ,p_vrei_information2            => p_vrei_information2
    ,p_vrei_information3            => p_vrei_information3
    ,p_vrei_information4            => p_vrei_information4
    ,p_vrei_information5            => p_vrei_information5
    ,p_vrei_information6            => p_vrei_information6
    ,p_vrei_information7            => p_vrei_information7
    ,p_vrei_information8            => p_vrei_information8
    ,p_vrei_information9            => p_vrei_information9
    ,p_vrei_information10           => p_vrei_information10
    ,p_vrei_information11           => p_vrei_information11
    ,p_vrei_information12           => p_vrei_information12
    ,p_vrei_information13           => p_vrei_information13
    ,p_vrei_information14           => p_vrei_information14
    ,p_vrei_information15           => p_vrei_information15
    ,p_vrei_information16           => p_vrei_information16
    ,p_vrei_information17           => p_vrei_information17
    ,p_vrei_information18           => p_vrei_information18
    ,p_vrei_information19           => p_vrei_information19
    ,p_vrei_information20           => p_vrei_information20
    ,p_vrei_information21           => p_vrei_information21
    ,p_vrei_information22           => p_vrei_information22
    ,p_vrei_information23           => p_vrei_information23
    ,p_vrei_information24           => p_vrei_information24
    ,p_vrei_information25           => p_vrei_information25
    ,p_vrei_information26           => p_vrei_information26
    ,p_vrei_information27           => p_vrei_information27
    ,p_vrei_information28           => p_vrei_information28
    ,p_vrei_information29           => p_vrei_information29
    ,p_vrei_information30           => p_vrei_information30
    ,p_request_id                   => p_request_id
    ,p_program_application_id       => p_program_application_id
    ,p_program_id                   => p_program_id
    ,p_program_update_date          => p_program_update_date
    );

Line: 411


    rollback to update_veh_repos_xtra_info_swi;

Line: 426


    rollback to update_veh_repos_xtra_info_swi;

Line: 437


end update_veh_repos_extra_info;

Line: 441


PROCEDURE delete_veh_repos_extra_info
  (p_validate                     in     number
  ,p_veh_repos_extra_info_id      in     number
  ,p_object_version_number        in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 454


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

Line: 460


  savepoint delete_veh_repos_xtra_info_swi;

Line: 480


  pqp_veh_repos_extra_info_api.delete_veh_repos_extra_info
    (p_validate                     => l_validate
    ,p_veh_repos_extra_info_id      => p_veh_repos_extra_info_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 507


    rollback to delete_veh_repos_xtra_info_swi;

Line: 521


    rollback to delete_veh_repos_xtra_info_swi;

Line: 531


end delete_veh_repos_extra_info;