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_DELEGATE_BOOKINGS

Line 27: ota_delegate_bookings tdb,

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
31: AND bst.booking_status_type_id = tdb.booking_status_type_id

Line 44: ota_delegate_bookings tdb,

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
48: AND evt.activity_version_id = p_activity_version_id

Line 103: p_date_status_changed OUT NOCOPY ota_delegate_bookings.date_status_changed%TYPE,

99: p_contact_id IN ota_learning_paths.contact_id%TYPE,
100: p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE,
101: p_lp_member_enrollment_id IN ota_lp_member_enrollments.lp_member_enrollment_id%TYPE,
102: p_booking_status_type OUT NOCOPY ota_booking_status_types.type%TYPE,
103: p_date_status_changed OUT NOCOPY ota_delegate_bookings.date_status_changed%TYPE,
104: p_successful_attendance_flag OUT NOCOPY ota_delegate_bookings.successful_attendance_flag%TYPE)
105: IS
106:
107:

Line 104: p_successful_attendance_flag OUT NOCOPY ota_delegate_bookings.successful_attendance_flag%TYPE)

100: p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE,
101: p_lp_member_enrollment_id IN ota_lp_member_enrollments.lp_member_enrollment_id%TYPE,
102: p_booking_status_type OUT NOCOPY ota_booking_status_types.type%TYPE,
103: p_date_status_changed OUT NOCOPY ota_delegate_bookings.date_status_changed%TYPE,
104: p_successful_attendance_flag OUT NOCOPY ota_delegate_bookings.successful_attendance_flag%TYPE)
105: IS
106:
107:
108: CURSOR csr_lp_enr IS

Line 115: ota_delegate_bookings tdb,

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
119: AND bst.booking_status_type_id = tdb.booking_status_type_id

Line 132: ota_delegate_bookings tdb,

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
136: AND evt.activity_version_id = p_activity_version_id

Line 145: v_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

141:
142: l_proc VARCHAR2(72) := g_package|| 'get_enrollment_status';
143:
144: v_enroll_status VARCHAR2(30);
145: v_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
146: v_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
147: BEGIN
148:
149: hr_utility.set_location(' Step:'|| l_proc, 10);

Line 146: v_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;

142: l_proc VARCHAR2(72) := g_package|| 'get_enrollment_status';
143:
144: v_enroll_status VARCHAR2(30);
145: v_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
146: v_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
147: BEGIN
148:
149: hr_utility.set_location(' Step:'|| l_proc, 10);
150: IF p_lp_member_enrollment_id IS NOT NULL THEN

Line 188: ota_delegate_bookings b,

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
191: WHERE e.event_id = b.event_id
192: AND lpm.activity_version_id = a.activity_version_id

Line 237: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;

233: l_enroll_status VARCHAR2(30);
234: l_date_status_changed DATE;
235: l_person_id ota_learning_paths.person_id%TYPE;
236: l_contact_id ota_learning_paths.contact_id%TYPE;
237: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
238: BEGIN
239:
240: hr_utility.set_location('Entering:'|| l_proc, 10);
241:

Line 297: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;

293: l_member_status_code VARCHAR2(30);
294: l_date_status_changed DATE;
295: l_person_id ota_learning_paths.person_id%TYPE;
296: l_contact_id ota_learning_paths.contact_id%TYPE;
297: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;
298: BEGIN
299:
300: hr_utility.set_location('Entering:'|| l_proc, 10);
301:

Line 463: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

459: l_completion_type_code ota_lp_sections.completion_type_code%TYPE;
460: l_enroll_type ota_booking_status_types.type%TYPE;
461: l_member_status_code ota_lp_member_enrollments.member_status_code%TYPE;
462: l_completion_date ota_lp_enrollments.completion_date%TYPE;
463: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
464: l_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE := 0;
465: l_mandatory_courses ota_lp_enrollments.no_of_mandatory_courses%TYPE;
466: l_section_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE;
467:

Line 473: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%TYPE;

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

Line 1371: ota_delegate_bookings odb,

1367: FROM ota_events oev,
1368: ota_offerings ofr,
1369: ota_performances opf,
1370: ota_category_usages ocu,
1371: ota_delegate_bookings odb,
1372: ota_booking_status_types obst
1373: WHERE oev.parent_offering_id = ofr.offering_id
1374: AND ofr.learning_object_id = opf.learning_object_id
1375: AND ocu.category_usage_Id = ofr.delivery_mode_id

Line 1393: ota_delegate_bookings odb,

1389: FROM ota_events oev,
1390: ota_offerings ofr,
1391: ota_performances opf,
1392: ota_category_usages ocu,
1393: ota_delegate_bookings odb,
1394: ota_booking_status_types obst
1395: WHERE oev.parent_offering_id = ofr.offering_id
1396: AND ofr.learning_object_id = opf.learning_object_id
1397: AND ocu.category_usage_Id = ofr.delivery_mode_id

Line 1410: ota_delegate_bookings odb,

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
1414: AND odb.booking_status_type_id = obst.booking_status_type_id

Line 1421: ota_delegate_bookings odb,

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
1425: AND odb.booking_status_type_id = obst.booking_status_type_id

Line 1431: FROM ota_delegate_bookings odb,

1427: AND odb.delegate_contact_id = p_contact_id;
1428:
1429: CURSOR get_offasync_compl_date_p IS
1430: SELECT odb.date_status_changed
1431: FROM ota_delegate_bookings odb,
1432: ota_booking_status_types obst
1433: WHERE odb.booking_status_type_id = obst.booking_status_type_id
1434: AND obst.type = 'A'
1435: AND odb.delegate_person_id = p_person_id

Line 1440: FROM ota_delegate_bookings odb,

1436: AND odb.event_id = p_event_id;
1437:
1438: CURSOR get_offasync_compl_date_c IS
1439: SELECT odb.date_status_changed
1440: FROM ota_delegate_bookings odb,
1441: ota_booking_status_types obst
1442: WHERE odb.booking_status_type_id = obst.booking_status_type_id
1443: AND obst.type = 'A'
1444: AND odb.delegate_contact_id = p_contact_id