APPS.OTA_CLASSIC_UPGRADE dependencies on FND_NATURAL_LANGUAGES

Line 1442: l_language_code fnd_natural_languages.language_code%type;

1438: l_duration_units ota_offerings.duration_units%Type;
1439: l_duration ota_offerings.duration%Type;
1440: l_default_language Fnd_languages.Language_id%Type;
1441:
1442: l_language_code fnd_natural_languages.language_code%type;
1443:
1444: l_off_dup_lang number;
1445:
1446: CURSOR c_get_ids is

Line 1528: SELECT fl.language_id, fnl.language_code FROM fnd_languages fl, fnd_natural_languages fnl

1524:
1525: cursor c_lang_code_for_langid(p_lang_id number) is
1526: select b.language_code LanguageCode
1527: from (
1528: SELECT fl.language_id, fnl.language_code FROM fnd_languages fl, fnd_natural_languages fnl
1529: WHERE fl.iso_language_3 = UPPER(fnl.iso_language_3)
1530: AND fl.iso_territory = fnl.iso_territory ) a,
1531: ota_natural_languages_v b
1532: where a.language_code(+) = b.language_code

Line 1535: l_fnd_lang_code fnd_natural_languages.language_code%type;

1531: ota_natural_languages_v b
1532: where a.language_code(+) = b.language_code
1533: and a.language_id = p_lang_id;
1534:
1535: l_fnd_lang_code fnd_natural_languages.language_code%type;
1536:
1537: l_new_dm_name ota_category_usages.category%type;
1538:
1539:

Line 2241: fnd_natural_languages fnl WHERE

2237: begin
2238: update ota_offerings a
2239: set a.language_code=decode(a.language_code, null, (select fnl.language_code
2240: FROM fnd_languages fl,
2241: fnd_natural_languages fnl WHERE
2242: fl.iso_language_3 = UPPER(fnl.iso_language_3) AND fl.iso_territory =
2243: fnl.iso_territory and fl.language_id=a.language_id),a.language_code);
2244:
2245:

Line 2260: fnd_natural_languages fnl WHERE

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 =
2262: fnl.iso_territory and fl.language_id=a.language_id),a.language_code);
2263:
2264: end Upgrade_LO_Lang_Code;

Line 2278: fnd_natural_languages fnl WHERE

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 =
2280: fnl.iso_territory and fl.language_id=a.language_id),a.language_code);
2281:
2282: end Upgrade_Comp_Lang_Code;