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: PROCEDURE 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: PROCEDURE 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: PROCEDURE 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: x_return_status OUT NOCOPY boolean

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: x_return_status OUT NOCOPY boolean
18: )

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: x_return_status OUT NOCOPY boolean
18: )
19: IS

Line 27: l_segment_id csf_tds_route_cache.to_segment_id%TYPE;

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

Line 34: FROM csf_tds_route_cache'||multiDataSetProfileValue ||'

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

Line 104: l_segment_id csf_tds_route_cache.from_segment_id%TYPE;

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

Line 105: l_spot csf_tds_route_cache.from_segment_position%TYPE;

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

Line 106: l_side csf_tds_route_cache.from_segment_side%TYPE;

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

Line 115: l_segment_id_inner csf_tds_route_cache.to_segment_id%TYPE;

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

Line 116: l_spot_inner csf_tds_route_cache.to_segment_position%TYPE;

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

Line 117: l_side_inner csf_tds_route_cache.to_segment_side%TYPE;

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

Line 124: l_seg_From csf_tds_route_cache.from_segment_id%TYPE;

120: l_SRID_inner NUMBER;
121: l_tile_id_inner NUMBER;
122: l_hr_ctry_code_inner VARCHAR2(10);
123:
124: l_seg_From csf_tds_route_cache.from_segment_id%TYPE;
125:
126: task_qry_stmt VARCHAR2(2000);
127: res_qry_stmt VARCHAR2(2000);
128:

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

500: --
501: l_start_date := csf_timezones_pvt.date_to_server_tz_date (l_start_date);
502: l_end_date := csf_timezones_pvt.date_to_server_tz_date (l_end_date);
503:
504: l_del_qry := 'DELETE FROM CSF_TDS_ROUTE_CACHE'||multiDataSetProfileValue
505: ||' WHERE HITCOUNT = 0
506: AND CREATION_DATE >= :1
507: AND CREATION_DATE <= :2';
508: