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.

APPS.OTA_CERT_MBR_ENROLLMENT_API dependencies on OTA_CERT_PRD_ENROLLMENTS

Line 286: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_enrollment_id%TYPE := p_cert_prd_enrollment_id;

282:
283: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE := p_member_status_code;
284: l_completion_date ota_cert_mbr_enrollments.completion_date%TYPE := p_completion_date;
285: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
286: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_enrollment_id%TYPE := p_cert_prd_enrollment_id;
287:
288: CURSOR csr_get_course_id IS
289: SELECT cmb.object_id,
290: cpe.cert_prd_enrollment_id

Line 293: ota_cert_prd_enrollments cpe

289: SELECT cmb.object_id,
290: cpe.cert_prd_enrollment_id
291: FROM ota_certification_members cmb,
292: ota_cert_mbr_enrollments cme,
293: ota_cert_prd_enrollments cpe
294: WHERE cme.cert_mbr_enrollment_id = p_cert_mbr_enrollment_id
295: AND cpe.cert_prd_enrollment_id = cme.cert_prd_enrollment_id
296: AND cme.cert_member_id = cmb.certification_member_id;
297: