PACKAGE: APPS.QLTDATE

Source

1 PACKAGE QLTDATE AUTHID CURRENT_USER as
2 /* $Header: qltdateb.pls 120.0.12020000.3 2013/01/04 15:02:52 hmakam 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     --
109     -- Bug 16029748
110     -- Function to convert the Varchar qty to number based on the user format mask
111     --
112     FUNCTION user_to_number (p_char_val IN VARCHAR2) RETURN NUMBER;
113 
114 END QLTDATE;
115