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:

Line 46: p_user_id fnd_user.user_id%type,

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

Line 54: p_user_id fnd_user.user_id%type,

50: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_id%type);
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:

Line 62: p_user_id fnd_user.user_id%type,

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

Line 72: p_user_id fnd_user.user_id%type,

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

Line 81: p_user_id fnd_user.user_id%type,

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

Line 90: p_user_id fnd_user.user_id%type,

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

Line 99: p_user_id fnd_user.user_id%type,

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

Line 109: p_user_id fnd_user.user_id%type,

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

Line 117: p_user_id fnd_user.user_id%type,

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

Line 125: p_user_id fnd_user.user_id%type,

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

Line 134: p_user_id fnd_user.user_id%type,

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

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

Line 153: p_user_id fnd_user.user_id%type,

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

Line 160: p_user_id fnd_user.user_id%type,

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

Line 166: p_user_id fnd_user.user_id%type,

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

Line 174: p_user_id fnd_user.user_id%type,

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

Line 210: p_user_id fnd_user.user_id%type,

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,

Line 226: p_user_id fnd_user.user_id%type,

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

Line 241: p_user_id fnd_user.user_id%type,

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

Line 256: p_user_id fnd_user.user_id%type,

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

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

369: --
370: -- {End Of Comments}
371: ----------------------------------------------------------------------------
372:
373: FUNCTION get_history_button(p_user_id fnd_user.user_id%TYPE,
374: p_lo_id ota_learning_objects.learning_object_id%TYPE,
375: p_event_id ota_events.event_id%TYPE,
376: p_booking_id ota_delegate_bookings.booking_id%TYPE)
377: RETURN VARCHAR2;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 867: p_user_id fnd_user.user_id%type,

863: RETURN VARCHAR2;
864:
865: function get_play_eval_button(
866: p_event_id OTA_EVENTS.EVENT_ID%TYPE,
867: p_user_id fnd_user.user_id%type,
868: p_booking_status_type_id OTA_DELEGATE_BOOKINGS.BOOKING_STATUS_TYPE_ID%TYPE,
869: p_object_id OTA_EVALUATIONS.OBJECT_ID%TYPE,
870: p_object_type OTA_EVALUATIONS.OBJECT_TYPE%TYPE,
871: p_mand_flag OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE,

Line 876: p_user_id fnd_user.user_id%type,

872: p_test_id OTA_TESTS.TEST_ID%TYPE)
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(

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

Line 900: p_user_id fnd_user.user_id%type,

896:
897: --Enhancement: 7310093 SIP: A NEW FIELD WHICH CAN GIVE THE STATUS OF THE COURSE / CLASS EVALUATION
898: function get_admin_eval_status(
899: p_event_id OTA_EVENTS.EVENT_ID%TYPE,
900: p_user_id fnd_user.user_id%type,
901: p_booking_status_type_id OTA_DELEGATE_BOOKINGS.BOOKING_STATUS_TYPE_ID%TYPE,
902: p_mand_flag OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE,
903: p_test_id OTA_TESTS.TEST_ID%TYPE)
904: return varchar2;