APPS.OTA_CLASSIC_UPGRADE dependencies on OTA_LEARNING_OBJECTS

Line 2252: -- This procedure populates Language_code in OTA_LEARNING_OBJECTS if it is null.

2248: --enh 2733966 --
2249: -- ----------------------------------------------------------------------------
2250: -- |--------------------------< Upgrade_LO_Lang_Code >-----------------------|
2251: -- ----------------------------------------------------------------------------
2252: -- This procedure populates Language_code in OTA_LEARNING_OBJECTS if it is null.
2253:
2254: Procedure Upgrade_LO_Lang_Code is
2255:
2256: begin

Line 2257: update ota_learning_objects a

2253:
2254: Procedure Upgrade_LO_Lang_Code is
2255:
2256: begin
2257: update ota_learning_objects a
2258: set a.language_code=decode(a.language_code, null, (select fnl.language_code
2259: FROM fnd_languages fl,
2260: fnd_natural_languages fnl WHERE
2261: fl.iso_language_3 = UPPER(fnl.iso_language_3) AND fl.iso_territory =

Line 2288: -- This procedure checks if Language_Code is null in OTA_OFFERINGS, OTA_LEARNING_OBJECTS

2284: --enh 2733966 --
2285: -- ----------------------------------------------------------------------------
2286: -- |--------------------------< Upgrade_Language_Code >----------------------------|
2287: -- ----------------------------------------------------------------------------
2288: -- This procedure checks if Language_Code is null in OTA_OFFERINGS, OTA_LEARNING_OBJECTS
2289: -- and OTA_COMPETENCE_LANGUAGES and populate it based on Langauge_Id
2290: Procedure Upgrade_Language_Code is
2291:
2292: cursor c_exist_off is

Line 2299: from ota_learning_objects

2295: where language_code is null;
2296:
2297: cursor c_exist_lo is
2298: select 1
2299: from ota_learning_objects
2300: where language_code is null;
2301:
2302: cursor c_exist_comp is
2303: select 1

Line 2376: l_err_msg := nvl(substr(SQLERRM,1,2000),'Error When upgrading Language code for OTA_LEARNING_OBJECTS');

2372: exception
2373: when others then
2374:
2375: l_err_code := SQLCODE;
2376: l_err_msg := nvl(substr(SQLERRM,1,2000),'Error When upgrading Language code for OTA_LEARNING_OBJECTS');
2377:
2378: add_log_entry( p_table_name => 'UPG_LANGUAGE_CODE'
2379: ,p_source_primary_key => '9999'
2380: ,p_object_value => 'No Language code updated for OTA_LEARNING_OBJETCS'

Line 2864: l_learning_object_id ota_learning_objects.learning_object_id%Type ;

2860: l_process_date ota_upgrade_log.process_date%Type;
2861:
2862: l_event_id number;
2863: l_business_group_id number;
2864: l_learning_object_id ota_learning_objects.learning_object_id%Type ;
2865:
2866: CURSOR c_booking_id IS
2867: SELECT Booking_id, event_id,content_player_status,business_group_id,object_version_number,
2868: delegate_person_id,