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_LO_UTILITY dependencies on OTA_ATTEMPTS

Line 39: p_user_type ota_attempts.user_type%type,

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: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type);
43:

Line 48: p_user_type ota_attempts.user_type%type,

44:
45: procedure set_performance_lesson_status(
46: p_lo_id ota_learning_objects.learning_object_id%type,
47: p_user_id fnd_user.user_id%type,
48: p_user_type ota_attempts.user_type%type,
49: p_lesson_status ota_performances.lesson_status%type,
50: p_date date,
51: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
52: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type);

Line 58: p_user_type ota_attempts.user_type%type,

54: --13485033
55: procedure set_performance_lesson_status(
56: p_lo_id ota_learning_objects.learning_object_id%type,
57: p_user_id fnd_user.user_id%type,
58: p_user_type ota_attempts.user_type%type,
59: p_lesson_status ota_performances.lesson_status%type,
60: p_cascaded varchar2,
61: p_date date,
62: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,

Line 68: p_user_type ota_attempts.user_type%type,

64:
65: procedure set_performance_time(
66: p_lo_id ota_learning_objects.learning_object_id%type,
67: p_user_id fnd_user.user_id%type,
68: p_user_type ota_attempts.user_type%type,
69: p_time ota_performances.time%type,
70: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
71: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type);
72:

Line 77: p_user_type ota_attempts.user_type%type,

73:
74: procedure set_performance_time(
75: p_lo_id ota_learning_objects.learning_object_id%type,
76: p_user_id fnd_user.user_id%type,
77: p_user_type ota_attempts.user_type%type,
78: p_time ota_performances.time%type,
79: p_date date,
80: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type,
81: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_id%type);

Line 88: p_user_type ota_attempts.user_type%type,

84: function get_previous_event_lo_id(
85: p_event_id ota_events.event_id%type,
86: p_starting_lo_id ota_learning_objects.learning_object_id%type,
87: p_user_id fnd_user.user_id%type,
88: p_user_type ota_attempts.user_type%type,
89: p_launch_type ota_attempts.launch_type%type,
90: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
91:
92:

Line 89: p_launch_type ota_attempts.launch_type%type,

85: p_event_id ota_events.event_id%type,
86: p_starting_lo_id ota_learning_objects.learning_object_id%type,
87: p_user_id fnd_user.user_id%type,
88: p_user_type ota_attempts.user_type%type,
89: p_launch_type ota_attempts.launch_type%type,
90: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
91:
92:
93: function get_next_event_lo_id(

Line 90: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;

86: p_starting_lo_id ota_learning_objects.learning_object_id%type,
87: p_user_id fnd_user.user_id%type,
88: p_user_type ota_attempts.user_type%type,
89: p_launch_type ota_attempts.launch_type%type,
90: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
91:
92:
93: function get_next_event_lo_id(
94: p_event_id ota_events.event_id%type,

Line 97: p_user_type ota_attempts.user_type%type,

93: function get_next_event_lo_id(
94: p_event_id ota_events.event_id%type,
95: p_starting_lo_id ota_learning_objects.learning_object_id%type,
96: p_user_id fnd_user.user_id%type,
97: p_user_type ota_attempts.user_type%type,
98: p_launch_type ota_attempts.launch_type%type,
99: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
100:
101:

Line 98: p_launch_type ota_attempts.launch_type%type,

94: p_event_id ota_events.event_id%type,
95: p_starting_lo_id ota_learning_objects.learning_object_id%type,
96: p_user_id fnd_user.user_id%type,
97: p_user_type ota_attempts.user_type%type,
98: p_launch_type ota_attempts.launch_type%type,
99: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
100:
101:
102: function get_previous_lo_id(

Line 99: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;

95: p_starting_lo_id ota_learning_objects.learning_object_id%type,
96: p_user_id fnd_user.user_id%type,
97: p_user_type ota_attempts.user_type%type,
98: p_launch_type ota_attempts.launch_type%type,
99: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
100:
101:
102: function get_previous_lo_id(
103: p_root_lo_id ota_learning_objects.learning_object_id%type,

Line 106: p_user_type ota_attempts.user_type%type,

102: function get_previous_lo_id(
103: p_root_lo_id ota_learning_objects.learning_object_id%type,
104: p_starting_lo_id ota_learning_objects.learning_object_id%type,
105: p_user_id fnd_user.user_id%type,
106: p_user_type ota_attempts.user_type%type,
107: p_launch_type ota_attempts.launch_type%type,
108: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
109:
110:

Line 107: p_launch_type ota_attempts.launch_type%type,

103: p_root_lo_id ota_learning_objects.learning_object_id%type,
104: p_starting_lo_id ota_learning_objects.learning_object_id%type,
105: p_user_id fnd_user.user_id%type,
106: p_user_type ota_attempts.user_type%type,
107: p_launch_type ota_attempts.launch_type%type,
108: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
109:
110:
111: function get_next_lo_id(

Line 108: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;

104: p_starting_lo_id ota_learning_objects.learning_object_id%type,
105: p_user_id fnd_user.user_id%type,
106: p_user_type ota_attempts.user_type%type,
107: p_launch_type ota_attempts.launch_type%type,
108: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
109:
110:
111: function get_next_lo_id(
112: p_root_lo_id ota_learning_objects.learning_object_id%type,

Line 115: p_user_type ota_attempts.user_type%type,

111: function get_next_lo_id(
112: p_root_lo_id ota_learning_objects.learning_object_id%type,
113: p_starting_lo_id ota_learning_objects.learning_object_id%type,
114: p_user_id fnd_user.user_id%type,
115: p_user_type ota_attempts.user_type%type,
116: p_launch_type ota_attempts.launch_type%type,
117: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
118:
119:

Line 116: p_launch_type ota_attempts.launch_type%type,

112: p_root_lo_id ota_learning_objects.learning_object_id%type,
113: p_starting_lo_id ota_learning_objects.learning_object_id%type,
114: p_user_id fnd_user.user_id%type,
115: p_user_type ota_attempts.user_type%type,
116: p_launch_type ota_attempts.launch_type%type,
117: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
118:
119:
120: function get_next_lo_id(

Line 117: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;

113: p_starting_lo_id ota_learning_objects.learning_object_id%type,
114: p_user_id fnd_user.user_id%type,
115: p_user_type ota_attempts.user_type%type,
116: p_launch_type ota_attempts.launch_type%type,
117: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
118:
119:
120: function get_next_lo_id(
121: p_root_lo_id ota_learning_objects.learning_object_id%type,

Line 125: p_user_type ota_attempts.user_type%type,

121: p_root_lo_id ota_learning_objects.learning_object_id%type,
122: p_root_starting_url ota_learning_objects.starting_url%type,
123: p_starting_lo_id ota_learning_objects.learning_object_id%type,
124: p_user_id fnd_user.user_id%type,
125: p_user_type ota_attempts.user_type%type,
126: p_launch_type ota_attempts.launch_type%type,
127: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
128:
129:

Line 126: p_launch_type ota_attempts.launch_type%type,

122: p_root_starting_url ota_learning_objects.starting_url%type,
123: p_starting_lo_id ota_learning_objects.learning_object_id%type,
124: p_user_id fnd_user.user_id%type,
125: p_user_type ota_attempts.user_type%type,
126: p_launch_type ota_attempts.launch_type%type,
127: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
128:
129:
130: function get_first_lo_id(

Line 127: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;

123: p_starting_lo_id ota_learning_objects.learning_object_id%type,
124: p_user_id fnd_user.user_id%type,
125: p_user_type ota_attempts.user_type%type,
126: p_launch_type ota_attempts.launch_type%type,
127: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
128:
129:
130: function get_first_lo_id(
131: p_event_id ota_events.event_id%type,

Line 133: p_user_type ota_attempts.user_type%type,

129:
130: function get_first_lo_id(
131: p_event_id ota_events.event_id%type,
132: p_user_id fnd_user.user_id%type,
133: p_user_type ota_attempts.user_type%type,
134: p_launch_type ota_attempts.launch_type%type,
135: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
136:
137:

Line 134: p_launch_type ota_attempts.launch_type%type,

130: function get_first_lo_id(
131: p_event_id ota_events.event_id%type,
132: p_user_id fnd_user.user_id%type,
133: p_user_type ota_attempts.user_type%type,
134: p_launch_type ota_attempts.launch_type%type,
135: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
136:
137:
138: function get_most_recent_lo_id(

Line 135: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;

131: p_event_id ota_events.event_id%type,
132: p_user_id fnd_user.user_id%type,
133: p_user_type ota_attempts.user_type%type,
134: p_launch_type ota_attempts.launch_type%type,
135: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;
136:
137:
138: function get_most_recent_lo_id(
139: p_event_id ota_events.event_id%type,

Line 141: p_user_type ota_attempts.user_type%type,

137:
138: function get_most_recent_lo_id(
139: p_event_id ota_events.event_id%type,
140: p_user_id fnd_user.user_id%type,
141: p_user_type ota_attempts.user_type%type,
142: p_launch_type ota_attempts.launch_type%type,
143: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type) return ota_learning_objects.learning_object_id%type;
144:
145:

Line 142: p_launch_type ota_attempts.launch_type%type,

138: function get_most_recent_lo_id(
139: p_event_id ota_events.event_id%type,
140: p_user_id fnd_user.user_id%type,
141: p_user_type ota_attempts.user_type%type,
142: p_launch_type ota_attempts.launch_type%type,
143: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type) return ota_learning_objects.learning_object_id%type;
144:
145:
146: function get_jump_lo_id(

Line 143: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type) return ota_learning_objects.learning_object_id%type;

139: p_event_id ota_events.event_id%type,
140: p_user_id fnd_user.user_id%type,
141: p_user_type ota_attempts.user_type%type,
142: p_launch_type ota_attempts.launch_type%type,
143: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type) return ota_learning_objects.learning_object_id%type;
144:
145:
146: function get_jump_lo_id(
147: p_lo_id ota_learning_objects.learning_object_id%type,

Line 150: p_user_type ota_attempts.user_type%type,

146: function get_jump_lo_id(
147: p_lo_id ota_learning_objects.learning_object_id%type,
148: p_event_id ota_events.event_id%type,
149: p_user_id fnd_user.user_id%type,
150: p_user_type ota_attempts.user_type%type,
151: p_launch_type ota_attempts.launch_type%type,
152: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type,
153: p_reason out nocopy number) return ota_learning_objects.learning_object_id%type;
154:

Line 151: p_launch_type ota_attempts.launch_type%type,

147: p_lo_id ota_learning_objects.learning_object_id%type,
148: p_event_id ota_events.event_id%type,
149: p_user_id fnd_user.user_id%type,
150: p_user_type ota_attempts.user_type%type,
151: p_launch_type ota_attempts.launch_type%type,
152: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type,
153: p_reason out nocopy number) return ota_learning_objects.learning_object_id%type;
154:
155: function get_lo_type(

Line 152: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type,

148: p_event_id ota_events.event_id%type,
149: p_user_id fnd_user.user_id%type,
150: p_user_type ota_attempts.user_type%type,
151: p_launch_type ota_attempts.launch_type%type,
152: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type,
153: p_reason out nocopy number) return ota_learning_objects.learning_object_id%type;
154:
155: function get_lo_type(
156: p_lo_id ota_learning_objects.learning_object_id%type) return varchar2;

Line 161: p_user_type ota_attempts.user_type%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,
162: p_launch_type ota_attempts.launch_type%type,
163: p_reason out nocopy number) return varchar2;
164:
165:

Line 162: p_launch_type ota_attempts.launch_type%type,

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,
162: p_launch_type ota_attempts.launch_type%type,
163: p_reason out nocopy number) return varchar2;
164:
165:
166: function user_can_attempt_event(

Line 169: p_user_type ota_attempts.user_type%type,

165:
166: function user_can_attempt_event(
167: p_event_id ota_events.event_id%type,
168: p_user_id fnd_user.user_id%type,
169: p_user_type ota_attempts.user_type%type,
170: p_launch_type ota_attempts.launch_type%type) return varchar2;
171:
172:
173: function user_can_attempt_event(

Line 170: p_launch_type ota_attempts.launch_type%type) return varchar2;

166: function user_can_attempt_event(
167: p_event_id ota_events.event_id%type,
168: p_user_id fnd_user.user_id%type,
169: p_user_type ota_attempts.user_type%type,
170: p_launch_type ota_attempts.launch_type%type) return varchar2;
171:
172:
173: function user_can_attempt_event(
174: p_event_id ota_events.event_id%type,

Line 176: p_user_type ota_attempts.user_type%type) return varchar2;

172:
173: function user_can_attempt_event(
174: p_event_id ota_events.event_id%type,
175: p_user_id fnd_user.user_id%type,
176: p_user_type ota_attempts.user_type%type) return varchar2;
177:
178:
179: function user_can_attempt_lo(
180: p_lo_id ota_learning_objects.learning_object_id%type,

Line 182: p_user_type ota_attempts.user_type%type,

178:
179: function user_can_attempt_lo(
180: p_lo_id ota_learning_objects.learning_object_id%type,
181: p_user_id fnd_user.user_id%type,
182: p_user_type ota_attempts.user_type%type,
183: p_launch_type ota_attempts.launch_type%type default '',
184: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2;
185:
186:

Line 183: p_launch_type ota_attempts.launch_type%type default '',

179: function user_can_attempt_lo(
180: p_lo_id ota_learning_objects.learning_object_id%type,
181: p_user_id fnd_user.user_id%type,
182: p_user_type ota_attempts.user_type%type,
183: p_launch_type ota_attempts.launch_type%type default '',
184: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2;
185:
186:
187: function user_can_attempt_cert(

Line 184: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2;

180: p_lo_id ota_learning_objects.learning_object_id%type,
181: p_user_id fnd_user.user_id%type,
182: p_user_type ota_attempts.user_type%type,
183: p_launch_type ota_attempts.launch_type%type default '',
184: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2;
185:
186:
187: function user_can_attempt_cert(
188: p_cert_prd_enroll_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type,

Line 190: p_user_type ota_attempts.user_type%type,

186:
187: function user_can_attempt_cert(
188: p_cert_prd_enroll_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
189: p_user_id fnd_user.user_id%type,
190: p_user_type ota_attempts.user_type%type,
191: p_reason out nocopy number) return varchar2;
192:
193: -- Author: sbhullar
194: -- ----------------------------------------------------------------

Line 217: p_user_type IN ota_attempts.user_type%type,

213: -- {End of Comments}
214: ------------------------------------------------------------------
215: FUNCTION get_lo_title_for_tree(p_lo_id IN NUMBER,
216: p_user_id IN NUMBER,
217: p_user_type IN ota_attempts.user_type%type,
218: p_mode IN NUMBER default 1,
219: p_active_cert_flag varchar2 default 'N',
220: p_scorm_learning_attempt_id In ota_performances.scorm_learner_attempt_id%type default null)
221: RETURN varchar2;

Line 227: p_user_type ota_attempts.user_type%type,

223:
224:
225: function get_play_button(
226: p_user_id fnd_user.user_id%type,
227: p_user_type ota_attempts.user_type%type,
228: p_is_manager varchar2,
229: p_event_id ota_events.event_id%type,
230: p_event_type ota_events.event_type%type,
231: p_synchronous_flag ota_category_usages.synchronous_flag%type,

Line 236: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null,

232: p_online_flag ota_category_usages.online_flag%type,
233: p_course_start_date ota_events.course_start_date%type,
234: p_course_end_date ota_events.course_end_date%type,
235: p_enrollment_status_type ota_booking_status_types.type%TYPE DEFAULT NULL,
236: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null,
237: p_contact_id ota_cert_enrollments.contact_id%type default null,
238: p_chk_active_cert_flag varchar2 default 'N') return varchar2;
239:
240:

Line 243: p_user_type ota_attempts.user_type%type,

239:
240:
241: function get_play_button_for_test(
242: p_user_id fnd_user.user_id%type,
243: p_user_type ota_attempts.user_type%type,
244: p_event_id ota_events.event_id%type,
245: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2;
246:
247: --

Line 245: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2;

241: function get_play_button_for_test(
242: p_user_id fnd_user.user_id%type,
243: p_user_type ota_attempts.user_type%type,
244: p_event_id ota_events.event_id%type,
245: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2;
246:
247: --
248: -- ----------------------------------------------------------------------------
249: -- |-------------------------< get_wait_duration_for_test >--------------------

Line 258: p_user_type ota_attempts.user_type%type,

254: -- [End of Comments]
255: -- ----------------------------------------------------------------------------
256: function get_wait_duration_for_test(
257: p_user_id fnd_user.user_id%type,
258: p_user_type ota_attempts.user_type%type,
259: p_event_id ota_events.event_id%type,
260: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2;
261:
262: --

Line 260: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2;

256: function get_wait_duration_for_test(
257: p_user_id fnd_user.user_id%type,
258: p_user_type ota_attempts.user_type%type,
259: p_event_id ota_events.event_id%type,
260: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2;
261:
262: --
263: -- ----------------------------------------------------------------------------
264: -- |-------------------------< get_wait_duration_for_lo >------------------

Line 273: p_user_type ota_attempts.user_type%type,

269: -- [End of Comments]
270: -- ---------------------------------------------------------------------------
271: function get_wait_duration_for_lo(
272: p_user_id fnd_user.user_id%type,
273: p_user_type ota_attempts.user_type%type,
274: p_lo_id ota_learning_objects.learning_object_id%type,
275: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2;
276:
277: --

Line 275: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2;

271: function get_wait_duration_for_lo(
272: p_user_id fnd_user.user_id%type,
273: p_user_type ota_attempts.user_type%type,
274: p_lo_id ota_learning_objects.learning_object_id%type,
275: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2;
276:
277: --
278: -- ----------------------------------------------------------------------------
279: -- |-------------------------< root_folder_exists>----------------------------|

Line 349: p_user_type IN ota_attempts.user_type%type,

345: ----------------------------------------------------------------------------
346: --
347:
348: FUNCTION get_enroll_lo_status(p_user_id IN NUMBER,
349: p_user_type IN ota_attempts.user_type%type,
350: p_event_id IN ota_events.event_id%TYPE,
351: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,
352: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,
353: p_mode IN number default null,

Line 397: p_user_type IN ota_attempts.user_type%type,

393: RETURN VARCHAR2;
394:
395: FUNCTION get_lo_completion_date(p_event_id IN ota_events.event_id%type,
396: p_user_id IN NUMBER,
397: p_user_type IN ota_attempts.user_type%type,
398: p_cert_prd_enroll_id IN ota_performances.cert_prd_enrollment_id%type default NULL,
399: p_module_name IN VARCHAR2 default 'LEARNER')
400: RETURN varchar2;
401:

Line 437: p_user_type IN ota_attempts.user_type%type,

433: -- {End Of Comments}
434: ----------------------------------------------------------------------------
435:
436: FUNCTION get_cert_lo_status(p_user_id IN NUMBER,
437: p_user_type IN ota_attempts.user_type%type,
438: p_event_id IN ota_events.event_id%TYPE,
439: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,
440: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,
441: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,

Line 471: p_user_type IN ota_attempts.user_type%type,

467: ------------------------------------------------------------------
468:
469: FUNCTION get_cert_lo_title_for_tree(p_lo_id IN NUMBER,
470: p_user_id IN NUMBER,
471: p_user_type IN ota_attempts.user_type%type,
472: p_cert_prd_enrollment_id IN ota_performances.cert_prd_enrollment_id%type,
473: p_mode IN NUMBER default 1,
474: p_scormattempid IN ota_performances.scorm_learner_attempt_id%type default null)
475: RETURN varchar2;

Line 498: p_user_type in ota_attempts.user_type%type,

494: -- Public
495: -- {End of Comments}
496: ------------------------------------------------------------------
497: function get_cme_online_event_id(p_user_id in fnd_user.user_id%type,
498: p_user_type in ota_attempts.user_type%type,
499: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
500: return varchar2;
501:
502: -- ----------------------------------------------------------------

Line 524: p_user_type in ota_attempts.user_type%type,

520: -- Public
521: -- {End of Comments}
522: ------------------------------------------------------------------
523: function get_cme_play_button(p_user_id in fnd_user.user_id%type,
524: p_user_type in ota_attempts.user_type%type,
525: p_is_manager in varchar2,
526: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
527: return varchar2;
528:

Line 550: p_user_type in ota_attempts.user_type%type,

546: -- Public
547: -- {End of Comments}
548: ------------------------------------------------------------------
549: function get_cme_player_toolbar_flag(p_user_id in fnd_user.user_id%type,
550: p_user_type in ota_attempts.user_type%type,
551: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
552: return varchar2;
553:
554: -- ----------------------------------------------------------------

Line 575: p_user_type in ota_attempts.user_type%type,

571: -- Public
572: -- {End of Comments}
573: ------------------------------------------------------------------
574: function get_cert_lo_status(p_user_id in fnd_user.user_id%type,
575: p_user_type in ota_attempts.user_type%type,
576: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
577: return varchar2;
578:
579:

Line 601: p_user_type in ota_attempts.user_type%type,

597: -- Public
598: -- {End of Comments}
599: ------------------------------------------------------------------
600: function get_cme_onl_evt_count(p_user_id in fnd_user.user_id%type,
601: p_user_type in ota_attempts.user_type%type,
602: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
603: return varchar2;
604:
605: -- ----------------------------------------------------------------

Line 670: p_user_type in ota_attempts.user_type%type,

666: -- Public
667: -- {End of Comments}
668: ------------------------------------------------------------------
669: function get_lme_play_button(p_user_id in fnd_user.user_id%type,
670: p_user_type in ota_attempts.user_type%type,
671: p_is_manager in varchar2,
672: p_lp_member_enrollment_id in ota_lp_member_enrollments.lp_member_enrollment_id%type)
673: return varchar2;
674:

Line 717: p_user_type in ota_attempts.user_type%type,

713: -- Public
714: -- {End of Comments}
715: ------------------------------------------------------------------
716: function get_lpe_lo_status(p_user_id in fnd_user.user_id%type,
717: p_user_type in ota_attempts.user_type%type,
718: p_lp_member_enrollment_id in ota_lp_member_enrollments.lp_member_enrollment_id%type)
719: return varchar2;
720:
721:

Line 767: p_user_type IN ota_attempts.user_type%type,

763: --Added for 6768606:COMPLETION DATE COLUMN SORT NUMERIC AND NOT BY ACTUAL DATE SORT
764:
765: FUNCTION get_lo_completion_date_time(p_event_id IN ota_events.event_id%type,
766: p_user_id IN NUMBER,
767: p_user_type IN ota_attempts.user_type%type,
768: p_cert_prd_enroll_id IN ota_performances.cert_prd_enrollment_id%type default NULL,
769: p_module_name IN VARCHAR2 default 'LEARNER')
770: RETURN date;
771: -- ----------------------------------------------------------------------------

Line 803: p_user_type IN ota_attempts.user_type%type,

799: -- {End Of Comments}
800: ----------------------------------------------------------------------------
801: --
802: FUNCTION get_enroll_lo_score(p_user_id IN NUMBER,
803: p_user_type IN ota_attempts.user_type%type,
804: p_event_id IN ota_events.event_id%TYPE,
805: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)
806: RETURN VARCHAR2;
807: --

Line 840: p_user_type IN ota_attempts.user_type%type,

836: -- {End Of Comments}
837: ----------------------------------------------------------------------------
838: --
839: FUNCTION get_enroll_lo_time(p_user_id IN NUMBER,
840: p_user_type IN ota_attempts.user_type%type,
841: p_event_id IN ota_events.event_id%TYPE,
842: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)
843: RETURN VARCHAR2;
844:

Line 877: p_user_type IN ota_attempts.user_type%type,

873: -- {End Of Comments}
874: ----------------------------------------------------------------------------
875: --
876: FUNCTION get_player_status(p_user_id IN NUMBER,
877: p_user_type IN ota_attempts.user_type%type,
878: p_event_id IN ota_events.event_id%TYPE,
879: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)
880: RETURN VARCHAR2;
881:

Line 894: p_user_type ota_attempts.user_type%type,

890: return varchar2;
891:
892: procedure update_enrollment_status(
893: p_user_id fnd_user.user_id%type,
894: p_user_type ota_attempts.user_type%type,
895: p_event_id ota_events.event_id%type);
896:
897: procedure update_enroll_status_for_lo(
898: p_lo_id ota_learning_objects.learning_object_id%type,

Line 900: p_user_type ota_attempts.user_type%type,

896:
897: procedure update_enroll_status_for_lo(
898: p_lo_id ota_learning_objects.learning_object_id%type,
899: p_user_id fnd_user.user_id%type,
900: p_user_type ota_attempts.user_type%type,
901: p_date date,
902: p_failed varchar2);
903:
904: procedure update_enrollment(

Line 934: p_user_type IN ota_attempts.user_type%type,

930: p_contact_id ota_cert_enrollments.contact_id%type) RETURN VARCHAR2;
931:
932: -- Enchancement 13496386 Added for Learner Performance Details page
933: FUNCTION get_num_of_online_records(p_user_id IN NUMBER,
934: p_user_type IN ota_attempts.user_type%type,
935: p_event_id IN ota_events.event_id%TYPE,
936: p_mode IN number default null,
937: p_chk_active_cert_flag varchar2 default 'N')
938: RETURN INTEGER;