1 PACKAGE CN_UPGRADE_UTL_PKG as
2 /* $Header: cnuputls.pls 120.1 2006/02/17 04:26:35 rramakri noship $ */
3
4 FUNCTION get_start_date(p_period_id NUMBER,
5 p_org_id NUMBER) RETURN DATE ;
6
7 PRAGMA RESTRICT_REFERENCES (get_start_date,WNDS,WNPS);
8
9 FUNCTION get_end_date(p_period_id NUMBER,
10 p_org_id NUMBER) RETURN DATE;
11
12 PRAGMA RESTRICT_REFERENCES (get_end_date,WNDS,WNPS);
13
14
15 --| ---------------------------------------------------------------------+
16 --| Function Name : is_release_11510
17 --| Desc : Check if current release is 11.5.10
18 --| Return 1 if current release is 11.5.10
19 --| Return 0 if current release is 10.7, 3i or 11.0, 11.5
20 --| Return -1 : not valid release
21 --| ---------------------------------------------------------------------+
22
23 FUNCTION is_release_11510 RETURN NUMBER;
24
25 --| ---------------------------------------------------------------------+
26 --| Function Name : is_release_115
27 --| Desc : Check if current release is 11.5
28 --| Return 1 if current release is 11.5
29 --| Return 0 if current release is 10.7, 3i or 11.0
30 --| Return -1 : not valid release
31 --| ---------------------------------------------------------------------+
32
33 FUNCTION is_release_115 RETURN NUMBER;
34
35 --| ---------------------------------------------------------------------+
36 --| Function Name : is_release_107
37 --| Desc : Check if current release is 10.7
38 --| Return 1 if current release is 10.7
39 --| Return 0 if current release is 11.5,3i or 11.0
40 --| Return -1 : not valid release
41 --| ---------------------------------------------------------------------+
42
43
44 FUNCTION is_release_120 RETURN NUMBER;
45
46 --| ---------------------------------------------------------------------+
47 --| Function Name : is_release_120
48 --| Desc : Check if current release is 120
49 --| Return 1 if current release is 120
50 --| Return -1 : not valid release
51 --| ---------------
52
53 FUNCTION is_release_107 RETURN NUMBER ;
54
55 --| ---------------------------------------------------------------------+
56 --| Function Name : is_release_110
57 --| Desc : Check if current release is 11.0
58 --| Return 1 if current release is 11.0
59 --| Return 0 if current release is 10.7,3i or 11.0 or 11.5
60 --| Return -1 : not valid release
61 --| ---------------------------------------------------------------------+
62
63 FUNCTION is_release_110 RETURN NUMBER ;
64
65 --| ---------------------------------------------------------------------+
66 --| Function Name : is_release_3i
67 --| Desc : Check if current release is 3i
68 --| Return 1 if current release is 3i
69 --| Return 0 if current release is 10.7,11.0 or 11.5
70 --| Return -1 : not valid release
71 --| ---------------------------------------------------------------------+
72
73 FUNCTION is_release_3i RETURN NUMBER ;
74
75 END cn_upgrade_utl_pkg;