APPS.OTA_CME_UTIL dependencies on OTA_BOOKING_STATUS_TYPES

Line 24: ota_booking_status_types bst

20: tdb.successful_attendance_flag,
21: tdb.sign_eval_status ---added for sign in cert.10164130
22: FROM ota_events evt,
23: ota_delegate_bookings tdb,
24: ota_booking_status_types bst
25: WHERE evt.event_id = tdb.event_id
26: AND bst.booking_status_type_id = tdb.booking_status_type_id
27: and (
28: --sync sched, online(conf) or offline(ILT)

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

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

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

101: END get_enrl_status_on_update;
102:
103: PROCEDURE get_enrl_status_on_update(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
104: p_cert_prd_enrollment_id IN ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
105: p_booking_status_type OUT NOCOPY ota_booking_status_types.type%TYPE,
106: p_date_status_changed OUT NOCOPY ota_delegate_bookings.date_status_changed%TYPE,
107: p_successful_attendance_flag OUT NOCOPY ota_delegate_bookings.successful_attendance_flag%TYPE)
108: IS
109:

Line 350: l_enroll_type ota_booking_status_types.type%TYPE;

346: AND cpe.period_status_code <> 'EXPIRED';
347:
348: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
349: l_online_flag ota_category_usages.online_flag%type;
350: l_enroll_type ota_booking_status_types.type%TYPE;
351: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;
352: l_completion_date ota_cert_mbr_enrollments.completion_date%TYPE;
353: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
354:

Line 558: l_enroll_type ota_booking_status_types.type%TYPE;

554: WHERE cme.cert_member_id = cmb.certification_member_id
555: AND cme.cert_mbr_enrollment_id = p_cert_mbr_enrollment_id;
556: --AND cme.member_status_code <> 'CANCELLED';
557:
558: l_enroll_type ota_booking_status_types.type%TYPE;
559: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;
560: l_completion_date ota_cert_mbr_enrollments.completion_date%TYPE;
561: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
562:

Line 892: ota_booking_status_types_VL s,

888: FROM ota_events e,
889: ota_events_tl et,
890: ota_activity_versions a,
891: ota_delegate_bookings b,
892: ota_booking_status_types_VL s,
893: ota_cert_enrollments cre,
894: ota_cert_prd_enrollments cpe,
895: ota_cert_mbr_enrollments cme,
896: ota_certification_members cmb,

Line 924: l_enrollment_Status_Type ota_booking_status_types.Type%type;

920:
921: l_proc VARCHAR2(72) := g_package ||'chk_active_cme_enrl';
922:
923:
924: l_enrollment_Status_Type ota_booking_status_types.Type%type;
925: l_return_flag varchar2(1) := 'F';
926:
927: begin
928: