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_BULK_ENR_REQ_MEMBERS

Line 202: FROM ota_bulk_enr_req_members

198: RETURN NUMBER
199: IS
200: CURSOR csr_get_number_of_learners IS
201: SELECT count(bulk_enr_request_id)
202: FROM ota_bulk_enr_req_members
203: WHERE bulk_enr_request_id = p_bulk_enr_request_id;
204:
205: l_total_enr_requested NUMBER := 0;
206: BEGIN

Line 221: FROM ota_bulk_enr_req_members brm,

217: ,p_unfulfil_comp_prereqs OUT NOCOPY NUMBER)
218: IS
219: CURSOR get_unfulfil_crs_prereq IS
220: SELECT count(person_id)
221: FROM ota_bulk_enr_req_members brm,
222: ota_bulk_enr_requests ber,
223: ota_events evt
224: WHERE ber.bulk_enr_request_id = brm.bulk_enr_request_id
225: AND ber.bulk_enr_request_id = p_bulk_enr_request_id

Line 236: FROM ota_bulk_enr_req_members brm,

232: , evt.activity_version_id) = 'N';
233:
234: CURSOR get_unfulfil_comp_prereqs IS
235: SELECT count(person_id)
236: FROM ota_bulk_enr_req_members brm,
237: ota_bulk_enr_requests ber,
238: ota_events evt
239: WHERE ber.bulk_enr_request_id = brm.bulk_enr_request_id
240: AND ber.bulk_enr_request_id = p_bulk_enr_request_id

Line 304: FROM ota_bulk_enr_req_members

300: IS
301:
302: CURSOR get_success_enrollments IS
303: SELECT count(person_id)
304: FROM ota_bulk_enr_req_members
305: WHERE bulk_enr_request_id = p_bulk_enr_request_id
306: AND enrollment_status IS NOT NULL;
307:
308: CURSOR get_errored_enrollments IS

Line 310: FROM ota_bulk_enr_req_members

306: AND enrollment_status IS NOT NULL;
307:
308: CURSOR get_errored_enrollments IS
309: SELECT count(person_id)
310: FROM ota_bulk_enr_req_members
311: WHERE bulk_enr_request_id = p_bulk_enr_request_id
312: AND error_message IS NOT NULL;
313: BEGIN
314: get_enr_request_info(

Line 1198: DELETE FROM OTA_BULK_ENR_REQ_MEMBERS

1194: itemkey => itemkey,
1195: aname =>'BLK_ENR_REQUEST_ID',
1196: ignore_notfound => true);
1197:
1198: DELETE FROM OTA_BULK_ENR_REQ_MEMBERS
1199: WHERE BULK_ENR_REQUEST_ID = l_blk_enr_request_id;
1200:
1201: DELETE FROM OTA_BULK_ENR_REQUESTS
1202: WHERE BULK_ENR_REQUEST_ID = l_blk_enr_request_id;

Line 1249: FROM ota_bulk_enr_req_members

1245: WHERE person_id = p_person_id;
1246:
1247: CURSOR csr_get_error_learners IS
1248: SELECT COUNT(person_id)
1249: FROM ota_bulk_enr_req_members
1250: WHERE bulk_enr_request_id = p_enr_request_id
1251: and error_message IS NOT NULL;
1252:
1253: CURSOR csr_get_selected_learners IS

Line 1255: FROM ota_bulk_enr_req_members

1251: and error_message IS NOT NULL;
1252:
1253: CURSOR csr_get_selected_learners IS
1254: SELECT COUNT(person_id)
1255: FROM ota_bulk_enr_req_members
1256: WHERE bulk_enr_request_id = p_enr_request_id;
1257:
1258: CURSOR csr_get_successful_learners IS
1259: SELECT COUNT(person_id)

Line 1260: FROM ota_bulk_enr_req_members

1256: WHERE bulk_enr_request_id = p_enr_request_id;
1257:
1258: CURSOR csr_get_successful_learners IS
1259: SELECT COUNT(person_id)
1260: FROM ota_bulk_enr_req_members
1261: WHERE bulk_enr_request_id = p_enr_request_id
1262: and enrollment_status IS NOT NULL;
1263:
1264: l_object_name VARCHAR2(240);

Line 1375: l_error_message ota_bulk_enr_req_members.error_message%TYPE;

1371: IS
1372:
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);

Line 1419: UPDATE ota_bulk_enr_req_members

1415: l_error_message := fnd_message.get;
1416: fnd_message.clear;
1417: l_error_message := nvl(l_error_message,'Error When creating Learning Path subscription ');
1418: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
1419: UPDATE ota_bulk_enr_req_members
1420: SET error_message = l_error_message, enrollment_status = NULL
1421: WHERE person_id = l_req_member_rec.person_id
1422: AND bulk_enr_request_id = p_enr_request_id;
1423: END;

Line 1429: UPDATE ota_bulk_enr_req_members

1425: IF l_lp_enrollment_id IS NOT NULL THEN
1426: FND_FILE.PUT_LINE(FND_FILE.LOG,'Subscription Status - '
1427: || ota_utility.get_lookup_meaning('OTA_LEARNING_PATH_STATUS',l_path_status_code, 810));
1428: -- update lpe status to bulk_enr_req_members table
1429: UPDATE ota_bulk_enr_req_members
1430: SET enrollment_status = l_path_status_code, error_message = NULL
1431: WHERE person_id = l_req_member_rec.person_id
1432: AND bulk_enr_request_id = p_enr_request_id;
1433: END IF;

Line 1453: l_error_message ota_bulk_enr_req_members.error_message%TYPE;

1449:
1450: l_request_rec csr_get_request_info%ROWTYPE;
1451: l_req_member_rec csr_get_request_members%ROWTYPE;
1452: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE;
1453: l_error_message ota_bulk_enr_req_members.error_message%TYPE;
1454: l_person_name per_all_people_f.full_name%TYPE;
1455: l_certification_status_code ota_cert_enrollments.CERTIFICATION_STATUS_CODE%TYPE;
1456:
1457:

Line 1494: UPDATE ota_bulk_enr_req_members

1490: l_error_message := fnd_message.get;
1491: fnd_message.clear;
1492: l_error_message := nvl(l_error_message,'Error When creating Certification subscription ');
1493: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
1494: UPDATE ota_bulk_enr_req_members
1495: SET error_message = l_error_message, enrollment_status = NULL
1496: WHERE person_id = l_req_member_rec.person_id
1497: AND bulk_enr_request_id = p_enr_request_id;
1498: END;

Line 1504: UPDATE ota_bulk_enr_req_members

1500: IF l_cert_enrollment_id IS NOT NULL THEN
1501: FND_FILE.PUT_LINE(FND_FILE.LOG,'Subscription Status - '
1502: || ota_utility.get_lookup_meaning('OTA_CERT_ENROLL_STATUS',l_certification_status_code, 810));
1503: -- update lpe status to bulk_enr_req_members table
1504: UPDATE ota_bulk_enr_req_members
1505: SET enrollment_status = l_certification_status_code, error_message = NULL
1506: WHERE person_id = l_req_member_rec.person_id
1507: AND bulk_enr_request_id = p_enr_request_id;
1508: END IF;

Line 1552: l_error_message ota_bulk_enr_req_members.error_message%TYPE;

1548: and nvl(pcaf.effective_end_date,sysdate+1)
1549: AND trunc(sysdate) between nvl(assg.effective_start_date,trunc(sysdate))
1550: and nvl(assg.effective_end_date,trunc(sysdate+1));
1551:
1552: l_error_message ota_bulk_enr_req_members.error_message%TYPE;
1553: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%TYPE;
1554: l_booking_status ota_booking_status_types_tl.name%TYPE;
1555:
1556: l_request_rec csr_get_request_info%ROWTYPE;

Line 1607: UPDATE ota_bulk_enr_req_members

1603: ,p_override_prerequisites => 'Y');
1604: EXCEPTION
1605: WHEN OTHERS THEN
1606: l_error_message := nvl(substr(SQLERRM,1,2000),'Error When creating Enrollment ');
1607: UPDATE ota_bulk_enr_req_members
1608: SET error_message = l_error_message, enrollment_status = NULL
1609: WHERE person_id = l_req_member_rec.person_id
1610: AND bulk_enr_request_id = p_enr_request_id;
1611: END;

Line 1621: UPDATE ota_bulk_enr_req_members

1617: CLOSE csr_get_booking_status_id;
1618:
1619: FND_FILE.PUT_LINE(FND_FILE.LOG,'Enrollment Status - ' || l_booking_status);
1620:
1621: UPDATE ota_bulk_enr_req_members
1622: SET enrollment_status = l_booking_status_type_id, error_message = NULL
1623: WHERE person_id = l_req_member_rec.person_id
1624: AND assignment_id = l_req_member_rec.assignment_id
1625: AND bulk_enr_request_id = p_enr_request_id;

Line 1629: UPDATE ota_bulk_enr_req_members

1625: AND bulk_enr_request_id = p_enr_request_id;
1626: ELSE
1627: l_error_message := nvl(substr(l_error_message,1,2000),'Error When creating Enrollment ');
1628: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
1629: UPDATE ota_bulk_enr_req_members
1630: SET error_message = l_error_message, enrollment_status = NULL
1631: WHERE person_id = l_req_member_rec.person_id
1632: AND bulk_enr_request_id = p_enr_request_id;
1633: END IF;

Line 1659: FROM ota_bulk_enr_req_members

1655:
1656: IF l_threshold IS NULL THEN l_threshold := 0; END IF;
1657: SELECT count(person_id)
1658: INTO l_learners_selected
1659: FROM ota_bulk_enr_req_members
1660: WHERE bulk_enr_request_id = p_enr_request_id;
1661:
1662: OPEN csr_get_request_info(p_enr_request_id);
1663: FETCH csr_get_request_info INTO l_request_rec;