APPS.OTA_REPROCESS_CLASSIC_UPGRADE dependencies on OTA_CLASSIC_UPGRADE

Line 430: ota_classic_upgrade.migrate_lookup;

426: -- 1) Migrate Lookups
427: if do_migrate_lookup then
428: write_log('Migrating Lookup:FREQUENCY');
429: l_upgrade_done := true;
430: ota_classic_upgrade.migrate_lookup;
431: end if;
432: -- 2) Upgrade Category
433: if do_upgrade_category then
434: write_log('Upgrading Category definitions');

Line 436: submit_upgrade( 'ota_classic_upgrade.upgrade_category'

432: -- 2) Upgrade Category
433: if do_upgrade_category then
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;

Line 443: ota_classic_upgrade.upgrade_act_cat_inclusions;

439: ,'CATEGORY_USAGE_ID');
440: end if;
441:
442: -- Upgrade Act cat Inclusions
443: ota_classic_upgrade.upgrade_act_cat_inclusions;
444:
445: -- Upgrade Online delivery modes
446: ota_classic_upgrade.upgrade_online_delivery_modes(CONC_UPGRADE_ID);
447:

Line 446: ota_classic_upgrade.upgrade_online_delivery_modes(CONC_UPGRADE_ID);

442: -- Upgrade Act cat Inclusions
443: ota_classic_upgrade.upgrade_act_cat_inclusions;
444:
445: -- Upgrade Online delivery modes
446: ota_classic_upgrade.upgrade_online_delivery_modes(CONC_UPGRADE_ID);
447:
448: -- Create root dms and categories for BGS
449: ota_classic_upgrade.create_root_ctg_and_dms;
450:

Line 449: ota_classic_upgrade.create_root_ctg_and_dms;

445: -- Upgrade Online delivery modes
446: ota_classic_upgrade.upgrade_online_delivery_modes(CONC_UPGRADE_ID);
447:
448: -- Create root dms and categories for BGS
449: ota_classic_upgrade.create_root_ctg_and_dms;
450:
451: ota_classic_upgrade.create_ctg_dm_for_act_bg(CONC_UPGRADE_ID);
452:
453:

Line 451: ota_classic_upgrade.create_ctg_dm_for_act_bg(CONC_UPGRADE_ID);

447:
448: -- Create root dms and categories for BGS
449: ota_classic_upgrade.create_root_ctg_and_dms;
450:
451: ota_classic_upgrade.create_ctg_dm_for_act_bg(CONC_UPGRADE_ID);
452:
453:
454: --3) Create Category for Activity
455: if do_create_ctg_for_tad then

Line 458: submit_upgrade( 'ota_classic_upgrade.create_category_for_activity'

454: --3) Create Category for Activity
455: if do_create_ctg_for_tad then
456: write_log('Creating category for activity');
457: l_upgrade_done := true;
458: submit_upgrade( 'ota_classic_upgrade.create_category_for_activity'
459: ,get_upgrade_name(ACTIVITY_TO_CATEGORY,CONC_UPGRADE_ID)
460: ,'OTA_ACTIVITY_DEFINITIONS'
461: ,'ACTIVITY_ID');
462: end if;

Line 470: submit_upgrade( 'ota_classic_upgrade.create_activity_for_category'

466: -- 4) Create Activity for Category
467: if do_create_tad_for_ctg then
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;

Line 476: ota_classic_upgrade.upgrade_root_category_dates;

472: ,'OTA_CATEGORY_USAGES'
473: ,'CATEGORY_USAGE_ID');
474: end if;
475:
476: ota_classic_upgrade.upgrade_root_category_dates;
477:
478: --5) Create Offerings
479: if do_create_offerings then
480: write_log('Creating Offerings');

Line 482: submit_upgrade( 'ota_classic_upgrade.create_offering'

478: --5) Create Offerings
479: if do_create_offerings then
480: write_log('Creating Offerings');
481: l_upgrade_done := true;
482: submit_upgrade( 'ota_classic_upgrade.create_offering'
483: ,get_upgrade_name(CREATE_OFFERINGS,CONC_UPGRADE_ID)
484: ,'OTA_ACTIVITY_VERSIONS'
485: ,'ACTIVITY_VERSION_ID');
486:

Line 496: submit_upgrade( 'ota_classic_upgrade.upgrade_event_associations'

492: -- 6) Upgrade Event Associations
493: if do_upgrade_evt_assoc then
494: write_log (' Upgrading event Associations');
495: l_upgrade_done := true;
496: submit_upgrade( 'ota_classic_upgrade.upgrade_event_associations'
497: ,get_upgrade_name(UPG_EVENT_ASSOCIATIONS,CONC_UPGRADE_ID)
498: ,'OTA_EVENT_ASSOCIATIONS'
499: ,'EVENT_ASSOCIATION_ID');
500:

Line 507: submit_upgrade( 'ota_classic_upgrade.upgrade_events'

503: -- 7) Upgrade Events
504: if do_upgrade_evt then
505: write_log (' Upgrading Events');
506: l_upgrade_done := true;
507: submit_upgrade( 'ota_classic_upgrade.upgrade_events'
508: ,get_upgrade_name(UPG_EVENTS,CONC_UPGRADE_ID)
509: ,'OTA_EVENTS'
510: ,'EVENT_ID');
511: end if;

Line 516: ota_classic_upgrade.upgrade_language_code;

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:
519: if l_upgrade_done then
520: if check_errors(CONC_UPGRADE_ID) then