1229: l_asg_id NUMBER;
1230: l_neg_bal_exists BOOLEAN := FALSE;
1231:
1232: l_person_id per_people_f.person_id%TYPE;
1233: l_address_line1 per_addresses.address_line1%TYPE;
1234: l_address_line2 per_addresses.address_line2%TYPE;
1235: l_address_line3 per_addresses.address_line3%TYPE;
1236: l_city per_addresses.town_or_city%TYPE;
1237: l_postal_code per_addresses.postal_code%TYPE;
1230: l_neg_bal_exists BOOLEAN := FALSE;
1231:
1232: l_person_id per_people_f.person_id%TYPE;
1233: l_address_line1 per_addresses.address_line1%TYPE;
1234: l_address_line2 per_addresses.address_line2%TYPE;
1235: l_address_line3 per_addresses.address_line3%TYPE;
1236: l_city per_addresses.town_or_city%TYPE;
1237: l_postal_code per_addresses.postal_code%TYPE;
1238: l_country VARCHAR2(60);
1231:
1232: l_person_id per_people_f.person_id%TYPE;
1233: l_address_line1 per_addresses.address_line1%TYPE;
1234: l_address_line2 per_addresses.address_line2%TYPE;
1235: l_address_line3 per_addresses.address_line3%TYPE;
1236: l_city per_addresses.town_or_city%TYPE;
1237: l_postal_code per_addresses.postal_code%TYPE;
1238: l_country VARCHAR2(60);
1239: l_emp_province per_addresses.region_1%TYPE;
1232: l_person_id per_people_f.person_id%TYPE;
1233: l_address_line1 per_addresses.address_line1%TYPE;
1234: l_address_line2 per_addresses.address_line2%TYPE;
1235: l_address_line3 per_addresses.address_line3%TYPE;
1236: l_city per_addresses.town_or_city%TYPE;
1237: l_postal_code per_addresses.postal_code%TYPE;
1238: l_country VARCHAR2(60);
1239: l_emp_province per_addresses.region_1%TYPE;
1240:
1233: l_address_line1 per_addresses.address_line1%TYPE;
1234: l_address_line2 per_addresses.address_line2%TYPE;
1235: l_address_line3 per_addresses.address_line3%TYPE;
1236: l_city per_addresses.town_or_city%TYPE;
1237: l_postal_code per_addresses.postal_code%TYPE;
1238: l_country VARCHAR2(60);
1239: l_emp_province per_addresses.region_1%TYPE;
1240:
1241: l_return VARCHAR2(240);
1235: l_address_line3 per_addresses.address_line3%TYPE;
1236: l_city per_addresses.town_or_city%TYPE;
1237: l_postal_code per_addresses.postal_code%TYPE;
1238: l_country VARCHAR2(60);
1239: l_emp_province per_addresses.region_1%TYPE;
1240:
1241: l_return VARCHAR2(240);
1242: l_return_xml VARCHAR2(200);
1243: l_status BOOLEAN := TRUE;