1 PACKAGE CSD_SOO_PVT AS
2 /* $Header: csdvsoos.pls 120.0.12020000.4 2013/03/12 03:55:00 vicli noship $ */
3
4 -- Global Variables
5 C_ERROR CONSTANT VARCHAR2(1) := '2'; -- concurrent manager error code
6 C_WARNING CONSTANT VARCHAR2(1) := '1'; -- concurrent manager warning code
7 C_OK CONSTANT VARCHAR2(1) := '0'; -- concurrent manager success code
8
9 G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_SOO_PVT';
10 G_FILE_NAME CONSTANT VARCHAR2(30) := 'csdvsoos.pls';
11
12 G_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
13 G_CSD_RET_STS_WARNING CONSTANT VARCHAR2(1) := 'W';
14
15 G_MAX_DATE CONSTANT DATE := to_date(5373484, 'J');
16
17 TYPE SO_ORCHESTRATION_KEY_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
18
19 -- Table that keeps track of the primary keys of CSD_SO_ORCHESTRATION
20 -- which have been updated by the MERGE INTO... statements.
21 g_updated_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
22
23 -- Function called from the MERGE INTO... UPDATE SET... statements
24 -- that stores the primary key (orchestration_id) into g_updated_ids
25 function update_count(id IN NUMBER) return varchar2;
26
27 -- Function to return g_updated_ids.
28 function get_updated_ids return JTF_NUMBER_TABLE;
29
30 TYPE NUMBER_HASHTABLE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
31
32 -- Hashtable and procedure that keeps track of the repair_line_ids
33 -- which have RMA / RMA Third Party lines that need to be
34 -- updated in Depot tables.
35 g_rma_ro_line_ids NUMBER_HASHTABLE;
36 procedure update_rma_ro_line_id(id IN NUMBER);
37
38 -- Hashtable and procedure that keeps track of the repair_line_ids
39 -- which have Ship / Ship Third Party lines that need to be
40 -- updated in Depot tables.
41 g_ship_ro_line_ids NUMBER_HASHTABLE;
42 procedure update_ship_ro_line_id(id IN NUMBER);
43
44 -- Hashtable and procedure that keeps track of the order_header_ids
45 -- which have Internal Sales Order / Requisition lines that need to be
46 -- updated in Depot tables.
47 g_int_order_header_ids NUMBER_HASHTABLE;
48 procedure update_int_order_header_id(id IN NUMBER);
49
50 /*-------------------------------------------------------------------------------------*/
51 /* Function name: DEBUG */
52 /* Description : Logs the debug message */
53 /* Called from : Called from Update API */
54 /* */
55 /* STANDARD PARAMETERS */
56 /* In Parameters : */
57 /* p_message Required Debug message that needs to be logged */
58 /* p_mod_name Required Module name */
59 /* p_severity_level Required Severity level */
60 /* Output Parameters: */
61 /* NON-STANDARD PARAMETERS */
62 /* In Parameters */
63 /* Out parameters */
64 /* Change Hist : */
65 /* 09/20/03 vlakaman Initial Creation. */
66 /*-------------------------------------------------------------------------------------*/
67
68 Procedure DEBUG(p_message in varchar2,
69 p_mod_name in varchar2,
70 p_severity_level in number);
71
72 /*--------------------------------------------------*/
73 /* procedure name: Get_Document_Status */
74 /* description : wrapper function of procedure */
75 /* get_document_status so that */
76 /* it can be called from SQL */
77 /*--------------------------------------------------*/
78 Function Get_Document_Status
79 (
80 p_document_type in VARCHAR2,
81 p_status_code in VARCHAR2 := fnd_api.g_miss_char,
82 p_status_id in NUMBER := fnd_api.g_miss_num
83 ) RETURN VARCHAR2;
84
85 /*--------------------------------------------------*/
86 /* procedure name: Get_Document_Status */
87 /* description : procedure to get the status */
88 /* given a document_type and */
89 /* either a document_id or */
90 /* document_code */
91 /*--------------------------------------------------*/
92 Procedure Get_Document_Status(p_document_type in VARCHAR2,
93 p_status_code in VARCHAR2 := FND_API.G_MISS_CHAR,
94 p_status_id in NUMBER := FND_API.G_MISS_NUM,
95 x_status_name out NOCOPY VARCHAR2,
96 p_api_version IN NUMBER,
97 p_commit IN VARCHAR2,
98 p_init_msg_list IN VARCHAR2,
99 p_validation_level IN NUMBER,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2);
103
104
105 /*--------------------------------------------------*/
106 /* procedure name: Refresh_Job */
107 /* description : procedure to load or update */
108 /* CSD_SO_ORCHESTRATION with */
109 /* WIP job data */
110 /*--------------------------------------------------*/
111 PROCEDURE Refresh_Job(p_api_version IN NUMBER,
112 p_commit IN VARCHAR2,
113 p_init_msg_list IN VARCHAR2,
114 p_validation_level IN NUMBER,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118 p_wip_entity_id IN NUMBER := FND_API.G_MISS_NUM,
119 p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
120 p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
121 p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
122 p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
123 p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
124 p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
125 p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
126 p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
127 p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
128
129
130 /*--------------------------------------------------*/
131 /* procedure name: Refresh_SR */
132 /* description : procedure to load or update */
133 /* CSD_SO_ORCHESTRATION with */
134 /* Service Request data */
135 /*--------------------------------------------------*/
136 PROCEDURE Refresh_SR (p_api_version IN NUMBER,
137 p_commit IN VARCHAR2,
138 p_init_msg_list IN VARCHAR2,
139 p_validation_level IN NUMBER,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_incident_id IN NUMBER := FND_API.G_MISS_NUM,
144 p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
145 p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
146 p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
147 p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
148 p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
149 p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
150 p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151 p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
152 p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
153
154 /*--------------------------------------------------*/
155 /* procedure name: Refresh_SR_Task */
156 /* description : procedure to load or update */
157 /* CSD_SO_ORCHESTRATION with */
158 /* Service Request Task data */
159 /*--------------------------------------------------*/
160 PROCEDURE Refresh_SR_Task
161 (p_api_version IN NUMBER,
162 p_commit IN VARCHAR2,
163 p_init_msg_list IN VARCHAR2,
164 p_validation_level IN NUMBER,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168 p_task_id IN NUMBER := FND_API.G_MISS_NUM,
169 p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
173 p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
170 p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
171 p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
172 p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
174 p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
175 p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
176 p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
177 p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
178
179 /*--------------------------------------------------*/
180 /* procedure name: Refresh_Purchase_Req */
181 /* description : procedure to load or update */
182 /* CSD_SO_ORCHESTRATION with */
183 /* Purchase Requisition data */
184 /*--------------------------------------------------*/
185 PROCEDURE Refresh_Purchase_Req
186 (p_api_version IN NUMBER,
187 p_commit IN VARCHAR2,
188 p_init_msg_list IN VARCHAR2,
189 p_validation_level IN NUMBER,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,
194 p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
195 p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
196 p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
197 p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
198 p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
199 p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
200 p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
201 p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
202 p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
203
204 /*--------------------------------------------------*/
205 /* procedure name: Refresh_Internal_Req */
206 /* description : procedure to load or update */
207 /* CSD_SO_ORCHESTRATION with */
208 /* Internal Requisition data */
209 /*--------------------------------------------------*/
210 PROCEDURE Refresh_Internal_Req
211 (p_api_version IN NUMBER,
212 p_commit IN VARCHAR2,
213 p_init_msg_list IN VARCHAR2,
214 p_validation_level IN NUMBER,
215 x_return_status OUT NOCOPY VARCHAR2,
216 x_msg_count OUT NOCOPY NUMBER,
217 x_msg_data OUT NOCOPY VARCHAR2,
218 p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,
219 p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
220 p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
221 p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
222 p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
223 p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
224 p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
225 p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
226 p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
227 p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
228
229 /*--------------------------------------------------*/
230 /* procedure name: Refresh_Int_Sales_Order */
231 /* description : procedure to load or update */
232 /* CSD_SO_ORCHESTRATION with */
233 /* Internal Sales Order data */
234 /*--------------------------------------------------*/
235 PROCEDURE Refresh_Int_Sales_Order
236 (p_api_version IN NUMBER,
237 p_commit IN VARCHAR2,
238 p_init_msg_list IN VARCHAR2,
239 p_validation_level IN NUMBER,
240 x_return_status OUT NOCOPY VARCHAR2,
241 x_msg_count OUT NOCOPY NUMBER,
242 x_msg_data OUT NOCOPY VARCHAR2,
243 p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
244 p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
245 p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
246 p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
247 p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
248 p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
249 p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
250 p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
251 p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
252 p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
253
254 /*--------------------------------------------------*/
255 /* procedure name: Refresh_RMA */
256 /* description : procedure to load or update */
257 /* CSD_SO_ORCHESTRATION with */
258 /* RMA data */
259 /*--------------------------------------------------*/
260 PROCEDURE Refresh_RMA
261 (p_api_version IN NUMBER,
262 p_commit IN VARCHAR2,
263 p_init_msg_list IN VARCHAR2,
267 x_msg_data OUT NOCOPY VARCHAR2,
264 p_validation_level IN NUMBER,
265 x_return_status OUT NOCOPY VARCHAR2,
266 x_msg_count OUT NOCOPY NUMBER,
268 p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
269 p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
270 p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
271 p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
272 p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
273 p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
274 p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
275 p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
276 p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
277 p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
278
279 /*--------------------------------------------------*/
280 /* procedure name: Refresh_RMA_Third_Party */
281 /* description : procedure to load or update */
282 /* CSD_SO_ORCHESTRATION with */
283 /* RMA Third Party data */
284 /*--------------------------------------------------*/
285 PROCEDURE Refresh_RMA_Third_Party
286 (p_api_version IN NUMBER,
287 p_commit IN VARCHAR2,
288 p_init_msg_list IN VARCHAR2,
289 p_validation_level IN NUMBER,
290 x_return_status OUT NOCOPY VARCHAR2,
291 x_msg_count OUT NOCOPY NUMBER,
292 x_msg_data OUT NOCOPY VARCHAR2,
293 p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
294 p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
295 p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
296 p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
297 p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
298 p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
299 p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
300 p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
301 p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
302 p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
303
304 /*--------------------------------------------------*/
305 /* procedure name: Refresh_Ship */
306 /* description : procedure to load or update */
307 /* CSD_SO_ORCHESTRATION with */
308 /* Ship data */
309 /*--------------------------------------------------*/
310 PROCEDURE Refresh_Ship
311 (p_api_version IN NUMBER,
312 p_commit IN VARCHAR2,
313 p_init_msg_list IN VARCHAR2,
314 p_validation_level IN NUMBER,
315 x_return_status OUT NOCOPY VARCHAR2,
316 x_msg_count OUT NOCOPY NUMBER,
317 x_msg_data OUT NOCOPY VARCHAR2,
318 p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
319 p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
320 p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
321 p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
322 p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
323 p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
324 p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
325 p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
326 p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
327 p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
328
329 /*--------------------------------------------------*/
330 /* procedure name: Refresh_Ship_Third_Party */
331 /* description : procedure to load or update */
332 /* CSD_SO_ORCHESTRATION with */
333 /* Ship Third Party data */
334 /*--------------------------------------------------*/
335 PROCEDURE Refresh_Ship_Third_Party
336 (p_api_version IN NUMBER,
337 p_commit IN VARCHAR2,
338 p_init_msg_list IN VARCHAR2,
339 p_validation_level IN NUMBER,
340 x_return_status OUT NOCOPY VARCHAR2,
341 x_msg_count OUT NOCOPY NUMBER,
342 x_msg_data OUT NOCOPY VARCHAR2,
343 p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
344 p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
345 p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
346 p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
347 p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
348 p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
349 p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
350 p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
351 p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
352 p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
353
354 /*--------------------------------------------------*/
355 /* procedure name: Refresh_Delivery */
359 /*--------------------------------------------------*/
356 /* description : procedure to load or update */
357 /* CSD_SO_ORCHESTRATION with */
358 /* Shipping Delivery Line data */
360 PROCEDURE Refresh_Delivery
361 (p_api_version IN NUMBER,
362 p_commit IN VARCHAR2,
363 p_init_msg_list IN VARCHAR2,
364 p_validation_level IN NUMBER,
365 x_return_status OUT NOCOPY VARCHAR2,
366 x_msg_count OUT NOCOPY NUMBER,
367 x_msg_data OUT NOCOPY VARCHAR2,
368 p_delivery_id IN NUMBER := FND_API.G_MISS_NUM,
369 p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
370 p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
371 p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
372 p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
373 p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
374 p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
375 p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
376 p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
377 p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
378
379 /*--------------------------------------------------------------------------*/
380 /* procedure name: Refresh */
381 /* description : procedure to load or update */
382 /* CSD_SO_ORCHESTRATION */
383 /* p_so_orchestration_key_tbl An array of primary keys (orchestration_id) */
384 /* for CSD_SO_ORCHESTRATION table */
385 /* to refresh those specified documents. This is */
386 /* called from the Refresh button on the SOO OAF */
387 /* page using 'Select' checkboxes. */
388 /* p_repair_line_id To use Repair Number as a filter on which documents */
389 /* to update in the concurrent program. */
390 /* p_document_type To use Document Type as a filter on which documents */
391 /* to update in the concurrent program. */
392 /* p_operating_unit_id To use Document Operating Unit as a filter on which */
393 /* documents to update in the concurrent program. */
394 /* p_inventory_org_id To use Document Inventory Org as a filter on which */
395 /* documents to update in the concurrent program. */
396 /* p_repair_owner_id To use Repair Owner as a filter on which documents */
397 /* to update in the concurrent program. */
398 /* p_ro_status_id To use RO Status as a filter on which documents to */
399 /* update in the concurrent program. */
400 /* p_repair_type_id To use Repair Type as a filter on which documents */
401 /* to update in the concurrent program. */
402 /* p_ro_priority_code To use RO Priority Code as a filter on which */
403 /* documents to update in the concurrent program. */
404 /* p_ro_age To use 'RO age less than this number of days' as a */
405 /* filter on which documents to update in the */
406 /* concurrent program. */
407 /* p_ro_due_date_age To use 'RO promise date / due date less than this */
408 /* number of days away' as a filter on which documents */
409 /* to update in the concurrent program. */
410 /*--------------------------------------------------------------------------*/
411 PROCEDURE Refresh(p_api_version IN NUMBER,
412 p_commit IN VARCHAR2,
413 p_init_msg_list IN VARCHAR2,
414 p_validation_level IN NUMBER,
415 x_return_status OUT NOCOPY VARCHAR2,
416 x_msg_count OUT NOCOPY NUMBER,
417 x_msg_data OUT NOCOPY VARCHAR2,
418 p_so_orchestration_key_tbl IN so_orchestration_key_tbl_type,
419 p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
420 p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
421 p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
422 p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
423 p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
424 p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
425 p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
426 p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
427 p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
428 p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
429
430 /*--------------------------------------------------------------------------*/
431 /* procedure name: Soo_Bi_Driver_Main */
432 /* description : main procedure of */
433 /* concurrent program */
434 /* Note: If no filters are specified, then all documents are refreshed. */
435 /* errbuf Standard concurrent program argument. */
436 /* retcode Standard concurrent program argument. */
437 /* p_repair_line_id To use Repair Number as a filter on which documents */
438 /* to update in the concurrent program. */
439 /* p_document_type To use Document Type as a filter on which documents */
440 /* to update in the concurrent program. */
441 /* p_operating_unit_id To use Document Operating Unit as a filter on which */
442 /* documents to update in the concurrent program. */
443 /* p_inventory_org_id To use Document Inventory Org as a filter on which */
444 /* documents to update in the concurrent program. */
445 /* p_repair_owner_id To use Repair Owner as a filter on which documents */
446 /* to update in the concurrent program. */
447 /* p_ro_status_id To use RO Status as a filter on which documents to */
448 /* update in the concurrent program. */
449 /* p_repair_type_id To use Repair Type as a filter on which documents */
450 /* to update in the concurrent program. */
451 /* p_ro_priority_code To use RO Priority Code as a filter on which */
452 /* documents to update in the concurrent program. */
453 /* p_ro_age To use 'RO age less than this number of days' as a */
454 /* filter on which documents to update in the */
455 /* concurrent program. */
456 /* p_ro_due_date_age To use 'RO promise date / due date less than this */
457 /* number of days away' as a filter on which documents */
458 /* to update in the concurrent program. */
459 /*--------------------------------------------------------------------------*/
460
461 PROCEDURE Soo_Driver_Main (errbuf OUT NOCOPY VARCHAR2,
462 retcode OUT NOCOPY VARCHAR2,
463 p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
464 p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
465 p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
466 p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
467 p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
468 p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
469 p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
470 p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
471 p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
472 p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
473
474 END CSD_SOO_PVT;