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.HZ_FORMAT_PUB dependencies on FND_LANGUAGES

Line 151: x_ref_language_code OUT NOCOPY fnd_languages.language_code%TYPE

147: x_ref_territory_code OUT NOCOPY fnd_territories.territory_code%TYPE
148: );
149:
150: PROCEDURE get_default_ref_language (
151: x_ref_language_code OUT NOCOPY fnd_languages.language_code%TYPE
152: );
153:
154: PROCEDURE get_country_name_lang (
155: x_country_name_lang OUT NOCOPY fnd_languages.language_code%TYPE

Line 155: x_country_name_lang OUT NOCOPY fnd_languages.language_code%TYPE

151: x_ref_language_code OUT NOCOPY fnd_languages.language_code%TYPE
152: );
153:
154: PROCEDURE get_country_name_lang (
155: x_country_name_lang OUT NOCOPY fnd_languages.language_code%TYPE
156: );
157:
158: PROCEDURE load_internal_format_table(
159: p_style_format_code IN VARCHAR2,

Line 230: p_to_language_code IN fnd_languages.language_code%TYPE,

226: PROCEDURE set_context (
227: p_style_code IN hz_styles_b.style_code%TYPE,
228: p_style_format_code IN hz_style_formats_b.style_format_code%TYPE,
229: p_to_territory_code IN fnd_territories.territory_code%TYPE,
230: p_to_language_code IN fnd_languages.language_code%TYPE,
231: p_from_territory_code IN fnd_territories.territory_code%TYPE,
232: p_from_language_code IN fnd_languages.language_code%TYPE,
233: p_country_name_lang IN fnd_languages.language_code%TYPE
234: );

Line 232: p_from_language_code IN fnd_languages.language_code%TYPE,

228: p_style_format_code IN hz_style_formats_b.style_format_code%TYPE,
229: p_to_territory_code IN fnd_territories.territory_code%TYPE,
230: p_to_language_code IN fnd_languages.language_code%TYPE,
231: p_from_territory_code IN fnd_territories.territory_code%TYPE,
232: p_from_language_code IN fnd_languages.language_code%TYPE,
233: p_country_name_lang IN fnd_languages.language_code%TYPE
234: );
235:
236:

Line 233: p_country_name_lang IN fnd_languages.language_code%TYPE

229: p_to_territory_code IN fnd_territories.territory_code%TYPE,
230: p_to_language_code IN fnd_languages.language_code%TYPE,
231: p_from_territory_code IN fnd_territories.territory_code%TYPE,
232: p_from_language_code IN fnd_languages.language_code%TYPE,
233: p_country_name_lang IN fnd_languages.language_code%TYPE
234: );
235:
236:
237: /********************* PUBLIC FORMATTING APIs *****************************/

Line 291: l_to_language_code fnd_languages.language_code%TYPE;

287:
288: -- Context Information
289:
290: l_to_territory_code fnd_territories.territory_code%TYPE;
291: l_to_language_code fnd_languages.language_code%TYPE;
292: l_from_territory_code fnd_territories.territory_code%TYPE;
293: l_from_language_code fnd_languages.language_code%TYPE;
294: l_country_name_lang fnd_languages.language_code%TYPE;
295:

Line 293: l_from_language_code fnd_languages.language_code%TYPE;

289:
290: l_to_territory_code fnd_territories.territory_code%TYPE;
291: l_to_language_code fnd_languages.language_code%TYPE;
292: l_from_territory_code fnd_territories.territory_code%TYPE;
293: l_from_language_code fnd_languages.language_code%TYPE;
294: l_country_name_lang fnd_languages.language_code%TYPE;
295:
296:
297: BEGIN

Line 294: l_country_name_lang fnd_languages.language_code%TYPE;

290: l_to_territory_code fnd_territories.territory_code%TYPE;
291: l_to_language_code fnd_languages.language_code%TYPE;
292: l_from_territory_code fnd_territories.territory_code%TYPE;
293: l_from_language_code fnd_languages.language_code%TYPE;
294: l_country_name_lang fnd_languages.language_code%TYPE;
295:
296:
297: BEGIN
298: --

Line 598: l_to_language_code fnd_languages.language_code%TYPE;

594:
595: -- Context Information
596:
597: l_to_territory_code fnd_territories.territory_code%TYPE;
598: l_to_language_code fnd_languages.language_code%TYPE;
599: l_from_territory_code fnd_territories.territory_code%TYPE;
600: l_from_language_code fnd_languages.language_code%TYPE;
601: l_country_name_lang fnd_languages.language_code%TYPE;
602:

Line 600: l_from_language_code fnd_languages.language_code%TYPE;

596:
597: l_to_territory_code fnd_territories.territory_code%TYPE;
598: l_to_language_code fnd_languages.language_code%TYPE;
599: l_from_territory_code fnd_territories.territory_code%TYPE;
600: l_from_language_code fnd_languages.language_code%TYPE;
601: l_country_name_lang fnd_languages.language_code%TYPE;
602:
603: BEGIN
604:

Line 601: l_country_name_lang fnd_languages.language_code%TYPE;

597: l_to_territory_code fnd_territories.territory_code%TYPE;
598: l_to_language_code fnd_languages.language_code%TYPE;
599: l_from_territory_code fnd_territories.territory_code%TYPE;
600: l_from_language_code fnd_languages.language_code%TYPE;
601: l_country_name_lang fnd_languages.language_code%TYPE;
602:
603: BEGIN
604:
605: --

Line 884: l_to_language_code fnd_languages.language_code%TYPE;

880:
881: -- Context Information
882:
883: l_to_territory_code fnd_territories.territory_code%TYPE;
884: l_to_language_code fnd_languages.language_code%TYPE;
885: l_from_territory_code fnd_territories.territory_code%TYPE;
886: l_from_language_code fnd_languages.language_code%TYPE;
887: l_country_name_lang fnd_languages.language_code%TYPE;
888:

Line 886: l_from_language_code fnd_languages.language_code%TYPE;

882:
883: l_to_territory_code fnd_territories.territory_code%TYPE;
884: l_to_language_code fnd_languages.language_code%TYPE;
885: l_from_territory_code fnd_territories.territory_code%TYPE;
886: l_from_language_code fnd_languages.language_code%TYPE;
887: l_country_name_lang fnd_languages.language_code%TYPE;
888:
889: BEGIN
890:

Line 887: l_country_name_lang fnd_languages.language_code%TYPE;

883: l_to_territory_code fnd_territories.territory_code%TYPE;
884: l_to_language_code fnd_languages.language_code%TYPE;
885: l_from_territory_code fnd_territories.territory_code%TYPE;
886: l_from_language_code fnd_languages.language_code%TYPE;
887: l_country_name_lang fnd_languages.language_code%TYPE;
888:
889: BEGIN
890:
891: --

Line 1168: l_to_language_code fnd_languages.language_code%TYPE;

1164:
1165: -- Context Information
1166:
1167: l_to_territory_code fnd_territories.territory_code%TYPE;
1168: l_to_language_code fnd_languages.language_code%TYPE;
1169: l_from_territory_code fnd_territories.territory_code%TYPE;
1170: l_from_language_code fnd_languages.language_code%TYPE;
1171: l_country_name_lang fnd_languages.language_code%TYPE;
1172:

Line 1170: l_from_language_code fnd_languages.language_code%TYPE;

1166:
1167: l_to_territory_code fnd_territories.territory_code%TYPE;
1168: l_to_language_code fnd_languages.language_code%TYPE;
1169: l_from_territory_code fnd_territories.territory_code%TYPE;
1170: l_from_language_code fnd_languages.language_code%TYPE;
1171: l_country_name_lang fnd_languages.language_code%TYPE;
1172:
1173:
1174: BEGIN

Line 1171: l_country_name_lang fnd_languages.language_code%TYPE;

1167: l_to_territory_code fnd_territories.territory_code%TYPE;
1168: l_to_language_code fnd_languages.language_code%TYPE;
1169: l_from_territory_code fnd_territories.territory_code%TYPE;
1170: l_from_language_code fnd_languages.language_code%TYPE;
1171: l_country_name_lang fnd_languages.language_code%TYPE;
1172:
1173:
1174: BEGIN
1175: --

Line 1454: l_to_language_code fnd_languages.language_code%TYPE;

1450:
1451: -- Context Information
1452:
1453: l_to_territory_code fnd_territories.territory_code%TYPE;
1454: l_to_language_code fnd_languages.language_code%TYPE;
1455: l_from_territory_code fnd_territories.territory_code%TYPE;
1456: l_from_language_code fnd_languages.language_code%TYPE;
1457: l_country_name_lang fnd_languages.language_code%TYPE;
1458:

Line 1456: l_from_language_code fnd_languages.language_code%TYPE;

1452:
1453: l_to_territory_code fnd_territories.territory_code%TYPE;
1454: l_to_language_code fnd_languages.language_code%TYPE;
1455: l_from_territory_code fnd_territories.territory_code%TYPE;
1456: l_from_language_code fnd_languages.language_code%TYPE;
1457: l_country_name_lang fnd_languages.language_code%TYPE;
1458:
1459: l_sql_string varchar2(200);
1460: l_var_counts number := 0;

Line 1457: l_country_name_lang fnd_languages.language_code%TYPE;

1453: l_to_territory_code fnd_territories.territory_code%TYPE;
1454: l_to_language_code fnd_languages.language_code%TYPE;
1455: l_from_territory_code fnd_territories.territory_code%TYPE;
1456: l_from_language_code fnd_languages.language_code%TYPE;
1457: l_country_name_lang fnd_languages.language_code%TYPE;
1458:
1459: l_sql_string varchar2(200);
1460: l_var_counts number := 0;
1461:

Line 1755: l_language_code fnd_languages.language_code%TYPE;

1751:
1752: l_style_code hz_styles_b.style_code%TYPE;
1753: l_style_format_code hz_style_formats_b.style_format_code%TYPE;
1754: l_territory_code fnd_territories.territory_code%TYPE;
1755: l_language_code fnd_languages.language_code%TYPE;
1756:
1757: l_variation_num NUMBER;
1758:
1759: BEGIN

Line 2016: l_language_code fnd_languages.language_code%TYPE;

2012:
2013: l_style_code hz_styles_b.style_code%TYPE;
2014: l_style_format_code hz_style_formats_b.style_format_code%TYPE;
2015: l_territory_code fnd_territories.territory_code%TYPE;
2016: l_language_code fnd_languages.language_code%TYPE;
2017: l_variation_num NUMBER;
2018: BEGIN
2019: --
2020: -- Reset return status and messages

Line 2274: l_language_code fnd_languages.language_code%TYPE;

2270:
2271: l_style_code hz_styles_b.style_code%TYPE;
2272: l_style_format_code hz_style_formats_b.style_format_code%TYPE;
2273: l_territory_code fnd_territories.territory_code%TYPE;
2274: l_language_code fnd_languages.language_code%TYPE;
2275: l_variation_num NUMBER;
2276: l_pk_column_count NUMBER := 0;
2277:
2278: l_pk_name VARCHAR2(30);

Line 2856: p_language_code IN fnd_languages.language_code%TYPE,

2852:
2853: PROCEDURE get_style_format (
2854: p_style_code IN VARCHAR2,
2855: p_territory_code IN fnd_territories.territory_code%TYPE,
2856: p_language_code IN fnd_languages.language_code%TYPE,
2857: x_return_status OUT NOCOPY VARCHAR2,
2858: x_msg_count OUT NOCOPY VARCHAR2,
2859: x_msg_data OUT NOCOPY VARCHAR2,
2860: x_style_format_code OUT NOCOPY VARCHAR2

Line 3187: l_language_code fnd_languages.language_code%TYPE;

3183: p_territory_code IN VARCHAR2
3184: ) RETURN VARCHAR2
3185: IS
3186: l_territory_name fnd_territories_vl.territory_short_name%TYPE;
3187: l_language_code fnd_languages.language_code%TYPE;
3188:
3189: CURSOR c_territory (
3190: p_territory_code IN VARCHAR2,
3191: p_language IN VARCHAR2

Line 3566: x_ref_language_code OUT NOCOPY fnd_languages.language_code%TYPE

3562: |
3563: +=========================================================================*/
3564:
3565: PROCEDURE get_default_ref_language (
3566: x_ref_language_code OUT NOCOPY fnd_languages.language_code%TYPE
3567: ) IS
3568: l_language_code fnd_languages.language_code%TYPE;
3569: BEGIN
3570:

Line 3568: l_language_code fnd_languages.language_code%TYPE;

3564:
3565: PROCEDURE get_default_ref_language (
3566: x_ref_language_code OUT NOCOPY fnd_languages.language_code%TYPE
3567: ) IS
3568: l_language_code fnd_languages.language_code%TYPE;
3569: BEGIN
3570:
3571: /* Fix perf bug 3669930, 4220460, use cached profile option value
3572: -- check profile option

Line 3624: x_country_name_lang OUT NOCOPY fnd_languages.language_code%TYPE

3620: |
3621: +=========================================================================*/
3622:
3623: PROCEDURE get_country_name_lang (
3624: x_country_name_lang OUT NOCOPY fnd_languages.language_code%TYPE
3625: ) IS
3626: l_language_code fnd_languages.language_code%TYPE;
3627: BEGIN
3628:

Line 3626: l_language_code fnd_languages.language_code%TYPE;

3622:
3623: PROCEDURE get_country_name_lang (
3624: x_country_name_lang OUT NOCOPY fnd_languages.language_code%TYPE
3625: ) IS
3626: l_language_code fnd_languages.language_code%TYPE;
3627: BEGIN
3628:
3629: --
3630: -- Language

Line 4358: p_to_language_code IN fnd_languages.language_code%TYPE,

4354: PROCEDURE set_context (
4355: p_style_code IN hz_styles_b.style_code%TYPE,
4356: p_style_format_code IN hz_style_formats_b.style_format_code%TYPE,
4357: p_to_territory_code IN fnd_territories.territory_code%TYPE,
4358: p_to_language_code IN fnd_languages.language_code%TYPE,
4359: p_from_territory_code IN fnd_territories.territory_code%TYPE,
4360: p_from_language_code IN fnd_languages.language_code%TYPE,
4361: p_country_name_lang IN fnd_languages.language_code%TYPE
4362: ) IS

Line 4360: p_from_language_code IN fnd_languages.language_code%TYPE,

4356: p_style_format_code IN hz_style_formats_b.style_format_code%TYPE,
4357: p_to_territory_code IN fnd_territories.territory_code%TYPE,
4358: p_to_language_code IN fnd_languages.language_code%TYPE,
4359: p_from_territory_code IN fnd_territories.territory_code%TYPE,
4360: p_from_language_code IN fnd_languages.language_code%TYPE,
4361: p_country_name_lang IN fnd_languages.language_code%TYPE
4362: ) IS
4363: BEGIN
4364:

Line 4361: p_country_name_lang IN fnd_languages.language_code%TYPE

4357: p_to_territory_code IN fnd_territories.territory_code%TYPE,
4358: p_to_language_code IN fnd_languages.language_code%TYPE,
4359: p_from_territory_code IN fnd_territories.territory_code%TYPE,
4360: p_from_language_code IN fnd_languages.language_code%TYPE,
4361: p_country_name_lang IN fnd_languages.language_code%TYPE
4362: ) IS
4363: BEGIN
4364:
4365: -- Access the global context directly