[Home] [Help]
PACKAGE: APPS.QLTDATE
Source
1 PACKAGE QLTDATE as
2 /* $Header: qltdateb.pls 120.0.12000000.1 2007/01/19 07:15:29 appldev ship $ */
3
4 FUNCTION user_mask RETURN Varchar2;
5 PRAGMA restrict_references(user_mask, WNDS, WNPS);
6 -- See Oracle8 Server Application Developer's Guide p. 10-47
7
8 FUNCTION output_mask RETURN Varchar2;
9 PRAGMA restrict_references(output_mask, WNDS, WNPS);
10
11 FUNCTION canon_to_date(canon Varchar2) RETURN Date;
12 PRAGMA restrict_references(canon_to_date, WNDS, WNPS);
13
14 -- canon_to_date is also over-loaded as in the case
15 -- of any_to_date(). Extremely useful to hide the
16 -- details of implementation from caller.
17 -- rkunchal Mon Aug 26 04:34:42 PDT 2002
18
19 FUNCTION canon_to_date(canon Date) RETURN Date;
20 PRAGMA restrict_references(canon_to_date, WNDS, WNPS);
21
22 FUNCTION canon_to_user(canon Varchar2) RETURN Varchar2;
23 PRAGMA restrict_references(canon_to_user, WNDS, WNPS);
24
25 -- canon_to_user is also over-loaded as in the case
26 -- of any_to_user(). Extremely useful to hide the
27 -- details of implementation from caller.
28 -- rkunchal Mon Aug 26 04:34:42 PDT 2002
29
30 FUNCTION canon_to_user(d Date) RETURN Varchar2;
31 PRAGMA restrict_references(canon_to_user, WNDS, WNPS);
32
33 FUNCTION any_to_date(flex Varchar2) RETURN Date;
34 PRAGMA restrict_references(any_to_date, WNDS, WNPS);
35
36 FUNCTION any_to_date(flex Date) RETURN Date;
37 PRAGMA restrict_references(any_to_date, WNDS, WNPS);
38
39 FUNCTION any_to_canon(flex Varchar2) RETURN Varchar2;
40 PRAGMA restrict_references(any_to_canon, WNDS, WNPS);
41
42 FUNCTION any_to_user(flex Varchar2) RETURN Varchar2;
43 PRAGMA restrict_references(any_to_user, WNDS, WNPS);
44
45 -- See bug #2503882
46 -- Overloaded to treat hard-coded and soft-coded
47 -- collection elements differently.
48 -- Hard-coded elements donot need to be to_date()-ed.
49 -- rkunchal Thu Aug 22 09:57:16 PDT 2002
50
51 FUNCTION any_to_user(d Date) RETURN Varchar2;
52 PRAGMA restrict_references(any_to_user, WNDS, WNPS);
53
54 FUNCTION date_to_user(d Date) RETURN Varchar2;
55 PRAGMA restrict_references(date_to_user, WNDS, WNPS);
56
57 FUNCTION date_to_canon(d Date) RETURN Varchar2;
58 PRAGMA restrict_references(date_to_canon, WNDS, WNPS);
59
60 FUNCTION canon_to_number(canon Varchar2) RETURN Number;
61 PRAGMA restrict_references(canon_to_number, WNDS, WNPS);
62
63 FUNCTION canon_to_number(canon Number) RETURN Number;
64 PRAGMA restrict_references(canon_to_number, WNDS, WNPS);
65
66 FUNCTION any_to_number(n Number) RETURN Number;
67 PRAGMA restrict_references(any_to_number, WNDS, WNPS);
68
69 FUNCTION any_to_number(n Varchar2) RETURN Number;
70 PRAGMA restrict_references(any_to_number, WNDS, WNPS);
71
72 FUNCTION number_to_canon(n Number) RETURN Varchar2;
73 PRAGMA restrict_references(number_to_canon, WNDS, WNPS);
74
75 FUNCTION number_canon_to_user(canon Varchar2) RETURN Varchar2;
76 PRAGMA restrict_references(number_canon_to_user, WNDS, WNPS);
77
78 FUNCTION number_user_to_canon(n Varchar2) RETURN Varchar2;
79 PRAGMA restrict_references(number_user_to_canon, WNDS, WNPS);
80
81 FUNCTION get_sysdate RETURN date;
82 PRAGMA restrict_references(get_sysdate, WNDS, WNPS);
83
84 FUNCTION upgrade_to_canon(flex Varchar2) RETURN Varchar2;
85 PRAGMA restrict_references(upgrade_to_canon, WNDS, WNPS);
86
87 -- Bug 3179845. Timezone Project. rponnusa Fri Oct 17 10:34:50 PDT 2003
88 -- Following new function are added
89 --
90 FUNCTION date_to_canon_dt(d Date) RETURN Varchar2;
91 PRAGMA restrict_references(date_to_canon_dt, WNDS, WNPS);
92
93 FUNCTION any_to_datetime(flex Date) RETURN Date;
94 PRAGMA restrict_references(any_to_datetime, WNDS, WNPS);
95
96 FUNCTION any_to_datetime(flex Varchar2) RETURN Date;
97 PRAGMA restrict_references(any_to_datetime, WNDS, WNPS);
98
99 FUNCTION output_DT_mask RETURN Varchar2;
100 PRAGMA restrict_references(output_DT_mask, WNDS, WNPS);
101
102 FUNCTION date_to_user_dt(d Date) RETURN Varchar2;
103 PRAGMA restrict_references(date_to_user_dt, WNDS, WNPS);
104
105 FUNCTION any_to_user_dt(flex Varchar2) RETURN Varchar2;
106 PRAGMA restrict_references(any_to_user_dt, WNDS, WNPS);
107
108 END QLTDATE;
109