[Home] [Help]
PACKAGE BODY: APPS.OE_LINE_UTIL_EXT
Source
1 PACKAGE BODY OE_Line_Util_Ext AS
2 /* $Header: OEXULXTB.pls 120.11.12020000.2 2013/01/07 10:42:22 sujithku ship $ */
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 ---bug 9411403 ,9670984 null;
848 -----Start bug 9411403 ,9670984
849 ----clear the warehouse if the ship_set_id,arrival_set_id have some value and line is return type
850 IF (p_x_line_rec.ship_set_id is not null AND
851 p_x_line_rec.ship_set_id <> FND_API.G_MISS_NUM
852 AND p_x_line_rec.line_category_code = 'RETURN' ) OR
853 (p_x_line_rec.arrival_set_id is not null AND
854 p_x_line_rec.arrival_set_id <> FND_API.G_MISS_NUM
855 AND p_x_line_rec.line_category_code = 'RETURN')
856 THEN
857
858 IF NVL(FND_PROFILE.VALUE('ONT_BRANCH_SCHEDULING'),'N') = 'Y'
859 THEN
860 IF OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING = 'N' THEN
861 RETURN;
862 END IF;
863 END IF;
864 p_x_line_rec.SHIP_FROM_ORG_ID := FND_API.G_MISS_NUM;
865 x_dep_attr_exists := 'Y';
866 END IF;
867
868 ---end of bug 9411403,9670984
869
870 ELSE
871
872 -- do not clear Ship_from type if this is a scheduling
873 -- recursive call. Any updates due to scheduling (warehouse or item
874 -- in case of item substitution) should not result in a change to
875 -- the ship from.
876 --4504362
877
878 IF OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING = 'N' THEN
879 RETURN;
880 END IF;
881 p_x_line_rec.SHIP_FROM_ORG_ID := FND_API.G_MISS_NUM;
882 x_dep_attr_exists := 'Y';
883 END IF;
884
885 END IF;
886 END SHIP_FROM_ORG;
887
888 PROCEDURE SUBINVENTORY IS
889 BEGIN
890 IF (p_initial_line_rec.SUBINVENTORY = FND_API.G_MISS_CHAR OR
891 (OE_GLOBAlS.Equal(p_initial_line_rec.SUBINVENTORY, p_old_line_rec.SUBINVENTORY)
892 AND
893 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SUBINVENTORY IS NOT NULL))
894 ) -- the AND condition above added to fix 3098878
895 THEN
896 p_x_line_rec.SUBINVENTORY := FND_API.G_MISS_CHAR;
897 x_dep_attr_exists := 'Y';
898
899 END IF;
900 END SUBINVENTORY;
901
902
903 PROCEDURE SHIP_TOLERANCE_ABOVE IS
904 BEGIN
905 IF (p_initial_line_rec.SHIP_TOLERANCE_ABOVE = FND_API.G_MISS_NUM OR
906 (OE_GLOBALS.Equal(p_initial_line_rec.SHIP_TOLERANCE_ABOVE, p_old_line_rec.SHIP_TOLERANCE_ABOVE)
907 AND
908 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIP_TOLERANCE_ABOVE IS NOT NULL))
909 ) -- the AND condition above added to fix 3098878
910 THEN
911 p_x_line_rec.SHIP_TOLERANCE_ABOVE := FND_API.G_MISS_NUM;
912 x_dep_attr_exists := 'Y';
913 END IF;
914 END SHIP_TOLERANCE_ABOVE;
915
916 PROCEDURE SHIP_TOLERANCE_BELOW IS
917 BEGIN
918 IF (p_initial_line_rec.SHIP_TOLERANCE_BELOW = FND_API.G_MISS_NUM OR
919 (OE_GLOBALS.Equal(p_initial_line_rec.SHIP_TOLERANCE_BELOW, p_old_line_rec.SHIP_TOLERANCE_BELOW)
920 AND
921 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIP_TOLERANCE_BELOW IS NOT NULL))
922 ) -- the AND condition above added to fix 3098878
923 THEN
924 p_x_line_rec.SHIP_TOLERANCE_BELOW := FND_API.G_MISS_NUM;
925 x_dep_attr_exists := 'Y';
926 END IF;
927 END SHIP_TOLERANCE_BELOW;
928
929 PROCEDURE SHIP_TO_CONTACT IS
930 BEGIN
931 IF (p_initial_line_rec.SHIP_TO_CONTACT_ID = FND_API.G_MISS_NUM OR
932 (OE_GLOBALS.Equal(p_initial_line_rec.SHIP_TO_CONTACT_ID, p_old_line_rec.SHIP_TO_CONTACT_ID)
933 AND
934 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIP_TO_CONTACT_ID IS NOT NULL))
935 ) -- the AND condition above added to fix 3098878
936 THEN
937 p_x_line_rec.SHIP_TO_CONTACT_ID := FND_API.G_MISS_NUM;
938 x_dep_attr_exists := 'Y';
939 END IF;
940 END SHIP_TO_CONTACT;
941
942 PROCEDURE SHIP_TO_ORG IS
943 BEGIN
944 IF (p_initial_line_rec.SHIP_TO_ORG_ID = FND_API.G_MISS_NUM OR
945 (OE_GLOBALS.Equal(p_initial_line_rec.SHIP_TO_ORG_ID, p_old_line_rec.SHIP_TO_ORG_ID)
946 AND
947 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIP_TO_ORG_ID IS NOT NULL))
948 ) -- the AND condition above added to fix 3098878
949 THEN
950 -- Let us not clear request_date for an ATO option or SMC
951 -- PTO option
952 -- Code commented for Bug-2543024
953 /* IF (p_x_line_rec.ato_line_id is not null AND
954 p_x_line_rec.ato_line_id <> FND_API.G_MISS_NUM AND
955 p_x_line_rec.ato_line_id <> p_x_line_rec.line_id) OR
956 (p_x_line_rec.top_model_line_id is not null AND
957 p_x_line_rec.top_model_line_id <> FND_API.G_MISS_NUM AND
958 p_x_line_rec.top_model_line_id <> p_x_line_rec.line_id AND
959 p_x_line_rec.ship_model_complete_flag = 'Y') THEN
960
961 null;
962 ELSE*/
963 p_x_line_rec.SHIP_TO_ORG_ID := FND_API.G_MISS_NUM;
964 x_dep_attr_exists := 'Y';
965 -- END IF;
966
967 END IF;
968 END SHIP_TO_ORG;
969
970 PROCEDURE SOLD_TO_ORG IS
971 BEGIN
972 IF (p_initial_line_rec.SOLD_TO_ORG_ID = FND_API.G_MISS_NUM OR
973 (OE_GLOBALS.Equal(p_initial_line_rec.SOLD_TO_ORG_ID, p_old_line_rec.SOLD_TO_ORG_ID)
974 AND
975 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SOLD_TO_ORG_ID IS NOT NULL))
976 ) -- the AND condition above added to fix 3098878
977 THEN
978 IF p_x_line_rec.reference_line_id IS NOT NULL AND
979 p_x_line_rec.reference_line_id <> FND_API.G_MISS_NUM AND
980 p_x_line_rec.line_category_code = 'RETURN'
981 THEN
982 NULL;
983 ELSE
984 p_x_line_rec.SOLD_TO_ORG_ID := FND_API.G_MISS_NUM;
985 x_dep_attr_exists := 'Y';
986 END IF;
987 END IF;
988 END SOLD_TO_ORG;
989
990 PROCEDURE TAX IS
991 BEGIN
992 IF (p_initial_line_rec.TAX_CODE = FND_API.G_MISS_CHAR OR
993 (OE_GLOBAlS.Equal(p_initial_line_rec.TAX_CODE, p_old_line_rec.TAX_CODE)
994 AND
995 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TAX_CODE IS NOT NULL))
996 ) -- the AND condition above added to fix 3098878
997 THEN
998 IF p_x_line_rec.reference_line_id IS NOT NULL AND
999 p_x_line_rec.reference_line_id <> FND_API.G_MISS_NUM AND
1000 p_x_line_rec.line_category_code = 'RETURN'
1001 THEN
1002 NULL;
1003 -- commenting the below code to address bug 2287931
1004 -- ELSIF p_x_line_rec.TAX_CODE IS NOT NULL THEN
1005 -- NULL;
1006 ELSE
1007 p_x_line_rec.TAX_CODE := FND_API.G_MISS_CHAR;
1008 x_dep_attr_exists := 'Y';
1009 END IF;
1010 END IF;
1011 END TAX;
1012
1013 PROCEDURE TAX_DATE IS
1014 BEGIN
1015 IF (p_initial_line_rec.TAX_DATE = FND_API.G_MISS_DATE OR
1016 (OE_GLOBALS.Equal(p_initial_line_rec.TAX_DATE, p_old_line_rec.TAX_DATE)
1017 AND
1018 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TAX_DATE IS NOT NULL))
1019 ) -- the AND condition above added to fix 3098878
1020 THEN
1021 IF p_x_line_rec.reference_line_id IS NOT NULL AND
1022 p_x_line_rec.line_category_code = 'RETURN'
1023 THEN
1024 NULL;
1025 ELSE
1026 p_x_line_rec.TAX_DATE := FND_API.G_MISS_DATE;
1027 x_dep_attr_exists := 'Y';
1028 END IF;
1029 END IF;
1030 END TAX_DATE;
1031
1032 PROCEDURE TAX_EXEMPT IS
1033 BEGIN
1034 IF (p_initial_line_rec.TAX_EXEMPT_FLAG = FND_API.G_MISS_CHAR OR
1035 (OE_GLOBAlS.Equal(p_initial_line_rec.TAX_EXEMPT_FLAG, p_old_line_rec.TAX_EXEMPT_FLAG)
1036 AND
1037 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TAX_EXEMPT_FLAG IS NOT NULL))
1038 ) -- the AND condition above added to fix 3098878
1039 THEN
1040 IF p_x_line_rec.reference_line_id IS NOT NULL AND
1041 p_x_line_rec.reference_line_id <> FND_API.G_MISS_NUM AND
1042 p_x_line_rec.line_category_code = 'RETURN'
1043 THEN
1044 NULL;
1045 ELSE
1046 p_x_line_rec.TAX_EXEMPT_FLAG := FND_API.G_MISS_CHAR;
1047 x_dep_attr_exists := 'Y';
1048 END IF;
1049 END IF;
1050 END TAX_EXEMPT;
1051
1052 PROCEDURE TAX_EXEMPT_NUMBER IS
1053 BEGIN
1054 IF (p_initial_line_rec.TAX_EXEMPT_NUMBER = FND_API.G_MISS_CHAR OR
1055 (OE_GLOBAlS.Equal(p_initial_line_rec.TAX_EXEMPT_NUMBER, p_old_line_rec.TAX_EXEMPT_NUMBER)
1056 AND
1057 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TAX_EXEMPT_NUMBER IS NOT NULL))
1058 ) -- the AND condition above added to fix 3098878
1059 THEN
1060 IF p_x_line_rec.reference_line_id IS NOT NULL AND
1061 p_x_line_rec.reference_line_id <> FND_API.G_MISS_NUM AND
1062 p_x_line_rec.line_category_code = 'RETURN'
1063 THEN
1064 NULL;
1065 ELSE
1066 -- Clear it only if the tax_exempt_flag = 'S' or
1067 -- the tax_exempt_flag has changed.
1068 IF NOT OE_GLOBAlS.Equal(p_x_line_rec.TAX_EXEMPT_FLAG
1069 , p_old_line_rec.TAX_EXEMPT_FLAG)
1070 OR (p_old_line_rec.TAX_EXEMPT_FLAG = 'S' AND
1071 p_x_line_rec.TAX_EXEMPT_FLAG = 'S' ) THEN
1072
1073 p_x_line_rec.TAX_EXEMPT_NUMBER := FND_API.G_MISS_CHAR;
1074 x_dep_attr_exists := 'Y';
1075 END IF;
1076 END IF;
1077
1078 END IF;
1079 END TAX_EXEMPT_NUMBER;
1080
1081 PROCEDURE TAX_EXEMPT_REASON IS
1082 BEGIN
1083 IF (p_initial_line_rec.TAX_EXEMPT_REASON_CODE = FND_API.G_MISS_CHAR OR
1084 (OE_GLOBAlS.Equal(p_initial_line_rec.TAX_EXEMPT_REASON_CODE, p_old_line_rec.TAX_EXEMPT_REASON_CODE)
1085 AND
1086 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TAX_EXEMPT_REASON_CODE IS NOT NULL))
1087 ) -- the AND condition above added to fix 3098878
1088 THEN
1089 IF p_x_line_rec.reference_line_id IS NOT NULL AND
1090 p_x_line_rec.reference_line_id <> FND_API.G_MISS_NUM AND
1091 p_x_line_rec.line_category_code = 'RETURN'
1092 THEN
1093 NULL;
1094 ELSE
1095 -- Clear it only if the tax_exempt_flag = 'S' or
1096 -- the tax_exempt_flag has changed.
1097
1098 IF NOT OE_GLOBAlS.Equal(p_x_line_rec.TAX_EXEMPT_FLAG
1099 , p_old_line_rec.TAX_EXEMPT_FLAG)
1100 OR (p_old_line_rec.TAX_EXEMPT_FLAG = 'S' AND
1101 p_x_line_rec.TAX_EXEMPT_FLAG = 'S' ) THEN
1102
1103 p_x_line_rec.TAX_EXEMPT_REASON_CODE := FND_API.G_MISS_CHAR;
1104 x_dep_attr_exists := 'Y';
1105 END IF;
1106
1107 END IF;
1108
1109 END IF;
1110 END TAX_EXEMPT_REASON;
1111
1112 PROCEDURE TOP_MODEL_LINE IS
1113 BEGIN
1114 IF (p_initial_line_rec.TOP_MODEL_LINE_ID = FND_API.G_MISS_NUM OR
1115 (OE_GLOBALS.Equal(p_initial_line_rec.TOP_MODEL_LINE_ID, p_old_line_rec.TOP_MODEL_LINE_ID)
1116 AND
1117 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TOP_MODEL_LINE_ID IS NOT NULL))
1118 ) -- the AND condition above added to fix 3098878
1119 THEN
1120 p_x_line_rec.TOP_MODEL_LINE_ID := FND_API.G_MISS_NUM;
1121 x_dep_attr_exists := 'Y';
1122 END IF;
1123 END TOP_MODEL_LINE;
1124
1125 PROCEDURE SERVICE_START_DATE IS
1126 BEGIN
1127 IF (p_initial_line_rec.SERVICE_START_DATE = FND_API.G_MISS_DATE OR
1128 (OE_GLOBALS.Equal(p_initial_line_rec.SERVICE_START_DATE, p_old_line_rec.SERVICE_START_DATE)
1129 AND
1130 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SERVICE_START_DATE IS NOT NULL))
1131 ) -- the AND condition above added to fix 3098878
1132 THEN
1133 p_x_line_rec.SERVICE_START_DATE := FND_API.G_MISS_DATE;
1134 x_dep_attr_exists := 'Y';
1135 END IF;
1136 END SERVICE_START_DATE;
1137
1138 PROCEDURE SERVICE_PERIOD IS
1139 BEGIN
1140 IF (p_initial_line_rec.SERVICE_PERIOD = FND_API.G_MISS_CHAR OR
1141 (OE_GLOBAlS.Equal(p_initial_line_rec.SERVICE_PERIOD, p_old_line_rec.SERVICE_PERIOD)
1142 AND
1143 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SERVICE_PERIOD IS NOT NULL))
1144 ) -- the AND condition above added to fix 3098878
1145 THEN
1146 p_x_line_rec.SERVICE_PERIOD := FND_API.G_MISS_CHAR;
1147 x_dep_attr_exists := 'Y';
1148 END IF;
1149 END SERVICE_PERIOD;
1150
1151 -- bug4283037
1152 PROCEDURE SERVICE_DURATION IS
1153 BEGIN
1154 IF (p_initial_line_rec.SERVICE_DURATION = FND_API.G_MISS_NUM OR
1155 (OE_GLOBAlS.Equal(p_initial_line_rec.SERVICE_DURATION, p_old_line_rec.SERVICE_DURATION)
1156 AND
1157 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SERVICE_DURATION IS NOT NULL))
1158 ) -- the AND condition above added to fix 3098878
1159 THEN
1160 p_x_line_rec.SERVICE_DURATION := FND_API.G_MISS_NUM;
1161 x_dep_attr_exists := 'Y';
1162 END IF;
1163 END SERVICE_DURATION;
1164
1165 PROCEDURE SERVICE_REFERENCE_TYPE_CODE IS
1166 BEGIN
1167 IF (p_initial_line_rec.SERVICE_REFERENCE_TYPE_CODE = FND_API.G_MISS_CHAR OR
1168 (OE_GLOBAlS.Equal(p_initial_line_rec.SERVICE_REFERENCE_TYPE_CODE, p_old_line_rec.SERVICE_REFERENCE_TYPE_CODE)
1169 AND
1170 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SERVICE_REFERENCE_TYPE_CODE IS NOT NULL))
1171 ) -- the AND condition above added to fix 3098878
1172 THEN
1173 p_x_line_rec.SERVICE_REFERENCE_TYPE_CODE := FND_API.G_MISS_CHAR;
1174 x_dep_attr_exists := 'Y';
1175 END IF;
1176 END SERVICE_REFERENCE_TYPE_CODE;
1177
1178 --sol_ord_er #16014165
1179 PROCEDURE subscription_enable_flag IS
1180 BEGIN
1181 IF (p_initial_line_rec.subscription_enable_flag = FND_API.G_MISS_CHAR OR
1182 (OE_GLOBAlS.Equal(p_initial_line_rec.subscription_enable_flag, p_old_line_rec.subscription_enable_flag)
1183 AND
1184 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.subscription_enable_flag IS NOT NULL))
1185 )
1186 THEN
1187 p_x_line_rec.subscription_enable_flag := FND_API.G_MISS_CHAR;
1188 x_dep_attr_exists := 'Y';
1189 END IF;
1190 END subscription_enable_flag;
1191
1192 PROCEDURE BILL_PROFILE_ID IS
1193 BEGIN
1194 IF (p_initial_line_rec.SERVICE_BILL_PROFILE_ID = FND_API.G_MISS_NUM OR
1195 (OE_GLOBAlS.Equal(p_initial_line_rec.SERVICE_BILL_PROFILE_ID, p_old_line_rec.SERVICE_BILL_PROFILE_ID)
1196 AND
1197 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SERVICE_BILL_PROFILE_ID IS NOT NULL))
1198 )
1199 THEN
1200 p_x_line_rec.SERVICE_BILL_PROFILE_ID := FND_API.G_MISS_NUM;
1201 x_dep_attr_exists := 'Y';
1202 END IF;
1203 END BILL_PROFILE_ID;
1204
1205 PROCEDURE SERVICE_COVERAGE_TEMP IS
1206 BEGIN
1207 IF (p_initial_line_rec.SERVICE_COV_TEMPLATE_ID = FND_API.G_MISS_NUM OR
1208 (OE_GLOBAlS.Equal(p_initial_line_rec.SERVICE_COV_TEMPLATE_ID, p_old_line_rec.SERVICE_COV_TEMPLATE_ID)
1209 AND
1210 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SERVICE_COV_TEMPLATE_ID IS NOT NULL))
1211 )
1212 THEN
1213 p_x_line_rec.SERVICE_COV_TEMPLATE_ID := FND_API.G_MISS_NUM;
1214 x_dep_attr_exists := 'Y';
1215 END IF;
1216 END SERVICE_COVERAGE_TEMP;
1217
1218 PROCEDURE SUBSCRIPTION_TEMP IS
1219 BEGIN
1220 IF (p_initial_line_rec.service_subs_template_id = FND_API.G_MISS_NUM OR
1221 (OE_GLOBAlS.Equal(p_initial_line_rec.service_subs_template_id, p_old_line_rec.service_subs_template_id)
1222 AND
1223 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.service_subs_template_id IS NOT NULL))
1224 )
1225 THEN
1226 p_x_line_rec.service_subs_template_id := FND_API.G_MISS_NUM;
1227 x_dep_attr_exists := 'Y';
1228 END IF;
1229 END SUBSCRIPTION_TEMP;
1230
1231 PROCEDURE SERV_BILL_OPTION IS
1232 BEGIN
1233 IF (p_initial_line_rec.service_bill_option_code = FND_API.G_MISS_CHAR OR
1234 (OE_GLOBAlS.Equal(p_initial_line_rec.service_bill_option_code, p_old_line_rec.service_bill_option_code)
1235 AND
1236 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.service_bill_option_code IS NOT NULL))
1237 )
1238 THEN
1239 p_x_line_rec.service_bill_option_code := FND_API.G_MISS_CHAR;
1240 x_dep_attr_exists := 'Y';
1241 END IF;
1242 END SERV_BILL_OPTION;
1243 -- sol_ord_er #16014165 end
1244
1245 PROCEDURE RETURN_CONTEXT IS
1246 BEGIN
1247 IF (p_initial_line_rec.RETURN_CONTEXT = FND_API.G_MISS_CHAR OR
1248 (OE_GLOBAlS.Equal(p_initial_line_rec.RETURN_CONTEXT, p_old_line_rec.RETURN_CONTEXT)
1249 AND
1250 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.RETURN_CONTEXT IS NOT NULL))
1251 ) -- the AND condition above added to fix 3098878
1252 THEN
1253 oe_debug_pub.add('RMA:Clearing Return Attrs',1);
1254
1255 p_x_line_rec.RETURN_CONTEXT := FND_API.G_MISS_CHAR;
1256 p_x_line_rec.RETURN_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1257 p_x_line_rec.RETURN_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1258 p_x_line_rec.reference_customer_trx_line_id := FND_API.G_MISS_NUM;
1259 p_x_line_rec.credit_invoice_line_id := FND_API.G_MISS_NUM;
1260 p_x_line_rec.reference_line_id := FND_API.G_MISS_NUM;
1261 p_x_line_rec.reference_header_id := FND_API.G_MISS_NUM;
1262 END IF;
1263 END RETURN_CONTEXT;
1264
1265 -- Add for Bug 2766005
1266 PROCEDURE PACKING_INSTRUCTIONS IS
1267 BEGIN
1268 IF (p_initial_line_rec.PACKING_INSTRUCTIONS = FND_API.G_MISS_CHAR OR
1269 (OE_GLOBAlS.Equal(p_initial_line_rec.PACKING_INSTRUCTIONS, p_old_line_rec.PACKING_INSTRUCTIONS)
1270 AND
1271 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.PACKING_INSTRUCTIONS IS NOT NULL))
1272 ) -- the AND condition above added to fix 3098878
1273 THEN
1274 p_x_line_rec.PACKING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
1275 x_dep_attr_exists := 'Y';
1276 END IF;
1277 END PACKING_INSTRUCTIONS;
1278
1279 PROCEDURE SHIPPING_INSTRUCTIONS IS
1280 BEGIN
1281 IF (p_initial_line_rec.SHIPPING_INSTRUCTIONS = FND_API.G_MISS_CHAR OR
1282 (OE_GLOBAlS.Equal(p_initial_line_rec.SHIPPING_INSTRUCTIONS, p_old_line_rec.SHIPPING_INSTRUCTIONS)
1283 AND
1284 (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIPPING_INSTRUCTIONS IS NOT NULL))
1285 ) -- the AND condition above added to fix 3098878
1286 THEN
1287 p_x_line_rec.SHIPPING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
1288 x_dep_attr_exists := 'Y';
1289 END IF;
1290 END SHIPPING_INSTRUCTIONS;
1291 -- End code for bug 2766005
1292
1293
1294 --distributed orders
1295 PROCEDURE end_customer IS
1296 BEGIN
1297 IF (p_initial_line_rec.end_customer_id = FND_API.G_MISS_NUM
1298 OR OE_GLOBALS.Equal(p_initial_line_rec.end_customer_id
1299 , p_old_line_rec.end_customer_id ))
1300 THEN
1301 p_x_line_rec.end_customer_id := FND_API.G_MISS_NUM;
1302 x_dep_attr_exists := 'Y';
1303 END IF;
1304 END end_customer;
1305
1306 PROCEDURE end_customer_contact IS
1307 BEGIN
1308 IF (p_initial_line_rec.end_customer_contact_id = FND_API.G_MISS_NUM
1309 OR OE_GLOBALS.Equal(p_initial_line_rec.end_customer_contact_id
1310 , p_old_line_rec.end_customer_contact_id ))
1311 THEN
1312 p_x_line_rec.end_customer_contact_id := FND_API.G_MISS_NUM;
1313 x_dep_attr_exists := 'Y';
1314 END IF;
1315 END end_customer_contact;
1316
1317 PROCEDURE end_customer_site_use IS
1318 BEGIN
1319 IF (p_initial_line_rec.end_customer_site_use_id = FND_API.G_MISS_NUM
1320 OR OE_GLOBALS.Equal(p_initial_line_rec.end_customer_site_use_id ,
1321 p_old_line_rec.end_customer_site_use_id ))
1322 THEN
1323 p_x_line_rec.end_customer_site_use_id := FND_API.G_MISS_NUM;
1324 x_dep_attr_exists := 'Y';
1325 END IF;
1326 END end_customer_site_use;
1327
1328 --key Transaction Dates Project
1329 PROCEDURE order_firmed_date IS
1330 BEGIN
1331 IF(p_initial_line_rec.order_firmed_date = FND_API.G_MISS_DATE
1332 OR OE_GLOBALS.Equal(p_initial_line_rec.order_firmed_date ,
1333 p_old_line_rec.order_firmed_date ))
1334 THEN
1335 p_x_line_rec.order_firmed_date := FND_API.G_MISS_DATE ;
1336 x_dep_attr_exists := 'Y' ;
1337 END IF;
1338 END order_firmed_date ;
1339 --end
1340 --Rakesh
1341 PROCEDURE CHARGE_PERIODICITY IS
1342 BEGIN
1343 IF (p_initial_line_rec.charge_periodicity_code = FND_API.G_MISS_CHAR OR
1344 OE_GLOBAlS.Equal(p_initial_line_rec.charge_periodicity_code, p_old_line_rec.charge_periodicity_code))
1345 THEN
1346 p_x_line_rec.charge_periodicity_code := FND_API.G_MISS_CHAR;
1347 x_dep_attr_exists := 'Y';
1348 END IF;
1349 END CHARGE_PERIODICITY;
1350 --13088960 begins
1351 PROCEDURE latest_acceptable_date IS
1352 BEGIN
1353 IF (p_initial_line_rec.latest_acceptable_date = FND_API.G_MISS_DATE OR
1354 OE_GLOBAlS.Equal(p_initial_line_rec.latest_acceptable_date, p_old_line_rec.latest_acceptable_date))
1355 THEN
1356 p_x_line_rec.latest_acceptable_date := FND_API.G_MISS_DATE;
1357 x_dep_attr_exists := 'Y';
1358 END IF;
1359 END latest_acceptable_date;
1360 --end 13088960
1361 -- Bug 2843738
1362 PROCEDURE ship_set IS
1363 l_set_status VARCHAR2(1);
1364 BEGIN
1365 OE_DEBUG_PUB.add('Procedure ship set',1);
1366 OE_Order_Cache.Load_Order_Header(p_initial_line_rec.header_id); -- 13706641
1367 -- Bug 13730871
1368 BEGIN
1369 SELECT set_status INTO l_set_status
1370 FROM oe_sets
1371 WHERE set_id = p_initial_line_rec.ship_set_id
1372 AND set_type = 'SHIP_SET';
1373 EXCEPTION
1374 WHEN Others THEN NULL;
1375 END;
1376 IF (p_initial_line_rec.ship_set = FND_API.G_MISS_CHAR OR
1377 OE_GLOBAlS.Equal(p_initial_line_rec.ship_set, p_old_line_rec.ship_set))
1378 THEN
1379 IF NVL(oe_sys_parameters.Value('ONT_LINE_SET_WH',p_initial_line_rec.org_id),'N') = 'Y'
1380 AND NVL(FND_PROFILE.VALUE('ONT_SET_FOR_EACH_LINE'),'N') = 'N' -- 13706641
1381 AND OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'SHIP' -- 13706641
1382 AND p_initial_line_rec.split_from_line_id IS null -- 13706641
1383 AND l_set_status = 'T' -- 13730871
1384 THEN
1385 p_x_line_rec.ship_set := FND_API.G_MISS_CHAR;
1386 p_x_line_rec.ship_set_id := FND_API.G_MISS_NUM;
1387 x_dep_attr_exists := 'Y';
1388 END IF;
1389 END IF;
1390 END ship_set;
1391 -- ER 2843738
1392
1393 BEGIN
1394
1395
1396 -- Bug 2337711: Initialize this OUT parameter to 'N', if a
1397 -- dependent attribute is cleared later, it will be re-set to 'Y'.
1398 -- Without this initialization, procedure Clear_Dep_And_Default
1399 -- was calling oe_default_line even if there weren't any dependents!
1400 x_dep_attr_exists := 'N';
1401
1402 IF p_src_attr_tbl.COUNT > 0 THEN
1403
1404 OE_Dependencies.Mark_Dependent
1405 (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1406 p_source_attr_tbl => p_src_attr_tbl,
1407 p_dep_attr_tbl => l_dep_attr_tbl);
1408
1409 FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
1410 oe_debug_pub.add('Dep. attr :'||l_dep_attr_tbl(I));
1411
1412 -- Bug fix 1131529: clear the dependent attribute ONLY if attribute
1413 -- did not have a user-specified value (attribute is not user specified
1414 -- if value is missing or old value is same as the initial value)
1415
1416 -- Bug fix : create nested procedures per attribute and call the
1417 -- procedure if it is the dependent attribute.
1418 -- Also, eliminate unnecessary code for attribute that cannot be
1419 -- dependent attributes
1420
1421 IF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ACCOUNTING_RULE THEN
1422 ACCOUNTING_RULE;
1423 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ACCOUNTING_RULE_DURATION THEN
1424 ACCOUNTING_RULE_DURATION;
1425 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_AGREEMENT THEN
1426 AGREEMENT;
1427 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ATO_LINE THEN
1428 ATO_LINE;
1429 --For bug 3571400
1430 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_NUMBER THEN
1431 BLANKET_NUMBER;
1432 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_LINE_NUMBER THEN
1433 BLANKET_LINE_NUMBER;
1434 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_BLANKET_VERSION_NUMBER THEN
1435 BLANKET_VERSION_NUMBER;
1436 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMMITMENT THEN
1437 COMMITMENT;
1438 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT THEN
1439 COMPONENT;
1440 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_COMPONENT_SEQUENCE THEN
1441 COMPONENT_SEQUENCE;
1442 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SORT_ORDER THEN
1443 SORT_ORDER;
1444 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUST_PO_NUMBER THEN
1445 CUST_PO_NUMBER;
1446 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CUSTOMER_LINE_NUMBER THEN --For 2844285
1447 CUSTOMER_LINE_NUMBER;
1448 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_CONTACT THEN
1449 DELIVER_TO_CONTACT;
1450 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DELIVER_TO_ORG THEN
1451 DELIVER_TO_ORG;
1452 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEMAND_CLASS THEN
1453 DEMAND_CLASS;
1454 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_DEP_PLAN_REQUIRED THEN
1455 DEP_PLAN_REQUIRED;
1456 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_ITEM_UNIT_NUMBER THEN
1457 END_ITEM_UNIT_NUMBER;
1458 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FOB_POINT THEN
1459 FOB_POINT;
1460 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_FREIGHT_TERMS THEN
1461 FREIGHT_TERMS;
1462 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_CONTACT THEN
1463 INTERMED_SHIP_TO_CONTACT;
1464 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INTERMED_SHIP_TO_ORG THEN
1465 INTERMED_SHIP_TO_ORG;
1466 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_CONTACT THEN
1467 INVOICE_TO_CONTACT;
1468 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICE_TO_ORG THEN
1469 INVOICE_TO_ORG;
1470 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_INVOICING_RULE THEN
1471 INVOICING_RULE;
1472 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_IDENTIFIER_TYPE THEN
1473 ITEM_IDENTIFIER_TYPE;
1474 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_REVISION THEN -- For bug 2951575
1475 ITEM_REVISION;
1476 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ITEM_TYPE THEN
1477 ITEM_TYPE;
1478 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_TYPE THEN
1479 LINE_TYPE;
1480 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LINE_CATEGORY THEN
1481 LINE_CATEGORY;
1482 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_OPTION_NUMBER THEN
1483 OPTION_NUMBER;
1484 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_ITEM THEN
1485 ORDERED_ITEM;
1486 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDER_QUANTITY_UOM THEN
1487 ORDER_QUANTITY_UOM;
1488 -- OPM 02/JUN/00 BEGIN
1489 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_QUANTITY_UOM2 THEN
1490 ORDERED_QUANTITY_UOM2;
1491 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDERED_QUANTITY2 THEN
1492 ORDERED_QUANTITY2; -- Bug3016136
1493 -- OPM 02/JUN/00 END
1494 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PAYMENT_TERM THEN
1495 PAYMENT_TERM;
1496 -- OPM 02/JUN/00 BEGIN
1497 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PREFERRED_GRADE THEN
1498 PREFERRED_GRADE;
1499 -- OPM 02/JUN/00 END
1500 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICE_LIST THEN
1501 PRICE_LIST;
1502 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICE_REQUEST_CODE THEN
1503 PRICE_REQUEST_CODE; -- PROMOTIONS SEP/01
1504 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PRICING_QUANTITY_UOM THEN
1505 PRICING_QUANTITY_UOM;
1506 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PROMISE_DATE THEN
1507 PROMISE_DATE;
1508 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_REQUEST_DATE THEN
1509 REQUEST_DATE;
1510 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SALESREP THEN
1511 SALESREP;
1512 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE THEN
1513 SCHEDULE_SHIP_DATE;
1514 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_NUMBER THEN
1515 SHIPMENT_NUMBER;
1516 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPMENT_PRIORITY THEN
1517 SHIPMENT_PRIORITY;
1518 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPABLE THEN
1519 SHIPPABLE;
1520 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPING_METHOD THEN
1521 SHIPPING_METHOD;
1522 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_FROM_ORG THEN
1523 SHIP_FROM_ORG;
1524 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SUBINVENTORY THEN
1525 SUBINVENTORY;
1526 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_ABOVE THEN
1527 SHIP_TOLERANCE_ABOVE;
1528 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TOLERANCE_BELOW THEN
1529 SHIP_TOLERANCE_BELOW;
1530 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_CONTACT THEN
1531 SHIP_TO_CONTACT;
1532 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_TO_ORG THEN
1533 SHIP_TO_ORG;
1534 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SOLD_TO_ORG THEN
1535 SOLD_TO_ORG;
1536 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX THEN
1537 TAX;
1538 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_DATE THEN
1539 TAX_DATE;
1540 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT THEN
1541 TAX_EXEMPT;
1542 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_NUMBER THEN
1543 TAX_EXEMPT_NUMBER;
1544 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TAX_EXEMPT_REASON THEN
1545 TAX_EXEMPT_REASON;
1546 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_TOP_MODEL_LINE THEN
1547 TOP_MODEL_LINE;
1548 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_START_DATE THEN
1549 SERVICE_START_DATE;
1550 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_PERIOD THEN
1551 SERVICE_PERIOD;
1552 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_REFERENCE_TYPE_CODE THEN
1553 SERVICE_REFERENCE_TYPE_CODE;
1554 --sol_ord_er #16014165
1555 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_BILL_PROFILE_ID THEN
1556 BILL_PROFILE_ID;
1557 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_COV_TEMPLATE_ID THEN
1558 SERVICE_COVERAGE_TEMP;
1559 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_SUBS_TEMPLATE_ID THEN
1560 SUBSCRIPTION_TEMP;
1561 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_BILL_OPTION_CODE THEN
1562 serv_bill_option;
1563 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.g_subscription_enable_flag THEN
1564 subscription_enable_flag;
1565 -- sol_ord_er #16014165 end
1566 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_RETURN_CONTEXT THEN
1567 RETURN_CONTEXT;
1568 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SOURCE_TYPE THEN
1569 SOURCE_TYPE;
1570 -- Add for bug 2766005
1571 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_PACKING_INSTRUCTIONS THEN
1572 PACKING_INSTRUCTIONS;
1573 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIPPING_INSTRUCTIONS THEN
1574 SHIPPING_INSTRUCTIONS;
1575 -- End of code for bug 2766005
1576 -- Distributed orders
1577 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER THEN
1578 END_CUSTOMER;
1579 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER_CONTACT THEN
1580 END_CUSTOMER_CONTACT;
1581 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_END_CUSTOMER_SITE_USE THEN
1582 END_CUSTOMER_SITE_USE;
1583 -- bug 4283037
1584 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SERVICE_DURATION THEN
1585 SERVICE_DURATION;
1586 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_ORDER_FIRMED_DATE and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >='110509'
1587 THEN --key Transaction Dates Project
1588 ORDER_FIRMED_DATE ;
1589 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_CHARGE_PERIODICITY THEN
1590 CHARGE_PERIODICITY;
1591 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_LATEST_ACCEPTABLE_DATE THEN --bug13088960
1592 latest_acceptable_date; --bug13088960
1593 ELSIF l_dep_attr_tbl(I) = OE_LINE_UTIL.G_SHIP_SET THEN --ER 2843738
1594 ship_set; --ER 2843738
1595 END IF;
1596 END LOOP;
1597 END IF;
1598
1599 EXCEPTION
1600 WHEN FND_API.G_EXC_ERROR THEN
1601 RAISE FND_API.G_EXC_ERROR;
1602 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1603 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1604 WHEN OTHERS THEN
1605 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1606 THEN
1607 OE_MSG_PUB.Add_Exc_Msg
1608 ( G_PKG_NAME
1609 , 'Clear_Dependents'
1610 );
1611 END IF;
1612 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1613 END Clear_Dependents;
1614
1615 -- Function to initialize a record of type OE_AK_ORDER_LINES_V%ROWTYPE
1616 FUNCTION G_MISS_OE_AK_LINE_REC
1617 RETURN OE_AK_ORDER_LINES_V%ROWTYPE IS
1618 l_rowtype_rec OE_AK_ORDER_LINES_V%ROWTYPE;
1619 BEGIN
1620
1621 -- OPM 02/JUN/00 - add process attributes
1622 -- =========================================================================
1623
1624 l_rowtype_rec.ACCOUNTING_RULE_ID := FND_API.G_MISS_NUM;
1625 l_rowtype_rec.ACCOUNTING_RULE_DURATION := FND_API.G_MISS_NUM;
1626 l_rowtype_rec.ACTUAL_ARRIVAL_DATE := FND_API.G_MISS_DATE;
1627 l_rowtype_rec.ACTUAL_SHIPMENT_DATE := FND_API.G_MISS_DATE;
1628 l_rowtype_rec.AGREEMENT_ID := FND_API.G_MISS_NUM;
1629 l_rowtype_rec.ARRIVAL_SET := FND_API.G_MISS_CHAR;
1630 l_rowtype_rec.upgraded_flag := FND_API.G_MISS_CHAR;
1631 l_rowtype_rec.ARRIVAL_SET_ID := FND_API.G_MISS_NUM;
1632 l_rowtype_rec.ATO_LINE_ID := FND_API.G_MISS_NUM;
1633 l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1634 l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
1635 l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
1636 l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
1637 l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
1638 l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
1639 l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
1640 l_rowtype_rec.ATTRIBUTE16 := FND_API.G_MISS_CHAR; --For bug 2184255
1641 l_rowtype_rec.ATTRIBUTE17 := FND_API.G_MISS_CHAR;
1642 l_rowtype_rec.ATTRIBUTE18 := FND_API.G_MISS_CHAR;
1643 l_rowtype_rec.ATTRIBUTE19 := FND_API.G_MISS_CHAR;
1644 l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1645 l_rowtype_rec.ATTRIBUTE20 := FND_API.G_MISS_CHAR;
1646 l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
1647 l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
1648 l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
1649 l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
1650 l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
1651 l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
1652 l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
1653 l_rowtype_rec.AUTHORIZED_TO_SHIP_FLAG := FND_API.G_MISS_CHAR;
1654 l_rowtype_rec.AUTO_SELECTED_QUANTITY := FND_API.G_MISS_NUM;
1655 l_rowtype_rec.BOOKED_FLAG := FND_API.G_MISS_CHAR;
1656 l_rowtype_rec.CANCELLED_FLAG := FND_API.G_MISS_CHAR;
1657 l_rowtype_rec.CANCELLED_QUANTITY := FND_API.G_MISS_NUM;
1658 l_rowtype_rec.CANCELLED_QUANTITY2 := FND_API.G_MISS_NUM; --OPM
1659 l_rowtype_rec.COMPONENT_CODE := FND_API.G_MISS_CHAR;
1660 l_rowtype_rec.COMPONENT_NUMBER := FND_API.G_MISS_NUM;
1661 l_rowtype_rec.COMPONENT_SEQUENCE_ID := FND_API.G_MISS_NUM;
1662 l_rowtype_rec.CONFIGURATION_ID := FND_API.G_MISS_NUM;
1663 l_rowtype_rec.CONFIG_DISPLAY_SEQUENCE := FND_API.G_MISS_NUM;
1664 l_rowtype_rec.CONFIG_HEADER_ID := FND_API.G_MISS_NUM;
1665 l_rowtype_rec.CONFIG_REV_NBR := FND_API.G_MISS_NUM;
1666 l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
1667 l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
1668 l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
1669 l_rowtype_rec.CREDIT_INVOICE_LINE_ID := FND_API.G_MISS_NUM;
1670 l_rowtype_rec.CUSTOMER_DOCK_CODE := FND_API.G_MISS_CHAR;
1671 l_rowtype_rec.CUSTOMER_JOB := FND_API.G_MISS_CHAR;
1672 l_rowtype_rec.CUSTOMER_PRODUCTION_LINE := FND_API.G_MISS_CHAR;
1673 l_rowtype_rec.CUSTOMER_TRX_LINE_ID := FND_API.G_MISS_NUM;
1674 l_rowtype_rec.CUST_MODEL_SERIAL_NUMBER := FND_API.G_MISS_CHAR;
1675 l_rowtype_rec.CUST_PO_NUMBER := FND_API.G_MISS_CHAR;
1676 l_rowtype_rec.CUSTOMER_LINE_NUMBER := FND_API.G_MISS_CHAR;
1677 l_rowtype_rec.CUST_PRODUCTION_SEQ_NUM := FND_API.G_MISS_CHAR;
1678 l_rowtype_rec.DELIVERY_LEAD_TIME := FND_API.G_MISS_NUM;
1679 l_rowtype_rec.DELIVER_TO_CONTACT_ID := FND_API.G_MISS_NUM;
1680 l_rowtype_rec.DELIVER_TO_ORG_ID := FND_API.G_MISS_NUM;
1681 l_rowtype_rec.DEMAND_BUCKET_TYPE_CODE := FND_API.G_MISS_CHAR;
1682 l_rowtype_rec.DEMAND_CLASS_CODE := FND_API.G_MISS_CHAR;
1683 l_rowtype_rec.DEP_PLAN_REQUIRED_FLAG := FND_API.G_MISS_CHAR;
1684 l_rowtype_rec.EARLIEST_ACCEPTABLE_DATE := FND_API.G_MISS_DATE;
1685 l_rowtype_rec.END_ITEM_UNIT_NUMBER := FND_API.G_MISS_CHAR;
1686 l_rowtype_rec.EXPLOSION_DATE := FND_API.G_MISS_DATE;
1687 l_rowtype_rec.FOB_POINT_CODE := FND_API.G_MISS_CHAR;
1688 l_rowtype_rec.FREIGHT_CARRIER_CODE := FND_API.G_MISS_CHAR;
1689 l_rowtype_rec.FREIGHT_TERMS_CODE := FND_API.G_MISS_CHAR;
1690 l_rowtype_rec.FULFILLED_QUANTITY := FND_API.G_MISS_NUM;
1691 l_rowtype_rec.FULFILLED_FLAG := FND_API.G_MISS_CHAR;
1692 l_rowtype_rec.FULFILLMENT_METHOD_CODE := FND_API.G_MISS_CHAR;
1693 l_rowtype_rec.FULFILLMENT_DATE := FND_API.G_MISS_DATE;
1694 l_rowtype_rec.GLOBAL_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1695 l_rowtype_rec.GLOBAL_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
1696 l_rowtype_rec.GLOBAL_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
1697 l_rowtype_rec.GLOBAL_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
1698 l_rowtype_rec.GLOBAL_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
1699 l_rowtype_rec.GLOBAL_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
1700 l_rowtype_rec.GLOBAL_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
1701 l_rowtype_rec.GLOBAL_ATTRIBUTE16 := FND_API.G_MISS_CHAR;
1702 l_rowtype_rec.GLOBAL_ATTRIBUTE17 := FND_API.G_MISS_CHAR;
1703 l_rowtype_rec.GLOBAL_ATTRIBUTE18 := FND_API.G_MISS_CHAR;
1704 l_rowtype_rec.GLOBAL_ATTRIBUTE19 := FND_API.G_MISS_CHAR;
1705 l_rowtype_rec.GLOBAL_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1706 l_rowtype_rec.GLOBAL_ATTRIBUTE20 := FND_API.G_MISS_CHAR;
1707 l_rowtype_rec.GLOBAL_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
1708 l_rowtype_rec.GLOBAL_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
1709 l_rowtype_rec.GLOBAL_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
1710 l_rowtype_rec.GLOBAL_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
1711 l_rowtype_rec.GLOBAL_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
1712 l_rowtype_rec.GLOBAL_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
1713 l_rowtype_rec.GLOBAL_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
1714 l_rowtype_rec.GLOBAL_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
1715 l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
1716 l_rowtype_rec.INDUSTRY_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1717 l_rowtype_rec.INDUSTRY_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
1718 l_rowtype_rec.INDUSTRY_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
1719 l_rowtype_rec.INDUSTRY_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
1720 l_rowtype_rec.INDUSTRY_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
1721 l_rowtype_rec.INDUSTRY_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
1722 l_rowtype_rec.INDUSTRY_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
1723 l_rowtype_rec.INDUSTRY_ATTRIBUTE16 := FND_API.G_MISS_CHAR;
1724 l_rowtype_rec.INDUSTRY_ATTRIBUTE17 := FND_API.G_MISS_CHAR;
1725 l_rowtype_rec.INDUSTRY_ATTRIBUTE18 := FND_API.G_MISS_CHAR;
1726 l_rowtype_rec.INDUSTRY_ATTRIBUTE19 := FND_API.G_MISS_CHAR;
1727 l_rowtype_rec.INDUSTRY_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1728 l_rowtype_rec.INDUSTRY_ATTRIBUTE20 := FND_API.G_MISS_CHAR;
1729 l_rowtype_rec.INDUSTRY_ATTRIBUTE21 := FND_API.G_MISS_CHAR;
1730 l_rowtype_rec.INDUSTRY_ATTRIBUTE22 := FND_API.G_MISS_CHAR;
1731 l_rowtype_rec.INDUSTRY_ATTRIBUTE23 := FND_API.G_MISS_CHAR;
1732 l_rowtype_rec.INDUSTRY_ATTRIBUTE24 := FND_API.G_MISS_CHAR;
1733 l_rowtype_rec.INDUSTRY_ATTRIBUTE25 := FND_API.G_MISS_CHAR;
1734 l_rowtype_rec.INDUSTRY_ATTRIBUTE26 := FND_API.G_MISS_CHAR;
1735 l_rowtype_rec.INDUSTRY_ATTRIBUTE27 := FND_API.G_MISS_CHAR;
1736 l_rowtype_rec.INDUSTRY_ATTRIBUTE28 := FND_API.G_MISS_CHAR;
1737 l_rowtype_rec.INDUSTRY_ATTRIBUTE29 := FND_API.G_MISS_CHAR;
1738 l_rowtype_rec.INDUSTRY_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
1739 l_rowtype_rec.INDUSTRY_ATTRIBUTE30 := FND_API.G_MISS_CHAR;
1740 l_rowtype_rec.INDUSTRY_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
1741 l_rowtype_rec.INDUSTRY_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
1742 l_rowtype_rec.INDUSTRY_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
1743 l_rowtype_rec.INDUSTRY_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
1744 l_rowtype_rec.INDUSTRY_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
1745 l_rowtype_rec.INDUSTRY_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
1746 l_rowtype_rec.INDUSTRY_CONTEXT := FND_API.G_MISS_CHAR;
1747 l_rowtype_rec.INTERMED_SHIP_TO_CONTACT_ID := FND_API.G_MISS_NUM;
1748 l_rowtype_rec.INTERMED_SHIP_TO_ORG_ID := FND_API.G_MISS_NUM;
1749 l_rowtype_rec.INVENTORY_ITEM_ID := FND_API.G_MISS_NUM;
1750 l_rowtype_rec.INVOICE_INTERFACE_STATUS_CODE := FND_API.G_MISS_CHAR;
1751 l_rowtype_rec.INVOICE_TO_CONTACT_ID := FND_API.G_MISS_NUM;
1752 l_rowtype_rec.INVOICE_TO_ORG_ID := FND_API.G_MISS_NUM;
1753 l_rowtype_rec.INVOICED_QUANTITY := FND_API.G_MISS_NUM;
1754 l_rowtype_rec.INVOICING_RULE_ID := FND_API.G_MISS_NUM;
1755 l_rowtype_rec.ORDERED_ITEM_ID := FND_API.G_MISS_NUM;
1756 l_rowtype_rec.ITEM_IDENTIFIER_TYPE := FND_API.G_MISS_CHAR;
1757 l_rowtype_rec.ORDERED_ITEM := FND_API.G_MISS_CHAR;
1758 l_rowtype_rec.ITEM_REVISION := FND_API.G_MISS_CHAR;
1759 l_rowtype_rec.ITEM_TYPE_CODE := FND_API.G_MISS_CHAR;
1760 l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
1761 l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
1762 l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
1763 l_rowtype_rec.LATEST_ACCEPTABLE_DATE := FND_API.G_MISS_DATE;
1764 l_rowtype_rec.LINE_CATEGORY_CODE := FND_API.G_MISS_CHAR;
1765 l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
1766 l_rowtype_rec.LINE_NUMBER := FND_API.G_MISS_NUM;
1767 l_rowtype_rec.LINE_TYPE_ID := FND_API.G_MISS_NUM;
1768 l_rowtype_rec.LINK_TO_LINE_ID := FND_API.G_MISS_NUM;
1769 l_rowtype_rec.MFG_COMPONENT_SEQUENCE_ID := FND_API.G_MISS_NUM;
1770 l_rowtype_rec.MODEL_GROUP_NUMBER := FND_API.G_MISS_NUM;
1771 l_rowtype_rec.OPEN_FLAG := FND_API.G_MISS_CHAR;
1772 l_rowtype_rec.OPTION_FLAG := FND_API.G_MISS_CHAR;
1773 l_rowtype_rec.OPTION_NUMBER := FND_API.G_MISS_NUM;
1774 l_rowtype_rec.ORDERED_QUANTITY := FND_API.G_MISS_NUM;
1775 l_rowtype_rec.ORDERED_QUANTITY2 := FND_API.G_MISS_NUM; -- OPM 1857167
1776 l_rowtype_rec.ORDER_QUANTITY_UOM := FND_API.G_MISS_CHAR;
1777 l_rowtype_rec.ORG_ID := FND_API.G_MISS_NUM;
1778 l_rowtype_rec.ORIG_SYS_DOCUMENT_REF := FND_API.G_MISS_CHAR;
1779 l_rowtype_rec.ORIG_SYS_LINE_REF := FND_API.G_MISS_CHAR;
1780 l_rowtype_rec.OVER_SHIP_REASON_CODE := FND_API.G_MISS_CHAR;
1781 l_rowtype_rec.OVER_SHIP_RESOLVED_FLAG := FND_API.G_MISS_CHAR;
1782 l_rowtype_rec.PACKING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
1783 l_rowtype_rec.PAYMENT_TERM_ID := FND_API.G_MISS_NUM;
1784 l_rowtype_rec.PLANNING_PRIORITY := FND_API.G_MISS_NUM;
1785 l_rowtype_rec.PRICE_LIST_ID := FND_API.G_MISS_NUM;
1786 l_rowtype_rec.PRICE_REQUEST_CODE := FND_API.G_MISS_CHAR; -- PROMOTIONS SEP/01
1787 l_rowtype_rec.PRICING_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1788 l_rowtype_rec.PRICING_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
1789 l_rowtype_rec.PRICING_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1790 l_rowtype_rec.PRICING_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
1791 l_rowtype_rec.PRICING_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
1792 l_rowtype_rec.PRICING_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
1793 l_rowtype_rec.PRICING_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
1794 l_rowtype_rec.PRICING_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
1795 l_rowtype_rec.PRICING_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
1796 l_rowtype_rec.PRICING_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
1797 l_rowtype_rec.PRICING_CONTEXT := FND_API.G_MISS_CHAR;
1798 l_rowtype_rec.PRICING_DATE := FND_API.G_MISS_DATE;
1799 l_rowtype_rec.PRICING_QUANTITY := FND_API.G_MISS_NUM;
1800 l_rowtype_rec.PRICING_QUANTITY_UOM := FND_API.G_MISS_CHAR;
1801 l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
1802 l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
1803 l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
1804 l_rowtype_rec.PROJECT_ID := FND_API.G_MISS_NUM;
1805 l_rowtype_rec.PROMISE_DATE := FND_API.G_MISS_DATE;
1806 l_rowtype_rec.RE_SOURCE_FLAG := FND_API.G_MISS_CHAR;
1807 l_rowtype_rec.REFERENCE_CUSTOMER_TRX_LINE_ID := FND_API.G_MISS_NUM;
1808 l_rowtype_rec.REFERENCE_HEADER_ID := FND_API.G_MISS_NUM;
1809 l_rowtype_rec.REFERENCE_LINE_ID := FND_API.G_MISS_NUM;
1810 l_rowtype_rec.REFERENCE_TYPE := FND_API.G_MISS_CHAR;
1811 l_rowtype_rec.REQUEST_DATE := FND_API.G_MISS_DATE;
1812 l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
1813 l_rowtype_rec.RESERVED_QUANTITY := FND_API.G_MISS_NUM;
1814 l_rowtype_rec.RETURN_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1815 l_rowtype_rec.RETURN_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
1816 l_rowtype_rec.RETURN_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
1817 l_rowtype_rec.RETURN_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
1818 l_rowtype_rec.RETURN_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
1819 l_rowtype_rec.RETURN_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
1820 l_rowtype_rec.RETURN_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
1821 l_rowtype_rec.RETURN_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1822 l_rowtype_rec.RETURN_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
1823 l_rowtype_rec.RETURN_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
1824 l_rowtype_rec.RETURN_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
1825 l_rowtype_rec.RETURN_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
1826 l_rowtype_rec.RETURN_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
1827 l_rowtype_rec.RETURN_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
1828 l_rowtype_rec.RETURN_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
1829 l_rowtype_rec.RETURN_CONTEXT := FND_API.G_MISS_CHAR;
1830 l_rowtype_rec.RETURN_REASON_CODE := FND_API.G_MISS_CHAR;
1831 l_rowtype_rec.RLA_SCHEDULE_TYPE_CODE := FND_API.G_MISS_CHAR;
1832 l_rowtype_rec.SALESREP_ID := FND_API.G_MISS_NUM;
1833 l_rowtype_rec.SCHEDULE_ACTION_CODE := FND_API.G_MISS_CHAR;
1834 l_rowtype_rec.SPLIT_ACTION_CODE := FND_API.G_MISS_CHAR;
1835 l_rowtype_rec.SCHEDULE_ARRIVAL_DATE := FND_API.G_MISS_DATE;
1836 l_rowtype_rec.SCHEDULE_SHIP_DATE := FND_API.G_MISS_DATE;
1837 l_rowtype_rec.SCHEDULE_STATUS_CODE := FND_API.G_MISS_CHAR;
1838 l_rowtype_rec.SHIPMENT_NUMBER := FND_API.G_MISS_NUM;
1839 l_rowtype_rec.SHIPMENT_PRIORITY_CODE := FND_API.G_MISS_CHAR;
1840 l_rowtype_rec.SHIPPED_QUANTITY := FND_API.G_MISS_NUM;
1841 l_rowtype_rec.SHIPPING_INTERFACED_FLAG := FND_API.G_MISS_CHAR;
1842 l_rowtype_rec.SHIPPING_METHOD_CODE := FND_API.G_MISS_CHAR;
1843 l_rowtype_rec.SHIPPING_QUANTITY := FND_API.G_MISS_NUM;
1844 l_rowtype_rec.SHIPPING_QUANTITY_UOM := FND_API.G_MISS_CHAR;
1845 l_rowtype_rec.SHIPPING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
1846 l_rowtype_rec.SHIP_FROM_ORG_ID := FND_API.G_MISS_NUM;
1847 l_rowtype_rec.SUBINVENTORY := FND_API.G_MISS_CHAR;
1848 l_rowtype_rec.SHIP_MODEL_COMPLETE_FLAG := FND_API.G_MISS_CHAR;
1849 l_rowtype_rec.SHIP_SET := FND_API.G_MISS_CHAR;
1850 l_rowtype_rec.SHIP_SET_ID := FND_API.G_MISS_NUM;
1851 l_rowtype_rec.SHIP_TOLERANCE_ABOVE := FND_API.G_MISS_NUM;
1852 l_rowtype_rec.SHIP_TOLERANCE_BELOW := FND_API.G_MISS_NUM;
1853 l_rowtype_rec.SHIP_TO_CONTACT_ID := FND_API.G_MISS_NUM;
1854 l_rowtype_rec.SHIP_TO_ORG_ID := FND_API.G_MISS_NUM;
1855 l_rowtype_rec.SOLD_FROM_ORG_ID := FND_API.G_MISS_NUM;
1856 l_rowtype_rec.SOLD_TO_ORG_ID := FND_API.G_MISS_NUM;
1857 l_rowtype_rec.SORT_ORDER := FND_API.G_MISS_CHAR;
1858 l_rowtype_rec.SOURCE_DOCUMENT_ID := FND_API.G_MISS_NUM;
1859 l_rowtype_rec.SOURCE_DOCUMENT_LINE_ID := FND_API.G_MISS_NUM;
1860 l_rowtype_rec.SOURCE_DOCUMENT_TYPE_ID := FND_API.G_MISS_NUM;
1861 l_rowtype_rec.SOURCE_TYPE_CODE := FND_API.G_MISS_CHAR;
1862 l_rowtype_rec.SPLIT_FROM_LINE_ID := FND_API.G_MISS_NUM;
1863 l_rowtype_rec.LINE_SET_ID := FND_API.G_MISS_NUM;
1864 l_rowtype_rec.SPLIT_BY := FND_API.G_MISS_CHAR;
1865 l_rowtype_rec.Model_remnant_flag := FND_API.G_MISS_CHAR;
1866 l_rowtype_rec.TASK_ID := FND_API.G_MISS_NUM;
1867 l_rowtype_rec.TAX_CODE := FND_API.G_MISS_CHAR;
1868 l_rowtype_rec.TAX_DATE := FND_API.G_MISS_DATE;
1869 l_rowtype_rec.TAX_EXEMPT_FLAG := FND_API.G_MISS_CHAR;
1870 l_rowtype_rec.TAX_EXEMPT_NUMBER := FND_API.G_MISS_CHAR;
1871 l_rowtype_rec.TAX_EXEMPT_REASON_CODE := FND_API.G_MISS_CHAR;
1872 l_rowtype_rec.TAX_POINT_CODE := FND_API.G_MISS_CHAR;
1873 l_rowtype_rec.TAX_RATE := FND_API.G_MISS_NUM;
1874 l_rowtype_rec.TAX_VALUE := FND_API.G_MISS_NUM;
1875 l_rowtype_rec.TOP_MODEL_LINE_ID := FND_API.G_MISS_NUM;
1876 l_rowtype_rec.UNIT_LIST_PRICE := FND_API.G_MISS_NUM;
1877 l_rowtype_rec.UNIT_SELLING_PRICE := FND_API.G_MISS_NUM;
1878 l_rowtype_rec.VEH_CUS_ITEM_CUM_KEY_ID := FND_API.G_MISS_NUM;
1879 l_rowtype_rec.VISIBLE_DEMAND_FLAG := FND_API.G_MISS_CHAR;
1880 l_rowtype_rec.SHIPPABLE_FLAG := FND_API.G_MISS_CHAR;
1881 l_rowtype_rec.SERVICE_TXN_REASON_CODE := FND_API.G_MISS_CHAR;
1882 l_rowtype_rec.SERVICE_DURATION := FND_API.G_MISS_NUM;
1883 l_rowtype_rec.SERVICE_PERIOD := FND_API.G_MISS_CHAR;
1884 l_rowtype_rec.SERVICE_START_DATE := FND_API.G_MISS_DATE;
1885 l_rowtype_rec.SERVICE_END_DATE := FND_API.G_MISS_DATE;
1886 l_rowtype_rec.SERVICE_COTERMINATE_FLAG := FND_API.G_MISS_CHAR;
1887 l_rowtype_rec.SERVICE_TXN_COMMENTS := FND_API.G_MISS_CHAR;
1888 l_rowtype_rec.UNIT_SELLING_PERCENT := FND_API.G_MISS_NUM;
1889 l_rowtype_rec.UNIT_LIST_PERCENT := FND_API.G_MISS_NUM;
1890 l_rowtype_rec.UNIT_PERCENT_BASE_PRICE := FND_API.G_MISS_NUM;
1891 l_rowtype_rec.SERVICE_NUMBER := FND_API.G_MISS_NUM;
1892 l_rowtype_rec.SERVICE_REFERENCE_TYPE_CODE := FND_API.G_MISS_CHAR;
1893 --sol_ord_er #16014165
1894 l_rowtype_rec.SERVICE_BILL_PROFILE_ID :=FND_API.G_MISS_NUM;
1895 l_rowtype_rec.service_cov_template_id :=FND_API.G_MISS_NUM;
1896 l_rowtype_rec.service_subs_template_id :=FND_API.G_MISS_NUM;
1897 l_rowtype_rec.service_bill_option_code :=FND_API.G_MISS_CHAR;
1898 --sol_ord_er #16014165 end
1899 l_rowtype_rec.SERVICE_REFERENCE_LINE_ID := FND_API.G_MISS_NUM;
1900 l_rowtype_rec.SERVICE_REFERENCE_SYSTEM_ID := FND_API.G_MISS_NUM;
1901 l_rowtype_rec.TP_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1902 l_rowtype_rec.TP_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
1903 l_rowtype_rec.TP_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
1904 l_rowtype_rec.TP_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
1905 l_rowtype_rec.TP_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
1906 l_rowtype_rec.TP_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
1907 l_rowtype_rec.TP_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
1908 l_rowtype_rec.TP_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1909 l_rowtype_rec.TP_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
1910 l_rowtype_rec.TP_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
1911 l_rowtype_rec.TP_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
1912 l_rowtype_rec.TP_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
1913 l_rowtype_rec.TP_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
1914 l_rowtype_rec.TP_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
1915 l_rowtype_rec.TP_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
1916 l_rowtype_rec.TP_CONTEXT := FND_API.G_MISS_CHAR;
1917 l_rowtype_rec.CALCULATE_PRICE_FLAG := FND_API.G_MISS_CHAR;
1918 -- QUOTING changes
1919 l_rowtype_rec.TRANSACTION_PHASE_CODE := FND_API.G_MISS_CHAR;
1920 l_rowtype_rec.SOURCE_DOCUMENT_VERSION_NUMBER := FND_API.G_MISS_NUM;
1921 --key Transaction Dates Project
1922 l_rowtype_rec.order_firmed_date := FND_API.G_MISS_DATE;
1923 l_rowtype_rec.actual_fulfillment_date := FND_API.G_MISS_DATE;
1924 -- INVCONV
1925 l_rowtype_rec.FULFILLED_QUANTITY2 := FND_API.G_MISS_NUM;
1926 l_rowtype_rec.SHIPPED_QUANTITY2 := FND_API.G_MISS_NUM;
1927 l_rowtype_rec.SHIPPING_QUANTITY2 := FND_API.G_MISS_NUM;
1928 l_rowtype_rec.SHIPPING_QUANTITY_UOM2 := FND_API.G_MISS_CHAR;
1929 l_rowtype_rec.charge_periodicity_code := FND_API.G_MISS_CHAR; -- Rakesh
1930
1931
1932 RETURN l_rowtype_rec;
1933
1934 EXCEPTION
1935 WHEN OTHERS THEN
1936 IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1937 THEN
1938 oe_msg_pub.Add_Exc_Msg
1939 ( G_PKG_NAME
1940 , 'G_MISS_OE_AK_LINE_REC'
1941 );
1942 END IF;
1943 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1944 END G_MISS_OE_AK_LINE_REC;
1945
1946 PROCEDURE API_Rec_To_Rowtype_Rec
1947 ( p_LINE_rec IN OE_Order_PUB.LINE_Rec_Type
1948 , x_rowtype_rec IN OUT NOCOPY OE_AK_ORDER_LINES_V%ROWTYPE
1949 ) IS
1950 BEGIN
1951
1952 x_rowtype_rec.ACCOUNTING_RULE_ID := p_line_rec.ACCOUNTING_RULE_ID;
1953 x_rowtype_rec.ACCOUNTING_RULE_DURATION := p_line_rec.ACCOUNTING_RULE_DURATION;
1954 x_rowtype_rec.ACTUAL_ARRIVAL_DATE := p_line_rec.ACTUAL_ARRIVAL_DATE;
1955 x_rowtype_rec.ACTUAL_SHIPMENT_DATE := p_line_rec.ACTUAL_SHIPMENT_DATE;
1956 x_rowtype_rec.AGREEMENT_ID := p_line_rec.AGREEMENT_ID;
1957 x_rowtype_rec.ARRIVAL_SET := p_line_rec.ARRIVAL_SET;
1958 x_rowtype_rec.upgraded_flag := p_line_rec.upgraded_flag;
1959 x_rowtype_rec.ARRIVAL_SET_ID := p_line_rec.ARRIVAL_SET_ID;
1960 x_rowtype_rec.ATO_LINE_ID := p_line_rec.ATO_LINE_ID;
1961 x_rowtype_rec.ATTRIBUTE1 := p_line_rec.ATTRIBUTE1;
1962 x_rowtype_rec.ATTRIBUTE10 := p_line_rec.ATTRIBUTE10;
1963 x_rowtype_rec.ATTRIBUTE11 := p_line_rec.ATTRIBUTE11;
1964 x_rowtype_rec.ATTRIBUTE12 := p_line_rec.ATTRIBUTE12;
1965 x_rowtype_rec.ATTRIBUTE13 := p_line_rec.ATTRIBUTE13;
1966 x_rowtype_rec.ATTRIBUTE14 := p_line_rec.ATTRIBUTE14;
1967 x_rowtype_rec.ATTRIBUTE15 := p_line_rec.ATTRIBUTE15;
1968 x_rowtype_rec.ATTRIBUTE16 := p_line_rec.ATTRIBUTE16; --For bug 2184255
1969 x_rowtype_rec.ATTRIBUTE17 := p_line_rec.ATTRIBUTE17;
1970 x_rowtype_rec.ATTRIBUTE18 := p_line_rec.ATTRIBUTE18;
1971 x_rowtype_rec.ATTRIBUTE19 := p_line_rec.ATTRIBUTE19;
1972 x_rowtype_rec.ATTRIBUTE2 := p_line_rec.ATTRIBUTE2;
1973 x_rowtype_rec.ATTRIBUTE20 := p_line_rec.ATTRIBUTE20;
1974 x_rowtype_rec.ATTRIBUTE3 := p_line_rec.ATTRIBUTE3;
1975 x_rowtype_rec.ATTRIBUTE4 := p_line_rec.ATTRIBUTE4;
1976 x_rowtype_rec.ATTRIBUTE5 := p_line_rec.ATTRIBUTE5;
1977 x_rowtype_rec.ATTRIBUTE6 := p_line_rec.ATTRIBUTE6;
1978 x_rowtype_rec.ATTRIBUTE7 := p_line_rec.ATTRIBUTE7;
1979 x_rowtype_rec.ATTRIBUTE8 := p_line_rec.ATTRIBUTE8;
1980 x_rowtype_rec.ATTRIBUTE9 := p_line_rec.ATTRIBUTE9;
1981 x_rowtype_rec.AUTHORIZED_TO_SHIP_FLAG := p_line_rec.AUTHORIZED_TO_SHIP_FLAG;
1982 x_rowtype_rec.AUTO_SELECTED_QUANTITY := p_line_rec.AUTO_SELECTED_QUANTITY;
1983 x_rowtype_rec.BLANKET_NUMBER := p_line_rec.BLANKET_NUMBER;
1984 x_rowtype_rec.BLANKET_LINE_NUMBER := p_line_rec.BLANKET_LINE_NUMBER;
1985 x_rowtype_rec.BLANKET_VERSION_NUMBER := p_line_rec.BLANKET_VERSION_NUMBER;
1986 x_rowtype_rec.BOOKED_FLAG := p_line_rec.BOOKED_FLAG;
1987 x_rowtype_rec.CALCULATE_PRICE_FLAG := p_line_rec.CALCULATE_PRICE_FLAG;
1988 x_rowtype_rec.CANCELLED_FLAG := p_line_rec.CANCELLED_FLAG;
1989 x_rowtype_rec.CANCELLED_QUANTITY := p_line_rec.CANCELLED_QUANTITY;
1990 x_rowtype_rec.CANCELLED_QUANTITY2 := p_line_rec.CANCELLED_QUANTITY2;
1991 x_rowtype_rec.COMMITMENT_ID := p_line_rec.COMMITMENT_ID;
1992 x_rowtype_rec.COMPONENT_CODE := p_line_rec.COMPONENT_CODE;
1993 x_rowtype_rec.COMPONENT_NUMBER := p_line_rec.COMPONENT_NUMBER;
1994 x_rowtype_rec.COMPONENT_SEQUENCE_ID := p_line_rec.COMPONENT_SEQUENCE_ID;
1995 x_rowtype_rec.CONFIGURATION_ID := p_line_rec.CONFIGURATION_ID;
1996 x_rowtype_rec.CONFIG_DISPLAY_SEQUENCE := p_line_rec.CONFIG_DISPLAY_SEQUENCE;
1997 x_rowtype_rec.CONFIG_HEADER_ID := p_line_rec.CONFIG_HEADER_ID;
1998 x_rowtype_rec.CONFIG_REV_NBR := p_line_rec.CONFIG_REV_NBR;
1999 x_rowtype_rec.CONTEXT := p_line_rec.CONTEXT;
2000 x_rowtype_rec.CREATED_BY := p_line_rec.CREATED_BY;
2001 x_rowtype_rec.CREATION_DATE := p_line_rec.CREATION_DATE;
2002 x_rowtype_rec.CREDIT_INVOICE_LINE_ID := p_line_rec.CREDIT_INVOICE_LINE_ID;
2003 x_rowtype_rec.CUSTOMER_DOCK_CODE := p_line_rec.CUSTOMER_DOCK_CODE;
2004 x_rowtype_rec.CUSTOMER_JOB := p_line_rec.CUSTOMER_JOB;
2005 x_rowtype_rec.CUSTOMER_PRODUCTION_LINE := p_line_rec.CUSTOMER_PRODUCTION_LINE;
2006 x_rowtype_rec.CUSTOMER_TRX_LINE_ID := p_line_rec.CUSTOMER_TRX_LINE_ID;
2007 x_rowtype_rec.CUST_MODEL_SERIAL_NUMBER := p_line_rec.CUST_MODEL_SERIAL_NUMBER;
2008 x_rowtype_rec.CUST_PO_NUMBER := p_line_rec.CUST_PO_NUMBER;
2009 x_rowtype_rec.CUSTOMER_LINE_NUMBER := p_line_rec.CUSTOMER_LINE_NUMBER;
2010 --bug 11932310
2011 x_rowtype_rec.CUSTOMER_SHIPMENT_NUMBER := p_line_rec.CUSTOMER_SHIPMENT_NUMBER;
2012 x_rowtype_rec.CUST_PRODUCTION_SEQ_NUM := p_line_rec.CUST_PRODUCTION_SEQ_NUM;
2013 x_rowtype_rec.DELIVERY_LEAD_TIME := p_line_rec.DELIVERY_LEAD_TIME;
2014 x_rowtype_rec.DELIVER_TO_CONTACT_ID := p_line_rec.DELIVER_TO_CONTACT_ID;
2015 x_rowtype_rec.DELIVER_TO_ORG_ID := p_line_rec.DELIVER_TO_ORG_ID;
2016 x_rowtype_rec.DEMAND_BUCKET_TYPE_CODE := p_line_rec.DEMAND_BUCKET_TYPE_CODE;
2017 x_rowtype_rec.DEMAND_CLASS_CODE := p_line_rec.DEMAND_CLASS_CODE;
2018 x_rowtype_rec.DEP_PLAN_REQUIRED_FLAG := p_line_rec.DEP_PLAN_REQUIRED_FLAG;
2019 x_rowtype_rec.EARLIEST_ACCEPTABLE_DATE := p_line_rec.EARLIEST_ACCEPTABLE_DATE;
2020 x_rowtype_rec.END_ITEM_UNIT_NUMBER := p_line_rec.END_ITEM_UNIT_NUMBER;
2021 x_rowtype_rec.EXPLOSION_DATE := p_line_rec.EXPLOSION_DATE;
2022 x_rowtype_rec.FOB_POINT_CODE := p_line_rec.FOB_POINT_CODE;
2023 x_rowtype_rec.FREIGHT_CARRIER_CODE := p_line_rec.FREIGHT_CARRIER_CODE;
2024 x_rowtype_rec.FREIGHT_TERMS_CODE := p_line_rec.FREIGHT_TERMS_CODE;
2025 x_rowtype_rec.FULFILLED_QUANTITY := p_line_rec.FULFILLED_QUANTITY;
2026 x_rowtype_rec.FULFILLED_QUANTITY2 := p_line_rec.FULFILLED_QUANTITY2;
2027 x_rowtype_rec.FULFILLED_FLAG := p_line_rec.FULFILLED_FLAG;
2028 x_rowtype_rec.FULFILLMENT_METHOD_CODE := p_line_rec.FULFILLMENT_METHOD_CODE;
2029 x_rowtype_rec.FULFILLMENT_DATE := p_line_rec.FULFILLMENT_DATE;
2030 x_rowtype_rec.GLOBAL_ATTRIBUTE1 := p_line_rec.GLOBAL_ATTRIBUTE1;
2031 x_rowtype_rec.GLOBAL_ATTRIBUTE10 := p_line_rec.GLOBAL_ATTRIBUTE10;
2032 x_rowtype_rec.GLOBAL_ATTRIBUTE11 := p_line_rec.GLOBAL_ATTRIBUTE11;
2033 x_rowtype_rec.GLOBAL_ATTRIBUTE12 := p_line_rec.GLOBAL_ATTRIBUTE12;
2034 x_rowtype_rec.GLOBAL_ATTRIBUTE13 := p_line_rec.GLOBAL_ATTRIBUTE13;
2035 x_rowtype_rec.GLOBAL_ATTRIBUTE14 := p_line_rec.GLOBAL_ATTRIBUTE14;
2036 x_rowtype_rec.GLOBAL_ATTRIBUTE15 := p_line_rec.GLOBAL_ATTRIBUTE15;
2037 x_rowtype_rec.GLOBAL_ATTRIBUTE16 := p_line_rec.GLOBAL_ATTRIBUTE16;
2038 x_rowtype_rec.GLOBAL_ATTRIBUTE17 := p_line_rec.GLOBAL_ATTRIBUTE17;
2039 x_rowtype_rec.GLOBAL_ATTRIBUTE18 := p_line_rec.GLOBAL_ATTRIBUTE18;
2040 x_rowtype_rec.GLOBAL_ATTRIBUTE19 := p_line_rec.GLOBAL_ATTRIBUTE19;
2041 x_rowtype_rec.GLOBAL_ATTRIBUTE2 := p_line_rec.GLOBAL_ATTRIBUTE2;
2042 x_rowtype_rec.GLOBAL_ATTRIBUTE20 := p_line_rec.GLOBAL_ATTRIBUTE20;
2043 x_rowtype_rec.GLOBAL_ATTRIBUTE3 := p_line_rec.GLOBAL_ATTRIBUTE3;
2044 x_rowtype_rec.GLOBAL_ATTRIBUTE4 := p_line_rec.GLOBAL_ATTRIBUTE4;
2045 x_rowtype_rec.GLOBAL_ATTRIBUTE5 := p_line_rec.GLOBAL_ATTRIBUTE5;
2046 x_rowtype_rec.GLOBAL_ATTRIBUTE6 := p_line_rec.GLOBAL_ATTRIBUTE6;
2047 x_rowtype_rec.GLOBAL_ATTRIBUTE7 := p_line_rec.GLOBAL_ATTRIBUTE7;
2048 x_rowtype_rec.GLOBAL_ATTRIBUTE8 := p_line_rec.GLOBAL_ATTRIBUTE8;
2049 x_rowtype_rec.GLOBAL_ATTRIBUTE9 := p_line_rec.GLOBAL_ATTRIBUTE9;
2050 x_rowtype_rec.GLOBAL_ATTRIBUTE_CATEGORY := p_line_rec.GLOBAL_ATTRIBUTE_CATEGORY;
2051 x_rowtype_rec.HEADER_ID := p_line_rec.HEADER_ID;
2052 x_rowtype_rec.INDUSTRY_ATTRIBUTE1 := p_line_rec.INDUSTRY_ATTRIBUTE1;
2053 x_rowtype_rec.INDUSTRY_ATTRIBUTE10 := p_line_rec.INDUSTRY_ATTRIBUTE10;
2054 x_rowtype_rec.INDUSTRY_ATTRIBUTE11 := p_line_rec.INDUSTRY_ATTRIBUTE11;
2055 x_rowtype_rec.INDUSTRY_ATTRIBUTE12 := p_line_rec.INDUSTRY_ATTRIBUTE12;
2056 x_rowtype_rec.INDUSTRY_ATTRIBUTE13 := p_line_rec.INDUSTRY_ATTRIBUTE13;
2057 x_rowtype_rec.INDUSTRY_ATTRIBUTE14 := p_line_rec.INDUSTRY_ATTRIBUTE14;
2058 x_rowtype_rec.INDUSTRY_ATTRIBUTE15 := p_line_rec.INDUSTRY_ATTRIBUTE15;
2059 x_rowtype_rec.INDUSTRY_ATTRIBUTE16 := p_line_rec.INDUSTRY_ATTRIBUTE16;
2060 x_rowtype_rec.INDUSTRY_ATTRIBUTE17 := p_line_rec.INDUSTRY_ATTRIBUTE17;
2061 x_rowtype_rec.INDUSTRY_ATTRIBUTE18 := p_line_rec.INDUSTRY_ATTRIBUTE18;
2062 x_rowtype_rec.INDUSTRY_ATTRIBUTE19 := p_line_rec.INDUSTRY_ATTRIBUTE19;
2063 x_rowtype_rec.INDUSTRY_ATTRIBUTE2 := p_line_rec.INDUSTRY_ATTRIBUTE2;
2064 x_rowtype_rec.INDUSTRY_ATTRIBUTE20 := p_line_rec.INDUSTRY_ATTRIBUTE20;
2065 x_rowtype_rec.INDUSTRY_ATTRIBUTE21 := p_line_rec.INDUSTRY_ATTRIBUTE21;
2066 x_rowtype_rec.INDUSTRY_ATTRIBUTE22 := p_line_rec.INDUSTRY_ATTRIBUTE22;
2067 x_rowtype_rec.INDUSTRY_ATTRIBUTE23 := p_line_rec.INDUSTRY_ATTRIBUTE23;
2068 x_rowtype_rec.INDUSTRY_ATTRIBUTE24 := p_line_rec.INDUSTRY_ATTRIBUTE24;
2069 x_rowtype_rec.INDUSTRY_ATTRIBUTE25 := p_line_rec.INDUSTRY_ATTRIBUTE25;
2070 x_rowtype_rec.INDUSTRY_ATTRIBUTE26 := p_line_rec.INDUSTRY_ATTRIBUTE26;
2071 x_rowtype_rec.INDUSTRY_ATTRIBUTE27 := p_line_rec.INDUSTRY_ATTRIBUTE27;
2072 x_rowtype_rec.INDUSTRY_ATTRIBUTE28 := p_line_rec.INDUSTRY_ATTRIBUTE28;
2073 x_rowtype_rec.INDUSTRY_ATTRIBUTE29 := p_line_rec.INDUSTRY_ATTRIBUTE29;
2074 x_rowtype_rec.INDUSTRY_ATTRIBUTE3 := p_line_rec.INDUSTRY_ATTRIBUTE3;
2075 x_rowtype_rec.INDUSTRY_ATTRIBUTE30 := p_line_rec.INDUSTRY_ATTRIBUTE30;
2076 x_rowtype_rec.INDUSTRY_ATTRIBUTE4 := p_line_rec.INDUSTRY_ATTRIBUTE4;
2077 x_rowtype_rec.INDUSTRY_ATTRIBUTE5 := p_line_rec.INDUSTRY_ATTRIBUTE5;
2078 x_rowtype_rec.INDUSTRY_ATTRIBUTE6 := p_line_rec.INDUSTRY_ATTRIBUTE6;
2079 x_rowtype_rec.INDUSTRY_ATTRIBUTE7 := p_line_rec.INDUSTRY_ATTRIBUTE7;
2080 x_rowtype_rec.INDUSTRY_ATTRIBUTE8 := p_line_rec.INDUSTRY_ATTRIBUTE8;
2081 x_rowtype_rec.INDUSTRY_ATTRIBUTE9 := p_line_rec.INDUSTRY_ATTRIBUTE9;
2082 x_rowtype_rec.INDUSTRY_CONTEXT := p_line_rec.INDUSTRY_CONTEXT;
2083 x_rowtype_rec.INTERMED_SHIP_TO_CONTACT_ID := p_line_rec.INTERMED_SHIP_TO_CONTACT_ID;
2084 x_rowtype_rec.INTERMED_SHIP_TO_ORG_ID := p_line_rec.INTERMED_SHIP_TO_ORG_ID;
2085 x_rowtype_rec.INVENTORY_ITEM_ID := p_line_rec.INVENTORY_ITEM_ID;
2086 x_rowtype_rec.INVOICE_INTERFACE_STATUS_CODE := p_line_rec.INVOICE_INTERFACE_STATUS_CODE;
2087 x_rowtype_rec.INVOICE_TO_CONTACT_ID := p_line_rec.INVOICE_TO_CONTACT_ID;
2088 x_rowtype_rec.INVOICE_TO_ORG_ID := p_line_rec.INVOICE_TO_ORG_ID;
2089 x_rowtype_rec.INVOICED_QUANTITY := p_line_rec.INVOICED_QUANTITY;
2090 x_rowtype_rec.INVOICING_RULE_ID := p_line_rec.INVOICING_RULE_ID;
2091 x_rowtype_rec.ORDERED_ITEM_ID := p_line_rec.ORDERED_ITEM_ID;
2092 x_rowtype_rec.ITEM_IDENTIFIER_TYPE := p_line_rec.ITEM_IDENTIFIER_TYPE;
2093 x_rowtype_rec.ORDERED_ITEM := p_line_rec.ORDERED_ITEM;
2094 x_rowtype_rec.ITEM_REVISION := p_line_rec.ITEM_REVISION;
2095 x_rowtype_rec.ITEM_TYPE_CODE := p_line_rec.ITEM_TYPE_CODE;
2096 x_rowtype_rec.LAST_UPDATED_BY := p_line_rec.LAST_UPDATED_BY;
2097 x_rowtype_rec.LAST_UPDATE_DATE := p_line_rec.LAST_UPDATE_DATE;
2098 x_rowtype_rec.LAST_UPDATE_LOGIN := p_line_rec.LAST_UPDATE_LOGIN;
2099 x_rowtype_rec.LATEST_ACCEPTABLE_DATE := p_line_rec.LATEST_ACCEPTABLE_DATE;
2100 x_rowtype_rec.LINE_CATEGORY_CODE := p_line_rec.LINE_CATEGORY_CODE;
2101 x_rowtype_rec.LINE_ID := p_line_rec.LINE_ID;
2102 x_rowtype_rec.LINE_NUMBER := p_line_rec.LINE_NUMBER;
2103 x_rowtype_rec.LINE_TYPE_ID := p_line_rec.LINE_TYPE_ID;
2104 x_rowtype_rec.LINK_TO_LINE_ID := p_line_rec.LINK_TO_LINE_ID;
2105 x_rowtype_rec.MFG_COMPONENT_SEQUENCE_ID := p_line_rec.MFG_COMPONENT_SEQUENCE_ID;
2106 x_rowtype_rec.MODEL_GROUP_NUMBER := p_line_rec.MODEL_GROUP_NUMBER;
2107 x_rowtype_rec.OPEN_FLAG := p_line_rec.OPEN_FLAG;
2108 x_rowtype_rec.OPTION_FLAG := p_line_rec.OPTION_FLAG;
2109 x_rowtype_rec.OPTION_NUMBER := p_line_rec.OPTION_NUMBER;
2110 x_rowtype_rec.ORDERED_QUANTITY := p_line_rec.ORDERED_QUANTITY;
2111 x_rowtype_rec.ORDERED_QUANTITY2 := p_line_rec.ORDERED_QUANTITY2;
2112 x_rowtype_rec.ORDER_QUANTITY_UOM := p_line_rec.ORDER_QUANTITY_UOM;
2113 x_rowtype_rec.ORDERED_QUANTITY_UOM2 := p_line_rec.ORDERED_QUANTITY_UOM2;
2114 x_rowtype_rec.ORG_ID := p_line_rec.ORG_ID;
2115 x_rowtype_rec.ORIG_SYS_DOCUMENT_REF := p_line_rec.ORIG_SYS_DOCUMENT_REF;
2116 x_rowtype_rec.ORIG_SYS_LINE_REF := p_line_rec.ORIG_SYS_LINE_REF;
2117 x_rowtype_rec.OVER_SHIP_REASON_CODE := p_line_rec.OVER_SHIP_REASON_CODE;
2118 x_rowtype_rec.OVER_SHIP_RESOLVED_FLAG := p_line_rec.OVER_SHIP_RESOLVED_FLAG;
2119 x_rowtype_rec.PACKING_INSTRUCTIONS := p_line_rec.PACKING_INSTRUCTIONS;
2120 x_rowtype_rec.PAYMENT_TERM_ID := p_line_rec.PAYMENT_TERM_ID;
2121 x_rowtype_rec.PLANNING_PRIORITY := p_line_rec.PLANNING_PRIORITY;
2122 x_rowtype_rec.PREFERRED_GRADE := p_line_rec.PREFERRED_GRADE;
2123 x_rowtype_rec.PRICE_LIST_ID := p_line_rec.PRICE_LIST_ID;
2124 x_rowtype_rec.PRICE_REQUEST_CODE := p_line_rec.PRICE_REQUEST_CODE; -- PROMOTIONS SEP/01
2125 x_rowtype_rec.PRICING_ATTRIBUTE1 := p_line_rec.PRICING_ATTRIBUTE1;
2126 x_rowtype_rec.PRICING_ATTRIBUTE10 := p_line_rec.PRICING_ATTRIBUTE10;
2127 x_rowtype_rec.PRICING_ATTRIBUTE2 := p_line_rec.PRICING_ATTRIBUTE2;
2128 x_rowtype_rec.PRICING_ATTRIBUTE3 := p_line_rec.PRICING_ATTRIBUTE3;
2129 x_rowtype_rec.PRICING_ATTRIBUTE4 := p_line_rec.PRICING_ATTRIBUTE4;
2130 x_rowtype_rec.PRICING_ATTRIBUTE5 := p_line_rec.PRICING_ATTRIBUTE5;
2131 x_rowtype_rec.PRICING_ATTRIBUTE6 := p_line_rec.PRICING_ATTRIBUTE6;
2132 x_rowtype_rec.PRICING_ATTRIBUTE7 := p_line_rec.PRICING_ATTRIBUTE7;
2133 x_rowtype_rec.PRICING_ATTRIBUTE8 := p_line_rec.PRICING_ATTRIBUTE8;
2134 x_rowtype_rec.PRICING_ATTRIBUTE9 := p_line_rec.PRICING_ATTRIBUTE9;
2135 x_rowtype_rec.PRICING_CONTEXT := p_line_rec.PRICING_CONTEXT;
2136 x_rowtype_rec.PRICING_DATE := p_line_rec.PRICING_DATE;
2137 x_rowtype_rec.PRICING_QUANTITY := p_line_rec.PRICING_QUANTITY;
2138 x_rowtype_rec.PRICING_QUANTITY_UOM := p_line_rec.PRICING_QUANTITY_UOM;
2139 x_rowtype_rec.PROGRAM_APPLICATION_ID := p_line_rec.PROGRAM_APPLICATION_ID;
2140 x_rowtype_rec.PROGRAM_ID := p_line_rec.PROGRAM_ID;
2141 x_rowtype_rec.PROGRAM_UPDATE_DATE := p_line_rec.PROGRAM_UPDATE_DATE;
2142 x_rowtype_rec.PROJECT_ID := p_line_rec.PROJECT_ID;
2143 x_rowtype_rec.PROMISE_DATE := p_line_rec.PROMISE_DATE;
2144 x_rowtype_rec.RE_SOURCE_FLAG := p_line_rec.RE_SOURCE_FLAG;
2145 x_rowtype_rec.REFERENCE_CUSTOMER_TRX_LINE_ID
2146 := p_line_rec.REFERENCE_CUSTOMER_TRX_LINE_ID;
2147 x_rowtype_rec.REFERENCE_HEADER_ID := p_line_rec.REFERENCE_HEADER_ID;
2148 x_rowtype_rec.REFERENCE_LINE_ID := p_line_rec.REFERENCE_LINE_ID;
2149 x_rowtype_rec.REFERENCE_TYPE := p_line_rec.REFERENCE_TYPE;
2150 x_rowtype_rec.REQUEST_DATE := p_line_rec.REQUEST_DATE;
2151 x_rowtype_rec.REQUEST_ID := p_line_rec.REQUEST_ID;
2152 x_rowtype_rec.RESERVED_QUANTITY := p_line_rec.RESERVED_QUANTITY;
2153 x_rowtype_rec.RETURN_ATTRIBUTE1 := p_line_rec.RETURN_ATTRIBUTE1;
2154 x_rowtype_rec.RETURN_ATTRIBUTE10 := p_line_rec.RETURN_ATTRIBUTE10;
2155 x_rowtype_rec.RETURN_ATTRIBUTE11 := p_line_rec.RETURN_ATTRIBUTE11;
2156 x_rowtype_rec.RETURN_ATTRIBUTE12 := p_line_rec.RETURN_ATTRIBUTE12;
2157 x_rowtype_rec.RETURN_ATTRIBUTE13 := p_line_rec.RETURN_ATTRIBUTE13;
2158 x_rowtype_rec.RETURN_ATTRIBUTE14 := p_line_rec.RETURN_ATTRIBUTE14;
2159 x_rowtype_rec.RETURN_ATTRIBUTE15 := p_line_rec.RETURN_ATTRIBUTE15;
2160 x_rowtype_rec.RETURN_ATTRIBUTE2 := p_line_rec.RETURN_ATTRIBUTE2;
2161 x_rowtype_rec.RETURN_ATTRIBUTE3 := p_line_rec.RETURN_ATTRIBUTE3;
2162 x_rowtype_rec.RETURN_ATTRIBUTE4 := p_line_rec.RETURN_ATTRIBUTE4;
2163 x_rowtype_rec.RETURN_ATTRIBUTE5 := p_line_rec.RETURN_ATTRIBUTE5;
2164 x_rowtype_rec.RETURN_ATTRIBUTE6 := p_line_rec.RETURN_ATTRIBUTE6;
2165 x_rowtype_rec.RETURN_ATTRIBUTE7 := p_line_rec.RETURN_ATTRIBUTE7;
2166 x_rowtype_rec.RETURN_ATTRIBUTE8 := p_line_rec.RETURN_ATTRIBUTE8;
2167 x_rowtype_rec.RETURN_ATTRIBUTE9 := p_line_rec.RETURN_ATTRIBUTE9;
2168 x_rowtype_rec.RETURN_CONTEXT := p_line_rec.RETURN_CONTEXT;
2169 x_rowtype_rec.RETURN_REASON_CODE := p_line_rec.RETURN_REASON_CODE;
2170 x_rowtype_rec.RLA_SCHEDULE_TYPE_CODE := p_line_rec.RLA_SCHEDULE_TYPE_CODE;
2171 x_rowtype_rec.SALESREP_ID := p_line_rec.SALESREP_ID;
2172 x_rowtype_rec.SCHEDULE_ACTION_CODE := p_line_rec.SCHEDULE_ACTION_CODE;
2173 x_rowtype_rec.SPLIT_ACTION_CODE := p_line_rec.SPLIT_ACTION_CODE;
2174 x_rowtype_rec.SCHEDULE_ARRIVAL_DATE := p_line_rec.SCHEDULE_ARRIVAL_DATE;
2175 x_rowtype_rec.SCHEDULE_SHIP_DATE := p_line_rec.SCHEDULE_SHIP_DATE;
2176 x_rowtype_rec.SCHEDULE_STATUS_CODE := p_line_rec.SCHEDULE_STATUS_CODE;
2177 x_rowtype_rec.SHIPMENT_NUMBER := p_line_rec.SHIPMENT_NUMBER;
2178 x_rowtype_rec.SHIPMENT_PRIORITY_CODE := p_line_rec.SHIPMENT_PRIORITY_CODE;
2179 x_rowtype_rec.SHIPPED_QUANTITY := p_line_rec.SHIPPED_QUANTITY;
2180 x_rowtype_rec.SHIPPED_QUANTITY2 := p_line_rec.SHIPPED_QUANTITY2;
2181 x_rowtype_rec.SHIPPING_INTERFACED_FLAG := p_line_rec.SHIPPING_INTERFACED_FLAG;
2182 x_rowtype_rec.SHIPPING_INSTRUCTIONS := p_line_rec.SHIPPING_INSTRUCTIONS;
2183 x_rowtype_rec.SHIPPING_METHOD_CODE := p_line_rec.SHIPPING_METHOD_CODE;
2184 x_rowtype_rec.SHIPPING_QUANTITY := p_line_rec.SHIPPING_QUANTITY;
2185 x_rowtype_rec.SHIPPING_QUANTITY2 := p_line_rec.SHIPPING_QUANTITY2;
2186 x_rowtype_rec.SHIPPING_QUANTITY_UOM := p_line_rec.SHIPPING_QUANTITY_UOM;
2187 x_rowtype_rec.SHIPPING_QUANTITY_UOM2 := p_line_rec.SHIPPING_QUANTITY_UOM2;
2188 x_rowtype_rec.SHIP_FROM_ORG_ID := p_line_rec.SHIP_FROM_ORG_ID;
2189 x_rowtype_rec.SUBINVENTORY := p_line_rec.SUBINVENTORY;
2190 x_rowtype_rec.SHIP_MODEL_COMPLETE_FLAG := p_line_rec.SHIP_MODEL_COMPLETE_FLAG;
2191 x_rowtype_rec.SHIP_SET := p_line_rec.SHIP_SET;
2192 x_rowtype_rec.SHIP_SET_ID := p_line_rec.SHIP_SET_ID;
2193 x_rowtype_rec.SHIP_TOLERANCE_ABOVE := p_line_rec.SHIP_TOLERANCE_ABOVE;
2194 x_rowtype_rec.SHIP_TOLERANCE_BELOW := p_line_rec.SHIP_TOLERANCE_BELOW;
2195 x_rowtype_rec.SHIP_TO_CONTACT_ID := p_line_rec.SHIP_TO_CONTACT_ID;
2196 x_rowtype_rec.SHIP_TO_ORG_ID := p_line_rec.SHIP_TO_ORG_ID;
2197 x_rowtype_rec.SOLD_FROM_ORG_ID := p_line_rec.SOLD_FROM_ORG_ID;
2198 x_rowtype_rec.SOLD_TO_ORG_ID := p_line_rec.SOLD_TO_ORG_ID;
2199 x_rowtype_rec.SORT_ORDER := p_line_rec.SORT_ORDER;
2200 x_rowtype_rec.SOURCE_DOCUMENT_ID := p_line_rec.SOURCE_DOCUMENT_ID;
2201 x_rowtype_rec.SOURCE_DOCUMENT_LINE_ID := p_line_rec.SOURCE_DOCUMENT_LINE_ID;
2202 x_rowtype_rec.SOURCE_DOCUMENT_TYPE_ID := p_line_rec.SOURCE_DOCUMENT_TYPE_ID;
2203 x_rowtype_rec.SOURCE_TYPE_CODE := p_line_rec.SOURCE_TYPE_CODE;
2204 x_rowtype_rec.SPLIT_FROM_LINE_ID := p_line_rec.SPLIT_FROM_LINE_ID;
2205 x_rowtype_rec.LINE_SET_ID := p_line_rec.LINE_SET_ID;
2206 x_rowtype_rec.SPLIT_BY := p_line_rec.SPLIT_BY;
2207 x_rowtype_rec.MODEL_REMNANT_FLAG := p_line_rec.MODEL_REMNANT_FLAG;
2208 x_rowtype_rec.TASK_ID := p_line_rec.TASK_ID;
2209 x_rowtype_rec.TAX_CODE := p_line_rec.TAX_CODE;
2210 x_rowtype_rec.TAX_DATE := p_line_rec.TAX_DATE;
2211 x_rowtype_rec.TAX_EXEMPT_FLAG := p_line_rec.TAX_EXEMPT_FLAG;
2212 x_rowtype_rec.TAX_EXEMPT_NUMBER := p_line_rec.TAX_EXEMPT_NUMBER;
2213 x_rowtype_rec.TAX_EXEMPT_REASON_CODE := p_line_rec.TAX_EXEMPT_REASON_CODE;
2214 x_rowtype_rec.TAX_POINT_CODE := p_line_rec.TAX_POINT_CODE;
2215 x_rowtype_rec.TAX_RATE := p_line_rec.TAX_RATE;
2216 x_rowtype_rec.TAX_VALUE := p_line_rec.TAX_VALUE;
2217 x_rowtype_rec.TOP_MODEL_LINE_ID := p_line_rec.TOP_MODEL_LINE_ID;
2218 x_rowtype_rec.UNIT_LIST_PRICE := p_line_rec.UNIT_LIST_PRICE;
2219 x_rowtype_rec.UNIT_SELLING_PRICE := p_line_rec.UNIT_SELLING_PRICE;
2220 x_rowtype_rec.UNIT_LIST_PRICE_PER_PQTY := p_line_rec.UNIT_LIST_PRICE_PER_PQTY;
2221 x_rowtype_rec.UNIT_SELLING_PRICE_PER_PQTY := p_line_rec.UNIT_SELLING_PRICE_PER_PQTY;
2222 x_rowtype_rec.VEH_CUS_ITEM_CUM_KEY_ID := p_line_rec.VEH_CUS_ITEM_CUM_KEY_ID;
2223 x_rowtype_rec.VISIBLE_DEMAND_FLAG := p_line_rec.VISIBLE_DEMAND_FLAG;
2224 x_rowtype_rec.OPERATION := p_line_rec.OPERATION;
2225 x_rowtype_rec.RETURN_STATUS := p_line_rec.RETURN_STATUS;
2226 x_rowtype_rec.DB_FLAG := p_line_rec.DB_FLAG;
2227 x_rowtype_rec.CHANGE_REASON := p_line_rec.CHANGE_REASON;
2228 x_rowtype_rec.CHANGE_COMMENTS := p_line_rec.CHANGE_COMMENTS;
2229 x_rowtype_rec.SHIPPABLE_FLAG := p_line_rec.SHIPPABLE_FLAG;
2230 x_rowtype_rec.SERVICE_TXN_REASON_CODE := p_line_rec.SERVICE_TXN_REASON_CODE;
2231 x_rowtype_rec.SERVICE_DURATION := p_line_rec.SERVICE_DURATION;
2232 x_rowtype_rec.SERVICE_PERIOD := p_line_rec.SERVICE_PERIOD;
2233 x_rowtype_rec.SERVICE_START_DATE := p_line_rec.SERVICE_START_DATE;
2234 x_rowtype_rec.SERVICE_END_DATE := p_line_rec.SERVICE_END_DATE;
2235 x_rowtype_rec.SERVICE_COTERMINATE_FLAG := p_line_rec.SERVICE_COTERMINATE_FLAG;
2236 x_rowtype_rec.SERVICE_TXN_COMMENTS := p_line_rec.SERVICE_TXN_COMMENTS;
2237 x_rowtype_rec.UNIT_SELLING_PERCENT := p_line_rec.UNIT_SELLING_PERCENT;
2238 x_rowtype_rec.UNIT_LIST_PERCENT := p_line_rec.UNIT_LIST_PERCENT;
2239 x_rowtype_rec.UNIT_PERCENT_BASE_PRICE := p_line_rec.UNIT_PERCENT_BASE_PRICE;
2240 x_rowtype_rec.SERVICE_NUMBER := p_line_rec.SERVICE_NUMBER;
2241 x_rowtype_rec.SERVICE_REFERENCE_TYPE_CODE := p_line_rec.SERVICE_REFERENCE_TYPE_CODE;
2242 x_rowtype_rec.SERVICE_REFERENCE_LINE_ID := p_line_rec.SERVICE_REFERENCE_LINE_ID;
2243 x_rowtype_rec.SERVICE_REFERENCE_SYSTEM_ID := p_line_rec.SERVICE_REFERENCE_SYSTEM_ID;
2244 x_rowtype_rec.FLOW_STATUS_CODE := p_line_rec.flow_status_code;
2245 x_rowtype_rec.TP_ATTRIBUTE1 := p_line_rec.TP_ATTRIBUTE1;
2246 x_rowtype_rec.TP_ATTRIBUTE10 := p_line_rec.TP_ATTRIBUTE10;
2247 x_rowtype_rec.TP_ATTRIBUTE11 := p_line_rec.TP_ATTRIBUTE11;
2248 x_rowtype_rec.TP_ATTRIBUTE12 := p_line_rec.TP_ATTRIBUTE12;
2249 x_rowtype_rec.TP_ATTRIBUTE13 := p_line_rec.TP_ATTRIBUTE13;
2250 x_rowtype_rec.TP_ATTRIBUTE14 := p_line_rec.TP_ATTRIBUTE14;
2251 x_rowtype_rec.TP_ATTRIBUTE15 := p_line_rec.TP_ATTRIBUTE15;
2252 x_rowtype_rec.TP_ATTRIBUTE2 := p_line_rec.TP_ATTRIBUTE2;
2253 x_rowtype_rec.TP_ATTRIBUTE3 := p_line_rec.TP_ATTRIBUTE3;
2254 x_rowtype_rec.TP_ATTRIBUTE4 := p_line_rec.TP_ATTRIBUTE4;
2255 x_rowtype_rec.TP_ATTRIBUTE5 := p_line_rec.TP_ATTRIBUTE5;
2256 x_rowtype_rec.TP_ATTRIBUTE6 := p_line_rec.TP_ATTRIBUTE6;
2257 x_rowtype_rec.TP_ATTRIBUTE7 := p_line_rec.TP_ATTRIBUTE7;
2258 x_rowtype_rec.TP_ATTRIBUTE8 := p_line_rec.TP_ATTRIBUTE8;
2259 x_rowtype_rec.TP_ATTRIBUTE9 := p_line_rec.TP_ATTRIBUTE9;
2260 x_rowtype_rec.TP_CONTEXT := p_line_rec.TP_CONTEXT;
2261 x_rowtype_rec.FIRST_ACK_CODE := p_line_rec.FIRST_ACK_CODE;
2262 x_rowtype_rec.FIRST_ACK_DATE := p_line_rec.FIRST_ACK_DATE;
2263 x_rowtype_rec.LAST_ACK_CODE := p_line_rec.LAST_ACK_CODE;
2264 x_rowtype_rec.LAST_ACK_DATE := p_line_rec.LAST_ACK_DATE;
2265 x_rowtype_rec.USER_ITEM_DESCRIPTION := p_line_rec.USER_ITEM_DESCRIPTION;
2266 -- QUOTING changes
2267 x_rowtype_rec.transaction_phase_code := p_line_rec.transaction_phase_code;
2268 x_rowtype_rec.source_document_version_number :=
2269 p_line_rec.source_document_version_number;
2270 x_rowtype_rec.IB_OWNER := p_line_rec.IB_OWNER;
2271 x_rowtype_rec.IB_INSTALLED_AT_LOCATION := p_line_rec.IB_INSTALLED_AT_LOCATION;
2272 x_rowtype_rec.IB_CURRENT_LOCATION := p_line_rec.IB_CURRENT_LOCATION;
2273 x_rowtype_rec.END_CUSTOMER_ID := p_line_rec.END_CUSTOMER_ID;
2274 x_rowtype_rec.END_CUSTOMER_CONTACT_ID := p_line_rec.END_CUSTOMER_CONTACT_ID;
2275 x_rowtype_rec.END_CUSTOMER_SITE_USE_ID := p_line_rec.END_CUSTOMER_SITE_USE_ID;
2276 --retro{
2277 x_rowtype_rec.retrobill_request_id:=p_line_rec.retrobill_request_id;
2278 --retro}
2279 --key Transaction Dates Project
2280 x_rowtype_rec.order_firmed_date := p_line_rec.order_firmed_date;
2281 x_rowtype_rec.actual_fulfillment_date := p_line_rec.actual_fulfillment_date;
2282 --Customer Acceptance
2283 x_rowtype_rec.CONTINGENCY_ID := p_line_rec.CONTINGENCY_ID;
2284 x_rowtype_rec.REVREC_EVENT_CODE := p_line_rec.REVREC_EVENT_CODE;
2285 x_rowtype_rec.REVREC_EXPIRATION_DAYS := p_line_rec.REVREC_EXPIRATION_DAYS;
2286 x_rowtype_rec.ACCEPTED_QUANTITY := p_line_rec.ACCEPTED_QUANTITY;
2287 x_rowtype_rec.REVREC_COMMENTS := p_line_rec.REVREC_COMMENTS;
2288 x_rowtype_rec.REVREC_SIGNATURE := p_line_rec.REVREC_SIGNATURE;
2289 x_rowtype_rec.REVREC_SIGNATURE_DATE := p_line_rec.REVREC_SIGNATURE_DATE;
2290 x_rowtype_rec.ACCEPTED_BY := p_line_rec.ACCEPTED_BY;
2291 x_rowtype_rec.REVREC_REFERENCE_DOCUMENT := p_line_rec.REVREC_REFERENCE_DOCUMENT;
2292 x_rowtype_rec.REVREC_IMPLICIT_FLAG := p_line_rec.REVREC_IMPLICIT_FLAG;
2293 x_rowtype_rec.charge_periodicity_code := p_line_rec.charge_periodicity_code; -- Rakesh
2294 --sol_ord_er #16014165
2295 x_rowtype_rec.SERVICE_COV_TEMPLATE_ID := p_line_rec.service_cov_template_id;
2296 x_rowtype_rec.SERVICE_BILL_PROFILE_ID := p_line_rec.service_bill_profile_id;
2297 x_rowtype_rec.service_subs_template_id :=p_line_rec.service_subs_template_id;
2298 x_rowtype_rec.service_bill_option_code :=p_line_rec.service_bill_option_code;
2299 x_rowtype_rec.subscription_enable_flag :=p_line_rec.subscription_enable_flag;
2300 --sol_ord_er #16014165 end
2301
2302
2303 EXCEPTION
2304 WHEN OTHERS THEN
2305 IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2306 THEN
2307 oe_msg_pub.Add_Exc_Msg
2308 ( G_PKG_NAME
2309 , 'API_Rec_To_RowType_Rec'
2310 );
2311 END IF;
2312 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2313 END API_Rec_To_RowType_Rec;
2314
2315
2316 PROCEDURE Rowtype_Rec_To_API_Rec
2317 ( p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
2318 , x_api_rec IN OUT NOCOPY OE_Order_PUB.LINE_Rec_Type
2319 ) IS
2320 BEGIN
2321
2322 x_api_rec.ACCOUNTING_RULE_ID := p_record.ACCOUNTING_RULE_ID;
2323 x_api_rec.ACCOUNTING_RULE_DURATION := p_record.ACCOUNTING_RULE_DURATION;
2324 x_api_rec.ACTUAL_ARRIVAL_DATE := p_record.ACTUAL_ARRIVAL_DATE;
2325 x_api_rec.ACTUAL_SHIPMENT_DATE := p_record.ACTUAL_SHIPMENT_DATE;
2326 x_api_rec.AGREEMENT_ID := p_record.AGREEMENT_ID;
2327 x_api_rec.ARRIVAL_SET := p_record.ARRIVAL_SET;
2328 x_api_rec.upgraded_flag := p_record.upgraded_flag;
2329 x_api_rec.ARRIVAL_SET_ID := p_record.ARRIVAL_SET_ID;
2330 x_api_rec.ATO_LINE_ID := p_record.ATO_LINE_ID;
2331 x_api_rec.ATTRIBUTE1 := p_record.ATTRIBUTE1;
2332 x_api_rec.ATTRIBUTE10 := p_record.ATTRIBUTE10;
2333 x_api_rec.ATTRIBUTE11 := p_record.ATTRIBUTE11;
2334 x_api_rec.ATTRIBUTE12 := p_record.ATTRIBUTE12;
2335 x_api_rec.ATTRIBUTE13 := p_record.ATTRIBUTE13;
2336 x_api_rec.ATTRIBUTE14 := p_record.ATTRIBUTE14;
2337 x_api_rec.ATTRIBUTE15 := p_record.ATTRIBUTE15;
2338 x_api_rec.ATTRIBUTE16 := p_record.ATTRIBUTE16; -- For bug 2184255
2339 x_api_rec.ATTRIBUTE17 := p_record.ATTRIBUTE17;
2340 x_api_rec.ATTRIBUTE18 := p_record.ATTRIBUTE18;
2341 x_api_rec.ATTRIBUTE19 := p_record.ATTRIBUTE19;
2342 x_api_rec.ATTRIBUTE2 := p_record.ATTRIBUTE2;
2343 x_api_rec.ATTRIBUTE20 := p_record.ATTRIBUTE20;
2344 x_api_rec.ATTRIBUTE3 := p_record.ATTRIBUTE3;
2345 x_api_rec.ATTRIBUTE4 := p_record.ATTRIBUTE4;
2346 x_api_rec.ATTRIBUTE5 := p_record.ATTRIBUTE5;
2347 x_api_rec.ATTRIBUTE6 := p_record.ATTRIBUTE6;
2348 x_api_rec.ATTRIBUTE7 := p_record.ATTRIBUTE7;
2349 x_api_rec.ATTRIBUTE8 := p_record.ATTRIBUTE8;
2350 x_api_rec.ATTRIBUTE9 := p_record.ATTRIBUTE9;
2351 x_api_rec.AUTHORIZED_TO_SHIP_FLAG := p_record.AUTHORIZED_TO_SHIP_FLAG;
2352 x_api_rec.AUTO_SELECTED_QUANTITY := p_record.AUTO_SELECTED_QUANTITY;
2353 x_api_rec.BOOKED_FLAG := p_record.BOOKED_FLAG;
2354 x_api_rec.BLANKET_NUMBER := p_record.BLANKET_NUMBER;
2355 x_api_rec.BLANKET_LINE_NUMBER := p_record.BLANKET_LINE_NUMBER;
2356 x_api_rec.BLANKET_VERSION_NUMBER := p_record.BLANKET_VERSION_NUMBER;
2357 x_api_rec.CALCULATE_PRICE_FLAG := p_record.CALCULATE_PRICE_FLAG;
2358 x_api_rec.COMMITMENT_ID := p_record.COMMITMENT_ID;
2359 x_api_rec.CANCELLED_FLAG := p_record.CANCELLED_FLAG;
2360 x_api_rec.CANCELLED_QUANTITY := p_record.CANCELLED_QUANTITY;
2361 x_api_rec.CANCELLED_QUANTITY2 := p_record.CANCELLED_QUANTITY2;
2362 x_api_rec.COMPONENT_CODE := p_record.COMPONENT_CODE;
2363 x_api_rec.COMPONENT_NUMBER := p_record.COMPONENT_NUMBER;
2364 x_api_rec.COMPONENT_SEQUENCE_ID := p_record.COMPONENT_SEQUENCE_ID;
2365 x_api_rec.CONFIGURATION_ID := p_record.CONFIGURATION_ID;
2366 x_api_rec.CONFIG_DISPLAY_SEQUENCE := p_record.CONFIG_DISPLAY_SEQUENCE;
2367 x_api_rec.CONFIG_HEADER_ID := p_record.CONFIG_HEADER_ID;
2368 x_api_rec.CONFIG_REV_NBR := p_record.CONFIG_REV_NBR;
2369 x_api_rec.CONTEXT := p_record.CONTEXT;
2370 x_api_rec.CREATED_BY := p_record.CREATED_BY;
2371 x_api_rec.CREATION_DATE := p_record.CREATION_DATE;
2372 x_api_rec.CREDIT_INVOICE_LINE_ID := p_record.CREDIT_INVOICE_LINE_ID;
2373 x_api_rec.CUSTOMER_DOCK_CODE := p_record.CUSTOMER_DOCK_CODE;
2374 x_api_rec.CUSTOMER_JOB := p_record.CUSTOMER_JOB;
2375 x_api_rec.CUSTOMER_PRODUCTION_LINE := p_record.CUSTOMER_PRODUCTION_LINE;
2376 x_api_rec.CUSTOMER_TRX_LINE_ID := p_record.CUSTOMER_TRX_LINE_ID;
2377 x_api_rec.CUST_MODEL_SERIAL_NUMBER := p_record.CUST_MODEL_SERIAL_NUMBER;
2378 x_api_rec.CUST_PO_NUMBER := p_record.CUST_PO_NUMBER;
2379 x_api_rec.CUSTOMER_LINE_NUMBER := p_record.CUSTOMER_LINE_NUMBER;
2380 --bug 11932310
2381 x_api_rec.CUSTOMER_SHIPMENT_NUMBER := p_record.CUSTOMER_SHIPMENT_NUMBER;
2382 x_api_rec.CUST_PRODUCTION_SEQ_NUM := p_record.CUST_PRODUCTION_SEQ_NUM;
2383 x_api_rec.DELIVERY_LEAD_TIME := p_record.DELIVERY_LEAD_TIME;
2384 x_api_rec.DELIVER_TO_CONTACT_ID := p_record.DELIVER_TO_CONTACT_ID;
2385 x_api_rec.DELIVER_TO_ORG_ID := p_record.DELIVER_TO_ORG_ID;
2386 x_api_rec.DEMAND_BUCKET_TYPE_CODE := p_record.DEMAND_BUCKET_TYPE_CODE;
2387 x_api_rec.DEMAND_CLASS_CODE := p_record.DEMAND_CLASS_CODE;
2388 x_api_rec.DEP_PLAN_REQUIRED_FLAG := p_record.DEP_PLAN_REQUIRED_FLAG;
2389 x_api_rec.EARLIEST_ACCEPTABLE_DATE := p_record.EARLIEST_ACCEPTABLE_DATE;
2390 x_api_rec.END_ITEM_UNIT_NUMBER := p_record.END_ITEM_UNIT_NUMBER;
2391 x_api_rec.EXPLOSION_DATE := p_record.EXPLOSION_DATE;
2392 x_api_rec.FOB_POINT_CODE := p_record.FOB_POINT_CODE;
2393 x_api_rec.FREIGHT_CARRIER_CODE := p_record.FREIGHT_CARRIER_CODE;
2394 x_api_rec.FREIGHT_TERMS_CODE := p_record.FREIGHT_TERMS_CODE;
2395 x_api_rec.FULFILLED_QUANTITY := p_record.FULFILLED_QUANTITY;
2396 x_api_rec.FULFILLED_QUANTITY2 := p_record.FULFILLED_QUANTITY2;
2397 x_api_rec.FULFILLED_FLAG := p_record.FULFILLED_FLAG;
2398 x_api_rec.FULFILLMENT_METHOD_CODE := p_record.FULFILLMENT_METHOD_CODE;
2399 x_api_rec.FULFILLMENT_DATE := p_record.FULFILLMENT_DATE;
2400 x_api_rec.GLOBAL_ATTRIBUTE1 := p_record.GLOBAL_ATTRIBUTE1;
2401 x_api_rec.GLOBAL_ATTRIBUTE10 := p_record.GLOBAL_ATTRIBUTE10;
2402 x_api_rec.GLOBAL_ATTRIBUTE11 := p_record.GLOBAL_ATTRIBUTE11;
2403 x_api_rec.GLOBAL_ATTRIBUTE12 := p_record.GLOBAL_ATTRIBUTE12;
2404 x_api_rec.GLOBAL_ATTRIBUTE13 := p_record.GLOBAL_ATTRIBUTE13;
2405 x_api_rec.GLOBAL_ATTRIBUTE14 := p_record.GLOBAL_ATTRIBUTE14;
2406 x_api_rec.GLOBAL_ATTRIBUTE15 := p_record.GLOBAL_ATTRIBUTE15;
2407 x_api_rec.GLOBAL_ATTRIBUTE16 := p_record.GLOBAL_ATTRIBUTE16;
2408 x_api_rec.GLOBAL_ATTRIBUTE17 := p_record.GLOBAL_ATTRIBUTE17;
2409 x_api_rec.GLOBAL_ATTRIBUTE18 := p_record.GLOBAL_ATTRIBUTE18;
2410 x_api_rec.GLOBAL_ATTRIBUTE19 := p_record.GLOBAL_ATTRIBUTE19;
2411 x_api_rec.GLOBAL_ATTRIBUTE2 := p_record.GLOBAL_ATTRIBUTE2;
2412 x_api_rec.GLOBAL_ATTRIBUTE20 := p_record.GLOBAL_ATTRIBUTE20;
2413 x_api_rec.GLOBAL_ATTRIBUTE3 := p_record.GLOBAL_ATTRIBUTE3;
2414 x_api_rec.GLOBAL_ATTRIBUTE4 := p_record.GLOBAL_ATTRIBUTE4;
2415 x_api_rec.GLOBAL_ATTRIBUTE5 := p_record.GLOBAL_ATTRIBUTE5;
2416 x_api_rec.GLOBAL_ATTRIBUTE6 := p_record.GLOBAL_ATTRIBUTE6;
2417 x_api_rec.GLOBAL_ATTRIBUTE7 := p_record.GLOBAL_ATTRIBUTE7;
2418 x_api_rec.GLOBAL_ATTRIBUTE8 := p_record.GLOBAL_ATTRIBUTE8;
2419 x_api_rec.GLOBAL_ATTRIBUTE9 := p_record.GLOBAL_ATTRIBUTE9;
2420 x_api_rec.GLOBAL_ATTRIBUTE_CATEGORY := p_record.GLOBAL_ATTRIBUTE_CATEGORY;
2421 x_api_rec.HEADER_ID := p_record.HEADER_ID;
2422 x_api_rec.INDUSTRY_ATTRIBUTE1 := p_record.INDUSTRY_ATTRIBUTE1;
2423 x_api_rec.INDUSTRY_ATTRIBUTE10 := p_record.INDUSTRY_ATTRIBUTE10;
2424 x_api_rec.INDUSTRY_ATTRIBUTE11 := p_record.INDUSTRY_ATTRIBUTE11;
2425 x_api_rec.INDUSTRY_ATTRIBUTE12 := p_record.INDUSTRY_ATTRIBUTE12;
2426 x_api_rec.INDUSTRY_ATTRIBUTE13 := p_record.INDUSTRY_ATTRIBUTE13;
2427 x_api_rec.INDUSTRY_ATTRIBUTE14 := p_record.INDUSTRY_ATTRIBUTE14;
2428 x_api_rec.INDUSTRY_ATTRIBUTE15 := p_record.INDUSTRY_ATTRIBUTE15;
2429 x_api_rec.INDUSTRY_ATTRIBUTE16 := p_record.INDUSTRY_ATTRIBUTE16;
2430 x_api_rec.INDUSTRY_ATTRIBUTE17 := p_record.INDUSTRY_ATTRIBUTE17;
2431 x_api_rec.INDUSTRY_ATTRIBUTE18 := p_record.INDUSTRY_ATTRIBUTE18;
2432 x_api_rec.INDUSTRY_ATTRIBUTE19 := p_record.INDUSTRY_ATTRIBUTE19;
2433 x_api_rec.INDUSTRY_ATTRIBUTE2 := p_record.INDUSTRY_ATTRIBUTE2;
2434 x_api_rec.INDUSTRY_ATTRIBUTE20 := p_record.INDUSTRY_ATTRIBUTE20;
2435 x_api_rec.INDUSTRY_ATTRIBUTE21 := p_record.INDUSTRY_ATTRIBUTE21;
2436 x_api_rec.INDUSTRY_ATTRIBUTE22 := p_record.INDUSTRY_ATTRIBUTE22;
2437 x_api_rec.INDUSTRY_ATTRIBUTE23 := p_record.INDUSTRY_ATTRIBUTE23;
2438 x_api_rec.INDUSTRY_ATTRIBUTE24 := p_record.INDUSTRY_ATTRIBUTE24;
2439 x_api_rec.INDUSTRY_ATTRIBUTE25 := p_record.INDUSTRY_ATTRIBUTE25;
2440 x_api_rec.INDUSTRY_ATTRIBUTE26 := p_record.INDUSTRY_ATTRIBUTE26;
2441 x_api_rec.INDUSTRY_ATTRIBUTE27 := p_record.INDUSTRY_ATTRIBUTE27;
2442 x_api_rec.INDUSTRY_ATTRIBUTE28 := p_record.INDUSTRY_ATTRIBUTE28;
2443 x_api_rec.INDUSTRY_ATTRIBUTE29 := p_record.INDUSTRY_ATTRIBUTE29;
2444 x_api_rec.INDUSTRY_ATTRIBUTE3 := p_record.INDUSTRY_ATTRIBUTE3;
2445 x_api_rec.INDUSTRY_ATTRIBUTE30 := p_record.INDUSTRY_ATTRIBUTE30;
2446 x_api_rec.INDUSTRY_ATTRIBUTE4 := p_record.INDUSTRY_ATTRIBUTE4;
2447 x_api_rec.INDUSTRY_ATTRIBUTE5 := p_record.INDUSTRY_ATTRIBUTE5;
2448 x_api_rec.INDUSTRY_ATTRIBUTE6 := p_record.INDUSTRY_ATTRIBUTE6;
2449 x_api_rec.INDUSTRY_ATTRIBUTE7 := p_record.INDUSTRY_ATTRIBUTE7;
2450 x_api_rec.INDUSTRY_ATTRIBUTE8 := p_record.INDUSTRY_ATTRIBUTE8;
2451 x_api_rec.INDUSTRY_ATTRIBUTE9 := p_record.INDUSTRY_ATTRIBUTE9;
2452 x_api_rec.INDUSTRY_CONTEXT := p_record.INDUSTRY_CONTEXT;
2453 x_api_rec.INTERMED_SHIP_TO_CONTACT_ID := p_record.INTERMED_SHIP_TO_CONTACT_ID;
2454 x_api_rec.INTERMED_SHIP_TO_ORG_ID := p_record.INTERMED_SHIP_TO_ORG_ID;
2455 x_api_rec.INVENTORY_ITEM_ID := p_record.INVENTORY_ITEM_ID;
2456 x_api_rec.INVOICE_INTERFACE_STATUS_CODE := p_record.INVOICE_INTERFACE_STATUS_CODE;
2457 x_api_rec.INVOICE_TO_CONTACT_ID := p_record.INVOICE_TO_CONTACT_ID;
2458 x_api_rec.INVOICE_TO_ORG_ID := p_record.INVOICE_TO_ORG_ID;
2459 x_api_rec.INVOICED_QUANTITY := p_record.INVOICED_QUANTITY;
2460 x_api_rec.INVOICING_RULE_ID := p_record.INVOICING_RULE_ID;
2461 x_api_rec.ORDERED_ITEM_ID := p_record.ORDERED_ITEM_ID;
2462 x_api_rec.ITEM_IDENTIFIER_TYPE := p_record.ITEM_IDENTIFIER_TYPE;
2463 x_api_rec.ORDERED_ITEM := p_record.ORDERED_ITEM;
2464 x_api_rec.ITEM_REVISION := p_record.ITEM_REVISION;
2465 x_api_rec.ITEM_TYPE_CODE := p_record.ITEM_TYPE_CODE;
2466 x_api_rec.LAST_UPDATED_BY := p_record.LAST_UPDATED_BY;
2467 x_api_rec.LAST_UPDATE_DATE := p_record.LAST_UPDATE_DATE;
2468 x_api_rec.LAST_UPDATE_LOGIN := p_record.LAST_UPDATE_LOGIN;
2469 x_api_rec.LATEST_ACCEPTABLE_DATE := p_record.LATEST_ACCEPTABLE_DATE;
2470 x_api_rec.LINE_CATEGORY_CODE := p_record.LINE_CATEGORY_CODE;
2471 x_api_rec.LINE_ID := p_record.LINE_ID;
2472 x_api_rec.LINE_NUMBER := p_record.LINE_NUMBER;
2473 x_api_rec.LINE_TYPE_ID := p_record.LINE_TYPE_ID;
2474 x_api_rec.LINK_TO_LINE_ID := p_record.LINK_TO_LINE_ID;
2475 x_api_rec.MFG_COMPONENT_SEQUENCE_ID := p_record.MFG_COMPONENT_SEQUENCE_ID;
2476 x_api_rec.MODEL_GROUP_NUMBER := p_record.MODEL_GROUP_NUMBER;
2477 x_api_rec.OPEN_FLAG := p_record.OPEN_FLAG;
2478 x_api_rec.OPTION_FLAG := p_record.OPTION_FLAG;
2479 x_api_rec.OPTION_NUMBER := p_record.OPTION_NUMBER;
2480 x_api_rec.ORDERED_QUANTITY := p_record.ORDERED_QUANTITY;
2481 x_api_rec.ORDERED_QUANTITY2 := p_record.ORDERED_QUANTITY2;
2482 x_api_rec.ORDER_QUANTITY_UOM := p_record.ORDER_QUANTITY_UOM;
2483 x_api_rec.ORDERED_QUANTITY_UOM2 := p_record.ORDERED_QUANTITY_UOM2;
2484 x_api_rec.ORG_ID := p_record.ORG_ID;
2485 x_api_rec.ORIG_SYS_DOCUMENT_REF := p_record.ORIG_SYS_DOCUMENT_REF;
2486 x_api_rec.ORIG_SYS_LINE_REF := p_record.ORIG_SYS_LINE_REF;
2487 x_api_rec.OVER_SHIP_REASON_CODE := p_record.OVER_SHIP_REASON_CODE;
2488 x_api_rec.OVER_SHIP_RESOLVED_FLAG := p_record.OVER_SHIP_RESOLVED_FLAG;
2489 x_api_rec.PACKING_INSTRUCTIONS := p_record.PACKING_INSTRUCTIONS;
2490 x_api_rec.PAYMENT_TERM_ID := p_record.PAYMENT_TERM_ID;
2491 x_api_rec.PLANNING_PRIORITY := p_record.PLANNING_PRIORITY;
2492 x_api_rec.PREFERRED_GRADE := p_record.PREFERRED_GRADE;
2493 x_api_rec.PRICE_LIST_ID := p_record.PRICE_LIST_ID;
2494 x_api_rec.PRICE_REQUEST_CODE := p_record.PRICE_REQUEST_CODE; -- PROMOTIONS SEP/01
2495 x_api_rec.PRICING_ATTRIBUTE1 := p_record.PRICING_ATTRIBUTE1;
2496 x_api_rec.PRICING_ATTRIBUTE10 := p_record.PRICING_ATTRIBUTE10;
2497 x_api_rec.PRICING_ATTRIBUTE2 := p_record.PRICING_ATTRIBUTE2;
2498 x_api_rec.PRICING_ATTRIBUTE3 := p_record.PRICING_ATTRIBUTE3;
2499 x_api_rec.PRICING_ATTRIBUTE4 := p_record.PRICING_ATTRIBUTE4;
2500 x_api_rec.PRICING_ATTRIBUTE5 := p_record.PRICING_ATTRIBUTE5;
2501 x_api_rec.PRICING_ATTRIBUTE6 := p_record.PRICING_ATTRIBUTE6;
2502 x_api_rec.PRICING_ATTRIBUTE7 := p_record.PRICING_ATTRIBUTE7;
2503 x_api_rec.PRICING_ATTRIBUTE8 := p_record.PRICING_ATTRIBUTE8;
2504 x_api_rec.PRICING_ATTRIBUTE9 := p_record.PRICING_ATTRIBUTE9;
2505 x_api_rec.PRICING_CONTEXT := p_record.PRICING_CONTEXT;
2506 x_api_rec.PRICING_DATE := p_record.PRICING_DATE;
2507 x_api_rec.PRICING_QUANTITY := p_record.PRICING_QUANTITY;
2508 x_api_rec.PRICING_QUANTITY_UOM := p_record.PRICING_QUANTITY_UOM;
2509 x_api_rec.PROGRAM_APPLICATION_ID := p_record.PROGRAM_APPLICATION_ID;
2510 x_api_rec.PROGRAM_ID := p_record.PROGRAM_ID;
2511 x_api_rec.PROGRAM_UPDATE_DATE := p_record.PROGRAM_UPDATE_DATE;
2512 x_api_rec.PROJECT_ID := p_record.PROJECT_ID;
2513 x_api_rec.PROMISE_DATE := p_record.PROMISE_DATE;
2514 x_api_rec.RE_SOURCE_FLAG := p_record.RE_SOURCE_FLAG;
2515 x_api_rec.REFERENCE_CUSTOMER_TRX_LINE_ID
2516 := p_record.REFERENCE_CUSTOMER_TRX_LINE_ID;
2517 x_api_rec.REFERENCE_HEADER_ID := p_record.REFERENCE_HEADER_ID;
2518 x_api_rec.REFERENCE_LINE_ID := p_record.REFERENCE_LINE_ID;
2519 x_api_rec.REFERENCE_TYPE := p_record.REFERENCE_TYPE;
2520 x_api_rec.REQUEST_DATE := p_record.REQUEST_DATE;
2521 x_api_rec.REQUEST_ID := p_record.REQUEST_ID;
2522 -- Commenting this to fix bug 1391988.
2523 -- x_api_rec.RESERVED_QUANTITY := p_record.RESERVED_QUANTITY;
2524 x_api_rec.RETURN_ATTRIBUTE1 := p_record.RETURN_ATTRIBUTE1;
2525 x_api_rec.RETURN_ATTRIBUTE10 := p_record.RETURN_ATTRIBUTE10;
2526 x_api_rec.RETURN_ATTRIBUTE11 := p_record.RETURN_ATTRIBUTE11;
2527 x_api_rec.RETURN_ATTRIBUTE12 := p_record.RETURN_ATTRIBUTE12;
2528 x_api_rec.RETURN_ATTRIBUTE13 := p_record.RETURN_ATTRIBUTE13;
2529 x_api_rec.RETURN_ATTRIBUTE14 := p_record.RETURN_ATTRIBUTE14;
2530 x_api_rec.RETURN_ATTRIBUTE15 := p_record.RETURN_ATTRIBUTE15;
2531 x_api_rec.RETURN_ATTRIBUTE2 := p_record.RETURN_ATTRIBUTE2;
2532 x_api_rec.RETURN_ATTRIBUTE3 := p_record.RETURN_ATTRIBUTE3;
2533 x_api_rec.RETURN_ATTRIBUTE4 := p_record.RETURN_ATTRIBUTE4;
2534 x_api_rec.RETURN_ATTRIBUTE5 := p_record.RETURN_ATTRIBUTE5;
2535 x_api_rec.RETURN_ATTRIBUTE6 := p_record.RETURN_ATTRIBUTE6;
2536 x_api_rec.RETURN_ATTRIBUTE7 := p_record.RETURN_ATTRIBUTE7;
2537 x_api_rec.RETURN_ATTRIBUTE8 := p_record.RETURN_ATTRIBUTE8;
2538 x_api_rec.RETURN_ATTRIBUTE9 := p_record.RETURN_ATTRIBUTE9;
2539 x_api_rec.RETURN_CONTEXT := p_record.RETURN_CONTEXT;
2540 x_api_rec.RETURN_REASON_CODE := p_record.RETURN_REASON_CODE;
2541 x_api_rec.RLA_SCHEDULE_TYPE_CODE := p_record.RLA_SCHEDULE_TYPE_CODE;
2542 x_api_rec.SALESREP_ID := p_record.SALESREP_ID;
2543 x_api_rec.SCHEDULE_ACTION_CODE := p_record.SCHEDULE_ACTION_CODE;
2544 x_api_rec.SPLIT_ACTION_CODE := p_record.SPLIT_ACTION_CODE;
2545 x_api_rec.SCHEDULE_ARRIVAL_DATE := p_record.SCHEDULE_ARRIVAL_DATE;
2546 x_api_rec.SCHEDULE_SHIP_DATE := p_record.SCHEDULE_SHIP_DATE;
2547 x_api_rec.SCHEDULE_STATUS_CODE := p_record.SCHEDULE_STATUS_CODE;
2548 x_api_rec.SHIPMENT_NUMBER := p_record.SHIPMENT_NUMBER;
2549 x_api_rec.SHIPMENT_PRIORITY_CODE := p_record.SHIPMENT_PRIORITY_CODE;
2550 x_api_rec.SHIPPED_QUANTITY := p_record.SHIPPED_QUANTITY;
2551 x_api_rec.SHIPPED_QUANTITY2 := p_record.SHIPPED_QUANTITY2;
2552 x_api_rec.SHIPPING_INTERFACED_FLAG := p_record.SHIPPING_INTERFACED_FLAG;
2553 x_api_rec.SHIPPING_INSTRUCTIONS := p_record.SHIPPING_INSTRUCTIONS;
2554 x_api_rec.SHIPPING_METHOD_CODE := p_record.SHIPPING_METHOD_CODE;
2555 x_api_rec.SHIPPING_QUANTITY := p_record.SHIPPING_QUANTITY;
2556 x_api_rec.SHIPPING_QUANTITY2 := p_record.SHIPPING_QUANTITY2;
2557 x_api_rec.SHIPPING_QUANTITY_UOM := p_record.SHIPPING_QUANTITY_UOM;
2558 x_api_rec.SHIPPING_QUANTITY_UOM2 := p_record.SHIPPING_QUANTITY_UOM2;
2559 x_api_rec.SHIP_FROM_ORG_ID := p_record.SHIP_FROM_ORG_ID;
2560 x_api_rec.SUBINVENTORY := p_record.SUBINVENTORY;
2561 x_api_rec.SHIP_MODEL_COMPLETE_FLAG := p_record.SHIP_MODEL_COMPLETE_FLAG;
2562 x_api_rec.SHIP_SET := p_record.SHIP_SET;
2563 x_api_rec.SHIP_SET_ID := p_record.SHIP_SET_ID;
2564 x_api_rec.SHIP_TOLERANCE_ABOVE := p_record.SHIP_TOLERANCE_ABOVE;
2565 x_api_rec.SHIP_TOLERANCE_BELOW := p_record.SHIP_TOLERANCE_BELOW;
2566 x_api_rec.SHIP_TO_CONTACT_ID := p_record.SHIP_TO_CONTACT_ID;
2567 x_api_rec.SHIP_TO_ORG_ID := p_record.SHIP_TO_ORG_ID;
2568 x_api_rec.SOLD_FROM_ORG_ID := p_record.SOLD_FROM_ORG_ID;
2569 x_api_rec.SOLD_TO_ORG_ID := p_record.SOLD_TO_ORG_ID;
2570 x_api_rec.SORT_ORDER := p_record.SORT_ORDER;
2571 x_api_rec.SOURCE_DOCUMENT_ID := p_record.SOURCE_DOCUMENT_ID;
2572 x_api_rec.SOURCE_DOCUMENT_LINE_ID := p_record.SOURCE_DOCUMENT_LINE_ID;
2573 x_api_rec.SOURCE_DOCUMENT_TYPE_ID := p_record.SOURCE_DOCUMENT_TYPE_ID;
2574 x_api_rec.SOURCE_TYPE_CODE := p_record.SOURCE_TYPE_CODE;
2575 x_api_rec.SPLIT_FROM_LINE_ID := p_record.SPLIT_FROM_LINE_ID;
2576 x_api_rec.LINE_SET_ID := p_record.LINE_SET_ID;
2577 x_api_rec.SPLIT_BY := p_record.SPLIT_BY;
2578 x_api_rec.Model_remnant_flag := p_record.Model_Remnant_Flag;
2579 x_api_rec.TASK_ID := p_record.TASK_ID;
2580 x_api_rec.TAX_CODE := p_record.TAX_CODE;
2581 x_api_rec.TAX_DATE := p_record.TAX_DATE;
2582 x_api_rec.TAX_EXEMPT_FLAG := p_record.TAX_EXEMPT_FLAG;
2583 x_api_rec.TAX_EXEMPT_NUMBER := p_record.TAX_EXEMPT_NUMBER;
2584 x_api_rec.TAX_EXEMPT_REASON_CODE := p_record.TAX_EXEMPT_REASON_CODE;
2585 x_api_rec.TAX_POINT_CODE := p_record.TAX_POINT_CODE;
2586 x_api_rec.TAX_RATE := p_record.TAX_RATE;
2587 x_api_rec.TAX_VALUE := p_record.TAX_VALUE;
2588 x_api_rec.TOP_MODEL_LINE_ID := p_record.TOP_MODEL_LINE_ID;
2589 x_api_rec.UNIT_LIST_PRICE := p_record.UNIT_LIST_PRICE;
2590 x_api_rec.UNIT_SELLING_PRICE := p_record.UNIT_SELLING_PRICE;
2591 x_api_rec.UNIT_LIST_PRICE_PER_PQTY := p_record.UNIT_LIST_PRICE_PER_PQTY;
2592 x_api_rec.UNIT_SELLING_PRICE_PER_PQTY := p_record.UNIT_SELLING_PRICE_PER_PQTY;
2593 x_api_rec.VEH_CUS_ITEM_CUM_KEY_ID := p_record.VEH_CUS_ITEM_CUM_KEY_ID;
2594 x_api_rec.VISIBLE_DEMAND_FLAG := p_record.VISIBLE_DEMAND_FLAG;
2595 x_api_rec.OPERATION := p_record.OPERATION;
2596 x_api_rec.RETURN_STATUS := p_record.RETURN_STATUS;
2597 x_api_rec.DB_FLAG := p_record.DB_FLAG;
2598 x_api_rec.CHANGE_REASON := p_record.CHANGE_REASON;
2599 x_api_rec.CHANGE_COMMENTS := p_record.CHANGE_COMMENTS;
2600 x_api_rec.SHIPPABLE_FLAG := p_record.SHIPPABLE_FLAG;
2601 x_api_rec.SERVICE_TXN_REASON_CODE := p_record.SERVICE_TXN_REASON_CODE;
2602 x_api_rec.SERVICE_DURATION := p_record.SERVICE_DURATION;
2603 x_api_rec.SERVICE_PERIOD := p_record.SERVICE_PERIOD;
2604 x_api_rec.SERVICE_START_DATE := p_record.SERVICE_START_DATE;
2605 x_api_rec.SERVICE_END_DATE := p_record.SERVICE_END_DATE;
2606 x_api_rec.SERVICE_COTERMINATE_FLAG := p_record.SERVICE_COTERMINATE_FLAG;
2607 x_api_rec.SERVICE_TXN_COMMENTS := p_record.SERVICE_TXN_COMMENTS;
2608 x_api_rec.UNIT_SELLING_PERCENT := p_record.UNIT_SELLING_PERCENT;
2609 x_api_rec.UNIT_LIST_PERCENT := p_record.UNIT_LIST_PERCENT;
2610 x_api_rec.UNIT_PERCENT_BASE_PRICE := p_record.UNIT_PERCENT_BASE_PRICE;
2611 x_api_rec.SERVICE_NUMBER := p_record.SERVICE_NUMBER;
2612 x_api_rec.SERVICE_REFERENCE_TYPE_CODE := p_record.SERVICE_REFERENCE_TYPE_CODE;
2613 x_api_rec.SERVICE_REFERENCE_LINE_ID := p_record.SERVICE_REFERENCE_LINE_ID;
2614 x_api_rec.SERVICE_REFERENCE_SYSTEM_ID := p_record.SERVICE_REFERENCE_SYSTEM_ID;
2615 x_api_rec.FLOW_STATUS_CODE := p_record.FLOW_STATUS_CODE;
2616 x_api_rec.TP_ATTRIBUTE1 := p_record.TP_ATTRIBUTE1;
2617 x_api_rec.TP_ATTRIBUTE10 := p_record.TP_ATTRIBUTE10;
2618 x_api_rec.TP_ATTRIBUTE11 := p_record.TP_ATTRIBUTE11;
2619 x_api_rec.TP_ATTRIBUTE12 := p_record.TP_ATTRIBUTE12;
2620 x_api_rec.TP_ATTRIBUTE13 := p_record.TP_ATTRIBUTE13;
2621 x_api_rec.TP_ATTRIBUTE14 := p_record.TP_ATTRIBUTE14;
2622 x_api_rec.TP_ATTRIBUTE15 := p_record.TP_ATTRIBUTE15;
2623 x_api_rec.TP_ATTRIBUTE2 := p_record.TP_ATTRIBUTE2;
2624 x_api_rec.TP_ATTRIBUTE3 := p_record.TP_ATTRIBUTE3;
2625 x_api_rec.TP_ATTRIBUTE4 := p_record.TP_ATTRIBUTE4;
2626 x_api_rec.TP_ATTRIBUTE5 := p_record.TP_ATTRIBUTE5;
2627 x_api_rec.TP_ATTRIBUTE6 := p_record.TP_ATTRIBUTE6;
2628 x_api_rec.TP_ATTRIBUTE7 := p_record.TP_ATTRIBUTE7;
2629 x_api_rec.TP_ATTRIBUTE8 := p_record.TP_ATTRIBUTE8;
2630 x_api_rec.TP_ATTRIBUTE9 := p_record.TP_ATTRIBUTE9;
2631 x_api_rec.TP_CONTEXT := p_record.TP_CONTEXT;
2632 x_api_rec.FIRST_ACK_CODE := p_record.FIRST_ACK_CODE;
2633 x_api_rec.FIRST_ACK_DATE := p_record.FIRST_ACK_DATE;
2634 x_api_rec.LAST_ACK_CODE := p_record.LAST_ACK_CODE;
2635 x_api_rec.LAST_ACK_DATE := p_record.LAST_ACK_DATE;
2636 x_api_rec.USER_ITEM_DESCRIPTION := p_record.USER_ITEM_DESCRIPTION;
2637 -- QUOTING changes
2638 x_api_rec.transaction_phase_code := p_record.transaction_phase_code;
2639 x_api_rec.source_document_version_number :=
2640 p_record.source_document_version_number;
2641 x_api_rec.IB_OWNER := p_record.IB_OWNER;
2642 x_api_rec.IB_INSTALLED_AT_LOCATION := p_record.IB_INSTALLED_AT_LOCATION;
2643 x_api_rec.IB_CURRENT_LOCATION := p_record.IB_CURRENT_LOCATION;
2644 x_api_rec.END_CUSTOMER_ID := p_record.END_CUSTOMER_ID;
2645 x_api_rec.END_CUSTOMER_CONTACT_ID := p_record.END_CUSTOMER_CONTACT_ID;
2646 x_api_rec.END_CUSTOMER_SITE_USE_ID := p_record.END_CUSTOMER_SITE_USE_ID;
2647
2648 --retro{
2649 x_api_rec.retrobill_request_id := p_record.retrobill_request_id;
2650 --retro}
2651 --key Transaction dates Project
2652 x_api_rec.order_firmed_date := p_record.order_firmed_date;
2653 x_api_rec.actual_fulfillment_date := p_record.actual_fulfillment_date;
2654 --Customer Acceptance
2655 x_api_rec.CONTINGENCY_ID := p_record.CONTINGENCY_ID;
2656 x_api_rec.REVREC_EVENT_CODE := p_record.REVREC_EVENT_CODE;
2657 x_api_rec.REVREC_EXPIRATION_DAYS := p_record.REVREC_EXPIRATION_DAYS;
2658 x_api_rec.ACCEPTED_QUANTITY := p_record.ACCEPTED_QUANTITY;
2659 x_api_rec.REVREC_COMMENTS := p_record.REVREC_COMMENTS;
2660 x_api_rec.REVREC_SIGNATURE := p_record.REVREC_SIGNATURE;
2661 x_api_rec.REVREC_SIGNATURE_DATE := p_record.REVREC_SIGNATURE_DATE;
2662 x_api_rec.ACCEPTED_BY := p_record.ACCEPTED_BY;
2663 x_api_rec.REVREC_REFERENCE_DOCUMENT := p_record.REVREC_REFERENCE_DOCUMENT;
2664 x_api_rec.REVREC_IMPLICIT_FLAG := p_record.REVREC_IMPLICIT_FLAG;
2665 x_api_rec.charge_periodicity_code := p_record.charge_periodicity_code; --Rakesh
2666 --sol_ord_er #16014165
2667 x_api_rec.SERVICE_COV_TEMPLATE_ID := p_record.SERVICE_COV_TEMPLATE_ID;
2668 x_api_rec.service_bill_profile_id := p_record.SERVICE_BILL_PROFILE_ID;
2669 x_api_rec.service_subs_template_id :=p_record. service_subs_template_id;
2670 x_api_rec.service_bill_option_code :=p_record.service_bill_option_code;
2671 x_api_rec.subscription_enable_flag :=p_record.subscription_enable_flag;
2672 --sol_ord_er #16014165
2673
2674 EXCEPTION
2675 WHEN OTHERS THEN
2676 IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2677 THEN
2678 oe_msg_pub.Add_Exc_Msg
2679 ( G_PKG_NAME
2680 , 'Rowtype_Rec_To_API_Rec'
2681 );
2682 END IF;
2683 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2684 END Rowtype_Rec_To_API_Rec;
2685
2686 -- PROCEDURE Clear_Dependent_Attr
2687 -- This version of the clear dependent attributes procedure is called
2688 -- from the generated entity defaulting handler packages to clear
2689 -- the dependents if the new defaulted value is different from the
2690 -- old value on the record. The record types here of view%rowtype
2691 -- as the defaulting packages operate only on these record types.
2692 -- Arguments:
2693 -- p_attr_id: if passed, then clear attributes dependent only on
2694 -- this attribute else compare p_old_line_rec and p_line_rec
2695 -- and clear attributes dependent on all the change attributes
2696 -- p_initial_line_rec: this is the initial record passed to the process
2697 -- order or the defaulting APIs and is used to identify which
2698 -- attributes are user-specified so that they are not cleared
2699 -- p_old_line_rec: the old record as it was before the changes
2700 -- p_x_line_rec: the current record with the user-specified changes and
2701 -- attributes that may have defaulted prior to this call
2702 PROCEDURE Clear_Dependent_Attr
2703 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
2704 , p_initial_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
2705 , p_old_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
2706 , p_x_line_rec IN OUT NOCOPY OE_AK_ORDER_LINES_V%ROWTYPE
2707 )
2708 IS
2709 l_index NUMBER :=0;
2710 l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
2711 l_dep_attr_exists VARCHAR2(1);
2712 BEGIN
2713
2714 oe_debug_pub.add('Entering OE_LINE_UTIL.CLEAR_DEPENDENT_ATTR', 1);
2715 oe_debug_pub.add('Attr Id: '||p_attr_id);
2716
2717
2718 IF p_attr_id <> FND_API.G_MISS_NUM THEN
2719
2720 l_index := l_index + 1.0;
2721 l_src_attr_tbl(l_index) := p_attr_id;
2722
2723 -- If attr_id is missing compare old and new records and for
2724 -- every changed attribute clear its dependent fields.
2725
2726 ELSE
2727
2728 IF NOT OE_GLOBALS.Equal(p_x_line_rec.ACCOUNTING_RULE_ID,p_old_line_rec.ACCOUNTING_RULE_ID)
2729 THEN
2730 l_index := l_index + 1.0;
2731 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ACCOUNTING_RULE;
2732 END IF;
2733
2734 IF NOT OE_GLOBALS.Equal(p_x_line_rec.AGREEMENT_ID,p_old_line_rec.AGREEMENT_ID)
2735 THEN
2736 l_index := l_index + 1.0;
2737 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_AGREEMENT;
2738 END IF;
2739
2740 IF NOT OE_GLOBALS.Equal(p_x_line_rec.blanket_number,p_old_line_rec.blanket_number)
2741 THEN
2742 l_index := l_index + 1.0;
2743 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_BLANKET_NUMBER;
2744 END IF;
2745
2746 IF NOT OE_GLOBALS.Equal(p_x_line_rec.blanket_line_number,p_old_line_rec.blanket_line_number)
2747 THEN
2748 l_index := l_index + 1.0;
2749 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_BLANKET_LINE_NUMBER;
2750 END IF;
2751
2752 --bug5160469
2753 IF NOT OE_GLOBALS.Equal(p_x_line_rec.commitment_id,p_old_line_rec.commitment_id)
2754 THEN
2755 l_index := l_index + 1.0;
2756 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_COMMITMENT;
2757 END IF;
2758
2759 IF NOT OE_GLOBALS.Equal(p_x_line_rec.DELIVER_TO_ORG_ID,p_old_line_rec.DELIVER_TO_ORG_ID)
2760 THEN
2761 l_index := l_index + 1.0;
2762 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_DELIVER_TO_ORG;
2763 END IF;
2764
2765 IF NOT OE_GLOBALS.Equal(p_x_line_rec.INTERMED_SHIP_TO_ORG_ID,p_old_line_rec.INTERMED_SHIP_TO_ORG_ID)
2766 THEN
2767 l_index := l_index + 1.0;
2768 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INTERMED_SHIP_TO_ORG;
2769 END IF;
2770
2771
2772
2773 IF NOT OE_GLOBALS.Equal(p_x_line_rec.INVENTORY_ITEM_ID,p_old_line_rec.INVENTORY_ITEM_ID)
2774 THEN
2775 l_index := l_index + 1.0;
2776 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INVENTORY_ITEM;
2777 END IF;
2778 --sol_ord_er #16014165
2779 IF NOT OE_GLOBALS.Equal(p_x_line_rec.subscription_enable_flag,p_old_line_rec.subscription_enable_flag)
2780 THEN
2781 l_index := l_index + 1.0;
2782 l_src_attr_tbl(l_index) := OE_LINE_UTIL.g_subscription_enable_flag;
2783 END IF;
2784 --sol_ord_er #16014165 end
2785
2786 IF NOT OE_GLOBALS.Equal(p_x_line_rec.INVOICE_TO_ORG_ID,p_old_line_rec.INVOICE_TO_ORG_ID)
2787 THEN
2788 l_index := l_index + 1.0;
2789 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INVOICE_TO_ORG;
2790 END IF;
2791
2792 IF NOT OE_GLOBALS.Equal(p_x_line_rec.LINE_NUMBER,p_old_line_rec.LINE_NUMBER)
2793 THEN
2794 l_index := l_index + 1.0;
2795 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_LINE_NUMBER;
2796 END IF;
2797
2798 IF NOT OE_GLOBALS.Equal(p_x_line_rec.LINE_TYPE_ID,p_old_line_rec.LINE_TYPE_ID)
2799 THEN
2800 l_index := l_index + 1.0;
2801 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_LINE_TYPE;
2802 END IF;
2803
2804 IF NOT OE_GLOBALS.Equal(p_x_line_rec.PRICE_LIST_ID,p_old_line_rec.PRICE_LIST_ID)
2805 THEN
2806 l_index := l_index + 1.0;
2807 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PRICE_LIST;
2808 END IF;
2809
2810 IF NOT OE_GLOBALS.Equal(p_x_line_rec.PROMISE_DATE,p_old_line_rec.PROMISE_DATE)
2811 THEN
2812 l_index := l_index + 1.0;
2813 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PROMISE_DATE;
2814 END IF;
2815
2816 IF NOT OE_GLOBALS.Equal(p_x_line_rec.REQUEST_DATE,p_old_line_rec.REQUEST_DATE)
2817 THEN
2818 l_index := l_index + 1.0;
2819 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_REQUEST_DATE;
2820 END IF;
2821
2822 IF NOT OE_GLOBALS.Equal(p_x_line_rec.SCHEDULE_SHIP_DATE,p_old_line_rec.SCHEDULE_SHIP_DATE)
2823 THEN
2824 l_index := l_index + 1.0;
2825 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE;
2826 END IF;
2827
2828 IF NOT OE_GLOBALS.Equal(p_x_line_rec.SHIP_FROM_ORG_ID,p_old_line_rec.SHIP_FROM_ORG_ID)
2829 THEN
2830 l_index := l_index + 1.0;
2831 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SHIP_FROM_ORG;
2832 END IF;
2833
2834 IF NOT OE_GLOBALS.Equal(p_x_line_rec.SUBINVENTORY,p_old_line_rec.SUBINVENTORY)
2835 THEN
2836 l_index := l_index + 1.0;
2837 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SUBINVENTORY;
2838 END IF;
2839
2840 IF NOT OE_GLOBALS.Equal(p_x_line_rec.SHIP_TO_ORG_ID,p_old_line_rec.SHIP_TO_ORG_ID)
2841 THEN
2842 l_index := l_index + 1.0;
2843 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SHIP_TO_ORG;
2844 END IF;
2845
2846 IF NOT OE_GLOBALS.Equal(p_x_line_rec.SOLD_TO_ORG_ID,p_old_line_rec.SOLD_TO_ORG_ID)
2847 THEN
2848 l_index := l_index + 1.0;
2849 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SOLD_TO_ORG;
2850 END IF;
2851
2852 IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_CODE,p_old_line_rec.TAX_CODE)
2853 THEN
2854 l_index := l_index + 1.0;
2855 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX;
2856 END IF;
2857
2858 IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_DATE,p_old_line_rec.TAX_DATE)
2859 THEN
2860 l_index := l_index + 1.0;
2861 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX_DATE;
2862 END IF;
2863
2864 IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_EXEMPT_FLAG,p_old_line_rec.TAX_EXEMPT_FLAG)
2865 THEN
2866 l_index := l_index + 1.0;
2867 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX_EXEMPT;
2868 END IF;
2869 --Added following condition for Bug 2245073
2870 IF NOT OE_GLOBALS.Equal(p_x_line_rec.PRICING_DATE, p_old_line_rec.PRICING_DATE
2871 ) Then
2872 l_index := l_index + 1.0;
2873 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PRICING_DATE;
2874 End If;
2875
2876 -- The next two IF statements added for bug 5076119
2877 IF NOT OE_GLOBALS.Equal(p_x_line_rec.ORDERED_QUANTITY, p_old_line_rec.ORDERED_QUANTITY)
2878 THEN
2879 l_index := l_index + 1.0;
2880 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ORDERED_QUANTITY;
2881 END IF;
2882
2883 IF NOT OE_GLOBALS.Equal(p_x_line_rec.ORDER_QUANTITY_UOM, p_old_line_rec.ORDER_QUANTITY_UOM)
2884 THEN
2885 l_index := l_index + 1.0;
2886 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ORDER_QUANTITY_UOM;
2887 END IF;
2888
2889 --bug 13088960
2890 IF NOT OE_GLOBALS.Equal(p_x_line_rec.shipping_method_code, p_old_line_rec.shipping_method_code)
2891 THEN
2892 l_index := l_index + 1.0;
2893 l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SHIPPING_METHOD ;
2894 END IF;
2895 ---end 13088960
2896
2897 END IF;
2898
2899 Clear_Dependents
2900 (p_src_attr_tbl => l_src_attr_tbl
2901 ,p_initial_line_rec => p_initial_line_rec
2902 ,p_old_line_rec => p_old_line_rec
2903 ,p_x_line_rec => p_x_line_rec
2904 ,x_dep_attr_exists => l_dep_attr_exists);
2905
2906 oe_debug_pub.add('Exiting OE_LINE_UTIL.CLEAR_DEPENDENT_ATTR', 1);
2907
2908 EXCEPTION
2909 WHEN FND_API.G_EXC_ERROR THEN
2910 RAISE FND_API.G_EXC_ERROR;
2911 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2912 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2913 WHEN OTHERS THEN
2914 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2915 THEN
2916 OE_MSG_PUB.Add_Exc_Msg
2917 ( G_PKG_NAME
2918 , 'Clear_Dependent_Attr'
2919 );
2920 END IF;
2921 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2922 END Clear_Dependent_Attr;
2923
2924 -- PROCEDURE Clear_Dependent_Attr
2925 -- This version of the clear dependent attributes procedure is called
2926 -- from the private process order API (OE_Order_PVT) to clear the
2927 -- dependents if control_rec.clear_dependents is TRUE. The record
2928 -- types are of the type OE_Order_PUB.<Entity>_rec_Type
2929 -- Arguments:
2930 -- p_attr_id: if passed, then clear attributes dependent only on
2931 -- this attribute else compare p_old_line_rec and p_x_line_rec
2932 -- and clear attributes dependent on all the change attributes
2933 -- p_old_line_rec: the old record as it was before the changes
2934 -- p_x_line_rec: the current record with the user-specified changes
2935 PROCEDURE Clear_Dependent_Attr
2936 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
2937 , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
2938 , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
2939 OE_Order_PUB.G_MISS_LINE_REC
2940 )
2941 IS
2942 l_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2943 l_initial_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2944 l_old_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2945 BEGIN
2946
2947 API_Rec_To_RowType_Rec(p_x_line_rec, l_line_rec);
2948 API_Rec_To_RowType_Rec(p_old_line_rec, l_old_line_rec);
2949
2950 -- Initial rec is same as current record here as this procedure is
2951 -- called before defaulting and the current record is the same as
2952 -- that passed to process order with the user-specified changes only
2953 l_initial_line_rec := l_line_rec;
2954
2955 Clear_Dependent_Attr
2956 ( p_attr_id => p_attr_id
2957 , p_initial_line_rec => l_initial_line_rec
2958 , p_old_line_rec => l_old_line_rec
2959 , p_x_line_rec => l_line_rec
2960 );
2961
2962 RowType_Rec_To_API_Rec(l_line_rec, p_x_line_rec);
2963
2964 END Clear_Dependent_Attr;
2965
2966 -- 13-DEC-01 Introduced new procedure - clear_dep_and_default.
2967 -- This procedure will be used to detect if there was a dependent
2968 -- attribute that is changed and re-defaulted in the call or not.
2969 PROCEDURE Clear_Dep_And_Default
2970 ( p_src_attr_tbl IN OE_GLOBALS.Number_Tbl_Type
2971 , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
2972 , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
2973 )IS
2974 l_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2975 l_initial_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2976 l_old_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2977 l_dep_attr_exists VARCHAR2(1);
2978 BEGIN
2979
2980 API_Rec_To_RowType_Rec(p_x_line_rec, l_line_rec);
2981 API_Rec_To_RowType_Rec(p_old_line_rec, l_old_line_rec);
2982
2983 -- Initial rec is same as current record here as this procedure is
2984 -- called before defaulting and the current record is the same as
2985 -- that passed to process order with the user-specified changes only
2986 l_initial_line_rec := l_line_rec;
2987
2988 -- Initialize the global to 'N'
2989 OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'N';
2990
2991 Clear_Dependents
2992 ( p_src_attr_tbl => p_src_attr_tbl
2993 , p_initial_line_rec => l_initial_line_rec
2994 , p_old_line_rec => l_old_line_rec
2995 , p_x_line_rec => l_line_rec
2996 , x_dep_attr_exists => l_dep_attr_exists
2997 );
2998
2999 IF l_dep_attr_exists = 'N' THEN
3000 oe_debug_pub.add('No Dep Attributes');
3001 RETURN;
3002 END IF;
3003
3004 RowType_Rec_To_API_Rec(l_line_rec, p_x_line_rec);
3005
3006 OE_Default_Line.Attributes
3007 ( p_x_line_rec => p_x_line_rec
3008 , p_old_line_rec => p_old_line_rec
3009 );
3010
3011 EXCEPTION
3012 WHEN FND_API.G_EXC_ERROR THEN
3013 RAISE FND_API.G_EXC_ERROR;
3014 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3015 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3016 WHEN OTHERS THEN
3017 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3018 THEN
3019 OE_MSG_PUB.Add_Exc_Msg
3020 ( G_PKG_NAME
3021 , 'Clear_Dep_And_Default'
3022 );
3023 END IF;
3024 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3025 END Clear_Dep_And_Default;
3026
3027 END OE_Line_Util_Ext;