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

Line 114: ota_events

110: select
111: event_id,
112: object_version_number
113: from
114: ota_events
115: where
116: activity_version_id = l_activity_version_id and
117: business_group_id = p_business_group_id;
118:

Line 547: l_event_type OTA_EVENTS.EVENT_TYPE%TYPE;

543:
544: l_proc varchar2(72) := g_package||'crt_or_upd_event';
545: l_activity_start_date OTA_ACTIVITY_VERSIONS.START_DATE%TYPE;
546: l_activity_ovn OTA_ACTIVITY_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
547: l_event_type OTA_EVENTS.EVENT_TYPE%TYPE;
548: l2_event_type OTA_EVENTS.EVENT_TYPE%TYPE;
549: l_event_status OTA_EVENTS.EVENT_STATUS%TYPE;
550: l_event_id OTA_EVENTS.EVENT_ID%TYPE;
551: l_course_start_date OTA_EVENTS.COURSE_START_DATE%TYPE;

Line 548: l2_event_type OTA_EVENTS.EVENT_TYPE%TYPE;

544: l_proc varchar2(72) := g_package||'crt_or_upd_event';
545: l_activity_start_date OTA_ACTIVITY_VERSIONS.START_DATE%TYPE;
546: l_activity_ovn OTA_ACTIVITY_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
547: l_event_type OTA_EVENTS.EVENT_TYPE%TYPE;
548: l2_event_type OTA_EVENTS.EVENT_TYPE%TYPE;
549: l_event_status OTA_EVENTS.EVENT_STATUS%TYPE;
550: l_event_id OTA_EVENTS.EVENT_ID%TYPE;
551: l_course_start_date OTA_EVENTS.COURSE_START_DATE%TYPE;
552: l_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;

Line 549: l_event_status OTA_EVENTS.EVENT_STATUS%TYPE;

545: l_activity_start_date OTA_ACTIVITY_VERSIONS.START_DATE%TYPE;
546: l_activity_ovn OTA_ACTIVITY_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
547: l_event_type OTA_EVENTS.EVENT_TYPE%TYPE;
548: l2_event_type OTA_EVENTS.EVENT_TYPE%TYPE;
549: l_event_status OTA_EVENTS.EVENT_STATUS%TYPE;
550: l_event_id OTA_EVENTS.EVENT_ID%TYPE;
551: l_course_start_date OTA_EVENTS.COURSE_START_DATE%TYPE;
552: l_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
553: l2_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;

Line 550: l_event_id OTA_EVENTS.EVENT_ID%TYPE;

546: l_activity_ovn OTA_ACTIVITY_VERSIONS.OBJECT_VERSION_NUMBER%TYPE;
547: l_event_type OTA_EVENTS.EVENT_TYPE%TYPE;
548: l2_event_type OTA_EVENTS.EVENT_TYPE%TYPE;
549: l_event_status OTA_EVENTS.EVENT_STATUS%TYPE;
550: l_event_id OTA_EVENTS.EVENT_ID%TYPE;
551: l_course_start_date OTA_EVENTS.COURSE_START_DATE%TYPE;
552: l_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
553: l2_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
554: l3_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;

Line 551: l_course_start_date OTA_EVENTS.COURSE_START_DATE%TYPE;

547: l_event_type OTA_EVENTS.EVENT_TYPE%TYPE;
548: l2_event_type OTA_EVENTS.EVENT_TYPE%TYPE;
549: l_event_status OTA_EVENTS.EVENT_STATUS%TYPE;
550: l_event_id OTA_EVENTS.EVENT_ID%TYPE;
551: l_course_start_date OTA_EVENTS.COURSE_START_DATE%TYPE;
552: l_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
553: l2_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
554: l3_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
555: l_course_start_time OTA_EVENTS.COURSE_START_TIME%TYPE;

Line 552: l_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;

548: l2_event_type OTA_EVENTS.EVENT_TYPE%TYPE;
549: l_event_status OTA_EVENTS.EVENT_STATUS%TYPE;
550: l_event_id OTA_EVENTS.EVENT_ID%TYPE;
551: l_course_start_date OTA_EVENTS.COURSE_START_DATE%TYPE;
552: l_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
553: l2_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
554: l3_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
555: l_course_start_time OTA_EVENTS.COURSE_START_TIME%TYPE;
556: l_course_end_time OTA_EVENTS.COURSE_END_TIME%TYPE;

Line 553: l2_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;

549: l_event_status OTA_EVENTS.EVENT_STATUS%TYPE;
550: l_event_id OTA_EVENTS.EVENT_ID%TYPE;
551: l_course_start_date OTA_EVENTS.COURSE_START_DATE%TYPE;
552: l_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
553: l2_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
554: l3_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
555: l_course_start_time OTA_EVENTS.COURSE_START_TIME%TYPE;
556: l_course_end_time OTA_EVENTS.COURSE_END_TIME%TYPE;
557: l_enrollment_start_date OTA_EVENTS.ENROLMENT_START_DATE%TYPE;

