PACKAGE: APPS.HZ_TIMEZONE_UTILS_PVT

Source

1 PACKAGE HZ_TIMEZONE_UTILS_PVT AUTHID CURRENT_USER AS
2 /*$Header: ARHTZUTS.pls 115.1 2003/09/10 19:22:26 awu noship $ */
3 
4 procedure duplicate_country_code(p_territory_code in varchar2,
5  x_return_status out nocopy varchar2);
6 
7 procedure duplicate_area_code(p_territory_code in varchar2, p_area_code in varchar2,
8 		x_return_status out nocopy varchar2);
9 
10 PROCEDURE create_area_code(
11   p_territory_code        IN VARCHAR2,
12   p_phone_country_code    IN VARCHAR2,
13   p_area_code             IN VARCHAR2,
14   p_description           IN VARCHAR2,
15   p_timezone_id           IN NUMBER,
16   x_return_status         OUT NOCOPY VARCHAR2,
17   x_msg_count             OUT NOCOPY NUMBER,
18   x_msg_data              OUT NOCOPY VARCHAR2);
19 
20 PROCEDURE update_area_code(
21   p_territory_code        IN VARCHAR2,
22   p_area_code             IN VARCHAR2,
23   p_old_area_code             IN VARCHAR2,
24   p_description           IN VARCHAR2,
25   p_timezone_id           IN NUMBER,
26   p_object_version_number IN OUT NOCOPY NUMBER,
27   x_return_status         OUT NOCOPY VARCHAR2,
28   x_msg_count             OUT NOCOPY NUMBER,
29   x_msg_data              OUT NOCOPY VARCHAR2);
30 
31 PROCEDURE update_country_timezone(
32   p_territory_code        IN VARCHAR2,
33   p_timezone_id           IN NUMBER,
34   p_object_version_number IN OUT NOCOPY NUMBER,
35   x_return_status         OUT NOCOPY VARCHAR2,
36   x_msg_count             OUT NOCOPY NUMBER,
37   x_msg_data              OUT NOCOPY VARCHAR2);
38 
39 function areacode_timezone_exist(p_territory_code in varchar2) return varchar2;
40 
41 
42 END HZ_TIMEZONE_UTILS_PVT;