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

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

Line: 43


      l_status_code := 'UPDATED';

Line: 424


procedure update_appraisal_period
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_appraisal_period_id           in     number
  ,p_object_version_number         in out nocopy   number
  ,p_start_date                    in     date     default hr_api.g_date
  ,p_end_date                      in     date     default hr_api.g_date
  ,p_task_start_date               in     date     default hr_api.g_date
  ,p_task_end_date                 in     date     default hr_api.g_date
  ,p_initiator_code                in     varchar2 default hr_api.g_varchar2
  ,p_appraisal_system_type         in     varchar2 default hr_api.g_varchar2
  ,p_appraisal_type                in     varchar2 default hr_api.g_varchar2
  ,p_appraisal_assmt_status        in     varchar2 default hr_api.g_varchar2
  ,p_auto_conc_process             in     varchar2 default hr_api.g_varchar2
  ,p_days_before_task_st_dt        in     number   default hr_api.g_number
  ,p_attribute_category            in     varchar2 default hr_api.g_varchar2
  ,p_attribute1                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute2                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute3                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute4                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute5                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute6                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute7                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute8                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute9                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute10                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute11                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute12                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute13                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute14                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute15                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute16                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute17                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute18                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute19                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute20                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute21                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute22                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute23                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute24                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute25                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute26                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute27                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute28                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute29                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute30                   in     varchar2 default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_effective_date         date;

Line: 475


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

Line: 520


  savepoint update_appraisal_period;

Line: 535


    hr_appraisal_period_bk2.update_appraisal_period_b
      (p_effective_date                => l_effective_date
      ,p_appraisal_period_id           => p_appraisal_period_id
      ,p_object_version_number         => l_object_version_number
      ,p_start_date                    => l_start_date
      ,p_end_date                      => l_end_date
      ,p_task_start_date               => l_task_start_date
      ,p_task_end_date                 => l_task_end_date
      ,p_initiator_code                => p_initiator_code
      ,p_appraisal_system_type         => p_appraisal_system_type
      ,p_appraisal_type                => p_appraisal_type
      ,p_appraisal_assmt_status        => p_appraisal_assmt_status
      ,p_auto_conc_process             => p_auto_conc_process
      ,p_days_before_task_st_dt        => p_days_before_task_st_dt
      ,p_attribute_category            => p_attribute_category
      ,p_attribute1                    => p_attribute1
      ,p_attribute2                    => p_attribute2
      ,p_attribute3                    => p_attribute3
      ,p_attribute4                    => p_attribute4
      ,p_attribute5                    => p_attribute5
      ,p_attribute6                    => p_attribute6
      ,p_attribute7                    => p_attribute7
      ,p_attribute8                    => p_attribute8
      ,p_attribute9                    => p_attribute9
      ,p_attribute10                   => p_attribute10
      ,p_attribute11                   => p_attribute11
      ,p_attribute12                   => p_attribute12
      ,p_attribute13                   => p_attribute13
      ,p_attribute14                   => p_attribute14
      ,p_attribute15                   => p_attribute15
      ,p_attribute16                   => p_attribute16
      ,p_attribute17                   => p_attribute17
      ,p_attribute18                   => p_attribute18
      ,p_attribute19                   => p_attribute19
      ,p_attribute20                   => p_attribute20
      ,p_attribute21                   => p_attribute21
      ,p_attribute22                   => p_attribute22
      ,p_attribute23                   => p_attribute23
      ,p_attribute24                   => p_attribute24
      ,p_attribute25                   => p_attribute25
      ,p_attribute26                   => p_attribute26
      ,p_attribute27                   => p_attribute27
      ,p_attribute28                   => p_attribute28
      ,p_attribute29                   => p_attribute29
      ,p_attribute30                   => p_attribute30
      );

Line: 584


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

Line: 645


    hr_appraisal_period_bk2.update_appraisal_period_a
      (p_effective_date                => l_effective_date
      ,p_appraisal_period_id           => p_appraisal_period_id
      ,p_object_version_number         => l_object_version_number
      ,p_start_date                    => l_start_date
      ,p_end_date                      => l_end_date
      ,p_task_start_date               => l_task_start_date
      ,p_task_end_date                 => l_task_end_date
      ,p_initiator_code                => p_initiator_code
      ,p_appraisal_system_type         => p_appraisal_system_type
      ,p_appraisal_type                => p_appraisal_type
      ,p_appraisal_assmt_status        => p_appraisal_assmt_status
      ,p_auto_conc_process             => p_auto_conc_process
      ,p_days_before_task_st_dt        => p_days_before_task_st_dt
      ,p_attribute_category            => p_attribute_category
      ,p_attribute1                    => p_attribute1
      ,p_attribute2                    => p_attribute2
      ,p_attribute3                    => p_attribute3
      ,p_attribute4                    => p_attribute4
      ,p_attribute5                    => p_attribute5
      ,p_attribute6                    => p_attribute6
      ,p_attribute7                    => p_attribute7
      ,p_attribute8                    => p_attribute8
      ,p_attribute9                    => p_attribute9
      ,p_attribute10                   => p_attribute10
      ,p_attribute11                   => p_attribute11
      ,p_attribute12                   => p_attribute12
      ,p_attribute13                   => p_attribute13
      ,p_attribute14                   => p_attribute14
      ,p_attribute15                   => p_attribute15
      ,p_attribute16                   => p_attribute16
      ,p_attribute17                   => p_attribute17
      ,p_attribute18                   => p_attribute18
      ,p_attribute19                   => p_attribute19
      ,p_attribute20                   => p_attribute20
      ,p_attribute21                   => p_attribute21
      ,p_attribute22                   => p_attribute22
      ,p_attribute23                   => p_attribute23
      ,p_attribute24                   => p_attribute24
      ,p_attribute25                   => p_attribute25
      ,p_attribute26                   => p_attribute26
      ,p_attribute27                   => p_attribute27
      ,p_attribute28                   => p_attribute28
      ,p_attribute29                   => p_attribute29
      ,p_attribute30                   => p_attribute30
      );

Line: 694


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

Line: 745


    rollback to update_appraisal_period;

Line: 757


    rollback to update_appraisal_period;

Line: 765


end update_appraisal_period;

Line: 771


procedure delete_appraisal_period
  (p_validate                      in     boolean  default false
  ,p_appraisal_period_id           in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||'delete_appraisal_period';

Line: 807


  savepoint delete_appraisal_period;

Line: 813


    hr_appraisal_period_bk3.delete_appraisal_period_b
      (p_appraisal_period_id           => p_appraisal_period_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 820


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

Line: 839


    hr_appraisal_period_bk3.delete_appraisal_period_a
      (p_appraisal_period_id           => p_appraisal_period_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 846


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

Line: 882


    rollback to delete_appraisal_period;

Line: 888


    rollback to delete_appraisal_period;

Line: 891


end delete_appraisal_period;