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.

[Home] [Help]

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

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

Line 53: p_lo_id ota_learning_objects.learning_object_id%type,

49: p_date date,
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);

Line 61: p_lo_id ota_learning_objects.learning_object_id%type,

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

Line 71: p_starting_lo_id ota_learning_objects.learning_object_id%type,

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

Line 75: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_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:
77:
78: function get_next_event_lo_id(
79: p_event_id ota_events.event_id%type,

Line 80: p_starting_lo_id ota_learning_objects.learning_object_id%type,

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

Line 84: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_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:
86:
87: function get_previous_lo_id(
88: p_root_lo_id ota_learning_objects.learning_object_id%type,

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

Line 89: p_starting_lo_id ota_learning_objects.learning_object_id%type,

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

Line 93: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return 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:
95:
96: function get_next_lo_id(
97: p_root_lo_id ota_learning_objects.learning_object_id%type,

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

Line 98: p_starting_lo_id ota_learning_objects.learning_object_id%type,

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

Line 102: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return 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:
104:
105: function get_next_lo_id(
106: p_root_lo_id ota_learning_objects.learning_object_id%type,

Line 106: p_root_lo_id ota_learning_objects.learning_object_id%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:
104:
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,

Line 107: p_root_starting_url ota_learning_objects.starting_url%type,

103:
104:
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,

Line 108: p_starting_lo_id ota_learning_objects.learning_object_id%type,

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

Line 112: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return ota_learning_objects.learning_object_id%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:
114:
115: function get_first_lo_id(
116: p_event_id ota_events.event_id%type,

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

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:
122:
123: function get_most_recent_lo_id(
124: p_event_id ota_events.event_id%type,

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

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:
130:
131: function get_jump_lo_id(
132: p_lo_id ota_learning_objects.learning_object_id%type,

Line 132: p_lo_id ota_learning_objects.learning_object_id%type,

128: p_cert_prd_enroll_id ota_attempts.cert_prd_enrollment_id%type) return ota_learning_objects.learning_object_id%type;
129:
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,

Line 138: p_reason out nocopy number) return ota_learning_objects.learning_object_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;
139:
140: function get_lo_type(
141: p_lo_id ota_learning_objects.learning_object_id%type) return varchar2;
142:

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

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;
139:
140: function get_lo_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,

Line 165: p_lo_id ota_learning_objects.learning_object_id%type,

161: p_user_type ota_attempts.user_type%type) return varchar2;
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;

Line 258: p_lo_id ota_learning_objects.learning_object_id%type,

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:
261: --
262: -- ----------------------------------------------------------------------------

Line 374: p_lo_id ota_learning_objects.learning_object_id%TYPE,

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

Line 881: p_lo_id ota_learning_objects.learning_object_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(
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);