[Home] [Help]
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 */
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 */
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 */
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 : */
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 */
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 : */
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 */
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 : */
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 */
223: /* STANDARD PARAMETERS */
224: /* In Parameters : */
225: /* p_api_version NUMBER Required Api Version number */
226: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
227: /* p_commit VARCHAR2 Optional Commits in API */
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 */
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 */
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 : */
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 */
301: /* Called from : Called from RECEIPTS_UPDATE API */
302: /* STANDARD PARAMETERS */
303: /* In Parameters : */
304: /* p_api_version NUMBER Required Api Version number */
305: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
306: /* p_commit VARCHAR2 Optional Commits in API */
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 : */
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 */
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 : */
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 : */
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 */
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 */
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 */
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 : */
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 */
454: /* In Parameters : */
455: /* p_api_version NUMBER Required Api Version number */
456: /* p_init_msg_list VARCHAR2 Optional To Initialize message stack */
457: /* p_commit VARCHAR2 Optional Commits in API */
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 : */
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 */
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 : */
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: */
531: /* errbuf VARCHAR2 Error message */
530: /* Output Parameters: */
531: /* errbuf VARCHAR2 Error message */
532: /* retcode VARCHAR2 Error Code */
533: /* */
534: /* NON-STANDARD PARAMETERS */
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 */
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 */
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 : */
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 */
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 */
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 */
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 : */
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: /* */
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 : */