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_ACTIVITY_VERSIONS

Line 101: FROM OTA_ACTIVITY_VERSIONS TAV

97: Fetch csr_check_dm into l_delivery_mode_id ;
98: If csr_check_dm%NOTfound then
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

Line 374: ,ota_activity_versions tav

370:
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'

Line 474: ,ota_activity_versions tav

470:
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'

Line 584: from ota_activity_versions tav

580:
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

Line 594: l_activity_version_id ota_activity_versions.activity_version_id%type;

590: where off.activity_version_id = tav.activity_version_id
591: and rownum =1);
592:
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;

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 932: FROM OTA_ACTIVITY_VERSIONS TAV

928: ,p_update_id in number default 1) is
929:
930: CURSOR csr_activity_versions (p_act_id number)is
931: SELECT tav.activity_version_id
932: FROM OTA_ACTIVITY_VERSIONS TAV
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

Line 958: l_act_ver_id ota_activity_versions.activity_version_id%type;

954:
955:
956: l_equivalent_tad ota_activity_definitions.activity_id%type;
957: l_equivalent_ctu ota_category_usages.category_usage_id%type;
958: l_act_ver_id ota_activity_versions.activity_version_id%type;
959: l_count number;
960: l_err_code varchar2(72);
961: l_err_msg varchar2(2000);
962:

Line 981: update Ota_Activity_Versions

977: l_equivalent_tad := -1;
978: open csr_equivalent_tad(l_equivalent_ctu);
979: fetch csr_equivalent_tad into l_equivalent_tad;
980: if csr_equivalent_tad%found then
981: update Ota_Activity_Versions
982: set activity_id = l_equivalent_tad
983: where activity_version_id = l_act_ver_id;
984: end if;
985: close csr_equivalent_tad;

Line 1045: Update Ota_Activity_Versions

1041: ,p_activity_id in number)
1042: is
1043: begin
1044:
1045: Update Ota_Activity_Versions
1046: Set Business_group_id = p_business_group_id
1047: Where Activity_id = p_activity_id
1048: and Business_group_id is NULL ;
1049:

Line 1241: from ota_activity_versions

1237:
1238:
1239: cursor csr_min_start_date(p_act_id number) is
1240: select min(start_date)
1241: from ota_activity_versions
1242: where activity_id = p_act_id;
1243:
1244:
1245: l_object_version_number number;

Line 1416: -- and ota_activity_versions table.

1412: -- ----------------------------------------------------------------------------
1413: -- |--------------------------< Create_Offering >-----------------------------|
1414: -- ----------------------------------------------------------------------------
1415: -- This procedure creates the Offering based on the records exists in ota_events
1416: -- and ota_activity_versions table.
1417: PROCEDURE Create_Offering(
1418: p_process_control IN varchar2,
1419: p_start_pkid IN number,
1420: p_end_pkid IN number,

Line 1464: FROM ota_activity_versions_vl tav, ota_activity_definitions tad

1460: ,tav.budget_cost
1461: ,tav.budget_currency_code
1462: ,tav.vendor_id
1463: ,tav.rco_id
1464: FROM ota_activity_versions_vl tav, ota_activity_definitions tad
1465: WHERE tav.activity_id =tad.activity_id
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

Line 1740: From Ota_activity_versions_tl M

1736: M.Creation_date,
1737: M.Last_Updated_By,
1738: M.Last_Update_Date,
1739: M.Last_Update_Login
1740: From Ota_activity_versions_tl M
1741: Where M.activity_version_id = l_act_ver_id;
1742:
1743:
1744: begin

Line 1977: from ota_activity_versions

1973: End loop; -- Activity Version loop ends here
1974:
1975:
1976: Select count(Activity_version_id) into l_rows_processed
1977: from ota_activity_versions
1978: Where activity_Version_id between p_start_pkid and p_end_pkid ;
1979:
1980: p_rows_processed := l_rows_processed;
1981: