APPS.OTA_CME_UTIL dependencies on OTA_CERT_ENROLLMENTS

Line 106: p_person_id IN ota_cert_enrollments.person_id%TYPE,

102: --
103: -- {End Of Comments}
104: -- ---------------------------------------------------------------------------
105: PROCEDURE update_cme_status (p_event_id IN ota_events.event_id%TYPE,
106: p_person_id IN ota_cert_enrollments.person_id%TYPE,
107: p_contact_id IN ota_cert_enrollments.contact_id%TYPE,
108: p_cert_prd_enrollment_ids OUT NOCOPY varchar2);
109:
110:

Line 107: p_contact_id IN ota_cert_enrollments.contact_id%TYPE,

103: -- {End Of Comments}
104: -- ---------------------------------------------------------------------------
105: PROCEDURE update_cme_status (p_event_id IN ota_events.event_id%TYPE,
106: p_person_id IN ota_cert_enrollments.person_id%TYPE,
107: p_contact_id IN ota_cert_enrollments.contact_id%TYPE,
108: p_cert_prd_enrollment_ids OUT NOCOPY varchar2);
109:
110:
111: -- ---------------------------------------------------------------------------

Line 227: p_person_id IN ota_cert_enrollments.person_id%type,

223: Function chk_active_cme_enrl(p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
224: return varchar2;
225:
226: function get_cert_mbr_enroll_id(p_event_id IN ota_events.event_id%type,
227: p_person_id IN ota_cert_enrollments.person_id%type,
228: p_contact_id ota_cert_enrollments.contact_id%type)
229: return ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type;
230:
231: function get_cert_prd_enroll_id(p_event_id IN ota_events.event_id%type,

Line 228: p_contact_id ota_cert_enrollments.contact_id%type)

224: return varchar2;
225:
226: function get_cert_mbr_enroll_id(p_event_id IN ota_events.event_id%type,
227: p_person_id IN ota_cert_enrollments.person_id%type,
228: p_contact_id ota_cert_enrollments.contact_id%type)
229: return ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type;
230:
231: function get_cert_prd_enroll_id(p_event_id IN ota_events.event_id%type,
232: p_person_id IN ota_cert_enrollments.person_id%type,

Line 232: p_person_id IN ota_cert_enrollments.person_id%type,

228: p_contact_id ota_cert_enrollments.contact_id%type)
229: return ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type;
230:
231: function get_cert_prd_enroll_id(p_event_id IN ota_events.event_id%type,
232: p_person_id IN ota_cert_enrollments.person_id%type,
233: p_contact_id ota_cert_enrollments.contact_id%type)
234: return ota_cert_prd_enrollments.cert_prd_enrollment_id%type;
235: END OTA_CME_UTIL;

Line 233: p_contact_id ota_cert_enrollments.contact_id%type)

229: return ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type;
230:
231: function get_cert_prd_enroll_id(p_event_id IN ota_events.event_id%type,
232: p_person_id IN ota_cert_enrollments.person_id%type,
233: p_contact_id ota_cert_enrollments.contact_id%type)
234: return ota_cert_prd_enrollments.cert_prd_enrollment_id%type;
235: END OTA_CME_UTIL;