32:
33: TYPE geo_suggest_rec IS RECORD
34: (
35: country hz_locations.country%TYPE,
36: country_code hz_geographies.geography_code%TYPE,
37: country_geo_id hz_geographies.geography_id%TYPE,
38: country_geo_type hz_geographies.geography_type%TYPE,
39: state hz_locations.state%TYPE,
40: state_code hz_geographies.geography_code%TYPE,
33: TYPE geo_suggest_rec IS RECORD
34: (
35: country hz_locations.country%TYPE,
36: country_code hz_geographies.geography_code%TYPE,
37: country_geo_id hz_geographies.geography_id%TYPE,
38: country_geo_type hz_geographies.geography_type%TYPE,
39: state hz_locations.state%TYPE,
40: state_code hz_geographies.geography_code%TYPE,
41: state_geo_id hz_geographies.geography_id%TYPE,
34: (
35: country hz_locations.country%TYPE,
36: country_code hz_geographies.geography_code%TYPE,
37: country_geo_id hz_geographies.geography_id%TYPE,
38: country_geo_type hz_geographies.geography_type%TYPE,
39: state hz_locations.state%TYPE,
40: state_code hz_geographies.geography_code%TYPE,
41: state_geo_id hz_geographies.geography_id%TYPE,
42: state_geo_type hz_geographies.geography_type%TYPE,
36: country_code hz_geographies.geography_code%TYPE,
37: country_geo_id hz_geographies.geography_id%TYPE,
38: country_geo_type hz_geographies.geography_type%TYPE,
39: state hz_locations.state%TYPE,
40: state_code hz_geographies.geography_code%TYPE,
41: state_geo_id hz_geographies.geography_id%TYPE,
42: state_geo_type hz_geographies.geography_type%TYPE,
43: province hz_locations.province%TYPE,
44: province_code hz_geographies.geography_code%TYPE,
37: country_geo_id hz_geographies.geography_id%TYPE,
38: country_geo_type hz_geographies.geography_type%TYPE,
39: state hz_locations.state%TYPE,
40: state_code hz_geographies.geography_code%TYPE,
41: state_geo_id hz_geographies.geography_id%TYPE,
42: state_geo_type hz_geographies.geography_type%TYPE,
43: province hz_locations.province%TYPE,
44: province_code hz_geographies.geography_code%TYPE,
45: province_geo_id hz_geographies.geography_id%TYPE,
38: country_geo_type hz_geographies.geography_type%TYPE,
39: state hz_locations.state%TYPE,
40: state_code hz_geographies.geography_code%TYPE,
41: state_geo_id hz_geographies.geography_id%TYPE,
42: state_geo_type hz_geographies.geography_type%TYPE,
43: province hz_locations.province%TYPE,
44: province_code hz_geographies.geography_code%TYPE,
45: province_geo_id hz_geographies.geography_id%TYPE,
46: province_geo_type hz_geographies.geography_type%TYPE,
40: state_code hz_geographies.geography_code%TYPE,
41: state_geo_id hz_geographies.geography_id%TYPE,
42: state_geo_type hz_geographies.geography_type%TYPE,
43: province hz_locations.province%TYPE,
44: province_code hz_geographies.geography_code%TYPE,
45: province_geo_id hz_geographies.geography_id%TYPE,
46: province_geo_type hz_geographies.geography_type%TYPE,
47: county hz_locations.county%TYPE,
48: county_geo_id hz_geographies.geography_id%TYPE,
41: state_geo_id hz_geographies.geography_id%TYPE,
42: state_geo_type hz_geographies.geography_type%TYPE,
43: province hz_locations.province%TYPE,
44: province_code hz_geographies.geography_code%TYPE,
45: province_geo_id hz_geographies.geography_id%TYPE,
46: province_geo_type hz_geographies.geography_type%TYPE,
47: county hz_locations.county%TYPE,
48: county_geo_id hz_geographies.geography_id%TYPE,
49: county_geo_type hz_geographies.geography_type%TYPE,
42: state_geo_type hz_geographies.geography_type%TYPE,
43: province hz_locations.province%TYPE,
44: province_code hz_geographies.geography_code%TYPE,
45: province_geo_id hz_geographies.geography_id%TYPE,
46: province_geo_type hz_geographies.geography_type%TYPE,
47: county hz_locations.county%TYPE,
48: county_geo_id hz_geographies.geography_id%TYPE,
49: county_geo_type hz_geographies.geography_type%TYPE,
50: city hz_locations.city%TYPE,
44: province_code hz_geographies.geography_code%TYPE,
45: province_geo_id hz_geographies.geography_id%TYPE,
46: province_geo_type hz_geographies.geography_type%TYPE,
47: county hz_locations.county%TYPE,
48: county_geo_id hz_geographies.geography_id%TYPE,
49: county_geo_type hz_geographies.geography_type%TYPE,
50: city hz_locations.city%TYPE,
51: city_geo_id hz_geographies.geography_id%TYPE,
52: city_geo_type hz_geographies.geography_type%TYPE,
45: province_geo_id hz_geographies.geography_id%TYPE,
46: province_geo_type hz_geographies.geography_type%TYPE,
47: county hz_locations.county%TYPE,
48: county_geo_id hz_geographies.geography_id%TYPE,
49: county_geo_type hz_geographies.geography_type%TYPE,
50: city hz_locations.city%TYPE,
51: city_geo_id hz_geographies.geography_id%TYPE,
52: city_geo_type hz_geographies.geography_type%TYPE,
53: postal_code hz_locations.postal_code%TYPE,
47: county hz_locations.county%TYPE,
48: county_geo_id hz_geographies.geography_id%TYPE,
49: county_geo_type hz_geographies.geography_type%TYPE,
50: city hz_locations.city%TYPE,
51: city_geo_id hz_geographies.geography_id%TYPE,
52: city_geo_type hz_geographies.geography_type%TYPE,
53: postal_code hz_locations.postal_code%TYPE,
54: postal_code_geo_id hz_geographies.geography_id%TYPE,
55: postal_code_geo_type hz_geographies.geography_type%TYPE,
48: county_geo_id hz_geographies.geography_id%TYPE,
49: county_geo_type hz_geographies.geography_type%TYPE,
50: city hz_locations.city%TYPE,
51: city_geo_id hz_geographies.geography_id%TYPE,
52: city_geo_type hz_geographies.geography_type%TYPE,
53: postal_code hz_locations.postal_code%TYPE,
54: postal_code_geo_id hz_geographies.geography_id%TYPE,
55: postal_code_geo_type hz_geographies.geography_type%TYPE,
56: postal_plus4_code hz_locations.postal_plus4_code%TYPE,
50: city hz_locations.city%TYPE,
51: city_geo_id hz_geographies.geography_id%TYPE,
52: city_geo_type hz_geographies.geography_type%TYPE,
53: postal_code hz_locations.postal_code%TYPE,
54: postal_code_geo_id hz_geographies.geography_id%TYPE,
55: postal_code_geo_type hz_geographies.geography_type%TYPE,
56: postal_plus4_code hz_locations.postal_plus4_code%TYPE,
57: postal_plus4_code_geo_id hz_geographies.geography_id%TYPE,
58: postal_plus4_code_geo_type hz_geographies.geography_type%TYPE,
51: city_geo_id hz_geographies.geography_id%TYPE,
52: city_geo_type hz_geographies.geography_type%TYPE,
53: postal_code hz_locations.postal_code%TYPE,
54: postal_code_geo_id hz_geographies.geography_id%TYPE,
55: postal_code_geo_type hz_geographies.geography_type%TYPE,
56: postal_plus4_code hz_locations.postal_plus4_code%TYPE,
57: postal_plus4_code_geo_id hz_geographies.geography_id%TYPE,
58: postal_plus4_code_geo_type hz_geographies.geography_type%TYPE,
59: attribute1 hz_locations.attribute1%TYPE,
53: postal_code hz_locations.postal_code%TYPE,
54: postal_code_geo_id hz_geographies.geography_id%TYPE,
55: postal_code_geo_type hz_geographies.geography_type%TYPE,
56: postal_plus4_code hz_locations.postal_plus4_code%TYPE,
57: postal_plus4_code_geo_id hz_geographies.geography_id%TYPE,
58: postal_plus4_code_geo_type hz_geographies.geography_type%TYPE,
59: attribute1 hz_locations.attribute1%TYPE,
60: attribute1_geo_id hz_geographies.geography_id%TYPE,
61: attribute1_geo_type hz_geographies.geography_type%TYPE,
54: postal_code_geo_id hz_geographies.geography_id%TYPE,
55: postal_code_geo_type hz_geographies.geography_type%TYPE,
56: postal_plus4_code hz_locations.postal_plus4_code%TYPE,
57: postal_plus4_code_geo_id hz_geographies.geography_id%TYPE,
58: postal_plus4_code_geo_type hz_geographies.geography_type%TYPE,
59: attribute1 hz_locations.attribute1%TYPE,
60: attribute1_geo_id hz_geographies.geography_id%TYPE,
61: attribute1_geo_type hz_geographies.geography_type%TYPE,
62: attribute2 hz_locations.attribute2%TYPE,
56: postal_plus4_code hz_locations.postal_plus4_code%TYPE,
57: postal_plus4_code_geo_id hz_geographies.geography_id%TYPE,
58: postal_plus4_code_geo_type hz_geographies.geography_type%TYPE,
59: attribute1 hz_locations.attribute1%TYPE,
60: attribute1_geo_id hz_geographies.geography_id%TYPE,
61: attribute1_geo_type hz_geographies.geography_type%TYPE,
62: attribute2 hz_locations.attribute2%TYPE,
63: attribute2_geo_id hz_geographies.geography_id%TYPE,
64: attribute2_geo_type hz_geographies.geography_type%TYPE,
57: postal_plus4_code_geo_id hz_geographies.geography_id%TYPE,
58: postal_plus4_code_geo_type hz_geographies.geography_type%TYPE,
59: attribute1 hz_locations.attribute1%TYPE,
60: attribute1_geo_id hz_geographies.geography_id%TYPE,
61: attribute1_geo_type hz_geographies.geography_type%TYPE,
62: attribute2 hz_locations.attribute2%TYPE,
63: attribute2_geo_id hz_geographies.geography_id%TYPE,
64: attribute2_geo_type hz_geographies.geography_type%TYPE,
65: attribute3 hz_locations.attribute3%TYPE,
59: attribute1 hz_locations.attribute1%TYPE,
60: attribute1_geo_id hz_geographies.geography_id%TYPE,
61: attribute1_geo_type hz_geographies.geography_type%TYPE,
62: attribute2 hz_locations.attribute2%TYPE,
63: attribute2_geo_id hz_geographies.geography_id%TYPE,
64: attribute2_geo_type hz_geographies.geography_type%TYPE,
65: attribute3 hz_locations.attribute3%TYPE,
66: attribute3_geo_id hz_geographies.geography_id%TYPE,
67: attribute3_geo_type hz_geographies.geography_type%TYPE,
60: attribute1_geo_id hz_geographies.geography_id%TYPE,
61: attribute1_geo_type hz_geographies.geography_type%TYPE,
62: attribute2 hz_locations.attribute2%TYPE,
63: attribute2_geo_id hz_geographies.geography_id%TYPE,
64: attribute2_geo_type hz_geographies.geography_type%TYPE,
65: attribute3 hz_locations.attribute3%TYPE,
66: attribute3_geo_id hz_geographies.geography_id%TYPE,
67: attribute3_geo_type hz_geographies.geography_type%TYPE,
68: attribute4 hz_locations.attribute4%TYPE,
62: attribute2 hz_locations.attribute2%TYPE,
63: attribute2_geo_id hz_geographies.geography_id%TYPE,
64: attribute2_geo_type hz_geographies.geography_type%TYPE,
65: attribute3 hz_locations.attribute3%TYPE,
66: attribute3_geo_id hz_geographies.geography_id%TYPE,
67: attribute3_geo_type hz_geographies.geography_type%TYPE,
68: attribute4 hz_locations.attribute4%TYPE,
69: attribute4_geo_id hz_geographies.geography_id%TYPE,
70: attribute4_geo_type hz_geographies.geography_type%TYPE,
63: attribute2_geo_id hz_geographies.geography_id%TYPE,
64: attribute2_geo_type hz_geographies.geography_type%TYPE,
65: attribute3 hz_locations.attribute3%TYPE,
66: attribute3_geo_id hz_geographies.geography_id%TYPE,
67: attribute3_geo_type hz_geographies.geography_type%TYPE,
68: attribute4 hz_locations.attribute4%TYPE,
69: attribute4_geo_id hz_geographies.geography_id%TYPE,
70: attribute4_geo_type hz_geographies.geography_type%TYPE,
71: attribute5 hz_locations.attribute5%TYPE,
65: attribute3 hz_locations.attribute3%TYPE,
66: attribute3_geo_id hz_geographies.geography_id%TYPE,
67: attribute3_geo_type hz_geographies.geography_type%TYPE,
68: attribute4 hz_locations.attribute4%TYPE,
69: attribute4_geo_id hz_geographies.geography_id%TYPE,
70: attribute4_geo_type hz_geographies.geography_type%TYPE,
71: attribute5 hz_locations.attribute5%TYPE,
72: attribute5_geo_id hz_geographies.geography_id%TYPE,
73: attribute5_geo_type hz_geographies.geography_type%TYPE,
66: attribute3_geo_id hz_geographies.geography_id%TYPE,
67: attribute3_geo_type hz_geographies.geography_type%TYPE,
68: attribute4 hz_locations.attribute4%TYPE,
69: attribute4_geo_id hz_geographies.geography_id%TYPE,
70: attribute4_geo_type hz_geographies.geography_type%TYPE,
71: attribute5 hz_locations.attribute5%TYPE,
72: attribute5_geo_id hz_geographies.geography_id%TYPE,
73: attribute5_geo_type hz_geographies.geography_type%TYPE,
74: attribute6 hz_locations.attribute6%TYPE,
68: attribute4 hz_locations.attribute4%TYPE,
69: attribute4_geo_id hz_geographies.geography_id%TYPE,
70: attribute4_geo_type hz_geographies.geography_type%TYPE,
71: attribute5 hz_locations.attribute5%TYPE,
72: attribute5_geo_id hz_geographies.geography_id%TYPE,
73: attribute5_geo_type hz_geographies.geography_type%TYPE,
74: attribute6 hz_locations.attribute6%TYPE,
75: attribute6_geo_id hz_geographies.geography_id%TYPE,
76: attribute6_geo_type hz_geographies.geography_type%TYPE,
69: attribute4_geo_id hz_geographies.geography_id%TYPE,
70: attribute4_geo_type hz_geographies.geography_type%TYPE,
71: attribute5 hz_locations.attribute5%TYPE,
72: attribute5_geo_id hz_geographies.geography_id%TYPE,
73: attribute5_geo_type hz_geographies.geography_type%TYPE,
74: attribute6 hz_locations.attribute6%TYPE,
75: attribute6_geo_id hz_geographies.geography_id%TYPE,
76: attribute6_geo_type hz_geographies.geography_type%TYPE,
77: attribute7 hz_locations.attribute7%TYPE,
71: attribute5 hz_locations.attribute5%TYPE,
72: attribute5_geo_id hz_geographies.geography_id%TYPE,
73: attribute5_geo_type hz_geographies.geography_type%TYPE,
74: attribute6 hz_locations.attribute6%TYPE,
75: attribute6_geo_id hz_geographies.geography_id%TYPE,
76: attribute6_geo_type hz_geographies.geography_type%TYPE,
77: attribute7 hz_locations.attribute7%TYPE,
78: attribute7_geo_id hz_geographies.geography_id%TYPE,
79: attribute7_geo_type hz_geographies.geography_type%TYPE,
72: attribute5_geo_id hz_geographies.geography_id%TYPE,
73: attribute5_geo_type hz_geographies.geography_type%TYPE,
74: attribute6 hz_locations.attribute6%TYPE,
75: attribute6_geo_id hz_geographies.geography_id%TYPE,
76: attribute6_geo_type hz_geographies.geography_type%TYPE,
77: attribute7 hz_locations.attribute7%TYPE,
78: attribute7_geo_id hz_geographies.geography_id%TYPE,
79: attribute7_geo_type hz_geographies.geography_type%TYPE,
80: attribute8 hz_locations.attribute8%TYPE,
74: attribute6 hz_locations.attribute6%TYPE,
75: attribute6_geo_id hz_geographies.geography_id%TYPE,
76: attribute6_geo_type hz_geographies.geography_type%TYPE,
77: attribute7 hz_locations.attribute7%TYPE,
78: attribute7_geo_id hz_geographies.geography_id%TYPE,
79: attribute7_geo_type hz_geographies.geography_type%TYPE,
80: attribute8 hz_locations.attribute8%TYPE,
81: attribute8_geo_id hz_geographies.geography_id%TYPE,
82: attribute8_geo_type hz_geographies.geography_type%TYPE,
75: attribute6_geo_id hz_geographies.geography_id%TYPE,
76: attribute6_geo_type hz_geographies.geography_type%TYPE,
77: attribute7 hz_locations.attribute7%TYPE,
78: attribute7_geo_id hz_geographies.geography_id%TYPE,
79: attribute7_geo_type hz_geographies.geography_type%TYPE,
80: attribute8 hz_locations.attribute8%TYPE,
81: attribute8_geo_id hz_geographies.geography_id%TYPE,
82: attribute8_geo_type hz_geographies.geography_type%TYPE,
83: attribute9 hz_locations.attribute9%TYPE,
77: attribute7 hz_locations.attribute7%TYPE,
78: attribute7_geo_id hz_geographies.geography_id%TYPE,
79: attribute7_geo_type hz_geographies.geography_type%TYPE,
80: attribute8 hz_locations.attribute8%TYPE,
81: attribute8_geo_id hz_geographies.geography_id%TYPE,
82: attribute8_geo_type hz_geographies.geography_type%TYPE,
83: attribute9 hz_locations.attribute9%TYPE,
84: attribute9_geo_id hz_geographies.geography_id%TYPE,
85: attribute9_geo_type hz_geographies.geography_type%TYPE,
78: attribute7_geo_id hz_geographies.geography_id%TYPE,
79: attribute7_geo_type hz_geographies.geography_type%TYPE,
80: attribute8 hz_locations.attribute8%TYPE,
81: attribute8_geo_id hz_geographies.geography_id%TYPE,
82: attribute8_geo_type hz_geographies.geography_type%TYPE,
83: attribute9 hz_locations.attribute9%TYPE,
84: attribute9_geo_id hz_geographies.geography_id%TYPE,
85: attribute9_geo_type hz_geographies.geography_type%TYPE,
86: attribute10 hz_locations.attribute10%TYPE,
80: attribute8 hz_locations.attribute8%TYPE,
81: attribute8_geo_id hz_geographies.geography_id%TYPE,
82: attribute8_geo_type hz_geographies.geography_type%TYPE,
83: attribute9 hz_locations.attribute9%TYPE,
84: attribute9_geo_id hz_geographies.geography_id%TYPE,
85: attribute9_geo_type hz_geographies.geography_type%TYPE,
86: attribute10 hz_locations.attribute10%TYPE,
87: attribute10_geo_id hz_geographies.geography_id%TYPE,
88: attribute10_geo_type hz_geographies.geography_type%TYPE,
81: attribute8_geo_id hz_geographies.geography_id%TYPE,
82: attribute8_geo_type hz_geographies.geography_type%TYPE,
83: attribute9 hz_locations.attribute9%TYPE,
84: attribute9_geo_id hz_geographies.geography_id%TYPE,
85: attribute9_geo_type hz_geographies.geography_type%TYPE,
86: attribute10 hz_locations.attribute10%TYPE,
87: attribute10_geo_id hz_geographies.geography_id%TYPE,
88: attribute10_geo_type hz_geographies.geography_type%TYPE,
89: suggestion_list VARCHAR2(4000)
83: attribute9 hz_locations.attribute9%TYPE,
84: attribute9_geo_id hz_geographies.geography_id%TYPE,
85: attribute9_geo_type hz_geographies.geography_type%TYPE,
86: attribute10 hz_locations.attribute10%TYPE,
87: attribute10_geo_id hz_geographies.geography_id%TYPE,
88: attribute10_geo_type hz_geographies.geography_type%TYPE,
89: suggestion_list VARCHAR2(4000)
90: );
91:
84: attribute9_geo_id hz_geographies.geography_id%TYPE,
85: attribute9_geo_type hz_geographies.geography_type%TYPE,
86: attribute10 hz_locations.attribute10%TYPE,
87: attribute10_geo_id hz_geographies.geography_id%TYPE,
88: attribute10_geo_type hz_geographies.geography_type%TYPE,
89: suggestion_list VARCHAR2(4000)
90: );
91:
92: TYPE geo_suggest_tbl_type IS TABLE OF geo_suggest_rec INDEX BY BINARY_INTEGER;