DBA Data[Home] [Help]

APPS.CS_STD dependencies on HZ_FORMAT_PUB

Line 814: HZ_FORMAT_PUB. In case of error, it returns a simple concatenation of fields.*/

810: -- return(to_number(fnd_profile.value_wnps('ASO_PRODUCT_ORGANIZATION_ID')));
811: end;
812:
813: /* The Following Functions will take address fields and Format them based on
814: HZ_FORMAT_PUB. In case of error, it returns a simple concatenation of fields.*/
815:
816: FUNCTION format_address_concat( address_style IN VARCHAR2,
817: address1 IN VARCHAR2,
818: address2 IN VARCHAR2,

Line 899: l_formatted_address_tbl hz_format_pub.string_tbl_type;

895: )return VARCHAR2 IS
896:
897: l_formatted_address VARCHAR2(2000);
898: l_formatted_lines_cnt NUMBER;
899: l_formatted_address_tbl hz_format_pub.string_tbl_type;
900: l_return_status VARCHAR2(1);
901: l_msg_count NUMBER;
902: l_msg_data VARCHAR2(2000);
903:

Line 906: hz_format_pub.format_address (

902: l_msg_data VARCHAR2(2000);
903:
904: BEGIN
905:
906: hz_format_pub.format_address (
907: p_line_break => ', ',
908: p_from_territory_code => 'x', -- force country short name be displayed
909: p_address_line_1 => address1,
910: p_address_line_2 => address2,