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_LRNG_PATH_UTIL dependencies on OTA_LP_SECTIONS

Line 45: FROM ota_lp_sections lps, ota_lp_enrollments lpe

41:
42: -- bug 7028384
43: CURSOR get_lp_section_details IS
44: SELECT lps.completion_type_code, lps.learning_path_section_id, lps.no_of_mandatory_courses
45: FROM ota_lp_sections lps, ota_lp_enrollments lpe
46: WHERE lpe.lp_enrollment_id = p_lp_enrollment_id AND
47: lpe.learning_path_id = lps.learning_path_id;
48:
49: CURSOR get_lp_member_status(p_lp_section_id ota_lp_sections.learning_path_section_id%TYPE) IS

Line 49: CURSOR get_lp_member_status(p_lp_section_id ota_lp_sections.learning_path_section_id%TYPE) IS

45: FROM ota_lp_sections lps, ota_lp_enrollments lpe
46: WHERE lpe.lp_enrollment_id = p_lp_enrollment_id AND
47: lpe.learning_path_id = lps.learning_path_id;
48:
49: CURSOR get_lp_member_status(p_lp_section_id ota_lp_sections.learning_path_section_id%TYPE) IS
50: SELECT member_status_code FROM ota_lp_member_enrollments
51: WHERE learning_path_section_id = p_lp_section_id AND
52: lp_enrollment_id = p_lp_enrollment_id;
53: -- bug 7028384

Line 255: FROM ota_lp_sections

251: RETURN number IS
252:
253: CURSOR csr_s_lpm IS
254: SELECT sum(no_of_mandatory_courses)
255: FROM ota_lp_sections
256: WHERE learning_path_id = p_learning_path_id
257: AND completion_type_code = 'S';
258:
259: CURSOR csr_m_lpm IS

Line 261: FROM ota_lp_sections lpc,

257: AND completion_type_code = 'S';
258:
259: CURSOR csr_m_lpm IS
260: SELECT count(lpm.learning_path_member_id)
261: FROM ota_lp_sections lpc,
262: ota_learning_path_members lpm
263: WHERE lpc.learning_path_id = p_learning_path_id
264: and lpm.learning_path_section_id = lpc.learning_path_section_id
265: AND completion_type_code = 'M';

Line 338: ota_lp_sections lpc

334: CURSOR csr_sections IS
335: SELECT lpc.no_of_mandatory_courses,
336: lpc.learning_path_section_id
337: FROM ota_lp_enrollments lme,
338: ota_lp_sections lpc
339: WHERE lpc.learning_path_id = lme.learning_path_id
340: AND lpc.completion_type_code = 'S'
341: AND lme.lp_enrollment_id = p_lp_enrollment_id;
342:

Line 353: ota_lp_sections lpc

349:
350: CURSOR csr_m_lpm IS
351: SELECT count(lp_member_enrollment_id)
352: FROM ota_lp_member_enrollments lme,
353: ota_lp_sections lpc
354: WHERE lpc.learning_path_section_id = lme.learning_path_section_id
355: AND lpc.completion_type_code = 'M'
356: AND lme.member_status_code = 'COMPLETED'
357: AND lme.lp_enrollment_id = p_lp_enrollment_id;

Line 359: l_no_of_mandatory_courses ota_lp_sections.no_of_mandatory_courses%TYPE;

355: AND lpc.completion_type_code = 'M'
356: AND lme.member_status_code = 'COMPLETED'
357: AND lme.lp_enrollment_id = p_lp_enrollment_id;
358:
359: l_no_of_mandatory_courses ota_lp_sections.no_of_mandatory_courses%TYPE;
360:
361: l_s_lpm ota_lp_enrollments.no_of_mandatory_courses%TYPE;
362: l_m_lpm ota_lp_enrollments.no_of_mandatory_courses%TYPE;
363: l_completed_courses ota_lp_enrollments.no_of_mandatory_courses%TYPE := 0;

Line 677: FUNCTION get_no_of_mand_compl_courses(p_learning_path_section_id IN ota_lp_sections.learning_path_section_id%TYPE,

673: --
674: -- {End Of Comments}
675: -- ----------------------------------------------------------------------------
676:
677: FUNCTION get_no_of_mand_compl_courses(p_learning_path_section_id IN ota_lp_sections.learning_path_section_id%TYPE,
678: p_person_id IN ota_learning_paths.person_id%TYPE,
679: p_contact_id IN ota_learning_paths.contact_id%TYPE)
680: RETURN number
681: IS

Line 686: FROM ota_lp_sections

682: CURSOR csr_lps IS
683: SELECT learning_path_id,
684: no_of_mandatory_courses,
685: completion_type_code
686: FROM ota_lp_sections
687: WHERE learning_path_section_id = p_learning_path_section_id;
688:
689: CURSOR csr_m_lpm IS
690: SELECT count(learning_path_member_id)

Line 692: ota_lp_sections lpc

688:
689: CURSOR csr_m_lpm IS
690: SELECT count(learning_path_member_id)
691: FROM ota_learning_path_members lpm,
692: ota_lp_sections lpc
693: WHERE lpc.learning_path_section_id = p_learning_path_section_id
694: AND lpm.learning_path_section_id = lpc.learning_path_section_id
695: AND lpc.completion_type_code = 'M';
696:

Line 709: l_learning_path_id ota_lp_sections.learning_path_id%TYPE;

705: and lpe.PATH_STATUS_CODE in ('ACTIVE', 'COMPLETED')
706: and lme.member_status_code like 'COMPLETED'
707: and lme.LP_ENROLLMENT_ID = lpe.LP_ENROLLMENT_ID;
708:
709: l_learning_path_id ota_lp_sections.learning_path_id%TYPE;
710: l_no_of_mandatory_courses ota_lp_sections.no_of_mandatory_courses%TYPE;
711: l_completion_type_code ota_lp_sections.completion_type_code%TYPE;
712: l_mand_crse_compl_count NUMBER:= 0;
713: l_mand_crse_count NUMBER:= 0;

Line 710: l_no_of_mandatory_courses ota_lp_sections.no_of_mandatory_courses%TYPE;

706: and lme.member_status_code like 'COMPLETED'
707: and lme.LP_ENROLLMENT_ID = lpe.LP_ENROLLMENT_ID;
708:
709: l_learning_path_id ota_lp_sections.learning_path_id%TYPE;
710: l_no_of_mandatory_courses ota_lp_sections.no_of_mandatory_courses%TYPE;
711: l_completion_type_code ota_lp_sections.completion_type_code%TYPE;
712: l_mand_crse_compl_count NUMBER:= 0;
713: l_mand_crse_count NUMBER:= 0;
714:

Line 711: l_completion_type_code ota_lp_sections.completion_type_code%TYPE;

707: and lme.LP_ENROLLMENT_ID = lpe.LP_ENROLLMENT_ID;
708:
709: l_learning_path_id ota_lp_sections.learning_path_id%TYPE;
710: l_no_of_mandatory_courses ota_lp_sections.no_of_mandatory_courses%TYPE;
711: l_completion_type_code ota_lp_sections.completion_type_code%TYPE;
712: l_mand_crse_compl_count NUMBER:= 0;
713: l_mand_crse_count NUMBER:= 0;
714:
715: BEGIN

Line 771: from ota_lp_sections lpc

767: CURSOR csr_chk_person IS
768: select
769: sum( decode(tdb.successful_attendance_flag, 'Y',1,0)) completed_courses,
770: max(lpc.no_of_mandatory_courses) no_of_courses
771: from ota_lp_sections lpc
772: , ota_learning_path_members lpm
773: , ota_events evt
774: , ota_delegate_bookings tdb
775: , ota_lp_enrollments lpe

Line 794: from ota_lp_sections lpc

790:
791: select
792: sum( decode(tdb.successful_attendance_flag, 'Y',1,0)) completed_courses,
793: sum(1) no_of_courses
794: from ota_lp_sections lpc
795: , ota_learning_path_members lpm
796: , ota_events evt
797: , ota_delegate_bookings tdb
798: , ota_lp_enrollments lpe

Line 816: from ota_lp_sections lpc

812: CURSOR csr_chk_contact IS
813: select
814: sum( decode(tdb.successful_attendance_flag, 'Y',1,0)) completed_courses,
815: max(lpc.no_of_mandatory_courses) no_of_courses
816: from ota_lp_sections lpc
817: , ota_learning_path_members lpm
818: , ota_events evt
819: , ota_delegate_bookings tdb
820: , ota_lp_enrollments lpe

Line 839: from ota_lp_sections lpc

835:
836: select
837: sum( decode(tdb.successful_attendance_flag, 'Y',1,0)) completed_courses,
838: sum(1) no_of_courses
839: from ota_lp_sections lpc
840: , ota_learning_path_members lpm
841: , ota_events evt
842: , ota_delegate_bookings tdb
843: , ota_lp_enrollments lpe

Line 931: from ota_lp_enrollments ole, ota_lp_sections ols

927: RETURN number is
928:
929: cursor get_lp_mand_completed is
930: select sum(OTA_LRNG_PATH_UTIL.get_no_of_mand_compl_courses(ols.learning_path_section_id, ole.person_id, ole.contact_id))
931: from ota_lp_enrollments ole, ota_lp_sections ols
932: where ole.learning_path_id = ols.learning_path_id
933: and ole.lp_enrollment_id = p_lp_enrollment_id;
934:
935: l_mand_courses_completed number := 0;