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

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

Line: 353


procedure update_service_history_period
  (p_validate                      in     boolean  default false
  ,p_service_history_period_id     in     number
  ,p_assignment_id                 in     number   default hr_api.g_number
  ,p_start_date                    in     date     default hr_api.g_date
  ,p_end_date                      in     date     default hr_api.g_date
  ,p_employer_name                 in     varchar2 default hr_api.g_varchar2
  ,p_employer_address              in     varchar2 default hr_api.g_varchar2
  ,p_employer_type                 in     varchar2 default hr_api.g_varchar2
  ,p_employer_subtype              in     varchar2 default hr_api.g_varchar2
  ,p_description                   in     varchar2 default hr_api.g_varchar2
  ,p_continuous_service            in     varchar2 default hr_api.g_varchar2
  ,p_all_assignments               in     varchar2 default hr_api.g_varchar2
  ,p_period_years                  in     number   default hr_api.g_number
  ,p_period_days                   in     number   default hr_api.g_number
  ,p_shp_attribute_category        in     varchar2 default hr_api.g_varchar2
  ,p_shp_attribute1                in     varchar2 default hr_api.g_varchar2
  ,p_shp_attribute2                in     varchar2 default hr_api.g_varchar2
  ,p_shp_attribute3                in     varchar2 default hr_api.g_varchar2
  ,p_shp_attribute4                in     varchar2 default hr_api.g_varchar2
  ,p_shp_attribute5                in     varchar2 default hr_api.g_varchar2
  ,p_shp_attribute6                in     varchar2 default hr_api.g_varchar2
  ,p_shp_attribute7                in     varchar2 default hr_api.g_varchar2
  ,p_shp_attribute8                in     varchar2 default hr_api.g_varchar2
  ,p_shp_attribute9                in     varchar2 default hr_api.g_varchar2
  ,p_shp_attribute10               in     varchar2 default hr_api.g_varchar2
  ,p_shp_attribute11               in     varchar2 default hr_api.g_varchar2
  ,p_shp_attribute12               in     varchar2 default hr_api.g_varchar2
  ,p_shp_attribute13               in     varchar2 default hr_api.g_varchar2
  ,p_shp_attribute14               in     varchar2 default hr_api.g_varchar2
  ,p_shp_attribute15               in     varchar2 default hr_api.g_varchar2
  ,p_shp_attribute16               in     varchar2 default hr_api.g_varchar2
  ,p_shp_attribute17               in     varchar2 default hr_api.g_varchar2
  ,p_shp_attribute18               in     varchar2 default hr_api.g_varchar2
  ,p_shp_attribute19               in     varchar2 default hr_api.g_varchar2
  ,p_shp_attribute20               in     varchar2 default hr_api.g_varchar2
  ,p_shp_information_category      in     varchar2 default hr_api.g_varchar2
  ,p_shp_information1              in     varchar2 default hr_api.g_varchar2
  ,p_shp_information2              in     varchar2 default hr_api.g_varchar2
  ,p_shp_information3              in     varchar2 default hr_api.g_varchar2
  ,p_shp_information4              in     varchar2 default hr_api.g_varchar2
  ,p_shp_information5              in     varchar2 default hr_api.g_varchar2
  ,p_shp_information6              in     varchar2 default hr_api.g_varchar2
  ,p_shp_information7              in     varchar2 default hr_api.g_varchar2
  ,p_shp_information8              in     varchar2 default hr_api.g_varchar2
  ,p_shp_information9              in     varchar2 default hr_api.g_varchar2
  ,p_shp_information10             in     varchar2 default hr_api.g_varchar2
  ,p_shp_information11             in     varchar2 default hr_api.g_varchar2
  ,p_shp_information12             in     varchar2 default hr_api.g_varchar2
  ,p_shp_information13             in     varchar2 default hr_api.g_varchar2
  ,p_shp_information14             in     varchar2 default hr_api.g_varchar2
  ,p_shp_information15             in     varchar2 default hr_api.g_varchar2
  ,p_shp_information16             in     varchar2 default hr_api.g_varchar2
  ,p_shp_information17             in     varchar2 default hr_api.g_varchar2
  ,p_shp_information18             in     varchar2 default hr_api.g_varchar2
  ,p_shp_information19             in     varchar2 default hr_api.g_varchar2
  ,p_shp_information20             in     varchar2 default hr_api.g_varchar2
  ,p_object_version_number         in out nocopy number
  ) is

  --
  -- Declare cursors and local variables
  --

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

Line: 427


  savepoint update_service_history_period;

Line: 438


    pqp_service_history_period_bk2.update_pqp_service_hist_pd_b
      (p_service_history_period_id  => p_service_history_period_id
      ,p_assignment_id              => p_assignment_id
      ,p_start_date                 => l_start_date
      ,p_end_date                   => l_end_date
      ,p_employer_name              => p_employer_name
      ,p_employer_address           => p_employer_address
      ,p_employer_type              => p_employer_type
      ,p_employer_subtype           => p_employer_subtype
      ,p_description                => p_description
      ,p_continuous_service         => p_continuous_service
      ,p_all_assignments            => p_all_assignments
      ,p_period_years               => p_period_years
      ,p_period_days                => p_period_days
      ,p_object_version_number      => p_object_version_number
      ,p_shp_attribute_category => p_shp_attribute_category
      ,p_shp_attribute1      => p_shp_attribute1
      ,p_shp_attribute2      => p_shp_attribute2
      ,p_shp_attribute3      => p_shp_attribute3
      ,p_shp_attribute4      => p_shp_attribute4
      ,p_shp_attribute5      => p_shp_attribute5
      ,p_shp_attribute6      => p_shp_attribute6
      ,p_shp_attribute7      => p_shp_attribute7
      ,p_shp_attribute8      => p_shp_attribute8
      ,p_shp_attribute9      => p_shp_attribute9
      ,p_shp_attribute10     => p_shp_attribute10
      ,p_shp_attribute11     => p_shp_attribute11
      ,p_shp_attribute12     => p_shp_attribute12
      ,p_shp_attribute13     => p_shp_attribute13
      ,p_shp_attribute14     => p_shp_attribute14
      ,p_shp_attribute15     => p_shp_attribute15
      ,p_shp_attribute16     => p_shp_attribute16
      ,p_shp_attribute17     => p_shp_attribute17
      ,p_shp_attribute18     => p_shp_attribute18
      ,p_shp_attribute19     => p_shp_attribute19
      ,p_shp_attribute20     => p_shp_attribute20
      ,p_shp_information_category => p_shp_information_category
      ,p_shp_information1    => p_shp_information1
      ,p_shp_information2    => p_shp_information2
      ,p_shp_information3    => p_shp_information3
      ,p_shp_information4    => p_shp_information4
      ,p_shp_information5    => p_shp_information5
      ,p_shp_information6    => p_shp_information6
      ,p_shp_information7    => p_shp_information7
      ,p_shp_information8    => p_shp_information8
      ,p_shp_information9    => p_shp_information9
      ,p_shp_information10   => p_shp_information10
      ,p_shp_information11   => p_shp_information11
      ,p_shp_information12   => p_shp_information12
      ,p_shp_information13   => p_shp_information13
      ,p_shp_information14   => p_shp_information14
      ,p_shp_information15   => p_shp_information15
      ,p_shp_information16   => p_shp_information16
      ,p_shp_information17   => p_shp_information17
      ,p_shp_information18   => p_shp_information18
      ,p_shp_information19   => p_shp_information19
      ,p_shp_information20   => p_shp_information20
      );

Line: 499


        (p_module_name => 'update_service_history_period'
        ,p_hook_type   => 'BP'
        );

Line: 581


    pqp_service_history_period_bk2.update_pqp_service_hist_pd_a
      (p_service_history_period_id   => p_service_history_period_id
      ,p_object_version_number       => l_object_version_number
      ,p_assignment_id               => p_assignment_id
      ,p_start_date                  => l_start_date
      ,p_end_date                    => l_end_date
      ,p_employer_name               => p_employer_name
      ,p_employer_address            => p_employer_address
      ,p_employer_type               => p_employer_type
      ,p_employer_subtype            => p_employer_subtype
      ,p_description                 => p_description
      ,p_continuous_service          => p_continuous_service
      ,p_all_assignments             => p_all_assignments
      ,p_period_years                => p_period_years
      ,p_period_days                 => p_period_days
      ,p_shp_attribute_category => p_shp_attribute_category
      ,p_shp_attribute1      => p_shp_attribute1
      ,p_shp_attribute2      => p_shp_attribute2
      ,p_shp_attribute3      => p_shp_attribute3
      ,p_shp_attribute4      => p_shp_attribute4
      ,p_shp_attribute5      => p_shp_attribute5
      ,p_shp_attribute6      => p_shp_attribute6
      ,p_shp_attribute7      => p_shp_attribute7
      ,p_shp_attribute8      => p_shp_attribute8
      ,p_shp_attribute9      => p_shp_attribute9
      ,p_shp_attribute10     => p_shp_attribute10
      ,p_shp_attribute11     => p_shp_attribute11
      ,p_shp_attribute12     => p_shp_attribute12
      ,p_shp_attribute13     => p_shp_attribute13
      ,p_shp_attribute14     => p_shp_attribute14
      ,p_shp_attribute15     => p_shp_attribute15
      ,p_shp_attribute16     => p_shp_attribute16
      ,p_shp_attribute17     => p_shp_attribute17
      ,p_shp_attribute18     => p_shp_attribute18
      ,p_shp_attribute19     => p_shp_attribute19
      ,p_shp_attribute20     => p_shp_attribute20
      ,p_shp_information_category => p_shp_information_category
      ,p_shp_information1    => p_shp_information1
      ,p_shp_information2    => p_shp_information2
      ,p_shp_information3    => p_shp_information3
      ,p_shp_information4    => p_shp_information4
      ,p_shp_information5    => p_shp_information5
      ,p_shp_information6    => p_shp_information6
      ,p_shp_information7    => p_shp_information7
      ,p_shp_information8    => p_shp_information8
      ,p_shp_information9    => p_shp_information9
      ,p_shp_information10   => p_shp_information10
      ,p_shp_information11   => p_shp_information11
      ,p_shp_information12   => p_shp_information12
      ,p_shp_information13   => p_shp_information13
      ,p_shp_information14   => p_shp_information14
      ,p_shp_information15   => p_shp_information15
      ,p_shp_information16   => p_shp_information16
      ,p_shp_information17   => p_shp_information17
      ,p_shp_information18   => p_shp_information18
      ,p_shp_information19   => p_shp_information19
      ,p_shp_information20   => p_shp_information20
      );

Line: 642


        (p_module_name => 'update_service_history_period'
        ,p_hook_type   => 'AP'
        );

Line: 665


    rollback to update_service_history_period;

Line: 677


    rollback to update_service_history_period;

Line: 681


end update_service_history_period;

Line: 687


procedure delete_service_history_period
  (p_validate                      in     boolean  default false
  ,p_service_history_period_id     in     number
  ,p_object_version_number         in     number
  ) is

  --
  -- Declare cursors and local variables
  --

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

Line: 704


  savepoint delete_service_history_period;

Line: 711


    pqp_service_history_period_bk3.delete_pqp_service_hist_pd_b
      (p_service_history_period_id  => p_service_history_period_id
      ,p_object_version_number      => p_object_version_number
      );

Line: 718


        (p_module_name => 'delete_service_history_period'
        ,p_hook_type   => 'BP'
        );

Line: 745


    pqp_service_history_period_bk3.delete_pqp_service_hist_pd_a
      (p_service_history_period_id   => p_service_history_period_id
      ,p_object_version_number       => p_object_version_number
      );

Line: 752


        (p_module_name => 'delete_service_history_period'
        ,p_hook_type   => 'AP'
        );

Line: 774


    rollback to delete_service_history_period;

Line: 785


    rollback to delete_service_history_period;

Line: 788


end delete_service_history_period;