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

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

Line: 86


    select ppf.full_name
    from per_all_people_f ppf
    where ppf.person_id = p_person_id
      and p_effective_date between ppf.effective_start_date and ppf.effective_end_date;

Line: 92


        Select learning_path_id
        From ota_training_plans
        Where training_plan_id = p_training_plan_id;

Line: 318


PROCEDURE delete_training_plan_member
  (p_validate                     IN     NUMBER    DEFAULT hr_api.g_false_num
  ,p_training_plan_member_id      IN     number
  ,p_object_version_NUMBER        IN     number
  ,p_return_status                   OUT NOCOPY VARCHAR2
  ) IS
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 331


  l_proc    VARCHAR2(72) := g_package ||'delete_training_plan_member';

Line: 337


  SAVEPOINT delete_trng_plan_member_swi;

Line: 357


  ota_tpm_api.delete_training_plan_member
    (p_validate                     => l_validate
    ,p_training_plan_member_id      => p_training_plan_member_id
    ,p_object_version_NUMBER        => p_object_version_number
    );

Line: 384


    ROLLBACK TO delete_trng_plan_member_swi;

Line: 398


    ROLLBACK TO delete_trng_plan_member_swi;

Line: 408


END delete_training_plan_member;

Line: 412


PROCEDURE update_training_plan_member
  (p_validate                     IN     NUMBER    DEFAULT hr_api.g_false_num
  ,p_effective_date               IN     date
  ,p_training_plan_member_id      IN     number
  ,p_object_version_NUMBER        IN OUT NOCOPY number
  ,p_activity_version_id          IN     NUMBER    DEFAULT hr_api.g_number
  ,p_activity_definition_id       IN     NUMBER    DEFAULT hr_api.g_number
  ,p_member_status_type_id        IN     VARCHAR2  DEFAULT hr_api.g_VARCHAR2
  ,p_target_completion_date       IN     date      DEFAULT hr_api.g_date
  ,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
  ,p_assignment_id                IN     NUMBER    DEFAULT hr_api.g_number
  ,p_source_id                    IN     NUMBER    DEFAULT hr_api.g_number
  ,p_source_function              IN     VARCHAR2  DEFAULT hr_api.g_VARCHAR2
  ,p_cancellation_reason          IN     VARCHAR2  DEFAULT hr_api.g_VARCHAR2
  ,p_earliest_start_date          IN     date      DEFAULT hr_api.g_date
  ,p_creator_person_id             IN    NUMBER
  ,p_return_status                   OUT NOCOPY VARCHAR2
  ) IS
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 468


  l_proc    VARCHAR2(72) := g_package ||'update_training_plan_member';

Line: 475


  SAVEPOINT update_trng_plan_member_swi;

Line: 496


  ota_tpm_api.update_training_plan_member
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_training_plan_member_id      => p_training_plan_member_id
    ,p_object_version_NUMBER        => p_object_version_number
    ,p_activity_version_id          => p_activity_version_id
    ,p_activity_definition_id       => p_activity_definition_id
    ,p_member_status_type_id        => p_member_status_type_id
    ,p_target_completion_date       => p_target_completion_date
    ,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
    ,p_assignment_id                => p_assignment_id
    ,p_source_id                    => p_source_id
    ,p_source_function              => p_source_function
    ,p_cancellation_reason          => p_cancellation_reason
    ,p_earliest_start_date          => p_earliest_start_date
    ,p_creator_person_id           => p_creator_person_id
    );

Line: 565


    ROLLBACK TO update_trng_plan_member_swi;

Line: 580


    ROLLBACK TO update_trng_plan_member_swi;

Line: 591


END update_training_plan_member;