1 package PA_CONTROL_API_PUB AUTHID DEFINER as
2 /*$Header: PACIAMPS.pls 120.0 2006/11/24 08:34:51 vgottimu noship $*/
3
4
5 G_PA_MISS_NUM CONSTANT NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
6 G_PA_MISS_DATE CONSTANT DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
7 G_PA_MISS_CHAR CONSTANT VARCHAR2(3) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
8
9
10
11 type ci_action_in_rec_type is record(
12 action_type_code pa_ci_actions.type_code%type := 'REVIEW',
13 assignee_id number,
14 date_required pa_ci_actions.date_required%type,
15 request_text pa_ci_comments.comment_text%type,
16 sign_off_requested_flag pa_ci_actions.sign_off_required_flag%type := 'N',
17 action_status pa_ci_actions.status_code%type,
18 signed_off pa_ci_actions.sign_off_flag%type := 'N',
19 source_ci_action_id number,
20 start_wf VARCHAR2(1) := 'N',
21 closed_date pa_ci_actions.date_closed%type
22 );
23
24 type ci_action_out_rec_type is record(
25 action_id pa_ci_actions.ci_action_id%type,
26 action_number pa_ci_actions.ci_action_number%type
27 );
28
29 type ci_actions_in_tbl_type is table of ci_action_in_rec_type
30 index by binary_integer;
31
32 type ci_actions_out_tbl_type is table of ci_action_out_rec_type
33 index by binary_integer;
34
35 --Record and table type definitions
36 TYPE supp_det_rec_type IS RECORD
37 (
38 change_type pa_ci_supplier_details.change_type%type := G_PA_MISS_CHAR,
39 change_description pa_ci_supplier_details.change_description%type := G_PA_MISS_CHAR,
40 vendor_id NUMBER := G_PA_MISS_NUM,
41 po_header_id NUMBER := G_PA_MISS_NUM,
42 po_number varchar2(40) := G_PA_MISS_CHAR,
43 po_line_id number := G_PA_MISS_NUM,
44 po_line_num number := G_PA_MISS_NUM,
45 currency pa_ci_supplier_details.CURRENCY_CODE%type:= G_PA_MISS_CHAR,
46 change_amount number := G_PA_MISS_NUM
47 );
48
49
50 TYPE SUPP_DET_TBL_TYPE IS TABLE OF supp_det_rec_type
51 INDEX BY BINARY_INTEGER;
52
53
54 TYPE REL_ITEM_IN_TABLE_TYPE IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
55
56 TYPE CI_COMMENTS_TBL_TYPE IS TABLE OF PA_CI_COMMENTS.COMMENT_TEXT%TYPE INDEX BY BINARY_INTEGER;
57
58 /* Procedure to the add the Workplan impacts*/
59 Procedure Add_Workplan_Impact (
60 p_commit IN VARCHAR2 := FND_API.G_FALSE,
61 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62 p_api_version_number IN NUMBER,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2,
66 p_ci_id IN NUMBER := G_PA_MISS_NUM,
67 p_impact_description IN VARCHAR2 := G_PA_MISS_CHAR,
68 x_impact_id OUT NOCOPY NUMBER
69 );
70
71 /* Procedure to the add the Staffing impacts*/
72 Procedure Add_Staffing_Impact(
73 p_commit IN VARCHAR2 := FND_API.G_FALSE,
74 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75 p_api_version_number IN NUMBER,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2,
79 p_ci_id IN NUMBER := G_PA_MISS_NUM,
80 p_impact_description IN VARCHAR2 := G_PA_MISS_CHAR,
81 x_impact_id OUT NOCOPY NUMBER
82 );
83
84 /* Procedure to the add the Contract impacts*/
85 Procedure Add_Contract_Impact(
86 p_commit IN VARCHAR2 := FND_API.G_FALSE,
87 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
88 p_api_version_number IN NUMBER,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2,
92 p_ci_id IN NUMBER := G_PA_MISS_NUM,
93 p_impact_description IN VARCHAR2 := G_PA_MISS_CHAR,
94 x_impact_id OUT NOCOPY NUMBER
95 );
96
97 /* Procedure to the add the Other impacts*/
98 Procedure Add_Other_Impact(
99 p_commit IN VARCHAR2 := FND_API.G_FALSE,
100 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101 p_api_version_number IN NUMBER,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2,
105 p_ci_id IN NUMBER := G_PA_MISS_NUM,
106 p_impact_description IN VARCHAR2 := G_PA_MISS_CHAR,
107 x_impact_id OUT NOCOPY NUMBER
108 );
109
110 /* Procedure to the add the Supplier impacts*/
111 /* Parameter is included to pass the table with supplier details*/
112
113 Procedure Add_Supplier_Impact (
114 p_commit IN VARCHAR2 := FND_API.G_FALSE,
115 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
116 p_api_version_number IN NUMBER,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120 p_ci_id IN NUMBER := G_PA_MISS_NUM,
121 p_impact_description IN VARCHAR2 := G_PA_MISS_CHAR,
122 p_supplier_det_tbl IN SUPP_DET_TBL_TYPE, --Table with supplier details
123 x_impact_id OUT NOCOPY NUMBER
124 );
125
126
127 /*Procedure to update the impact and to implement the workplan impact*/
128 Procedure Update_Workplan_Impact (
129 p_commit IN VARCHAR2 := FND_API.G_FALSE,
130 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
131 p_api_version_number IN NUMBER,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2,
135 p_ci_id IN NUMBER := G_PA_MISS_NUM,
136 p_impact_description IN VARCHAR2 := G_PA_MISS_CHAR
137 );
138
139 /*Procedure to update the impact and to implement the Staffing impact*/
140 Procedure Update_Staffing_Impact(
141 p_commit IN VARCHAR2 := FND_API.G_FALSE,
142 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
143 p_api_version_number IN NUMBER,
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_msg_count OUT NOCOPY NUMBER,
146 x_msg_data OUT NOCOPY VARCHAR2,
147 p_ci_id IN NUMBER := G_PA_MISS_NUM,
148 p_impact_description IN VARCHAR2 := G_PA_MISS_CHAR
149 );
150
151 /*Procedure to update the impact and to implement the Contract impact*/
152 Procedure Update_Contract_Impact(
153 p_commit IN VARCHAR2 := FND_API.G_FALSE,
154 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155 p_api_version_number IN NUMBER,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159 p_ci_id IN NUMBER := G_PA_MISS_NUM,
160 p_impact_description IN VARCHAR2 := G_PA_MISS_CHAR
161 );
162
163 /*Procedure to update the impact and to implement the Staffing impact*/
164 Procedure Update_Other_Impact(
165 p_commit IN VARCHAR2 := FND_API.G_FALSE,
166 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167 p_api_version_number IN NUMBER,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171 p_ci_id IN NUMBER := G_PA_MISS_NUM,
172 p_impact_description IN VARCHAR2 := G_PA_MISS_CHAR
173 );
174
175 /*Procedure to update the impact and to implement the Supplier impact*/
176 Procedure Update_Supplier_Impact (
177 p_commit IN VARCHAR2 := FND_API.G_FALSE,
178 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179 p_api_version_number IN NUMBER,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 p_ci_id IN NUMBER := G_PA_MISS_NUM,
184 p_impact_description IN VARCHAR2 := G_PA_MISS_CHAR
185 );
186
187
188 /*Procudure to delete the supplier details*/
189 Procedure Delete_Supplier_Impact_Details
190 (
191 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
192 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
193 P_API_VERSION_NUMBER IN NUMBER,
194 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
195 X_MSG_COUNT OUT NOCOPY NUMBER,
196 X_MSG_DATA OUT NOCOPY VARCHAR2,
197 P_CI_TRANSACTION_ID IN NUMBER);
198
199
200
201 /*Procedure to update the Progress details and resolution details in pa_control_item*/
202 Procedure Update_Progress(
203 p_commit IN VARCHAR2 := FND_API.G_FALSE,
204 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205 p_api_version_number IN NUMBER,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209 p_ci_id IN NUMBER := G_PA_MISS_NUM,
210 p_ci_status_code IN VARCHAR2 := G_PA_MISS_CHAR,
211 p_status_comment IN VARCHAR2 := G_PA_MISS_CHAR,
212 p_as_of_date IN DATE := G_PA_MISS_DATE,
213 p_progress_status_code IN VARCHAR2 := G_PA_MISS_CHAR,
214 p_progress_overview IN VARCHAR2 := G_PA_MISS_CHAR,
215 p_resolution_code IN VARCHAR2 := G_PA_MISS_CHAR,
216 p_resolution_comment IN VARCHAR2 := G_PA_MISS_CHAR
217 );
218
219
220
221 PROCEDURE CREATE_ISSUE
222 (
223 p_commit IN VARCHAR2 := FND_API.G_FALSE,
224 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
225 p_api_version_number IN NUMBER := G_PA_MISS_NUM,
226 p_orig_system_code IN VARCHAR2 := null,
227 p_orig_system_reference IN VARCHAR2 := null,
228 x_return_status OUT NOCOPY VARCHAR2,
229 x_msg_count OUT NOCOPY NUMBER,
230 x_msg_data OUT NOCOPY VARCHAR2,
231 x_ci_id OUT NOCOPY NUMBER,
232 x_ci_number OUT NOCOPY NUMBER,
233 p_project_id IN NUMBER := G_PA_MISS_NUM,
234 p_project_name IN VARCHAR2 := G_PA_MISS_CHAR,
235 p_project_number IN VARCHAR2 := G_PA_MISS_CHAR,
236 p_ci_type_id IN NUMBER := G_PA_MISS_NUM,
237 p_summary IN VARCHAR2,
238 p_ci_number IN VARCHAR2 := G_PA_MISS_CHAR,
239 p_description IN VARCHAR2 := G_PA_MISS_CHAR,
240 p_status_code IN VARCHAR2 := G_PA_MISS_CHAR,
241 p_status IN VARCHAR2 := G_PA_MISS_CHAR,
242 p_owner_id IN NUMBER := G_PA_MISS_NUM,
243 p_progress_status_code IN VARCHAR2 := G_PA_MISS_CHAR,
244 p_progress_as_of_date IN DATE := G_PA_MISS_DATE,
245 p_status_overview IN VARCHAR2 := G_PA_MISS_CHAR,
246 p_classification_code IN NUMBER,
250 p_date_required IN DATE := G_PA_MISS_DATE,
247 p_reason_code IN NUMBER,
248 p_object_id IN NUMBER := G_PA_MISS_NUM,
249 p_object_type IN VARCHAR2 := G_PA_MISS_CHAR,
251 p_date_closed IN DATE := G_PA_MISS_DATE,
252 p_closed_by_id IN NUMBER := G_PA_MISS_NUM,
253 p_resolution IN VARCHAR2 := G_PA_MISS_CHAR,
254 p_resolution_code IN NUMBER := G_PA_MISS_NUM,
255 p_priority_code IN VARCHAR2 := G_PA_MISS_CHAR,
256 p_effort_level_code IN VARCHAR2 := G_PA_MISS_CHAR,
257 p_price IN NUMBER := G_PA_MISS_NUM,
258 p_price_currency_code IN VARCHAR2 := G_PA_MISS_CHAR,
259 p_source_type_name IN VARCHAR2 := G_PA_MISS_CHAR,
260 p_source_type_code IN VARCHAR2 := G_PA_MISS_CHAR,
261 p_source_number IN VARCHAR2 := G_PA_MISS_CHAR,
262 p_source_comment IN VARCHAR2 := G_PA_MISS_CHAR,
263 p_source_date_received IN DATE := G_PA_MISS_DATE,
264 p_source_organization IN VARCHAR2 := G_PA_MISS_CHAR,
265 p_source_person IN VARCHAR2 := G_PA_MISS_CHAR,
266 p_attribute_category IN VARCHAR2 := G_PA_MISS_CHAR,
267 p_attribute1 IN VARCHAR2 := G_PA_MISS_CHAR,
268 p_attribute2 IN VARCHAR2 := G_PA_MISS_CHAR,
269 p_attribute3 IN VARCHAR2 := G_PA_MISS_CHAR,
270 p_attribute4 IN VARCHAR2 := G_PA_MISS_CHAR,
271 p_attribute5 IN VARCHAR2 := G_PA_MISS_CHAR,
272 p_attribute6 IN VARCHAR2 := G_PA_MISS_CHAR,
273 p_attribute7 IN VARCHAR2 := G_PA_MISS_CHAR,
274 p_attribute8 IN VARCHAR2 := G_PA_MISS_CHAR,
275 p_attribute9 IN VARCHAR2 := G_PA_MISS_CHAR,
276 p_attribute10 IN VARCHAR2 := G_PA_MISS_CHAR,
277 p_attribute11 IN VARCHAR2 := G_PA_MISS_CHAR,
278 p_attribute12 IN VARCHAR2 := G_PA_MISS_CHAR,
279 p_attribute13 IN VARCHAR2 := G_PA_MISS_CHAR,
280 p_attribute14 IN VARCHAR2 := G_PA_MISS_CHAR,
281 p_attribute15 IN VARCHAR2 := G_PA_MISS_CHAR
282 );
283
284 PROCEDURE CREATE_CHANGE_REQUEST
285 (
286 p_commit IN VARCHAR2 := FND_API.G_FALSE,
287 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
288 p_api_version_number IN NUMBER := G_PA_MISS_NUM,
289 p_orig_system_code IN VARCHAR2 := null,
290 p_orig_system_reference IN VARCHAR2 := null,
291 x_return_status OUT NOCOPY VARCHAR2,
292 x_msg_count OUT NOCOPY NUMBER,
293 x_msg_data OUT NOCOPY VARCHAR2,
294 x_ci_id OUT NOCOPY NUMBER,
295 x_ci_number OUT NOCOPY NUMBER,
296 p_project_id IN NUMBER := G_PA_MISS_NUM,
297 p_project_name IN VARCHAR2 := G_PA_MISS_CHAR,
298 p_project_number IN VARCHAR2 := G_PA_MISS_CHAR,
299 p_ci_type_id IN NUMBER := G_PA_MISS_NUM,
300 p_summary IN VARCHAR2,
301 p_ci_number IN VARCHAR2 := G_PA_MISS_CHAR,
302 p_description IN VARCHAR2 := G_PA_MISS_CHAR,
303 p_status_code IN VARCHAR2 := G_PA_MISS_CHAR,
304 p_status IN VARCHAR2 := G_PA_MISS_CHAR,
305 p_owner_id IN NUMBER := G_PA_MISS_NUM,
306 p_progress_status_code IN VARCHAR2 := G_PA_MISS_CHAR,
307 p_progress_as_of_date IN DATE := G_PA_MISS_DATE,
308 p_status_overview IN VARCHAR2 := G_PA_MISS_CHAR,
309 p_classification_code IN NUMBER,
310 p_reason_code IN NUMBER,
311 p_object_id IN NUMBER := G_PA_MISS_NUM,
312 p_object_type IN VARCHAR2 := G_PA_MISS_CHAR,
313 p_date_required IN DATE := G_PA_MISS_DATE,
314 p_date_closed IN DATE := G_PA_MISS_DATE,
315 p_closed_by_id IN NUMBER := G_PA_MISS_NUM,
316 p_resolution IN VARCHAR2 := G_PA_MISS_CHAR,
317 p_resolution_code IN NUMBER := G_PA_MISS_NUM,
318 p_priority_code IN VARCHAR2 := G_PA_MISS_CHAR,
319 p_effort_level_code IN VARCHAR2 := G_PA_MISS_CHAR,
320 p_price IN NUMBER := G_PA_MISS_NUM,
321 p_price_currency_code IN VARCHAR2 := G_PA_MISS_CHAR,
322 p_source_type_name IN VARCHAR2 := G_PA_MISS_CHAR,
323 p_source_type_code IN VARCHAR2 := G_PA_MISS_CHAR,
324 p_source_number IN VARCHAR2 := G_PA_MISS_CHAR,
325 p_source_comment IN VARCHAR2 := G_PA_MISS_CHAR,
326 p_source_date_received IN DATE := G_PA_MISS_DATE,
327 p_source_organization IN VARCHAR2 := G_PA_MISS_CHAR,
328 p_source_person IN VARCHAR2 := G_PA_MISS_CHAR,
332 p_attribute3 IN VARCHAR2 := G_PA_MISS_CHAR,
329 p_attribute_category IN VARCHAR2 := G_PA_MISS_CHAR,
330 p_attribute1 IN VARCHAR2 := G_PA_MISS_CHAR,
331 p_attribute2 IN VARCHAR2 := G_PA_MISS_CHAR,
333 p_attribute4 IN VARCHAR2 := G_PA_MISS_CHAR,
334 p_attribute5 IN VARCHAR2 := G_PA_MISS_CHAR,
335 p_attribute6 IN VARCHAR2 := G_PA_MISS_CHAR,
336 p_attribute7 IN VARCHAR2 := G_PA_MISS_CHAR,
337 p_attribute8 IN VARCHAR2 := G_PA_MISS_CHAR,
338 p_attribute9 IN VARCHAR2 := G_PA_MISS_CHAR,
339 p_attribute10 IN VARCHAR2 := G_PA_MISS_CHAR,
340 p_attribute11 IN VARCHAR2 := G_PA_MISS_CHAR,
341 p_attribute12 IN VARCHAR2 := G_PA_MISS_CHAR,
342 p_attribute13 IN VARCHAR2 := G_PA_MISS_CHAR,
343 p_attribute14 IN VARCHAR2 := G_PA_MISS_CHAR,
344 p_attribute15 IN VARCHAR2 := G_PA_MISS_CHAR
345 );
346
347 PROCEDURE CREATE_CHANGE_ORDER
348 (
349 p_commit IN VARCHAR2 := FND_API.G_FALSE,
350 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
351 p_api_version_number IN NUMBER := G_PA_MISS_NUM,
352 p_orig_system_code IN VARCHAR2 := null,
353 p_orig_system_reference IN VARCHAR2 := null,
354 x_return_status OUT NOCOPY VARCHAR2,
355 x_msg_count OUT NOCOPY NUMBER,
356 x_msg_data OUT NOCOPY VARCHAR2,
357 x_ci_id OUT NOCOPY NUMBER,
358 x_ci_number OUT NOCOPY NUMBER,
359 p_project_id IN NUMBER := G_PA_MISS_NUM,
360 p_project_name IN VARCHAR2 := G_PA_MISS_CHAR,
361 p_project_number IN VARCHAR2 := G_PA_MISS_CHAR,
362 p_ci_type_id IN NUMBER := G_PA_MISS_NUM,
363 p_summary IN VARCHAR2,
364 p_ci_number IN VARCHAR2 := G_PA_MISS_CHAR,
365 p_description IN VARCHAR2 := G_PA_MISS_CHAR,
366 p_status_code IN VARCHAR2 := G_PA_MISS_CHAR,
367 p_status IN VARCHAR2 := G_PA_MISS_CHAR,
368 p_owner_id IN NUMBER := G_PA_MISS_NUM,
369 p_progress_status_code IN VARCHAR2 := G_PA_MISS_CHAR,
370 p_progress_as_of_date IN DATE := G_PA_MISS_DATE,
371 p_status_overview IN VARCHAR2 := G_PA_MISS_CHAR,
372 p_classification_code IN NUMBER,
373 p_reason_code IN NUMBER,
374 p_object_id IN NUMBER := G_PA_MISS_NUM,
375 p_object_type IN VARCHAR2 := G_PA_MISS_CHAR,
376 p_date_required IN DATE := G_PA_MISS_DATE,
377 p_date_closed IN DATE := G_PA_MISS_DATE,
378 p_closed_by_id IN NUMBER := G_PA_MISS_NUM,
379 p_resolution IN VARCHAR2 := G_PA_MISS_CHAR,
380 p_resolution_code IN NUMBER := G_PA_MISS_NUM,
381 p_priority_code IN VARCHAR2 := G_PA_MISS_CHAR,
382 p_effort_level_code IN VARCHAR2 := G_PA_MISS_CHAR,
383 p_price IN NUMBER := G_PA_MISS_NUM,
384 p_price_currency_code IN VARCHAR2 := G_PA_MISS_CHAR,
385 p_source_type_name IN VARCHAR2 := G_PA_MISS_CHAR,
386 p_source_type_code IN VARCHAR2 := G_PA_MISS_CHAR,
387 p_source_number IN VARCHAR2 := G_PA_MISS_CHAR,
388 p_source_comment IN VARCHAR2 := G_PA_MISS_CHAR,
389 p_source_date_received IN DATE := G_PA_MISS_DATE,
390 p_source_organization IN VARCHAR2 := G_PA_MISS_CHAR,
391 p_source_person IN VARCHAR2 := G_PA_MISS_CHAR,
392 p_attribute_category IN VARCHAR2 := G_PA_MISS_CHAR,
393 p_attribute1 IN VARCHAR2 := G_PA_MISS_CHAR,
394 p_attribute2 IN VARCHAR2 := G_PA_MISS_CHAR,
395 p_attribute3 IN VARCHAR2 := G_PA_MISS_CHAR,
396 p_attribute4 IN VARCHAR2 := G_PA_MISS_CHAR,
397 p_attribute5 IN VARCHAR2 := G_PA_MISS_CHAR,
398 p_attribute6 IN VARCHAR2 := G_PA_MISS_CHAR,
399 p_attribute7 IN VARCHAR2 := G_PA_MISS_CHAR,
400 p_attribute8 IN VARCHAR2 := G_PA_MISS_CHAR,
401 p_attribute9 IN VARCHAR2 := G_PA_MISS_CHAR,
402 p_attribute10 IN VARCHAR2 := G_PA_MISS_CHAR,
403 p_attribute11 IN VARCHAR2 := G_PA_MISS_CHAR,
404 p_attribute12 IN VARCHAR2 := G_PA_MISS_CHAR,
405 p_attribute13 IN VARCHAR2 := G_PA_MISS_CHAR,
406 p_attribute14 IN VARCHAR2 := G_PA_MISS_CHAR,
407 p_attribute15 IN VARCHAR2 := G_PA_MISS_CHAR
408 );
409
410
411
412 PROCEDURE CREATE_ACTION
413 (
414 p_commit IN VARCHAR2 := FND_API.G_FALSE,
418 x_msg_count OUT NOCOPY NUMBER,
415 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
416 p_api_version_number IN NUMBER := G_PA_MISS_NUM,
417 x_return_status OUT NOCOPY VARCHAR2,
419 x_msg_data OUT NOCOPY VARCHAR2,
420 p_ci_id IN NUMBER := G_PA_MISS_NUM,
421 p_action_tbl IN ci_actions_in_tbl_type,
422 x_action_tbl OUT NOCOPY ci_actions_out_tbl_type
423 );
424
425 PROCEDURE TAKE_ACTION
426 (
427 p_commit IN VARCHAR2 := FND_API.G_FALSE,
428 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
429 p_api_version_number IN NUMBER := G_PA_MISS_NUM,
430 x_return_status OUT NOCOPY VARCHAR2,
431 x_msg_count OUT NOCOPY NUMBER,
432 x_msg_data OUT NOCOPY VARCHAR2,
433 p_ci_id IN NUMBER := G_PA_MISS_NUM,
434 p_action_id IN NUMBER := G_PA_MISS_NUM,
435 p_action_number IN NUMBER := G_PA_MISS_NUM,
436 p_close_action_flag IN VARCHAR2 := 'N',
437 p_response_text IN VARCHAR2 := G_PA_MISS_CHAR,
438 p_sign_off_flag IN VARCHAR2 := 'N',
439 p_reassign_action_flag IN VARCHAR2 := 'N',
440 p_reassign_to_id IN NUMBER := G_PA_MISS_NUM,
441 p_reassign_request_text IN VARCHAR2 := G_PA_MISS_CHAR,
442 p_required_by_date IN DATE := G_PA_MISS_DATE
443 );
444
445
446 /*Procedure to cancel the action*/
447 Procedure Cancel_Action(
448 p_commit IN VARCHAR2 := FND_API.G_FALSE,
449 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
450 p_api_version_number IN NUMBER,
451 x_return_status OUT NOCOPY VARCHAR2,
452 x_msg_count OUT NOCOPY NUMBER,
453 x_msg_data OUT NOCOPY VARCHAR2,
454 p_ci_id IN NUMBER := G_PA_MISS_NUM,
455 p_action_id IN NUMBER := G_PA_MISS_NUM,
456 p_action_number IN NUMBER := G_PA_MISS_NUM,
457 p_cancel_comment IN VARCHAR2 := G_PA_MISS_CHAR
458 );
459
460
461 Procedure Delete_Issue (
462 p_Commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
463 , p_Init_Msg_List IN VARCHAR2 DEFAULT FND_API.G_FALSE
464 , p_Api_Version_Number IN NUMBER
465 , p_Ci_Id IN NUMBER
466 , x_Return_Status OUT NOCOPY VARCHAR2
467 , x_Msg_Count OUT NOCOPY NUMBER
468 , x_Msg_Data OUT NOCOPY VARCHAR2
469 );
470
471
472 Procedure Delete_Change_Request (
473 p_Commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
474 , p_Init_Msg_List IN VARCHAR2 DEFAULT FND_API.G_FALSE
475 , p_Api_Version_Number IN NUMBER
476 , p_Ci_Id IN NUMBER
477 , x_Return_Status OUT NOCOPY VARCHAR2
478 , x_Msg_Count OUT NOCOPY NUMBER
479 , x_Msg_Data OUT NOCOPY VARCHAR2
480 );
481 Procedure Delete_Change_Order (
482 p_Commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
483 , p_Init_Msg_List IN VARCHAR2 DEFAULT FND_API.G_FALSE
484 , p_Api_Version_Number IN NUMBER
485 , p_Ci_Id IN NUMBER
486 , x_Return_Status OUT NOCOPY VARCHAR2
487 , x_Msg_Count OUT NOCOPY NUMBER
488 , x_Msg_Data OUT NOCOPY VARCHAR2
489 );
490
491 Procedure Add_Comments (
492 p_Commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
493 , p_Init_Msg_List IN VARCHAR2 DEFAULT FND_API.G_FALSE
494 , p_Api_Version_Number IN NUMBER
495 , p_Ci_Id IN NUMBER
496 , p_Comments_Tbl IN CI_COMMENTS_TBL_TYPE
497 , x_Return_Status OUT NOCOPY VARCHAR2
498 , x_Msg_Count OUT NOCOPY NUMBER
499 , x_Msg_Data OUT NOCOPY VARCHAR2
500 );
501 Procedure Add_Related_Items (
502 p_Commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
503 , p_Init_Msg_List IN VARCHAR2 DEFAULT FND_API.G_FALSE
504 , p_Api_Version_Number IN NUMBER
505 , p_Ci_Id IN NUMBER
506 , p_Related_Items_Tbl IN REL_ITEM_IN_TABLE_TYPE
507 , x_Return_Status OUT NOCOPY VARCHAR2
508 , x_Msg_Count OUT NOCOPY NUMBER
509 , x_Msg_Data OUT NOCOPY VARCHAR2
510 );
511 Procedure Delete_Related_Item (
512 p_Commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
513 , p_Init_Msg_List IN VARCHAR2 DEFAULT FND_API.G_FALSE
514 , p_Api_Version_Number IN NUMBER
518 , x_Msg_Count OUT NOCOPY NUMBER
515 , p_Ci_Id IN NUMBER
516 , p_To_Ci_Id IN NUMBER
517 , x_Return_Status OUT NOCOPY VARCHAR2
519 , x_Msg_Data OUT NOCOPY VARCHAR2
520 );
521
522 PROCEDURE UPDATE_ISSUE (
523 p_commit IN VARCHAR2 := FND_API.G_FALSE,
524 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
525 p_api_version_number IN NUMBER,
526 x_return_status OUT NOCOPY VARCHAR2,
527 x_msg_count OUT NOCOPY NUMBER,
528 x_msg_data OUT NOCOPY VARCHAR2,
529 p_ci_id IN NUMBER,
530 P_RECORD_VERSION_NUMBER IN NUMBER := G_PA_MISS_NUM,
531 P_SUMMARY IN VARCHAR2 := G_PA_MISS_CHAR,
532 P_DESCRIPTION IN VARCHAR2 := G_PA_MISS_CHAR,
533 P_OWNER_ID IN NUMBER := G_PA_MISS_NUM,
534 P_OWNER_COMMENT IN VARCHAR2 := G_PA_MISS_CHAR,
535 P_CLASSIFICATION_CODE IN NUMBER := G_PA_MISS_NUM,
536 P_REASON_CODE IN NUMBER := G_PA_MISS_NUM,
537 P_OBJECT_ID IN NUMBER := G_PA_MISS_NUM,
538 P_OBJECT_TYPE IN VARCHAR2 := G_PA_MISS_CHAR,
539 P_CI_NUMBER IN VARCHAR2 := G_PA_MISS_CHAR,
540 P_DATE_REQUIRED IN DATE := G_PA_MISS_DATE,
541 P_PRIORITY_CODE IN VARCHAR2 := G_PA_MISS_CHAR,
542 P_EFFORT_LEVEL_CODE IN VARCHAR2 := G_PA_MISS_CHAR,
543 P_PRICE IN NUMBER := G_PA_MISS_NUM,
544 P_PRICE_CURRENCY_CODE IN VARCHAR2 := G_PA_MISS_CHAR,
545 P_SOURCE_TYPE_CODE IN VARCHAR2 := G_PA_MISS_CHAR,
546 P_SOURCE_NUMBER IN VARCHAR2 := G_PA_MISS_CHAR,
547 P_SOURCE_COMMENT IN VARCHAR2 := G_PA_MISS_CHAR,
548 P_SOURCE_DATE_RECEIVED IN DATE := G_PA_MISS_DATE,
549 P_SOURCE_ORGANIZATION IN VARCHAR2 := G_PA_MISS_CHAR,
550 P_SOURCE_PERSON IN VARCHAR2 := G_PA_MISS_CHAR,
551 P_CI_STATUS_CODE IN VARCHAR2 := G_PA_MISS_CHAR,
552 P_STATUS_COMMENT IN VARCHAR2 := G_PA_MISS_CHAR,
553 P_PROGRESS_AS_OF_DATE IN DATE := G_PA_MISS_DATE,
554 P_PROGRESS_STATUS_CODE IN VARCHAR2 := G_PA_MISS_CHAR,
555 P_PROGRESS_OVERVIEW IN VARCHAR2 := G_PA_MISS_CHAR,
556 P_RESOLUTION_CODE IN VARCHAR2 := G_PA_MISS_CHAR,
557 P_RESOLUTION_COMMENT IN VARCHAR2 := G_PA_MISS_CHAR,
558 P_ATTRIBUTE_CATEGORY IN VARCHAR2 := G_PA_MISS_CHAR,
559 P_ATTRIBUTE1 IN VARCHAR2 := G_PA_MISS_CHAR,
560 P_ATTRIBUTE2 IN VARCHAR2 := G_PA_MISS_CHAR,
561 P_ATTRIBUTE3 IN VARCHAR2 := G_PA_MISS_CHAR,
562 P_ATTRIBUTE4 IN VARCHAR2 := G_PA_MISS_CHAR,
563 P_ATTRIBUTE5 IN VARCHAR2 := G_PA_MISS_CHAR,
564 P_ATTRIBUTE6 IN VARCHAR2 := G_PA_MISS_CHAR,
565 P_ATTRIBUTE7 IN VARCHAR2 := G_PA_MISS_CHAR,
566 P_ATTRIBUTE8 IN VARCHAR2 := G_PA_MISS_CHAR,
567 P_ATTRIBUTE9 IN VARCHAR2 := G_PA_MISS_CHAR,
568 P_ATTRIBUTE10 IN VARCHAR2 := G_PA_MISS_CHAR,
569 P_ATTRIBUTE11 IN VARCHAR2 := G_PA_MISS_CHAR,
570 P_ATTRIBUTE12 IN VARCHAR2 := G_PA_MISS_CHAR,
571 P_ATTRIBUTE13 IN VARCHAR2 := G_PA_MISS_CHAR,
572 P_ATTRIBUTE14 IN VARCHAR2 := G_PA_MISS_CHAR,
573 P_ATTRIBUTE15 IN VARCHAR2 := G_PA_MISS_CHAR
574 );
575
576 PROCEDURE UPDATE_CHANGE_REQUEST (
577 p_commit IN VARCHAR2 := FND_API.G_FALSE,
578 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
579 p_api_version_number IN NUMBER,
580 x_return_status OUT NOCOPY VARCHAR2,
581 x_msg_count OUT NOCOPY NUMBER,
582 x_msg_data OUT NOCOPY VARCHAR2,
583 p_ci_id IN NUMBER,
584 P_RECORD_VERSION_NUMBER IN NUMBER := G_PA_MISS_NUM,
585 P_SUMMARY IN VARCHAR2 := G_PA_MISS_CHAR,
586 P_DESCRIPTION IN VARCHAR2 := G_PA_MISS_CHAR,
587 P_OWNER_ID IN NUMBER := G_PA_MISS_NUM,
588 P_OWNER_COMMENT IN VARCHAR2 := G_PA_MISS_CHAR,
589 P_CLASSIFICATION_CODE IN NUMBER := G_PA_MISS_NUM,
590 P_REASON_CODE IN NUMBER := G_PA_MISS_NUM,
591 P_OBJECT_ID IN NUMBER := G_PA_MISS_NUM,
592 P_OBJECT_TYPE IN VARCHAR2 := G_PA_MISS_CHAR,
593 P_CI_NUMBER IN VARCHAR2 := G_PA_MISS_CHAR,
594 P_DATE_REQUIRED IN DATE := G_PA_MISS_DATE,
598 P_PRICE_CURRENCY_CODE IN VARCHAR2 := G_PA_MISS_CHAR,
595 P_PRIORITY_CODE IN VARCHAR2 := G_PA_MISS_CHAR,
596 P_EFFORT_LEVEL_CODE IN VARCHAR2 := G_PA_MISS_CHAR,
597 P_PRICE IN NUMBER := G_PA_MISS_NUM,
599 P_SOURCE_TYPE_CODE IN VARCHAR2 := G_PA_MISS_CHAR,
600 P_SOURCE_NUMBER IN VARCHAR2 := G_PA_MISS_CHAR,
601 P_SOURCE_COMMENT IN VARCHAR2 := G_PA_MISS_CHAR,
602 P_SOURCE_DATE_RECEIVED IN DATE := G_PA_MISS_DATE,
603 P_SOURCE_ORGANIZATION IN VARCHAR2 := G_PA_MISS_CHAR,
604 P_SOURCE_PERSON IN VARCHAR2 := G_PA_MISS_CHAR,
605 P_CI_STATUS_CODE IN VARCHAR2 := G_PA_MISS_CHAR,
606 P_STATUS_COMMENT IN VARCHAR2 := G_PA_MISS_CHAR,
607 P_PROGRESS_AS_OF_DATE IN DATE := G_PA_MISS_DATE,
608 P_PROGRESS_STATUS_CODE IN VARCHAR2 := G_PA_MISS_CHAR,
609 P_PROGRESS_OVERVIEW IN VARCHAR2 := G_PA_MISS_CHAR,
610 P_RESOLUTION_CODE IN VARCHAR2 := G_PA_MISS_CHAR,
611 P_RESOLUTION_COMMENT IN VARCHAR2 := G_PA_MISS_CHAR,
612 P_ATTRIBUTE_CATEGORY IN VARCHAR2 := G_PA_MISS_CHAR,
613 P_ATTRIBUTE1 IN VARCHAR2 := G_PA_MISS_CHAR,
614 P_ATTRIBUTE2 IN VARCHAR2 := G_PA_MISS_CHAR,
615 P_ATTRIBUTE3 IN VARCHAR2 := G_PA_MISS_CHAR,
616 P_ATTRIBUTE4 IN VARCHAR2 := G_PA_MISS_CHAR,
617 P_ATTRIBUTE5 IN VARCHAR2 := G_PA_MISS_CHAR,
618 P_ATTRIBUTE6 IN VARCHAR2 := G_PA_MISS_CHAR,
619 P_ATTRIBUTE7 IN VARCHAR2 := G_PA_MISS_CHAR,
620 P_ATTRIBUTE8 IN VARCHAR2 := G_PA_MISS_CHAR,
621 P_ATTRIBUTE9 IN VARCHAR2 := G_PA_MISS_CHAR,
622 P_ATTRIBUTE10 IN VARCHAR2 := G_PA_MISS_CHAR,
623 P_ATTRIBUTE11 IN VARCHAR2 := G_PA_MISS_CHAR,
624 P_ATTRIBUTE12 IN VARCHAR2 := G_PA_MISS_CHAR,
625 P_ATTRIBUTE13 IN VARCHAR2 := G_PA_MISS_CHAR,
626 P_ATTRIBUTE14 IN VARCHAR2 := G_PA_MISS_CHAR,
627 P_ATTRIBUTE15 IN VARCHAR2 := G_PA_MISS_CHAR
628 );
629
630 PROCEDURE UPDATE_CHANGE_ORDER (
631 p_commit IN VARCHAR2 := FND_API.G_FALSE,
632 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
633 p_api_version_number IN NUMBER,
634 x_return_status OUT NOCOPY VARCHAR2,
635 x_msg_count OUT NOCOPY NUMBER,
636 x_msg_data OUT NOCOPY VARCHAR2,
637 p_ci_id IN NUMBER,
638 P_RECORD_VERSION_NUMBER IN NUMBER := G_PA_MISS_NUM,
639 P_SUMMARY IN VARCHAR2 := G_PA_MISS_CHAR,
640 P_DESCRIPTION IN VARCHAR2 := G_PA_MISS_CHAR,
641 P_OWNER_ID IN NUMBER := G_PA_MISS_NUM,
642 P_OWNER_COMMENT IN VARCHAR2 := G_PA_MISS_CHAR,
643 P_CLASSIFICATION_CODE IN NUMBER := G_PA_MISS_NUM,
644 P_REASON_CODE IN NUMBER := G_PA_MISS_NUM,
645 P_OBJECT_ID IN NUMBER := G_PA_MISS_NUM,
646 P_OBJECT_TYPE IN VARCHAR2 := G_PA_MISS_CHAR,
647 P_CI_NUMBER IN VARCHAR2 := G_PA_MISS_CHAR,
648 P_DATE_REQUIRED IN DATE := G_PA_MISS_DATE,
649 P_PRIORITY_CODE IN VARCHAR2 := G_PA_MISS_CHAR,
650 P_EFFORT_LEVEL_CODE IN VARCHAR2 := G_PA_MISS_CHAR,
651 P_PRICE IN NUMBER := G_PA_MISS_NUM,
652 P_PRICE_CURRENCY_CODE IN VARCHAR2 := G_PA_MISS_CHAR,
653 P_SOURCE_TYPE_CODE IN VARCHAR2 := G_PA_MISS_CHAR,
654 P_SOURCE_NUMBER IN VARCHAR2 := G_PA_MISS_CHAR,
655 P_SOURCE_COMMENT IN VARCHAR2 := G_PA_MISS_CHAR,
656 P_SOURCE_DATE_RECEIVED IN DATE := G_PA_MISS_DATE,
657 P_SOURCE_ORGANIZATION IN VARCHAR2 := G_PA_MISS_CHAR,
658 P_SOURCE_PERSON IN VARCHAR2 := G_PA_MISS_CHAR,
659 P_CI_STATUS_CODE IN VARCHAR2 := G_PA_MISS_CHAR,
660 P_STATUS_COMMENT IN VARCHAR2 := G_PA_MISS_CHAR,
661 P_PROGRESS_AS_OF_DATE IN DATE := G_PA_MISS_DATE,
662 P_PROGRESS_STATUS_CODE IN VARCHAR2 := G_PA_MISS_CHAR,
663 P_PROGRESS_OVERVIEW IN VARCHAR2 := G_PA_MISS_CHAR,
664 P_RESOLUTION_CODE IN VARCHAR2 := G_PA_MISS_CHAR,
665 P_RESOLUTION_COMMENT IN VARCHAR2 := G_PA_MISS_CHAR,
666 P_ATTRIBUTE_CATEGORY IN VARCHAR2 := G_PA_MISS_CHAR,
667 P_ATTRIBUTE1 IN VARCHAR2 := G_PA_MISS_CHAR,
668 P_ATTRIBUTE2 IN VARCHAR2 := G_PA_MISS_CHAR,
669 P_ATTRIBUTE3 IN VARCHAR2 := G_PA_MISS_CHAR,
670 P_ATTRIBUTE4 IN VARCHAR2 := G_PA_MISS_CHAR,
674 P_ATTRIBUTE8 IN VARCHAR2 := G_PA_MISS_CHAR,
671 P_ATTRIBUTE5 IN VARCHAR2 := G_PA_MISS_CHAR,
672 P_ATTRIBUTE6 IN VARCHAR2 := G_PA_MISS_CHAR,
673 P_ATTRIBUTE7 IN VARCHAR2 := G_PA_MISS_CHAR,
675 P_ATTRIBUTE9 IN VARCHAR2 := G_PA_MISS_CHAR,
676 P_ATTRIBUTE10 IN VARCHAR2 := G_PA_MISS_CHAR,
677 P_ATTRIBUTE11 IN VARCHAR2 := G_PA_MISS_CHAR,
678 P_ATTRIBUTE12 IN VARCHAR2 := G_PA_MISS_CHAR,
679 P_ATTRIBUTE13 IN VARCHAR2 := G_PA_MISS_CHAR,
680 P_ATTRIBUTE14 IN VARCHAR2 := G_PA_MISS_CHAR,
681 P_ATTRIBUTE15 IN VARCHAR2 := G_PA_MISS_CHAR
682 );
683
684 END PA_CONTROL_API_PUB;