[Home] [Help]
311: v_business_group_id number;
312: --
313: cursor get_activity is
314: select business_group_id
315: from ota_activity_definitions tad
316: where activity_id = p_activity_id;
317: --
318: cursor sel_unique_key is
319: select 'Y'
317: --
318: cursor sel_unique_key is
319: select 'Y'
320: from ota_activity_versions_vl tav
321: , ota_activity_definitions tad
322: where tav.version_name = p_version_name
323: and tav.activity_id = tad.activity_id
324: and (p_activity_version_id is null or
325: (p_activity_version_id is not null and
1751: v_exists varchar2(1);
1752: --
1753: cursor sel_activity is
1754: select 'Y'
1755: from ota_activity_definitions tad
1756: where tad.activity_id = p_activity_id
1757: and tad.multiple_con_versions_flag = 'N' ;
1758: --
1759: Begin
1816: , tav.start_date
1817: , tav.end_date
1818: , tav.object_version_number
1819: from ota_activity_versions tav
1820: , ota_activity_definitions tad
1821: where tad.activity_id = p_activity_id
1822: and tad.multiple_con_versions_flag = 'N'
1823: and tav.activity_id = tad.activity_id
1824: and tav.start_date =
1890: --
1891: cursor get_versions is
1892: select tav.end_date
1893: from ota_activity_versions tav
1894: , ota_activity_definitions tad
1895: where tav.activity_id = tad.activity_id --p_activity_id
1896: and tad.activity_id = p_activity_id -- Bug 2808274
1897: and tad.multiple_con_versions_flag = 'N'
1898: order by tav.end_date desc;
1942: v_proc varchar2(72) := g_package||'check_version_after_supersede';
1943: --
1944: cursor sel_latest_version is
1945: select tav.superseded_by_act_version_id
1946: from ota_activity_definitions tad
1947: , ota_activity_versions tav
1948: where tad.activity_id = p_activity_id
1949: and tad.multiple_con_versions_flag = 'N'
1950: and tav.activity_id = tad.activity_id