1 PACKAGE BODY IBE_Order_W1_PVT AS
2 /* $Header: IBEVOW1B.pls 120.0.12010000.2 2009/06/26 10:01:00 scnagara ship $ */
3
4 l_true VARCHAR2(1) := FND_API.G_TRUE;
5
6
7 ROSETTA_G_MISS_DATE DATE := TO_DATE('01/01/+4713', 'MM/DD/SYYYY');
8 ROSETTA_G_MISS_NUM NUMBER := 0-1962.0724;
9
10 PROCEDURE Construct_Ctrl_Rec(
11 p_submit_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
12 ,p_cancel_flag IN VARCHAR2
13 ,p_chkconstraint_flag IN VARCHAR2
14 ,x_control_rec OUT NOCOPY Control_Rec_Type
15 )
16 IS
17 -- l_control_rec Control_Rec_Type := G_MISS_Control_Rec;
18
19 BEGIN
20 IF (IBE_UTIL.G_DEBUGON = l_true) THEN
21 IBE_Util.Debug('In Returns construct controlrec package body - Begin');
22 END IF;
23
24 x_control_rec.SUBMIT_FLAG := p_submit_flag;
25 x_control_rec.CANCEL_FLAG := p_cancel_flag;
26 x_control_rec.CHKCONSTRAINT_FLAG := p_chkconstraint_flag;
27
28
29 IF (IBE_UTIL.G_DEBUGON = l_true) THEN
30 IBE_Util.Debug('In Returns construct controlrec package body - End');
31 END IF;
32
33 END Construct_Ctrl_Rec;
34
35
36 Function Construct_Line_Tbl(
37 p_LINE_ID IN jtf_number_table := NULL
38 ,p_OPERATION IN jtf_varchar2_table_100 := NULL
39 ,p_ORG_ID IN jtf_number_table := NULL
40 ,p_HEADER_ID IN jtf_number_table := NULL
41 ,p_LINE_TYPE_ID IN jtf_number_table := NULL
42 ,p_LINE_NUMBER IN jtf_number_table := NULL
43 ,p_ORDERED_ITEM IN jtf_varchar2_table_300 := NULL
44 ,p_REQUEST_DATE IN jtf_date_table := NULL
45 ,p_PROMISE_DATE IN jtf_date_table := NULL
46 ,p_SCHEDULE_SHIP_DATE IN jtf_date_table := NULL
47 ,p_ORDER_QUANTITY_UOM IN jtf_varchar2_table_100 := NULL
48 ,p_PRICING_QUANTITY IN jtf_number_table := NULL
49 ,p_PRICING_QUANTITY_UOM IN jtf_varchar2_table_300 := NULL
50 ,p_CANCELLED_QUANTITY IN jtf_number_table := NULL
51 ,p_SHIPPED_QUANTITY IN jtf_number_table := NULL
52 ,p_ORDERED_QUANTITY IN jtf_number_table := NULL
53 ,p_FULFILLED_QUANTITY IN jtf_number_table := NULL
54 ,p_SHIPPING_QUANTITY IN jtf_number_table := NULL
55 ,p_SHIPPING_QUANTITY_UOM IN jtf_varchar2_table_100 := NULL
56 ,p_DELIVERY_LEAD_TIME IN jtf_number_table := NULL
57 ,p_TAX_EXEMPT_FLAG IN jtf_varchar2_table_100 := NULL
58 ,p_TAX_EXEMPT_NUMBER IN jtf_varchar2_table_100 := NULL
59 ,p_TAX_EXEMPT_REASON_CODE IN jtf_varchar2_table_100 := NULL
60 ,p_SHIP_FROM_ORG_ID IN jtf_number_table := NULL
61 ,p_SHIP_TO_ORG_ID IN jtf_number_table := NULL
62 ,p_INVOICE_TO_ORG_ID IN jtf_number_table := NULL
63 ,p_DELIVER_TO_ORG_ID IN jtf_number_table := NULL
64 ,p_SHIP_TO_CONTACT_ID IN jtf_number_table := NULL
65 ,p_DELIVER_TO_CONTACT_ID IN jtf_number_table := NULL
66 ,p_INVOICE_TO_CONTACT_ID IN jtf_number_table := NULL
67 ,p_SOLD_FROM_ORG_ID IN jtf_number_table := NULL
68 ,p_SOLD_TO_ORG_ID IN jtf_number_table := NULL
69 ,p_CUST_PO_NUMBER IN jtf_varchar2_table_100 := NULL
70 ,p_SHIP_TOLERANCE_ABOVE IN jtf_number_table := NULL
71 ,p_SHIP_TOLERANCE_BELOW IN jtf_number_table := NULL
72 ,p_DEMAND_BUCKET_TYPE_CODE IN jtf_varchar2_table_100 := NULL
73 ,p_VEH_CUS_ITEM_CUM_KEY_ID IN jtf_number_table := NULL
74 ,p_RLA_SCHEDULE_TYPE_CODE IN jtf_varchar2_table_100 := NULL
75 ,p_CUSTOMER_DOCK_CODE IN jtf_varchar2_table_100 := NULL
76 ,p_CUSTOMER_JOB IN jtf_varchar2_table_100 := NULL
77 ,p_CUSTOMER_PRODUCTION_LINE IN jtf_varchar2_table_100 := NULL
78 ,p_CUST_MODEL_SERIAL_NUMBER IN jtf_varchar2_table_100 := NULL
79 ,p_PROJECT_ID IN jtf_number_table := NULL
80 ,p_TASK_ID IN jtf_number_table := NULL
81 ,p_INVENTORY_ITEM_ID IN jtf_number_table := NULL
82 ,p_TAX_DATE IN jtf_date_table := NULL
83 ,p_TAX_CODE IN jtf_varchar2_table_100 := NULL
84 ,p_TAX_RATE IN jtf_number_table := NULL
85 ,p_INVOICE_INTER_STATUS_CODE IN jtf_varchar2_table_100 := NULL
86 ,p_DEMAND_CLASS_CODE IN jtf_varchar2_table_100 := NULL
87 ,p_PRICE_LIST_ID IN jtf_number_table := NULL
88 ,p_PRICING_DATE IN jtf_date_table := NULL
89 ,p_SHIPMENT_NUMBER IN jtf_number_table := NULL
90 ,p_AGREEMENT_ID IN jtf_number_table := NULL
91 ,p_SHIPMENT_PRIORITY_CODE IN jtf_varchar2_table_100 := NULL
92 ,p_SHIPPING_METHOD_CODE IN jtf_varchar2_table_100 := NULL
93 ,p_FREIGHT_CARRIER_CODE IN jtf_varchar2_table_100 := NULL
94 ,p_FREIGHT_TERMS_CODE IN jtf_varchar2_table_100 := NULL
95 ,p_FOB_POINT_CODE IN jtf_varchar2_table_100 := NULL
96 ,p_TAX_POINT_CODE IN jtf_varchar2_table_100 := NULL
97 ,p_PAYMENT_TERM_ID IN jtf_number_table := NULL
98 ,p_INVOICING_RULE_ID IN jtf_number_table := NULL
99 ,p_ACCOUNTING_RULE_ID IN jtf_number_table := NULL
100 ,p_SOURCE_DOCUMENT_TYPE_ID IN jtf_number_table := NULL
101 ,p_ORIG_SYS_DOCUMENT_REF IN jtf_varchar2_table_100 := NULL
102 ,p_SOURCE_DOCUMENT_ID IN jtf_number_table := NULL
103 ,p_ORIG_SYS_LINE_REF IN jtf_varchar2_table_100 := NULL
104 ,p_SOURCE_DOCUMENT_LINE_ID IN jtf_number_table := NULL
105 ,p_REFERENCE_LINE_ID IN jtf_number_table := NULL
106 ,p_REFERENCE_TYPE IN jtf_varchar2_table_300 := NULL
107 ,p_REFERENCE_HEADER_ID IN jtf_number_table := NULL
108 ,p_ITEM_REVISION IN jtf_varchar2_table_100 := NULL
109 ,p_UNIT_SELLING_PRICE IN jtf_number_table := NULL
110 ,p_UNIT_LIST_PRICE IN jtf_number_table := NULL
111 ,p_TAX_VALUE IN jtf_number_table := NULL
112 ,p_CONTEXT IN jtf_varchar2_table_300 := NULL
113 ,p_ATTRIBUTE1 IN jtf_varchar2_table_300 := NULL
114 ,p_ATTRIBUTE2 IN jtf_varchar2_table_300 := NULL
115 ,p_ATTRIBUTE3 IN jtf_varchar2_table_300 := NULL
116 ,p_ATTRIBUTE4 IN jtf_varchar2_table_300 := NULL
117 ,p_ATTRIBUTE5 IN jtf_varchar2_table_300 := NULL
118 ,p_ATTRIBUTE6 IN jtf_varchar2_table_300 := NULL
119 ,p_ATTRIBUTE7 IN jtf_varchar2_table_300 := NULL
120 ,p_ATTRIBUTE8 IN jtf_varchar2_table_300 := NULL
121 ,p_ATTRIBUTE9 IN jtf_varchar2_table_300 := NULL
122 ,p_ATTRIBUTE10 IN jtf_varchar2_table_300 := NULL
123 ,p_ATTRIBUTE11 IN jtf_varchar2_table_300 := NULL
124 ,p_ATTRIBUTE12 IN jtf_varchar2_table_300 := NULL
125 ,p_ATTRIBUTE13 IN jtf_varchar2_table_300 := NULL
126 ,p_ATTRIBUTE14 IN jtf_varchar2_table_300 := NULL
127 ,p_ATTRIBUTE15 IN jtf_varchar2_table_300 := NULL
128 ,p_GLOBAL_ATTRIBUTE_CATEGORY IN jtf_varchar2_table_100 := NULL
129 ,p_GLOBAL_ATTRIBUTE1 IN jtf_varchar2_table_300 := NULL
130 ,p_GLOBAL_ATTRIBUTE2 IN jtf_varchar2_table_300 := NULL
131 ,p_GLOBAL_ATTRIBUTE3 IN jtf_varchar2_table_300 := NULL
132 ,p_GLOBAL_ATTRIBUTE4 IN jtf_varchar2_table_300 := NULL
133 ,p_GLOBAL_ATTRIBUTE5 IN jtf_varchar2_table_300 := NULL
134 ,p_GLOBAL_ATTRIBUTE6 IN jtf_varchar2_table_300 := NULL
135 ,p_GLOBAL_ATTRIBUTE7 IN jtf_varchar2_table_300 := NULL
136 ,p_GLOBAL_ATTRIBUTE8 IN jtf_varchar2_table_300 := NULL
137 ,p_GLOBAL_ATTRIBUTE9 IN jtf_varchar2_table_300 := NULL
138 ,p_GLOBAL_ATTRIBUTE10 IN jtf_varchar2_table_300 := NULL
139 ,p_GLOBAL_ATTRIBUTE11 IN jtf_varchar2_table_300 := NULL
140 ,p_GLOBAL_ATTRIBUTE12 IN jtf_varchar2_table_300 := NULL
141 ,p_GLOBAL_ATTRIBUTE13 IN jtf_varchar2_table_300 := NULL
142 ,p_GLOBAL_ATTRIBUTE14 IN jtf_varchar2_table_300 := NULL
143 ,p_GLOBAL_ATTRIBUTE15 IN jtf_varchar2_table_300 := NULL
144 ,p_GLOBAL_ATTRIBUTE16 IN jtf_varchar2_table_300 := NULL
145 ,p_GLOBAL_ATTRIBUTE17 IN jtf_varchar2_table_300 := NULL
146 ,p_GLOBAL_ATTRIBUTE18 IN jtf_varchar2_table_300 := NULL
147 ,p_GLOBAL_ATTRIBUTE19 IN jtf_varchar2_table_300 := NULL
148 ,p_GLOBAL_ATTRIBUTE20 IN jtf_varchar2_table_300 := NULL
149 ,p_PRICING_CONTEXT IN jtf_varchar2_table_300 := NULL
150 ,p_PRICING_ATTRIBUTE1 IN jtf_varchar2_table_300 := NULL
151 ,p_PRICING_ATTRIBUTE2 IN jtf_varchar2_table_300 := NULL
152 ,p_PRICING_ATTRIBUTE3 IN jtf_varchar2_table_300 := NULL
153 ,p_PRICING_ATTRIBUTE4 IN jtf_varchar2_table_300 := NULL
154 ,p_PRICING_ATTRIBUTE5 IN jtf_varchar2_table_300 := NULL
155 ,p_PRICING_ATTRIBUTE6 IN jtf_varchar2_table_300 := NULL
156 ,p_PRICING_ATTRIBUTE7 IN jtf_varchar2_table_300 := NULL
157 ,p_PRICING_ATTRIBUTE8 IN jtf_varchar2_table_300 := NULL
158 ,p_PRICING_ATTRIBUTE9 IN jtf_varchar2_table_300 := NULL
159 ,p_PRICING_ATTRIBUTE10 IN jtf_varchar2_table_300 := NULL
160 ,p_INDUSTRY_CONTEXT IN jtf_varchar2_table_100 := NULL
161 ,p_INDUSTRY_ATTRIBUTE1 IN jtf_varchar2_table_300 := NULL
162 ,p_INDUSTRY_ATTRIBUTE2 IN jtf_varchar2_table_300 := NULL
163 ,p_INDUSTRY_ATTRIBUTE3 IN jtf_varchar2_table_300 := NULL
164 ,p_INDUSTRY_ATTRIBUTE4 IN jtf_varchar2_table_300 := NULL
165 ,p_INDUSTRY_ATTRIBUTE5 IN jtf_varchar2_table_300 := NULL
166 ,p_INDUSTRY_ATTRIBUTE6 IN jtf_varchar2_table_300 := NULL
167 ,p_INDUSTRY_ATTRIBUTE7 IN jtf_varchar2_table_300 := NULL
168 ,p_INDUSTRY_ATTRIBUTE8 IN jtf_varchar2_table_300 := NULL
169 ,p_INDUSTRY_ATTRIBUTE9 IN jtf_varchar2_table_300 := NULL
170 ,p_INDUSTRY_ATTRIBUTE10 IN jtf_varchar2_table_300 := NULL
171 ,p_INDUSTRY_ATTRIBUTE11 IN jtf_varchar2_table_300 := NULL
172 ,p_INDUSTRY_ATTRIBUTE13 IN jtf_varchar2_table_300 := NULL
173 ,p_INDUSTRY_ATTRIBUTE12 IN jtf_varchar2_table_300 := NULL
174 ,p_INDUSTRY_ATTRIBUTE14 IN jtf_varchar2_table_300 := NULL
175 ,p_INDUSTRY_ATTRIBUTE15 IN jtf_varchar2_table_300 := NULL
176 ,p_INDUSTRY_ATTRIBUTE16 IN jtf_varchar2_table_300 := NULL
177 ,p_INDUSTRY_ATTRIBUTE17 IN jtf_varchar2_table_300 := NULL
178 ,p_INDUSTRY_ATTRIBUTE18 IN jtf_varchar2_table_300 := NULL
179 ,p_INDUSTRY_ATTRIBUTE19 IN jtf_varchar2_table_300 := NULL
180 ,p_INDUSTRY_ATTRIBUTE20 IN jtf_varchar2_table_300 := NULL
181 ,p_INDUSTRY_ATTRIBUTE21 IN jtf_varchar2_table_300 := NULL
182 ,p_INDUSTRY_ATTRIBUTE22 IN jtf_varchar2_table_300 := NULL
183 ,p_INDUSTRY_ATTRIBUTE23 IN jtf_varchar2_table_300 := NULL
184 ,p_INDUSTRY_ATTRIBUTE24 IN jtf_varchar2_table_300 := NULL
185 ,p_INDUSTRY_ATTRIBUTE25 IN jtf_varchar2_table_300 := NULL
186 ,p_INDUSTRY_ATTRIBUTE26 IN jtf_varchar2_table_300 := NULL
187 ,p_INDUSTRY_ATTRIBUTE27 IN jtf_varchar2_table_300 := NULL
188 ,p_INDUSTRY_ATTRIBUTE28 IN jtf_varchar2_table_300 := NULL
189 ,p_INDUSTRY_ATTRIBUTE29 IN jtf_varchar2_table_300 := NULL
190 ,p_INDUSTRY_ATTRIBUTE30 IN jtf_varchar2_table_300 := NULL
191 ,p_CREATION_DATE IN jtf_date_table := NULL
192 ,p_CREATED_BY IN jtf_number_table := NULL
193 ,p_LAST_UPDATE_DATE IN jtf_date_table := NULL
194 ,p_LAST_UPDATED_BY IN jtf_number_table := NULL
195 ,p_LAST_UPDATE_LOGIN IN jtf_number_table := NULL
196 ,p_PROGRAM_APPLICATION_ID IN jtf_number_table := NULL
197 ,p_PROGRAM_ID IN jtf_number_table := NULL
198 ,p_PROGRAM_UPDATE_DATE IN jtf_date_table := NULL
199 ,p_REQUEST_ID IN jtf_number_table := NULL
200 ,p_TOP_MODEL_LINE_ID IN jtf_number_table := NULL
201 ,p_LINK_TO_LINE_ID IN jtf_number_table := NULL
202 ,p_COMPONENT_SEQUENCE_ID IN jtf_number_table := NULL
203 ,p_COMPONENT_CODE IN jtf_varchar2_table_300 := NULL
204 ,p_CONFIG_DISPLAY_SEQUENCE IN jtf_number_table := NULL
205 ,p_SORT_ORDER IN jtf_varchar2_table_300 := NULL
206 ,p_ITEM_TYPE_CODE IN jtf_varchar2_table_100 := NULL
207 ,p_OPTION_NUMBER IN jtf_number_table := NULL
208 ,p_OPTION_FLAG IN jtf_varchar2_table_100 := NULL
209 ,p_DEP_PLAN_REQUIRED_FLAG IN jtf_varchar2_table_100 := NULL
210 ,p_VISIBLE_DEMAND_FLAG IN jtf_varchar2_table_100 := NULL
211 ,p_LINE_CATEGORY_CODE IN jtf_varchar2_table_100 := NULL
212 ,p_ACTUAL_SHIPMENT_DATE IN jtf_date_table := NULL
213 ,p_CUSTOMER_TRX_LINE_ID IN jtf_number_table := NULL
214 ,p_RETURN_CONTEXT IN jtf_varchar2_table_100 := NULL
215 ,p_RETURN_ATTRIBUTE1 IN jtf_varchar2_table_300 := NULL
216 ,p_RETURN_ATTRIBUTE2 IN jtf_varchar2_table_300 := NULL
217 ,p_RETURN_ATTRIBUTE3 IN jtf_varchar2_table_300 := NULL
218 ,p_RETURN_ATTRIBUTE4 IN jtf_varchar2_table_300 := NULL
219 ,p_RETURN_ATTRIBUTE5 IN jtf_varchar2_table_300 := NULL
220 ,p_RETURN_ATTRIBUTE6 IN jtf_varchar2_table_300 := NULL
221 ,p_RETURN_ATTRIBUTE7 IN jtf_varchar2_table_300 := NULL
222 ,p_RETURN_ATTRIBUTE8 IN jtf_varchar2_table_300 := NULL
223 ,p_RETURN_ATTRIBUTE9 IN jtf_varchar2_table_300 := NULL
224 ,p_RETURN_ATTRIBUTE10 IN jtf_varchar2_table_300 := NULL
225 ,p_RETURN_ATTRIBUTE11 IN jtf_varchar2_table_300 := NULL
226 ,p_RETURN_ATTRIBUTE12 IN jtf_varchar2_table_300 := NULL
227 ,p_RETURN_ATTRIBUTE13 IN jtf_varchar2_table_300 := NULL
228 ,p_RETURN_ATTRIBUTE14 IN jtf_varchar2_table_300 := NULL
229 ,p_RETURN_ATTRIBUTE15 IN jtf_varchar2_table_300 := NULL
230 ,p_ACTUAL_ARRIVAL_DATE IN jtf_date_table := NULL
231 ,p_ATO_LINE_ID IN jtf_number_table := NULL
232 ,p_AUTO_SELECTED_QUANTITY IN jtf_number_table := NULL
233 ,p_COMPONENT_NUMBER IN jtf_number_table := NULL
234 ,p_EARLIEST_ACCEPTABLE_DATE IN jtf_date_table := NULL
235 ,p_EXPLOSION_DATE IN jtf_date_table := NULL
236 ,p_LATEST_ACCEPTABLE_DATE IN jtf_date_table := NULL
237 ,p_MODEL_GROUP_NUMBER IN jtf_number_table := NULL
238 ,p_SCHEDULE_ARRIVAL_DATE IN jtf_date_table := NULL
239 ,p_SHIP_MODEL_COMPLETE_FLAG IN jtf_varchar2_table_100 := NULL
240 ,p_SCHEDULE_STATUS_CODE IN jtf_varchar2_table_100 := NULL
241 ,p_SOURCE_TYPE_CODE IN jtf_varchar2_table_100 := NULL
242 ,p_CANCELLED_FLAG IN jtf_varchar2_table_100 := NULL
243 ,p_OPEN_FLAG IN jtf_varchar2_table_100 := NULL
244 ,p_BOOKED_FLAG IN jtf_varchar2_table_100 := NULL
245 ,p_SALESREP_ID IN jtf_number_table := NULL
246 ,p_RETURN_REASON_CODE IN jtf_varchar2_table_100 := NULL
247 ,p_ARRIVAL_SET_ID IN jtf_number_table := NULL
248 ,p_SHIP_SET_ID IN jtf_number_table := NULL
249 ,p_SPLIT_FROM_LINE_ID IN jtf_number_table := NULL
250 ,p_CUST_PRODUCTION_SEQ_NUM IN jtf_varchar2_table_100 := NULL
251 ,p_AUTHORIZED_TO_SHIP_FLAG IN jtf_varchar2_table_300 := NULL
252 ,p_OVER_SHIP_REASON_CODE IN jtf_varchar2_table_100 := NULL
253 ,p_OVER_SHIP_RESOLVED_FLAG IN jtf_varchar2_table_100 := NULL
254 ,p_ORDERED_ITEM_ID IN jtf_number_table := NULL
255 ,p_ITEM_IDENTIFIER_TYPE IN jtf_varchar2_table_100 := NULL
256 ,p_CONFIGURATION_ID IN jtf_number_table := NULL
257 ,p_COMMITMENT_ID IN jtf_number_table := NULL
258 ,p_SHIPPING_INTERFACED_FLAG IN jtf_varchar2_table_100 := NULL
259 ,p_CREDIT_INVOICE_LINE_ID IN jtf_number_table := NULL
260 ,p_FIRST_ACK_CODE IN jtf_varchar2_table_100 := NULL
261 ,p_FIRST_ACK_DATE IN jtf_date_table := NULL
262 ,p_LAST_ACK_CODE IN jtf_varchar2_table_100 := NULL
263 ,p_LAST_ACK_DATE IN jtf_date_table := NULL
264 ,p_PLANNING_PRIORITY IN jtf_number_table := NULL
265 ,p_ORDER_SOURCE_ID IN jtf_number_table := NULL
266 ,p_ORIG_SYS_SHIPMENT_REF IN jtf_varchar2_table_100 := NULL
267 ,p_CHANGE_SEQUENCE IN jtf_varchar2_table_100 := NULL
268 ,p_DROP_SHIP_FLAG IN jtf_varchar2_table_100 := NULL
269 ,p_CUSTOMER_LINE_NUMBER IN jtf_varchar2_table_100 := NULL
270 ,p_CUSTOMER_SHIPMENT_NUMBER IN jtf_varchar2_table_100 := NULL
271 ,p_CUSTOMER_ITEM_NET_PRICE IN jtf_number_table := NULL
272 ,p_CUSTOMER_PAYMENT_TERM_ID IN jtf_number_table := NULL
273 ,p_FULFILLED_FLAG IN jtf_varchar2_table_100 := NULL
274 ,p_END_ITEM_UNIT_NUMBER IN jtf_varchar2_table_100 := NULL
275 ,p_CONFIG_HEADER_ID IN jtf_number_table := NULL
276 ,p_CONFIG_REV_NBR IN jtf_number_table := NULL
277 ,p_MFG_COMPONENT_SEQUENCE_ID IN jtf_number_table := NULL
278 ,p_SHIPPING_INSTRUCTIONS IN jtf_varchar2_table_300 := NULL
279 ,p_PACKING_INSTRUCTIONS IN jtf_varchar2_table_300 := NULL
280 ,p_INVOICED_QUANTITY IN jtf_number_table := NULL
281 ,p_REF_CUSTOMER_TRX_LINE_ID IN jtf_number_table := NULL
282 ,p_SPLIT_BY IN jtf_varchar2_table_300 := NULL
283 ,p_LINE_SET_ID IN jtf_number_table := NULL
284 ,p_SERVICE_TXN_REASON_CODE IN jtf_varchar2_table_100 := NULL
285 ,p_SERVICE_TXN_COMMENTS IN jtf_varchar2_table_300 := NULL
286 ,p_SERVICE_DURATION IN jtf_number_table := NULL
287 ,p_SERVICE_START_DATE IN jtf_date_table := NULL
288 ,p_SERVICE_END_DATE IN jtf_date_table := NULL
289 ,p_SERVICE_COTERMINATE_FLAG IN jtf_varchar2_table_100 := NULL
290 ,p_UNIT_LIST_PERCENT IN jtf_number_table := NULL
291 ,p_UNIT_SELLING_PERCENT IN jtf_number_table := NULL
292 ,p_UNIT_PERCENT_BASE_PRICE IN jtf_number_table := NULL
293 ,p_SERVICE_NUMBER IN jtf_number_table := NULL
294 ,p_SERVICE_PERIOD IN jtf_varchar2_table_100 := NULL
295 ,p_SHIPPABLE_FLAG IN jtf_varchar2_table_100 := NULL
296 ,p_MODEL_REMNANT_FLAG IN jtf_varchar2_table_100 := NULL
297 ,p_RE_SOURCE_FLAG IN jtf_varchar2_table_300 := NULL
298 ,p_FLOW_STATUS_CODE IN jtf_varchar2_table_100 := NULL
299 ,p_TP_CONTEXT IN jtf_varchar2_table_100 := NULL
300 ,p_TP_ATTRIBUTE1 IN jtf_varchar2_table_300 := NULL
301 ,p_TP_ATTRIBUTE2 IN jtf_varchar2_table_300 := NULL
302 ,p_TP_ATTRIBUTE3 IN jtf_varchar2_table_300 := NULL
303 ,p_TP_ATTRIBUTE4 IN jtf_varchar2_table_300 := NULL
304 ,p_TP_ATTRIBUTE5 IN jtf_varchar2_table_300 := NULL
305 ,p_TP_ATTRIBUTE6 IN jtf_varchar2_table_300 := NULL
306 ,p_TP_ATTRIBUTE7 IN jtf_varchar2_table_300 := NULL
307 ,p_TP_ATTRIBUTE8 IN jtf_varchar2_table_300 := NULL
308 ,p_TP_ATTRIBUTE9 IN jtf_varchar2_table_300 := NULL
309 ,p_TP_ATTRIBUTE10 IN jtf_varchar2_table_300 := NULL
310 ,p_TP_ATTRIBUTE11 IN jtf_varchar2_table_300 := NULL
311 ,p_TP_ATTRIBUTE12 IN jtf_varchar2_table_300 := NULL
312 ,p_TP_ATTRIBUTE13 IN jtf_varchar2_table_300 := NULL
313 ,p_TP_ATTRIBUTE14 IN jtf_varchar2_table_300 := NULL
314 ,p_TP_ATTRIBUTE15 IN jtf_varchar2_table_300 := NULL
315 ,p_FULFILLMENT_METHOD_CODE IN jtf_varchar2_table_300 := NULL
316 ,p_MARKETING_SOURCE_CODE_ID IN jtf_number_table := NULL
317 ,p_SERVICE_REF_TYPE_CODE IN jtf_varchar2_table_100 := NULL
318 ,p_SERVICE_REFERENCE_LINE_ID IN jtf_number_table := NULL
319 ,p_SERVICE_REF_SYSTEM_ID IN jtf_number_table := NULL
320 ,p_CALCULATE_PRICE_FLAG IN jtf_varchar2_table_100 := NULL
321 ,p_UPGRADED_FLAG IN jtf_varchar2_table_100 := NULL
322 ,p_REVENUE_AMOUNT IN jtf_number_table := NULL
323 ,p_FULFILLMENT_DATE IN jtf_date_table := NULL
324 ,p_PREFERRED_GRADE IN jtf_varchar2_table_100 := NULL
325 ,p_ORDERED_QUANTITY2 IN jtf_number_table := NULL
326 ,p_ORDERED_QUANTITY_UOM2 IN jtf_varchar2_table_100 := NULL
327 ,p_SHIPPING_QUANTITY2 IN jtf_number_table := NULL
328 ,p_CANCELLED_QUANTITY2 IN jtf_number_table := NULL
329 ,p_SHIPPED_QUANTITY2 IN jtf_number_table := NULL
330 ,p_SHIPPING_QUANTITY_UOM2 IN jtf_varchar2_table_100 := NULL
331 ,p_FULFILLED_QUANTITY2 IN jtf_number_table := NULL
332 ,p_MFG_LEAD_TIME IN jtf_number_table := NULL
333 ,p_LOCK_CONTROL IN jtf_number_table := NULL
334 ,p_SUBINVENTORY IN jtf_varchar2_table_100 := NULL
335 ,p_UNIT_LIST_PRICE_PER_PQTY IN jtf_number_table := NULL
336 ,p_UNIT_SELL_PRICE_PER_PQTY IN jtf_number_table := NULL
337 ,p_PRICE_REQUEST_CODE IN jtf_varchar2_table_300 := NULL
338 ,p_ORIGINAL_INVENTORY_ITEM_ID IN jtf_number_table := NULL
339 ,p_ORIGINAL_ORDERED_ITEM_ID IN jtf_number_table := NULL
340 ,p_ORIGINAL_ORDERED_ITEM IN jtf_varchar2_table_300 := NULL
341 ,p_ORIGINAL_ITEM_IDENTIF_TYPE IN jtf_varchar2_table_100 := NULL
342 ,p_ITEM_SUBSTIT_TYPE_CODE IN jtf_varchar2_table_100 := NULL
343 ,p_OVERRIDE_ATP_DATE_CODE IN jtf_varchar2_table_100 := NULL
344 ,p_LATE_DEMAND_PENALTY_FACTOR IN jtf_number_table := NULL
345 ,p_ACCOUNTING_RULE_DURATION IN jtf_number_table := NULL
346
347 ,p_top_model_line_index IN jtf_number_table := NULL
348 ,p_top_model_line_ref IN jtf_varchar2_table_100 := NULL
349 ,p_unit_cost IN jtf_number_table := NULL
350 ,p_xml_transaction_type_code IN jtf_varchar2_table_100 := NULL
351 ,p_Sold_to_address_id IN jtf_number_table := NULL
352 ,p_Split_Action_Code IN jtf_varchar2_table_100 := NULL
353 ,p_split_from_line_ref IN jtf_varchar2_table_100 := NULL
354 ,p_split_from_shipment_ref IN jtf_varchar2_table_100 := NULL
355 ,p_status_flag IN jtf_varchar2_table_100 := NULL
356 ,p_ship_from_edi_loc_code IN jtf_varchar2_table_100 := NULL
357 ,p_ship_set IN jtf_varchar2_table_100 := NULL
358 ,p_Ship_to_address_code IN jtf_varchar2_table_100 := NULL
359 ,p_Ship_to_address_id IN jtf_varchar2_table_300 := NULL
360 ,p_ship_to_customer_id IN jtf_number_table := NULL
361 ,p_ship_to_edi_location_code IN jtf_varchar2_table_100 := NULL
362 ,p_service_ref_line_number IN jtf_number_table := NULL
363 ,p_service_ref_option_number IN jtf_number_table := NULL
364 ,p_service_ref_order_number IN jtf_number_table := NULL
365 ,p_service_ref_ship_number IN jtf_number_table := NULL
366 ,p_service_reference_line IN jtf_varchar2_table_100 := NULL
367 ,p_service_reference_order IN jtf_varchar2_table_100 := NULL
368 ,p_service_reference_system IN jtf_varchar2_table_100 := NULL
369 ,p_reserved_quantity IN jtf_number_table := NULL
370 ,p_return_status IN jtf_varchar2_table_100 := NULL
371 ,p_schedule_action_code IN jtf_varchar2_table_100 := NULL
372 ,p_service_line_index IN jtf_number_table := NULL
373 ,p_intermed_ship_to_cont_id IN jtf_number_table := NULL
374 ,p_intermed_ship_to_org_id IN jtf_number_table := NULL
375 ,p_Invoice_address_id IN jtf_number_table := NULL
376 ,p_invoice_to_customer_id IN jtf_number_table := NULL
377 ,p_item_relationship_type IN jtf_number_table := NULL
378 ,p_link_to_line_index IN jtf_number_table := NULL
379 ,p_link_to_line_ref IN jtf_varchar2_table_100 := NULL
380 ,p_db_flag IN jtf_varchar2_table_100 := NULL
381 ,p_deliver_to_customer_id IN jtf_number_table := NULL
382 ,p_fulfillment_set IN jtf_varchar2_table_100 := NULL
383 ,p_fulfillment_set_id IN jtf_number_table := NULL
384 ,p_change_comments IN jtf_varchar2_table_300 := NULL
385 ,p_change_reason IN jtf_varchar2_table_100 := NULL
386 ,p_change_request_code IN jtf_varchar2_table_100 := NULL
387 ,p_Bill_to_Edi_Location_Code IN jtf_varchar2_table_100 := NULL
388 ,p_Blanket_Line_Number IN jtf_number_table := NULL
389 ,p_Blanket_Number IN jtf_number_table := NULL
390 ,p_Blanket_Version_Number IN jtf_number_table := NULL
391 ,p_arrival_set IN jtf_varchar2_table_100 := NULL
392 ,p_attribute16 IN jtf_varchar2_table_300 := NULL
393 ,p_attribute17 IN jtf_varchar2_table_300 := NULL
394 ,p_attribute18 IN jtf_varchar2_table_300 := NULL
395 ,p_attribute19 IN jtf_varchar2_table_300 := NULL
396 ,p_attribute20 IN jtf_varchar2_table_300 := NULL
397
398 )
399 RETURN OE_Order_PUB.Line_Tbl_Type
400 IS
401
402 l_order_line_tbl OE_Order_PUB.Line_Tbl_Type;
403 l_table_size PLS_INTEGER := 0;
404 i PLS_INTEGER;
405 BEGIN
406 IF (IBE_UTIL.G_DEBUGON = l_true) THEN
407 IBE_Util.Debug('In Returns construct LineRecord package body - Begin');
408 END IF;
409
410 --To determine the table size
411
412 IF p_HEADER_ID IS NOT NULL THEN
413 l_table_size := p_HEADER_ID.COUNT;
414 IF (IBE_UTIL.G_DEBUGON = l_true) THEN
415 IBE_Util.Debug('In Returns construct LineRecord tcount' ||l_table_size);
416 END IF;
417 END IF;
418
419 IF l_table_size > 0 THEN
420
421 FOR i IN 1..l_table_size LOOP
422
423 l_order_line_tbl(i) := OE_Order_PUB.G_MISS_LINE_REC;
424
425 IF ((p_LINE_ID is not null) and ((p_LINE_ID(i) is null) or (p_LINE_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
426 l_order_line_tbl(i).LINE_ID := p_LINE_ID(i);
427 END IF;
428
429 IF (p_OPERATION is not null) THEN
430 l_order_line_tbl(i).OPERATION := p_OPERATION(i);
431 END IF;
432
433 IF ((p_ORG_ID is not null) and ((p_ORG_ID(i) is null) or (p_ORG_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
434 l_order_line_tbl(i).ORG_ID := p_ORG_ID(i);
435 END IF;
436
437
438 IF ((p_HEADER_ID is not null) and ((p_HEADER_ID(i) is null) or (p_HEADER_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
439 l_order_line_tbl(i).HEADER_ID := p_HEADER_ID(i);
440 END IF;
441
442 IF ((p_LINE_TYPE_ID is not null) and ((p_LINE_TYPE_ID(i) is null) or (p_LINE_TYPE_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
443 l_order_line_tbl(i).LINE_TYPE_ID := p_LINE_TYPE_ID(i);
444 END IF;
445 IF ((p_LINE_NUMBER is not null) and ((p_LINE_NUMBER(i) is null) or (p_LINE_NUMBER(i) <> ROSETTA_G_MISS_NUM))) THEN
446 l_order_line_tbl(i).LINE_NUMBER := p_LINE_NUMBER(i);
447 END IF;
448 IF (p_ORDERED_ITEM is not null) THEN
449 l_order_line_tbl(i).ORDERED_ITEM := p_ORDERED_ITEM(i);
450 END IF;
451 IF ((p_REQUEST_DATE is not null) and ((p_REQUEST_DATE(i) is null) or (p_REQUEST_DATE(i) <> ROSETTA_G_MISS_DATE))) THEN
452 l_order_line_tbl(i).REQUEST_DATE := p_REQUEST_DATE(i);
453 END IF;
454 IF ((p_PROMISE_DATE is not null) and ((p_PROMISE_DATE(i) is null) or (p_PROMISE_DATE(i) <> ROSETTA_G_MISS_DATE))) THEN
455 l_order_line_tbl(i).PROMISE_DATE := p_PROMISE_DATE(i);
456 END IF;
457 IF ((p_SCHEDULE_SHIP_DATE is not null) and ((p_SCHEDULE_SHIP_DATE(i) is null) or (p_SCHEDULE_SHIP_DATE(i) <> ROSETTA_G_MISS_DATE))) THEN
458 l_order_line_tbl(i).SCHEDULE_SHIP_DATE := p_SCHEDULE_SHIP_DATE(i);
459 END IF;
460
461 IF (p_ORDER_QUANTITY_UOM is not null) THEN
462 l_order_line_tbl(i).ORDER_QUANTITY_UOM := p_ORDER_QUANTITY_UOM(i);
463 END IF;
464 IF ((p_PRICING_QUANTITY is not null) and ((p_PRICING_QUANTITY(i) is null) or (p_PRICING_QUANTITY(i) <> ROSETTA_G_MISS_NUM))) THEN
465 l_order_line_tbl(i).PRICING_QUANTITY := p_PRICING_QUANTITY(i);
466 END IF;
467 IF (p_PRICING_QUANTITY_UOM is not null) THEN
468 l_order_line_tbl(i).PRICING_QUANTITY_UOM := p_PRICING_QUANTITY_UOM(i);
469 END IF;
470 IF ((p_CANCELLED_QUANTITY is not null) and ((p_CANCELLED_QUANTITY(i) is null) or (p_CANCELLED_QUANTITY(i) <> ROSETTA_G_MISS_NUM))) THEN
471 l_order_line_tbl(i).CANCELLED_QUANTITY := p_CANCELLED_QUANTITY(i);
472 END IF;
473 IF ((p_SHIPPED_QUANTITY is not null) and ((p_SHIPPED_QUANTITY(i) is null) or (p_SHIPPED_QUANTITY(i) <> ROSETTA_G_MISS_NUM))) THEN
474 l_order_line_tbl(i).SHIPPED_QUANTITY := p_SHIPPED_QUANTITY(i);
475 END IF;
476 IF ((p_ORDERED_QUANTITY is not null) and ((p_ORDERED_QUANTITY(i) is null) or (p_ORDERED_QUANTITY(i) <> ROSETTA_G_MISS_NUM))) THEN
477 l_order_line_tbl(i).ORDERED_QUANTITY := p_ORDERED_QUANTITY(i);
478 END IF;
479 IF ((p_FULFILLED_QUANTITY is not null) and ((p_FULFILLED_QUANTITY(i) is null) or (p_FULFILLED_QUANTITY(i) <> ROSETTA_G_MISS_NUM))) THEN
480 l_order_line_tbl(i).FULFILLED_QUANTITY := p_FULFILLED_QUANTITY(i);
481 END IF;
482 IF ((p_SHIPPING_QUANTITY is not null) and ((p_SHIPPING_QUANTITY(i) is null) or (p_SHIPPING_QUANTITY(i) <> ROSETTA_G_MISS_NUM))) THEN
483 l_order_line_tbl(i).SHIPPING_QUANTITY := p_SHIPPING_QUANTITY(i);
484 END IF;
485 IF (p_SHIPPING_QUANTITY_UOM is not null) THEN
486 l_order_line_tbl(i).SHIPPING_QUANTITY_UOM := p_SHIPPING_QUANTITY_UOM(i);
487 END IF;
488 IF ((p_DELIVERY_LEAD_TIME is not null) and ((p_DELIVERY_LEAD_TIME(i) is null) or (p_DELIVERY_LEAD_TIME(i) <> ROSETTA_G_MISS_NUM))) THEN
489 l_order_line_tbl(i).DELIVERY_LEAD_TIME := p_DELIVERY_LEAD_TIME(i);
490 END IF;
491 IF (p_TAX_EXEMPT_FLAG is not null) THEN
492 l_order_line_tbl(i).TAX_EXEMPT_FLAG := p_TAX_EXEMPT_FLAG(i);
493 END IF;
494 IF (p_TAX_EXEMPT_NUMBER is not null) THEN
495 l_order_line_tbl(i).TAX_EXEMPT_NUMBER := p_TAX_EXEMPT_NUMBER(i);
496 END IF;
497 IF (p_TAX_EXEMPT_REASON_CODE is not null) THEN
498 l_order_line_tbl(i).TAX_EXEMPT_REASON_CODE := p_TAX_EXEMPT_REASON_CODE(i);
499 END IF;
500 IF ((p_SHIP_FROM_ORG_ID is not null) and ((p_SHIP_FROM_ORG_ID(i) is null) or (p_SHIP_FROM_ORG_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
501 l_order_line_tbl(i).SHIP_FROM_ORG_ID := p_SHIP_FROM_ORG_ID(i);
502 END IF;
503 IF ((p_SHIP_TO_ORG_ID is not null) and ((p_SHIP_TO_ORG_ID(i) is null) or (p_SHIP_TO_ORG_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
504 l_order_line_tbl(i).SHIP_TO_ORG_ID := p_SHIP_TO_ORG_ID(i);
505 END IF;
506 IF ((p_INVOICE_TO_ORG_ID is not null) and ((p_INVOICE_TO_ORG_ID(i) is null) or (p_INVOICE_TO_ORG_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
507 l_order_line_tbl(i).INVOICE_TO_ORG_ID := p_INVOICE_TO_ORG_ID(i);
508 END IF;
509 IF ((p_DELIVER_TO_ORG_ID is not null) and ((p_DELIVER_TO_ORG_ID(i) is null) or (p_DELIVER_TO_ORG_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
510 l_order_line_tbl(i).DELIVER_TO_ORG_ID := p_DELIVER_TO_ORG_ID(i);
511 END IF;
512 IF ((p_SHIP_TO_CONTACT_ID is not null) and ((p_SHIP_TO_CONTACT_ID(i) is null) or (p_SHIP_TO_CONTACT_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
513 l_order_line_tbl(i).SHIP_TO_CONTACT_ID := p_SHIP_TO_CONTACT_ID(i);
514 END IF;
515 IF ((p_DELIVER_TO_CONTACT_ID is not null) and ((p_DELIVER_TO_CONTACT_ID(i) is null) or (p_DELIVER_TO_CONTACT_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
516 l_order_line_tbl(i).DELIVER_TO_CONTACT_ID := p_DELIVER_TO_CONTACT_ID(i);
517 END IF;
518 IF ((p_INVOICE_TO_CONTACT_ID is not null) and ((p_INVOICE_TO_CONTACT_ID(i) is null) or (p_INVOICE_TO_CONTACT_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
519 l_order_line_tbl(i).INVOICE_TO_CONTACT_ID := p_INVOICE_TO_CONTACT_ID(i);
520 END IF;
521
522 IF ((p_SOLD_FROM_ORG_ID is not null) and ((p_SOLD_FROM_ORG_ID(i) is null) or (p_SOLD_FROM_ORG_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
523 l_order_line_tbl(i).SOLD_FROM_ORG_ID := p_SOLD_FROM_ORG_ID(i);
524 END IF;
525 IF ((p_SOLD_TO_ORG_ID is not null) and ((p_SOLD_TO_ORG_ID(i) is null) or (p_SOLD_TO_ORG_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
526 l_order_line_tbl(i).SOLD_TO_ORG_ID := p_SOLD_TO_ORG_ID(i);
527 END IF;
528 IF (p_CUST_PO_NUMBER is not null) THEN
529 l_order_line_tbl(i).CUST_PO_NUMBER := p_CUST_PO_NUMBER(i);
530 END IF;
531 IF ((p_SHIP_TOLERANCE_ABOVE is not null) and ((p_SHIP_TOLERANCE_ABOVE(i) is null) or (p_SHIP_TOLERANCE_ABOVE(i) <> ROSETTA_G_MISS_NUM))) THEN
532 l_order_line_tbl(i).SHIP_TOLERANCE_ABOVE := p_SHIP_TOLERANCE_ABOVE(i);
533 END IF;
534 IF ((p_SHIP_TOLERANCE_BELOW is not null) and ((p_SHIP_TOLERANCE_BELOW(i) is null) or (p_SHIP_TOLERANCE_BELOW(i) <> ROSETTA_G_MISS_NUM))) THEN
535 l_order_line_tbl(i).SHIP_TOLERANCE_BELOW := p_SHIP_TOLERANCE_BELOW(i);
536 END IF;
537 IF (p_DEMAND_BUCKET_TYPE_CODE is not null) THEN
538 l_order_line_tbl(i).DEMAND_BUCKET_TYPE_CODE := p_DEMAND_BUCKET_TYPE_CODE(i);
539 END IF;
540 IF ((p_VEH_CUS_ITEM_CUM_KEY_ID is not null) and ((p_VEH_CUS_ITEM_CUM_KEY_ID(i) is null) or (p_VEH_CUS_ITEM_CUM_KEY_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
541 l_order_line_tbl(i).VEH_CUS_ITEM_CUM_KEY_ID := p_VEH_CUS_ITEM_CUM_KEY_ID(i);
542 END IF;
543 IF (p_RLA_SCHEDULE_TYPE_CODE is not null) THEN
544 l_order_line_tbl(i).RLA_SCHEDULE_TYPE_CODE := p_RLA_SCHEDULE_TYPE_CODE(i);
545 END IF;
546 IF (p_CUSTOMER_DOCK_CODE is not null) THEN
547 l_order_line_tbl(i).CUSTOMER_DOCK_CODE := p_CUSTOMER_DOCK_CODE(i);
548 END IF;
549 IF (p_CUSTOMER_JOB is not null) THEN
550 l_order_line_tbl(i).CUSTOMER_JOB := p_CUSTOMER_JOB(i);
551 END IF;
552 IF (p_CUSTOMER_PRODUCTION_LINE is not null) THEN
553 l_order_line_tbl(i).CUSTOMER_PRODUCTION_LINE := p_CUSTOMER_PRODUCTION_LINE(i);
554 END IF;
555 IF (p_CUST_MODEL_SERIAL_NUMBER is not null) THEN
556 l_order_line_tbl(i).CUST_MODEL_SERIAL_NUMBER := p_CUST_MODEL_SERIAL_NUMBER(i);
557 END IF;
558 IF ((p_PROJECT_ID is not null) and ((p_PROJECT_ID(i) is null) or (p_PROJECT_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
559 l_order_line_tbl(i).PROJECT_ID := p_PROJECT_ID(i);
560 END IF;
561 IF ((p_TASK_ID is not null) and ((p_TASK_ID(i) is null) or (p_TASK_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
562 l_order_line_tbl(i).TASK_ID := p_TASK_ID(i);
563 END IF;
564 IF ((p_INVENTORY_ITEM_ID is not null) and ((p_INVENTORY_ITEM_ID(i) is null) or (p_INVENTORY_ITEM_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
565 l_order_line_tbl(i).INVENTORY_ITEM_ID := p_INVENTORY_ITEM_ID(i);
566 END IF;
567 IF ((p_TAX_DATE is not null) and ((p_TAX_DATE(i) is null) or (p_TAX_DATE(i) <> ROSETTA_G_MISS_DATE))) THEN
568 l_order_line_tbl(i).TAX_DATE := p_TAX_DATE(i);
569 END IF;
570 IF (p_TAX_CODE is not null) THEN
571 l_order_line_tbl(i).TAX_CODE := p_TAX_CODE(i);
572 END IF;
573 IF ((p_TAX_RATE is not null) and ((p_TAX_RATE(i) is null) or (p_TAX_RATE(i) <> ROSETTA_G_MISS_NUM))) THEN
574 l_order_line_tbl(i).TAX_RATE := p_TAX_RATE(i);
575 END IF;
576 IF (p_INVOICE_INTER_STATUS_CODE is not null) THEN
577 l_order_line_tbl(i).INVOICE_INTERFACE_STATUS_CODE := p_INVOICE_INTER_STATUS_CODE(i);
578 END IF;
579 IF (p_DEMAND_CLASS_CODE is not null) THEN
580 l_order_line_tbl(i).DEMAND_CLASS_CODE := p_DEMAND_CLASS_CODE(i);
581 END IF;
582 IF ((p_PRICE_LIST_ID is not null) and ((p_PRICE_LIST_ID(i) is null) or (p_PRICE_LIST_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
583 l_order_line_tbl(i).PRICE_LIST_ID := p_PRICE_LIST_ID(i);
584 END IF;
585 IF ((p_PRICING_DATE is not null) and ((p_PRICING_DATE(i) is null) or (p_PRICING_DATE(i) <> ROSETTA_G_MISS_DATE))) THEN
586 l_order_line_tbl(i).PRICING_DATE := p_PRICING_DATE(i);
587 END IF;
588 IF ((p_SHIPMENT_NUMBER is not null) and ((p_SHIPMENT_NUMBER(i) is null) or (p_SHIPMENT_NUMBER(i) <> ROSETTA_G_MISS_NUM))) THEN
589 l_order_line_tbl(i).SHIPMENT_NUMBER := p_SHIPMENT_NUMBER(i);
590 END IF;
591 IF ((p_AGREEMENT_ID is not null) and ((p_AGREEMENT_ID(i) is null) or (p_AGREEMENT_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
592 l_order_line_tbl(i).AGREEMENT_ID := p_AGREEMENT_ID(i);
593 END IF;
594 IF (p_SHIPMENT_PRIORITY_CODE is not null) THEN
595 l_order_line_tbl(i).SHIPMENT_PRIORITY_CODE := p_SHIPMENT_PRIORITY_CODE(i);
596 END IF;
597 IF (p_SHIPPING_METHOD_CODE is not null) THEN
598 l_order_line_tbl(i).SHIPPING_METHOD_CODE := p_SHIPPING_METHOD_CODE(i);
599 END IF;
600 IF (p_FREIGHT_CARRIER_CODE is not null) THEN
601 l_order_line_tbl(i).FREIGHT_CARRIER_CODE := p_FREIGHT_CARRIER_CODE(i);
602 END IF;
603 IF (p_FREIGHT_TERMS_CODE is not null) THEN
604 l_order_line_tbl(i).FREIGHT_TERMS_CODE := p_FREIGHT_TERMS_CODE(i);
605 END IF;
606 IF (p_FOB_POINT_CODE is not null) THEN
607 l_order_line_tbl(i).FOB_POINT_CODE := p_FOB_POINT_CODE(i);
608 END IF;
609 IF (p_TAX_POINT_CODE is not null) THEN
610 l_order_line_tbl(i).TAX_POINT_CODE := p_TAX_POINT_CODE(i);
611 END IF;
612 IF ((p_PAYMENT_TERM_ID is not null) and ((p_PAYMENT_TERM_ID(i) is null) or (p_PAYMENT_TERM_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
613 l_order_line_tbl(i).PAYMENT_TERM_ID := p_PAYMENT_TERM_ID(i);
614 END IF;
615 IF ((p_INVOICING_RULE_ID is not null) and ((p_INVOICING_RULE_ID(i) is null) or (p_INVOICING_RULE_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
616 l_order_line_tbl(i).INVOICING_RULE_ID := p_INVOICING_RULE_ID(i);
617 END IF;
618 IF ((p_ACCOUNTING_RULE_ID is not null) and ((p_ACCOUNTING_RULE_ID(i) is null) or (p_ACCOUNTING_RULE_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
619 l_order_line_tbl(i).ACCOUNTING_RULE_ID := p_ACCOUNTING_RULE_ID(i);
620 END IF;
621 IF ((p_SOURCE_DOCUMENT_TYPE_ID is not null) and ((p_SOURCE_DOCUMENT_TYPE_ID(i) is null) or (p_SOURCE_DOCUMENT_TYPE_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
622 l_order_line_tbl(i).SOURCE_DOCUMENT_TYPE_ID := p_SOURCE_DOCUMENT_TYPE_ID(i);
623 END IF;
624 IF (p_ORIG_SYS_DOCUMENT_REF is not null) THEN
625 l_order_line_tbl(i).ORIG_SYS_DOCUMENT_REF := p_ORIG_SYS_DOCUMENT_REF(i);
626 END IF;
627 IF ((p_SOURCE_DOCUMENT_ID is not null) and ((p_SOURCE_DOCUMENT_ID(i) is null) or (p_SOURCE_DOCUMENT_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
628 l_order_line_tbl(i).SOURCE_DOCUMENT_ID := p_SOURCE_DOCUMENT_ID(i);
629 END IF;
630 IF (p_ORIG_SYS_LINE_REF is not null) THEN
631 l_order_line_tbl(i).ORIG_SYS_LINE_REF := p_ORIG_SYS_LINE_REF(i);
632 END IF;
633 IF ((p_SOURCE_DOCUMENT_LINE_ID is not null) and ((p_SOURCE_DOCUMENT_LINE_ID(i) is null) or (p_SOURCE_DOCUMENT_LINE_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
634 l_order_line_tbl(i).SOURCE_DOCUMENT_LINE_ID := p_SOURCE_DOCUMENT_LINE_ID(i);
635 END IF;
636 IF ((p_REFERENCE_LINE_ID is not null) and ((p_REFERENCE_LINE_ID(i) is null) or (p_REFERENCE_LINE_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
637 l_order_line_tbl(i).REFERENCE_LINE_ID := p_REFERENCE_LINE_ID(i);
638 END IF;
639 IF (p_REFERENCE_TYPE is not null) THEN
640 l_order_line_tbl(i).REFERENCE_TYPE := p_REFERENCE_TYPE(i);
641 END IF;
642 IF ((p_REFERENCE_HEADER_ID is not null) and ((p_REFERENCE_HEADER_ID(i) is null) or (p_REFERENCE_HEADER_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
643 l_order_line_tbl(i).REFERENCE_HEADER_ID := p_REFERENCE_HEADER_ID(i);
644 END IF;
645 IF (p_ITEM_REVISION is not null) THEN
646 l_order_line_tbl(i).ITEM_REVISION := p_ITEM_REVISION(i);
647 END IF;
648 IF ((p_UNIT_SELLING_PRICE is not null) and ((p_UNIT_SELLING_PRICE(i) is null) or (p_UNIT_SELLING_PRICE(i) <> ROSETTA_G_MISS_NUM))) THEN
649 l_order_line_tbl(i).UNIT_SELLING_PRICE := p_UNIT_SELLING_PRICE(i);
650 END IF;
651 IF ((p_UNIT_LIST_PRICE is not null) and ((p_UNIT_LIST_PRICE(i) is null) or (p_UNIT_LIST_PRICE(i) <> ROSETTA_G_MISS_NUM))) THEN
652 l_order_line_tbl(i).UNIT_LIST_PRICE := p_UNIT_LIST_PRICE(i);
653 END IF;
654 IF ((p_TAX_VALUE is not null) and ((p_TAX_VALUE(i) is null) or (p_TAX_VALUE(i) <> ROSETTA_G_MISS_NUM))) THEN
655 l_order_line_tbl(i).TAX_VALUE := p_TAX_VALUE(i);
656 END IF;
657 IF (p_CONTEXT is not null) THEN
658 l_order_line_tbl(i).CONTEXT := p_CONTEXT(i);
659 END IF;
660 IF (p_ATTRIBUTE1 is not null) THEN
661 l_order_line_tbl(i).ATTRIBUTE1 := p_ATTRIBUTE1(i);
662 END IF;
663 IF (p_ATTRIBUTE2 is not null) THEN
664 l_order_line_tbl(i).ATTRIBUTE2 := p_ATTRIBUTE2(i);
665 END IF;
666 IF (p_ATTRIBUTE3 is not null) THEN
667 l_order_line_tbl(i).ATTRIBUTE3 := p_ATTRIBUTE3(i);
668 END IF;
669 IF (p_ATTRIBUTE4 is not null) THEN
670 l_order_line_tbl(i).ATTRIBUTE4 := p_ATTRIBUTE4(i);
671 END IF;
672 IF (p_ATTRIBUTE5 is not null) THEN
673 l_order_line_tbl(i).ATTRIBUTE5 := p_ATTRIBUTE5(i);
674 END IF;
675 IF (p_ATTRIBUTE6 is not null) THEN
676 l_order_line_tbl(i).ATTRIBUTE6 := p_ATTRIBUTE6(i);
677 END IF;
678 IF (p_ATTRIBUTE7 is not null) THEN
679 l_order_line_tbl(i).ATTRIBUTE7 := p_ATTRIBUTE7(i);
680 END IF;
681 IF (p_ATTRIBUTE8 is not null) THEN
682 l_order_line_tbl(i).ATTRIBUTE8 := p_ATTRIBUTE8(i);
683 END IF;
684 IF (p_ATTRIBUTE9 is not null) THEN
685 l_order_line_tbl(i).ATTRIBUTE9 := p_ATTRIBUTE9(i);
686 END IF;
687 IF (p_ATTRIBUTE10 is not null) THEN
688 l_order_line_tbl(i).ATTRIBUTE10 := p_ATTRIBUTE10(i);
689 END IF;
690 IF (p_ATTRIBUTE11 is not null) THEN
691 l_order_line_tbl(i).ATTRIBUTE11 := p_ATTRIBUTE11(i);
692 END IF;
693 IF (p_ATTRIBUTE12 is not null) THEN
694 l_order_line_tbl(i).ATTRIBUTE12 := p_ATTRIBUTE12(i);
695 END IF;
696 IF (p_ATTRIBUTE13 is not null) THEN
697 l_order_line_tbl(i).ATTRIBUTE13 := p_ATTRIBUTE13(i);
698 END IF;
699 IF (p_ATTRIBUTE14 is not null) THEN
700 l_order_line_tbl(i).ATTRIBUTE14 := p_ATTRIBUTE14(i);
701 END IF;
702 IF (p_ATTRIBUTE15 is not null) THEN
703 l_order_line_tbl(i).ATTRIBUTE15 := p_ATTRIBUTE15(i);
704 END IF;
705 IF (p_GLOBAL_ATTRIBUTE_CATEGORY is not null) THEN
706 l_order_line_tbl(i).GLOBAL_ATTRIBUTE_CATEGORY := p_GLOBAL_ATTRIBUTE_CATEGORY(i);
707 END IF;
708 IF (p_GLOBAL_ATTRIBUTE1 is not null) THEN
709 l_order_line_tbl(i).GLOBAL_ATTRIBUTE1 := p_GLOBAL_ATTRIBUTE1(i);
710 END IF;
711 IF (p_GLOBAL_ATTRIBUTE2 is not null) THEN
712 l_order_line_tbl(i).GLOBAL_ATTRIBUTE2 := p_GLOBAL_ATTRIBUTE2(i);
713 END IF;
714 IF (p_GLOBAL_ATTRIBUTE3 is not null) THEN
715 l_order_line_tbl(i).GLOBAL_ATTRIBUTE3 := p_GLOBAL_ATTRIBUTE3(i);
716 END IF;
717 IF (p_GLOBAL_ATTRIBUTE4 is not null) THEN
718 l_order_line_tbl(i).GLOBAL_ATTRIBUTE4 := p_GLOBAL_ATTRIBUTE4(i);
719 END IF;
720 IF (p_GLOBAL_ATTRIBUTE5 is not null) THEN
721 l_order_line_tbl(i).GLOBAL_ATTRIBUTE5 := p_GLOBAL_ATTRIBUTE5(i);
722 END IF;
723 IF (p_GLOBAL_ATTRIBUTE6 is not null) THEN
724 l_order_line_tbl(i).GLOBAL_ATTRIBUTE6 := p_GLOBAL_ATTRIBUTE6(i);
725 END IF;
726 IF (p_GLOBAL_ATTRIBUTE7 is not null) THEN
727 l_order_line_tbl(i).GLOBAL_ATTRIBUTE7 := p_GLOBAL_ATTRIBUTE7(i);
728 END IF;
729 IF (p_GLOBAL_ATTRIBUTE8 is not null) THEN
730 l_order_line_tbl(i).GLOBAL_ATTRIBUTE8 := p_GLOBAL_ATTRIBUTE8(i);
731 END IF;
732 IF (p_GLOBAL_ATTRIBUTE9 is not null) THEN
733 l_order_line_tbl(i).GLOBAL_ATTRIBUTE9 := p_GLOBAL_ATTRIBUTE9(i);
734 END IF;
735 IF (p_GLOBAL_ATTRIBUTE10 is not null) THEN
736 l_order_line_tbl(i).GLOBAL_ATTRIBUTE10 := p_GLOBAL_ATTRIBUTE10(i);
737 END IF;
738 IF (p_GLOBAL_ATTRIBUTE11 is not null) THEN
739 l_order_line_tbl(i).GLOBAL_ATTRIBUTE11 := p_GLOBAL_ATTRIBUTE11(i);
740 END IF;
741 IF (p_GLOBAL_ATTRIBUTE12 is not null) THEN
742 l_order_line_tbl(i).GLOBAL_ATTRIBUTE12 := p_GLOBAL_ATTRIBUTE12(i);
743 END IF;
744 IF (p_GLOBAL_ATTRIBUTE13 is not null) THEN
745 l_order_line_tbl(i).GLOBAL_ATTRIBUTE13 := p_GLOBAL_ATTRIBUTE13(i);
746 END IF;
747 IF (p_GLOBAL_ATTRIBUTE14 is not null) THEN
748 l_order_line_tbl(i).GLOBAL_ATTRIBUTE14 := p_GLOBAL_ATTRIBUTE14(i);
749 END IF;
750 IF (p_GLOBAL_ATTRIBUTE15 is not null) THEN
751 l_order_line_tbl(i).GLOBAL_ATTRIBUTE15 := p_GLOBAL_ATTRIBUTE15(i);
752 END IF;
753 IF (p_GLOBAL_ATTRIBUTE16 is not null) THEN
754 l_order_line_tbl(i).GLOBAL_ATTRIBUTE16 := p_GLOBAL_ATTRIBUTE16(i);
755 END IF;
756 IF (p_GLOBAL_ATTRIBUTE17 is not null) THEN
757 l_order_line_tbl(i).GLOBAL_ATTRIBUTE17 := p_GLOBAL_ATTRIBUTE17(i);
758 END IF;
759 IF (p_GLOBAL_ATTRIBUTE18 is not null) THEN
760 l_order_line_tbl(i).GLOBAL_ATTRIBUTE18 := p_GLOBAL_ATTRIBUTE18(i);
761 END IF;
762 IF (p_GLOBAL_ATTRIBUTE19 is not null) THEN
763 l_order_line_tbl(i).GLOBAL_ATTRIBUTE19 := p_GLOBAL_ATTRIBUTE19(i);
764 END IF;
765 IF (p_GLOBAL_ATTRIBUTE20 is not null) THEN
766 l_order_line_tbl(i).GLOBAL_ATTRIBUTE20 := p_GLOBAL_ATTRIBUTE20(i);
767 END IF;
768 IF (p_PRICING_CONTEXT is not null) THEN
769 l_order_line_tbl(i).PRICING_CONTEXT := p_PRICING_CONTEXT(i);
770 END IF;
771 IF (p_PRICING_ATTRIBUTE1 is not null) THEN
772 l_order_line_tbl(i).PRICING_ATTRIBUTE1 := p_PRICING_ATTRIBUTE1(i);
773 END IF;
774 IF (p_PRICING_ATTRIBUTE2 is not null) THEN
775 l_order_line_tbl(i).PRICING_ATTRIBUTE2 := p_PRICING_ATTRIBUTE2(i);
776 END IF;
777 IF (p_PRICING_ATTRIBUTE3 is not null) THEN
778 l_order_line_tbl(i).PRICING_ATTRIBUTE3 := p_PRICING_ATTRIBUTE3(i);
779 END IF;
780 IF (p_PRICING_ATTRIBUTE4 is not null) THEN
781 l_order_line_tbl(i).PRICING_ATTRIBUTE4 := p_PRICING_ATTRIBUTE4(i);
782 END IF;
783 IF (p_PRICING_ATTRIBUTE5 is not null) THEN
784 l_order_line_tbl(i).PRICING_ATTRIBUTE5 := p_PRICING_ATTRIBUTE5(i);
785 END IF;
786 IF (p_PRICING_ATTRIBUTE6 is not null) THEN
787 l_order_line_tbl(i).PRICING_ATTRIBUTE6 := p_PRICING_ATTRIBUTE6(i);
788 END IF;
789 IF (p_PRICING_ATTRIBUTE7 is not null) THEN
790 l_order_line_tbl(i).PRICING_ATTRIBUTE7 := p_PRICING_ATTRIBUTE7(i);
791 END IF;
792 IF (p_PRICING_ATTRIBUTE8 is not null) THEN
793 l_order_line_tbl(i).PRICING_ATTRIBUTE8 := p_PRICING_ATTRIBUTE8(i);
794 END IF;
795 IF (p_PRICING_ATTRIBUTE9 is not null) THEN
796 l_order_line_tbl(i).PRICING_ATTRIBUTE9 := p_PRICING_ATTRIBUTE9(i);
797 END IF;
798 IF (p_PRICING_ATTRIBUTE10 is not null) THEN
799 l_order_line_tbl(i).PRICING_ATTRIBUTE10 := p_PRICING_ATTRIBUTE10(i);
800 END IF;
801 IF (p_INDUSTRY_CONTEXT is not null) THEN
802 l_order_line_tbl(i).INDUSTRY_CONTEXT := p_INDUSTRY_CONTEXT(i);
803 END IF;
804 IF (p_INDUSTRY_ATTRIBUTE1 is not null) THEN
805 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE1 := p_INDUSTRY_ATTRIBUTE1(i);
806 END IF;
807 IF (p_INDUSTRY_ATTRIBUTE2 is not null) THEN
808 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE2 := p_INDUSTRY_ATTRIBUTE2(i);
809 END IF;
810 IF (p_INDUSTRY_ATTRIBUTE3 is not null) THEN
811 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE3 := p_INDUSTRY_ATTRIBUTE3(i);
812 END IF;
813 IF (p_INDUSTRY_ATTRIBUTE4 is not null) THEN
814 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE4 := p_INDUSTRY_ATTRIBUTE4(i);
815 END IF;
816 IF (p_INDUSTRY_ATTRIBUTE5 is not null) THEN
817 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE5 := p_INDUSTRY_ATTRIBUTE5(i);
818 END IF;
819 IF (p_INDUSTRY_ATTRIBUTE6 is not null) THEN
820 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE6 := p_INDUSTRY_ATTRIBUTE6(i);
821 END IF;
822 IF (p_INDUSTRY_ATTRIBUTE7 is not null) THEN
823 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE7 := p_INDUSTRY_ATTRIBUTE7(i);
824 END IF;
825 IF (p_INDUSTRY_ATTRIBUTE8 is not null) THEN
826 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE8 := p_INDUSTRY_ATTRIBUTE8(i);
827 END IF;
828 IF (p_INDUSTRY_ATTRIBUTE9 is not null) THEN
829 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE9 := p_INDUSTRY_ATTRIBUTE9(i);
830 END IF;
831 IF (p_INDUSTRY_ATTRIBUTE10 is not null) THEN
832 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE10 := p_INDUSTRY_ATTRIBUTE10(i);
833 END IF;
834 IF (p_INDUSTRY_ATTRIBUTE11 is not null) THEN
835 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE11 := p_INDUSTRY_ATTRIBUTE11(i);
836 END IF;
837 IF (p_INDUSTRY_ATTRIBUTE13 is not null) THEN
838 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE13 := p_INDUSTRY_ATTRIBUTE13(i);
839 END IF;
840 IF (p_INDUSTRY_ATTRIBUTE12 is not null) THEN
841 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE12 := p_INDUSTRY_ATTRIBUTE12(i);
842 END IF;
843 IF (p_INDUSTRY_ATTRIBUTE14 is not null) THEN
844 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE14 := p_INDUSTRY_ATTRIBUTE14(i);
845 END IF;
846 IF (p_INDUSTRY_ATTRIBUTE15 is not null) THEN
847 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE15 := p_INDUSTRY_ATTRIBUTE15(i);
848 END IF;
849 IF (p_INDUSTRY_ATTRIBUTE16 is not null) THEN
850 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE16 := p_INDUSTRY_ATTRIBUTE16(i);
851 END IF;
852 IF (p_INDUSTRY_ATTRIBUTE17 is not null) THEN
853 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE17 := p_INDUSTRY_ATTRIBUTE17(i);
854 END IF;
855 IF (p_INDUSTRY_ATTRIBUTE18 is not null) THEN
856 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE18 := p_INDUSTRY_ATTRIBUTE18(i);
857 END IF;
858 IF (p_INDUSTRY_ATTRIBUTE19 is not null) THEN
859 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE19 := p_INDUSTRY_ATTRIBUTE19(i);
860 END IF;
861 IF (p_INDUSTRY_ATTRIBUTE20 is not null) THEN
862 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE20 := p_INDUSTRY_ATTRIBUTE20(i);
863 END IF;
864 IF (p_INDUSTRY_ATTRIBUTE21 is not null) THEN
865 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE21 := p_INDUSTRY_ATTRIBUTE21(i);
866 END IF;
867 IF (p_INDUSTRY_ATTRIBUTE22 is not null) THEN
868 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE22 := p_INDUSTRY_ATTRIBUTE22(i);
869 END IF;
870 IF (p_INDUSTRY_ATTRIBUTE23 is not null) THEN
871 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE23 := p_INDUSTRY_ATTRIBUTE23(i);
872 END IF;
873 IF (p_INDUSTRY_ATTRIBUTE24 is not null) THEN
874 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE24 := p_INDUSTRY_ATTRIBUTE24(i);
875 END IF;
876 IF (p_INDUSTRY_ATTRIBUTE25 is not null) THEN
877 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE25 := p_INDUSTRY_ATTRIBUTE25(i);
878 END IF;
879 IF (p_INDUSTRY_ATTRIBUTE26 is not null) THEN
880 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE26 := p_INDUSTRY_ATTRIBUTE26(i);
881 END IF;
882 IF (p_INDUSTRY_ATTRIBUTE27 is not null) THEN
883 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE27 := p_INDUSTRY_ATTRIBUTE27(i);
884 END IF;
885 IF (p_INDUSTRY_ATTRIBUTE28 is not null) THEN
886 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE28 := p_INDUSTRY_ATTRIBUTE28(i);
887 END IF;
888 IF (p_INDUSTRY_ATTRIBUTE29 is not null) THEN
889 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE29 := p_INDUSTRY_ATTRIBUTE29(i);
890 END IF;
891 IF (p_INDUSTRY_ATTRIBUTE30 is not null) THEN
892 l_order_line_tbl(i).INDUSTRY_ATTRIBUTE30 := p_INDUSTRY_ATTRIBUTE30(i);
893 END IF;
894 IF ((p_CREATION_DATE is not null) and ((p_CREATION_DATE(i) is null) or (p_CREATION_DATE(i) <> ROSETTA_G_MISS_DATE))) THEN
895 l_order_line_tbl(i).CREATION_DATE := p_CREATION_DATE(i);
896 END IF;
897 IF ((p_CREATED_BY is not null) and ((p_CREATED_BY(i) is null) or (p_CREATED_BY(i) <> ROSETTA_G_MISS_NUM))) THEN
898 l_order_line_tbl(i).CREATED_BY := p_CREATED_BY(i);
899 END IF;
900 IF ((p_LAST_UPDATE_DATE is not null) and ((p_LAST_UPDATE_DATE(i) is null) or (p_LAST_UPDATE_DATE(i) <> ROSETTA_G_MISS_DATE))) THEN
901 l_order_line_tbl(i).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(i);
902 END IF;
903 IF ((p_LAST_UPDATED_BY is not null) and ((p_LAST_UPDATED_BY(i) is null) or (p_LAST_UPDATED_BY(i) <> ROSETTA_G_MISS_NUM))) THEN
904 l_order_line_tbl(i).LAST_UPDATED_BY := p_LAST_UPDATED_BY(i);
905 END IF;
906 IF ((p_LAST_UPDATE_LOGIN is not null) and ((p_LAST_UPDATE_LOGIN(i) is null) or (p_LAST_UPDATE_LOGIN(i) <> ROSETTA_G_MISS_NUM))) THEN
907 l_order_line_tbl(i).LAST_UPDATE_LOGIN := p_LAST_UPDATE_LOGIN(i);
908 END IF;
909 IF ((p_PROGRAM_APPLICATION_ID is not null) and ((p_PROGRAM_APPLICATION_ID(i) is null) or (p_PROGRAM_APPLICATION_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
910 l_order_line_tbl(i).PROGRAM_APPLICATION_ID := p_PROGRAM_APPLICATION_ID(i);
911 END IF;
912 IF ((p_PROGRAM_ID is not null) and ((p_PROGRAM_ID(i) is null) or (p_PROGRAM_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
913 l_order_line_tbl(i).PROGRAM_ID := p_PROGRAM_ID(i);
914 END IF;
915 IF ((p_PROGRAM_UPDATE_DATE is not null) and ((p_PROGRAM_UPDATE_DATE(i) is null) or (p_PROGRAM_UPDATE_DATE(i) <> ROSETTA_G_MISS_DATE))) THEN
916 l_order_line_tbl(i).PROGRAM_UPDATE_DATE := p_PROGRAM_UPDATE_DATE(i);
917 END IF;
918 IF ((p_REQUEST_ID is not null) and ((p_REQUEST_ID(i) is null) or (p_REQUEST_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
919 l_order_line_tbl(i).REQUEST_ID := p_REQUEST_ID(i);
920 END IF;
921 IF ((p_TOP_MODEL_LINE_ID is not null) and ((p_TOP_MODEL_LINE_ID(i) is null) or (p_TOP_MODEL_LINE_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
922 l_order_line_tbl(i).TOP_MODEL_LINE_ID := p_TOP_MODEL_LINE_ID(i);
923 END IF;
924 IF ((p_LINK_TO_LINE_ID is not null) and ((p_LINK_TO_LINE_ID(i) is null) or (p_LINK_TO_LINE_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
925 l_order_line_tbl(i).LINK_TO_LINE_ID := p_LINK_TO_LINE_ID(i);
926 END IF;
927 IF ((p_COMPONENT_SEQUENCE_ID is not null) and ((p_COMPONENT_SEQUENCE_ID(i) is null) or (p_COMPONENT_SEQUENCE_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
928 l_order_line_tbl(i).COMPONENT_SEQUENCE_ID := p_COMPONENT_SEQUENCE_ID(i);
929 END IF;
930 IF (p_COMPONENT_CODE is not null) THEN
931 l_order_line_tbl(i).COMPONENT_CODE := p_COMPONENT_CODE(i);
932 END IF;
933 IF ((p_CONFIG_DISPLAY_SEQUENCE is not null) and ((p_CONFIG_DISPLAY_SEQUENCE(i) is null) or (p_CONFIG_DISPLAY_SEQUENCE(i) <> ROSETTA_G_MISS_NUM))) THEN
934 l_order_line_tbl(i).CONFIG_DISPLAY_SEQUENCE := p_CONFIG_DISPLAY_SEQUENCE(i);
935 END IF;
936 IF (p_SORT_ORDER is not null) THEN
937 l_order_line_tbl(i).SORT_ORDER := p_SORT_ORDER(i);
938 END IF;
939 IF (p_ITEM_TYPE_CODE is not null) THEN
940 l_order_line_tbl(i).ITEM_TYPE_CODE := p_ITEM_TYPE_CODE(i);
941 END IF;
942 IF ((p_OPTION_NUMBER is not null) and ((p_OPTION_NUMBER(i) is null) or (p_OPTION_NUMBER(i) <> ROSETTA_G_MISS_NUM))) THEN
943 l_order_line_tbl(i).OPTION_NUMBER := p_OPTION_NUMBER(i);
944 END IF;
945 IF (p_OPTION_FLAG is not null) THEN
946 l_order_line_tbl(i).OPTION_FLAG := p_OPTION_FLAG(i);
947 END IF;
948 IF (p_DEP_PLAN_REQUIRED_FLAG is not null) THEN
949 l_order_line_tbl(i).DEP_PLAN_REQUIRED_FLAG := p_DEP_PLAN_REQUIRED_FLAG(i);
950 END IF;
951 IF (p_VISIBLE_DEMAND_FLAG is not null) THEN
952 l_order_line_tbl(i).VISIBLE_DEMAND_FLAG := p_VISIBLE_DEMAND_FLAG(i);
953 END IF;
954 IF (p_LINE_CATEGORY_CODE is not null) THEN
955 l_order_line_tbl(i).LINE_CATEGORY_CODE := p_LINE_CATEGORY_CODE(i);
956 END IF;
957 IF ((p_ACTUAL_SHIPMENT_DATE is not null) and ((p_ACTUAL_SHIPMENT_DATE(i) is null) or (p_ACTUAL_SHIPMENT_DATE(i) <> ROSETTA_G_MISS_DATE))) THEN
958 l_order_line_tbl(i).ACTUAL_SHIPMENT_DATE := p_ACTUAL_SHIPMENT_DATE(i);
959 END IF;
960 IF ((p_CUSTOMER_TRX_LINE_ID is not null) and ((p_CUSTOMER_TRX_LINE_ID(i) is null) or (p_CUSTOMER_TRX_LINE_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
961 l_order_line_tbl(i).CUSTOMER_TRX_LINE_ID := p_CUSTOMER_TRX_LINE_ID(i);
962 END IF;
963 IF (p_RETURN_CONTEXT is not null) THEN
964 l_order_line_tbl(i).RETURN_CONTEXT := p_RETURN_CONTEXT(i);
965 END IF;
966 IF (p_RETURN_ATTRIBUTE1 is not null) THEN
967 l_order_line_tbl(i).RETURN_ATTRIBUTE1 := p_RETURN_ATTRIBUTE1(i);
968 END IF;
969 IF (p_RETURN_ATTRIBUTE2 is not null) THEN
970 l_order_line_tbl(i).RETURN_ATTRIBUTE2 := p_RETURN_ATTRIBUTE2(i);
971 END IF;
972 IF (p_RETURN_ATTRIBUTE3 is not null) THEN
973 l_order_line_tbl(i).RETURN_ATTRIBUTE3 := p_RETURN_ATTRIBUTE3(i);
974 END IF;
975 IF (p_RETURN_ATTRIBUTE4 is not null) THEN
976 l_order_line_tbl(i).RETURN_ATTRIBUTE4 := p_RETURN_ATTRIBUTE4(i);
977 END IF;
978 IF (p_RETURN_ATTRIBUTE5 is not null) THEN
979 l_order_line_tbl(i).RETURN_ATTRIBUTE5 := p_RETURN_ATTRIBUTE5(i);
980 END IF;
981 IF (p_RETURN_ATTRIBUTE6 is not null) THEN
982 l_order_line_tbl(i).RETURN_ATTRIBUTE6 := p_RETURN_ATTRIBUTE6(i);
983 END IF;
984 IF (p_RETURN_ATTRIBUTE7 is not null) THEN
985 l_order_line_tbl(i).RETURN_ATTRIBUTE7 := p_RETURN_ATTRIBUTE7(i);
986 END IF;
987 IF (p_RETURN_ATTRIBUTE8 is not null) THEN
988 l_order_line_tbl(i).RETURN_ATTRIBUTE8 := p_RETURN_ATTRIBUTE8(i);
989 END IF;
990 IF (p_RETURN_ATTRIBUTE9 is not null) THEN
991 l_order_line_tbl(i).RETURN_ATTRIBUTE9 := p_RETURN_ATTRIBUTE9(i);
992 END IF;
993 IF (p_RETURN_ATTRIBUTE10 is not null) THEN
994 l_order_line_tbl(i).RETURN_ATTRIBUTE10 := p_RETURN_ATTRIBUTE10(i);
995 END IF;
996 IF (p_RETURN_ATTRIBUTE11 is not null) THEN
997 l_order_line_tbl(i).RETURN_ATTRIBUTE11 := p_RETURN_ATTRIBUTE11(i);
998 END IF;
999 IF (p_RETURN_ATTRIBUTE12 is not null) THEN
1000 l_order_line_tbl(i).RETURN_ATTRIBUTE12 := p_RETURN_ATTRIBUTE12(i);
1001 END IF;
1002 IF (p_RETURN_ATTRIBUTE13 is not null) THEN
1003 l_order_line_tbl(i).RETURN_ATTRIBUTE13 := p_RETURN_ATTRIBUTE13(i);
1004 END IF;
1005 IF (p_RETURN_ATTRIBUTE14 is not null) THEN
1006 l_order_line_tbl(i).RETURN_ATTRIBUTE14 := p_RETURN_ATTRIBUTE14(i);
1007 END IF;
1008 IF (p_RETURN_ATTRIBUTE15 is not null) THEN
1009 l_order_line_tbl(i).RETURN_ATTRIBUTE15 := p_RETURN_ATTRIBUTE15(i);
1010 END IF;
1011 IF ((p_ACTUAL_ARRIVAL_DATE is not null) and ((p_ACTUAL_ARRIVAL_DATE(i) is null) or (p_ACTUAL_ARRIVAL_DATE(i) <> ROSETTA_G_MISS_DATE))) THEN
1012 l_order_line_tbl(i).ACTUAL_ARRIVAL_DATE := p_ACTUAL_ARRIVAL_DATE(i);
1013 END IF;
1014 IF ((p_ATO_LINE_ID is not null) and ((p_ATO_LINE_ID(i) is null) or (p_ATO_LINE_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
1015 l_order_line_tbl(i).ATO_LINE_ID := p_ATO_LINE_ID(i);
1016 END IF;
1017 IF ((p_AUTO_SELECTED_QUANTITY is not null) and ((p_AUTO_SELECTED_QUANTITY(i) is null) or (p_AUTO_SELECTED_QUANTITY(i) <> ROSETTA_G_MISS_NUM))) THEN
1018 l_order_line_tbl(i).AUTO_SELECTED_QUANTITY := p_AUTO_SELECTED_QUANTITY(i);
1019 END IF;
1020 IF ((p_COMPONENT_NUMBER is not null) and ((p_COMPONENT_NUMBER(i) is null) or (p_COMPONENT_NUMBER(i) <> ROSETTA_G_MISS_NUM))) THEN
1021 l_order_line_tbl(i).COMPONENT_NUMBER := p_COMPONENT_NUMBER(i);
1022 END IF;
1023 IF ((p_EARLIEST_ACCEPTABLE_DATE is not null) and ((p_EARLIEST_ACCEPTABLE_DATE(i) is null) or (p_EARLIEST_ACCEPTABLE_DATE(i) <> ROSETTA_G_MISS_DATE))) THEN
1024 l_order_line_tbl(i).EARLIEST_ACCEPTABLE_DATE := p_EARLIEST_ACCEPTABLE_DATE(i);
1025 END IF;
1026 IF ((p_EXPLOSION_DATE is not null) and ((p_EXPLOSION_DATE(i) is null) or (p_EXPLOSION_DATE(i) <> ROSETTA_G_MISS_DATE))) THEN
1027 l_order_line_tbl(i).EXPLOSION_DATE := p_EXPLOSION_DATE(i);
1028 END IF;
1029 IF ((p_LATEST_ACCEPTABLE_DATE is not null) and ((p_LATEST_ACCEPTABLE_DATE(i) is null) or (p_LATEST_ACCEPTABLE_DATE(i) <> ROSETTA_G_MISS_DATE))) THEN
1030 l_order_line_tbl(i).LATEST_ACCEPTABLE_DATE := p_LATEST_ACCEPTABLE_DATE(i);
1031 END IF;
1032 IF ((p_MODEL_GROUP_NUMBER is not null) and ((p_MODEL_GROUP_NUMBER(i) is null) or (p_MODEL_GROUP_NUMBER(i) <> ROSETTA_G_MISS_NUM))) THEN
1033 l_order_line_tbl(i).MODEL_GROUP_NUMBER := p_MODEL_GROUP_NUMBER(i);
1034 END IF;
1035 IF ((p_SCHEDULE_ARRIVAL_DATE is not null) and ((p_SCHEDULE_ARRIVAL_DATE(i) is null) or (p_SCHEDULE_ARRIVAL_DATE(i) <> ROSETTA_G_MISS_DATE))) THEN
1036 l_order_line_tbl(i).SCHEDULE_ARRIVAL_DATE := p_SCHEDULE_ARRIVAL_DATE(i);
1037 END IF;
1038 IF (p_SHIP_MODEL_COMPLETE_FLAG is not null) THEN
1039 l_order_line_tbl(i).SHIP_MODEL_COMPLETE_FLAG := p_SHIP_MODEL_COMPLETE_FLAG(i);
1040 END IF;
1041 IF (p_SCHEDULE_STATUS_CODE is not null) THEN
1042 l_order_line_tbl(i).SCHEDULE_STATUS_CODE := p_SCHEDULE_STATUS_CODE(i);
1043 END IF;
1044 IF (p_SOURCE_TYPE_CODE is not null) THEN
1045 l_order_line_tbl(i).SOURCE_TYPE_CODE := p_SOURCE_TYPE_CODE(i);
1046 END IF;
1047 IF (p_CANCELLED_FLAG is not null) THEN
1048 l_order_line_tbl(i).CANCELLED_FLAG := p_CANCELLED_FLAG(i);
1049 END IF;
1050 IF (p_OPEN_FLAG is not null) THEN
1051 l_order_line_tbl(i).OPEN_FLAG := p_OPEN_FLAG(i);
1052 END IF;
1053 IF (p_BOOKED_FLAG is not null) THEN
1054 l_order_line_tbl(i).BOOKED_FLAG := p_BOOKED_FLAG(i);
1055 END IF;
1056 IF ((p_SALESREP_ID is not null) and ((p_SALESREP_ID(i) is null) or (p_SALESREP_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
1057 l_order_line_tbl(i).SALESREP_ID := p_SALESREP_ID(i);
1058 END IF;
1059 IF (p_RETURN_REASON_CODE is not null) THEN
1060 l_order_line_tbl(i).RETURN_REASON_CODE := p_RETURN_REASON_CODE(i);
1061 END IF;
1062 IF ((p_ARRIVAL_SET_ID is not null) and ((p_ARRIVAL_SET_ID(i) is null) or (p_ARRIVAL_SET_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
1063 l_order_line_tbl(i).ARRIVAL_SET_ID := p_ARRIVAL_SET_ID(i);
1064 END IF;
1065 IF ((p_SHIP_SET_ID is not null) and ((p_SHIP_SET_ID(i) is null) or (p_SHIP_SET_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
1066 l_order_line_tbl(i).SHIP_SET_ID := p_SHIP_SET_ID(i);
1067 END IF;
1068 IF ((p_SPLIT_FROM_LINE_ID is not null) and ((p_SPLIT_FROM_LINE_ID(i) is null) or (p_SPLIT_FROM_LINE_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
1069 l_order_line_tbl(i).SPLIT_FROM_LINE_ID := p_SPLIT_FROM_LINE_ID(i);
1070 END IF;
1071 IF (p_CUST_PRODUCTION_SEQ_NUM is not null) THEN
1072 l_order_line_tbl(i).CUST_PRODUCTION_SEQ_NUM := p_CUST_PRODUCTION_SEQ_NUM(i);
1073 END IF;
1074 IF (p_AUTHORIZED_TO_SHIP_FLAG is not null) THEN
1075 l_order_line_tbl(i).AUTHORIZED_TO_SHIP_FLAG := p_AUTHORIZED_TO_SHIP_FLAG(i);
1076 END IF;
1077 IF (p_OVER_SHIP_REASON_CODE is not null) THEN
1078 l_order_line_tbl(i).OVER_SHIP_REASON_CODE := p_OVER_SHIP_REASON_CODE(i);
1079 END IF;
1080 IF (p_OVER_SHIP_RESOLVED_FLAG is not null) THEN
1081 l_order_line_tbl(i).OVER_SHIP_RESOLVED_FLAG := p_OVER_SHIP_RESOLVED_FLAG(i);
1082 END IF;
1083 IF ((p_ORDERED_ITEM_ID is not null) and ((p_ORDERED_ITEM_ID(i) is null) or (p_ORDERED_ITEM_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
1084 l_order_line_tbl(i).ORDERED_ITEM_ID := p_ORDERED_ITEM_ID(i);
1085 END IF;
1086 IF (p_ITEM_IDENTIFIER_TYPE is not null) THEN
1087 l_order_line_tbl(i).ITEM_IDENTIFIER_TYPE := p_ITEM_IDENTIFIER_TYPE(i);
1088 END IF;
1089 IF ((p_CONFIGURATION_ID is not null) and ((p_CONFIGURATION_ID(i) is null) or (p_CONFIGURATION_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
1090 l_order_line_tbl(i).CONFIGURATION_ID := p_CONFIGURATION_ID(i);
1091 END IF;
1092 IF ((p_COMMITMENT_ID is not null) and ((p_COMMITMENT_ID(i) is null) or (p_COMMITMENT_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
1093 l_order_line_tbl(i).COMMITMENT_ID := p_COMMITMENT_ID(i);
1094 END IF;
1095 IF (p_SHIPPING_INTERFACED_FLAG is not null) THEN
1096 l_order_line_tbl(i).SHIPPING_INTERFACED_FLAG := p_SHIPPING_INTERFACED_FLAG(i);
1097 END IF;
1098 IF ((p_CREDIT_INVOICE_LINE_ID is not null) and ((p_CREDIT_INVOICE_LINE_ID(i) is null) or (p_CREDIT_INVOICE_LINE_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
1099 l_order_line_tbl(i).CREDIT_INVOICE_LINE_ID := p_CREDIT_INVOICE_LINE_ID(i);
1100 END IF;
1101 IF (p_FIRST_ACK_CODE is not null) THEN
1102 l_order_line_tbl(i).FIRST_ACK_CODE := p_FIRST_ACK_CODE(i);
1103 END IF;
1104 IF ((p_FIRST_ACK_DATE is not null) and ((p_FIRST_ACK_DATE(i) is null) or (p_FIRST_ACK_DATE(i) <> ROSETTA_G_MISS_DATE))) THEN
1105 l_order_line_tbl(i).FIRST_ACK_DATE := p_FIRST_ACK_DATE(i);
1106 END IF;
1107 IF (p_LAST_ACK_CODE is not null) THEN
1108 l_order_line_tbl(i).LAST_ACK_CODE := p_LAST_ACK_CODE(i);
1109 END IF;
1110 IF ((p_LAST_ACK_DATE is not null) and ((p_LAST_ACK_DATE(i) is null) or (p_LAST_ACK_DATE(i) <> ROSETTA_G_MISS_DATE))) THEN
1111 l_order_line_tbl(i).LAST_ACK_DATE := p_LAST_ACK_DATE(i);
1112 END IF;
1113 IF ((p_PLANNING_PRIORITY is not null) and ((p_PLANNING_PRIORITY(i) is null) or (p_PLANNING_PRIORITY(i) <> ROSETTA_G_MISS_NUM))) THEN
1114 l_order_line_tbl(i).PLANNING_PRIORITY := p_PLANNING_PRIORITY(i);
1115 END IF;
1116 IF ((p_ORDER_SOURCE_ID is not null) and ((p_ORDER_SOURCE_ID(i) is null) or (p_ORDER_SOURCE_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
1117 l_order_line_tbl(i).ORDER_SOURCE_ID := p_ORDER_SOURCE_ID(i);
1118 END IF;
1119 IF (p_ORIG_SYS_SHIPMENT_REF is not null) THEN
1120 l_order_line_tbl(i).ORIG_SYS_SHIPMENT_REF := p_ORIG_SYS_SHIPMENT_REF(i);
1121 END IF;
1122 IF (p_CHANGE_SEQUENCE is not null) THEN
1123 l_order_line_tbl(i).CHANGE_SEQUENCE := p_CHANGE_SEQUENCE(i);
1124 END IF;
1125 IF (p_DROP_SHIP_FLAG is not null) THEN
1126 l_order_line_tbl(i).DROP_SHIP_FLAG := p_DROP_SHIP_FLAG(i);
1127 END IF;
1128 IF (p_CUSTOMER_LINE_NUMBER is not null) THEN
1129 l_order_line_tbl(i).CUSTOMER_LINE_NUMBER := p_CUSTOMER_LINE_NUMBER(i);
1130 END IF;
1131 IF (p_CUSTOMER_SHIPMENT_NUMBER is not null) THEN
1132 l_order_line_tbl(i).CUSTOMER_SHIPMENT_NUMBER := p_CUSTOMER_SHIPMENT_NUMBER(i);
1133 END IF;
1134 IF ((p_CUSTOMER_ITEM_NET_PRICE is not null) and ((p_CUSTOMER_ITEM_NET_PRICE(i) is null) or (p_CUSTOMER_ITEM_NET_PRICE(i) <> ROSETTA_G_MISS_NUM))) THEN
1135 l_order_line_tbl(i).CUSTOMER_ITEM_NET_PRICE := p_CUSTOMER_ITEM_NET_PRICE(i);
1136 END IF;
1137 IF ((p_CUSTOMER_PAYMENT_TERM_ID is not null) and ((p_CUSTOMER_PAYMENT_TERM_ID(i) is null) or (p_CUSTOMER_PAYMENT_TERM_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
1138 l_order_line_tbl(i).CUSTOMER_PAYMENT_TERM_ID := p_CUSTOMER_PAYMENT_TERM_ID(i);
1139 END IF;
1140 IF (p_FULFILLED_FLAG is not null) THEN
1141 l_order_line_tbl(i).FULFILLED_FLAG := p_FULFILLED_FLAG(i);
1142 END IF;
1143 IF (p_END_ITEM_UNIT_NUMBER is not null) THEN
1144 l_order_line_tbl(i).END_ITEM_UNIT_NUMBER := p_END_ITEM_UNIT_NUMBER(i);
1145 END IF;
1146 IF ((p_CONFIG_HEADER_ID is not null) and ((p_CONFIG_HEADER_ID(i) is null) or (p_CONFIG_HEADER_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
1147 l_order_line_tbl(i).CONFIG_HEADER_ID := p_CONFIG_HEADER_ID(i);
1148 END IF;
1149 IF ((p_CONFIG_REV_NBR is not null) and ((p_CONFIG_REV_NBR(i) is null) or (p_CONFIG_REV_NBR(i) <> ROSETTA_G_MISS_NUM))) THEN
1150 l_order_line_tbl(i).CONFIG_REV_NBR := p_CONFIG_REV_NBR(i);
1151 END IF;
1152 IF ((p_MFG_COMPONENT_SEQUENCE_ID is not null) and ((p_MFG_COMPONENT_SEQUENCE_ID(i) is null) or (p_MFG_COMPONENT_SEQUENCE_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
1153 l_order_line_tbl(i).MFG_COMPONENT_SEQUENCE_ID := p_MFG_COMPONENT_SEQUENCE_ID(i);
1154 END IF;
1155 IF (p_SHIPPING_INSTRUCTIONS is not null) THEN
1156 l_order_line_tbl(i).SHIPPING_INSTRUCTIONS := p_SHIPPING_INSTRUCTIONS(i);
1157 END IF;
1158 IF (p_PACKING_INSTRUCTIONS is not null) THEN
1159 l_order_line_tbl(i).PACKING_INSTRUCTIONS := p_PACKING_INSTRUCTIONS(i);
1160 END IF;
1161 IF ((p_INVOICED_QUANTITY is not null) and ((p_INVOICED_QUANTITY(i) is null) or (p_INVOICED_QUANTITY(i) <> ROSETTA_G_MISS_NUM))) THEN
1162 l_order_line_tbl(i).INVOICED_QUANTITY := p_INVOICED_QUANTITY(i);
1163 END IF;
1164 IF ((p_REF_CUSTOMER_TRX_LINE_ID is not null) and ((p_REF_CUSTOMER_TRX_LINE_ID(i) is null) or (p_REF_CUSTOMER_TRX_LINE_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
1165 l_order_line_tbl(i).REFERENCE_CUSTOMER_TRX_LINE_ID := p_REF_CUSTOMER_TRX_LINE_ID(i);
1166 END IF;
1167 IF (p_SPLIT_BY is not null) THEN
1168 l_order_line_tbl(i).SPLIT_BY := p_SPLIT_BY(i);
1169 END IF;
1170 IF ((p_LINE_SET_ID is not null) and ((p_LINE_SET_ID(i) is null) or (p_LINE_SET_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
1171 l_order_line_tbl(i).LINE_SET_ID := p_LINE_SET_ID(i);
1172 END IF;
1173 IF (p_SERVICE_TXN_REASON_CODE is not null) THEN
1174 l_order_line_tbl(i).SERVICE_TXN_REASON_CODE := p_SERVICE_TXN_REASON_CODE(i);
1175 END IF;
1176 IF (p_SERVICE_TXN_COMMENTS is not null) THEN
1177 l_order_line_tbl(i).SERVICE_TXN_COMMENTS := p_SERVICE_TXN_COMMENTS(i);
1178 END IF;
1179 IF ((p_SERVICE_DURATION is not null) and ((p_SERVICE_DURATION(i) is null) or (p_SERVICE_DURATION(i) <> ROSETTA_G_MISS_NUM))) THEN
1180 l_order_line_tbl(i).SERVICE_DURATION := p_SERVICE_DURATION(i);
1181 END IF;
1182 IF ((p_SERVICE_START_DATE is not null) and ((p_SERVICE_START_DATE(i) is null) or (p_SERVICE_START_DATE(i) <> ROSETTA_G_MISS_DATE))) THEN
1183 l_order_line_tbl(i).SERVICE_START_DATE := p_SERVICE_START_DATE(i);
1184 END IF;
1185 IF ((p_SERVICE_END_DATE is not null) and ((p_SERVICE_END_DATE(i) is null) or (p_SERVICE_END_DATE(i) <> ROSETTA_G_MISS_DATE))) THEN
1186 l_order_line_tbl(i).SERVICE_END_DATE := p_SERVICE_END_DATE(i);
1187 END IF;
1188 IF (p_SERVICE_COTERMINATE_FLAG is not null) THEN
1189 l_order_line_tbl(i).SERVICE_COTERMINATE_FLAG := p_SERVICE_COTERMINATE_FLAG(i);
1190 END IF;
1191 IF ((p_UNIT_LIST_PERCENT is not null) and ((p_UNIT_LIST_PERCENT(i) is null) or (p_UNIT_LIST_PERCENT(i) <> ROSETTA_G_MISS_NUM))) THEN
1192 l_order_line_tbl(i).UNIT_LIST_PERCENT := p_UNIT_LIST_PERCENT(i);
1193 END IF;
1194 IF ((p_UNIT_SELLING_PERCENT is not null) and ((p_UNIT_SELLING_PERCENT(i) is null) or (p_UNIT_SELLING_PERCENT(i) <> ROSETTA_G_MISS_NUM))) THEN
1195 l_order_line_tbl(i).UNIT_SELLING_PERCENT := p_UNIT_SELLING_PERCENT(i);
1196 END IF;
1197 IF ((p_UNIT_PERCENT_BASE_PRICE is not null) and ((p_UNIT_PERCENT_BASE_PRICE(i) is null) or (p_UNIT_PERCENT_BASE_PRICE(i) <> ROSETTA_G_MISS_NUM))) THEN
1198 l_order_line_tbl(i).UNIT_PERCENT_BASE_PRICE := p_UNIT_PERCENT_BASE_PRICE(i);
1199 END IF;
1200 IF ((p_SERVICE_NUMBER is not null) and ((p_SERVICE_NUMBER(i) is null) or (p_SERVICE_NUMBER(i) <> ROSETTA_G_MISS_NUM))) THEN
1201 l_order_line_tbl(i).SERVICE_NUMBER := p_SERVICE_NUMBER(i);
1202 END IF;
1203 IF (p_SERVICE_PERIOD is not null) THEN
1204 l_order_line_tbl(i).SERVICE_PERIOD := p_SERVICE_PERIOD(i);
1205 END IF;
1206 IF (p_SHIPPABLE_FLAG is not null) THEN
1207 l_order_line_tbl(i).SHIPPABLE_FLAG := p_SHIPPABLE_FLAG(i);
1208 END IF;
1209 IF (p_MODEL_REMNANT_FLAG is not null) THEN
1210 l_order_line_tbl(i).MODEL_REMNANT_FLAG := p_MODEL_REMNANT_FLAG(i);
1211 END IF;
1212 IF (p_RE_SOURCE_FLAG is not null) THEN
1213 l_order_line_tbl(i).RE_SOURCE_FLAG := p_RE_SOURCE_FLAG(i);
1214 END IF;
1215 IF (p_FLOW_STATUS_CODE is not null) THEN
1216 l_order_line_tbl(i).FLOW_STATUS_CODE := p_FLOW_STATUS_CODE(i);
1217 END IF;
1218 IF (p_TP_CONTEXT is not null) THEN
1219 l_order_line_tbl(i).TP_CONTEXT := p_TP_CONTEXT(i);
1220 END IF;
1221 IF (p_TP_ATTRIBUTE1 is not null) THEN
1222 l_order_line_tbl(i).TP_ATTRIBUTE1 := p_TP_ATTRIBUTE1(i);
1223 END IF;
1224 IF (p_TP_ATTRIBUTE2 is not null) THEN
1225 l_order_line_tbl(i).TP_ATTRIBUTE2 := p_TP_ATTRIBUTE2(i);
1226 END IF;
1227 IF (p_TP_ATTRIBUTE3 is not null) THEN
1228 l_order_line_tbl(i).TP_ATTRIBUTE3 := p_TP_ATTRIBUTE3(i);
1229 END IF;
1230 IF (p_TP_ATTRIBUTE4 is not null) THEN
1231 l_order_line_tbl(i).TP_ATTRIBUTE4 := p_TP_ATTRIBUTE4(i);
1232 END IF;
1233 IF (p_TP_ATTRIBUTE5 is not null) THEN
1234 l_order_line_tbl(i).TP_ATTRIBUTE5 := p_TP_ATTRIBUTE5(i);
1235 END IF;
1236 IF (p_TP_ATTRIBUTE6 is not null) THEN
1237 l_order_line_tbl(i).TP_ATTRIBUTE6 := p_TP_ATTRIBUTE6(i);
1238 END IF;
1239 IF (p_TP_ATTRIBUTE7 is not null) THEN
1240 l_order_line_tbl(i).TP_ATTRIBUTE7 := p_TP_ATTRIBUTE7(i);
1241 END IF;
1242 IF (p_TP_ATTRIBUTE8 is not null) THEN
1243 l_order_line_tbl(i).TP_ATTRIBUTE8 := p_TP_ATTRIBUTE8(i);
1244 END IF;
1245 IF (p_TP_ATTRIBUTE9 is not null) THEN
1246 l_order_line_tbl(i).TP_ATTRIBUTE9 := p_TP_ATTRIBUTE9(i);
1247 END IF;
1248 IF (p_TP_ATTRIBUTE10 is not null) THEN
1249 l_order_line_tbl(i).TP_ATTRIBUTE10 := p_TP_ATTRIBUTE10(i);
1250 END IF;
1251 IF (p_TP_ATTRIBUTE11 is not null) THEN
1252 l_order_line_tbl(i).TP_ATTRIBUTE11 := p_TP_ATTRIBUTE11(i);
1253 END IF;
1254 IF (p_TP_ATTRIBUTE12 is not null) THEN
1255 l_order_line_tbl(i).TP_ATTRIBUTE12 := p_TP_ATTRIBUTE12(i);
1256 END IF;
1257 IF (p_TP_ATTRIBUTE13 is not null) THEN
1258 l_order_line_tbl(i).TP_ATTRIBUTE13 := p_TP_ATTRIBUTE13(i);
1259 END IF;
1260 IF (p_TP_ATTRIBUTE14 is not null) THEN
1261 l_order_line_tbl(i).TP_ATTRIBUTE14 := p_TP_ATTRIBUTE14(i);
1262 END IF;
1263 IF (p_TP_ATTRIBUTE15 is not null) THEN
1264 l_order_line_tbl(i).TP_ATTRIBUTE15 := p_TP_ATTRIBUTE15(i);
1265 END IF;
1266 IF (p_FULFILLMENT_METHOD_CODE is not null) THEN
1267 l_order_line_tbl(i).FULFILLMENT_METHOD_CODE := p_FULFILLMENT_METHOD_CODE(i);
1268 END IF;
1269 IF ((p_MARKETING_SOURCE_CODE_ID is not null) and ((p_MARKETING_SOURCE_CODE_ID(i) is null) or (p_MARKETING_SOURCE_CODE_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
1270 l_order_line_tbl(i).MARKETING_SOURCE_CODE_ID := p_MARKETING_SOURCE_CODE_ID(i);
1271 END IF;
1272 IF (p_SERVICE_REF_TYPE_CODE is not null) THEN
1273 l_order_line_tbl(i).SERVICE_REFERENCE_TYPE_CODE := p_SERVICE_REF_TYPE_CODE(i);
1274 END IF;
1275 IF ((p_SERVICE_REFERENCE_LINE_ID is not null) and ((p_SERVICE_REFERENCE_LINE_ID(i) is null) or (p_SERVICE_REFERENCE_LINE_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
1276 l_order_line_tbl(i).SERVICE_REFERENCE_LINE_ID := p_SERVICE_REFERENCE_LINE_ID(i);
1277 END IF;
1278 IF ((p_SERVICE_REF_SYSTEM_ID is not null) and ((p_SERVICE_REF_SYSTEM_ID(i) is null) or (p_SERVICE_REF_SYSTEM_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
1279 l_order_line_tbl(i).SERVICE_REFERENCE_SYSTEM_ID := p_SERVICE_REF_SYSTEM_ID(i);
1280 END IF;
1281 IF (p_CALCULATE_PRICE_FLAG is not null) THEN
1282 l_order_line_tbl(i).CALCULATE_PRICE_FLAG := p_CALCULATE_PRICE_FLAG(i);
1283 END IF;
1284 IF (p_UPGRADED_FLAG is not null) THEN
1285 l_order_line_tbl(i).UPGRADED_FLAG := p_UPGRADED_FLAG(i);
1286 END IF;
1287 IF ((p_REVENUE_AMOUNT is not null) and ((p_REVENUE_AMOUNT(i) is null) or (p_REVENUE_AMOUNT(i) <> ROSETTA_G_MISS_NUM))) THEN
1288 l_order_line_tbl(i).REVENUE_AMOUNT := p_REVENUE_AMOUNT(i);
1289 END IF;
1290 IF ((p_FULFILLMENT_DATE is not null) and ((p_FULFILLMENT_DATE(i) is null) or (p_FULFILLMENT_DATE(i) <> ROSETTA_G_MISS_DATE))) THEN
1291 l_order_line_tbl(i).FULFILLMENT_DATE := p_FULFILLMENT_DATE(i);
1292 END IF;
1293 IF (p_PREFERRED_GRADE is not null) THEN
1294 l_order_line_tbl(i).PREFERRED_GRADE := p_PREFERRED_GRADE(i);
1295 END IF;
1296 IF ((p_ORDERED_QUANTITY2 is not null) and ((p_ORDERED_QUANTITY2(i) is null) or (p_ORDERED_QUANTITY2(i) <> ROSETTA_G_MISS_NUM))) THEN
1297 l_order_line_tbl(i).ORDERED_QUANTITY2 := p_ORDERED_QUANTITY2(i);
1298 END IF;
1299 IF (p_ORDERED_QUANTITY_UOM2 is not null) THEN
1300 l_order_line_tbl(i).ORDERED_QUANTITY_UOM2 := p_ORDERED_QUANTITY_UOM2(i);
1301 END IF;
1302 IF ((p_SHIPPING_QUANTITY2 is not null) and ((p_SHIPPING_QUANTITY2(i) is null) or (p_SHIPPING_QUANTITY2(i) <> ROSETTA_G_MISS_NUM))) THEN
1303 l_order_line_tbl(i).SHIPPING_QUANTITY2 := p_SHIPPING_QUANTITY2(i);
1304 END IF;
1305 IF ((p_CANCELLED_QUANTITY2 is not null) and ((p_CANCELLED_QUANTITY2(i) is null) or (p_CANCELLED_QUANTITY2(i) <> ROSETTA_G_MISS_NUM))) THEN
1306 l_order_line_tbl(i).CANCELLED_QUANTITY2 := p_CANCELLED_QUANTITY2(i);
1307 END IF;
1308 IF ((p_SHIPPED_QUANTITY2 is not null) and ((p_SHIPPED_QUANTITY2(i) is null) or (p_SHIPPED_QUANTITY2(i) <> ROSETTA_G_MISS_NUM))) THEN
1309 l_order_line_tbl(i).SHIPPED_QUANTITY2 := p_SHIPPED_QUANTITY2(i);
1310 END IF;
1311 IF (p_SHIPPING_QUANTITY_UOM2 is not null) THEN
1312 l_order_line_tbl(i).SHIPPING_QUANTITY_UOM2 := p_SHIPPING_QUANTITY_UOM2(i);
1313 END IF;
1314 IF ((p_FULFILLED_QUANTITY2 is not null) and ((p_FULFILLED_QUANTITY2(i) is null) or (p_FULFILLED_QUANTITY2(i) <> ROSETTA_G_MISS_NUM))) THEN
1315 l_order_line_tbl(i).FULFILLED_QUANTITY2 := p_FULFILLED_QUANTITY2(i);
1316 END IF;
1317 IF ((p_MFG_LEAD_TIME is not null) and ((p_MFG_LEAD_TIME(i) is null) or (p_MFG_LEAD_TIME(i) <> ROSETTA_G_MISS_NUM))) THEN
1318 l_order_line_tbl(i).MFG_LEAD_TIME := p_MFG_LEAD_TIME(i);
1319 END IF;
1320 IF ((p_LOCK_CONTROL is not null) and ((p_LOCK_CONTROL(i) is null) or (p_LOCK_CONTROL(i) <> ROSETTA_G_MISS_NUM))) THEN
1321 l_order_line_tbl(i).LOCK_CONTROL := p_LOCK_CONTROL(i);
1322 END IF;
1323 IF (p_SUBINVENTORY is not null) THEN
1324 l_order_line_tbl(i).SUBINVENTORY := p_SUBINVENTORY(i);
1325 END IF;
1326 IF ((p_UNIT_LIST_PRICE_PER_PQTY is not null) and ((p_UNIT_LIST_PRICE_PER_PQTY(i) is null) or (p_UNIT_LIST_PRICE_PER_PQTY(i) <> ROSETTA_G_MISS_NUM))) THEN
1327 l_order_line_tbl(i).UNIT_LIST_PRICE_PER_PQTY := p_UNIT_LIST_PRICE_PER_PQTY(i);
1328 END IF;
1329 IF ((p_UNIT_SELL_PRICE_PER_PQTY is not null) and ((p_UNIT_SELL_PRICE_PER_PQTY(i) is null) or (p_UNIT_SELL_PRICE_PER_PQTY(i) <> ROSETTA_G_MISS_NUM))) THEN
1330 l_order_line_tbl(i).UNIT_SELLING_PRICE_PER_PQTY := p_UNIT_SELL_PRICE_PER_PQTY(i);
1331 END IF;
1332 IF (p_PRICE_REQUEST_CODE is not null) THEN
1333 l_order_line_tbl(i).PRICE_REQUEST_CODE := p_PRICE_REQUEST_CODE(i);
1334 END IF;
1335 IF ((p_ORIGINAL_INVENTORY_ITEM_ID is not null) and ((p_ORIGINAL_INVENTORY_ITEM_ID(i) is null) or (p_ORIGINAL_INVENTORY_ITEM_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
1336 l_order_line_tbl(i).ORIGINAL_INVENTORY_ITEM_ID := p_ORIGINAL_INVENTORY_ITEM_ID(i);
1337 END IF;
1338 IF ((p_ORIGINAL_ORDERED_ITEM_ID is not null) and ((p_ORIGINAL_ORDERED_ITEM_ID(i) is null) or (p_ORIGINAL_ORDERED_ITEM_ID(i) <> ROSETTA_G_MISS_NUM))) THEN
1339 l_order_line_tbl(i).ORIGINAL_ORDERED_ITEM_ID := p_ORIGINAL_ORDERED_ITEM_ID(i);
1340 END IF;
1341 IF (p_ORIGINAL_ORDERED_ITEM is not null) THEN
1342 l_order_line_tbl(i).ORIGINAL_ORDERED_ITEM := p_ORIGINAL_ORDERED_ITEM(i);
1343 END IF;
1344 IF (p_ORIGINAL_ITEM_IDENTIF_TYPE is not null) THEN
1345 l_order_line_tbl(i).ORIGINAL_ITEM_IDENTIFIER_TYPE := p_ORIGINAL_ITEM_IDENTIF_TYPE(i);
1346 END IF;
1347 IF (p_ITEM_SUBSTIT_TYPE_CODE is not null) THEN
1348 l_order_line_tbl(i).ITEM_SUBSTITUTION_TYPE_CODE := p_ITEM_SUBSTIT_TYPE_CODE(i);
1349 END IF;
1350 IF (p_OVERRIDE_ATP_DATE_CODE is not null) THEN
1351 l_order_line_tbl(i).OVERRIDE_ATP_DATE_CODE := p_OVERRIDE_ATP_DATE_CODE(i);
1352 END IF;
1353 IF ((p_LATE_DEMAND_PENALTY_FACTOR is not null) and ((p_LATE_DEMAND_PENALTY_FACTOR(i) is null) or (p_LATE_DEMAND_PENALTY_FACTOR(i) <> ROSETTA_G_MISS_NUM))) THEN
1354 l_order_line_tbl(i).LATE_DEMAND_PENALTY_FACTOR := p_LATE_DEMAND_PENALTY_FACTOR(i);
1355 END IF;
1356 IF ((p_ACCOUNTING_RULE_DURATION is not null) and ((p_ACCOUNTING_RULE_DURATION(i) is null) or (p_ACCOUNTING_RULE_DURATION(i) <> ROSETTA_G_MISS_NUM))) THEN
1357 l_order_line_tbl(i).ACCOUNTING_RULE_DURATION := p_ACCOUNTING_RULE_DURATION(i);
1358 END IF;
1359
1360 IF ((p_top_model_line_index is not null) and ((p_top_model_line_index(i) is null) or (p_top_model_line_index(i) <> ROSETTA_G_MISS_NUM))) THEN
1361 l_order_line_tbl(i).top_model_line_index := p_top_model_line_index(i);
1362 END IF;
1363
1364 IF (p_top_model_line_ref is not null) THEN
1365 l_order_line_tbl(i).top_model_line_ref := p_top_model_line_ref(i);
1366 END IF;
1367
1368 /*IF ((p_unit_cost is not null) and ((p_unit_cost(i) is null) or (p_unit_cost(i) <> ROSETTA_G_MISS_NUM))) THEN
1369 l_order_line_tbl(i).unit_cost := p_unit_cost(i);
1370 END IF;
1371
1372 IF (p_xml_transaction_type_code is not null) THEN
1373 l_order_line_tbl(i).xml_transaction_type_code := p_xml_transaction_type_code(i);
1374 END IF;*/
1375
1376 IF ((p_Sold_to_address_id is not null) and ((p_Sold_to_address_id(i) is null) or (p_Sold_to_address_id(i) <> ROSETTA_G_MISS_NUM))) THEN
1377 l_order_line_tbl(i).Sold_to_address_id := p_Sold_to_address_id(i);
1378 END IF;
1379
1380 IF (p_Split_Action_Code is not null) THEN
1381 l_order_line_tbl(i).Split_Action_Code := p_Split_Action_Code(i);
1382 END IF;
1383
1384 IF (p_split_from_line_ref is not null) THEN
1385 l_order_line_tbl(i).split_from_line_ref := p_split_from_line_ref(i);
1386 END IF;
1387
1388 IF (p_split_from_shipment_ref is not null) THEN
1389 l_order_line_tbl(i).split_from_shipment_ref := p_split_from_shipment_ref(i);
1390 END IF;
1391
1392 IF (p_status_flag is not null) THEN
1393 l_order_line_tbl(i).status_flag := p_status_flag(i);
1394 END IF;
1395
1396 IF (p_ship_from_edi_loc_code is not null) THEN
1397 l_order_line_tbl(i).ship_from_edi_location_code := p_ship_from_edi_loc_code(i);
1398 END IF;
1399
1400 IF (p_ship_set is not null) THEN
1401 l_order_line_tbl(i).ship_set := p_ship_set(i);
1402 END IF;
1403
1404 IF (p_Ship_to_address_code is not null) THEN
1405 l_order_line_tbl(i).Ship_to_address_code := p_Ship_to_address_code(i);
1406 END IF;
1407
1408 IF (p_Ship_to_address_id is not null) THEN
1409 l_order_line_tbl(i).Ship_to_address_id := p_Ship_to_address_id(i);
1410 END IF;
1411
1412 IF ((p_ship_to_customer_id is not null) and ((p_ship_to_customer_id(i) is null) or (p_ship_to_customer_id(i) <> ROSETTA_G_MISS_NUM))) THEN
1413 l_order_line_tbl(i).ship_to_customer_id := p_ship_to_customer_id(i);
1414 END IF;
1415
1416 IF (p_ship_to_edi_location_code is not null) THEN
1417 l_order_line_tbl(i).ship_to_edi_location_code := p_ship_to_edi_location_code(i);
1418 END IF;
1419
1420 IF ((p_service_ref_line_number is not null) and ((p_service_ref_line_number(i) is null) or (p_service_ref_line_number(i) <> ROSETTA_G_MISS_NUM))) THEN
1421 l_order_line_tbl(i).service_ref_line_number := p_service_ref_line_number(i);
1422 END IF;
1423
1424 IF ((p_service_ref_option_number is not null) and ((p_service_ref_option_number(i) is null) or (p_service_ref_option_number(i) <> ROSETTA_G_MISS_NUM))) THEN
1425 l_order_line_tbl(i).service_ref_option_number := p_service_ref_option_number(i);
1426 END IF;
1427
1428 IF ((p_service_ref_order_number is not null) and ((p_service_ref_order_number(i) is null) or (p_service_ref_order_number(i) <> ROSETTA_G_MISS_NUM))) THEN
1429 l_order_line_tbl(i).service_ref_order_number := p_service_ref_order_number(i);
1430 END IF;
1431
1432 IF ((p_service_ref_ship_number is not null) and ((p_service_ref_ship_number(i) is null) or (p_service_ref_ship_number(i) <> ROSETTA_G_MISS_NUM))) THEN
1433 l_order_line_tbl(i).service_ref_shipment_number := p_service_ref_ship_number(i);
1434 END IF;
1435
1436 IF (p_service_reference_line is not null) THEN
1437 l_order_line_tbl(i).service_reference_line := p_service_reference_line(i);
1438 END IF;
1439
1440 IF (p_service_reference_order is not null) THEN
1441 l_order_line_tbl(i).service_reference_order := p_service_reference_order(i);
1442 END IF;
1443
1444 IF (p_service_reference_system is not null) THEN
1445 l_order_line_tbl(i).service_reference_system := p_service_reference_system(i);
1446 END IF;
1447
1448 IF ((p_reserved_quantity is not null) and ((p_reserved_quantity(i) is null) or (p_reserved_quantity(i) <> ROSETTA_G_MISS_NUM))) THEN
1449 l_order_line_tbl(i).reserved_quantity := p_reserved_quantity(i);
1450 END IF;
1451
1452 IF (p_return_status is not null) THEN
1453 l_order_line_tbl(i).return_status := p_return_status(i);
1454 END IF;
1455
1456 IF (p_schedule_action_code is not null) THEN
1457 l_order_line_tbl(i).schedule_action_code := p_schedule_action_code(i);
1458 END IF;
1459
1460 IF ((p_service_line_index is not null) and ((p_service_line_index(i) is null) or (p_service_line_index(i) <> ROSETTA_G_MISS_NUM))) THEN
1461 l_order_line_tbl(i).service_line_index := p_service_line_index(i);
1462 END IF;
1463
1464 IF ((p_intermed_ship_to_cont_id is not null) and ((p_intermed_ship_to_cont_id(i) is null) or (p_intermed_ship_to_cont_id(i) <> ROSETTA_G_MISS_NUM))) THEN
1465 l_order_line_tbl(i).intermed_ship_to_contact_id := p_intermed_ship_to_cont_id(i);
1466 END IF;
1467
1468 IF ((p_intermed_ship_to_org_id is not null) and ((p_intermed_ship_to_org_id(i) is null) or (p_intermed_ship_to_org_id(i) <> ROSETTA_G_MISS_NUM))) THEN
1469 l_order_line_tbl(i).intermed_ship_to_org_id := p_intermed_ship_to_org_id(i);
1470 END IF;
1471
1472 IF ((p_Invoice_address_id is not null) and ((p_Invoice_address_id(i) is null) or (p_Invoice_address_id(i) <> ROSETTA_G_MISS_NUM))) THEN
1473 l_order_line_tbl(i).Invoice_address_id := p_Invoice_address_id(i);
1474 END IF;
1475
1476 IF ((p_invoice_to_customer_id is not null) and ((p_invoice_to_customer_id(i) is null) or (p_invoice_to_customer_id(i) <> ROSETTA_G_MISS_NUM))) THEN
1477 l_order_line_tbl(i).invoice_to_customer_id := p_invoice_to_customer_id(i);
1478 END IF;
1479
1480 /* IF ((p_item_relationship_type is not null) and ((p_item_relationship_type(i) is null) or (p_item_relationship_type(i) <> ROSETTA_G_MISS_NUM))) THEN
1481 l_order_line_tbl(i).item_relationship_type := p_item_relationship_type(i);
1482 END IF;*/
1483
1484 IF ((p_link_to_line_index is not null) and ((p_link_to_line_index(i) is null) or (p_link_to_line_index(i) <> ROSETTA_G_MISS_NUM))) THEN
1485 l_order_line_tbl(i).link_to_line_index := p_link_to_line_index(i);
1486 END IF;
1487
1488 IF (p_link_to_line_ref is not null) THEN
1489 l_order_line_tbl(i).link_to_line_ref := p_link_to_line_ref(i);
1490 END IF;
1491
1492 IF (p_db_flag is not null) THEN
1493 l_order_line_tbl(i).db_flag := p_db_flag(i);
1494 END IF;
1495
1496 IF ((p_deliver_to_customer_id is not null) and ((p_deliver_to_customer_id(i) is null) or (p_deliver_to_customer_id(i) <> ROSETTA_G_MISS_NUM))) THEN
1497 l_order_line_tbl(i).deliver_to_customer_id := p_deliver_to_customer_id(i);
1498 END IF;
1499
1500 IF (p_fulfillment_set is not null) THEN
1501 l_order_line_tbl(i).fulfillment_set := p_fulfillment_set(i);
1502 END IF;
1503
1504 IF ((p_fulfillment_set_id is not null) and ((p_fulfillment_set_id(i) is null) or (p_fulfillment_set_id(i) <> ROSETTA_G_MISS_NUM))) THEN
1505 l_order_line_tbl(i).fulfillment_set_id := p_fulfillment_set_id(i);
1506 END IF;
1507
1508 IF (p_change_comments is not null) THEN
1509 l_order_line_tbl(i).change_comments := p_change_comments(i);
1510 END IF;
1511
1512 IF (p_change_reason is not null) THEN
1513 l_order_line_tbl(i).change_reason := p_change_reason(i);
1514 END IF;
1515
1516 IF (p_change_request_code is not null) THEN
1517 l_order_line_tbl(i).change_request_code := p_change_request_code(i);
1518 END IF;
1519
1520 IF (p_Bill_to_Edi_Location_Code is not null) THEN
1521 l_order_line_tbl(i).Bill_to_Edi_Location_Code := p_Bill_to_Edi_Location_Code(i);
1522 END IF;
1523
1524 /*IF ((p_Blanket_Line_Number is not null) and ((p_Blanket_Line_Number(i) is null) or (p_Blanket_Line_Number(i) <> ROSETTA_G_MISS_NUM))) THEN
1525 l_order_line_tbl(i).Blanket_Line_Number := p_Blanket_Line_Number(i);
1526 END IF;
1527
1528 IF ((p_Blanket_Number is not null) and ((p_Blanket_Number(i) is null) or (p_Blanket_Number(i) <> ROSETTA_G_MISS_NUM))) THEN
1529 l_order_line_tbl(i).Blanket_Number := p_Blanket_Number(i);
1530 END IF;
1531
1532 IF ((p_Blanket_Version_Number is not null) and ((p_Blanket_Version_Number(i) is null) or (p_Blanket_Version_Number(i) <> ROSETTA_G_MISS_NUM))) THEN
1533 l_order_line_tbl(i).Blanket_Version_Number := p_Blanket_Version_Number(i);
1534 END IF;*/
1535
1536 IF (p_arrival_set is not null) THEN
1537 l_order_line_tbl(i).arrival_set := p_arrival_set(i);
1538 END IF;
1539
1540 /* IF (p_attribute16 is not null) THEN
1541 l_order_line_tbl(i).attribute16 := p_attribute16(i);
1542 END IF;
1543
1544 IF (p_attribute17 is not null) THEN
1545 l_order_line_tbl(i).attribute17 := p_attribute17(i);
1546 END IF;
1547
1548 IF (p_attribute18 is not null) THEN
1549 l_order_line_tbl(i).attribute18 := p_attribute18(i);
1550 END IF;
1551
1552 IF (p_attribute19 is not null) THEN
1553 l_order_line_tbl(i).attribute19 := p_attribute19(i);
1554 END IF;
1555
1556 IF (p_attribute20 is not null) THEN
1557 l_order_line_tbl(i).attribute20 := p_attribute20(i);
1558 END IF;*/
1559
1560 END LOOP;
1561
1562 RETURN l_order_line_tbl;
1563
1564 ELSE
1565 RETURN OE_ORDER_PUB.G_MISS_LINE_TBL; --empty qte_line arrays passed in
1566
1567
1568 END IF; --end if for l_table_siz
1569 IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1570 IBE_Util.Debug('In Returns construct LineRecord package body - End');
1571 END IF;
1572
1573 END Construct_Line_Tbl;
1574
1575
1576 Function Construct_Hdr_Tbl(
1577 p_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
1578 p_OPERATION IN VARCHAR2 := FND_API.G_MISS_CHAR,
1579 p_ORG_ID IN NUMBER := FND_API.G_MISS_NUM,
1580 p_ORDER_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
1581 p_ORDER_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
1582 p_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
1583 p_EXPIRATION_DATE IN DATE := FND_API.G_MISS_DATE,
1584 p_ORDER_SOURCE_ID IN NUMBER := FND_API.G_MISS_NUM,
1585 p_SOURCE_DOCUMENT_TYPE_ID IN NUMBER := FND_API.G_MISS_NUM,
1586 p_ORIG_SYS_DOCUMENT_REF IN VARCHAR2 := FND_API.G_MISS_CHAR,
1587 p_SOURCE_DOCUMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
1588 p_ORDERED_DATE IN DATE := FND_API.G_MISS_DATE,
1589 p_REQUEST_DATE IN DATE := FND_API.G_MISS_DATE,
1590 p_PRICING_DATE IN DATE := FND_API.G_MISS_DATE,
1591 p_SHIPMENT_PRIORITY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1592 p_DEMAND_CLASS_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1593 p_PRICE_LIST_ID IN NUMBER := FND_API.G_MISS_NUM,
1594 p_MINISITE_ID IN NUMBER := FND_API.G_MISS_NUM, -- bug 8337371, scnagara
1595 p_TAX_EXEMPT_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
1596 p_TAX_EXEMPT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
1597 p_TAX_EXEMPT_REASON_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1598 p_CONVERSION_RATE IN NUMBER := FND_API.G_MISS_NUM,
1599 p_CONVERSION_TYPE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1600 p_CONVERSION_RATE_DATE IN DATE := FND_API.G_MISS_DATE,
1601 p_PARTIAL_SHIPMENTS_ALLOWED IN VARCHAR2 := FND_API.G_MISS_CHAR,
1602 p_SHIP_TOLERANCE_ABOVE IN NUMBER := FND_API.G_MISS_NUM,
1603 p_SHIP_TOLERANCE_BELOW IN NUMBER := FND_API.G_MISS_NUM,
1604 p_TRANSACTIONAL_CURR_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1605 p_AGREEMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
1606 p_TAX_POINT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1607 p_CUST_PO_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
1608 p_INVOICING_RULE_ID IN NUMBER := FND_API.G_MISS_NUM,
1609 p_ACCOUNTING_RULE_ID IN NUMBER := FND_API.G_MISS_NUM,
1610 p_PAYMENT_TERM_ID IN NUMBER := FND_API.G_MISS_NUM,
1611 p_SHIPPING_METHOD_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1612 p_FREIGHT_CARRIER_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1613 p_FOB_POINT_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1614 p_FREIGHT_TERMS_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1615 p_SOLD_FROM_ORG_ID IN NUMBER := FND_API.G_MISS_NUM,
1616 p_SOLD_TO_ORG_ID IN NUMBER := FND_API.G_MISS_NUM,
1617 p_SHIP_FROM_ORG_ID IN NUMBER := FND_API.G_MISS_NUM,
1618 p_SHIP_TO_ORG_ID IN NUMBER := FND_API.G_MISS_NUM,
1619 p_INVOICE_TO_ORG_ID IN NUMBER := FND_API.G_MISS_NUM,
1620 p_DELIVER_TO_ORG_ID IN NUMBER := FND_API.G_MISS_NUM,
1621 p_SOLD_TO_CONTACT_ID IN NUMBER := FND_API.G_MISS_NUM,
1622 p_SHIP_TO_CONTACT_ID IN NUMBER := FND_API.G_MISS_NUM,
1623 p_INVOICE_TO_CONTACT_ID IN NUMBER := FND_API.G_MISS_NUM,
1624 p_DELIVER_TO_CONTACT_ID IN NUMBER := FND_API.G_MISS_NUM,
1625 p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
1626 p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
1627 p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
1628 p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
1629 p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
1630 p_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
1631 p_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
1632 p_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
1633 p_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
1634 p_CONTEXT IN VARCHAR2 := FND_API.G_MISS_CHAR,
1635 p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1636 p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1637 p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1638 p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1639 p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1640 p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1641 p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1642 p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1643 p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1644 p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1645 p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1646 p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1647 p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1648 p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1649 p_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1650 p_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
1651 p_GLOBAL_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1652 p_GLOBAL_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1653 p_GLOBAL_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1654 p_GLOBAL_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1655 p_GLOBAL_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1656 p_GLOBAL_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1657 p_GLOBAL_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1658 p_GLOBAL_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1659 p_GLOBAL_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1660 p_GLOBAL_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1661 p_GLOBAL_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1662 p_GLOBAL_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1663 p_GLOBAL_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1664 p_GLOBAL_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1665 p_GLOBAL_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1666 p_GLOBAL_ATTRIBUTE16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1667 p_GLOBAL_ATTRIBUTE17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1668 p_GLOBAL_ATTRIBUTE18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1669 p_GLOBAL_ATTRIBUTE19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1670 p_GLOBAL_ATTRIBUTE20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1671 p_CANCELLED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
1672 p_OPEN_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
1673 p_BOOKED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
1674 p_SALESREP_ID IN NUMBER := FND_API.G_MISS_NUM,
1675 p_RETURN_REASON_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1676 p_ORDER_DATE_TYPE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1677 p_EARLIEST_SCHEDULE_LIMIT IN NUMBER := FND_API.G_MISS_NUM,
1678 p_LATEST_SCHEDULE_LIMIT IN NUMBER := FND_API.G_MISS_NUM,
1679 p_PAYMENT_TYPE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1680 p_PAYMENT_AMOUNT IN NUMBER := FND_API.G_MISS_NUM,
1681 p_CHECK_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
1682 p_CREDIT_CARD_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1683 p_CREDIT_CARD_HOLDER_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
1684 p_CREDIT_CARD_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
1685 p_CREDIT_CARD_EXPIR_DATE IN DATE := FND_API.G_MISS_DATE,
1686 p_CREDIT_CARD_APPROVAL_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1687 p_SALES_CHANNEL_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1688 p_FIRST_ACK_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1689 p_FIRST_ACK_DATE IN DATE := FND_API.G_MISS_DATE,
1690 p_LAST_ACK_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1691 p_LAST_ACK_DATE IN DATE := FND_API.G_MISS_DATE,
1692 p_ORDER_CATEGORY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1693 p_CHANGE_SEQUENCE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1694 p_DROP_SHIP_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
1695 p_CUSTOMER_PAYMENT_TERM_ID IN NUMBER := FND_API.G_MISS_NUM,
1696 p_SHIPPING_INSTRUCTIONS IN VARCHAR2 := FND_API.G_MISS_CHAR,
1697 p_PACKING_INSTRUCTIONS IN VARCHAR2 := FND_API.G_MISS_CHAR,
1698 p_TP_CONTEXT IN VARCHAR2 := FND_API.G_MISS_CHAR,
1699 p_TP_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1700 p_TP_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1701 p_TP_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1702 p_TP_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1703 p_TP_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1704 p_TP_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1705 p_TP_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1706 p_TP_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1707 p_TP_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1708 p_TP_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1709 p_TP_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1710 p_TP_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1711 p_TP_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1712 p_TP_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1713 p_TP_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1714 p_FLOW_STATUS_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1715 p_MARKETING_SOURCE_CODE_ID IN NUMBER := FND_API.G_MISS_NUM,
1716 p_CREDIT_CARD_APPROVAL_DATE IN DATE := FND_API.G_MISS_DATE,
1717 p_UPGRADED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
1718 p_CUSTOMER_PREF_SET_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1719 p_BOOKED_DATE IN DATE := FND_API.G_MISS_DATE,
1720 p_LOCK_CONTROL IN NUMBER := FND_API.G_MISS_NUM,
1721 p_PRICE_REQUEST_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1722 p_XML_MESSAGE_ID IN NUMBER := FND_API.G_MISS_NUM,
1723 p_ACCOUNTING_RULE_DURATION IN NUMBER := FND_API.G_MISS_NUM,
1724
1725 p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1726 p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1727 p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1728 p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1729 p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1730 p_bill_to_edi_location_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1731
1732 p_Blanket_Number IN NUMBER := FND_API.G_MISS_NUM,
1733 p_change_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
1734 p_change_reason IN VARCHAR2 := FND_API.G_MISS_CHAR,
1735 p_change_request_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1736 p_db_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1737 p_Default_Fulfillment_set IN VARCHAR2 := FND_API.G_MISS_CHAR,
1738
1739 p_deliver_to_customer_id IN NUMBER := FND_API.G_MISS_NUM,
1740 p_force_apply_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1741 p_Fulfillment_Set_Name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1742 p_INVOICE_ADDRESS_ID IN NUMBER := FND_API.G_MISS_NUM,
1743 p_invoice_to_customer_id IN NUMBER := FND_API.G_MISS_NUM,
1744 p_SHIP_FROM_ADDRESS_ID IN NUMBER := FND_API.G_MISS_NUM,
1745 p_ship_from_edi_loc_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1746
1747 p_Line_Set_Name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1748 p_ready_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1749 p_SHIP_TO_ADDRESS_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
1750 p_SHIP_TO_ADDRESS_ID IN NUMBER := FND_API.G_MISS_NUM,
1751 p_ship_to_customer_id IN NUMBER := FND_API.G_MISS_NUM,
1752 p_ship_to_edi_location_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1753
1754 p_SOLD_TO_ADDRESS_ID IN NUMBER := FND_API.G_MISS_NUM,
1755 p_sold_to_edi_location_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1756 p_sold_to_phone_id IN NUMBER := FND_API.G_MISS_NUM,
1757 p_status_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1758 p_xml_transaction_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
1759
1760 )
1761
1762 RETURN OE_Order_PUB.Header_Rec_Type
1763 IS
1764 l_order_header_rec OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC;
1765 BEGIN
1766
1767 IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1768 IBE_Util.Debug('In Returns construct HeaderRecord package body - Begin');
1769 END IF;
1770
1771 IF p_HEADER_ID = ROSETTA_G_MISS_NUM THEN
1772 l_order_header_rec.HEADER_ID := FND_API.G_MISS_NUM;
1773 ELSE
1774 l_order_header_rec.HEADER_ID := p_HEADER_ID;
1775 END IF;
1776
1777 l_order_header_rec.OPERATION := p_OPERATION;
1778
1779 IF p_ORG_ID = ROSETTA_G_MISS_NUM THEN
1780 l_order_header_rec.ORG_ID := FND_API.G_MISS_NUM;
1781 ELSE
1782 l_order_header_rec.ORG_ID := p_ORG_ID;
1783 END IF;
1784 IF p_ORDER_TYPE_ID = ROSETTA_G_MISS_NUM THEN
1785 l_order_header_rec.ORDER_TYPE_ID := FND_API.G_MISS_NUM;
1786 ELSE
1787 l_order_header_rec.ORDER_TYPE_ID := p_ORDER_TYPE_ID;
1788 END IF;
1789 IF p_ORDER_NUMBER = ROSETTA_G_MISS_NUM THEN
1790 l_order_header_rec.ORDER_NUMBER := FND_API.G_MISS_NUM;
1791 ELSE
1792 l_order_header_rec.ORDER_NUMBER := p_ORDER_NUMBER;
1793 END IF;
1794 IF p_VERSION_NUMBER = ROSETTA_G_MISS_NUM THEN
1795 l_order_header_rec.VERSION_NUMBER := FND_API.G_MISS_NUM;
1796 ELSE
1797 l_order_header_rec.VERSION_NUMBER := p_VERSION_NUMBER;
1798 END IF;
1799 IF p_EXPIRATION_DATE = ROSETTA_G_MISS_DATE THEN
1800 l_order_header_rec.EXPIRATION_DATE := FND_API.G_MISS_DATE;
1801 ELSE
1802 l_order_header_rec.EXPIRATION_DATE := p_EXPIRATION_DATE;
1803 END IF;
1804 IF p_ORDER_SOURCE_ID = ROSETTA_G_MISS_NUM THEN
1805 l_order_header_rec.ORDER_SOURCE_ID := FND_API.G_MISS_NUM;
1806 ELSE
1807 l_order_header_rec.ORDER_SOURCE_ID := p_ORDER_SOURCE_ID;
1808 END IF;
1809 IF p_SOURCE_DOCUMENT_TYPE_ID = ROSETTA_G_MISS_NUM THEN
1810 l_order_header_rec.SOURCE_DOCUMENT_TYPE_ID := FND_API.G_MISS_NUM;
1811 ELSE
1812 l_order_header_rec.SOURCE_DOCUMENT_TYPE_ID := p_SOURCE_DOCUMENT_TYPE_ID;
1813 END IF;
1814
1815 l_order_header_rec.ORIG_SYS_DOCUMENT_REF := p_ORIG_SYS_DOCUMENT_REF;
1816
1817 IF p_SOURCE_DOCUMENT_ID = ROSETTA_G_MISS_NUM THEN
1818 l_order_header_rec.SOURCE_DOCUMENT_ID := FND_API.G_MISS_NUM;
1819 ELSE
1820 l_order_header_rec.SOURCE_DOCUMENT_ID := p_SOURCE_DOCUMENT_ID;
1821 END IF;
1822 IF p_ORDERED_DATE = ROSETTA_G_MISS_DATE THEN
1823 l_order_header_rec.ORDERED_DATE := FND_API.G_MISS_DATE;
1824 ELSE
1825 l_order_header_rec.ORDERED_DATE := p_ORDERED_DATE;
1826 END IF;
1827 IF p_REQUEST_DATE = ROSETTA_G_MISS_DATE THEN
1828 l_order_header_rec.REQUEST_DATE := FND_API.G_MISS_DATE;
1829 ELSE
1830 l_order_header_rec.REQUEST_DATE := p_REQUEST_DATE;
1831 END IF;
1832 IF p_PRICING_DATE = ROSETTA_G_MISS_DATE THEN
1833 l_order_header_rec.PRICING_DATE := FND_API.G_MISS_DATE;
1834 ELSE
1835 l_order_header_rec.PRICING_DATE := p_PRICING_DATE;
1836 END IF;
1837 l_order_header_rec.SHIPMENT_PRIORITY_CODE := p_SHIPMENT_PRIORITY_CODE;
1838 l_order_header_rec.DEMAND_CLASS_CODE := p_DEMAND_CLASS_CODE;
1839 IF p_PRICE_LIST_ID = ROSETTA_G_MISS_NUM THEN
1840 l_order_header_rec.PRICE_LIST_ID := FND_API.G_MISS_NUM;
1841 ELSE
1842 l_order_header_rec.PRICE_LIST_ID := p_PRICE_LIST_ID;
1843 END IF;
1844 IF p_MINISITE_ID = ROSETTA_G_MISS_NUM THEN -- bug 8337371, scnagara
1845 l_order_header_rec.Minisite_Id := FND_API.G_MISS_NUM;
1846 ELSE
1847 l_order_header_rec.Minisite_Id := p_MINISITE_ID;
1848 END IF;
1849 l_order_header_rec.TAX_EXEMPT_FLAG := p_TAX_EXEMPT_FLAG;
1850 l_order_header_rec.TAX_EXEMPT_NUMBER := p_TAX_EXEMPT_NUMBER;
1851 l_order_header_rec.TAX_EXEMPT_REASON_CODE := p_TAX_EXEMPT_REASON_CODE;
1852 IF p_CONVERSION_RATE = ROSETTA_G_MISS_NUM THEN
1853 l_order_header_rec.CONVERSION_RATE := FND_API.G_MISS_NUM;
1854 ELSE
1855 l_order_header_rec.CONVERSION_RATE := p_CONVERSION_RATE;
1856 END IF;
1857 l_order_header_rec.CONVERSION_TYPE_CODE := p_CONVERSION_TYPE_CODE;
1858 IF p_CONVERSION_RATE_DATE = ROSETTA_G_MISS_DATE THEN
1859 l_order_header_rec.CONVERSION_RATE_DATE := FND_API.G_MISS_DATE;
1860 ELSE
1861 l_order_header_rec.CONVERSION_RATE_DATE := p_CONVERSION_RATE_DATE;
1862 END IF;
1863 l_order_header_rec.PARTIAL_SHIPMENTS_ALLOWED := p_PARTIAL_SHIPMENTS_ALLOWED;
1864 IF p_SHIP_TOLERANCE_ABOVE = ROSETTA_G_MISS_NUM THEN
1865 l_order_header_rec.SHIP_TOLERANCE_ABOVE := FND_API.G_MISS_NUM;
1866 ELSE
1867 l_order_header_rec.SHIP_TOLERANCE_ABOVE := p_SHIP_TOLERANCE_ABOVE;
1868 END IF;
1869 IF p_SHIP_TOLERANCE_BELOW = ROSETTA_G_MISS_NUM THEN
1870 l_order_header_rec.SHIP_TOLERANCE_BELOW := FND_API.G_MISS_NUM;
1871 ELSE
1872 l_order_header_rec.SHIP_TOLERANCE_BELOW := p_SHIP_TOLERANCE_BELOW;
1873 END IF;
1874 l_order_header_rec.TRANSACTIONAL_CURR_CODE := p_TRANSACTIONAL_CURR_CODE;
1875 IF p_AGREEMENT_ID = ROSETTA_G_MISS_NUM THEN
1876 l_order_header_rec.AGREEMENT_ID := FND_API.G_MISS_NUM;
1877 ELSE
1878 l_order_header_rec.AGREEMENT_ID := p_AGREEMENT_ID;
1879 END IF;
1880 l_order_header_rec.TAX_POINT_CODE := p_TAX_POINT_CODE;
1881 l_order_header_rec.CUST_PO_NUMBER := p_CUST_PO_NUMBER;
1882 IF p_INVOICING_RULE_ID = ROSETTA_G_MISS_NUM THEN
1883 l_order_header_rec.INVOICING_RULE_ID := FND_API.G_MISS_NUM;
1884 ELSE
1885 l_order_header_rec.INVOICING_RULE_ID := p_INVOICING_RULE_ID;
1886 END IF;
1887 IF p_ACCOUNTING_RULE_ID = ROSETTA_G_MISS_NUM THEN
1888 l_order_header_rec.ACCOUNTING_RULE_ID := FND_API.G_MISS_NUM;
1889 ELSE
1890 l_order_header_rec.ACCOUNTING_RULE_ID := p_ACCOUNTING_RULE_ID;
1891 END IF;
1892 IF p_PAYMENT_TERM_ID = ROSETTA_G_MISS_NUM THEN
1893 l_order_header_rec.PAYMENT_TERM_ID := FND_API.G_MISS_NUM;
1894 ELSE
1895 l_order_header_rec.PAYMENT_TERM_ID := p_PAYMENT_TERM_ID;
1896 END IF;
1897 l_order_header_rec.SHIPPING_METHOD_CODE := p_SHIPPING_METHOD_CODE;
1898 l_order_header_rec.FREIGHT_CARRIER_CODE := p_FREIGHT_CARRIER_CODE;
1899 l_order_header_rec.FOB_POINT_CODE := p_FOB_POINT_CODE;
1900 l_order_header_rec.FREIGHT_TERMS_CODE := p_FREIGHT_TERMS_CODE;
1901 IF p_SOLD_FROM_ORG_ID = ROSETTA_G_MISS_NUM THEN
1902 l_order_header_rec.SOLD_FROM_ORG_ID := FND_API.G_MISS_NUM;
1903 ELSE
1904 l_order_header_rec.SOLD_FROM_ORG_ID := p_SOLD_FROM_ORG_ID;
1905 END IF;
1906 IF p_SOLD_TO_ORG_ID = ROSETTA_G_MISS_NUM THEN
1907 l_order_header_rec.SOLD_TO_ORG_ID := FND_API.G_MISS_NUM;
1908 ELSE
1909 l_order_header_rec.SOLD_TO_ORG_ID := p_SOLD_TO_ORG_ID;
1910 END IF;
1911 IF p_SHIP_FROM_ORG_ID = ROSETTA_G_MISS_NUM THEN
1912 l_order_header_rec.SHIP_FROM_ORG_ID := FND_API.G_MISS_NUM;
1913 ELSE
1914 l_order_header_rec.SHIP_FROM_ORG_ID := p_SHIP_FROM_ORG_ID;
1915 END IF;
1916 IF p_SHIP_TO_ORG_ID = ROSETTA_G_MISS_NUM THEN
1917 l_order_header_rec.SHIP_TO_ORG_ID := FND_API.G_MISS_NUM;
1918 ELSE
1919 l_order_header_rec.SHIP_TO_ORG_ID := p_SHIP_TO_ORG_ID;
1920 END IF;
1921 IF p_INVOICE_TO_ORG_ID = ROSETTA_G_MISS_NUM THEN
1922 l_order_header_rec.INVOICE_TO_ORG_ID := FND_API.G_MISS_NUM;
1923 ELSE
1924 l_order_header_rec.INVOICE_TO_ORG_ID := p_INVOICE_TO_ORG_ID;
1925 END IF;
1926 IF p_DELIVER_TO_ORG_ID = ROSETTA_G_MISS_NUM THEN
1927 l_order_header_rec.DELIVER_TO_ORG_ID := FND_API.G_MISS_NUM;
1928 ELSE
1929 l_order_header_rec.DELIVER_TO_ORG_ID := p_DELIVER_TO_ORG_ID;
1930 END IF;
1931 IF p_SOLD_TO_CONTACT_ID = ROSETTA_G_MISS_NUM THEN
1932 l_order_header_rec.SOLD_TO_CONTACT_ID := FND_API.G_MISS_NUM;
1933 ELSE
1934 l_order_header_rec.SOLD_TO_CONTACT_ID := p_SOLD_TO_CONTACT_ID;
1935 END IF;
1936 IF p_SHIP_TO_CONTACT_ID = ROSETTA_G_MISS_NUM THEN
1937 l_order_header_rec.SHIP_TO_CONTACT_ID := FND_API.G_MISS_NUM;
1938 ELSE
1939 l_order_header_rec.SHIP_TO_CONTACT_ID := p_SHIP_TO_CONTACT_ID;
1940 END IF;
1941 IF p_INVOICE_TO_CONTACT_ID = ROSETTA_G_MISS_NUM THEN
1942 l_order_header_rec.INVOICE_TO_CONTACT_ID := FND_API.G_MISS_NUM;
1943 ELSE
1944 l_order_header_rec.INVOICE_TO_CONTACT_ID := p_INVOICE_TO_CONTACT_ID;
1945 END IF;
1946 IF p_DELIVER_TO_CONTACT_ID = ROSETTA_G_MISS_NUM THEN
1947 l_order_header_rec.DELIVER_TO_CONTACT_ID := FND_API.G_MISS_NUM;
1948 ELSE
1949 l_order_header_rec.DELIVER_TO_CONTACT_ID := p_DELIVER_TO_CONTACT_ID;
1950 END IF;
1951 IF p_CREATION_DATE = ROSETTA_G_MISS_DATE THEN
1952 l_order_header_rec.CREATION_DATE := FND_API.G_MISS_DATE;
1953 ELSE
1954 l_order_header_rec.CREATION_DATE := p_CREATION_DATE;
1955 END IF;
1956 IF p_CREATED_BY = ROSETTA_G_MISS_NUM THEN
1957 l_order_header_rec.CREATED_BY := FND_API.G_MISS_NUM;
1958 ELSE
1959 l_order_header_rec.CREATED_BY := p_CREATED_BY;
1960 END IF;
1961 IF p_LAST_UPDATED_BY = ROSETTA_G_MISS_NUM THEN
1962 l_order_header_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
1963 ELSE
1964 l_order_header_rec.LAST_UPDATED_BY := p_LAST_UPDATED_BY;
1965 END IF;
1966 IF p_LAST_UPDATE_DATE = ROSETTA_G_MISS_DATE THEN
1967 l_order_header_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
1968 ELSE
1969 l_order_header_rec.LAST_UPDATE_DATE := p_LAST_UPDATE_DATE;
1970 END IF;
1971 IF p_LAST_UPDATE_LOGIN = ROSETTA_G_MISS_NUM THEN
1972 l_order_header_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
1973 ELSE
1974 l_order_header_rec.LAST_UPDATE_LOGIN := p_LAST_UPDATE_LOGIN;
1975 END IF;
1976 IF p_PROGRAM_APPLICATION_ID = ROSETTA_G_MISS_NUM THEN
1977 l_order_header_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
1978 ELSE
1979 l_order_header_rec.PROGRAM_APPLICATION_ID := p_PROGRAM_APPLICATION_ID;
1980 END IF;
1981 IF p_PROGRAM_ID = ROSETTA_G_MISS_NUM THEN
1982 l_order_header_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
1983 ELSE
1984 l_order_header_rec.PROGRAM_ID := p_PROGRAM_ID;
1985 END IF;
1986 IF p_PROGRAM_UPDATE_DATE = ROSETTA_G_MISS_DATE THEN
1987 l_order_header_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
1988 ELSE
1989 l_order_header_rec.PROGRAM_UPDATE_DATE := p_PROGRAM_UPDATE_DATE;
1990 END IF;
1991 IF p_REQUEST_ID = ROSETTA_G_MISS_NUM THEN
1992 l_order_header_rec.REQUEST_ID := FND_API.G_MISS_NUM;
1993 ELSE
1994 l_order_header_rec.REQUEST_ID := p_REQUEST_ID;
1995 END IF;
1996 l_order_header_rec.CONTEXT := p_CONTEXT;
1997 l_order_header_rec.ATTRIBUTE1 := p_ATTRIBUTE1;
1998 l_order_header_rec.ATTRIBUTE2 := p_ATTRIBUTE2;
1999 l_order_header_rec.ATTRIBUTE3 := p_ATTRIBUTE3;
2000 l_order_header_rec.ATTRIBUTE4 := p_ATTRIBUTE4;
2001 l_order_header_rec.ATTRIBUTE5 := p_ATTRIBUTE5;
2002 l_order_header_rec.ATTRIBUTE6 := p_ATTRIBUTE6;
2003 l_order_header_rec.ATTRIBUTE7 := p_ATTRIBUTE7;
2004 l_order_header_rec.ATTRIBUTE8 := p_ATTRIBUTE8;
2005 l_order_header_rec.ATTRIBUTE9 := p_ATTRIBUTE9;
2006 l_order_header_rec.ATTRIBUTE10 := p_ATTRIBUTE10;
2007 l_order_header_rec.ATTRIBUTE11 := p_ATTRIBUTE11;
2008 l_order_header_rec.ATTRIBUTE12 := p_ATTRIBUTE12;
2009 l_order_header_rec.ATTRIBUTE13 := p_ATTRIBUTE13;
2010 l_order_header_rec.ATTRIBUTE14 := p_ATTRIBUTE14;
2011 l_order_header_rec.ATTRIBUTE15 := p_ATTRIBUTE15;
2012 l_order_header_rec.GLOBAL_ATTRIBUTE_CATEGORY := p_GLOBAL_ATTRIBUTE_CATEGORY;
2013 l_order_header_rec.GLOBAL_ATTRIBUTE1 := p_GLOBAL_ATTRIBUTE1;
2014 l_order_header_rec.GLOBAL_ATTRIBUTE2 := p_GLOBAL_ATTRIBUTE2;
2015 l_order_header_rec.GLOBAL_ATTRIBUTE3 := p_GLOBAL_ATTRIBUTE3;
2016 l_order_header_rec.GLOBAL_ATTRIBUTE4 := p_GLOBAL_ATTRIBUTE4;
2017 l_order_header_rec.GLOBAL_ATTRIBUTE5 := p_GLOBAL_ATTRIBUTE5;
2018 l_order_header_rec.GLOBAL_ATTRIBUTE6 := p_GLOBAL_ATTRIBUTE6;
2019 l_order_header_rec.GLOBAL_ATTRIBUTE7 := p_GLOBAL_ATTRIBUTE7;
2020 l_order_header_rec.GLOBAL_ATTRIBUTE8 := p_GLOBAL_ATTRIBUTE8;
2021 l_order_header_rec.GLOBAL_ATTRIBUTE9 := p_GLOBAL_ATTRIBUTE9;
2022 l_order_header_rec.GLOBAL_ATTRIBUTE10 := p_GLOBAL_ATTRIBUTE10;
2023 l_order_header_rec.GLOBAL_ATTRIBUTE11 := p_GLOBAL_ATTRIBUTE11;
2024 l_order_header_rec.GLOBAL_ATTRIBUTE12 := p_GLOBAL_ATTRIBUTE12;
2025 l_order_header_rec.GLOBAL_ATTRIBUTE13 := p_GLOBAL_ATTRIBUTE13;
2026 l_order_header_rec.GLOBAL_ATTRIBUTE14 := p_GLOBAL_ATTRIBUTE14;
2027 l_order_header_rec.GLOBAL_ATTRIBUTE15 := p_GLOBAL_ATTRIBUTE15;
2028 l_order_header_rec.GLOBAL_ATTRIBUTE16 := p_GLOBAL_ATTRIBUTE16;
2029 l_order_header_rec.GLOBAL_ATTRIBUTE17 := p_GLOBAL_ATTRIBUTE17;
2030 l_order_header_rec.GLOBAL_ATTRIBUTE18 := p_GLOBAL_ATTRIBUTE18;
2031 l_order_header_rec.GLOBAL_ATTRIBUTE19 := p_GLOBAL_ATTRIBUTE19;
2032 l_order_header_rec.GLOBAL_ATTRIBUTE20 := p_GLOBAL_ATTRIBUTE20;
2033 l_order_header_rec.CANCELLED_FLAG := p_CANCELLED_FLAG;
2034 l_order_header_rec.OPEN_FLAG := p_OPEN_FLAG;
2035 l_order_header_rec.BOOKED_FLAG := p_BOOKED_FLAG;
2036 IF p_SALESREP_ID = ROSETTA_G_MISS_NUM THEN
2037 l_order_header_rec.SALESREP_ID := FND_API.G_MISS_NUM;
2038 ELSE
2039 l_order_header_rec.SALESREP_ID := p_SALESREP_ID;
2040 END IF;
2041 l_order_header_rec.RETURN_REASON_CODE := p_RETURN_REASON_CODE;
2042 l_order_header_rec.ORDER_DATE_TYPE_CODE := p_ORDER_DATE_TYPE_CODE;
2043 IF p_EARLIEST_SCHEDULE_LIMIT = ROSETTA_G_MISS_NUM THEN
2044 l_order_header_rec.EARLIEST_SCHEDULE_LIMIT := FND_API.G_MISS_NUM;
2045 ELSE
2046 l_order_header_rec.EARLIEST_SCHEDULE_LIMIT := p_EARLIEST_SCHEDULE_LIMIT;
2047 END IF;
2048 IF p_LATEST_SCHEDULE_LIMIT = ROSETTA_G_MISS_NUM THEN
2049 l_order_header_rec.LATEST_SCHEDULE_LIMIT := FND_API.G_MISS_NUM;
2050 ELSE
2051 l_order_header_rec.LATEST_SCHEDULE_LIMIT := p_LATEST_SCHEDULE_LIMIT;
2052 END IF;
2053 l_order_header_rec.PAYMENT_TYPE_CODE := p_PAYMENT_TYPE_CODE;
2054 IF p_PAYMENT_AMOUNT = ROSETTA_G_MISS_NUM THEN
2055 l_order_header_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
2056 ELSE
2057 l_order_header_rec.PAYMENT_AMOUNT := p_PAYMENT_AMOUNT;
2058 END IF;
2059 l_order_header_rec.CHECK_NUMBER := p_CHECK_NUMBER;
2060 l_order_header_rec.CREDIT_CARD_CODE := p_CREDIT_CARD_CODE;
2061 l_order_header_rec.CREDIT_CARD_HOLDER_NAME := p_CREDIT_CARD_HOLDER_NAME;
2062 l_order_header_rec.CREDIT_CARD_NUMBER := p_CREDIT_CARD_NUMBER;
2063
2064 IF p_CREDIT_CARD_EXPIR_DATE = ROSETTA_G_MISS_DATE THEN
2065 l_order_header_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
2066 ELSE
2067 l_order_header_rec.CREDIT_CARD_EXPIRATION_DATE := p_CREDIT_CARD_EXPIR_DATE;
2068 END IF;
2069 l_order_header_rec.CREDIT_CARD_APPROVAL_CODE := p_CREDIT_CARD_APPROVAL_CODE;
2070 l_order_header_rec.SALES_CHANNEL_CODE := p_SALES_CHANNEL_CODE;
2071 l_order_header_rec.FIRST_ACK_CODE := p_FIRST_ACK_CODE;
2072 IF p_FIRST_ACK_DATE = ROSETTA_G_MISS_DATE THEN
2073 l_order_header_rec.FIRST_ACK_DATE := FND_API.G_MISS_DATE;
2074 ELSE
2075 l_order_header_rec.FIRST_ACK_DATE := p_FIRST_ACK_DATE;
2076 END IF;
2077
2078 l_order_header_rec.LAST_ACK_CODE := p_LAST_ACK_CODE;
2079 IF p_LAST_ACK_DATE = ROSETTA_G_MISS_DATE THEN
2080 l_order_header_rec.LAST_ACK_DATE := FND_API.G_MISS_DATE;
2081 ELSE
2082 l_order_header_rec.LAST_ACK_DATE := p_LAST_ACK_DATE;
2083 END IF;
2084 l_order_header_rec.ORDER_CATEGORY_CODE := p_ORDER_CATEGORY_CODE;
2085 l_order_header_rec.CHANGE_SEQUENCE := p_CHANGE_SEQUENCE;
2086 l_order_header_rec.DROP_SHIP_FLAG := p_DROP_SHIP_FLAG;
2087
2088 IF p_CUSTOMER_PAYMENT_TERM_ID = ROSETTA_G_MISS_NUM THEN
2089 l_order_header_rec.CUSTOMER_PAYMENT_TERM_ID := FND_API.G_MISS_NUM;
2090 ELSE
2091 l_order_header_rec.CUSTOMER_PAYMENT_TERM_ID := p_CUSTOMER_PAYMENT_TERM_ID;
2092 END IF;
2093 l_order_header_rec.SHIPPING_INSTRUCTIONS := p_SHIPPING_INSTRUCTIONS;
2094 l_order_header_rec.PACKING_INSTRUCTIONS := p_PACKING_INSTRUCTIONS;
2095 l_order_header_rec.TP_CONTEXT := p_TP_CONTEXT;
2096 l_order_header_rec.TP_ATTRIBUTE1 := p_TP_ATTRIBUTE1;
2097 l_order_header_rec.TP_ATTRIBUTE2 := p_TP_ATTRIBUTE2;
2098 l_order_header_rec.TP_ATTRIBUTE3 := p_TP_ATTRIBUTE3;
2099 l_order_header_rec.TP_ATTRIBUTE4 := p_TP_ATTRIBUTE4;
2100 l_order_header_rec.TP_ATTRIBUTE5 := p_TP_ATTRIBUTE5;
2101 l_order_header_rec.TP_ATTRIBUTE6 := p_TP_ATTRIBUTE6;
2102 l_order_header_rec.TP_ATTRIBUTE7 := p_TP_ATTRIBUTE7;
2103 l_order_header_rec.TP_ATTRIBUTE8 := p_TP_ATTRIBUTE8;
2104 l_order_header_rec.TP_ATTRIBUTE9 := p_TP_ATTRIBUTE9;
2105 l_order_header_rec.TP_ATTRIBUTE10 := p_TP_ATTRIBUTE10;
2106 l_order_header_rec.TP_ATTRIBUTE11 := p_TP_ATTRIBUTE11;
2107 l_order_header_rec.TP_ATTRIBUTE12 := p_TP_ATTRIBUTE12;
2108 l_order_header_rec.TP_ATTRIBUTE13 := p_TP_ATTRIBUTE13;
2109 l_order_header_rec.TP_ATTRIBUTE14 := p_TP_ATTRIBUTE14;
2110 l_order_header_rec.TP_ATTRIBUTE15 := p_TP_ATTRIBUTE15;
2111
2112 -- The If condition is checked. because flow_status_code is defaulted to 'entered' in g_miss_header_rec so to avoid overriding.
2113 IF (p_FLOW_STATUS_CODE IS NOT NULL AND p_FLOW_STATUS_CODE <> FND_API.G_MISS_CHAR) THEN
2114 l_order_header_rec.FLOW_STATUS_CODE := p_FLOW_STATUS_CODE;
2115 END IF;
2116
2117 IF p_MARKETING_SOURCE_CODE_ID = ROSETTA_G_MISS_NUM THEN
2118 l_order_header_rec.MARKETING_SOURCE_CODE_ID := FND_API.G_MISS_NUM;
2119 ELSE
2120 l_order_header_rec.MARKETING_SOURCE_CODE_ID := p_MARKETING_SOURCE_CODE_ID;
2121 END IF;
2122
2123
2124 IF p_CREDIT_CARD_APPROVAL_DATE = ROSETTA_G_MISS_DATE THEN
2125 l_order_header_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
2126 ELSE
2127 l_order_header_rec.CREDIT_CARD_APPROVAL_DATE := p_CREDIT_CARD_APPROVAL_DATE;
2128 END IF;
2129 l_order_header_rec.UPGRADED_FLAG := p_UPGRADED_FLAG;
2130 l_order_header_rec.CUSTOMER_PREFERENCE_SET_CODE := p_CUSTOMER_PREF_SET_CODE;
2131
2132 IF p_BOOKED_DATE = ROSETTA_G_MISS_DATE THEN
2133 l_order_header_rec.BOOKED_DATE := FND_API.G_MISS_DATE;
2134 ELSE
2135 l_order_header_rec.BOOKED_DATE := p_BOOKED_DATE;
2136 END IF;
2137
2138 IF p_LOCK_CONTROL = ROSETTA_G_MISS_NUM THEN
2139 l_order_header_rec.LOCK_CONTROL := FND_API.G_MISS_NUM;
2140 ELSE
2141 l_order_header_rec.LOCK_CONTROL := p_LOCK_CONTROL;
2142 END IF;
2143 l_order_header_rec.PRICE_REQUEST_CODE := p_PRICE_REQUEST_CODE;
2144
2145 IF p_XML_MESSAGE_ID = ROSETTA_G_MISS_NUM THEN
2146 l_order_header_rec.XML_MESSAGE_ID := FND_API.G_MISS_NUM;
2147 ELSE
2148 l_order_header_rec.XML_MESSAGE_ID := p_XML_MESSAGE_ID;
2149 END IF;
2150
2151 IF p_ACCOUNTING_RULE_DURATION = ROSETTA_G_MISS_NUM THEN
2152 l_order_header_rec.ACCOUNTING_RULE_DURATION := FND_API.G_MISS_NUM;
2153 ELSE
2154 l_order_header_rec.ACCOUNTING_RULE_DURATION := p_ACCOUNTING_RULE_DURATION ;
2155 END IF;
2156
2157 /* l_order_header_rec.attribute16 := p_attribute16;
2158 l_order_header_rec.attribute17 := p_attribute17;
2159 l_order_header_rec.attribute18 := p_attribute18;
2160 l_order_header_rec.attribute19 := p_attribute19;
2161 l_order_header_rec.attribute20 := p_attribute20;*/
2162 l_order_header_rec.bill_to_edi_location_code := p_bill_to_edi_location_code;
2163
2164 /* IF p_Blanket_Number = ROSETTA_G_MISS_NUM THEN
2165 l_order_header_rec.Blanket_Number := FND_API.G_MISS_NUM;
2166 ELSE
2167 l_order_header_rec.Blanket_Number := p_Blanket_Number;
2168 END IF; */
2169
2170 l_order_header_rec.change_comments := p_change_comments;
2171 l_order_header_rec.change_reason := p_change_reason;
2172 l_order_header_rec.change_request_code := p_change_request_code;
2173 l_order_header_rec.db_flag := p_db_flag;
2174 --l_order_header_rec.Default_Fulfillment_Set := p_Default_Fulfillment_Set;
2175
2176 IF p_deliver_to_customer_id = ROSETTA_G_MISS_NUM THEN
2177 l_order_header_rec.deliver_to_customer_id := FND_API.G_MISS_NUM;
2178 ELSE
2179 l_order_header_rec.deliver_to_customer_id := p_deliver_to_customer_id;
2180 END IF;
2181
2182 l_order_header_rec.force_apply_flag := p_force_apply_flag;
2183 --l_order_header_rec.Fulfillment_Set_Name := p_Fulfillment_Set_Name;
2184
2185 IF p_INVOICE_ADDRESS_ID = ROSETTA_G_MISS_NUM THEN
2186 l_order_header_rec.INVOICE_ADDRESS_ID := FND_API.G_MISS_NUM;
2187 ELSE
2188 l_order_header_rec.INVOICE_ADDRESS_ID := p_INVOICE_ADDRESS_ID;
2189 END IF;
2190
2191 IF p_invoice_to_customer_id = ROSETTA_G_MISS_NUM THEN
2192 l_order_header_rec.invoice_to_customer_id := FND_API.G_MISS_NUM;
2193 ELSE
2194 l_order_header_rec.invoice_to_customer_id := p_invoice_to_customer_id;
2195 END IF;
2196
2197 IF p_SHIP_FROM_ADDRESS_ID = ROSETTA_G_MISS_NUM THEN
2198 l_order_header_rec.SHIP_FROM_ADDRESS_ID := FND_API.G_MISS_NUM;
2199 ELSE
2200 l_order_header_rec.SHIP_FROM_ADDRESS_ID := p_SHIP_FROM_ADDRESS_ID;
2201 END IF;
2202
2203 l_order_header_rec.ship_from_edi_location_code := p_ship_from_edi_loc_code;
2204 --l_order_header_rec.Line_Set_Name := p_Line_Set_Name;
2205 l_order_header_rec.ready_flag := p_ready_flag;
2206 l_order_header_rec.SHIP_TO_ADDRESS_CODE := p_SHIP_TO_ADDRESS_CODE;
2207
2208 IF p_SHIP_TO_ADDRESS_ID = ROSETTA_G_MISS_NUM THEN
2209 l_order_header_rec.SHIP_TO_ADDRESS_ID := FND_API.G_MISS_NUM;
2210 ELSE
2211 l_order_header_rec.SHIP_TO_ADDRESS_ID := p_SHIP_TO_ADDRESS_ID;
2212 END IF;
2213
2214 IF p_ship_to_customer_id = ROSETTA_G_MISS_NUM THEN
2215 l_order_header_rec.ship_to_customer_id := FND_API.G_MISS_NUM;
2216 ELSE
2217 l_order_header_rec.ship_to_customer_id := p_ship_to_customer_id;
2218 END IF;
2219
2220 l_order_header_rec.ship_to_edi_location_code := p_ship_to_edi_location_code;
2221
2222 IF P_SOLD_TO_ADDRESS_ID = ROSETTA_G_MISS_NUM THEN
2223 l_order_header_rec.SOLD_TO_ADDRESS_ID := FND_API.G_MISS_NUM;
2224 ELSE
2225 l_order_header_rec.SOLD_TO_ADDRESS_ID := p_SOLD_TO_ADDRESS_ID;
2226 END IF;
2227
2228 l_order_header_rec.sold_to_edi_location_code := p_sold_to_edi_location_code;
2229
2230 /* IF p_sold_to_phone_id = ROSETTA_G_MISS_NUM THEN
2231 l_order_header_rec.sold_to_phone_id := FND_API.G_MISS_NUM;
2232 ELSE
2233 l_order_header_rec.sold_to_phone_id := p_sold_to_phone_id;
2234 END IF;*/
2235
2236 l_order_header_rec.status_flag := p_status_flag;
2237 --l_order_header_rec.xml_transaction_type_code := p_xml_transaction_type_code;
2238
2239 IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2240 IBE_Util.Debug('In Returns construct HeaderRecord package body - end');
2241 END IF;
2242
2243 RETURN l_order_header_rec;
2244
2245 END Construct_Hdr_Tbl;
2246
2247
2248 PROCEDURE SaveWrapper(
2249 x_error_lineids OUT NOCOPY JTF_VARCHAR2_TABLE_300 ,
2250 X_failed_line_ids OUT NOCOPY JTF_VARCHAR2_TABLE_300 , --3272918
2251 p_api_version_number IN NUMBER ,
2252 p_init_msg_list IN VARCHAR2 ,
2253 p_commit IN VARCHAR2 ,
2254 x_return_status OUT NOCOPY VARCHAR2 ,
2255 x_msg_count OUT NOCOPY NUMBER ,
2256 x_msg_data OUT NOCOPY VARCHAR2 ,
2257 x_order_header_id OUT NOCOPY NUMBER ,
2258 x_order_number OUT NOCOPY NUMBER ,
2259 x_flow_status_code OUT NOCOPY VARCHAR2 ,
2260 x_last_update_date OUT NOCOPY DATE ,
2261 p_h_HEADER_ID IN NUMBER ,
2262 p_h_OPERATION IN VARCHAR2 ,
2263 p_h_ORG_ID IN NUMBER ,
2264 p_h_ORDER_TYPE_ID IN NUMBER ,
2265 p_h_ORDER_NUMBER IN NUMBER ,
2266 p_h_VERSION_NUMBER IN NUMBER ,
2267 p_h_EXPIRATION_DATE IN DATE ,
2268 p_h_ORDER_SOURCE_ID IN NUMBER ,
2269 p_h_SOURCE_DOCUMENT_TYPE_ID IN NUMBER ,
2270 p_h_ORIG_SYS_DOCUMENT_REF IN VARCHAR2 ,
2271 p_h_SOURCE_DOCUMENT_ID IN NUMBER ,
2272 p_h_ORDERED_DATE IN DATE ,
2273 p_h_REQUEST_DATE IN DATE ,
2274 p_h_PRICING_DATE IN DATE ,
2275 p_h_SHIPMENT_PRIORITY_CODE IN VARCHAR2 ,
2276 p_h_DEMAND_CLASS_CODE IN VARCHAR2 ,
2277 p_h_PRICE_LIST_ID IN NUMBER ,
2278 p_h_MINISITE_ID IN NUMBER , -- bug 8337371, scnagara
2279 p_h_TAX_EXEMPT_FLAG IN VARCHAR2 ,
2280 p_h_TAX_EXEMPT_NUMBER IN VARCHAR2 ,
2281 p_h_TAX_EXEMPT_REASON_CODE IN VARCHAR2 ,
2282 p_h_CONVERSION_RATE IN NUMBER ,
2283 p_h_CONVERSION_TYPE_CODE IN VARCHAR2 ,
2284 p_h_CONVERSION_RATE_DATE IN DATE ,
2285 p_h_PARTIAL_SHIPMENTS_ALLOWED IN VARCHAR2 ,
2286 p_h_SHIP_TOLERANCE_ABOVE IN NUMBER ,
2287 p_h_SHIP_TOLERANCE_BELOW IN NUMBER ,
2288 p_h_TRANSACTIONAL_CURR_CODE IN VARCHAR2 ,
2289 p_h_AGREEMENT_ID IN NUMBER ,
2290 p_h_TAX_POINT_CODE IN VARCHAR2 ,
2291 p_h_CUST_PO_NUMBER IN VARCHAR2 ,
2292 p_h_INVOICING_RULE_ID IN NUMBER ,
2293 p_h_ACCOUNTING_RULE_ID IN NUMBER ,
2294 p_h_PAYMENT_TERM_ID IN NUMBER ,
2295 p_h_SHIPPING_METHOD_CODE IN VARCHAR2 ,
2296 p_h_FREIGHT_CARRIER_CODE IN VARCHAR2 ,
2297 p_h_FOB_POINT_CODE IN VARCHAR2 ,
2298 p_h_FREIGHT_TERMS_CODE IN VARCHAR2 ,
2299 p_h_SOLD_FROM_ORG_ID IN NUMBER ,
2300 p_h_SOLD_TO_ORG_ID IN NUMBER ,
2301 p_h_SHIP_FROM_ORG_ID IN NUMBER ,
2302 p_h_SHIP_TO_ORG_ID IN NUMBER ,
2303 p_h_INVOICE_TO_ORG_ID IN NUMBER ,
2304 p_h_DELIVER_TO_ORG_ID IN NUMBER ,
2305 p_h_SOLD_TO_CONTACT_ID IN NUMBER ,
2306 p_h_SHIP_TO_CONTACT_ID IN NUMBER ,
2307 p_h_INVOICE_TO_CONTACT_ID IN NUMBER ,
2308 p_h_DELIVER_TO_CONTACT_ID IN NUMBER ,
2309 p_h_CREATION_DATE IN DATE ,
2310 p_h_CREATED_BY IN NUMBER ,
2311 p_h_LAST_UPDATED_BY IN NUMBER ,
2312 p_h_LAST_UPDATE_DATE IN DATE ,
2313 p_h_LAST_UPDATE_LOGIN IN NUMBER ,
2314 p_h_PROGRAM_APPLICATION_ID IN NUMBER ,
2315 p_h_PROGRAM_ID IN NUMBER ,
2316 p_h_PROGRAM_UPDATE_DATE IN DATE ,
2317 p_h_REQUEST_ID IN NUMBER ,
2318 p_h_CONTEXT IN VARCHAR2 ,
2319 p_h_ATTRIBUTE1 IN VARCHAR2 ,
2320 p_h_ATTRIBUTE2 IN VARCHAR2 ,
2321 p_h_ATTRIBUTE3 IN VARCHAR2 ,
2322 p_h_ATTRIBUTE4 IN VARCHAR2 ,
2323 p_h_ATTRIBUTE5 IN VARCHAR2 ,
2324 p_h_ATTRIBUTE6 IN VARCHAR2 ,
2325 p_h_ATTRIBUTE7 IN VARCHAR2 ,
2326 p_h_ATTRIBUTE8 IN VARCHAR2 ,
2327 p_h_ATTRIBUTE9 IN VARCHAR2 ,
2328 p_h_ATTRIBUTE10 IN VARCHAR2 ,
2329 p_h_ATTRIBUTE11 IN VARCHAR2 ,
2330 p_h_ATTRIBUTE12 IN VARCHAR2 ,
2331 p_h_ATTRIBUTE13 IN VARCHAR2 ,
2332 p_h_ATTRIBUTE14 IN VARCHAR2 ,
2333 p_h_ATTRIBUTE15 IN VARCHAR2 ,
2334 p_h_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2 ,
2335 p_h_GLOBAL_ATTRIBUTE1 IN VARCHAR2 ,
2336 p_h_GLOBAL_ATTRIBUTE2 IN VARCHAR2 ,
2337 p_h_GLOBAL_ATTRIBUTE3 IN VARCHAR2 ,
2338 p_h_GLOBAL_ATTRIBUTE4 IN VARCHAR2 ,
2339 p_h_GLOBAL_ATTRIBUTE5 IN VARCHAR2 ,
2340 p_h_GLOBAL_ATTRIBUTE6 IN VARCHAR2 ,
2341 p_h_GLOBAL_ATTRIBUTE7 IN VARCHAR2 ,
2342 p_h_GLOBAL_ATTRIBUTE8 IN VARCHAR2 ,
2343 p_h_GLOBAL_ATTRIBUTE9 IN VARCHAR2 ,
2344 p_h_GLOBAL_ATTRIBUTE10 IN VARCHAR2 ,
2345 p_h_GLOBAL_ATTRIBUTE11 IN VARCHAR2 ,
2346 p_h_GLOBAL_ATTRIBUTE12 IN VARCHAR2 ,
2347 p_h_GLOBAL_ATTRIBUTE13 IN VARCHAR2 ,
2348 p_h_GLOBAL_ATTRIBUTE14 IN VARCHAR2 ,
2349 p_h_GLOBAL_ATTRIBUTE15 IN VARCHAR2 ,
2350 p_h_GLOBAL_ATTRIBUTE16 IN VARCHAR2 ,
2351 p_h_GLOBAL_ATTRIBUTE17 IN VARCHAR2 ,
2352 p_h_GLOBAL_ATTRIBUTE18 IN VARCHAR2 ,
2353 p_h_GLOBAL_ATTRIBUTE19 IN VARCHAR2 ,
2354 p_h_GLOBAL_ATTRIBUTE20 IN VARCHAR2 ,
2355 p_h_CANCELLED_FLAG IN VARCHAR2 ,
2356 p_h_OPEN_FLAG IN VARCHAR2 ,
2357 p_h_BOOKED_FLAG IN VARCHAR2 ,
2358 p_h_SALESREP_ID IN NUMBER ,
2359 p_h_RETURN_REASON_CODE IN VARCHAR2 ,
2360 p_h_ORDER_DATE_TYPE_CODE IN VARCHAR2 ,
2361 p_h_EARLIEST_SCHEDULE_LIMIT IN NUMBER ,
2362 p_h_LATEST_SCHEDULE_LIMIT IN NUMBER ,
2363 p_h_PAYMENT_TYPE_CODE IN VARCHAR2 ,
2364 p_h_PAYMENT_AMOUNT IN NUMBER ,
2365 p_h_CHECK_NUMBER IN VARCHAR2 ,
2366 p_h_CREDIT_CARD_CODE IN VARCHAR2 ,
2367 p_h_CREDIT_CARD_HOLDER_NAME IN VARCHAR2 ,
2368 p_h_CREDIT_CARD_NUMBER IN VARCHAR2 ,
2369 p_h_CREDIT_CARD_EXPIR_DATE IN DATE ,
2370 p_h_CREDIT_CARD_APPROVAL_CODE IN VARCHAR2 ,
2371 p_h_SALES_CHANNEL_CODE IN VARCHAR2 ,
2372 p_h_FIRST_ACK_CODE IN VARCHAR2 ,
2373 p_h_FIRST_ACK_DATE IN DATE ,
2374 p_h_LAST_ACK_CODE IN VARCHAR2 ,
2375 p_h_LAST_ACK_DATE IN DATE ,
2376 p_h_ORDER_CATEGORY_CODE IN VARCHAR2 ,
2377 p_h_CHANGE_SEQUENCE IN VARCHAR2 ,
2378 p_h_DROP_SHIP_FLAG IN VARCHAR2 ,
2379 p_h_CUSTOMER_PAYMENT_TERM_ID IN NUMBER ,
2380 p_h_SHIPPING_INSTRUCTIONS IN VARCHAR2 ,
2381 p_h_PACKING_INSTRUCTIONS IN VARCHAR2 ,
2382 p_h_TP_CONTEXT IN VARCHAR2 ,
2383 p_h_TP_ATTRIBUTE1 IN VARCHAR2 ,
2384 p_h_TP_ATTRIBUTE2 IN VARCHAR2 ,
2385 p_h_TP_ATTRIBUTE3 IN VARCHAR2 ,
2386 p_h_TP_ATTRIBUTE4 IN VARCHAR2 ,
2387 p_h_TP_ATTRIBUTE5 IN VARCHAR2 ,
2388 p_h_TP_ATTRIBUTE6 IN VARCHAR2 ,
2389 p_h_TP_ATTRIBUTE7 IN VARCHAR2 ,
2390 p_h_TP_ATTRIBUTE8 IN VARCHAR2 ,
2391 p_h_TP_ATTRIBUTE9 IN VARCHAR2 ,
2392 p_h_TP_ATTRIBUTE10 IN VARCHAR2 ,
2393 p_h_TP_ATTRIBUTE11 IN VARCHAR2 ,
2394 p_h_TP_ATTRIBUTE12 IN VARCHAR2 ,
2395 p_h_TP_ATTRIBUTE13 IN VARCHAR2 ,
2396 p_h_TP_ATTRIBUTE14 IN VARCHAR2 ,
2397 p_h_TP_ATTRIBUTE15 IN VARCHAR2 ,
2398 p_h_FLOW_STATUS_CODE IN VARCHAR2 ,
2399 p_h_MARKETING_SOURCE_CODE_ID IN NUMBER ,
2400 p_h_CREDIT_CARD_APPROVAL_DATE IN DATE ,
2401 p_h_UPGRADED_FLAG IN VARCHAR2 ,
2402 p_h_CUSTOMER_PREF_SET_CODE IN VARCHAR2 ,
2403 p_h_BOOKED_DATE IN DATE ,
2404 p_h_LOCK_CONTROL IN NUMBER ,
2405 p_h_PRICE_REQUEST_CODE IN VARCHAR2 ,
2406 p_h_XML_MESSAGE_ID IN NUMBER ,
2407 p_h_ACCOUNTING_RULE_DURATION IN NUMBER ,
2408 p_h_attribute16 IN VARCHAR2 ,
2409 p_h_attribute17 IN VARCHAR2 ,
2410 p_h_attribute18 IN VARCHAR2 ,
2411 p_h_attribute19 IN VARCHAR2 ,
2412 p_h_attribute20 IN VARCHAR2 ,
2413 p_h_bill_to_edi_location_code IN VARCHAR2 ,
2414 p_h_Blanket_Number IN NUMBER ,
2415 p_h_change_comments IN VARCHAR2 ,
2416 p_h_change_reason IN VARCHAR2 ,
2417 p_h_change_request_code IN VARCHAR2 ,
2418 p_h_db_flag IN VARCHAR2 ,
2419 p_h_Default_Fulfillment_Set IN VARCHAR2 ,
2420 p_h_deliver_to_customer_id IN NUMBER ,
2421 p_h_force_apply_flag IN VARCHAR2 ,
2422 p_h_Fulfillment_Set_Name IN VARCHAR2 ,
2423 p_h_INVOICE_ADDRESS_ID IN NUMBER ,
2424 p_h_invoice_to_customer_id IN NUMBER ,
2425 p_h_SHIP_FROM_ADDRESS_ID IN NUMBER ,
2426 p_h_ship_from_edi_loc_code IN VARCHAR2 ,
2427 p_h_Line_Set_Name IN VARCHAR2 ,
2428 p_h_ready_flag IN VARCHAR2 ,
2429 p_h_SHIP_TO_ADDRESS_CODE IN VARCHAR2 ,
2430 p_h_SHIP_TO_ADDRESS_ID IN NUMBER ,
2431 p_h_ship_to_customer_id IN NUMBER ,
2432 p_h_ship_to_edi_location_code IN VARCHAR2 ,
2433 p_h_SOLD_TO_ADDRESS_ID IN NUMBER ,
2434 p_h_sold_to_edi_location_code IN VARCHAR2 ,
2435 p_h_sold_to_phone_id IN NUMBER ,
2436 p_h_status_flag IN VARCHAR2 ,
2437 p_h_xml_transaction_type_code IN VARCHAR2 ,
2438 p_l_LINE_ID IN jtf_number_table ,
2439 p_l_OPERATION IN jtf_varchar2_table_100 ,
2440 p_l_ORG_ID IN jtf_number_table ,
2441 p_l_HEADER_ID IN jtf_number_table ,
2442 p_l_LINE_TYPE_ID IN jtf_number_table ,
2443 p_l_LINE_NUMBER IN jtf_number_table ,
2444 p_l_ORDERED_ITEM IN jtf_varchar2_table_300 ,
2445 p_l_REQUEST_DATE IN jtf_date_table ,
2446 p_l_PROMISE_DATE IN jtf_date_table ,
2447 p_l_SCHEDULE_SHIP_DATE IN jtf_date_table ,
2448 p_l_ORDER_QUANTITY_UOM IN jtf_varchar2_table_100 ,
2449 p_l_PRICING_QUANTITY IN jtf_number_table ,
2450 p_l_PRICING_QUANTITY_UOM IN jtf_varchar2_table_300 ,
2451 p_l_CANCELLED_QUANTITY IN jtf_number_table ,
2452 p_l_SHIPPED_QUANTITY IN jtf_number_table ,
2453 p_l_ORDERED_QUANTITY IN jtf_number_table ,
2454 p_l_FULFILLED_QUANTITY IN jtf_number_table ,
2455 p_l_SHIPPING_QUANTITY IN jtf_number_table ,
2456 p_l_SHIPPING_QUANTITY_UOM IN jtf_varchar2_table_100 ,
2457 p_l_DELIVERY_LEAD_TIME IN jtf_number_table ,
2458 p_l_TAX_EXEMPT_FLAG IN jtf_varchar2_table_100 ,
2459 p_l_TAX_EXEMPT_NUMBER IN jtf_varchar2_table_100 ,
2460 p_l_TAX_EXEMPT_REASON_CODE IN jtf_varchar2_table_100 ,
2461 p_l_SHIP_FROM_ORG_ID IN jtf_number_table ,
2462 p_l_SHIP_TO_ORG_ID IN jtf_number_table ,
2463 p_l_INVOICE_TO_ORG_ID IN jtf_number_table ,
2464 p_l_DELIVER_TO_ORG_ID IN jtf_number_table ,
2465 p_l_SHIP_TO_CONTACT_ID IN jtf_number_table ,
2466 p_l_DELIVER_TO_CONTACT_ID IN jtf_number_table ,
2467 p_l_INVOICE_TO_CONTACT_ID IN jtf_number_table ,
2468 p_l_SOLD_FROM_ORG_ID IN jtf_number_table ,
2469 p_l_SOLD_TO_ORG_ID IN jtf_number_table ,
2470 p_l_CUST_PO_NUMBER IN jtf_varchar2_table_100 ,
2471 p_l_SHIP_TOLERANCE_ABOVE IN jtf_number_table ,
2472 p_l_SHIP_TOLERANCE_BELOW IN jtf_number_table ,
2473 p_l_DEMAND_BUCKET_TYPE_CODE IN jtf_varchar2_table_100 ,
2474 p_l_VEH_CUS_ITEM_CUM_KEY_ID IN jtf_number_table ,
2475 p_l_RLA_SCHEDULE_TYPE_CODE IN jtf_varchar2_table_100 ,
2476 p_l_CUSTOMER_DOCK_CODE IN jtf_varchar2_table_100 ,
2477 p_l_CUSTOMER_JOB IN jtf_varchar2_table_100 ,
2478 p_l_CUSTOMER_PRODUCTION_LINE IN jtf_varchar2_table_100 ,
2479 p_l_CUST_MODEL_SERIAL_NUMBER IN jtf_varchar2_table_100 ,
2480 p_l_PROJECT_ID IN jtf_number_table ,
2481 p_l_TASK_ID IN jtf_number_table ,
2482 p_l_INVENTORY_ITEM_ID IN jtf_number_table ,
2483 p_l_TAX_DATE IN jtf_date_table ,
2484 p_l_TAX_CODE IN jtf_varchar2_table_100 ,
2485 p_l_TAX_RATE IN jtf_number_table ,
2486 -- p_l_INVOICE_INTERFACE_STATUS_CODE IN jtf_varchar2_table_100 ,
2487 p_l_INVOICE_INTER_STATUS_CODE IN jtf_varchar2_table_100 ,
2488 p_l_DEMAND_CLASS_CODE IN jtf_varchar2_table_100 ,
2489 p_l_PRICE_LIST_ID IN jtf_number_table ,
2490 p_l_PRICING_DATE IN jtf_date_table ,
2491 p_l_SHIPMENT_NUMBER IN jtf_number_table ,
2492 p_l_AGREEMENT_ID IN jtf_number_table ,
2493 p_l_SHIPMENT_PRIORITY_CODE IN jtf_varchar2_table_100 ,
2494 p_l_SHIPPING_METHOD_CODE IN jtf_varchar2_table_100 ,
2495 p_l_FREIGHT_CARRIER_CODE IN jtf_varchar2_table_100 ,
2496 p_l_FREIGHT_TERMS_CODE IN jtf_varchar2_table_100 ,
2497 p_l_FOB_POINT_CODE IN jtf_varchar2_table_100 ,
2498 p_l_TAX_POINT_CODE IN jtf_varchar2_table_100 ,
2499 p_l_PAYMENT_TERM_ID IN jtf_number_table ,
2500 p_l_INVOICING_RULE_ID IN jtf_number_table ,
2501 p_l_ACCOUNTING_RULE_ID IN jtf_number_table ,
2502 p_l_SOURCE_DOCUMENT_TYPE_ID IN jtf_number_table ,
2503 p_l_ORIG_SYS_DOCUMENT_REF IN jtf_varchar2_table_100 ,
2504 p_l_SOURCE_DOCUMENT_ID IN jtf_number_table ,
2505 p_l_ORIG_SYS_LINE_REF IN jtf_varchar2_table_100 ,
2506 p_l_SOURCE_DOCUMENT_LINE_ID IN jtf_number_table ,
2507 p_l_REFERENCE_LINE_ID IN jtf_number_table ,
2508 p_l_REFERENCE_TYPE IN jtf_varchar2_table_300 ,
2509 p_l_REFERENCE_HEADER_ID IN jtf_number_table ,
2510 p_l_ITEM_REVISION IN jtf_varchar2_table_100 ,
2511 p_l_UNIT_SELLING_PRICE IN jtf_number_table ,
2512 p_l_UNIT_LIST_PRICE IN jtf_number_table ,
2513 p_l_TAX_VALUE IN jtf_number_table ,
2514 p_l_CONTEXT IN jtf_varchar2_table_300 ,
2515 p_l_ATTRIBUTE1 IN jtf_varchar2_table_300 ,
2516 p_l_ATTRIBUTE2 IN jtf_varchar2_table_300 ,
2517 p_l_ATTRIBUTE3 IN jtf_varchar2_table_300 ,
2518 p_l_ATTRIBUTE4 IN jtf_varchar2_table_300 ,
2519 p_l_ATTRIBUTE5 IN jtf_varchar2_table_300 ,
2520 p_l_ATTRIBUTE6 IN jtf_varchar2_table_300 ,
2521 p_l_ATTRIBUTE7 IN jtf_varchar2_table_300 ,
2522 p_l_ATTRIBUTE8 IN jtf_varchar2_table_300 ,
2523 p_l_ATTRIBUTE9 IN jtf_varchar2_table_300 ,
2524 p_l_ATTRIBUTE10 IN jtf_varchar2_table_300 ,
2525 p_l_ATTRIBUTE11 IN jtf_varchar2_table_300 ,
2526 p_l_ATTRIBUTE12 IN jtf_varchar2_table_300 ,
2527 p_l_ATTRIBUTE13 IN jtf_varchar2_table_300 ,
2528 p_l_ATTRIBUTE14 IN jtf_varchar2_table_300 ,
2529 p_l_ATTRIBUTE15 IN jtf_varchar2_table_300 ,
2530 p_l_GLOBAL_ATTRIBUTE_CATEGORY IN jtf_varchar2_table_100 ,
2531 p_l_GLOBAL_ATTRIBUTE1 IN jtf_varchar2_table_300 ,
2532 p_l_GLOBAL_ATTRIBUTE2 IN jtf_varchar2_table_300 ,
2533 p_l_GLOBAL_ATTRIBUTE3 IN jtf_varchar2_table_300 ,
2534 p_l_GLOBAL_ATTRIBUTE4 IN jtf_varchar2_table_300 ,
2535 p_l_GLOBAL_ATTRIBUTE5 IN jtf_varchar2_table_300 ,
2536 p_l_GLOBAL_ATTRIBUTE6 IN jtf_varchar2_table_300 ,
2537 p_l_GLOBAL_ATTRIBUTE7 IN jtf_varchar2_table_300 ,
2538 p_l_GLOBAL_ATTRIBUTE8 IN jtf_varchar2_table_300 ,
2539 p_l_GLOBAL_ATTRIBUTE9 IN jtf_varchar2_table_300 ,
2540 p_l_GLOBAL_ATTRIBUTE10 IN jtf_varchar2_table_300 ,
2541 p_l_GLOBAL_ATTRIBUTE11 IN jtf_varchar2_table_300 ,
2542 p_l_GLOBAL_ATTRIBUTE12 IN jtf_varchar2_table_300 ,
2543 p_l_GLOBAL_ATTRIBUTE13 IN jtf_varchar2_table_300 ,
2544 p_l_GLOBAL_ATTRIBUTE14 IN jtf_varchar2_table_300 ,
2545 p_l_GLOBAL_ATTRIBUTE15 IN jtf_varchar2_table_300 ,
2546 p_l_GLOBAL_ATTRIBUTE16 IN jtf_varchar2_table_300 ,
2547 p_l_GLOBAL_ATTRIBUTE17 IN jtf_varchar2_table_300 ,
2548 p_l_GLOBAL_ATTRIBUTE18 IN jtf_varchar2_table_300 ,
2549 p_l_GLOBAL_ATTRIBUTE19 IN jtf_varchar2_table_300 ,
2550 p_l_GLOBAL_ATTRIBUTE20 IN jtf_varchar2_table_300 ,
2551 p_l_PRICING_CONTEXT IN jtf_varchar2_table_300 ,
2552 p_l_PRICING_ATTRIBUTE1 IN jtf_varchar2_table_300 ,
2553 p_l_PRICING_ATTRIBUTE2 IN jtf_varchar2_table_300 ,
2554 p_l_PRICING_ATTRIBUTE3 IN jtf_varchar2_table_300 ,
2555 p_l_PRICING_ATTRIBUTE4 IN jtf_varchar2_table_300 ,
2556 p_l_PRICING_ATTRIBUTE5 IN jtf_varchar2_table_300 ,
2557 p_l_PRICING_ATTRIBUTE6 IN jtf_varchar2_table_300 ,
2558 p_l_PRICING_ATTRIBUTE7 IN jtf_varchar2_table_300 ,
2559 p_l_PRICING_ATTRIBUTE8 IN jtf_varchar2_table_300 ,
2560 p_l_PRICING_ATTRIBUTE9 IN jtf_varchar2_table_300 ,
2561 p_l_PRICING_ATTRIBUTE10 IN jtf_varchar2_table_300 ,
2562 p_l_INDUSTRY_CONTEXT IN jtf_varchar2_table_100 ,
2563 p_l_INDUSTRY_ATTRIBUTE1 IN jtf_varchar2_table_300 ,
2564 p_l_INDUSTRY_ATTRIBUTE2 IN jtf_varchar2_table_300 ,
2565 p_l_INDUSTRY_ATTRIBUTE3 IN jtf_varchar2_table_300 ,
2566 p_l_INDUSTRY_ATTRIBUTE4 IN jtf_varchar2_table_300 ,
2567 p_l_INDUSTRY_ATTRIBUTE5 IN jtf_varchar2_table_300 ,
2568 p_l_INDUSTRY_ATTRIBUTE6 IN jtf_varchar2_table_300 ,
2569 p_l_INDUSTRY_ATTRIBUTE7 IN jtf_varchar2_table_300 ,
2570 p_l_INDUSTRY_ATTRIBUTE8 IN jtf_varchar2_table_300 ,
2571 p_l_INDUSTRY_ATTRIBUTE9 IN jtf_varchar2_table_300 ,
2572 p_l_INDUSTRY_ATTRIBUTE10 IN jtf_varchar2_table_300 ,
2573 p_l_INDUSTRY_ATTRIBUTE11 IN jtf_varchar2_table_300 ,
2574 p_l_INDUSTRY_ATTRIBUTE13 IN jtf_varchar2_table_300 ,
2575 p_l_INDUSTRY_ATTRIBUTE12 IN jtf_varchar2_table_300 ,
2576 p_l_INDUSTRY_ATTRIBUTE14 IN jtf_varchar2_table_300 ,
2577 p_l_INDUSTRY_ATTRIBUTE15 IN jtf_varchar2_table_300 ,
2578 p_l_INDUSTRY_ATTRIBUTE16 IN jtf_varchar2_table_300 ,
2579 p_l_INDUSTRY_ATTRIBUTE17 IN jtf_varchar2_table_300 ,
2580 p_l_INDUSTRY_ATTRIBUTE18 IN jtf_varchar2_table_300 ,
2581 p_l_INDUSTRY_ATTRIBUTE19 IN jtf_varchar2_table_300 ,
2582 p_l_INDUSTRY_ATTRIBUTE20 IN jtf_varchar2_table_300 ,
2583 p_l_INDUSTRY_ATTRIBUTE21 IN jtf_varchar2_table_300 ,
2584 p_l_INDUSTRY_ATTRIBUTE22 IN jtf_varchar2_table_300 ,
2585 p_l_INDUSTRY_ATTRIBUTE23 IN jtf_varchar2_table_300 ,
2586 p_l_INDUSTRY_ATTRIBUTE24 IN jtf_varchar2_table_300 ,
2587 p_l_INDUSTRY_ATTRIBUTE25 IN jtf_varchar2_table_300 ,
2588 p_l_INDUSTRY_ATTRIBUTE26 IN jtf_varchar2_table_300 ,
2589 p_l_INDUSTRY_ATTRIBUTE27 IN jtf_varchar2_table_300 ,
2590 p_l_INDUSTRY_ATTRIBUTE28 IN jtf_varchar2_table_300 ,
2591 p_l_INDUSTRY_ATTRIBUTE29 IN jtf_varchar2_table_300 ,
2592 p_l_INDUSTRY_ATTRIBUTE30 IN jtf_varchar2_table_300 ,
2593 p_l_CREATION_DATE IN jtf_date_table ,
2594 p_l_CREATED_BY IN jtf_number_table ,
2595 p_l_LAST_UPDATE_DATE IN jtf_date_table ,
2596 p_l_LAST_UPDATED_BY IN jtf_number_table ,
2597 p_l_LAST_UPDATE_LOGIN IN jtf_number_table ,
2598 p_l_PROGRAM_APPLICATION_ID IN jtf_number_table ,
2599 p_l_PROGRAM_ID IN jtf_number_table ,
2600 p_l_PROGRAM_UPDATE_DATE IN jtf_date_table ,
2601 p_l_REQUEST_ID IN jtf_number_table ,
2602 p_l_TOP_MODEL_LINE_ID IN jtf_number_table ,
2603 p_l_LINK_TO_LINE_ID IN jtf_number_table ,
2604 p_l_COMPONENT_SEQUENCE_ID IN jtf_number_table ,
2605 p_l_COMPONENT_CODE IN jtf_varchar2_table_300 ,
2606 p_l_CONFIG_DISPLAY_SEQUENCE IN jtf_number_table ,
2607 p_l_SORT_ORDER IN jtf_varchar2_table_300 ,
2608 p_l_ITEM_TYPE_CODE IN jtf_varchar2_table_100 ,
2609 p_l_OPTION_NUMBER IN jtf_number_table ,
2610 p_l_OPTION_FLAG IN jtf_varchar2_table_100 ,
2611 p_l_DEP_PLAN_REQUIRED_FLAG IN jtf_varchar2_table_100 ,
2612 p_l_VISIBLE_DEMAND_FLAG IN jtf_varchar2_table_100 ,
2613 p_l_LINE_CATEGORY_CODE IN jtf_varchar2_table_100 ,
2614 p_l_ACTUAL_SHIPMENT_DATE IN jtf_date_table ,
2615 p_l_CUSTOMER_TRX_LINE_ID IN jtf_number_table ,
2616 p_l_RETURN_CONTEXT IN jtf_varchar2_table_100 ,
2617 p_l_RETURN_ATTRIBUTE1 IN jtf_varchar2_table_300 ,
2618 p_l_RETURN_ATTRIBUTE2 IN jtf_varchar2_table_300 ,
2619 p_l_RETURN_ATTRIBUTE3 IN jtf_varchar2_table_300 ,
2620 p_l_RETURN_ATTRIBUTE4 IN jtf_varchar2_table_300 ,
2621 p_l_RETURN_ATTRIBUTE5 IN jtf_varchar2_table_300 ,
2622 p_l_RETURN_ATTRIBUTE6 IN jtf_varchar2_table_300 ,
2623 p_l_RETURN_ATTRIBUTE7 IN jtf_varchar2_table_300 ,
2624 p_l_RETURN_ATTRIBUTE8 IN jtf_varchar2_table_300 ,
2625 p_l_RETURN_ATTRIBUTE9 IN jtf_varchar2_table_300 ,
2626 p_l_RETURN_ATTRIBUTE10 IN jtf_varchar2_table_300 ,
2627 p_l_RETURN_ATTRIBUTE11 IN jtf_varchar2_table_300 ,
2628 p_l_RETURN_ATTRIBUTE12 IN jtf_varchar2_table_300 ,
2629 p_l_RETURN_ATTRIBUTE13 IN jtf_varchar2_table_300 ,
2630 p_l_RETURN_ATTRIBUTE14 IN jtf_varchar2_table_300 ,
2631 p_l_RETURN_ATTRIBUTE15 IN jtf_varchar2_table_300 ,
2632 p_l_ACTUAL_ARRIVAL_DATE IN jtf_date_table ,
2633 p_l_ATO_LINE_ID IN jtf_number_table ,
2634 p_l_AUTO_SELECTED_QUANTITY IN jtf_number_table ,
2635 p_l_COMPONENT_NUMBER IN jtf_number_table ,
2636 p_l_EARLIEST_ACCEPTABLE_DATE IN jtf_date_table ,
2637 p_l_EXPLOSION_DATE IN jtf_date_table ,
2638 p_l_LATEST_ACCEPTABLE_DATE IN jtf_date_table ,
2639 p_l_MODEL_GROUP_NUMBER IN jtf_number_table ,
2640 p_l_SCHEDULE_ARRIVAL_DATE IN jtf_date_table ,
2641 p_l_SHIP_MODEL_COMPLETE_FLAG IN jtf_varchar2_table_100 ,
2642 p_l_SCHEDULE_STATUS_CODE IN jtf_varchar2_table_100 ,
2643 p_l_SOURCE_TYPE_CODE IN jtf_varchar2_table_100 ,
2644 p_l_CANCELLED_FLAG IN jtf_varchar2_table_100 ,
2645 p_l_OPEN_FLAG IN jtf_varchar2_table_100 ,
2646 p_l_BOOKED_FLAG IN jtf_varchar2_table_100 ,
2647 p_l_SALESREP_ID IN jtf_number_table ,
2648 p_l_RETURN_REASON_CODE IN jtf_varchar2_table_100 ,
2649 p_l_ARRIVAL_SET_ID IN jtf_number_table ,
2650 p_l_SHIP_SET_ID IN jtf_number_table ,
2651 p_l_SPLIT_FROM_LINE_ID IN jtf_number_table ,
2652 p_l_CUST_PRODUCTION_SEQ_NUM IN jtf_varchar2_table_100 ,
2653 p_l_AUTHORIZED_TO_SHIP_FLAG IN jtf_varchar2_table_300 ,
2654 p_l_OVER_SHIP_REASON_CODE IN jtf_varchar2_table_100 ,
2655 p_l_OVER_SHIP_RESOLVED_FLAG IN jtf_varchar2_table_100 ,
2656 p_l_ORDERED_ITEM_ID IN jtf_number_table ,
2657 p_l_ITEM_IDENTIFIER_TYPE IN jtf_varchar2_table_100 ,
2658 p_l_CONFIGURATION_ID IN jtf_number_table ,
2659 p_l_COMMITMENT_ID IN jtf_number_table ,
2660 p_l_SHIPPING_INTERFACED_FLAG IN jtf_varchar2_table_100 ,
2661 p_l_CREDIT_INVOICE_LINE_ID IN jtf_number_table ,
2662 p_l_FIRST_ACK_CODE IN jtf_varchar2_table_100 ,
2663 p_l_FIRST_ACK_DATE IN jtf_date_table ,
2664 p_l_LAST_ACK_CODE IN jtf_varchar2_table_100 ,
2665 p_l_LAST_ACK_DATE IN jtf_date_table ,
2666 p_l_PLANNING_PRIORITY IN jtf_number_table ,
2667 p_l_ORDER_SOURCE_ID IN jtf_number_table ,
2668 p_l_ORIG_SYS_SHIPMENT_REF IN jtf_varchar2_table_100 ,
2669 p_l_CHANGE_SEQUENCE IN jtf_varchar2_table_100 ,
2670 p_l_DROP_SHIP_FLAG IN jtf_varchar2_table_100 ,
2671 p_l_CUSTOMER_LINE_NUMBER IN jtf_varchar2_table_100 ,
2672 p_l_CUSTOMER_SHIPMENT_NUMBER IN jtf_varchar2_table_100 ,
2673 p_l_CUSTOMER_ITEM_NET_PRICE IN jtf_number_table ,
2674 p_l_CUSTOMER_PAYMENT_TERM_ID IN jtf_number_table ,
2675 p_l_FULFILLED_FLAG IN jtf_varchar2_table_100 ,
2676 p_l_END_ITEM_UNIT_NUMBER IN jtf_varchar2_table_100 ,
2677 p_l_CONFIG_HEADER_ID IN jtf_number_table ,
2678 p_l_CONFIG_REV_NBR IN jtf_number_table ,
2679 p_l_MFG_COMPONENT_SEQUENCE_ID IN jtf_number_table ,
2680 p_l_SHIPPING_INSTRUCTIONS IN jtf_varchar2_table_300 ,
2681 p_l_PACKING_INSTRUCTIONS IN jtf_varchar2_table_300 ,
2682 p_l_INVOICED_QUANTITY IN jtf_number_table ,
2683 p_l_REF_CUSTOMER_TRX_LINE_ID IN jtf_number_table ,
2684 p_l_SPLIT_BY IN jtf_varchar2_table_300 ,
2685 p_l_LINE_SET_ID IN jtf_number_table ,
2686 p_l_SERVICE_TXN_REASON_CODE IN jtf_varchar2_table_100 ,
2687 p_l_SERVICE_TXN_COMMENTS IN jtf_varchar2_table_300 ,
2688 p_l_SERVICE_DURATION IN jtf_number_table ,
2689 p_l_SERVICE_START_DATE IN jtf_date_table ,
2690 p_l_SERVICE_END_DATE IN jtf_date_table ,
2691 p_l_SERVICE_COTERMINATE_FLAG IN jtf_varchar2_table_100 ,
2692 p_l_UNIT_LIST_PERCENT IN jtf_number_table ,
2693 p_l_UNIT_SELLING_PERCENT IN jtf_number_table ,
2694 p_l_UNIT_PERCENT_BASE_PRICE IN jtf_number_table ,
2695 p_l_SERVICE_NUMBER IN jtf_number_table ,
2696 p_l_SERVICE_PERIOD IN jtf_varchar2_table_100 ,
2697 p_l_SHIPPABLE_FLAG IN jtf_varchar2_table_100 ,
2698 p_l_MODEL_REMNANT_FLAG IN jtf_varchar2_table_100 ,
2699 p_l_RE_SOURCE_FLAG IN jtf_varchar2_table_300 ,
2700 p_l_FLOW_STATUS_CODE IN jtf_varchar2_table_100 ,
2701 p_l_TP_CONTEXT IN jtf_varchar2_table_100 ,
2702 p_l_TP_ATTRIBUTE1 IN jtf_varchar2_table_300 ,
2703 p_l_TP_ATTRIBUTE2 IN jtf_varchar2_table_300 ,
2704 p_l_TP_ATTRIBUTE3 IN jtf_varchar2_table_300 ,
2705 p_l_TP_ATTRIBUTE4 IN jtf_varchar2_table_300 ,
2706 p_l_TP_ATTRIBUTE5 IN jtf_varchar2_table_300 ,
2707 p_l_TP_ATTRIBUTE6 IN jtf_varchar2_table_300 ,
2708 p_l_TP_ATTRIBUTE7 IN jtf_varchar2_table_300 ,
2709 p_l_TP_ATTRIBUTE8 IN jtf_varchar2_table_300 ,
2710 p_l_TP_ATTRIBUTE9 IN jtf_varchar2_table_300 ,
2711 p_l_TP_ATTRIBUTE10 IN jtf_varchar2_table_300 ,
2712 p_l_TP_ATTRIBUTE11 IN jtf_varchar2_table_300 ,
2713 p_l_TP_ATTRIBUTE12 IN jtf_varchar2_table_300 ,
2714 p_l_TP_ATTRIBUTE13 IN jtf_varchar2_table_300 ,
2715 p_l_TP_ATTRIBUTE14 IN jtf_varchar2_table_300 ,
2716 p_l_TP_ATTRIBUTE15 IN jtf_varchar2_table_300 ,
2717 p_l_FULFILLMENT_METHOD_CODE IN jtf_varchar2_table_300 ,
2718 p_l_MARKETING_SOURCE_CODE_ID IN jtf_number_table ,
2719 p_l_SERVICE_REF_TYPE_CODE IN jtf_varchar2_table_100 ,
2720 p_l_SERVICE_REFERENCE_LINE_ID IN jtf_number_table ,
2721 p_l_SERVICE_REF_SYSTEM_ID IN jtf_number_table ,
2722 p_l_CALCULATE_PRICE_FLAG IN jtf_varchar2_table_100 ,
2723 p_l_UPGRADED_FLAG IN jtf_varchar2_table_100 ,
2724 p_l_REVENUE_AMOUNT IN jtf_number_table ,
2725 p_l_FULFILLMENT_DATE IN jtf_date_table ,
2726 p_l_PREFERRED_GRADE IN jtf_varchar2_table_100 ,
2727 p_l_ORDERED_QUANTITY2 IN jtf_number_table ,
2728 p_l_ORDERED_QUANTITY_UOM2 IN jtf_varchar2_table_100 ,
2729 p_l_SHIPPING_QUANTITY2 IN jtf_number_table ,
2730 p_l_CANCELLED_QUANTITY2 IN jtf_number_table ,
2731 p_l_SHIPPED_QUANTITY2 IN jtf_number_table ,
2732 p_l_SHIPPING_QUANTITY_UOM2 IN jtf_varchar2_table_100 ,
2733 p_l_FULFILLED_QUANTITY2 IN jtf_number_table ,
2734 p_l_MFG_LEAD_TIME IN jtf_number_table ,
2735 p_l_LOCK_CONTROL IN jtf_number_table ,
2736 p_l_SUBINVENTORY IN jtf_varchar2_table_100 ,
2737 p_l_UNIT_LIST_PRICE_PER_PQTY IN jtf_number_table ,
2738 -- p_l_UNIT_SELLING_PRICE_PER_PQTY IN jtf_number_table ,
2739 p_l_UNIT_SELL_PRICE_PER_PQTY IN jtf_number_table ,
2740 p_l_PRICE_REQUEST_CODE IN jtf_varchar2_table_300 ,
2741 p_l_ORIGINAL_INVENTORY_ITEM_ID IN jtf_number_table ,
2742 p_l_ORIGINAL_ORDERED_ITEM_ID IN jtf_number_table ,
2743 p_l_ORIGINAL_ORDERED_ITEM IN jtf_varchar2_table_300 ,
2744 p_l_ORIGINAL_ITEM_IDENTIF_TYPE IN jtf_varchar2_table_100 ,
2745 p_l_ITEM_SUBSTIT_TYPE_CODE IN jtf_varchar2_table_100 ,
2746 p_l_OVERRIDE_ATP_DATE_CODE IN jtf_varchar2_table_100 ,
2747 p_l_LATE_DEMAND_PENALTY_FACTOR IN jtf_number_table ,
2748 p_l_ACCOUNTING_RULE_DURATION IN jtf_number_table ,
2749 p_l_top_model_line_index IN jtf_number_table ,
2750 p_l_top_model_line_ref IN jtf_varchar2_table_100 ,
2751 p_l_unit_cost IN jtf_number_table ,
2752 p_l_xml_transaction_type_code IN jtf_varchar2_table_100 ,
2753 p_l_Sold_to_address_id IN jtf_number_table ,
2754 p_l_Split_Action_Code IN jtf_varchar2_table_100 ,
2755 p_l_split_from_line_ref IN jtf_varchar2_table_100 ,
2756 p_l_split_from_shipment_ref IN jtf_varchar2_table_100 ,
2757 p_l_status_flag IN jtf_varchar2_table_100 ,
2758 p_l_ship_from_edi_loc_code IN jtf_varchar2_table_100 ,
2759 p_l_ship_set IN jtf_varchar2_table_100 ,
2760 p_l_Ship_to_address_code IN jtf_varchar2_table_100 ,
2761 p_l_Ship_to_address_id IN jtf_varchar2_table_300 ,
2762 p_l_ship_to_customer_id IN jtf_number_table ,
2763 p_l_ship_to_edi_location_code IN jtf_varchar2_table_100 ,
2764 p_l_service_ref_line_number IN jtf_number_table ,
2765 p_l_service_ref_option_number IN jtf_number_table ,
2766 p_l_service_ref_order_number IN jtf_number_table ,
2767 p_l_service_ref_ship_number IN jtf_number_table ,
2768 p_l_service_reference_line IN jtf_varchar2_table_100 ,
2769 p_l_service_reference_order IN jtf_varchar2_table_100 ,
2770 p_l_service_reference_system IN jtf_varchar2_table_100 ,
2771 p_l_reserved_quantity IN jtf_number_table ,
2772 p_l_return_status IN jtf_varchar2_table_100 ,
2773 p_l_schedule_action_code IN jtf_varchar2_table_100 ,
2774 p_l_service_line_index IN jtf_number_table ,
2775 p_l_intermed_ship_to_cont_id IN jtf_number_table ,
2776 p_l_intermed_ship_to_org_id IN jtf_number_table ,
2777 p_l_Invoice_address_id IN jtf_number_table ,
2778 p_l_invoice_to_customer_id IN jtf_number_table ,
2779 p_l_item_relationship_type IN jtf_number_table ,
2780 p_l_link_to_line_index IN jtf_number_table ,
2781 p_l_link_to_line_ref IN jtf_varchar2_table_100 ,
2782 p_l_db_flag IN jtf_varchar2_table_100 ,
2783 p_l_deliver_to_customer_id IN jtf_number_table ,
2784 p_l_fulfillment_set IN jtf_varchar2_table_100 ,
2785 p_l_fulfillment_set_id IN jtf_number_table ,
2786 p_l_change_comments IN jtf_varchar2_table_300 ,
2787 p_l_change_reason IN jtf_varchar2_table_100 ,
2788 p_l_change_request_code IN jtf_varchar2_table_100 ,
2789 p_l_Bill_to_Edi_Location_Code IN jtf_varchar2_table_100 ,
2790 p_l_Blanket_Line_Number IN jtf_number_table ,
2791 p_l_Blanket_Number IN jtf_number_table ,
2792 p_l_Blanket_Version_Number IN jtf_number_table ,
2793 p_l_arrival_set IN jtf_varchar2_table_100 ,
2794 p_l_attribute16 IN jtf_varchar2_table_300 ,
2795 p_l_attribute17 IN jtf_varchar2_table_300 ,
2796 p_l_attribute18 IN jtf_varchar2_table_300 ,
2797 p_l_attribute19 IN jtf_varchar2_table_300 ,
2798 p_l_attribute20 IN jtf_varchar2_table_300 ,
2799 p_c_CANCEL_FLAG IN VARCHAR2 ,
2800 p_c_SUBMIT_FLAG IN VARCHAR2 ,
2801 p_c_CHKCONSTRAINT_FLAG IN VARCHAR2 ,
2802 p_party_id IN NUMBER ,
2803 p_shipto_partysite_id IN NUMBER ,
2804 p_billto_partysite_id IN NUMBER ,
2805 p_save_type IN NUMBER
2806 )
2807 IS
2808
2809 l_order_header_rec OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC;
2810 l_order_line_tbl OE_Order_PUB.Line_Tbl_Type;
2811 l_ctrl_rec Control_Rec_Type;
2812
2813 BEGIN
2814
2815 IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2816 IBE_Util.Debug('In Returns SaveWrapper package body - Begin 123');
2817 END IF;
2818
2819 -- raise no_data_found;
2820 Construct_Ctrl_Rec(
2821 p_submit_flag => p_c_SUBMIT_FLAG
2822 ,p_cancel_flag => p_c_CANCEL_FLAG
2823 ,p_chkconstraint_flag => p_c_chkconstraint_flag
2824 ,x_control_rec => l_ctrl_rec
2825 );
2826
2827
2828 l_order_header_rec := Construct_Hdr_Tbl(
2829 p_HEADER_ID => p_h_HEADER_ID ,
2830 p_OPERATION => p_h_OPERATION ,
2831 p_ORG_ID => p_h_ORG_ID ,
2832 p_ORDER_TYPE_ID => p_h_ORDER_TYPE_ID ,
2833 p_ORDER_NUMBER => p_h_ORDER_NUMBER ,
2834 p_VERSION_NUMBER => p_h_VERSION_NUMBER ,
2835 p_EXPIRATION_DATE => p_h_EXPIRATION_DATE ,
2836 p_ORDER_SOURCE_ID => p_h_ORDER_SOURCE_ID ,
2837 p_SOURCE_DOCUMENT_TYPE_ID => p_h_SOURCE_DOCUMENT_TYPE_ID ,
2838 p_ORIG_SYS_DOCUMENT_REF => p_h_ORIG_SYS_DOCUMENT_REF ,
2839 p_SOURCE_DOCUMENT_ID => p_h_SOURCE_DOCUMENT_ID ,
2840 p_ORDERED_DATE => p_h_ORDERED_DATE ,
2841 p_REQUEST_DATE => p_h_REQUEST_DATE ,
2842 p_PRICING_DATE => p_h_PRICING_DATE ,
2843 p_SHIPMENT_PRIORITY_CODE => p_h_SHIPMENT_PRIORITY_CODE ,
2844 p_DEMAND_CLASS_CODE => p_h_DEMAND_CLASS_CODE ,
2845 p_PRICE_LIST_ID => p_h_PRICE_LIST_ID ,
2846 p_MINISITE_ID => p_h_MINISITE_ID , -- bug 8337371, scnagara
2847 p_TAX_EXEMPT_FLAG => p_h_TAX_EXEMPT_FLAG ,
2848 p_TAX_EXEMPT_NUMBER => p_h_TAX_EXEMPT_NUMBER ,
2849 p_TAX_EXEMPT_REASON_CODE => p_h_TAX_EXEMPT_REASON_CODE ,
2850 p_CONVERSION_RATE => p_h_CONVERSION_RATE ,
2851 p_CONVERSION_TYPE_CODE => p_h_CONVERSION_TYPE_CODE ,
2852 p_CONVERSION_RATE_DATE => p_h_CONVERSION_RATE_DATE ,
2853 p_PARTIAL_SHIPMENTS_ALLOWED => p_h_PARTIAL_SHIPMENTS_ALLOWED,
2854 p_SHIP_TOLERANCE_ABOVE => p_h_SHIP_TOLERANCE_ABOVE ,
2855 p_SHIP_TOLERANCE_BELOW => p_h_SHIP_TOLERANCE_BELOW ,
2856 p_TRANSACTIONAL_CURR_CODE => p_h_TRANSACTIONAL_CURR_CODE ,
2857 p_AGREEMENT_ID => p_h_AGREEMENT_ID ,
2858 p_TAX_POINT_CODE => p_h_TAX_POINT_CODE ,
2859 p_CUST_PO_NUMBER => p_h_CUST_PO_NUMBER ,
2860 p_INVOICING_RULE_ID => p_h_INVOICING_RULE_ID ,
2861 p_ACCOUNTING_RULE_ID => p_h_ACCOUNTING_RULE_ID ,
2862 p_PAYMENT_TERM_ID => p_h_PAYMENT_TERM_ID ,
2863 p_SHIPPING_METHOD_CODE => p_h_SHIPPING_METHOD_CODE ,
2864 p_FREIGHT_CARRIER_CODE => p_h_FREIGHT_CARRIER_CODE ,
2865 p_FOB_POINT_CODE => p_h_FOB_POINT_CODE ,
2866 p_FREIGHT_TERMS_CODE => p_h_FREIGHT_TERMS_CODE ,
2867 p_SOLD_FROM_ORG_ID => p_h_SOLD_FROM_ORG_ID ,
2868 p_SOLD_TO_ORG_ID => p_h_SOLD_TO_ORG_ID ,
2869 p_SHIP_FROM_ORG_ID => p_h_SHIP_FROM_ORG_ID ,
2870 p_SHIP_TO_ORG_ID => p_h_SHIP_TO_ORG_ID ,
2871 p_INVOICE_TO_ORG_ID => p_h_INVOICE_TO_ORG_ID ,
2872 p_DELIVER_TO_ORG_ID => p_h_DELIVER_TO_ORG_ID ,
2873 p_SOLD_TO_CONTACT_ID => p_h_SOLD_TO_CONTACT_ID ,
2874 p_SHIP_TO_CONTACT_ID => p_h_SHIP_TO_CONTACT_ID ,
2875 p_INVOICE_TO_CONTACT_ID => p_h_INVOICE_TO_CONTACT_ID ,
2876 p_DELIVER_TO_CONTACT_ID => p_h_DELIVER_TO_CONTACT_ID ,
2877 p_CREATION_DATE => p_h_CREATION_DATE ,
2878 p_CREATED_BY => p_h_CREATED_BY ,
2879 p_LAST_UPDATED_BY => p_h_LAST_UPDATED_BY ,
2880 p_LAST_UPDATE_DATE => p_h_LAST_UPDATE_DATE ,
2881 p_LAST_UPDATE_LOGIN => p_h_LAST_UPDATE_LOGIN ,
2882 p_PROGRAM_APPLICATION_ID => p_h_PROGRAM_APPLICATION_ID ,
2883 p_PROGRAM_ID => p_h_PROGRAM_ID ,
2884 p_PROGRAM_UPDATE_DATE => p_h_PROGRAM_UPDATE_DATE ,
2885 p_REQUEST_ID => p_h_REQUEST_ID ,
2886 p_CONTEXT => p_h_CONTEXT ,
2887 p_ATTRIBUTE1 => p_h_ATTRIBUTE1 ,
2888 p_ATTRIBUTE2 => p_h_ATTRIBUTE2 ,
2889 p_ATTRIBUTE3 => p_h_ATTRIBUTE3 ,
2890 p_ATTRIBUTE4 => p_h_ATTRIBUTE4 ,
2891 p_ATTRIBUTE5 => p_h_ATTRIBUTE5 ,
2892 p_ATTRIBUTE6 => p_h_ATTRIBUTE6 ,
2893 p_ATTRIBUTE7 => p_h_ATTRIBUTE7 ,
2894 p_ATTRIBUTE8 => p_h_ATTRIBUTE8 ,
2895 p_ATTRIBUTE9 => p_h_ATTRIBUTE9 ,
2896 p_ATTRIBUTE10 => p_h_ATTRIBUTE10 ,
2897 p_ATTRIBUTE11 => p_h_ATTRIBUTE11 ,
2898 p_ATTRIBUTE12 => p_h_ATTRIBUTE12 ,
2899 p_ATTRIBUTE13 => p_h_ATTRIBUTE13 ,
2900 p_ATTRIBUTE14 => p_h_ATTRIBUTE14 ,
2901 p_ATTRIBUTE15 => p_h_ATTRIBUTE15 ,
2902 p_GLOBAL_ATTRIBUTE_CATEGORY => p_h_GLOBAL_ATTRIBUTE_CATEGORY,
2903 p_GLOBAL_ATTRIBUTE1 => p_h_GLOBAL_ATTRIBUTE1 ,
2904 p_GLOBAL_ATTRIBUTE2 => p_h_GLOBAL_ATTRIBUTE2 ,
2905 p_GLOBAL_ATTRIBUTE3 => p_h_GLOBAL_ATTRIBUTE3 ,
2906 p_GLOBAL_ATTRIBUTE4 => p_h_GLOBAL_ATTRIBUTE4 ,
2907 p_GLOBAL_ATTRIBUTE5 => p_h_GLOBAL_ATTRIBUTE5 ,
2908 p_GLOBAL_ATTRIBUTE6 => p_h_GLOBAL_ATTRIBUTE6 ,
2909 p_GLOBAL_ATTRIBUTE7 => p_h_GLOBAL_ATTRIBUTE7 ,
2910 p_GLOBAL_ATTRIBUTE8 => p_h_GLOBAL_ATTRIBUTE8 ,
2911 p_GLOBAL_ATTRIBUTE9 => p_h_GLOBAL_ATTRIBUTE9 ,
2912 p_GLOBAL_ATTRIBUTE10 => p_h_GLOBAL_ATTRIBUTE10 ,
2913 p_GLOBAL_ATTRIBUTE11 => p_h_GLOBAL_ATTRIBUTE11 ,
2914 p_GLOBAL_ATTRIBUTE12 => p_h_GLOBAL_ATTRIBUTE12 ,
2915 p_GLOBAL_ATTRIBUTE13 => p_h_GLOBAL_ATTRIBUTE13 ,
2916 p_GLOBAL_ATTRIBUTE14 => p_h_GLOBAL_ATTRIBUTE14 ,
2917 p_GLOBAL_ATTRIBUTE15 => p_h_GLOBAL_ATTRIBUTE15 ,
2918 p_GLOBAL_ATTRIBUTE16 => p_h_GLOBAL_ATTRIBUTE16 ,
2919 p_GLOBAL_ATTRIBUTE17 => p_h_GLOBAL_ATTRIBUTE17 ,
2920 p_GLOBAL_ATTRIBUTE18 => p_h_GLOBAL_ATTRIBUTE18 ,
2921 p_GLOBAL_ATTRIBUTE19 => p_h_GLOBAL_ATTRIBUTE19 ,
2922 p_GLOBAL_ATTRIBUTE20 => p_h_GLOBAL_ATTRIBUTE20 ,
2923 p_CANCELLED_FLAG => p_h_CANCELLED_FLAG ,
2924 p_OPEN_FLAG => p_h_OPEN_FLAG ,
2925 p_BOOKED_FLAG => p_h_BOOKED_FLAG ,
2926 p_SALESREP_ID => p_h_SALESREP_ID ,
2927 p_RETURN_REASON_CODE => p_h_RETURN_REASON_CODE ,
2928 p_ORDER_DATE_TYPE_CODE => p_h_ORDER_DATE_TYPE_CODE ,
2929 p_EARLIEST_SCHEDULE_LIMIT => p_h_EARLIEST_SCHEDULE_LIMIT ,
2930 p_LATEST_SCHEDULE_LIMIT => p_h_LATEST_SCHEDULE_LIMIT ,
2931 p_PAYMENT_TYPE_CODE => p_h_PAYMENT_TYPE_CODE ,
2932 p_PAYMENT_AMOUNT => p_h_PAYMENT_AMOUNT ,
2933 p_CHECK_NUMBER => p_h_CHECK_NUMBER ,
2934 p_CREDIT_CARD_CODE => p_h_CREDIT_CARD_CODE ,
2935 p_CREDIT_CARD_HOLDER_NAME => p_h_CREDIT_CARD_HOLDER_NAME ,
2936 p_CREDIT_CARD_NUMBER => p_h_CREDIT_CARD_NUMBER ,
2937 p_CREDIT_CARD_EXPIR_DATE => p_h_CREDIT_CARD_EXPIR_DATE ,
2938 p_CREDIT_CARD_APPROVAL_CODE => p_h_CREDIT_CARD_APPROVAL_CODE ,
2939 p_SALES_CHANNEL_CODE => p_h_SALES_CHANNEL_CODE ,
2940 p_FIRST_ACK_CODE => p_h_FIRST_ACK_CODE ,
2941 p_FIRST_ACK_DATE => p_h_FIRST_ACK_DATE ,
2942 p_LAST_ACK_CODE => p_h_LAST_ACK_CODE ,
2943 p_LAST_ACK_DATE => p_h_LAST_ACK_DATE ,
2944 p_ORDER_CATEGORY_CODE => p_h_ORDER_CATEGORY_CODE ,
2945 p_CHANGE_SEQUENCE => p_h_CHANGE_SEQUENCE ,
2946 p_DROP_SHIP_FLAG => p_h_DROP_SHIP_FLAG ,
2947 p_CUSTOMER_PAYMENT_TERM_ID => p_h_CUSTOMER_PAYMENT_TERM_ID ,
2948 p_SHIPPING_INSTRUCTIONS => p_h_SHIPPING_INSTRUCTIONS ,
2949 p_PACKING_INSTRUCTIONS => p_h_PACKING_INSTRUCTIONS ,
2950 p_TP_CONTEXT => p_h_TP_CONTEXT ,
2951 p_TP_ATTRIBUTE1 => p_h_TP_ATTRIBUTE1 ,
2952 p_TP_ATTRIBUTE2 => p_h_TP_ATTRIBUTE2 ,
2953 p_TP_ATTRIBUTE3 => p_h_TP_ATTRIBUTE3 ,
2954 p_TP_ATTRIBUTE4 => p_h_TP_ATTRIBUTE4 ,
2955 p_TP_ATTRIBUTE5 => p_h_TP_ATTRIBUTE5 ,
2956 p_TP_ATTRIBUTE6 => p_h_TP_ATTRIBUTE6 ,
2957 p_TP_ATTRIBUTE7 => p_h_TP_ATTRIBUTE7 ,
2958 p_TP_ATTRIBUTE8 => p_h_TP_ATTRIBUTE8 ,
2959 p_TP_ATTRIBUTE9 => p_h_TP_ATTRIBUTE9 ,
2960 p_TP_ATTRIBUTE10 => p_h_TP_ATTRIBUTE10 ,
2961 p_TP_ATTRIBUTE11 => p_h_TP_ATTRIBUTE11 ,
2962 p_TP_ATTRIBUTE12 => p_h_TP_ATTRIBUTE12 ,
2963 p_TP_ATTRIBUTE13 => p_h_TP_ATTRIBUTE13 ,
2964 p_TP_ATTRIBUTE14 => p_h_TP_ATTRIBUTE14 ,
2965 p_TP_ATTRIBUTE15 => p_h_TP_ATTRIBUTE15 ,
2966 p_FLOW_STATUS_CODE => p_h_FLOW_STATUS_CODE ,
2967 p_MARKETING_SOURCE_CODE_ID => p_h_MARKETING_SOURCE_CODE_ID ,
2968 p_CREDIT_CARD_APPROVAL_DATE => p_h_CREDIT_CARD_APPROVAL_DATE ,
2969 p_UPGRADED_FLAG => p_h_UPGRADED_FLAG ,
2970 p_CUSTOMER_PREF_SET_CODE => p_h_CUSTOMER_PREF_SET_CODE ,
2971 p_BOOKED_DATE => p_h_BOOKED_DATE ,
2972 p_LOCK_CONTROL => p_h_LOCK_CONTROL ,
2973 p_PRICE_REQUEST_CODE => p_h_PRICE_REQUEST_CODE ,
2974 p_XML_MESSAGE_ID => p_h_XML_MESSAGE_ID ,
2975 p_ACCOUNTING_RULE_DURATION => p_h_ACCOUNTING_RULE_DURATION ,
2976 p_attribute16 => p_h_attribute16 ,
2977 p_attribute17 => p_h_attribute17 ,
2978 p_attribute18 => p_h_attribute18 ,
2979 p_attribute19 => p_h_attribute19 ,
2980 p_attribute20 => p_h_attribute20 ,
2981 p_bill_to_edi_location_code => p_h_bill_to_edi_location_code,
2982 p_Blanket_Number => p_h_Blanket_Number ,
2983 p_change_comments => p_h_change_comments ,
2984 p_change_reason => p_h_change_reason ,
2985 p_change_request_code => p_h_change_request_code ,
2986 p_db_flag => p_h_db_flag ,
2987 p_Default_Fulfillment_Set => p_h_Default_Fulfillment_Set,
2988 p_deliver_to_customer_id => p_h_deliver_to_customer_id,
2989 p_force_apply_flag => p_h_force_apply_flag ,
2990 p_Fulfillment_Set_Name => p_h_Fulfillment_Set_Name ,
2991 p_INVOICE_ADDRESS_ID => p_h_INVOICE_ADDRESS_ID ,
2992 p_invoice_to_customer_id => p_h_invoice_to_customer_id,
2993 p_SHIP_FROM_ADDRESS_ID => p_h_SHIP_FROM_ADDRESS_ID ,
2994 p_ship_from_edi_loc_code => p_h_ship_from_edi_loc_code ,
2995 p_Line_Set_Name => p_h_Line_Set_Name ,
2996 p_ready_flag => p_h_ready_flag ,
2997 p_SHIP_TO_ADDRESS_CODE => p_h_SHIP_TO_ADDRESS_CODE,
2998 p_SHIP_TO_ADDRESS_ID => p_h_SHIP_TO_ADDRESS_ID ,
2999 p_ship_to_customer_id => p_h_ship_to_customer_id ,
3000 p_ship_to_edi_location_code => p_h_ship_to_edi_location_code,
3001 p_SOLD_TO_ADDRESS_ID => p_h_SOLD_TO_ADDRESS_ID ,
3002 p_sold_to_edi_location_code => p_h_sold_to_edi_location_code,
3003 p_sold_to_phone_id => p_h_sold_to_phone_id ,
3004 p_status_flag => p_h_status_flag ,
3005 p_xml_transaction_type_code => p_h_xml_transaction_type_code
3006
3007 );
3008
3009 l_order_line_tbl := Construct_Line_Tbl(
3010 p_LINE_ID => p_l_LINE_ID ,
3011 p_OPERATION => p_l_OPERATION ,
3012 p_ORG_ID => p_l_ORG_ID ,
3013 p_HEADER_ID => p_l_HEADER_ID ,
3014 p_LINE_TYPE_ID => p_l_LINE_TYPE_ID ,
3015 p_LINE_NUMBER => p_l_LINE_NUMBER ,
3016 p_ORDERED_ITEM => p_l_ORDERED_ITEM ,
3017 p_REQUEST_DATE => p_l_REQUEST_DATE ,
3018 p_PROMISE_DATE => p_l_PROMISE_DATE ,
3019 p_SCHEDULE_SHIP_DATE => p_l_SCHEDULE_SHIP_DATE ,
3020 p_ORDER_QUANTITY_UOM => p_l_ORDER_QUANTITY_UOM ,
3021 p_PRICING_QUANTITY => p_l_PRICING_QUANTITY ,
3022 p_PRICING_QUANTITY_UOM => p_l_PRICING_QUANTITY_UOM ,
3023 p_CANCELLED_QUANTITY => p_l_CANCELLED_QUANTITY ,
3024 p_SHIPPED_QUANTITY => p_l_SHIPPED_QUANTITY ,
3025 p_ORDERED_QUANTITY => p_l_ORDERED_QUANTITY ,
3026 p_FULFILLED_QUANTITY => p_l_FULFILLED_QUANTITY ,
3027 p_SHIPPING_QUANTITY => p_l_SHIPPING_QUANTITY ,
3028 p_SHIPPING_QUANTITY_UOM => p_l_SHIPPING_QUANTITY_UOM ,
3029 p_DELIVERY_LEAD_TIME => p_l_DELIVERY_LEAD_TIME ,
3030 p_TAX_EXEMPT_FLAG => p_l_TAX_EXEMPT_FLAG ,
3031 p_TAX_EXEMPT_NUMBER => p_l_TAX_EXEMPT_NUMBER ,
3032 p_TAX_EXEMPT_REASON_CODE => p_l_TAX_EXEMPT_REASON_CODE ,
3033 p_SHIP_FROM_ORG_ID => p_l_SHIP_FROM_ORG_ID ,
3034 p_SHIP_TO_ORG_ID => p_l_SHIP_TO_ORG_ID ,
3035 p_INVOICE_TO_ORG_ID => p_l_INVOICE_TO_ORG_ID ,
3036 p_DELIVER_TO_ORG_ID => p_l_DELIVER_TO_ORG_ID ,
3037 p_SHIP_TO_CONTACT_ID => p_l_SHIP_TO_CONTACT_ID ,
3038 p_DELIVER_TO_CONTACT_ID => p_l_DELIVER_TO_CONTACT_ID ,
3039 p_INVOICE_TO_CONTACT_ID => p_l_INVOICE_TO_CONTACT_ID ,
3040 p_SOLD_FROM_ORG_ID => p_l_SOLD_FROM_ORG_ID ,
3041 p_SOLD_TO_ORG_ID => p_l_SOLD_TO_ORG_ID ,
3042 p_CUST_PO_NUMBER => p_l_CUST_PO_NUMBER ,
3043 p_SHIP_TOLERANCE_ABOVE => p_l_SHIP_TOLERANCE_ABOVE ,
3044 p_SHIP_TOLERANCE_BELOW => p_l_SHIP_TOLERANCE_BELOW ,
3045 p_DEMAND_BUCKET_TYPE_CODE => p_l_DEMAND_BUCKET_TYPE_CODE ,
3046 p_VEH_CUS_ITEM_CUM_KEY_ID => p_l_VEH_CUS_ITEM_CUM_KEY_ID ,
3047 p_RLA_SCHEDULE_TYPE_CODE => p_l_RLA_SCHEDULE_TYPE_CODE ,
3048 p_CUSTOMER_DOCK_CODE => p_l_CUSTOMER_DOCK_CODE ,
3049 p_CUSTOMER_JOB => p_l_CUSTOMER_JOB ,
3050 p_CUSTOMER_PRODUCTION_LINE => p_l_CUSTOMER_PRODUCTION_LINE ,
3051 p_CUST_MODEL_SERIAL_NUMBER => p_l_CUST_MODEL_SERIAL_NUMBER ,
3052 p_PROJECT_ID => p_l_PROJECT_ID ,
3053 p_TASK_ID => p_l_TASK_ID ,
3054 p_INVENTORY_ITEM_ID => p_l_INVENTORY_ITEM_ID ,
3055 p_TAX_DATE => p_l_TAX_DATE ,
3056 p_TAX_CODE => p_l_TAX_CODE ,
3057 p_TAX_RATE => p_l_TAX_RATE ,
3058 p_INVOICE_INTER_STATUS_CODE => p_l_INVOICE_INTER_STATUS_CODE ,
3059 p_DEMAND_CLASS_CODE => p_l_DEMAND_CLASS_CODE ,
3060 p_PRICE_LIST_ID => p_l_PRICE_LIST_ID ,
3061 p_PRICING_DATE => p_l_PRICING_DATE ,
3062 p_SHIPMENT_NUMBER => p_l_SHIPMENT_NUMBER ,
3063 p_AGREEMENT_ID => p_l_AGREEMENT_ID ,
3064 p_SHIPMENT_PRIORITY_CODE => p_l_SHIPMENT_PRIORITY_CODE ,
3065 p_SHIPPING_METHOD_CODE => p_l_SHIPPING_METHOD_CODE ,
3066 p_FREIGHT_CARRIER_CODE => p_l_FREIGHT_CARRIER_CODE ,
3067 p_FREIGHT_TERMS_CODE => p_l_FREIGHT_TERMS_CODE ,
3068 p_FOB_POINT_CODE => p_l_FOB_POINT_CODE ,
3069 p_TAX_POINT_CODE => p_l_TAX_POINT_CODE ,
3070 p_PAYMENT_TERM_ID => p_l_PAYMENT_TERM_ID ,
3071 p_INVOICING_RULE_ID => p_l_INVOICING_RULE_ID ,
3072 p_ACCOUNTING_RULE_ID => p_l_ACCOUNTING_RULE_ID ,
3073 p_SOURCE_DOCUMENT_TYPE_ID => p_l_SOURCE_DOCUMENT_TYPE_ID ,
3074 p_ORIG_SYS_DOCUMENT_REF => p_l_ORIG_SYS_DOCUMENT_REF ,
3075 p_SOURCE_DOCUMENT_ID => p_l_SOURCE_DOCUMENT_ID ,
3076 p_ORIG_SYS_LINE_REF => p_l_ORIG_SYS_LINE_REF ,
3077 p_SOURCE_DOCUMENT_LINE_ID => p_l_SOURCE_DOCUMENT_LINE_ID ,
3078 p_REFERENCE_LINE_ID => p_l_REFERENCE_LINE_ID ,
3079 p_REFERENCE_TYPE => p_l_REFERENCE_TYPE ,
3080 p_REFERENCE_HEADER_ID => p_l_REFERENCE_HEADER_ID ,
3081 p_ITEM_REVISION => p_l_ITEM_REVISION ,
3082 p_UNIT_SELLING_PRICE => p_l_UNIT_SELLING_PRICE ,
3083 p_UNIT_LIST_PRICE => p_l_UNIT_LIST_PRICE ,
3084 p_TAX_VALUE => p_l_TAX_VALUE ,
3085 p_CONTEXT => p_l_CONTEXT ,
3086 p_ATTRIBUTE1 => p_l_ATTRIBUTE1 ,
3087 p_ATTRIBUTE2 => p_l_ATTRIBUTE2 ,
3088 p_ATTRIBUTE3 => p_l_ATTRIBUTE3 ,
3089 p_ATTRIBUTE4 => p_l_ATTRIBUTE4 ,
3090 p_ATTRIBUTE5 => p_l_ATTRIBUTE5 ,
3091 p_ATTRIBUTE6 => p_l_ATTRIBUTE6 ,
3092 p_ATTRIBUTE7 => p_l_ATTRIBUTE7 ,
3093 p_ATTRIBUTE8 => p_l_ATTRIBUTE8 ,
3094 p_ATTRIBUTE9 => p_l_ATTRIBUTE9 ,
3095 p_ATTRIBUTE10 => p_l_ATTRIBUTE10 ,
3096 p_ATTRIBUTE11 => p_l_ATTRIBUTE11 ,
3097 p_ATTRIBUTE12 => p_l_ATTRIBUTE12 ,
3098 p_ATTRIBUTE13 => p_l_ATTRIBUTE13 ,
3099 p_ATTRIBUTE14 => p_l_ATTRIBUTE14 ,
3100 p_ATTRIBUTE15 => p_l_ATTRIBUTE15 ,
3101 p_GLOBAL_ATTRIBUTE_CATEGORY => p_l_GLOBAL_ATTRIBUTE_CATEGORY ,
3102 p_GLOBAL_ATTRIBUTE1 => p_l_GLOBAL_ATTRIBUTE1 ,
3103 p_GLOBAL_ATTRIBUTE2 => p_l_GLOBAL_ATTRIBUTE2 ,
3104 p_GLOBAL_ATTRIBUTE3 => p_l_GLOBAL_ATTRIBUTE3 ,
3105 p_GLOBAL_ATTRIBUTE4 => p_l_GLOBAL_ATTRIBUTE4 ,
3106 p_GLOBAL_ATTRIBUTE5 => p_l_GLOBAL_ATTRIBUTE5 ,
3107 p_GLOBAL_ATTRIBUTE6 => p_l_GLOBAL_ATTRIBUTE6 ,
3108 p_GLOBAL_ATTRIBUTE7 => p_l_GLOBAL_ATTRIBUTE7 ,
3109 p_GLOBAL_ATTRIBUTE8 => p_l_GLOBAL_ATTRIBUTE8 ,
3110 p_GLOBAL_ATTRIBUTE9 => p_l_GLOBAL_ATTRIBUTE9 ,
3111 p_GLOBAL_ATTRIBUTE10 => p_l_GLOBAL_ATTRIBUTE10 ,
3112 p_GLOBAL_ATTRIBUTE11 => p_l_GLOBAL_ATTRIBUTE11 ,
3113 p_GLOBAL_ATTRIBUTE12 => p_l_GLOBAL_ATTRIBUTE12 ,
3114 p_GLOBAL_ATTRIBUTE13 => p_l_GLOBAL_ATTRIBUTE13 ,
3115 p_GLOBAL_ATTRIBUTE14 => p_l_GLOBAL_ATTRIBUTE14 ,
3116 p_GLOBAL_ATTRIBUTE15 => p_l_GLOBAL_ATTRIBUTE15 ,
3117 p_GLOBAL_ATTRIBUTE16 => p_l_GLOBAL_ATTRIBUTE16 ,
3118 p_GLOBAL_ATTRIBUTE17 => p_l_GLOBAL_ATTRIBUTE17 ,
3119 p_GLOBAL_ATTRIBUTE18 => p_l_GLOBAL_ATTRIBUTE18 ,
3120 p_GLOBAL_ATTRIBUTE19 => p_l_GLOBAL_ATTRIBUTE19 ,
3121 p_GLOBAL_ATTRIBUTE20 => p_l_GLOBAL_ATTRIBUTE20 ,
3122 p_PRICING_CONTEXT => p_l_PRICING_CONTEXT ,
3123 p_PRICING_ATTRIBUTE1 => p_l_PRICING_ATTRIBUTE1 ,
3124 p_PRICING_ATTRIBUTE2 => p_l_PRICING_ATTRIBUTE2 ,
3125 p_PRICING_ATTRIBUTE3 => p_l_PRICING_ATTRIBUTE3 ,
3126 p_PRICING_ATTRIBUTE4 => p_l_PRICING_ATTRIBUTE4 ,
3127 p_PRICING_ATTRIBUTE5 => p_l_PRICING_ATTRIBUTE5 ,
3128 p_PRICING_ATTRIBUTE6 => p_l_PRICING_ATTRIBUTE6 ,
3129 p_PRICING_ATTRIBUTE7 => p_l_PRICING_ATTRIBUTE7 ,
3130 p_PRICING_ATTRIBUTE8 => p_l_PRICING_ATTRIBUTE8 ,
3131 p_PRICING_ATTRIBUTE9 => p_l_PRICING_ATTRIBUTE9 ,
3132 p_PRICING_ATTRIBUTE10 => p_l_PRICING_ATTRIBUTE10 ,
3133 p_INDUSTRY_CONTEXT => p_l_INDUSTRY_CONTEXT ,
3134 p_INDUSTRY_ATTRIBUTE1 => p_l_INDUSTRY_ATTRIBUTE1 ,
3135 p_INDUSTRY_ATTRIBUTE2 => p_l_INDUSTRY_ATTRIBUTE2 ,
3136 p_INDUSTRY_ATTRIBUTE3 => p_l_INDUSTRY_ATTRIBUTE3 ,
3137 p_INDUSTRY_ATTRIBUTE4 => p_l_INDUSTRY_ATTRIBUTE4 ,
3138 p_INDUSTRY_ATTRIBUTE5 => p_l_INDUSTRY_ATTRIBUTE5 ,
3139 p_INDUSTRY_ATTRIBUTE6 => p_l_INDUSTRY_ATTRIBUTE6 ,
3140 p_INDUSTRY_ATTRIBUTE7 => p_l_INDUSTRY_ATTRIBUTE7 ,
3141 p_INDUSTRY_ATTRIBUTE8 => p_l_INDUSTRY_ATTRIBUTE8 ,
3142 p_INDUSTRY_ATTRIBUTE9 => p_l_INDUSTRY_ATTRIBUTE9 ,
3143 p_INDUSTRY_ATTRIBUTE10 => p_l_INDUSTRY_ATTRIBUTE10 ,
3144 p_INDUSTRY_ATTRIBUTE11 => p_l_INDUSTRY_ATTRIBUTE11 ,
3145 p_INDUSTRY_ATTRIBUTE13 => p_l_INDUSTRY_ATTRIBUTE13 ,
3146 p_INDUSTRY_ATTRIBUTE12 => p_l_INDUSTRY_ATTRIBUTE12 ,
3147 p_INDUSTRY_ATTRIBUTE14 => p_l_INDUSTRY_ATTRIBUTE14 ,
3148 p_INDUSTRY_ATTRIBUTE15 => p_l_INDUSTRY_ATTRIBUTE15 ,
3149 p_INDUSTRY_ATTRIBUTE16 => p_l_INDUSTRY_ATTRIBUTE16 ,
3150 p_INDUSTRY_ATTRIBUTE17 => p_l_INDUSTRY_ATTRIBUTE17 ,
3151 p_INDUSTRY_ATTRIBUTE18 => p_l_INDUSTRY_ATTRIBUTE18 ,
3152 p_INDUSTRY_ATTRIBUTE19 => p_l_INDUSTRY_ATTRIBUTE19 ,
3153 p_INDUSTRY_ATTRIBUTE20 => p_l_INDUSTRY_ATTRIBUTE20 ,
3154 p_INDUSTRY_ATTRIBUTE21 => p_l_INDUSTRY_ATTRIBUTE21 ,
3155 p_INDUSTRY_ATTRIBUTE22 => p_l_INDUSTRY_ATTRIBUTE22 ,
3156 p_INDUSTRY_ATTRIBUTE23 => p_l_INDUSTRY_ATTRIBUTE23 ,
3157 p_INDUSTRY_ATTRIBUTE24 => p_l_INDUSTRY_ATTRIBUTE24 ,
3158 p_INDUSTRY_ATTRIBUTE25 => p_l_INDUSTRY_ATTRIBUTE25 ,
3159 p_INDUSTRY_ATTRIBUTE26 => p_l_INDUSTRY_ATTRIBUTE26 ,
3160 p_INDUSTRY_ATTRIBUTE27 => p_l_INDUSTRY_ATTRIBUTE27 ,
3161 p_INDUSTRY_ATTRIBUTE28 => p_l_INDUSTRY_ATTRIBUTE28 ,
3162 p_INDUSTRY_ATTRIBUTE29 => p_l_INDUSTRY_ATTRIBUTE29 ,
3163 p_INDUSTRY_ATTRIBUTE30 => p_l_INDUSTRY_ATTRIBUTE30 ,
3164 p_CREATION_DATE => p_l_CREATION_DATE ,
3165 p_CREATED_BY => p_l_CREATED_BY ,
3166 p_LAST_UPDATE_DATE => p_l_LAST_UPDATE_DATE ,
3167 p_LAST_UPDATED_BY => p_l_LAST_UPDATED_BY ,
3168 p_LAST_UPDATE_LOGIN => p_l_LAST_UPDATE_LOGIN ,
3169 p_PROGRAM_APPLICATION_ID => p_l_PROGRAM_APPLICATION_ID ,
3170 p_PROGRAM_ID => p_l_PROGRAM_ID ,
3171 p_PROGRAM_UPDATE_DATE => p_l_PROGRAM_UPDATE_DATE ,
3172 p_REQUEST_ID => p_l_REQUEST_ID ,
3173 p_TOP_MODEL_LINE_ID => p_l_TOP_MODEL_LINE_ID ,
3174 p_LINK_TO_LINE_ID => p_l_LINK_TO_LINE_ID ,
3175 p_COMPONENT_SEQUENCE_ID => p_l_COMPONENT_SEQUENCE_ID ,
3176 p_COMPONENT_CODE => p_l_COMPONENT_CODE ,
3177 p_CONFIG_DISPLAY_SEQUENCE => p_l_CONFIG_DISPLAY_SEQUENCE ,
3178 p_SORT_ORDER => p_l_SORT_ORDER ,
3179 p_ITEM_TYPE_CODE => p_l_ITEM_TYPE_CODE ,
3180 p_OPTION_NUMBER => p_l_OPTION_NUMBER ,
3181 p_OPTION_FLAG => p_l_OPTION_FLAG ,
3182 p_DEP_PLAN_REQUIRED_FLAG => p_l_DEP_PLAN_REQUIRED_FLAG ,
3183 p_VISIBLE_DEMAND_FLAG => p_l_VISIBLE_DEMAND_FLAG ,
3184 p_LINE_CATEGORY_CODE => p_l_LINE_CATEGORY_CODE ,
3185 p_ACTUAL_SHIPMENT_DATE => p_l_ACTUAL_SHIPMENT_DATE ,
3186 p_CUSTOMER_TRX_LINE_ID => p_l_CUSTOMER_TRX_LINE_ID ,
3187 p_RETURN_CONTEXT => p_l_RETURN_CONTEXT ,
3188 p_RETURN_ATTRIBUTE1 => p_l_RETURN_ATTRIBUTE1 ,
3189 p_RETURN_ATTRIBUTE2 => p_l_RETURN_ATTRIBUTE2 ,
3190 p_RETURN_ATTRIBUTE3 => p_l_RETURN_ATTRIBUTE3 ,
3191 p_RETURN_ATTRIBUTE4 => p_l_RETURN_ATTRIBUTE4 ,
3192 p_RETURN_ATTRIBUTE5 => p_l_RETURN_ATTRIBUTE5 ,
3193 p_RETURN_ATTRIBUTE6 => p_l_RETURN_ATTRIBUTE6 ,
3194 p_RETURN_ATTRIBUTE7 => p_l_RETURN_ATTRIBUTE7 ,
3195 p_RETURN_ATTRIBUTE8 => p_l_RETURN_ATTRIBUTE8 ,
3196 p_RETURN_ATTRIBUTE9 => p_l_RETURN_ATTRIBUTE9 ,
3197 p_RETURN_ATTRIBUTE10 => p_l_RETURN_ATTRIBUTE10 ,
3198 p_RETURN_ATTRIBUTE11 => p_l_RETURN_ATTRIBUTE11 ,
3199 p_RETURN_ATTRIBUTE12 => p_l_RETURN_ATTRIBUTE12 ,
3200 p_RETURN_ATTRIBUTE13 => p_l_RETURN_ATTRIBUTE13 ,
3201 p_RETURN_ATTRIBUTE14 => p_l_RETURN_ATTRIBUTE14 ,
3202 p_RETURN_ATTRIBUTE15 => p_l_RETURN_ATTRIBUTE15 ,
3203 p_ACTUAL_ARRIVAL_DATE => p_l_ACTUAL_ARRIVAL_DATE ,
3204 p_ATO_LINE_ID => p_l_ATO_LINE_ID ,
3205 p_AUTO_SELECTED_QUANTITY => p_l_AUTO_SELECTED_QUANTITY ,
3206 p_COMPONENT_NUMBER => p_l_COMPONENT_NUMBER ,
3207 p_EARLIEST_ACCEPTABLE_DATE => p_l_EARLIEST_ACCEPTABLE_DATE ,
3208 p_EXPLOSION_DATE => p_l_EXPLOSION_DATE ,
3209 p_LATEST_ACCEPTABLE_DATE => p_l_LATEST_ACCEPTABLE_DATE ,
3210 p_MODEL_GROUP_NUMBER => p_l_MODEL_GROUP_NUMBER ,
3211 p_SCHEDULE_ARRIVAL_DATE => p_l_SCHEDULE_ARRIVAL_DATE ,
3212 p_SHIP_MODEL_COMPLETE_FLAG => p_l_SHIP_MODEL_COMPLETE_FLAG ,
3213 p_SCHEDULE_STATUS_CODE => p_l_SCHEDULE_STATUS_CODE ,
3214 p_SOURCE_TYPE_CODE => p_l_SOURCE_TYPE_CODE ,
3215 p_CANCELLED_FLAG => p_l_CANCELLED_FLAG ,
3216 p_OPEN_FLAG => p_l_OPEN_FLAG ,
3217 p_BOOKED_FLAG => p_l_BOOKED_FLAG ,
3218 p_SALESREP_ID => p_l_SALESREP_ID ,
3219 p_RETURN_REASON_CODE => p_l_RETURN_REASON_CODE ,
3220 p_ARRIVAL_SET_ID => p_l_ARRIVAL_SET_ID ,
3221 p_SHIP_SET_ID => p_l_SHIP_SET_ID ,
3222 p_SPLIT_FROM_LINE_ID => p_l_SPLIT_FROM_LINE_ID ,
3223 p_CUST_PRODUCTION_SEQ_NUM => p_l_CUST_PRODUCTION_SEQ_NUM ,
3224 p_AUTHORIZED_TO_SHIP_FLAG => p_l_AUTHORIZED_TO_SHIP_FLAG ,
3225 p_OVER_SHIP_REASON_CODE => p_l_OVER_SHIP_REASON_CODE ,
3226 p_OVER_SHIP_RESOLVED_FLAG => p_l_OVER_SHIP_RESOLVED_FLAG ,
3227 p_ORDERED_ITEM_ID => p_l_ORDERED_ITEM_ID ,
3228 p_ITEM_IDENTIFIER_TYPE => p_l_ITEM_IDENTIFIER_TYPE ,
3229 p_CONFIGURATION_ID => p_l_CONFIGURATION_ID ,
3230 p_COMMITMENT_ID => p_l_COMMITMENT_ID ,
3231 p_SHIPPING_INTERFACED_FLAG => p_l_SHIPPING_INTERFACED_FLAG ,
3232 p_CREDIT_INVOICE_LINE_ID => p_l_CREDIT_INVOICE_LINE_ID ,
3233 p_FIRST_ACK_CODE => p_l_FIRST_ACK_CODE ,
3234 p_FIRST_ACK_DATE => p_l_FIRST_ACK_DATE ,
3235 p_LAST_ACK_CODE => p_l_LAST_ACK_CODE ,
3236 p_LAST_ACK_DATE => p_l_LAST_ACK_DATE ,
3237 p_PLANNING_PRIORITY => p_l_PLANNING_PRIORITY ,
3238 p_ORDER_SOURCE_ID => p_l_ORDER_SOURCE_ID ,
3239 p_ORIG_SYS_SHIPMENT_REF => p_l_ORIG_SYS_SHIPMENT_REF ,
3240 p_CHANGE_SEQUENCE => p_l_CHANGE_SEQUENCE ,
3241 p_DROP_SHIP_FLAG => p_l_DROP_SHIP_FLAG ,
3242 p_CUSTOMER_LINE_NUMBER => p_l_CUSTOMER_LINE_NUMBER ,
3243 p_CUSTOMER_SHIPMENT_NUMBER => p_l_CUSTOMER_SHIPMENT_NUMBER ,
3244 p_CUSTOMER_ITEM_NET_PRICE => p_l_CUSTOMER_ITEM_NET_PRICE ,
3245 p_CUSTOMER_PAYMENT_TERM_ID => p_l_CUSTOMER_PAYMENT_TERM_ID ,
3246 p_FULFILLED_FLAG => p_l_FULFILLED_FLAG ,
3247 p_END_ITEM_UNIT_NUMBER => p_l_END_ITEM_UNIT_NUMBER ,
3248 p_CONFIG_HEADER_ID => p_l_CONFIG_HEADER_ID ,
3249 p_CONFIG_REV_NBR => p_l_CONFIG_REV_NBR ,
3250 p_MFG_COMPONENT_SEQUENCE_ID => p_l_MFG_COMPONENT_SEQUENCE_ID ,
3251 p_SHIPPING_INSTRUCTIONS => p_l_SHIPPING_INSTRUCTIONS ,
3252 p_PACKING_INSTRUCTIONS => p_l_PACKING_INSTRUCTIONS ,
3253 p_INVOICED_QUANTITY => p_l_INVOICED_QUANTITY ,
3254 p_REF_CUSTOMER_TRX_LINE_ID => p_l_REF_CUSTOMER_TRX_LINE_ID ,
3255 p_SPLIT_BY => p_l_SPLIT_BY ,
3256 p_LINE_SET_ID => p_l_LINE_SET_ID ,
3257 p_SERVICE_TXN_REASON_CODE => p_l_SERVICE_TXN_REASON_CODE ,
3258 p_SERVICE_TXN_COMMENTS => p_l_SERVICE_TXN_COMMENTS ,
3259 p_SERVICE_DURATION => p_l_SERVICE_DURATION ,
3260 p_SERVICE_START_DATE => p_l_SERVICE_START_DATE ,
3261 p_SERVICE_END_DATE => p_l_SERVICE_END_DATE ,
3262 p_SERVICE_COTERMINATE_FLAG => p_l_SERVICE_COTERMINATE_FLAG ,
3263 p_UNIT_LIST_PERCENT => p_l_UNIT_LIST_PERCENT ,
3264 p_UNIT_SELLING_PERCENT => p_l_UNIT_SELLING_PERCENT ,
3265 p_UNIT_PERCENT_BASE_PRICE => p_l_UNIT_PERCENT_BASE_PRICE ,
3266 p_SERVICE_NUMBER => p_l_SERVICE_NUMBER ,
3267 p_SERVICE_PERIOD => p_l_SERVICE_PERIOD ,
3268 p_SHIPPABLE_FLAG => p_l_SHIPPABLE_FLAG ,
3269 p_MODEL_REMNANT_FLAG => p_l_MODEL_REMNANT_FLAG ,
3270 p_RE_SOURCE_FLAG => p_l_RE_SOURCE_FLAG ,
3271 p_FLOW_STATUS_CODE => p_l_FLOW_STATUS_CODE ,
3272 p_TP_CONTEXT => p_l_TP_CONTEXT ,
3273 p_TP_ATTRIBUTE1 => p_l_TP_ATTRIBUTE1 ,
3274 p_TP_ATTRIBUTE2 => p_l_TP_ATTRIBUTE2 ,
3275 p_TP_ATTRIBUTE3 => p_l_TP_ATTRIBUTE3 ,
3276 p_TP_ATTRIBUTE4 => p_l_TP_ATTRIBUTE4 ,
3277 p_TP_ATTRIBUTE5 => p_l_TP_ATTRIBUTE5 ,
3278 p_TP_ATTRIBUTE6 => p_l_TP_ATTRIBUTE6 ,
3279 p_TP_ATTRIBUTE7 => p_l_TP_ATTRIBUTE7 ,
3280 p_TP_ATTRIBUTE8 => p_l_TP_ATTRIBUTE8 ,
3281 p_TP_ATTRIBUTE9 => p_l_TP_ATTRIBUTE9 ,
3282 p_TP_ATTRIBUTE10 => p_l_TP_ATTRIBUTE10 ,
3283 p_TP_ATTRIBUTE11 => p_l_TP_ATTRIBUTE11 ,
3284 p_TP_ATTRIBUTE12 => p_l_TP_ATTRIBUTE12 ,
3285 p_TP_ATTRIBUTE13 => p_l_TP_ATTRIBUTE13 ,
3286 p_TP_ATTRIBUTE14 => p_l_TP_ATTRIBUTE14 ,
3287 p_TP_ATTRIBUTE15 => p_l_TP_ATTRIBUTE15 ,
3288 p_FULFILLMENT_METHOD_CODE => p_l_FULFILLMENT_METHOD_CODE ,
3289 p_MARKETING_SOURCE_CODE_ID => p_l_MARKETING_SOURCE_CODE_ID ,
3290 p_SERVICE_REF_TYPE_CODE => p_l_SERVICE_REF_TYPE_CODE ,
3291 p_SERVICE_REFERENCE_LINE_ID => p_l_SERVICE_REFERENCE_LINE_ID ,
3292 p_SERVICE_REF_SYSTEM_ID => p_l_SERVICE_REF_SYSTEM_ID ,
3293 p_CALCULATE_PRICE_FLAG => p_l_CALCULATE_PRICE_FLAG ,
3294 p_UPGRADED_FLAG => p_l_UPGRADED_FLAG ,
3295 p_REVENUE_AMOUNT => p_l_REVENUE_AMOUNT ,
3296 p_FULFILLMENT_DATE => p_l_FULFILLMENT_DATE ,
3297 p_PREFERRED_GRADE => p_l_PREFERRED_GRADE ,
3298 p_ORDERED_QUANTITY2 => p_l_ORDERED_QUANTITY2 ,
3299 p_ORDERED_QUANTITY_UOM2 => p_l_ORDERED_QUANTITY_UOM2 ,
3300 p_SHIPPING_QUANTITY2 => p_l_SHIPPING_QUANTITY2 ,
3301 p_CANCELLED_QUANTITY2 => p_l_CANCELLED_QUANTITY2 ,
3302 p_SHIPPED_QUANTITY2 => p_l_SHIPPED_QUANTITY2 ,
3303 p_SHIPPING_QUANTITY_UOM2 => p_l_SHIPPING_QUANTITY_UOM2 ,
3304 p_FULFILLED_QUANTITY2 => p_l_FULFILLED_QUANTITY2 ,
3305 p_MFG_LEAD_TIME => p_l_MFG_LEAD_TIME ,
3306 p_LOCK_CONTROL => p_l_LOCK_CONTROL ,
3307 p_SUBINVENTORY => p_l_SUBINVENTORY ,
3308 p_UNIT_LIST_PRICE_PER_PQTY => p_l_UNIT_LIST_PRICE_PER_PQTY ,
3309 p_UNIT_SELL_PRICE_PER_PQTY => p_l_UNIT_SELL_PRICE_PER_PQTY ,
3310 p_PRICE_REQUEST_CODE => p_l_PRICE_REQUEST_CODE ,
3311 p_ORIGINAL_INVENTORY_ITEM_ID => p_l_ORIGINAL_INVENTORY_ITEM_ID ,
3312 p_ORIGINAL_ORDERED_ITEM_ID => p_l_ORIGINAL_ORDERED_ITEM_ID ,
3313 p_ORIGINAL_ORDERED_ITEM => p_l_ORIGINAL_ORDERED_ITEM ,
3314 p_ORIGINAL_ITEM_IDENTIF_TYPE => p_l_ORIGINAL_ITEM_IDENTIF_TYPE ,
3315 p_ITEM_SUBSTIT_TYPE_CODE => p_l_ITEM_SUBSTIT_TYPE_CODE ,
3316 p_OVERRIDE_ATP_DATE_CODE => p_l_OVERRIDE_ATP_DATE_CODE ,
3317 p_LATE_DEMAND_PENALTY_FACTOR => p_l_LATE_DEMAND_PENALTY_FACTOR ,
3318 p_ACCOUNTING_RULE_DURATION => p_l_ACCOUNTING_RULE_DURATION ,
3319 p_top_model_line_index => p_l_top_model_line_index ,
3320 p_top_model_line_ref => p_l_top_model_line_ref ,
3321 p_unit_cost => p_l_unit_cost ,
3322 p_xml_transaction_type_code => p_l_xml_transaction_type_code ,
3323 p_Sold_to_address_id => p_l_Sold_to_address_id ,
3324 p_Split_Action_Code => p_l_Split_Action_Code ,
3325 p_split_from_line_ref => p_l_split_from_line_ref ,
3326 p_split_from_shipment_ref => p_l_split_from_shipment_ref ,
3327 p_status_flag => p_l_status_flag ,
3328 p_ship_from_edi_loc_code => p_l_ship_from_edi_loc_code ,
3329 p_ship_set => p_l_ship_set ,
3330 p_Ship_to_address_code => p_l_Ship_to_address_code ,
3331 p_Ship_to_address_id => p_l_Ship_to_address_id ,
3332 p_ship_to_customer_id => p_l_ship_to_customer_id ,
3333 p_ship_to_edi_location_code => p_l_ship_to_edi_location_code ,
3334 p_service_ref_line_number => p_l_service_ref_line_number ,
3335 p_service_ref_option_number => p_l_service_ref_option_number ,
3336 p_service_ref_order_number => p_l_service_ref_order_number ,
3337 p_service_ref_ship_number => p_l_service_ref_ship_number ,
3338 p_service_reference_line => p_l_service_reference_line ,
3339 p_service_reference_order => p_l_service_reference_order ,
3340 p_service_reference_system => p_l_service_reference_system ,
3341 p_reserved_quantity => p_l_reserved_quantity ,
3342 p_return_status => p_l_return_status ,
3343 p_schedule_action_code => p_l_schedule_action_code ,
3344 p_service_line_index => p_l_service_line_index ,
3345 p_intermed_ship_to_cont_id => p_l_intermed_ship_to_cont_id ,
3346 p_intermed_ship_to_org_id => p_l_intermed_ship_to_org_id ,
3347 p_Invoice_address_id => p_l_Invoice_address_id ,
3348 p_invoice_to_customer_id => p_l_invoice_to_customer_id ,
3349 p_item_relationship_type => p_l_item_relationship_type ,
3350 p_link_to_line_index => p_l_link_to_line_index ,
3351 p_link_to_line_ref => p_l_link_to_line_ref ,
3352 p_db_flag => p_l_db_flag ,
3353 p_deliver_to_customer_id => p_l_deliver_to_customer_id ,
3354 p_fulfillment_set => p_l_fulfillment_set ,
3355 p_fulfillment_set_id => p_l_fulfillment_set_id ,
3356 p_change_comments => p_l_change_comments ,
3357 p_change_reason => p_l_change_reason ,
3358 p_change_request_code => p_l_change_request_code ,
3359 p_Bill_to_Edi_Location_Code => p_l_Bill_to_Edi_Location_Code ,
3360 p_Blanket_Line_Number => p_l_Blanket_Line_Number ,
3361 p_Blanket_Number => p_l_Blanket_Number ,
3362 p_Blanket_Version_Number => p_l_Blanket_Version_Number ,
3363 p_arrival_set => p_l_arrival_set ,
3364 p_attribute16 => p_l_attribute16 ,
3365 p_attribute17 => p_l_attribute17 ,
3366 p_attribute18 => p_l_attribute18 ,
3367 p_attribute19 => p_l_attribute19 ,
3368 p_attribute20 => p_l_attribute20
3369
3370 );
3371
3372 -- CALLING SAVE() API
3373
3374 IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3375 IBE_Util.Debug('In Returns SaveWrapper - B4 calling order_pvt' || p_c_CHKCONSTRAINT_FLAG);
3376 END IF;
3377
3378
3379 IF (p_c_CHKCONSTRAINT_FLAG = 'Y') THEN
3380 IBE_Order_Save_Pvt.CheckConstraint
3381 (
3382 p_api_version_number => p_api_version_number
3383 ,p_init_msg_list => p_init_msg_list
3384 ,p_commit => p_commit
3385 ,p_order_header_rec => l_order_header_rec
3386 ,p_order_line_tbl => l_order_line_tbl
3387 ,p_submit_control_rec => l_ctrl_rec
3388 ,p_party_id => p_party_id
3389 ,x_return_status => x_return_status
3390 ,x_msg_count => x_msg_count
3391 ,x_msg_data => x_msg_data
3392 ,x_error_lineids => x_error_lineids
3393 ,x_last_update_date => x_last_update_date
3394 );
3395 ELSE
3396
3397 IBE_Order_Save_PVT.Save(
3398 p_api_version_number => p_api_version_number
3399 ,p_init_msg_list => p_init_msg_list
3400 ,p_commit => p_commit
3401 ,p_order_header_rec => l_order_header_rec
3402 ,p_order_line_tbl => l_order_line_tbl
3403 ,p_submit_control_rec => l_ctrl_rec
3404 ,p_save_type => p_save_type
3405 ,p_party_id => p_party_id
3406 ,p_shipto_partysite_id => p_shipto_partysite_id
3407 ,p_billto_partysite_id => p_billto_partysite_id
3408 ,x_return_status => x_return_status
3409 ,x_msg_count => x_msg_count
3410 ,x_msg_data => x_msg_data
3411 ,x_order_header_id => x_order_header_id
3412 ,x_order_number => x_order_number
3413 ,x_flow_status_code => x_flow_status_code
3414 ,x_last_update_date => x_last_update_date
3415 ,X_failed_line_ids => X_failed_line_ids --3272918
3416 );
3417
3418 END IF;
3419
3420 IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3421 IBE_Util.Debug('In Returns SaveWrapper package body - End');
3422 END IF;
3423
3424 END SaveWrapper;
3425
3426 END IBE_Order_W1_PVT;