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

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

Line: 236


procedure update_learning_path_member
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_learning_path_member_id       in     number
  ,p_object_version_number         in out nocopy number
  ,p_activity_version_id           in     number   default hr_api.g_number
  ,p_course_sequence               in     number   default hr_api.g_number
  ,p_duration                      in     number   default hr_api.g_number
  ,p_duration_units                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_notify_days_before_target     in     number default hr_api.g_number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Update Learning Path member';

Line: 280


  savepoint update_learning_path_member;

Line: 291


    ota_lp_member_bk2.update_learning_path_member_b
  (p_effective_date                 => l_effective_date
  ,p_learning_path_member_id        => p_learning_path_member_id
  ,p_object_version_number          => l_object_version_number
  ,p_activity_version_id            => p_activity_version_id
  ,p_course_sequence                => p_course_sequence
  ,p_duration                       => p_duration
  ,p_duration_units                 => p_duration_units
  ,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_notify_days_before_target      => p_notify_days_before_target
  );

Line: 325


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

Line: 370


  ota_lp_member_bk2.update_learning_path_member_a
  (p_effective_date                 => l_effective_date
  ,p_learning_path_member_id        => p_learning_path_member_id
  ,p_object_version_number          => l_object_version_number
  ,p_activity_version_id            => p_activity_version_id
  ,p_course_sequence                => p_course_sequence
  ,p_duration                       => p_duration
  ,p_duration_units                 => p_duration_units
  ,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_notify_days_before_target      => p_notify_days_before_target
  );

Line: 404


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

Line: 426


    rollback to update_learning_path_member;

Line: 438


    rollback to update_learning_path_member;

Line: 442


end update_learning_path_member;

Line: 453


   SELECT lpm.course_sequence, lpm.learning_path_id
   FROM ota_learning_path_members lpm
   WHERE lpm.learning_path_member_id = p_learning_path_member_id;

Line: 458


   SELECT lpm.learning_path_member_id, lpm.object_version_number, lpm.course_sequence
   FROM ota_learning_path_members lpm
   WHERE lpm.learning_path_id = p_learning_path_id
    AND lpm.course_sequence > p_course_sequence
   ORDER BY course_sequence;

Line: 479


     OTA_LP_MEMBER_API.update_learning_path_member(
                p_validate                => p_validate
               ,p_learning_path_member_id => l_lpm_rec.learning_path_member_id
               ,p_object_version_number   => l_lpm_rec.object_version_number
               ,p_effective_date          => trunc(sysdate)
               ,p_course_sequence         => l_sequence);

Line: 494


procedure delete_learning_path_member
  (p_validate                      in     boolean  default false
  ,p_learning_path_member_id       in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Delete Learning Path Member';

Line: 509


  savepoint delete_learning_path_member;

Line: 514


    ota_lp_member_bk3.delete_learning_path_member_b
    (p_learning_path_member_id     => p_learning_path_member_id
    ,p_object_version_number       => p_object_version_number
    );

Line: 521


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

Line: 542


  ota_lp_member_bk3.delete_learning_path_member_a
  (p_learning_path_member_id     => p_learning_path_member_id
  ,p_object_version_number       => p_object_version_number
  );

Line: 549


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

Line: 570


    rollback to delete_learning_path_member;

Line: 581


    rollback to delete_learning_path_member;

Line: 584


end delete_learning_path_member;