APPS.OTA_LRNG_PATH_UTIL dependencies on OTA_EVENTS

Line 773: , ota_events evt

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
776: , ota_booking_status_types bst
777: where lpc.learning_path_id = lpe.learning_path_id

Line 796: , ota_events evt

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
799: , ota_booking_status_types bst
800: where lpc.learning_path_id = lpe.learning_path_id

Line 818: , ota_events evt

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
821: , ota_booking_status_types bst
822: where lpc.learning_path_id = lpe.learning_path_id

Line 841: , ota_events evt

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
844: , ota_booking_status_types bst
845: where lpc.learning_path_id = lpe.learning_path_id

Line 887: p_event_id in ota_Events.event_id%type)

883: return 'Y';
884: END is_path_successful;
885:
886: Procedure Start_comp_proc_success_attnd(p_person_id in number ,
887: p_event_id in ota_Events.event_id%type)
888: is
889:
890: cursor get_lp_enroll is
891: select lp_enrollment_id, lpe.learning_path_id

Line 893: , ota_events evt

889:
890: cursor get_lp_enroll is
891: select lp_enrollment_id, lpe.learning_path_id
892: From ota_learning_path_members lpm
893: , ota_events evt
894: , ota_lp_enrollments lpe
895: where evt.activity_version_id = lpm.activity_version_id
896: and lpm.learning_path_id = lpe.learning_path_id
897: and evt.event_id = p_event_id

Line 983: ota_events evt,

979: tdb.booking_status_type_id,
980: tdb.delegate_person_id,
981: tdb.delegate_contact_id
982: FROM ota_activity_versions oav,
983: ota_events evt,
984: ota_delegate_bookings tdb,
985: ota_booking_status_types bst
986: WHERE oav.activity_version_id = p_activity_version_id
987: AND oav.activity_version_id = evt.activity_version_id

Line 1031: function get_lp_enroll_id(p_event_id IN ota_events.event_id%type,

1027: end if;
1028: return ota_utility.get_lookup_meaning('OTA_LP_CURRENT_STATUS', l_path_status_code, 810);
1029: end get_lp_current_status;
1030:
1031: function get_lp_enroll_id(p_event_id IN ota_events.event_id%type,
1032: p_person_id IN ota_lp_enrollments.person_id%type,
1033: p_contact_id ota_lp_enrollments.contact_id%type)
1034: return ota_lp_enrollments.lp_enrollment_id%type IS
1035:

Line 1039: ota_events oev,

1035:
1036: CURSOR csr_lp_enrl_id_person IS
1037: SELECT lpe.lp_enrollment_id
1038: FROM ota_lp_enrollments lpe,
1039: ota_events oev,
1040: ota_learning_path_members lpm
1041: WHERE lpe.person_id = p_person_id
1042: AND oev.event_id = p_event_id
1043: AND NVL(lpe.is_history_flag, 'N') = 'N'

Line 1052: ota_events oev,

1048:
1049: CURSOR csr_lp_enrl_id_contact IS
1050: SELECT lpe.lp_enrollment_id
1051: FROM ota_lp_enrollments lpe,
1052: ota_events oev,
1053: ota_learning_path_members lpm
1054: WHERE lpe.contact_id = p_contact_id
1055: AND oev.event_id = p_event_id
1056: AND NVL(lpe.is_history_flag, 'N') = 'N'