DBA Data[Home] [Help]

APPS.OTA_TRAINING_PLAN_UPGRADE dependencies on OTA_LP_ENROLLMENT_API

Line 975: -- ota_lp_enrollment_api.create_lp_enrollment(

971:
972: if not is_lp_enr_migrated(p_training_plan_id
973: ,p_source_id, p_source_function, p_assignment_id) then
974: begin
975: -- ota_lp_enrollment_api.create_lp_enrollment(
976: ota_lpe_ins.ins(
977: p_effective_date => trunc(sysdate)
978: ,p_learning_path_id => p_learning_path_id
979: ,p_Completion_target_date => p_Completion_target_date

Line 2366: ota_lp_enrollment_api.update_lp_enrollment

2362: FETCH csr_get_lp_completion_info INTO l_completion_date, l_completed_courses;
2363: IF csr_get_lp_completion_info%FOUND THEN
2364: IF to_char(l_lp_completion_date_old,'DD/MM/RRRR') = '31/12/4712' then
2365: begin
2366: ota_lp_enrollment_api.update_lp_enrollment
2367: (p_effective_date => trunc(sysdate)
2368: ,p_lp_enrollment_id => l_lp_enrollment_id
2369: ,p_path_status_code => 'COMPLETED'
2370: ,p_no_of_completed_courses => nvl(l_completed_courses,0)