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 1201: DELETE FROM OTA_BULK_ENR_REQ_MEMBERS

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

Line 1253: FROM ota_bulk_enr_req_members

1249: WHERE person_id = p_person_id;
1250:
1251: CURSOR csr_get_error_learners IS
1252: SELECT COUNT(person_id)
1253: FROM ota_bulk_enr_req_members
1254: WHERE bulk_enr_request_id = p_enr_request_id
1255: and error_message IS NOT NULL;
1256:
1257: CURSOR csr_get_selected_learners IS

Line 1259: FROM ota_bulk_enr_req_members

1255: and error_message IS NOT NULL;
1256:
1257: CURSOR csr_get_selected_learners IS
1258: SELECT COUNT(person_id)
1259: FROM ota_bulk_enr_req_members
1260: WHERE bulk_enr_request_id = p_enr_request_id;
1261:
1262: CURSOR csr_get_successful_learners IS
1263: SELECT COUNT(person_id)

Line 1264: FROM ota_bulk_enr_req_members

1260: WHERE bulk_enr_request_id = p_enr_request_id;
1261:
1262: CURSOR csr_get_successful_learners IS
1263: SELECT COUNT(person_id)
1264: FROM ota_bulk_enr_req_members
1265: WHERE bulk_enr_request_id = p_enr_request_id
1266: and enrollment_status IS NOT NULL;
1267:
1268: l_object_name VARCHAR2(240);

Line 1381: l_error_message ota_bulk_enr_req_members.error_message%TYPE;

1377: IS
1378:
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);

Line 1425: UPDATE ota_bulk_enr_req_members

1421: l_error_message := fnd_message.get;
1422: fnd_message.clear;
1423: l_error_message := nvl(l_error_message,'Error When creating Learning Path subscription ');
1424: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
1425: UPDATE ota_bulk_enr_req_members
1426: SET error_message = l_error_message, enrollment_status = NULL
1427: WHERE person_id = l_req_member_rec.person_id
1428: AND bulk_enr_request_id = p_enr_request_id;
1429: END;

Line 1435: UPDATE ota_bulk_enr_req_members

1431: IF l_lp_enrollment_id IS NOT NULL THEN
1432: FND_FILE.PUT_LINE(FND_FILE.LOG,'Subscription Status - '
1433: || ota_utility.get_lookup_meaning('OTA_LEARNING_PATH_STATUS',l_path_status_code, 810));
1434: -- update lpe status to bulk_enr_req_members table
1435: UPDATE ota_bulk_enr_req_members
1436: SET enrollment_status = l_path_status_code, error_message = NULL
1437: WHERE person_id = l_req_member_rec.person_id
1438: AND bulk_enr_request_id = p_enr_request_id;
1439: END IF;

Line 1459: l_error_message ota_bulk_enr_req_members.error_message%TYPE;

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:
1463:

Line 1500: UPDATE ota_bulk_enr_req_members

1496: l_error_message := fnd_message.get;
1497: fnd_message.clear;
1498: l_error_message := nvl(l_error_message,'Error When creating Certification subscription ');
1499: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
1500: UPDATE ota_bulk_enr_req_members
1501: SET error_message = l_error_message, enrollment_status = NULL
1502: WHERE person_id = l_req_member_rec.person_id
1503: AND bulk_enr_request_id = p_enr_request_id;
1504: END;

Line 1510: UPDATE ota_bulk_enr_req_members

1506: IF l_cert_enrollment_id IS NOT NULL THEN
1507: FND_FILE.PUT_LINE(FND_FILE.LOG,'Subscription Status - '
1508: || ota_utility.get_lookup_meaning('OTA_CERT_ENROLL_STATUS',l_certification_status_code, 810));
1509: -- update lpe status to bulk_enr_req_members table
1510: UPDATE ota_bulk_enr_req_members
1511: SET enrollment_status = l_certification_status_code, error_message = NULL
1512: WHERE person_id = l_req_member_rec.person_id
1513: AND bulk_enr_request_id = p_enr_request_id;
1514: END IF;

Line 1560: l_error_message ota_bulk_enr_req_members.error_message%TYPE;

1556: and nvl(pcaf.effective_end_date,sysdate+1)
1557: AND trunc(sysdate) between nvl(assg.effective_start_date,trunc(sysdate))
1558: and nvl(assg.effective_end_date,trunc(sysdate+1));
1559:
1560: l_error_message ota_bulk_enr_req_members.error_message%TYPE;
1561: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%TYPE;
1562: l_booking_status ota_booking_status_types_tl.name%TYPE;
1563:
1564: l_request_rec csr_get_request_info%ROWTYPE;

Line 1615: UPDATE ota_bulk_enr_req_members

1611: ,p_override_prerequisites => 'Y');
1612: EXCEPTION
1613: WHEN OTHERS THEN
1614: l_error_message := nvl(substr(SQLERRM,1,2000),'Error When creating Enrollment ');
1615: UPDATE ota_bulk_enr_req_members
1616: SET error_message = l_error_message, enrollment_status = NULL
1617: WHERE person_id = l_req_member_rec.person_id
1618: AND bulk_enr_request_id = p_enr_request_id;
1619: END;

Line 1629: UPDATE ota_bulk_enr_req_members

1625: CLOSE csr_get_booking_status_id;
1626:
1627: FND_FILE.PUT_LINE(FND_FILE.LOG,'Enrollment Status - ' || l_booking_status);
1628:
1629: UPDATE ota_bulk_enr_req_members
1630: SET enrollment_status = l_booking_status_type_id, error_message = NULL
1631: WHERE person_id = l_req_member_rec.person_id
1632: AND assignment_id = l_req_member_rec.assignment_id
1633: AND bulk_enr_request_id = p_enr_request_id;

Line 1637: UPDATE ota_bulk_enr_req_members

1633: AND bulk_enr_request_id = p_enr_request_id;
1634: ELSE
1635: l_error_message := nvl(substr(l_error_message,1,2000),'Error When creating Enrollment ');
1636: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
1637: UPDATE ota_bulk_enr_req_members
1638: SET error_message = l_error_message, enrollment_status = NULL
1639: WHERE person_id = l_req_member_rec.person_id
1640: AND bulk_enr_request_id = p_enr_request_id;
1641: END IF;

Line 1705: ota_bulk_enr_req_members berm

1701: SELECT
1702: berm.bulk_enr_request_id
1703: from
1704: ota_bulk_enr_requests ber,
1705: ota_bulk_enr_req_members berm
1706: where berm.bulk_enr_request_id = ber.bulk_enr_request_id
1707: AND ber.conc_program_request_id = l_conc_req_id
1708: AND ber.object_id = l_lp_id
1709: AND berm.person_id = l_person_id

Line 1730: l_error_message ota_bulk_enr_req_members.error_message%TYPE;

1726: and evt.activity_version_id=lpm.activity_version_id
1727: AND lme.learning_path_member_id=lpm.learning_path_member_id
1728: AND lpe.learning_path_id= lpm.learning_path_id;
1729:
1730: l_error_message ota_bulk_enr_req_members.error_message%TYPE;
1731: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%TYPE;
1732: l_booking_status ota_booking_status_types_tl.name%TYPE;
1733:
1734: l_request_rec csr_get_request_info%ROWTYPE;

Line 1836: UPDATE ota_bulk_enr_req_members

1832: l_error_message := fnd_message.get();
1833:
1834:
1835: -- l_error_message := nvl(substr(SQLERRM,1,2000),'Error When creating Enrollment ');
1836: UPDATE ota_bulk_enr_req_members
1837: SET error_message = l_error_message, enrollment_status = NULL
1838: WHERE person_id = l_req_member_rec.person_id
1839: AND bulk_enr_request_id = p_enr_request_id;
1840:

Line 1873: UPDATE ota_bulk_enr_req_members

