APPS.CSP_PART_SEARCH_PVT dependencies on HZ_GEOCODE_PKG

Line 1100: l_array hz_geocode_pkg.loc_array := hz_geocode_pkg.loc_array();

1096: and hcsua.status = 'A'
1097: and hcasa.cust_acct_site_id = hcsua.cust_acct_site_id
1098: and hps.party_site_id = hcasa.party_site_id;
1099:
1100: l_array hz_geocode_pkg.loc_array := hz_geocode_pkg.loc_array();
1101: l_rec hz_location_v2pub.location_rec_type;
1102: l_http_ad VARCHAR2(200);
1103: cpt number;
1104: l_distance_uom_code varchar2(30);

Line 1172: log('get_my_location','calling hz_geocode_pkg.get_spatial_coords');

1168: if l_my_location is null then
1169: fnd_profile.get('HZ_GEOCODE_WEBSITE', l_http_ad);
1170: log('get_my_location','l_http_ad:'||l_http_ad);
1171: l_array(cpt).location_id := l_to_hz_location_id;
1172: log('get_my_location','calling hz_geocode_pkg.get_spatial_coords');
1173: hz_geocode_pkg.get_spatial_coords(
1174: p_loc_array => l_array,
1175: p_name => null,
1176: p_http_ad => l_http_ad,

Line 1173: hz_geocode_pkg.get_spatial_coords(

1169: fnd_profile.get('HZ_GEOCODE_WEBSITE', l_http_ad);
1170: log('get_my_location','l_http_ad:'||l_http_ad);
1171: l_array(cpt).location_id := l_to_hz_location_id;
1172: log('get_my_location','calling hz_geocode_pkg.get_spatial_coords');
1173: hz_geocode_pkg.get_spatial_coords(
1174: p_loc_array => l_array,
1175: p_name => null,
1176: p_http_ad => l_http_ad,
1177: p_proxy => null,