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_LRNR_ENROLL_UNENROLL_WF dependencies on OTA_EVENTS

Line 138: p_eventid in ota_Events.event_id%type,

134:
135: Procedure Learner_Enrollment(p_process in wf_process_activities.process_name%type,
136: p_itemtype in wf_items.item_type%type,
137: p_person_id in number ,
138: p_eventid in ota_Events.event_id%type,
139: p_booking_id in number)
140: is
141: l_proc varchar2(72) := g_package||'Learner_Enrollment';
142: l_process wf_activities.name%type := upper(p_process);

Line 155: l_event_title ota_events.title%type;

151: l_creator_username fnd_user.user_name%TYPE;
152: l_current_displayname per_all_people_f.full_name%TYPE;
153: l_creator_displayname per_all_people_f.full_name%TYPE;
154: */
155: l_event_title ota_events.title%type;
156: l_course_start_date ota_events.course_start_date%type;
157: l_course_start_time ota_events.course_start_time%type;
158: l_course_end_date ota_events.course_end_date%type;
159: l_delivery_mode ota_category_usages_tl.category%type;

Line 156: l_course_start_date ota_events.course_start_date%type;

152: l_current_displayname per_all_people_f.full_name%TYPE;
153: l_creator_displayname per_all_people_f.full_name%TYPE;
154: */
155: l_event_title ota_events.title%type;
156: l_course_start_date ota_events.course_start_date%type;
157: l_course_start_time ota_events.course_start_time%type;
158: l_course_end_date ota_events.course_end_date%type;
159: l_delivery_mode ota_category_usages_tl.category%type;
160: l_event_location hr_locations_all.location_code%TYPE;

Line 157: l_course_start_time ota_events.course_start_time%type;

153: l_creator_displayname per_all_people_f.full_name%TYPE;
154: */
155: l_event_title ota_events.title%type;
156: l_course_start_date ota_events.course_start_date%type;
157: l_course_start_time ota_events.course_start_time%type;
158: l_course_end_date ota_events.course_end_date%type;
159: l_delivery_mode ota_category_usages_tl.category%type;
160: l_event_location hr_locations_all.location_code%TYPE;
161: l_version_name ota_activity_versions.version_name%type;

Line 158: l_course_end_date ota_events.course_end_date%type;

154: */
155: l_event_title ota_events.title%type;
156: l_course_start_date ota_events.course_start_date%type;
157: l_course_start_time ota_events.course_start_time%type;
158: l_course_end_date ota_events.course_end_date%type;
159: l_delivery_mode ota_category_usages_tl.category%type;
160: l_event_location hr_locations_all.location_code%TYPE;
161: l_version_name ota_activity_versions.version_name%type;
162:

Line 170: l_course_end_time ota_events.course_start_time%type;

166:
167:
168: l_process_display_name varchar2(240);
169: l_timezone fnd_timezones_tl.name%TYPE;
170: l_course_end_time ota_events.course_start_time%type;
171:
172: Cursor get_display_name is
173: SELECT wrpv.display_name displayName
174: FROM wf_runnable_processes_v wrpv

Line 185: from ota_Events oev , ota_events_tl evt,ota_activity_versions_tl oav,

181: oev.course_end_date, oev.course_start_time,
182: ctl.category,
183: ota_general.get_location_code(oev.location_id) Location_Name,
184: oav.version_name,ota_timezone_util.get_timezone_name(oev.timezone),oev.course_end_time
185: from ota_Events oev , ota_events_tl evt,ota_activity_versions_tl oav,
186: OTA_CATEGORY_USAGES_TL ctl,ota_offerings off
187: where oev.event_id = evt.event_id
188: and oev.parent_offering_id=off.offering_id
189: and off.activity_version_id= oav.activity_version_id

Line 346: p_eventid in ota_Events.event_id%type)

342:
343: Procedure Learner_UnEnrollment(p_process in wf_process_activities.process_name%type,
344: p_itemtype in wf_items.item_type%type,
345: p_person_id in number ,
346: p_eventid in ota_Events.event_id%type)
347:
348: is
349: l_proc varchar2(72) := g_package||'Learner_UnEnrollment';
350: l_process wf_activities.name%type := upper(p_process);

Line 355: l_event_title ota_events.title%type;

351: l_item_type wf_items.item_type%type := upper(p_itemtype);
352: l_item_key wf_items.item_key%type;
353:
354:
355: l_event_title ota_events.title%type;
356: l_course_start_date ota_events.course_start_date%type;
357:
358: l_version_name ota_activity_versions.version_name%type;
359:

Line 356: l_course_start_date ota_events.course_start_date%type;

352: l_item_key wf_items.item_key%type;
353:
354:
355: l_event_title ota_events.title%type;
356: l_course_start_date ota_events.course_start_date%type;
357:
358: l_version_name ota_activity_versions.version_name%type;
359:
360: --l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;

Line 368: from ota_Events oev , ota_events_tl evt,ota_activity_versions_tl oav

364:
365: Cursor csr_name is
366: select evt.title,oev.course_start_date,
367: oav.version_name
368: from ota_Events oev , ota_events_tl evt,ota_activity_versions_tl oav
369: where oev.event_id = evt.event_id
370: and oev.activity_version_id= oav.activity_version_id
371: AND evt.language = userenv('LANG')
372: and oev.event_id= p_eventid;