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 AUTHID CURRENT_USER AS

1: PACKAGE WSH_REGIONS_PKG AUTHID CURRENT_USER AS
2: /* $Header: WSHRETHS.pls 120.2 2010/11/08 23:45:21 rvarghes ship $ */
3:
4: --
5: -- Package

Line 6: -- WSH_REGIONS_PKG

2: /* $Header: WSHRETHS.pls 120.2 2010/11/08 23:45:21 rvarghes ship $ */
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 500: -- PURPOSE : Populates the data in Global Temp tables(Wsh_Regions_Global

496:
497: --
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 (

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

497: --
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,

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,

Line 520: -- ( Wsh_Regions_Global_Data and Wsh_Regions_Global tables )

516: --
517: -- PROCEDURE : Insert_Global_Table
518: --
519: -- PURPOSE : Inserts the data in Global Temp tables
520: -- ( Wsh_Regions_Global_Data and Wsh_Regions_Global tables )
521: PROCEDURE Insert_Global_Table (
522: p_country IN VARCHAR2,
523: p_state IN VARCHAR2,
524: p_city IN VARCHAR2,

Line 541: -- ( Wsh_Regions_Global_Data and Wsh_Regions_Global tables )

537: --
538: -- PROCEDURE : Update_Global_Table
539: --
540: -- PURPOSE : Updates the data in Global Temp tables
541: -- ( Wsh_Regions_Global_Data and Wsh_Regions_Global tables )
542: PROCEDURE Update_Global_Table (
543: p_country IN VARCHAR2,
544: p_state IN VARCHAR2,
545: p_city IN VARCHAR2,

Line 556: END WSH_REGIONS_PKG;

552: p_parent_zone_level IN NUMBER,
553: p_lang_code IN VARCHAR2,
554: x_return_status OUT NOCOPY VARCHAR2 );
555:
556: END WSH_REGIONS_PKG;
557: