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_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 1383: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE;

1379: l_request_rec csr_get_request_info%ROWTYPE;
1380: l_req_member_rec csr_get_request_members%ROWTYPE;
1381: l_error_message ota_bulk_enr_req_members.error_message%TYPE;
1382: l_person_name per_all_people_f.full_name%TYPE;
1383: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE;
1384: l_path_status_code ota_lp_enrollments.path_status_code%TYPE;
1385: l_return_status varchar2(30);
1386:
1387:

Line 1384: l_path_status_code ota_lp_enrollments.path_status_code%TYPE;

1380: l_req_member_rec csr_get_request_members%ROWTYPE;
1381: l_error_message ota_bulk_enr_req_members.error_message%TYPE;
1382: l_person_name per_all_people_f.full_name%TYPE;
1383: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE;
1384: l_path_status_code ota_lp_enrollments.path_status_code%TYPE;
1385: l_return_status varchar2(30);
1386:
1387:
1388: BEGIN

Line 1695: ota_lp_enrollments lpe

1691: CURSOR csr_check_lp_enr_exists(l_person_id in NUMBER,l_lp_id in NUMBER) IS
1692: SELECT
1693: lpe.lp_enrollment_id
1694: from
1695: ota_lp_enrollments lpe
1696: where lpe.learning_path_id= l_lp_id
1697: AND lpe.person_id = l_person_id
1698: AND lpe.path_status_code <> 'CANCELLED';
1699:

Line 1717: ota_lp_enrollments lpe,

1713: CURSOR csr_get_lp_member_to_upd(l_person_id in NUMBER,l_lp_id in NUMBER,l_event_id in NUMBER) IS
1714: SELECT
1715: lme.lp_member_enrollment_id
1716: from
1717: ota_lp_enrollments lpe,
1718: ota_lp_member_enrollments lme,
1719: OTA_LEARNING_PATH_MEMBERS lpm,
1720: ota_events evt
1721: where lpe.learning_path_id= l_lp_id