eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_CLASSIC_UPGRADE dependencies on FND_LANGUAGES

Line 56: l_lang_code fnd_languages.language_code%type;

52: -- ----------------------------------------------------------------------------
53: -- |-------------------------< get_lang_code >-----------------------------|
54: -- ----------------------------------------------------------------------------
55: function get_lang_code(p_evt_language_id in number,p_tav_language_id in number) return varchar2 is
56: l_lang_code fnd_languages.language_code%type;
57: cursor c_lang_code is
58: select fl.language_code
59: from fnd_languages fl
60: where fl.language_id = Nvl(p_evt_language_id,p_tav_language_id);

Line 59: from fnd_languages fl

55: function get_lang_code(p_evt_language_id in number,p_tav_language_id in number) return varchar2 is
56: l_lang_code fnd_languages.language_code%type;
57: cursor c_lang_code is
58: select fl.language_code
59: from fnd_languages fl
60: where fl.language_id = Nvl(p_evt_language_id,p_tav_language_id);
61:
62: begin
63: open c_lang_code;

Line 712: FROM fnd_languages lng

708:
709: CURSOR csr_installed_languages is
710: SELECT lng.language_code,
711: lng.nls_Language
712: FROM fnd_languages lng
713: WHERE lng.installed_flag in ('I', 'B');
714:
715:
716:

Line 718: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');

714:
715:
716:
717:
718: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');
719: l_current_nls_language VARCHAR2(30);
720: l_current_language FND_LANGUAGES.LANGUAGE_CODE%TYPE ;
721: l_rows_processed number := 0;
722:

Line 720: l_current_language FND_LANGUAGES.LANGUAGE_CODE%TYPE ;

716:
717:
718: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');
719: l_current_nls_language VARCHAR2(30);
720: l_current_language FND_LANGUAGES.LANGUAGE_CODE%TYPE ;
721: l_rows_processed number := 0;
722:
723:
724:

Line 1227: FROM fnd_languages lng

1223:
1224:
1225: CURSOR csr_installed_languages is
1226: SELECT lng.language_code, lng.nls_Language
1227: FROM fnd_languages lng
1228: WHERE lng.installed_flag in ('I', 'B');
1229:
1230: CURSOR csr_duplicate_category (p_act_name varchar2, p_business_group_id number) is
1231: SELECT ocu.category_usage_id

Line 1251: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');

1247: l_type varchar2(30) :='C';
1248: l_act_id number;
1249: l_business_group_id number;
1250: l_business_group_name varchar2(240);
1251: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');
1252: l_current_nls_language VARCHAR2(30);
1253: l_current_language FND_LANGUAGES.LANGUAGE_CODE%TYPE ;
1254: l_parent_category_usage_id number;
1255: l_count number ;

Line 1253: l_current_language FND_LANGUAGES.LANGUAGE_CODE%TYPE ;

1249: l_business_group_id number;
1250: l_business_group_name varchar2(240);
1251: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');
1252: l_current_nls_language VARCHAR2(30);
1253: l_current_language FND_LANGUAGES.LANGUAGE_CODE%TYPE ;
1254: l_parent_category_usage_id number;
1255: l_count number ;
1256: l_act_name ota_activity_definitions_tl.name%type;
1257: l_act_ver_id number;

Line 1429: l_base_lang_id fnd_languages.language_id%Type ;

1425: l_act_ver_id number;
1426: l_offering_id number;
1427: l_object_version_number number;
1428: l_lang_id number := 0;
1429: l_base_lang_id fnd_languages.language_id%Type ;
1430: l_language_id number ;
1431: l_competence_element_id number;
1432: l_parent_offering_id ota_offerings.Offering_id%type;
1433: l_vendor_id number;

Line 1440: l_default_language Fnd_languages.Language_id%Type;

1436: l_default_dm ota_category_usages.category_usage_id%Type ;
1437: l_resource_usage_id number;
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;

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 1561: From Fnd_Languages lng

1557:
1558: Begin
1559:
1560: Select lng.Language_id into l_default_language
1561: From Fnd_Languages lng
1562: Where lng.Installed_Flag = 'B' ;
1563:
1564: For ids in c_get_ids loop
1565:

Line 2240: FROM fnd_languages fl,

2236:
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:

Line 2259: FROM fnd_languages fl,

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

Line 2277: FROM fnd_languages fl,

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

Line 2549: from fnd_languages fl,

2545: MAX_OFFERING_NAME_LEN constant number := 80;
2546: MAX_DATA_TRUNC_LEN constant number := 10;
2547: cursor c_get_lang_description is
2548: select flt.description
2549: from fnd_languages fl,
2550: fnd_languages_tl flt
2551: where flt.language_code = fl.language_code
2552: and flt.language = p_language
2553: and fl.language_id = p_language_id ;

Line 2550: fnd_languages_tl flt

2546: MAX_DATA_TRUNC_LEN constant number := 10;
2547: cursor c_get_lang_description is
2548: select flt.description
2549: from fnd_languages fl,
2550: fnd_languages_tl flt
2551: where flt.language_code = fl.language_code
2552: and flt.language = p_language
2553: and fl.language_id = p_language_id ;
2554: l_lang_len number;

Line 2556: description fnd_languages_tl.description%type;

2552: and flt.language = p_language
2553: and fl.language_id = p_language_id ;
2554: l_lang_len number;
2555: l_off_name ota_offerings_tl.name%type := p_off_name;
2556: description fnd_languages_tl.description%type;
2557: begin
2558:
2559:
2560: open c_get_lang_description;