1648: END IF;
1649: -- the ContactName is left null
1650: SELECT
1651: XMLElement("ContactLocators",
1652: XMLElement("PhoneNumber", nvl(hz_format_phone_v2pub.get_formatted_phone(l_phone_cp_id), l_hr_loc_phone)),
1653: XMLElement("FaxNumber", nvl(hz_format_phone_v2pub.get_formatted_phone(l_fax_cp_id), l_hr_loc_fax)),
1654: XMLElement("EmailAddress", l_email),
1655: XMLElement("Website", l_url)
1656: )
1649: -- the ContactName is left null
1650: SELECT
1651: XMLElement("ContactLocators",
1652: XMLElement("PhoneNumber", nvl(hz_format_phone_v2pub.get_formatted_phone(l_phone_cp_id), l_hr_loc_phone)),
1653: XMLElement("FaxNumber", nvl(hz_format_phone_v2pub.get_formatted_phone(l_fax_cp_id), l_hr_loc_fax)),
1654: XMLElement("EmailAddress", l_email),
1655: XMLElement("Website", l_url)
1656: )
1657: INTO g_payer_contact_tbl(p_party_id).l_contactinfo
1797:
1798: -- the ContactName is left null
1799: SELECT
1800: XMLElement("ContactLocators",
1801: XMLElement("PhoneNumber", hz_format_phone_v2pub.get_formatted_phone(l_phone_cp_id)),
1802: XMLElement("FaxNumber", hz_format_phone_v2pub.get_formatted_phone(l_fax_cp_id)),
1803: XMLElement("EmailAddress", l_email),
1804: XMLElement("Website", l_url)
1805: )
1798: -- the ContactName is left null
1799: SELECT
1800: XMLElement("ContactLocators",
1801: XMLElement("PhoneNumber", hz_format_phone_v2pub.get_formatted_phone(l_phone_cp_id)),
1802: XMLElement("FaxNumber", hz_format_phone_v2pub.get_formatted_phone(l_fax_cp_id)),
1803: XMLElement("EmailAddress", l_email),
1804: XMLElement("Website", l_url)
1805: )
1806: INTO l_contactinfo