1 Package CSD_UPDATE_PROGRAMS_PVT AUTHID CURRENT_USER as
2 /* $Header: csddrcls.pls 120.3 2008/04/12 01:25:38 takwong ship $ */
3
4 /*-------------------------------------------------------------------------------------*/
5 /* Name : Activity_rec_type */
6 /* Package name : csd_update_programs_pvt */
7 /* Type : type definition, private */
8 /* Description : Record to hold information about the activity */
9 /*-------------------------------------------------------------------------------------*/
10
11 TYPE Activity_Rec_Type IS RECORD
12 ( REPAIR_HISTORY_ID csd_repair_history.REPAIR_HISTORY_ID%type,
13 REPAIR_LINE_ID csd_repair_history.REPAIR_LINE_ID%type,
14 REQUEST_ID csd_repair_history.REQUEST_ID%type,
15 PROGRAM_ID csd_repair_history.PROGRAM_ID%type,
16 PROGRAM_APPLICATION_ID csd_repair_history.PROGRAM_APPLICATION_ID%type,
17 PROGRAM_UPDATE_DATE csd_repair_history.PROGRAM_UPDATE_DATE%type,
18 EVENT_CODE csd_repair_history.EVENT_CODE%type,
19 ACTION_CODE NUMBER,
20 EVENT_DATE csd_repair_history.EVENT_DATE%type,
21 QUANTITY csd_repair_history.QUANTITY%type,
22 PARAMN1 csd_repair_history.PARAMN1%type,
23 PARAMN2 csd_repair_history.PARAMN2%type,
24 PARAMN3 csd_repair_history.PARAMN3%type,
25 PARAMN4 csd_repair_history.PARAMN4%type,
26 PARAMN5 csd_repair_history.PARAMN5%type,
27 PARAMN6 csd_repair_history.PARAMN6%type,
28 PARAMN7 csd_repair_history.PARAMN7%type,
29 PARAMN8 csd_repair_history.PARAMN8%type,
30 PARAMN9 csd_repair_history.PARAMN9%type,
31 PARAMN10 csd_repair_history.PARAMN10%type,
32 PARAMC1 csd_repair_history.PARAMC1%type,
33 PARAMC2 csd_repair_history.PARAMC2%type,
34 PARAMC3 csd_repair_history.PARAMC3%type,
35 PARAMC4 csd_repair_history.PARAMC4%type,
36 PARAMC5 csd_repair_history.PARAMC5%type,
37 PARAMC6 csd_repair_history.PARAMC6%type,
38 PARAMC7 csd_repair_history.PARAMC7%type,
39 PARAMC8 csd_repair_history.PARAMC8%type,
40 PARAMC9 csd_repair_history.PARAMC9%type,
41 PARAMC10 csd_repair_history.PARAMC10%type,
42 PARAMD1 csd_repair_history.PARAMD1%type,
43 PARAMD2 csd_repair_history.PARAMD2%type,
44 PARAMD3 csd_repair_history.PARAMD3%type,
45 PARAMD4 csd_repair_history.PARAMD4%type,
46 PARAMD5 csd_repair_history.PARAMD5%type,
47 PARAMD6 csd_repair_history.PARAMD6%type,
48 PARAMD7 csd_repair_history.PARAMD7%type,
49 PARAMD8 csd_repair_history.PARAMD8%type,
50 PARAMD9 csd_repair_history.PARAMD9%type,
51 PARAMD10 csd_repair_history.PARAMD10%type,
52 ATTRIBUTE_CATEGORY csd_repair_history.ATTRIBUTE_CATEGORY%type,
53 ATTRIBUTE1 csd_repair_history.ATTRIBUTE1%type,
54 ATTRIBUTE2 csd_repair_history.ATTRIBUTE2%type,
55 ATTRIBUTE3 csd_repair_history.ATTRIBUTE3%type,
56 ATTRIBUTE4 csd_repair_history.ATTRIBUTE4%type,
57 ATTRIBUTE5 csd_repair_history.ATTRIBUTE5%type,
58 ATTRIBUTE6 csd_repair_history.ATTRIBUTE6%type,
59 ATTRIBUTE7 csd_repair_history.ATTRIBUTE7%type,
60 ATTRIBUTE8 csd_repair_history.ATTRIBUTE8%type,
61 ATTRIBUTE9 csd_repair_history.ATTRIBUTE9%type,
62 ATTRIBUTE10 csd_repair_history.ATTRIBUTE10%type,
63 ATTRIBUTE11 csd_repair_history.ATTRIBUTE11%type,
64 ATTRIBUTE12 csd_repair_history.ATTRIBUTE12%type,
65 ATTRIBUTE13 csd_repair_history.ATTRIBUTE13%type,
66 ATTRIBUTE14 csd_repair_history.ATTRIBUTE14%type,
67 ATTRIBUTE15 csd_repair_history.ATTRIBUTE15%type,
68 OBJECT_VERSION_NUMBER csd_repair_history.OBJECT_VERSION_NUMBER%type
69 );
70
71 -- Define a record of type Activity_Rec_Type
72 activity_rec Activity_Rec_Type;
73
74 /*-------------------------------------------------------------------------------------*/
75 /* Procedure name: Convert_to_RO_uom */
76 /* Description : Procedure to convert the qty into Repair Order UOM */
77 /* Logistics lines could be created with different UOM than the one on */
78 /* repair order */
79 /* Called from : Called from Update API (SO_RCV_UPDATE,SO_SHIP_UPDATE) */
80 /* */
81 /* STANDARD PARAMETERS */
82 /* In Parameters : */
83 /* */
84 /* Output Parameters: */
85 /* x_return_status VARCHAR2 Return status of the API */
86 /* */
87 /* NON-STANDARD PARAMETERS */
88 /* In Parameters */
89 /* p_to_uom_code VARCHAR2 Required RO Unit of measure */
90 /* p_item_id NUMBER Required Inventory Item Id */
91 /* p_from_uom VARCHAR2 Conditionaly Required Needed for receiving lines */
92 /* p_from_uom_code VARCHAR2 Conditionaly Required Needed for shipping lines */
93 /* p_from_quantity NUMBER Required Transaction quantity */
94 /* Out parameters */
95 /* x_result_quantity NUMBER converted qty in Repair Order UOM */
96 /* */
97 /* Change Hist : */
98 /* 09/20/03 vlakaman Initial Creation. */
99 /*-------------------------------------------------------------------------------------*/
100
101 Procedure CONVERT_TO_RO_UOM
102 (x_return_status OUT NOCOPY VARCHAR2,
103 p_to_uom_code IN varchar2,
104 p_item_id IN NUMBER,
105 p_from_uom IN varchar2,
106 p_from_uom_code IN varchar2,
107 p_from_quantity IN number,
108 x_result_quantity OUT NOCOPY number );
109
110 /*-------------------------------------------------------------------------------------*/
111 /* Procedure name: LOG_ACTIVITY */
112 /* Description : Procedure called for logging activity */
113 /* */
114 /* Called from : Called from all the api */
115 /* STANDARD PARAMETERS */
116 /* In Parameters : */
117 /* p_api_version NUMBER Required Api Version number */
118 /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
119 /* p_commit VARCHAR2 Optional Commits in API */
120 /* p_validation_level NUMBER Optional validation level */
121 /* */
122 /* Output Parameters: */
123 /* x_return_status VARCHAR2 Return status of the API */
124 /* x_msg_count NUMBER Number of messages in stack */
125 /* x_msg_data VARCHAR2 Error Message from message stack */
126 /* */
127 /* NON-STANDARD PARAMETERS */
128 /* In Parameters */
129 /* p_activity_rec RECORD TYPE Activity record type */
130 /* Output Parameter : */
131 /* Change Hist : */
132 /* 09/20/03 vlakaman Initial Creation. */
133 /*-------------------------------------------------------------------------------------*/
134
135 Procedure LOG_ACTIVITY
136 ( 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_activity_rec IN activity_rec_type );
144
145
146 /*-------------------------------------------------------------------------------------*/
147 /* Procedure name: JOB_COMPLETION_UPDATE */
148 /* Description : Procedure called from wip_update API to update the completed qty */
149 /* It also logs activity for the job completion */
150 /* Called from : Called from WIP_Update API */
151 /* STANDARD PARAMETERS */
152 /* In Parameters : */
153 /* p_api_version NUMBER Required Api Version number */
154 /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
155 /* p_commit VARCHAR2 Optional Commits in API */
156 /* p_validation_level NUMBER Optional validation level */
157 /* */
158 /* Output Parameters: */
159 /* x_return_status VARCHAR2 Return status of the API */
160 /* x_msg_count NUMBER Number of messages in stack */
161 /* x_msg_data VARCHAR2 Error Message from message stack */
162 /* */
163 /* NON-STANDARD PARAMETERS */
164 /* In Parameters */
165 /* p_repair_line_id NUMBER Optional Repair Order Line Id */
166 /* Output Parm : */
167 /* Change Hist : */
168 /* 09/20/03 vlakaman Initial Creation. */
169 /*-------------------------------------------------------------------------------------*/
170
171 Procedure JOB_COMPLETION_UPDATE
172 ( p_api_version IN NUMBER,
173 p_commit IN VARCHAR2,
174 p_init_msg_list IN VARCHAR2,
175 p_validation_level IN NUMBER,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2,
179 p_repair_line_id IN NUMBER );
180
181 /*-------------------------------------------------------------------------------------*/
182 /* Procedure name: JOB_CREATION_UPDATE */
183 /* Description : Procedure called from wip_update API to update the wip entity Id */
184 /* for the new jobs created by the WIP Mass Load concurrent program */
185 /* Called from : Called from WIP_Update API */
186 /* STANDARD PARAMETERS */
187 /* In Parameters : */
188 /* p_api_version NUMBER Required Api Version number */
189 /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
190 /* p_commit VARCHAR2 Optional Commits in API */
191 /* p_validation_level NUMBER Optional validation level */
192 /* */
193 /* Output Parameters: */
194 /* x_return_status VARCHAR2 Return status of the API */
195 /* x_msg_count NUMBER Number of messages in stack */
196 /* x_msg_data VARCHAR2 Error Message from message stack */
197 /* */
198 /* NON-STANDARD PARAMETERS */
199 /* In Parameters */
200 /* p_repair_line_id NUMBER Optional Repair Order Line Id */
201 /* Output Parm : */
202 /* Change Hist : */
203 /* 09/20/03 vlakaman Initial Creation. */
204 /* */
205 /*-------------------------------------------------------------------------------------*/
206
207 Procedure JOB_CREATION_UPDATE
208 ( p_api_version IN NUMBER,
209 p_commit IN VARCHAR2,
210 p_init_msg_list IN VARCHAR2,
211 p_validation_level IN NUMBER,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2,
215 p_repair_line_id IN NUMBER );
216
217 /*-------------------------------------------------------------------------------------*/
218 /* Procedure name: RECEIPTS_UPDATE */
219 /* Description : Procedure called from the UI to update the depot tables */
220 /* for the receipts against RMA/Internal Requisitions. It calls */
221 /* RMA_RCV_UPDATE and IO_RCV_UPDATE to process RMA and IO respectively */
222 /* Called from : Called from Depot Repair UI */
226 /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
223 /* STANDARD PARAMETERS */
224 /* In Parameters : */
225 /* p_api_version NUMBER Required Api Version number */
227 /* p_commit VARCHAR2 Optional Commits in API */
228 /* p_validation_level NUMBER Optional validation level */
229 /* */
230 /* Output Parameters: */
231 /* x_return_status VARCHAR2 Return status of the API */
232 /* x_msg_count NUMBER Number of messages in stack */
233 /* x_msg_data VARCHAR2 Error Message from message stack */
234 /* */
235 /* NON-STANDARD PARAMETERS */
236 /* In Parameters */
237 /* p_order_header_id NUMBER Optional Interal sales order Id */
238 /* p_internal_order_flag VARCHAR2 Required Order Type; Possible values -'Y','N' */
239 /* p_repair_line_id NUMBER Optional Repair Order Line Id */
240 /* Output Parm : */
241 /* Change Hist : */
242 /* 09/20/03 vlakaman Initial Creation. */
243 /*-------------------------------------------------------------------------------------*/
244
245 Procedure RECEIPTS_UPDATE
246 ( p_api_version IN NUMBER,
247 p_commit IN VARCHAR2,
248 p_init_msg_list IN VARCHAR2,
249 p_validation_level IN NUMBER,
250 x_return_status OUT NOCOPY VARCHAR2,
251 x_msg_count OUT NOCOPY NUMBER,
252 x_msg_data OUT NOCOPY VARCHAR2,
253 p_internal_order_flag IN VARCHAR2,
254 p_order_header_id IN NUMBER,
255 p_repair_line_id IN NUMBER,
256 p_past_num_of_days IN NUMBER DEFAULT NULL); --bug#6753684, 6742512
257
258 /*-------------------------------------------------------------------------------------*/
259 /* Procedure name: RMA_RCV_UPDATE */
260 /* Description : Procedure called from the update API to update the depot tables */
261 /* for the receipts against RMA. It also logs activities for accept */
262 /* reject txn lines */
263 /* Called from : Called from RECEIPTS_UPDATE API */
264 /* STANDARD PARAMETERS */
265 /* In Parameters : */
266 /* p_api_version NUMBER Required Api Version number */
267 /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
268 /* p_commit VARCHAR2 Optional Commits in API */
269 /* p_validation_level NUMBER Optional validation level */
270 /* */
271 /* Output Parameters: */
272 /* x_return_status VARCHAR2 Return status of the API */
273 /* x_msg_count NUMBER Number of messages in stack */
274 /* x_msg_data VARCHAR2 Error Message from message stack */
275 /* */
276 /* NON-STANDARD PARAMETERS */
277 /* In Parameters */
278 /* p_repair_line_id NUMBER Optional Repair Order Line Id */
279 /* Output Parm : */
280 /* Change Hist : */
281 /* 09/20/03 vlakaman Initial Creation. */
282 /*-------------------------------------------------------------------------------------*/
283
284 Procedure RMA_RCV_UPDATE
285 ( p_api_version IN NUMBER,
286 p_commit IN VARCHAR2,
287 p_init_msg_list IN VARCHAR2,
288 p_validation_level IN NUMBER,
289 x_return_status OUT NOCOPY VARCHAR2,
290 x_msg_count OUT NOCOPY NUMBER,
291 x_msg_data OUT NOCOPY VARCHAR2,
292 p_repair_line_id IN NUMBER,
293 p_past_num_of_days IN NUMBER DEFAULT NULL); --bug#6753684, 6742512
294
295
296 /*-------------------------------------------------------------------------------------*/
297 /* Procedure name: IO_RCV_UPDATE */
298 /* Description : Procedure called from the Update api to update the depot tables */
299 /* for the receipts against Internal Requisitions */
300 /* It also logs activities for accept reject txn lines */
304 /* p_api_version NUMBER Required Api Version number */
301 /* Called from : Called from RECEIPTS_UPDATE API */
302 /* STANDARD PARAMETERS */
303 /* In Parameters : */
305 /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
306 /* p_commit VARCHAR2 Optional Commits in API */
307 /* p_validation_level NUMBER Optional validation level */
308 /* */
309 /* Output Parameters: */
310 /* x_return_status VARCHAR2 Return status of the API */
311 /* x_msg_count NUMBER Number of messages in stack */
312 /* x_msg_data VARCHAR2 Error Message from message stack */
313 /* */
314 /* NON-STANDARD PARAMETERS */
315 /* In Parameters */
316 /* p_order_header_id NUMBER Optional Interal sales order Id */
317 /* Output Parm : */
318 /* Change Hist : */
319 /* 09/20/03 vlakaman Initial Creation. */
320 /*-------------------------------------------------------------------------------------*/
321
322 Procedure IO_RCV_UPDATE
323 ( p_api_version IN NUMBER,
324 p_commit IN VARCHAR2,
325 p_init_msg_list IN VARCHAR2,
326 p_validation_level IN NUMBER,
327 x_return_status OUT NOCOPY VARCHAR2,
328 x_msg_count OUT NOCOPY NUMBER,
329 x_msg_data OUT NOCOPY VARCHAR2,
330 p_order_header_id IN NUMBER );
331
332 /*-------------------------------------------------------------------------------------*/
333 /* Procedure name: IO_RCV_UPDATE_MOVE_OUT */
334 /* Description : Procedure called from the Update api to update the depot tables */
335 /* for the receipts against Internal Requisitions for move out line */
336 /* It also logs activities for accept reject txn lines */
337 /* Called from : Called from SHIP_UPDATE API */
338 /* STANDARD PARAMETERS */
339 /* In Parameters : */
340 /* p_api_version NUMBER Required Api Version number */
341 /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
342 /* p_commit VARCHAR2 Optional Commits in API */
343 /* p_validation_level NUMBER Optional validation level */
344 /* */
345 /* Output Parameters: */
346 /* x_return_status VARCHAR2 Return status of the API */
347 /* x_msg_count NUMBER Number of messages in stack */
348 /* x_msg_data VARCHAR2 Error Message from message stack */
349 /* */
350 /* NON-STANDARD PARAMETERS */
351 /* In Parameters */
352 /* p_order_header_id NUMBER Optional Internal sales order Id */
353 /* Output Parm : */
354 /* Change Hist : */
355 /* 24-Apr-2007 swai Initial Creation. Bug#5564180 /FP# 5845995 */
356 /*-------------------------------------------------------------------------------------*/
357
358 Procedure IO_RCV_UPDATE_MOVE_OUT
359 ( p_api_version IN NUMBER,
360 p_commit IN VARCHAR2,
361 p_init_msg_list IN VARCHAR2,
362 p_validation_level IN NUMBER,
363 x_return_status OUT NOCOPY VARCHAR2,
364 x_msg_count OUT NOCOPY NUMBER,
365 x_msg_data OUT NOCOPY VARCHAR2,
366 p_order_header_id IN NUMBER );
367
368 /*-------------------------------------------------------------------------------------*/
369 /* Procedure name: SHIP_UPDATE */
370 /* Description : Procedure called from the UI to update the depot tables */
371 /* for the shipment against regular sales order/Internal Sales Order */
372 /* It calls SO_SHIP_UPDATE and IO_SHIP_UPDATE to process sales order */
373 /* and internal sales order */
374 /* Called from : Called from Depot Repair UI */
375 /* STANDARD PARAMETERS */
376 /* In Parameters : */
380 /* p_validation_level NUMBER Optional validation level */
377 /* p_api_version NUMBER Required Api Version number */
378 /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
379 /* p_commit VARCHAR2 Optional Commits in API */
381 /* */
382 /* Output Parameters: */
383 /* x_return_status VARCHAR2 Return status of the API */
384 /* x_msg_count NUMBER Number of messages in stack */
385 /* x_msg_data VARCHAR2 Error Message from message stack */
386 /* */
387 /* NON-STANDARD PARAMETERS */
388 /* In Parameters */
389 /* p_order_header_id NUMBER Optional Interal sales order Id */
390 /* p_internal_order_flag VARCHAR2 Required Order Type; Possible values -'Y','N' */
391 /* p_repair_line_id NUMBER Optional Repair Order Line Id */
392 /* Output Parm : */
393 /* Change Hist : */
394 /* 09/20/03 vlakaman Initial Creation. */
395 /*-------------------------------------------------------------------------------------*/
396
397 Procedure SHIP_UPDATE
398 ( p_api_version IN NUMBER,
399 p_commit IN VARCHAR2,
400 p_init_msg_list IN VARCHAR2,
401 p_validation_level IN NUMBER,
402 x_return_status OUT NOCOPY VARCHAR2,
403 x_msg_count OUT NOCOPY NUMBER,
404 x_msg_data OUT NOCOPY VARCHAR2,
405 p_internal_order_flag IN VARCHAR2,
406 p_order_header_id IN NUMBER,
407 p_repair_line_id IN NUMBER,
408 p_past_num_of_days IN NUMBER DEFAULT NULL); --bug#6753684, 6742512
409
410 /*-------------------------------------------------------------------------------------*/
411 /* Procedure name: SO_SHIP_UPDATE */
412 /* Description : Procedure called from the Update api to update the depot tables */
413 /* for the shipment against sales order */
414 /* It also logs activities for the deliver txn lines */
415 /* Called from : Called from RECEIPTS_UPDATE API */
416 /* STANDARD PARAMETERS */
417 /* In Parameters : */
418 /* p_api_version NUMBER Required Api Version number */
419 /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
420 /* p_commit VARCHAR2 Optional Commits in API */
421 /* p_validation_level NUMBER Optional validation level */
422 /* */
423 /* Output Parameters: */
424 /* x_return_status VARCHAR2 Return status of the API */
425 /* x_msg_count NUMBER Number of messages in stack */
426 /* x_msg_data VARCHAR2 Error Message from message stack */
427 /* */
428 /* NON-STANDARD PARAMETERS */
429 /* In Parameters */
430 /* p_repair_line_id NUMBER Optional Repair Order Line Id */
431 /* Output Parm : */
432 /* Change Hist : */
433 /* 09/20/03 vlakaman Initial Creation. */
434 /*-------------------------------------------------------------------------------------*/
435
436 Procedure SO_SHIP_UPDATE
437 ( p_api_version IN NUMBER,
438 p_commit IN VARCHAR2,
439 p_init_msg_list IN VARCHAR2,
440 p_validation_level IN NUMBER,
441 x_return_status OUT NOCOPY VARCHAR2,
442 x_msg_count OUT NOCOPY NUMBER,
443 x_msg_data OUT NOCOPY VARCHAR2,
444 p_repair_line_id IN NUMBER,
445 p_past_num_of_days IN NUMBER DEFAULT NULL); --bug#6753684, 6742512
446
447 /*-------------------------------------------------------------------------------------*/
448 /* Procedure name: IO_SHIP_UPDATE */
449 /* Description : Procedure called from the Update api to update the depot tables */
450 /* for the shipment against Internal sales order */
451 /* It also logs activities for the deliver txn lines */
452 /* Called from : Called from RECEIPTS_UPDATE API */
453 /* STANDARD PARAMETERS */
457 /* p_commit VARCHAR2 Optional Commits in API */
454 /* In Parameters : */
455 /* p_api_version NUMBER Required Api Version number */
456 /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
458 /* p_validation_level NUMBER Optional validation level */
459 /* */
460 /* Output Parameters: */
461 /* x_return_status VARCHAR2 Return status of the API */
462 /* x_msg_count NUMBER Number of messages in stack */
463 /* x_msg_data VARCHAR2 Error Message from message stack */
464 /* */
465 /* NON-STANDARD PARAMETERS */
466 /* In Parameters */
467 /* p_order_header_id NUMBER Optional Interal sales order Id */
468 /* Output Parm : */
469 /* Change Hist : */
470 /* 09/20/03 vlakaman Initial Creation. */
471 /*-------------------------------------------------------------------------------------*/
472
473 Procedure IO_SHIP_UPDATE
474 ( p_api_version IN NUMBER,
475 p_commit IN VARCHAR2,
476 p_init_msg_list IN VARCHAR2,
477 p_validation_level IN NUMBER,
478 x_return_status OUT NOCOPY VARCHAR2,
479 x_msg_count OUT NOCOPY NUMBER,
480 x_msg_data OUT NOCOPY VARCHAR2,
481 p_order_header_id IN NUMBER );
482
483 /*-------------------------------------------------------------------------------------*/
484 /* Procedure name: WIP_UPDATE */
485 /* Description : Procedure called from the UI to update the depot tables */
486 /* for the WIP Job creation/Completion */
487 /* */
488 /* Called from : Called from Depot Repair UI */
489 /* STANDARD PARAMETERS */
490 /* In Parameters : */
491 /* p_api_version NUMBER Required Api Version number */
492 /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
493 /* p_commit VARCHAR2 Optional Commits in API */
494 /* p_validation_level NUMBER Optional validation level */
495 /* */
496 /* Output Parameters: */
497 /* x_return_status VARCHAR2 Return status of the API */
498 /* x_msg_count NUMBER Number of messages in stack */
499 /* x_msg_data VARCHAR2 Error Message from message stack */
500 /* */
501 /* NON-STANDARD PARAMETERS */
502 /* In Parameters */
503 /* p_upd_job_completion Required Order Type; Possible values -'Y','N' */
504 /* p_repair_line_id NUMBER Optional Repair Order Line Id */
505 /* Output Parm : */
506 /* Change Hist : */
507 /* 09/20/03 vlakaman Initial Creation. */
508 /*-------------------------------------------------------------------------------------*/
509
510 Procedure WIP_UPDATE
511 ( p_api_version IN NUMBER,
512 p_commit IN VARCHAR2,
513 p_init_msg_list IN VARCHAR2,
514 p_validation_level IN NUMBER,
515 x_return_status OUT NOCOPY VARCHAR2,
516 x_msg_count OUT NOCOPY NUMBER,
517 x_msg_data OUT NOCOPY VARCHAR2,
518 p_upd_job_completion IN VARCHAR2,
519 p_repair_line_id IN NUMBER );
520
521 /*-------------------------------------------------------------------------------------*/
522 /* Procedure name: RECEIPTS_UPDATE_CONC_PROG */
523 /* Description : Procedure called by concurrent program to update the depot tables */
524 /* for the receipts against RMA/Internal Requisitions */
525 /* */
526 /* Called from : Called from Receipt update concurrent program */
527 /* STANDARD PARAMETERS */
528 /* In Parameters : */
529 /* */
530 /* Output Parameters: */
534 /* NON-STANDARD PARAMETERS */
531 /* errbuf VARCHAR2 Error message */
532 /* retcode VARCHAR2 Error Code */
533 /* */
535 /* In Parameters */
536 /* p_order_type VARCHAR2 Required Order Type; Possible values- 'I','E' */
537 /* p_order_header_id NUMBER Optional Internal sales Order Id */
538 /* p_repair_line_id NUMBER Optional Repair Order Line Id */
539 /* Output Parm : */
540 /* Change Hist : */
541 /* 09/20/03 vlakaman Initial Creation. */
542 /*-------------------------------------------------------------------------------------*/
543
544 Procedure RECEIPTS_UPDATE_CONC_PROG
545 (errbuf OUT NOCOPY varchar2,
546 retcode OUT NOCOPY varchar2,
547 p_order_type IN varchar2,
548 p_order_header_id IN number,
549 p_repair_line_id IN number,
550 p_past_num_of_days IN number DEFAULT NULL); --bug#6753684, 6742512
551
552 /*-------------------------------------------------------------------------------------*/
553 /* Procedure name: WIP_UPDATE_CONC_PROG */
554 /* Description : Procedure called by concurrent program to update the depot tables */
555 /* for the WIP Job Creation/ Completion */
556 /* */
557 /* Called from : Called from Wip Update Concurrent Program */
558 /* STANDARD PARAMETERS */
559 /* In Parameters : */
560 /* */
561 /* Output Parameters: */
562 /* errbuf VARCHAR2 Error message */
563 /* retcode VARCHAR2 Error Code */
564 /* */
565 /* NON-STANDARD PARAMETERS */
566 /* In Parameters */
567 /* p_upd_job_completion Required Order Type; Possible values -'Y','N' */
568 /* p_repair_line_id NUMBER Optional Repair Order Line Id */
569 /* Output Parm : */
570 /* Change Hist : */
571 /* 09/20/03 vlakaman Initial Creation. */
572 /*-------------------------------------------------------------------------------------*/
573
574 Procedure WIP_UPDATE_CONC_PROG
575 (errbuf OUT NOCOPY varchar2,
576 retcode OUT NOCOPY varchar2,
577 p_repair_line_id IN number,
578 p_upd_job_completion IN varchar2);
579
580 /*-------------------------------------------------------------------------------------*/
581 /* Procedure name: SHIP_UPDATE_CONC_PROG */
582 /* Description : Procedure called by concurrent program to update the depot tables */
583 /* for the shipment against Sales order/Internal Sales Order */
584 /* */
585 /* Called from : Called from Receipt update concurrent program */
586 /* STANDARD PARAMETERS */
587 /* In Parameters : */
588 /* */
589 /* Output Parameters: */
590 /* errbuf VARCHAR2 Error message */
591 /* retcode VARCHAR2 Eeror Code */
592 /* */
593 /* NON-STANDARD PARAMETERS */
594 /* In Parameters */
595 /* p_order_type VARCHAR2 Required Order Type; Possible values- 'I','E' */
596 /* p_order_header_id NUMBER Optional Internal sales Order Id */
597 /* p_repair_line_id NUMBER Optional Repair Order Line Id */
598 /* Output Parm : */
599 /* Change Hist : */
600 /* 09/20/03 vlakaman Initial Creation. */
601 /*-------------------------------------------------------------------------------------*/
602
603 Procedure SHIP_UPDATE_CONC_PROG
604 (errbuf OUT NOCOPY varchar2,
605 retcode OUT NOCOPY varchar2,
606 p_order_type IN varchar2,
610
607 p_order_header_id IN number,
608 p_repair_line_id IN number,
609 p_past_num_of_days IN number DEFAULT NULL); --bug#6753684, 6742512
611 /*-------------------------------------------------------------------------------------*/
612 /* Procedure name: TASK_UPDATE_CONC_PROG */
613 /* Description : Procedure called by concurrent program to update the depot tables */
614 /* for the task creation and update */
615 /* */
616 /* */
617 /* Called from : Called from Task Update concurrent program */
618 /* STANDARD PARAMETERS */
619 /* In Parameters : */
620 /* */
621 /* Output Parameters: */
622 /* errbuf VARCHAR2 Error message */
623 /* retcode VARCHAR2 Error Code */
624 /* */
625 /* NON-STANDARD PARAMETERS */
626 /* In Parameters */
627 /* p_repair_line_id NUMBER Optional Repair Order Line Id */
628 /* Output Parm : */
629 /* Change Hist : */
630 /* 09/20/03 vlakaman Changed the API name and logic remains same */
631 /*-------------------------------------------------------------------------------------*/
632
633 Procedure TASK_UPDATE_CONC_PROG
634 (errbuf OUT NOCOPY varchar2,
635 retcode OUT NOCOPY varchar2,
636 p_repair_line_id IN number);
637
638 /*-------------------------------------------------------------------------------------*/
639 /* Procedure name: PROD_TXN_STATUS_UPD */
640 /* Description : Procedure called to update all the logistics lines status to booked */
641 /* */
642 /* */
643 /* Called from : csd_process_pvt and CSDREPLN.pld */
644 /* STANDARD PARAMETERS */
645 /* In Parameters : */
646 /* */
647 /* Output Parameters: */
648 /* */
649 /* NON-STANDARD PARAMETERS */
650 /* In Parameters */
651 /* p_repair_line_id NUMBER */
652 /* p_commit VARCHAR2 */
653 /* Output Parm : */
654 /* Change Hist : */
655 /* 12/20/04 mshirkol Initial Creation. Fix for bug#4020651 */
656 /*-------------------------------------------------------------------------------------*/
657
658 Procedure PROD_TXN_STATUS_UPD(p_repair_line_id in number,
659 p_commit in varchar2);
660
661
662 /*-------------------------------------------------------------------------------------*/
663 /* Procedure name: UPDATE_LOGISTIC_STATUS_WF */
664 /* Description : Procedure called from workflow process to update logistics */
665 /* line status */
666 /* */
667 /* Called from : Workflow */
668 /* PARAMETERS */
669 /* IN */
670 /* */
671 /* itemtype - type of the current item */
672 /* itemkey - key of the current item */
673 /* actid - process activity instance id */
674 /* funcmode - function execution mode ('RUN', 'CANCEL', 'TIMEOUT', ...) */
675 /* OUT */
676 /* result */
677 /* - COMPLETE[:<result>] */
678 /* activity has completed with the indicated result */
679 /* - WAITING */
680 /* activity is waiting for additional transitions */
681 /* - DEFERED */
682 /* execution should be defered to background */
683 /* - NOTIFIED[:<notification_id>:<assigned_user>] */
684 /* activity has notified an external entity that this */
685 /* step must be performed. A call to wf_engine.CompleteActivty */
686 /* will signal when this step is complete. Optional */
687 /* return of notification ID and assigned user. */
688 /* - ERROR[:<error_code>] */
689 /* function encountered an error. */
690 /* Change Hist : */
691 /* 04/18/06 mshirkol Initial Creation. ( Fix for bug#5610891 ) */
692 /*-------------------------------------------------------------------------------------*/
693
694 Procedure UPDATE_LOGISTIC_STATUS_WF
695 (itemtype in varchar2,
696 itemkey in varchar2,
697 actid in number,
698 funcmode in varchar2,
699 resultout in out nocopy varchar2);
700
701
702 End CSD_UPDATE_PROGRAMS_PVT ;