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 870: OTA_EVENTS E,

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

Line 871: OTA_EVENTS_TL ET,

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

Line 932: l_event_id ota_events.event_id%TYPE;

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

Line 1043: OTA_EVENTS E,

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

Line 1044: OTA_EVENTS_TL ET,

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

Line 1079: l_event_id ota_events.event_id%TYPE;

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

Line 1279: OTA_EVENTS E,

1275: ,D.SUCCESSFUL_ATTENDANCE_FLAG
1276: , nvl(D.IS_MANDATORY_ENROLLMENT,'N') is_mandatory_enrollment
1277: ,E.EVENT_ID
1278: FROM ota_activity_versions_vl a ,
1279: OTA_EVENTS E,
1280: OTA_EVENTS_TL ET,
1281: OTA_DELEGATE_BOOKINGS D,
1282: OTA_BOOKING_STATUS_TYPES S,
1283: OTA_BOOKING_STATUS_TYPES_TL ST,

Line 1280: OTA_EVENTS_TL ET,

1276: , nvl(D.IS_MANDATORY_ENROLLMENT,'N') is_mandatory_enrollment
1277: ,E.EVENT_ID
1278: FROM ota_activity_versions_vl a ,
1279: OTA_EVENTS E,
1280: OTA_EVENTS_TL ET,
1281: OTA_DELEGATE_BOOKINGS D,
1282: OTA_BOOKING_STATUS_TYPES S,
1283: OTA_BOOKING_STATUS_TYPES_TL ST,
1284: OTA_OFFERINGS O,

Line 1318: l_event_id ota_events.event_id%TYPE;

1314:
1315: l_activity_rec activity_rectype;
1316: l_activity_tbl activity_tabletype;
1317: l_count NUMBER := 1;
1318: l_event_id ota_events.event_id%TYPE;
1319: BEGIN
1320: l_activity_tbl := activity_tabletype();
1321:
1322: OPEN get_activity_rec;

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

1410: IS
1411: l_person_id ota_delegate_bookings.delegate_person_id%TYPE := NULL;
1412: l_activity_version_id ota_activity_versions.activity_id%TYPE := NULL;
1413: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE;
1414: l_event_id ota_events.event_id%TYPE := NULL;
1415: l_activity_rec activity_rectype;
1416: l_event_rec event_rectype;
1417:
1418: l_events_tbl event_tabletype;