133: -- exact match cursor
134: -------------------
135: CURSOR exact_cur IS
136: select territory_code
137: from fnd_territories_vl
138: where upper(territory_short_name) = upper(p_country)
139: and rownum = 1;
140:
141: exact_rec exact_cur%ROWTYPE;
144: -- fuzzy match cursor
145: -------------------
146: CURSOR fuzzy_count_cur IS
147: select count(1) fuzzy_count
148: from fnd_territories_vl
149: where
150: (
151: upper(territory_short_name) like '%'||upper(p_country)||'%'
152: or
157: l_fuzzy_count NUMBER := 0;
158:
159: CURSOR fuzzy_cur IS
160: select territory_code
161: from fnd_territories_vl
162: where
163: (
164: upper(territory_short_name) like '%'||upper(p_country)||'%'
165: or
173: -- extreme fuzzy match cursor
174: -------------------
175: CURSOR extreme_fuzzy_count_cur IS
176: select count(1) extreme_fuzzy_count
177: from fnd_territories_vl
178: where
179: (
180: upper(territory_short_name) like '%'||ap_web_upload_pdm_pkg.myreplace(upper(p_country))||'%'
181: or
186: l_extreme_fuzzy_count NUMBER := 0;
187:
188: CURSOR extreme_fuzzy_cur IS
189: select territory_code
190: from fnd_territories_vl
191: where
192: (
193: upper(territory_short_name) like '%'||ap_web_upload_pdm_pkg.myreplace(upper(p_country))||'%'
194: or
202: -- soundex match cursor
203: -------------------
204: CURSOR soundex_count_cur IS
205: select count(1) soundex_count
206: from fnd_territories_vl
207: where
208: (
209: ap_web_upload_pdm_pkg.mysoundex(upper(territory_short_name)) = ap_web_upload_pdm_pkg.mysoundex(upper(p_country))
210: or
215: l_soundex_count NUMBER := 0;
216:
217: CURSOR soundex_cur IS
218: select territory_code
219: from fnd_territories_vl
220: where
221: (
222: ap_web_upload_pdm_pkg.mysoundex(territory_short_name) = ap_web_upload_pdm_pkg.mysoundex(p_country)
223: or