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

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

Line: 75


  SELECT null
    FROM ota_learning_paths lps
   WHERE lps.learning_path_id = p_learning_path_id
     AND lps.path_source_code = 'CATALOG';

Line: 81


   select path_source_code
   from ota_learning_paths
   where learning_path_id = p_learning_path_id;

Line: 291


              ota_competence_ss.create_wf_process(p_process		=> 'OTA_COMPETENCE_UPDATE_JSP_PRC',
                                                  p_itemtype		=> 'HRSSA',
                                                  p_person_id 		=> p_person_id,
                                                  p_eventid		=> null,
                                                  p_learningpath_ids	=> to_char(p_learning_path_id),
                                                  p_itemkey		=> l_item_key);

Line: 346


procedure update_lp_enrollment
  (
 p_effective_date               in date,
  p_lp_enrollment_id             in number,
  p_object_version_number        in out nocopy number,
  p_person_id                    in number           default hr_api.g_number,
  p_contact_id                   in number           default hr_api.g_number,
  p_path_status_code             in varchar2         default hr_api.g_varchar2,
  p_enrollment_source_code       in varchar2         default hr_api.g_varchar2,
  p_no_of_mandatory_courses      in number           default hr_api.g_number,
  p_no_of_completed_courses      in number           default hr_api.g_number,
  p_completion_target_date       in date             default hr_api.g_date,
  p_completion_date              in date             default hr_api.g_date,
  p_creator_person_id            in number           default hr_api.g_number,
  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_is_history_flag              in varchar2         default hr_api.g_varchar2,
  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: 412


  SELECT lps.learning_path_id, lpe.person_id
    FROM ota_learning_paths lps,
         ota_lp_enrollments lpe
   WHERE lps.learning_path_id = lpe.learning_path_id
     AND lpe.lp_enrollment_id = p_lp_enrollment_id
     AND lps.path_source_code = 'CATALOG';

Line: 421


  SELECT lps.learning_path_id
    FROM ota_learning_paths lps,
         ota_lp_enrollments lpe
   WHERE lps.learning_path_id = lpe.learning_path_id
     AND lpe.lp_enrollment_id = p_lp_enrollment_id
     AND lps.source_function_code = 'SUITABILITY';

Line: 429


   select lps.path_source_code , lpe.path_status_code
   from ota_learning_paths lps, ota_lp_enrollments lpe
   where lps.learning_path_id = lpe.learning_path_id
     AND lpe.lp_enrollment_id = p_lp_enrollment_id;

Line: 442


  savepoint UPDATE_LP_ENROLLMENT;

Line: 446


  ota_lp_enrollment_bk2.update_lp_enrollment_b
  (p_effective_date               => p_effective_date
    ,p_lp_enrollment_id             => p_lp_enrollment_id
    ,p_object_version_number        => l_object_version_number
    ,p_person_id                    => p_person_id
    ,p_contact_id                   => p_contact_id
    ,p_path_status_code             => p_path_status_code
    ,p_enrollment_source_code       => p_enrollment_source_code
    ,p_no_of_mandatory_courses      => p_no_of_mandatory_courses
    ,p_no_of_completed_courses      => p_no_of_completed_courses
    ,p_completion_target_date       => p_completion_target_date
    ,p_completion_date              => p_completion_date
    ,p_creator_person_id            => p_creator_person_id
    ,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_IS_HISTORY_FLAG              => p_IS_HISTORY_FLAG
    ,p_business_group_id            => p_business_group_id
    ,p_validate                     => p_validate
    );

Line: 499


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

Line: 574


  ota_lp_enrollment_bk2.update_lp_enrollment_a
  (p_effective_date               => p_effective_date
    ,p_lp_enrollment_id             => p_lp_enrollment_id
    ,p_object_version_number        => l_object_version_number
    ,p_person_id                    => p_person_id
    ,p_contact_id                   => p_contact_id
    ,p_path_status_code             => p_path_status_code
    ,p_enrollment_source_code       => p_enrollment_source_code
    ,p_no_of_mandatory_courses      => p_no_of_mandatory_courses
    ,p_no_of_completed_courses      => p_no_of_completed_courses
    ,p_completion_target_date       => p_completion_target_date
    ,p_completion_date              => p_completion_date
    ,p_creator_person_id            => p_creator_person_id
    ,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_IS_HISTORY_FLAG              => p_IS_HISTORY_FLAG
    ,p_business_group_id            => p_business_group_id
    ,p_validate                     => p_validate
    );

Line: 627


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

Line: 654


              ota_competence_ss.create_wf_process(p_process		=> 'OTA_COMPETENCE_UPDATE_JSP_PRC',
                                                  p_itemtype		=> 'HRSSA',
                                                  p_person_id 	        => l_person_id,
                                                  p_eventid		=> null,
                                                  p_learningpath_ids	=> to_char(l_learning_path_id),
                                                  p_itemkey		=> l_item_key);

Line: 691


    rollback to UPDATE_LP_ENROLLMENT;

Line: 703


    rollback to UPDATE_LP_ENROLLMENT;

Line: 707


end update_lp_enrollment;

Line: 713


procedure delete_lp_enrollment
  (p_lp_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_ENROLLMENT';

Line: 730


  savepoint DELETE_LP_ENROLLMENT;

Line: 737


  ota_lp_enrollment_bk3.delete_lp_enrollment_b
  (p_lp_enrollment_id             => p_lp_enrollment_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 744


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

Line: 761


  ota_lp_enrollment_bk3.delete_lp_enrollment_a
  (p_lp_enrollment_id             => p_lp_enrollment_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 768


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

Line: 790


    rollback to DELETE_LP_ENROLLMENT;

Line: 801


    rollback to DELETE_LP_ENROLLMENT;

Line: 804


end delete_lp_enrollment;

Line: 854


select duration
from ota_learning_paths
where learning_path_id = p_learning_path_id;

Line: 859


select learning_path_member_id, activity_version_id, duration, learning_path_section_id
from ota_learning_path_members
where learning_path_id = p_learning_path_id;

Line: 864


select path_status_code, no_of_completed_courses, object_version_number, completion_date
FROM ota_lp_enrollments
where lp_enrollment_id = p_lp_enrollment_id;

Line: 1127


     ota_lp_enrollment_api.update_lp_enrollment
                       (p_effective_date               => sysdate
                       ,p_validate => p_validate
                       ,p_lp_enrollment_id             => p_lp_enrollment_id
                       ,p_object_version_number        => l_lpe_rec.object_version_number
		               ,p_no_of_completed_courses      => l_no_of_completed_courses
                       ,p_path_status_code             => p_path_status_code
                       ,p_completion_date              => l_completion_date);

Line: 1147


          ota_lp_enrollment_api.update_lp_enrollment
                       (p_effective_date               => sysdate
                       ,p_validate                     => p_validate
                       ,p_lp_enrollment_id             => p_lp_enrollment_id
                       ,p_object_version_number        => l_lpe_rec.object_version_number
                       ,p_path_status_code             => p_path_status_code
                       ,p_completion_date              => l_completion_date);