[Home] [Help]
133: /************* PRIVATE PROCEDURE/FUNCTION DECLARATIONS ********************/
134:
135:
136: PROCEDURE get_default_style (
137: p_object_name IN hz_styles_b.database_object_name%TYPE,
138: x_style_code OUT NOCOPY hz_styles_b.style_code%TYPE
139: );
140:
141: /*
134:
135:
136: PROCEDURE get_default_style (
137: p_object_name IN hz_styles_b.database_object_name%TYPE,
138: x_style_code OUT NOCOPY hz_styles_b.style_code%TYPE
139: );
140:
141: /*
142: PROCEDURE get_default_ref_territory (
223: x_string IN OUT NOCOPY VARCHAR2
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,
275:
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:
586: x_formatted_address_tbl OUT NOCOPY string_tbl_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:
872: x_formatted_address_tbl OUT NOCOPY string_tbl_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:
1152:
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:
1442: x_layout_tbl OUT NOCOPY layout_tbl_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:
1748: ) IS
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:
2009: x_formatted_name_tbl OUT NOCOPY string_tbl_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;
2267: x_formatted_data_tbl OUT NOCOPY string_tbl_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;
3248: | style (if none is passed from the caller).
3249: |
3250: | For names and addresses, a profile options are checked.
3251: | If profile options are not set (or formatting data other than
3252: | names and addresses) then HZ_STYLES_B is examined to see if there
3253: | is one and only one style defined for the object, and that will
3254: | be selected as the default.
3255: |
3256: | SCOPE: Private
3263: |
3264: +=========================================================================*/
3265:
3266: PROCEDURE get_default_style (
3267: p_object_name IN hz_styles_b.database_object_name%TYPE,
3268: x_style_code OUT NOCOPY hz_styles_b.style_code%TYPE
3269: ) IS
3270: l_style_code hz_styles_b.style_code%TYPE;
3271:
3264: +=========================================================================*/
3265:
3266: PROCEDURE get_default_style (
3267: p_object_name IN hz_styles_b.database_object_name%TYPE,
3268: x_style_code OUT NOCOPY hz_styles_b.style_code%TYPE
3269: ) IS
3270: l_style_code hz_styles_b.style_code%TYPE;
3271:
3272: CURSOR c_styles(p_object_name IN VARCHAR2)
3266: PROCEDURE get_default_style (
3267: p_object_name IN hz_styles_b.database_object_name%TYPE,
3268: x_style_code OUT NOCOPY hz_styles_b.style_code%TYPE
3269: ) IS
3270: l_style_code hz_styles_b.style_code%TYPE;
3271:
3272: CURSOR c_styles(p_object_name IN VARCHAR2)
3273: IS SELECT rownum, style_code FROM hz_styles_b WHERE database_object_name = p_object_name;
3274:
3269: ) IS
3270: l_style_code hz_styles_b.style_code%TYPE;
3271:
3272: CURSOR c_styles(p_object_name IN VARCHAR2)
3273: IS SELECT rownum, style_code FROM hz_styles_b WHERE database_object_name = p_object_name;
3274:
3275: BEGIN
3276:
3277:
3302:
3303: BEGIN
3304: SELECT style_code
3305: INTO l_style_code
3306: FROM hz_styles_b
3307: WHERE database_object_name = p_object_name;
3308: EXCEPTION
3309: WHEN NO_DATA_FOUND THEN
3310: NULL; -- cannot default style code
4351: |
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,