1: package wip_ws_util AUTHID CURRENT_USER as
2: /* $Header: wipwsuts.pls 120.15.12020000.4 2012/12/25 00:43:54 hliew ship $ */
3:
4: g_timezone_enabled BOOLEAN := (fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
5: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
6: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
7: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
8: fnd_profile.value('SERVER_TIMEZONE_ID'));
1: package wip_ws_util AUTHID CURRENT_USER as
2: /* $Header: wipwsuts.pls 120.15.12020000.4 2012/12/25 00:43:54 hliew ship $ */
3:
4: g_timezone_enabled BOOLEAN := (fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
5: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
6: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
7: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
8: fnd_profile.value('SERVER_TIMEZONE_ID'));
9:
2: /* $Header: wipwsuts.pls 120.15.12020000.4 2012/12/25 00:43:54 hliew ship $ */
3:
4: g_timezone_enabled BOOLEAN := (fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
5: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
6: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
7: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
8: fnd_profile.value('SERVER_TIMEZONE_ID'));
9:
10: g_client_id NUMBER := fnd_profile.value('CLIENT_TIMEZONE_ID');
3:
4: g_timezone_enabled BOOLEAN := (fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
5: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
6: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
7: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
8: fnd_profile.value('SERVER_TIMEZONE_ID'));
9:
10: g_client_id NUMBER := fnd_profile.value('CLIENT_TIMEZONE_ID');
11: g_server_id NUMBER := fnd_profile.value('SERVER_TIMEZONE_ID');
4: g_timezone_enabled BOOLEAN := (fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
5: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
6: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
7: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
8: fnd_profile.value('SERVER_TIMEZONE_ID'));
9:
10: g_client_id NUMBER := fnd_profile.value('CLIENT_TIMEZONE_ID');
11: g_server_id NUMBER := fnd_profile.value('SERVER_TIMEZONE_ID');
12:
6: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
7: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
8: fnd_profile.value('SERVER_TIMEZONE_ID'));
9:
10: g_client_id NUMBER := fnd_profile.value('CLIENT_TIMEZONE_ID');
11: g_server_id NUMBER := fnd_profile.value('SERVER_TIMEZONE_ID');
12:
13: --start constants for bugfix 6755623
14: g_pref_id_comp_short NUMBER := 33;
7: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
8: fnd_profile.value('SERVER_TIMEZONE_ID'));
9:
10: g_client_id NUMBER := fnd_profile.value('CLIENT_TIMEZONE_ID');
11: g_server_id NUMBER := fnd_profile.value('SERVER_TIMEZONE_ID');
12:
13: --start constants for bugfix 6755623
14: g_pref_id_comp_short NUMBER := 33;
15: g_pref_level_id_site NUMBER := 1;