PACKAGE: APPS.FND_DATE

Source

1 PACKAGE FND_DATE AUTHID CURRENT_USER as
2 /* $Header: AFDDATES.pls 115.11 2003/10/28 16:04:13 psloan ship $ */
3 
4 
5   canonical_mask    varchar2(15) := 'YYYY/MM/DD';
6   canonical_DT_mask varchar2(26) := 'YYYY/MM/DD HH24:MI:SS';
7   name_in_mask      varchar2(15) := 'DD-MON-YYYY';
8   name_in_DT_mask   varchar2(26) := 'DD-MON-YYYY HH24:MI:SS';
9   nls_mask       varchar2(20);
10   nls_DT_mask    varchar2(40);
11 -- It's possible to specify multiple masks seperated
12 -- by a '|' so the user masks need to be longer.
13 
14   user_mask  varchar2(100);
15   userDT_mask  varchar2(200);
16   output_mask  varchar2(20);
17   outputDT_mask  varchar2(40);
18 
19 -- Initialization routine
20 
21   procedure initialize(
22   p_user_mask varchar2,
23   p_userDT_mask varchar2 default NULL);
24 
25 -- Date/DisplayDate functions - covers on the now obsolete Date/CharDate
26 -- functions.  These functions are used to convert a date to and from
27 -- the display format.
28 
29   function displaydate_to_date(
30     chardate varchar2)
31   return date;
32   PRAGMA restrict_references(displaydate_to_date, WNDS, WNPS, RNDS);
33 
34   function displayDT_to_date(
35     charDT varchar2)
36   return date;
37   PRAGMA restrict_references(displayDT_to_date, WNDS, WNPS, RNDS);
38 
39   function date_to_displaydate(
40     dateval date)
41   return varchar2;
42   PRAGMA restrict_references(date_to_displaydate, WNDS, WNPS, RNDS);
43 
44   function date_to_displayDT(
45     dateval date)
46   return varchar2;
47   PRAGMA restrict_references(date_to_displayDT, WNDS, WNPS, RNDS);
48 
49 -- Date/CharDate functions
50 
51   function chardate_to_date(
52     chardate varchar2)
53   return date;
54   PRAGMA restrict_references(chardate_to_date, WNDS, WNPS, RNDS);
55 
56   function charDT_to_date(
57     charDT varchar2)
58   return date;
59   PRAGMA restrict_references(charDT_to_date, WNDS, WNPS, RNDS);
60 
61   function date_to_chardate(
62     dateval date)
63   return varchar2;
64   PRAGMA restrict_references(date_to_chardate, WNDS, WNPS, RNDS);
65 
66   function date_to_charDT(
67     dateval date)
68   return varchar2;
69   PRAGMA restrict_references(date_to_charDT, WNDS, WNPS, RNDS);
70 
71 -- Canonical functions
72 
73   function canonical_to_date(
74     canonical varchar2)
75   return date;
76   PRAGMA restrict_references(canonical_to_date, WNDS, WNPS, RNDS);
77 
78   function date_to_canonical(
79     dateval date)
80   return varchar2;
81   PRAGMA restrict_references(date_to_canonical, WNDS, WNPS, RNDS);
82 
83   --
84   -- This function converts the given string to date
85   -- by using the given date mask, and trying
86   -- several language settings.
87   -- Language is important if the mask has 'MON' or
88   -- similar language dependent fragments.
89   --
90   FUNCTION string_to_date(p_string IN VARCHAR2,
91         p_mask   IN VARCHAR2)
92     RETURN DATE;
93   PRAGMA restrict_references(string_to_date, WNDS, WNPS, RNPS);
94 
95   --
96   -- This function is similar to string_to_date
97   -- but it returns the result in canonical_DT_mask format.
98   --
99   FUNCTION string_to_canonical(p_string IN VARCHAR2,
100              p_mask   IN VARCHAR2)
101     RETURN VARCHAR2;
102   PRAGMA restrict_references(string_to_canonical, WNDS, WNPS);
103 
104 
105 -- Test procedure - used to verify functionality
106   procedure test;
107 
108  -- TZ*
109  -- private TZ variables
110  -- DO NOT user outside of fnd_date.
111 
112   server_timezone_code varchar2(50);
113   client_timezone_code varchar2(50);
114 
115   timezones_enabled boolean;
116 
117   -- over loaded function for fake dates.
118   -- pass in a new client timezone and over ride the default client timezone
119   function displayDT_to_date(charDT varchar2,new_client_tz_code varchar2) return date;
120   PRAGMA restrict_references(displayDT_to_date, WNDS, WNPS, RNDS);
121 
122   -- over loaded function for fake dates.
123   -- pass in a new client timezone and over ride the default client timezone
124   function date_to_displayDT(dateval date,new_client_tz_code varchar2) return varchar2;
125   PRAGMA restrict_references(date_to_displayDT, WNDS, WNPS, RNDS);
126 
127   -- public version of call for adjust_datetime.
128   function adjust_datetime(date_time date
129                           ,from_tz varchar2
130                           ,to_tz   varchar2) return date;
131   PRAGMA restrict_references(adjust_datetime, WNDS, WNPS, RNDS);
132   -- *TZ
133 
134 end FND_DATE;