APPS.OTA_REPROCESS_CLASSIC_UPGRADE dependencies on OTA_CATEGORY_USAGES

Line 172: from ota_category_usages ocu

168: -- ----------------------------------------------------------------------------
169: function do_upgrade_category return boolean is
170: cursor c_exist is
171: select 1
172: from ota_category_usages ocu
173: where ocu.category = (SELECT lkp.meaning
174: FROM hr_lookups lkp
175: WHERE lkp.lookup_code = ocu.category
176: AND lkp.lookup_type = 'ACTIVITY_CATEGORY')

Line 178: from ota_category_usages_tl oct

174: FROM hr_lookups lkp
175: WHERE lkp.lookup_code = ocu.category
176: AND lkp.lookup_type = 'ACTIVITY_CATEGORY')
177: or not exists (select 1
178: from ota_category_usages_tl oct
179: where oct.category_usage_id = ocu.category_usage_id)
180: and rownum = 1 ;
181:
182: l_exists boolean := false;

Line 222: from ota_category_usages ocu

218: -- ----------------------------------------------------------------------------
219: function do_create_tad_for_ctg return boolean is
220: cursor c_exist is
221: select 1
222: from ota_category_usages ocu
223: where ocu.type = 'C'
224: and not exists (select category_usage_id
225: from ota_activity_definitions tad
226: where tad.category_usage_id is not null

Line 438: ,'OTA_CATEGORY_USAGES'

434: write_log('Upgrading Category definitions');
435: l_upgrade_done := true;
436: submit_upgrade( 'ota_classic_upgrade.upgrade_category'
437: ,get_upgrade_name(UPGRADE_CATEGORY,CONC_UPGRADE_ID)
438: ,'OTA_CATEGORY_USAGES'
439: ,'CATEGORY_USAGE_ID');
440: end if;
441:
442: -- Upgrade Act cat Inclusions

Line 472: ,'OTA_CATEGORY_USAGES'

468: write_log('Creating activity for category');
469: l_upgrade_done := true;
470: submit_upgrade( 'ota_classic_upgrade.create_activity_for_category'
471: ,get_upgrade_name(CATEGORY_TO_ACTIVITY,CONC_UPGRADE_ID)
472: ,'OTA_CATEGORY_USAGES'
473: ,'CATEGORY_USAGE_ID');
474: end if;
475:
476: ota_classic_upgrade.upgrade_root_category_dates;