APPS.OTA_CLASSIC_UPGRADE dependencies on OTA_COMPETENCE_LANGUAGES

Line 2270: -- This procedure populates Language_code in OTA_COMPETENCE_LANGUAGES if it is null.

2266: --enh 2733966 --
2267: -- ----------------------------------------------------------------------------
2268: -- |--------------------------< Upgrade_Comp_Lang_Code >-----------------------|
2269: -- ----------------------------------------------------------------------------
2270: -- This procedure populates Language_code in OTA_COMPETENCE_LANGUAGES if it is null.
2271:
2272: Procedure Upgrade_Comp_Lang_Code is
2273:
2274: begin

Line 2275: update ota_competence_languages a

2271:
2272: Procedure Upgrade_Comp_Lang_Code is
2273:
2274: begin
2275: update ota_competence_languages a
2276: set a.language_code=decode(a.language_code, null, (select fnl.language_code
2277: FROM fnd_languages fl,
2278: fnd_natural_languages fnl WHERE
2279: fl.iso_language_3 = UPPER(fnl.iso_language_3) AND fl.iso_territory =

Line 2289: -- and OTA_COMPETENCE_LANGUAGES and populate it based on Langauge_Id

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
2293: select 1

Line 2304: from ota_competence_languages

2300: where language_code is null;
2301:
2302: cursor c_exist_comp is
2303: select 1
2304: from ota_competence_languages
2305: where language_code is null;
2306:
2307:
2308: l_exists_off boolean := false;

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

2402: exception
2403: when others then
2404:
2405: l_err_code := SQLCODE;
2406: l_err_msg := nvl(substr(SQLERRM,1,2000),'Error When upgrading Language code for OTA_COMPETENCE_LANGUAGES');
2407:
2408: add_log_entry( p_table_name => 'UPG_LANGUAGE_CODE'
2409: ,p_source_primary_key => '99999'
2410: ,p_object_value => 'No Language code updated for OTA_COMPETENCE_LANGUAGES'

Line 2410: ,p_object_value => 'No Language code updated for OTA_COMPETENCE_LANGUAGES'

2406: l_err_msg := nvl(substr(SQLERRM,1,2000),'Error When upgrading Language code for OTA_COMPETENCE_LANGUAGES');
2407:
2408: add_log_entry( p_table_name => 'UPG_LANGUAGE_CODE'
2409: ,p_source_primary_key => '99999'
2410: ,p_object_value => 'No Language code updated for OTA_COMPETENCE_LANGUAGES'
2411: ,p_message_text => l_err_msg
2412: ,p_upgrade_id => l_upg_id
2413: ,p_process_date => get_process_date(l_upg_id,'UPG_LANGUAGE_CODE')
2414: ,p_log_type => LOG_TYPE_E