[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;