APPS.OTA_LP_ENROLLMENT_API dependencies on OTA_LRNG_PATH_UTIL

Line 289: and ('Y' = ota_lrng_path_util.is_path_successful(p_lp_enrollment_id => p_lp_enrollment_id))

285: FETCH get_info_for_comp INTO g_dummy;
286: IF get_info_for_comp%FOUND THEN
287: --Modified for Bug#3864084
288: IF p_path_status_code = 'COMPLETED' AND p_person_id IS NOT NULL
289: and ('Y' = ota_lrng_path_util.is_path_successful(p_lp_enrollment_id => p_lp_enrollment_id))
290: THEN
291: ota_competence_ss.create_wf_process(p_process => 'OTA_COMPETENCE_UPDATE_JSP_PRC',
292: p_itemtype => 'HRSSA',
293: p_person_id => p_person_id,

Line 650: and ('Y' = ota_lrng_path_util.is_path_successful(p_lp_enrollment_id => p_lp_enrollment_id))

646: -- Modified for Bug#3864084
647: FETCH get_info_for_comp INTO l_learning_path_id, l_person_id;
648: IF get_info_for_comp%FOUND THEN
649: IF p_path_status_code = 'COMPLETED' AND l_person_id IS NOT NULL
650: and ('Y' = ota_lrng_path_util.is_path_successful(p_lp_enrollment_id => p_lp_enrollment_id))
651: --Added for bug#5054787
652: AND l_path_status_code <> 'COMPLETED'
653: THEN
654: ota_competence_ss.create_wf_process(p_process => 'OTA_COMPETENCE_UPDATE_JSP_PRC',

Line 913: l_total_number_of_courses := ota_lrng_path_util.get_no_of_mandatory_courses(p_learning_path_id => p_learning_path_id

909: l_attribute30 VARCHAR2(150) := p_attribute30 ;
910:
911: BEGIN
912:
913: l_total_number_of_courses := ota_lrng_path_util.get_no_of_mandatory_courses(p_learning_path_id => p_learning_path_id
914: ,p_path_source_code => 'CATALOG');
915: OPEN csr_get_lp_details;
916: FETCH csr_get_lp_details INTO l_lp_rec;
917: CLOSE csr_get_lp_details;

Line 1117: l_no_of_completed_courses := ota_lrng_path_util.get_no_of_completed_courses(

1113: OPEN csr_get_lpe_details;
1114: FETCH csr_get_lpe_details INTO l_lpe_rec;
1115: CLOSE csr_get_lpe_details;
1116:
1117: l_no_of_completed_courses := ota_lrng_path_util.get_no_of_completed_courses(
1118: p_lp_enrollment_id => p_lp_enrollment_id,
1119: p_path_source_code => 'CATALOG');
1120: p_path_status_code := l_lpe_rec.path_status_code;
1121: l_completion_date := l_lpe_rec.completion_date;

Line 1136: l_completion_status := ota_lrng_path_util.chk_complete_path_ok(p_lp_enrollment_id => p_lp_enrollment_id);

1132: ,p_no_of_completed_courses => l_no_of_completed_courses
1133: ,p_path_status_code => p_path_status_code
1134: ,p_completion_date => l_completion_date);
1135:
1136: l_completion_status := ota_lrng_path_util.chk_complete_path_ok(p_lp_enrollment_id => p_lp_enrollment_id);
1137:
1138: IF l_completion_status = 'S' THEN
1139: p_path_status_code := 'COMPLETED';
1140: --l_completion_date := trunc(sysdate);