1 PACKAGE IBE_Order_W1_PVT AUTHID CURRENT_USER AS
2 /* $Header: IBEVOW1S.pls 115.2 2003/12/19 16:00:12 nsultan noship $ */
3
4
5
6
7 TYPE Control_Rec_Type IS RECORD
8 (
9 SUBMIT_FLAG VARCHAR2(100) := FND_API.G_MISS_CHAR,
10 CANCEL_FLAG VARCHAR2(100) := FND_API.G_MISS_CHAR,
11 CHKCONSTRAINT_FLAG VARCHAR2(100) := FND_API.G_MISS_CHAR
12 );
13
14 G_MISS_Control_Rec Control_Rec_Type;
15
16 PROCEDURE SaveWrapper(
17 x_error_lineids OUT NOCOPY JTF_VARCHAR2_TABLE_300 ,
18 X_failed_line_ids OUT NOCOPY JTF_VARCHAR2_TABLE_300 , --3272918
19 p_api_version_number IN NUMBER := 1 ,
20 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
21 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
22 x_return_status OUT NOCOPY VARCHAR2 ,
23 x_msg_count OUT NOCOPY NUMBER ,
24 x_msg_data OUT NOCOPY VARCHAR2 ,
25 x_order_header_id OUT NOCOPY NUMBER ,
26 x_order_number OUT NOCOPY NUMBER ,
27 x_flow_status_code OUT NOCOPY VARCHAR2 ,
28 x_last_update_date OUT NOCOPY DATE ,
29 p_h_HEADER_ID IN NUMBER :=FND_API.G_MISS_NUM,
30 p_h_OPERATION IN VARCHAR2 :=FND_API.G_MISS_CHAR,
31 p_h_ORG_ID IN NUMBER :=FND_API.G_MISS_NUM,
32 p_h_ORDER_TYPE_ID IN NUMBER :=FND_API.G_MISS_NUM,
33 p_h_ORDER_NUMBER IN NUMBER :=FND_API.G_MISS_NUM,
34 p_h_VERSION_NUMBER IN NUMBER :=FND_API.G_MISS_NUM,
35 p_h_EXPIRATION_DATE IN DATE :=FND_API.G_MISS_DATE,
36 p_h_ORDER_SOURCE_ID IN NUMBER :=FND_API.G_MISS_NUM,
37 p_h_SOURCE_DOCUMENT_TYPE_ID IN NUMBER :=FND_API.G_MISS_NUM,
38 p_h_ORIG_SYS_DOCUMENT_REF IN VARCHAR2 :=FND_API.G_MISS_CHAR,
39 p_h_SOURCE_DOCUMENT_ID IN NUMBER :=FND_API.G_MISS_NUM,
40 p_h_ORDERED_DATE IN DATE :=FND_API.G_MISS_DATE,
41 p_h_REQUEST_DATE IN DATE :=FND_API.G_MISS_DATE,
42 p_h_PRICING_DATE IN DATE :=FND_API.G_MISS_DATE,
43 p_h_SHIPMENT_PRIORITY_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
44 p_h_DEMAND_CLASS_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
45 p_h_PRICE_LIST_ID IN NUMBER :=FND_API.G_MISS_NUM,
46 p_h_TAX_EXEMPT_FLAG IN VARCHAR2 :=FND_API.G_MISS_CHAR,
47 p_h_TAX_EXEMPT_NUMBER IN VARCHAR2 :=FND_API.G_MISS_CHAR,
48 p_h_TAX_EXEMPT_REASON_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
49 p_h_CONVERSION_RATE IN NUMBER :=FND_API.G_MISS_NUM,
50 p_h_CONVERSION_TYPE_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
51 p_h_CONVERSION_RATE_DATE IN DATE :=FND_API.G_MISS_DATE,
52 p_h_PARTIAL_SHIPMENTS_ALLOWED IN VARCHAR2 :=FND_API.G_MISS_CHAR,
53 p_h_SHIP_TOLERANCE_ABOVE IN NUMBER :=FND_API.G_MISS_NUM,
54 p_h_SHIP_TOLERANCE_BELOW IN NUMBER :=FND_API.G_MISS_NUM,
55 p_h_TRANSACTIONAL_CURR_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
56 p_h_AGREEMENT_ID IN NUMBER :=FND_API.G_MISS_NUM,
57 p_h_TAX_POINT_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
58 p_h_CUST_PO_NUMBER IN VARCHAR2 :=FND_API.G_MISS_CHAR,
59 p_h_INVOICING_RULE_ID IN NUMBER :=FND_API.G_MISS_NUM,
60 p_h_ACCOUNTING_RULE_ID IN NUMBER :=FND_API.G_MISS_NUM,
61 p_h_PAYMENT_TERM_ID IN NUMBER :=FND_API.G_MISS_NUM,
62 p_h_SHIPPING_METHOD_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
63 p_h_FREIGHT_CARRIER_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
64 p_h_FOB_POINT_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
65 p_h_FREIGHT_TERMS_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
66 p_h_SOLD_FROM_ORG_ID IN NUMBER :=FND_API.G_MISS_NUM,
67 p_h_SOLD_TO_ORG_ID IN NUMBER :=FND_API.G_MISS_NUM,
68 p_h_SHIP_FROM_ORG_ID IN NUMBER :=FND_API.G_MISS_NUM,
69 p_h_SHIP_TO_ORG_ID IN NUMBER :=FND_API.G_MISS_NUM,
70 p_h_INVOICE_TO_ORG_ID IN NUMBER :=FND_API.G_MISS_NUM,
71 p_h_DELIVER_TO_ORG_ID IN NUMBER :=FND_API.G_MISS_NUM,
72 p_h_SOLD_TO_CONTACT_ID IN NUMBER :=FND_API.G_MISS_NUM,
73 p_h_SHIP_TO_CONTACT_ID IN NUMBER :=FND_API.G_MISS_NUM,
74 p_h_INVOICE_TO_CONTACT_ID IN NUMBER :=FND_API.G_MISS_NUM,
75 p_h_DELIVER_TO_CONTACT_ID IN NUMBER :=FND_API.G_MISS_NUM,
76 p_h_CREATION_DATE IN DATE :=FND_API.G_MISS_DATE,
77 p_h_CREATED_BY IN NUMBER :=FND_API.G_MISS_NUM,
78 p_h_LAST_UPDATED_BY IN NUMBER :=FND_API.G_MISS_NUM,
79 p_h_LAST_UPDATE_DATE IN DATE :=FND_API.G_MISS_DATE,
80 p_h_LAST_UPDATE_LOGIN IN NUMBER :=FND_API.G_MISS_NUM,
81 p_h_PROGRAM_APPLICATION_ID IN NUMBER :=FND_API.G_MISS_NUM,
82 p_h_PROGRAM_ID IN NUMBER :=FND_API.G_MISS_NUM,
83 p_h_PROGRAM_UPDATE_DATE IN DATE :=FND_API.G_MISS_DATE,
84 p_h_REQUEST_ID IN NUMBER :=FND_API.G_MISS_NUM,
85 p_h_CONTEXT IN VARCHAR2 :=FND_API.G_MISS_CHAR,
86 p_h_ATTRIBUTE1 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
87 p_h_ATTRIBUTE2 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
88 p_h_ATTRIBUTE3 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
89 p_h_ATTRIBUTE4 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
90 p_h_ATTRIBUTE5 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
91 p_h_ATTRIBUTE6 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
92 p_h_ATTRIBUTE7 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
93 p_h_ATTRIBUTE8 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
94 p_h_ATTRIBUTE9 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
95 p_h_ATTRIBUTE10 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
96 p_h_ATTRIBUTE11 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
97 p_h_ATTRIBUTE12 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
98 p_h_ATTRIBUTE13 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
99 p_h_ATTRIBUTE14 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
100 p_h_ATTRIBUTE15 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
101 p_h_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2 :=FND_API.G_MISS_CHAR,
102 p_h_GLOBAL_ATTRIBUTE1 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
103 p_h_GLOBAL_ATTRIBUTE2 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
104 p_h_GLOBAL_ATTRIBUTE3 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
105 p_h_GLOBAL_ATTRIBUTE4 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
106 p_h_GLOBAL_ATTRIBUTE5 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
107 p_h_GLOBAL_ATTRIBUTE6 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
108 p_h_GLOBAL_ATTRIBUTE7 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
109 p_h_GLOBAL_ATTRIBUTE8 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
110 p_h_GLOBAL_ATTRIBUTE9 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
111 p_h_GLOBAL_ATTRIBUTE10 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
112 p_h_GLOBAL_ATTRIBUTE11 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
113 p_h_GLOBAL_ATTRIBUTE12 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
114 p_h_GLOBAL_ATTRIBUTE13 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
115 p_h_GLOBAL_ATTRIBUTE14 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
116 p_h_GLOBAL_ATTRIBUTE15 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
117 p_h_GLOBAL_ATTRIBUTE16 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
118 p_h_GLOBAL_ATTRIBUTE17 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
119 p_h_GLOBAL_ATTRIBUTE18 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
120 p_h_GLOBAL_ATTRIBUTE19 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
121 p_h_GLOBAL_ATTRIBUTE20 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
122 p_h_CANCELLED_FLAG IN VARCHAR2 :=FND_API.G_MISS_CHAR,
123 p_h_OPEN_FLAG IN VARCHAR2 :=FND_API.G_MISS_CHAR,
124 p_h_BOOKED_FLAG IN VARCHAR2 :=FND_API.G_MISS_CHAR,
125 p_h_SALESREP_ID IN NUMBER :=FND_API.G_MISS_NUM,
126 p_h_RETURN_REASON_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
127 p_h_ORDER_DATE_TYPE_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
128 p_h_EARLIEST_SCHEDULE_LIMIT IN NUMBER :=FND_API.G_MISS_NUM,
129 p_h_LATEST_SCHEDULE_LIMIT IN NUMBER :=FND_API.G_MISS_NUM,
130 p_h_PAYMENT_TYPE_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
131 p_h_PAYMENT_AMOUNT IN NUMBER :=FND_API.G_MISS_NUM,
132 p_h_CHECK_NUMBER IN VARCHAR2 :=FND_API.G_MISS_CHAR,
133 p_h_CREDIT_CARD_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
134 p_h_CREDIT_CARD_HOLDER_NAME IN VARCHAR2 :=FND_API.G_MISS_CHAR,
135 p_h_CREDIT_CARD_NUMBER IN VARCHAR2 :=FND_API.G_MISS_CHAR,
136 -- p_h_CREDIT_CARD_EXPIRATION_DATE IN DATE :=FND_API.G_MISS_DATE,
137 -- All commented variable names where renamed w/ short var. names because od DB error.
138 p_h_CREDIT_CARD_EXPIR_DATE IN DATE :=FND_API.G_MISS_DATE,
139 p_h_CREDIT_CARD_APPROVAL_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
140 p_h_SALES_CHANNEL_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
141 p_h_FIRST_ACK_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
142 p_h_FIRST_ACK_DATE IN DATE :=FND_API.G_MISS_DATE,
143 p_h_LAST_ACK_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
144 p_h_LAST_ACK_DATE IN DATE :=FND_API.G_MISS_DATE,
145 p_h_ORDER_CATEGORY_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
146 p_h_CHANGE_SEQUENCE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
147 p_h_DROP_SHIP_FLAG IN VARCHAR2 :=FND_API.G_MISS_CHAR,
148 p_h_CUSTOMER_PAYMENT_TERM_ID IN NUMBER :=FND_API.G_MISS_NUM,
149 p_h_SHIPPING_INSTRUCTIONS IN VARCHAR2 :=FND_API.G_MISS_CHAR,
150 p_h_PACKING_INSTRUCTIONS IN VARCHAR2 :=FND_API.G_MISS_CHAR,
151 p_h_TP_CONTEXT IN VARCHAR2 :=FND_API.G_MISS_CHAR,
152 p_h_TP_ATTRIBUTE1 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
153 p_h_TP_ATTRIBUTE2 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
154 p_h_TP_ATTRIBUTE3 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
155 p_h_TP_ATTRIBUTE4 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
156 p_h_TP_ATTRIBUTE5 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
157 p_h_TP_ATTRIBUTE6 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
158 p_h_TP_ATTRIBUTE7 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
159 p_h_TP_ATTRIBUTE8 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
160 p_h_TP_ATTRIBUTE9 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
161 p_h_TP_ATTRIBUTE10 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
162 p_h_TP_ATTRIBUTE11 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
163 p_h_TP_ATTRIBUTE12 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
164 p_h_TP_ATTRIBUTE13 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
165 p_h_TP_ATTRIBUTE14 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
166 p_h_TP_ATTRIBUTE15 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
167 p_h_FLOW_STATUS_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
168 p_h_MARKETING_SOURCE_CODE_ID IN NUMBER :=FND_API.G_MISS_NUM,
169 p_h_CREDIT_CARD_APPROVAL_DATE IN DATE :=FND_API.G_MISS_DATE,
170 p_h_UPGRADED_FLAG IN VARCHAR2 :=FND_API.G_MISS_CHAR,
171 -- p_h_CUSTOMER_PREFERENCE_SET_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
172 p_h_CUSTOMER_PREF_SET_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
173 p_h_BOOKED_DATE IN DATE :=FND_API.G_MISS_DATE,
174 p_h_LOCK_CONTROL IN NUMBER :=FND_API.G_MISS_NUM,
175 p_h_PRICE_REQUEST_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
176 p_h_XML_MESSAGE_ID IN NUMBER :=FND_API.G_MISS_NUM,
177 p_h_ACCOUNTING_RULE_DURATION IN NUMBER :=FND_API.G_MISS_NUM,
178 p_h_attribute16 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
179 p_h_attribute17 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
180 p_h_attribute18 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
181 p_h_attribute19 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
182 p_h_attribute20 IN VARCHAR2 :=FND_API.G_MISS_CHAR,
183 p_h_bill_to_edi_location_code IN VARCHAR2 :=FND_API.G_MISS_CHAR,
184 p_h_Blanket_Number IN NUMBER :=FND_API.G_MISS_NUM,
185 p_h_change_comments IN VARCHAR2 :=FND_API.G_MISS_CHAR,
186 p_h_change_reason IN VARCHAR2 :=FND_API.G_MISS_CHAR,
187 p_h_change_request_code IN VARCHAR2 :=FND_API.G_MISS_CHAR,
188 p_h_db_flag IN VARCHAR2 :=FND_API.G_MISS_CHAR,
189 p_h_Default_Fulfillment_Set IN VARCHAR2 :=FND_API.G_MISS_CHAR,
190 p_h_deliver_to_customer_id IN NUMBER :=FND_API.G_MISS_NUM,
191 p_h_force_apply_flag IN VARCHAR2 :=FND_API.G_MISS_CHAR,
192 p_h_Fulfillment_Set_Name IN VARCHAR2 :=FND_API.G_MISS_CHAR,
193 p_h_INVOICE_ADDRESS_ID IN NUMBER :=FND_API.G_MISS_NUM,
194 p_h_invoice_to_customer_id IN NUMBER :=FND_API.G_MISS_NUM,
195 p_h_SHIP_FROM_ADDRESS_ID IN NUMBER :=FND_API.G_MISS_NUM,
196 p_h_ship_from_edi_loc_code IN VARCHAR2 :=FND_API.G_MISS_CHAR,
197 -- p_h_ship_from_edi_location_code IN VARCHAR2 :=FND_API.G_MISS_CHAR,
198 p_h_Line_Set_Name IN VARCHAR2 :=FND_API.G_MISS_CHAR,
199 p_h_ready_flag IN VARCHAR2 :=FND_API.G_MISS_CHAR,
200 p_h_SHIP_TO_ADDRESS_CODE IN VARCHAR2 :=FND_API.G_MISS_CHAR,
201 p_h_SHIP_TO_ADDRESS_ID IN NUMBER :=FND_API.G_MISS_NUM,
202 p_h_ship_to_customer_id IN NUMBER :=FND_API.G_MISS_NUM,
203 p_h_ship_to_edi_location_code IN VARCHAR2 :=FND_API.G_MISS_CHAR,
204 p_h_SOLD_TO_ADDRESS_ID IN NUMBER :=FND_API.G_MISS_NUM,
205 p_h_sold_to_edi_location_code IN VARCHAR2 :=FND_API.G_MISS_CHAR,
206 p_h_sold_to_phone_id IN NUMBER :=FND_API.G_MISS_NUM,
207 p_h_status_flag IN VARCHAR2 :=FND_API.G_MISS_CHAR,
208 p_h_xml_transaction_type_code IN VARCHAR2 :=FND_API.G_MISS_CHAR,
209 p_l_LINE_ID IN jtf_number_table :=NULL,
210 p_l_OPERATION IN jtf_varchar2_table_100 :=NULL,
211 p_l_ORG_ID IN jtf_number_table :=NULL,
212 p_l_HEADER_ID IN jtf_number_table :=NULL,
213 p_l_LINE_TYPE_ID IN jtf_number_table :=NULL,
214 p_l_LINE_NUMBER IN jtf_number_table :=NULL,
215 p_l_ORDERED_ITEM IN jtf_varchar2_table_300 :=NULL,
216 p_l_REQUEST_DATE IN jtf_date_table :=NULL,
217 p_l_PROMISE_DATE IN jtf_date_table :=NULL,
218 p_l_SCHEDULE_SHIP_DATE IN jtf_date_table :=NULL,
219 p_l_ORDER_QUANTITY_UOM IN jtf_varchar2_table_100 :=NULL,
220 p_l_PRICING_QUANTITY IN jtf_number_table :=NULL,
221 p_l_PRICING_QUANTITY_UOM IN jtf_varchar2_table_300 :=NULL,
222 p_l_CANCELLED_QUANTITY IN jtf_number_table :=NULL,
223 p_l_SHIPPED_QUANTITY IN jtf_number_table :=NULL,
224 p_l_ORDERED_QUANTITY IN jtf_number_table :=NULL,
225 p_l_FULFILLED_QUANTITY IN jtf_number_table :=NULL,
226 p_l_SHIPPING_QUANTITY IN jtf_number_table :=NULL,
227 p_l_SHIPPING_QUANTITY_UOM IN jtf_varchar2_table_100 :=NULL,
228 p_l_DELIVERY_LEAD_TIME IN jtf_number_table :=NULL,
229 p_l_TAX_EXEMPT_FLAG IN jtf_varchar2_table_100 :=NULL,
230 p_l_TAX_EXEMPT_NUMBER IN jtf_varchar2_table_100 :=NULL,
231 p_l_TAX_EXEMPT_REASON_CODE IN jtf_varchar2_table_100 :=NULL,
232 p_l_SHIP_FROM_ORG_ID IN jtf_number_table :=NULL,
233 p_l_SHIP_TO_ORG_ID IN jtf_number_table :=NULL,
234 p_l_INVOICE_TO_ORG_ID IN jtf_number_table :=NULL,
235 p_l_DELIVER_TO_ORG_ID IN jtf_number_table :=NULL,
236 p_l_SHIP_TO_CONTACT_ID IN jtf_number_table :=NULL,
237 p_l_DELIVER_TO_CONTACT_ID IN jtf_number_table :=NULL,
238 p_l_INVOICE_TO_CONTACT_ID IN jtf_number_table :=NULL,
239 p_l_SOLD_FROM_ORG_ID IN jtf_number_table :=NULL,
240 p_l_SOLD_TO_ORG_ID IN jtf_number_table :=NULL,
241 p_l_CUST_PO_NUMBER IN jtf_varchar2_table_100 :=NULL,
242 p_l_SHIP_TOLERANCE_ABOVE IN jtf_number_table :=NULL,
243 p_l_SHIP_TOLERANCE_BELOW IN jtf_number_table :=NULL,
244 p_l_DEMAND_BUCKET_TYPE_CODE IN jtf_varchar2_table_100 :=NULL,
245 p_l_VEH_CUS_ITEM_CUM_KEY_ID IN jtf_number_table :=NULL,
246 p_l_RLA_SCHEDULE_TYPE_CODE IN jtf_varchar2_table_100 :=NULL,
247 p_l_CUSTOMER_DOCK_CODE IN jtf_varchar2_table_100 :=NULL,
248 p_l_CUSTOMER_JOB IN jtf_varchar2_table_100 :=NULL,
249 p_l_CUSTOMER_PRODUCTION_LINE IN jtf_varchar2_table_100 :=NULL,
250 p_l_CUST_MODEL_SERIAL_NUMBER IN jtf_varchar2_table_100 :=NULL,
251 p_l_PROJECT_ID IN jtf_number_table :=NULL,
252 p_l_TASK_ID IN jtf_number_table :=NULL,
253 p_l_INVENTORY_ITEM_ID IN jtf_number_table :=NULL,
254 p_l_TAX_DATE IN jtf_date_table :=NULL,
255 p_l_TAX_CODE IN jtf_varchar2_table_100 :=NULL,
256 p_l_TAX_RATE IN jtf_number_table :=NULL,
257 -- p_l_INVOICE_INTERFACE_STATUS_CODE IN jtf_varchar2_table_100 :=NULL,
258 p_l_INVOICE_INTER_STATUS_CODE IN jtf_varchar2_table_100 :=NULL,
259 p_l_DEMAND_CLASS_CODE IN jtf_varchar2_table_100 :=NULL,
260 p_l_PRICE_LIST_ID IN jtf_number_table :=NULL,
264 p_l_SHIPMENT_PRIORITY_CODE IN jtf_varchar2_table_100 :=NULL,
261 p_l_PRICING_DATE IN jtf_date_table :=NULL,
262 p_l_SHIPMENT_NUMBER IN jtf_number_table :=NULL,
263 p_l_AGREEMENT_ID IN jtf_number_table :=NULL,
265 p_l_SHIPPING_METHOD_CODE IN jtf_varchar2_table_100 :=NULL,
266 p_l_FREIGHT_CARRIER_CODE IN jtf_varchar2_table_100 :=NULL,
267 p_l_FREIGHT_TERMS_CODE IN jtf_varchar2_table_100 :=NULL,
268 p_l_FOB_POINT_CODE IN jtf_varchar2_table_100 :=NULL,
269 p_l_TAX_POINT_CODE IN jtf_varchar2_table_100 :=NULL,
270 p_l_PAYMENT_TERM_ID IN jtf_number_table :=NULL,
271 p_l_INVOICING_RULE_ID IN jtf_number_table :=NULL,
272 p_l_ACCOUNTING_RULE_ID IN jtf_number_table :=NULL,
273 p_l_SOURCE_DOCUMENT_TYPE_ID IN jtf_number_table :=NULL,
274 p_l_ORIG_SYS_DOCUMENT_REF IN jtf_varchar2_table_100 :=NULL,
275 p_l_SOURCE_DOCUMENT_ID IN jtf_number_table :=NULL,
276 p_l_ORIG_SYS_LINE_REF IN jtf_varchar2_table_100 :=NULL,
277 p_l_SOURCE_DOCUMENT_LINE_ID IN jtf_number_table :=NULL,
278 p_l_REFERENCE_LINE_ID IN jtf_number_table :=NULL,
279 p_l_REFERENCE_TYPE IN jtf_varchar2_table_300 :=NULL,
280 p_l_REFERENCE_HEADER_ID IN jtf_number_table :=NULL,
281 p_l_ITEM_REVISION IN jtf_varchar2_table_100 :=NULL,
282 p_l_UNIT_SELLING_PRICE IN jtf_number_table :=NULL,
283 p_l_UNIT_LIST_PRICE IN jtf_number_table :=NULL,
284 p_l_TAX_VALUE IN jtf_number_table :=NULL,
285 p_l_CONTEXT IN jtf_varchar2_table_300 :=NULL,
286 p_l_ATTRIBUTE1 IN jtf_varchar2_table_300 :=NULL,
287 p_l_ATTRIBUTE2 IN jtf_varchar2_table_300 :=NULL,
288 p_l_ATTRIBUTE3 IN jtf_varchar2_table_300 :=NULL,
289 p_l_ATTRIBUTE4 IN jtf_varchar2_table_300 :=NULL,
290 p_l_ATTRIBUTE5 IN jtf_varchar2_table_300 :=NULL,
291 p_l_ATTRIBUTE6 IN jtf_varchar2_table_300 :=NULL,
292 p_l_ATTRIBUTE7 IN jtf_varchar2_table_300 :=NULL,
293 p_l_ATTRIBUTE8 IN jtf_varchar2_table_300 :=NULL,
294 p_l_ATTRIBUTE9 IN jtf_varchar2_table_300 :=NULL,
295 p_l_ATTRIBUTE10 IN jtf_varchar2_table_300 :=NULL,
296 p_l_ATTRIBUTE11 IN jtf_varchar2_table_300 :=NULL,
297 p_l_ATTRIBUTE12 IN jtf_varchar2_table_300 :=NULL,
298 p_l_ATTRIBUTE13 IN jtf_varchar2_table_300 :=NULL,
299 p_l_ATTRIBUTE14 IN jtf_varchar2_table_300 :=NULL,
300 p_l_ATTRIBUTE15 IN jtf_varchar2_table_300 :=NULL,
301 p_l_GLOBAL_ATTRIBUTE_CATEGORY IN jtf_varchar2_table_100 :=NULL,
302 p_l_GLOBAL_ATTRIBUTE1 IN jtf_varchar2_table_300 :=NULL,
303 p_l_GLOBAL_ATTRIBUTE2 IN jtf_varchar2_table_300 :=NULL,
304 p_l_GLOBAL_ATTRIBUTE3 IN jtf_varchar2_table_300 :=NULL,
305 p_l_GLOBAL_ATTRIBUTE4 IN jtf_varchar2_table_300 :=NULL,
306 p_l_GLOBAL_ATTRIBUTE5 IN jtf_varchar2_table_300 :=NULL,
307 p_l_GLOBAL_ATTRIBUTE6 IN jtf_varchar2_table_300 :=NULL,
308 p_l_GLOBAL_ATTRIBUTE7 IN jtf_varchar2_table_300 :=NULL,
309 p_l_GLOBAL_ATTRIBUTE8 IN jtf_varchar2_table_300 :=NULL,
310 p_l_GLOBAL_ATTRIBUTE9 IN jtf_varchar2_table_300 :=NULL,
311 p_l_GLOBAL_ATTRIBUTE10 IN jtf_varchar2_table_300 :=NULL,
312 p_l_GLOBAL_ATTRIBUTE11 IN jtf_varchar2_table_300 :=NULL,
313 p_l_GLOBAL_ATTRIBUTE12 IN jtf_varchar2_table_300 :=NULL,
314 p_l_GLOBAL_ATTRIBUTE13 IN jtf_varchar2_table_300 :=NULL,
315 p_l_GLOBAL_ATTRIBUTE14 IN jtf_varchar2_table_300 :=NULL,
316 p_l_GLOBAL_ATTRIBUTE15 IN jtf_varchar2_table_300 :=NULL,
317 p_l_GLOBAL_ATTRIBUTE16 IN jtf_varchar2_table_300 :=NULL,
318 p_l_GLOBAL_ATTRIBUTE17 IN jtf_varchar2_table_300 :=NULL,
319 p_l_GLOBAL_ATTRIBUTE18 IN jtf_varchar2_table_300 :=NULL,
320 p_l_GLOBAL_ATTRIBUTE19 IN jtf_varchar2_table_300 :=NULL,
321 p_l_GLOBAL_ATTRIBUTE20 IN jtf_varchar2_table_300 :=NULL,
322 p_l_PRICING_CONTEXT IN jtf_varchar2_table_300 :=NULL,
323 p_l_PRICING_ATTRIBUTE1 IN jtf_varchar2_table_300 :=NULL,
324 p_l_PRICING_ATTRIBUTE2 IN jtf_varchar2_table_300 :=NULL,
325 p_l_PRICING_ATTRIBUTE3 IN jtf_varchar2_table_300 :=NULL,
326 p_l_PRICING_ATTRIBUTE4 IN jtf_varchar2_table_300 :=NULL,
327 p_l_PRICING_ATTRIBUTE5 IN jtf_varchar2_table_300 :=NULL,
328 p_l_PRICING_ATTRIBUTE6 IN jtf_varchar2_table_300 :=NULL,
329 p_l_PRICING_ATTRIBUTE7 IN jtf_varchar2_table_300 :=NULL,
330 p_l_PRICING_ATTRIBUTE8 IN jtf_varchar2_table_300 :=NULL,
331 p_l_PRICING_ATTRIBUTE9 IN jtf_varchar2_table_300 :=NULL,
332 p_l_PRICING_ATTRIBUTE10 IN jtf_varchar2_table_300 :=NULL,
333 p_l_INDUSTRY_CONTEXT IN jtf_varchar2_table_100 :=NULL,
334 p_l_INDUSTRY_ATTRIBUTE1 IN jtf_varchar2_table_300 :=NULL,
335 p_l_INDUSTRY_ATTRIBUTE2 IN jtf_varchar2_table_300 :=NULL,
336 p_l_INDUSTRY_ATTRIBUTE3 IN jtf_varchar2_table_300 :=NULL,
337 p_l_INDUSTRY_ATTRIBUTE4 IN jtf_varchar2_table_300 :=NULL,
338 p_l_INDUSTRY_ATTRIBUTE5 IN jtf_varchar2_table_300 :=NULL,
339 p_l_INDUSTRY_ATTRIBUTE6 IN jtf_varchar2_table_300 :=NULL,
340 p_l_INDUSTRY_ATTRIBUTE7 IN jtf_varchar2_table_300 :=NULL,
341 p_l_INDUSTRY_ATTRIBUTE8 IN jtf_varchar2_table_300 :=NULL,
342 p_l_INDUSTRY_ATTRIBUTE9 IN jtf_varchar2_table_300 :=NULL,
343 p_l_INDUSTRY_ATTRIBUTE10 IN jtf_varchar2_table_300 :=NULL,
344 p_l_INDUSTRY_ATTRIBUTE11 IN jtf_varchar2_table_300 :=NULL,
345 p_l_INDUSTRY_ATTRIBUTE13 IN jtf_varchar2_table_300 :=NULL,
346 p_l_INDUSTRY_ATTRIBUTE12 IN jtf_varchar2_table_300 :=NULL,
347 p_l_INDUSTRY_ATTRIBUTE14 IN jtf_varchar2_table_300 :=NULL,
348 p_l_INDUSTRY_ATTRIBUTE15 IN jtf_varchar2_table_300 :=NULL,
349 p_l_INDUSTRY_ATTRIBUTE16 IN jtf_varchar2_table_300 :=NULL,
350 p_l_INDUSTRY_ATTRIBUTE17 IN jtf_varchar2_table_300 :=NULL,
351 p_l_INDUSTRY_ATTRIBUTE18 IN jtf_varchar2_table_300 :=NULL,
352 p_l_INDUSTRY_ATTRIBUTE19 IN jtf_varchar2_table_300 :=NULL,
353 p_l_INDUSTRY_ATTRIBUTE20 IN jtf_varchar2_table_300 :=NULL,
354 p_l_INDUSTRY_ATTRIBUTE21 IN jtf_varchar2_table_300 :=NULL,
355 p_l_INDUSTRY_ATTRIBUTE22 IN jtf_varchar2_table_300 :=NULL,
356 p_l_INDUSTRY_ATTRIBUTE23 IN jtf_varchar2_table_300 :=NULL,
357 p_l_INDUSTRY_ATTRIBUTE24 IN jtf_varchar2_table_300 :=NULL,
358 p_l_INDUSTRY_ATTRIBUTE25 IN jtf_varchar2_table_300 :=NULL,
359 p_l_INDUSTRY_ATTRIBUTE26 IN jtf_varchar2_table_300 :=NULL,
360 p_l_INDUSTRY_ATTRIBUTE27 IN jtf_varchar2_table_300 :=NULL,
361 p_l_INDUSTRY_ATTRIBUTE28 IN jtf_varchar2_table_300 :=NULL,
362 p_l_INDUSTRY_ATTRIBUTE29 IN jtf_varchar2_table_300 :=NULL,
363 p_l_INDUSTRY_ATTRIBUTE30 IN jtf_varchar2_table_300 :=NULL,
364 p_l_CREATION_DATE IN jtf_date_table :=NULL,
365 p_l_CREATED_BY IN jtf_number_table :=NULL,
366 p_l_LAST_UPDATE_DATE IN jtf_date_table :=NULL,
367 p_l_LAST_UPDATED_BY IN jtf_number_table :=NULL,
368 p_l_LAST_UPDATE_LOGIN IN jtf_number_table :=NULL,
369 p_l_PROGRAM_APPLICATION_ID IN jtf_number_table :=NULL,
370 p_l_PROGRAM_ID IN jtf_number_table :=NULL,
371 p_l_PROGRAM_UPDATE_DATE IN jtf_date_table :=NULL,
372 p_l_REQUEST_ID IN jtf_number_table :=NULL,
373 p_l_TOP_MODEL_LINE_ID IN jtf_number_table :=NULL,
374 p_l_LINK_TO_LINE_ID IN jtf_number_table :=NULL,
375 p_l_COMPONENT_SEQUENCE_ID IN jtf_number_table :=NULL,
376 p_l_COMPONENT_CODE IN jtf_varchar2_table_300 :=NULL,
377 p_l_CONFIG_DISPLAY_SEQUENCE IN jtf_number_table :=NULL,
378 p_l_SORT_ORDER IN jtf_varchar2_table_300 :=NULL,
379 p_l_ITEM_TYPE_CODE IN jtf_varchar2_table_100 :=NULL,
380 p_l_OPTION_NUMBER IN jtf_number_table :=NULL,
381 p_l_OPTION_FLAG IN jtf_varchar2_table_100 :=NULL,
382 p_l_DEP_PLAN_REQUIRED_FLAG IN jtf_varchar2_table_100 :=NULL,
383 p_l_VISIBLE_DEMAND_FLAG IN jtf_varchar2_table_100 :=NULL,
384 p_l_LINE_CATEGORY_CODE IN jtf_varchar2_table_100 :=NULL,
385 p_l_ACTUAL_SHIPMENT_DATE IN jtf_date_table :=NULL,
386 p_l_CUSTOMER_TRX_LINE_ID IN jtf_number_table :=NULL,
387 p_l_RETURN_CONTEXT IN jtf_varchar2_table_100 :=NULL,
388 p_l_RETURN_ATTRIBUTE1 IN jtf_varchar2_table_300 :=NULL,
389 p_l_RETURN_ATTRIBUTE2 IN jtf_varchar2_table_300 :=NULL,
390 p_l_RETURN_ATTRIBUTE3 IN jtf_varchar2_table_300 :=NULL,
391 p_l_RETURN_ATTRIBUTE4 IN jtf_varchar2_table_300 :=NULL,
392 p_l_RETURN_ATTRIBUTE5 IN jtf_varchar2_table_300 :=NULL,
393 p_l_RETURN_ATTRIBUTE6 IN jtf_varchar2_table_300 :=NULL,
394 p_l_RETURN_ATTRIBUTE7 IN jtf_varchar2_table_300 :=NULL,
395 p_l_RETURN_ATTRIBUTE8 IN jtf_varchar2_table_300 :=NULL,
396 p_l_RETURN_ATTRIBUTE9 IN jtf_varchar2_table_300 :=NULL,
397 p_l_RETURN_ATTRIBUTE10 IN jtf_varchar2_table_300 :=NULL,
398 p_l_RETURN_ATTRIBUTE11 IN jtf_varchar2_table_300 :=NULL,
399 p_l_RETURN_ATTRIBUTE12 IN jtf_varchar2_table_300 :=NULL,
400 p_l_RETURN_ATTRIBUTE13 IN jtf_varchar2_table_300 :=NULL,
401 p_l_RETURN_ATTRIBUTE14 IN jtf_varchar2_table_300 :=NULL,
402 p_l_RETURN_ATTRIBUTE15 IN jtf_varchar2_table_300 :=NULL,
403 p_l_ACTUAL_ARRIVAL_DATE IN jtf_date_table :=NULL,
404 p_l_ATO_LINE_ID IN jtf_number_table :=NULL,
405 p_l_AUTO_SELECTED_QUANTITY IN jtf_number_table :=NULL,
406 p_l_COMPONENT_NUMBER IN jtf_number_table :=NULL,
407 p_l_EARLIEST_ACCEPTABLE_DATE IN jtf_date_table :=NULL,
408 p_l_EXPLOSION_DATE IN jtf_date_table :=NULL,
409 p_l_LATEST_ACCEPTABLE_DATE IN jtf_date_table :=NULL,
410 p_l_MODEL_GROUP_NUMBER IN jtf_number_table :=NULL,
411 p_l_SCHEDULE_ARRIVAL_DATE IN jtf_date_table :=NULL,
412 p_l_SHIP_MODEL_COMPLETE_FLAG IN jtf_varchar2_table_100 :=NULL,
413 p_l_SCHEDULE_STATUS_CODE IN jtf_varchar2_table_100 :=NULL,
414 p_l_SOURCE_TYPE_CODE IN jtf_varchar2_table_100 :=NULL,
415 p_l_CANCELLED_FLAG IN jtf_varchar2_table_100 :=NULL,
416 p_l_OPEN_FLAG IN jtf_varchar2_table_100 :=NULL,
417 p_l_BOOKED_FLAG IN jtf_varchar2_table_100 :=NULL,
418 p_l_SALESREP_ID IN jtf_number_table :=NULL,
419 p_l_RETURN_REASON_CODE IN jtf_varchar2_table_100 :=NULL,
420 p_l_ARRIVAL_SET_ID IN jtf_number_table :=NULL,
421 p_l_SHIP_SET_ID IN jtf_number_table :=NULL,
422 p_l_SPLIT_FROM_LINE_ID IN jtf_number_table :=NULL,
423 p_l_CUST_PRODUCTION_SEQ_NUM IN jtf_varchar2_table_100 :=NULL,
424 p_l_AUTHORIZED_TO_SHIP_FLAG IN jtf_varchar2_table_300 :=NULL,
425 p_l_OVER_SHIP_REASON_CODE IN jtf_varchar2_table_100 :=NULL,
426 p_l_OVER_SHIP_RESOLVED_FLAG IN jtf_varchar2_table_100 :=NULL,
427 p_l_ORDERED_ITEM_ID IN jtf_number_table :=NULL,
428 p_l_ITEM_IDENTIFIER_TYPE IN jtf_varchar2_table_100 :=NULL,
429 p_l_CONFIGURATION_ID IN jtf_number_table :=NULL,
430 p_l_COMMITMENT_ID IN jtf_number_table :=NULL,
431 p_l_SHIPPING_INTERFACED_FLAG IN jtf_varchar2_table_100 :=NULL,
432 p_l_CREDIT_INVOICE_LINE_ID IN jtf_number_table :=NULL,
433 p_l_FIRST_ACK_CODE IN jtf_varchar2_table_100 :=NULL,
434 p_l_FIRST_ACK_DATE IN jtf_date_table :=NULL,
435 p_l_LAST_ACK_CODE IN jtf_varchar2_table_100 :=NULL,
436 p_l_LAST_ACK_DATE IN jtf_date_table :=NULL,
437 p_l_PLANNING_PRIORITY IN jtf_number_table :=NULL,
438 p_l_ORDER_SOURCE_ID IN jtf_number_table :=NULL,
439 p_l_ORIG_SYS_SHIPMENT_REF IN jtf_varchar2_table_100 :=NULL,
440 p_l_CHANGE_SEQUENCE IN jtf_varchar2_table_100 :=NULL,
441 p_l_DROP_SHIP_FLAG IN jtf_varchar2_table_100 :=NULL,
442 p_l_CUSTOMER_LINE_NUMBER IN jtf_varchar2_table_100 :=NULL,
443 p_l_CUSTOMER_SHIPMENT_NUMBER IN jtf_varchar2_table_100 :=NULL,
444 p_l_CUSTOMER_ITEM_NET_PRICE IN jtf_number_table :=NULL,
445 p_l_CUSTOMER_PAYMENT_TERM_ID IN jtf_number_table :=NULL,
446 p_l_FULFILLED_FLAG IN jtf_varchar2_table_100 :=NULL,
447 p_l_END_ITEM_UNIT_NUMBER IN jtf_varchar2_table_100 :=NULL,
448 p_l_CONFIG_HEADER_ID IN jtf_number_table :=NULL,
449 p_l_CONFIG_REV_NBR IN jtf_number_table :=NULL,
450 p_l_MFG_COMPONENT_SEQUENCE_ID IN jtf_number_table :=NULL,
451 p_l_SHIPPING_INSTRUCTIONS IN jtf_varchar2_table_300 :=NULL,
452 p_l_PACKING_INSTRUCTIONS IN jtf_varchar2_table_300 :=NULL,
453 p_l_INVOICED_QUANTITY IN jtf_number_table :=NULL,
454 -- p_l_REFERENCE_CUSTOMER_TRX_LINE_ID IN jtf_number_table :=NULL,
455 p_l_REF_CUSTOMER_TRX_LINE_ID IN jtf_number_table :=NULL,
456 p_l_SPLIT_BY IN jtf_varchar2_table_300 :=NULL,
457 p_l_LINE_SET_ID IN jtf_number_table :=NULL,
458 p_l_SERVICE_TXN_REASON_CODE IN jtf_varchar2_table_100 :=NULL,
459 p_l_SERVICE_TXN_COMMENTS IN jtf_varchar2_table_300 :=NULL,
460 p_l_SERVICE_DURATION IN jtf_number_table :=NULL,
461 p_l_SERVICE_START_DATE IN jtf_date_table :=NULL,
462 p_l_SERVICE_END_DATE IN jtf_date_table :=NULL,
463 p_l_SERVICE_COTERMINATE_FLAG IN jtf_varchar2_table_100 :=NULL,
464 p_l_UNIT_LIST_PERCENT IN jtf_number_table :=NULL,
465 p_l_UNIT_SELLING_PERCENT IN jtf_number_table :=NULL,
466 p_l_UNIT_PERCENT_BASE_PRICE IN jtf_number_table :=NULL,
467 p_l_SERVICE_NUMBER IN jtf_number_table :=NULL,
468 p_l_SERVICE_PERIOD IN jtf_varchar2_table_100 :=NULL,
469 p_l_SHIPPABLE_FLAG IN jtf_varchar2_table_100 :=NULL,
470 p_l_MODEL_REMNANT_FLAG IN jtf_varchar2_table_100 :=NULL,
471 p_l_RE_SOURCE_FLAG IN jtf_varchar2_table_300 :=NULL,
472 p_l_FLOW_STATUS_CODE IN jtf_varchar2_table_100 :=NULL,
473 p_l_TP_CONTEXT IN jtf_varchar2_table_100 :=NULL,
474 p_l_TP_ATTRIBUTE1 IN jtf_varchar2_table_300 :=NULL,
475 p_l_TP_ATTRIBUTE2 IN jtf_varchar2_table_300 :=NULL,
476 p_l_TP_ATTRIBUTE3 IN jtf_varchar2_table_300 :=NULL,
477 p_l_TP_ATTRIBUTE4 IN jtf_varchar2_table_300 :=NULL,
478 p_l_TP_ATTRIBUTE5 IN jtf_varchar2_table_300 :=NULL,
479 p_l_TP_ATTRIBUTE6 IN jtf_varchar2_table_300 :=NULL,
480 p_l_TP_ATTRIBUTE7 IN jtf_varchar2_table_300 :=NULL,
481 p_l_TP_ATTRIBUTE8 IN jtf_varchar2_table_300 :=NULL,
482 p_l_TP_ATTRIBUTE9 IN jtf_varchar2_table_300 :=NULL,
483 p_l_TP_ATTRIBUTE10 IN jtf_varchar2_table_300 :=NULL,
484 p_l_TP_ATTRIBUTE11 IN jtf_varchar2_table_300 :=NULL,
485 p_l_TP_ATTRIBUTE12 IN jtf_varchar2_table_300 :=NULL,
486 p_l_TP_ATTRIBUTE13 IN jtf_varchar2_table_300 :=NULL,
487 p_l_TP_ATTRIBUTE14 IN jtf_varchar2_table_300 :=NULL,
488 p_l_TP_ATTRIBUTE15 IN jtf_varchar2_table_300 :=NULL,
489 p_l_FULFILLMENT_METHOD_CODE IN jtf_varchar2_table_300 :=NULL,
490 p_l_MARKETING_SOURCE_CODE_ID IN jtf_number_table :=NULL,
491 -- p_l_SERVICE_REFERENCE_TYPE_CODE IN jtf_varchar2_table_100 :=NULL,
492 p_l_SERVICE_REF_TYPE_CODE IN jtf_varchar2_table_100 :=NULL,
493 p_l_SERVICE_REFERENCE_LINE_ID IN jtf_number_table :=NULL,
494 -- p_l_SERVICE_REFERENCE_SYSTEM_ID IN jtf_number_table :=NULL,
495 p_l_SERVICE_REF_SYSTEM_ID IN jtf_number_table :=NULL,
496 p_l_CALCULATE_PRICE_FLAG IN jtf_varchar2_table_100 :=NULL,
497 p_l_UPGRADED_FLAG IN jtf_varchar2_table_100 :=NULL,
498 p_l_REVENUE_AMOUNT IN jtf_number_table :=NULL,
499 p_l_FULFILLMENT_DATE IN jtf_date_table :=NULL,
500 p_l_PREFERRED_GRADE IN jtf_varchar2_table_100 :=NULL,
501 p_l_ORDERED_QUANTITY2 IN jtf_number_table :=NULL,
502 p_l_ORDERED_QUANTITY_UOM2 IN jtf_varchar2_table_100 :=NULL,
503 p_l_SHIPPING_QUANTITY2 IN jtf_number_table :=NULL,
504 p_l_CANCELLED_QUANTITY2 IN jtf_number_table :=NULL,
505 p_l_SHIPPED_QUANTITY2 IN jtf_number_table :=NULL,
506 p_l_SHIPPING_QUANTITY_UOM2 IN jtf_varchar2_table_100 :=NULL,
507 p_l_FULFILLED_QUANTITY2 IN jtf_number_table :=NULL,
508 p_l_MFG_LEAD_TIME IN jtf_number_table :=NULL,
509 p_l_LOCK_CONTROL IN jtf_number_table :=NULL,
510 p_l_SUBINVENTORY IN jtf_varchar2_table_100 :=NULL,
511 p_l_UNIT_LIST_PRICE_PER_PQTY IN jtf_number_table :=NULL,
512 -- p_l_UNIT_SELLING_PRICE_PER_PQTY IN jtf_number_table :=NULL,
513 p_l_UNIT_SELL_PRICE_PER_PQTY IN jtf_number_table :=NULL,
514 p_l_PRICE_REQUEST_CODE IN jtf_varchar2_table_300 :=NULL,
515 p_l_ORIGINAL_INVENTORY_ITEM_ID IN jtf_number_table :=NULL,
516 p_l_ORIGINAL_ORDERED_ITEM_ID IN jtf_number_table :=NULL,
517 p_l_ORIGINAL_ORDERED_ITEM IN jtf_varchar2_table_300 :=NULL,
518 -- p_l_ORIGINAL_ITEM_IDENTIFIER_TYPE IN jtf_varchar2_table_100 :=NULL,
519 p_l_ORIGINAL_ITEM_IDENTIF_TYPE IN jtf_varchar2_table_100 :=NULL,
520 -- p_l_ITEM_SUBSTITUTION_TYPE_CODE IN jtf_varchar2_table_100 :=NULL,
521 p_l_ITEM_SUBSTIT_TYPE_CODE IN jtf_varchar2_table_100 :=NULL,
522 p_l_OVERRIDE_ATP_DATE_CODE IN jtf_varchar2_table_100 :=NULL,
523 p_l_LATE_DEMAND_PENALTY_FACTOR IN jtf_number_table :=NULL,
524 p_l_ACCOUNTING_RULE_DURATION IN jtf_number_table :=NULL,
525 p_l_top_model_line_index IN jtf_number_table :=null,
526 p_l_top_model_line_ref IN jtf_varchar2_table_100 :=null,
527 p_l_unit_cost IN jtf_number_table :=null,
528 p_l_xml_transaction_type_code IN jtf_varchar2_table_100 :=null,
529 p_l_Sold_to_address_id IN jtf_number_table :=null,
530 p_l_Split_Action_Code IN jtf_varchar2_table_100 :=null,
531 p_l_split_from_line_ref IN jtf_varchar2_table_100 :=null,
532 p_l_split_from_shipment_ref IN jtf_varchar2_table_100 :=null,
533 p_l_status_flag IN jtf_varchar2_table_100 :=null,
534 -- p_l_ship_from_edi_location_code IN jtf_varchar2_table_100 :=null,
535 p_l_ship_from_edi_loc_code IN jtf_varchar2_table_100 :=null,
536 p_l_ship_set IN jtf_varchar2_table_100 :=null,
537 p_l_Ship_to_address_code IN jtf_varchar2_table_100 :=null,
538 p_l_Ship_to_address_id IN jtf_varchar2_table_300 :=null,
539 p_l_ship_to_customer_id IN jtf_number_table :=null,
540 p_l_ship_to_edi_location_code IN jtf_varchar2_table_100 :=null,
541 p_l_service_ref_line_number IN jtf_number_table :=null,
542 p_l_service_ref_option_number IN jtf_number_table :=null,
543 p_l_service_ref_order_number IN jtf_number_table :=null,
544 -- p_l_service_ref_shipment_number IN jtf_number_table :=null,
545 p_l_service_ref_ship_number IN jtf_number_table :=null,
546 p_l_service_reference_line IN jtf_varchar2_table_100 :=null,
547 p_l_service_reference_order IN jtf_varchar2_table_100 :=null,
548 p_l_service_reference_system IN jtf_varchar2_table_100 :=null,
549 p_l_reserved_quantity IN jtf_number_table :=null,
550 p_l_return_status IN jtf_varchar2_table_100 :=null,
551 p_l_schedule_action_code IN jtf_varchar2_table_100 :=null,
552 p_l_service_line_index IN jtf_number_table :=null,
553 --p_l_intermed_ship_to_contact_id IN jtf_number_table :=null,
554 p_l_intermed_ship_to_cont_id IN jtf_number_table :=null,
555 p_l_intermed_ship_to_org_id IN jtf_number_table :=null,
556 p_l_Invoice_address_id IN jtf_number_table :=null,
557 p_l_invoice_to_customer_id IN jtf_number_table :=null,
558 p_l_item_relationship_type IN jtf_number_table :=null,
559 p_l_link_to_line_index IN jtf_number_table :=null,
560 p_l_link_to_line_ref IN jtf_varchar2_table_100 :=null,
561 p_l_db_flag IN jtf_varchar2_table_100 :=null,
562 p_l_deliver_to_customer_id IN jtf_number_table :=null,
563 p_l_fulfillment_set IN jtf_varchar2_table_100 :=null,
564 p_l_fulfillment_set_id IN jtf_number_table :=null,
565 p_l_change_comments IN jtf_varchar2_table_300 :=null,
566 p_l_change_reason IN jtf_varchar2_table_100 :=null,
567 p_l_change_request_code IN jtf_varchar2_table_100 :=null,
568 p_l_Bill_to_Edi_Location_Code IN jtf_varchar2_table_100 :=null,
569 p_l_Blanket_Line_Number IN jtf_number_table :=null,
570 p_l_Blanket_Number IN jtf_number_table :=null,
571 p_l_Blanket_Version_Number IN jtf_number_table :=null,
572 p_l_arrival_set IN jtf_varchar2_table_100 :=null,
573 p_l_attribute16 IN jtf_varchar2_table_300 :=null,
574 p_l_attribute17 IN jtf_varchar2_table_300 :=null,
575 p_l_attribute18 IN jtf_varchar2_table_300 :=null,
576 p_l_attribute19 IN jtf_varchar2_table_300 :=null,
577 p_l_attribute20 IN jtf_varchar2_table_300 :=null,
578 p_c_CANCEL_FLAG IN VARCHAR2 :=FND_API.G_MISS_CHAR,
579 p_c_SUBMIT_FLAG IN VARCHAR2 :=FND_API.G_MISS_CHAR,
580 p_c_CHKCONSTRAINT_FLAG IN VARCHAR2 :=FND_API.G_MISS_CHAR,
581 p_party_id IN NUMBER := FND_API.G_MISS_NUM,
582 p_shipto_partysite_id IN NUMBER := FND_API.G_MISS_NUM,
583 p_billto_partysite_id IN NUMBER := FND_API.G_MISS_NUM,
584 p_save_type IN NUMBER := FND_API.G_MISS_NUM
585 );
586
587 --IBE_Util.Debug('In SaveWrapper package - End');
588
589 END IBE_Order_W1_PVT;
[Home] [Help]