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_GPS_PUB dependencies on CSF_GPS_LOCATION_FEEDS

Line 139: FROM csf_gps_location_feeds l

135: SELECT NVL(fl.meaning, stmap.internal_status_code) FROM fnd_lookups fl, csf_gps_vendor_status_maps stmap
136: WHERE fl.lookup_type = 'CSF_GPS_DEVICE_STATUSES' AND fl.lookup_code = stmap.internal_status_code AND stmap.vendor_status_code = l.status
137: ) status_code_meaning
138: , l.creation_date
139: FROM csf_gps_location_feeds l
140: , csf_gps_devices d
141: WHERE d.device_id = p_device_id
142: AND l.device_id = d.device_id
143: -- AND (

Line 164: FROM csf_gps_location_feeds l

160: SELECT NVL(fl.meaning, stmap.internal_status_code) FROM fnd_lookups fl, csf_gps_vendor_status_maps stmap
161: WHERE fl.lookup_type = 'CSF_GPS_DEVICE_STATUSES' AND fl.lookup_code = stmap.internal_status_code AND stmap.vendor_status_code = l.status
162: ) status_code_meaning
163: , l.creation_date
164: FROM csf_gps_location_feeds l
165: , csf_gps_device_assignments a
166: , csf_gps_devices d
167: WHERE a.resource_id = p_resource_id
168: AND a.resource_type = p_resource_type

Line 212: l_feed_time csf_gps_location_feeds.vendor_feed_time%TYPE;

208: , p_resource_type IN VARCHAR2 DEFAULT NULL
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;

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 214: l_latitude csf_gps_location_feeds.latitude%TYPE;

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;
218: l_parked_time csf_gps_location_feeds.parked_time%TYPE;

Line 215: l_longitude csf_gps_location_feeds.longitude%TYPE;

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;
218: l_parked_time csf_gps_location_feeds.parked_time%TYPE;
219: l_address csf_gps_location_feeds.address%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 217: l_direction csf_gps_location_feeds.direction%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;
221: l_device_tag csf_gps_devices.device_tag%TYPE;

Line 218: l_parked_time csf_gps_location_feeds.parked_time%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;
221: l_device_tag csf_gps_devices.device_tag%TYPE;
222: l_status_code_meaning fnd_lookups.meaning%TYPE;

Line 219: l_address csf_gps_location_feeds.address%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;
221: l_device_tag csf_gps_devices.device_tag%TYPE;
222: l_status_code_meaning fnd_lookups.meaning%TYPE;
223: BEGIN

Line 220: l_creation_date csf_gps_location_feeds.creation_date%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;
221: l_device_tag csf_gps_devices.device_tag%TYPE;
222: l_status_code_meaning fnd_lookups.meaning%TYPE;
223: BEGIN
224: get_location(

Line 282: INSERT INTO csf_gps_location_feeds(

278: -- Initialize Return Status
279: x_return_status := fnd_api.g_ret_sts_success;
280:
281: FORALL i IN 1..p_count
282: INSERT INTO csf_gps_location_feeds(
283: location_feed_id
284: , device_id
285: , creation_date
286: , vendor_feed_time

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)

Line 341: DELETE csf_gps_location_feeds

337: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_DEVICE_LOCS');
338: fnd_message.set_token('DEVICE_TAG', p_device_tag);
339: debug(fnd_message.get, l_api_name, g_level_cp_output, p_indent);
340:
341: DELETE csf_gps_location_feeds
342: WHERE device_id = p_device_id
343: AND creation_date BETWEEN p_start_date AND p_end_date;
344: g_counter := g_counter + SQL%ROWCOUNT;
345: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_DEL_ROWS_STATS');

Line 366: DELETE csf_gps_location_feeds

362: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_RES_LOCS');
363: fnd_message.set_token('RESOURCE', l_res_info.resource_name || '(' || csf_resource_pub.get_resource_type_name(l_res_info.resource_type) || ', ' || l_res_info.resource_number || ')');
364: debug(fnd_message.get, l_api_name, g_level_cp_output, p_indent);
365:
366: DELETE csf_gps_location_feeds
367: WHERE device_id IN (
368: SELECT device_id
369: FROM csf_gps_device_assignments
370: WHERE resource_id = p_resource_id

Line 473: DELETE csf_gps_location_feeds

469: --
470: fnd_message.set_name('CSF', 'CSF_GPS_PURGING_ASSIGN_LOCS');
471: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);
472:
473: DELETE csf_gps_location_feeds
474: WHERE device_id IN (
475: SELECT device_id
476: FROM csf_gps_device_assignments
477: WHERE device_assignment_id = p_device_assignment_id