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

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

Line: 115


  SELECT noa_family_code
  FROM ghr_pa_requests
  WHERE pa_request_id = c_pa_request_id;

Line: 415


procedure update_pa_request_extra_info
  (p_validate                     in     boolean  default false
  ,p_pa_request_extra_info_id     in     number
  ,p_object_version_number        in out NOCOPY number
  ,p_rei_attribute_category       in     varchar2 default hr_api.g_varchar2
  ,p_rei_attribute1               in     varchar2 default hr_api.g_varchar2
  ,p_rei_attribute2               in     varchar2 default hr_api.g_varchar2
  ,p_rei_attribute3               in     varchar2 default hr_api.g_varchar2
  ,p_rei_attribute4               in     varchar2 default hr_api.g_varchar2
  ,p_rei_attribute5               in     varchar2 default hr_api.g_varchar2
  ,p_rei_attribute6               in     varchar2 default hr_api.g_varchar2
  ,p_rei_attribute7               in     varchar2 default hr_api.g_varchar2
  ,p_rei_attribute8               in     varchar2 default hr_api.g_varchar2
  ,p_rei_attribute9               in     varchar2 default hr_api.g_varchar2
  ,p_rei_attribute10              in     varchar2 default hr_api.g_varchar2
  ,p_rei_attribute11              in     varchar2 default hr_api.g_varchar2
  ,p_rei_attribute12              in     varchar2 default hr_api.g_varchar2
  ,p_rei_attribute13              in     varchar2 default hr_api.g_varchar2
  ,p_rei_attribute14              in     varchar2 default hr_api.g_varchar2
  ,p_rei_attribute15              in     varchar2 default hr_api.g_varchar2
  ,p_rei_attribute16              in     varchar2 default hr_api.g_varchar2
  ,p_rei_attribute17              in     varchar2 default hr_api.g_varchar2
  ,p_rei_attribute18              in     varchar2 default hr_api.g_varchar2
  ,p_rei_attribute19              in     varchar2 default hr_api.g_varchar2
  ,p_rei_attribute20              in     varchar2 default hr_api.g_varchar2
  ,p_rei_information_category     in     varchar2 default hr_api.g_varchar2
  ,p_rei_information1             in     varchar2 default hr_api.g_varchar2
  ,p_rei_information2             in     varchar2 default hr_api.g_varchar2
  ,p_rei_information3             in     varchar2 default hr_api.g_varchar2
  ,p_rei_information4             in     varchar2 default hr_api.g_varchar2
  ,p_rei_information5             in     varchar2 default hr_api.g_varchar2
  ,p_rei_information6             in     varchar2 default hr_api.g_varchar2
  ,p_rei_information7             in     varchar2 default hr_api.g_varchar2
  ,p_rei_information8             in     varchar2 default hr_api.g_varchar2
  ,p_rei_information9             in     varchar2 default hr_api.g_varchar2
  ,p_rei_information10            in     varchar2 default hr_api.g_varchar2
  ,p_rei_information11            in     varchar2 default hr_api.g_varchar2
  ,p_rei_information12            in     varchar2 default hr_api.g_varchar2
  ,p_rei_information13            in     varchar2 default hr_api.g_varchar2
  ,p_rei_information14            in     varchar2 default hr_api.g_varchar2
  ,p_rei_information15            in     varchar2 default hr_api.g_varchar2
  ,p_rei_information16            in     varchar2 default hr_api.g_varchar2
  ,p_rei_information17            in     varchar2 default hr_api.g_varchar2
  ,p_rei_information18            in     varchar2 default hr_api.g_varchar2
  ,p_rei_information19            in     varchar2 default hr_api.g_varchar2
  ,p_rei_information20            in     varchar2 default hr_api.g_varchar2
  ,p_rei_information21            in     varchar2 default hr_api.g_varchar2
  ,p_rei_information22            in     varchar2 default hr_api.g_varchar2
  ,p_rei_information23            in     varchar2 default hr_api.g_varchar2
  ,p_rei_information24            in     varchar2 default hr_api.g_varchar2
  ,p_rei_information25            in     varchar2 default hr_api.g_varchar2
  ,p_rei_information26            in     varchar2 default hr_api.g_varchar2
  ,p_rei_information27            in     varchar2 default hr_api.g_varchar2
  ,p_rei_information28            in     varchar2 default hr_api.g_varchar2
  ,p_rei_information29            in     varchar2 default hr_api.g_varchar2
  ,p_rei_information30            in     varchar2 default hr_api.g_varchar2
  ,p_ben_ei_validate			  in     varchar2 default 'FALSE'
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                 varchar2(72) ;

Line: 481


  SELECT noa_family_code
  FROM ghr_pa_requests
  WHERE pa_request_id = c_pa_request_id;

Line: 489


  SELECT pa_request_id, information_type
  FROM ghr_pa_request_extra_info
  WHERE pa_request_extra_info_id = c_pa_req_extra_info_id;

Line: 494


  l_proc := g_package||'update_pa_request_extra_info';

Line: 498


  savepoint update_pa_request_extra_info;

Line: 504


	ghr_par_extra_info_bk2.update_par_extra_info_b	(
          p_pa_request_extra_info_id     => p_pa_request_extra_info_id
         ,p_rei_attribute_category       => p_rei_attribute_category
         ,p_rei_attribute1               => p_rei_attribute1
         ,p_rei_attribute2               => p_rei_attribute2
         ,p_rei_attribute3               => p_rei_attribute3
         ,p_rei_attribute4               => p_rei_attribute4
         ,p_rei_attribute5               => p_rei_attribute5
         ,p_rei_attribute6               => p_rei_attribute6
         ,p_rei_attribute7               => p_rei_attribute7
         ,p_rei_attribute8               => p_rei_attribute8
         ,p_rei_attribute9               => p_rei_attribute9
         ,p_rei_attribute10              => p_rei_attribute10
         ,p_rei_attribute11              => p_rei_attribute11
         ,p_rei_attribute12              => p_rei_attribute12
         ,p_rei_attribute13              => p_rei_attribute13
         ,p_rei_attribute14              => p_rei_attribute14
         ,p_rei_attribute15              => p_rei_attribute15
         ,p_rei_attribute16              => p_rei_attribute16
         ,p_rei_attribute17              => p_rei_attribute17
         ,p_rei_attribute18              => p_rei_attribute18
         ,p_rei_attribute19              => p_rei_attribute19
         ,p_rei_attribute20              => p_rei_attribute20
         ,p_rei_information_category     => p_rei_information_category
         ,p_rei_information1             => p_rei_information1
         ,p_rei_information2             => p_rei_information2
         ,p_rei_information3             => p_rei_information3
         ,p_rei_information4             => p_rei_information4
         ,p_rei_information5             => p_rei_information5
         ,p_rei_information6             => p_rei_information6
         ,p_rei_information7             => p_rei_information7
         ,p_rei_information8             => p_rei_information8
         ,p_rei_information9             => p_rei_information9
         ,p_rei_information10            => p_rei_information10
         ,p_rei_information11            => p_rei_information11
         ,p_rei_information12            => p_rei_information12
         ,p_rei_information13            => p_rei_information13
         ,p_rei_information14            => p_rei_information14
         ,p_rei_information15            => p_rei_information15
         ,p_rei_information16            => p_rei_information16
         ,p_rei_information17            => p_rei_information17
         ,p_rei_information18            => p_rei_information18
         ,p_rei_information19            => p_rei_information19
         ,p_rei_information20            => p_rei_information20
         ,p_rei_information21            => p_rei_information21
         ,p_rei_information22            => p_rei_information22
         ,p_rei_information23            => p_rei_information23
         ,p_rei_information24            => p_rei_information24
         ,p_rei_information25            => p_rei_information25
         ,p_rei_information26            => p_rei_information26
         ,p_rei_information27            => p_rei_information27
         ,p_rei_information28            => p_rei_information28
         ,p_rei_information29            => p_rei_information29
         ,p_rei_information30            => p_rei_information30
         ,p_object_version_number        => p_object_version_number
	);

Line: 564


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

Line: 694


	ghr_par_extra_info_bk2.update_par_extra_info_a	(
          p_pa_request_extra_info_id     => p_pa_request_extra_info_id
         ,p_rei_attribute_category       => p_rei_attribute_category
         ,p_rei_attribute1               => p_rei_attribute1
         ,p_rei_attribute2               => p_rei_attribute2
         ,p_rei_attribute3               => p_rei_attribute3
         ,p_rei_attribute4               => p_rei_attribute4
         ,p_rei_attribute5               => p_rei_attribute5
         ,p_rei_attribute6               => p_rei_attribute6
         ,p_rei_attribute7               => p_rei_attribute7
         ,p_rei_attribute8               => p_rei_attribute8
         ,p_rei_attribute9               => p_rei_attribute9
         ,p_rei_attribute10              => p_rei_attribute10
         ,p_rei_attribute11              => p_rei_attribute11
         ,p_rei_attribute12              => p_rei_attribute12
         ,p_rei_attribute13              => p_rei_attribute13
         ,p_rei_attribute14              => p_rei_attribute14
         ,p_rei_attribute15              => p_rei_attribute15
         ,p_rei_attribute16              => p_rei_attribute16
         ,p_rei_attribute17              => p_rei_attribute17
         ,p_rei_attribute18              => p_rei_attribute18
         ,p_rei_attribute19              => p_rei_attribute19
         ,p_rei_attribute20              => p_rei_attribute20
         ,p_rei_information_category     => p_rei_information_category
         ,p_rei_information1             => p_rei_information1
         ,p_rei_information2             => p_rei_information2
         ,p_rei_information3             => p_rei_information3
         ,p_rei_information4             => p_rei_information4
         ,p_rei_information5             => p_rei_information5
         ,p_rei_information6             => p_rei_information6
         ,p_rei_information7             => p_rei_information7
         ,p_rei_information8             => p_rei_information8
         ,p_rei_information9             => p_rei_information9
         ,p_rei_information10            => p_rei_information10
         ,p_rei_information11            => p_rei_information11
         ,p_rei_information12            => p_rei_information12
         ,p_rei_information13            => p_rei_information13
         ,p_rei_information14            => p_rei_information14
         ,p_rei_information15            => p_rei_information15
         ,p_rei_information16            => p_rei_information16
         ,p_rei_information17            => p_rei_information17
         ,p_rei_information18            => p_rei_information18
         ,p_rei_information19            => p_rei_information19
         ,p_rei_information20            => p_rei_information20
         ,p_rei_information21            => p_rei_information21
         ,p_rei_information22            => p_rei_information22
         ,p_rei_information23            => p_rei_information23
         ,p_rei_information24            => p_rei_information24
         ,p_rei_information25            => p_rei_information25
         ,p_rei_information26            => p_rei_information26
         ,p_rei_information27            => p_rei_information27
         ,p_rei_information28            => p_rei_information28
         ,p_rei_information29            => p_rei_information29
         ,p_rei_information30            => p_rei_information30
         ,p_object_version_number        => p_object_version_number

		);

Line: 755


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

Line: 775


    ROLLBACK TO update_pa_request_extra_info;

Line: 785


      ROLLBACK TO update_pa_request_extra_info;

Line: 790


end update_pa_request_extra_info;

Line: 797


procedure delete_pa_request_extra_info
  (p_validate                      in     boolean  default false
  ,p_pa_request_extra_info_id      in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72);

Line: 808


  l_proc := g_package||'delete_pa_request_extra_info';

Line: 811


  savepoint delete_pa_request_extra_info;

Line: 817


	ghr_par_extra_info_bk3.delete_par_extra_info_b	(
             p_pa_request_extra_info_id    =>   p_pa_request_extra_info_id
            ,p_object_version_number       =>   p_object_version_number
	);

Line: 824


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

Line: 847


	ghr_par_extra_info_bk3.delete_par_extra_info_a	(
             p_pa_request_extra_info_id    =>   p_pa_request_extra_info_id
            ,p_object_version_number       =>   p_object_version_number
	);

Line: 854


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

Line: 874


    ROLLBACK TO delete_pa_request_extra_info;

Line: 877


    ROLLBACK TO delete_pa_request_extra_info;

Line: 881


end delete_pa_request_extra_info;

Line: 922


SELECT *
FROM ghr_pa_requests
WHERE pa_request_id = c_pa_request_id;

Line: 927


	SELECT rei_information3 payroll_id
	  FROM   ghr_pa_request_extra_info
	  WHERE  pa_request_id       =   c_pa_request_id
	  AND    information_type    =   'GHR_US_PAR_PAYROLL_TYPE';

Line: 933


SELECT min(start_date) start_date
   FROM per_time_periods
   WHERE payroll_id = c_payroll_id
   AND TO_CHAR(start_date,'YYYY') = c_year
   AND TO_CHAR(start_date,'MM') = c_month;