APPS.FTE_VALIDATION_PKG dependencies on WSH_REGIONS

Line 2886: l_region_info wsh_regions_search_pkg.region_rec;

2882: l_rate_chart_name VARCHAR2(200);
2883: l_transit_time_uom_code VARCHAR2(100);
2884: l_convert_date DATE;
2885:
2886: l_region_info wsh_regions_search_pkg.region_rec;
2887: l_region_id wsh_regions.region_id%type;
2888:
2889: l_zone_id NUMBER;
2890: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.VALIDATE_SERVICE';

Line 2887: l_region_id wsh_regions.region_id%type;

2883: l_transit_time_uom_code VARCHAR2(100);
2884: l_convert_date DATE;
2885:
2886: l_region_info wsh_regions_search_pkg.region_rec;
2887: l_region_id wsh_regions.region_id%type;
2888:
2889: l_zone_id NUMBER;
2890: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.VALIDATE_SERVICE';
2891:

Line 6921: l_region_info WSH_REGIONS_SEARCH_PKG.REGION_REC;

6917: l_rate_chart_name VARCHAR2(200);
6918: l_editable_flag VARCHAR2(1) := 'Y';
6919: l_service_level VARCHAR2(50);
6920: l_convert_date DATE;
6921: l_region_info WSH_REGIONS_SEARCH_PKG.REGION_REC;
6922: l_mode_code VARCHAR2(20);
6923: l_mode CONSTANT VARCHAR2(20) := 'TRUCK';
6924: l_rate_chart_view_flag VARCHAR2(1) := 'Y';
6925:

Line 6934: l_region_id WSH_REGIONS.REGION_ID%TYPE;

6930:
6931: l_lane_rate_chart_data FTE_BULKLOAD_PKG.data_values_tbl;
6932: l_lane_service_level_data FTE_BULKLOAD_PKG.data_values_tbl;
6933:
6934: l_region_id WSH_REGIONS.REGION_ID%TYPE;
6935:
6936: g_debug_on BOOLEAN := TRUE;
6937:
6938: l_module_name CONSTANT VARCHAR2(60) := 'FTE.PLSQL.' || g_pkg_name || '.VALIDATE_TL_SERVICE';

Line 7395: p_region_rec OUT NOCOPY WSH_REGIONS_SEARCH_PKG.region_rec,

7391: p_action OUT NOCOPY VARCHAR2,
7392: p_zone_name OUT NOCOPY VARCHAR2,
7393: p_country OUT NOCOPY VARCHAR2,
7394: p_zone_id OUT NOCOPY NUMBER,
7395: p_region_rec OUT NOCOPY WSH_REGIONS_SEARCH_PKG.region_rec,
7396: p_region_id OUT NOCOPY NUMBER,
7397: x_status OUT NOCOPY NUMBER,
7398: x_error_msg OUT NOCOPY VARCHAR2) IS
7399: