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_BOOKING_STATUS_TYPES

Line 28: ota_booking_status_types_vl bst

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
32: AND lme.learning_path_member_id = lpm.learning_path_member_id

Line 45: ota_booking_status_types_vl bst

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
49: AND ((p_person_id IS NOT NULL AND tdb.delegate_person_id = p_person_id)

Line 56: l_status_type ota_booking_status_types.type%TYPE;

52: ORDER BY status, evt.course_start_date;
53:
54: l_proc VARCHAR2(72) := g_package|| 'get_enrollment_status';
55:
56: l_status_type ota_booking_status_types.type%TYPE;
57: l_status_name ota_booking_status_types_vl.name%TYPE := null;
58: l_return ota_booking_status_types_vl.name%TYPE;
59:
60: BEGIN

Line 57: l_status_name ota_booking_status_types_vl.name%TYPE := null;

53:
54: l_proc VARCHAR2(72) := g_package|| 'get_enrollment_status';
55:
56: l_status_type ota_booking_status_types.type%TYPE;
57: l_status_name ota_booking_status_types_vl.name%TYPE := null;
58: l_return ota_booking_status_types_vl.name%TYPE;
59:
60: BEGIN
61:

Line 58: l_return ota_booking_status_types_vl.name%TYPE;

54: l_proc VARCHAR2(72) := g_package|| 'get_enrollment_status';
55:
56: l_status_type ota_booking_status_types.type%TYPE;
57: l_status_name ota_booking_status_types_vl.name%TYPE := null;
58: l_return ota_booking_status_types_vl.name%TYPE;
59:
60: BEGIN
61:
62: hr_utility.set_location(' Step:'|| l_proc, 10);

Line 102: p_booking_status_type OUT NOCOPY ota_booking_status_types.type%TYPE,

98: PROCEDURE get_enrollment_status(p_person_id IN ota_learning_paths.person_id%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:

Line 116: ota_booking_status_types bst

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
120: AND lme.learning_path_member_id = lpm.learning_path_member_id

Line 133: ota_booking_status_types_vl bst

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
137: AND ((p_person_id IS NOT NULL AND tdb.delegate_person_id = p_person_id)

Line 189: ota_booking_status_types s,

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
193: AND e.activity_version_id = a.activity_version_id

Line 460: l_enroll_type ota_booking_status_types.type%TYPE;

456:
457: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
458: l_lp_section_id ota_lp_sections.learning_path_section_id%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;

Line 1372: ota_booking_status_types obst

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
1376: AND opf.completed_date is not null

Line 1394: ota_booking_status_types obst

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
1398: AND opf.completed_date is not null

Line 1411: ota_booking_status_types obst

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
1415: AND obst.type = 'A'

Line 1422: ota_booking_status_types obst

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
1426: AND obst.type = 'A'

Line 1432: ota_booking_status_types obst

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
1436: AND odb.event_id = p_event_id;

Line 1441: ota_booking_status_types obst

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
1445: AND odb.event_id = p_event_id;