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

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

Line: 12


procedure Insert_Validation_Period
  (p_effective_date               in     date
  ,p_validation_id                  in     number
  ,p_start_date                     in     date     default null
  ,p_end_date                       in     date     default null
  ,p_previous_employer_id           in     number   default null
  ,p_assignment_category	    in     varchar2 default null
  ,p_normal_hours                   in     number   default null
  ,p_frequency                      in     varchar2 default null
  ,p_period_years                   in     number   default null
  ,p_period_months                  in     number   default null
  ,p_period_days                    in     number   default null
  ,p_comments                       in     varchar2 default null
  ,p_validation_status              in     varchar2 default null
  ,p_validation_period_id              out nocopy number
  ,p_object_version_number             out nocopy number) is
  --
  -- Declare cursors and local variables
  --

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

Line: 43


  savepoint Insert_Validation_Period;

Line: 52


   PQH_FR_VALIDATION_PERIODS_BK1.Insert_Validation_Period_b
   (p_effective_date               => l_effective_date
  ,p_validation_id                 => p_validation_id
  ,p_start_date                    => p_start_date
  ,p_end_date                      => p_end_date
  ,p_previous_employer_id          => p_previous_employer_id
  ,p_assignment_category	   => p_assignment_category
  ,p_normal_hours                  => p_normal_hours
  ,p_frequency                     => p_frequency
  ,p_period_years                  => p_period_years
  ,p_period_months                 => p_period_months
  ,p_period_days                   => p_period_days
  ,p_comments                      => p_comments
  ,p_validation_status             => p_validation_status
   );

Line: 72


        (p_module_name => 'PQH_FR_VALIDATION_PERIODS_API.Insert_Validation_Period'
        ,p_hook_type   => 'BP'
        );

Line: 103


     PQH_FR_VALIDATION_PERIODS_BK1.Insert_Validation_Period_a
     (p_effective_date               => l_effective_date
  ,p_validation_id                 => p_validation_id
  ,p_start_date                    => p_start_date
  ,p_end_date                      => p_end_date
  ,p_previous_employer_id          => p_previous_employer_id
  ,p_assignment_category	   => p_assignment_category
  ,p_normal_hours                  => p_normal_hours
  ,p_frequency                     => p_frequency
  ,p_period_years                  => p_period_years
  ,p_period_months                 => p_period_months
  ,p_period_days                   => p_period_days
  ,p_comments                      => p_comments
  ,p_validation_status             => p_validation_status);

Line: 121


        (p_module_name => 'PQH_FR_VALIDATION_PERIODS_API.Insert_Validation_Period'
        ,p_hook_type   => 'AP'
        );

Line: 149


    rollback to Insert_Validation_Period;

Line: 163


    rollback to Insert_Validation_Period;

Line: 166


end Insert_Validation_Period;

Line: 173


procedure Update_Validation_Period
  (p_effective_date               in     date
  ,p_validation_period_id         in     number
  ,p_object_version_number        in out nocopy number
  ,p_validation_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_previous_employer_id         in     number    default hr_api.g_number
  ,p_assignment_category	  in	 varchar2  default hr_api.g_varchar2
  ,p_normal_hours                 in     number    default hr_api.g_number
  ,p_frequency                    in     varchar2  default hr_api.g_varchar2
  ,p_period_years                 in     number    default hr_api.g_number
  ,p_period_months                in     number    default hr_api.g_number
  ,p_period_days                  in     number    default hr_api.g_number
  ,p_comments                     in     varchar2  default hr_api.g_varchar2
  ,p_validation_status            in     varchar2  default hr_api.g_varchar2) Is

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

Line: 199


  savepoint Update_Validation_Period;

Line: 209


   PQH_FR_VALIDATION_PERIODS_BK2.Update_Validation_Period_b
  (p_effective_date               => l_effective_date
  ,p_validation_period_id          => p_validation_period_id
  ,p_object_version_number         => p_object_version_number
  ,p_validation_id                 => p_validation_id
  ,p_start_date                    => p_start_date
  ,p_end_date                      => p_end_date
  ,p_previous_employer_id          => p_previous_employer_id
  ,p_assignment_category	   => p_assignment_category
  ,p_normal_hours                  => p_normal_hours
  ,p_frequency                     => p_frequency
  ,p_period_years                  => p_period_years
  ,p_period_months                 => p_period_months
  ,p_period_days                   => p_period_days
  ,p_comments                      => p_comments
  ,p_validation_status             => p_validation_status
  );

Line: 230


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

Line: 258


   PQH_FR_VALIDATION_PERIODS_BK2.Update_Validation_Period_a
  (p_effective_date               => l_effective_date
  ,p_validation_period_id          => p_validation_period_id
  ,p_object_version_number         => l_object_version_number
  ,p_validation_id                 => p_validation_id
  ,p_start_date                    => p_start_date
  ,p_end_date                      => p_end_date
  ,p_previous_employer_id          => p_previous_employer_id
  ,p_assignment_category	   => p_assignment_category
  ,p_normal_hours                  => p_normal_hours
  ,p_frequency                     => p_frequency
  ,p_period_years                  => p_period_years
  ,p_period_months                 => p_period_months
  ,p_period_days                   => p_period_days
  ,p_comments                      => p_comments
  ,p_validation_status             => p_validation_status);

Line: 278


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

Line: 302


    rollback to Update_Validation_Period;

Line: 315


    rollback to Update_Validation_Period;

Line: 318


end Update_Validation_Period;

Line: 324


procedure delete_Validation_period
  (p_validation_period_id                        in     number
  ,p_object_version_number                in     number
  ) Is   --

  -- Declare cursors and local variables
  --
  l_proc           varchar2(72) := g_package||'delete_Validation_period';

Line: 338


  savepoint delete_Validation_period;

Line: 343


  PQH_FR_VALIDATION_PERIODS_BK3.Delete_Validation_Period_b
  (p_validation_period_id            => p_validation_period_id
  ,p_object_version_number   => p_object_version_number
  );

Line: 350


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

Line: 366


   PQH_FR_VALIDATION_PERIODS_BK3.Delete_Validation_Period_a
  (
  p_validation_period_id            => p_validation_period_id
  ,p_object_version_number   => p_object_version_number
  );

Line: 375


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

Line: 394


    rollback to delete_Validation_period;

Line: 405


    rollback to delete_Validation_period;

Line: 408


end delete_Validation_period;