1 PACKAGE PON_OEX_TIMEZONE_PKG AUTHID CURRENT_USER as
2 /* $Header: PONOEXTS.pls 120.1 2005/06/22 23:46:13 rpatel noship $ */
3
4
5 FUNCTION valid_zone(p_timeZone VARCHAR2) RETURN NUMBER;
6
7 FUNCTION convert_time(p_fromDate DATE,
8 p_fromZone VARCHAR2,
9 p_toZone VARCHAR2) RETURN DATE;
10
11
12 /*=========================================================================+
13 --
14 -- CONVERT_DATE_TO_USER_TZ will convert given set of dates to user timezone.
15 -- This procedure will be used mainly to covnert Negotiation Preview date,
16 -- Negotiation open date, and Negotiation Close Date to user timezone.
17 --
18 -- It will return user timezone based on userId passed. If value for
19 -- user timezone is null procedure will return timezone of the
20 -- Negotiation Creator.
21 --
22 -- This logic will be applicable to the date conversion as well. That is
23 -- it will convert the dates to Negotiation Creator's timezone if
24 -- value of user timezone is null.
25 --
26 -- This API can be used to retrieve formatted date for other dates also.
27 -- In that case user can pass
28 -- Parameters :
29 -- x_person_party_id IN - trading partner contact id of the user
30 -- x_auctioneer_user_name IN - trading partner contact name of
31 -- the Negotiation Creator
32 -- x_date_value1 IN OUT NOCOPY - Negotication Preview Date and
33 -- New Date value in user timezone
34 -- x_date_value2 IN OUT NOCOPY - Negotication Open Date and
35 -- New Date value in user timezone
36 -- x_date_value3 IN OUT NOCOPY - Negotication Close Date and
37 -- New Date value in user timezone
38 -- x_date_value4 IN OUT NOCOPY - Other misc Dates
39 -- New Date value in user timezone
40 -- x_date_value5 IN OUT NOCOPY - Other misc Dates
41 -- New Date value in user timezone
42 -- x_timezone_dsp OUT NOCOPY - Time zone value for display.
43 --
44 +=========================================================================*/
45
46 PROCEDURE CONVERT_DATE_TO_USER_TZ (
47 p_person_party_id IN NUMBER,
48 p_auctioneer_user_name IN VARCHAR2,
49 x_date_value1 IN OUT NOCOPY DATE,
50 x_date_value2 IN OUT NOCOPY DATE,
51 x_date_value3 IN OUT NOCOPY DATE,
52 x_date_value4 IN OUT NOCOPY DATE,
53 x_date_value5 IN OUT NOCOPY DATE,
54 x_timezone_disp OUT NOCOPY VARCHAR2);
55
56 END PON_OEX_TIMEZONE_PKG;
[Home] [Help]