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 873: OTA_DELEGATE_BOOKINGS D,

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

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

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

Line 1048: OTA_DELEGATE_BOOKINGS D,

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

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

1232: CLOSE get_activity_rec;
1233: p_activity_tbl := l_activity_tbl;
1234: END get_training_details_internal;
1235:
1236: PROCEDURE get_training_details_internal(p_start_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,
1237: p_end_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,
1238: p_activity_tbl OUT NOCOPY activity_tabletype)
1239: IS
1240: CURSOR get_activity_rec IS

Line 1237: p_end_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,

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

Line 1286: OTA_DELEGATE_BOOKINGS D,

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

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

1383: CLOSE get_activity_rec;
1384: p_activity_tbl := l_activity_tbl;
1385: END get_training_details_internal;
1386:
1387: PROCEDURE get_booking_status(p_delegate_booking_id IN ota_delegate_bookings.booking_id%TYPE,
1388: p_status_name OUT NOCOPY ota_booking_status_types_VL.name%TYPE,
1389: p_status_type OUT NOCOPY ota_booking_status_types_VL.type%TYPE)
1390: IS
1391: CURSOR get_status IS

Line 1394: FROM ota_delegate_bookings b,

1390: IS
1391: CURSOR get_status IS
1392: SELECT s.name,
1393: s.type
1394: FROM ota_delegate_bookings b,
1395: ota_booking_status_types_VL s
1396: WHERE b.booking_status_type_id = s.booking_status_type_id
1397: AND b.booking_id = p_delegate_booking_id;
1398:

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

1413: p_training OUT NOCOPY activity_tabletype,
1414: p_certifications OUT NOCOPY certification_tabletype,
1415: p_ispartofcertification OUT NOCOPY BOOLEAN)
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;