DBA Data[Home] [Help]

APPS.CSF_RESOURCE_PUB dependencies on SDO_GEOMETRY

Line 906: l_geometry MDSYS.SDO_GEOMETRY;

902: i PLS_INTEGER;
903: j PLS_INTEGER;
904: l_pref_res_cnt PLS_INTEGER;
905: l_address csf_resource_address_pvt.address_rec_type;
906: l_geometry MDSYS.SDO_GEOMETRY;
907: l_task_lat NUMBER;
908: l_task_lon NUMBER;
909: l_res_lat NUMBER;
910: l_res_lon NUMBER;

Line 2621: l_geometry MDSYS.SDO_GEOMETRY;

2617: , x_device_tag OUT NOCOPY VARCHAR2
2618: , x_status_code_meaning OUT NOCOPY VARCHAR2
2619: ) IS
2620: l_address csf_resource_address_pvt.address_rec_type;
2621: l_geometry MDSYS.SDO_GEOMETRY;
2622: l_res_lat NUMBER;
2623: l_res_lon NUMBER;
2624: l_valid_geo VARCHAR2(5);
2625: l_mapping_count PLS_INTEGER := 0;