APPS.AP_WEB_UPLOAD_PDM_PKG dependencies on AP_WEB_UPLOAD_PDM_PKG

Line 1: PACKAGE BODY AP_WEB_UPLOAD_PDM_PKG AS

1: PACKAGE BODY AP_WEB_UPLOAD_PDM_PKG AS
2: /* $Header: apwupdmb.pls 120.12.12000000.2 2007/02/12 23:23:23 skoukunt ship $ */
3:
4:
5: PROCEDURE put_line(p_buff IN VARCHAR2) IS

Line 180: upper(territory_short_name) like '%'||ap_web_upload_pdm_pkg.myreplace(upper(p_country))||'%'

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
182: upper(description) like '%'||ap_web_upload_pdm_pkg.myreplace(upper(p_country))||'%'
183: );
184:

Line 182: upper(description) like '%'||ap_web_upload_pdm_pkg.myreplace(upper(p_country))||'%'

178: where
179: (
180: upper(territory_short_name) like '%'||ap_web_upload_pdm_pkg.myreplace(upper(p_country))||'%'
181: or
182: upper(description) like '%'||ap_web_upload_pdm_pkg.myreplace(upper(p_country))||'%'
183: );
184:
185: extreme_fuzzy_count_rec extreme_fuzzy_count_cur%ROWTYPE;
186: l_extreme_fuzzy_count NUMBER := 0;

Line 193: upper(territory_short_name) like '%'||ap_web_upload_pdm_pkg.myreplace(upper(p_country))||'%'

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
195: upper(description) like '%'||ap_web_upload_pdm_pkg.myreplace(upper(p_country))||'%'
196: )
197: and rownum = 1;

Line 195: upper(description) like '%'||ap_web_upload_pdm_pkg.myreplace(upper(p_country))||'%'

191: where
192: (
193: upper(territory_short_name) like '%'||ap_web_upload_pdm_pkg.myreplace(upper(p_country))||'%'
194: or
195: upper(description) like '%'||ap_web_upload_pdm_pkg.myreplace(upper(p_country))||'%'
196: )
197: and rownum = 1;
198:
199: extreme_fuzzy_rec extreme_fuzzy_cur%ROWTYPE;

Line 209: ap_web_upload_pdm_pkg.mysoundex(upper(territory_short_name)) = ap_web_upload_pdm_pkg.mysoundex(upper(p_country))

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
211: ap_web_upload_pdm_pkg.mysoundex(upper(description)) = ap_web_upload_pdm_pkg.mysoundex(upper(p_country))
212: );
213:

Line 211: ap_web_upload_pdm_pkg.mysoundex(upper(description)) = ap_web_upload_pdm_pkg.mysoundex(upper(p_country))

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
211: ap_web_upload_pdm_pkg.mysoundex(upper(description)) = ap_web_upload_pdm_pkg.mysoundex(upper(p_country))
212: );
213:
214: soundex_count_rec soundex_count_cur%ROWTYPE;
215: l_soundex_count NUMBER := 0;

Line 222: ap_web_upload_pdm_pkg.mysoundex(territory_short_name) = ap_web_upload_pdm_pkg.mysoundex(p_country)

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
224: ap_web_upload_pdm_pkg.mysoundex(description) = ap_web_upload_pdm_pkg.mysoundex(p_country)
225: )
226: and rownum = 1;

Line 224: ap_web_upload_pdm_pkg.mysoundex(description) = ap_web_upload_pdm_pkg.mysoundex(p_country)

220: where
221: (
222: ap_web_upload_pdm_pkg.mysoundex(territory_short_name) = ap_web_upload_pdm_pkg.mysoundex(p_country)
223: or
224: ap_web_upload_pdm_pkg.mysoundex(description) = ap_web_upload_pdm_pkg.mysoundex(p_country)
225: )
226: and rownum = 1;
227:
228: soundex_rec soundex_cur%ROWTYPE;

Line 4015: END AP_WEB_UPLOAD_PDM_PKG;

4011:
4012: END ValidateFileFormat;
4013:
4014:
4015: END AP_WEB_UPLOAD_PDM_PKG;