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.WSH_REGIONS_PKG dependencies on WSH_REGIONS_TL

Line 27: TYPE tab_continent is TABLE OF WSH_REGIONS_TL.Continent%TYPE index by binary_integer;

23: TYPE tab_rail_terminal_flag is TABLE OF WSH_REGIONS.Rail_Terminal_Flag%TYPE index by binary_integer;
24: TYPE tab_longitude is TABLE OF WSH_REGIONS.Longitude%TYPE index by binary_integer;
25: TYPE tab_latitude is TABLE OF WSH_REGIONS.Latitude%TYPE index by binary_integer;
26: TYPE tab_timezone is TABLE OF WSH_REGIONS.Timezone%TYPE index by binary_integer;
27: TYPE tab_continent is TABLE OF WSH_REGIONS_TL.Continent%TYPE index by binary_integer;
28: TYPE tab_country is TABLE OF WSH_REGIONS_TL.Country%TYPE index by binary_integer;
29: TYPE tab_country_region is TABLE OF WSH_REGIONS_TL.Country_Region%TYPE index by binary_integer;
30: TYPE tab_state is TABLE OF WSH_REGIONS_TL.State%TYPE index by binary_integer;
31: TYPE tab_city is TABLE OF WSH_REGIONS_TL.City%TYPE index by binary_integer;

Line 28: TYPE tab_country is TABLE OF WSH_REGIONS_TL.Country%TYPE index by binary_integer;

24: TYPE tab_longitude is TABLE OF WSH_REGIONS.Longitude%TYPE index by binary_integer;
25: TYPE tab_latitude is TABLE OF WSH_REGIONS.Latitude%TYPE index by binary_integer;
26: TYPE tab_timezone is TABLE OF WSH_REGIONS.Timezone%TYPE index by binary_integer;
27: TYPE tab_continent is TABLE OF WSH_REGIONS_TL.Continent%TYPE index by binary_integer;
28: TYPE tab_country is TABLE OF WSH_REGIONS_TL.Country%TYPE index by binary_integer;
29: TYPE tab_country_region is TABLE OF WSH_REGIONS_TL.Country_Region%TYPE index by binary_integer;
30: TYPE tab_state is TABLE OF WSH_REGIONS_TL.State%TYPE index by binary_integer;
31: TYPE tab_city is TABLE OF WSH_REGIONS_TL.City%TYPE index by binary_integer;
32: TYPE tab_alternate_name is TABLE OF WSH_REGIONS_TL.Alternate_Name%TYPE index by binary_integer;

Line 29: TYPE tab_country_region is TABLE OF WSH_REGIONS_TL.Country_Region%TYPE index by binary_integer;

25: TYPE tab_latitude is TABLE OF WSH_REGIONS.Latitude%TYPE index by binary_integer;
26: TYPE tab_timezone is TABLE OF WSH_REGIONS.Timezone%TYPE index by binary_integer;
27: TYPE tab_continent is TABLE OF WSH_REGIONS_TL.Continent%TYPE index by binary_integer;
28: TYPE tab_country is TABLE OF WSH_REGIONS_TL.Country%TYPE index by binary_integer;
29: TYPE tab_country_region is TABLE OF WSH_REGIONS_TL.Country_Region%TYPE index by binary_integer;
30: TYPE tab_state is TABLE OF WSH_REGIONS_TL.State%TYPE index by binary_integer;
31: TYPE tab_city is TABLE OF WSH_REGIONS_TL.City%TYPE index by binary_integer;
32: TYPE tab_alternate_name is TABLE OF WSH_REGIONS_TL.Alternate_Name%TYPE index by binary_integer;
33: TYPE tab_county is TABLE OF WSH_REGIONS_TL.County%TYPE index by binary_integer;

Line 30: TYPE tab_state is TABLE OF WSH_REGIONS_TL.State%TYPE index by binary_integer;