Line 554: l3_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;

550: l_event_id OTA_EVENTS.EVENT_ID%TYPE;
551: l_course_start_date OTA_EVENTS.COURSE_START_DATE%TYPE;
552: l_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
553: l2_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
554: l3_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
555: l_course_start_time OTA_EVENTS.COURSE_START_TIME%TYPE;
556: l_course_end_time OTA_EVENTS.COURSE_END_TIME%TYPE;
557: l_enrollment_start_date OTA_EVENTS.ENROLMENT_START_DATE%TYPE;
558: l_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;

Line 555: l_course_start_time OTA_EVENTS.COURSE_START_TIME%TYPE;

551: l_course_start_date OTA_EVENTS.COURSE_START_DATE%TYPE;
552: l_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
553: l2_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
554: l3_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
555: l_course_start_time OTA_EVENTS.COURSE_START_TIME%TYPE;
556: l_course_end_time OTA_EVENTS.COURSE_END_TIME%TYPE;
557: l_enrollment_start_date OTA_EVENTS.ENROLMENT_START_DATE%TYPE;
558: l_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
559: l2_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;

Line 556: l_course_end_time OTA_EVENTS.COURSE_END_TIME%TYPE;

552: l_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
553: l2_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
554: l3_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
555: l_course_start_time OTA_EVENTS.COURSE_START_TIME%TYPE;
556: l_course_end_time OTA_EVENTS.COURSE_END_TIME%TYPE;
557: l_enrollment_start_date OTA_EVENTS.ENROLMENT_START_DATE%TYPE;
558: l_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
559: l2_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
560: l3_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;

Line 557: l_enrollment_start_date OTA_EVENTS.ENROLMENT_START_DATE%TYPE;

553: l2_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
554: l3_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
555: l_course_start_time OTA_EVENTS.COURSE_START_TIME%TYPE;
556: l_course_end_time OTA_EVENTS.COURSE_END_TIME%TYPE;
557: l_enrollment_start_date OTA_EVENTS.ENROLMENT_START_DATE%TYPE;
558: l_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
559: l2_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
560: l3_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
561: l_default_event_owner_id OTA_EVENTS.OWNER_ID%TYPE;

Line 558: l_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;

554: l3_course_end_date OTA_EVENTS.COURSE_END_DATE%TYPE;
555: l_course_start_time OTA_EVENTS.COURSE_START_TIME%TYPE;
556: l_course_end_time OTA_EVENTS.COURSE_END_TIME%TYPE;
557: l_enrollment_start_date OTA_EVENTS.ENROLMENT_START_DATE%TYPE;
558: l_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
559: l2_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
560: l3_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
561: l_default_event_owner_id OTA_EVENTS.OWNER_ID%TYPE;
562: l_owner_id OTA_EVENTS.OWNER_ID%TYPE;

Line 559: l2_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;

555: l_course_start_time OTA_EVENTS.COURSE_START_TIME%TYPE;
556: l_course_end_time OTA_EVENTS.COURSE_END_TIME%TYPE;
557: l_enrollment_start_date OTA_EVENTS.ENROLMENT_START_DATE%TYPE;
558: l_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
559: l2_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
560: l3_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
561: l_default_event_owner_id OTA_EVENTS.OWNER_ID%TYPE;
562: l_owner_id OTA_EVENTS.OWNER_ID%TYPE;
563: l_maximum_attendees OTA_EVENTS.MAXIMUM_ATTENDEES%TYPE;

Line 560: l3_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;

556: l_course_end_time OTA_EVENTS.COURSE_END_TIME%TYPE;
557: l_enrollment_start_date OTA_EVENTS.ENROLMENT_START_DATE%TYPE;
558: l_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
559: l2_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
560: l3_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
561: l_default_event_owner_id OTA_EVENTS.OWNER_ID%TYPE;
562: l_owner_id OTA_EVENTS.OWNER_ID%TYPE;
563: l_maximum_attendees OTA_EVENTS.MAXIMUM_ATTENDEES%TYPE;
564: l_event_ovn OTA_EVENTS.OBJECT_VERSION_NUMBER%TYPE;

Line 561: l_default_event_owner_id OTA_EVENTS.OWNER_ID%TYPE;

557: l_enrollment_start_date OTA_EVENTS.ENROLMENT_START_DATE%TYPE;
558: l_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
559: l2_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
560: l3_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
561: l_default_event_owner_id OTA_EVENTS.OWNER_ID%TYPE;
562: l_owner_id OTA_EVENTS.OWNER_ID%TYPE;
563: l_maximum_attendees OTA_EVENTS.MAXIMUM_ATTENDEES%TYPE;
564: l_event_ovn OTA_EVENTS.OBJECT_VERSION_NUMBER%TYPE;
565: l_category OTA_CATEGORY_USAGES.CATEGORY%TYPE;

Line 562: l_owner_id OTA_EVENTS.OWNER_ID%TYPE;

558: l_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
559: l2_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
560: l3_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
561: l_default_event_owner_id OTA_EVENTS.OWNER_ID%TYPE;
562: l_owner_id OTA_EVENTS.OWNER_ID%TYPE;
563: l_maximum_attendees OTA_EVENTS.MAXIMUM_ATTENDEES%TYPE;
564: l_event_ovn OTA_EVENTS.OBJECT_VERSION_NUMBER%TYPE;
565: l_category OTA_CATEGORY_USAGES.CATEGORY%TYPE;
566: l_category_usage_id OTA_CATEGORY_USAGES.CATEGORY_USAGE_ID%TYPE;

Line 563: l_maximum_attendees OTA_EVENTS.MAXIMUM_ATTENDEES%TYPE;

559: l2_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
560: l3_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
561: l_default_event_owner_id OTA_EVENTS.OWNER_ID%TYPE;
562: l_owner_id OTA_EVENTS.OWNER_ID%TYPE;
563: l_maximum_attendees OTA_EVENTS.MAXIMUM_ATTENDEES%TYPE;
564: l_event_ovn OTA_EVENTS.OBJECT_VERSION_NUMBER%TYPE;
565: l_category OTA_CATEGORY_USAGES.CATEGORY%TYPE;
566: l_category_usage_id OTA_CATEGORY_USAGES.CATEGORY_USAGE_ID%TYPE;
567: l_cat_usages_ovn OTA_CATEGORY_USAGES.OBJECT_VERSION_NUMBER%TYPE;

Line 564: l_event_ovn OTA_EVENTS.OBJECT_VERSION_NUMBER%TYPE;

560: l3_enrollment_end_date OTA_EVENTS.ENROLMENT_END_DATE%TYPE;
561: l_default_event_owner_id OTA_EVENTS.OWNER_ID%TYPE;
562: l_owner_id OTA_EVENTS.OWNER_ID%TYPE;
563: l_maximum_attendees OTA_EVENTS.MAXIMUM_ATTENDEES%TYPE;
564: l_event_ovn OTA_EVENTS.OBJECT_VERSION_NUMBER%TYPE;
565: l_category OTA_CATEGORY_USAGES.CATEGORY%TYPE;
566: l_category_usage_id OTA_CATEGORY_USAGES.CATEGORY_USAGE_ID%TYPE;
567: l_cat_usages_ovn OTA_CATEGORY_USAGES.OBJECT_VERSION_NUMBER%TYPE;
568: l_cat_inc_ovn OTA_ACT_CAT_INCLUSIONS.OBJECT_VERSION_NUMBER%TYPE;

Line 583: l_event_title OTA_EVENTS_TL.TITLE%TYPE; -- MLS change _TL added

579: l_auto_enroll_status varchar2(1);
580: l_total_placed number;
581: l_sysdatetime varchar2(30);
582: l_user_name fnd_user.user_name%TYPE;
583: l_event_title OTA_EVENTS_TL.TITLE%TYPE; -- MLS change _TL added
584: l_synchronous_flag ota_category_usages.synchronous_flag%type;
585: l_online_flag ota_category_usages.synchronous_flag%type;
586:
587: cursor cur_get_event_id is

Line 600: ota_events

596: -- to_date(to_char(Course_start_date,'DD-MON-YYYY')||Course_start_time,'DD-MON-YYYYHH24:MI'),
597: to_date(to_char(Course_start_date,'DD/MM/YYYY')||Course_start_time,'DD/MM/YYYYHH24:MI'),
598: owner_id
599: from
600: ota_events
601: where
602: offering_id = p_offering_id and
603: business_group_id = p_business_group_id;
604:

Line 689: cursor cur_user (l_owner_id OTA_EVENTS.OWNER_ID%TYPE) is

685: WHERE type in ('A','P','E'))
686: and event_id = l_event_id;
687:
688:
689: cursor cur_user (l_owner_id OTA_EVENTS.OWNER_ID%TYPE) is
690: select user_name
691: from fnd_user
692: where employee_id = l_owner_id;
693:

Line 696: from ota_events_vl -- MLS change _vl added

692: where employee_id = l_owner_id;
693:
694: cursor cur_get_event_title is
695: select title
696: from ota_events_vl -- MLS change _vl added
697: where title = p_offering_title and
698: business_group_id = p_business_group_id;
699:
700: begin