APPS.OTA_LRNG_PATH_MEMBER_UTIL dependencies on OTA_LRNG_PATH_UTIL

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

599:
600: BEGIN
601: FOR rec1 in csr_lpe_with_lme LOOP
602: l_path_status_code :=rec1.path_status_code;
603: l_complete_ok := ota_lrng_path_util.chk_complete_path_ok(rec1.lp_enrollment_id);
604: IF l_complete_ok = 'S'
605: AND rec1.path_status_code = 'ACTIVE'
606: THEN
607: -- The Plan can be completed

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

662:
663: BEGIN
664: FOR rec1 in csr_lpe_with_lme LOOP
665: l_path_status_code :=rec1.path_status_code;
666: l_complete_ok := ota_lrng_path_util.chk_complete_path_ok(rec1.lp_enrollment_id); --Bug#7028384
667: -- IF p_no_of_completed_courses = rec1.no_of_mandatory_courses AND
668: IF rec1.path_status_code = 'ACTIVE' AND l_complete_ok = 'S'
669: THEN
670: -- The Plan can be completed

Line 858: l_learning_path_id := ota_lrng_path_util.get_talent_mgmt_lp

854: ,p_object_version_number => l_lp_ovn
855: ,p_return_status => l_lp_rtn_status
856: );
857:
858: l_learning_path_id := ota_lrng_path_util.get_talent_mgmt_lp
859: (p_person_id => p_person_id
860: ,p_source_function_code => p_source_function_code
861: ,p_source_id => p_source_id
862: ,p_assignment_id => p_assignment_id

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

1091: AND lpm.learning_path_id = l_learning_path_id
1092: AND lme.member_status_code <> 'CANCELLED';
1093:
1094: CURSOR csr_get_lpe_dtls(lp_id NUMBER, lpe_id NUMBER) IS
1095: SELECT ota_lrng_path_util.get_no_of_mandatory_courses(lp_id,'TALENT_MGMT') mandatory_courses,
1096: ota_lrng_path_util.get_no_of_completed_courses(lpe_id,'TALENT_MGMT') completed_courses
1097: FROM dual;
1098:
1099:

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

1092: AND lme.member_status_code <> 'CANCELLED';
1093:
1094: CURSOR csr_get_lpe_dtls(lp_id NUMBER, lpe_id NUMBER) IS
1095: SELECT ota_lrng_path_util.get_no_of_mandatory_courses(lp_id,'TALENT_MGMT') mandatory_courses,
1096: ota_lrng_path_util.get_no_of_completed_courses(lpe_id,'TALENT_MGMT') completed_courses
1097: FROM dual;
1098:
1099:
1100: BEGIN

Line 1522: if(ota_lrng_path_util.chk_complete_path_ok(p_lp_enrollment_id) = 'S') then

1518:
1519: l_completion_date date := null;
1520:
1521: BEGIN
1522: if(ota_lrng_path_util.chk_complete_path_ok(p_lp_enrollment_id) = 'S') then
1523: OPEN get_completion_date;
1524: FETCH get_completion_date into l_completion_date;
1525: CLOSE get_completion_date;
1526: end if;