[Home] [Help]
247: cursor c_exist is
248: select 1
249: FROM ota_activity_versions tav
250: WHERE
251: not exists (select 1 from ota_offerings off where off.activity_version_id = tav.activity_version_id )
252: and ( exists (select 1 from ota_events evt where evt.activity_version_id = tav.activity_version_id )
253: or ( exists (select 1 from ota_resource_usages rud where rud.activity_version_id = tav.activity_version_id)
254: and not exists (select 1 from ota_resource_usages rud1 where rud1.activity_version_id= tav.activity_version_id
255: and rud1.offering_id is null))
342: -- ----------------------------------------------------------------------------
343: function check_offering_event_link return boolean is
344: cursor csr_off_evt_link is
345: select evt.event_id,evt.activity_version_id evt_act_Ver_id, off.activity_version_id,evt.parent_offering_id
346: from ota_events evt, ota_offerings off
347: where evt.parent_offering_id = off.offering_id
348: and evt.activity_version_id <> off.activity_version_id ;
349:
350: cursor csr_off_evt_lang is
348: and evt.activity_version_id <> off.activity_version_id ;
349:
350: cursor csr_off_evt_lang is
351: select evt.event_id,evt.activity_version_id evt_act_Ver_id, off.activity_version_id,evt.parent_offering_id,evt.language_id evt_lang, off.language_id off_lang
352: from ota_events evt, ota_offerings off
353: where evt.parent_offering_id = off.offering_id
354: and evt.language_id <> off.language_id ;
355:
356:
483: ,get_upgrade_name(CREATE_OFFERINGS,CONC_UPGRADE_ID)
484: ,'OTA_ACTIVITY_VERSIONS'
485: ,'ACTIVITY_VERSION_ID');
486:
487: update ota_offerings
488: set learning_object_id = null
489: where learning_object_id = -1;
490: end if;
491:
510: ,'EVENT_ID');
511: end if;
512:
513: -- 2733966
514: -- 8) Populate Language_code column in OTA_Offerings, OTA_Learning_Objects and
515: -- OTA_Competence_languages if it is null.
516: ota_classic_upgrade.upgrade_language_code;
517:
518: