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_LEARNING_OBJECTS

Line 37: p_lo_id ota_learning_objects.learning_object_id%type,

33: CERT_REASON_INVALID_USER constant number := 7;
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,

Line 46: p_lo_id ota_learning_objects.learning_object_id%type,

42: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_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,

Line 56: p_lo_id ota_learning_objects.learning_object_id%type,

52: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_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,

Line 66: p_lo_id ota_learning_objects.learning_object_id%type,

62: p_cert_prd_enroll_id ota_performances.cert_prd_enrollment_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,

Line 75: p_lo_id ota_learning_objects.learning_object_id%type,

71: p_scorm_learner_attempt_id ota_performances.scorm_learner_attempt_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,

Line 86: p_starting_lo_id ota_learning_objects.learning_object_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,
90: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;

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 95: p_starting_lo_id 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,
99: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%type;

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 103: p_root_lo_id ota_learning_objects.learning_object_id%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,
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,

Line 104: p_starting_lo_id 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,
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;

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 112: p_root_lo_id ota_learning_objects.learning_object_id%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,
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,

Line 113: p_starting_lo_id 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,
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;

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 121: p_root_lo_id ota_learning_objects.learning_object_id%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,
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,

Line 122: p_root_starting_url ota_learning_objects.starting_url%type,

118:
119:
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,

Line 123: p_starting_lo_id ota_learning_objects.learning_object_id%type,

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

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 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 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 147: p_lo_id ota_learning_objects.learning_object_id%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,
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,

Line 153: p_reason out nocopy number) return ota_learning_objects.learning_object_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;
157:

Line 156: p_lo_id ota_learning_objects.learning_object_id%type) return varchar2;

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

Line 180: p_lo_id ota_learning_objects.learning_object_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,
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;

Line 274: p_lo_id ota_learning_objects.learning_object_id%type,

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

Line 390: p_lo_id ota_learning_objects.learning_object_id%TYPE,

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

Line 898: p_lo_id ota_learning_objects.learning_object_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,
900: p_user_type ota_attempts.user_type%type,
901: p_date date,
902: p_failed varchar2);