APPS.OTA_CME_UTIL dependencies on OTA_ACTIVITY_VERSIONS

Line 10: CURSOR get_enrl_status(csr_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,

6: -- ----------------------------------------------------------------------------
7: --
8: g_package VARCHAR2(33) := ' OTA_CME_UTIL.'; -- Global package name
9: --
10: CURSOR get_enrl_status(csr_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
11: csr_cert_period_start_date in ota_cert_prd_enrollments.cert_period_start_date%type,
12: csr_cert_period_end_date in ota_cert_prd_enrollments.cert_period_end_date%type,
13: csr_person_id in ota_cert_enrollments.person_id%TYPE,
14: csr_contact_id in ota_cert_enrollments.contact_id%TYPE) IS

Line 47: PROCEDURE get_enrl_status_on_update(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,

43: )
44: order by status;
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

Line 103: PROCEDURE get_enrl_status_on_update(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,

99: p_date_status_changed := null;
100:
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)

Line 167: PROCEDURE calculate_cme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,

163:
164: -- ---------------------------------------------------------------------------
165: -- |----------------------< calculate_cme_status >-----------------------------|
166: -- ---------------------------------------------------------------------------
167: PROCEDURE calculate_cme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
168: p_cert_prd_enrollment_id IN ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
169: p_mode in varchar2,
170: p_member_status_code OUT nocopy VARCHAR2,
171: p_completion_date OUT nocopy DATE,

Line 348: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;

344: AND trunc(sysdate) between trunc(cpe.cert_period_start_date) and trunc(cpe.cert_period_end_date)
345: -- don't consider expired prds
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;

Line 890: ota_activity_versions a,

886: SELECT
887: s.type Enrollment_Status_Type
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,