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.PAY_RUN_TYPE_API SQL Statements

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

Line: 306


procedure update_run_type
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_datetrack_update_mode         in     varchar2
  ,p_language_code                 in     varchar2 default hr_api.userenv_lang
  ,p_run_type_id                   in     number
  ,p_object_version_number         in out nocopy number
  ,p_business_group_id             in     number   default hr_api.g_number
  ,p_legislation_code              in     varchar2 default hr_api.g_varchar2
  ,p_shortname                     in     varchar2 default hr_api.g_varchar2
  ,p_srs_flag                      in     varchar2 default hr_api.g_varchar2
  ,p_run_information_category	   in     varchar2 default hr_api.g_varchar2
  ,p_run_information1		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information2		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information3		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information4		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information5		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information6		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information7		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information8		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information9		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information10		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information11		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information12		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information13		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information14		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information15		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information16		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information17		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information18		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information19		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information20		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information21		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information22		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information23		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information24		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information25		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information26		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information27		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information28		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information29		   in     varchar2 default hr_api.g_varchar2
  ,p_run_information30		   in     varchar2 default hr_api.g_varchar2
  ,p_effective_start_date             out nocopy date
  ,p_effective_end_date               out nocopy date
  ) is
  --
  -- Declare cursors and local variables
  --

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

Line: 374


  savepoint update_run_type;

Line: 389


    pay_run_type_bk2.update_run_type_b
      (p_effective_date                => l_effective_date
      ,p_datetrack_update_mode         => p_datetrack_update_mode
      ,p_language_code                 => l_language_code
      ,p_run_type_id                   => p_run_type_id
      ,p_object_version_number         => p_object_version_number
      ,p_business_group_id             => p_business_group_id
      ,p_legislation_code              => p_legislation_code
      ,p_shortname                     => p_shortname
      ,p_srs_flag                      => p_srs_flag
      ,p_run_information_category      => p_run_information_category
      ,p_run_information1	       => p_run_information1
      ,p_run_information2	       => p_run_information2
      ,p_run_information3	       => p_run_information3
      ,p_run_information4	       => p_run_information4
      ,p_run_information5	       => p_run_information5
      ,p_run_information6	       => p_run_information6
      ,p_run_information7	       => p_run_information7
      ,p_run_information8	       => p_run_information8
      ,p_run_information9	       => p_run_information9
      ,p_run_information10	       => p_run_information10
      ,p_run_information11	       => p_run_information11
      ,p_run_information12	       => p_run_information12
      ,p_run_information13	       => p_run_information13
      ,p_run_information14	       => p_run_information14
      ,p_run_information15	       => p_run_information15
      ,p_run_information16	       => p_run_information16
      ,p_run_information17	       => p_run_information17
      ,p_run_information18	       => p_run_information18
      ,p_run_information19	       => p_run_information19
      ,p_run_information20	       => p_run_information20
      ,p_run_information21	       => p_run_information21
      ,p_run_information22	       => p_run_information22
      ,p_run_information23	       => p_run_information23
      ,p_run_information24	       => p_run_information24
      ,p_run_information25	       => p_run_information25
      ,p_run_information26	       => p_run_information26
      ,p_run_information27	       => p_run_information27
      ,p_run_information28	       => p_run_information28
      ,p_run_information29	       => p_run_information29
      ,p_run_information30	       => p_run_information30
      );

Line: 434


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

Line: 450


       ,p_datetrack_mode              => p_datetrack_update_mode
       ,p_run_type_id                 => p_run_type_id
       ,p_object_version_number       => p_object_version_number
       ,p_shortname                   => p_shortname
       ,p_srs_flag                    => p_srs_flag
       ,p_run_information_category    => p_run_information_category
       ,p_run_information1	      => p_run_information1
       ,p_run_information2	      => p_run_information2
       ,p_run_information3	      => p_run_information3
       ,p_run_information4	      => p_run_information4
       ,p_run_information5	      => p_run_information5
       ,p_run_information6	      => p_run_information6
       ,p_run_information7	      => p_run_information7
       ,p_run_information8	      => p_run_information8
       ,p_run_information9	      => p_run_information9
       ,p_run_information10	      => p_run_information10
       ,p_run_information11	      => p_run_information11
       ,p_run_information12	      => p_run_information12
       ,p_run_information13	      => p_run_information13
       ,p_run_information14	      => p_run_information14
       ,p_run_information15	      => p_run_information15
       ,p_run_information16	      => p_run_information16
       ,p_run_information17	      => p_run_information17
       ,p_run_information18	      => p_run_information18
       ,p_run_information19	      => p_run_information19
       ,p_run_information20	      => p_run_information20
       ,p_run_information21	      => p_run_information21
       ,p_run_information22	      => p_run_information22
       ,p_run_information23	      => p_run_information23
       ,p_run_information24	      => p_run_information24
       ,p_run_information25	      => p_run_information25
       ,p_run_information26	      => p_run_information26
       ,p_run_information27	      => p_run_information27
       ,p_run_information28	      => p_run_information28
       ,p_run_information29	      => p_run_information29
       ,p_run_information30	      => p_run_information30
       ,p_effective_start_date        => l_effective_start_date
       ,p_effective_end_date          => l_effective_end_date
       );

Line: 503


    pay_run_type_bk2.update_run_type_a
      (p_effective_date                => l_effective_date
      ,p_datetrack_update_mode         => p_datetrack_update_mode
      ,p_language_code                 => l_language_code
      ,p_run_type_id                   => p_run_type_id
      ,p_object_version_number         => p_object_version_number
      ,p_business_group_id             => p_business_group_id
      ,p_legislation_code              => p_legislation_code
      ,p_shortname                     => p_shortname
      ,p_srs_flag                      => p_srs_flag
      ,p_effective_start_date          => l_effective_start_date
      ,p_effective_end_date            => l_effective_end_date
      ,p_run_information_category      => p_run_information_category
      ,p_run_information1	       => p_run_information1
      ,p_run_information2	       => p_run_information2
      ,p_run_information3	       => p_run_information3
      ,p_run_information4	       => p_run_information4
      ,p_run_information5	       => p_run_information5
      ,p_run_information6	       => p_run_information6
      ,p_run_information7	       => p_run_information7
      ,p_run_information8	       => p_run_information8
      ,p_run_information9	       => p_run_information9
      ,p_run_information10	       => p_run_information10
      ,p_run_information11	       => p_run_information11
      ,p_run_information12	       => p_run_information12
      ,p_run_information13	       => p_run_information13
      ,p_run_information14	       => p_run_information14
      ,p_run_information15	       => p_run_information15
      ,p_run_information16	       => p_run_information16
      ,p_run_information17	       => p_run_information17
      ,p_run_information18	       => p_run_information18
      ,p_run_information19	       => p_run_information19
      ,p_run_information20	       => p_run_information20
      ,p_run_information21	       => p_run_information21
      ,p_run_information22	       => p_run_information22
      ,p_run_information23	       => p_run_information23
      ,p_run_information24	       => p_run_information24
      ,p_run_information25	       => p_run_information25
      ,p_run_information26	       => p_run_information26
      ,p_run_information27	       => p_run_information27
      ,p_run_information28	       => p_run_information28
      ,p_run_information29	       => p_run_information29
      ,p_run_information30	       => p_run_information30
      );

Line: 550


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

Line: 575


    rollback to update_run_type;

Line: 589


    rollback to update_run_type;

Line: 592


end update_run_type;

Line: 596


procedure delete_run_type
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_datetrack_delete_mode         in     varchar2
  ,p_run_type_id                   in     number
  ,p_object_version_number         in out nocopy number
  ,p_business_group_id             in     number   default hr_api.g_number
  ,p_legislation_code              in     varchar2 default hr_api.g_varchar2
  ,p_effective_start_date             out nocopy date
  ,p_effective_end_date               out nocopy date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc               varchar2(72) := g_package||'delete_run_type';

Line: 626


  savepoint delete_run_type;

Line: 636


    pay_run_type_bk3.delete_run_type_b
      (p_effective_date            => l_effective_date
      ,p_datetrack_delete_mode     => p_datetrack_delete_mode
      ,p_run_type_id               => p_run_type_id
      ,p_object_version_number     => p_object_version_number
      ,p_business_group_id         => p_business_group_id
      ,p_legislation_code          => p_legislation_code
      );

Line: 647


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

Line: 660


  if p_datetrack_delete_mode = hr_api.g_zap then
  --
    pay_prt_shd.lck(p_effective_date        => l_effective_date
                   ,p_datetrack_mode        => p_datetrack_delete_mode
                   ,p_run_type_id           => p_run_type_id
                   ,p_object_version_number => p_object_version_number
                   ,p_validation_start_date => l_validation_start_date
                   ,p_validation_end_date   => l_validation_end_date
                   );

Line: 680


      ,p_datetrack_mode               => p_datetrack_delete_mode
      ,p_run_type_id                  => p_run_type_id
      ,p_object_version_number        => p_object_version_number
      ,p_effective_start_date         => l_effective_start_date
      ,p_effective_end_date           => l_effective_end_date
      );

Line: 692


    pay_run_type_bk3.delete_run_type_a
      (p_effective_date            => l_effective_date
      ,p_datetrack_delete_mode     => p_datetrack_delete_mode
      ,p_run_type_id               => p_run_type_id
      ,p_object_version_number     => p_object_version_number
      ,p_business_group_id         => p_business_group_id
      ,p_legislation_code          => p_legislation_code
      ,p_effective_start_date      => l_effective_start_date
      ,p_effective_end_date        => l_effective_end_date
      );

Line: 725


    ROLLBACK TO delete_run_type;

Line: 739


    ROLLBACK TO delete_run_type;

Line: 743


end delete_run_type;