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.RRS_SITE_UTILS dependencies on SDO_GEOMETRY

Line 265: select SDO_GEOMETRY(2001,8307,SDO_POINT_TYPE(p_x_coord,p_y_coord,null),null,null)

261: x_theme_id := 0;
262:
263: ELSIF(p_context_flag = 'IDENTIFY' OR p_context_flag = 'POINT_FEATURE' OR p_context_flag = 'POINT_FEATURE_AT_LOCATION') THEN
264:
265: select SDO_GEOMETRY(2001,8307,SDO_POINT_TYPE(p_x_coord,p_y_coord,null),null,null)
266: into l_geometry
267: from dual;
268:
269: IF(p_context_flag = 'IDENTIFY') THEN

Line 486: MDSYS.SDO_GEOMETRY(2001,

482: /* Bug 7143445 Do not stamp 0,0 for geometry */
483: UPDATE hz_locations
484: SET
485: geometry = decode(l_is_invalid_geocode, 1, NULL,
486: MDSYS.SDO_GEOMETRY(2001,
487: 8307,
488: SDO_POINT_TYPE(p_long, p_lat, NULL),
489: NULL,
490: NULL)),

Line 638: (geom IN MDSYS.SDO_GEOMETRY,

634:
635:
636:
637: FUNCTION get_ordinate
638: (geom IN MDSYS.SDO_GEOMETRY,
639: indx IN NUMBER
640: ) RETURN NUMBER
641: IS
642: BEGIN