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_API SQL Statements

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

Line: 79


  ,p_COMPETENCY_UPDATE_LEVEL        in     VARCHAR2 default null
  ,p_certification_id               out nocopy number
  ,p_object_version_number          out nocopy number
) is
 --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' create_certification';

Line: 146


  ,p_COMPETENCY_UPDATE_LEVEL        => p_COMPETENCY_UPDATE_LEVEL
);

Line: 196


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

Line: 271


  ,p_COMPETENCY_UPDATE_LEVEL        => p_COMPETENCY_UPDATE_LEVEL
  );

Line: 317


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     boolean   default false
) is
 --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' update_certification';

Line: 379


  savepoint UPDATE_CERTIFICATION;

Line: 384


  ota_certification_bk2.update_certification_b
  (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                     => p_validate
);

Line: 482


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

Line: 505


  ota_certification_bk2.update_certification_a
  (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                     => p_validate
  );

Line: 558


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

Line: 577


    rollback to UPDATE_CERTIFICATION;

Line: 589


    rollback to UPDATE_CERTIFICATION;

Line: 593


end update_certification;

Line: 600


procedure delete_certification
  (
  p_certification_id                   in number,
  p_object_version_number              in number,
  p_validate                           in boolean
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Delete Certification';

Line: 617


  savepoint DELETE_CERTIFICATION;

Line: 624


  ota_certification_bk3.delete_certification_b
  (p_certification_id             => p_certification_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 631


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

Line: 649


  ota_certification_bk3.delete_certification_a
  (p_certification_id             => p_certification_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 656


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

Line: 678


    rollback to DELETE_CERTIFICATION;

Line: 681


end delete_certification;