APPS.OTA_BULK_ENROLL_UTIL dependencies on OTA_LP_ENROLLMENTS

Line 16: FROM ota_lp_enrollments lpe,

12: CURSOR get_lp_enr_status IS
13: SELECT lpe.path_status_code status_code,
14: lkp.meaning Status_meaning,
15: decode(lpe.path_status_code,'CANCELLED' , 0, 'ACTIVE',1, 'COMPLETED', 2) path_status_number
16: FROM ota_lp_enrollments lpe,
17: hr_lookups lkp
18: WHERE lpe.learning_path_id = p_object_id
19: AND lpe.person_id = p_learner_id
20: AND lkp.lookup_code = lpe.path_status_code

Line 347: FROM ota_lp_enrollments

343: AND bst.type NOT IN ('C');
344:
345: CURSOR csr_get_lp_enrollments IS
346: SELECT count(lp_enrollment_id)
347: FROM ota_lp_enrollments
348: WHERE learning_path_id = p_object_id
349: AND path_status_code <> 'CANCELLED';
350:
351: CURSOR csr_get_cert_enrollments IS

Line 1377: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE;

1373: l_request_rec csr_get_request_info%ROWTYPE;
1374: l_req_member_rec csr_get_request_members%ROWTYPE;
1375: l_error_message ota_bulk_enr_req_members.error_message%TYPE;
1376: l_person_name per_all_people_f.full_name%TYPE;
1377: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE;
1378: l_path_status_code ota_lp_enrollments.path_status_code%TYPE;
1379: l_return_status varchar2(30);
1380:
1381:

Line 1378: l_path_status_code ota_lp_enrollments.path_status_code%TYPE;

1374: l_req_member_rec csr_get_request_members%ROWTYPE;
1375: l_error_message ota_bulk_enr_req_members.error_message%TYPE;
1376: l_person_name per_all_people_f.full_name%TYPE;
1377: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE;
1378: l_path_status_code ota_lp_enrollments.path_status_code%TYPE;
1379: l_return_status varchar2(30);
1380:
1381:
1382: BEGIN