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.RRS_SITE_UTILS dependencies on RRS_SITE_TMP

Line 131: l_geometry RRS_SITE_TMP.geometry%type;

127: p_x_coord IN NUMBER DEFAULT NULL,
128: p_y_coord IN NUMBER DEFAULT NULL
129: )
130: IS
131: l_geometry RRS_SITE_TMP.geometry%type;
132: l_trade_area_number_code rrs_group_trade_areas.trade_area_number_code%type;
133: --Bug 4903895 - Start Code
134: /*
135: CURSOR primary_tag_cursor IS

Line 152: rs.site_id in (select site_id from RRS_SITE_TMP where session_id = p_session_id and geometry is null)

148: rtag.group_id = rltag.group_id and
149: rgta.group_id = rltag.group_id and
150: rltag.location_id = l.location_id and
151: l.location_id = rs.location_id and
152: rs.site_id in (select site_id from RRS_SITE_TMP where session_id = p_session_id and geometry is null)
153: order by
154: rgta.trade_area_number_code desc;
155: CURSOR other_tag_cursor IS
156: select

Line 172: rs.site_id in (select site_id from RRS_SITE_TMP where session_id = p_session_id and geometry is null)

168: rtag.group_id = rltag.group_id and
169: rgta.group_id = rltag.group_id and
170: rltag.location_id = l.location_id and
171: l.location_id = rs.location_id and
172: rs.site_id in (select site_id from RRS_SITE_TMP where session_id = p_session_id and geometry is null)
173: order by
174: rgta.trade_area_number_code desc;
175: */
176: CURSOR primary_tag_cursor IS

Line 187: rrs_site_tmp tmp

183: rrs_group_trade_areas rgta,
184: rrs_loc_trade_area_grps rltag,
185: hz_locations l,
186: rrs_sites_b rs,
187: rrs_site_tmp tmp
188: where
189: rltag.is_primary_flag = 'Y' and
190: rtag.group_id = rltag.group_id and
191: rgta.group_id = rltag.group_id and

Line 210: rrs_site_tmp tmp

206: rrs_group_trade_areas rgta,
207: rrs_loc_trade_area_grps rltag,
208: hz_locations l,
209: rrs_sites_b rs,
210: rrs_site_tmp tmp
211: where
212: rgta.group_id = p_tag_code and
213: rtag.group_id = rltag.group_id and
214: rgta.group_id = rltag.group_id and

Line 228: from RRS_SITE_TMP

224: IF(p_context_flag = 'SITE') THEN
225:
226: select nvl(max(to_number(theme_id)),0) +1
227: into x_theme_id
228: from RRS_SITE_TMP
229: where session_id= p_session_id and geometry is null;
230:
231: forall i in 1..p_site_ids.count
232: insert into RRS_SITE_TMP

Line 232: insert into RRS_SITE_TMP

228: from RRS_SITE_TMP
229: where session_id= p_session_id and geometry is null;
230:
231: forall i in 1..p_site_ids.count
232: insert into RRS_SITE_TMP
233: (session_id,theme_id,site_id)
234: values
235: (p_session_id,x_theme_id,p_site_ids(i));
236:

Line 243: insert into RRS_SITE_TMP

239: OPEN primary_tag_cursor;
240: LOOP
241: FETCH primary_tag_cursor INTO l_geometry, l_trade_area_number_code;
242: EXIT WHEN primary_tag_cursor%NOTFOUND;
243: insert into RRS_SITE_TMP
244: (session_id,geometry,theme_id)
245: values
246: (p_session_id,l_geometry,l_trade_area_number_code);
247: END LOOP;

Line 254: insert into RRS_SITE_TMP

250: OPEN other_tag_cursor;
251: LOOP
252: FETCH other_tag_cursor INTO l_geometry, l_trade_area_number_code;
253: EXIT WHEN other_tag_cursor%NOTFOUND;
254: insert into RRS_SITE_TMP
255: (session_id,geometry,theme_id)
256: values
257: (p_session_id,l_geometry,l_trade_area_number_code);
258: END LOOP;

Line 270: insert into RRS_SITE_TMP

266: into l_geometry
267: from dual;
268:
269: IF(p_context_flag = 'IDENTIFY') THEN
270: insert into RRS_SITE_TMP
271: (session_id,theme_id,geometry)
272: values
273: (p_session_id,'-1',l_geometry);
274: ELSIF(p_context_flag = 'POINT_FEATURE') THEN

Line 275: insert into RRS_SITE_TMP

