eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_DIST_DWNLD_PKG dependencies on WSH_REGIONS_V

Line 34: -- from WSH_REGIONS_V (changed to the --

30: -- 2004/03/05 J ABLUNDEL 3487060 PROCEDURE: CREATE_DWNLD_FILE --
31: -- Need to check that region values --
32: -- exist for translated values for --
33: -- the return from c_get_region_values--
34: -- from WSH_REGIONS_V (changed to the --
35: -- view, VL) from the TL table --
36: -- --
37: -- -------------------------------------------------------------------------- --
38:

Line 1876: -- from WSH_REGIONS_V (changed to the --

1872: -- --
1873: -- 2004/03/05 J ABLUNDEL 3487060 Need to check that region values --
1874: -- exist for translated values for --
1875: -- the return from c_get_region_values--
1876: -- from WSH_REGIONS_V (changed to the --
1877: -- view, VL) from the TL table --
1878: -- --
1879: -- -------------------------------------------------------------------------- --
1880: PROCEDURE CREATE_DWNLD_FILE(p_origin_route IN PLS_INTEGER,

Line 2068: from wsh_regions_v wrtl

2064: wrtl.city,
2065: wrtl.state,
2066: null,
2067: wrtl.country
2068: from wsh_regions_v wrtl
2069: where wrtl.region_id = cp_region_id;
2070:
2071:
2072:

Line 2267: -- Set the language for getting info from wsh_regions_v -- [BUG:3487060] not used anymore but keep for debug messages

2263: l_rettim_length_tab.DELETE;
2264:
2265:
2266: --
2267: -- Set the language for getting info from wsh_regions_v -- [BUG:3487060] not used anymore but keep for debug messages
2268: --
2269: l_language := nvl(userenv('LANG'),'US');
2270:
2271: IF l_debug_on THEN

Line 3955: -- in WSH_REGIONS_V - if not we log a bug

3951:
3952: --
3953: -- [ABLUNDEL][03/05/2004][BUG:3487060]
3954: -- Need to check that region values exist for the translated values
3955: -- in WSH_REGIONS_V - if not we log a bug
3956: --
3957: IF (l_reg_region_id_tab.COUNT = 0) THEN
3958: --
3959: -- There are no region values from WSH_REGIONS_V for the region id and the language

Line 3959: -- There are no region values from WSH_REGIONS_V for the region id and the language

3955: -- in WSH_REGIONS_V - if not we log a bug
3956: --
3957: IF (l_reg_region_id_tab.COUNT = 0) THEN
3958: --
3959: -- There are no region values from WSH_REGIONS_V for the region id and the language
3960: --
3961: IF l_debug_on THEN
3962: WSH_DEBUG_SV.logmsg(l_module_name,'c_get_region_values - There are no region values from WSH_REGIONS_V for the region id and the language');
3963: WSH_DEBUG_SV.log(l_module_name,'l_origin region_id(kkkk)',l_origin_region_id(kkkk));

Line 3962: WSH_DEBUG_SV.logmsg(l_module_name,'c_get_region_values - There are no region values from WSH_REGIONS_V for the region id and the language');

3958: --
3959: -- There are no region values from WSH_REGIONS_V for the region id and the language
3960: --
3961: IF l_debug_on THEN
3962: WSH_DEBUG_SV.logmsg(l_module_name,'c_get_region_values - There are no region values from WSH_REGIONS_V for the region id and the language');
3963: WSH_DEBUG_SV.log(l_module_name,'l_origin region_id(kkkk)',l_origin_region_id(kkkk));
3964: WSH_DEBUG_SV.log(l_module_name,'l_language',l_language);
3965: END IF;
3966:

Line 4069: -- in WSH_REGIONS_V - if not we log a bug

4065:
4066: --
4067: -- [ABLUNDEL][03/05/2004][BUG:3487060]
4068: -- Need to check that region values exist for the translated values
4069: -- in WSH_REGIONS_V - if not we log a bug
4070: --
4071: IF (l_reg_region_id_tab.COUNT = 0) THEN
4072: --
4073: -- There are no region values from WSH_REGIONS_V for the region id and the language

Line 4073: -- There are no region values from WSH_REGIONS_V for the region id and the language

4069: -- in WSH_REGIONS_V - if not we log a bug
4070: --
4071: IF (l_reg_region_id_tab.COUNT = 0) THEN
4072: --
4073: -- There are no region values from WSH_REGIONS_V for the region id and the language
4074: --
4075: IF l_debug_on THEN
4076: WSH_DEBUG_SV.logmsg(l_module_name,'c_get_region_values - There are no region values from WSH_REGIONS_V for the region id and the language');
4077: WSH_DEBUG_SV.log(l_module_name,'l_destination_region_id(llll)',l_destination_region_id(llll));

Line 4076: WSH_DEBUG_SV.logmsg(l_module_name,'c_get_region_values - There are no region values from WSH_REGIONS_V for the region id and the language');

4072: --
4073: -- There are no region values from WSH_REGIONS_V for the region id and the language
4074: --
4075: IF l_debug_on THEN
4076: WSH_DEBUG_SV.logmsg(l_module_name,'c_get_region_values - There are no region values from WSH_REGIONS_V for the region id and the language');
4077: WSH_DEBUG_SV.log(l_module_name,'l_destination_region_id(llll)',l_destination_region_id(llll));
4078: WSH_DEBUG_SV.log(l_module_name,'l_language',l_language);
4079: END IF;
4080: