379: RETURN l_matched_value;
380: END IF;
381: IF p_attribute = 'POSTAL_CODE' THEN
382: BEGIN
383: SELECT HZ_LOCATIONS.POSTAL_CODE
384: INTO l_matched_value
385: FROM HZ_PARTY_SITES, HZ_LOCATIONS
386: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
387: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
381: IF p_attribute = 'POSTAL_CODE' THEN
382: BEGIN
383: SELECT HZ_LOCATIONS.POSTAL_CODE
384: INTO l_matched_value
385: FROM HZ_PARTY_SITES, HZ_LOCATIONS
386: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
387: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
388: EXCEPTION
389: WHEN NO_DATA_FOUND THEN
383: SELECT HZ_LOCATIONS.POSTAL_CODE
384: INTO l_matched_value
385: FROM HZ_PARTY_SITES, HZ_LOCATIONS
386: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
387: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
388: EXCEPTION
389: WHEN NO_DATA_FOUND THEN
390: l_matched_value := 'Err';
391: END;
5648: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5649: ) IS
5650: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5651: SELECT party_site_id
5652: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5653: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5654: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5655: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5656:
5649: ) IS
5650: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5651: SELECT party_site_id
5652: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5653: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5654: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5655: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5656:
5657: I NUMBER;
5651: SELECT party_site_id
5652: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5653: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5654: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5655: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5656:
5657: I NUMBER;
5658: J NUMBER:=1;
5659: l_party_site_id NUMBER;