222: PROCEDURE generate_detail_xml
223: IS
224:
225: l_proc_name VARCHAR2 (100) := g_proc_name ||'generate_detail_xml';
226: l_addr1 per_addresses.address_line1%TYPE;
227: l_addr2 per_addresses.address_line2%TYPE;
228: l_addr3 per_addresses.address_line3%TYPE;
229: l_country per_addresses.country%TYPE;
230: l_city per_addresses.town_or_city%TYPE;
223: IS
224:
225: l_proc_name VARCHAR2 (100) := g_proc_name ||'generate_detail_xml';
226: l_addr1 per_addresses.address_line1%TYPE;
227: l_addr2 per_addresses.address_line2%TYPE;
228: l_addr3 per_addresses.address_line3%TYPE;
229: l_country per_addresses.country%TYPE;
230: l_city per_addresses.town_or_city%TYPE;
231: l_postal_code per_addresses.postal_code%TYPE;
224:
225: l_proc_name VARCHAR2 (100) := g_proc_name ||'generate_detail_xml';
226: l_addr1 per_addresses.address_line1%TYPE;
227: l_addr2 per_addresses.address_line2%TYPE;
228: l_addr3 per_addresses.address_line3%TYPE;
229: l_country per_addresses.country%TYPE;
230: l_city per_addresses.town_or_city%TYPE;
231: l_postal_code per_addresses.postal_code%TYPE;
232: l_er_name hr_organization_units.name%TYPE;
225: l_proc_name VARCHAR2 (100) := g_proc_name ||'generate_detail_xml';
226: l_addr1 per_addresses.address_line1%TYPE;
227: l_addr2 per_addresses.address_line2%TYPE;
228: l_addr3 per_addresses.address_line3%TYPE;
229: l_country per_addresses.country%TYPE;
230: l_city per_addresses.town_or_city%TYPE;
231: l_postal_code per_addresses.postal_code%TYPE;
232: l_er_name hr_organization_units.name%TYPE;
233: l_er_ird_number hr_organization_information.org_information1%TYPE;
226: l_addr1 per_addresses.address_line1%TYPE;
227: l_addr2 per_addresses.address_line2%TYPE;
228: l_addr3 per_addresses.address_line3%TYPE;
229: l_country per_addresses.country%TYPE;
230: l_city per_addresses.town_or_city%TYPE;
231: l_postal_code per_addresses.postal_code%TYPE;
232: l_er_name hr_organization_units.name%TYPE;
233: l_er_ird_number hr_organization_information.org_information1%TYPE;
234: l_paye_ded pay_run_result_values.result_value%TYPE;
227: l_addr2 per_addresses.address_line2%TYPE;
228: l_addr3 per_addresses.address_line3%TYPE;
229: l_country per_addresses.country%TYPE;
230: l_city per_addresses.town_or_city%TYPE;
231: l_postal_code per_addresses.postal_code%TYPE;
232: l_er_name hr_organization_units.name%TYPE;
233: l_er_ird_number hr_organization_information.org_information1%TYPE;
234: l_paye_ded pay_run_result_values.result_value%TYPE;
235: l_child_support_ded pay_run_result_values.result_value%TYPE;