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_BOOKING_STATUS_TYPES_VL

Line 774: ota_booking_status_types_VL s,

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,
778: ota_certification_members cmb,

Line 1388: p_status_name OUT NOCOPY ota_booking_status_types_VL.name%TYPE,

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
1392: SELECT s.name,

Line 1389: p_status_type OUT NOCOPY ota_booking_status_types_VL.type%TYPE)

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
1392: SELECT s.name,
1393: s.type

Line 1395: ota_booking_status_types_VL s

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:
1399: l_name ota_booking_status_types_VL.name%TYPE;

Line 1399: l_name ota_booking_status_types_VL.name%TYPE;

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:
1399: l_name ota_booking_status_types_VL.name%TYPE;
1400: l_type ota_booking_status_types_VL.type%TYPE;
1401:
1402: BEGIN
1403: OPEN get_status;

Line 1400: l_type ota_booking_status_types_VL.type%TYPE;

1396: WHERE b.booking_status_type_id = s.booking_status_type_id
1397: AND b.booking_id = p_delegate_booking_id;
1398:
1399: l_name ota_booking_status_types_VL.name%TYPE;
1400: l_type ota_booking_status_types_VL.type%TYPE;
1401:
1402: BEGIN
1403: OPEN get_status;
1404: FETCH get_status INTO

Line 1429: l_status_name ota_booking_status_types_VL.name%TYPE;

1425: l_activity_tbl activity_tabletype;
1426:
1427: l_event_action VARCHAR2(50);
1428: l_is_part_of_certification BOOLEAN := FALSE;
1429: l_status_name ota_booking_status_types_VL.name%TYPE;
1430: l_status_type ota_booking_status_types_VL.type%TYPE;
1431:
1432: --certification input options
1433: l_cert_input_options cert_query_input_rectype;

Line 1430: l_status_type ota_booking_status_types_VL.type%TYPE;

1426:
1427: l_event_action VARCHAR2(50);
1428: l_is_part_of_certification BOOLEAN := FALSE;
1429: l_status_name ota_booking_status_types_VL.name%TYPE;
1430: l_status_type ota_booking_status_types_VL.type%TYPE;
1431:
1432: --certification input options
1433: l_cert_input_options cert_query_input_rectype;
1434: l_certifications_tbl certification_tabletype;