DBA Data[Home] [Help]

APPS.CS_STD dependencies on HZ_FORMAT_PUB

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

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

Line 898: l_formatted_address_tbl hz_format_pub.string_tbl_type;

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

Line 905: hz_format_pub.format_address (

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