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_MANDATORY_ENROLL_UTIL dependencies on OTA_CERTIFICATIONS_TL

Line 2246: l_cert_name ota_certifications_tl.name%type;

2242:
2243: l_rec auto_cert_subscr_rec;
2244: l_date ota_events.course_end_date%type;
2245: l_conc_request_id OTA_MAND_MULTI_ENR_REQUESTS.conc_program_request_id%type;
2246: l_cert_name ota_certifications_tl.name%type;
2247: l_chunk_size number := nvl(p_chunk_size,1000);
2248: l_threads number := nvl(p_thread_count,3);
2249: l_request_id number;
2250: l_person_name per_all_people_f.full_name%type;

Line 3136: l_certification_name ota_certifications_tl.name%type;

3132: l_req_member_rec csr_get_request_members%rowtype;
3133: l_person_name per_all_people_f.full_name%type;
3134: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE;
3135: l_certification_status_code ota_cert_enrollments.CERTIFICATION_STATUS_CODE%TYPE;
3136: l_certification_name ota_certifications_tl.name%type;
3137:
3138: l_proc varchar2(72) := g_package||'create_cert_subscriptions';
3139:
3140: BEGIN