20: l_cert_id number(15);
21:
22: Cursor get_cert_details (crs_certification_id number)is
23: select ctl.name, ctb.initial_completion_date
24: from ota_Certifications_tl ctl , ota_Certifications_b ctb
25: where ctl.certification_id = ctb.certification_id
26: and ctl.Language= USERENV('LANG')
27: and ctl.certification_id =crs_certification_id;
28:
762: l_attribute20 ota_cert_enrollments.attribute1%type;
763:
764: Cursor get_cert_name (crs_certification_id number)is
765: select ctl.name
766: from ota_Certifications_tl ctl , ota_Certifications_b ctb
767: where ctl.certification_id = ctb.certification_id
768: and ctl.Language= USERENV('LANG')
769: and ctl.certification_id =crs_certification_id;
770: