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 FND_USER

Line 38: p_user_id fnd_user.user_id%type,

34:
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);

Line 47: p_user_id fnd_user.user_id%type,

43:
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,

Line 57: p_user_id fnd_user.user_id%type,

53:
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,

Line 67: p_user_id fnd_user.user_id%type,

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

Line 76: p_user_id fnd_user.user_id%type,

72:
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,

Line 87: p_user_id fnd_user.user_id%type,

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

Line 96: p_user_id fnd_user.user_id%type,

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

Line 105: p_user_id fnd_user.user_id%type,

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

Line 114: p_user_id fnd_user.user_id%type,

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

Line 124: p_user_id fnd_user.user_id%type,

120: function get_next_lo_id(
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:

Line 132: p_user_id fnd_user.user_id%type,

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

Line 140: p_user_id fnd_user.user_id%type,

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

Line 149: p_user_id fnd_user.user_id%type,

145:
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;

Line 160: p_user_id fnd_user.user_id%type,

156: p_lo_id ota_learning_objects.learning_object_id%type) return varchar2;
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:

Line 168: p_user_id fnd_user.user_id%type,

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

Line 175: p_user_id fnd_user.user_id%type,

171:
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(

Line 181: p_user_id fnd_user.user_id%type,

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

Line 189: p_user_id fnd_user.user_id%type,

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

Line 226: p_user_id fnd_user.user_id%type,

222:
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,

Line 242: p_user_id fnd_user.user_id%type,

238: p_chk_active_cert_flag varchar2 default 'N') return varchar2;
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:

Line 257: p_user_id fnd_user.user_id%type,

253: -- wait before playing the test again. This is displayed as flyover text.
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:

Line 272: p_user_id fnd_user.user_id%type,

268: -- wait before playing the LO again.
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:

Line 389: FUNCTION get_history_button(p_user_id fnd_user.user_id%TYPE,

385: --
386: -- {End Of Comments}
387: ----------------------------------------------------------------------------
388:
389: FUNCTION get_history_button(p_user_id fnd_user.user_id%TYPE,
390: p_lo_id ota_learning_objects.learning_object_id%TYPE,
391: p_event_id ota_events.event_id%TYPE,
392: p_booking_id ota_delegate_bookings.booking_id%TYPE)
393: RETURN VARCHAR2;

Line 497: function get_cme_online_event_id(p_user_id in fnd_user.user_id%type,

493: -- Access Status
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:

Line 523: function get_cme_play_button(p_user_id in fnd_user.user_id%type,

519: -- Access Status
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;

Line 549: function get_cme_player_toolbar_flag(p_user_id in fnd_user.user_id%type,

545: -- Access Status
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:

Line 574: function get_cert_lo_status(p_user_id in fnd_user.user_id%type,

570: -- Access Status
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:

Line 600: function get_cme_onl_evt_count(p_user_id in fnd_user.user_id%type,

596: -- Access Status
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:

Line 669: function get_lme_play_button(p_user_id in fnd_user.user_id%type,

665: -- Access Status
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;

Line 716: function get_lpe_lo_status(p_user_id in fnd_user.user_id%type,

712: -- Access Status
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:

Line 884: p_user_id fnd_user.user_id%type,

880: RETURN VARCHAR2;
881:
882: function get_play_eval_button(
883: p_event_id OTA_EVENTS.EVENT_ID%TYPE,
884: p_user_id fnd_user.user_id%type,
885: p_booking_status_type_id OTA_DELEGATE_BOOKINGS.BOOKING_STATUS_TYPE_ID%TYPE,
886: p_object_id OTA_EVALUATIONS.OBJECT_ID%TYPE,
887: p_object_type OTA_EVALUATIONS.OBJECT_TYPE%TYPE,
888: p_mand_flag OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE,

Line 893: p_user_id fnd_user.user_id%type,

889: p_test_id OTA_TESTS.TEST_ID%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(

Line 899: p_user_id fnd_user.user_id%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,
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: