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 HZ_LOCATIONS

Line 9: l_address1 hz_locations.address1%type;

5: (
6: p_site_id IN NUMBER
7: ) RETURN VARCHAR2
8: IS
9: l_address1 hz_locations.address1%type;
10: l_city hz_locations.city%type;
11: l_state hz_locations.city%type;
12: l_postal_code hz_locations.postal_code%type;
13: l_ret varchar2(2000);

Line 10: l_city hz_locations.city%type;

6: p_site_id IN NUMBER
7: ) RETURN VARCHAR2
8: IS
9: l_address1 hz_locations.address1%type;
10: l_city hz_locations.city%type;
11: l_state hz_locations.city%type;
12: l_postal_code hz_locations.postal_code%type;
13: l_ret varchar2(2000);
14:

Line 11: l_state hz_locations.city%type;

7: ) RETURN VARCHAR2
8: IS
9: l_address1 hz_locations.address1%type;
10: l_city hz_locations.city%type;
11: l_state hz_locations.city%type;
12: l_postal_code hz_locations.postal_code%type;
13: l_ret varchar2(2000);
14:
15: BEGIN

Line 12: l_postal_code hz_locations.postal_code%type;

8: IS
9: l_address1 hz_locations.address1%type;
10: l_city hz_locations.city%type;
11: l_state hz_locations.city%type;
12: l_postal_code hz_locations.postal_code%type;
13: l_ret varchar2(2000);
14:
15: BEGIN
16:

Line 27: hz_locations hl,

23: l_city,
24: l_state,
25: l_postal_code
26: from
27: hz_locations hl,
28: rrs_sites_b rs
29: where
30: rs.location_id = hl.location_id
31: and rs.site_id = p_site_id;

Line 144: hz_locations l,

140: from
141: rrs_trade_area_groups_b rtag,
142: rrs_group_trade_areas rgta,
143: rrs_loc_trade_area_grps rltag,
144: hz_locations l,
145: rrs_sites_b rs
146: where
147: rltag.is_primary_flag = 'Y' and
148: rtag.group_id = rltag.group_id and

Line 164: hz_locations l,

160: from
161: rrs_trade_area_groups_b rtag,
162: rrs_group_trade_areas rgta,
163: rrs_loc_trade_area_grps rltag,
164: hz_locations l,
165: rrs_sites_b rs
166: where
167: rgta.group_id = p_tag_code and
168: rtag.group_id = rltag.group_id and

Line 185: hz_locations l,

181: from
182: rrs_trade_area_groups_b rtag,
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

Line 208: hz_locations l,

204: from
205: rrs_trade_area_groups_b rtag,
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

Line 483: UPDATE hz_locations

479: l_is_invalid_geocode := 1;
480: END IF;
481:
482: /* Bug 7143445 Do not stamp 0,0 for geometry */
483: UPDATE hz_locations
484: SET
485: geometry = decode(l_is_invalid_geocode, 1, NULL,
486: MDSYS.SDO_GEOMETRY(2001,
487: 8307,

Line 549: from hz_locations HL

545: into
546: x_latitude,
547: x_longitude,
548: x_geo_source
549: from hz_locations HL
550: where location_id = p_loc_id;
551:
552: IF (sql%rowcount = 0) THEN
553: x_return_status := 'E';

Line 598: from hz_locations

594: END IF;
595:
596: select geometry_source
597: into l_curr_geosource
598: from hz_locations
599: where location_id = p_loc_id;
600:
601: IF (sql%rowcount = 0) THEN
602: x_return_status := 'E';

Line 610: UPDATE hz_locations

606: FND_MESSAGE.SET_TOKEN('OBJECT_VALUE',p_loc_id);
607: x_msg_data := FND_MESSAGE.GET;
608: ELSE
609:
610: UPDATE hz_locations
611: SET geometry_source = l_default_geosource
612: WHERE location_id = p_loc_id
613: AND geometry_source is null;
614:

Line 654: l_address1 hz_locations.address1%type;

650: (p_loc_id IN NUMBER
651: ) RETURN VARCHAR2
652: IS
653:
654: l_address1 hz_locations.address1%type;
655: l_city hz_locations.city%type;
656: l_state hz_locations.city%type;
657: l_postal_code hz_locations.postal_code%type;
658: l_country hz_locations.country%type;

Line 655: l_city hz_locations.city%type;

651: ) RETURN VARCHAR2
652: IS
653:
654: l_address1 hz_locations.address1%type;
655: l_city hz_locations.city%type;
656: l_state hz_locations.city%type;
657: l_postal_code hz_locations.postal_code%type;
658: l_country hz_locations.country%type;
659: l_ret varchar2(500) := null;

Line 656: l_state hz_locations.city%type;

652: IS
653:
654: l_address1 hz_locations.address1%type;
655: l_city hz_locations.city%type;
656: l_state hz_locations.city%type;
657: l_postal_code hz_locations.postal_code%type;
658: l_country hz_locations.country%type;
659: l_ret varchar2(500) := null;
660:

Line 657: l_postal_code hz_locations.postal_code%type;

653:
654: l_address1 hz_locations.address1%type;
655: l_city hz_locations.city%type;
656: l_state hz_locations.city%type;
657: l_postal_code hz_locations.postal_code%type;
658: l_country hz_locations.country%type;
659: l_ret varchar2(500) := null;
660:
661: BEGIN

Line 658: l_country hz_locations.country%type;

654: l_address1 hz_locations.address1%type;
655: l_city hz_locations.city%type;
656: l_state hz_locations.city%type;
657: l_postal_code hz_locations.postal_code%type;
658: l_country hz_locations.country%type;
659: l_ret varchar2(500) := null;
660:
661: BEGIN
662:

Line 673: from hz_locations hl

669: l_city,
670: l_state,
671: l_postal_code,
672: l_country
673: from hz_locations hl
674: where hl.location_id = p_loc_id;
675:
676: IF(l_address1 is not null) THEN
677: l_ret := l_address1;