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_DELEGATE_BOOKINGS

Line 750: FUNCTION is_part_of_certification(p_booking_id IN ota_delegate_bookings.booking_id%TYPE,

746: WHEN invalid_certification_id THEN
747: p_certifications := certification_tabletype();
748: END get_certification_details;
749:
750: FUNCTION is_part_of_certification(p_booking_id IN ota_delegate_bookings.booking_id%TYPE,
751: p_cert_enrollment_id OUT NOCOPY ota_cert_enrollments.cert_enrollment_id%TYPE) RETURN BOOLEAN
752: IS
753:
754: CURSOR get_enrollments IS

Line 773: ota_delegate_bookings b,

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,
774: ota_booking_status_types_VL s,
775: ota_cert_enrollments cre,
776: ota_cert_prd_enrollments cpe,
777: ota_cert_mbr_enrollments cme,

Line 821: PROCEDURE get_training_details_internal(p_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,

817: RETURN FALSE;
818: CLOSE get_enrollments;
819: END is_part_of_certification;
820:
821: PROCEDURE get_training_details_internal(p_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,
822: p_start_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,
823: p_end_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,
824: p_view_history IN VARCHAR,
825: p_activity_tbl OUT NOCOPY activity_tabletype)

Line 822: p_start_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,

818: CLOSE get_enrollments;
819: END is_part_of_certification;
820:
821: PROCEDURE get_training_details_internal(p_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,
822: p_start_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,
823: p_end_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,
824: p_view_history IN VARCHAR,
825: p_activity_tbl OUT NOCOPY activity_tabletype)
826: IS

Line 823: p_end_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,

819: END is_part_of_certification;
820:
821: PROCEDURE get_training_details_internal(p_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,
822: p_start_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,
823: p_end_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,
824: p_view_history IN VARCHAR,
825: p_activity_tbl OUT NOCOPY activity_tabletype)
826: IS
827: CURSOR get_activity_rec IS

Line 872: OTA_DELEGATE_BOOKINGS D,

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,
876: OTA_OFFERINGS_TL OT,

Line 997: PROCEDURE get_training_details_internal(p_booking_id IN OTA_DELEGATE_BOOKINGS.BOOKING_ID%TYPE

993: CLOSE get_activity_rec;
994: p_activity_tbl := l_activity_tbl;
995: END get_training_details_internal;
996:
997: PROCEDURE get_training_details_internal(p_booking_id IN OTA_DELEGATE_BOOKINGS.BOOKING_ID%TYPE
998: ,p_activity_tbl OUT NOCOPY activity_tabletype)
999: IS
1000: CURSOR get_activity_rec IS
1001: SELECT distinct

Line 1045: OTA_DELEGATE_BOOKINGS D,

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,
1049: OTA_OFFERINGS_TL OT,

Line 1232: PROCEDURE get_training_details_internal(p_start_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,

1228: CLOSE get_activity_rec;
1229: p_activity_tbl := l_activity_tbl;
1230: END get_training_details_internal;
1231:
1232: PROCEDURE get_training_details_internal(p_start_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,
1233: p_end_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,
1234: p_activity_tbl OUT NOCOPY activity_tabletype)
1235: IS
1236: CURSOR get_activity_rec IS

Line 1233: p_end_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,

1229: p_activity_tbl := l_activity_tbl;
1230: END get_training_details_internal;
1231:
1232: PROCEDURE get_training_details_internal(p_start_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,
1233: p_end_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,
1234: p_activity_tbl OUT NOCOPY activity_tabletype)
1235: IS
1236: CURSOR get_activity_rec IS
1237: SELECT distinct

Line 1281: OTA_DELEGATE_BOOKINGS D,

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,
1285: OTA_OFFERINGS_TL OT,

Line 1381: PROCEDURE get_booking_status(p_delegate_booking_id IN ota_delegate_bookings.booking_id%TYPE,

1377: CLOSE get_activity_rec;
1378: p_activity_tbl := l_activity_tbl;
1379: END get_training_details_internal;
1380:
1381: PROCEDURE get_booking_status(p_delegate_booking_id IN ota_delegate_bookings.booking_id%TYPE,
1382: p_status_name OUT NOCOPY ota_booking_status_types_VL.name%TYPE,
1383: p_status_type OUT NOCOPY ota_booking_status_types_VL.type%TYPE)
1384: IS
1385: CURSOR get_status IS

Line 1388: FROM ota_delegate_bookings b,

1384: IS
1385: CURSOR get_status IS
1386: SELECT s.name,
1387: s.type
1388: FROM ota_delegate_bookings b,
1389: ota_booking_status_types_VL s
1390: WHERE b.booking_status_type_id = s.booking_status_type_id
1391: AND b.booking_id = p_delegate_booking_id;
1392:

Line 1411: l_person_id ota_delegate_bookings.delegate_person_id%TYPE := NULL;

1407: p_training OUT NOCOPY activity_tabletype,
1408: p_certifications OUT NOCOPY certification_tabletype,
1409: p_ispartofcertification OUT NOCOPY BOOLEAN)
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;