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.

[Home] [Help]

APPS.CSF_RESOURCE_PUB dependencies on SDO_POINT_TYPE

Line 911: l_res_position MDSYS.SDO_POINT_TYPE;

907: l_task_lat NUMBER;
908: l_task_lon NUMBER;
909: l_res_lat NUMBER;
910: l_res_lon NUMBER;
911: l_res_position MDSYS.SDO_POINT_TYPE;
912: l_valid_geo VARCHAR2(5);
913: l_distance NUMBER;
914:
915: CURSOR c_task_geometry IS

Line 2772: ) RETURN MDSYS.SDO_POINT_TYPE IS

2768: FUNCTION get_location (
2769: p_resource_id IN NUMBER
2770: , p_resource_type IN VARCHAR2
2771: , p_date IN DATE DEFAULT SYSDATE
2772: ) RETURN MDSYS.SDO_POINT_TYPE IS
2773: l_return_status VARCHAR2(1);
2774: l_msg_data VARCHAR2(2000);
2775: l_msg_count NUMBER;
2776: l_feed_time csf_gps_location_feeds.vendor_feed_time%TYPE;

Line 2807: RETURN MDSYS.SDO_POINT_TYPE(l_longitude, l_latitude, 0);

2803: , x_creation_date => l_creation_date
2804: , x_device_tag => l_device_tag
2805: , x_status_code_meaning => l_status_code_meaning
2806: );
2807: RETURN MDSYS.SDO_POINT_TYPE(l_longitude, l_latitude, 0);
2808: END get_location;
2809:
2810: FUNCTION get_location_attributes(
2811: p_resource_id IN NUMBER