APPS.OTA_LO_UTILITY dependencies on OTA_BOOKING_STATUS_TYPES_TL

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

3076: l_course_end_date ota_events.course_end_date%TYPE;
3077: l_sysdate ota_events.course_end_date%TYPE;
3078:
3079: l_status VARCHAR2(30) := null;
3080: l_status_name ota_booking_status_types_tl.name%TYPE := null;
3081:
3082: --Bug 4665032
3083: l_enrollment_status_code ota_booking_status_types.type%TYPE;
3084: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;

Line 3084: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;

3080: l_status_name ota_booking_status_types_tl.name%TYPE := null;
3081:
3082: --Bug 4665032
3083: l_enrollment_status_code ota_booking_status_types.type%TYPE;
3084: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;
3085: l_decode_lesson_status VARCHAR2(1);
3086:
3087: -- Bug 3725560
3088: l_imported_offering ota_events.offering_id%TYPE := null;

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

3584: l_learning_object_id ota_offerings.learning_object_id%TYPE;
3585: l_course_end_date ota_events.course_end_date%TYPE;
3586:
3587: l_status VARCHAR2(30) := null;
3588: l_status_name ota_booking_status_types_tl.name%TYPE := null;
3589:
3590: BEGIN
3591: hr_utility.set_location(' Step:'|| l_proc, 10);
3592: open c_delivery_mode;

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

4144:
4145: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type;
4146:
4147: l_status VARCHAR2(30) := null;
4148: l_status_name ota_booking_status_types_tl.name%TYPE := null;
4149:
4150: l_return_lo_status VARCHAR2(30);
4151: l_online_evt_count number;
4152:

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

4695:
4696: l_online_event_id ota_events.event_id%type;
4697:
4698: l_status VARCHAR2(30) := null;
4699: l_status_name ota_booking_status_types_tl.name%TYPE := null;
4700:
4701: l_return_lo_status VARCHAR2(30);
4702: l_online_evt_count number;
4703: BEGIN