APPS.OTA_LO_UTILITY dependencies on OTA_BOOKING_STATUS_TYPES_TL

Line 3479: l_status_name ota_booking_status_types_tl.name%TYPE := null;

3475: l_course_end_date ota_events.course_end_date%TYPE;
3476: l_sysdate ota_events.course_end_date%TYPE;
3477:
3478: l_status VARCHAR2(30) := null;
3479: l_status_name ota_booking_status_types_tl.name%TYPE := null;
3480:
3481: --Bug 4665032
3482: l_enrollment_status_code ota_booking_status_types.type%TYPE;
3483: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;

Line 3483: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;

3479: l_status_name ota_booking_status_types_tl.name%TYPE := null;
3480:
3481: --Bug 4665032
3482: l_enrollment_status_code ota_booking_status_types.type%TYPE;
3483: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;
3484: l_decode_lesson_status VARCHAR2(1);
3485:
3486: -- Bug 3725560
3487: l_imported_offering ota_events.offering_id%TYPE := null;

Line 4089: l_status_name ota_booking_status_types_tl.name%TYPE := null;

4085: l_learning_object_id ota_offerings.learning_object_id%TYPE;
4086: l_course_end_date ota_events.course_end_date%TYPE;
4087:
4088: l_status VARCHAR2(30) := null;
4089: l_status_name ota_booking_status_types_tl.name%TYPE := null;
4090: l_sign_eval_status OTA_DELEGATE_BOOKINGS.sign_eval_status%type;
4091:
4092: BEGIN
4093: hr_utility.set_location(' Step:'|| l_proc, 10);

Line 4724: l_status_name ota_booking_status_types_tl.name%TYPE := null;

4720:
4721: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type;
4722:
4723: l_status VARCHAR2(30) := null;
4724: l_status_name ota_booking_status_types_tl.name%TYPE := null;
4725:
4726: l_return_lo_status VARCHAR2(30);
4727: l_online_evt_count number;
4728:

Line 5275: l_status_name ota_booking_status_types_tl.name%TYPE := null;

5271:
5272: l_online_event_id ota_events.event_id%type;
5273:
5274: l_status VARCHAR2(30) := null;
5275: l_status_name ota_booking_status_types_tl.name%TYPE := null;
5276:
5277: l_return_lo_status VARCHAR2(30);
5278: l_online_evt_count number;
5279: BEGIN