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_CLASSIC_UPGRADE dependencies on OTA_ACT_CAT_INCLUSIONS

Line 103: (SELECT ACI.ACTIVITY_VERSION_ID FROM OTA_ACT_CAT_INCLUSIONS ACI,OTA_CATEGORY_USAGES CTU

99: begin
100: SELECT MIN(TAV.START_DATE) INTO l_course_min_st_dt
101: FROM OTA_ACTIVITY_VERSIONS TAV
102: WHERE NOT EXISTS
103: (SELECT ACI.ACTIVITY_VERSION_ID FROM OTA_ACT_CAT_INCLUSIONS ACI,OTA_CATEGORY_USAGES CTU
104: WHERE ACI.ACTIVITY_VERSION_ID = TAV.ACTIVITY_VERSION_ID
105: AND ACI.CATEGORY_USAGE_ID = CTU.CATEGORY_USAGE_ID
106: AND CTU.TYPE = 'DM') ;
107: If l_course_min_st_dt is NULL then

Line 304: update ota_act_cat_inclusions

300: -- |---------------------------< upgrade_act_cat_inclusions >-----------------|
301: -- ----------------------------------------------------------------------------
302: procedure upgrade_act_cat_inclusions is
303: begin
304: update ota_act_cat_inclusions
305: set activity_category = null
306: where activity_category is not null
307: and category_usage_id is not null;
308: end upgrade_act_cat_inclusions;

Line 375: ,ota_act_cat_inclusions aci

371: cursor c_online_courses(p_dm_id number) is
372: select tav.activity_version_id
373: from ota_category_usages ctu
374: ,ota_activity_versions tav
375: ,ota_act_cat_inclusions aci
376: where aci.category_usage_id = ctu.category_usage_id
377: and tav.activity_version_id = aci.activity_version_id
378: and ctu.type = 'DM'
379: and tav.rco_id is not null

Line 382: or not exists(select 1 from ota_act_cat_inclusions aci1

378: and ctu.type = 'DM'
379: and tav.rco_id is not null
380: and ctu.category_usage_id = p_dm_id
381: and ( aci.primary_flag = 'Y'
382: or not exists(select 1 from ota_act_cat_inclusions aci1
383: where aci1.activity_version_id = tav.activity_version_id
384: and aci1.category_usage_id <> p_dm_id)) ;
385:
386: cursor c_online_events(p_act_ver_id number) is

Line 431: delete from ota_act_cat_inclusions

427: l_category_usage_id := create_delivery_mode(c_ol_dms.category||DM_COPY_SUFFIX,
428: l_online_flag,
429: l_sync_flag,c_ol_dms.business_group_id);
430:
431: delete from ota_act_cat_inclusions
432: where activity_version_id = c_ol_tav.activity_version_id
433: and category_usage_id = c_ol_dms.category_usage_id;
434:
435: Insert into ota_act_cat_inclusions

Line 435: Insert into ota_act_cat_inclusions

431: delete from ota_act_cat_inclusions
432: where activity_version_id = c_ol_tav.activity_version_id
433: and category_usage_id = c_ol_dms.category_usage_id;
434:
435: Insert into ota_act_cat_inclusions
436: ( activity_category
437: ,activity_version_id
438: ,category_usage_id
439: ,object_version_number

Line 475: ,ota_act_cat_inclusions aci

471: cursor c_online_courses(p_dm_id number) is
472: select tav.activity_version_id
473: from ota_category_usages ctu
474: ,ota_activity_versions tav
475: ,ota_act_cat_inclusions aci
476: where aci.category_usage_id = ctu.category_usage_id
477: and tav.activity_version_id = aci.activity_version_id
478: and ctu.type = 'DM'
479: and tav.rco_id is not null

Line 529: update ota_act_cat_inclusions aci

525:
526:
527: begin
528:
529: update ota_act_cat_inclusions aci
530: set primary_flag = decode(category_usage_id, c_ol_dms.category_usage_id,'Y','N') --'N'
531: where aci.activity_version_id = c_ol_tav.activity_version_id
532: and aci.category_usage_id in (select ctu.category_usage_id
533: from ota_Category_usages ctu

Line 585: ,ota_act_cat_inclusions aci

581: cursor c_attach_online_dms(p_dm_id in number)is
582: select tav.activity_version_id
583: ,aci.primary_flag
584: from ota_activity_versions tav
585: ,ota_act_cat_inclusions aci
586: where aci.category_usage_id = p_dm_id
587: and tav.activity_version_id = aci.activity_version_id
588: and tav.rco_id is null
589: and not exists (select 1 from ota_offerings off

Line 597: l_primary_flag ota_act_cat_inclusions.primary_flag%type;

593:
594: l_activity_version_id ota_activity_versions.activity_version_id%type;
595: l_dm_start_date date;
596: l_category_usage_id ota_category_usages.category_usage_id%type;
597: l_primary_flag ota_act_cat_inclusions.primary_flag%type;
598: l_found number;
599:
600: l_err_code varchar2(72);
601: l_err_msg varchar2(2000);

Line 615: delete from ota_act_cat_inclusions

611: l_category_usage_id := null;
612: begin
613: l_category_usage_id := create_delivery_mode(c_ol_dms.category||DM_COPY_SUFFIX
614: ,'N','Y',c_ol_dms.business_group_id);
615: delete from ota_act_cat_inclusions
616: where category_usage_id = c_ol_dms.category_usage_id
617: and activity_version_id = l_activity_version_id;
618:
619: Insert into ota_act_cat_inclusions

Line 619: Insert into ota_act_cat_inclusions

615: delete from ota_act_cat_inclusions
616: where category_usage_id = c_ol_dms.category_usage_id
617: and activity_version_id = l_activity_version_id;
618:
619: Insert into ota_act_cat_inclusions
620: ( activity_category
621: ,activity_version_id
622: ,category_usage_id
623: ,object_version_number

Line 887: From ota_activity_versions tav,ota_act_cat_inclusions aci

883: l_course_max_end_dt := dm.end_date_active;
884:
885: Select Min(tav.Start_Date),Max(tav.End_date),Max(Decode(tav.End_date,NULL,'Y','N'))
886: into l_course_min_st_dt, l_course_max_end_dt,l_course_end_dt_has_null
887: From ota_activity_versions tav,ota_act_cat_inclusions aci
888: Where tav.activity_version_id = aci.activity_version_id
889: and aci.category_usage_id = dm.category_usage_id;
890:
891: If l_course_end_dt_has_null = 'Y' then

Line 937: FROM ota_act_cat_inclusions cat,

933: WHERE tav.activity_id = p_act_id;
934:
935: CURSOR csr_primary_present (p_act_ver_id number) is
936: SELECT ctu.category_usage_id
937: FROM ota_act_cat_inclusions cat,
938: ota_category_usages ctu
939: WHERE ctu.category_usage_id = cat.category_usage_id
940: AND ctu.type = 'C'
941: AND cat.primary_flag='Y'

Line 951: FROM ota_act_cat_inclusions cat

947: where category_usage_id = p_ctu_id;
948:
949: CURSOR csr_dup_act_cat (p_act_ver_id number, p_category_usage_id number) is
950: SELECT 1
951: FROM ota_act_cat_inclusions cat
952: WHERE cat.category_usage_id =p_category_usage_id
953: AND cat.activity_version_id = p_act_ver_id;
954:
955:

Line 994: Insert into ota_act_cat_inclusions

990: open csr_dup_act_cat(l_act_ver_id,p_category_usage_id);
991: fetch csr_dup_act_cat into l_count;
992: if csr_dup_act_cat%notfound then
993: begin
994: Insert into ota_act_cat_inclusions
995: ( activity_category
996: ,activity_version_id
997: ,category_usage_id
998: ,object_version_number

Line 1025: update ota_act_cat_inclusions

1021: end;
1022:
1023: elsif csr_dup_act_cat%found and l_primary_flag = 'Y' then
1024:
1025: update ota_act_cat_inclusions
1026: set primary_flag = 'Y'
1027: where category_usage_id = p_category_usage_id
1028: and activity_version_id = l_act_ver_id;
1029:

Line 1470: FROM ota_act_cat_inclusions aci ,

1466: AND tav.activity_version_id between p_start_pkid and p_end_pkid ;
1467:
1468: CURSOR c_get_dm(p_act_ver_id number)is
1469: SELECT aci.CATEGORY_USAGE_ID
1470: FROM ota_act_cat_inclusions aci ,
1471: OTA_CATEGORY_USAGES TCU
1472: WHERE ACI.CATEGORY_USAGE_ID = TCU.CATEGORY_USAGE_ID
1473: AND TCU.TYPE = 'DM'
1474: AND primary_flag = 'Y'

Line 1479: FROM ota_act_cat_inclusions aci ,

1475: AND activity_version_id = p_act_ver_id;
1476:
1477: CURSOR c_get_dm1(p_act_ver_id number)is
1478: SELECT aci.CATEGORY_USAGE_ID
1479: FROM ota_act_cat_inclusions aci ,
1480: OTA_CATEGORY_USAGES TCU
1481: WHERE ACI.CATEGORY_USAGE_ID = TCU.CATEGORY_USAGE_ID
1482: AND rownum = 1
1483: AND TCU.TYPE = 'DM'

Line 1519: from ota_act_cat_inclusions aci ,

1515:
1516: cursor c_get_tav_dms(p_tav_id number) is
1517: select ctu.category_usage_id,
1518: ctu.category
1519: from ota_act_cat_inclusions aci ,
1520: ota_category_usages_vl ctu
1521: where aci.activity_version_id = p_tav_id
1522: and ctu.category_usage_id = aci.category_usage_id
1523: and ctu.type = 'DM';

Line 1960: delete from ota_act_cat_inclusions

1956: ,p_upgrade_name => UPGRADE_NAME);
1957: end loop;
1958:
1959: -- Delete Delivery Mode
1960: delete from ota_act_cat_inclusions
1961: where activity_version_id = l_act_ver_id
1962: and category_usage_id in (select category_usage_id
1963: from ota_category_usages
1964: where type = 'DM');