APPS.HR_STD_HOL_ABS_API SQL Statements

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

Line: 223

procedure update_std_hol_abs
 (p_std_holiday_absences_id      in number,
  p_date_not_taken               in date             default hr_api.g_date,
  p_standard_holiday_id          in number           default hr_api.g_number,
  p_actual_date_taken            in date             default hr_api.g_date,
  p_reason                       in varchar2         default hr_api.g_varchar2,
  p_expired                      in varchar2         default hr_api.g_varchar2,
  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_object_version_number        in out nocopy number,
  p_validate                     in boolean          default false,
  p_effective_date               in date
 )

is
  --
  -- Declare cursors and local variables
  --
  l_object_version_number per_std_holiday_absences.object_version_number%TYPE;

Line: 263

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

Line: 270

  savepoint update_std_hol_abs;

Line: 280

  hr_std_hol_abs_bk2.update_std_hol_abs_b
  (p_std_holiday_absences_id    =>  p_std_holiday_absences_id
  ,p_date_not_taken             =>  p_date_not_taken
  ,p_standard_holiday_id        =>  p_standard_holiday_id
  ,p_actual_date_taken          =>  p_actual_date_taken
  ,p_reason                     =>  p_reason
  ,p_expired                    =>  p_expired
  ,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_object_version_number      =>  p_object_version_number
  ,p_effective_date             =>  p_effective_date
  );

Line: 314

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

Line: 358

 hr_std_hol_abs_bk2.update_std_hol_abs_a
  (p_std_holiday_absences_id    =>  p_std_holiday_absences_id
  ,p_date_not_taken             =>  p_date_not_taken
  ,p_standard_holiday_id        =>  p_standard_holiday_id
  ,p_actual_date_taken          =>  p_actual_date_taken
  ,p_reason                     =>  p_reason
  ,p_expired                    =>  p_expired
  ,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_object_version_number      =>  l_object_version_number
  ,p_effective_date             =>  p_effective_date
   );

Line: 392

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

Line: 414

    ROLLBACK TO update_std_hol_abs;

Line: 429

  ROLLBACK TO update_std_hol_abs;

Line: 433

end update_std_hol_abs;

Line: 438

procedure delete_std_hol_abs
  (p_validate                       in     boolean  default false
  ,p_std_holiday_absences_id        in     number
  ,p_object_version_number          in     number
  ) is
  --
  l_proc                varchar2(72) := g_package||'delete_std_hol_abs';

Line: 451

  savepoint delete_std_hol_abs;

Line: 461

hr_std_hol_abs_bk3.delete_std_hol_abs_b
  (p_std_holiday_absences_id    => p_std_holiday_absences_id
  ,p_object_version_number      => p_object_version_number
   );

Line: 468

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

Line: 483

hr_std_hol_abs_bk3.delete_std_hol_abs_a
  (p_std_holiday_absences_id    => p_std_holiday_absences_id
  ,p_object_version_number      => p_object_version_number
   );

Line: 490

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

Line: 511

    ROLLBACK TO delete_std_hol_abs;

Line: 519

  ROLLBACK TO delete_std_hol_abs;

Line: 523

end delete_std_hol_abs;