[Home] [Help]
PACKAGE BODY: APPS.OE_LINE_UTIL_EXT
Source
1 PACKAGE BODY OE_Line_Util_Ext AS
2 /* $Header: OEXULXTB.pls 120.4 2006/04/17 03:45:25 pviprana noship $ */
3
4 -- Global constant holding the package name
5
6 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Line_Util_Ext';
7
8 -- LOCAL Procedures
9 -- Clear_Dependents
10
11 -- 13-DEC-2001:
12 -- Introduced new OUT parameter x_dep_attr_exists. This parameter
13 -- is set to 'Y' if at least one dependent attribute is set to missing
14 -- in this procedure.
15 PROCEDURE Clear_Dependents
16 (p_src_attr_tbl IN OE_GLOBALS.NUMBER_Tbl_Type
17 ,p_initial_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
18 ,p_old_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
19 ,p_x_line_rec IN OUT NOCOPY OE_AK_ORDER_LINES_V%ROWTYPE
20 ,x_dep_attr_exists OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
21 IS
22 l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
23
24 PROCEDURE ACCOUNTING_RULE IS
25 BEGIN
26 IF (p_initial_line_rec.ACCOUNTING_RULE_ID = FND_API.G_MISS_NUM OR
27 (OE_GLOBAlS.Equal(p_initial_line_rec.ACCOUNTING_RULE_ID, p_old_line_rec.ACCOUNTING_RULE_ID)
28 AND
29 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.ACCOUNTING_RULE_ID IS NOT NULL))
30 ) -- the AND condition above added to fix 3098878
31 THEN
32 p_x_line_rec.ACCOUNTING_RULE_ID := FND_API.G_MISS_NUM;
33 x_dep_attr_exists := 'Y';
34 END IF;
35 END ACCOUNTING_RULE;
36
37 PROCEDURE ACCOUNTING_RULE_DURATION IS
38 BEGIN
39 IF (p_initial_line_rec.ACCOUNTING_RULE_DURATION = FND_API.G_MISS_NUM OR
40 (OE_GLOBAlS.Equal(p_initial_line_rec.ACCOUNTING_RULE_DURATION, p_old_line_rec.ACCOUNTING_RULE_DURATION)
41 AND
42 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.ACCOUNTING_RULE_DURATION IS NOT NULL))
43 ) -- the AND condition above added to fix 3098878
44 THEN
45 p_x_line_rec.ACCOUNTING_RULE_DURATION := FND_API.G_MISS_NUM;
46 x_dep_attr_exists := 'Y';
47 END IF;
48 END ACCOUNTING_RULE_DURATION;
49
50 PROCEDURE AGREEMENT IS
51 BEGIN
52 IF (p_initial_line_rec.AGREEMENT_ID = FND_API.G_MISS_NUM OR
53 (OE_GLOBAlS.Equal(p_initial_line_rec.AGREEMENT_ID, p_old_line_rec.AGREEMENT_ID)
54 AND
55 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.AGREEMENT_ID IS NOT NULL))
56 ) -- the AND condition above added to fix 3098878
57 THEN
58 p_x_line_rec.AGREEMENT_ID := FND_API.G_MISS_NUM;
59 x_dep_attr_exists := 'Y';
60 END IF;
61 END AGREEMENT;
62
63 PROCEDURE ATO_LINE IS
64 BEGIN
65 IF (p_initial_line_rec.ATO_LINE_ID = FND_API.G_MISS_NUM OR
66 (OE_GLOBAlS.Equal(p_initial_line_rec.ATO_LINE_ID, p_old_line_rec.ATO_LINE_ID)
67 AND
68 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.ATO_LINE_ID IS NOT NULL))
69 ) -- the AND condition above added to fix 3098878
70 THEN
71 p_x_line_rec.ATO_LINE_ID := FND_API.G_MISS_NUM;
72 x_dep_attr_exists := 'Y';
73 END IF;
74 END ATO_LINE;
75
76 -- For bug 3571400
77 PROCEDURE BLANKET_NUMBER IS
78 BEGIN
79 IF (p_initial_line_rec.blanket_number = FND_API.G_MISS_NUM OR
80 (OE_GLOBAlS.Equal(p_initial_line_rec.blanket_number, p_old_line_rec.blanket_number)
81 AND
82 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.blanket_number IS NOT NULL))
83 )
84 THEN
85 p_x_line_rec.blanket_number := FND_API.G_MISS_NUM;
86 x_dep_attr_exists := 'Y';
87 END IF;
88 END BLANKET_NUMBER;
89
90 PROCEDURE BLANKET_LINE_NUMBER IS
91 BEGIN
92 IF (p_initial_line_rec.blanket_line_number = FND_API.G_MISS_NUM OR
93 (OE_GLOBAlS.Equal(p_initial_line_rec.blanket_line_number, p_old_line_rec.blanket_line_number)
94 AND
95 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.blanket_line_number IS NOT NULL))
96 ) -- the AND condition above added to fix 3098878
97 THEN
98 p_x_line_rec.blanket_line_number := FND_API.G_MISS_NUM;
99 x_dep_attr_exists := 'Y';
100 END IF;
101 END BLANKET_LINE_NUMBER;
102
103 PROCEDURE BLANKET_VERSION_NUMBER IS
104 BEGIN
105 IF (p_initial_line_rec.blanket_version_number = FND_API.G_MISS_NUM OR
106 (OE_GLOBAlS.Equal(p_initial_line_rec.blanket_version_number, p_old_line_rec.blanket_version_number)
107 AND
108 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.blanket_version_number IS NOT NULL))
109 ) -- the AND condition above added to fix 3098878
110 THEN
111 p_x_line_rec.blanket_version_number := FND_API.G_MISS_NUM;
112 x_dep_attr_exists := 'Y';
113
114 END IF;
115 END BLANKET_VERSION_NUMBER;
116
117 PROCEDURE COMMITMENT IS
118 BEGIN
119 IF (p_initial_line_rec.COMMITMENT_ID = FND_API.G_MISS_NUM OR
120 (OE_GLOBAlS.Equal(p_initial_line_rec.COMMITMENT_ID, p_old_line_rec.COMMITMENT_ID)
121 AND
122 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.COMMITMENT_ID IS NOT NULL))
123 ) -- the AND condition above added to fix 3098878
124 THEN
125 p_x_line_rec.COMMITMENT_ID := FND_API.G_MISS_NUM;
126 x_dep_attr_exists := 'Y';
127 END IF;
128 END COMMITMENT;
129
130
131 PROCEDURE COMPONENT IS
132 BEGIN
133 IF (p_initial_line_rec.COMPONENT_CODE = FND_API.G_MISS_CHAR OR
134 (OE_GLOBAlS.Equal(p_initial_line_rec.COMPONENT_CODE, p_old_line_rec.COMPONENT_CODE)
135 AND
136 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.COMPONENT_CODE IS NOT NULL))
137 ) -- the AND condition above added to fix 3098878
138 THEN
139 p_x_line_rec.COMPONENT_CODE := FND_API.G_MISS_CHAR;
140 x_dep_attr_exists := 'Y';
141 END IF;
142 END COMPONENT;
143
144
145 PROCEDURE COMPONENT_SEQUENCE IS
146 BEGIN
147 IF (p_initial_line_rec.COMPONENT_SEQUENCE_ID = FND_API.G_MISS_NUM OR
148 (OE_GLOBALS.Equal(p_initial_line_rec.COMPONENT_SEQUENCE_ID, p_old_line_rec.COMPONENT_SEQUENCE_ID)
149 AND
150 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.COMPONENT_SEQUENCE_ID IS NOT NULL))
151 ) -- the AND condition above added to fix 3098878
152 THEN
153 p_x_line_rec.COMPONENT_SEQUENCE_ID := FND_API.G_MISS_NUM;
154 x_dep_attr_exists := 'Y';
155 END IF;
156 END COMPONENT_SEQUENCE;
157
158
159 PROCEDURE SORT_ORDER IS
160 BEGIN
161 IF (p_initial_line_rec.SORT_ORDER = FND_API.G_MISS_CHAR OR
162 (OE_GLOBAlS.Equal(p_initial_line_rec.SORT_ORDER, p_old_line_rec.SORT_ORDER)
163 AND
164 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SORT_ORDER IS NOT NULL))
165 ) -- the AND condition above added to fix 3098878
166 THEN
167 p_x_line_rec.SORT_ORDER := FND_API.G_MISS_CHAR;
168 x_dep_attr_exists := 'Y';
169 END IF;
170 END SORT_ORDER;
171
172
173 PROCEDURE SOURCE_TYPE IS
174 BEGIN
175 IF (p_initial_line_rec.SOURCE_TYPE_CODE = FND_API.G_MISS_CHAR OR
176 (OE_GLOBALS.Equal(p_initial_line_rec.SOURCE_TYPE_CODE, p_old_line_rec.SOURCE_TYPE_CODE)
177 AND
178 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SOURCE_TYPE_CODE IS NOT NULL))
179 ) -- the AND condition above added to fix 3098878
180 THEN
181 -- ER: 1840556 - do not clear source type if this is a scheduling
182 -- recursive call. Any updates due to scheduling (warehouse or item
183 -- in case of item substitution) should not result in a change to
184 -- the source type.
185
186 --Bug4504362
187
188 IF OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING = 'N' THEN
189 RETURN;
190 END IF;
191
192 p_x_line_rec.SOURCE_TYPE_CODE := FND_API.G_MISS_CHAR;
193 x_dep_attr_exists := 'Y';
194 END IF;
195 END SOURCE_TYPE;
196
197 PROCEDURE CUST_PO_NUMBER IS
198 BEGIN
199 IF (p_initial_line_rec.CUST_PO_NUMBER = FND_API.G_MISS_CHAR OR
200 (OE_GLOBALS.Equal(p_initial_line_rec.CUST_PO_NUMBER, p_old_line_rec.CUST_PO_NUMBER)
201 AND
202 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.CUST_PO_NUMBER IS NOT NULL))
203 ) -- the AND condition above added to fix 3098878
204 THEN
205 p_x_line_rec.CUST_PO_NUMBER := FND_API.G_MISS_CHAR;
206 x_dep_attr_exists := 'Y';
207 END IF;
208 END CUST_PO_NUMBER;
209
210 PROCEDURE CUSTOMER_LINE_NUMBER IS --For bug 2844285
211 BEGIN
212 IF (p_initial_line_rec.CUSTOMER_LINE_NUMBER = FND_API.G_MISS_CHAR OR
213 (OE_GLOBALS.Equal(p_initial_line_rec.CUSTOMER_LINE_NUMBER, p_old_line_rec.CUSTOMER_LINE_NUMBER)
214 AND
215 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.CUSTOMER_LINE_NUMBER IS NOT NULL))
216 ) -- the AND condition above added to fix 3098878
217 THEN
218 p_x_line_rec.CUSTOMER_LINE_NUMBER := FND_API.G_MISS_CHAR;
219 x_dep_attr_exists := 'Y';
220 END IF;
221 END CUSTOMER_LINE_NUMBER;
222
223 PROCEDURE DELIVER_TO_CONTACT IS
224 BEGIN
225 IF (p_initial_line_rec.DELIVER_TO_CONTACT_ID = FND_API.G_MISS_NUM OR
226 (OE_GLOBALS.Equal(p_initial_line_rec.DELIVER_TO_CONTACT_ID, p_old_line_rec.DELIVER_TO_CONTACT_ID)
227 AND
228 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.DELIVER_TO_CONTACT_ID IS NOT NULL))
229 ) -- the AND condition above added to fix 3098878
230 THEN
231 IF p_x_line_rec.reference_line_id IS NOT NULL AND
232 p_x_line_rec.reference_line_id <> FND_API.G_MISS_NUM AND
233 p_x_line_rec.line_category_code = 'RETURN'
234 THEN
235 NULL;
236 ELSE
237 p_x_line_rec.DELIVER_TO_CONTACT_ID := FND_API.G_MISS_NUM;
238 x_dep_attr_exists := 'Y';
239 END IF;
240 END IF;
241 END DELIVER_TO_CONTACT;
242
243 PROCEDURE DELIVER_TO_ORG IS
244 BEGIN
245 IF (p_initial_line_rec.DELIVER_TO_ORG_ID = FND_API.G_MISS_NUM OR
246 (OE_GLOBALS.Equal(p_initial_line_rec.DELIVER_TO_ORG_ID, p_old_line_rec.DELIVER_TO_ORG_ID)
247 AND
248 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.DELIVER_TO_ORG_ID IS NOT NULL))
249 ) -- the AND condition above added to fix 3098878
250 THEN
251 IF p_x_line_rec.reference_line_id IS NOT NULL AND
252 p_x_line_rec.reference_line_id <> FND_API.G_MISS_NUM AND
253 p_x_line_rec.line_category_code = 'RETURN'
254 THEN
255 NULL;
256 ELSE
257 p_x_line_rec.DELIVER_TO_ORG_ID := FND_API.G_MISS_NUM;
258 x_dep_attr_exists := 'Y';
259 END IF;
260 END IF;
261 END DELIVER_TO_ORG;
262
263 PROCEDURE DEMAND_CLASS IS
264 BEGIN
265 IF (p_initial_line_rec.DEMAND_CLASS_CODE = FND_API.G_MISS_CHAR OR
266 (OE_GLOBALS.Equal(p_initial_line_rec.DEMAND_CLASS_CODE, p_old_line_rec.DEMAND_CLASS_CODE)
267 AND
268 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.DEMAND_CLASS_CODE IS NOT NULL))
269 ) -- the AND condition above added to fix 3098878
270 THEN
271 p_x_line_rec.DEMAND_CLASS_CODE := FND_API.G_MISS_CHAR;
272 x_dep_attr_exists := 'Y';
273 END IF;
274 END DEMAND_CLASS;
275
276 PROCEDURE DEP_PLAN_REQUIRED IS
277 BEGIN
278 IF (p_initial_line_rec.DEP_PLAN_REQUIRED_FLAG = FND_API.G_MISS_CHAR OR
279 (OE_GLOBALS.Equal(p_initial_line_rec.DEP_PLAN_REQUIRED_FLAG, p_old_line_rec.DEP_PLAN_REQUIRED_FLAG)
280 AND
281 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.DEP_PLAN_REQUIRED_FLAG IS NOT NULL))
282 ) -- the AND condition above added to fix 3098878
283 THEN
284 p_x_line_rec.DEP_PLAN_REQUIRED_FLAG := FND_API.G_MISS_CHAR;
285 x_dep_attr_exists := 'Y';
286 END IF;
287 END DEP_PLAN_REQUIRED;
288
289 PROCEDURE END_ITEM_UNIT_NUMBER IS
290 BEGIN
291 IF (p_initial_line_rec.END_ITEM_UNIT_NUMBER = FND_API.G_MISS_CHAR OR
292 (OE_GLOBALS.Equal(p_initial_line_rec.END_ITEM_UNIT_NUMBER, p_old_line_rec.END_ITEM_UNIT_NUMBER)
293 AND
294 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.END_ITEM_UNIT_NUMBER IS NOT NULL))
295 ) -- the AND condition above added to fix 3098878
296 THEN
297 p_x_line_rec.END_ITEM_UNIT_NUMBER := FND_API.G_MISS_CHAR;
298 x_dep_attr_exists := 'Y';
299 END IF;
300 END END_ITEM_UNIT_NUMBER;
301
302 PROCEDURE FOB_POINT IS
303 BEGIN
304 IF (p_initial_line_rec.FOB_POINT_CODE = FND_API.G_MISS_CHAR OR
305 (OE_GLOBALS.Equal(p_initial_line_rec.FOB_POINT_CODE, p_old_line_rec.FOB_POINT_CODE)
306 AND
307 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.FOB_POINT_CODE IS NOT NULL))
308 ) -- the AND condition above added to fix 3098878
309 THEN
310 p_x_line_rec.FOB_POINT_CODE := FND_API.G_MISS_CHAR;
311 x_dep_attr_exists := 'Y';
312 END IF;
313 END FOB_POINT;
314
315 PROCEDURE FREIGHT_TERMS IS
316 BEGIN
317 IF (p_initial_line_rec.FREIGHT_TERMS_CODE = FND_API.G_MISS_CHAR OR
318 (OE_GLOBALS.Equal(p_initial_line_rec.FREIGHT_TERMS_CODE, p_old_line_rec.FREIGHT_TERMS_CODE)
319 AND
320 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.FREIGHT_TERMS_CODE IS NOT NULL))
321 ) -- the AND condition above added to fix 3098878
322 THEN
323 p_x_line_rec.FREIGHT_TERMS_CODE := FND_API.G_MISS_CHAR;
324 x_dep_attr_exists := 'Y';
325 END IF;
326 END FREIGHT_TERMS;
327
328 PROCEDURE INTERMED_SHIP_TO_CONTACT IS
329 BEGIN
330 IF (p_initial_line_rec.INTERMED_SHIP_TO_CONTACT_ID = FND_API.G_MISS_NUM OR
331 (OE_GLOBALS.Equal(p_initial_line_rec.INTERMED_SHIP_TO_CONTACT_ID, p_old_line_rec.INTERMED_SHIP_TO_CONTACT_ID)
332 AND
333 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.INTERMED_SHIP_TO_CONTACT_ID IS NOT NULL))
334 ) -- the AND condition above added to fix 3098878
335 THEN
336 p_x_line_rec.INTERMED_SHIP_TO_CONTACT_ID := FND_API.G_MISS_NUM;
337 x_dep_attr_exists := 'Y';
338 END IF;
339 END INTERMED_SHIP_TO_CONTACT;
340
341 PROCEDURE INTERMED_SHIP_TO_ORG IS
342 BEGIN
343 IF (p_initial_line_rec.INTERMED_SHIP_TO_ORG_ID = FND_API.G_MISS_NUM OR
344 (OE_GLOBALS.Equal(p_initial_line_rec.INTERMED_SHIP_TO_ORG_ID, p_old_line_rec.INTERMED_SHIP_TO_ORG_ID)
345 AND
346 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.INTERMED_SHIP_TO_ORG_ID IS NOT NULL))
347 ) -- the AND condition above added to fix 3098878
348 THEN
349 p_x_line_rec.INTERMED_SHIP_TO_ORG_ID := FND_API.G_MISS_NUM;
350 x_dep_attr_exists := 'Y';
351 END IF;
352 END INTERMED_SHIP_TO_ORG;
353
354 PROCEDURE INVOICE_TO_CONTACT IS
355 BEGIN
356 IF (p_initial_line_rec.INVOICE_TO_CONTACT_ID = FND_API.G_MISS_NUM OR
357 (OE_GLOBALS.Equal(p_initial_line_rec.INVOICE_TO_CONTACT_ID, p_old_line_rec.INVOICE_TO_CONTACT_ID)
358 AND
359 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.INVOICE_TO_CONTACT_ID IS NOT NULL))
360 ) -- the AND condition above added to fix 3098878
361 THEN
362 IF p_x_line_rec.reference_line_id IS NOT NULL AND
363 p_x_line_rec.reference_line_id <> FND_API.G_MISS_NUM AND
364 p_x_line_rec.line_category_code = 'RETURN'
365 THEN
366 NULL;
367 ELSE
368 p_x_line_rec.INVOICE_TO_CONTACT_ID := FND_API.G_MISS_NUM;
369 x_dep_attr_exists := 'Y';
370 END IF;
371 END IF;
372 END INVOICE_TO_CONTACT;
373
374 PROCEDURE INVOICE_TO_ORG IS
375 BEGIN
376 IF (p_initial_line_rec.INVOICE_TO_ORG_ID = FND_API.G_MISS_NUM OR
377 (OE_GLOBALS.Equal(p_initial_line_rec.INVOICE_TO_ORG_ID, p_old_line_rec.INVOICE_TO_ORG_ID)
378 AND
379 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.INVOICE_TO_ORG_ID IS NOT NULL))
380 ) -- the AND condition above added to fix 3098878
381 THEN
382 IF p_x_line_rec.reference_line_id IS NOT NULL AND
383 p_x_line_rec.reference_line_id <> FND_API.G_MISS_NUM AND
384 p_x_line_rec.line_category_code = 'RETURN'
385 THEN
386 NULL;
387 ELSE
388 p_x_line_rec.INVOICE_TO_ORG_ID := FND_API.G_MISS_NUM;
389 x_dep_attr_exists := 'Y';
390 END IF;
391 END IF;
392 END INVOICE_TO_ORG;
393
394 PROCEDURE INVOICING_RULE IS
395 BEGIN
396 IF (p_initial_line_rec.INVOICING_RULE_ID = FND_API.G_MISS_NUM OR
397 (OE_GLOBALS.Equal(p_initial_line_rec.INVOICING_RULE_ID, p_old_line_rec.INVOICING_RULE_ID)
398 AND
399 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.INVOICING_RULE_ID IS NOT NULL))
400 ) -- the AND condition above added to fix 3098878
401 THEN
402 p_x_line_rec.INVOICING_RULE_ID := FND_API.G_MISS_NUM;
403 x_dep_attr_exists := 'Y';
404 END IF;
405 END INVOICING_RULE;
406
407 PROCEDURE ITEM_IDENTIFIER_TYPE IS
408 BEGIN
409 IF (p_initial_line_rec.ITEM_IDENTIFIER_TYPE = FND_API.G_MISS_CHAR OR
410 (OE_GLOBAlS.Equal(p_initial_line_rec.ITEM_IDENTIFIER_TYPE, p_old_line_rec.ITEM_IDENTIFIER_TYPE)
411 AND
412 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.ITEM_IDENTIFIER_TYPE IS NOT NULL))
413 ) -- the AND condition above added to fix 3098878
414 THEN
415 IF p_x_line_rec.reference_line_id IS NOT NULL AND
416 p_x_line_rec.reference_line_id <> FND_API.G_MISS_NUM AND
417 p_x_line_rec.line_category_code = 'RETURN'
418 THEN
419 NULL;
420 ELSE
421 p_x_line_rec.ITEM_IDENTIFIER_TYPE := FND_API.G_MISS_CHAR;
422 x_dep_attr_exists := 'Y';
423 END IF;
424 END IF;
425 END ITEM_IDENTIFIER_TYPE;
426
427 PROCEDURE ITEM_REVISION IS -- For bug 2951575
428 BEGIN
429 IF (p_initial_line_rec.ITEM_REVISION = FND_API.G_MISS_CHAR OR
430 (OE_GLOBAlS.Equal(p_initial_line_rec.ITEM_REVISION, p_old_line_rec.ITEM_REVISION)
431 AND
432 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.ITEM_REVISION IS NOT NULL))
433 ) -- the AND condition above added to fix 3098878
434 THEN
435 p_x_line_rec.ITEM_REVISION := FND_API.G_MISS_CHAR;
436 x_dep_attr_exists := 'Y';
437 END IF;
438 END ITEM_REVISION;
439
440 PROCEDURE ITEM_TYPE IS
441 BEGIN
442 IF (p_initial_line_rec.ITEM_TYPE_CODE = FND_API.G_MISS_CHAR OR
443 (OE_GLOBAlS.Equal(p_initial_line_rec.ITEM_TYPE_CODE, p_old_line_rec.ITEM_TYPE_CODE)
444 AND
445 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.ITEM_TYPE_CODE IS NOT NULL))
446 ) -- the AND condition above added to fix 3098878
447 THEN
448 IF p_x_line_rec.reference_line_id IS NOT NULL AND
449 p_x_line_rec.reference_line_id <> FND_API.G_MISS_NUM AND
450 p_x_line_rec.line_category_code = 'RETURN'
451 THEN
452 NULL;
453 ELSE
454 p_x_line_rec.ITEM_TYPE_CODE := FND_API.G_MISS_CHAR;
455 x_dep_attr_exists := 'Y';
456 END IF;
457 END IF;
458 END ITEM_TYPE;
459
460 PROCEDURE LINE_TYPE IS
461 BEGIN
462 IF (p_initial_line_rec.LINE_TYPE_ID = FND_API.G_MISS_NUM OR
463 (OE_GLOBALS.Equal(p_initial_line_rec.LINE_TYPE_ID, p_old_line_rec.LINE_TYPE_ID)
464 AND
465 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.LINE_TYPE_ID IS NOT NULL))
466 ) -- the AND condition above added to fix 3098878
467 THEN
468 p_x_line_rec.LINE_TYPE_ID := FND_API.G_MISS_NUM;
469 x_dep_attr_exists := 'Y';
470 END IF;
471 END LINE_TYPE;
472
473 PROCEDURE LINE_CATEGORY IS
474 BEGIN
475 IF (p_initial_line_rec.LINE_CATEGORY_CODE = FND_API.G_MISS_CHAR OR
476 (OE_GLOBAlS.Equal(p_initial_line_rec.LINE_CATEGORY_CODE, p_old_line_rec.LINE_CATEGORY_CODE)
477 AND
478 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.LINE_CATEGORY_CODE IS NOT NULL))
479 ) -- the AND condition above added to fix 3098878
480 THEN
481 p_x_line_rec.LINE_CATEGORY_CODE := FND_API.G_MISS_CHAR;
482 x_dep_attr_exists := 'Y';
483 END IF;
484 END LINE_CATEGORY;
485
486
487 PROCEDURE OPTION_NUMBER IS
488 BEGIN
489 IF (p_initial_line_rec.OPTION_NUMBER = FND_API.G_MISS_NUM OR
490 (OE_GLOBALS.Equal(p_initial_line_rec.OPTION_NUMBER, p_old_line_rec.OPTION_NUMBER)
491 AND
492 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.OPTION_NUMBER IS NOT NULL))
493 ) -- the AND condition above added to fix 3098878
494 THEN
495 p_x_line_rec.OPTION_NUMBER := FND_API.G_MISS_NUM;
496 x_dep_attr_exists := 'Y';
497 END IF;
498 END OPTION_NUMBER;
499
500 PROCEDURE ORDERED_ITEM IS
501 BEGIN
502 IF (p_initial_line_rec.ORDERED_ITEM_ID = FND_API.G_MISS_NUM OR
503 (OE_GLOBALS.Equal(p_initial_line_rec.ORDERED_ITEM_ID, p_old_line_rec.ORDERED_ITEM_ID)
504 AND
505 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.ORDERED_ITEM_ID IS NOT NULL))
506 ) -- the AND condition above added to fix 3098878
507 THEN
508 IF p_x_line_rec.reference_line_id IS NOT NULL AND
509 p_x_line_rec.reference_line_id <> FND_API.G_MISS_NUM AND
510 p_x_line_rec.line_category_code = 'RETURN'
511 THEN
512 NULL;
513 ELSE
514 p_x_line_rec.ORDERED_ITEM_ID := FND_API.G_MISS_NUM;
515 x_dep_attr_exists := 'Y';
516 END IF;
517 END IF;
518 END ORDERED_ITEM;
519
520 PROCEDURE ORDER_QUANTITY_UOM IS
521 BEGIN
522 IF (p_initial_line_rec.ORDER_QUANTITY_UOM = FND_API.G_MISS_CHAR OR
523 (OE_GLOBAlS.Equal(p_initial_line_rec.ORDER_QUANTITY_UOM, p_old_line_rec.ORDER_QUANTITY_UOM)
524 AND
525 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.ORDER_QUANTITY_UOM IS NOT NULL))
526 ) -- the AND condition above added to fix 3098878
527 THEN
528 IF p_x_line_rec.reference_line_id IS NOT NULL AND
529 p_x_line_rec.reference_line_id <> FND_API.G_MISS_NUM AND
530 p_x_line_rec.line_category_code = 'RETURN'
531 THEN
532 NULL;
533 ELSE
534 -- do not clear uom if this is a scheduling
535 -- recursive call. Any updates due to scheduling (warehouse or item
536 -- in case of item substitution) should not result in a change to
537 -- the uom.
538
539 --4504362
540
541 IF OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING = 'N' THEN
542 RETURN;
543 END IF;
544
545 -- bug 2454963, do not clear for pricing call
546 IF (nvl(OE_GLOBALS.G_PRICING_RECURSION,'N') <> 'Y') THEN
547 p_x_line_rec.ORDER_QUANTITY_UOM := FND_API.G_MISS_CHAR;
548 END IF;
549 x_dep_attr_exists := 'Y';
550 END IF;
551 END IF;
552 END ORDER_QUANTITY_UOM;
553
554 /* OPM 02/JUN/00 BEGIN
555 =====================*/
556 PROCEDURE ORDERED_QUANTITY_UOM2 IS
557 BEGIN
558 IF (p_initial_line_rec.ORDERED_QUANTITY_UOM2 = FND_API.G_MISS_CHAR OR
559 (OE_GLOBAlS.Equal(p_initial_line_rec.ORDERED_QUANTITY_UOM2, p_old_line_rec.ORDERED_QUANTITY_UOM2)
560 AND
561 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.ORDERED_QUANTITY_UOM2 IS NOT NULL))
562 ) -- the AND condition above added to fix 3098878
563 THEN
564 IF p_x_line_rec.reference_line_id IS NOT NULL AND
565 p_x_line_rec.reference_line_id <> FND_API.G_MISS_NUM AND
566 p_x_line_rec.line_category_code = 'RETURN'
567 THEN
568 NULL;
569 ELSE
570 p_x_line_rec.ORDERED_QUANTITY_UOM2 := FND_API.G_MISS_CHAR;
571 x_dep_attr_exists := 'Y';
572 END IF;
573 END IF;
574 END ORDERED_QUANTITY_UOM2;
575 /* OPM 02/JUN/00 END
576 ===================*/
577
578 -- OPM Bug3016136
579 PROCEDURE ORDERED_QUANTITY2 IS
580 BEGIN
581 OE_DEBUG_PUB.add('OPM Procedure ordered_quantity2',1);
582 IF (p_initial_line_rec.ORDERED_QUANTITY2 = FND_API.G_MISS_NUM OR
583 (OE_GLOBALS.Equal(p_initial_line_rec.ORDERED_QUANTITY2, p_old_line_rec.ORDERED_QUANTITY2)
584 AND
585 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.ORDERED_QUANTITY2 IS NOT NULL))
586 ) -- the AND condition above added to fix 3098878
587 THEN
588 IF p_x_line_rec.reference_line_id IS NOT NULL AND
589 p_x_line_rec.reference_line_id <> FND_API.G_MISS_NUM AND
590 p_x_line_rec.line_category_code = 'RETURN'
591 THEN
592 NULL;
593 ELSE
594 p_x_line_rec.ORDERED_QUANTITY2 := FND_API.G_MISS_NUM;
595 x_dep_attr_exists := 'Y';
596 END IF;
597 END IF;
598 END ORDERED_QUANTITY2;
599 -- OPM End Bug3016136
600
601
602 PROCEDURE PAYMENT_TERM IS
603 BEGIN
604 IF (p_initial_line_rec.PAYMENT_TERM_ID = FND_API.G_MISS_NUM OR
605 (OE_GLOBALS.Equal(p_initial_line_rec.PAYMENT_TERM_ID, p_old_line_rec.PAYMENT_TERM_ID)
606 AND
607 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.PAYMENT_TERM_ID IS NOT NULL))
608 ) -- the AND condition above added to fix 3098878
609 THEN
610 p_x_line_rec.PAYMENT_TERM_ID := FND_API.G_MISS_NUM;
611 x_dep_attr_exists := 'Y';
612 END IF;
613 END PAYMENT_TERM;
614
615 /* OPM 02/JUN/00 BEGIN
616 =====================*/
617 PROCEDURE PREFERRED_GRADE IS
618 BEGIN
619 IF (p_initial_line_rec.PREFERRED_GRADE = FND_API.G_MISS_CHAR OR
620 (OE_GLOBAlS.Equal(p_initial_line_rec.PREFERRED_GRADE, p_old_line_rec.PREFERRED_GRADE)
621 AND
622 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.PREFERRED_GRADE IS NOT NULL))
623 ) -- the AND condition above added to fix 3098878
624 THEN
625 p_x_line_rec.PREFERRED_GRADE := FND_API.G_MISS_CHAR;
626 x_dep_attr_exists := 'Y';
627 END IF;
628 END PREFERRED_GRADE;
629 /* OPM 02/JUN/00 END
630 ===================*/
631
632 PROCEDURE PRICE_LIST IS
633 BEGIN
634 IF (p_initial_line_rec.PRICE_LIST_ID = FND_API.G_MISS_NUM OR
635 (OE_GLOBALS.Equal(p_initial_line_rec.PRICE_LIST_ID, p_old_line_rec.PRICE_LIST_ID)
636 AND
637 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.PRICE_LIST_ID IS NOT NULL))
638 ) -- the AND condition above added to fix 3098878
639 THEN
640 IF p_x_line_rec.reference_line_id IS NOT NULL AND
641 p_x_line_rec.reference_line_id <> FND_API.G_MISS_NUM AND
642 p_x_line_rec.line_category_code = 'RETURN'
643 THEN
644 NULL;
645 ELSE
646 --retro{For a retrobill line if price increases the line category and line_type are changed.
647 --This causes the price list also to be defaulted, but it shouldn't happen,
648 --So the following if with null for retrobill lines
649 IF( p_x_line_rec.retrobill_request_id is NOT NULL) THEN
650 oe_debug_pub.add('Retro:Pricelist not defaulted');
651 oe_debug_pub.add('Pricelist Id:'||p_x_line_rec.PRICE_LIST_ID);
652 Else
653 oe_debug_pub.add('Retro:Reseting price list to missnum');
654 p_x_line_rec.PRICE_LIST_ID := FND_API.G_MISS_NUM;
655 x_dep_attr_exists := 'Y';
656 END IF; --End of Retrobill check
657 END IF;
658 END IF;
659 END PRICE_LIST;
660
661 PROCEDURE PRICE_REQUEST_CODE IS -- PROMOTIONS SEP/01
662 BEGIN
663 IF (p_initial_line_rec.PRICE_REQUEST_CODE = FND_API.G_MISS_CHAR OR
664 (OE_GLOBAlS.Equal(p_initial_line_rec.PRICE_REQUEST_CODE, p_old_line_rec.PRICE_REQUEST_CODE)
665 AND
666 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.PRICE_REQUEST_CODE IS NOT NULL))
667 ) -- the AND condition above added to fix 3098878
668 THEN
669 p_x_line_rec.PRICE_REQUEST_CODE := FND_API.G_MISS_CHAR;
670 x_dep_attr_exists := 'Y';
671 END IF;
672 END PRICE_REQUEST_CODE;
673
674 PROCEDURE PRICING_QUANTITY_UOM IS
675 BEGIN
676 IF (p_initial_line_rec.PRICING_QUANTITY_UOM = FND_API.G_MISS_CHAR OR
677 (OE_GLOBAlS.Equal(p_initial_line_rec.PRICING_QUANTITY_UOM, p_old_line_rec.PRICING_QUANTITY_UOM)
678 AND
679 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.PRICING_QUANTITY_UOM IS NOT NULL))
680 ) -- the AND condition above added to fix 3098878
681 THEN
682
683 -- bug 2454963, do not clear for pricing call
684 IF (nvl(OE_GLOBALS.G_PRICING_RECURSION,'N') <> 'Y') THEN
685 p_x_line_rec.PRICING_QUANTITY_UOM := FND_API.G_MISS_CHAR;
686 END IF;
687 x_dep_attr_exists := 'Y';
688 END IF;
689 END PRICING_QUANTITY_UOM;
690
691 PROCEDURE PROMISE_DATE IS
692 BEGIN
693 IF (p_initial_line_rec.PROMISE_DATE = FND_API.G_MISS_DATE OR
694 (OE_GLOBALS.Equal(p_initial_line_rec.PROMISE_DATE, p_old_line_rec.PROMISE_DATE)
695 AND
696 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.PROMISE_DATE IS NOT NULL))
697 ) -- the AND condition above added to fix 3098878
698 THEN
699 p_x_line_rec.PROMISE_DATE := FND_API.G_MISS_DATE;
700 x_dep_attr_exists := 'Y';
701 END IF;
702 END PROMISE_DATE;
703
704 PROCEDURE REQUEST_DATE IS
705 BEGIN
706 IF (p_initial_line_rec.REQUEST_DATE = FND_API.G_MISS_DATE OR
707 (OE_GLOBALS.Equal(p_initial_line_rec.REQUEST_DATE, p_old_line_rec.REQUEST_DATE)
708 AND
709 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.REQUEST_DATE IS NOT NULL))
710 ) -- the AND condition above added to fix 3098878
711 THEN
712 -- Let us not clear request_date for an ATO option or SMC
713 -- PTO option
714
715 IF (p_x_line_rec.ato_line_id is not null AND
716 p_x_line_rec.ato_line_id <> FND_API.G_MISS_NUM AND
717 p_x_line_rec.ato_line_id <> p_x_line_rec.line_id) OR
718 (p_x_line_rec.top_model_line_id is not null AND
719 p_x_line_rec.top_model_line_id <> FND_API.G_MISS_NUM AND
720 p_x_line_rec.top_model_line_id <> p_x_line_rec.line_id AND
721 p_x_line_rec.ship_model_complete_flag = 'Y') THEN
722 null;
723 ELSE
724 p_x_line_rec.REQUEST_DATE := FND_API.G_MISS_DATE;
725 x_dep_attr_exists := 'Y';
726 END IF;
727
728 END IF;
729 END REQUEST_DATE;
730
731 PROCEDURE SALESREP IS
732 BEGIN
733 IF (p_initial_line_rec.SALESREP_ID = FND_API.G_MISS_NUM OR
734 (OE_GLOBALS.Equal(p_initial_line_rec.SALESREP_ID, p_old_line_rec.SALESREP_ID)
735 AND
736 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SALESREP_ID IS NOT NULL))
737 ) -- the AND condition above added to fix 3098878
738 THEN
739 p_x_line_rec.SALESREP_ID := FND_API.G_MISS_NUM;
740 x_dep_attr_exists := 'Y';
741 END IF;
742 END SALESREP;
743
744 PROCEDURE SCHEDULE_SHIP_DATE IS
745 BEGIN
746 IF (p_initial_line_rec.SCHEDULE_SHIP_DATE = FND_API.G_MISS_DATE OR
747 (OE_GLOBALS.Equal(p_initial_line_rec.SCHEDULE_SHIP_DATE, p_old_line_rec.SCHEDULE_SHIP_DATE)
748 AND
749 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SCHEDULE_SHIP_DATE IS NOT NULL))
750 ) -- the AND condition above added to fix 3098878
751 THEN
752 p_x_line_rec.SCHEDULE_SHIP_DATE := FND_API.G_MISS_DATE;
753 x_dep_attr_exists := 'Y';
754 END IF;
755 END SCHEDULE_SHIP_DATE;
756
757 PROCEDURE SHIPMENT_NUMBER IS
758 BEGIN
759 IF ((p_initial_line_rec.SHIPMENT_NUMBER = FND_API.G_MISS_NUM OR
760 (OE_GLOBALS.Equal(p_initial_line_rec.SHIPMENT_NUMBER, p_old_line_rec.SHIPMENT_NUMBER)
761 AND
762 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIPMENT_NUMBER IS NOT NULL)))
763 AND
764 (p_initial_line_rec.SPLIT_FROM_LINE_ID is null OR p_initial_line_rec.SPLIT_FROM_LINE_ID= FND_API.G_MISS_NUM)
765 ) -- the second AND condition above added to fix 3098878
766 -- Added the last and condition for bug 3209104
767 THEN
768 p_x_line_rec.SHIPMENT_NUMBER := FND_API.G_MISS_NUM;
769 x_dep_attr_exists := 'Y';
770 END IF;
771 END SHIPMENT_NUMBER;
772
773 PROCEDURE SHIPMENT_PRIORITY IS
774 BEGIN
775 IF (p_initial_line_rec.SHIPMENT_PRIORITY_CODE = FND_API.G_MISS_CHAR OR
776 (OE_GLOBAlS.Equal(p_initial_line_rec.SHIPMENT_PRIORITY_CODE, p_old_line_rec.SHIPMENT_PRIORITY_CODE)
777 AND
778 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIPMENT_PRIORITY_CODE IS NOT NULL))
779 ) -- the AND condition above added to fix 3098878
780 THEN
781 p_x_line_rec.SHIPMENT_PRIORITY_CODE := FND_API.G_MISS_CHAR;
782 x_dep_attr_exists := 'Y';
783 END IF;
784 END SHIPMENT_PRIORITY;
785
786 PROCEDURE SHIPPABLE IS
787 BEGIN
788 IF (p_initial_line_rec.SHIPPABLE_FLAG = FND_API.G_MISS_CHAR OR
789 (OE_GLOBAlS.Equal(p_initial_line_rec.SHIPPABLE_FLAG, p_old_line_rec.SHIPPABLE_FLAG)
790 AND
791 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIPPABLE_FLAG IS NOT NULL))
792 ) -- the AND condition above added to fix 3098878
793 THEN
794 /*
795 ** Fix Bug # 2314689
796 ** Shippable flag should not be cleared on a return
797 ** line after it has been defaulted from reference line.
798 */
799 IF p_x_line_rec.reference_line_id IS NOT NULL AND
800 p_x_line_rec.reference_line_id <> FND_API.G_MISS_NUM AND
801 p_x_line_rec.line_category_code = 'RETURN'
802 THEN
803 NULL;
804 ELSE
805 p_x_line_rec.SHIPPABLE_FLAG := FND_API.G_MISS_CHAR;
806 x_dep_attr_exists := 'Y';
807 END IF;
808 END IF;
809 END SHIPPABLE;
810
811 PROCEDURE SHIPPING_METHOD IS
812 BEGIN
813 IF (p_initial_line_rec.SHIPPING_METHOD_CODE = FND_API.G_MISS_CHAR OR
814 (OE_GLOBAlS.Equal(p_initial_line_rec.SHIPPING_METHOD_CODE, p_old_line_rec.SHIPPING_METHOD_CODE)
815 AND
816 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIPPING_METHOD_CODE IS NOT NULL))
817 ) -- the AND condition above added to fix 3098878
818 THEN
819 p_x_line_rec.SHIPPING_METHOD_CODE := FND_API.G_MISS_CHAR;
820 x_dep_attr_exists := 'Y';
821 END IF;
822 END SHIPPING_METHOD;
823
824 PROCEDURE SHIP_FROM_ORG IS
825 BEGIN
826 IF (p_initial_line_rec.SHIP_FROM_ORG_ID = FND_API.G_MISS_NUM OR
827 (OE_GLOBALS.Equal(p_initial_line_rec.SHIP_FROM_ORG_ID, p_old_line_rec.SHIP_FROM_ORG_ID)
828 AND
829 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIP_FROM_ORG_ID IS NOT NULL))
830 ) -- the AND condition above added to fix 3098878
831 THEN
832 -- Let us not clear request_date for an ATO option or SMC
833 -- PTO option
834
835 IF (p_x_line_rec.ato_line_id is not null AND
836 p_x_line_rec.ato_line_id <> FND_API.G_MISS_NUM AND
837 p_x_line_rec.ato_line_id <> p_x_line_rec.line_id) OR
838 (p_x_line_rec.top_model_line_id is not null AND
839 p_x_line_rec.top_model_line_id <> FND_API.G_MISS_NUM AND
840 p_x_line_rec.top_model_line_id <> p_x_line_rec.line_id AND
841 p_x_line_rec.ship_model_complete_flag = 'Y') OR
842 (p_x_line_rec.ship_set_id is not null AND
843 p_x_line_rec.ship_set_id <> FND_API.G_MISS_NUM) OR
844 (p_x_line_rec.arrival_set_id is not null AND
845 p_x_line_rec.arrival_set_id <> FND_API.G_MISS_NUM)
846 THEN
847 null;
848 ELSE
849
850 -- do not clear Ship_from type if this is a scheduling
851 -- recursive call. Any updates due to scheduling (warehouse or item
852 -- in case of item substitution) should not result in a change to
853 -- the ship from.
854 --4504362
855
856 IF OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING = 'N' THEN
857 RETURN;
858 END IF;
859 p_x_line_rec.SHIP_FROM_ORG_ID := FND_API.G_MISS_NUM;
860 x_dep_attr_exists := 'Y';
861 END IF;
862
863 END IF;
864 END SHIP_FROM_ORG;
865
866 PROCEDURE SUBINVENTORY IS
867 BEGIN
868 IF (p_initial_line_rec.SUBINVENTORY = FND_API.G_MISS_CHAR OR
869 (OE_GLOBAlS.Equal(p_initial_line_rec.SUBINVENTORY, p_old_line_rec.SUBINVENTORY)
870 AND
871 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SUBINVENTORY IS NOT NULL))
872 ) -- the AND condition above added to fix 3098878
873 THEN
874 p_x_line_rec.SUBINVENTORY := FND_API.G_MISS_CHAR;
875 x_dep_attr_exists := 'Y';
876
877 END IF;
878 END SUBINVENTORY;
879
880
881 PROCEDURE SHIP_TOLERANCE_ABOVE IS
882 BEGIN
883 IF (p_initial_line_rec.SHIP_TOLERANCE_ABOVE = FND_API.G_MISS_NUM OR
884 (OE_GLOBALS.Equal(p_initial_line_rec.SHIP_TOLERANCE_ABOVE, p_old_line_rec.SHIP_TOLERANCE_ABOVE)
885 AND
886 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIP_TOLERANCE_ABOVE IS NOT NULL))
887 ) -- the AND condition above added to fix 3098878
888 THEN
889 p_x_line_rec.SHIP_TOLERANCE_ABOVE := FND_API.G_MISS_NUM;
890 x_dep_attr_exists := 'Y';
891 END IF;
892 END SHIP_TOLERANCE_ABOVE;
893
894 PROCEDURE SHIP_TOLERANCE_BELOW IS
895 BEGIN
896 IF (p_initial_line_rec.SHIP_TOLERANCE_BELOW = FND_API.G_MISS_NUM OR
897 (OE_GLOBALS.Equal(p_initial_line_rec.SHIP_TOLERANCE_BELOW, p_old_line_rec.SHIP_TOLERANCE_BELOW)
898 AND
899 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIP_TOLERANCE_BELOW IS NOT NULL))
900 ) -- the AND condition above added to fix 3098878
901 THEN
902 p_x_line_rec.SHIP_TOLERANCE_BELOW := FND_API.G_MISS_NUM;
903 x_dep_attr_exists := 'Y';
904 END IF;
905 END SHIP_TOLERANCE_BELOW;
906
907 PROCEDURE SHIP_TO_CONTACT IS
908 BEGIN
909 IF (p_initial_line_rec.SHIP_TO_CONTACT_ID = FND_API.G_MISS_NUM OR
910 (OE_GLOBALS.Equal(p_initial_line_rec.SHIP_TO_CONTACT_ID, p_old_line_rec.SHIP_TO_CONTACT_ID)
911 AND
912 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIP_TO_CONTACT_ID IS NOT NULL))
913 ) -- the AND condition above added to fix 3098878
914 THEN
915 p_x_line_rec.SHIP_TO_CONTACT_ID := FND_API.G_MISS_NUM;
916 x_dep_attr_exists := 'Y';
917 END IF;
918 END SHIP_TO_CONTACT;
919
920 PROCEDURE SHIP_TO_ORG IS
921 BEGIN
922 IF (p_initial_line_rec.SHIP_TO_ORG_ID = FND_API.G_MISS_NUM OR
923 (OE_GLOBALS.Equal(p_initial_line_rec.SHIP_TO_ORG_ID, p_old_line_rec.SHIP_TO_ORG_ID)
924 AND
925 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIP_TO_ORG_ID IS NOT NULL))
926 ) -- the AND condition above added to fix 3098878
927 THEN
928 -- Let us not clear request_date for an ATO option or SMC
929 -- PTO option
930 -- Code commented for Bug-2543024
931 /* IF (p_x_line_rec.ato_line_id is not null AND
932 p_x_line_rec.ato_line_id <> FND_API.G_MISS_NUM AND
933 p_x_line_rec.ato_line_id <> p_x_line_rec.line_id) OR
934 (p_x_line_rec.top_model_line_id is not null AND
935 p_x_line_rec.top_model_line_id <> FND_API.G_MISS_NUM AND
936 p_x_line_rec.top_model_line_id <> p_x_line_rec.line_id AND
937 p_x_line_rec.ship_model_complete_flag = 'Y') THEN
938
939 null;
940 ELSE*/
941 p_x_line_rec.SHIP_TO_ORG_ID := FND_API.G_MISS_NUM;
942 x_dep_attr_exists := 'Y';
943 -- END IF;
944
945 END IF;
946 END SHIP_TO_ORG;
947
948 PROCEDURE SOLD_TO_ORG IS
949 BEGIN
950 IF (p_initial_line_rec.SOLD_TO_ORG_ID = FND_API.G_MISS_NUM OR
951 (OE_GLOBALS.Equal(p_initial_line_rec.SOLD_TO_ORG_ID, p_old_line_rec.SOLD_TO_ORG_ID)
952 AND
953 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SOLD_TO_ORG_ID IS NOT NULL))
954 ) -- the AND condition above added to fix 3098878
955 THEN
956 IF p_x_line_rec.reference_line_id IS NOT NULL AND
957 p_x_line_rec.reference_line_id <> FND_API.G_MISS_NUM AND
958 p_x_line_rec.line_category_code = 'RETURN'
959 THEN
960 NULL;
961 ELSE
962 p_x_line_rec.SOLD_TO_ORG_ID := FND_API.G_MISS_NUM;
963 x_dep_attr_exists := 'Y';
964 END IF;
965 END IF;
966 END SOLD_TO_ORG;
967
968 PROCEDURE TAX IS
969 BEGIN
970 IF (p_initial_line_rec.TAX_CODE = FND_API.G_MISS_CHAR OR
971 (OE_GLOBAlS.Equal(p_initial_line_rec.TAX_CODE, p_old_line_rec.TAX_CODE)
972 AND
973 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TAX_CODE IS NOT NULL))
974 ) -- the AND condition above added to fix 3098878
975 THEN
976 IF p_x_line_rec.reference_line_id IS NOT NULL AND
977 p_x_line_rec.reference_line_id <> FND_API.G_MISS_NUM AND
978 p_x_line_rec.line_category_code = 'RETURN'
979 THEN
980 NULL;
981 -- commenting the below code to address bug 2287931
982 -- ELSIF p_x_line_rec.TAX_CODE IS NOT NULL THEN
983 -- NULL;
984 ELSE
985 p_x_line_rec.TAX_CODE := FND_API.G_MISS_CHAR;
986 x_dep_attr_exists := 'Y';
987 END IF;
988 END IF;
989 END TAX;
990
991 PROCEDURE TAX_DATE IS
992 BEGIN
993 IF (p_initial_line_rec.TAX_DATE = FND_API.G_MISS_DATE OR
994 (OE_GLOBALS.Equal(p_initial_line_rec.TAX_DATE, p_old_line_rec.TAX_DATE)
995 AND
996 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TAX_DATE IS NOT NULL))
997 ) -- the AND condition above added to fix 3098878
998 THEN
999 IF p_x_line_rec.reference_line_id IS NOT NULL AND
1000 p_x_line_rec.line_category_code = 'RETURN'
1001 THEN
1002 NULL;
1003 ELSE
1004 p_x_line_rec.TAX_DATE := FND_API.G_MISS_DATE;
1005 x_dep_attr_exists := 'Y';
1006 END IF;
1007 END IF;
1008 END TAX_DATE;
1009
1010 PROCEDURE TAX_EXEMPT IS
1011 BEGIN
1012 IF (p_initial_line_rec.TAX_EXEMPT_FLAG = FND_API.G_MISS_CHAR OR
1013 (OE_GLOBAlS.Equal(p_initial_line_rec.TAX_EXEMPT_FLAG, p_old_line_rec.TAX_EXEMPT_FLAG)
1014 AND
1015 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TAX_EXEMPT_FLAG IS NOT NULL))
1016 ) -- the AND condition above added to fix 3098878
1017 THEN
1018 IF p_x_line_rec.reference_line_id IS NOT NULL AND
1019 p_x_line_rec.reference_line_id <> FND_API.G_MISS_NUM AND
1020 p_x_line_rec.line_category_code = 'RETURN'
1021 THEN
1022 NULL;
1023 ELSE
1024 p_x_line_rec.TAX_EXEMPT_FLAG := FND_API.G_MISS_CHAR;
1025 x_dep_attr_exists := 'Y';
1026 END IF;
1027 END IF;
1028 END TAX_EXEMPT;
1029
1030 PROCEDURE TAX_EXEMPT_NUMBER IS
1031 BEGIN
1032 IF (p_initial_line_rec.TAX_EXEMPT_NUMBER = FND_API.G_MISS_CHAR OR
1033 (OE_GLOBAlS.Equal(p_initial_line_rec.TAX_EXEMPT_NUMBER, p_old_line_rec.TAX_EXEMPT_NUMBER)
1034 AND
1035 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TAX_EXEMPT_NUMBER IS NOT NULL))
1036 ) -- the AND condition above added to fix 3098878
1037 THEN
1038 IF p_x_line_rec.reference_line_id IS NOT NULL AND
1039 p_x_line_rec.reference_line_id <> FND_API.G_MISS_NUM AND
1040 p_x_line_rec.line_category_code = 'RETURN'
1041 THEN
1042 NULL;
1043 ELSE
1044 -- Clear it only if the tax_exempt_flag = 'S' or
1045 -- the tax_exempt_flag has changed.
1046 IF NOT OE_GLOBAlS.Equal(p_x_line_rec.TAX_EXEMPT_FLAG
1047 , p_old_line_rec.TAX_EXEMPT_FLAG)
1048 OR (p_old_line_rec.TAX_EXEMPT_FLAG = 'S' AND
1049 p_x_line_rec.TAX_EXEMPT_FLAG = 'S' ) THEN
1050
1051 p_x_line_rec.TAX_EXEMPT_NUMBER := FND_API.G_MISS_CHAR;
1052 x_dep_attr_exists := 'Y';
1053 END IF;
1054 END IF;
1055
1056 END IF;
1057 END TAX_EXEMPT_NUMBER;
1058
1059 PROCEDURE TAX_EXEMPT_REASON IS
1060 BEGIN
1061 IF (p_initial_line_rec.TAX_EXEMPT_REASON_CODE = FND_API.G_MISS_CHAR OR
1062 (OE_GLOBAlS.Equal(p_initial_line_rec.TAX_EXEMPT_REASON_CODE, p_old_line_rec.TAX_EXEMPT_REASON_CODE)
1063 AND
1064 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TAX_EXEMPT_REASON_CODE IS NOT NULL))
1065 ) -- the AND condition above added to fix 3098878
1066 THEN
1067 IF p_x_line_rec.reference_line_id IS NOT NULL AND
1068 p_x_line_rec.reference_line_id <> FND_API.G_MISS_NUM AND
1069 p_x_line_rec.line_category_code = 'RETURN'
1070 THEN
1071 NULL;
1072 ELSE
1073 -- Clear it only if the tax_exempt_flag = 'S' or
1074 -- the tax_exempt_flag has changed.
1075
1076 IF NOT OE_GLOBAlS.Equal(p_x_line_rec.TAX_EXEMPT_FLAG
1077 , p_old_line_rec.TAX_EXEMPT_FLAG)
1078 OR (p_old_line_rec.TAX_EXEMPT_FLAG = 'S' AND
1079 p_x_line_rec.TAX_EXEMPT_FLAG = 'S' ) THEN
1080
1081 p_x_line_rec.TAX_EXEMPT_REASON_CODE := FND_API.G_MISS_CHAR;
1082 x_dep_attr_exists := 'Y';
1083 END IF;
1084
1085 END IF;
1086
1087 END IF;
1088 END TAX_EXEMPT_REASON;
1089
1090 PROCEDURE TOP_MODEL_LINE IS
1091 BEGIN
1092 IF (p_initial_line_rec.TOP_MODEL_LINE_ID = FND_API.G_MISS_NUM OR
1093 (OE_GLOBALS.Equal(p_initial_line_rec.TOP_MODEL_LINE_ID, p_old_line_rec.TOP_MODEL_LINE_ID)
1094 AND
1095 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TOP_MODEL_LINE_ID IS NOT NULL))
1096 ) -- the AND condition above added to fix 3098878
1097 THEN
1098 p_x_line_rec.TOP_MODEL_LINE_ID := FND_API.G_MISS_NUM;
1099 x_dep_attr_exists := 'Y';
1100 END IF;
1101 END TOP_MODEL_LINE;
1102
1103 PROCEDURE SERVICE_START_DATE IS
1104 BEGIN
1105 IF (p_initial_line_rec.SERVICE_START_DATE = FND_API.G_MISS_DATE OR
1106 (OE_GLOBALS.Equal(p_initial_line_rec.SERVICE_START_DATE, p_old_line_rec.SERVICE_START_DATE)
1107 AND
1108 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SERVICE_START_DATE IS NOT NULL))
1109 ) -- the AND condition above added to fix 3098878
1110 THEN
1111 p_x_line_rec.SERVICE_START_DATE := FND_API.G_MISS_DATE;
1112 x_dep_attr_exists := 'Y';
1113 END IF;
1114 END SERVICE_START_DATE;
1115
1116 PROCEDURE SERVICE_PERIOD IS
1117 BEGIN
1118 IF (p_initial_line_rec.SERVICE_PERIOD = FND_API.G_MISS_CHAR OR
1119 (OE_GLOBAlS.Equal(p_initial_line_rec.SERVICE_PERIOD, p_old_line_rec.SERVICE_PERIOD)
1120 AND
1121 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SERVICE_PERIOD IS NOT NULL))
1122 ) -- the AND condition above added to fix 3098878
1123 THEN
1124 p_x_line_rec.SERVICE_PERIOD := FND_API.G_MISS_CHAR;
1125 x_dep_attr_exists := 'Y';
1126 END IF;
1127 END SERVICE_PERIOD;
1128
1129 -- bug4283037
1130 PROCEDURE SERVICE_DURATION IS
1131 BEGIN
1132 IF (p_initial_line_rec.SERVICE_DURATION = FND_API.G_MISS_NUM OR
1133 (OE_GLOBAlS.Equal(p_initial_line_rec.SERVICE_DURATION, p_old_line_rec.SERVICE_DURATION)
1134 AND
1135 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SERVICE_DURATION IS NOT NULL))
1136 ) -- the AND condition above added to fix 3098878
1137 THEN
1138 p_x_line_rec.SERVICE_DURATION := FND_API.G_MISS_NUM;
1139 x_dep_attr_exists := 'Y';
1140 END IF;
1141 END SERVICE_DURATION;
1142
1143 PROCEDURE SERVICE_REFERENCE_TYPE_CODE IS
1144 BEGIN
1145 IF (p_initial_line_rec.SERVICE_REFERENCE_TYPE_CODE = FND_API.G_MISS_CHAR OR
1146 (OE_GLOBAlS.Equal(p_initial_line_rec.SERVICE_REFERENCE_TYPE_CODE, p_old_line_rec.SERVICE_REFERENCE_TYPE_CODE)
1147 AND
1148 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SERVICE_REFERENCE_TYPE_CODE IS NOT NULL))
1149 ) -- the AND condition above added to fix 3098878
1150 THEN
1151 p_x_line_rec.SERVICE_REFERENCE_TYPE_CODE := FND_API.G_MISS_CHAR;
1152 x_dep_attr_exists := 'Y';
1153 END IF;
1154 END SERVICE_REFERENCE_TYPE_CODE;
1155
1156 PROCEDURE RETURN_CONTEXT IS
1157 BEGIN
1158 IF (p_initial_line_rec.RETURN_CONTEXT = FND_API.G_MISS_CHAR OR
1159 (OE_GLOBAlS.Equal(p_initial_line_rec.RETURN_CONTEXT, p_old_line_rec.RETURN_CONTEXT)
1160 AND
1161 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.RETURN_CONTEXT IS NOT NULL))
1162 ) -- the AND condition above added to fix 3098878
1163 THEN
1164 oe_debug_pub.add('RMA:Clearing Return Attrs',1);
1165
1166 p_x_line_rec.RETURN_CONTEXT := FND_API.G_MISS_CHAR;
1167 p_x_line_rec.RETURN_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1168 p_x_line_rec.RETURN_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1169 p_x_line_rec.reference_customer_trx_line_id := FND_API.G_MISS_NUM;
1170 p_x_line_rec.credit_invoice_line_id := FND_API.G_MISS_NUM;
1171 p_x_line_rec.reference_line_id := FND_API.G_MISS_NUM;
1172 p_x_line_rec.reference_header_id := FND_API.G_MISS_NUM;
1173 END IF;
1174 END RETURN_CONTEXT;
1175
1176 -- Add for Bug 2766005
1177 PROCEDURE PACKING_INSTRUCTIONS IS
1178 BEGIN
1179 IF (p_initial_line_rec.PACKING_INSTRUCTIONS = FND_API.G_MISS_CHAR OR
1180 (OE_GLOBAlS.Equal(p_initial_line_rec.PACKING_INSTRUCTIONS, p_old_line_rec.PACKING_INSTRUCTIONS)
1181 AND
1182 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.PACKING_INSTRUCTIONS IS NOT NULL))
1183 ) -- the AND condition above added to fix 3098878
1184 THEN
1185 p_x_line_rec.PACKING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
1186 x_dep_attr_exists := 'Y';
1187 END IF;
1188 END PACKING_INSTRUCTIONS;
1189
1190 PROCEDURE SHIPPING_INSTRUCTIONS IS
1191 BEGIN
1192 IF (p_initial_line_rec.SHIPPING_INSTRUCTIONS = FND_API.G_MISS_CHAR OR
1193 (OE_GLOBAlS.Equal(p_initial_line_rec.SHIPPING_INSTRUCTIONS, p_old_line_rec.SHIPPING_INSTRUCTIONS)
1194 AND
1195 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIPPING_INSTRUCTIONS IS NOT NULL))
1196 ) -- the AND condition above added to fix 3098878
1197 THEN
1198 p_x_line_rec.SHIPPING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
1199 x_dep_attr_exists := 'Y';
1200 END IF;
1201 END SHIPPING_INSTRUCTIONS;
1202 -- End code for bug 2766005
1203
1204
1205 --distributed orders
1206 PROCEDURE end_customer IS
1207 BEGIN
1208 IF (p_initial_line_rec.end_customer_id = FND_API.G_MISS_NUM
1209 OR OE_GLOBALS.Equal(p_initial_line_rec.end_customer_id
1210 , p_old_line_rec.end_customer_id ))
1211 THEN
1212 p_x_line_rec.end_customer_id := FND_API.G_MISS_NUM;
1213 x_dep_attr_exists := 'Y';
1214 END IF;
1215 END end_customer;
1216
1217 PROCEDURE end_customer_contact IS
1218 BEGIN
1219 IF (p_initial_line_rec.end_customer_contact_id = FND_API.G_MISS_NUM
1220 OR OE_GLOBALS.Equal(p_initial_line_rec.end_customer_contact_id
1221 , p_old_line_rec.end_customer_contact_id ))
1222 THEN
1223 p_x_line_rec.end_customer_contact_id := FND_API.G_MISS_NUM;
1224 x_dep_attr_exists := 'Y';
1225 END IF;
1226 END end_customer_contact;
1227
1228 PROCEDURE end_customer_site_use IS
1229 BEGIN
1230 IF (p_initial_line_rec.end_customer_site_use_id = FND_API.G_MISS_NUM
1231 OR OE_GLOBALS.Equal(p_initial_line_rec.end_customer_site_use_id ,
1232 p_old_line_rec.end_customer_site_use_id ))
1233 THEN
1234 p_x_line_rec.end_customer_site_use_id := FND_API.G_MISS_NUM;
1235 x_dep_attr_exists := 'Y';
1236 END IF;
1237 END end_customer_site_use;
1238
1239 --key Transaction Dates Project
1240 PROCEDURE order_firmed_date IS
1241 BEGIN
1242 IF(p_initial_line_rec.order_firmed_date = FND_API.G_MISS_DATE
1243 OR OE_GLOBALS.Equal(p_initial_line_rec.order_firmed_date ,
1244 p_old_line_rec.order_firmed_date ))
1245 THEN
1246 p_x_line_rec.order_firmed_date := FND_API.G_MISS_DATE ;
1247 x_dep_attr_exists := 'Y' ;
1248 END IF;
1249 END order_firmed_date ;
1250 --end
1251 --Rakesh
1252 PROCEDURE CHARGE_PERIODICITY IS
1253 BEGIN
1254 IF (p_initial_line_rec.charge_periodicity_code = FND_API.G_MISS_CHAR OR
1255 OE_GLOBAlS.Equal(p_initial_line_rec.charge_periodicity_code, p_old_line_rec.charge_periodicity_code))
1256 THEN
1257 p_x_line_rec.charge_periodicity_code := FND_API.G_MISS_CHAR;
1258 x_dep_attr_exists := 'Y';
1259 END IF;
1260 END CHARGE_PERIODICITY;
1261
1262 BEGIN
1263
1264
1265 -- Bug 2337711: Initialize this OUT parameter to 'N', if a
1266 -- dependent attribute is cleared later, it will be re-set to 'Y'.
1267 -- Without this initialization, procedure Clear_Dep_And_Default
1268 -- was calling oe_default_line even if there weren't any dependents!
1269 x_dep_attr_exists := 'N';
1270
1271 IF p_src_attr_tbl.COUNT > 0 THEN
1272
1273 OE_Dependencies.Mark_Dependent
1274 (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1275 p_source_attr_tbl => p_src_attr_tbl,
1276 p_dep_attr_tbl => l_dep_attr_tbl);
1277
1278 FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
1279 oe_debug_pub.add('Dep. attr :'||l_dep_attr_tbl(I));
1280
1281 -- Bug fix 1131529: clear the dependent attribute ONLY if attribute
1282 -- did not have a user-specified value (attribute is not user specified
1283 -- if value is missing or old value is same as the initial value)
1284
1285 -- Bug fix : create nested procedures per attribute and call the
1286 -- procedure if it is the dependent attribute.
1287 -- Also, eliminate unnecessary code for attribute that cannot be
1288 -- dependent attributes
1289
1290 IF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ACCOUNTING_RULE THEN
1291 ACCOUNTING_RULE;
1292 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ACCOUNTING_RULE_DURATION THEN
1293 ACCOUNTING_RULE_DURATION;
1294 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_AGREEMENT THEN
1295 AGREEMENT;
1296 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ATO_LINE THEN
1297 ATO_LINE;
1298 --For bug 3571400
1299 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_NUMBER THEN
1300 BLANKET_NUMBER;
1301 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_LINE_NUMBER THEN
1302 BLANKET_LINE_NUMBER;
1303 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_VERSION_NUMBER THEN
1304 BLANKET_VERSION_NUMBER;
1305 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMMITMENT THEN
1306 COMMITMENT;
1307 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT THEN
1308 COMPONENT;
1309 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT_SEQUENCE THEN
1310 COMPONENT_SEQUENCE;
1311 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SORT_ORDER THEN
1312 SORT_ORDER;
1313 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUST_PO_NUMBER THEN
1314 CUST_PO_NUMBER;
1315 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUSTOMER_LINE_NUMBER THEN --For 2844285
1316 CUSTOMER_LINE_NUMBER;
1317 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_CONTACT THEN
1318 DELIVER_TO_CONTACT;
1319 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_ORG THEN
1320 DELIVER_TO_ORG;
1321 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEMAND_CLASS THEN
1322 DEMAND_CLASS;
1323 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEP_PLAN_REQUIRED THEN
1324 DEP_PLAN_REQUIRED;
1325 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_ITEM_UNIT_NUMBER THEN
1326 END_ITEM_UNIT_NUMBER;
1327 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FOB_POINT THEN
1328 FOB_POINT;
1329 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FREIGHT_TERMS THEN
1330 FREIGHT_TERMS;
1331 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_CONTACT THEN
1332 INTERMED_SHIP_TO_CONTACT;
1333 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_ORG THEN
1334 INTERMED_SHIP_TO_ORG;
1335 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_CONTACT THEN
1336 INVOICE_TO_CONTACT;
1337 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_ORG THEN
1338 INVOICE_TO_ORG;
1339 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICING_RULE THEN
1340 INVOICING_RULE;
1341 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_IDENTIFIER_TYPE THEN
1342 ITEM_IDENTIFIER_TYPE;
1343 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_REVISION THEN -- For bug 2951575
1344 ITEM_REVISION;
1345 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_TYPE THEN
1346 ITEM_TYPE;
1347 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_TYPE THEN
1348 LINE_TYPE;
1349 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_CATEGORY THEN
1350 LINE_CATEGORY;
1351 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_OPTION_NUMBER THEN
1352 OPTION_NUMBER;
1353 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_ITEM THEN
1354 ORDERED_ITEM;
1355 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDER_QUANTITY_UOM THEN
1356 ORDER_QUANTITY_UOM;
1357 -- OPM 02/JUN/00 BEGIN
1358 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_QUANTITY_UOM2 THEN
1359 ORDERED_QUANTITY_UOM2;
1360 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_QUANTITY2 THEN
1361 ORDERED_QUANTITY2; -- Bug3016136
1362 -- OPM 02/JUN/00 END
1363 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PAYMENT_TERM THEN
1364 PAYMENT_TERM;
1365 -- OPM 02/JUN/00 BEGIN
1366 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PREFERRED_GRADE THEN
1367 PREFERRED_GRADE;
1368 -- OPM 02/JUN/00 END
1369 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICE_LIST THEN
1370 PRICE_LIST;
1371 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICE_REQUEST_CODE THEN
1372 PRICE_REQUEST_CODE; -- PROMOTIONS SEP/01
1373 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICING_QUANTITY_UOM THEN
1374 PRICING_QUANTITY_UOM;
1375 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PROMISE_DATE THEN
1376 PROMISE_DATE;
1377 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_REQUEST_DATE THEN
1378 REQUEST_DATE;
1379 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SALESREP THEN
1380 SALESREP;
1381 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE THEN
1382 SCHEDULE_SHIP_DATE;
1383 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_NUMBER THEN
1384 SHIPMENT_NUMBER;
1385 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_PRIORITY THEN
1386 SHIPMENT_PRIORITY;
1387 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPABLE THEN
1388 SHIPPABLE;
1389 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPING_METHOD THEN
1390 SHIPPING_METHOD;
1391 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_FROM_ORG THEN
1392 SHIP_FROM_ORG;
1393 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SUBINVENTORY THEN
1394 SUBINVENTORY;
1395 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_ABOVE THEN
1396 SHIP_TOLERANCE_ABOVE;
1397 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_BELOW THEN
1398 SHIP_TOLERANCE_BELOW;
1399 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_CONTACT THEN
1400 SHIP_TO_CONTACT;
1401 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_ORG THEN
1402 SHIP_TO_ORG;
1403 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SOLD_TO_ORG THEN
1404 SOLD_TO_ORG;
1405 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX THEN
1406 TAX;
1407 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_DATE THEN
1408 TAX_DATE;
1409 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT THEN
1410 TAX_EXEMPT;
1411 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_NUMBER THEN
1412 TAX_EXEMPT_NUMBER;
1413 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_REASON THEN
1414 TAX_EXEMPT_REASON;
1415 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TOP_MODEL_LINE THEN
1416 TOP_MODEL_LINE;
1417 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_START_DATE THEN
1418 SERVICE_START_DATE;
1419 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_PERIOD THEN
1420 SERVICE_PERIOD;
1421 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_REFERENCE_TYPE_CODE THEN
1422 SERVICE_REFERENCE_TYPE_CODE;
1423 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_RETURN_CONTEXT THEN
1424 RETURN_CONTEXT;
1425 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SOURCE_TYPE THEN
1426 SOURCE_TYPE;
1427 -- Add for bug 2766005
1428 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PACKING_INSTRUCTIONS THEN
1429 PACKING_INSTRUCTIONS;
1430 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPING_INSTRUCTIONS THEN
1431 SHIPPING_INSTRUCTIONS;
1432 -- End of code for bug 2766005
1433 -- Distributed orders
1434 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER THEN
1435 END_CUSTOMER;
1436 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER_CONTACT THEN
1437 END_CUSTOMER_CONTACT;
1438 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER_SITE_USE THEN
1439 END_CUSTOMER_SITE_USE;
1440 -- bug 4283037
1441 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_DURATION THEN
1442 SERVICE_DURATION;
1443 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDER_FIRMED_DATE and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >='110509'
1444 THEN --key Transaction Dates Project
1445 ORDER_FIRMED_DATE ;
1446 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CHARGE_PERIODICITY THEN
1447 CHARGE_PERIODICITY;
1448 END IF;
1449 END LOOP;
1450 END IF;
1451
1452 EXCEPTION
1453 WHEN FND_API.G_EXC_ERROR THEN
1454 RAISE FND_API.G_EXC_ERROR;
1455 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1456 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1457 WHEN OTHERS THEN
1458 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1459 THEN
1460 OE_MSG_PUB.Add_Exc_Msg
1461 ( G_PKG_NAME
1462 , 'Clear_Dependents'
1463 );
1464 END IF;
1465 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1466 END Clear_Dependents;
1467
1468 -- Function to initialize a record of type OE_AK_ORDER_LINES_V%ROWTYPE
1469 FUNCTION G_MISS_OE_AK_LINE_REC
1470 RETURN OE_AK_ORDER_LINES_V%ROWTYPE IS
1471 l_rowtype_rec OE_AK_ORDER_LINES_V%ROWTYPE;
1472 BEGIN
1473
1474 -- OPM 02/JUN/00 - add process attributes
1475 -- =========================================================================
1476
1477 l_rowtype_rec.ACCOUNTING_RULE_ID := FND_API.G_MISS_NUM;
1478 l_rowtype_rec.ACCOUNTING_RULE_DURATION := FND_API.G_MISS_NUM;
1479 l_rowtype_rec.ACTUAL_ARRIVAL_DATE := FND_API.G_MISS_DATE;
1480 l_rowtype_rec.ACTUAL_SHIPMENT_DATE := FND_API.G_MISS_DATE;
1481 l_rowtype_rec.AGREEMENT_ID := FND_API.G_MISS_NUM;
1482 l_rowtype_rec.ARRIVAL_SET := FND_API.G_MISS_CHAR;
1483 l_rowtype_rec.upgraded_flag := FND_API.G_MISS_CHAR;
1484 l_rowtype_rec.ARRIVAL_SET_ID := FND_API.G_MISS_NUM;
1485 l_rowtype_rec.ATO_LINE_ID := FND_API.G_MISS_NUM;
1486 l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1487 l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
1488 l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
1489 l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
1490 l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
1491 l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
1492 l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
1493 l_rowtype_rec.ATTRIBUTE16 := FND_API.G_MISS_CHAR; --For bug 2184255
1494 l_rowtype_rec.ATTRIBUTE17 := FND_API.G_MISS_CHAR;
1495 l_rowtype_rec.ATTRIBUTE18 := FND_API.G_MISS_CHAR;
1496 l_rowtype_rec.ATTRIBUTE19 := FND_API.G_MISS_CHAR;
1497 l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1498 l_rowtype_rec.ATTRIBUTE20 := FND_API.G_MISS_CHAR;
1499 l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
1500 l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
1501 l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
1502 l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
1503 l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
1504 l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
1505 l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
1506 l_rowtype_rec.AUTHORIZED_TO_SHIP_FLAG := FND_API.G_MISS_CHAR;
1507 l_rowtype_rec.AUTO_SELECTED_QUANTITY := FND_API.G_MISS_NUM;
1508 l_rowtype_rec.BOOKED_FLAG := FND_API.G_MISS_CHAR;
1509 l_rowtype_rec.CANCELLED_FLAG := FND_API.G_MISS_CHAR;
1510 l_rowtype_rec.CANCELLED_QUANTITY := FND_API.G_MISS_NUM;
1511 l_rowtype_rec.CANCELLED_QUANTITY2 := FND_API.G_MISS_NUM; --OPM
1512 l_rowtype_rec.COMPONENT_CODE := FND_API.G_MISS_CHAR;
1513 l_rowtype_rec.COMPONENT_NUMBER := FND_API.G_MISS_NUM;
1514 l_rowtype_rec.COMPONENT_SEQUENCE_ID := FND_API.G_MISS_NUM;
1515 l_rowtype_rec.CONFIGURATION_ID := FND_API.G_MISS_NUM;
1516 l_rowtype_rec.CONFIG_DISPLAY_SEQUENCE := FND_API.G_MISS_NUM;
1517 l_rowtype_rec.CONFIG_HEADER_ID := FND_API.G_MISS_NUM;
1518 l_rowtype_rec.CONFIG_REV_NBR := FND_API.G_MISS_NUM;
1519 l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
1520 l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
1521 l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
1522 l_rowtype_rec.CREDIT_INVOICE_LINE_ID := FND_API.G_MISS_NUM;
1523 l_rowtype_rec.CUSTOMER_DOCK_CODE := FND_API.G_MISS_CHAR;
1524 l_rowtype_rec.CUSTOMER_JOB := FND_API.G_MISS_CHAR;
1525 l_rowtype_rec.CUSTOMER_PRODUCTION_LINE := FND_API.G_MISS_CHAR;
1526 l_rowtype_rec.CUSTOMER_TRX_LINE_ID := FND_API.G_MISS_NUM;
1527 l_rowtype_rec.CUST_MODEL_SERIAL_NUMBER := FND_API.G_MISS_CHAR;
1528 l_rowtype_rec.CUST_PO_NUMBER := FND_API.G_MISS_CHAR;
1529 l_rowtype_rec.CUSTOMER_LINE_NUMBER := FND_API.G_MISS_CHAR;
1530 l_rowtype_rec.CUST_PRODUCTION_SEQ_NUM := FND_API.G_MISS_CHAR;
1531 l_rowtype_rec.DELIVERY_LEAD_TIME := FND_API.G_MISS_NUM;
1532 l_rowtype_rec.DELIVER_TO_CONTACT_ID := FND_API.G_MISS_NUM;
1533 l_rowtype_rec.DELIVER_TO_ORG_ID := FND_API.G_MISS_NUM;
1534 l_rowtype_rec.DEMAND_BUCKET_TYPE_CODE := FND_API.G_MISS_CHAR;
1535 l_rowtype_rec.DEMAND_CLASS_CODE := FND_API.G_MISS_CHAR;
1536 l_rowtype_rec.DEP_PLAN_REQUIRED_FLAG := FND_API.G_MISS_CHAR;
1537 l_rowtype_rec.EARLIEST_ACCEPTABLE_DATE := FND_API.G_MISS_DATE;
1538 l_rowtype_rec.END_ITEM_UNIT_NUMBER := FND_API.G_MISS_CHAR;
1539 l_rowtype_rec.EXPLOSION_DATE := FND_API.G_MISS_DATE;
1540 l_rowtype_rec.FOB_POINT_CODE := FND_API.G_MISS_CHAR;
1541 l_rowtype_rec.FREIGHT_CARRIER_CODE := FND_API.G_MISS_CHAR;
1542 l_rowtype_rec.FREIGHT_TERMS_CODE := FND_API.G_MISS_CHAR;
1543 l_rowtype_rec.FULFILLED_QUANTITY := FND_API.G_MISS_NUM;
1544 l_rowtype_rec.FULFILLED_FLAG := FND_API.G_MISS_CHAR;
1545 l_rowtype_rec.FULFILLMENT_METHOD_CODE := FND_API.G_MISS_CHAR;
1546 l_rowtype_rec.FULFILLMENT_DATE := FND_API.G_MISS_DATE;
1547 l_rowtype_rec.GLOBAL_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1548 l_rowtype_rec.GLOBAL_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
1549 l_rowtype_rec.GLOBAL_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
1550 l_rowtype_rec.GLOBAL_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
1551 l_rowtype_rec.GLOBAL_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
1552 l_rowtype_rec.GLOBAL_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
1553 l_rowtype_rec.GLOBAL_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
1554 l_rowtype_rec.GLOBAL_ATTRIBUTE16 := FND_API.G_MISS_CHAR;
1555 l_rowtype_rec.GLOBAL_ATTRIBUTE17 := FND_API.G_MISS_CHAR;
1556 l_rowtype_rec.GLOBAL_ATTRIBUTE18 := FND_API.G_MISS_CHAR;
1557 l_rowtype_rec.GLOBAL_ATTRIBUTE19 := FND_API.G_MISS_CHAR;
1558 l_rowtype_rec.GLOBAL_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1559 l_rowtype_rec.GLOBAL_ATTRIBUTE20 := FND_API.G_MISS_CHAR;
1560 l_rowtype_rec.GLOBAL_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
1561 l_rowtype_rec.GLOBAL_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
1562 l_rowtype_rec.GLOBAL_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
1563 l_rowtype_rec.GLOBAL_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
1564 l_rowtype_rec.GLOBAL_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
1565 l_rowtype_rec.GLOBAL_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
1566 l_rowtype_rec.GLOBAL_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
1567 l_rowtype_rec.GLOBAL_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
1568 l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
1569 l_rowtype_rec.INDUSTRY_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1570 l_rowtype_rec.INDUSTRY_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
1571 l_rowtype_rec.INDUSTRY_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
1572 l_rowtype_rec.INDUSTRY_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
1573 l_rowtype_rec.INDUSTRY_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
1574 l_rowtype_rec.INDUSTRY_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
1575 l_rowtype_rec.INDUSTRY_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
1576 l_rowtype_rec.INDUSTRY_ATTRIBUTE16 := FND_API.G_MISS_CHAR;
1577 l_rowtype_rec.INDUSTRY_ATTRIBUTE17 := FND_API.G_MISS_CHAR;
1578 l_rowtype_rec.INDUSTRY_ATTRIBUTE18 := FND_API.G_MISS_CHAR;
1579 l_rowtype_rec.INDUSTRY_ATTRIBUTE19 := FND_API.G_MISS_CHAR;
1580 l_rowtype_rec.INDUSTRY_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1581 l_rowtype_rec.INDUSTRY_ATTRIBUTE20 := FND_API.G_MISS_CHAR;
1582 l_rowtype_rec.INDUSTRY_ATTRIBUTE21 := FND_API.G_MISS_CHAR;
1583 l_rowtype_rec.INDUSTRY_ATTRIBUTE22 := FND_API.G_MISS_CHAR;
1584 l_rowtype_rec.INDUSTRY_ATTRIBUTE23 := FND_API.G_MISS_CHAR;
1585 l_rowtype_rec.INDUSTRY_ATTRIBUTE24 := FND_API.G_MISS_CHAR;
1586 l_rowtype_rec.INDUSTRY_ATTRIBUTE25 := FND_API.G_MISS_CHAR;
1587 l_rowtype_rec.INDUSTRY_ATTRIBUTE26 := FND_API.G_MISS_CHAR;
1588 l_rowtype_rec.INDUSTRY_ATTRIBUTE27 := FND_API.G_MISS_CHAR;
1589 l_rowtype_rec.INDUSTRY_ATTRIBUTE28 := FND_API.G_MISS_CHAR;
1590 l_rowtype_rec.INDUSTRY_ATTRIBUTE29 := FND_API.G_MISS_CHAR;
1591 l_rowtype_rec.INDUSTRY_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
1592 l_rowtype_rec.INDUSTRY_ATTRIBUTE30 := FND_API.G_MISS_CHAR;
1593 l_rowtype_rec.INDUSTRY_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
1594 l_rowtype_rec.INDUSTRY_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
1595 l_rowtype_rec.INDUSTRY_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
1596 l_rowtype_rec.INDUSTRY_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
1597 l_rowtype_rec.INDUSTRY_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
1598 l_rowtype_rec.INDUSTRY_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
1599 l_rowtype_rec.INDUSTRY_CONTEXT := FND_API.G_MISS_CHAR;
1600 l_rowtype_rec.INTERMED_SHIP_TO_CONTACT_ID := FND_API.G_MISS_NUM;
1601 l_rowtype_rec.INTERMED_SHIP_TO_ORG_ID := FND_API.G_MISS_NUM;
1602 l_rowtype_rec.INVENTORY_ITEM_ID := FND_API.G_MISS_NUM;
1603 l_rowtype_rec.INVOICE_INTERFACE_STATUS_CODE := FND_API.G_MISS_CHAR;
1604 l_rowtype_rec.INVOICE_TO_CONTACT_ID := FND_API.G_MISS_NUM;
1605 l_rowtype_rec.INVOICE_TO_ORG_ID := FND_API.G_MISS_NUM;
1606 l_rowtype_rec.INVOICED_QUANTITY := FND_API.G_MISS_NUM;
1607 l_rowtype_rec.INVOICING_RULE_ID := FND_API.G_MISS_NUM;
1608 l_rowtype_rec.ORDERED_ITEM_ID := FND_API.G_MISS_NUM;
1609 l_rowtype_rec.ITEM_IDENTIFIER_TYPE := FND_API.G_MISS_CHAR;
1610 l_rowtype_rec.ORDERED_ITEM := FND_API.G_MISS_CHAR;
1611 l_rowtype_rec.ITEM_REVISION := FND_API.G_MISS_CHAR;
1612 l_rowtype_rec.ITEM_TYPE_CODE := FND_API.G_MISS_CHAR;
1613 l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
1614 l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
1615 l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
1616 l_rowtype_rec.LATEST_ACCEPTABLE_DATE := FND_API.G_MISS_DATE;
1617 l_rowtype_rec.LINE_CATEGORY_CODE := FND_API.G_MISS_CHAR;
1618 l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
1619 l_rowtype_rec.LINE_NUMBER := FND_API.G_MISS_NUM;
1620 l_rowtype_rec.LINE_TYPE_ID := FND_API.G_MISS_NUM;
1621 l_rowtype_rec.LINK_TO_LINE_ID := FND_API.G_MISS_NUM;
1622 l_rowtype_rec.MFG_COMPONENT_SEQUENCE_ID := FND_API.G_MISS_NUM;
1623 l_rowtype_rec.MODEL_GROUP_NUMBER := FND_API.G_MISS_NUM;
1624 l_rowtype_rec.OPEN_FLAG := FND_API.G_MISS_CHAR;
1625 l_rowtype_rec.OPTION_FLAG := FND_API.G_MISS_CHAR;
1626 l_rowtype_rec.OPTION_NUMBER := FND_API.G_MISS_NUM;
1627 l_rowtype_rec.ORDERED_QUANTITY := FND_API.G_MISS_NUM;
1628 l_rowtype_rec.ORDERED_QUANTITY2 := FND_API.G_MISS_NUM; -- OPM 1857167
1629 l_rowtype_rec.ORDER_QUANTITY_UOM := FND_API.G_MISS_CHAR;
1630 l_rowtype_rec.ORG_ID := FND_API.G_MISS_NUM;
1631 l_rowtype_rec.ORIG_SYS_DOCUMENT_REF := FND_API.G_MISS_CHAR;
1632 l_rowtype_rec.ORIG_SYS_LINE_REF := FND_API.G_MISS_CHAR;
1633 l_rowtype_rec.OVER_SHIP_REASON_CODE := FND_API.G_MISS_CHAR;
1634 l_rowtype_rec.OVER_SHIP_RESOLVED_FLAG := FND_API.G_MISS_CHAR;
1635 l_rowtype_rec.PACKING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
1636 l_rowtype_rec.PAYMENT_TERM_ID := FND_API.G_MISS_NUM;
1637 l_rowtype_rec.PLANNING_PRIORITY := FND_API.G_MISS_NUM;
1638 l_rowtype_rec.PRICE_LIST_ID := FND_API.G_MISS_NUM;
1639 l_rowtype_rec.PRICE_REQUEST_CODE := FND_API.G_MISS_CHAR; -- PROMOTIONS SEP/01
1640 l_rowtype_rec.PRICING_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1641 l_rowtype_rec.PRICING_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
1642 l_rowtype_rec.PRICING_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1643 l_rowtype_rec.PRICING_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
1644 l_rowtype_rec.PRICING_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
1645 l_rowtype_rec.PRICING_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
1646 l_rowtype_rec.PRICING_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
1647 l_rowtype_rec.PRICING_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
1648 l_rowtype_rec.PRICING_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
1649 l_rowtype_rec.PRICING_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
1650 l_rowtype_rec.PRICING_CONTEXT := FND_API.G_MISS_CHAR;
1651 l_rowtype_rec.PRICING_DATE := FND_API.G_MISS_DATE;
1652 l_rowtype_rec.PRICING_QUANTITY := FND_API.G_MISS_NUM;
1653 l_rowtype_rec.PRICING_QUANTITY_UOM := FND_API.G_MISS_CHAR;
1654 l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
1655 l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
1656 l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
1657 l_rowtype_rec.PROJECT_ID := FND_API.G_MISS_NUM;
1658 l_rowtype_rec.PROMISE_DATE := FND_API.G_MISS_DATE;
1659 l_rowtype_rec.RE_SOURCE_FLAG := FND_API.G_MISS_CHAR;
1660 l_rowtype_rec.REFERENCE_CUSTOMER_TRX_LINE_ID := FND_API.G_MISS_NUM;
1661 l_rowtype_rec.REFERENCE_HEADER_ID := FND_API.G_MISS_NUM;
1662 l_rowtype_rec.REFERENCE_LINE_ID := FND_API.G_MISS_NUM;
1663 l_rowtype_rec.REFERENCE_TYPE := FND_API.G_MISS_CHAR;
1664 l_rowtype_rec.REQUEST_DATE := FND_API.G_MISS_DATE;
1665 l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
1666 l_rowtype_rec.RESERVED_QUANTITY := FND_API.G_MISS_NUM;
1667 l_rowtype_rec.RETURN_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1668 l_rowtype_rec.RETURN_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
1669 l_rowtype_rec.RETURN_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
1670 l_rowtype_rec.RETURN_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
1671 l_rowtype_rec.RETURN_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
1672 l_rowtype_rec.RETURN_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
1673 l_rowtype_rec.RETURN_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
1674 l_rowtype_rec.RETURN_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1675 l_rowtype_rec.RETURN_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
1676 l_rowtype_rec.RETURN_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
1677 l_rowtype_rec.RETURN_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
1678 l_rowtype_rec.RETURN_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
1679 l_rowtype_rec.RETURN_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
1680 l_rowtype_rec.RETURN_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
1681 l_rowtype_rec.RETURN_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
1682 l_rowtype_rec.RETURN_CONTEXT := FND_API.G_MISS_CHAR;
1683 l_rowtype_rec.RETURN_REASON_CODE := FND_API.G_MISS_CHAR;
1684 l_rowtype_rec.RLA_SCHEDULE_TYPE_CODE := FND_API.G_MISS_CHAR;
1685 l_rowtype_rec.SALESREP_ID := FND_API.G_MISS_NUM;
1686 l_rowtype_rec.SCHEDULE_ACTION_CODE := FND_API.G_MISS_CHAR;
1687 l_rowtype_rec.SPLIT_ACTION_CODE := FND_API.G_MISS_CHAR;
1688 l_rowtype_rec.SCHEDULE_ARRIVAL_DATE := FND_API.G_MISS_DATE;
1689 l_rowtype_rec.SCHEDULE_SHIP_DATE := FND_API.G_MISS_DATE;
1690 l_rowtype_rec.SCHEDULE_STATUS_CODE := FND_API.G_MISS_CHAR;
1691 l_rowtype_rec.SHIPMENT_NUMBER := FND_API.G_MISS_NUM;
1692 l_rowtype_rec.SHIPMENT_PRIORITY_CODE := FND_API.G_MISS_CHAR;
1693 l_rowtype_rec.SHIPPED_QUANTITY := FND_API.G_MISS_NUM;
1694 l_rowtype_rec.SHIPPING_INTERFACED_FLAG := FND_API.G_MISS_CHAR;
1695 l_rowtype_rec.SHIPPING_METHOD_CODE := FND_API.G_MISS_CHAR;
1696 l_rowtype_rec.SHIPPING_QUANTITY := FND_API.G_MISS_NUM;
1697 l_rowtype_rec.SHIPPING_QUANTITY_UOM := FND_API.G_MISS_CHAR;
1698 l_rowtype_rec.SHIPPING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
1699 l_rowtype_rec.SHIP_FROM_ORG_ID := FND_API.G_MISS_NUM;
1700 l_rowtype_rec.SUBINVENTORY := FND_API.G_MISS_CHAR;
1701 l_rowtype_rec.SHIP_MODEL_COMPLETE_FLAG := FND_API.G_MISS_CHAR;
1702 l_rowtype_rec.SHIP_SET := FND_API.G_MISS_CHAR;
1703 l_rowtype_rec.SHIP_SET_ID := FND_API.G_MISS_NUM;
1704 l_rowtype_rec.SHIP_TOLERANCE_ABOVE := FND_API.G_MISS_NUM;
1705 l_rowtype_rec.SHIP_TOLERANCE_BELOW := FND_API.G_MISS_NUM;
1706 l_rowtype_rec.SHIP_TO_CONTACT_ID := FND_API.G_MISS_NUM;
1707 l_rowtype_rec.SHIP_TO_ORG_ID := FND_API.G_MISS_NUM;
1708 l_rowtype_rec.SOLD_FROM_ORG_ID := FND_API.G_MISS_NUM;
1709 l_rowtype_rec.SOLD_TO_ORG_ID := FND_API.G_MISS_NUM;
1710 l_rowtype_rec.SORT_ORDER := FND_API.G_MISS_CHAR;
1711 l_rowtype_rec.SOURCE_DOCUMENT_ID := FND_API.G_MISS_NUM;
1712 l_rowtype_rec.SOURCE_DOCUMENT_LINE_ID := FND_API.G_MISS_NUM;
1713 l_rowtype_rec.SOURCE_DOCUMENT_TYPE_ID := FND_API.G_MISS_NUM;
1714 l_rowtype_rec.SOURCE_TYPE_CODE := FND_API.G_MISS_CHAR;
1715 l_rowtype_rec.SPLIT_FROM_LINE_ID := FND_API.G_MISS_NUM;
1716 l_rowtype_rec.LINE_SET_ID := FND_API.G_MISS_NUM;
1717 l_rowtype_rec.SPLIT_BY := FND_API.G_MISS_CHAR;
1718 l_rowtype_rec.Model_remnant_flag := FND_API.G_MISS_CHAR;
1719 l_rowtype_rec.TASK_ID := FND_API.G_MISS_NUM;
1720 l_rowtype_rec.TAX_CODE := FND_API.G_MISS_CHAR;
1721 l_rowtype_rec.TAX_DATE := FND_API.G_MISS_DATE;
1722 l_rowtype_rec.TAX_EXEMPT_FLAG := FND_API.G_MISS_CHAR;
1723 l_rowtype_rec.TAX_EXEMPT_NUMBER := FND_API.G_MISS_CHAR;
1724 l_rowtype_rec.TAX_EXEMPT_REASON_CODE := FND_API.G_MISS_CHAR;
1725 l_rowtype_rec.TAX_POINT_CODE := FND_API.G_MISS_CHAR;
1726 l_rowtype_rec.TAX_RATE := FND_API.G_MISS_NUM;
1727 l_rowtype_rec.TAX_VALUE := FND_API.G_MISS_NUM;
1728 l_rowtype_rec.TOP_MODEL_LINE_ID := FND_API.G_MISS_NUM;
1729 l_rowtype_rec.UNIT_LIST_PRICE := FND_API.G_MISS_NUM;
1730 l_rowtype_rec.UNIT_SELLING_PRICE := FND_API.G_MISS_NUM;
1731 l_rowtype_rec.VEH_CUS_ITEM_CUM_KEY_ID := FND_API.G_MISS_NUM;
1732 l_rowtype_rec.VISIBLE_DEMAND_FLAG := FND_API.G_MISS_CHAR;
1733 l_rowtype_rec.SHIPPABLE_FLAG := FND_API.G_MISS_CHAR;
1734 l_rowtype_rec.SERVICE_TXN_REASON_CODE := FND_API.G_MISS_CHAR;
1735 l_rowtype_rec.SERVICE_DURATION := FND_API.G_MISS_NUM;
1736 l_rowtype_rec.SERVICE_PERIOD := FND_API.G_MISS_CHAR;
1737 l_rowtype_rec.SERVICE_START_DATE := FND_API.G_MISS_DATE;
1738 l_rowtype_rec.SERVICE_END_DATE := FND_API.G_MISS_DATE;
1739 l_rowtype_rec.SERVICE_COTERMINATE_FLAG := FND_API.G_MISS_CHAR;
1740 l_rowtype_rec.SERVICE_TXN_COMMENTS := FND_API.G_MISS_CHAR;
1741 l_rowtype_rec.UNIT_SELLING_PERCENT := FND_API.G_MISS_NUM;
1742 l_rowtype_rec.UNIT_LIST_PERCENT := FND_API.G_MISS_NUM;
1743 l_rowtype_rec.UNIT_PERCENT_BASE_PRICE := FND_API.G_MISS_NUM;
1744 l_rowtype_rec.SERVICE_NUMBER := FND_API.G_MISS_NUM;
1745 l_rowtype_rec.SERVICE_REFERENCE_TYPE_CODE := FND_API.G_MISS_CHAR;
1746 l_rowtype_rec.SERVICE_REFERENCE_LINE_ID := FND_API.G_MISS_NUM;
1747 l_rowtype_rec.SERVICE_REFERENCE_SYSTEM_ID := FND_API.G_MISS_NUM;
1748 l_rowtype_rec.TP_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1749 l_rowtype_rec.TP_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
1750 l_rowtype_rec.TP_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
1751 l_rowtype_rec.TP_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
1752 l_rowtype_rec.TP_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
1753 l_rowtype_rec.TP_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
1754 l_rowtype_rec.TP_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
1755 l_rowtype_rec.TP_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1756 l_rowtype_rec.TP_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
1757 l_rowtype_rec.TP_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
1758 l_rowtype_rec.TP_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
1759 l_rowtype_rec.TP_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
1760 l_rowtype_rec.TP_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
1761 l_rowtype_rec.TP_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
1762 l_rowtype_rec.TP_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
1763 l_rowtype_rec.TP_CONTEXT := FND_API.G_MISS_CHAR;
1764 l_rowtype_rec.CALCULATE_PRICE_FLAG := FND_API.G_MISS_CHAR;
1765 -- QUOTING changes
1766 l_rowtype_rec.TRANSACTION_PHASE_CODE := FND_API.G_MISS_CHAR;
1767 l_rowtype_rec.SOURCE_DOCUMENT_VERSION_NUMBER := FND_API.G_MISS_NUM;
1768 --key Transaction Dates Project
1769 l_rowtype_rec.order_firmed_date := FND_API.G_MISS_DATE;
1770 l_rowtype_rec.actual_fulfillment_date := FND_API.G_MISS_DATE;
1771 -- INVCONV
1772 l_rowtype_rec.FULFILLED_QUANTITY2 := FND_API.G_MISS_NUM;
1773 l_rowtype_rec.SHIPPED_QUANTITY2 := FND_API.G_MISS_NUM;
1774 l_rowtype_rec.SHIPPING_QUANTITY2 := FND_API.G_MISS_NUM;
1775 l_rowtype_rec.SHIPPING_QUANTITY_UOM2 := FND_API.G_MISS_CHAR;
1776 l_rowtype_rec.charge_periodicity_code := FND_API.G_MISS_CHAR; -- Rakesh
1777
1778
1779 RETURN l_rowtype_rec;
1780
1781 EXCEPTION
1782 WHEN OTHERS THEN
1783 IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1784 THEN
1785 oe_msg_pub.Add_Exc_Msg
1786 ( G_PKG_NAME
1787 , 'G_MISS_OE_AK_LINE_REC'
1788 );
1789 END IF;
1790 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1791 END G_MISS_OE_AK_LINE_REC;
1792
1793 PROCEDURE API_Rec_To_Rowtype_Rec
1794 ( p_LINE_rec IN OE_Order_PUB.LINE_Rec_Type
1795 , x_rowtype_rec IN OUT NOCOPY OE_AK_ORDER_LINES_V%ROWTYPE
1796 ) IS
1797 BEGIN
1798
1799 x_rowtype_rec.ACCOUNTING_RULE_ID := p_line_rec.ACCOUNTING_RULE_ID;
1800 x_rowtype_rec.ACCOUNTING_RULE_DURATION := p_line_rec.ACCOUNTING_RULE_DURATION;
1801 x_rowtype_rec.ACTUAL_ARRIVAL_DATE := p_line_rec.ACTUAL_ARRIVAL_DATE;
1802 x_rowtype_rec.ACTUAL_SHIPMENT_DATE := p_line_rec.ACTUAL_SHIPMENT_DATE;
1803 x_rowtype_rec.AGREEMENT_ID := p_line_rec.AGREEMENT_ID;
1804 x_rowtype_rec.ARRIVAL_SET := p_line_rec.ARRIVAL_SET;
1805 x_rowtype_rec.upgraded_flag := p_line_rec.upgraded_flag;
1806 x_rowtype_rec.ARRIVAL_SET_ID := p_line_rec.ARRIVAL_SET_ID;
1807 x_rowtype_rec.ATO_LINE_ID := p_line_rec.ATO_LINE_ID;
1808 x_rowtype_rec.ATTRIBUTE1 := p_line_rec.ATTRIBUTE1;
1809 x_rowtype_rec.ATTRIBUTE10 := p_line_rec.ATTRIBUTE10;
1810 x_rowtype_rec.ATTRIBUTE11 := p_line_rec.ATTRIBUTE11;
1811 x_rowtype_rec.ATTRIBUTE12 := p_line_rec.ATTRIBUTE12;
1812 x_rowtype_rec.ATTRIBUTE13 := p_line_rec.ATTRIBUTE13;
1813 x_rowtype_rec.ATTRIBUTE14 := p_line_rec.ATTRIBUTE14;
1814 x_rowtype_rec.ATTRIBUTE15 := p_line_rec.ATTRIBUTE15;
1815 x_rowtype_rec.ATTRIBUTE16 := p_line_rec.ATTRIBUTE16; --For bug 2184255
1816 x_rowtype_rec.ATTRIBUTE17 := p_line_rec.ATTRIBUTE17;
1817 x_rowtype_rec.ATTRIBUTE18 := p_line_rec.ATTRIBUTE18;
1818 x_rowtype_rec.ATTRIBUTE19 := p_line_rec.ATTRIBUTE19;
1819 x_rowtype_rec.ATTRIBUTE2 := p_line_rec.ATTRIBUTE2;
1820 x_rowtype_rec.ATTRIBUTE20 := p_line_rec.ATTRIBUTE20;
1821 x_rowtype_rec.ATTRIBUTE3 := p_line_rec.ATTRIBUTE3;
1822 x_rowtype_rec.ATTRIBUTE4 := p_line_rec.ATTRIBUTE4;
1823 x_rowtype_rec.ATTRIBUTE5 := p_line_rec.ATTRIBUTE5;
1824 x_rowtype_rec.ATTRIBUTE6 := p_line_rec.ATTRIBUTE6;
1825 x_rowtype_rec.ATTRIBUTE7 := p_line_rec.ATTRIBUTE7;
1826 x_rowtype_rec.ATTRIBUTE8 := p_line_rec.ATTRIBUTE8;
1827 x_rowtype_rec.ATTRIBUTE9 := p_line_rec.ATTRIBUTE9;
1828 x_rowtype_rec.AUTHORIZED_TO_SHIP_FLAG := p_line_rec.AUTHORIZED_TO_SHIP_FLAG;
1829 x_rowtype_rec.AUTO_SELECTED_QUANTITY := p_line_rec.AUTO_SELECTED_QUANTITY;
1830 x_rowtype_rec.BLANKET_NUMBER := p_line_rec.BLANKET_NUMBER;
1831 x_rowtype_rec.BLANKET_LINE_NUMBER := p_line_rec.BLANKET_LINE_NUMBER;
1832 x_rowtype_rec.BLANKET_VERSION_NUMBER := p_line_rec.BLANKET_VERSION_NUMBER;
1833 x_rowtype_rec.BOOKED_FLAG := p_line_rec.BOOKED_FLAG;
1834 x_rowtype_rec.CALCULATE_PRICE_FLAG := p_line_rec.CALCULATE_PRICE_FLAG;
1835 x_rowtype_rec.CANCELLED_FLAG := p_line_rec.CANCELLED_FLAG;
1836 x_rowtype_rec.CANCELLED_QUANTITY := p_line_rec.CANCELLED_QUANTITY;
1837 x_rowtype_rec.CANCELLED_QUANTITY2 := p_line_rec.CANCELLED_QUANTITY2;
1838 x_rowtype_rec.COMMITMENT_ID := p_line_rec.COMMITMENT_ID;
1839 x_rowtype_rec.COMPONENT_CODE := p_line_rec.COMPONENT_CODE;
1840 x_rowtype_rec.COMPONENT_NUMBER := p_line_rec.COMPONENT_NUMBER;
1841 x_rowtype_rec.COMPONENT_SEQUENCE_ID := p_line_rec.COMPONENT_SEQUENCE_ID;
1842 x_rowtype_rec.CONFIGURATION_ID := p_line_rec.CONFIGURATION_ID;
1843 x_rowtype_rec.CONFIG_DISPLAY_SEQUENCE := p_line_rec.CONFIG_DISPLAY_SEQUENCE;
1844 x_rowtype_rec.CONFIG_HEADER_ID := p_line_rec.CONFIG_HEADER_ID;
1845 x_rowtype_rec.CONFIG_REV_NBR := p_line_rec.CONFIG_REV_NBR;
1846 x_rowtype_rec.CONTEXT := p_line_rec.CONTEXT;
1847 x_rowtype_rec.CREATED_BY := p_line_rec.CREATED_BY;
1848 x_rowtype_rec.CREATION_DATE := p_line_rec.CREATION_DATE;
1849 x_rowtype_rec.CREDIT_INVOICE_LINE_ID := p_line_rec.CREDIT_INVOICE_LINE_ID;
1850 x_rowtype_rec.CUSTOMER_DOCK_CODE := p_line_rec.CUSTOMER_DOCK_CODE;
1851 x_rowtype_rec.CUSTOMER_JOB := p_line_rec.CUSTOMER_JOB;
1852 x_rowtype_rec.CUSTOMER_PRODUCTION_LINE := p_line_rec.CUSTOMER_PRODUCTION_LINE;
1853 x_rowtype_rec.CUSTOMER_TRX_LINE_ID := p_line_rec.CUSTOMER_TRX_LINE_ID;
1854 x_rowtype_rec.CUST_MODEL_SERIAL_NUMBER := p_line_rec.CUST_MODEL_SERIAL_NUMBER;
1855 x_rowtype_rec.CUST_PO_NUMBER := p_line_rec.CUST_PO_NUMBER;
1856 x_rowtype_rec.CUSTOMER_LINE_NUMBER := p_line_rec.CUSTOMER_LINE_NUMBER;
1857 x_rowtype_rec.CUST_PRODUCTION_SEQ_NUM := p_line_rec.CUST_PRODUCTION_SEQ_NUM;
1858 x_rowtype_rec.DELIVERY_LEAD_TIME := p_line_rec.DELIVERY_LEAD_TIME;
1859 x_rowtype_rec.DELIVER_TO_CONTACT_ID := p_line_rec.DELIVER_TO_CONTACT_ID;
1860 x_rowtype_rec.DELIVER_TO_ORG_ID := p_line_rec.DELIVER_TO_ORG_ID;
1861 x_rowtype_rec.DEMAND_BUCKET_TYPE_CODE := p_line_rec.DEMAND_BUCKET_TYPE_CODE;
1862 x_rowtype_rec.DEMAND_CLASS_CODE := p_line_rec.DEMAND_CLASS_CODE;
1863 x_rowtype_rec.DEP_PLAN_REQUIRED_FLAG := p_line_rec.DEP_PLAN_REQUIRED_FLAG;
1864 x_rowtype_rec.EARLIEST_ACCEPTABLE_DATE := p_line_rec.EARLIEST_ACCEPTABLE_DATE;
1865 x_rowtype_rec.END_ITEM_UNIT_NUMBER := p_line_rec.END_ITEM_UNIT_NUMBER;
1866 x_rowtype_rec.EXPLOSION_DATE := p_line_rec.EXPLOSION_DATE;
1867 x_rowtype_rec.FOB_POINT_CODE := p_line_rec.FOB_POINT_CODE;
1868 x_rowtype_rec.FREIGHT_CARRIER_CODE := p_line_rec.FREIGHT_CARRIER_CODE;
1869 x_rowtype_rec.FREIGHT_TERMS_CODE := p_line_rec.FREIGHT_TERMS_CODE;
1870 x_rowtype_rec.FULFILLED_QUANTITY := p_line_rec.FULFILLED_QUANTITY;
1871 x_rowtype_rec.FULFILLED_QUANTITY2 := p_line_rec.FULFILLED_QUANTITY2;
1872 x_rowtype_rec.FULFILLED_FLAG := p_line_rec.FULFILLED_FLAG;
1873 x_rowtype_rec.FULFILLMENT_METHOD_CODE := p_line_rec.FULFILLMENT_METHOD_CODE;
1874 x_rowtype_rec.FULFILLMENT_DATE := p_line_rec.FULFILLMENT_DATE;
1875 x_rowtype_rec.GLOBAL_ATTRIBUTE1 := p_line_rec.GLOBAL_ATTRIBUTE1;
1876 x_rowtype_rec.GLOBAL_ATTRIBUTE10 := p_line_rec.GLOBAL_ATTRIBUTE10;
1877 x_rowtype_rec.GLOBAL_ATTRIBUTE11 := p_line_rec.GLOBAL_ATTRIBUTE11;
1878 x_rowtype_rec.GLOBAL_ATTRIBUTE12 := p_line_rec.GLOBAL_ATTRIBUTE12;
1879 x_rowtype_rec.GLOBAL_ATTRIBUTE13 := p_line_rec.GLOBAL_ATTRIBUTE13;
1880 x_rowtype_rec.GLOBAL_ATTRIBUTE14 := p_line_rec.GLOBAL_ATTRIBUTE14;
1881 x_rowtype_rec.GLOBAL_ATTRIBUTE15 := p_line_rec.GLOBAL_ATTRIBUTE15;
1882 x_rowtype_rec.GLOBAL_ATTRIBUTE16 := p_line_rec.GLOBAL_ATTRIBUTE16;
1883 x_rowtype_rec.GLOBAL_ATTRIBUTE17 := p_line_rec.GLOBAL_ATTRIBUTE17;
1884 x_rowtype_rec.GLOBAL_ATTRIBUTE18 := p_line_rec.GLOBAL_ATTRIBUTE18;
1885 x_rowtype_rec.GLOBAL_ATTRIBUTE19 := p_line_rec.GLOBAL_ATTRIBUTE19;
1886 x_rowtype_rec.GLOBAL_ATTRIBUTE2 := p_line_rec.GLOBAL_ATTRIBUTE2;
1887 x_rowtype_rec.GLOBAL_ATTRIBUTE20 := p_line_rec.GLOBAL_ATTRIBUTE20;
1888 x_rowtype_rec.GLOBAL_ATTRIBUTE3 := p_line_rec.GLOBAL_ATTRIBUTE3;
1889 x_rowtype_rec.GLOBAL_ATTRIBUTE4 := p_line_rec.GLOBAL_ATTRIBUTE4;
1890 x_rowtype_rec.GLOBAL_ATTRIBUTE5 := p_line_rec.GLOBAL_ATTRIBUTE5;
1891 x_rowtype_rec.GLOBAL_ATTRIBUTE6 := p_line_rec.GLOBAL_ATTRIBUTE6;
1892 x_rowtype_rec.GLOBAL_ATTRIBUTE7 := p_line_rec.GLOBAL_ATTRIBUTE7;
1893 x_rowtype_rec.GLOBAL_ATTRIBUTE8 := p_line_rec.GLOBAL_ATTRIBUTE8;
1894 x_rowtype_rec.GLOBAL_ATTRIBUTE9 := p_line_rec.GLOBAL_ATTRIBUTE9;
1895 x_rowtype_rec.GLOBAL_ATTRIBUTE_CATEGORY := p_line_rec.GLOBAL_ATTRIBUTE_CATEGORY;
1896 x_rowtype_rec.HEADER_ID := p_line_rec.HEADER_ID;
1897 x_rowtype_rec.INDUSTRY_ATTRIBUTE1 := p_line_rec.INDUSTRY_ATTRIBUTE1;
1898 x_rowtype_rec.INDUSTRY_ATTRIBUTE10 := p_line_rec.INDUSTRY_ATTRIBUTE10;
1899 x_rowtype_rec.INDUSTRY_ATTRIBUTE11 := p_line_rec.INDUSTRY_ATTRIBUTE11;
1900 x_rowtype_rec.INDUSTRY_ATTRIBUTE12 := p_line_rec.INDUSTRY_ATTRIBUTE12;
1901 x_rowtype_rec.INDUSTRY_ATTRIBUTE13 := p_line_rec.INDUSTRY_ATTRIBUTE13;
1902 x_rowtype_rec.INDUSTRY_ATTRIBUTE14 := p_line_rec.INDUSTRY_ATTRIBUTE14;
1903 x_rowtype_rec.INDUSTRY_ATTRIBUTE15 := p_line_rec.INDUSTRY_ATTRIBUTE15;
1904 x_rowtype_rec.INDUSTRY_ATTRIBUTE16 := p_line_rec.INDUSTRY_ATTRIBUTE16;
1905 x_rowtype_rec.INDUSTRY_ATTRIBUTE17 := p_line_rec.INDUSTRY_ATTRIBUTE17;
1906 x_rowtype_rec.INDUSTRY_ATTRIBUTE18 := p_line_rec.INDUSTRY_ATTRIBUTE18;
1907 x_rowtype_rec.INDUSTRY_ATTRIBUTE19 := p_line_rec.INDUSTRY_ATTRIBUTE19;
1908 x_rowtype_rec.INDUSTRY_ATTRIBUTE2 := p_line_rec.INDUSTRY_ATTRIBUTE2;
1909 x_rowtype_rec.INDUSTRY_ATTRIBUTE20 := p_line_rec.INDUSTRY_ATTRIBUTE20;
1910 x_rowtype_rec.INDUSTRY_ATTRIBUTE21 := p_line_rec.INDUSTRY_ATTRIBUTE21;
1911 x_rowtype_rec.INDUSTRY_ATTRIBUTE22 := p_line_rec.INDUSTRY_ATTRIBUTE22;
1912 x_rowtype_rec.INDUSTRY_ATTRIBUTE23 := p_line_rec.INDUSTRY_ATTRIBUTE23;
1913 x_rowtype_rec.INDUSTRY_ATTRIBUTE24 := p_line_rec.INDUSTRY_ATTRIBUTE24;
1914 x_rowtype_rec.INDUSTRY_ATTRIBUTE25 := p_line_rec.INDUSTRY_ATTRIBUTE25;
1915 x_rowtype_rec.INDUSTRY_ATTRIBUTE26 := p_line_rec.INDUSTRY_ATTRIBUTE26;
1916 x_rowtype_rec.INDUSTRY_ATTRIBUTE27 := p_line_rec.INDUSTRY_ATTRIBUTE27;
1917 x_rowtype_rec.INDUSTRY_ATTRIBUTE28 := p_line_rec.INDUSTRY_ATTRIBUTE28;
1918 x_rowtype_rec.INDUSTRY_ATTRIBUTE29 := p_line_rec.INDUSTRY_ATTRIBUTE29;
1919 x_rowtype_rec.INDUSTRY_ATTRIBUTE3 := p_line_rec.INDUSTRY_ATTRIBUTE3;
1920 x_rowtype_rec.INDUSTRY_ATTRIBUTE30 := p_line_rec.INDUSTRY_ATTRIBUTE30;
1921 x_rowtype_rec.INDUSTRY_ATTRIBUTE4 := p_line_rec.INDUSTRY_ATTRIBUTE4;
1922 x_rowtype_rec.INDUSTRY_ATTRIBUTE5 := p_line_rec.INDUSTRY_ATTRIBUTE5;
1923 x_rowtype_rec.INDUSTRY_ATTRIBUTE6 := p_line_rec.INDUSTRY_ATTRIBUTE6;
1924 x_rowtype_rec.INDUSTRY_ATTRIBUTE7 := p_line_rec.INDUSTRY_ATTRIBUTE7;
1925 x_rowtype_rec.INDUSTRY_ATTRIBUTE8 := p_line_rec.INDUSTRY_ATTRIBUTE8;
1926 x_rowtype_rec.INDUSTRY_ATTRIBUTE9 := p_line_rec.INDUSTRY_ATTRIBUTE9;
1927 x_rowtype_rec.INDUSTRY_CONTEXT := p_line_rec.INDUSTRY_CONTEXT;
1928 x_rowtype_rec.INTERMED_SHIP_TO_CONTACT_ID := p_line_rec.INTERMED_SHIP_TO_CONTACT_ID;
1929 x_rowtype_rec.INTERMED_SHIP_TO_ORG_ID := p_line_rec.INTERMED_SHIP_TO_ORG_ID;
1930 x_rowtype_rec.INVENTORY_ITEM_ID := p_line_rec.INVENTORY_ITEM_ID;
1931 x_rowtype_rec.INVOICE_INTERFACE_STATUS_CODE := p_line_rec.INVOICE_INTERFACE_STATUS_CODE;
1932 x_rowtype_rec.INVOICE_TO_CONTACT_ID := p_line_rec.INVOICE_TO_CONTACT_ID;
1933 x_rowtype_rec.INVOICE_TO_ORG_ID := p_line_rec.INVOICE_TO_ORG_ID;
1934 x_rowtype_rec.INVOICED_QUANTITY := p_line_rec.INVOICED_QUANTITY;
1935 x_rowtype_rec.INVOICING_RULE_ID := p_line_rec.INVOICING_RULE_ID;
1936 x_rowtype_rec.ORDERED_ITEM_ID := p_line_rec.ORDERED_ITEM_ID;
1937 x_rowtype_rec.ITEM_IDENTIFIER_TYPE := p_line_rec.ITEM_IDENTIFIER_TYPE;
1938 x_rowtype_rec.ORDERED_ITEM := p_line_rec.ORDERED_ITEM;
1939 x_rowtype_rec.ITEM_REVISION := p_line_rec.ITEM_REVISION;
1940 x_rowtype_rec.ITEM_TYPE_CODE := p_line_rec.ITEM_TYPE_CODE;
1941 x_rowtype_rec.LAST_UPDATED_BY := p_line_rec.LAST_UPDATED_BY;
1942 x_rowtype_rec.LAST_UPDATE_DATE := p_line_rec.LAST_UPDATE_DATE;
1943 x_rowtype_rec.LAST_UPDATE_LOGIN := p_line_rec.LAST_UPDATE_LOGIN;
1944 x_rowtype_rec.LATEST_ACCEPTABLE_DATE := p_line_rec.LATEST_ACCEPTABLE_DATE;
1945 x_rowtype_rec.LINE_CATEGORY_CODE := p_line_rec.LINE_CATEGORY_CODE;
1946 x_rowtype_rec.LINE_ID := p_line_rec.LINE_ID;
1947 x_rowtype_rec.LINE_NUMBER := p_line_rec.LINE_NUMBER;
1948 x_rowtype_rec.LINE_TYPE_ID := p_line_rec.LINE_TYPE_ID;
1949 x_rowtype_rec.LINK_TO_LINE_ID := p_line_rec.LINK_TO_LINE_ID;
1950 x_rowtype_rec.MFG_COMPONENT_SEQUENCE_ID := p_line_rec.MFG_COMPONENT_SEQUENCE_ID;
1951 x_rowtype_rec.MODEL_GROUP_NUMBER := p_line_rec.MODEL_GROUP_NUMBER;
1952 x_rowtype_rec.OPEN_FLAG := p_line_rec.OPEN_FLAG;
1953 x_rowtype_rec.OPTION_FLAG := p_line_rec.OPTION_FLAG;
1954 x_rowtype_rec.OPTION_NUMBER := p_line_rec.OPTION_NUMBER;
1955 x_rowtype_rec.ORDERED_QUANTITY := p_line_rec.ORDERED_QUANTITY;
1956 x_rowtype_rec.ORDERED_QUANTITY2 := p_line_rec.ORDERED_QUANTITY2;
1957 x_rowtype_rec.ORDER_QUANTITY_UOM := p_line_rec.ORDER_QUANTITY_UOM;
1958 x_rowtype_rec.ORDERED_QUANTITY_UOM2 := p_line_rec.ORDERED_QUANTITY_UOM2;
1959 x_rowtype_rec.ORG_ID := p_line_rec.ORG_ID;
1960 x_rowtype_rec.ORIG_SYS_DOCUMENT_REF := p_line_rec.ORIG_SYS_DOCUMENT_REF;
1961 x_rowtype_rec.ORIG_SYS_LINE_REF := p_line_rec.ORIG_SYS_LINE_REF;
1962 x_rowtype_rec.OVER_SHIP_REASON_CODE := p_line_rec.OVER_SHIP_REASON_CODE;
1963 x_rowtype_rec.OVER_SHIP_RESOLVED_FLAG := p_line_rec.OVER_SHIP_RESOLVED_FLAG;
1964 x_rowtype_rec.PACKING_INSTRUCTIONS := p_line_rec.PACKING_INSTRUCTIONS;
1965 x_rowtype_rec.PAYMENT_TERM_ID := p_line_rec.PAYMENT_TERM_ID;
1966 x_rowtype_rec.PLANNING_PRIORITY := p_line_rec.PLANNING_PRIORITY;
1967 x_rowtype_rec.PREFERRED_GRADE := p_line_rec.PREFERRED_GRADE;
1968 x_rowtype_rec.PRICE_LIST_ID := p_line_rec.PRICE_LIST_ID;
1969 x_rowtype_rec.PRICE_REQUEST_CODE := p_line_rec.PRICE_REQUEST_CODE; -- PROMOTIONS SEP/01
1970 x_rowtype_rec.PRICING_ATTRIBUTE1 := p_line_rec.PRICING_ATTRIBUTE1;
1971 x_rowtype_rec.PRICING_ATTRIBUTE10 := p_line_rec.PRICING_ATTRIBUTE10;
1972 x_rowtype_rec.PRICING_ATTRIBUTE2 := p_line_rec.PRICING_ATTRIBUTE2;
1973 x_rowtype_rec.PRICING_ATTRIBUTE3 := p_line_rec.PRICING_ATTRIBUTE3;
1974 x_rowtype_rec.PRICING_ATTRIBUTE4 := p_line_rec.PRICING_ATTRIBUTE4;
1975 x_rowtype_rec.PRICING_ATTRIBUTE5 := p_line_rec.PRICING_ATTRIBUTE5;
1976 x_rowtype_rec.PRICING_ATTRIBUTE6 := p_line_rec.PRICING_ATTRIBUTE6;
1977 x_rowtype_rec.PRICING_ATTRIBUTE7 := p_line_rec.PRICING_ATTRIBUTE7;
1978 x_rowtype_rec.PRICING_ATTRIBUTE8 := p_line_rec.PRICING_ATTRIBUTE8;
1979 x_rowtype_rec.PRICING_ATTRIBUTE9 := p_line_rec.PRICING_ATTRIBUTE9;
1980 x_rowtype_rec.PRICING_CONTEXT := p_line_rec.PRICING_CONTEXT;
1981 x_rowtype_rec.PRICING_DATE := p_line_rec.PRICING_DATE;
1982 x_rowtype_rec.PRICING_QUANTITY := p_line_rec.PRICING_QUANTITY;
1983 x_rowtype_rec.PRICING_QUANTITY_UOM := p_line_rec.PRICING_QUANTITY_UOM;
1984 x_rowtype_rec.PROGRAM_APPLICATION_ID := p_line_rec.PROGRAM_APPLICATION_ID;
1985 x_rowtype_rec.PROGRAM_ID := p_line_rec.PROGRAM_ID;
1986 x_rowtype_rec.PROGRAM_UPDATE_DATE := p_line_rec.PROGRAM_UPDATE_DATE;
1987 x_rowtype_rec.PROJECT_ID := p_line_rec.PROJECT_ID;
1988 x_rowtype_rec.PROMISE_DATE := p_line_rec.PROMISE_DATE;
1989 x_rowtype_rec.RE_SOURCE_FLAG := p_line_rec.RE_SOURCE_FLAG;
1990 x_rowtype_rec.REFERENCE_CUSTOMER_TRX_LINE_ID
1991 := p_line_rec.REFERENCE_CUSTOMER_TRX_LINE_ID;
1992 x_rowtype_rec.REFERENCE_HEADER_ID := p_line_rec.REFERENCE_HEADER_ID;
1993 x_rowtype_rec.REFERENCE_LINE_ID := p_line_rec.REFERENCE_LINE_ID;
1994 x_rowtype_rec.REFERENCE_TYPE := p_line_rec.REFERENCE_TYPE;
1995 x_rowtype_rec.REQUEST_DATE := p_line_rec.REQUEST_DATE;
1996 x_rowtype_rec.REQUEST_ID := p_line_rec.REQUEST_ID;
1997 x_rowtype_rec.RESERVED_QUANTITY := p_line_rec.RESERVED_QUANTITY;
1998 x_rowtype_rec.RETURN_ATTRIBUTE1 := p_line_rec.RETURN_ATTRIBUTE1;
1999 x_rowtype_rec.RETURN_ATTRIBUTE10 := p_line_rec.RETURN_ATTRIBUTE10;
2000 x_rowtype_rec.RETURN_ATTRIBUTE11 := p_line_rec.RETURN_ATTRIBUTE11;
2001 x_rowtype_rec.RETURN_ATTRIBUTE12 := p_line_rec.RETURN_ATTRIBUTE12;
2002 x_rowtype_rec.RETURN_ATTRIBUTE13 := p_line_rec.RETURN_ATTRIBUTE13;
2003 x_rowtype_rec.RETURN_ATTRIBUTE14 := p_line_rec.RETURN_ATTRIBUTE14;
2004 x_rowtype_rec.RETURN_ATTRIBUTE15 := p_line_rec.RETURN_ATTRIBUTE15;
2005 x_rowtype_rec.RETURN_ATTRIBUTE2 := p_line_rec.RETURN_ATTRIBUTE2;
2006 x_rowtype_rec.RETURN_ATTRIBUTE3 := p_line_rec.RETURN_ATTRIBUTE3;
2007 x_rowtype_rec.RETURN_ATTRIBUTE4 := p_line_rec.RETURN_ATTRIBUTE4;
2008 x_rowtype_rec.RETURN_ATTRIBUTE5 := p_line_rec.RETURN_ATTRIBUTE5;
2009 x_rowtype_rec.RETURN_ATTRIBUTE6 := p_line_rec.RETURN_ATTRIBUTE6;
2010 x_rowtype_rec.RETURN_ATTRIBUTE7 := p_line_rec.RETURN_ATTRIBUTE7;
2011 x_rowtype_rec.RETURN_ATTRIBUTE8 := p_line_rec.RETURN_ATTRIBUTE8;
2012 x_rowtype_rec.RETURN_ATTRIBUTE9 := p_line_rec.RETURN_ATTRIBUTE9;
2013 x_rowtype_rec.RETURN_CONTEXT := p_line_rec.RETURN_CONTEXT;
2014 x_rowtype_rec.RETURN_REASON_CODE := p_line_rec.RETURN_REASON_CODE;
2015 x_rowtype_rec.RLA_SCHEDULE_TYPE_CODE := p_line_rec.RLA_SCHEDULE_TYPE_CODE;
2016 x_rowtype_rec.SALESREP_ID := p_line_rec.SALESREP_ID;
2017 x_rowtype_rec.SCHEDULE_ACTION_CODE := p_line_rec.SCHEDULE_ACTION_CODE;
2018 x_rowtype_rec.SPLIT_ACTION_CODE := p_line_rec.SPLIT_ACTION_CODE;
2019 x_rowtype_rec.SCHEDULE_ARRIVAL_DATE := p_line_rec.SCHEDULE_ARRIVAL_DATE;
2020 x_rowtype_rec.SCHEDULE_SHIP_DATE := p_line_rec.SCHEDULE_SHIP_DATE;
2021 x_rowtype_rec.SCHEDULE_STATUS_CODE := p_line_rec.SCHEDULE_STATUS_CODE;
2022 x_rowtype_rec.SHIPMENT_NUMBER := p_line_rec.SHIPMENT_NUMBER;
2023 x_rowtype_rec.SHIPMENT_PRIORITY_CODE := p_line_rec.SHIPMENT_PRIORITY_CODE;
2024 x_rowtype_rec.SHIPPED_QUANTITY := p_line_rec.SHIPPED_QUANTITY;
2025 x_rowtype_rec.SHIPPED_QUANTITY2 := p_line_rec.SHIPPED_QUANTITY2;
2026 x_rowtype_rec.SHIPPING_INTERFACED_FLAG := p_line_rec.SHIPPING_INTERFACED_FLAG;
2027 x_rowtype_rec.SHIPPING_INSTRUCTIONS := p_line_rec.SHIPPING_INSTRUCTIONS;
2028 x_rowtype_rec.SHIPPING_METHOD_CODE := p_line_rec.SHIPPING_METHOD_CODE;
2029 x_rowtype_rec.SHIPPING_QUANTITY := p_line_rec.SHIPPING_QUANTITY;
2030 x_rowtype_rec.SHIPPING_QUANTITY2 := p_line_rec.SHIPPING_QUANTITY2;
2031 x_rowtype_rec.SHIPPING_QUANTITY_UOM := p_line_rec.SHIPPING_QUANTITY_UOM;
2032 x_rowtype_rec.SHIPPING_QUANTITY_UOM2 := p_line_rec.SHIPPING_QUANTITY_UOM2;
2033 x_rowtype_rec.SHIP_FROM_ORG_ID := p_line_rec.SHIP_FROM_ORG_ID;
2034 x_rowtype_rec.SUBINVENTORY := p_line_rec.SUBINVENTORY;
2035 x_rowtype_rec.SHIP_MODEL_COMPLETE_FLAG := p_line_rec.SHIP_MODEL_COMPLETE_FLAG;
2036 x_rowtype_rec.SHIP_SET := p_line_rec.SHIP_SET;
2037 x_rowtype_rec.SHIP_SET_ID := p_line_rec.SHIP_SET_ID;
2038 x_rowtype_rec.SHIP_TOLERANCE_ABOVE := p_line_rec.SHIP_TOLERANCE_ABOVE;
2039 x_rowtype_rec.SHIP_TOLERANCE_BELOW := p_line_rec.SHIP_TOLERANCE_BELOW;
2040 x_rowtype_rec.SHIP_TO_CONTACT_ID := p_line_rec.SHIP_TO_CONTACT_ID;
2041 x_rowtype_rec.SHIP_TO_ORG_ID := p_line_rec.SHIP_TO_ORG_ID;
2042 x_rowtype_rec.SOLD_FROM_ORG_ID := p_line_rec.SOLD_FROM_ORG_ID;
2043 x_rowtype_rec.SOLD_TO_ORG_ID := p_line_rec.SOLD_TO_ORG_ID;
2044 x_rowtype_rec.SORT_ORDER := p_line_rec.SORT_ORDER;
2045 x_rowtype_rec.SOURCE_DOCUMENT_ID := p_line_rec.SOURCE_DOCUMENT_ID;
2046 x_rowtype_rec.SOURCE_DOCUMENT_LINE_ID := p_line_rec.SOURCE_DOCUMENT_LINE_ID;
2047 x_rowtype_rec.SOURCE_DOCUMENT_TYPE_ID := p_line_rec.SOURCE_DOCUMENT_TYPE_ID;
2048 x_rowtype_rec.SOURCE_TYPE_CODE := p_line_rec.SOURCE_TYPE_CODE;
2049 x_rowtype_rec.SPLIT_FROM_LINE_ID := p_line_rec.SPLIT_FROM_LINE_ID;
2050 x_rowtype_rec.LINE_SET_ID := p_line_rec.LINE_SET_ID;
2051 x_rowtype_rec.SPLIT_BY := p_line_rec.SPLIT_BY;
2052 x_rowtype_rec.MODEL_REMNANT_FLAG := p_line_rec.MODEL_REMNANT_FLAG;
2053 x_rowtype_rec.TASK_ID := p_line_rec.TASK_ID;
2054 x_rowtype_rec.TAX_CODE := p_line_rec.TAX_CODE;
2055 x_rowtype_rec.TAX_DATE := p_line_rec.TAX_DATE;
2056 x_rowtype_rec.TAX_EXEMPT_FLAG := p_line_rec.TAX_EXEMPT_FLAG;
2057 x_rowtype_rec.TAX_EXEMPT_NUMBER := p_line_rec.TAX_EXEMPT_NUMBER;
2058 x_rowtype_rec.TAX_EXEMPT_REASON_CODE := p_line_rec.TAX_EXEMPT_REASON_CODE;
2059 x_rowtype_rec.TAX_POINT_CODE := p_line_rec.TAX_POINT_CODE;
2060 x_rowtype_rec.TAX_RATE := p_line_rec.TAX_RATE;
2061 x_rowtype_rec.TAX_VALUE := p_line_rec.TAX_VALUE;
2062 x_rowtype_rec.TOP_MODEL_LINE_ID := p_line_rec.TOP_MODEL_LINE_ID;
2063 x_rowtype_rec.UNIT_LIST_PRICE := p_line_rec.UNIT_LIST_PRICE;
2064 x_rowtype_rec.UNIT_SELLING_PRICE := p_line_rec.UNIT_SELLING_PRICE;
2065 x_rowtype_rec.UNIT_LIST_PRICE_PER_PQTY := p_line_rec.UNIT_LIST_PRICE_PER_PQTY;
2066 x_rowtype_rec.UNIT_SELLING_PRICE_PER_PQTY := p_line_rec.UNIT_SELLING_PRICE_PER_PQTY;
2067 x_rowtype_rec.VEH_CUS_ITEM_CUM_KEY_ID := p_line_rec.VEH_CUS_ITEM_CUM_KEY_ID;
2068 x_rowtype_rec.VISIBLE_DEMAND_FLAG := p_line_rec.VISIBLE_DEMAND_FLAG;
2069 x_rowtype_rec.OPERATION := p_line_rec.OPERATION;
2070 x_rowtype_rec.RETURN_STATUS := p_line_rec.RETURN_STATUS;
2071 x_rowtype_rec.DB_FLAG := p_line_rec.DB_FLAG;
2072 x_rowtype_rec.CHANGE_REASON := p_line_rec.CHANGE_REASON;
2073 x_rowtype_rec.CHANGE_COMMENTS := p_line_rec.CHANGE_COMMENTS;
2074 x_rowtype_rec.SHIPPABLE_FLAG := p_line_rec.SHIPPABLE_FLAG;
2075 x_rowtype_rec.SERVICE_TXN_REASON_CODE := p_line_rec.SERVICE_TXN_REASON_CODE;
2076 x_rowtype_rec.SERVICE_DURATION := p_line_rec.SERVICE_DURATION;
2077 x_rowtype_rec.SERVICE_PERIOD := p_line_rec.SERVICE_PERIOD;
2078 x_rowtype_rec.SERVICE_START_DATE := p_line_rec.SERVICE_START_DATE;
2079 x_rowtype_rec.SERVICE_END_DATE := p_line_rec.SERVICE_END_DATE;
2080 x_rowtype_rec.SERVICE_COTERMINATE_FLAG := p_line_rec.SERVICE_COTERMINATE_FLAG;
2081 x_rowtype_rec.SERVICE_TXN_COMMENTS := p_line_rec.SERVICE_TXN_COMMENTS;
2082 x_rowtype_rec.UNIT_SELLING_PERCENT := p_line_rec.UNIT_SELLING_PERCENT;
2083 x_rowtype_rec.UNIT_LIST_PERCENT := p_line_rec.UNIT_LIST_PERCENT;
2084 x_rowtype_rec.UNIT_PERCENT_BASE_PRICE := p_line_rec.UNIT_PERCENT_BASE_PRICE;
2085 x_rowtype_rec.SERVICE_NUMBER := p_line_rec.SERVICE_NUMBER;
2086 x_rowtype_rec.SERVICE_REFERENCE_TYPE_CODE := p_line_rec.SERVICE_REFERENCE_TYPE_CODE;
2087 x_rowtype_rec.SERVICE_REFERENCE_LINE_ID := p_line_rec.SERVICE_REFERENCE_LINE_ID;
2088 x_rowtype_rec.SERVICE_REFERENCE_SYSTEM_ID := p_line_rec.SERVICE_REFERENCE_SYSTEM_ID;
2089 x_rowtype_rec.FLOW_STATUS_CODE := p_line_rec.flow_status_code;
2090 x_rowtype_rec.TP_ATTRIBUTE1 := p_line_rec.TP_ATTRIBUTE1;
2091 x_rowtype_rec.TP_ATTRIBUTE10 := p_line_rec.TP_ATTRIBUTE10;
2092 x_rowtype_rec.TP_ATTRIBUTE11 := p_line_rec.TP_ATTRIBUTE11;
2093 x_rowtype_rec.TP_ATTRIBUTE12 := p_line_rec.TP_ATTRIBUTE12;
2094 x_rowtype_rec.TP_ATTRIBUTE13 := p_line_rec.TP_ATTRIBUTE13;
2095 x_rowtype_rec.TP_ATTRIBUTE14 := p_line_rec.TP_ATTRIBUTE14;
2096 x_rowtype_rec.TP_ATTRIBUTE15 := p_line_rec.TP_ATTRIBUTE15;
2097 x_rowtype_rec.TP_ATTRIBUTE2 := p_line_rec.TP_ATTRIBUTE2;
2098 x_rowtype_rec.TP_ATTRIBUTE3 := p_line_rec.TP_ATTRIBUTE3;
2099 x_rowtype_rec.TP_ATTRIBUTE4 := p_line_rec.TP_ATTRIBUTE4;
2100 x_rowtype_rec.TP_ATTRIBUTE5 := p_line_rec.TP_ATTRIBUTE5;
2101 x_rowtype_rec.TP_ATTRIBUTE6 := p_line_rec.TP_ATTRIBUTE6;
2102 x_rowtype_rec.TP_ATTRIBUTE7 := p_line_rec.TP_ATTRIBUTE7;
2103 x_rowtype_rec.TP_ATTRIBUTE8 := p_line_rec.TP_ATTRIBUTE8;
2104 x_rowtype_rec.TP_ATTRIBUTE9 := p_line_rec.TP_ATTRIBUTE9;
2105 x_rowtype_rec.TP_CONTEXT := p_line_rec.TP_CONTEXT;
2106 x_rowtype_rec.FIRST_ACK_CODE := p_line_rec.FIRST_ACK_CODE;
2107 x_rowtype_rec.FIRST_ACK_DATE := p_line_rec.FIRST_ACK_DATE;
2108 x_rowtype_rec.LAST_ACK_CODE := p_line_rec.LAST_ACK_CODE;
2109 x_rowtype_rec.LAST_ACK_DATE := p_line_rec.LAST_ACK_DATE;
2110 x_rowtype_rec.USER_ITEM_DESCRIPTION := p_line_rec.USER_ITEM_DESCRIPTION;
2111 -- QUOTING changes
2112 x_rowtype_rec.transaction_phase_code := p_line_rec.transaction_phase_code;
2113 x_rowtype_rec.source_document_version_number :=
2114 p_line_rec.source_document_version_number;
2115 x_rowtype_rec.IB_OWNER := p_line_rec.IB_OWNER;
2116 x_rowtype_rec.IB_INSTALLED_AT_LOCATION := p_line_rec.IB_INSTALLED_AT_LOCATION;
2117 x_rowtype_rec.IB_CURRENT_LOCATION := p_line_rec.IB_CURRENT_LOCATION;
2118 x_rowtype_rec.END_CUSTOMER_ID := p_line_rec.END_CUSTOMER_ID;
2119 x_rowtype_rec.END_CUSTOMER_CONTACT_ID := p_line_rec.END_CUSTOMER_CONTACT_ID;
2120 x_rowtype_rec.END_CUSTOMER_SITE_USE_ID := p_line_rec.END_CUSTOMER_SITE_USE_ID;
2121 --retro{
2122 x_rowtype_rec.retrobill_request_id:=p_line_rec.retrobill_request_id;
2123 --retro}
2124 --key Transaction Dates Project
2125 x_rowtype_rec.order_firmed_date := p_line_rec.order_firmed_date;
2126 x_rowtype_rec.actual_fulfillment_date := p_line_rec.actual_fulfillment_date;
2127 --Customer Acceptance
2128 x_rowtype_rec.CONTINGENCY_ID := p_line_rec.CONTINGENCY_ID;
2129 x_rowtype_rec.REVREC_EVENT_CODE := p_line_rec.REVREC_EVENT_CODE;
2130 x_rowtype_rec.REVREC_EXPIRATION_DAYS := p_line_rec.REVREC_EXPIRATION_DAYS;
2131 x_rowtype_rec.ACCEPTED_QUANTITY := p_line_rec.ACCEPTED_QUANTITY;
2132 x_rowtype_rec.REVREC_COMMENTS := p_line_rec.REVREC_COMMENTS;
2133 x_rowtype_rec.REVREC_SIGNATURE := p_line_rec.REVREC_SIGNATURE;
2134 x_rowtype_rec.REVREC_SIGNATURE_DATE := p_line_rec.REVREC_SIGNATURE_DATE;
2135 x_rowtype_rec.ACCEPTED_BY := p_line_rec.ACCEPTED_BY;
2136 x_rowtype_rec.REVREC_REFERENCE_DOCUMENT := p_line_rec.REVREC_REFERENCE_DOCUMENT;
2137 x_rowtype_rec.REVREC_IMPLICIT_FLAG := p_line_rec.REVREC_IMPLICIT_FLAG;
2138 x_rowtype_rec.charge_periodicity_code := p_line_rec.charge_periodicity_code; -- Rakesh
2139
2140
2141 EXCEPTION
2142 WHEN OTHERS THEN
2143 IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2144 THEN
2145 oe_msg_pub.Add_Exc_Msg
2146 ( G_PKG_NAME
2147 , 'API_Rec_To_RowType_Rec'
2148 );
2149 END IF;
2150 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2151 END API_Rec_To_RowType_Rec;
2152
2153
2154 PROCEDURE Rowtype_Rec_To_API_Rec
2155 ( p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2156 , x_api_rec IN OUT NOCOPY OE_Order_PUB.LINE_Rec_Type
2157 ) IS
2158 BEGIN
2159
2160 x_api_rec.ACCOUNTING_RULE_ID := p_record.ACCOUNTING_RULE_ID;
2161 x_api_rec.ACCOUNTING_RULE_DURATION := p_record.ACCOUNTING_RULE_DURATION;
2162 x_api_rec.ACTUAL_ARRIVAL_DATE := p_record.ACTUAL_ARRIVAL_DATE;
2163 x_api_rec.ACTUAL_SHIPMENT_DATE := p_record.ACTUAL_SHIPMENT_DATE;
2164 x_api_rec.AGREEMENT_ID := p_record.AGREEMENT_ID;
2165 x_api_rec.ARRIVAL_SET := p_record.ARRIVAL_SET;
2166 x_api_rec.upgraded_flag := p_record.upgraded_flag;
2167 x_api_rec.ARRIVAL_SET_ID := p_record.ARRIVAL_SET_ID;
2168 x_api_rec.ATO_LINE_ID := p_record.ATO_LINE_ID;
2169 x_api_rec.ATTRIBUTE1 := p_record.ATTRIBUTE1;
2170 x_api_rec.ATTRIBUTE10 := p_record.ATTRIBUTE10;
2171 x_api_rec.ATTRIBUTE11 := p_record.ATTRIBUTE11;
2172 x_api_rec.ATTRIBUTE12 := p_record.ATTRIBUTE12;
2173 x_api_rec.ATTRIBUTE13 := p_record.ATTRIBUTE13;
2174 x_api_rec.ATTRIBUTE14 := p_record.ATTRIBUTE14;
2175 x_api_rec.ATTRIBUTE15 := p_record.ATTRIBUTE15;
2176 x_api_rec.ATTRIBUTE16 := p_record.ATTRIBUTE16; -- For bug 2184255
2177 x_api_rec.ATTRIBUTE17 := p_record.ATTRIBUTE17;
2178 x_api_rec.ATTRIBUTE18 := p_record.ATTRIBUTE18;
2179 x_api_rec.ATTRIBUTE19 := p_record.ATTRIBUTE19;
2180 x_api_rec.ATTRIBUTE2 := p_record.ATTRIBUTE2;
2181 x_api_rec.ATTRIBUTE20 := p_record.ATTRIBUTE20;
2182 x_api_rec.ATTRIBUTE3 := p_record.ATTRIBUTE3;
2183 x_api_rec.ATTRIBUTE4 := p_record.ATTRIBUTE4;
2184 x_api_rec.ATTRIBUTE5 := p_record.ATTRIBUTE5;
2185 x_api_rec.ATTRIBUTE6 := p_record.ATTRIBUTE6;
2186 x_api_rec.ATTRIBUTE7 := p_record.ATTRIBUTE7;
2187 x_api_rec.ATTRIBUTE8 := p_record.ATTRIBUTE8;
2188 x_api_rec.ATTRIBUTE9 := p_record.ATTRIBUTE9;
2189 x_api_rec.AUTHORIZED_TO_SHIP_FLAG := p_record.AUTHORIZED_TO_SHIP_FLAG;
2190 x_api_rec.AUTO_SELECTED_QUANTITY := p_record.AUTO_SELECTED_QUANTITY;
2191 x_api_rec.BOOKED_FLAG := p_record.BOOKED_FLAG;
2192 x_api_rec.BLANKET_NUMBER := p_record.BLANKET_NUMBER;
2193 x_api_rec.BLANKET_LINE_NUMBER := p_record.BLANKET_LINE_NUMBER;
2194 x_api_rec.BLANKET_VERSION_NUMBER := p_record.BLANKET_VERSION_NUMBER;
2195 x_api_rec.CALCULATE_PRICE_FLAG := p_record.CALCULATE_PRICE_FLAG;
2196 x_api_rec.COMMITMENT_ID := p_record.COMMITMENT_ID;
2197 x_api_rec.CANCELLED_FLAG := p_record.CANCELLED_FLAG;
2198 x_api_rec.CANCELLED_QUANTITY := p_record.CANCELLED_QUANTITY;
2199 x_api_rec.CANCELLED_QUANTITY2 := p_record.CANCELLED_QUANTITY2;
2200 x_api_rec.COMPONENT_CODE := p_record.COMPONENT_CODE;
2201 x_api_rec.COMPONENT_NUMBER := p_record.COMPONENT_NUMBER;
2202 x_api_rec.COMPONENT_SEQUENCE_ID := p_record.COMPONENT_SEQUENCE_ID;
2203 x_api_rec.CONFIGURATION_ID := p_record.CONFIGURATION_ID;
2204 x_api_rec.CONFIG_DISPLAY_SEQUENCE := p_record.CONFIG_DISPLAY_SEQUENCE;
2205 x_api_rec.CONFIG_HEADER_ID := p_record.CONFIG_HEADER_ID;
2206 x_api_rec.CONFIG_REV_NBR := p_record.CONFIG_REV_NBR;
2207 x_api_rec.CONTEXT := p_record.CONTEXT;
2208 x_api_rec.CREATED_BY := p_record.CREATED_BY;
2209 x_api_rec.CREATION_DATE := p_record.CREATION_DATE;
2210 x_api_rec.CREDIT_INVOICE_LINE_ID := p_record.CREDIT_INVOICE_LINE_ID;
2211 x_api_rec.CUSTOMER_DOCK_CODE := p_record.CUSTOMER_DOCK_CODE;
2212 x_api_rec.CUSTOMER_JOB := p_record.CUSTOMER_JOB;
2213 x_api_rec.CUSTOMER_PRODUCTION_LINE := p_record.CUSTOMER_PRODUCTION_LINE;
2214 x_api_rec.CUSTOMER_TRX_LINE_ID := p_record.CUSTOMER_TRX_LINE_ID;
2215 x_api_rec.CUST_MODEL_SERIAL_NUMBER := p_record.CUST_MODEL_SERIAL_NUMBER;
2216 x_api_rec.CUST_PO_NUMBER := p_record.CUST_PO_NUMBER;
2217 x_api_rec.CUSTOMER_LINE_NUMBER := p_record.CUSTOMER_LINE_NUMBER;
2218 x_api_rec.CUST_PRODUCTION_SEQ_NUM := p_record.CUST_PRODUCTION_SEQ_NUM;
2219 x_api_rec.DELIVERY_LEAD_TIME := p_record.DELIVERY_LEAD_TIME;
2220 x_api_rec.DELIVER_TO_CONTACT_ID := p_record.DELIVER_TO_CONTACT_ID;
2221 x_api_rec.DELIVER_TO_ORG_ID := p_record.DELIVER_TO_ORG_ID;
2222 x_api_rec.DEMAND_BUCKET_TYPE_CODE := p_record.DEMAND_BUCKET_TYPE_CODE;
2223 x_api_rec.DEMAND_CLASS_CODE := p_record.DEMAND_CLASS_CODE;
2224 x_api_rec.DEP_PLAN_REQUIRED_FLAG := p_record.DEP_PLAN_REQUIRED_FLAG;
2225 x_api_rec.EARLIEST_ACCEPTABLE_DATE := p_record.EARLIEST_ACCEPTABLE_DATE;
2226 x_api_rec.END_ITEM_UNIT_NUMBER := p_record.END_ITEM_UNIT_NUMBER;
2227 x_api_rec.EXPLOSION_DATE := p_record.EXPLOSION_DATE;
2228 x_api_rec.FOB_POINT_CODE := p_record.FOB_POINT_CODE;
2229 x_api_rec.FREIGHT_CARRIER_CODE := p_record.FREIGHT_CARRIER_CODE;
2230 x_api_rec.FREIGHT_TERMS_CODE := p_record.FREIGHT_TERMS_CODE;
2231 x_api_rec.FULFILLED_QUANTITY := p_record.FULFILLED_QUANTITY;
2232 x_api_rec.FULFILLED_QUANTITY2 := p_record.FULFILLED_QUANTITY2;
2233 x_api_rec.FULFILLED_FLAG := p_record.FULFILLED_FLAG;
2234 x_api_rec.FULFILLMENT_METHOD_CODE := p_record.FULFILLMENT_METHOD_CODE;
2235 x_api_rec.FULFILLMENT_DATE := p_record.FULFILLMENT_DATE;
2236 x_api_rec.GLOBAL_ATTRIBUTE1 := p_record.GLOBAL_ATTRIBUTE1;
2237 x_api_rec.GLOBAL_ATTRIBUTE10 := p_record.GLOBAL_ATTRIBUTE10;
2238 x_api_rec.GLOBAL_ATTRIBUTE11 := p_record.GLOBAL_ATTRIBUTE11;
2239 x_api_rec.GLOBAL_ATTRIBUTE12 := p_record.GLOBAL_ATTRIBUTE12;
2240 x_api_rec.GLOBAL_ATTRIBUTE13 := p_record.GLOBAL_ATTRIBUTE13;
2241 x_api_rec.GLOBAL_ATTRIBUTE14 := p_record.GLOBAL_ATTRIBUTE14;
2242 x_api_rec.GLOBAL_ATTRIBUTE15 := p_record.GLOBAL_ATTRIBUTE15;
2243 x_api_rec.GLOBAL_ATTRIBUTE16 := p_record.GLOBAL_ATTRIBUTE16;
2244 x_api_rec.GLOBAL_ATTRIBUTE17 := p_record.GLOBAL_ATTRIBUTE17;
2245 x_api_rec.GLOBAL_ATTRIBUTE18 := p_record.GLOBAL_ATTRIBUTE18;
2246 x_api_rec.GLOBAL_ATTRIBUTE19 := p_record.GLOBAL_ATTRIBUTE19;
2247 x_api_rec.GLOBAL_ATTRIBUTE2 := p_record.GLOBAL_ATTRIBUTE2;
2248 x_api_rec.GLOBAL_ATTRIBUTE20 := p_record.GLOBAL_ATTRIBUTE20;
2249 x_api_rec.GLOBAL_ATTRIBUTE3 := p_record.GLOBAL_ATTRIBUTE3;
2250 x_api_rec.GLOBAL_ATTRIBUTE4 := p_record.GLOBAL_ATTRIBUTE4;
2251 x_api_rec.GLOBAL_ATTRIBUTE5 := p_record.GLOBAL_ATTRIBUTE5;
2252 x_api_rec.GLOBAL_ATTRIBUTE6 := p_record.GLOBAL_ATTRIBUTE6;
2253 x_api_rec.GLOBAL_ATTRIBUTE7 := p_record.GLOBAL_ATTRIBUTE7;
2254 x_api_rec.GLOBAL_ATTRIBUTE8 := p_record.GLOBAL_ATTRIBUTE8;
2255 x_api_rec.GLOBAL_ATTRIBUTE9 := p_record.GLOBAL_ATTRIBUTE9;
2256 x_api_rec.GLOBAL_ATTRIBUTE_CATEGORY := p_record.GLOBAL_ATTRIBUTE_CATEGORY;
2257 x_api_rec.HEADER_ID := p_record.HEADER_ID;
2258 x_api_rec.INDUSTRY_ATTRIBUTE1 := p_record.INDUSTRY_ATTRIBUTE1;
2259 x_api_rec.INDUSTRY_ATTRIBUTE10 := p_record.INDUSTRY_ATTRIBUTE10;
2260 x_api_rec.INDUSTRY_ATTRIBUTE11 := p_record.INDUSTRY_ATTRIBUTE11;
2261 x_api_rec.INDUSTRY_ATTRIBUTE12 := p_record.INDUSTRY_ATTRIBUTE12;
2262 x_api_rec.INDUSTRY_ATTRIBUTE13 := p_record.INDUSTRY_ATTRIBUTE13;
2263 x_api_rec.INDUSTRY_ATTRIBUTE14 := p_record.INDUSTRY_ATTRIBUTE14;
2264 x_api_rec.INDUSTRY_ATTRIBUTE15 := p_record.INDUSTRY_ATTRIBUTE15;
2265 x_api_rec.INDUSTRY_ATTRIBUTE16 := p_record.INDUSTRY_ATTRIBUTE16;
2266 x_api_rec.INDUSTRY_ATTRIBUTE17 := p_record.INDUSTRY_ATTRIBUTE17;
2267 x_api_rec.INDUSTRY_ATTRIBUTE18 := p_record.INDUSTRY_ATTRIBUTE18;
2268 x_api_rec.INDUSTRY_ATTRIBUTE19 := p_record.INDUSTRY_ATTRIBUTE19;
2269 x_api_rec.INDUSTRY_ATTRIBUTE2 := p_record.INDUSTRY_ATTRIBUTE2;
2270 x_api_rec.INDUSTRY_ATTRIBUTE20 := p_record.INDUSTRY_ATTRIBUTE20;
2271 x_api_rec.INDUSTRY_ATTRIBUTE21 := p_record.INDUSTRY_ATTRIBUTE21;
2272 x_api_rec.INDUSTRY_ATTRIBUTE22 := p_record.INDUSTRY_ATTRIBUTE22;
2273 x_api_rec.INDUSTRY_ATTRIBUTE23 := p_record.INDUSTRY_ATTRIBUTE23;
2274 x_api_rec.INDUSTRY_ATTRIBUTE24 := p_record.INDUSTRY_ATTRIBUTE24;
2275 x_api_rec.INDUSTRY_ATTRIBUTE25 := p_record.INDUSTRY_ATTRIBUTE25;
2276 x_api_rec.INDUSTRY_ATTRIBUTE26 := p_record.INDUSTRY_ATTRIBUTE26;
2277 x_api_rec.INDUSTRY_ATTRIBUTE27 := p_record.INDUSTRY_ATTRIBUTE27;
2278 x_api_rec.INDUSTRY_ATTRIBUTE28 := p_record.INDUSTRY_ATTRIBUTE28;
2279 x_api_rec.INDUSTRY_ATTRIBUTE29 := p_record.INDUSTRY_ATTRIBUTE29;
2280 x_api_rec.INDUSTRY_ATTRIBUTE3 := p_record.INDUSTRY_ATTRIBUTE3;
2281 x_api_rec.INDUSTRY_ATTRIBUTE30 := p_record.INDUSTRY_ATTRIBUTE30;
2282 x_api_rec.INDUSTRY_ATTRIBUTE4 := p_record.INDUSTRY_ATTRIBUTE4;
2283 x_api_rec.INDUSTRY_ATTRIBUTE5 := p_record.INDUSTRY_ATTRIBUTE5;
2284 x_api_rec.INDUSTRY_ATTRIBUTE6 := p_record.INDUSTRY_ATTRIBUTE6;
2285 x_api_rec.INDUSTRY_ATTRIBUTE7 := p_record.INDUSTRY_ATTRIBUTE7;
2286 x_api_rec.INDUSTRY_ATTRIBUTE8 := p_record.INDUSTRY_ATTRIBUTE8;
2287 x_api_rec.INDUSTRY_ATTRIBUTE9 := p_record.INDUSTRY_ATTRIBUTE9;
2288 x_api_rec.INDUSTRY_CONTEXT := p_record.INDUSTRY_CONTEXT;
2289 x_api_rec.INTERMED_SHIP_TO_CONTACT_ID := p_record.INTERMED_SHIP_TO_CONTACT_ID;
2290 x_api_rec.INTERMED_SHIP_TO_ORG_ID := p_record.INTERMED_SHIP_TO_ORG_ID;
2291 x_api_rec.INVENTORY_ITEM_ID := p_record.INVENTORY_ITEM_ID;
2292 x_api_rec.INVOICE_INTERFACE_STATUS_CODE := p_record.INVOICE_INTERFACE_STATUS_CODE;
2293 x_api_rec.INVOICE_TO_CONTACT_ID := p_record.INVOICE_TO_CONTACT_ID;
2294 x_api_rec.INVOICE_TO_ORG_ID := p_record.INVOICE_TO_ORG_ID;
2295 x_api_rec.INVOICED_QUANTITY := p_record.INVOICED_QUANTITY;
2296 x_api_rec.INVOICING_RULE_ID := p_record.INVOICING_RULE_ID;
2297 x_api_rec.ORDERED_ITEM_ID := p_record.ORDERED_ITEM_ID;
2298 x_api_rec.ITEM_IDENTIFIER_TYPE := p_record.ITEM_IDENTIFIER_TYPE;
2299 x_api_rec.ORDERED_ITEM := p_record.ORDERED_ITEM;
2300 x_api_rec.ITEM_REVISION := p_record.ITEM_REVISION;
2301 x_api_rec.ITEM_TYPE_CODE := p_record.ITEM_TYPE_CODE;
2302 x_api_rec.LAST_UPDATED_BY := p_record.LAST_UPDATED_BY;
2303 x_api_rec.LAST_UPDATE_DATE := p_record.LAST_UPDATE_DATE;
2304 x_api_rec.LAST_UPDATE_LOGIN := p_record.LAST_UPDATE_LOGIN;
2305 x_api_rec.LATEST_ACCEPTABLE_DATE := p_record.LATEST_ACCEPTABLE_DATE;
2306 x_api_rec.LINE_CATEGORY_CODE := p_record.LINE_CATEGORY_CODE;
2307 x_api_rec.LINE_ID := p_record.LINE_ID;
2308 x_api_rec.LINE_NUMBER := p_record.LINE_NUMBER;
2309 x_api_rec.LINE_TYPE_ID := p_record.LINE_TYPE_ID;
2310 x_api_rec.LINK_TO_LINE_ID := p_record.LINK_TO_LINE_ID;
2311 x_api_rec.MFG_COMPONENT_SEQUENCE_ID := p_record.MFG_COMPONENT_SEQUENCE_ID;
2312 x_api_rec.MODEL_GROUP_NUMBER := p_record.MODEL_GROUP_NUMBER;
2313 x_api_rec.OPEN_FLAG := p_record.OPEN_FLAG;
2314 x_api_rec.OPTION_FLAG := p_record.OPTION_FLAG;
2315 x_api_rec.OPTION_NUMBER := p_record.OPTION_NUMBER;
2316 x_api_rec.ORDERED_QUANTITY := p_record.ORDERED_QUANTITY;
2317 x_api_rec.ORDERED_QUANTITY2 := p_record.ORDERED_QUANTITY2;
2318 x_api_rec.ORDER_QUANTITY_UOM := p_record.ORDER_QUANTITY_UOM;
2319 x_api_rec.ORDERED_QUANTITY_UOM2 := p_record.ORDERED_QUANTITY_UOM2;
2320 x_api_rec.ORG_ID := p_record.ORG_ID;
2321 x_api_rec.ORIG_SYS_DOCUMENT_REF := p_record.ORIG_SYS_DOCUMENT_REF;
2322 x_api_rec.ORIG_SYS_LINE_REF := p_record.ORIG_SYS_LINE_REF;
2323 x_api_rec.OVER_SHIP_REASON_CODE := p_record.OVER_SHIP_REASON_CODE;
2324 x_api_rec.OVER_SHIP_RESOLVED_FLAG := p_record.OVER_SHIP_RESOLVED_FLAG;
2325 x_api_rec.PACKING_INSTRUCTIONS := p_record.PACKING_INSTRUCTIONS;
2326 x_api_rec.PAYMENT_TERM_ID := p_record.PAYMENT_TERM_ID;
2327 x_api_rec.PLANNING_PRIORITY := p_record.PLANNING_PRIORITY;
2328 x_api_rec.PREFERRED_GRADE := p_record.PREFERRED_GRADE;
2329 x_api_rec.PRICE_LIST_ID := p_record.PRICE_LIST_ID;
2330 x_api_rec.PRICE_REQUEST_CODE := p_record.PRICE_REQUEST_CODE; -- PROMOTIONS SEP/01
2331 x_api_rec.PRICING_ATTRIBUTE1 := p_record.PRICING_ATTRIBUTE1;
2332 x_api_rec.PRICING_ATTRIBUTE10 := p_record.PRICING_ATTRIBUTE10;
2333 x_api_rec.PRICING_ATTRIBUTE2 := p_record.PRICING_ATTRIBUTE2;
2334 x_api_rec.PRICING_ATTRIBUTE3 := p_record.PRICING_ATTRIBUTE3;
2335 x_api_rec.PRICING_ATTRIBUTE4 := p_record.PRICING_ATTRIBUTE4;
2336 x_api_rec.PRICING_ATTRIBUTE5 := p_record.PRICING_ATTRIBUTE5;
2337 x_api_rec.PRICING_ATTRIBUTE6 := p_record.PRICING_ATTRIBUTE6;
2338 x_api_rec.PRICING_ATTRIBUTE7 := p_record.PRICING_ATTRIBUTE7;
2339 x_api_rec.PRICING_ATTRIBUTE8 := p_record.PRICING_ATTRIBUTE8;
2340 x_api_rec.PRICING_ATTRIBUTE9 := p_record.PRICING_ATTRIBUTE9;
2341 x_api_rec.PRICING_CONTEXT := p_record.PRICING_CONTEXT;
2342 x_api_rec.PRICING_DATE := p_record.PRICING_DATE;
2343 x_api_rec.PRICING_QUANTITY := p_record.PRICING_QUANTITY;
2344 x_api_rec.PRICING_QUANTITY_UOM := p_record.PRICING_QUANTITY_UOM;
2345 x_api_rec.PROGRAM_APPLICATION_ID := p_record.PROGRAM_APPLICATION_ID;
2346 x_api_rec.PROGRAM_ID := p_record.PROGRAM_ID;
2347 x_api_rec.PROGRAM_UPDATE_DATE := p_record.PROGRAM_UPDATE_DATE;
2348 x_api_rec.PROJECT_ID := p_record.PROJECT_ID;
2349 x_api_rec.PROMISE_DATE := p_record.PROMISE_DATE;
2350 x_api_rec.RE_SOURCE_FLAG := p_record.RE_SOURCE_FLAG;
2351 x_api_rec.REFERENCE_CUSTOMER_TRX_LINE_ID
2352 := p_record.REFERENCE_CUSTOMER_TRX_LINE_ID;
2353 x_api_rec.REFERENCE_HEADER_ID := p_record.REFERENCE_HEADER_ID;
2354 x_api_rec.REFERENCE_LINE_ID := p_record.REFERENCE_LINE_ID;
2355 x_api_rec.REFERENCE_TYPE := p_record.REFERENCE_TYPE;
2356 x_api_rec.REQUEST_DATE := p_record.REQUEST_DATE;
2357 x_api_rec.REQUEST_ID := p_record.REQUEST_ID;
2358 -- Commenting this to fix bug 1391988.
2359 -- x_api_rec.RESERVED_QUANTITY := p_record.RESERVED_QUANTITY;
2360 x_api_rec.RETURN_ATTRIBUTE1 := p_record.RETURN_ATTRIBUTE1;
2361 x_api_rec.RETURN_ATTRIBUTE10 := p_record.RETURN_ATTRIBUTE10;
2362 x_api_rec.RETURN_ATTRIBUTE11 := p_record.RETURN_ATTRIBUTE11;
2363 x_api_rec.RETURN_ATTRIBUTE12 := p_record.RETURN_ATTRIBUTE12;
2364 x_api_rec.RETURN_ATTRIBUTE13 := p_record.RETURN_ATTRIBUTE13;
2365 x_api_rec.RETURN_ATTRIBUTE14 := p_record.RETURN_ATTRIBUTE14;
2366 x_api_rec.RETURN_ATTRIBUTE15 := p_record.RETURN_ATTRIBUTE15;
2367 x_api_rec.RETURN_ATTRIBUTE2 := p_record.RETURN_ATTRIBUTE2;
2368 x_api_rec.RETURN_ATTRIBUTE3 := p_record.RETURN_ATTRIBUTE3;
2369 x_api_rec.RETURN_ATTRIBUTE4 := p_record.RETURN_ATTRIBUTE4;
2370 x_api_rec.RETURN_ATTRIBUTE5 := p_record.RETURN_ATTRIBUTE5;
2371 x_api_rec.RETURN_ATTRIBUTE6 := p_record.RETURN_ATTRIBUTE6;
2372 x_api_rec.RETURN_ATTRIBUTE7 := p_record.RETURN_ATTRIBUTE7;
2373 x_api_rec.RETURN_ATTRIBUTE8 := p_record.RETURN_ATTRIBUTE8;
2374 x_api_rec.RETURN_ATTRIBUTE9 := p_record.RETURN_ATTRIBUTE9;
2375 x_api_rec.RETURN_CONTEXT := p_record.RETURN_CONTEXT;
2376 x_api_rec.RETURN_REASON_CODE := p_record.RETURN_REASON_CODE;
2377 x_api_rec.RLA_SCHEDULE_TYPE_CODE := p_record.RLA_SCHEDULE_TYPE_CODE;
2378 x_api_rec.SALESREP_ID := p_record.SALESREP_ID;
2379 x_api_rec.SCHEDULE_ACTION_CODE := p_record.SCHEDULE_ACTION_CODE;
2380 x_api_rec.SPLIT_ACTION_CODE := p_record.SPLIT_ACTION_CODE;
2381 x_api_rec.SCHEDULE_ARRIVAL_DATE := p_record.SCHEDULE_ARRIVAL_DATE;
2382 x_api_rec.SCHEDULE_SHIP_DATE := p_record.SCHEDULE_SHIP_DATE;
2383 x_api_rec.SCHEDULE_STATUS_CODE := p_record.SCHEDULE_STATUS_CODE;
2384 x_api_rec.SHIPMENT_NUMBER := p_record.SHIPMENT_NUMBER;
2385 x_api_rec.SHIPMENT_PRIORITY_CODE := p_record.SHIPMENT_PRIORITY_CODE;
2386 x_api_rec.SHIPPED_QUANTITY := p_record.SHIPPED_QUANTITY;
2387 x_api_rec.SHIPPED_QUANTITY2 := p_record.SHIPPED_QUANTITY2;
2388 x_api_rec.SHIPPING_INTERFACED_FLAG := p_record.SHIPPING_INTERFACED_FLAG;
2389 x_api_rec.SHIPPING_INSTRUCTIONS := p_record.SHIPPING_INSTRUCTIONS;
2390 x_api_rec.SHIPPING_METHOD_CODE := p_record.SHIPPING_METHOD_CODE;
2391 x_api_rec.SHIPPING_QUANTITY := p_record.SHIPPING_QUANTITY;
2392 x_api_rec.SHIPPING_QUANTITY2 := p_record.SHIPPING_QUANTITY2;
2393 x_api_rec.SHIPPING_QUANTITY_UOM := p_record.SHIPPING_QUANTITY_UOM;
2394 x_api_rec.SHIPPING_QUANTITY_UOM2 := p_record.SHIPPING_QUANTITY_UOM2;
2395 x_api_rec.SHIP_FROM_ORG_ID := p_record.SHIP_FROM_ORG_ID;
2396 x_api_rec.SUBINVENTORY := p_record.SUBINVENTORY;
2397 x_api_rec.SHIP_MODEL_COMPLETE_FLAG := p_record.SHIP_MODEL_COMPLETE_FLAG;
2398 x_api_rec.SHIP_SET := p_record.SHIP_SET;
2399 x_api_rec.SHIP_SET_ID := p_record.SHIP_SET_ID;
2400 x_api_rec.SHIP_TOLERANCE_ABOVE := p_record.SHIP_TOLERANCE_ABOVE;
2401 x_api_rec.SHIP_TOLERANCE_BELOW := p_record.SHIP_TOLERANCE_BELOW;
2402 x_api_rec.SHIP_TO_CONTACT_ID := p_record.SHIP_TO_CONTACT_ID;
2403 x_api_rec.SHIP_TO_ORG_ID := p_record.SHIP_TO_ORG_ID;
2404 x_api_rec.SOLD_FROM_ORG_ID := p_record.SOLD_FROM_ORG_ID;
2405 x_api_rec.SOLD_TO_ORG_ID := p_record.SOLD_TO_ORG_ID;
2406 x_api_rec.SORT_ORDER := p_record.SORT_ORDER;
2407 x_api_rec.SOURCE_DOCUMENT_ID := p_record.SOURCE_DOCUMENT_ID;
2408 x_api_rec.SOURCE_DOCUMENT_LINE_ID := p_record.SOURCE_DOCUMENT_LINE_ID;
2409 x_api_rec.SOURCE_DOCUMENT_TYPE_ID := p_record.SOURCE_DOCUMENT_TYPE_ID;
2410 x_api_rec.SOURCE_TYPE_CODE := p_record.SOURCE_TYPE_CODE;
2411 x_api_rec.SPLIT_FROM_LINE_ID := p_record.SPLIT_FROM_LINE_ID;
2412 x_api_rec.LINE_SET_ID := p_record.LINE_SET_ID;
2413 x_api_rec.SPLIT_BY := p_record.SPLIT_BY;
2414 x_api_rec.Model_remnant_flag := p_record.Model_Remnant_Flag;
2415 x_api_rec.TASK_ID := p_record.TASK_ID;
2416 x_api_rec.TAX_CODE := p_record.TAX_CODE;
2417 x_api_rec.TAX_DATE := p_record.TAX_DATE;
2418 x_api_rec.TAX_EXEMPT_FLAG := p_record.TAX_EXEMPT_FLAG;
2419 x_api_rec.TAX_EXEMPT_NUMBER := p_record.TAX_EXEMPT_NUMBER;
2420 x_api_rec.TAX_EXEMPT_REASON_CODE := p_record.TAX_EXEMPT_REASON_CODE;
2421 x_api_rec.TAX_POINT_CODE := p_record.TAX_POINT_CODE;
2422 x_api_rec.TAX_RATE := p_record.TAX_RATE;
2423 x_api_rec.TAX_VALUE := p_record.TAX_VALUE;
2424 x_api_rec.TOP_MODEL_LINE_ID := p_record.TOP_MODEL_LINE_ID;
2425 x_api_rec.UNIT_LIST_PRICE := p_record.UNIT_LIST_PRICE;
2426 x_api_rec.UNIT_SELLING_PRICE := p_record.UNIT_SELLING_PRICE;
2427 x_api_rec.UNIT_LIST_PRICE_PER_PQTY := p_record.UNIT_LIST_PRICE_PER_PQTY;
2428 x_api_rec.UNIT_SELLING_PRICE_PER_PQTY := p_record.UNIT_SELLING_PRICE_PER_PQTY;
2429 x_api_rec.VEH_CUS_ITEM_CUM_KEY_ID := p_record.VEH_CUS_ITEM_CUM_KEY_ID;
2430 x_api_rec.VISIBLE_DEMAND_FLAG := p_record.VISIBLE_DEMAND_FLAG;
2431 x_api_rec.OPERATION := p_record.OPERATION;
2432 x_api_rec.RETURN_STATUS := p_record.RETURN_STATUS;
2433 x_api_rec.DB_FLAG := p_record.DB_FLAG;
2434 x_api_rec.CHANGE_REASON := p_record.CHANGE_REASON;
2435 x_api_rec.CHANGE_COMMENTS := p_record.CHANGE_COMMENTS;
2436 x_api_rec.SHIPPABLE_FLAG := p_record.SHIPPABLE_FLAG;
2437 x_api_rec.SERVICE_TXN_REASON_CODE := p_record.SERVICE_TXN_REASON_CODE;
2438 x_api_rec.SERVICE_DURATION := p_record.SERVICE_DURATION;
2439 x_api_rec.SERVICE_PERIOD := p_record.SERVICE_PERIOD;
2440 x_api_rec.SERVICE_START_DATE := p_record.SERVICE_START_DATE;
2441 x_api_rec.SERVICE_END_DATE := p_record.SERVICE_END_DATE;
2442 x_api_rec.SERVICE_COTERMINATE_FLAG := p_record.SERVICE_COTERMINATE_FLAG;
2443 x_api_rec.SERVICE_TXN_COMMENTS := p_record.SERVICE_TXN_COMMENTS;
2444 x_api_rec.UNIT_SELLING_PERCENT := p_record.UNIT_SELLING_PERCENT;
2445 x_api_rec.UNIT_LIST_PERCENT := p_record.UNIT_LIST_PERCENT;
2446 x_api_rec.UNIT_PERCENT_BASE_PRICE := p_record.UNIT_PERCENT_BASE_PRICE;
2447 x_api_rec.SERVICE_NUMBER := p_record.SERVICE_NUMBER;
2448 x_api_rec.SERVICE_REFERENCE_TYPE_CODE := p_record.SERVICE_REFERENCE_TYPE_CODE;
2449 x_api_rec.SERVICE_REFERENCE_LINE_ID := p_record.SERVICE_REFERENCE_LINE_ID;
2450 x_api_rec.SERVICE_REFERENCE_SYSTEM_ID := p_record.SERVICE_REFERENCE_SYSTEM_ID;
2451 x_api_rec.FLOW_STATUS_CODE := p_record.FLOW_STATUS_CODE;
2452 x_api_rec.TP_ATTRIBUTE1 := p_record.TP_ATTRIBUTE1;
2453 x_api_rec.TP_ATTRIBUTE10 := p_record.TP_ATTRIBUTE10;
2454 x_api_rec.TP_ATTRIBUTE11 := p_record.TP_ATTRIBUTE11;
2455 x_api_rec.TP_ATTRIBUTE12 := p_record.TP_ATTRIBUTE12;
2456 x_api_rec.TP_ATTRIBUTE13 := p_record.TP_ATTRIBUTE13;
2457 x_api_rec.TP_ATTRIBUTE14 := p_record.TP_ATTRIBUTE14;
2458 x_api_rec.TP_ATTRIBUTE15 := p_record.TP_ATTRIBUTE15;
2459 x_api_rec.TP_ATTRIBUTE2 := p_record.TP_ATTRIBUTE2;
2460 x_api_rec.TP_ATTRIBUTE3 := p_record.TP_ATTRIBUTE3;
2461 x_api_rec.TP_ATTRIBUTE4 := p_record.TP_ATTRIBUTE4;
2462 x_api_rec.TP_ATTRIBUTE5 := p_record.TP_ATTRIBUTE5;
2463 x_api_rec.TP_ATTRIBUTE6 := p_record.TP_ATTRIBUTE6;
2464 x_api_rec.TP_ATTRIBUTE7 := p_record.TP_ATTRIBUTE7;
2465 x_api_rec.TP_ATTRIBUTE8 := p_record.TP_ATTRIBUTE8;
2466 x_api_rec.TP_ATTRIBUTE9 := p_record.TP_ATTRIBUTE9;
2467 x_api_rec.TP_CONTEXT := p_record.TP_CONTEXT;
2468 x_api_rec.FIRST_ACK_CODE := p_record.FIRST_ACK_CODE;
2469 x_api_rec.FIRST_ACK_DATE := p_record.FIRST_ACK_DATE;
2470 x_api_rec.LAST_ACK_CODE := p_record.LAST_ACK_CODE;
2471 x_api_rec.LAST_ACK_DATE := p_record.LAST_ACK_DATE;
2472 x_api_rec.USER_ITEM_DESCRIPTION := p_record.USER_ITEM_DESCRIPTION;
2473 -- QUOTING changes
2474 x_api_rec.transaction_phase_code := p_record.transaction_phase_code;
2475 x_api_rec.source_document_version_number :=
2476 p_record.source_document_version_number;
2477 x_api_rec.IB_OWNER := p_record.IB_OWNER;
2478 x_api_rec.IB_INSTALLED_AT_LOCATION := p_record.IB_INSTALLED_AT_LOCATION;
2479 x_api_rec.IB_CURRENT_LOCATION := p_record.IB_CURRENT_LOCATION;
2480 x_api_rec.END_CUSTOMER_ID := p_record.END_CUSTOMER_ID;
2481 x_api_rec.END_CUSTOMER_CONTACT_ID := p_record.END_CUSTOMER_CONTACT_ID;
2482 x_api_rec.END_CUSTOMER_SITE_USE_ID := p_record.END_CUSTOMER_SITE_USE_ID;
2483
2484 --retro{
2485 x_api_rec.retrobill_request_id := p_record.retrobill_request_id;
2486 --retro}
2487 --key Transaction dates Project
2488 x_api_rec.order_firmed_date := p_record.order_firmed_date;
2489 x_api_rec.actual_fulfillment_date := p_record.actual_fulfillment_date;
2490 --Customer Acceptance
2491 x_api_rec.CONTINGENCY_ID := p_record.CONTINGENCY_ID;
2492 x_api_rec.REVREC_EVENT_CODE := p_record.REVREC_EVENT_CODE;
2493 x_api_rec.REVREC_EXPIRATION_DAYS := p_record.REVREC_EXPIRATION_DAYS;
2494 x_api_rec.ACCEPTED_QUANTITY := p_record.ACCEPTED_QUANTITY;
2495 x_api_rec.REVREC_COMMENTS := p_record.REVREC_COMMENTS;
2496 x_api_rec.REVREC_SIGNATURE := p_record.REVREC_SIGNATURE;
2497 x_api_rec.REVREC_SIGNATURE_DATE := p_record.REVREC_SIGNATURE_DATE;
2498 x_api_rec.ACCEPTED_BY := p_record.ACCEPTED_BY;
2499 x_api_rec.REVREC_REFERENCE_DOCUMENT := p_record.REVREC_REFERENCE_DOCUMENT;
2500 x_api_rec.REVREC_IMPLICIT_FLAG := p_record.REVREC_IMPLICIT_FLAG;
2501 x_api_rec.charge_periodicity_code := p_record.charge_periodicity_code; --Rakesh
2502
2503 EXCEPTION
2504 WHEN OTHERS THEN
2505 IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2506 THEN
2507 oe_msg_pub.Add_Exc_Msg
2508 ( G_PKG_NAME
2509 , 'Rowtype_Rec_To_API_Rec'
2510 );
2511 END IF;
2512 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2513 END Rowtype_Rec_To_API_Rec;
2514
2515 -- PROCEDURE Clear_Dependent_Attr
2516 -- This version of the clear dependent attributes procedure is called
2517 -- from the generated entity defaulting handler packages to clear
2518 -- the dependents if the new defaulted value is different from the
2519 -- old value on the record. The record types here of view%rowtype
2520 -- as the defaulting packages operate only on these record types.
2521 -- Arguments:
2522 -- p_attr_id: if passed, then clear attributes dependent only on
2523 -- this attribute else compare p_old_line_rec and p_line_rec
2524 -- and clear attributes dependent on all the change attributes
2525 -- p_initial_line_rec: this is the initial record passed to the process
2526 -- order or the defaulting APIs and is used to identify which
2527 -- attributes are user-specified so that they are not cleared
2528 -- p_old_line_rec: the old record as it was before the changes
2529 -- p_x_line_rec: the current record with the user-specified changes and
2530 -- attributes that may have defaulted prior to this call
2531 PROCEDURE Clear_Dependent_Attr
2532 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
2533 , p_initial_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
2534 , p_old_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
2535 , p_x_line_rec IN OUT NOCOPY OE_AK_ORDER_LINES_V%ROWTYPE
2536 )
2537 IS
2538 l_index NUMBER :=0;
2539 l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
2540 l_dep_attr_exists VARCHAR2(1);
2541 BEGIN
2542
2543 oe_debug_pub.add('Entering OE_LINE_UTIL.CLEAR_DEPENDENT_ATTR', 1);
2544 oe_debug_pub.add('Attr Id: '||p_attr_id);
2545
2546
2547 IF p_attr_id <> FND_API.G_MISS_NUM THEN
2548
2549 l_index := l_index + 1.0;
2550 l_src_attr_tbl(l_index) := p_attr_id;
2551
2552 -- If attr_id is missing compare old and new records and for
2553 -- every changed attribute clear its dependent fields.
2554
2555 ELSE
2556
2557 IF NOT OE_GLOBALS.Equal(p_x_line_rec.ACCOUNTING_RULE_ID,p_old_line_rec.ACCOUNTING_RULE_ID)
2558 THEN
2559 l_index := l_index + 1.0;
2560 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ACCOUNTING_RULE;
2561 END IF;
2562
2563 IF NOT OE_GLOBALS.Equal(p_x_line_rec.AGREEMENT_ID,p_old_line_rec.AGREEMENT_ID)
2564 THEN
2565 l_index := l_index + 1.0;
2566 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_AGREEMENT;
2567 END IF;
2568
2569 IF NOT OE_GLOBALS.Equal(p_x_line_rec.blanket_number,p_old_line_rec.blanket_number)
2570 THEN
2571 l_index := l_index + 1.0;
2572 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_BLANKET_NUMBER;
2573 END IF;
2574
2575 IF NOT OE_GLOBALS.Equal(p_x_line_rec.blanket_line_number,p_old_line_rec.blanket_line_number)
2576 THEN
2577 l_index := l_index + 1.0;
2578 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_BLANKET_LINE_NUMBER;
2579 END IF;
2580
2581 --bug5160469
2582 IF NOT OE_GLOBALS.Equal(p_x_line_rec.commitment_id,p_old_line_rec.commitment_id)
2583 THEN
2584 l_index := l_index + 1.0;
2585 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_COMMITMENT;
2586 END IF;
2587
2588 IF NOT OE_GLOBALS.Equal(p_x_line_rec.DELIVER_TO_ORG_ID,p_old_line_rec.DELIVER_TO_ORG_ID)
2589 THEN
2590 l_index := l_index + 1.0;
2591 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_DELIVER_TO_ORG;
2592 END IF;
2593
2594 IF NOT OE_GLOBALS.Equal(p_x_line_rec.INTERMED_SHIP_TO_ORG_ID,p_old_line_rec.INTERMED_SHIP_TO_ORG_ID)
2595 THEN
2596 l_index := l_index + 1.0;
2597 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INTERMED_SHIP_TO_ORG;
2598 END IF;
2599
2600
2601
2602 IF NOT OE_GLOBALS.Equal(p_x_line_rec.INVENTORY_ITEM_ID,p_old_line_rec.INVENTORY_ITEM_ID)
2603 THEN
2604 l_index := l_index + 1.0;
2605 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INVENTORY_ITEM;
2606 END IF;
2607
2608 IF NOT OE_GLOBALS.Equal(p_x_line_rec.INVOICE_TO_ORG_ID,p_old_line_rec.INVOICE_TO_ORG_ID)
2609 THEN
2610 l_index := l_index + 1.0;
2611 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INVOICE_TO_ORG;
2612 END IF;
2613
2614 IF NOT OE_GLOBALS.Equal(p_x_line_rec.LINE_NUMBER,p_old_line_rec.LINE_NUMBER)
2615 THEN
2616 l_index := l_index + 1.0;
2617 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_LINE_NUMBER;
2618 END IF;
2619
2620 IF NOT OE_GLOBALS.Equal(p_x_line_rec.LINE_TYPE_ID,p_old_line_rec.LINE_TYPE_ID)
2621 THEN
2622 l_index := l_index + 1.0;
2623 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_LINE_TYPE;
2624 END IF;
2625
2626 IF NOT OE_GLOBALS.Equal(p_x_line_rec.PRICE_LIST_ID,p_old_line_rec.PRICE_LIST_ID)
2627 THEN
2628 l_index := l_index + 1.0;
2629 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PRICE_LIST;
2630 END IF;
2631
2632 IF NOT OE_GLOBALS.Equal(p_x_line_rec.PROMISE_DATE,p_old_line_rec.PROMISE_DATE)
2633 THEN
2634 l_index := l_index + 1.0;
2635 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PROMISE_DATE;
2636 END IF;
2637
2638 IF NOT OE_GLOBALS.Equal(p_x_line_rec.REQUEST_DATE,p_old_line_rec.REQUEST_DATE)
2639 THEN
2640 l_index := l_index + 1.0;
2641 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_REQUEST_DATE;
2642 END IF;
2643
2644 IF NOT OE_GLOBALS.Equal(p_x_line_rec.SCHEDULE_SHIP_DATE,p_old_line_rec.SCHEDULE_SHIP_DATE)
2645 THEN
2646 l_index := l_index + 1.0;
2647 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE;
2648 END IF;
2649
2650 IF NOT OE_GLOBALS.Equal(p_x_line_rec.SHIP_FROM_ORG_ID,p_old_line_rec.SHIP_FROM_ORG_ID)
2651 THEN
2652 l_index := l_index + 1.0;
2653 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SHIP_FROM_ORG;
2654 END IF;
2655
2656 IF NOT OE_GLOBALS.Equal(p_x_line_rec.SUBINVENTORY,p_old_line_rec.SUBINVENTORY)
2657 THEN
2658 l_index := l_index + 1.0;
2659 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SUBINVENTORY;
2660 END IF;
2661
2662 IF NOT OE_GLOBALS.Equal(p_x_line_rec.SHIP_TO_ORG_ID,p_old_line_rec.SHIP_TO_ORG_ID)
2663 THEN
2664 l_index := l_index + 1.0;
2665 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SHIP_TO_ORG;
2666 END IF;
2667
2668 IF NOT OE_GLOBALS.Equal(p_x_line_rec.SOLD_TO_ORG_ID,p_old_line_rec.SOLD_TO_ORG_ID)
2669 THEN
2670 l_index := l_index + 1.0;
2671 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SOLD_TO_ORG;
2672 END IF;
2673
2674 IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_CODE,p_old_line_rec.TAX_CODE)
2675 THEN
2676 l_index := l_index + 1.0;
2677 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX;
2678 END IF;
2679
2680 IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_DATE,p_old_line_rec.TAX_DATE)
2681 THEN
2682 l_index := l_index + 1.0;
2683 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX_DATE;
2684 END IF;
2685
2686 IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_EXEMPT_FLAG,p_old_line_rec.TAX_EXEMPT_FLAG)
2687 THEN
2688 l_index := l_index + 1.0;
2689 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX_EXEMPT;
2690 END IF;
2691 --Added following condition for Bug 2245073
2692 IF NOT OE_GLOBALS.Equal(p_x_line_rec.PRICING_DATE, p_old_line_rec.PRICING_DATE
2693 ) Then
2694 l_index := l_index + 1.0;
2695 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PRICING_DATE;
2696 End If;
2697
2698 -- The next two IF statements added for bug 5076119
2699 IF NOT OE_GLOBALS.Equal(p_x_line_rec.ORDERED_QUANTITY, p_old_line_rec.ORDERED_QUANTITY)
2700 THEN
2701 l_index := l_index + 1.0;
2702 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ORDERED_QUANTITY;
2703 END IF;
2704
2705 IF NOT OE_GLOBALS.Equal(p_x_line_rec.ORDER_QUANTITY_UOM, p_old_line_rec.ORDER_QUANTITY_UOM)
2706 THEN
2707 l_index := l_index + 1.0;
2708 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ORDER_QUANTITY_UOM;
2709 END IF;
2710
2711
2712 END IF;
2713
2714 Clear_Dependents
2715 (p_src_attr_tbl => l_src_attr_tbl
2716 ,p_initial_line_rec => p_initial_line_rec
2717 ,p_old_line_rec => p_old_line_rec
2718 ,p_x_line_rec => p_x_line_rec
2719 ,x_dep_attr_exists => l_dep_attr_exists);
2720
2721 oe_debug_pub.add('Exiting OE_LINE_UTIL.CLEAR_DEPENDENT_ATTR', 1);
2722
2723 EXCEPTION
2724 WHEN FND_API.G_EXC_ERROR THEN
2725 RAISE FND_API.G_EXC_ERROR;
2726 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2727 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2728 WHEN OTHERS THEN
2729 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2730 THEN
2731 OE_MSG_PUB.Add_Exc_Msg
2732 ( G_PKG_NAME
2733 , 'Clear_Dependent_Attr'
2734 );
2735 END IF;
2736 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2737 END Clear_Dependent_Attr;
2738
2739 -- PROCEDURE Clear_Dependent_Attr
2740 -- This version of the clear dependent attributes procedure is called
2741 -- from the private process order API (OE_Order_PVT) to clear the
2742 -- dependents if control_rec.clear_dependents is TRUE. The record
2743 -- types are of the type OE_Order_PUB.<Entity>_rec_Type
2744 -- Arguments:
2745 -- p_attr_id: if passed, then clear attributes dependent only on
2746 -- this attribute else compare p_old_line_rec and p_x_line_rec
2747 -- and clear attributes dependent on all the change attributes
2748 -- p_old_line_rec: the old record as it was before the changes
2749 -- p_x_line_rec: the current record with the user-specified changes
2750 PROCEDURE Clear_Dependent_Attr
2751 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
2752 , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
2753 , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
2754 OE_Order_PUB.G_MISS_LINE_REC
2755 )
2756 IS
2757 l_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2758 l_initial_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2759 l_old_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2760 BEGIN
2761
2762 API_Rec_To_RowType_Rec(p_x_line_rec, l_line_rec);
2763 API_Rec_To_RowType_Rec(p_old_line_rec, l_old_line_rec);
2764
2765 -- Initial rec is same as current record here as this procedure is
2766 -- called before defaulting and the current record is the same as
2767 -- that passed to process order with the user-specified changes only
2768 l_initial_line_rec := l_line_rec;
2769
2770 Clear_Dependent_Attr
2771 ( p_attr_id => p_attr_id
2772 , p_initial_line_rec => l_initial_line_rec
2773 , p_old_line_rec => l_old_line_rec
2774 , p_x_line_rec => l_line_rec
2775 );
2776
2777 RowType_Rec_To_API_Rec(l_line_rec, p_x_line_rec);
2778
2779 END Clear_Dependent_Attr;
2780
2781 -- 13-DEC-01 Introduced new procedure - clear_dep_and_default.
2782 -- This procedure will be used to detect if there was a dependent
2783 -- attribute that is changed and re-defaulted in the call or not.
2784 PROCEDURE Clear_Dep_And_Default
2785 ( p_src_attr_tbl IN OE_GLOBALS.Number_Tbl_Type
2786 , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
2787 , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
2788 )IS
2789 l_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2790 l_initial_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2791 l_old_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2792 l_dep_attr_exists VARCHAR2(1);
2793 BEGIN
2794
2795 API_Rec_To_RowType_Rec(p_x_line_rec, l_line_rec);
2796 API_Rec_To_RowType_Rec(p_old_line_rec, l_old_line_rec);
2797
2798 -- Initial rec is same as current record here as this procedure is
2799 -- called before defaulting and the current record is the same as
2800 -- that passed to process order with the user-specified changes only
2801 l_initial_line_rec := l_line_rec;
2802
2803 -- Initialize the global to 'N'
2804 OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'N';
2805
2806 Clear_Dependents
2807 ( p_src_attr_tbl => p_src_attr_tbl
2808 , p_initial_line_rec => l_initial_line_rec
2809 , p_old_line_rec => l_old_line_rec
2810 , p_x_line_rec => l_line_rec
2811 , x_dep_attr_exists => l_dep_attr_exists
2812 );
2813
2814 IF l_dep_attr_exists = 'N' THEN
2815 oe_debug_pub.add('No Dep Attributes');
2816 RETURN;
2817 END IF;
2818
2819 RowType_Rec_To_API_Rec(l_line_rec, p_x_line_rec);
2820
2821 OE_Default_Line.Attributes
2822 ( p_x_line_rec => p_x_line_rec
2823 , p_old_line_rec => p_old_line_rec
2824 );
2825
2826 EXCEPTION
2827 WHEN FND_API.G_EXC_ERROR THEN
2828 RAISE FND_API.G_EXC_ERROR;
2829 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2830 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2831 WHEN OTHERS THEN
2832 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2833 THEN
2834 OE_MSG_PUB.Add_Exc_Msg
2835 ( G_PKG_NAME
2836 , 'Clear_Dep_And_Default'
2837 );
2838 END IF;
2839 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2840 END Clear_Dep_And_Default;
2841
2842 END OE_Line_Util_Ext;