APPS.OTA_BULK_ENROLL_UTIL dependencies on OTA_CERT_ENROLLMENTS

Line 45: FROM ota_cert_enrollments cre,

41: SELECT cre.certification_status_code status_code,
42: lkp.meaning Status_meaning,
43: decode(cre.certification_status_code, 'REJECTED', 0, 'EXPIRED', 1, 'AWAITING_APPROVAL',2,
44: 'CERTIFIED' , 3, 'CONCLUDED', 4,'ENROLLED',5) cert_status_number
45: FROM ota_cert_enrollments cre,
46: hr_lookups lkp
47: WHERE cre.certification_id = p_object_id
48: AND cre.person_id = p_learner_id
49: AND lkp.lookup_code =cre.certification_status_code

Line 353: FROM ota_cert_enrollments crt

349: AND path_status_code <> 'CANCELLED';
350:
351: CURSOR csr_get_cert_enrollments IS
352: SELECT count(cert_enrollment_id)
353: FROM ota_cert_enrollments crt
354: WHERE certification_id = p_object_id
355: --TBD: Confirm if this is correct
356: AND CERTIFICATION_STATUS_CODE <> 'CANCELLED';
357:

Line 1458: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE;

1454: IS
1455:
1456: l_request_rec csr_get_request_info%ROWTYPE;
1457: l_req_member_rec csr_get_request_members%ROWTYPE;
1458: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE;
1459: l_error_message ota_bulk_enr_req_members.error_message%TYPE;
1460: l_person_name per_all_people_f.full_name%TYPE;
1461: l_certification_status_code ota_cert_enrollments.CERTIFICATION_STATUS_CODE%TYPE;
1462:

Line 1461: l_certification_status_code ota_cert_enrollments.CERTIFICATION_STATUS_CODE%TYPE;

1457: l_req_member_rec csr_get_request_members%ROWTYPE;
1458: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE;
1459: l_error_message ota_bulk_enr_req_members.error_message%TYPE;
1460: l_person_name per_all_people_f.full_name%TYPE;
1461: l_certification_status_code ota_cert_enrollments.CERTIFICATION_STATUS_CODE%TYPE;
1462:
1463:
1464: BEGIN
1465: OPEN csr_get_request_info(p_enr_request_id);