1 PACKAGE CN_UPGRADE_UTL_PKG AUTHID CURRENT_USER as
2 /* $Header: cnuputls.pls 120.5 2010/09/30 23:07:49 rnagaraj ship $ */
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 --| ---------------------------------------------------------------------+
76 --| Function Name : is_release_121
77 --| Desc : Check if current release is 121
78 --| Return 1 if current release is 121
79 --| Return -1 : not valid release
80 --| ---------------------------------------------------------------------+
81
82 FUNCTION is_release_121 RETURN NUMBER;
83
84
85
86 --| ---------------------------------------------------------------------+
87 --| Procedure Name : CNCMAUPD_R1212
88 --| Desc : To improve the performance of Credit Allocation CP,
89 --| NVL(cn_comm_lines_api_all.adjust_status,NEW) and
90 --| NVL(cn_comm_lines_api_all.preserve_credit_override_flag,N)
91 --| need to be performed and this is done via the concurrent
92 --| program CN_R1212_CNCMAUPD - reference to bugs.,
93 --| 9725647 and 9737110.
94 --| ---------------------------------------------------------------------+
95 PROCEDURE CNCMAUPD_R1212 (
96 x_errbuf OUT NOCOPY VARCHAR2,
97 x_retcode OUT NOCOPY VARCHAR2,
98 p_batch_size IN NUMBER,
99 p_num_workers IN NUMBER,
100 p_worker_id IN NUMBER);
101
102
103
104 --| ---------------------------------------------------------------------+
105 --| Procedure Name : CNCMHUPD_R1212
106 --| Desc : To improve the performance of Credit Allocation CP,
107 --| NVL(cn_commission_headers_all.adjust_status,NEW) need
108 --| to be performed and this is done via the concurrent
109 --| program CN_R1212_CNCMHUPD - reference to bugs.,
110 --| 9725883 and 9737110.
111 --| ---------------------------------------------------------------------+
112 PROCEDURE CNCMHUPD_R1212 (
113 x_errbuf OUT NOCOPY VARCHAR2,
114 x_retcode OUT NOCOPY VARCHAR2,
115 p_batch_size IN NUMBER,
116 p_num_workers IN NUMBER,
117 p_worker_id IN NUMBER);
118
119
120
121 --| ---------------------------------------------------------------------+
122 --| Procedure Name : CNSRPTXN_R1212
123 --| Desc : To minimize the downtime during an upgrade, the script
124 --| will be calling a concurrent program, which runs
125 --| after the application system is up and running.
126 --| Concurrent program CN_R1212_CNSRPTXN -
127 --| reference to bug 10149831.
128 --| ---------------------------------------------------------------------+
129 PROCEDURE CNSRPTXN_R1212 (
130 x_errbuf OUT NOCOPY VARCHAR2,
131 x_retcode OUT NOCOPY VARCHAR2,
132 p_batch_size IN NUMBER,
133 p_num_workers IN NUMBER,
134 p_worker_id IN NUMBER);
135
136
137 END cn_upgrade_utl_pkg;