DBA Data[Home] [Help]

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 475: UPDATE hz_locations

471: l_is_invalid_geocode := 1;
472: END IF;
473:
474: /* Bug 7143445 Do not stamp 0,0 for geometry */
475: UPDATE hz_locations
476: SET
477: geometry = decode(l_is_invalid_geocode, 1, NULL,
478: MDSYS.SDO_GEOMETRY(2001,
479: 8307,

Line 519: l_address1 hz_locations.address1%type;

515: (p_loc_id IN NUMBER
516: ) RETURN VARCHAR2
517: IS
518:
519: l_address1 hz_locations.address1%type;
520: l_city hz_locations.city%type;
521: l_state hz_locations.city%type;
522: l_postal_code hz_locations.postal_code%type;
523: l_country hz_locations.country%type;

Line 520: l_city hz_locations.city%type;

516: ) RETURN VARCHAR2
517: IS
518:
519: l_address1 hz_locations.address1%type;
520: l_city hz_locations.city%type;
521: l_state hz_locations.city%type;
522: l_postal_code hz_locations.postal_code%type;
523: l_country hz_locations.country%type;
524: l_ret varchar2(500) := null;

Line 521: l_state hz_locations.city%type;

517: IS
518:
519: l_address1 hz_locations.address1%type;
520: l_city hz_locations.city%type;
521: l_state hz_locations.city%type;
522: l_postal_code hz_locations.postal_code%type;
523: l_country hz_locations.country%type;
524: l_ret varchar2(500) := null;
525:

Line 522: l_postal_code hz_locations.postal_code%type;

518:
519: l_address1 hz_locations.address1%type;
520: l_city hz_locations.city%type;
521: l_state hz_locations.city%type;
522: l_postal_code hz_locations.postal_code%type;
523: l_country hz_locations.country%type;
524: l_ret varchar2(500) := null;
525:
526: BEGIN

Line 523: l_country hz_locations.country%type;

519: l_address1 hz_locations.address1%type;
520: l_city hz_locations.city%type;
521: l_state hz_locations.city%type;
522: l_postal_code hz_locations.postal_code%type;
523: l_country hz_locations.country%type;
524: l_ret varchar2(500) := null;
525:
526: BEGIN
527:

Line 538: from hz_locations hl

534: l_city,
535: l_state,
536: l_postal_code,
537: l_country
538: from hz_locations hl
539: where hl.location_id = p_loc_id;
540:
541: IF(l_address1 is not null) THEN
542: l_ret := l_address1;