35:
36: procedure set_performance_lesson_status(
37: p_lo_id ota_learning_objects.learning_object_id%type,
38: p_user_id fnd_user.user_id%type,
39: p_user_type ota_attempts.user_type%type,
40: p_lesson_status ota_performances.lesson_status%type,
41: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type);
42:
43:
43:
44: procedure set_performance_lesson_status(
45: p_lo_id ota_learning_objects.learning_object_id%type,
46: p_user_id fnd_user.user_id%type,
47: p_user_type ota_attempts.user_type%type,
48: p_lesson_status ota_performances.lesson_status%type,
49: p_date date,
50: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type);
51:
51:
52: procedure set_performance_time(
53: p_lo_id ota_learning_objects.learning_object_id%type,
54: p_user_id fnd_user.user_id%type,
55: p_user_type ota_attempts.user_type%type,
56: p_time ota_performances.time%type,
57: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type);
58:
59:
59:
60: procedure set_performance_time(
61: p_lo_id ota_learning_objects.learning_object_id%type,
62: p_user_id fnd_user.user_id%type,
63: p_user_type ota_attempts.user_type%type,
64: p_time ota_performances.time%type,
65: p_date date,
66: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type);
67:
69: function get_previous_event_lo_id(
70: p_event_id ota_events.event_id%type,
71: p_starting_lo_id ota_learning_objects.learning_object_id%type,
72: p_user_id fnd_user.user_id%type,
73: p_user_type ota_attempts.user_type%type,
74: p_launch_type ota_attempts.launch_type%type,
75: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
76:
77:
70: p_event_id ota_events.event_id%type,
71: p_starting_lo_id ota_learning_objects.learning_object_id%type,
72: p_user_id fnd_user.user_id%type,
73: p_user_type ota_attempts.user_type%type,
74: p_launch_type ota_attempts.launch_type%type,
75: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
76:
77:
78: function get_next_event_lo_id(
71: p_starting_lo_id ota_learning_objects.learning_object_id%type,
72: p_user_id fnd_user.user_id%type,
73: p_user_type ota_attempts.user_type%type,
74: p_launch_type ota_attempts.launch_type%type,
75: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
76:
77:
78: function get_next_event_lo_id(
79: p_event_id ota_events.event_id%type,
78: function get_next_event_lo_id(
79: p_event_id ota_events.event_id%type,
80: p_starting_lo_id ota_learning_objects.learning_object_id%type,
81: p_user_id fnd_user.user_id%type,
82: p_user_type ota_attempts.user_type%type,
83: p_launch_type ota_attempts.launch_type%type,
84: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
85:
86:
79: p_event_id ota_events.event_id%type,
80: p_starting_lo_id ota_learning_objects.learning_object_id%type,
81: p_user_id fnd_user.user_id%type,
82: p_user_type ota_attempts.user_type%type,
83: p_launch_type ota_attempts.launch_type%type,
84: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
85:
86:
87: function get_previous_lo_id(
80: p_starting_lo_id ota_learning_objects.learning_object_id%type,
81: p_user_id fnd_user.user_id%type,
82: p_user_type ota_attempts.user_type%type,
83: p_launch_type ota_attempts.launch_type%type,
84: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
85:
86:
87: function get_previous_lo_id(
88: p_root_lo_id ota_learning_objects.learning_object_id%type,
87: function get_previous_lo_id(
88: p_root_lo_id ota_learning_objects.learning_object_id%type,
89: p_starting_lo_id ota_learning_objects.learning_object_id%type,
90: p_user_id fnd_user.user_id%type,
91: p_user_type ota_attempts.user_type%type,
92: p_launch_type ota_attempts.launch_type%type,
93: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
94:
95:
88: p_root_lo_id ota_learning_objects.learning_object_id%type,
89: p_starting_lo_id ota_learning_objects.learning_object_id%type,
90: p_user_id fnd_user.user_id%type,
91: p_user_type ota_attempts.user_type%type,
92: p_launch_type ota_attempts.launch_type%type,
93: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
94:
95:
96: function get_next_lo_id(
89: p_starting_lo_id ota_learning_objects.learning_object_id%type,
90: p_user_id fnd_user.user_id%type,
91: p_user_type ota_attempts.user_type%type,
92: p_launch_type ota_attempts.launch_type%type,
93: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
94:
95:
96: function get_next_lo_id(
97: p_root_lo_id ota_learning_objects.learning_object_id%type,
96: function get_next_lo_id(
97: p_root_lo_id ota_learning_objects.learning_object_id%type,
98: p_starting_lo_id ota_learning_objects.learning_object_id%type,
99: p_user_id fnd_user.user_id%type,
100: p_user_type ota_attempts.user_type%type,
101: p_launch_type ota_attempts.launch_type%type,
102: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
103:
104:
97: p_root_lo_id ota_learning_objects.learning_object_id%type,
98: p_starting_lo_id ota_learning_objects.learning_object_id%type,
99: p_user_id fnd_user.user_id%type,
100: p_user_type ota_attempts.user_type%type,
101: p_launch_type ota_attempts.launch_type%type,
102: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
103:
104:
105: function get_next_lo_id(
98: p_starting_lo_id ota_learning_objects.learning_object_id%type,
99: p_user_id fnd_user.user_id%type,
100: p_user_type ota_attempts.user_type%type,
101: p_launch_type ota_attempts.launch_type%type,
102: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
103:
104:
105: function get_next_lo_id(
106: p_root_lo_id ota_learning_objects.learning_object_id%type,
106: p_root_lo_id ota_learning_objects.learning_object_id%type,
107: p_root_starting_url ota_learning_objects.starting_url%type,
108: p_starting_lo_id ota_learning_objects.learning_object_id%type,
109: p_user_id fnd_user.user_id%type,
110: p_user_type ota_attempts.user_type%type,
111: p_launch_type ota_attempts.launch_type%type,
112: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
113:
114:
107: p_root_starting_url ota_learning_objects.starting_url%type,
108: p_starting_lo_id ota_learning_objects.learning_object_id%type,
109: p_user_id fnd_user.user_id%type,
110: p_user_type ota_attempts.user_type%type,
111: p_launch_type ota_attempts.launch_type%type,
112: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
113:
114:
115: function get_first_lo_id(
108: p_starting_lo_id ota_learning_objects.learning_object_id%type,
109: p_user_id fnd_user.user_id%type,
110: p_user_type ota_attempts.user_type%type,
111: p_launch_type ota_attempts.launch_type%type,
112: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
113:
114:
115: function get_first_lo_id(
116: p_event_id ota_events.event_id%type,
114:
115: function get_first_lo_id(
116: p_event_id ota_events.event_id%type,
117: p_user_id fnd_user.user_id%type,
118: p_user_type ota_attempts.user_type%type,
119: p_launch_type ota_attempts.launch_type%type,
120: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
121:
122:
115: function get_first_lo_id(
116: p_event_id ota_events.event_id%type,
117: p_user_id fnd_user.user_id%type,
118: p_user_type ota_attempts.user_type%type,
119: p_launch_type ota_attempts.launch_type%type,
120: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
121:
122:
123: function get_most_recent_lo_id(
116: p_event_id ota_events.event_id%type,
117: p_user_id fnd_user.user_id%type,
118: p_user_type ota_attempts.user_type%type,
119: p_launch_type ota_attempts.launch_type%type,
120: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
121:
122:
123: function get_most_recent_lo_id(
124: p_event_id ota_events.event_id%type,
122:
123: function get_most_recent_lo_id(
124: p_event_id ota_events.event_id%type,
125: p_user_id fnd_user.user_id%type,
126: p_user_type ota_attempts.user_type%type,
127: p_launch_type ota_attempts.launch_type%type,
128: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type) return ota_learning_objects.learning_object_id%type;
129:
130:
123: function get_most_recent_lo_id(
124: p_event_id ota_events.event_id%type,
125: p_user_id fnd_user.user_id%type,
126: p_user_type ota_attempts.user_type%type,
127: p_launch_type ota_attempts.launch_type%type,
128: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type) return ota_learning_objects.learning_object_id%type;
129:
130:
131: function get_jump_lo_id(
124: p_event_id ota_events.event_id%type,
125: p_user_id fnd_user.user_id%type,
126: p_user_type ota_attempts.user_type%type,
127: p_launch_type ota_attempts.launch_type%type,
128: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type) return ota_learning_objects.learning_object_id%type;
129:
130:
131: function get_jump_lo_id(
132: p_lo_id ota_learning_objects.learning_object_id%type,
131: function get_jump_lo_id(
132: p_lo_id ota_learning_objects.learning_object_id%type,
133: p_event_id ota_events.event_id%type,
134: p_user_id fnd_user.user_id%type,
135: p_user_type ota_attempts.user_type%type,
136: p_launch_type ota_attempts.launch_type%type,
137: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type,
138: p_reason out nocopy number) return ota_learning_objects.learning_object_id%type;
139:
132: p_lo_id ota_learning_objects.learning_object_id%type,
133: p_event_id ota_events.event_id%type,
134: p_user_id fnd_user.user_id%type,
135: p_user_type ota_attempts.user_type%type,
136: p_launch_type ota_attempts.launch_type%type,
137: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type,
138: p_reason out nocopy number) return ota_learning_objects.learning_object_id%type;
139:
140: function get_lo_type(
133: p_event_id ota_events.event_id%type,
134: p_user_id fnd_user.user_id%type,
135: p_user_type ota_attempts.user_type%type,
136: p_launch_type ota_attempts.launch_type%type,
137: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type,
138: p_reason out nocopy number) return ota_learning_objects.learning_object_id%type;
139:
140: function get_lo_type(
141: p_lo_id ota_learning_objects.learning_object_id%type) return varchar2;
142:
143: function user_can_attempt_event(
144: p_event_id ota_events.event_id%type,
145: p_user_id fnd_user.user_id%type,
146: p_user_type ota_attempts.user_type%type,
147: p_launch_type ota_attempts.launch_type%type,
148: p_reason out nocopy number) return varchar2;
149:
150:
143: function user_can_attempt_event(
144: p_event_id ota_events.event_id%type,
145: p_user_id fnd_user.user_id%type,
146: p_user_type ota_attempts.user_type%type,
147: p_launch_type ota_attempts.launch_type%type,
148: p_reason out nocopy number) return varchar2;
149:
150:
151: function user_can_attempt_event(
150:
151: function user_can_attempt_event(
152: p_event_id ota_events.event_id%type,
153: p_user_id fnd_user.user_id%type,
154: p_user_type ota_attempts.user_type%type,
155: p_launch_type ota_attempts.launch_type%type) return varchar2;
156:
157:
158: function user_can_attempt_event(
151: function user_can_attempt_event(
152: p_event_id ota_events.event_id%type,
153: p_user_id fnd_user.user_id%type,
154: p_user_type ota_attempts.user_type%type,
155: p_launch_type ota_attempts.launch_type%type) return varchar2;
156:
157:
158: function user_can_attempt_event(
159: p_event_id ota_events.event_id%type,
157:
158: function user_can_attempt_event(
159: p_event_id ota_events.event_id%type,
160: p_user_id fnd_user.user_id%type,
161: p_user_type ota_attempts.user_type%type) return varchar2;
162:
163:
164: function user_can_attempt_lo(
165: p_lo_id ota_learning_objects.learning_object_id%type,
163:
164: function user_can_attempt_lo(
165: p_lo_id ota_learning_objects.learning_object_id%type,
166: p_user_id fnd_user.user_id%type,
167: p_user_type ota_attempts.user_type%type,
168: p_launch_type ota_attempts.launch_type%type default '',
169: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2;
170:
171:
164: function user_can_attempt_lo(
165: p_lo_id ota_learning_objects.learning_object_id%type,
166: p_user_id fnd_user.user_id%type,
167: p_user_type ota_attempts.user_type%type,
168: p_launch_type ota_attempts.launch_type%type default '',
169: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2;
170:
171:
172: function user_can_attempt_cert(
165: p_lo_id ota_learning_objects.learning_object_id%type,
166: p_user_id fnd_user.user_id%type,
167: p_user_type ota_attempts.user_type%type,
168: p_launch_type ota_attempts.launch_type%type default '',
169: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2;
170:
171:
172: function user_can_attempt_cert(
173: p_cert_prd_enroll_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
171:
172: function user_can_attempt_cert(
173: p_cert_prd_enroll_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
174: p_user_id fnd_user.user_id%type,
175: p_user_type ota_attempts.user_type%type,
176: p_reason out nocopy number) return varchar2;
177:
178: -- Author: sbhullar
179: -- ----------------------------------------------------------------
198: -- {End of Comments}
199: ------------------------------------------------------------------
200: FUNCTION get_lo_title_for_tree(p_lo_id IN NUMBER,
201: p_user_id IN NUMBER,
202: p_user_type IN ota_attempts.user_type%type,
203: p_mode IN NUMBER default 1,
204: p_active_cert_flag varchar2 default 'N')
205: RETURN varchar2;
206:
207:
208:
209: function get_play_button(
210: p_user_id fnd_user.user_id%type,
211: p_user_type ota_attempts.user_type%type,
212: p_is_manager varchar2,
213: p_event_id ota_events.event_id%type,
214: p_event_type ota_events.event_type%type,
215: p_synchronous_flag ota_category_usages.synchronous_flag%type,
216: p_online_flag ota_category_usages.online_flag%type,
217: p_course_start_date ota_events.course_start_date%type,
218: p_course_end_date ota_events.course_end_date%type,
219: p_enrollment_status_type ota_booking_status_types.type%TYPE DEFAULT NULL,
220: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null,
221: p_contact_id ota_cert_enrollments.contact_id%type default null,
222: p_chk_active_cert_flag varchar2 default 'N') return varchar2;
223:
224:
223:
224:
225: function get_play_button_for_test(
226: p_user_id fnd_user.user_id%type,
227: p_user_type ota_attempts.user_type%type,
228: p_event_id ota_events.event_id%type,
229: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2;
230:
231: --
225: function get_play_button_for_test(
226: p_user_id fnd_user.user_id%type,
227: p_user_type ota_attempts.user_type%type,
228: p_event_id ota_events.event_id%type,
229: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2;
230:
231: --
232: -- ----------------------------------------------------------------------------
233: -- |-------------------------< get_wait_duration_for_test >--------------------
238: -- [End of Comments]
239: -- ----------------------------------------------------------------------------
240: function get_wait_duration_for_test(
241: p_user_id fnd_user.user_id%type,
242: p_user_type ota_attempts.user_type%type,
243: p_event_id ota_events.event_id%type,
244: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2;
245:
246: --
240: function get_wait_duration_for_test(
241: p_user_id fnd_user.user_id%type,
242: p_user_type ota_attempts.user_type%type,
243: p_event_id ota_events.event_id%type,
244: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2;
245:
246: --
247: -- ----------------------------------------------------------------------------
248: -- |-------------------------< get_wait_duration_for_lo >------------------
253: -- [End of Comments]
254: -- ---------------------------------------------------------------------------
255: function get_wait_duration_for_lo(
256: p_user_id fnd_user.user_id%type,
257: p_user_type ota_attempts.user_type%type,
258: p_lo_id ota_learning_objects.learning_object_id%type,
259: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2;
260:
261: --
255: function get_wait_duration_for_lo(
256: p_user_id fnd_user.user_id%type,
257: p_user_type ota_attempts.user_type%type,
258: p_lo_id ota_learning_objects.learning_object_id%type,
259: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2;
260:
261: --
262: -- ----------------------------------------------------------------------------
263: -- |-------------------------< root_folder_exists>----------------------------|
329: ----------------------------------------------------------------------------
330: --
331:
332: FUNCTION get_enroll_lo_status(p_user_id IN NUMBER,
333: p_user_type IN ota_attempts.user_type%type,
334: p_event_id IN ota_events.event_id%TYPE,
335: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,
336: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,
337: p_mode IN number default null,
377: RETURN VARCHAR2;
378:
379: FUNCTION get_lo_completion_date(p_event_id IN ota_events.event_id%type,
380: p_user_id IN NUMBER,
381: p_user_type IN ota_attempts.user_type%type,
382: p_cert_prd_enroll_id IN ota_performances.cert_prd_enrollment_id%type default NULL,
383: p_module_name IN VARCHAR2 default 'LEARNER')
384: RETURN varchar2;
385:
417: -- {End Of Comments}
418: ----------------------------------------------------------------------------
419:
420: FUNCTION get_cert_lo_status(p_user_id IN NUMBER,
421: p_user_type IN ota_attempts.user_type%type,
422: p_event_id IN ota_events.event_id%TYPE,
423: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,
424: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,
425: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
451: ------------------------------------------------------------------
452:
453: FUNCTION get_cert_lo_title_for_tree(p_lo_id IN NUMBER,
454: p_user_id IN NUMBER,
455: p_user_type IN ota_attempts.user_type%type,
456: p_cert_prd_enrollment_id IN ota_performances.cert_prd_enrollment_id%type,
457: p_mode IN NUMBER default 1)
458: RETURN varchar2;
459:
477: -- Public
478: -- {End of Comments}
479: ------------------------------------------------------------------
480: function get_cme_online_event_id(p_user_id in fnd_user.user_id%type,
481: p_user_type in ota_attempts.user_type%type,
482: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
483: return varchar2;
484:
485: -- ----------------------------------------------------------------
503: -- Public
504: -- {End of Comments}
505: ------------------------------------------------------------------
506: function get_cme_play_button(p_user_id in fnd_user.user_id%type,
507: p_user_type in ota_attempts.user_type%type,
508: p_is_manager in varchar2,
509: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
510: return varchar2;
511:
529: -- Public
530: -- {End of Comments}
531: ------------------------------------------------------------------
532: function get_cme_player_toolbar_flag(p_user_id in fnd_user.user_id%type,
533: p_user_type in ota_attempts.user_type%type,
534: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
535: return varchar2;
536:
537: -- ----------------------------------------------------------------
554: -- Public
555: -- {End of Comments}
556: ------------------------------------------------------------------
557: function get_cert_lo_status(p_user_id in fnd_user.user_id%type,
558: p_user_type in ota_attempts.user_type%type,
559: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
560: return varchar2;
561:
562:
580: -- Public
581: -- {End of Comments}
582: ------------------------------------------------------------------
583: function get_cme_onl_evt_count(p_user_id in fnd_user.user_id%type,
584: p_user_type in ota_attempts.user_type%type,
585: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
586: return varchar2;
587:
588: -- ----------------------------------------------------------------
649: -- Public
650: -- {End of Comments}
651: ------------------------------------------------------------------
652: function get_lme_play_button(p_user_id in fnd_user.user_id%type,
653: p_user_type in ota_attempts.user_type%type,
654: p_is_manager in varchar2,
655: p_lp_member_enrollment_id in ota_lp_member_enrollments.lp_member_enrollment_id%type)
656: return varchar2;
657:
696: -- Public
697: -- {End of Comments}
698: ------------------------------------------------------------------
699: function get_lpe_lo_status(p_user_id in fnd_user.user_id%type,
700: p_user_type in ota_attempts.user_type%type,
701: p_lp_member_enrollment_id in ota_lp_member_enrollments.lp_member_enrollment_id%type)
702: return varchar2;
703:
704:
746: --Added for 6768606:COMPLETION DATE COLUMN SORT NUMERIC AND NOT BY ACTUAL DATE SORT
747:
748: FUNCTION get_lo_completion_date_time(p_event_id IN ota_events.event_id%type,
749: p_user_id IN NUMBER,
750: p_user_type IN ota_attempts.user_type%type,
751: p_cert_prd_enroll_id IN ota_performances.cert_prd_enrollment_id%type default NULL,
752: p_module_name IN VARCHAR2 default 'LEARNER')
753: RETURN date;
754: -- ----------------------------------------------------------------------------
782: -- {End Of Comments}
783: ----------------------------------------------------------------------------
784: --
785: FUNCTION get_enroll_lo_score(p_user_id IN NUMBER,
786: p_user_type IN ota_attempts.user_type%type,
787: p_event_id IN ota_events.event_id%TYPE,
788: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)
789: RETURN VARCHAR2;
790: --
819: -- {End Of Comments}
820: ----------------------------------------------------------------------------
821: --
822: FUNCTION get_enroll_lo_time(p_user_id IN NUMBER,
823: p_user_type IN ota_attempts.user_type%type,
824: p_event_id IN ota_events.event_id%TYPE,
825: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)
826: RETURN VARCHAR2;
827:
856: -- {End Of Comments}
857: ----------------------------------------------------------------------------
858: --
859: FUNCTION get_player_status(p_user_id IN NUMBER,
860: p_user_type IN ota_attempts.user_type%type,
861: p_event_id IN ota_events.event_id%TYPE,
862: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)
863: RETURN VARCHAR2;
864:
873: return varchar2;
874:
875: procedure update_enrollment_status(
876: p_user_id fnd_user.user_id%type,
877: p_user_type ota_attempts.user_type%type,
878: p_event_id ota_events.event_id%type);
879:
880: procedure update_enroll_status_for_lo(
881: p_lo_id ota_learning_objects.learning_object_id%type,
879:
880: procedure update_enroll_status_for_lo(
881: p_lo_id ota_learning_objects.learning_object_id%type,
882: p_user_id fnd_user.user_id%type,
883: p_user_type ota_attempts.user_type%type,
884: p_date date,
885: p_failed varchar2);
886:
887: procedure update_enrollment(