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 388: p_event_id in ota_events.event_id%type

384: (p_person_id in per_all_people_f.person_id%type,
385: p_delegate_contact_id in NUMBER,
386: p_user_id in NUMBER,
387: p_user_type in ota_attempts.user_type%type,
388: p_event_id in ota_events.event_id%type
389: ) RETURN varchar2 is
390:
391: Cursor c_get_act_ver_id is
392: SELECT activity_version_id

Line 393: FROM ota_events

389: ) RETURN varchar2 is
390:
391: Cursor c_get_act_ver_id is
392: SELECT activity_version_id
393: FROM ota_events
394: WHERE event_id = p_event_id;
395:
396: l_enroll_image varchar2(20);
397: l_enrollment_status varchar2(1);

Line 426: p_event_id ota_events.event_id%TYPE

422:
423: Procedure chk_mandatory_prereqs
424: (p_person_id ota_delegate_bookings.delegate_person_id%TYPE,
425: p_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE,
426: p_event_id ota_events.event_id%TYPE
427: ) IS
428:
429: Cursor c_get_act_ver_id is
430: SELECT ofr.activity_version_id

Line 431: FROM ota_events evt, ota_offerings ofr

427: ) IS
428:
429: Cursor c_get_act_ver_id is
430: SELECT ofr.activity_version_id
431: FROM ota_events evt, ota_offerings ofr
432: WHERE evt.event_id = p_event_id
433: and evt.parent_offering_id = ofr.offering_id;
434:
435: Cursor get_ext_lrn_party_id is

Line 550: ,p_event_id in ota_events.event_id%type

546: END is_mand_comp_prereqs_completed;
547:
548: Function Get_course_prereq_count
549: (p_prereq_met varchar2
550: ,p_event_id in ota_events.event_id%type
551: ,p_prerequisite_course_id ota_activity_versions.activity_version_id%type
552: ) Return varchar2 is
553: --
554: --

Line 567: ota_events evb

563: ) prereq_met
564: from
565: ota_delegate_bookings odb,
566: ota_booking_status_types bst,
567: ota_events evb
568: where
569: odb.booking_status_type_id = bst.booking_status_type_id
570: and evb.event_id = odb.event_id
571: and evb.event_id = p_event_id;

Line 592: ,p_event_id in ota_events.event_id%type

588: End Get_course_prereq_count;
589:
590: Function Get_comp_prereq_count
591: (p_prereq_met varchar2
592: ,p_event_id in ota_events.event_id%type
593: ,p_comp_id in per_competence_elements.competence_id%type
594: ,p_level_id in per_competence_elements.proficiency_level_id%type
595: ) Return varchar2 is
596: --

Line 607: ota_events evb

603: ,p_level_id
604: ) prereq_met
605: from
606: ota_delegate_bookings odb,
607: ota_events evb
608: where
609: evb.event_id = odb.event_id
610: and evb.event_id = p_event_id;
611: --

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

626: --
627: End Get_comp_prereq_count;
628:
629: FUNCTION get_prereq_met_count
630: (p_event_id in ota_events.event_id%type,
631: p_prerequisite_course_id ota_activity_versions.activity_version_id%type,
632: p_comp_id in per_competence_elements.competence_id%type,
633: p_level_id in per_competence_elements.proficiency_level_id%type
634: ) RETURN varchar2 is

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

662: End get_prereq_met_count;
663:
664:
665: FUNCTION get_prereq_not_met_count
666: (p_event_id in ota_events.event_id%type,
667: p_prerequisite_course_id ota_activity_versions.activity_version_id%type,
668: p_comp_id in per_competence_elements.competence_id%type,
669: p_level_id in per_competence_elements.proficiency_level_id%type
670: ) RETURN varchar2 is

Line 703: p_event_id in ota_events.event_id%type

699:
700: -- Added for Bug#4485646
701: FUNCTION is_mand_comp_prereqs_comp_evt
702: (p_person_id in per_all_people_f.person_id%type,
703: p_event_id in ota_events.event_id%type
704: ) RETURN varchar2
705: IS
706: CURSOR csr_get_course_id IS
707: SELECT activity_version_id

Line 708: FROM ota_events

704: ) RETURN varchar2
705: IS
706: CURSOR csr_get_course_id IS
707: SELECT activity_version_id
708: FROM ota_events
709: WHERE event_id = p_event_id;
710:
711: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
712:

Line 727: ,p_event_id in ota_events.event_id%type

723: (p_person_id in per_all_people_f.person_id%type
724: ,p_delegate_contact_id in ota_delegate_bookings.delegate_contact_id%TYPE
725: ,p_user_id in number
726: ,p_user_type in varchar2
727: ,p_event_id in ota_events.event_id%type
728: ) RETURN varchar2
729: IS
730: CURSOR csr_get_course_id IS
731: SELECT activity_version_id

Line 732: FROM ota_events

728: ) RETURN varchar2
729: IS
730: CURSOR csr_get_course_id IS
731: SELECT activity_version_id
732: FROM ota_events
733: WHERE event_id = p_event_id;
734:
735: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
736:

Line 754: , p_event_id in ota_events.event_id%type

750: (p_person_id in per_all_people_f.person_id%type
751: ,p_delegate_contact_id in ota_delegate_bookings.delegate_contact_id%TYPE default NULL
752: ,p_user_id in number default NULL
753: ,p_user_type in varchar2 default 'E'
754: , p_event_id in ota_events.event_id%type
755: ) RETURN varchar2
756: IS
757: l_user_type varchar2(10):= p_user_type;
758: l_user_id number(15):=p_user_id;

Line 796: from OTA_EVENTS oev

792: ) RETURN varchar2 is
793: --
794: cursor get_valid_classes is
795: select 'Y'
796: from OTA_EVENTS oev
797: where oev.ACTIVITY_VERSION_ID = p_prerequisite_course_id
798: and (oev.EVENT_TYPE = 'SCHEDULED' or oev.EVENT_TYPE = 'SELFPACED')
799: and oev.EVENT_STATUS <> 'A'
800: and nvl(trunc(oev.course_end_date), trunc(sysdate)) >= trunc(sysdate);