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_TDS_PUB dependencies on CSF_TDS_ROUTE_CACHE

Line 10: l_from_segment_id csf_tds_route_cache.to_segment_id%TYPE,

6: PROCEDURE put_stream (p_handle IN NUMBER, p_msg_data IN VARCHAR2);
7:
8: FUNCTION CACHED_ROUTE_EXISTS
9: ( l_config_string VARCHAR2,
10: l_from_segment_id csf_tds_route_cache.to_segment_id%TYPE,
11: l_from_spot csf_tds_route_cache.to_segment_position%TYPE,
12: l_from_side csf_tds_route_cache.to_segment_side%TYPE,
13: l_to_segment_id csf_tds_route_cache.to_segment_id%TYPE,
14: l_to_spot csf_tds_route_cache.to_segment_position%TYPE,

Line 11: l_from_spot csf_tds_route_cache.to_segment_position%TYPE,

7:
8: FUNCTION CACHED_ROUTE_EXISTS
9: ( l_config_string VARCHAR2,
10: l_from_segment_id csf_tds_route_cache.to_segment_id%TYPE,
11: l_from_spot csf_tds_route_cache.to_segment_position%TYPE,
12: l_from_side csf_tds_route_cache.to_segment_side%TYPE,
13: l_to_segment_id csf_tds_route_cache.to_segment_id%TYPE,
14: l_to_spot csf_tds_route_cache.to_segment_position%TYPE,
15: l_to_side csf_tds_route_cache.to_segment_side%TYPE,

Line 12: l_from_side csf_tds_route_cache.to_segment_side%TYPE,

8: FUNCTION CACHED_ROUTE_EXISTS
9: ( l_config_string VARCHAR2,
10: l_from_segment_id csf_tds_route_cache.to_segment_id%TYPE,
11: l_from_spot csf_tds_route_cache.to_segment_position%TYPE,
12: l_from_side csf_tds_route_cache.to_segment_side%TYPE,
13: l_to_segment_id csf_tds_route_cache.to_segment_id%TYPE,
14: l_to_spot csf_tds_route_cache.to_segment_position%TYPE,
15: l_to_side csf_tds_route_cache.to_segment_side%TYPE,
16: multiDataSetProfileValue VARCHAR2

Line 13: l_to_segment_id csf_tds_route_cache.to_segment_id%TYPE,

9: ( l_config_string VARCHAR2,
10: l_from_segment_id csf_tds_route_cache.to_segment_id%TYPE,
11: l_from_spot csf_tds_route_cache.to_segment_position%TYPE,
12: l_from_side csf_tds_route_cache.to_segment_side%TYPE,
13: l_to_segment_id csf_tds_route_cache.to_segment_id%TYPE,
14: l_to_spot csf_tds_route_cache.to_segment_position%TYPE,
15: l_to_side csf_tds_route_cache.to_segment_side%TYPE,
16: multiDataSetProfileValue VARCHAR2
17: )

Line 14: l_to_spot csf_tds_route_cache.to_segment_position%TYPE,

10: l_from_segment_id csf_tds_route_cache.to_segment_id%TYPE,
11: l_from_spot csf_tds_route_cache.to_segment_position%TYPE,
12: l_from_side csf_tds_route_cache.to_segment_side%TYPE,
13: l_to_segment_id csf_tds_route_cache.to_segment_id%TYPE,
14: l_to_spot csf_tds_route_cache.to_segment_position%TYPE,
15: l_to_side csf_tds_route_cache.to_segment_side%TYPE,
16: multiDataSetProfileValue VARCHAR2
17: )
18: RETURN boolean IS

Line 15: l_to_side csf_tds_route_cache.to_segment_side%TYPE,

11: l_from_spot csf_tds_route_cache.to_segment_position%TYPE,
12: l_from_side csf_tds_route_cache.to_segment_side%TYPE,
13: l_to_segment_id csf_tds_route_cache.to_segment_id%TYPE,
14: l_to_spot csf_tds_route_cache.to_segment_position%TYPE,
15: l_to_side csf_tds_route_cache.to_segment_side%TYPE,
16: multiDataSetProfileValue VARCHAR2
17: )
18: RETURN boolean IS
19:

Line 26: l_segment_id csf_tds_route_cache.to_segment_id%TYPE;

22: route_cache_cursor t_crs;
23:
24: route_cache_qry VARCHAR2(1000);
25:
26: l_segment_id csf_tds_route_cache.to_segment_id%TYPE;
27:
28: BEGIN
29: return_val := false;
30:

Line 33: FROM csf_tds_route_cache'||multiDataSetProfileValue ||'

29: return_val := false;
30:
31:
32: route_cache_qry := 'SELECT distinct FROM_SEGMENT_ID
33: FROM csf_tds_route_cache'||multiDataSetProfileValue ||'
34: WHERE CONFIG = '||l_config_string||' AND
35: FROM_SEGMENT_ID = '||l_from_segment_id||' AND
36: FROM_SEGMENT_SIDE = '|| l_from_side ||' AND
37: FROM_SEGMENT_POSITION = '|| l_from_spot ||' AND

Line 103: l_segment_id csf_tds_route_cache.from_segment_id%TYPE;

99: res_address_Cursor t_crs;
100: res_address_Cursor_inner t_crs;
101:
102: -- l_location_id hz_locations.location_id%TYPE;
103: l_segment_id csf_tds_route_cache.from_segment_id%TYPE;
104: l_spot csf_tds_route_cache.from_segment_position%TYPE;
105: l_side csf_tds_route_cache.from_segment_side%TYPE;
106: l_lat NUMBER;
107: l_lon NUMBER;

Line 104: l_spot csf_tds_route_cache.from_segment_position%TYPE;

100: res_address_Cursor_inner t_crs;
101:
102: -- l_location_id hz_locations.location_id%TYPE;
103: l_segment_id csf_tds_route_cache.from_segment_id%TYPE;
104: l_spot csf_tds_route_cache.from_segment_position%TYPE;
105: l_side csf_tds_route_cache.from_segment_side%TYPE;
106: l_lat NUMBER;
107: l_lon NUMBER;
108: l_SRID NUMBER;

Line 105: l_side csf_tds_route_cache.from_segment_side%TYPE;

101:
102: -- l_location_id hz_locations.location_id%TYPE;
103: l_segment_id csf_tds_route_cache.from_segment_id%TYPE;
104: l_spot csf_tds_route_cache.from_segment_position%TYPE;
105: l_side csf_tds_route_cache.from_segment_side%TYPE;
106: l_lat NUMBER;
107: l_lon NUMBER;
108: l_SRID NUMBER;
109: l_tile_id NUMBER;

Line 113: l_segment_id_inner csf_tds_route_cache.to_segment_id%TYPE;

109: l_tile_id NUMBER;
110:
111:
112: -- l_location_id_inner hz_locations.location_id%TYPE;
113: l_segment_id_inner csf_tds_route_cache.to_segment_id%TYPE;
114: l_spot_inner csf_tds_route_cache.to_segment_position%TYPE;
115: l_side_inner csf_tds_route_cache.to_segment_side%TYPE;
116: l_lat_inner NUMBER;
117: l_lon_inner NUMBER;

Line 114: l_spot_inner csf_tds_route_cache.to_segment_position%TYPE;

110:
111:
112: -- l_location_id_inner hz_locations.location_id%TYPE;
113: l_segment_id_inner csf_tds_route_cache.to_segment_id%TYPE;
114: l_spot_inner csf_tds_route_cache.to_segment_position%TYPE;
115: l_side_inner csf_tds_route_cache.to_segment_side%TYPE;
116: l_lat_inner NUMBER;
117: l_lon_inner NUMBER;
118: l_SRID_inner NUMBER;

Line 115: l_side_inner csf_tds_route_cache.to_segment_side%TYPE;

111:
112: -- l_location_id_inner hz_locations.location_id%TYPE;
113: l_segment_id_inner csf_tds_route_cache.to_segment_id%TYPE;
114: l_spot_inner csf_tds_route_cache.to_segment_position%TYPE;
115: l_side_inner csf_tds_route_cache.to_segment_side%TYPE;
116: l_lat_inner NUMBER;
117: l_lon_inner NUMBER;
118: l_SRID_inner NUMBER;
119: l_tile_id_inner NUMBER;

Line 121: l_seg_From csf_tds_route_cache.from_segment_id%TYPE;

117: l_lon_inner NUMBER;
118: l_SRID_inner NUMBER;
119: l_tile_id_inner NUMBER;
120:
121: l_seg_From csf_tds_route_cache.from_segment_id%TYPE;
122:
123: task_qry_stmt VARCHAR2(2000);
124: res_qry_stmt VARCHAR2(2000);
125:

Line 476: l_del_qry := 'DELETE FROM CSF_TDS_ROUTE_CACHE'||multiDataSetProfileValue

472: --
473: l_start_date := csf_timezones_pvt.date_to_server_tz_date (l_start_date);
474: l_end_date := csf_timezones_pvt.date_to_server_tz_date (l_end_date);
475:
476: l_del_qry := 'DELETE FROM CSF_TDS_ROUTE_CACHE'||multiDataSetProfileValue
477: ||' WHERE HITCOUNT = 0
478: AND CREATION_DATE >= :1
479: AND CREATION_DATE <= :2';
480: