[Home] [Help]
155: cre.earliest_enroll_date,
156: cpe.expiration_date,
157: crt.start_date_active,
158: crt.end_date_active
159: FROM ota_certifications_b crt
160: ,ota_certifications_tl ctl
161: ,ota_cert_enrollments cre
162: ,ota_cert_prd_enrollments cpe
163: ,hr_lookups cpe_lkp
239: cre.earliest_enroll_date,
240: cpe.expiration_date,
241: crt.start_date_active,
242: crt.end_date_active
243: FROM ota_certifications_b crt
244: ,ota_certifications_tl ctl
245: ,ota_cert_enrollments cre
246: ,ota_cert_prd_enrollments cpe
247: ,hr_lookups cpe_lkp
338: cre.earliest_enroll_date,
339: cpe.expiration_date,
340: crt.start_date_active,
341: crt.end_date_active
342: FROM ota_certifications_b crt
343: ,ota_certifications_tl ctl
344: ,ota_cert_enrollments cre
345: ,ota_cert_prd_enrollments cpe
346: ,hr_lookups cpe_lkp
396: CLOSE get_certification;
397: p_certification_tbl := l_certification_tbl;
398: END get_certifications;
399:
400: PROCEDURE get_certification_description(p_certification_id IN ota_certifications_b.certification_id%TYPE,
401: p_cert_enrollment_id IN ota_cert_enrollments.cert_enrollment_id%TYPE,
402: p_cert_prd_enrollment_id IN ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
403: p_certification_desc_rec OUT NOCOPY cert_description_rectype)
404: IS
423: , tl.purpose Purpose
424: , tl.keywords Keywords
425: , INITIAL_PERIOD_COMMENTS
426: , tl.RENEWAL_PERIOD_COMMENTS
427: from ota_certifications_b b,
428: ota_certifications_tl tl
429: where
430: b.certification_id = tl.certification_id
431: --and b.business_group_id = ota_general.get_business_group_id
501: p_certification_desc_rec := l_certification_desc_rec;
502:
503: END get_certification_description;
504:
505: PROCEDURE get_cert_competencies(p_certification_id IN ota_certifications_b.certification_id%TYPE,
506: p_competencies_tbl OUT NOCOPY cert_competencies_tabletype)
507: IS
508: CURSOR get_competencies IS
509: SELECT comp.competence_id Competence_Id,