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_CATEGORY_USAGES

Line 565: l_category OTA_CATEGORY_USAGES.CATEGORY%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;
569: l_primary_flag OTA_ACT_CAT_INCLUSIONS.PRIMARY_FLAG%TYPE;

Line 566: l_category_usage_id OTA_CATEGORY_USAGES.CATEGORY_USAGE_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;
569: l_primary_flag OTA_ACT_CAT_INCLUSIONS.PRIMARY_FLAG%TYPE;
570: l_dummy varchar2(6);

Line 567: l_cat_usages_ovn OTA_CATEGORY_USAGES.OBJECT_VERSION_NUMBER%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;
569: l_primary_flag OTA_ACT_CAT_INCLUSIONS.PRIMARY_FLAG%TYPE;
570: l_dummy varchar2(6);
571: l_primary_count number(1);

Line 584: l_synchronous_flag ota_category_usages.synchronous_flag%type;

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
588: select

Line 585: l_online_flag ota_category_usages.synchronous_flag%type;

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
588: select
589: event_id,

Line 611: ota_category_usages

607: cursor cur_get_cat_usage_id is
608: select
609: category_usage_id
610: from
611: ota_category_usages
612: where
613: business_group_id = p_business_group_id and
614: type = 'DM' and
615: category = l_category;

Line 644: ota_category_usages OCU,

640: cursor cur_get_primary_count is
641: select
642: count(*)
643: from
644: ota_category_usages OCU,
645: ota_act_cat_inclusions OAC
646: where
647: OAC.activity_version_id = p_activity_version_id and
648: OAC.category_usage_id = OCU.category_usage_id and