DBA Data[Home] [Help]

APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on HZ_FORMAT_PUB

Line 1865: l_formatted_address := hz_format_pub.format_address_lov(

1861: FETCH l_hr_loc_csr INTO l_address_line_1, l_address_line_2, l_address_line_3,
1862: l_city, l_county, l_state, l_postal_code, l_country;
1863: CLOSE l_hr_loc_csr;
1864:
1865: l_formatted_address := hz_format_pub.format_address_lov(
1866: p_address_line_1 => l_address_line_1,
1867: p_address_line_2 => l_address_line_2,
1868: p_address_line_3 => l_address_line_3,
1869: p_address_line_4 => NULL,

Line 1911: l_formatted_address := hz_format_pub.format_address(

1907: IF p_hz_location_id IS NULL THEN
1908: RETURN NULL;
1909: END IF;
1910:
1911: l_formatted_address := hz_format_pub.format_address(
1912: p_location_id => p_hz_location_id,
1913: p_style_code => p_style_code
1914: );
1915: