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 45: PROCEDURE get_enrl_status_on_update(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,

41: )
42: order by status;
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

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

100:
101: -- ---------------------------------------------------------------------------
102: -- |----------------------< calculate_cme_status >-----------------------------|
103: -- ---------------------------------------------------------------------------
104: PROCEDURE calculate_cme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
105: p_cert_prd_enrollment_id IN ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
106: p_mode in varchar2,
107: p_member_status_code OUT nocopy VARCHAR2,
108: p_completion_date OUT nocopy DATE)

Line 253: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;

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

Line 778: ota_activity_versions a,

774: SELECT
775: s.type Enrollment_Status_Type
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,