1 PACKAGE PA_EGO_WRAPPER_PUB AS
2 /* $Header: PAEGOWPS.pls 120.1 2005/08/19 16:21:56 mwasowic noship $ */
3
4
5 -- Start of comments
6 -- API name : check_delete_phase_ok
7 -- Type : Public
8 -- Pre-reqs : None.
9 -- Purpose : Calls EGO_LIFECYCLE_ADMIN_PUB.check_delete_phase_ok
10 -- Parameters :
11 -- p_api_version IN NUMBER Optional Default 1.0
12 -- p_phase_id IN NUMBER Required
13 -- P_init_msg_list IN VARCHAR2 Optional Default NULL
14 -- x_delete_ok OUT VARCHAR2
15 -- x_errorcode OUT NUMBER
16 -- X_return_status OUT VARCHAR2
17 -- X_msg_count OUT NUMBER
18 -- X_msg_data OUT VARCHAR2
19 -- History :
20 -- 8-NOV-02 mrajput Created.
21 -- End of comments
22
23 PROCEDURE check_delete_phase_ok(
24 p_api_version IN NUMBER :=1.0 ,
25 p_phase_id IN NUMBER ,
26 p_init_msg_list IN VARCHAR2 DEFAULT NULL ,
27 x_delete_ok OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
28 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
29 x_errorcode OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
30 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
31 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
32
33
34
35 -- Start of comments
36 -- API name : process_phase_delete
37 -- Type : Public
38 -- Pre-reqs : None.
39 -- Purpose : Calls EGO_LIFECYCLE_ADMIN_PUB.process_phase_delete
40 -- Parameters :
41 -- p_api_version IN NUMBER Optional Default 1.0
42 -- p_phase_id IN NUMBER Required
43 -- P_init_msg_list IN VARCHAR2 Optional Default NULL
44 -- P_commit IN VARCHAR2 Optional Default NULL
45 -- x_errorcode OUT NUMBER
46 -- X_return_status OUT VARCHAR2
47 -- X_msg_count OUT NUMBER
48 -- X_msg_data OUT VARCHAR2
49 -- History :
50 -- 8-NOV-02 mrajput Created.
51 -- End of comments
52
53 PROCEDURE process_phase_delete(
54 p_api_version IN NUMBER :=1.0 ,
55 p_phase_id IN NUMBER ,
56 p_init_msg_list IN VARCHAR2 DEFAULT NULL ,
57 p_commit IN VARCHAR2 DEFAULT NULL ,
58 x_errorcode OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
59 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
60 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
61 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
62
63 -- Start of comments
64 -- API name : check_delete_lifecycle_ok
65 -- Type : Public
66 -- Pre-reqs : None.
67 -- Purpose : Calls EGO_LIFECYCLE_ADMIN_PUB.check_delete_lifecycle_ok
68 -- Parameters :
69 -- p_api_version IN NUMBER Optional Default 1.0
70 -- p_lifecycle_id IN NUMBER Required
71 -- P_init_msg_list IN VARCHAR2 Optional Default NULL
72 -- x_delete_ok OUT VARCHAR2
73 -- x_errorcode OUT NUMBER
74 -- X_return_status OUT VARCHAR2
75 -- X_msg_count OUT NUMBER
76 -- X_msg_data OUT VARCHAR2
77 -- History :
78 -- 8-NOV-02 mrajput Created.
79 -- End of comments
80 PROCEDURE check_delete_lifecycle_ok(
81 p_api_version IN NUMBER :=1.0 ,
82 p_lifecycle_id IN NUMBER ,
83 p_init_msg_list IN VARCHAR2 DEFAULT NULL ,
84 x_delete_ok OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
85 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
86 x_errorcode OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
87 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
88 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
89
90 -- Start of comments
91 -- API name : delete_stale_data_for_lc
92 -- Type : Public
93 -- Pre-reqs : None.
94 -- Purpose : Calls EGO_LIFECYCLE_ADMIN_PUB.delete_stale_data_for_lc
95 -- Parameters :
96 -- p_api_version IN NUMBER Optional Default 1.0
97 -- p_lifecycle_id IN NUMBER Required
98 -- P_init_msg_list IN VARCHAR2 Optional Default NULL
99 -- P_commit IN VARCHAR2 Optional Default NULL
100 -- x_errorcode OUT NUMBER
101 -- X_return_status OUT VARCHAR2
102 -- X_msg_count OUT NUMBER
103 -- X_msg_data OUT VARCHAR2
104 -- History :
105 -- 8-NOV-02 mrajput Created.
106 -- End of comments
107 PROCEDURE delete_stale_data_for_lc(
108 p_api_version IN NUMBER :=1.0 ,
109 p_lifecycle_id IN NUMBER ,
110 p_init_msg_list IN VARCHAR2 DEFAULT NULL ,
111 p_commit IN VARCHAR2 DEFAULT NULL ,
112 x_errorcode OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
113 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
114 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
115 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
116
117 -- Start of comments
118 -- API name : get_policy_for_phase_change
119 -- Type : Public
120 -- Pre-reqs : None.
121 -- Purpose : Calls EGO_LIFECYCLE_USER_PUB.get_policy_for_phase_change
122 -- Parameters :
123 -- p_api_version IN NUMBER Optional Default 1.0
124 -- p_project_id IN NUMBER Required
125 -- p_current_phase_id IN NUMBER Required
126 -- p_future_phase_id IN NUMBER Required
127 -- p_phase_change_code IN VARCHAR2 Required
128 -- p_lifecycle_id IN NUMBER
129 -- x_policy_code OUT VARCHAR2
130 -- X_return_status OUT VARCHAR2
131 -- x_errorcode OUT NUMBER
132 -- X_msg_count OUT NUMBER
133 -- X_msg_data OUT VARCHAR2
134 -- History :
135 -- 13-NOV-02 mrajput Created.
136 -- End of comments
137
138 PROCEDURE get_policy_for_phase_change(
139 p_api_version IN NUMBER := 1.0 ,
140 p_project_id IN NUMBER , -- Bug 2800909
141 p_current_phase_id IN NUMBER ,
142 p_future_phase_id IN NUMBER ,
143 p_phase_change_code IN VARCHAR2 ,
144 p_lifecycle_id IN NUMBER ,
145 x_policy_code OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
146 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
147 x_error_message OUT NOCOPY VARCHAR2 , -- Bug 2760719 --File.Sql.39 bug 4440895
148 x_errorcode OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
149 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
150 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
151
152
153 -- Start of comments
154 -- API name : sync_phase_change
155 -- Type : Public
156 -- Pre-reqs : None.
157 -- Purpose : Calls EGO_LIFECYCLE_USER_PUB.sync_phase_change
158 -- Parameters :
159 -- p_api_version IN NUMBER Optional Default 1.0
160 -- p_project_id IN NUMBER Required
161 -- p_lifecycle_id IN NUMBER Required
162 -- p_phase_id IN NUMBER Required
163 -- p_effective_date IN NUMBER Required
164 -- P_init_msg_list IN VARCHAR2 Optional Default NULL
165 -- P_commit IN VARCHAR2 Optional Default NULL
166 -- x_errorcode OUT NUMBER
167 -- X_return_status OUT VARCHAR2
168 -- X_msg_count OUT NUMBER
169 -- X_msg_data OUT VARCHAR2
170 -- History :
171 -- 13-NOV-02 mrajput Created.
172 -- End of comments
173
174 PROCEDURE sync_phase_change(
175 p_api_version IN NUMBER :=1.0 ,
176 p_project_id IN NUMBER ,
177 p_lifecycle_id IN NUMBER ,
178 p_phase_id IN NUMBER ,
179 p_effective_date IN DATE ,
180 p_init_msg_list IN VARCHAR2 DEFAULT NULL ,
181 p_commit IN VARCHAR2 DEFAULT NULL ,
182 x_errorcode OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
183 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
184 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
185 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
186
187
188 -- Start of comments
189 -- API name : check_lc_tracking_project
190 -- Type : Public
191 -- Pre-reqs : None.
192 -- Purpose : Calls EGO_LIFECYCLE_USER_PUB.check_lc_tracking_project
193 -- Parameters :
194 -- p_api_version IN NUMBER Optional Default 1.0
195 -- p_project_id IN NUMBER Required
196 -- x_is_lifecycle_tracking OUT VARCHAR2
197 -- X_return_status OUT VARCHAR2
198 -- x_errorcode OUT NUMBER
199 -- X_msg_count OUT NUMBER
200 -- X_msg_data OUT VARCHAR2
201 -- History :
202 -- 13-NOV-02 mrajput Created.
203 -- End of comments
204
205
206 PROCEDURE check_lc_tracking_project(
207 p_api_version IN NUMBER :=1.0 ,
208 p_project_id IN NUMBER ,
209 x_is_lifecycle_tracking OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
210 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
211 x_errorcode OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
212 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
213 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
214
215 -- Start of comments
216 -- API name : check_delete_project_ok
217 -- Type : Public
218 -- Pre-reqs : None.
219 -- Purpose : Calls EGO_LIFECYCLE_USER_PUB.check_delete_project_ok
220 -- Parameters :
221 -- p_api_version IN NUMBER Optional Default 1.0
222 -- p_project_id IN NUMBER Required
223 -- p_init_msg_list IN VARCHAR2 Optional Default NULL
224 -- x_delete_ok OUT VARCHAR2
225 -- X_return_status OUT VARCHAR2
226 -- x_errorcode OUT NUMBER
227 -- X_msg_count OUT NUMBER
228 -- X_msg_data OUT VARCHAR2
229 -- History :
230 -- 13-NOV-02 mrajput Created.
231 -- End of comments
232
233 PROCEDURE check_delete_project_ok(
234 p_api_version IN NUMBER :=1.0 ,
235 p_project_id IN NUMBER ,
236 p_init_msg_list IN VARCHAR2 DEFAULT NULL ,
237 x_delete_ok OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
238 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
239 x_errorcode OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
240 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
241 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
242
243
244
245 -- Start of comments
246 -- API name : delete_all_item_assocs
247 -- Type : Public
248 -- Pre-reqs : None.
249 -- Purpose : Calls EGO_LIFECYCLE_USER_PUB.delete_all_item_assocs
250 -- Parameters :
251 -- p_api_version IN NUMBER Optional Default 1.0
252 -- p_project_id IN NUMBER Required
253 -- p_init_msg_list IN VARCHAR2 Optional Default NULL
254 -- p_commit IN VARCHAR2 Optional Default NULL
255 -- X_return_status OUT VARCHAR2
256 -- x_errorcode OUT NUMBER
257 -- X_msg_count OUT NUMBER
258 -- X_msg_data OUT VARCHAR2
259 -- History :
260 -- 13-NOV-02 mrajput Created.
261 -- End of comments
262
263 PROCEDURE delete_all_item_assocs(
264 p_api_version IN NUMBER :=1.0 ,
265 p_project_id IN NUMBER ,
266 p_init_msg_list IN VARCHAR2 DEFAULT NULL ,
267 p_commit IN VARCHAR2 DEFAULT NULL ,
268 x_errorcode OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
269 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
270 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
271 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
272
273
274
275
276
277 FUNCTION CHECK_PLM_INSTALLED RETURN CHAR;
278 -- The function will check whether PLM is installed or not
279 -- and return TRUE if the product PLM is installed.
280
281
282 -- Start of comments
283 -- API name : copy_item_assocs
284 -- Type : Public
285 -- Pre-reqs : None.
286 -- Purpose : Calls EGO_LIFECYCLE_USER_PUB.copy_item_assocs
287 -- Parameters :
288 -- p_api_version IN NUMBER Optional Default 1.0
289 -- p_project_id_from IN NUMBER Required
290 -- p_project_id_to IN NUMBER Required
291 -- p_init_msg_list IN VARCHAR2 Optional Default NULL
292 -- p_commit IN VARCHAR2 Optional Default NULL
293 -- X_return_status OUT VARCHAR2
294 -- x_errorcode OUT NUMBER
295 -- X_msg_count OUT NUMBER
296 -- X_msg_data OUT VARCHAR2
297 -- History :
298 -- 13-DEC-02 anlee Created.
299 -- End of comments
300
301 PROCEDURE Copy_Item_Assocs
302 (
303 p_api_version IN NUMBER := 1.0
304 ,p_project_id_from IN NUMBER
305 ,p_project_id_to IN NUMBER
306 ,p_init_msg_list IN VARCHAR2 DEFAULT NULL
307 ,p_commit IN VARCHAR2 DEFAULT NULL
308 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
309 ,x_errorcode OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
310 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
311 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
312 );
313
314 /* Start for Changes made for Integration with Eng */
315 -- Start of comments
316 -- API name : check_delete_project_ok_eng
317 -- Type : Public
318 -- Pre-reqs : None.
319 -- Purpose : Calls ENG_LIFECYCLE_USER_PUB.check_delete_project_ok
320 -- Parameters :
321 -- p_api_version IN NUMBER Optional Default 1.0
322 -- p_project_id IN NUMBER Required
323 -- p_init_msg_list IN VARCHAR2 Optional Default NULL
324 -- x_delete_ok OUT VARCHAR2
325 -- X_return_status OUT VARCHAR2
326 -- x_errorcode OUT NUMBER
327 -- X_msg_count OUT NUMBER
328 -- X_msg_data OUT VARCHAR2
329 -- History :
330 -- 13-FEB-03 mrajput Created.
331 -- End of comments
332
333 PROCEDURE check_delete_project_ok_eng(
334 p_api_version IN NUMBER :=1.0 ,
335 p_project_id IN NUMBER ,
336 p_init_msg_list IN VARCHAR2 DEFAULT NULL ,
337 x_delete_ok OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
338 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
339 x_errorcode OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
340 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
341 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
342
343 -- Start of comments
344 -- API name : check_delete_task_ok_eng
345 -- Type : Public
346 -- Pre-reqs : None.
347 -- Purpose : Calls ENG_LIFECYCLE_USER_PUB.check_delete_task_ok
348 -- Parameters :
349 -- p_api_version IN NUMBER Optional Default 1.0
350 -- p_task_id IN NUMBER Required
351 -- p_init_msg_list IN VARCHAR2 Optional Default NULL
352 -- x_delete_ok OUT VARCHAR2
353 -- X_return_status OUT VARCHAR2
354 -- x_errorcode OUT NUMBER
355 -- X_msg_count OUT NUMBER
356 -- X_msg_data OUT VARCHAR2
357 -- History :
358 -- 13-FEB-03 mrajput Created.
359 -- End of comments
360
361 PROCEDURE check_delete_task_ok_eng(
362 p_api_version IN NUMBER :=1.0 ,
363 p_task_id IN NUMBER ,
364 p_init_msg_list IN VARCHAR2 DEFAULT NULL ,
365 x_delete_ok OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
366 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
367 x_errorcode OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
368 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
369 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
370
371 /* End for Changes made for Integration with Eng */
372
373
374 /* Start Changes for Bug 2778408 */
375
376 -- Start of comments
377 -- API name : process_phase_code_delete
378 -- Type : Public
379 -- Pre-reqs : None.
380 -- Purpose : Calls EGO_LIFECYCLE_ADMIN_PUB.process_phase_code_delete
381 -- Parameters :
382 -- p_api_version IN NUMBER Optional Default 1.0
383 -- p_phase_code IN NUMBER Required
384 -- P_init_msg_list IN VARCHAR2 Optional Default NULL
385 -- P_commit IN VARCHAR2 Optional Default NULL
386 -- x_errorcode OUT NUMBER
387 -- X_return_status OUT VARCHAR2
388 -- X_msg_count OUT NUMBER
389 -- X_msg_data OUT VARCHAR2
390 -- History :
391 -- 14-FEB-03 mrajput Created.
392 -- End of comments
393 PROCEDURE process_phase_code_delete(
394 p_api_version IN NUMBER :=1.0 ,
395 p_phase_code IN NUMBER ,
396 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
397 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
398 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
399 x_errorcode OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
400 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
401 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
402
403 /* End Changes for Bug 2778408 */
404 END PA_EGO_WRAPPER_PUB;