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

Line 17: PROCEDURE get_events(p_event_id IN ota_events_v.event_id%TYPE,

13: END IF;
14: RETURN FALSE;
15: END is_required;
16:
17: PROCEDURE get_events(p_event_id IN ota_events_v.event_id%TYPE,
18: p_activity_version_id IN ota_activity_versions_vl.activity_version_id%TYPE,
19: p_events_tbl OUT NOCOPY event_tabletype)
20: IS
21: CURSOR cur_event IS

Line 110: FROM OTA_EVENTS_V

106: timezone,
107: inventory_item_id,
108: parent_offering_id,
109: data_source
110: FROM OTA_EVENTS_V
111: WHERE ((p_event_id IS NULL) OR (p_event_id IS NOT NULL AND event_id = p_event_id))
112: AND ((p_activity_version_id IS NULL) OR (p_activity_version_id IS NOT NULL AND activity_version_id = p_activity_version_id));
113:
114: l_event_rec event_rectype;

Line 584: from ota_events e

580: fnd_profile.value('OTA_ILEARNING_SITE_ID') AS SITE_SHORT_NAME ,
581: fnd_profile.value('USERNAME') AS FND_USER_NAME ,
582: WFA_HTML.CONV_SPECIAL_URL_CHARS(fnd_profile.value('OTA_ILEARNING_SITE_ADDRESS')) Encoded_Site_Address ,
583: (select e.offering_id
584: from ota_events e
585: where e.event_id = OTA_LO_UTILITY.get_cme_online_event_id(NVL(cre.person_id, cre.contact_id),
586: DECODE(cre.person_id, NULL, 'C', 'E'), cme.cert_mbr_enrollment_id))AS CLASSROOM_ID
587: from ota_cert_enrollments cre,
588: ota_cert_prd_enrollments cpe,

Line 768: FROM ota_events e,

764: cpe.cert_period_end_date,
765: e.course_end_date Course_End,
766: e.course_start_date event_start_date,
767: e.event_type event_type
768: FROM ota_events e,
769: ota_events_tl et,
770: hr_all_organization_units o,
771: hr_all_organization_units_tl haotl,
772: ota_activity_versions a,

Line 769: ota_events_tl et,

765: e.course_end_date Course_End,
766: e.course_start_date event_start_date,
767: e.event_type event_type
768: FROM ota_events e,
769: ota_events_tl et,
770: hr_all_organization_units o,
771: hr_all_organization_units_tl haotl,
772: ota_activity_versions a,
773: ota_delegate_bookings b,

Line 871: OTA_EVENTS E,

867: ,D.SUCCESSFUL_ATTENDANCE_FLAG
868: , nvl(D.IS_MANDATORY_ENROLLMENT,'N') is_mandatory_enrollment
869: ,E.EVENT_ID
870: FROM ota_activity_versions_vl a ,
871: OTA_EVENTS E,
872: OTA_EVENTS_TL ET,
873: OTA_DELEGATE_BOOKINGS D,
874: OTA_BOOKING_STATUS_TYPES S,
875: OTA_BOOKING_STATUS_TYPES_TL ST,

Line 872: OTA_EVENTS_TL ET,

868: , nvl(D.IS_MANDATORY_ENROLLMENT,'N') is_mandatory_enrollment
869: ,E.EVENT_ID
870: FROM ota_activity_versions_vl a ,
871: OTA_EVENTS E,
872: OTA_EVENTS_TL ET,
873: OTA_DELEGATE_BOOKINGS D,
874: OTA_BOOKING_STATUS_TYPES S,
875: OTA_BOOKING_STATUS_TYPES_TL ST,
876: OTA_OFFERINGS O,

Line 933: l_event_id ota_events.event_id%TYPE;

929:
930: l_activity_rec activity_rectype;
931: l_activity_tbl activity_tabletype;
932: l_count NUMBER := 1;
933: l_event_id ota_events.event_id%TYPE;
934: BEGIN
935: l_activity_tbl := activity_tabletype();
936: OPEN get_activity_rec;
937: LOOP

Line 1046: OTA_EVENTS E,

1042: ,D.SUCCESSFUL_ATTENDANCE_FLAG
1043: , nvl(D.IS_MANDATORY_ENROLLMENT,'N') is_mandatory_enrollment
1044: ,E.EVENT_ID
1045: FROM ota_activity_versions_vl a ,
1046: OTA_EVENTS E,
1047: OTA_EVENTS_TL ET,
1048: OTA_DELEGATE_BOOKINGS D,
1049: OTA_BOOKING_STATUS_TYPES S,
1050: OTA_BOOKING_STATUS_TYPES_TL ST,

Line 1047: OTA_EVENTS_TL ET,

1043: , nvl(D.IS_MANDATORY_ENROLLMENT,'N') is_mandatory_enrollment
1044: ,E.EVENT_ID
1045: FROM ota_activity_versions_vl a ,
1046: OTA_EVENTS E,
1047: OTA_EVENTS_TL ET,
1048: OTA_DELEGATE_BOOKINGS D,
1049: OTA_BOOKING_STATUS_TYPES S,
1050: OTA_BOOKING_STATUS_TYPES_TL ST,
1051: OTA_OFFERINGS O,

Line 1082: l_event_id ota_events.event_id%TYPE;

1078: AND D.BOOKING_ID = p_booking_id;
1079:
1080: l_activity_rec activity_rectype;
1081: l_activity_tbl activity_tabletype;
1082: l_event_id ota_events.event_id%TYPE;
1083: BEGIN
1084: l_activity_tbl := activity_tabletype();
1085:
1086: OPEN get_activity_rec;

Line 1284: OTA_EVENTS E,

1280: ,D.SUCCESSFUL_ATTENDANCE_FLAG
1281: , nvl(D.IS_MANDATORY_ENROLLMENT,'N') is_mandatory_enrollment
1282: ,E.EVENT_ID
1283: FROM ota_activity_versions_vl a ,
1284: OTA_EVENTS E,
1285: OTA_EVENTS_TL ET,
1286: OTA_DELEGATE_BOOKINGS D,
1287: OTA_BOOKING_STATUS_TYPES S,
1288: OTA_BOOKING_STATUS_TYPES_TL ST,

Line 1285: OTA_EVENTS_TL ET,

1281: , nvl(D.IS_MANDATORY_ENROLLMENT,'N') is_mandatory_enrollment
1282: ,E.EVENT_ID
1283: FROM ota_activity_versions_vl a ,
1284: OTA_EVENTS E,
1285: OTA_EVENTS_TL ET,
1286: OTA_DELEGATE_BOOKINGS D,
1287: OTA_BOOKING_STATUS_TYPES S,
1288: OTA_BOOKING_STATUS_TYPES_TL ST,
1289: OTA_OFFERINGS O,

Line 1323: l_event_id ota_events.event_id%TYPE;

1319:
1320: l_activity_rec activity_rectype;
1321: l_activity_tbl activity_tabletype;
1322: l_count NUMBER := 1;
1323: l_event_id ota_events.event_id%TYPE;
1324: BEGIN
1325: l_activity_tbl := activity_tabletype();
1326:
1327: OPEN get_activity_rec;

Line 1420: l_event_id ota_events.event_id%TYPE := NULL;

1416: IS
1417: l_person_id ota_delegate_bookings.delegate_person_id%TYPE := NULL;
1418: l_activity_version_id ota_activity_versions.activity_id%TYPE := NULL;
1419: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE;
1420: l_event_id ota_events.event_id%TYPE := NULL;
1421: l_activity_rec activity_rectype;
1422: l_event_rec event_rectype;
1423:
1424: l_events_tbl event_tabletype;