APPS.FTE_LANE_SEARCH dependencies on WSH_REGIONS_SEARCH_PKG

Line 15: -- WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches

11: -- Name: Set_Up_Regions
12: -- Type: Procedure
13: --
14: -- Description: This procedure calls
15: -- WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches
16: -- with location_id and/or regions information
17: -- and obtains all the regions and parent regions
18: -- that match.
19: --

Line 38: l_regions_temp WSH_REGIONS_SEARCH_PKG.region_table;

34: l_city VARCHAR2(60) := null;
35: l_city_code VARCHAR2(10) := null;
36:
37: l_status NUMBER;
38: l_regions_temp WSH_REGIONS_SEARCH_PKG.region_table;
39: l_region WSH_REGIONS_SEARCH_PKG.region_rec;
40:
41: l_regions FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
42: l_parent_regions FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;

Line 39: l_region WSH_REGIONS_SEARCH_PKG.region_rec;

35: l_city_code VARCHAR2(10) := null;
36:
37: l_status NUMBER;
38: l_regions_temp WSH_REGIONS_SEARCH_PKG.region_table;
39: l_region WSH_REGIONS_SEARCH_PKG.region_rec;
40:
41: l_regions FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
42: l_parent_regions FTE_LANE_SEARCH_QUERY_GEN.fte_lane_search_regions_tab;
43:

Line 120: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_ALL_REGION_MATCHES',WSH_DEBUG_SV.C_PROC_LEVEL);

116: --
117: -- Debug Statements
118: --
119: IF l_debug_on THEN
120: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_ALL_REGION_MATCHES',WSH_DEBUG_SV.C_PROC_LEVEL);
121: END IF;
122: --
123: BEGIN
124: WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches(p_country => l_country,

Line 124: WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches(p_country => l_country,

120: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_ALL_REGION_MATCHES',WSH_DEBUG_SV.C_PROC_LEVEL);
121: END IF;
122: --
123: BEGIN
124: WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches(p_country => l_country,
125: p_country_region => null,
126: p_state => l_state,
127: p_city => l_city,
128: p_postal_code_from => p_zip,

Line 162: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_ALL_REGION_MATCHES',WSH_DEBUG_SV.C_PROC_LEVEL);

158: --
159: -- Debug Statements
160: --
161: IF l_debug_on THEN
162: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_ALL_REGION_MATCHES',WSH_DEBUG_SV.C_PROC_LEVEL);
163: END IF;
164: --
165: BEGIN
166: WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches(p_country => l_country,

Line 166: WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches(p_country => l_country,

162: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_ALL_REGION_MATCHES',WSH_DEBUG_SV.C_PROC_LEVEL);
163: END IF;
164: --
165: BEGIN
166: WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches(p_country => l_country,
167: p_country_region => null,
168: p_state => l_state,
169: p_city => l_city,
170: p_postal_code_from => p_zip,