DBA Data[Home] [Help]

APPS.ARP_ADDR_LABEL_PKG dependencies on HZ_FORMAT_PUB

Line 43: l_formatted_address_tbl hz_format_pub.string_tbl_type;

39: IS
40: l_from_territory_code VARCHAR2(2) := p_country_code;
41: l_formatted_address VARCHAR2(2000);
42: l_formatted_addr_lines_cnt NUMBER;
43: l_formatted_address_tbl hz_format_pub.string_tbl_type;
44: l_formatted_name VARCHAR2(100);
45: l_formatted_name_lines_cnt NUMBER;
46: l_formatted_name_tbl hz_format_pub.string_tbl_type;
47: l_return_status VARCHAR2(1);

Line 46: l_formatted_name_tbl hz_format_pub.string_tbl_type;

42: l_formatted_addr_lines_cnt NUMBER;
43: l_formatted_address_tbl hz_format_pub.string_tbl_type;
44: l_formatted_name VARCHAR2(100);
45: l_formatted_name_lines_cnt NUMBER;
46: l_formatted_name_tbl hz_format_pub.string_tbl_type;
47: l_return_status VARCHAR2(1);
48: l_msg_count NUMBER;
49: l_msg_data VARCHAR2(2000);
50: l_country_code VARCHAR2(2) := p_country_code;

Line 62: hz_format_pub.format_address (

58: p_print_home_country_flag = 'Y' THEN
59: l_from_territory_code := 'x'; -- force country short name be displayed
60: END IF;
61:
62: hz_format_pub.format_address (
63: p_line_break => ' ',
64: p_from_territory_code => l_from_territory_code,
65: p_address_line_1 => p_address1,
66: p_address_line_2 => p_address2,

Line 88: hz_format_pub.format_name (

84: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
85: RETURN;
86: END IF;
87:
88: hz_format_pub.format_name (
89: p_ref_territory_code => l_country_code,
90: p_person_first_name => p_first_name,
91: p_person_last_name => p_last_name,
92: -- output parameters