1 PACKAGE OE_ORDER_PURGE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEXVPURS.pls 120.5.12000000.1 2007/01/16 22:12:08 appldev ship $ */
3
4 TYPE SELECTED_IDS_TBL IS TABLE OF NUMBER
5 INDEX BY BINARY_INTEGER;
6
7 -- Start of Comments
8 -- API name : Select_Purge_Orders
9 -- Type : Private
10 -- Pre-reqs : None.
11 -- Function : This procedure is called from concurrent request Create
12 -- Purge set(Submitted from Order Organizer). It will make
13 -- a table of records for ids from CLOB structure.
14 -- Parameters : p_dummy1 IN VARCHAR2
15 -- p_dummy2 IN VARCHAR2
16 -- p_purge_set_id IN NUMBER
17 -- Purge set id
18 -- Version : Current version = 1.0
19 -- Initial version = 1.0
20 -- End of Comments
21 --
22 PROCEDURE Select_Purge_Orders
23 (
24 p_dummy1 OUT NOCOPY VARCHAR2,
25
26 p_dummy2 OUT NOCOPY VARCHAR2,
27
28 p_purge_set_id IN NUMBER
29 );
30
31 -- Start of Comments
32 -- API name : Selected_Ids_Purge
33 -- Type : Private
34 -- Pre-reqs : None.
35 -- Function : This procedure is called from procedure select_purge_orders
36 -- It will create records in OE_PURGE_ORDERS for passed
37 -- selected ids.
38 -- Parameters : p_purge_set_id IN NUMBER
39 -- Purge set id
40 -- p_selected_ids_tbl IN SELECTED_IDS_TBL
41 -- Table with header ids of orders to be purged.
42 -- p_count_selected IN NUMBER
43 -- Number of ids selected.
44 -- p_orders_per_commit IN NUMBER
45 -- Number of orders per commit.
46 -- Version : Current version = 1.0
47 -- Initial version = 1.0
48 -- End of Comments
49 --
50 PROCEDURE select_ids_purge
51 (
52 p_purge_set_id IN NUMBER
53 , p_selected_ids_tbl IN SELECTED_IDS_TBL
54 , p_count_selected IN NUMBER
55 , p_orders_per_commit IN NUMBER
56 );
57
58 -- Start of Comments
59 -- API name : Select_where_cond_purge
60 -- Type : Private
61 -- Pre-reqs : None.
62 -- Function : This procedure is called from concurrent program Order
63 -- Purge Selection. It will select the orders based upon
64 -- specified where criteria and create records in
65 -- oe_purge_orders
66 -- Parameters : ERRBUF OUT NOCOPY /* file.sql.39 change */ VARCHAR2
67 -- RETCODE OUT NOCOPY /* file.sql.39 change */ VARCHAR2
68 -- p_purge_set_name IN VARCHAR2
69 -- purge set name.
70 -- p_purge_set_description IN VARCHAR2
71 -- purge set description
72 -- p_order_number_low IN NUMBER
73 -- order number range low.
74 -- p_order_number_high IN NUMBER
75 -- order number range high.
76 -- p_order_type_id IN NUMBER
77 -- order type id.
78 -- p_order_category IN VARCHAR2
79 -- order category code.
80 -- p_customer_id IN NUMBER
81 -- customer id.
82 -- p_ordered_date_low IN DATE
83 -- ordered date low.
84 -- p_ordered_date_high IN DATE
85 -- ordered date high.
86 -- p_creation_date_low IN DATE
87 -- creation date low.
88 -- p_creation_date_high IN DATE
89 -- creation date high.
90 -- Version : Current version = 1.0
91 -- Initial version = 1.0
92 -- End of Comments
93 --
94 PROCEDURE select_where_cond_purge
95 ( ERRBUF OUT NOCOPY VARCHAR2
96 , RETCODE OUT NOCOPY VARCHAR2
97 , p_organization_id IN NUMBER
98 , p_purge_set_name IN VARCHAR2
99 , p_purge_set_description IN VARCHAR2
100 , p_order_number_low IN NUMBER
101 , p_order_number_high IN NUMBER
102 , p_order_type_id IN NUMBER
103 , p_order_category IN VARCHAR2
104 , p_customer_id IN NUMBER
105 , p_ordered_date_low IN VARCHAR2
106 , p_ordered_date_high IN VARCHAR2
107 , p_creation_date_low IN VARCHAR2
108 , p_creation_date_high IN VARCHAR2
109 , p_dummy IN VARCHAR2 DEFAULT NULL
110 , p_include_contractual_orders IN VARCHAR2 DEFAULT NULL
111 );
112
113 -- Start of Comments
114 -- API name : Select_Where_Cond_Purge_Quote
115 -- Type : Private
116 -- Pre-reqs : None.
117 -- Function : This procedure is called from concurrent program Quote
118 -- Purge Selection. It will select the quote based upon
119 -- specified where criteria and create records in
120 -- oe_purge_orders
121 -- Parameters : ERRBUF OUT NOCOPY /* file.sql.39 change */ VARCHAR2
122 -- RETCODE OUT NOCOPY /* file.sql.39 change */ VARCHAR2
123 -- p_purge_set_name IN VARCHAR2
124 -- purge set name.
125 -- p_purge_set_description IN VARCHAR2
126 -- purge set description
127 -- p_quote_number_low IN NUMBER
128 -- quote number range low.
129 -- p_quote_number_high IN NUMBER
130 -- quote number range high.
131 -- p_order_type_id IN NUMBER
132 -- order type id.
133 -- p_customer_id IN NUMBER
134 -- customer id.
135 -- p_quote_date_low IN DATE
136 -- quote date low.
137 -- p_quote_date_high IN DATE
138 -- quote date high.
139 -- p_creation_date_low IN DATE
140 -- creation date low.
141 -- p_creation_date_high IN DATE
142 -- creation date high.
143 -- p_offer_exp_date_low IN DATE
144 -- offer expiration date low.
145 -- p_offer_exp_date_high IN DATE
146 -- offer expiration date high.
147 -- p_purge_exp_quotes IN VARCHAR2
148 -- purge expired quotes flag.
149 -- p_purge_lost_quotes IN VARCHAR2
150 -- purge lost quotes flag.
151 --
152 -- Version : Current version = 1.0
153 -- Initial version = 1.0
154 -- End of Comments
155 --
156
157 Procedure Select_Where_Cond_Purge_Quote
158 (
159 ERRBUF OUT NOCOPY /* file.sql.39 change */ VARCHAR2
160 , RETCODE OUT NOCOPY /* file.sql.39 change */ VARCHAR2
161 , p_organization_id IN NUMBER
162 , p_purge_set_name IN VARCHAR2
163 , p_purge_set_description IN VARCHAR2
164 , p_quote_number_low IN NUMBER
165 , p_quote_number_high IN NUMBER
166 , p_order_type_id IN NUMBER
167 , p_customer_id IN NUMBER
168 , p_quote_date_low IN VARCHAR2
169 , p_quote_date_high IN VARCHAR2
170 , p_creation_date_low IN VARCHAR2
171 , p_creation_date_high IN VARCHAR2
172 , p_offer_exp_date_low IN VARCHAR2
173 , p_offer_exp_date_high IN VARCHAR2
174 , p_purge_exp_quotes IN VARCHAR2
175 , p_purge_lost_quotes IN VARCHAR2
176 );
177
178
179 -- Start of Comments
180 -- API name : Insert_Purge_Set
181 -- Type : Private
182 -- Pre-reqs : None.
183 -- Function : This procedure inserts a record in oe_purge_sets table.
184 -- It converts the passed table of ids t a CLOB before
185 -- inserting it into the table.
186 -- Parameters : p_purge_set_name IN VARCHAR2
187 -- Purge set name
188 -- p_purge_set_description IN VARCHAR2
189 -- purge set name
190 -- p_purge_set_request_id IN NUMBER
191 -- Request id of concurrent request for creation of purge
192 -- set
193 -- p_purge_set_submit_datetime IN DATE
194 -- DATETIME of create purge set submission.
195 -- p_selected_ids IN SELECTED_IDS_TBL
196 -- Table of header ids. It will be passed from multi select
197 -- p_count_selected IN NUMBER
198 -- Number of orders selected
199 -- p_where_condition IN VARCHAR2
200 -- Where condition for the selection. It will be passed
201 -- when order purge selection request is submitted.
202 -- p_created_by IN NUMBER
203 -- Created by.
204 -- p_last_updated_by IN NUMBER
205 -- Last updated by.
206 -- x_purge_set_id OUT NOCOPY /* file.sql.39 change */ NUMBER
207 -- generated purge set id.
208 -- Version : Current version = 1.0
209 -- Initial version = 1.0
210 -- End of Comments
211 --
212 PROCEDURE Insert_Purge_Set
213 (
214 p_purge_set_name IN VARCHAR2
215 , p_purge_set_description IN VARCHAR2
216 , p_purge_set_request_Id IN NUMBER
217 , p_purge_set_submit_datetime IN DATE
218 , p_selected_ids IN SELECTED_IDS_TBL
219 , p_count_selected IN NUMBER
220 , p_where_condition IN VARCHAR2
221 , p_created_by IN NUMBER
222 , p_last_updated_by IN NUMBER
223 , x_purge_set_id OUT NOCOPY NUMBER
224
225 );
226
227
228 -- Start of Comments
229 -- API name : Check_And_Get_Detail
230 -- Type : Private
231 -- Pre-reqs : None.
232 -- Function : This procedure calls diffrent procedures to verify whether
233 -- order can be purged or not. Then it inserts a record in
234 -- table oe_purge_orders with error messages. It will check
235 -- if an order is open, open invoice exists, open RMA exists.
236 -- Parameters : p_purge_set_id IN NUMBER
237 -- Purge set id
238 -- p_header_id IN NUMBER
239 -- header id.
240 -- p_order_number IN NUMBER
241 -- Order number
242 -- p_order_type_name IN VARCHAR2
243 -- order type
244 -- p_customer_id IN NUMBER
245 -- customer id.
246 -- p_price_list_id IN NUMBER
247 -- price list id
248 -- p_quote_number IN NUMBER
249 -- quote number
250 -- p_flow_status_code IN varchar2(30)
251 -- flow status code
252 -- p_upgraded_flag IN varchar2(1)
253 -- upgraded flag
254 -- p_expiration_date IN DATE
255 -- expiration date
256 -- Version : Current version = 1.1
257 -- Initial version = 1.0
258 -- End of Comments
259 --
260
261 Procedure check_and_get_detail
262 (
263 p_purge_set_id IN NUMBER
264 , p_header_id IN NUMBER
265 , p_order_number IN NUMBER
266 , p_order_type_name IN VARCHAR2
267 , p_customer_number IN NUMBER
268 , p_price_list_id IN NUMBER
269 , p_quote_number IN NUMBER DEFAULT NULL
270 , p_flow_status_code IN VARCHAR2 DEFAULT NULL
271 , p_upgraded_flag IN VARCHAR2 DEFAULT NULL
272 , p_expiration_date IN DATE DEFAULT NULL
273 );
274
275
276 -- Start of Comments
277 -- API name : Delete_Purge_Set
278 -- Type : Private
279 -- Pre-reqs : None.
280 -- Function : This procedure is called from the form to delete a purge
281 -- set. It will check if the purge set is purged or if there
282 -- are any orders in the set have been purged, if yes it will
283 -- return false, else the purge set will be deleted and true
284 -- will be return.
285 -- Parameters : p_purge_set_id IN NUMBER
286 -- Purge set id
287 -- x_return_status IN VARCHAR2
288 -- Return status, will be FND_API.G_FALSE if the purge set
289 -- can not be deleted, eill be FND_API.G_TRUE if the purge
290 -- set is deleted.
291 -- Version : Current version = 1.0
292 -- Initial version = 1.0
293 -- End of Comments
294 --
295 Procedure delete_purge_set
296 (
297 p_purge_set_id IN NUMBER
298 , x_return_status OUT NOCOPY VARCHAR2);
299
300 -- Start of Comments
301 -- API name : Check_Open_Quotes
302 -- Type : Private
303 -- Pre-reqs : None.
304 -- Function : This function checks if the quote is open. It will return
305 -- FND_API.G_FALSE if the quote is open, else will return
306 -- FND_API.G_TRUE.
307 -- Parameters : p_header_id IN NUMBER
308 -- Header id
309 -- Version : Current version = 1.0
310 -- Initial version = 1.0
311 -- End of Comments
312 --
313
314 FUNCTION Check_Open_Quotes
315 (
316 p_header_id IN NUMBER
317 )
318 RETURN VARCHAR2;
319
320
321 -- Start of Comments
322 -- API name : Check_Open_Orders
323 -- Type : Private
324 -- Pre-reqs : None.
325 -- Function : This function checks if the order is open. It will return
326 -- FND_API.G_FALSE if the order is open, else will return
327 -- FND_API.G_TRUE.
328 -- Parameters : p_order_number IN NUMBER
329 -- Order Number
330 -- Version : Current version = 1.0
331 -- Initial version = 1.0
332 -- End of Comments
333 --
334
335 FUNCTION Check_Open_Orders
336 (
337 --for Bug # 4516769
338 p_header_id IN NUMBER
339 )
340 RETURN VARCHAR2;
341
342 -- Start of Comments
343 -- API name : Check_Open_Invoiced_Orders
344 -- Type : Private
345 -- Pre-reqs : None.
349 -- Parameters : p_order_number IN VARCHAR2
346 -- Function : This function checks if there are any open invoices against
347 -- a order . It will return FND_API.G_FALSE if an open invoive
348 -- exists for the order, else will return FND_API.G_TRUE.
350 -- Order Number
351 -- p_order_type_name IN VARCHAR2
352 -- Order Type
353 -- Version : Current version = 1.0
354 -- Initial version = 1.0
355 -- End of Comments
356 --
357
358 FUNCTION check_open_invoiced_orders
359 (
360 p_order_number IN VARCHAR2
361 , p_order_type_name IN VARCHAR2 )
362 RETURN VARCHAR2;
363
364 -- Start of Comments
365 -- API name : Check_Open_Returns
366 -- Type : Private
367 -- Pre-reqs : None.
368 -- Function : This function checks if there are any open returns for
369 -- a order . It will return FND_API.G_FALSE if an open returns
370 -- exists for the order, else will return FND_API.G_TRUE.
371 -- Parameters : p_order_number IN NUMBER
372 -- Order Number
373 -- p_order_type_name IN VARCHAR2
374 -- Order Type
375 -- Version : Current version = 1.0
376 -- Initial version = 1.0
377 -- End of Comments
378 --
379 FUNCTION check_open_returns
380 (
381 p_order_number IN NUMBER
382 , p_order_type_name IN VARCHAR2 )
383 RETURN VARCHAR2;
384
385
386 -- Start of Comments
387 -- API name : Check_Open_RMA_Receipts
388 -- Type : Private
389 -- Pre-reqs : None.
390 -- Function : This function checks if there are any open RMA receipts for
391 -- all Return Lines in the order(Return/Mixed). It will return -- FND_API.G_FALSE if open receipts exists,
392 -- else will return FND_API.G_TRUE.
393 -- Version : Current version = 1.0
394 -- Initial version = 1.0
395 -- End of Comments
396 --
397 PROCEDURE Check_Open_RMA_Receipts
398 ( p_header_id IN NUMBER,
399 x_return_status OUT NOCOPY VARCHAR2,
400
401 x_message OUT NOCOPY VARCHAR2);
402
403
404
405
406 -- Start of Comments
407 -- API name : Submit_Purge
408 -- Type : Private
409 -- Pre-reqs : None.
410 -- Function : This pricedure will be called from concurrent request when
411 -- a purge set is submitted for purge. It will call various
412 -- APIs to delete the records and will update the purged flag
413 -- on OE_PURGE_ORDERS, and purge set purged flag on
414 -- OE_PURGE_SETS table.
415 -- Parameters : p_dummy1 IN VARCHAR2
416 -- p_dummy2 IN VARCHAR2
417 -- p_purge_set_id IN NUMBER
418 -- purge set id
419 -- Version : Current version = 1.0
420 -- Initial version = 1.0
421 -- End of Comments
422 --
423
424 --
425 -- As per the MOAC changes the 'Order Purge Job' would be MULTI Organizational concurrent Request.
426 -- But the organization_id is not passed as this would be always passed as NULL.
427 --
428 Procedure submit_purge
429 ( p_dummy1 IN VARCHAR2
430 , p_dummy2 IN VARCHAR2
431 , p_purge_set_id IN NUMBER
432 );
433
434 -- Start of Comments
435 -- API name : OE_Purge_Headers
436 -- Type : Private
437 -- Pre-reqs : None.
438 -- Function : This pricedure will call APIs to delete header related
439 -- tables and will delete the record from OE_ORDER_HEADERS
440 -- Parameters : p_purge_set_id IN NUMBER
441 -- p_header_id IN NUMBER
442 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
443 -- return status, will be FND_API.G_RET_STS_SUCCESS if the
444 -- delete is successful else will be
445 -- FND_API.G_RET_STS_ERROR
446 -- Version : Current version = 1.0
447 -- Initial version = 1.0
448 -- End of Comments
449 --
450
451 PROCEDURE oe_purge_headers
452 (
453 p_purge_set_id IN NUMBER
454 , p_header_id IN NUMBER
455 , x_return_status OUT NOCOPY VARCHAR2
456
457 );
458
459 -- Start of Comments
460 -- API name : OE_Purge_Lines
461 -- Type : Private
462 -- Pre-reqs : None.
463 -- Function : This pricedure will call APIs to delete line related
464 -- tables and will delete the record from OE_ORDER_LINES
465 -- Parameters : p_purge_set_id IN NUMBER
466 -- p_header_id IN NUMBER
467 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
468 -- return status, will be FND_API.G_RET_STS_SUCCESS if the
469 -- delete is successful else will be
470 -- FND_API.G_RET_STS_ERROR
471 -- Version : Current version = 1.0
472 -- Initial version = 1.0
473 -- End of Comments
474 --
475 PROCEDURE oe_purge_lines
476 (
477 p_purge_set_id IN NUMBER
478 , p_header_id IN NUMBER
479 , x_return_status OUT NOCOPY VARCHAR2
480
481 );
482
483 -- Start of Comments
484 -- API name : OE_Purge_Header_Adj
485 -- Type : Private
486 -- Pre-reqs : None.
487 -- Function : This function will delete the records from price adjustment
488 -- tables for header id.
489 -- will return FND_API.G_RET_STS_SUCCESS if the records are
490 -- deleted, else will return FND_API.G_RET_STS_UNEXP_ERROR
491 -- Parameters : p_purge_set_id IN NUMBER
492 -- p_header_id IN NUMBER
496 --
493 -- Version : Current version = 1.0
494 -- Initial version = 1.0
495 -- End of Comments
497 FUNCTION OE_Purge_Header_Adj
498 (
499 p_purge_set_id IN NUMBER
500 , p_header_id IN NUMBER)
501
502 RETURN VARCHAR2 ;
503
504 -- Start of Comments
505 -- API name : OE_Purge_Line_Adj
506 -- Type : Private
507 -- Pre-reqs : None.
508 -- Function : This function will delete the records from price adjustment
509 -- tables for line id.
510 -- will return FND_API.G_RET_STS_SUCCESS if the records are
511 -- deleted, else will return FND_API.G_RET_STS_UNEXP_ERROR
512 -- Parameters : p_purge_set_id IN NUMBER
513 -- p_line_id IN NUMBER
514 -- Version : Current version = 1.0
515 -- Initial version = 1.0
516 -- End of Comments
517 --
518 FUNCTION OE_Purge_Line_Adj
519 (
520 p_purge_set_id IN NUMBER
521 , p_header_id IN NUMBER
522 , p_line_id IN NUMBER)
523 RETURN VARCHAR2;
524
525 -- Start of Comments
526 -- API name : OE_Purge_Price_Attribs
527 -- Type : Private
528 -- Pre-reqs : None.
529 -- Function : This function will delete the records from
530 -- OE_ORDER_PRICE_ATTRIBS table for header id.
531 -- will return FND_API.G_RET_STS_SUCCESS if the records are
532 -- deleted, else will return FND_API.G_RET_STS_UNEXP_ERROR
533 -- Parameters : p_purge_set_id IN NUMBER
534 -- p_header_id IN NUMBER
535 -- Version : Current version = 1.0
536 -- Initial version = 1.0
537 -- End of Comments
538 --
539 FUNCTION OE_Purge_Price_Attribs
540 (
541 p_purge_set_id IN NUMBER
542 , p_header_id IN NUMBER)
543 RETURN VARCHAR2;
544
545 -- Start of Comments
546 -- API name : OE_Purge_Order_Sales_Credits
547 -- Type : Private
548 -- Pre-reqs : None.
549 -- Function : This function will delete the records from sales credits
550 -- tables for header id.
551 -- will return FND_API.G_RET_STS_SUCCESS if the records are
552 -- deleted, else will return FND_API.G_RET_STS_UNEXP_ERROR
553 -- Parameters : p_purge_set_id IN NUMBER
554 -- p_header_id IN NUMBER
555 -- Version : Current version = 1.0
556 -- Initial version = 1.0
557 -- End of Comments
558 --
559
560 FUNCTION OE_Purge_Order_Sales_Credits
561 (
562 p_purge_set_id IN NUMBER
563 , p_header_id IN NUMBER)
564 RETURN VARCHAR2;
565
566 -- Start of Comments
567 -- API name : OE_Purge_Line_Sales_Credits
568 -- Type : Private
569 -- Pre-reqs : None.
570 -- Function : This function will delete the records from sales credits
571 -- tables for line id.
572 -- will return FND_API.G_RET_STS_SUCCESS if the records are
573 -- deleted, else will return FND_API.G_RET_STS_UNEXP_ERROR
574 -- Parameters : p_purge_set_id IN NUMBER
575 -- p_line_id IN NUMBER
576 -- Version : Current version = 1.0
577 -- Initial version = 1.0
578 -- End of Comments
579 --
580 FUNCTION OE_Purge_Line_Sales_Credits
581 (
582 p_purge_set_id IN NUMBER
583 , p_header_id IN NUMBER
584 , p_line_id IN NUMBER)
585 RETURN VARCHAR2;
586
587 -- Start of Comments
588 -- API name : OE_Purge_Order_Sets
589 -- Type : Private
590 -- Pre-reqs : None.
591 -- Function : This function will delete the records from oe_sets
592 -- tables for header id.
593 -- will return FND_API.G_RET_STS_SUCCESS if the records are
594 -- deleted, else will return FND_API.G_RET_STS_UNEXP_ERROR
595 -- Parameters : p_purge_set_id IN NUMBER
596 -- p_header_id IN NUMBER
597 -- Version : Current version = 1.0
598 -- Initial version = 1.0
599 -- End of Comments
600 --
601
602 FUNCTION OE_Purge_Order_Sets
603 (
604 p_purge_set_id IN NUMBER
605 , p_header_id IN NUMBER)
606 RETURN VARCHAR2;
607
608 -- Start of Comments
609 -- API name : OE_Purge_Line_Sets
610 -- Type : Private
611 -- Pre-reqs : None.
612 -- Function : This function will delete the records from OE_LINE_SETS
613 -- tables for line id.
614 -- will return FND_API.G_RET_STS_SUCCESS if the records are
615 -- deleted, else will return FND_API.G_RET_STS_UNEXP_ERROR
616 -- Parameters : p_purge_set_id IN NUMBER
617 -- p_line_id IN NUMBER
618 -- Version : Current version = 1.0
619 -- Initial version = 1.0
620 -- End of Comments
621 --
622
623 FUNCTION OE_Purge_Line_Sets
624 (
625 p_purge_set_id IN NUMBER
626 , p_header_id IN NUMBER
627 , p_line_id IN NUMBER)
628 RETURN VARCHAR2;
629
630 -- Start of Comments
631 -- API name : OE_Purge_Order_Holds
632 -- Type : Private
633 -- Pre-reqs : None.
634 -- Function : This function will delete the records from Holds
635 -- tables for header id.
636 -- will return FND_API.G_RET_STS_SUCCESS if the records are
637 -- deleted, else will return FND_API.G_RET_STS_UNEXP_ERROR
638 -- Parameters : p_purge_set_id IN NUMBER
639 -- p_header_id IN NUMBER
640 -- Version : Current version = 1.0
641 -- Initial version = 1.0
642 -- End of Comments
643 --
644
645 FUNCTION OE_Purge_Order_Holds
646 (
647 p_purge_set_id IN NUMBER
651
648 , p_header_id IN NUMBER)
649 RETURN VARCHAR2;
650
652 -- Start of Comments
653 -- API name : OE_Purge_RMA_Line_Receipts
654 -- Type : Private
655 -- Pre-reqs : None.
656 -- Function : This function will delete RMA line receipts in PO Tables,
657 -- will return FND_API.G_RET_STS_SUCCESS if the records are
658 -- deleted, else will return FND_API.G_RET_STS_UNEXP_ERROR
659 -- Version : Current version = 1.0
660 -- Initial version = 1.0
661 -- End of Comments
662 --
663
664 FUNCTION OE_Purge_RMA_Line_Receipts
665 ( p_purge_set_id IN NUMBER
666 , p_header_id IN NUMBER
667 , p_line_id IN NUMBER)
668 RETURN VARCHAR2;
669
670
671 -- Start of Comments
672 -- API name : OE_Purge_RMA_Line_Lot_Srl
673 -- Type : Private
674 -- Pre-reqs : None.
675 -- Function : This function will delete RMA line lot and serial number
676 -- records in OM Tables,
677 -- will return FND_API.G_RET_STS_SUCCESS if the records are
678 -- deleted, else will return FND_API.G_RET_STS_UNEXP_ERROR
679 -- Version : Current version = 1.0
680 -- Initial version = 1.0
681 -- End of Comments
682 --
683
684 FUNCTION OE_Purge_RMA_Line_Lot_Srl
685 ( p_purge_set_id IN NUMBER
686 , p_header_id IN NUMBER
687 , p_line_id IN NUMBER)
688 RETURN VARCHAR2;
689
690
691 -- Start of Comments
692 -- API name : record_errors
693 -- Type : Private
694 -- Pre-reqs : None.
695 -- Function : This procedure will be called to record the errors
696 -- encountered during delete.
697 -- Parameters : p_return_status IN VARCHAR2
698 -- p_purge_set_id IN NUMBER
699 -- p_header_id IN NUMBER
700 -- p_error_message IN VARCHAR2
701 -- Version : Current version = 1.0
702 -- Initial version = 1.0
703 -- End of Comments
704 --
705
706 PROCEDURE record_errors
707 (
708 p_return_status IN VARCHAR2
709 , p_purge_set_id IN NUMBER
710 , p_header_id IN NUMBER
711 , p_error_message IN VARCHAR2
712 ) ;
713
714 -- Purge Changes for 11i.10
715
716 -- Function : Check_Open_PO_Reqs_Dropship
717 -- Description : This function checks if there are any open
718 -- PO/Requsitions associated with drop ship order lines.
719 -- It will call an API provided by Purchasing. If this API
720 -- returns that the PO/Requsition associated with any of
721 -- the drop ship order line is open, the order will be marked
722 -- for not to be purged, with message OE_PURGE_OPEN_PO_REQ.
723 --
724
725 Function Check_Open_PO_Reqs_Dropship
726 ( p_header_id IN NUMBER
727 ) RETURN VARCHAR2;
728
729 -- added for multiple payments
730 FUNCTION OE_Purge_Header_Payments
731 ( p_purge_set_id IN NUMBER
732 , p_header_id IN NUMBER)
733 RETURN VARCHAR2;
734
735 -- added for multiple payments
736 FUNCTION OE_Purge_Line_Payments
737 ( p_purge_set_id IN NUMBER
738 , p_header_id IN NUMBER
739 , p_line_id IN NUMBER)
740 RETURN VARCHAR2;
741
742
743 -- This procedure is called from the OEXOEPUR.pld .
744 -- This checks if the Order is eligible for Purging.
745
746 PROCEDURE check_is_purgable( p_purge_set_id IN NUMBER
747 , p_header_id IN NUMBER
748 , p_order_number IN NUMBER
749 , p_order_type_name IN VARCHAR2
750 , p_quote_number IN NUMBER
751 , p_is_purgable OUT NOCOPY VARCHAR2
752 , p_error_message OUT NOCOPY VARCHAR2 );
753
754
755 END oe_order_purge_pvt; -- specification