[Home] [Help]
PACKAGE: APPS.ASO_ORDER_INT
Source
1 PACKAGE ASO_order_INT as
2 /* $Header: asoiords.pls 120.3 2005/06/30 13:55:42 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_ORDER_INT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 -- Default number of records fetch per call
12 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
13
14
15 -- *******************************************************
16 -- Start of Comments
17 -- -------------------------------------------------------
18 -- Record name:Order_Header_Rec_Type
19 -- -------------------------------------------------------
20 -- Parameters:
21 -- order_number
22 -- header_id
23 -- status
24
25 -- Required:
26 -- Defaults:
27 -- Note: This is automatic generated record definition, it includes all columns
28 -- defined in the table, developer must manually add or delete some of the attributes.
29 --
30 -- End of Comments
31
32 TYPE Order_Header_Rec_Type IS RECORD
33 (
34 ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
35 ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
36 QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
37 STATUS VARCHAR2(150) := FND_API.G_MISS_CHAR
38 );
39
40 G_MISS_Order_Header_Rec Order_Header_Rec_Type;
41
42
43 -- *******************************************************
44 -- Start of Comments
45 -- -------------------------------------------------------
46 -- Record name:Order_Line_Rec_Type
47 -- -------------------------------------------------------
48 -- Parameters:
49
50 -- header_id
51 -- line_id
52 -- status
53
54 -- Required:
55 -- Defaults:
56 -- Note: This is automatic generated record definition, it includes all columns
57 -- defined in the table, developer must manually add or delete some of the attributes.
58 --
59 -- End of Comments
60
61 TYPE Order_Line_Rec_Type IS RECORD
62 (
63 ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
64 ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
65 QUOTE_SHIPMENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
66 STATUS VARCHAR2(150) := FND_API.G_MISS_CHAR
67 );
68
69
70 G_MISS_Order_Line_Rec Order_Line_Rec_Type;
71 TYPE Order_Line_Tbl_type IS TABLE OF Order_Line_Rec_type
72 INDEX BY BINARY_INTEGER;
73 G_MISS_Order_Line_Tbl Order_Line_Tbl_Type;
74
75
76
77 TYPE FULFILLMENT_REC_TYPE IS RECORD
78 (QUOTE_LINE_INDEX NUMBER);
79
80 TYPE FULFILLMENT_TBL_TYPE IS TABLE OF FULFILLMENT_REC_TYPE
81 INDEX BY BINARY_INTEGER;
82 G_MISS_Fulfillment_tbl FULFILLMENT_TBL_TYPE;
83
84
85 TYPE Control_Rec_Type IS RECORD
86 (
87 BOOK_FLAG VARCHAR2(1) := FND_API.G_TRUE,
88 -- RESERVE_FLAG VARCHAR2(1) := FND_API.G_FALSE,
89 CALCULATE_PRICE VARCHAR2(1) := FND_API.G_FALSE,
90 SERVER_ID NUMBER := -1 ,
91 INTERFACE_FFM_FLAG VARCHAR2(1) := FND_API.G_TRUE,
92 CC_BY_FAX VARCHAR2(1) := FND_API.G_FALSE
93 );
94
95
96 G_MISS_Control_Rec Control_Rec_Type;
97
98
99 TYPE order_sort_rec_type IS RECORD
100 (
101 -- Please define your own sort by record here.
102 ORDER_HEADER_ID NUMBER := NULL
103 );
104
105
106
107 -- Line_Scredit record type
108
109 TYPE Sales_credit_Rec_Type IS RECORD
110 ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
111 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
112 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
113 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
114 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
115 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
116 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
117 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
118 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
119 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
120 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
121 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
122 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
123 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
124 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
125 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
126 , dw_update_advice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
127 , quote_header_id NUMBER := FND_API.G_MISS_NUM
128 , quote_line_id NUMBER := FND_API.G_MISS_NUM
129 , percent NUMBER := FND_API.G_MISS_NUM
130 , quota_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
131 , salesrep_id NUMBER := FND_API.G_MISS_NUM
132 , sales_credit_id NUMBER := FND_API.G_MISS_NUM
133 , wh_update_date DATE := FND_API.G_MISS_DATE
134 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
135 , line_index NUMBER := FND_API.G_MISS_NUM
136 , orig_sys_credit_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
137 , change_request_code VARCHAR2(30) := FND_API.G_MISS_CHAR
138 , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
139 );
140 G_MISS_SALES_CREDIT_REC SALES_CREDIT_Rec_Type;
141 TYPE Sales_Credit_Tbl_type IS TABLE OF Sales_Credit_Rec_type
142 INDEX BY BINARY_INTEGER;
143 G_MISS_Sales_Credit_Tbl Sales_Credit_Tbl_Type;
144
145
146 TYPE Lot_Serial_Rec_Type IS RECORD
147 ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
148 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
149 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
150 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
151 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
152 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
153 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
154 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
155 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
156 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
157 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
158 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
159 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
160 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
161 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
162 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
163 , created_by NUMBER := FND_API.G_MISS_NUM
164 , creation_date DATE := FND_API.G_MISS_DATE
165 , from_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR
166 , last_updated_by NUMBER := FND_API.G_MISS_NUM
167 , last_update_date DATE := FND_API.G_MISS_DATE
168 , last_update_login NUMBER := FND_API.G_MISS_NUM
169 , line_id NUMBER := FND_API.G_MISS_NUM
170 , lot_number VARCHAR2(30) := FND_API.G_MISS_CHAR
171 , lot_serial_id NUMBER := FND_API.G_MISS_NUM
172 , quantity NUMBER := FND_API.G_MISS_NUM
173 , to_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR
174 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
175 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
176 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
177 , line_index NUMBER := FND_API.G_MISS_NUM
178 , orig_sys_lotserial_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
179 , change_request_code VARCHAR2(30) := FND_API.G_MISS_CHAR
180 , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
181 , line_set_id NUMBER := FND_API.G_MISS_NUM
182 );
183
184 TYPE Lot_Serial_Tbl_Type IS TABLE OF Lot_Serial_Rec_Type
185 INDEX BY BINARY_INTEGER;
186
187 G_MISS_Lot_Serial_Tbl Lot_Serial_Tbl_Type ;
188
189
190
191 -- *******************************************************
192 -- Start of Comments
193 -- *******************************************************
194 -- API Name: Create_Order
195 -- Type : Public
196 -- Pre-Req :
197 -- Parameters:
198 -- IN
199 -- p_api_version_number IN NUMBER Required
200 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202 -- P_qte_lines_Rec IN ASO_QUOTE_PUB.qte_line_Rec_Type Required
203 -- P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type Required
204 -- P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type Required
205 -- P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type Required
206 -- P_Qte_Line_Dtl_Rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type Required
207 -- P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type Required
208 -- P_Tax_Details_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type Required
209 -- P_Quote_Line_Rltship IN ASO_QUOTE_PUB.Quote_Line_Rltship_Type Required
210 -- OUT:
211 -- x_order_number OUT NOCOPY /* file.sql.39 change */ NUMBER
212 -- X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ Order_Header_Rec_Type
213 -- X_Order_Line_Tbl OUT NOCOPY /* file.sql.39 change */ Order_Line_Tbl_type
214 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
215 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
216 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
217 -- Version : Current version 2.0
218 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
219 -- and basic operation, developer must manually add parameters and business logic as necessary.
220 --
221 -- End of Comments
222 --
223 PROCEDURE Create_order(
224 P_Api_Version_Number IN NUMBER,
225 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
226 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
227 P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
228 := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
229 P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
230 := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
231 P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
232 := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
233 P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
234 := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
235 P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
236 := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
237 P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
238 := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
239 P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
240 := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
241 P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
242 := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
243 P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
244 := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
245 P_header_sales_credit_TBL IN Sales_credit_tbl_type
246 := G_MISS_sales_credit_TBL,
247 P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
248 := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
249 P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
250 := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
251 P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
252 := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
253 P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
254 := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
255 P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
256 := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
257 P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
258 := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
259 P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
260 := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
261 P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
262 := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
263 P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
264 := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
265 P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
266 := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
267 P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
268 := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
269 P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
270 := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
271 P_Line_sales_credit_TBL IN Sales_credit_tbl_type
272 := G_MISS_sales_credit_TBL,
273 P_Lot_Serial_Tbl IN Lot_Serial_Tbl_Type
274 := G_MISS_Lot_Serial_Tbl,
275 P_Control_Rec IN Control_Rec_Type := G_MISS_Control_Rec,
276 X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ Order_Header_Rec_Type,
277 X_Order_Line_Tbl OUT NOCOPY /* file.sql.39 change */ Order_Line_Tbl_type,
278 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
279 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
280 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
281 );
282
283 -- *******************************************************
284 -- Start of Comments
285 -- *******************************************************
286 -- API Name: Update_order
287 -- Type : Public
288 -- Pre-Req :
289 -- Parameters:
290 -- IN
291 -- p_api_version_number IN NUMBER Required
292 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
293 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
294 -- P_qte_lines_Rec IN ASO_QUOTE_PUB.qte_line_Rec_Type Required
295 -- P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type Required
296 -- P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type Required
297 -- P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type Required
298 -- P_Qte_Line_Dtl_Rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type Required
299 -- P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type Required
300 -- P_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type Required
301 -- P_Quote_Line_Rltship IN ASO_QUOTE_PUB. Quote_Line_Rltship_Type Required
302 -- OUT:
303 -- x_order_number OUT NOCOPY /* file.sql.39 change */ NUMBER
304 -- X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ Order_Header_Rec_Type
305 -- X_Order_Line_Tbl OUT NOCOPY /* file.sql.39 change */ Order_Line_Tbl_type
306 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
307 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
308 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
309 -- Version : Current version 2.0
310 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
311 -- and basic operation, developer must manually add parameters and business logic as necessary.
312 --
313 -- End of Comments
314 --
315 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
316 PROCEDURE Update_order(
317 P_Api_Version_Number IN NUMBER,
318 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
319 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
323 P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
320 P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
321 P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
322 P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
324 P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
325 P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
326 P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
327 P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
328 P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
329 P_header_sales_credit_TBL IN Sales_credit_tbl_type := G_MISS_sales_credit_TBL,
330 P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
331 P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
332 P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
333 P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
334 P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
335 P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
336 P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
337 P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
338 P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
339 P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
340 P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
341 P_Line_sales_credit_TBL IN Sales_credit_tbl_type := G_MISS_sales_credit_TBL,
342 P_Lot_Serial_Tbl IN Lot_Serial_Tbl_Type
343 := G_MISS_Lot_Serial_Tbl,
344 P_Control_Rec IN Control_Rec_Type := G_MISS_Control_Rec,
345 X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ Order_Header_Rec_Type,
346 X_Order_Line_Tbl OUT NOCOPY /* file.sql.39 change */ Order_Line_Tbl_type,
347 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
348 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
349 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
350 );
351
352
353 -- *******************************************************
354 -- Start of Comments
355 -- *******************************************************
356 -- API Name: Delete_order
357 -- Type : Public
358 -- Pre-Req :
359 -- Parameters:
360 -- IN
361 -- p_api_version_number IN NUMBER Required
362 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
363 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
364 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
365 -- p_order_number IN NUMBER Required
366 -- P_Order_Header_Rec IN Order_Header_Rec_Type
367 --
368 -- OUT:
369 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
370 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
371 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
372 -- Version : Current version 2.0
373 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
374 -- and basic operation, developer must manually add parameters and business logic as necessary.
375 --
376 -- End of Comments
377 --
378 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
379 -- The Master delete procedure may not be needed depends on different business requirements.
380 PROCEDURE Delete_order(
381 P_Api_Version_Number IN NUMBER,
382 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
383 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
384 P_Order_Header_ID IN NUMBER,
385 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
386 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
387 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
388 );
389
390
391 -- This procedure can be used to book orders that are in an entered state.
392
393 PROCEDURE BOOK_ORDER(
394 P_Api_Version_Number IN NUMBER,
395 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
396 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
397 p_order_header_id IN NUMBER,
398 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
399 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
400 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
401 );
402
403
407 PROCEDURE CANCEL_ORDER(
404 -- this procedure is used to cancel an order. if successful it will set the
405 -- cancelled_flag to 'Y' in oe_order_headers
406
408 P_Api_Version_Number IN NUMBER,
409 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
410 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
411 p_order_header_id IN NUMBER,
412 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
413 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
414 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
415 );
416
417
418 --- create order overloaded
419 -- the following procedure is an overloaded procedure which takes the same
420 -- parameters as the create order but all record types are defined in
421 -- ASO_QUOTE_PUB.
422
423 PROCEDURE Create_order(
424 P_Api_Version IN NUMBER,
425 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
426 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
427 P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
428 := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
429 P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
430 := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
431 P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
432 := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
433 P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
434 := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
435 P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
436 := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
437 P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
438 := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
439 P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
440 := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
441 P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
442 := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
443 P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
444 := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
445 P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
446 := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
447 P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
448 := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
449 P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
450 := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
451 P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
452 := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
453 P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
454 := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
455 P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
456 := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
457 P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
458 := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
459 P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
460 := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
461 P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
462 := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
463 P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
464 := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
465 P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
466 := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
467 P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
468 := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
469 P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
470 := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
471 P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
472 := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
473 P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
474 := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
475 P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
476 := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
477 P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
478 := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
479 P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
480 := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
481 P_Control_Rec IN Control_Rec_Type := G_MISS_Control_Rec,
482 X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ Order_Header_Rec_Type,
483 X_Order_Line_Tbl OUT NOCOPY /* file.sql.39 change */ Order_Line_Tbl_type,
484 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
485 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
486 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
487 );
488
489
490
491 PROCEDURE Update_order(
492 P_Api_Version IN NUMBER,
493 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
494 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
495 P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
496 := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
497 P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
498 := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
499 P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
500 := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
501 P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
505 P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
502 := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
503 P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
504 := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
506 := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
507 P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
508 := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
509 P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
510 := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
511 P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
512 := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
513 P_Header_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
514 := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
515 P_Header_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
516 := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
517 P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
518 := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
519 P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
520 := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
521 P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
522 := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
523 P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
524 := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
525 P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
526 := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
527 P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
528 := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
529 P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
530 := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
531 P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
532 := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
533 P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
534 := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
535 P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
536 := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
537 P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
538 P_Line_ATTRIBS_EXT_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
539 := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
540 P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
541 := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
542 P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
543 := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
544 P_Line_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
545 := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
546 P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
547 := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
548 P_Control_Rec IN Control_Rec_Type := G_MISS_Control_Rec,
549 X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ Order_Header_Rec_Type,
550 X_Order_Line_Tbl OUT NOCOPY /* file.sql.39 change */ Order_Line_Tbl_type,
551 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
552 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
553 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
554 );
555
556 PROCEDURE get_acct_site_uses
557 (
558 p_party_site_id IN NUMBER,
559 p_acct_site_type IN VARCHAR2,
560 p_cust_account_id IN NUMBER,
561 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
562 x_site_use_id OUT NOCOPY /* file.sql.39 change */ number
563 );
564
565 PROCEDURE get_cust_acct_roles
566 (
567 p_party_id IN NUMBER,
568 p_party_site_id IN NUMBER,
569 p_acct_site_type IN VARCHAR2,
570 p_cust_account_id IN NUMBER,
571 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
572 x_cust_account_role_id OUT NOCOPY /* file.sql.39 change */ number
573 );
574
575 PROCEDURE Get_Cust_Accnt_Id(
576 P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
577 := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
578 p_Party_Id IN NUMBER,
579 p_Cust_Acct_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
580 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
581 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
582 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
583
584
585
586 FUNCTION Get_Header_Status (
587 p_Header_Id NUMBER) RETURN VARCHAR2;
588
589 FUNCTION Get_Line_Status (
590 p_Line_Id NUMBER) RETURN VARCHAR2;
591
592 FUNCTION Total_Order_Price (
593 p_Header_Id IN NUMBER) RETURN NUMBER;
594
595 FUNCTION Total_List_Price (
596 p_Header_Id IN NUMBER,
597 p_Line_Id in NUMBER,
598 p_line_number in NUMBER,
599 p_shipment_number in number default null) RETURN NUMBER;
600
601 FUNCTION GET_ORDER_TOTAL(
602 P_HEADER_ID IN NUMBER,
603 P_LINE_ID IN NUMBER,
604 P_TOTAL_TYPE IN VARCHAR2 DEFAULT 'ALL')
605 RETURN NUMBER;
606
607 PROCEDURE Initialize_OM_rec_types
608 (
609 px_header_rec IN OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
610 px_line_tbl IN OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
611 p_line_tbl_count IN NUMBER
612 );
613
614 FUNCTION Salesrep_Id (
615 employee_person_id NUMBER
616 )
617 RETURN NUMBER;
618
619 FUNCTION Service_Index (
620 quote_line_id NUMBER := FND_API.G_MISS_NUM,
621 quote_line_index NUMBER := FND_API.G_MISS_NUM,
622 P_Line_Rltship_Tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type ,
623 p_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type
624 )
625 RETURN NUMBER;
626
627 End ASO_ORDER_INT;