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: IS
105:
106:

Line 114: ota_booking_status_types bst

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

Line 130: ota_booking_status_types_vl bst

126: SELECT DECODE(bst.type,'C','Z',bst.type) status,
127: tdb.date_status_changed
128: FROM ota_events evt,
129: ota_delegate_bookings tdb,
130: ota_booking_status_types_vl bst
131: WHERE evt.event_id = tdb.event_id
132: AND bst.booking_status_type_id = tdb.booking_status_type_id
133: AND evt.activity_version_id = p_activity_version_id
134: AND ((p_person_id IS NOT NULL AND tdb.delegate_person_id = p_person_id)

Line 183: ota_booking_status_types s,

179: SELECT NULL
180: FROM ota_events e,
181: ota_activity_versions a,
182: ota_delegate_bookings b,
183: ota_booking_status_types s,
184: ota_learning_path_members lpm
185: WHERE e.event_id = b.event_id
186: AND lpm.activity_version_id = a.activity_version_id
187: AND e.activity_version_id = a.activity_version_id

Line 448: l_enroll_type ota_booking_status_types.type%TYPE;

444:
445: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
446: l_lp_section_id ota_lp_sections.learning_path_section_id%TYPE;
447: l_completion_type_code ota_lp_sections.completion_type_code%TYPE;
448: l_enroll_type ota_booking_status_types.type%TYPE;
449: l_member_status_code ota_lp_member_enrollments.member_status_code%TYPE;
450: l_completion_date ota_lp_enrollments.completion_date%TYPE;
451: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;
452: l_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE := 0;