PACKAGE: APPS.FLM_TIMEZONE

Source

1 PACKAGE flm_timezone AUTHID CURRENT_USER AS
2 /* $Header: FLMTMZOS.pls 115.3 2004/08/18 23:17:21 hwenas noship $*/
3 /*==========================================================================+
4 |   Copyright (c) 1997 Oracle Corporation Redwood Shores, California, USA   |
5 |                          All rights reserved.                             |
6 +===========================================================================+
7 |                                                                           |
8 | FILE NAME    : FLMTMZOS.pls                                               |
9 | DESCRIPTION  : This package contains functions used to provide timezone   |
10 |                support                                                    |
11 | MODIFICATION HISTORY:                                                     |
12 |   Hadi Wenas         10/14/03          Created                            |
13 +===========================================================================*/
14 
15 g_enabled   BOOLEAN := (fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
16 												fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
17 												fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
18                         fnd_profile.value('CLIENT_TIMEZONE_ID') <>
19                         fnd_profile.value('SERVER_TIMEZONE_ID'));
20 
21 g_client_id NUMBER  := fnd_profile.value('CLIENT_TIMEZONE_ID');
22 g_server_id NUMBER  := fnd_profile.value('SERVER_TIMEZONE_ID');
23 g_init BOOLEAN := FALSE;
24 
25 --fix bug#3827600: new global variables
26 g_client_start_time NUMBER	:= 0;
27 g_server_start_time NUMBER	:= 0;
28 g_org_id NUMBER 		:= 0;
29 
30 PROCEDURE init_timezone(p_org_id NUMBER);
31 FUNCTION is_init RETURN BOOLEAN;
32 
33 FUNCTION server_to_calendar(p_server_date IN DATE) RETURN DATE;
34 FUNCTION client_to_calendar(p_client_date IN DATE) RETURN DATE; --fix bug#3840945
35 
36 --fix bug#3827600
37 --Modified signature
38 FUNCTION calendar_to_server(p_calendar_date IN DATE,
39                             p_server_time IN NUMBER DEFAULT NULL) RETURN DATE;
40 --end of fix bug#3827600
41 
42 FUNCTION server_to_client(p_server_date IN DATE) RETURN DATE;
43 FUNCTION client_to_server(p_client_date IN DATE) RETURN DATE;
44 FUNCTION client00_in_server(p_server_date IN DATE) RETURN DATE;
45 FUNCTION sysdate00_in_server RETURN DATE;
46 
47 /*fix bug#3827600
48   Removed the following procedures:
49   - get_offset()
50   - calendar_to_client()
51   - client_to_calendar()
52 
53   end of fix bug#3827600
54 */
55 
56 END flm_timezone;