271: (session_id,theme_id,geometry)
272: values
273: (p_session_id,'-1',l_geometry);
274: ELSIF(p_context_flag = 'POINT_FEATURE') THEN
275: insert into RRS_SITE_TMP
276: (session_id,theme_id,geometry)
277: values
278: (p_session_id,'0',l_geometry);
279: ELSIF(p_context_flag = 'POINT_FEATURE_AT_LOCATION') THEN

Line 280: insert into RRS_SITE_TMP

276: (session_id,theme_id,geometry)
277: values
278: (p_session_id,'0',l_geometry);
279: ELSIF(p_context_flag = 'POINT_FEATURE_AT_LOCATION') THEN
280: insert into RRS_SITE_TMP
281: (session_id,theme_id,geometry)
282: values
283: (p_session_id,'-2',l_geometry);
284: END IF;

Line 312: delete from RRS_SITE_TMP where session_id = p_session_id;

308: 'POINT_FEATURE_AT_LOCATION' -> Delete the point-geometry theme added for mapping the Point Feature at a Location.
309: */
310:
311: IF(p_delete_theme = 'ALL') THEN
312: delete from RRS_SITE_TMP where session_id = p_session_id;
313: ELSIF(p_delete_theme = 'ALL_BUT_BASE') THEN
314: delete from RRS_SITE_TMP where session_id = p_session_id
315: and ((to_number(theme_id) > 1 and site_id is not null) or (theme_id <> '0' and site_id is null));
316: ELSIF(p_delete_theme = 'IDENTIFY') THEN

Line 314: delete from RRS_SITE_TMP where session_id = p_session_id

310:
311: IF(p_delete_theme = 'ALL') THEN
312: delete from RRS_SITE_TMP where session_id = p_session_id;
313: ELSIF(p_delete_theme = 'ALL_BUT_BASE') THEN
314: delete from RRS_SITE_TMP where session_id = p_session_id
315: and ((to_number(theme_id) > 1 and site_id is not null) or (theme_id <> '0' and site_id is null));
316: ELSIF(p_delete_theme = 'IDENTIFY') THEN
317: delete from RRS_SITE_TMP where session_id = p_session_id and theme_id = '-1';
318: ELSIF(p_delete_theme = 'POINT_FEATURE') THEN

Line 317: delete from RRS_SITE_TMP where session_id = p_session_id and theme_id = '-1';

313: ELSIF(p_delete_theme = 'ALL_BUT_BASE') THEN
314: delete from RRS_SITE_TMP where session_id = p_session_id
315: and ((to_number(theme_id) > 1 and site_id is not null) or (theme_id <> '0' and site_id is null));
316: ELSIF(p_delete_theme = 'IDENTIFY') THEN
317: delete from RRS_SITE_TMP where session_id = p_session_id and theme_id = '-1';
318: ELSIF(p_delete_theme = 'POINT_FEATURE') THEN
319: delete from RRS_SITE_TMP where session_id = p_session_id and theme_id = '0';
320: ELSIF(p_delete_theme = 'POINT_FEATURE_AT_LOCATION') THEN
321: delete from RRS_SITE_TMP where session_id = p_session_id and theme_id = '-2';

Line 319: delete from RRS_SITE_TMP where session_id = p_session_id and theme_id = '0';

315: and ((to_number(theme_id) > 1 and site_id is not null) or (theme_id <> '0' and site_id is null));
316: ELSIF(p_delete_theme = 'IDENTIFY') THEN
317: delete from RRS_SITE_TMP where session_id = p_session_id and theme_id = '-1';
318: ELSIF(p_delete_theme = 'POINT_FEATURE') THEN
319: delete from RRS_SITE_TMP where session_id = p_session_id and theme_id = '0';
320: ELSIF(p_delete_theme = 'POINT_FEATURE_AT_LOCATION') THEN
321: delete from RRS_SITE_TMP where session_id = p_session_id and theme_id = '-2';
322: END IF;
323:

Line 321: delete from RRS_SITE_TMP where session_id = p_session_id and theme_id = '-2';

317: delete from RRS_SITE_TMP where session_id = p_session_id and theme_id = '-1';
318: ELSIF(p_delete_theme = 'POINT_FEATURE') THEN
319: delete from RRS_SITE_TMP where session_id = p_session_id and theme_id = '0';
320: ELSIF(p_delete_theme = 'POINT_FEATURE_AT_LOCATION') THEN
321: delete from RRS_SITE_TMP where session_id = p_session_id and theme_id = '-2';
322: END IF;
323:
324: END CLEAR_TEMP_FOR_MAP;
325: