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_TERRITORIES

Line 109: g_territory_code fnd_territories.territory_code%TYPE;

105: g_context context_rec_type;
106:
107: -- performance bug 4079490
108: g_terr_code_exist NUMBER := 0;
109: g_territory_code fnd_territories.territory_code%TYPE;
110:
111: --
112: -- Constants
113: --

Line 143: x_ref_territory_code OUT NOCOPY fnd_territories.territory_code%TYPE

139: );
140:
141: /*
142: PROCEDURE get_default_ref_territory (
143: x_ref_territory_code OUT NOCOPY fnd_territories.territory_code%TYPE
144: );
145: */
146: PROCEDURE get_default_eloc_ref_territory (
147: x_ref_territory_code OUT NOCOPY fnd_territories.territory_code%TYPE

Line 147: x_ref_territory_code OUT NOCOPY fnd_territories.territory_code%TYPE

143: x_ref_territory_code OUT NOCOPY fnd_territories.territory_code%TYPE
144: );
145: */
146: PROCEDURE get_default_eloc_ref_territory (
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

Line 229: p_to_territory_code IN fnd_territories.territory_code%TYPE,

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

Line 231: p_from_territory_code IN fnd_territories.territory_code%TYPE,

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: );
235:

Line 290: l_to_territory_code fnd_territories.territory_code%TYPE;

286: WHERE LOCATION_ID = p_location_id;
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;

Line 292: l_from_territory_code fnd_territories.territory_code%TYPE;

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

Line 597: l_to_territory_code fnd_territories.territory_code%TYPE;

593: l_variation_num NUMBER;
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;

Line 599: l_from_territory_code fnd_territories.territory_code%TYPE;

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:
603: BEGIN

Line 883: l_to_territory_code fnd_territories.territory_code%TYPE;

879: l_variation_num NUMBER;
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;

Line 885: l_from_territory_code fnd_territories.territory_code%TYPE;

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:
889: BEGIN

Line 1167: l_to_territory_code fnd_territories.territory_code%TYPE;

1163: WHERE LOCATION_ID = p_location_id;
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;

Line 1169: l_from_territory_code fnd_territories.territory_code%TYPE;

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

Line 1453: l_to_territory_code fnd_territories.territory_code%TYPE;

1449: l_variation_num NUMBER;
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;

Line 1455: l_from_territory_code fnd_territories.territory_code%TYPE;

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:
1459: l_sql_string varchar2(200);

Line 1754: l_territory_code fnd_territories.territory_code%TYPE;

1750: l_sql_string VARCHAR2(2000);
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:

Line 2015: l_territory_code fnd_territories.territory_code%TYPE;

2011: l_api_name VARCHAR2(30) := 'format_name(2)';
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: --

Line 2273: l_territory_code fnd_territories.territory_code%TYPE;

2269: l_api_name VARCHAR2(30) := 'format_data';
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:

Line 2855: p_territory_code IN fnd_territories.territory_code%TYPE,

2851: +=========================================================================*/
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,

Line 3186: l_territory_name fnd_territories_vl.territory_short_name%TYPE;

3182: FUNCTION get_tl_territory_name (
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,

Line 3194: FROM fnd_territories_tl

3190: p_territory_code IN VARCHAR2,
3191: p_language IN VARCHAR2
3192: ) IS
3193: SELECT territory_short_name
3194: FROM fnd_territories_tl
3195: WHERE territory_code = p_territory_code
3196: AND language=p_language;
3197:
3198:

Line 3345: x_ref_territory_code OUT NOCOPY fnd_territories.territory_code%TYPE

3341: |
3342: +=========================================================================*/
3343:
3344: PROCEDURE get_default_ref_territory (
3345: x_ref_territory_code OUT NOCOPY fnd_territories.territory_code%TYPE
3346: ) IS
3347: l_territory_code fnd_territories.territory_code%TYPE;
3348: l_nls_territory varchar(30);
3349: BEGIN

Line 3347: l_territory_code fnd_territories.territory_code%TYPE;

3343:
3344: PROCEDURE get_default_ref_territory (
3345: x_ref_territory_code OUT NOCOPY fnd_territories.territory_code%TYPE
3346: ) IS
3347: l_territory_code fnd_territories.territory_code%TYPE;
3348: l_nls_territory varchar(30);
3349: BEGIN
3350:
3351: ---Bug No. 5110275. First check HZ_REF_TERRITORY profile option and then ICX_TERRITORY profile option

Line 3383: from fnd_territories

3379: END IF;
3380:
3381: if l_nls_territory is not null then
3382: select territory_code into l_territory_code
3383: from fnd_territories
3384: where nls_territory = l_nls_territory
3385: and OBSOLETE_FLAG = 'N'
3386: and rownum = 1;
3387: end if;

Line 3409: fnd_territories fnd

3405: g_terr_code_exist :=1;
3406: SELECT fnd.territory_code
3407: INTO g_territory_code
3408: FROM nls_session_parameters nls,
3409: fnd_territories fnd
3410: WHERE nls.parameter = 'NLS_TERRITORY'
3411: AND fnd.nls_territory = nls.value;
3412: end if;
3413: if g_territory_code is not null then

Line 3457: x_ref_territory_code OUT NOCOPY fnd_territories.territory_code%TYPE

3453: |
3454: +=========================================================================*/
3455:
3456: PROCEDURE get_default_eloc_ref_territory (
3457: x_ref_territory_code OUT NOCOPY fnd_territories.territory_code%TYPE
3458: ) IS
3459: l_territory_code fnd_territories.territory_code%TYPE;
3460: l_nls_territory varchar(30);
3461: BEGIN

Line 3459: l_territory_code fnd_territories.territory_code%TYPE;

3455:
3456: PROCEDURE get_default_eloc_ref_territory (
3457: x_ref_territory_code OUT NOCOPY fnd_territories.territory_code%TYPE
3458: ) IS
3459: l_territory_code fnd_territories.territory_code%TYPE;
3460: l_nls_territory varchar(30);
3461: BEGIN
3462:
3463: ----Bug No. 5110275. First check for HZ_REF_TERRITORY and then for ICX_TERRITORY PROFILE OPTION

Line 3496: from fnd_territories

3492:
3493:
3494: if l_nls_territory is not null then
3495: select territory_code into l_territory_code
3496: from fnd_territories
3497: where nls_territory = l_nls_territory
3498: and OBSOLETE_FLAG = 'N'
3499: and rownum = 1;
3500: end if;

Line 3522: fnd_territories fnd

3518: g_terr_code_exist :=1;
3519: SELECT fnd.territory_code
3520: INTO g_territory_code
3521: FROM nls_session_parameters nls,
3522: fnd_territories fnd
3523: WHERE nls.parameter = 'NLS_TERRITORY'
3524: AND fnd.nls_territory = nls.value;
3525: end if;
3526: if g_territory_code is not null then

Line 4357: p_to_territory_code IN fnd_territories.territory_code%TYPE,

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

Line 4359: p_from_territory_code IN fnd_territories.territory_code%TYPE,

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
4363: BEGIN