DBA Data[Home] [Help]

APPS.CSF_GPS_PUB dependencies on CSF_GPS_LOCATION_FEEDS_S

Line 213: l_status_code csf_gps_location_feeds.status%TYPE;

209: , p_date IN DATE DEFAULT NULL
210: )
211: RETURN MDSYS.SDO_POINT_TYPE IS
212: l_feed_time csf_gps_location_feeds.vendor_feed_time%TYPE;
213: l_status_code csf_gps_location_feeds.status%TYPE;
214: l_latitude csf_gps_location_feeds.latitude%TYPE;
215: l_longitude csf_gps_location_feeds.longitude%TYPE;
216: l_speed csf_gps_location_feeds.speed%TYPE;
217: l_direction csf_gps_location_feeds.direction%TYPE;

Line 216: l_speed csf_gps_location_feeds.speed%TYPE;

212: l_feed_time csf_gps_location_feeds.vendor_feed_time%TYPE;
213: l_status_code csf_gps_location_feeds.status%TYPE;
214: l_latitude csf_gps_location_feeds.latitude%TYPE;
215: l_longitude csf_gps_location_feeds.longitude%TYPE;
216: l_speed csf_gps_location_feeds.speed%TYPE;
217: l_direction csf_gps_location_feeds.direction%TYPE;
218: l_parked_time csf_gps_location_feeds.parked_time%TYPE;
219: l_address csf_gps_location_feeds.address%TYPE;
220: l_creation_date csf_gps_location_feeds.creation_date%TYPE;

Line 296: csf_gps_location_feeds_s.NEXTVAL

292: , parked_time
293: , address
294: )
295: VALUES (
296: csf_gps_location_feeds_s.NEXTVAL
297: , p_device_id_tbl(i)
298: , SYSDATE
299: , p_feed_time_tbl(i)
300: , p_status_tbl(i)