1869: end if;--l_request_rec.object_type = 'LPCL' and l_existing_booking_id is NOT NULL then
1870: EXCEPTION
1871: WHEN OTHERS THEN
1872: l_error_message := nvl(substr(SQLERRM,1,2000),'Error When creating Enrollment ');
1873: UPDATE ota_bulk_enr_req_members
1874: SET error_message = l_error_message, enrollment_status = NULL
1875: WHERE person_id = l_req_member_rec.person_id
1876: AND bulk_enr_request_id = p_enr_request_id;
1877: END;

Line 1887: UPDATE ota_bulk_enr_req_members

1883: CLOSE csr_get_booking_status_id;
1884:
1885: FND_FILE.PUT_LINE(FND_FILE.LOG,'Enrollment Status - ' || l_booking_status);
1886:
1887: UPDATE ota_bulk_enr_req_members
1888: SET enrollment_status = l_booking_status_type_id, error_message = NULL
1889: WHERE person_id = l_req_member_rec.person_id
1890: AND assignment_id = l_req_member_rec.assignment_id
1891: AND bulk_enr_request_id = p_enr_request_id;

Line 1904: UPDATE ota_bulk_enr_req_members

1900:
1901: ELSE
1902: l_error_message := nvl(substr(l_error_message,1,2000),'Error When creating Enrollment ');
1903: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
1904: UPDATE ota_bulk_enr_req_members
1905: SET error_message = l_error_message, enrollment_status = NULL
1906: WHERE person_id = l_req_member_rec.person_id
1907: AND bulk_enr_request_id = p_enr_request_id;
1908: END IF;

Line 1953: FROM ota_bulk_enr_req_members

1949:
1950: IF l_threshold IS NULL THEN l_threshold := 0; END IF;
1951: SELECT count(person_id)
1952: INTO l_learners_selected
1953: FROM ota_bulk_enr_req_members
1954: WHERE bulk_enr_request_id = p_enr_request_id;
1955:
1956: IF l_threshold >= l_learners_selected THEN
1957: -- No concurrent processing required

Line 2198: l_error_message ota_bulk_enr_req_members.error_message%TYPE;

2194: fln.object_version_number object_version_number
2195: FROM ota_finance_lines fln
2196: WHERE fln.booking_id = p_booking_id;
2197:
2198: l_error_message ota_bulk_enr_req_members.error_message%TYPE;
2199: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%TYPE;
2200: l_booking_status ota_booking_status_types_tl.name%TYPE;
2201: l_object_version_number ota_delegate_bookings.object_version_number%TYPE;
2202: l_request_rec csr_get_request_info%ROWTYPE;

Line 2272: UPDATE ota_bulk_enr_req_members

2268:
2269: EXCEPTION
2270: WHEN OTHERS THEN
2271: l_error_message := nvl(substr(SQLERRM,1,2000),'Error When creating Enrollment ');
2272: UPDATE ota_bulk_enr_req_members
2273: SET error_message = l_error_message
2274: WHERE person_id = l_req_member_rec.person_id
2275: AND bulk_enr_request_id = p_enr_request_id;
2276: END;

Line 2287: UPDATE ota_bulk_enr_req_members

2283: if(p_debug = 'Y') then
2284: FND_FILE.PUT_LINE(FND_FILE.LOG,'Enrollment Status - ' || l_booking_status);
2285: end if;
2286:
2287: UPDATE ota_bulk_enr_req_members
2288: SET enrollment_status = l_booking_status_type_id, error_message = NULL
2289: WHERE person_id = l_req_member_rec.person_id
2290: AND assignment_id = l_req_member_rec.assignment_id
2291: AND bulk_enr_request_id = p_enr_request_id;

Line 2299: UPDATE ota_bulk_enr_req_members

2295: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
2296: FND_FILE.PUT_LINE(FND_FILE.LOG,'Learner Name - ' || l_person_name);
2297: l_error_message := fnd_message.get;
2298: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR - ' || l_error_message);
2299: UPDATE ota_bulk_enr_req_members
2300: SET error_message = l_error_message
2301: WHERE person_id = l_req_member_rec.person_id
2302: AND bulk_enr_request_id = p_enr_request_id;
2303: END IF;