1 Package MTH_TZ_UTIL AS
2 /*$Header: mthtzuts.pls 120.0.12010000.4 2008/09/09 00:51:58 tkan noship $*/
3
4 /* ****************************************************************************
5 * Function : convert_tz *
6 * Description : This function is used to return date by passed Date,*
7 * Source, and Target time zone name *
8 * File Name : MTHTZUTS.PLS *
9 * Visibility : Public *
10 * Parameters : date, from_tz, to _tz *
11 * Modification log : *
12 * Author Date Change *
13 * Tawen Kan 01-Mar-2008 Initial Creation *
14 **************************************************************************** */
15 Function convert_tz(date_time date
16 ,from_tz varchar2
17 ,to_tz varchar2) return date;
18
19 /* ****************************************************************************
20 * Function : FROM_TZ *
21 * Description : This function is used to return date by passed *
22 * Source time zone name *
23 * File Name : MTHTZUTS.PLS *
24 * Visibility : Public *
25 * Parameters : date, from_tz *
26 * Modification log : *
27 * Author Date Change *
28 * Tawen Kan 01-Mar-2008 Initial Creation *
29 **************************************************************************** */
30 Function from_tz(date_time date
31 ,from_tz varchar2) return date;
32
33 /* ****************************************************************************
34 * Function : TO_TZ *
35 * Description : This function is used to return date by passed *
36 * Target time zone name *
37 * File Name : MTHTZUTS.PLS *
38 * Visibility : Public *
39 * Parameters : date, to_tz *
40 * Modification log : *
41 * Author Date Change *
42 * Tawen Kan 01-Mar-2008 Initial Creation *
43 **************************************************************************** */
44 Function to_tz(date_time date
45 ,to_tz varchar2) return date;
46
47 END MTH_TZ_UTIL;