DBA Data[Home] [Help]

PACKAGE BODY: APPS.OKX_GATEWAY

Source


1 PACKAGE BODY   OKX_GATEWAY    AS
2 /* $Header: OKXSWRPB.pls 120.1 2005/10/03 15:06:43 jvarghes noship $ */
3 
4   PROCEDURE OKX_TIMEZONE_GETTIME (
5     p_api_version          IN   NUMBER,
6     p_init_msg_list        IN   VARCHAR2 DEFAULT OKC_API.G_FALSE,
7     p_source_tz_id         IN   NUMBER,
8     p_dest_ts_id           IN   NUMBER,
9     p_source_day_time      IN   DATE,
10     x_dest_day_time        OUT  NOCOPY DATE,
11     x_return_status        OUT  NOCOPY VARCHAR2,
12     x_msg_count            OUT  NOCOPY NUMBER,
13     x_msg_data             OUT  NOCOPY VARCHAR2) is
14 /*
15 REM Get destination day time, given the source day time,
16 REM source timezone_id and destination timezone_id
17 
18   l_api_name               CONSTANT VARCHAR2(30):= 'OKX_TIMEZONE_GETTIME';
19   l_api_version            CONSTANT NUMBER      := 1.0;
20   l_row_count              NUMBER;
21   l_return_status          VARCHAR2(1)          := OKC_API.G_RET_STS_SUCCESS;
22 */
23   BEGIN
24 
25   HZ_TIMEZONE_PUB.GET_TIME (
26    p_api_version,
27    p_init_msg_list,
28    p_source_tz_id,
29    p_dest_ts_id,
30    p_source_day_time,
31    x_dest_day_time,
32    x_return_status,
33    x_msg_count,
34    x_msg_data );
35 
36   /* EXCEPTION
37      when others then
38          x_return_status := OKC_API.HANDLE_EXCEPTIONS(
39                               l_api_name
40                              ,G_PKG_NAME
41                              ,'OTHERS'
42                              ,x_msg_count
43                              ,x_msg_data
44                              ,'_PVT'
45          );
46 */
47   END OKX_TIMEZONE_GETTIME;
48 
49 END okx_gateway;