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_LRNG_PATH_MEMBER_UTIL dependencies on OTA_EVENTS

Line 26: ota_events evt,

22: SELECT DECODE(bst.type,'C','Z',bst.type) status,
23: bst.name
24: FROM ota_learning_path_members lpm,
25: ota_lp_member_enrollments lme,
26: ota_events evt,
27: ota_delegate_bookings tdb,
28: ota_booking_status_types_vl bst
29: WHERE lpm.activity_version_id = evt.activity_version_id
30: AND evt.event_id = tdb.event_id

Line 43: FROM ota_events evt,

39:
40: CURSOR csr_act_enr IS
41: SELECT DECODE(bst.type,'C','Z',bst.type) status,
42: bst.name
43: FROM ota_events evt,
44: ota_delegate_bookings tdb,
45: ota_booking_status_types_vl bst
46: WHERE evt.event_id = tdb.event_id
47: AND bst.booking_status_type_id = tdb.booking_status_type_id

Line 114: ota_events evt,

110: tdb.date_status_changed,
111: tdb.successful_attendance_flag
112: FROM ota_learning_path_members lpm,
113: ota_lp_member_enrollments lme,
114: ota_events evt,
115: ota_delegate_bookings tdb,
116: ota_booking_status_types bst
117: WHERE lpm.activity_version_id = evt.activity_version_id
118: AND evt.event_id = tdb.event_id

Line 131: FROM ota_events evt,

127: CURSOR csr_act_enr IS
128: SELECT DECODE(bst.type,'C','Z',bst.type) status,
129: tdb.date_status_changed,
130: tdb.successful_attendance_flag
131: FROM ota_events evt,
132: ota_delegate_bookings tdb,
133: ota_booking_status_types_vl bst
134: WHERE evt.event_id = tdb.event_id
135: AND bst.booking_status_type_id = tdb.booking_status_type_id

Line 186: FROM ota_events e,

182: RETURN boolean
183: IS
184: CURSOR chk_enr IS
185: SELECT NULL
186: FROM ota_events e,
187: ota_activity_versions a,
188: ota_delegate_bookings b,
189: ota_booking_status_types s,
190: ota_learning_path_members lpm

Line 421: PROCEDURE update_lme_enroll_status_chg (p_event_id IN ota_events.event_id%TYPE,

417:
418: -- ---------------------------------------------------------------------------
419: -- |----------------------< update_lme_enroll_status_chg >--------------------------|
420: -- ---------------------------------------------------------------------------
421: PROCEDURE update_lme_enroll_status_chg (p_event_id IN ota_events.event_id%TYPE,
422: p_person_id IN ota_lp_enrollments.person_id%TYPE,
423: p_contact_id IN ota_lp_enrollments.contact_id%TYPE,
424: p_lp_enrollment_ids OUT NOCOPY varchar2)
425: IS

Line 432: FROM ota_events

428:
429:
430: CURSOR evt_det IS
431: SELECT activity_version_id
432: FROM ota_events
433: WHERE event_id = p_event_id;
434:
435: --get all the lpms which have the passed event as a component
436: CURSOR csr_lpm_info(csr_activity_version_id number) IS

Line 472: l_event_id ota_events.event_id%TYPE;

468: --variables to store old values
469: l_old_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;
470: l_old_mandatory_courses ota_lp_enrollments.no_of_mandatory_courses%TYPE;
471: l_old_member_status ota_lp_member_enrollments.member_status_code%TYPE;
472: l_event_id ota_events.event_id%TYPE;
473: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
474:
475: BEGIN
476:

Line 1348: FUNCTION get_class_completion_date(p_event_id IN ota_events.event_id%type,

1344:
1345: hr_utility.set_location(' Leaving:'||l_proc, 90);
1346: END chk_no_of_mandatory_courses;
1347:
1348: FUNCTION get_class_completion_date(p_event_id IN ota_events.event_id%type,
1349: p_person_id IN NUMBER,
1350: p_contact_id IN ota_attempts.user_type%type)
1351: RETURN DATE IS
1352:

Line 1356: FROM ota_events oev,

1352:
1353: CURSOR class_type IS
1354: SELECT ocu.synchronous_flag,
1355: ocu.online_flag
1356: FROM ota_events oev,
1357: ota_offerings ofr,
1358: ota_category_usages ocu
1359: WHERE oev.parent_offering_id = ofr.offering_id
1360: AND ocu.category_usage_Id = ofr.delivery_mode_id

Line 1363: CURSOR get_online_compl_date_p(p_event_id IN ota_events.event_id%type,

1359: WHERE oev.parent_offering_id = ofr.offering_id
1360: AND ocu.category_usage_Id = ofr.delivery_mode_id
1361: AND oev.event_id = p_event_id;
1362:
1363: CURSOR get_online_compl_date_p(p_event_id IN ota_events.event_id%type,
1364: p_user_id IN ota_attempts.user_id%type,
1365: p_user_type IN ota_attempts.user_type%type) IS
1366: SELECT ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), ocu.Online_Flag, ota_timezone_util.get_server_timezone_code) completion_date
1367: FROM ota_events oev,

Line 1367: FROM ota_events oev,

1363: CURSOR get_online_compl_date_p(p_event_id IN ota_events.event_id%type,
1364: p_user_id IN ota_attempts.user_id%type,
1365: p_user_type IN ota_attempts.user_type%type) IS
1366: SELECT ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), ocu.Online_Flag, ota_timezone_util.get_server_timezone_code) completion_date
1367: FROM ota_events oev,
1368: ota_offerings ofr,
1369: ota_performances opf,
1370: ota_category_usages ocu,
1371: ota_delegate_bookings odb,

Line 1385: CURSOR get_online_compl_date_c(p_event_id IN ota_events.event_id%type,

1381: AND obst.type = 'A'
1382: AND odb.delegate_person_id = p_person_id
1383: AND oev.event_id = odb.event_id;
1384:
1385: CURSOR get_online_compl_date_c(p_event_id IN ota_events.event_id%type,
1386: p_user_id IN ota_attempts.user_id%type,
1387: p_user_type IN ota_attempts.user_type%type) IS
1388: SELECT ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), ocu.Online_Flag, ota_timezone_util.get_server_timezone_code) completion_date
1389: FROM ota_events oev,

Line 1389: FROM ota_events oev,

1385: CURSOR get_online_compl_date_c(p_event_id IN ota_events.event_id%type,
1386: p_user_id IN ota_attempts.user_id%type,
1387: p_user_type IN ota_attempts.user_type%type) IS
1388: SELECT ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), ocu.Online_Flag, ota_timezone_util.get_server_timezone_code) completion_date
1389: FROM ota_events oev,
1390: ota_offerings ofr,
1391: ota_performances opf,
1392: ota_category_usages ocu,
1393: ota_delegate_bookings odb,

Line 1409: FROM ota_events oev,

1405: AND oev.event_id = odb.event_id;
1406:
1407: CURSOR get_offsync_class_compl_date_p IS
1408: SELECT to_date(to_char(nvl(oev.course_end_date,trunc(sysdate)),'YYYY/MM/DD') || ' ' || nvl(oev.course_end_time,'23:59'), 'YYYY MM/DD HH24:MI') event_end_date
1409: FROM ota_events oev,
1410: ota_delegate_bookings odb,
1411: ota_booking_status_types obst
1412: WHERE oev.event_id = p_event_id
1413: AND oev.event_id = odb.event_id

Line 1420: FROM ota_events oev,

1416: AND odb.delegate_person_id = p_person_id;
1417:
1418: CURSOR get_offsync_class_compl_date_c IS
1419: SELECT to_date(to_char(nvl(oev.course_end_date,trunc(sysdate)),'YYYY/MM/DD') || ' ' || nvl(oev.course_end_time,'23:59'), 'YYYY MM/DD HH24:MI') event_end_date
1420: FROM ota_events oev,
1421: ota_delegate_bookings odb,
1422: ota_booking_status_types obst
1423: WHERE oev.event_id = p_event_id
1424: AND oev.event_id = odb.event_id

Line 1514: ota_events oev

1510: CURSOR get_completion_date IS
1511: SELECT max(ota_lrng_path_member_util.get_class_completion_date(oev.event_id,lpe.person_id, lpe.contact_id)) completion_date
1512: FROM ota_lp_enrollments lpe,
1513: ota_learning_path_members lpm,
1514: ota_events oev
1515: WHERE lpe.learning_path_id = lpm.learning_path_id
1516: AND oev.activity_version_id = lpm.activity_version_id
1517: AND lpe.lp_enrollment_id = p_lp_enrollment_id;
1518:

Line 1543: ota_events oev

1539: SELECT max(ota_lrng_path_member_util.get_class_completion_date(oev.event_id,lpe.person_id, lpe.contact_id)) completion_date
1540: FROM ota_lp_enrollments lpe,
1541: ota_learning_path_members lpm,
1542: ota_lp_member_enrollments lpme,
1543: ota_events oev
1544: WHERE lpe.learning_path_id = lpm.learning_path_id
1545: AND oev.activity_version_id = lpm.activity_version_id
1546: AND lpe.lp_enrollment_id = lpme.lp_enrollment_id
1547: AND lpme.learning_path_member_id = lpm.learning_path_member_id

Line 1552: FROM ota_events oev

1548: AND lpme.lp_member_enrollment_id = p_lp_member_enrollment_id;
1549:
1550: CURSOR get_crs_completion_date IS
1551: SELECT max(ota_lrng_path_member_util.get_class_completion_date(oev.event_id,p_person_id, p_contact_id)) completion_date
1552: FROM ota_events oev
1553: WHERE oev.activity_version_id = p_activity_version_id;
1554:
1555: l_completion_date date := null;
1556: