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 HZ_STYLE_FORMATS_B

Line 93: g_cache_style_format_code hz_style_formats_b.style_format_code%TYPE;

89:
90: g_pkg_name VARCHAR2(30) := 'hz_format_pub';
91:
92: g_caching BOOLEAN := TRUE;
93: g_cache_style_format_code hz_style_formats_b.style_format_code%TYPE;
94: g_cache_variation_number NUMBER;
95:
96: g_layout_tbl layout_tbl_type;
97: g_layout_tbl_cnt NUMBER;

Line 228: p_style_format_code IN hz_style_formats_b.style_format_code%TYPE,

224: );
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,

Line 280: l_style_format_code hz_style_formats_b.style_format_code%TYPE;

276: l_api_name VARCHAR2(30) := 'format_address(1)';
277: l_sql_string VARCHAR2(2000);
278:
279: l_style_code hz_styles_b.style_code%TYPE;
280: l_style_format_code hz_style_formats_b.style_format_code%TYPE;
281:
282: l_variation_num NUMBER;
283:
284: CURSOR c_location_territory(p_location_id IN NUMBER)

Line 372: from hz_style_formats_b

368: -- bug 2656819 fix
369: -- l_style_format_code := p_style_format_code;
370: BEGIN
371: select style_format_code into l_style_format_code
372: from hz_style_formats_b
373: where style_format_code = p_style_format_code;
374: EXCEPTION
375: WHEN NO_DATA_FOUND THEN
376: l_style_format_code := null;

Line 591: l_style_format_code hz_style_formats_b.style_format_code%TYPE;

587: ) IS
588: l_api_name VARCHAR2(30) := 'format_address(2)';
589:
590: l_style_code hz_styles_b.style_code%TYPE;
591: l_style_format_code hz_style_formats_b.style_format_code%TYPE;
592:
593: l_variation_num NUMBER;
594:
595: -- Context Information

Line 665: from hz_style_formats_b

661: -- bug 2656819 fix
662: -- l_style_format_code := p_style_format_code;
663: BEGIN
664: select style_format_code into l_style_format_code
665: from hz_style_formats_b
666: where style_format_code = p_style_format_code;
667: EXCEPTION
668: WHEN NO_DATA_FOUND THEN
669: l_style_format_code := null;

Line 877: l_style_format_code hz_style_formats_b.style_format_code%TYPE;

873: ) IS
874: l_api_name VARCHAR2(30) := 'format_address(2)';
875:
876: l_style_code hz_styles_b.style_code%TYPE;
877: l_style_format_code hz_style_formats_b.style_format_code%TYPE;
878:
879: l_variation_num NUMBER;
880:
881: -- Context Information

Line 951: from hz_style_formats_b

947: -- bug 2656819 fix
948: -- l_style_format_code := p_style_format_code;
949: BEGIN
950: select style_format_code into l_style_format_code
951: from hz_style_formats_b
952: where style_format_code = p_style_format_code;
953: EXCEPTION
954: WHEN NO_DATA_FOUND THEN
955: l_style_format_code := null;

Line 1157: l_style_format_code hz_style_formats_b.style_format_code%TYPE;

1153: l_api_name VARCHAR2(30) := 'format_address(1)';
1154: l_sql_string VARCHAR2(2000);
1155:
1156: l_style_code hz_styles_b.style_code%TYPE;
1157: l_style_format_code hz_style_formats_b.style_format_code%TYPE;
1158:
1159: l_variation_num NUMBER;
1160:
1161: CURSOR c_location_territory(p_location_id IN NUMBER)

Line 1249: from hz_style_formats_b

1245: -- bug 2656819 fix
1246: -- l_style_format_code := p_style_format_code;
1247: BEGIN
1248: select style_format_code into l_style_format_code
1249: from hz_style_formats_b
1250: where style_format_code = p_style_format_code;
1251: EXCEPTION
1252: WHEN NO_DATA_FOUND THEN
1253: l_style_format_code := null;

Line 1447: l_style_format_code hz_style_formats_b.style_format_code%TYPE;

1443: ) IS
1444: l_api_name VARCHAR2(30) := 'format_address(2)';
1445:
1446: l_style_code hz_styles_b.style_code%TYPE;
1447: l_style_format_code hz_style_formats_b.style_format_code%TYPE;
1448:
1449: l_variation_num NUMBER;
1450:
1451: -- Context Information

Line 1524: from hz_style_formats_b

1520: -- bug 2656819 fix
1521: -- l_style_format_code := p_style_format_code;
1522: BEGIN
1523: select style_format_code into l_style_format_code
1524: from hz_style_formats_b
1525: where style_format_code = p_style_format_code;
1526: EXCEPTION
1527: WHEN NO_DATA_FOUND THEN
1528: l_style_format_code := null;

Line 1753: l_style_format_code hz_style_formats_b.style_format_code%TYPE;

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

Line 1799: from hz_style_formats_b

1795: -- bug 2656819 fix
1796: -- l_style_format_code := p_style_format_code;
1797: BEGIN
1798: select style_format_code into l_style_format_code
1799: from hz_style_formats_b
1800: where style_format_code = p_style_format_code;
1801: EXCEPTION
1802: WHEN NO_DATA_FOUND THEN
1803: l_style_format_code := null;

Line 2014: l_style_format_code hz_style_formats_b.style_format_code%TYPE;

2010: ) IS
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

Line 2058: from hz_style_formats_b

2054: -- bug 2656819 fix
2055: -- l_style_format_code := p_style_format_code;
2056: BEGIN
2057: select style_format_code into l_style_format_code
2058: from hz_style_formats_b
2059: where style_format_code = p_style_format_code;
2060: EXCEPTION
2061: WHEN NO_DATA_FOUND THEN
2062: l_style_format_code := null;

Line 2272: l_style_format_code hz_style_formats_b.style_format_code%TYPE;

2268: ) IS
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;

Line 2362: from hz_style_formats_b

2358: -- bug 2656819 fix
2359: -- l_style_format_code := p_style_format_code;
2360: BEGIN
2361: select style_format_code into l_style_format_code
2362: from hz_style_formats_b
2363: where style_format_code = p_style_format_code;
2364: EXCEPTION
2365: WHEN NO_DATA_FOUND THEN
2366: l_style_format_code := null;

Line 2874: hz_style_formats_b hsf

2870: SELECT
2871: hsf.style_format_code
2872: FROM
2873: hz_style_fmt_locales hsfl,
2874: hz_style_formats_b hsf
2875: WHERE
2876: nvl(hsfl.territory_code,'X') = nvl(p_territory_code,'X')
2877: AND nvl(hsfl.language_code,'X') = nvl(p_language_code,'X')
2878: AND hsfl.style_format_code = hsf.style_format_code

Line 2891: hz_style_formats_b hsf

2887: ) IS
2888: SELECT
2889: hsf.style_format_code
2890: FROM
2891: hz_style_formats_b hsf
2892: WHERE
2893: hsf.default_flag = 'Y'
2894: AND hsf.style_code = p_style_code;
2895:

Line 2896: l_style_format_code hz_style_formats_b.style_format_code%TYPE;

2892: WHERE
2893: hsf.default_flag = 'Y'
2894: AND hsf.style_code = p_style_code;
2895:
2896: l_style_format_code hz_style_formats_b.style_format_code%TYPE;
2897:
2898: BEGIN
2899:
2900: --

Line 3071: l_style_format_code hz_style_formats_b.style_format_code%TYPE;

3067: -- Determine the format that the "from" country uses.
3068: --
3069:
3070: DECLARE
3071: l_style_format_code hz_style_formats_b.style_format_code%TYPE;
3072: l_return_status VARCHAR2(1);
3073: l_msg_count NUMBER;
3074: l_msg_data VARCHAR2(2000);
3075:

Line 4356: p_style_format_code IN hz_style_formats_b.style_format_code%TYPE,

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