DBA Data[Home] [Help]

APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on HZ_FORMAT_PUB

Line 2609: l_formatted_address := hz_format_pub.format_address_lov(

2605: FETCH l_hr_loc_csr INTO l_address_line_1, l_address_line_2, l_address_line_3,
2606: l_city, l_county, l_state, l_postal_code, l_country;
2607: CLOSE l_hr_loc_csr;
2608:
2609: l_formatted_address := hz_format_pub.format_address_lov(
2610: p_address_line_1 => l_address_line_1,
2611: p_address_line_2 => l_address_line_2,
2612: p_address_line_3 => l_address_line_3,
2613: p_address_line_4 => NULL,

Line 2666: g_formatted_hz_addr_tbl(l_key).formatted_address := hz_format_pub.format_address(

2662: debug_level => G_LEVEL_STATEMENT,
2663: module => G_Debug_Module || '.format_hz_address');
2664: END IF;
2665:
2666: g_formatted_hz_addr_tbl(l_key).formatted_address := hz_format_pub.format_address(
2667: p_location_id => p_hz_location_id,
2668: p_style_code => p_style_code
2669: );
2670: