APPS.OTA_ILEARNING dependencies on OTA_ACT_CAT_INCLUSIONS

Line 568: l_cat_inc_ovn OTA_ACT_CAT_INCLUSIONS.OBJECT_VERSION_NUMBER%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);
572: l_sysdate date;

Line 569: l_primary_flag OTA_ACT_CAT_INCLUSIONS.PRIMARY_FLAG%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);
572: l_sysdate date;
573: l_no_of_enrollments number(9);

Line 634: ota_act_cat_inclusions

630: cursor cur_check_cat_inclusions is
631: select
632: 'dummy'
633: from
634: ota_act_cat_inclusions
635: where
636: activity_version_id = p_activity_version_id and
637: category_usage_id = l_category_usage_id;
638:

Line 645: ota_act_cat_inclusions OAC

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
649: OCU.type = 'DM' and