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

Line 1: PACKAGE WSH_REGIONS_PKG AS

1: PACKAGE WSH_REGIONS_PKG AS
2: /* $Header: WSHRETHS.pls 120.1 2005/07/05 00:17:27 pkaliyam noship $ */
3:
4: --
5: -- Package

Line 6: -- WSH_REGIONS_PKG

2: /* $Header: WSHRETHS.pls 120.1 2005/07/05 00:17:27 pkaliyam noship $ */
3:
4: --
5: -- Package
6: -- WSH_REGIONS_PKG
7: --
8: -- Purpose
9: --
10:

Line 15: TYPE tab_region_id is TABLE OF WSH_REGIONS.Region_Id%TYPE index by binary_integer;

11: --
12: -- PACKAGE TYPES
13: --
14:
15: TYPE tab_region_id is TABLE OF WSH_REGIONS.Region_Id%TYPE index by binary_integer;
16: TYPE tab_country_code is TABLE OF WSH_REGIONS.Country_Code%TYPE index by binary_integer;
17: TYPE tab_country_region_code is TABLE OF WSH_REGIONS.Country_Region_Code%TYPE index by binary_integer;
18: TYPE tab_state_code is TABLE OF WSH_REGIONS.State_Code%TYPE index by binary_integer;
19: TYPE tab_city_code is TABLE OF WSH_REGIONS.City_Code%TYPE index by binary_integer;

Line 16: TYPE tab_country_code is TABLE OF WSH_REGIONS.Country_Code%TYPE index by binary_integer;

12: -- PACKAGE TYPES
13: --
14:
15: TYPE tab_region_id is TABLE OF WSH_REGIONS.Region_Id%TYPE index by binary_integer;
16: TYPE tab_country_code is TABLE OF WSH_REGIONS.Country_Code%TYPE index by binary_integer;
17: TYPE tab_country_region_code is TABLE OF WSH_REGIONS.Country_Region_Code%TYPE index by binary_integer;
18: TYPE tab_state_code is TABLE OF WSH_REGIONS.State_Code%TYPE index by binary_integer;
19: TYPE tab_city_code is TABLE OF WSH_REGIONS.City_Code%TYPE index by binary_integer;
20: TYPE tab_port_flag is TABLE OF WSH_REGIONS.Port_Flag%TYPE index by binary_integer;

Line 17: TYPE tab_country_region_code is TABLE OF WSH_REGIONS.Country_Region_Code%TYPE index by binary_integer;

13: --
14:
15: TYPE tab_region_id is TABLE OF WSH_REGIONS.Region_Id%TYPE index by binary_integer;
16: TYPE tab_country_code is TABLE OF WSH_REGIONS.Country_Code%TYPE index by binary_integer;
17: TYPE tab_country_region_code is TABLE OF WSH_REGIONS.Country_Region_Code%TYPE index by binary_integer;
18: TYPE tab_state_code is TABLE OF WSH_REGIONS.State_Code%TYPE index by binary_integer;
19: TYPE tab_city_code is TABLE OF WSH_REGIONS.City_Code%TYPE index by binary_integer;
20: TYPE tab_port_flag is TABLE OF WSH_REGIONS.Port_Flag%TYPE index by binary_integer;
21: TYPE tab_airport_flag is TABLE OF WSH_REGIONS.Airport_Flag%TYPE index by binary_integer;

Line 18: TYPE tab_state_code is TABLE OF WSH_REGIONS.State_Code%TYPE index by binary_integer;

14:
15: TYPE tab_region_id is TABLE OF WSH_REGIONS.Region_Id%TYPE index by binary_integer;
16: TYPE tab_country_code is TABLE OF WSH_REGIONS.Country_Code%TYPE index by binary_integer;
17: TYPE tab_country_region_code is TABLE OF WSH_REGIONS.Country_Region_Code%TYPE index by binary_integer;
18: TYPE tab_state_code is TABLE OF WSH_REGIONS.State_Code%TYPE index by binary_integer;
19: TYPE tab_city_code is TABLE OF WSH_REGIONS.City_Code%TYPE index by binary_integer;
20: TYPE tab_port_flag is TABLE OF WSH_REGIONS.Port_Flag%TYPE index by binary_integer;
21: TYPE tab_airport_flag is TABLE OF WSH_REGIONS.Airport_Flag%TYPE index by binary_integer;
22: TYPE tab_road_terminal_flag is TABLE OF WSH_REGIONS.Road_Terminal_Flag%TYPE index by binary_integer;

Line 19: TYPE tab_city_code is TABLE OF WSH_REGIONS.City_Code%TYPE index by binary_integer;

15: TYPE tab_region_id is TABLE OF WSH_REGIONS.Region_Id%TYPE index by binary_integer;
16: TYPE tab_country_code is TABLE OF WSH_REGIONS.Country_Code%TYPE index by binary_integer;
17: TYPE tab_country_region_code is TABLE OF WSH_REGIONS.Country_Region_Code%TYPE index by binary_integer;
18: TYPE tab_state_code is TABLE OF WSH_REGIONS.State_Code%TYPE index by binary_integer;
19: TYPE tab_city_code is TABLE OF WSH_REGIONS.City_Code%TYPE index by binary_integer;
20: TYPE tab_port_flag is TABLE OF WSH_REGIONS.Port_Flag%TYPE index by binary_integer;
21: TYPE tab_airport_flag is TABLE OF WSH_REGIONS.Airport_Flag%TYPE index by binary_integer;
22: TYPE tab_road_terminal_flag is TABLE OF WSH_REGIONS.Road_Terminal_Flag%TYPE index by binary_integer;
23: TYPE tab_rail_terminal_flag is TABLE OF WSH_REGIONS.Rail_Terminal_Flag%TYPE index by binary_integer;

Line 20: TYPE tab_port_flag is TABLE OF WSH_REGIONS.Port_Flag%TYPE index by binary_integer;

16: TYPE tab_country_code is TABLE OF WSH_REGIONS.Country_Code%TYPE index by binary_integer;
17: TYPE tab_country_region_code is TABLE OF WSH_REGIONS.Country_Region_Code%TYPE index by binary_integer;
18: TYPE tab_state_code is TABLE OF WSH_REGIONS.State_Code%TYPE index by binary_integer;
19: TYPE tab_city_code is TABLE OF WSH_REGIONS.City_Code%TYPE index by binary_integer;
20: TYPE tab_port_flag is TABLE OF WSH_REGIONS.Port_Flag%TYPE index by binary_integer;
21: TYPE tab_airport_flag is TABLE OF WSH_REGIONS.Airport_Flag%TYPE index by binary_integer;
22: TYPE tab_road_terminal_flag is TABLE OF WSH_REGIONS.Road_Terminal_Flag%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;

Line 21: TYPE tab_airport_flag is TABLE OF WSH_REGIONS.Airport_Flag%TYPE index by binary_integer;

17: TYPE tab_country_region_code is TABLE OF WSH_REGIONS.Country_Region_Code%TYPE index by binary_integer;
18: TYPE tab_state_code is TABLE OF WSH_REGIONS.State_Code%TYPE index by binary_integer;
19: TYPE tab_city_code is TABLE OF WSH_REGIONS.City_Code%TYPE index by binary_integer;
20: TYPE tab_port_flag is TABLE OF WSH_REGIONS.Port_Flag%TYPE index by binary_integer;
21: TYPE tab_airport_flag is TABLE OF WSH_REGIONS.Airport_Flag%TYPE index by binary_integer;
22: TYPE tab_road_terminal_flag is TABLE OF WSH_REGIONS.Road_Terminal_Flag%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;

Line 22: TYPE tab_road_terminal_flag is TABLE OF WSH_REGIONS.Road_Terminal_Flag%TYPE index by binary_integer;

18: TYPE tab_state_code is TABLE OF WSH_REGIONS.State_Code%TYPE index by binary_integer;
19: TYPE tab_city_code is TABLE OF WSH_REGIONS.City_Code%TYPE index by binary_integer;
20: TYPE tab_port_flag is TABLE OF WSH_REGIONS.Port_Flag%TYPE index by binary_integer;
21: TYPE tab_airport_flag is TABLE OF WSH_REGIONS.Airport_Flag%TYPE index by binary_integer;
22: TYPE tab_road_terminal_flag is TABLE OF WSH_REGIONS.Road_Terminal_Flag%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;

Line 23: TYPE tab_rail_terminal_flag is TABLE OF WSH_REGIONS.Rail_Terminal_Flag%TYPE index by binary_integer;

19: TYPE tab_city_code is TABLE OF WSH_REGIONS.City_Code%TYPE index by binary_integer;
20: TYPE tab_port_flag is TABLE OF WSH_REGIONS.Port_Flag%TYPE index by binary_integer;
21: TYPE tab_airport_flag is TABLE OF WSH_REGIONS.Airport_Flag%TYPE index by binary_integer;
22: TYPE tab_road_terminal_flag is TABLE OF WSH_REGIONS.Road_Terminal_Flag%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;

Line 24: TYPE tab_longitude is TABLE OF WSH_REGIONS.Longitude%TYPE index by binary_integer;

20: TYPE tab_port_flag is TABLE OF WSH_REGIONS.Port_Flag%TYPE index by binary_integer;
21: TYPE tab_airport_flag is TABLE OF WSH_REGIONS.Airport_Flag%TYPE index by binary_integer;
22: TYPE tab_road_terminal_flag is TABLE OF WSH_REGIONS.Road_Terminal_Flag%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;

Line 25: TYPE tab_latitude is TABLE OF WSH_REGIONS.Latitude%TYPE index by binary_integer;

21: TYPE tab_airport_flag is TABLE OF WSH_REGIONS.Airport_Flag%TYPE index by binary_integer;
22: TYPE tab_road_terminal_flag is TABLE OF WSH_REGIONS.Road_Terminal_Flag%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;

Line 26: TYPE tab_timezone is TABLE OF WSH_REGIONS.Timezone%TYPE index by binary_integer;

22: TYPE tab_road_terminal_flag is TABLE OF WSH_REGIONS.Road_Terminal_Flag%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;

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 91: x_parent_region_info OUT NOCOPY wsh_regions_search_pkg.region_rec,

87: p_lang_code IN VARCHAR2,
88: p_interface_flag IN VARCHAR2,
89: p_user_id IN NUMBER,
90: p_insert_parent_flag IN VARCHAR2,
91: x_parent_region_info OUT NOCOPY wsh_regions_search_pkg.region_rec,
92: p_conc_request_flag IN VARCHAR2 DEFAULT 'N');
93:
94: --
95: -- Procedure: Add_Region

Line 494: -- PURPOSE : Populates the data in Global Temp tables(Wsh_Regions_Global

490:
491: --
492: -- PROCEDURE : Init_Global_Table
493: --
494: -- PURPOSE : Populates the data in Global Temp tables(Wsh_Regions_Global
495: -- and Wsh_Regions_Global_Data) fetched from Wsh_Regions and
496: -- Wsh_Regions_Tl based on parameter p_populate_type.
497: --
498: PROCEDURE Init_global_table (

Line 495: -- and Wsh_Regions_Global_Data) fetched from Wsh_Regions and

491: --
492: -- PROCEDURE : Init_Global_Table
493: --
494: -- PURPOSE : Populates the data in Global Temp tables(Wsh_Regions_Global
495: -- and Wsh_Regions_Global_Data) fetched from Wsh_Regions and
496: -- Wsh_Regions_Tl based on parameter p_populate_type.
497: --
498: PROCEDURE Init_global_table (
499: p_country IN VARCHAR2,

Line 496: -- Wsh_Regions_Tl based on parameter p_populate_type.

492: -- PROCEDURE : Init_Global_Table
493: --
494: -- PURPOSE : Populates the data in Global Temp tables(Wsh_Regions_Global
495: -- and Wsh_Regions_Global_Data) fetched from Wsh_Regions and
496: -- Wsh_Regions_Tl based on parameter p_populate_type.
497: --
498: PROCEDURE Init_global_table (
499: p_country IN VARCHAR2,
500: p_state IN VARCHAR2,

Line 514: -- ( Wsh_Regions_Global_Data and Wsh_Regions_Global tables )

510: --
511: -- PROCEDURE : Insert_Global_Table
512: --
513: -- PURPOSE : Inserts the data in Global Temp tables
514: -- ( Wsh_Regions_Global_Data and Wsh_Regions_Global tables )
515: PROCEDURE Insert_Global_Table (
516: p_country IN VARCHAR2,
517: p_state IN VARCHAR2,
518: p_city IN VARCHAR2,

Line 535: -- ( Wsh_Regions_Global_Data and Wsh_Regions_Global tables )

531: --
532: -- PROCEDURE : Update_Global_Table
533: --
534: -- PURPOSE : Updates the data in Global Temp tables
535: -- ( Wsh_Regions_Global_Data and Wsh_Regions_Global tables )
536: PROCEDURE Update_Global_Table (
537: p_country IN VARCHAR2,
538: p_state IN VARCHAR2,
539: p_city IN VARCHAR2,

Line 550: END WSH_REGIONS_PKG;

546: p_parent_zone_level IN NUMBER,
547: p_lang_code IN VARCHAR2,
548: x_return_status OUT NOCOPY VARCHAR2 );
549:
550: END WSH_REGIONS_PKG;
551: