eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OTA_CME_UTIL dependencies on OTA_CERT_MBR_ENROLLMENTS

Line 139: (p_cert_mbr_enrollment_id IN ota_cert_mbr_enrollments.cert_mbr_enrollment_id%TYPE

135: --
136: -- {End Of Comments}
137: -- ---------------------------------------------------------------------------
138: Procedure Update_cpe_status
139: (p_cert_mbr_enrollment_id IN ota_cert_mbr_enrollments.cert_mbr_enrollment_id%TYPE
140: ,p_cert_prd_enrollment_id OUT NOCOPY varchar2
141: ,p_completion_date in date default sysdate);
142:
143: -- ---------------------------------------------------------------------------

Line 169: PROCEDURE update_cme_status (p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type);

165: -- Internal Development Use Only.
166: --
167: -- {End Of Comments}
168: -- ---------------------------------------------------------------------------
169: PROCEDURE update_cme_status (p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type);
170:
171: -- ---------------------------------------------------------------------------
172: -- |----------------------< chk_if_cme_exists >-------------------|
173: -- ---------------------------------------------------------------------------

Line 221: procedure refresh_cme(p_cert_prd_enrollment_id in ota_cert_mbr_enrollments.cert_prd_enrollment_id%type);

217: -- Access Status:
218: --
219: -- {End Of Comments}
220: -- ---------------------------------------------------------------------------
221: procedure refresh_cme(p_cert_prd_enrollment_id in ota_cert_mbr_enrollments.cert_prd_enrollment_id%type);
222:
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:

Line 223: Function chk_active_cme_enrl(p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)

219: -- {End Of Comments}
220: -- ---------------------------------------------------------------------------
221: procedure refresh_cme(p_cert_prd_enrollment_id in ota_cert_mbr_enrollments.cert_prd_enrollment_id%type);
222:
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,

Line 229: return ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type;

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,
233: p_contact_id ota_cert_enrollments.contact_id%type)