3821: p_contact_ids HZ_PARTY_SEARCH.IDList;
3822: l_match_idx NUMBER;
3823: cursor get_cpts_for_party_sites is select contact_point_id
3824: from hz_contact_points
3825: where owner_table_name = 'HZ_PARTY_SITES'
3826: and primary_flag='Y'
3827: and owner_table_id = p_party_site_id;
3828: BEGIN
3829: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5198: AND ROWNUM<6
5199: UNION
5200:
5201: SELECT CONTACT_POINT_ID
5202: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5203: WHERE PRIMARY_FLAG = 'Y'
5204: AND owner_table_name = 'HZ_PARTY_SITES'
5205: AND owner_table_id = party_site_id
5206: AND PARTY_ID = p_party_id
5200:
5201: SELECT CONTACT_POINT_ID
5202: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5203: WHERE PRIMARY_FLAG = 'Y'
5204: AND owner_table_name = 'HZ_PARTY_SITES'
5205: AND owner_table_id = party_site_id
5206: AND PARTY_ID = p_party_id
5207: AND IDENTIFYING_ADDRESS_FLAG = 'Y') LOOP
5208: l_contact_pt_ids(cpt) := CONTACT_POINTS.CONTACT_POINT_ID;
5334: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5335: ) IS
5336: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5337: SELECT party_site_id
5338: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5339: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5340: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5341:
5342: I NUMBER;
5335: ) IS
5336: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5337: SELECT party_site_id
5338: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5339: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5340: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5341:
5342: I NUMBER;
5343: J NUMBER:=1;
5336: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5337: SELECT party_site_id
5338: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5339: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5340: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5341:
5342: I NUMBER;
5343: J NUMBER:=1;
5344: l_party_site_id NUMBER;