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

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

Line: 57


  ,p_COMPETENCY_UPDATE_LEVEL      in     VARCHAR2 default null
  ,p_certification_id             in     number
  ,p_object_version_number           out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 151


    ,p_COMPETENCY_UPDATE_LEVEL      => p_COMPETENCY_UPDATE_LEVEL
    ,p_certification_id             => l_certification_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 207


PROCEDURE update_certification
  (p_effective_date               in     date
  ,p_certification_id             in     number
  ,p_object_version_number        in out nocopy number
  ,p_name                         in     varchar2  default hr_api.g_varchar2
  ,p_public_flag                  in     varchar2  default hr_api.g_varchar2
  ,p_initial_completion_date      in     date      default hr_api.g_date
  ,p_initial_completion_duration  in     number    default hr_api.g_number
  ,p_initial_compl_duration_units in     varchar2  default hr_api.g_varchar2
  ,p_renewal_duration             in     number    default hr_api.g_number
  ,p_renewal_duration_units       in     varchar2  default hr_api.g_varchar2
  ,p_notify_days_before_expire    in     number    default hr_api.g_number
  ,p_start_date_active            in     date      default hr_api.g_date
  ,p_end_date_active              in     date      default hr_api.g_date
  ,p_description                  in     varchar2  default hr_api.g_varchar2
  ,p_objectives                   in     varchar2  default hr_api.g_varchar2
  ,p_purpose                      in     varchar2  default hr_api.g_varchar2
  ,p_keywords                     in     varchar2  default hr_api.g_varchar2
  ,p_end_date_comments            in     varchar2  default hr_api.g_varchar2
  ,p_initial_period_comments      in     varchar2  default hr_api.g_varchar2
  ,p_renewal_period_comments      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_business_group_id            in     number    default hr_api.g_number
  ,p_VALIDITY_DURATION            in     NUMBER    default hr_api.g_number
  ,p_VALIDITY_DURATION_UNITS      in     VARCHAR2  default hr_api.g_varchar2
  ,p_RENEWABLE_FLAG               in     VARCHAR2  default hr_api.g_varchar2
  ,p_VALIDITY_START_TYPE          in     VARCHAR2  default hr_api.g_varchar2
  ,p_COMPETENCY_UPDATE_LEVEL      in     VARCHAR2  default hr_api.g_varchar2
  ,p_validate                     in     number    default hr_api.g_false_num
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 266


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

Line: 272


  savepoint update_certification_swi;

Line: 301


  ota_certification_api.update_certification
    (p_effective_date               => p_effective_date
    ,p_certification_id             => p_certification_id
    ,p_object_version_number        => p_object_version_number
    ,p_name                         => p_name
    ,p_public_flag                  => p_public_flag
    ,p_initial_completion_date      => p_initial_completion_date
    ,p_initial_completion_duration  => p_initial_completion_duration
    ,p_initial_compl_duration_units => p_initial_compl_duration_units
    ,p_renewal_duration             => p_renewal_duration
    ,p_renewal_duration_units       => p_renewal_duration_units
    ,p_notify_days_before_expire    => p_notify_days_before_expire
    ,p_start_date_active            => p_start_date_active
    ,p_end_date_active              => p_end_date_active
    ,p_description                  => p_description
    ,p_objectives                   => p_objectives
    ,p_purpose                      => p_purpose
    ,p_keywords                     => p_keywords
    ,p_end_date_comments            => p_end_date_comments
    ,p_initial_period_comments      => p_initial_period_comments
    ,p_renewal_period_comments      => p_renewal_period_comments
    ,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_business_group_id            => p_business_group_id
    ,p_VALIDITY_DURATION            => p_VALIDITY_DURATION
    ,p_VALIDITY_DURATION_UNITS      => p_VALIDITY_DURATION_UNITS
    ,p_RENEWABLE_FLAG               => p_RENEWABLE_FLAG
    ,p_VALIDITY_START_TYPE          => p_VALIDITY_START_TYPE
    ,p_COMPETENCY_UPDATE_LEVEL      => p_COMPETENCY_UPDATE_LEVEL
    ,p_validate                     => l_validate
    );

Line: 373


    rollback to update_certification_swi;

Line: 388


    rollback to update_certification_swi;

Line: 399


end update_certification;

Line: 403


PROCEDURE delete_certification
  (p_certification_id             in     number
  ,p_object_version_number        in     number
  ,p_validate                     in     number    default hr_api.g_false_num
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 416


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

Line: 422


  savepoint delete_certification_swi;

Line: 442


  ota_certification_api.delete_certification
    (p_certification_id             => p_certification_id
    ,p_object_version_number        => p_object_version_number
    ,p_validate                     => l_validate
    );

Line: 469


    rollback to delete_certification_swi;

Line: 483


    rollback to delete_certification_swi;

Line: 493


end delete_certification;

Line: 523


  SELECT 1
  FROM ota_cert_enrollments ce
  WHERE ce.certification_id = p_certification_id;

Line: 527


l_update_allowed   varchar2(1);

Line: 534


     l_update_allowed := 'N';

Line: 536


     l_update_allowed := 'Y';

Line: 540


  return l_update_allowed;

Line: 555


   SELECT 1
   FROM   OTA_CERTIFICATIONS_VL cert
   WHERE  rtrim(p_name) = rtrim(cert.name)
      AND cert.business_group_id = l_business_group_id
      AND (p_certification_id IS NULL
            OR ( p_certification_id IS NOT NULL
                 AND p_certification_id <> cert.certification_id)) ;

Line: 564


  SELECT cert.business_group_id
  FROM OTA_CERTIFICATIONS_B cert
  WHERE cert.certification_id = p_certification_id;