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_CPR_UTILITY dependencies on OTA_EVENTS

Line 220: ota_events OEV,

216: OFR.learning_object_id
217: FROM
218: ota_activity_versions OAV,
219: ota_offerings OFR,
220: ota_events OEV,
221: ota_category_usages OCU
222: WHERE
223: OFR.activity_version_id = OAV.activity_version_id
224: And OEV.parent_offering_id = OFR.offering_id

Line 394: p_event_id in ota_events.event_id%type

390: (p_person_id in per_all_people_f.person_id%type,
391: p_delegate_contact_id in NUMBER,
392: p_user_id in NUMBER,
393: p_user_type in ota_attempts.user_type%type,
394: p_event_id in ota_events.event_id%type
395: ) RETURN varchar2 is
396:
397: Cursor c_get_act_ver_id is
398: SELECT activity_version_id

Line 399: FROM ota_events

395: ) RETURN varchar2 is
396:
397: Cursor c_get_act_ver_id is
398: SELECT activity_version_id
399: FROM ota_events
400: WHERE event_id = p_event_id;
401:
402: l_enroll_image varchar2(20);
403: l_enrollment_status varchar2(1);

Line 432: p_event_id ota_events.event_id%TYPE

428:
429: Procedure chk_mandatory_prereqs
430: (p_person_id ota_delegate_bookings.delegate_person_id%TYPE,
431: p_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE,
432: p_event_id ota_events.event_id%TYPE
433: ) IS
434:
435: Cursor c_get_act_ver_id is
436: SELECT ofr.activity_version_id

Line 437: FROM ota_events evt, ota_offerings ofr

433: ) IS
434:
435: Cursor c_get_act_ver_id is
436: SELECT ofr.activity_version_id
437: FROM ota_events evt, ota_offerings ofr
438: WHERE evt.event_id = p_event_id
439: and evt.parent_offering_id = ofr.offering_id;
440:
441: Cursor get_ext_lrn_party_id is

Line 556: ,p_event_id in ota_events.event_id%type

552: END is_mand_comp_prereqs_completed;
553:
554: Function Get_course_prereq_count
555: (p_prereq_met varchar2
556: ,p_event_id in ota_events.event_id%type
557: ,p_prerequisite_course_id ota_activity_versions.activity_version_id%type
558: ) Return varchar2 is
559: --
560: --

Line 573: ota_events evb

569: ) prereq_met
570: from
571: ota_delegate_bookings odb,
572: ota_booking_status_types bst,
573: ota_events evb
574: where
575: odb.booking_status_type_id = bst.booking_status_type_id
576: and evb.event_id = odb.event_id
577: and evb.event_id = p_event_id;

Line 598: ,p_event_id in ota_events.event_id%type

594: End Get_course_prereq_count;
595:
596: Function Get_comp_prereq_count
597: (p_prereq_met varchar2
598: ,p_event_id in ota_events.event_id%type
599: ,p_comp_id in per_competence_elements.competence_id%type
600: ,p_level_id in per_competence_elements.proficiency_level_id%type
601: ) Return varchar2 is
602: --

Line 613: ota_events evb

609: ,p_level_id
610: ) prereq_met
611: from
612: ota_delegate_bookings odb,
613: ota_events evb
614: where
615: evb.event_id = odb.event_id
616: and evb.event_id = p_event_id;
617: --

Line 636: (p_event_id in ota_events.event_id%type,

632: --
633: End Get_comp_prereq_count;
634:
635: FUNCTION get_prereq_met_count
636: (p_event_id in ota_events.event_id%type,
637: p_prerequisite_course_id ota_activity_versions.activity_version_id%type,
638: p_comp_id in per_competence_elements.competence_id%type,
639: p_level_id in per_competence_elements.proficiency_level_id%type
640: ) RETURN varchar2 is

Line 672: (p_event_id in ota_events.event_id%type,

668: End get_prereq_met_count;
669:
670:
671: FUNCTION get_prereq_not_met_count
672: (p_event_id in ota_events.event_id%type,
673: p_prerequisite_course_id ota_activity_versions.activity_version_id%type,
674: p_comp_id in per_competence_elements.competence_id%type,
675: p_level_id in per_competence_elements.proficiency_level_id%type
676: ) RETURN varchar2 is

Line 709: p_event_id in ota_events.event_id%type

705:
706: -- Added for Bug#4485646
707: FUNCTION is_mand_comp_prereqs_comp_evt
708: (p_person_id in per_all_people_f.person_id%type,
709: p_event_id in ota_events.event_id%type
710: ) RETURN varchar2
711: IS
712: CURSOR csr_get_course_id IS
713: SELECT activity_version_id

Line 714: FROM ota_events

710: ) RETURN varchar2
711: IS
712: CURSOR csr_get_course_id IS
713: SELECT activity_version_id
714: FROM ota_events
715: WHERE event_id = p_event_id;
716:
717: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
718:

Line 733: ,p_event_id in ota_events.event_id%type

729: (p_person_id in per_all_people_f.person_id%type
730: ,p_delegate_contact_id in ota_delegate_bookings.delegate_contact_id%TYPE
731: ,p_user_id in number
732: ,p_user_type in varchar2
733: ,p_event_id in ota_events.event_id%type
734: ) RETURN varchar2
735: IS
736: CURSOR csr_get_course_id IS
737: SELECT activity_version_id

Line 738: FROM ota_events

734: ) RETURN varchar2
735: IS
736: CURSOR csr_get_course_id IS
737: SELECT activity_version_id
738: FROM ota_events
739: WHERE event_id = p_event_id;
740:
741: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
742:

Line 760: , p_event_id in ota_events.event_id%type

756: (p_person_id in per_all_people_f.person_id%type
757: ,p_delegate_contact_id in ota_delegate_bookings.delegate_contact_id%TYPE default NULL
758: ,p_user_id in number default NULL
759: ,p_user_type in varchar2 default 'E'
760: , p_event_id in ota_events.event_id%type
761: ) RETURN varchar2
762: IS
763: l_user_type varchar2(10):= p_user_type;
764: l_user_id number(15):=p_user_id;

Line 802: from OTA_EVENTS oev

798: ) RETURN varchar2 is
799: --
800: cursor get_valid_classes is
801: select 'Y'
802: from OTA_EVENTS oev
803: where oev.ACTIVITY_VERSION_ID = p_prerequisite_course_id
804: and (oev.EVENT_TYPE = 'SCHEDULED' or oev.EVENT_TYPE = 'SELFPACED')
805: and oev.EVENT_STATUS <> 'A'
806: and nvl(trunc(oev.course_end_date), trunc(sysdate)) >= trunc(sysdate);