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

Line 44: p_event_title IN ota_events.title%TYPE,

40: x_msg_data OUT NOCOPY VARCHAR2,
41: p_item_key IN wf_items.item_key%TYPE,
42: p_item_type IN wf_items.item_type%TYPE,
43: p_person_id IN number default NULL,
44: p_event_title IN ota_events.title%TYPE,
45: p_course_start_date IN ota_events.course_start_date%TYPE,
46: p_course_end_date IN ota_events.course_end_date%TYPE,
47: p_version_name IN ota_activity_versions.Version_name%type )
48: --

Line 45: p_course_start_date IN ota_events.course_start_date%TYPE,

41: p_item_key IN wf_items.item_key%TYPE,
42: p_item_type IN wf_items.item_type%TYPE,
43: p_person_id IN number default NULL,
44: p_event_title IN ota_events.title%TYPE,
45: p_course_start_date IN ota_events.course_start_date%TYPE,
46: p_course_end_date IN ota_events.course_end_date%TYPE,
47: p_version_name IN ota_activity_versions.Version_name%type )
48: --
49: --

Line 46: p_course_end_date IN ota_events.course_end_date%TYPE,

42: p_item_type IN wf_items.item_type%TYPE,
43: p_person_id IN number default NULL,
44: p_event_title IN ota_events.title%TYPE,
45: p_course_start_date IN ota_events.course_start_date%TYPE,
46: p_course_end_date IN ota_events.course_end_date%TYPE,
47: p_version_name IN ota_activity_versions.Version_name%type )
48: --
49: --
50: --

Line 325: l_event_title ota_events.title%TYPE;

321: -- ------------------------
322: -- event_csr variables
323: -- ------------------------
324: --
325: l_event_title ota_events.title%TYPE;
326: l_event_status ota_events.event_status%TYPE;
327: l_course_start_date ota_events.course_start_date%TYPE;
328: l_course_start_time ota_events.course_start_time%TYPE;
329: l_course_end_date ota_events.course_start_date%TYPE;

Line 326: l_event_status ota_events.event_status%TYPE;

322: -- event_csr variables
323: -- ------------------------
324: --
325: l_event_title ota_events.title%TYPE;
326: l_event_status ota_events.event_status%TYPE;
327: l_course_start_date ota_events.course_start_date%TYPE;
328: l_course_start_time ota_events.course_start_time%TYPE;
329: l_course_end_date ota_events.course_start_date%TYPE;
330: l_owner_id ota_events.owner_id%TYPE;

Line 327: l_course_start_date ota_events.course_start_date%TYPE;

323: -- ------------------------
324: --
325: l_event_title ota_events.title%TYPE;
326: l_event_status ota_events.event_status%TYPE;
327: l_course_start_date ota_events.course_start_date%TYPE;
328: l_course_start_time ota_events.course_start_time%TYPE;
329: l_course_end_date ota_events.course_start_date%TYPE;
330: l_owner_id ota_events.owner_id%TYPE;
331: --

Line 328: l_course_start_time ota_events.course_start_time%TYPE;

324: --
325: l_event_title ota_events.title%TYPE;
326: l_event_status ota_events.event_status%TYPE;
327: l_course_start_date ota_events.course_start_date%TYPE;
328: l_course_start_time ota_events.course_start_time%TYPE;
329: l_course_end_date ota_events.course_start_date%TYPE;
330: l_owner_id ota_events.owner_id%TYPE;
331: --
332: -- ------------------------

Line 329: l_course_end_date ota_events.course_start_date%TYPE;

325: l_event_title ota_events.title%TYPE;
326: l_event_status ota_events.event_status%TYPE;
327: l_course_start_date ota_events.course_start_date%TYPE;
328: l_course_start_time ota_events.course_start_time%TYPE;
329: l_course_end_date ota_events.course_start_date%TYPE;
330: l_owner_id ota_events.owner_id%TYPE;
331: --
332: -- ------------------------
333: -- booking_csr variables

Line 330: l_owner_id ota_events.owner_id%TYPE;

326: l_event_status ota_events.event_status%TYPE;
327: l_course_start_date ota_events.course_start_date%TYPE;
328: l_course_start_time ota_events.course_start_time%TYPE;
329: l_course_end_date ota_events.course_start_date%TYPE;
330: l_owner_id ota_events.owner_id%TYPE;
331: --
332: -- ------------------------
333: -- booking_csr variables
334: -- ------------------------

Line 382: CURSOR event_csr (p_event_id ota_events.event_id%TYPE)

378: ltt_item_attribute_value hr_workflow_service.g_varchar2_tab_type;
379: l_proc VARCHAR2(72) := 'ota_cancel_enrollment_ss.cancel_enrollment';
380: l_activity_version_name ota_activity_versions.version_name%TYPE;
381: --
382: CURSOR event_csr (p_event_id ota_events.event_id%TYPE)
383: IS
384: SELECT a.version_name,
385: e.title,
386: e.event_status,

Line 391: FROM ota_events_vl e,

387: e.course_start_date,
388: e.course_start_time,
389: e.course_end_date,
390: e.owner_id
391: FROM ota_events_vl e,
392: ota_activity_versions_tl a
393: WHERE a.activity_version_id = e.activity_version_id
394: AND e.event_id = p_event_id
395: AND language=userenv('LANG');