1 PACKAGE OE_Order_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEXVORDS.pls 120.1.12000000.1 2007/01/16 22:11:55 appldev ship $ */
3
4
5 -- This procedure will return TRUE if the order was a valid upgraded
6 -- order else will return FALSE
7
8 FUNCTION Valid_Upgraded_Order(p_header_id Number)
9 RETURN Boolean;
10
11
12 -- Entity Specific Procedures
13
14 -- Added to improve performance - if certain pvt procedures are operating
15 -- on only one entity, then these entity procedures can be called instead
16 -- of calling OE_Order_PVT.Process_Order
17
18 -- NOTE: In most cases, the API - Process_Requests_And_Notify_OC should
19 -- also be called after calling these procedures.
20
21 PROCEDURE Header
22 ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
23 , p_validation_level IN NUMBER
24 , p_control_rec IN OE_GLOBALS.Control_Rec_Type
25 , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
26 , p_x_old_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
27 , x_return_status OUT NOCOPY VARCHAR2
28
29 );
30
31 PROCEDURE Header_Scredits
32 ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
33 , p_validation_level IN NUMBER
34 , p_control_rec IN OE_GLOBALS.Control_Rec_Type
35 , p_x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type
36 , p_x_old_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type
37 , x_return_status OUT NOCOPY VARCHAR2
38
39 );
40
41 PROCEDURE Header_Payments
42 ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
43 , p_validation_level IN NUMBER
44 , p_control_rec IN OE_GLOBALS.Control_Rec_Type
45 , p_x_Header_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_Payment_Tbl_Type
46 , p_x_old_Header_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_Payment_Tbl_Type
47 , x_return_status OUT NOCOPY VARCHAR2
48
49 );
50
51 PROCEDURE Lines
52 ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
53 , p_validation_level IN NUMBER
54 , p_control_rec IN OE_GLOBALS.Control_Rec_Type
55 , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
56 , p_x_old_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
57 , x_return_status OUT NOCOPY VARCHAR2
58
59 );
60
61 PROCEDURE Line_Scredits
62 ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
63 , p_validation_level IN NUMBER
64 , p_control_rec IN OE_GLOBALS.Control_Rec_Type
65 , p_x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
66 , p_x_old_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
67 , x_return_status OUT NOCOPY VARCHAR2
68
69 );
70
71 PROCEDURE Line_Payments
72 ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
73 , p_validation_level IN NUMBER
74 , p_control_rec IN OE_GLOBALS.Control_Rec_Type
75 , p_x_Line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type
76 , p_x_old_Line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type
77 , x_return_status OUT NOCOPY VARCHAR2
78
79 );
80
81 PROCEDURE Lot_Serials
82 ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
83 , p_validation_level IN NUMBER
84 , p_control_rec IN OE_GLOBALS.Control_Rec_Type
85 , p_x_Lot_Serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type
86 , p_x_old_Lot_Serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type
87 , x_return_status OUT NOCOPY VARCHAR2
88
89 );
90
91
92 -- Process_Requests_And_Notify
93 -- This API should be called by procedures that are directly updating
94 -- attributes on the sales order entities or calling the above entity
95 -- specific procedures for operations on the sales order entities.
96 -- Set p_process_requests to TRUE if delayed requests need to be executed
97 -- Set p_notify to TRUE if notifications to be posted to OC. Set p_process_ack
98 -- If acknowledgement is to be processed. Please make sure that you set
99 -- p_notify to TRUE when setting p_process_ack to TRUE. Otherwise
100 -- acknowledgements will not be processed.
101
102 PROCEDURE Process_Requests_And_Notify
103 ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
104 , p_process_requests IN BOOLEAN := TRUE
105 , p_notify IN BOOLEAN := TRUE
106 , p_process_ack IN BOOLEAN := TRUE
107 , x_return_status OUT NOCOPY VARCHAR2
108
109 , p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
110 OE_Order_PUB.G_MISS_HEADER_REC
111 , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
112 OE_Order_PUB.G_MISS_HEADER_REC
113 , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
114 OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
115 , p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
116 OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
117 , p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
118 OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
119 , p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
120 OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
121 , p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
122 OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
123 , p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
124 OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
125 , p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
126 OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
127 , p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
128 OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
129 , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
130 OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
131 , p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
132 OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
133 , p_Header_Payment_tbl IN OE_Order_PUB.Header_Payment_Tbl_Type :=
134 OE_Order_PUB.G_MISS_HEADER_PAYMENT_TBL
135 , p_old_Header_Payment_tbl IN OE_Order_PUB.Header_Payment_Tbl_Type :=
136 OE_Order_PUB.G_MISS_HEADER_PAYMENT_TBL
137 , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
138 OE_Order_PUB.G_MISS_LINE_TBL
139 , p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
140 OE_Order_PUB.G_MISS_LINE_TBL
141 , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
142 OE_Order_PUB.G_MISS_LINE_ADJ_TBL
143 , p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
144 OE_Order_PUB.G_MISS_LINE_ADJ_TBL
145 , p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
146 OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
147 , p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
148 OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
149 , p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
150 OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
151 , p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
152 OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
153 , p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
154 OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
155 , p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
156 OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
157 , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
158 OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
159 , p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
160 OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
161 , p_Line_Payment_tbl IN OE_Order_PUB.Line_Payment_Tbl_Type :=
162 OE_Order_PUB.G_MISS_LINE_PAYMENT_TBL
163 , p_old_Line_Payment_tbl IN OE_Order_PUB.Line_Payment_Tbl_Type :=
164 OE_Order_PUB.G_MISS_LINE_PAYMENT_TBL
165 , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
166 OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
167 , p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
168 OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
169 , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
170 OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
171 , p_old_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
172 OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
173 );
174
175
176 -- Start of Comments
177 -- API name Process_Order
178 -- Type Private
179 --
180 -- Pre-reqs
181 --
182 -- Parameters
183 --
184 -- Version Current version = 1.0
185 -- Initial version = 1.0
186 --
187 -- Notes
188 --
189 -- End of Comments
190 PROCEDURE Process_Order
191 ( p_api_version_number IN NUMBER
192 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
193 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
194 , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
195 OE_GLOBALS.G_MISS_CONTROL_REC
196 , x_return_status OUT NOCOPY VARCHAR2
197
198 , x_msg_count OUT NOCOPY NUMBER
199
200 , x_msg_data OUT NOCOPY VARCHAR2
201
202 , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
203 , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
204 OE_Order_PUB.G_MISS_HEADER_REC
205 , p_x_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
206 , p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
207 OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
208 , p_x_Header_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type
209 , p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
210 OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
211 , p_x_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
212 , p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
213 OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
214 , p_x_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
215 , p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
216 OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
217 , p_x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type
218 , p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
219 OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
220 , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
221 , p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
222 OE_Order_PUB.G_MISS_LINE_TBL
223 , p_x_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
224 , p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
225 OE_Order_PUB.G_MISS_LINE_ADJ_TBL
226 , p_x_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
227 , p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
228 OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
229 , p_x_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
230 , p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
231 OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
232 , p_x_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
233 , p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
234 OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
235 , p_x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
236 , p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
237 OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
238 , p_x_Lot_Serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type
239 , p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
240 OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
241 , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
242 OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
243 , p_old_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
244 OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
245 , p_x_action_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type
246 , p_action_commit IN VARCHAR2 := FND_API.G_FALSE
247 );
248
249 -- Overloaded for payments entities
250 PROCEDURE Process_Order
251 ( p_api_version_number IN NUMBER
252 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
253 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
254 , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
255 OE_GLOBALS.G_MISS_CONTROL_REC
256 , x_return_status OUT NOCOPY VARCHAR2
257
258 , x_msg_count OUT NOCOPY NUMBER
259
260 , x_msg_data OUT NOCOPY VARCHAR2
261
262 , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
263 , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
264 OE_Order_PUB.G_MISS_HEADER_REC
265 , p_x_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
266 , p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
267 OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
268 , p_x_Header_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type
269 , p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
270 OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
271 , p_x_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
272 , p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
273 OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
274 , p_x_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
275 , p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
276 OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
277 , p_x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type
278 , p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
279 OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
280 , p_x_Header_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_Payment_Tbl_Type
281 , p_old_Header_Payment_tbl IN OE_Order_PUB.Header_Payment_Tbl_Type :=
282 OE_Order_PUB.G_MISS_HEADER_PAYMENT_TBL
283 , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
284 , p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
285 OE_Order_PUB.G_MISS_LINE_TBL
286 , p_x_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
287 , p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
288 OE_Order_PUB.G_MISS_LINE_ADJ_TBL
289 , p_x_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
290 , p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
291 OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
292 , p_x_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
293 , p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
294 OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
295 , p_x_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
296 , p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
297 OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
298 , p_x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
299 , p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
300 OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
301 , p_x_Line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type
302 , p_old_Line_Payment_tbl IN OE_Order_PUB.Line_Payment_Tbl_Type :=
303 OE_Order_PUB.G_MISS_LINE_PAYMENT_TBL
304 , p_x_Lot_Serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type
305 , p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
306 OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
307 , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
308 OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
309 , p_old_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
310 OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
311 , p_x_action_request_tbl IN OUT NOCOPY OE_Order_PUB.request_tbl_type
312 , p_action_commit IN VARCHAR2 := FND_API.G_FALSE
313 );
314
315 -- Start of Comments
316 -- API name Lock_Order
317 -- Type Private
318 --
319 -- Pre-reqs
320 --
321 -- Parameters
322 --
323 -- Version Current version = 1.0
324 -- Initial version = 1.0
325 --
326 -- Notes
327 --
328 -- End of Comments
329
330 PROCEDURE Lock_Order
331 ( p_api_version_number IN NUMBER
332 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
333 , x_return_status OUT NOCOPY VARCHAR2
334
335 , x_msg_count OUT NOCOPY NUMBER
336
337 , x_msg_data OUT NOCOPY VARCHAR2
338
339 , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
340 , p_x_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
341 , p_x_Header_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type
342 , p_x_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
343 , p_x_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
344 , p_x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type
345 , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
346 , p_x_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
347 , p_x_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
348 , p_x_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
349 , p_x_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
350 , p_x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
351 , p_x_Lot_Serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type
352 );
353
354 -- overloaded with payments parameters
355 PROCEDURE Lock_Order
356 ( p_api_version_number IN NUMBER
357 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
358 , x_return_status OUT NOCOPY VARCHAR2
359
360 , x_msg_count OUT NOCOPY NUMBER
361
362 , x_msg_data OUT NOCOPY VARCHAR2
363
364 , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
365 , p_x_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
366 , p_x_Header_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type
367 , p_x_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
368 , p_x_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
369 , p_x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type
370 , p_x_Header_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_Payment_Tbl_Type
371 , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
372 , p_x_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
373 , p_x_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
374 , p_x_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
375 , p_x_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
376 , p_x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
377 , p_x_Line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type
378 , p_x_Lot_Serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type
379 );
380
381 -- Start of Comments
382 -- API name Get_Order
383 -- Type Private
384 --
385 -- Pre-reqs
386 --
387 -- Parameters
388 --
389 -- Version Current version = 1.0
390 -- Initial version = 1.0
391 --
392 -- Notes
393 --
394 -- End of Comments
395
396 PROCEDURE Get_Order
397 ( p_api_version_number IN NUMBER
398 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
399 , x_return_status OUT NOCOPY VARCHAR2
400
401 , x_msg_count OUT NOCOPY NUMBER
402
403 , x_msg_data OUT NOCOPY VARCHAR2
404
405 , p_header_id IN NUMBER
406 , x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
407 , x_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
408 , x_Header_price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type
409 , x_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
410 , x_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
411 , x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type
412 , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
413 , x_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
414 , x_Line_price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
415 , x_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
416 , x_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
417 , x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
418 , x_Lot_Serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type
419 );
420
421 -- overloaded with payments parameters
422 PROCEDURE Get_Order
423 ( p_api_version_number IN NUMBER
424 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
425 , x_return_status OUT NOCOPY VARCHAR2
426
427 , x_msg_count OUT NOCOPY NUMBER
428
429 , x_msg_data OUT NOCOPY VARCHAR2
430
431 , p_header_id IN NUMBER
432 , x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
433 , x_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
434 , x_Header_price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type
435 , x_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
436 , x_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
437 , x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type
438 , x_Header_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_Payment_Tbl_Type
439 , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
440 , x_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
441 , x_Line_price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
442 , x_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
443 , x_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
444 , x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
445 , x_Line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type
446 , x_Lot_Serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type
447 );
448
449
450 Procedure Cancel_Order
451 ( p_api_version_number IN NUMBER
452 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
453 , x_return_status OUT NOCOPY VARCHAR2
454
455 , x_msg_count OUT NOCOPY NUMBER
456
457 , x_msg_data OUT NOCOPY VARCHAR2
458
459 , x_can_req IN OUT
460 OE_ORDER_PUB.Cancel_Line_Tbl_Type
461 );
462
463 Procedure Set_Recursion_Mode (p_Entity_Code number,
464 p_In_Out number := 1);
465
466
467
468 END OE_Order_PVT;