APPS.OTA_CME_UTIL dependencies on OTA_BOOKING_STATUS_TYPES

Line 22: ota_booking_status_types bst

18: evt.COURSE_START_DATE,
19: evt.COURSE_END_DATE
20: FROM ota_events evt,
21: ota_delegate_bookings tdb,
22: ota_booking_status_types bst
23: WHERE evt.event_id = tdb.event_id
24: AND bst.booking_status_type_id = tdb.booking_status_type_id
25: and (
26: --sync sched, online(conf) or offline(ILT)

Line 47: p_booking_status_type OUT NOCOPY ota_booking_status_types.type%TYPE,

43: --
44:
45: PROCEDURE get_enrl_status_on_update(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
46: p_cert_prd_enrollment_id IN ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
47: p_booking_status_type OUT NOCOPY ota_booking_status_types.type%TYPE,
48: p_date_status_changed OUT NOCOPY ota_delegate_bookings.date_status_changed%TYPE)
49: IS
50:
51: CURSOR csr_cert_enrl IS

Line 255: l_enroll_type ota_booking_status_types.type%TYPE;

251: AND cpe.period_status_code <> 'EXPIRED';
252:
253: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
254: l_online_flag ota_category_usages.online_flag%type;
255: l_enroll_type ota_booking_status_types.type%TYPE;
256: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;
257: l_completion_date ota_cert_mbr_enrollments.completion_date%TYPE;
258: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
259:

Line 455: l_enroll_type ota_booking_status_types.type%TYPE;

451: WHERE cme.cert_member_id = cmb.certification_member_id
452: AND cme.cert_mbr_enrollment_id = p_cert_mbr_enrollment_id;
453: --AND cme.member_status_code <> 'CANCELLED';
454:
455: l_enroll_type ota_booking_status_types.type%TYPE;
456: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;
457: l_completion_date ota_cert_mbr_enrollments.completion_date%TYPE;
458: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
459:

Line 780: ota_booking_status_types_VL s,

776: FROM ota_events e,
777: ota_events_tl et,
778: ota_activity_versions a,
779: ota_delegate_bookings b,
780: ota_booking_status_types_VL s,
781: ota_cert_enrollments cre,
782: ota_cert_prd_enrollments cpe,
783: ota_cert_mbr_enrollments cme,
784: ota_certification_members cmb,

Line 812: l_enrollment_Status_Type ota_booking_status_types.Type%type;

808:
809: l_proc VARCHAR2(72) := g_package ||'chk_active_cme_enrl';
810:
811:
812: l_enrollment_Status_Type ota_booking_status_types.Type%type;
813: l_return_flag varchar2(1) := 'F';
814:
815: begin
816: