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

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

Line: 70


  SELECT activity_version_id
    FROM ota_learning_path_members
   WHERE learning_path_member_id = p_learning_path_member_id;

Line: 288


procedure update_lp_member_enrollment
( p_effective_date               in date,
  p_lp_member_enrollment_id      in number,
  p_object_version_number        in out nocopy number,
  p_lp_enrollment_id             in number           default hr_api.g_number,
  p_learning_path_section_id     in number           default hr_api.g_number,
  p_learning_path_member_id      in number           default hr_api.g_number,
  p_member_status_code                in varchar2         default hr_api.g_varchar2,
  p_completion_target_date       in date             default hr_api.g_date,
  p_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_creator_person_id            in number           default hr_api.g_number,
  p_business_group_id            in number           default hr_api.g_number,
  p_validate                     in boolean          default false
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Update Learning Path';

Line: 345


  SELECT lpm.activity_version_id,
         lpe.lp_enrollment_id
    FROM ota_learning_path_members lpm,
         ota_lp_member_enrollments lme,
         ota_lp_enrollments lpe
   WHERE lme.lp_member_enrollment_id = p_lp_member_enrollment_id
     AND lpe.lp_enrollment_id = lme.lp_enrollment_id
     AND lme.learning_path_member_id = lpm.learning_path_member_id;

Line: 360


  savepoint UPDATE_LP_MEMBER_ENROLLMENT;

Line: 377


  ota_lp_member_enrollment_bk2.update_lp_member_enrollment_b
  (  p_effective_date               => p_effective_date
    ,p_lp_member_enrollment_id      => p_lp_member_enrollment_id
    ,p_object_version_number        => l_object_version_number
    ,p_lp_enrollment_id             => l_lp_enrollment_id
    ,p_learning_path_section_id     => p_learning_path_section_id
    ,p_learning_path_member_id      => p_learning_path_member_id
    ,p_member_status_code                => l_member_status_code
    ,p_completion_target_date       => p_completion_target_date
    ,p_completion_date               => l_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_creator_person_id            => p_creator_person_id
    ,p_business_group_id            => p_business_group_id
    ,p_validate                     => p_validate
    );

Line: 427


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

Line: 483


  ota_lp_member_enrollment_bk2.update_lp_member_enrollment_a
  (  p_effective_date               => p_effective_date
    ,p_lp_member_enrollment_id      => p_lp_member_enrollment_id
    ,p_object_version_number        => l_object_version_number
    ,p_lp_enrollment_id             => l_lp_enrollment_id
    ,p_learning_path_section_id     => p_learning_path_section_id
    ,p_learning_path_member_id      => p_learning_path_member_id
    ,p_member_status_code           => l_member_status_code
    ,p_completion_target_date       => p_completion_target_date
    ,p_completion_date              => l_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_creator_person_id            => p_creator_person_id
    ,p_business_group_id            => p_business_group_id
    ,p_validate                     => p_validate
    );

Line: 533


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

Line: 557


    rollback to UPDATE_LP_MEMBER_ENROLLMENT;

Line: 569


    rollback to UPDATE_LP_MEMBER_ENROLLMENT;

Line: 573


end update_lp_member_enrollment;

Line: 579


procedure delete_lp_member_enrollment
  (p_lp_member_enrollment_id       in     number
  ,p_object_version_number         in     number
  ,p_validate                      in     boolean  default false
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||'DELETE_LP_MEMBER_ENROLLMENT';

Line: 595


  savepoint DELETE_LP_MEMBER_ENROLLMENT;

Line: 602


  ota_lp_member_enrollment_bk3.delete_lp_member_enrollment_b
  (p_lp_member_enrollment_id        => p_lp_member_enrollment_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 609


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

Line: 626


  ota_lp_member_enrollment_bk3.delete_lp_member_enrollment_a
  (p_lp_member_enrollment_id        => p_lp_member_enrollment_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 633


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

Line: 655


    rollback to DELETE_LP_MEMBER_ENROLLMENT;

Line: 666


    rollback to DELETE_LP_MEMBER_ENROLLMENT;

Line: 669


end delete_lp_member_enrollment;