1 PACKAGE ICX_CAT_R12_UPGRADE_PVT AUTHID CURRENT_USER AS
2 /* $Header: ICXV12US.pls 120.3 2006/06/21 19:12:28 sbgeorge noship $*/
3
4 -- Start of comments
5 -- API name : getPOAttrValuesTLPAction
6 -- * Type : Private
7 -- * Pre-reqs : None.
8 -- * Function : Checks if the line exists in PO_ATTRIBUTE_VALUES_TLP
9 -- for the given po_line_id, req_template_name, req_template_line_num,
10 -- org_id and language.
11 -- Depending upon the existance of the line the function
12 -- will return ADD/UPDATE
13 -- * Parameters :
14 -- IN : p_po_line_id IN NUMBER
15 -- Required
16 -- Corresponds to the po_line_id of the line.
17 -- p_req_template_name IN VARCHAR2
18 -- Required
19 -- Corresponds to the req_template_name of the line.
20 -- p_req_template_line_num IN NUMBER
21 -- Required
22 -- Corresponds to the req_template_line_num of the line.
23 -- p_org_id IN NUMBER
24 -- Required
25 -- Corresponds to the org_id of the line.
26 -- p_language IN VARCHAR2
27 -- Required
28 -- Corresponds to the language of the line.
29 -- OUT : l_action OUT NOCOPY VARCHAR2
30 -- Corresponds to the ACTION in PO_ATTR_VALUES_TLP_INTERFACE
31 -- * Version : Current version 1.0
32 -- Previous version 1.0
33 -- Initial version 1.0
34 --
35 -- Notes : None.
36 --
37 -- End of comments
38 FUNCTION getPOAttrValuesTLPAction
39 ( p_po_line_id IN NUMBER ,
40 p_req_template_name IN VARCHAR2 ,
41 p_req_template_line_num IN NUMBER ,
42 p_org_id IN NUMBER ,
43 p_language IN VARCHAR2
44 )
45 RETURN VARCHAR2;
46
47 -- Start of comments
48 -- API name : updatePOHeaderId
49 -- * Type : Private
50 -- * Pre-reqs : None.
51 -- * Function : Takes care of populating the header id in
52 -- icx_cat_r12_upgrade. This procedure is
53 -- called by purchasing when a po_header_id is stamped
54 -- in PO_HEADERS_INTERFACE
55 -- * Parameters :
56 -- IN : p_interface_header_id IN DBMS_SQL.NUMBER_TABLE
57 -- Required
58 -- Corresponds to the column INTERFACE_HEADER_ID in
59 -- the table PO_HEADERS_INTERFACE, and identifies the
60 -- interface_header_ids which has been updated with
61 -- a po_header_id.
62 -- OUT : None
63 -- * Version : Current version 1.0
64 -- Previous version 1.0
65 -- Initial version 1.0
66 --
67 -- Notes : None.
68 --
69 -- End of comments
70 PROCEDURE updatePOHeaderId
71 ( p_interface_header_id IN DBMS_SQL.NUMBER_TABLE
72 );
73
74 -- Start of comments
75 -- API name : updatePOLineId
76 -- * Type : Private
77 -- * Pre-reqs : None.
78 -- * Function : Takes care of populating the line id in
79 -- icx_cat_r12_upgrade. This procedure is
80 -- called by purchasing when a po_line_id is stamped
81 -- in PO_LINES_INTERFACE
82 -- * Parameters :
83 -- IN : p_interface_line_id IN DBMS_SQL.NUMBER_TABLE
84 -- Required
85 -- Corresponds to the column INTERFACE_LINE_ID in
86 -- the table PO_LINES_INTERFACE, and identifies the
87 -- interface_line_ids which has been updated with
88 -- a po_line_id.
89 -- OUT : None
90 -- * Version : Current version 1.0
91 -- Previous version 1.0
92 -- Initial version 1.0
93 --
94 -- Notes : None.
95 --
96 -- End of comments
97 PROCEDURE updatePOLineId
98 ( p_interface_line_id IN DBMS_SQL.NUMBER_TABLE
99 );
100
101 -- Start of comments
102 -- API name : upgradeDefaultSortProfiles
103 -- * Type : Private
104 -- * Pre-reqs : None.
105 -- * Function : The api upgrades the default sort profiles:
106 -- 1. POR_DEFAULT_SHOPPING_SORT
107 -- 2. POR_DEFAULT_SHOPPING_SORT_ORDER
108 -- * Parameters :
109 -- IN : None
110 -- OUT : None
111 -- * Version : Current version 1.0
112 -- Previous version 1.0
113 -- Initial version 1.0
114 --
115 -- Notes : None.
116 --
117 -- End of comments
118 PROCEDURE upgradeDefaultSortProfiles;
119
120 -- Start of comments
121 -- API name : runR12Upgrade
122 -- * Type : Private
123 -- * Pre-reqs : None.
124 -- * Function : The r12 Upgrade api is run on a R12 instance
125 -- The api will upgrade the ip data to R12 data model
126 -- In addition it will also upgrade the favorite list lines
127 -- and make all the GBPAs created during pre-upgrade/upgrade
128 -- approved.
129 -- * Parameters :
130 -- IN : None
131 -- OUT : x_errbuf OUT NOCOPY VARCHAR2
132 -- x_retcode OUT NOCOPY NUMBER
133 -- * Version : Current version 1.0
134 -- Previous version 1.0
135 -- Initial version 1.0
136 --
137 -- Notes : None.
138 --
139 -- End of comments
140 PROCEDURE runR12Upgrade
141 ( x_errbuf OUT NOCOPY VARCHAR2 ,
142 x_retcode OUT NOCOPY NUMBER
143 );
144
145 -- Start of comments
146 -- API name : runDataExcptnRptChildProcess
147 -- * Type : Private
148 -- * Pre-reqs : None.
149 -- * Function : Data Exceptions report tells the user the ip data that
150 -- was not upgraded to R12 due to errors. Also user can
151 -- find out the reasons the data was not upgraded, and the user
152 -- can download the file for the errored data. If the user
153 -- chooses, he can correct the data and reload.
154 -- When preUpgrade is run on a 11.5.9/11.5.10 instance
155 -- The api runDataExcptnRptChildProcess is run as a child process
156 -- so that this can be run parallel to other process
157 -- * Parameters :
158 -- IN : p_parent_int_req_id IN NUMBER
159 -- Required
160 -- Corresponds to the column INTERNAL_REQUEST_ID,
161 -- and identifies the rows that have been
162 -- created/updated in a particular run.
163 -- p_batch_size IN NUMBER
164 -- Required
165 -- Corresponds to the batch_size used for DMLs.
166 -- p_commit IN VARCHAR2
167 -- Required
168 -- Deciding factor whether to commit in the API
169 -- p_pdoi_batch_id IN NUMBER
170 -- Required
171 -- Corresponds to the column BATCH_ID in
172 -- PO_HEADERS_INTERFACE, the data exceptions report
173 -- is run for the data available in the batch
174 -- OUT : x_errbuf OUT NOCOPY VARCHAR2
175 -- x_retcode OUT NOCOPY NUMBER
176 -- * Version : Current version 1.0
177 -- Previous version 1.0
178 -- Initial version 1.0
179 --
180 -- Notes : None.
181 --
182 -- End of comments
183 PROCEDURE runDataExcptnRptChildProcess
184 ( x_errbuf OUT NOCOPY VARCHAR2 ,
185 x_retcode OUT NOCOPY NUMBER ,
186 p_parent_int_req_id IN NUMBER ,
187 p_batch_size IN NUMBER ,
188 p_commit IN VARCHAR2 ,
189 p_pdoi_batch_id IN NUMBER
190 );
191
192 -- Start of comments
193 -- API name : createR12UpgradeJob
194 -- * Type : Private
195 -- * Pre-reqs : None.
196 -- * Function : The api creates the current job row with all the
197 -- details in icx_cat_r12_upgrade_jobs
198 -- * Parameters :
199 -- IN : p_audsid IN NUMBER
200 -- Required
201 -- Corresponds to the USERENV('SESSIONID')
202 -- p_pdoi_batch_id IN NUMBER
203 -- Optional
204 -- Corresponds to the column BATCH_ID in
205 -- PO_HEADERS_INTERFACE for the current job
206 -- OUT : None
207 -- * Version : Current version 1.0
208 -- Previous version 1.0
209 -- Initial version 1.0
210 --
211 -- Notes : None.
212 --
213 -- End of comments
214 PROCEDURE createR12UpgradeJob
215 ( p_audsid IN NUMBER ,
216 p_pdoi_batch_id IN NUMBER DEFAULT NULL
217 );
218
219 -- Start of comments
220 -- API name : updateR12UpgradeJob
221 -- * Type : Private
222 -- * Pre-reqs : None.
223 -- * Function : The api updates the current job status
224 -- in icx_cat_r12_upgrade_jobs.
225 -- * Parameters :
226 -- IN : p_job_status IN VARCHAR2
227 -- Required
228 -- Corresponds to the column JOB_STATUS in
229 -- ICX_CAT_R12_UPGRADE_JOBS for the current job
230 -- p_audsid2 IN NUMBER
231 -- Optional
232 -- Corresponds to the USERENV('SESSIONID')
233 --
234 -- OUT : None
235 -- * Version : Current version 1.0
236 -- Previous version 1.0
237 -- Initial version 1.0
238 --
239 -- Notes : None.
240 --
241 -- End of comments
242 PROCEDURE updateR12UpgradeJob
243 ( p_job_status IN VARCHAR2 ,
244 p_audsid2 IN NUMBER DEFAULT NULL
245 );
246
247 -- Start of comments
248 -- API name : callICXFinalSteps
249 -- * Type : Private
250 -- * Pre-reqs : None.
251 -- * Function : This API is called during upgrade.
252 -- It calls the final purge to remove the invalid blanket lines
253 -- that might have been not approved during po final upgrade
254 -- * Parameters :
255 -- IN : None
256 -- OUT : None
257 -- * Version : Current version 1.0
258 -- Previous version 1.0
259 -- Initial version 1.0
260 --
261 -- Notes : None.
262 --
263 -- End of comments
264 PROCEDURE callICXFinalSteps;
265
266 END ICX_CAT_R12_UPGRADE_PVT;