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_ACTIVITY_VERSIONS

Line 47: p_version_name IN ota_activity_versions.Version_name%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: --
51: IS

Line 380: l_activity_version_name ota_activity_versions.version_name%TYPE;

376: l_wf_exception EXCEPTION;
377: ltt_item_attribute hr_workflow_service.g_varchar2_tab_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,

Line 392: ota_activity_versions_tl a

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');
396: --