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

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

Line: 71


  ,p_program_update_date            in     date
  ,p_veh_alloc_extra_info_id        out nocopy number
  ,p_object_version_number          out nocopy number
  )
IS
  --
  -- Declare cursors and local variables
  --
  l_in_out_parameter    number;

Line: 158


  ,p_program_update_date            =>p_program_update_date
  );

Line: 230


  ,p_program_update_date            =>p_program_update_date
  ,p_veh_alloc_extra_info_id        =>p_veh_alloc_extra_info_id
  ,p_object_version_number          =>p_object_version_number
  );

Line: 302


  ,p_program_update_date            =>p_program_update_date
  ,p_veh_alloc_extra_info_id        =>p_veh_alloc_extra_info_id
  ,p_object_version_number          =>p_object_version_number
  );

Line: 361


 procedure update_veh_alloc_extra_info
 ( p_validate                     in    boolean
  ,p_veh_alloc_extra_info_id      in     number
  ,p_object_version_number        in out nocopy number
  ,p_vehicle_allocation_id        in     number
  ,p_information_type             in     varchar2
  ,p_vaei_attribute_category      in     varchar2
  ,p_vaei_attribute1              in     varchar2
  ,p_vaei_attribute2              in     varchar2
  ,p_vaei_attribute3              in     varchar2
  ,p_vaei_attribute4              in     varchar2
  ,p_vaei_attribute5              in     varchar2
  ,p_vaei_attribute6              in     varchar2
  ,p_vaei_attribute7              in     varchar2
  ,p_vaei_attribute8              in     varchar2
  ,p_vaei_attribute9              in     varchar2
  ,p_vaei_attribute10             in     varchar2
  ,p_vaei_attribute11             in     varchar2
  ,p_vaei_attribute12             in     varchar2
  ,p_vaei_attribute13             in     varchar2
  ,p_vaei_attribute14             in     varchar2
  ,p_vaei_attribute15             in     varchar2
  ,p_vaei_attribute16             in     varchar2
  ,p_vaei_attribute17             in     varchar2
  ,p_vaei_attribute18             in     varchar2
  ,p_vaei_attribute19             in     varchar2
  ,p_vaei_attribute20             in     varchar2
  ,p_vaei_information_category    in     varchar2
  ,p_vaei_information1            in     varchar2
  ,p_vaei_information2            in     varchar2
  ,p_vaei_information3            in     varchar2
  ,p_vaei_information4            in     varchar2
  ,p_vaei_information5            in     varchar2
  ,p_vaei_information6            in     varchar2
  ,p_vaei_information7            in     varchar2
  ,p_vaei_information8            in     varchar2
  ,p_vaei_information9            in     varchar2
  ,p_vaei_information10           in     varchar2
  ,p_vaei_information11           in     varchar2
  ,p_vaei_information12           in     varchar2
  ,p_vaei_information13           in     varchar2
  ,p_vaei_information14           in     varchar2
  ,p_vaei_information15           in     varchar2
  ,p_vaei_information16           in     varchar2
  ,p_vaei_information17           in     varchar2
  ,p_vaei_information18           in     varchar2
  ,p_vaei_information19           in     varchar2
  ,p_vaei_information20           in     varchar2
  ,p_vaei_information21           in     varchar2
  ,p_vaei_information22           in     varchar2
  ,p_vaei_information23           in     varchar2
  ,p_vaei_information24           in     varchar2
  ,p_vaei_information25           in     varchar2
  ,p_vaei_information26           in     varchar2
  ,p_vaei_information27           in     varchar2
  ,p_vaei_information28           in     varchar2
  ,p_vaei_information29           in     varchar2
  ,p_vaei_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
  )
is
 l_effective_date      date;

Line: 426


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

Line: 433


  savepoint UPDATE_VEH_ALLOC_EXTRA_INFO;

Line: 446


    pqp_veh_alloc_extra_info_bk2.update_veh_alloc_extra_info_b
 ( p_veh_alloc_extra_info_id        =>p_veh_alloc_extra_info_id
  ,p_object_version_number          =>p_object_version_number
  ,p_vehicle_allocation_id          =>p_vehicle_allocation_id
  ,p_information_type               =>p_information_type
  ,p_vaei_attribute_category        =>p_vaei_attribute_category
  ,p_vaei_attribute1                =>p_vaei_attribute1
  ,p_vaei_attribute2                =>p_vaei_attribute2
  ,p_vaei_attribute3                =>p_vaei_attribute3
  ,p_vaei_attribute4                =>p_vaei_attribute4
  ,p_vaei_attribute5                =>p_vaei_attribute5
  ,p_vaei_attribute6                =>p_vaei_attribute6
  ,p_vaei_attribute7                =>p_vaei_attribute7
  ,p_vaei_attribute8                =>p_vaei_attribute8
  ,p_vaei_attribute9                =>p_vaei_attribute9
  ,p_vaei_attribute10               =>p_vaei_attribute10
  ,p_vaei_attribute11               =>p_vaei_attribute11
  ,p_vaei_attribute12               =>p_vaei_attribute12
  ,p_vaei_attribute13               =>p_vaei_attribute13
  ,p_vaei_attribute14               =>p_vaei_attribute14
  ,p_vaei_attribute15               =>p_vaei_attribute15
  ,p_vaei_attribute16               =>p_vaei_attribute16
  ,p_vaei_attribute17               =>p_vaei_attribute17
  ,p_vaei_attribute18               =>p_vaei_attribute18
  ,p_vaei_attribute19               =>p_vaei_attribute19
  ,p_vaei_attribute20               =>p_vaei_attribute20
  ,p_vaei_information_category      =>p_vaei_information_category
  ,p_vaei_information1              =>p_vaei_information1
  ,p_vaei_information2              =>p_vaei_information2
  ,p_vaei_information3              =>p_vaei_information3
  ,p_vaei_information4              =>p_vaei_information4
  ,p_vaei_information5              =>p_vaei_information5
  ,p_vaei_information6              =>p_vaei_information6
  ,p_vaei_information7              =>p_vaei_information7
  ,p_vaei_information8              =>p_vaei_information8
  ,p_vaei_information9              =>p_vaei_information9
  ,p_vaei_information10             =>p_vaei_information10
  ,p_vaei_information11             =>p_vaei_information11
  ,p_vaei_information12             =>p_vaei_information12
  ,p_vaei_information13             =>p_vaei_information13
  ,p_vaei_information14             =>p_vaei_information14
  ,p_vaei_information15             =>p_vaei_information15
  ,p_vaei_information16             =>p_vaei_information16
  ,p_vaei_information17             =>p_vaei_information17
  ,p_vaei_information18             =>p_vaei_information18
  ,p_vaei_information19             =>p_vaei_information19
  ,p_vaei_information20             =>p_vaei_information20
  ,p_vaei_information21             =>p_vaei_information21
  ,p_vaei_information22             =>p_vaei_information22
  ,p_vaei_information23             =>p_vaei_information23
  ,p_vaei_information24             =>p_vaei_information24
  ,p_vaei_information25             =>p_vaei_information25
  ,p_vaei_information26             =>p_vaei_information26
  ,p_vaei_information27             =>p_vaei_information27
  ,p_vaei_information28             =>p_vaei_information28
  ,p_vaei_information29             =>p_vaei_information29
  ,p_vaei_information30             =>p_vaei_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: 580


  ,p_program_update_date            =>p_program_update_date
  );

Line: 592


  pqp_veh_alloc_extra_info_bk2.update_veh_alloc_extra_info_a
 ( p_veh_alloc_extra_info_id        => p_veh_alloc_extra_info_id
  ,p_object_version_number          =>p_object_version_number
  ,p_vehicle_allocation_id          =>p_vehicle_allocation_id
  ,p_information_type               =>p_information_type
  ,p_vaei_attribute_category        =>p_vaei_attribute_category
  ,p_vaei_attribute1                =>p_vaei_attribute1
  ,p_vaei_attribute2                =>p_vaei_attribute2
  ,p_vaei_attribute3                =>p_vaei_attribute3
  ,p_vaei_attribute4                =>p_vaei_attribute4
  ,p_vaei_attribute5                =>p_vaei_attribute5
  ,p_vaei_attribute6                =>p_vaei_attribute6
  ,p_vaei_attribute7                =>p_vaei_attribute7
  ,p_vaei_attribute8                =>p_vaei_attribute8
  ,p_vaei_attribute9                =>p_vaei_attribute9
  ,p_vaei_attribute10               =>p_vaei_attribute10
  ,p_vaei_attribute11               =>p_vaei_attribute11
  ,p_vaei_attribute12               =>p_vaei_attribute12
  ,p_vaei_attribute13               =>p_vaei_attribute13
  ,p_vaei_attribute14               =>p_vaei_attribute14
  ,p_vaei_attribute15               =>p_vaei_attribute15
  ,p_vaei_attribute16               =>p_vaei_attribute16
  ,p_vaei_attribute17               =>p_vaei_attribute17
  ,p_vaei_attribute18               =>p_vaei_attribute18
  ,p_vaei_attribute19               =>p_vaei_attribute19
  ,p_vaei_attribute20               =>p_vaei_attribute20
  ,p_vaei_information_category      =>p_vaei_information_category
  ,p_vaei_information1              =>p_vaei_information1
  ,p_vaei_information2              =>p_vaei_information2
  ,p_vaei_information3              =>p_vaei_information3
  ,p_vaei_information4              =>p_vaei_information4
  ,p_vaei_information5              =>p_vaei_information5
  ,p_vaei_information6              =>p_vaei_information6
  ,p_vaei_information7              =>p_vaei_information7
  ,p_vaei_information8              =>p_vaei_information8
  ,p_vaei_information9              =>p_vaei_information9
  ,p_vaei_information10             =>p_vaei_information10
  ,p_vaei_information11             =>p_vaei_information11
  ,p_vaei_information12             =>p_vaei_information12
  ,p_vaei_information13             =>p_vaei_information13
  ,p_vaei_information14             =>p_vaei_information14
  ,p_vaei_information15             =>p_vaei_information15
  ,p_vaei_information16             =>p_vaei_information16
  ,p_vaei_information17             =>p_vaei_information17
  ,p_vaei_information18             =>p_vaei_information18
  ,p_vaei_information19             =>p_vaei_information19
  ,p_vaei_information20             =>p_vaei_information20
  ,p_vaei_information21             =>p_vaei_information21
  ,p_vaei_information22             =>p_vaei_information22
  ,p_vaei_information23             =>p_vaei_information23
  ,p_vaei_information24             =>p_vaei_information24
  ,p_vaei_information25             =>p_vaei_information25
  ,p_vaei_information26             =>p_vaei_information26
  ,p_vaei_information27             =>p_vaei_information27
  ,p_vaei_information28             =>p_vaei_information28
  ,p_vaei_information29             =>p_vaei_information29
  ,p_vaei_information30             =>p_vaei_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: 678


    rollback to UPDATE_VEH_ALLOC_EXTRA_INFO;

Line: 689


    rollback to UPDATE_VEH_ALLOC_EXTRA_INFO;

Line: 696


end update_veh_alloc_extra_info;

Line: 702


procedure delete_veh_alloc_extra_info
( p_validate                       in     boolean  default false
 ,p_veh_alloc_extra_info_id        in     number
 ,p_object_version_number           in     number
 )
is
 cursor csr_veh_id (c_veh_alloc_extra_info_id in number) is
 select vae.vehicle_allocation_id
   from pqp_veh_alloc_extra_info vae
  where vae.veh_alloc_extra_info_id = c_veh_alloc_extra_info_id;

Line: 715


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

Line: 723


  savepoint delete_veh_alloc_extra_info;

Line: 738


  pqp_veh_alloc_extra_info_bk3.delete_veh_alloc_extra_info_b
  (p_veh_alloc_extra_info_id  => p_veh_alloc_extra_info_id
  ,p_vehicle_allocation_id    => l_vehicle_allocation_id
  ,p_object_version_number    =>p_object_version_number
  );

Line: 765


  pqp_veh_alloc_extra_info_bk3.delete_veh_alloc_extra_info_a
  (p_veh_alloc_extra_info_id  => p_veh_alloc_extra_info_id
  ,p_vehicle_allocation_id    => l_vehicle_allocation_id
  ,p_object_version_number    =>p_object_version_number
  );

Line: 794


    rollback to DELETE_VEH_ALLOC_EXTRA_INFO;

Line: 805


    rollback to DELETE_VEH_ALLOC_EXTRA_INFO;

Line: 812


end  delete_veh_alloc_extra_info;