APPS.OTA_LRNG_PATH_MEMBER_UTIL dependencies on OTA_LRNG_PATH_UTIL

Line 582: l_complete_ok := ota_lrng_path_util.chk_complete_path_ok(rec1.lp_enrollment_id);

578:
579: BEGIN
580: FOR rec1 in csr_lpe_with_lme LOOP
581: l_path_status_code :=rec1.path_status_code;
582: l_complete_ok := ota_lrng_path_util.chk_complete_path_ok(rec1.lp_enrollment_id);
583: IF l_complete_ok = 'S'
584: AND rec1.path_status_code = 'ACTIVE'
585: THEN
586: -- The Plan can be completed

Line 645: l_complete_ok := ota_lrng_path_util.chk_complete_path_ok(rec1.lp_enrollment_id); --Bug#7028384

641:
642: BEGIN
643: FOR rec1 in csr_lpe_with_lme LOOP
644: l_path_status_code :=rec1.path_status_code;
645: l_complete_ok := ota_lrng_path_util.chk_complete_path_ok(rec1.lp_enrollment_id); --Bug#7028384
646: -- IF p_no_of_completed_courses = rec1.no_of_mandatory_courses AND
647: IF rec1.path_status_code = 'ACTIVE' AND l_complete_ok = 'S'
648: THEN
649: -- The Plan can be completed

Line 836: l_learning_path_id := ota_lrng_path_util.get_talent_mgmt_lp

832: ,p_object_version_number => l_lp_ovn
833: ,p_return_status => l_lp_rtn_status
834: );
835:
836: l_learning_path_id := ota_lrng_path_util.get_talent_mgmt_lp
837: (p_person_id => p_person_id
838: ,p_source_function_code => p_source_function_code
839: ,p_source_id => p_source_id
840: ,p_assignment_id => p_assignment_id

Line 1073: SELECT ota_lrng_path_util.get_no_of_mandatory_courses(lp_id,'TALENT_MGMT') mandatory_courses,

1069: AND lpm.learning_path_id = l_learning_path_id
1070: AND lme.member_status_code <> 'CANCELLED';
1071:
1072: CURSOR csr_get_lpe_dtls(lp_id NUMBER, lpe_id NUMBER) IS
1073: SELECT ota_lrng_path_util.get_no_of_mandatory_courses(lp_id,'TALENT_MGMT') mandatory_courses,
1074: ota_lrng_path_util.get_no_of_completed_courses(lpe_id,'TALENT_MGMT') completed_courses
1075: FROM dual;
1076:
1077:

Line 1074: ota_lrng_path_util.get_no_of_completed_courses(lpe_id,'TALENT_MGMT') completed_courses

1070: AND lme.member_status_code <> 'CANCELLED';
1071:
1072: CURSOR csr_get_lpe_dtls(lp_id NUMBER, lpe_id NUMBER) IS
1073: SELECT ota_lrng_path_util.get_no_of_mandatory_courses(lp_id,'TALENT_MGMT') mandatory_courses,
1074: ota_lrng_path_util.get_no_of_completed_courses(lpe_id,'TALENT_MGMT') completed_courses
1075: FROM dual;
1076:
1077:
1078: BEGIN