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_EVENTS

Line 85: p_event_id ota_events.event_id%type,

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

Line 94: p_event_id ota_events.event_id%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,
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,

Line 131: p_event_id ota_events.event_id%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,
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;

Line 139: p_event_id ota_events.event_id%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,
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;

Line 148: p_event_id ota_events.event_id%type,

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

Line 159: p_event_id ota_events.event_id%type,

155: function get_lo_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;

Line 167: p_event_id ota_events.event_id%type,

163: p_reason out nocopy number) return varchar2;
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:

Line 174: p_event_id ota_events.event_id%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,
175: p_user_id fnd_user.user_id%type,
176: p_user_type ota_attempts.user_type%type) return varchar2;
177:
178:

Line 229: p_event_id ota_events.event_id%type,

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,
232: p_online_flag ota_category_usages.online_flag%type,
233: p_course_start_date ota_events.course_start_date%type,

Line 230: p_event_type ota_events.event_type%type,

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

Line 233: p_course_start_date ota_events.course_start_date%type,

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

Line 234: p_course_end_date ota_events.course_end_date%type,

230: p_event_type ota_events.event_type%type,
231: p_synchronous_flag ota_category_usages.synchronous_flag%type,
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;

Line 244: p_event_id ota_events.event_id%type,

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

Line 259: p_event_id ota_events.event_id%type,

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

Line 350: p_event_id IN ota_events.event_id%TYPE,

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,
354: p_chk_active_cert_flag varchar2 default 'N')

Line 391: p_event_id ota_events.event_id%TYPE,

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;
394:
395: FUNCTION get_lo_completion_date(p_event_id IN ota_events.event_id%type,

Line 395: FUNCTION get_lo_completion_date(p_event_id IN ota_events.event_id%type,

391: p_event_id ota_events.event_id%TYPE,
392: p_booking_id ota_delegate_bookings.booking_id%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')

Line 438: p_event_id IN ota_events.event_id%TYPE,

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,
442: p_mode IN number default null)

Line 746: p_event_id ota_events.event_id%type,

742: function get_lme_onl_evt_count(p_lp_member_enrollment_id in ota_lp_member_enrollments.lp_member_enrollment_id%type)
743: return varchar2;
744:
745: procedure get_active_cert_prds(
746: p_event_id ota_events.event_id%type,
747: p_person_id ota_cert_enrollments.contact_id%type,
748: p_contact_id ota_cert_enrollments.contact_id%type,
749: p_cert_prd_enrollment_ids OUT NOCOPY varchar2);
750:

Line 765: FUNCTION get_lo_completion_date_time(p_event_id IN ota_events.event_id%type,

761: -- ----------------------------------------------------------------------------
762:
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')

Line 804: p_event_id IN ota_events.event_id%TYPE,

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

Line 841: p_event_id IN ota_events.event_id%TYPE,

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

Line 878: p_event_id IN ota_events.event_id%TYPE,

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:
882: function get_play_eval_button(

Line 883: p_event_id OTA_EVENTS.EVENT_ID%TYPE,

879: p_booking_id IN ota_delegate_bookings.booking_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,

Line 895: p_event_id ota_events.event_id%type);

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

Line 906: p_event_id ota_events.event_id%type,

902: p_failed varchar2);
903:
904: procedure update_enrollment(
905: p_booking_id ota_delegate_bookings.booking_id%type,
906: p_event_id ota_events.event_id%type,
907: p_business_group_id ota_delegate_bookings.business_group_id%type,
908: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
909: p_object_version_number ota_delegate_bookings.object_version_number%type,
910: p_sign_eval_status ota_delegate_bookings.sign_eval_status%type, --8785933

Line 919: p_event_id OTA_EVENTS.EVENT_ID%TYPE,

915:
916: --Enhancement: 7310093 SIP: A NEW FIELD WHICH CAN GIVE THE STATUS OF THE COURSE / CLASS EVALUATION
917: --Modified for 8855548.
918: function get_admin_eval_status(
919: p_event_id OTA_EVENTS.EVENT_ID%TYPE,
920: p_sign_eval_status OTA_DELEGATE_BOOKINGS.SIGN_EVAL_STATUS%TYPE)
921: return varchar2;
922:
923: --Enhancement: 8785933 Added to show sign or evaluation buttons whichever present.

Line 928: FUNCTION get_member_in(p_event_id ota_events.event_id%type,

924: function get_sign_eval_button(
925: p_sign_eval_status OTA_DELEGATE_BOOKINGS.SIGN_EVAL_STATUS%TYPE)
926: return varchar2;
927:
928: FUNCTION get_member_in(p_event_id ota_events.event_id%type,
929: p_person_id ota_cert_enrollments.person_id%type,
930: p_contact_id ota_cert_enrollments.contact_id%type) RETURN VARCHAR2;
931:
932: -- Enchancement 13496386 Added for Learner Performance Details page

Line 935: p_event_id IN ota_events.event_id%TYPE,

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