APPS.FTE_REGION_ZONE_LOADER dependencies on WSH_REGIONS_SEARCH_PKG

Line 221: -- Purpose: call wsh_regions_search_pkg and get region information

217: --_______________________________________________________________________________________--
218: --
219: -- FUNCTION GET_REGION_ID
220: --
221: -- Purpose: call wsh_regions_search_pkg and get region information
222: --
223: -- IN parameters:
224: -- 1. p_region_info: region information record
225: --

Line 231: FUNCTION GET_REGION_ID(p_region_info IN WSH_REGIONS_SEARCH_PKG.REGION_REC)

227: -- 1. x_status: status, -1 if no error
228: -- 2. x_error_msg: error message if error
229: --_______________________________________________________________________________________--
230:
231: FUNCTION GET_REGION_ID(p_region_info IN WSH_REGIONS_SEARCH_PKG.REGION_REC)
232:
233: RETURN NUMBER IS
234:
235: x_region_info WSH_REGIONS_SEARCH_PKG.REGION_REC;

Line 235: x_region_info WSH_REGIONS_SEARCH_PKG.REGION_REC;

231: FUNCTION GET_REGION_ID(p_region_info IN WSH_REGIONS_SEARCH_PKG.REGION_REC)
232:
233: RETURN NUMBER IS
234:
235: x_region_info WSH_REGIONS_SEARCH_PKG.REGION_REC;
236:
237: l_country_code VARCHAR2(3) := '';
238: l_country VARCHAR2(50);
239: l_state P_REGION_INFO.STATE%TYPE;

Line 255: -- WSH_REGIONS_SEARCH_PKG.Get_Region_Info expects a country

251: l_city := p_region_info.CITY;
252: l_state := p_region_info.STATE;
253:
254: --+
255: -- WSH_REGIONS_SEARCH_PKG.Get_Region_Info expects a country
256: -- name as its first argument, and not a country code
257: -- i.e. 'United States' instead of 'US'. If we THINK that the
258: -- 'country' argument supplied is a country code, we pass it as
259: -- the 'country code' argument.

Line 278: WSH_REGIONS_SEARCH_PKG.Get_Region_Info(

274: l_city_code := l_city;
275: l_city := NULL;
276: END IF;
277:
278: WSH_REGIONS_SEARCH_PKG.Get_Region_Info(
279: p_country => l_country,
280: p_country_region => '',
281: p_state => l_state,
282: p_city => l_city,

Line 310: -- Purpose: call wsh_regions_search_pkg and get region information

306: --_______________________________________________________________________________________--
307: --
308: -- FUNCTION GET_REGION_ID
309: --
310: -- Purpose: call wsh_regions_search_pkg and get region information
311: --
312: -- IN parameters:
313: -- 1. p_region_info: region information record
314: -- 2. p_recursively_flag: recursive search flag

Line 320: FUNCTION GET_REGION_ID(p_region_info IN WSH_REGIONS_SEARCH_PKG.REGION_REC,

316: -- RETURN
317: -- 1. region id
318: --_______________________________________________________________________________________--
319:
320: FUNCTION GET_REGION_ID(p_region_info IN WSH_REGIONS_SEARCH_PKG.REGION_REC,
321: p_recursively_flag IN VARCHAR2)
322:
323: RETURN NUMBER IS
324:

Line 345: -- WSH_REGIONS_SEARCH_PKG.Get_Region_Info expects a country

341: l_city := p_region_info.CITY;
342: l_state := p_region_info.STATE;
343:
344: --+
345: -- WSH_REGIONS_SEARCH_PKG.Get_Region_Info expects a country
346: -- name as its first argument, and not a country code
347: -- i.e. 'United States' instead of 'US'. If we THINK that the
348: -- 'country' argument supplied is a country code, we pass it as
349: -- the 'country code' argument.

Line 365: WSH_REGIONS_SEARCH_PKG.Get_Region_Info(

361: l_city_code := l_city;
362: l_city := NULL;
363: END IF;
364:
365: WSH_REGIONS_SEARCH_PKG.Get_Region_Info(
366: p_country => l_country,
367: p_country_region => '',
368: p_state => l_state,
369: p_city => l_city,

Line 552: l_region_rec WSH_REGIONS_SEARCH_PKG.region_rec;

548: l_zone_name VARCHAR2(200);
549: l_country VARCHAR2(100);
550: l_zone_id NUMBER;
551: l_region_id NUMBER;
552: l_region_rec WSH_REGIONS_SEARCH_PKG.region_rec;
553: l_temp_id NUMBER;
554:
555: l_values FTE_BULKLOAD_PKG.data_values_tbl;
556: