1 PACKAGE OEXPURGE AUTHID CURRENT_USER AS
2 /* $Header: OEXPURGS.pls 115.3 99/07/16 08:15:28 porting shi $ */
3
4 PROCEDURE select_purge_orders
5 ( dummy_1 IN varchar2
6 , dummy_2 IN varchar2
7 , p_low_order_number IN NUMBER
8 , p_high_order_number IN NUMBER
9 , p_low_cdate IN DATE
10 , p_high_cdate IN DATE
11 , p_low_ddate IN DATE
12 , p_high_ddate IN DATE
13 , p_order_category IN VARCHAR2
14 , p_order_type_id IN NUMBER
15 , p_customer_id IN NUMBER
16 );
17
18 FUNCTION so_check_open_invoiced_orders
19 ( p_order_number IN VARCHAR2,
20 p_order_type_name IN VARCHAR2 ) RETURN NUMBER;
21
22 FUNCTION so_check_open_demand_orders
23 ( p_order_number IN VARCHAR2,
24 p_order_type_name IN VARCHAR2 ) RETURN NUMBER;
25
26 FUNCTION so_check_open_orders
27 ( p_order_number IN VARCHAR2,
28 p_order_type_name IN VARCHAR2 ) RETURN NUMBER;
29
30 FUNCTION so_check_open_returns
31 ( p_order_number IN NUMBER,
32 p_order_type_name IN VARCHAR2 ) RETURN NUMBER;
33
34
35 PROCEDURE so_order_purge
36 ( p_dummy_1 IN VARCHAR2,
37 p_dummy_2 IN VARCHAR2,
38 p_commit_point IN NUMBER );
39
40 FUNCTION so_purge_freight_charges
41 ( p_picking_header_id IN NUMBER,
42 p_request_id IN NUMBER ) RETURN NUMBER;
43
44 FUNCTION so_purge_headers
45 ( p_header_id IN NUMBER,
46 p_request_id IN NUMBER ) RETURN NUMBER;
47
48 FUNCTION so_purge_hold_releases
49 ( p_release_id IN NUMBER,
50 p_request_id IN NUMBER ) RETURN NUMBER;
51
52 FUNCTION so_purge_hold_sources
53 ( p_source_id IN NUMBER,
54 p_request_id IN NUMBER ) RETURN NUMBER;
55
56 FUNCTION so_purge_line_approvals
57 ( p_header_id IN NUMBER,
58 p_request_id IN NUMBER ) RETURN NUMBER;
59
60 FUNCTION so_purge_line_details
61 ( p_line_id IN NUMBER,
62 p_request_id IN NUMBER ) RETURN NUMBER;
63
64 FUNCTION so_purge_line_service_details
65 ( p_line_id IN NUMBER,
66 p_request_id IN NUMBER ) RETURN NUMBER;
67
68 FUNCTION so_purge_lines
69 ( p_header_id IN NUMBER,
70 p_request_id IN NUMBER ) RETURN NUMBER;
71
72 FUNCTION so_purge_note_references
73 ( p_header_id IN NUMBER,
74 p_request_id IN NUMBER ) RETURN NUMBER;
75
76 FUNCTION so_purge_order_approvals
77 ( p_header_id IN NUMBER,
78 p_request_id IN NUMBER ) RETURN NUMBER;
79
80 FUNCTION so_purge_order_cancel_lines
81 ( p_line_id IN NUMBER,
82 p_request_id IN NUMBER ) RETURN NUMBER;
83
84 FUNCTION so_purge_mtl_so_rma_interface
85 ( p_line_id IN NUMBER,
86 p_request_id IN NUMBER ) RETURN NUMBER;
87
88 FUNCTION so_purge_mtl_so_rma_receipts
89 ( p_rma_interface_id IN NUMBER,
90 p_request_id IN NUMBER ) RETURN NUMBER;
91
92 FUNCTION so_purge_order_cancellations
93 ( p_header_id IN NUMBER,
94 p_request_id IN NUMBER ) RETURN NUMBER;
95
96 FUNCTION so_purge_order_holds
97 ( p_header_id IN NUMBER,
98 p_request_id IN NUMBER ) RETURN NUMBER;
99
100 FUNCTION so_purge_picking_batches
101 ( p_batch_id IN NUMBER,
102 p_header_id IN NUMBER,
103 p_request_id IN NUMBER ) RETURN NUMBER;
104
105 FUNCTION so_purge_picking_cancellations
106 ( p_picking_line_id IN NUMBER,
107 p_request_id IN NUMBER ) RETURN NUMBER;
108
109 FUNCTION so_purge_picking_headers
110 ( p_header_id IN NUMBER,
111 p_request_id IN NUMBER ) RETURN NUMBER;
112
113 FUNCTION so_purge_picking_line_details
114 ( p_picking_line_id IN NUMBER,
115 p_request_id IN NUMBER ) RETURN NUMBER;
116
117 FUNCTION so_purge_picking_lines
118 ( p_picking_header_id IN NUMBER,
119 p_request_id IN NUMBER ) RETURN NUMBER;
120
121 FUNCTION so_purge_backorder_cancelled
122 ( p_header_id IN NUMBER,
123 p_request_id IN NUMBER ) RETURN NUMBER;
124
125 FUNCTION so_purge_picking_rules
126 ( p_header_id IN NUMBER,
127 p_request_id IN NUMBER ) RETURN NUMBER;
128
129 FUNCTION so_purge_price_adjustments
130 ( p_header_id IN NUMBER,
131 p_request_id IN NUMBER ) RETURN NUMBER;
132
133 FUNCTION so_purge_sales_credits
134 ( p_header_id IN NUMBER,
135 p_request_id IN NUMBER ) RETURN NUMBER;
136
137 PROCEDURE so_record_errors
138 ( p_return_status IN NUMBER,
139 p_request_id IN NUMBER,
140 p_id_number IN NUMBER,
141 p_context IN VARCHAR2,
142 p_error_message IN VARCHAR2 );
143
144 END OEXPURGE; -- specification