eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_RESOURCE_ADDRESS_PVT dependencies on SDO_GEOMETRY

Line 299: , x_geometry OUT NOCOPY mdsys.sdo_geometry

295: , p_country IN VARCHAR2
296: , p_country_code IN VARCHAR2
297: , p_alternate IN VARCHAR2
298: , p_update_address IN VARCHAR2 DEFAULT 'F'
299: , x_geometry OUT NOCOPY mdsys.sdo_geometry
300: ) IS
301: l_api_name CONSTANT VARCHAR2(50) := 'RESOLVE_ADDRESS';
302: l_api_version CONSTANT NUMBER := 1.0;
303: l_debug CONSTANT BOOLEAN := g_debug = 'Y';

Line 313: l_geometry MDSYS.SDO_GEOMETRY := NULL;

309: l_roadname hz_locations.address1%TYPE;
310: l_location_ovn NUMBER;
311: l_location_rec hz_location_v2pub.location_rec_type;
312: l_road VARCHAR2(200);
313: l_geometry MDSYS.SDO_GEOMETRY := NULL;
314: l_geom_status_code hz_locations.geometry_status_code%TYPE := NULL;
315: l_msg_data VARCHAR2(200);
316: l_existing_geom_seg_id NUMBER;
317: