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 1382: p_status_name OUT NOCOPY ota_booking_status_types_VL.name%TYPE,

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

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

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
1386: SELECT s.name,
1387: s.type

Line 1389: ota_booking_status_types_VL s

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

Line 1393: l_name ota_booking_status_types_VL.name%TYPE;

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:
1393: l_name ota_booking_status_types_VL.name%TYPE;
1394: l_type ota_booking_status_types_VL.type%TYPE;
1395:
1396: BEGIN
1397: OPEN get_status;

Line 1394: l_type ota_booking_status_types_VL.type%TYPE;

1390: WHERE b.booking_status_type_id = s.booking_status_type_id
1391: AND b.booking_id = p_delegate_booking_id;
1392:
1393: l_name ota_booking_status_types_VL.name%TYPE;
1394: l_type ota_booking_status_types_VL.type%TYPE;
1395:
1396: BEGIN
1397: OPEN get_status;
1398: FETCH get_status INTO

Line 1423: l_status_name ota_booking_status_types_VL.name%TYPE;

1419: l_activity_tbl activity_tabletype;
1420:
1421: l_event_action VARCHAR2(50);
1422: l_is_part_of_certification BOOLEAN := FALSE;
1423: l_status_name ota_booking_status_types_VL.name%TYPE;
1424: l_status_type ota_booking_status_types_VL.type%TYPE;
1425:
1426: --certification input options
1427: l_cert_input_options cert_query_input_rectype;

Line 1424: l_status_type ota_booking_status_types_VL.type%TYPE;

1420:
1421: l_event_action VARCHAR2(50);
1422: l_is_part_of_certification BOOLEAN := FALSE;
1423: l_status_name ota_booking_status_types_VL.name%TYPE;
1424: l_status_type ota_booking_status_types_VL.type%TYPE;
1425:
1426: --certification input options
1427: l_cert_input_options cert_query_input_rectype;
1428: l_certifications_tbl certification_tabletype;