26: TYPE tab_timezone is TABLE OF WSH_REGIONS.Timezone%TYPE index by binary_integer;
27: TYPE tab_continent is TABLE OF WSH_REGIONS_TL.Continent%TYPE index by binary_integer;
28: TYPE tab_country is TABLE OF WSH_REGIONS_TL.Country%TYPE index by binary_integer;
29: TYPE tab_country_region is TABLE OF WSH_REGIONS_TL.Country_Region%TYPE index by binary_integer;
30: TYPE tab_state is TABLE OF WSH_REGIONS_TL.State%TYPE index by binary_integer;
31: TYPE tab_city is TABLE OF WSH_REGIONS_TL.City%TYPE index by binary_integer;
32: TYPE tab_alternate_name is TABLE OF WSH_REGIONS_TL.Alternate_Name%TYPE index by binary_integer;
33: TYPE tab_county is TABLE OF WSH_REGIONS_TL.County%TYPE index by binary_integer;
34: TYPE tab_postal_code_from is TABLE OF WSH_REGIONS_TL.Postal_Code_From%TYPE index by binary_integer;

Line 31: TYPE tab_city is TABLE OF WSH_REGIONS_TL.City%TYPE index by binary_integer;

27: TYPE tab_continent is TABLE OF WSH_REGIONS_TL.Continent%TYPE index by binary_integer;
28: TYPE tab_country is TABLE OF WSH_REGIONS_TL.Country%TYPE index by binary_integer;
29: TYPE tab_country_region is TABLE OF WSH_REGIONS_TL.Country_Region%TYPE index by binary_integer;
30: TYPE tab_state is TABLE OF WSH_REGIONS_TL.State%TYPE index by binary_integer;
31: TYPE tab_city is TABLE OF WSH_REGIONS_TL.City%TYPE index by binary_integer;
32: TYPE tab_alternate_name is TABLE OF WSH_REGIONS_TL.Alternate_Name%TYPE index by binary_integer;
33: TYPE tab_county is TABLE OF WSH_REGIONS_TL.County%TYPE index by binary_integer;
34: TYPE tab_postal_code_from is TABLE OF WSH_REGIONS_TL.Postal_Code_From%TYPE index by binary_integer;
35: TYPE tab_postal_code_to is TABLE OF WSH_REGIONS_TL.Postal_Code_To%TYPE index by binary_integer;

Line 32: TYPE tab_alternate_name is TABLE OF WSH_REGIONS_TL.Alternate_Name%TYPE index by binary_integer;

28: TYPE tab_country is TABLE OF WSH_REGIONS_TL.Country%TYPE index by binary_integer;
29: TYPE tab_country_region is TABLE OF WSH_REGIONS_TL.Country_Region%TYPE index by binary_integer;
30: TYPE tab_state is TABLE OF WSH_REGIONS_TL.State%TYPE index by binary_integer;
31: TYPE tab_city is TABLE OF WSH_REGIONS_TL.City%TYPE index by binary_integer;
32: TYPE tab_alternate_name is TABLE OF WSH_REGIONS_TL.Alternate_Name%TYPE index by binary_integer;
33: TYPE tab_county is TABLE OF WSH_REGIONS_TL.County%TYPE index by binary_integer;
34: TYPE tab_postal_code_from is TABLE OF WSH_REGIONS_TL.Postal_Code_From%TYPE index by binary_integer;
35: TYPE tab_postal_code_to is TABLE OF WSH_REGIONS_TL.Postal_Code_To%TYPE index by binary_integer;
36: TYPE tab_language is TABLE OF WSH_REGIONS_TL.Language%TYPE index by binary_integer;

Line 33: TYPE tab_county is TABLE OF WSH_REGIONS_TL.County%TYPE index by binary_integer;

29: TYPE tab_country_region is TABLE OF WSH_REGIONS_TL.Country_Region%TYPE index by binary_integer;
30: TYPE tab_state is TABLE OF WSH_REGIONS_TL.State%TYPE index by binary_integer;
31: TYPE tab_city is TABLE OF WSH_REGIONS_TL.City%TYPE index by binary_integer;
32: TYPE tab_alternate_name is TABLE OF WSH_REGIONS_TL.Alternate_Name%TYPE index by binary_integer;
33: TYPE tab_county is TABLE OF WSH_REGIONS_TL.County%TYPE index by binary_integer;
34: TYPE tab_postal_code_from is TABLE OF WSH_REGIONS_TL.Postal_Code_From%TYPE index by binary_integer;
35: TYPE tab_postal_code_to is TABLE OF WSH_REGIONS_TL.Postal_Code_To%TYPE index by binary_integer;
36: TYPE tab_language is TABLE OF WSH_REGIONS_TL.Language%TYPE index by binary_integer;
37:

Line 34: TYPE tab_postal_code_from is TABLE OF WSH_REGIONS_TL.Postal_Code_From%TYPE index by binary_integer;

30: TYPE tab_state is TABLE OF WSH_REGIONS_TL.State%TYPE index by binary_integer;
31: TYPE tab_city is TABLE OF WSH_REGIONS_TL.City%TYPE index by binary_integer;
32: TYPE tab_alternate_name is TABLE OF WSH_REGIONS_TL.Alternate_Name%TYPE index by binary_integer;
33: TYPE tab_county is TABLE OF WSH_REGIONS_TL.County%TYPE index by binary_integer;
34: TYPE tab_postal_code_from is TABLE OF WSH_REGIONS_TL.Postal_Code_From%TYPE index by binary_integer;
35: TYPE tab_postal_code_to is TABLE OF WSH_REGIONS_TL.Postal_Code_To%TYPE index by binary_integer;
36: TYPE tab_language is TABLE OF WSH_REGIONS_TL.Language%TYPE index by binary_integer;
37:
38: --

Line 35: TYPE tab_postal_code_to is TABLE OF WSH_REGIONS_TL.Postal_Code_To%TYPE index by binary_integer;

31: TYPE tab_city is TABLE OF WSH_REGIONS_TL.City%TYPE index by binary_integer;
32: TYPE tab_alternate_name is TABLE OF WSH_REGIONS_TL.Alternate_Name%TYPE index by binary_integer;
33: TYPE tab_county is TABLE OF WSH_REGIONS_TL.County%TYPE index by binary_integer;
34: TYPE tab_postal_code_from is TABLE OF WSH_REGIONS_TL.Postal_Code_From%TYPE index by binary_integer;
35: TYPE tab_postal_code_to is TABLE OF WSH_REGIONS_TL.Postal_Code_To%TYPE index by binary_integer;
36: TYPE tab_language is TABLE OF WSH_REGIONS_TL.Language%TYPE index by binary_integer;
37:
38: --
39: -- PUBLIC VARIABLES

Line 36: TYPE tab_language is TABLE OF WSH_REGIONS_TL.Language%TYPE index by binary_integer;

32: TYPE tab_alternate_name is TABLE OF WSH_REGIONS_TL.Alternate_Name%TYPE index by binary_integer;
33: TYPE tab_county is TABLE OF WSH_REGIONS_TL.County%TYPE index by binary_integer;
34: TYPE tab_postal_code_from is TABLE OF WSH_REGIONS_TL.Postal_Code_From%TYPE index by binary_integer;
35: TYPE tab_postal_code_to is TABLE OF WSH_REGIONS_TL.Postal_Code_To%TYPE index by binary_integer;
36: TYPE tab_language is TABLE OF WSH_REGIONS_TL.Language%TYPE index by binary_integer;
37:
38: --
39: -- PUBLIC VARIABLES
40: --

Line 502: -- Wsh_Regions_Tl based on parameter p_populate_type.

498: -- PROCEDURE : Init_Global_Table
499: --
500: -- PURPOSE : Populates the data in Global Temp tables(Wsh_Regions_Global
501: -- and Wsh_Regions_Global_Data) fetched from Wsh_Regions and
502: -- Wsh_Regions_Tl based on parameter p_populate_type.
503: --
504: PROCEDURE Init_global_table (
505: p_country IN VARCHAR2,
506: p_state IN VARCHAR2,