[Home] [Help]
PACKAGE BODY: APPS.OE_DEFAULT_PRICE_LIST_LINE
Source
1 PACKAGE BODY OE_Default_Price_List_Line AS
2 /* $Header: OEXDPRLB.pls 120.2 2005/07/07 04:46:29 appldev ship $ */
3
4 -- Global constant holding the package name
5
6 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Default_Price_List_Line';
7
8 -- Package global used within the package.
9
10 g_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
11
12 -- Get functions.
13
14 FUNCTION Get_Comments
15 RETURN VARCHAR2
16 IS
17 BEGIN
18
19 RETURN NULL;
20
21 END Get_Comments;
22
23 FUNCTION Get_Customer_Item
24 RETURN NUMBER
25 IS
26 BEGIN
27
28 RETURN NULL;
29
30 END Get_Customer_Item;
31
32 FUNCTION Get_End_Date_Active
33 RETURN DATE
34 IS
35 BEGIN
36
37 RETURN NULL;
38
39 END Get_End_Date_Active;
40
41 FUNCTION Get_Inventory_Item
42 RETURN NUMBER
43 IS
44 BEGIN
45
46 RETURN NULL;
47
48 END Get_Inventory_Item;
49
50 FUNCTION Get_List_Price
51 RETURN NUMBER
52 IS
53 BEGIN
54
55 RETURN NULL;
56
57 END Get_List_Price;
58
59 FUNCTION Get_Method
60 RETURN VARCHAR2
61 IS
62 BEGIN
63
64 RETURN 'AMNT';
65
66 END Get_Method;
67
68 FUNCTION Get_Price_List
69 RETURN NUMBER
70 IS
71 BEGIN
72
73 RETURN NULL;
74
75 END Get_Price_List;
76
77 FUNCTION Get_Price_List_Line
78 RETURN NUMBER
79 IS
80 l_price_list_line_id NUMBER := NULL;
81 BEGIN
82
83 oe_debug_pub.add('Entering OE_Default_Price_List_Line.Get_Price_List_Line');
84
85 select qp_list_lines_s.nextval into l_price_list_line_id
86 from dual;
87
88 oe_debug_pub.add('Exiting OE_Default_Price_List_Line.Get_Price_List_Line: '|| to_char(l_price_list_line_id));
89
90 RETURN l_price_list_line_id;
91
92 EXCEPTION
93
94 WHEN OTHERS THEN
95
96 IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
97 THEN
98 OE_MSG_PUB.Add_Exc_Msg
99 ( G_PKG_NAME ,
100 'Get_Agreement'
101 );
102 END IF;
103
104 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
105
106 END Get_Price_List_Line;
107
108 FUNCTION Get_Pricing_Attribute1
109 RETURN VARCHAR2
110 IS
111 BEGIN
112
113 RETURN NULL;
114
115 END Get_Pricing_Attribute1;
116
117 FUNCTION Get_Pricing_Attribute10
118 RETURN VARCHAR2
119 IS
120 BEGIN
121
122 RETURN NULL;
123
124 END Get_Pricing_Attribute10;
125
126 FUNCTION Get_Pricing_Attribute11
127 RETURN VARCHAR2
128 IS
129 BEGIN
130
131 RETURN NULL;
132
133 END Get_Pricing_Attribute11;
134
135 FUNCTION Get_Pricing_Attribute12
136 RETURN VARCHAR2
137 IS
138 BEGIN
139
140 RETURN NULL;
141
142 END Get_Pricing_Attribute12;
143
144 FUNCTION Get_Pricing_Attribute13
145 RETURN VARCHAR2
146 IS
147 BEGIN
148
149 RETURN NULL;
150
151 END Get_Pricing_Attribute13;
152
153 FUNCTION Get_Pricing_Attribute14
154 RETURN VARCHAR2
155 IS
156 BEGIN
157
158 RETURN NULL;
159
160 END Get_Pricing_Attribute14;
161
162 FUNCTION Get_Pricing_Attribute15
163 RETURN VARCHAR2
164 IS
165 BEGIN
166
167 RETURN NULL;
168
169 END Get_Pricing_Attribute15;
170
171 FUNCTION Get_Pricing_Attribute2
172 RETURN VARCHAR2
173 IS
174 BEGIN
175
176 RETURN NULL;
177
178 END Get_Pricing_Attribute2;
179
180 FUNCTION Get_Pricing_Attribute3
181 RETURN VARCHAR2
182 IS
183 BEGIN
184
185 RETURN NULL;
186
187 END Get_Pricing_Attribute3;
188
189 FUNCTION Get_Pricing_Attribute4
190 RETURN VARCHAR2
191 IS
192 BEGIN
193
194 RETURN NULL;
195
196 END Get_Pricing_Attribute4;
197
198 FUNCTION Get_Pricing_Attribute5
199 RETURN VARCHAR2
200 IS
201 BEGIN
202
203 RETURN NULL;
204
205 END Get_Pricing_Attribute5;
206
207 FUNCTION Get_Pricing_Attribute6
208 RETURN VARCHAR2
209 IS
210 BEGIN
211 RETURN NULL;
212 END Get_Pricing_Attribute6;
213
214 FUNCTION Get_Pricing_Attribute7
215 RETURN VARCHAR2
216 IS
217 BEGIN
218 RETURN NULL;
219 END Get_Pricing_Attribute7;
220
221 FUNCTION Get_Pricing_Attribute8
222 RETURN VARCHAR2
223 IS
224 BEGIN
225 RETURN NULL;
226 END Get_Pricing_Attribute8;
227
228 FUNCTION Get_Pricing_Attribute9
229 RETURN VARCHAR2
230 IS
231 BEGIN
232 RETURN NULL;
233 END Get_Pricing_Attribute9;
234
235 FUNCTION Get_Pricing_Context
236 RETURN VARCHAR2
237 IS
238 BEGIN
239 RETURN NULL;
240 END Get_Pricing_Context;
241
242 FUNCTION Get_Pricing_Rule
243 RETURN NUMBER
244 IS
245 BEGIN
246
247 RETURN NULL;
248
249 END Get_Pricing_Rule;
250
251 FUNCTION Get_Primary
252 RETURN VARCHAR2
253 IS
254 BEGIN
255
256 RETURN NULL;
257
258 END Get_Primary;
259
260 FUNCTION Get_Reprice
261 RETURN VARCHAR2
262 IS
263 BEGIN
264
265 RETURN NULL;
266
267 END Get_Reprice;
268
269 FUNCTION Get_Revision
270 RETURN VARCHAR2
271 IS
272 BEGIN
273
274 RETURN '1';
275
276 END Get_Revision;
277
278 FUNCTION Get_Revision_Date
279 RETURN DATE
280 IS
281 BEGIN
282
283 RETURN SYSDATE;
284
285 END Get_Revision_Date;
286
287 FUNCTION Get_Revision_Reason
288 RETURN VARCHAR2
289 IS
290 BEGIN
291
292 RETURN NULL;
293
294 END Get_Revision_Reason;
295
296 FUNCTION Get_Start_Date_Active
297 RETURN DATE
298 IS
299 BEGIN
300
301 RETURN SYSDATE;
302
303 END Get_Start_Date_Active;
304
305 FUNCTION Get_Unit
306 RETURN VARCHAR2
307 IS
308 BEGIN
309
310 RETURN NULL;
311
312 END Get_Unit;
313
314 PROCEDURE Get_Flex_So_Price_List_Lines
315 IS
316 BEGIN
317
318 -- In the future call Flex APIs for defaults
319
320 IF g_PRICE_LIST_LINE_rec.attribute1 = FND_API.G_MISS_CHAR THEN
321 g_PRICE_LIST_LINE_rec.attribute1 := NULL;
322 END IF;
323
324 IF g_PRICE_LIST_LINE_rec.attribute10 = FND_API.G_MISS_CHAR THEN
325 g_PRICE_LIST_LINE_rec.attribute10 := NULL;
326 END IF;
327
328 IF g_PRICE_LIST_LINE_rec.attribute11 = FND_API.G_MISS_CHAR THEN
329 g_PRICE_LIST_LINE_rec.attribute11 := NULL;
330 END IF;
331
332 IF g_PRICE_LIST_LINE_rec.attribute12 = FND_API.G_MISS_CHAR THEN
333 g_PRICE_LIST_LINE_rec.attribute12 := NULL;
334 END IF;
335
336 IF g_PRICE_LIST_LINE_rec.attribute13 = FND_API.G_MISS_CHAR THEN
337 g_PRICE_LIST_LINE_rec.attribute13 := NULL;
338 END IF;
339
340 IF g_PRICE_LIST_LINE_rec.attribute14 = FND_API.G_MISS_CHAR THEN
341 g_PRICE_LIST_LINE_rec.attribute14 := NULL;
342 END IF;
343
344 IF g_PRICE_LIST_LINE_rec.attribute15 = FND_API.G_MISS_CHAR THEN
345 g_PRICE_LIST_LINE_rec.attribute15 := NULL;
346 END IF;
347
348 IF g_PRICE_LIST_LINE_rec.attribute2 = FND_API.G_MISS_CHAR THEN
349 g_PRICE_LIST_LINE_rec.attribute2 := NULL;
350 END IF;
351
352 IF g_PRICE_LIST_LINE_rec.attribute3 = FND_API.G_MISS_CHAR THEN
353 g_PRICE_LIST_LINE_rec.attribute3 := NULL;
354 END IF;
355
356 IF g_PRICE_LIST_LINE_rec.attribute4 = FND_API.G_MISS_CHAR THEN
357 g_PRICE_LIST_LINE_rec.attribute4 := NULL;
358 END IF;
359
360 IF g_PRICE_LIST_LINE_rec.attribute5 = FND_API.G_MISS_CHAR THEN
361 g_PRICE_LIST_LINE_rec.attribute5 := NULL;
362 END IF;
363
364 IF g_PRICE_LIST_LINE_rec.attribute6 = FND_API.G_MISS_CHAR THEN
365 g_PRICE_LIST_LINE_rec.attribute6 := NULL;
366 END IF;
367
368 IF g_PRICE_LIST_LINE_rec.attribute7 = FND_API.G_MISS_CHAR THEN
369 g_PRICE_LIST_LINE_rec.attribute7 := NULL;
370 END IF;
371
372 IF g_PRICE_LIST_LINE_rec.attribute8 = FND_API.G_MISS_CHAR THEN
373 g_PRICE_LIST_LINE_rec.attribute8 := NULL;
374 END IF;
375
376 IF g_PRICE_LIST_LINE_rec.attribute9 = FND_API.G_MISS_CHAR THEN
377 g_PRICE_LIST_LINE_rec.attribute9 := NULL;
378 END IF;
379
380 IF g_PRICE_LIST_LINE_rec.context = FND_API.G_MISS_CHAR THEN
381 g_PRICE_LIST_LINE_rec.context := NULL;
382 END IF;
383
384 END Get_Flex_So_Price_List_Lines;
385
386 PROCEDURE Get_Flex_Pricing_Attributes
387 IS
388 BEGIN
389
390 -- In the future call Flex APIs for defaults
391
392 IF g_PRICE_LIST_LINE_rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
393 g_PRICE_LIST_LINE_rec.pricing_attribute1 := NULL;
394 END IF;
395
396 IF g_PRICE_LIST_LINE_rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
397 g_PRICE_LIST_LINE_rec.pricing_attribute10 := NULL;
398 END IF;
399
400 IF g_PRICE_LIST_LINE_rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
401 g_PRICE_LIST_LINE_rec.pricing_attribute2 := NULL;
402 END IF;
403
404 IF g_PRICE_LIST_LINE_rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
405 g_PRICE_LIST_LINE_rec.pricing_attribute3 := NULL;
406 END IF;
407
408 IF g_PRICE_LIST_LINE_rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
409 g_PRICE_LIST_LINE_rec.pricing_attribute4 := NULL;
410 END IF;
411
412 IF g_PRICE_LIST_LINE_rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
413 g_PRICE_LIST_LINE_rec.pricing_attribute5 := NULL;
414 END IF;
415
416 IF g_PRICE_LIST_LINE_rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
417 g_PRICE_LIST_LINE_rec.pricing_attribute6 := NULL;
418 END IF;
419
420 IF g_PRICE_LIST_LINE_rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
421 g_PRICE_LIST_LINE_rec.pricing_attribute7 := NULL;
422 END IF;
423
424 IF g_PRICE_LIST_LINE_rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
425 g_PRICE_LIST_LINE_rec.pricing_attribute8 := NULL;
426 END IF;
427
428 IF g_PRICE_LIST_LINE_rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
429 g_PRICE_LIST_LINE_rec.pricing_attribute9 := NULL;
430 END IF;
431
432 IF g_PRICE_LIST_LINE_rec.pricing_context = FND_API.G_MISS_CHAR THEN
433 g_PRICE_LIST_LINE_rec.pricing_context := NULL;
434 END IF;
435
436 END Get_Flex_Pricing_Attributes;
437
438 /*
439 FUNCTION Get_Method_Type
440 RETURN VARCHAR2
441 IS
442 BEGIN
443
444 RETURN NULL;
445
446 END Get_Method_Type;
447 */
448
449 FUNCTION Get_List_Line_Type
450 RETURN VARCHAR2
451 IS
452 BEGIN
453
454 RETURN 'PLL';
455
456 END Get_List_Line_Type;
457
458 /*
459 FUNCTION Get_Price_Break_Type
460 RETURN VARCHAR2
461 IS
462 BEGIN
463
464 RETURN NULL;
465
466 END Get_Price_Break_Type;
467
468 FUNCTION Get_Price_Break_low
469 RETURN VARCHAR2
470 IS
471 BEGIN
472
473 RETURN NULL;
474
475 END Get_Price_Break_Low;
476
477 FUNCTION Get_Price_Break_High
478 RETURN VARCHAR2
479 IS
480 BEGIN
481
482 RETURN NULL;
483
484 END Get_Price_Break_High;
485
486 FUNCTION Get_Price_Break_Parent_Line
487 RETURN VARCHAR2
488 IS
489 BEGIN
490
491 RETURN NULL;
492
493 END Get_Price_Break_Parent_Line;
494
495 */
496
497
498 -- Procedure Attributes
499
500 PROCEDURE Attributes
501 ( p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
502 OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
503 , p_iteration IN NUMBER := 1
504 , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
505 )
506 IS
507 l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type; --[prarasto]
508 BEGIN
509
510 -- Check number of iterations.
511
512 IF p_iteration > OE_GLOBALS.G_MAX_DEF_ITERATIONS THEN
513
514 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
515 THEN
516
517 FND_MESSAGE.SET_NAME('OE','OE_DEF_MAX_ITERATION');
518 OE_MSG_PUB.Add;
519
520 END IF;
521
522 RAISE FND_API.G_EXC_ERROR;
523
524 END IF;
525
526 -- Initialize g_PRICE_LIST_LINE_rec
527
528 g_PRICE_LIST_LINE_rec := p_PRICE_LIST_LINE_rec;
529
530 -- Default missing attributes.
531
532 IF g_PRICE_LIST_LINE_rec.comments = FND_API.G_MISS_CHAR THEN
533
534 g_PRICE_LIST_LINE_rec.comments := Get_Comments;
535
536 IF g_PRICE_LIST_LINE_rec.comments IS NOT NULL THEN
537
538 IF OE_Validate_Attr.Comments(g_PRICE_LIST_LINE_rec.comments)
539 THEN
540
541 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
542
543 OE_Price_List_Line_Util.Clear_Dependent_Attr
544 ( p_attr_id => OE_Price_List_Line_Util.G_COMMENTS
545 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
546 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
547 );
548 ELSE
549 g_PRICE_LIST_LINE_rec.comments := NULL;
550 END IF;
551
552 END IF;
553
554 END IF;
555
556
557 IF g_PRICE_LIST_LINE_rec.customer_item_id = FND_API.G_MISS_NUM THEN
558
559 g_PRICE_LIST_LINE_rec.customer_item_id := Get_Customer_Item;
560
561 IF g_PRICE_LIST_LINE_rec.customer_item_id IS NOT NULL THEN
562
563 IF OE_Validate_Attr.Customer_Item(g_PRICE_LIST_LINE_rec.customer_item_id)
564 THEN
565
566 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
567
568 OE_Price_List_Line_Util.Clear_Dependent_Attr
569 ( p_attr_id => OE_Price_List_Line_Util.G_CUSTOMER_ITEM
570 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
571 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
572 );
573 ELSE
574 g_PRICE_LIST_LINE_rec.customer_item_id := NULL;
575 END IF;
576
577 END IF;
578
579 END IF;
580
581 IF g_PRICE_LIST_LINE_rec.end_date_active = FND_API.G_MISS_DATE THEN
582
583 g_PRICE_LIST_LINE_rec.end_date_active := Get_End_Date_Active;
584
585 IF g_PRICE_LIST_LINE_rec.end_date_active IS NOT NULL THEN
589
586
587 IF OE_Validate_Attr.End_Date_Active(g_PRICE_LIST_LINE_rec.end_date_active)
588 THEN
590 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
591
592 OE_Price_List_Line_Util.Clear_Dependent_Attr
593 ( p_attr_id => OE_Price_List_Line_Util.G_END_DATE_ACTIVE
594 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
595 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
596 );
597 ELSE
598 g_PRICE_LIST_LINE_rec.end_date_active := NULL;
599 END IF;
600
601 END IF;
602
603 END IF;
604
605 IF g_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
606
607 g_PRICE_LIST_LINE_rec.inventory_item_id := Get_Inventory_Item;
608
609 IF g_PRICE_LIST_LINE_rec.inventory_item_id IS NOT NULL THEN
610
611 IF OE_Validate_Attr.Inventory_Item(g_PRICE_LIST_LINE_rec.inventory_item_id)
612 THEN
613
614 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
615
616 OE_Price_List_Line_Util.Clear_Dependent_Attr
617 ( p_attr_id => OE_Price_List_Line_Util.G_INVENTORY_ITEM
618 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
619 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
620 );
621 ELSE
622 g_PRICE_LIST_LINE_rec.inventory_item_id := NULL;
623 END IF;
624
625 END IF;
626
627 END IF;
628
629 IF g_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM THEN
630
631 g_PRICE_LIST_LINE_rec.list_price := Get_List_Price;
632
633 IF g_PRICE_LIST_LINE_rec.list_price IS NOT NULL THEN
634
635 IF OE_Validate_Attr.List_Price(g_PRICE_LIST_LINE_rec.list_price)
636 THEN
637
638 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
639
640 OE_Price_List_Line_Util.Clear_Dependent_Attr
641 ( p_attr_id => OE_Price_List_Line_Util.G_LIST_PRICE
642 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
643 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
644 );
645 ELSE
646 g_PRICE_LIST_LINE_rec.list_price := NULL;
647 END IF;
648
649 END IF;
650
651 END IF;
652
653 IF g_PRICE_LIST_LINE_rec.method_code = FND_API.G_MISS_CHAR THEN
654
655 g_PRICE_LIST_LINE_rec.method_code := Get_Method;
656
657 IF g_PRICE_LIST_LINE_rec.method_code IS NOT NULL THEN
658
659 IF OE_Validate_Attr.Method(g_PRICE_LIST_LINE_rec.method_code)
660 THEN
661
662 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
663
664 OE_Price_List_Line_Util.Clear_Dependent_Attr
665 ( p_attr_id => OE_Price_List_Line_Util.G_METHOD
666 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
667 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
668 );
669 ELSE
670 g_PRICE_LIST_LINE_rec.method_code := NULL;
671 END IF;
672
673 END IF;
674
675 END IF;
676
677 IF g_PRICE_LIST_LINE_rec.price_list_id = FND_API.G_MISS_NUM THEN
678
679 g_PRICE_LIST_LINE_rec.price_list_id := Get_Price_List;
680
681 IF g_PRICE_LIST_LINE_rec.price_list_id IS NOT NULL THEN
682
683 IF OE_Validate_Attr.Price_List(g_PRICE_LIST_LINE_rec.price_list_id)
684 THEN
685
686 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
687
688 OE_Price_List_Line_Util.Clear_Dependent_Attr
689 ( p_attr_id => OE_Price_List_Line_Util.G_PRICE_LIST
690 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
691 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
692 );
693 ELSE
694 g_PRICE_LIST_LINE_rec.price_list_id := NULL;
695 END IF;
696
697 END IF;
698
699 END IF;
700
701 IF g_PRICE_LIST_LINE_rec.price_list_line_id = FND_API.G_MISS_NUM THEN
702
703 g_PRICE_LIST_LINE_rec.price_list_line_id := Get_Price_List_Line;
704
705 IF g_PRICE_LIST_LINE_rec.price_list_line_id IS NOT NULL THEN
706
707 IF OE_Validate_Attr.Price_List_Line(g_PRICE_LIST_LINE_rec.price_list_line_id)
708 THEN
709
710 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
711
712 OE_Price_List_Line_Util.Clear_Dependent_Attr
713 ( p_attr_id => OE_Price_List_Line_Util.G_PRICE_LIST_LINE
714 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
715 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
716 );
717 ELSE
718 g_PRICE_LIST_LINE_rec.price_list_line_id := NULL;
719 END IF;
723 END IF;
720
721 END IF;
722
724
725 IF g_PRICE_LIST_LINE_rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
726
727 g_PRICE_LIST_LINE_rec.pricing_attribute1 := Get_Pricing_Attribute1;
728
729 IF g_PRICE_LIST_LINE_rec.pricing_attribute1 IS NOT NULL THEN
730
731 IF OE_Validate_Attr.Pricing_Attribute1(g_PRICE_LIST_LINE_rec.pricing_attribute1)
732 THEN
733
734 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
735
736 OE_Price_List_Line_Util.Clear_Dependent_Attr
737 ( p_attr_id => OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE1
738 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
739 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
740 );
741 ELSE
742 g_PRICE_LIST_LINE_rec.pricing_attribute1 := NULL;
743 END IF;
744
745 END IF;
746
747 END IF;
748
749 IF g_PRICE_LIST_LINE_rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
750
751 g_PRICE_LIST_LINE_rec.pricing_attribute2 := Get_Pricing_Attribute2;
752
753 IF g_PRICE_LIST_LINE_rec.pricing_attribute2 IS NOT NULL THEN
754
755 IF OE_Validate_Attr.Pricing_Attribute2(g_PRICE_LIST_LINE_rec.pricing_attribute2)
756 THEN
757
758 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
759
760 OE_Price_List_Line_Util.Clear_Dependent_Attr
761 ( p_attr_id => OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE2
762 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
763 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
764 );
765 ELSE
766 g_PRICE_LIST_LINE_rec.pricing_attribute2 := NULL;
767 END IF;
768
769 END IF;
770
771 END IF;
772
773 IF g_PRICE_LIST_LINE_rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
774
775 g_PRICE_LIST_LINE_rec.pricing_attribute3 := Get_Pricing_Attribute3;
776
777 IF g_PRICE_LIST_LINE_rec.pricing_attribute3 IS NOT NULL THEN
778
779 IF OE_Validate_Attr.Pricing_Attribute3(g_PRICE_LIST_LINE_rec.pricing_attribute3)
780 THEN
781
782 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
783
784 OE_Price_List_Line_Util.Clear_Dependent_Attr
785 ( p_attr_id => OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE3
786 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
787 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
788 );
789 ELSE
790 g_PRICE_LIST_LINE_rec.pricing_attribute3 := NULL;
791 END IF;
792
793 END IF;
794
795 END IF;
796
797 IF g_PRICE_LIST_LINE_rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
798
799 g_PRICE_LIST_LINE_rec.pricing_attribute4 := Get_Pricing_Attribute4;
800
801 IF g_PRICE_LIST_LINE_rec.pricing_attribute4 IS NOT NULL THEN
802
803 IF OE_Validate_Attr.Pricing_Attribute4(g_PRICE_LIST_LINE_rec.pricing_attribute4)
804 THEN
805
806 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
807
808 OE_Price_List_Line_Util.Clear_Dependent_Attr
809 ( p_attr_id => OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE4
810 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
811 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
812 );
813 ELSE
814 g_PRICE_LIST_LINE_rec.pricing_attribute4 := NULL;
815 END IF;
816
817 END IF;
818
819 END IF;
820
821 IF g_PRICE_LIST_LINE_rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
822
823 g_PRICE_LIST_LINE_rec.pricing_attribute5 := Get_Pricing_Attribute5;
824
825 IF g_PRICE_LIST_LINE_rec.pricing_attribute5 IS NOT NULL THEN
826
827 IF OE_Validate_Attr.Pricing_Attribute5(g_PRICE_LIST_LINE_rec.pricing_attribute5)
828 THEN
829
830 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
831
832 OE_Price_List_Line_Util.Clear_Dependent_Attr
833 ( p_attr_id => OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE5
834 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
835 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
836 );
837 ELSE
838 g_PRICE_LIST_LINE_rec.pricing_attribute5 := NULL;
839 END IF;
840
841 END IF;
842
843 END IF;
844
845 IF g_PRICE_LIST_LINE_rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
846
847 g_PRICE_LIST_LINE_rec.pricing_attribute6 := Get_Pricing_Attribute6;
848
849 IF g_PRICE_LIST_LINE_rec.pricing_attribute6 IS NOT NULL THEN
850
851 IF OE_Validate_Attr.Pricing_Attribute6(g_PRICE_LIST_LINE_rec.pricing_attribute6)
852 THEN
853
857 ( p_attr_id => OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE6
854 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
855
856 OE_Price_List_Line_Util.Clear_Dependent_Attr
858 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
859 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
860 );
861 ELSE
862 g_PRICE_LIST_LINE_rec.pricing_attribute6 := NULL;
863 END IF;
864
865 END IF;
866
867 END IF;
868
869 IF g_PRICE_LIST_LINE_rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
870
871 g_PRICE_LIST_LINE_rec.pricing_attribute7 := Get_Pricing_Attribute7;
872
873 IF g_PRICE_LIST_LINE_rec.pricing_attribute7 IS NOT NULL THEN
874
875 IF OE_Validate_Attr.Pricing_Attribute7(g_PRICE_LIST_LINE_rec.pricing_attribute7)
876 THEN
877
878 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
879
880 OE_Price_List_Line_Util.Clear_Dependent_Attr
881 ( p_attr_id => OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE7
882 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
883 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
884 );
885 ELSE
886 g_PRICE_LIST_LINE_rec.pricing_attribute7 := NULL;
887 END IF;
888
889 END IF;
890
891 END IF;
892
893 IF g_PRICE_LIST_LINE_rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
894
895 g_PRICE_LIST_LINE_rec.pricing_attribute8 := Get_Pricing_Attribute8;
896
897 IF g_PRICE_LIST_LINE_rec.pricing_attribute8 IS NOT NULL THEN
898
899 IF OE_Validate_Attr.Pricing_Attribute8(g_PRICE_LIST_LINE_rec.pricing_attribute8)
900 THEN
901
902 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
903
904 OE_Price_List_Line_Util.Clear_Dependent_Attr
905 ( p_attr_id => OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE8
906 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
907 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
908 );
909 ELSE
910 g_PRICE_LIST_LINE_rec.pricing_attribute8 := NULL;
911 END IF;
912
913 END IF;
914
915 END IF;
916
917 IF g_PRICE_LIST_LINE_rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
918
919 g_PRICE_LIST_LINE_rec.pricing_attribute9 := Get_Pricing_Attribute9;
920
921 IF g_PRICE_LIST_LINE_rec.pricing_attribute9 IS NOT NULL THEN
922
923 IF OE_Validate_Attr.Pricing_Attribute9(g_PRICE_LIST_LINE_rec.pricing_attribute9)
924 THEN
925
926 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
927
928 OE_Price_List_Line_Util.Clear_Dependent_Attr
929 ( p_attr_id => OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE9
930 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
931 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
932 );
933 ELSE
934 g_PRICE_LIST_LINE_rec.pricing_attribute9 := NULL;
935 END IF;
936
937 END IF;
938
939 END IF;
940
941 IF g_PRICE_LIST_LINE_rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
942
943 g_PRICE_LIST_LINE_rec.pricing_attribute10 := Get_Pricing_Attribute10;
944
945 IF g_PRICE_LIST_LINE_rec.pricing_attribute10 IS NOT NULL THEN
946
947 IF OE_Validate_Attr.Pricing_Attribute10(g_PRICE_LIST_LINE_rec.pricing_attribute10)
948 THEN
949
950 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
951
952 OE_Price_List_Line_Util.Clear_Dependent_Attr
953 ( p_attr_id => OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE10
954 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
955 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
956 );
957 ELSE
958 g_PRICE_LIST_LINE_rec.pricing_attribute10 := NULL;
959 END IF;
960
961 END IF;
962
963 END IF;
964
965 IF g_PRICE_LIST_LINE_rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN
966
967 g_PRICE_LIST_LINE_rec.pricing_attribute11 := Get_Pricing_Attribute11;
968
969 IF g_PRICE_LIST_LINE_rec.pricing_attribute11 IS NOT NULL THEN
970
971 IF OE_Validate_Attr.Pricing_Attribute11(g_PRICE_LIST_LINE_rec.pricing_attribute11)
972 THEN
973
974 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
975
976 OE_Price_List_Line_Util.Clear_Dependent_Attr
977 ( p_attr_id => OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE11
978 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
979 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
980 );
981 ELSE
985 END IF;
982 g_PRICE_LIST_LINE_rec.pricing_attribute11 := NULL;
983 END IF;
984
986
987 END IF;
988
989 IF g_PRICE_LIST_LINE_rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN
990
991 g_PRICE_LIST_LINE_rec.pricing_attribute12 := Get_Pricing_Attribute12;
992
993 IF g_PRICE_LIST_LINE_rec.pricing_attribute12 IS NOT NULL THEN
994
995 IF OE_Validate_Attr.Pricing_Attribute12(g_PRICE_LIST_LINE_rec.pricing_attribute12)
996 THEN
997
998 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
999
1000 OE_Price_List_Line_Util.Clear_Dependent_Attr
1001 ( p_attr_id => OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE12
1002 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
1003 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
1004 );
1005 ELSE
1006 g_PRICE_LIST_LINE_rec.pricing_attribute12 := NULL;
1007 END IF;
1008
1009 END IF;
1010
1011 END IF;
1012
1013 IF g_PRICE_LIST_LINE_rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN
1014
1015 g_PRICE_LIST_LINE_rec.pricing_attribute13 := Get_Pricing_Attribute13;
1016
1017 IF g_PRICE_LIST_LINE_rec.pricing_attribute13 IS NOT NULL THEN
1018
1019 IF OE_Validate_Attr.Pricing_Attribute13(g_PRICE_LIST_LINE_rec.pricing_attribute13)
1020 THEN
1021
1022 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
1023
1024 OE_Price_List_Line_Util.Clear_Dependent_Attr
1025 ( p_attr_id => OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE13
1026 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
1027 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
1028 );
1029 ELSE
1030 g_PRICE_LIST_LINE_rec.pricing_attribute13 := NULL;
1031 END IF;
1032
1033 END IF;
1034
1035 END IF;
1036
1037 IF g_PRICE_LIST_LINE_rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN
1038
1039 g_PRICE_LIST_LINE_rec.pricing_attribute14 := Get_Pricing_Attribute14;
1040
1041 IF g_PRICE_LIST_LINE_rec.pricing_attribute14 IS NOT NULL THEN
1042
1043 IF OE_Validate_Attr.Pricing_Attribute14(g_PRICE_LIST_LINE_rec.pricing_attribute14)
1044 THEN
1045
1046 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
1047
1048 OE_Price_List_Line_Util.Clear_Dependent_Attr
1049 ( p_attr_id => OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE14
1050 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
1051 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
1052 );
1053 ELSE
1054 g_PRICE_LIST_LINE_rec.pricing_attribute14 := NULL;
1055 END IF;
1056
1057 END IF;
1058
1059 END IF;
1060
1061 IF g_PRICE_LIST_LINE_rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN
1062
1063 g_PRICE_LIST_LINE_rec.pricing_attribute15 := Get_Pricing_Attribute15;
1064
1065 IF g_PRICE_LIST_LINE_rec.pricing_attribute15 IS NOT NULL THEN
1066
1067 IF OE_Validate_Attr.Pricing_Attribute15(g_PRICE_LIST_LINE_rec.pricing_attribute15)
1068 THEN
1069
1070 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
1071
1072 OE_Price_List_Line_Util.Clear_Dependent_Attr
1073 ( p_attr_id => OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE15
1074 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
1075 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
1076 );
1077 ELSE
1078 g_PRICE_LIST_LINE_rec.pricing_attribute15 := NULL;
1079 END IF;
1080
1081 END IF;
1082
1083 END IF;
1084
1085
1086 IF g_PRICE_LIST_LINE_rec.pricing_context = FND_API.G_MISS_CHAR THEN
1087
1088 g_PRICE_LIST_LINE_rec.pricing_context := Get_Pricing_context;
1089
1090 IF g_PRICE_LIST_LINE_rec.pricing_context IS NOT NULL THEN
1091
1092 IF OE_Validate_Attr.Pricing_context(g_PRICE_LIST_LINE_rec.pricing_context)
1093 THEN
1094
1095 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
1096
1097 OE_Price_List_Line_Util.Clear_Dependent_Attr
1098 ( p_attr_id => OE_Price_List_Line_Util.G_PRICING_context
1099 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
1100 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
1101 );
1102 ELSE
1103 g_PRICE_LIST_LINE_rec.pricing_context := NULL;
1104 END IF;
1105
1106 END IF;
1107
1108 END IF;
1109
1110 IF g_PRICE_LIST_LINE_rec.pricing_rule_id = FND_API.G_MISS_NUM THEN
1111
1112 g_PRICE_LIST_LINE_rec.pricing_rule_id := Get_Pricing_Rule;
1113
1114 IF g_PRICE_LIST_LINE_rec.pricing_rule_id IS NOT NULL THEN
1115
1119 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
1116 IF OE_Validate_Attr.Pricing_Rule(g_PRICE_LIST_LINE_rec.pricing_rule_id)
1117 THEN
1118
1120
1121 OE_Price_List_Line_Util.Clear_Dependent_Attr
1122 ( p_attr_id => OE_Price_List_Line_Util.G_PRICING_RULE
1123 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
1124 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
1125 );
1126 ELSE
1127 g_PRICE_LIST_LINE_rec.pricing_rule_id := NULL;
1128 END IF;
1129
1130 END IF;
1131
1132 END IF;
1133
1134 IF g_PRICE_LIST_LINE_rec.primary = FND_API.G_MISS_CHAR THEN
1135
1136 g_PRICE_LIST_LINE_rec.primary := Get_Primary;
1137
1138 IF g_PRICE_LIST_LINE_rec.primary IS NOT NULL THEN
1139
1140 IF OE_Validate_Attr.Primary(g_PRICE_LIST_LINE_rec.primary)
1141 THEN
1142
1143 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
1144
1145 OE_Price_List_Line_Util.Clear_Dependent_Attr
1146 ( p_attr_id => OE_Price_List_Line_Util.G_PRIMARY
1147 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
1148 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
1149 );
1150 ELSE
1151 g_PRICE_LIST_LINE_rec.primary := NULL;
1152 END IF;
1153
1154 END IF;
1155
1156 END IF;
1157
1158 IF g_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
1159
1160 g_PRICE_LIST_LINE_rec.reprice_flag := Get_Reprice;
1161
1162 IF g_PRICE_LIST_LINE_rec.reprice_flag IS NOT NULL THEN
1163
1164 IF OE_Validate_Attr.Reprice(g_PRICE_LIST_LINE_rec.reprice_flag)
1165 THEN
1166
1167 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
1168
1169 OE_Price_List_Line_Util.Clear_Dependent_Attr
1170 ( p_attr_id => OE_Price_List_Line_Util.G_REPRICE
1171 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
1172 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
1173 );
1174 ELSE
1175 g_PRICE_LIST_LINE_rec.reprice_flag := NULL;
1176 END IF;
1177
1178 END IF;
1179
1180 END IF;
1181
1182 IF g_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR THEN
1183
1184 g_PRICE_LIST_LINE_rec.revision := Get_Revision;
1185
1186 IF g_PRICE_LIST_LINE_rec.revision IS NOT NULL THEN
1187
1188 IF OE_Validate_Attr.Revision(g_PRICE_LIST_LINE_rec.revision)
1189 THEN
1190
1191 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
1192
1193 OE_Price_List_Line_Util.Clear_Dependent_Attr
1194 ( p_attr_id => OE_Price_List_Line_Util.G_REVISION
1195 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
1196 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
1197 );
1198 ELSE
1199 g_PRICE_LIST_LINE_rec.revision := NULL;
1200 END IF;
1201
1202 END IF;
1203
1204 END IF;
1205
1206 IF g_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE THEN
1207
1208 g_PRICE_LIST_LINE_rec.revision_date := Get_Revision_Date;
1209
1210 IF g_PRICE_LIST_LINE_rec.revision_date IS NOT NULL THEN
1211
1212 IF OE_Validate_Attr.Revision_Date(g_PRICE_LIST_LINE_rec.revision_date)
1213 THEN
1214
1215 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
1216
1217 OE_Price_List_Line_Util.Clear_Dependent_Attr
1218 ( p_attr_id => OE_Price_List_Line_Util.G_REVISION_DATE
1219 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
1220 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
1221 );
1222 ELSE
1223 g_PRICE_LIST_LINE_rec.revision_date := NULL;
1224 END IF;
1225
1226 END IF;
1227
1228 END IF;
1229
1230 IF g_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1231
1232 g_PRICE_LIST_LINE_rec.revision_reason_code := Get_Revision_Reason;
1233
1234 IF g_PRICE_LIST_LINE_rec.revision_reason_code IS NOT NULL THEN
1235
1236 IF OE_Validate_Attr.Revision_Reason(g_PRICE_LIST_LINE_rec.revision_reason_code)
1237 THEN
1238
1239 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
1240
1241 OE_Price_List_Line_Util.Clear_Dependent_Attr
1242 ( p_attr_id => OE_Price_List_Line_Util.G_REVISION_REASON
1243 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
1244 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
1245 );
1246 ELSE
1250 END IF;
1247 g_PRICE_LIST_LINE_rec.revision_reason_code := NULL;
1248 END IF;
1249
1251
1252 END IF;
1253
1254 IF g_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE THEN
1255
1256 g_PRICE_LIST_LINE_rec.start_date_active := Get_Start_Date_Active;
1257
1258 IF g_PRICE_LIST_LINE_rec.start_date_active IS NOT NULL THEN
1259
1260 IF OE_Validate_Attr.Start_Date_Active(g_PRICE_LIST_LINE_rec.start_date_active)
1261 THEN
1262
1263 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
1264
1265 OE_Price_List_Line_Util.Clear_Dependent_Attr
1266 ( p_attr_id => OE_Price_List_Line_Util.G_START_DATE_ACTIVE
1267 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
1268 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
1269 );
1270 ELSE
1271 g_PRICE_LIST_LINE_rec.start_date_active := NULL;
1272 END IF;
1273
1274 END IF;
1275
1276 END IF;
1277
1278 IF g_PRICE_LIST_LINE_rec.unit_code = FND_API.G_MISS_CHAR THEN
1279
1280 g_PRICE_LIST_LINE_rec.unit_code := Get_Unit;
1281
1282 IF g_PRICE_LIST_LINE_rec.unit_code IS NOT NULL THEN
1283
1284 IF OE_Validate_Attr.Unit(g_PRICE_LIST_LINE_rec.unit_code)
1285 THEN
1286
1287 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
1288
1289 OE_Price_List_Line_Util.Clear_Dependent_Attr
1290 ( p_attr_id => OE_Price_List_Line_Util.G_UNIT
1291 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
1292 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
1293 );
1294 ELSE
1295 g_PRICE_LIST_LINE_rec.unit_code := NULL;
1296 END IF;
1297
1298 END IF;
1299
1300 END IF;
1301
1302
1303 IF g_PRICE_LIST_LINE_rec.list_line_type_code = FND_API.G_MISS_CHAR THEN
1304
1305 g_PRICE_LIST_LINE_rec.list_line_type_code := Get_List_Line_Type;
1306
1307 IF g_PRICE_LIST_LINE_rec.list_line_type_code IS NOT NULL THEN
1308
1309 IF OE_Validate_Attr.List_Line_Type(g_PRICE_LIST_LINE_rec.list_line_type_code)
1310 THEN
1311
1312 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
1313
1314 OE_Price_List_Line_Util.Clear_Dependent_Attr
1315 ( p_attr_id => OE_Price_List_Line_Util.G_LIST_LINE_TYPE_CODE
1316 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
1317 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
1318 );
1319 ELSE
1320 g_PRICE_LIST_LINE_rec.list_line_type_code := NULL;
1321 END IF;
1322
1323 END IF;
1324
1325 END IF;
1326
1327 /*
1328
1329 IF g_PRICE_LIST_LINE_rec.primary = FND_API.G_MISS_CHAR THEN
1330
1331 g_PRICE_LIST_LINE_rec.primary := Get_Primary;
1332
1333 IF g_PRICE_LIST_LINE_rec.primary IS NOT NULL THEN
1334
1335 IF OE_Validate_Attr.Primary(g_PRICE_LIST_LINE_rec.primary)
1336 THEN
1337
1338 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
1339
1340 OE_Price_List_Line_Util.Clear_Dependent_Attr
1341 ( p_attr_id => OE_Price_List_Line_Util.G_PRIMARY
1342 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
1343 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
1344 );
1345 ELSE
1346 g_PRICE_LIST_LINE_rec.primary := NULL;
1347 END IF;
1348
1349 END IF;
1350
1351 END IF;
1352
1353 IF g_PRICE_LIST_LINE_rec.primary = FND_API.G_MISS_CHAR THEN
1354
1355 g_PRICE_LIST_LINE_rec.primary := Get_Primary;
1356
1357 IF g_PRICE_LIST_LINE_rec.primary IS NOT NULL THEN
1358
1359 IF OE_Validate_Attr.Primary(g_PRICE_LIST_LINE_rec.primary)
1360 THEN
1361
1362 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
1363
1364 OE_Price_List_Line_Util.Clear_Dependent_Attr
1365 ( p_attr_id => OE_Price_List_Line_Util.G_PRIMARY
1366 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
1367 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
1368 );
1369 ELSE
1370 g_PRICE_LIST_LINE_rec.primary := NULL;
1371 END IF;
1372
1373 END IF;
1374
1375 END IF;
1376
1377 IF g_PRICE_LIST_LINE_rec.primary = FND_API.G_MISS_CHAR THEN
1378
1382
1379 g_PRICE_LIST_LINE_rec.primary := Get_Primary;
1380
1381 IF g_PRICE_LIST_LINE_rec.primary IS NOT NULL THEN
1383 IF OE_Validate_Attr.Primary(g_PRICE_LIST_LINE_rec.primary)
1384 THEN
1385
1386 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
1387
1388 OE_Price_List_Line_Util.Clear_Dependent_Attr
1389 ( p_attr_id => OE_Price_List_Line_Util.G_PRIMARY
1390 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
1391 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
1392 );
1393 ELSE
1394 g_PRICE_LIST_LINE_rec.primary := NULL;
1395 END IF;
1396
1397 END IF;
1398
1399 END IF;
1400
1401 IF g_PRICE_LIST_LINE_rec.primary = FND_API.G_MISS_CHAR THEN
1402
1403 g_PRICE_LIST_LINE_rec.primary := Get_Primary;
1404
1405 IF g_PRICE_LIST_LINE_rec.primary IS NOT NULL THEN
1406
1407 IF OE_Validate_Attr.Primary(g_PRICE_LIST_LINE_rec.primary)
1408 THEN
1409
1410 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
1411
1412 OE_Price_List_Line_Util.Clear_Dependent_Attr
1413 ( p_attr_id => OE_Price_List_Line_Util.G_PRIMARY
1414 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
1415 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
1416 );
1417 ELSE
1418 g_PRICE_LIST_LINE_rec.primary := NULL;
1419 END IF;
1420
1421 END IF;
1422
1423 END IF;
1424
1425 IF g_PRICE_LIST_LINE_rec.primary = FND_API.G_MISS_CHAR THEN
1426
1427 g_PRICE_LIST_LINE_rec.primary := Get_Primary;
1428
1429 IF g_PRICE_LIST_LINE_rec.primary IS NOT NULL THEN
1430
1431 IF OE_Validate_Attr.Primary(g_PRICE_LIST_LINE_rec.primary)
1432 THEN
1433
1434 l_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec; --[prarasto]
1435
1436 OE_Price_List_Line_Util.Clear_Dependent_Attr
1437 ( p_attr_id => OE_Price_List_Line_Util.G_PRIMARY
1438 , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
1439 , x_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
1440 );
1441 ELSE
1442 g_PRICE_LIST_LINE_rec.primary := NULL;
1443 END IF;
1444
1445 END IF;
1446
1447 END IF; */
1448
1449 IF g_PRICE_LIST_LINE_rec.attribute1 = FND_API.G_MISS_CHAR
1450 OR g_PRICE_LIST_LINE_rec.attribute10 = FND_API.G_MISS_CHAR
1454 OR g_PRICE_LIST_LINE_rec.attribute14 = FND_API.G_MISS_CHAR
1451 OR g_PRICE_LIST_LINE_rec.attribute11 = FND_API.G_MISS_CHAR
1452 OR g_PRICE_LIST_LINE_rec.attribute12 = FND_API.G_MISS_CHAR
1453 OR g_PRICE_LIST_LINE_rec.attribute13 = FND_API.G_MISS_CHAR
1455 OR g_PRICE_LIST_LINE_rec.attribute15 = FND_API.G_MISS_CHAR
1456 OR g_PRICE_LIST_LINE_rec.attribute2 = FND_API.G_MISS_CHAR
1457 OR g_PRICE_LIST_LINE_rec.attribute3 = FND_API.G_MISS_CHAR
1458 OR g_PRICE_LIST_LINE_rec.attribute4 = FND_API.G_MISS_CHAR
1459 OR g_PRICE_LIST_LINE_rec.attribute5 = FND_API.G_MISS_CHAR
1460 OR g_PRICE_LIST_LINE_rec.attribute6 = FND_API.G_MISS_CHAR
1461 OR g_PRICE_LIST_LINE_rec.attribute7 = FND_API.G_MISS_CHAR
1462 OR g_PRICE_LIST_LINE_rec.attribute8 = FND_API.G_MISS_CHAR
1463 OR g_PRICE_LIST_LINE_rec.attribute9 = FND_API.G_MISS_CHAR
1464 OR g_PRICE_LIST_LINE_rec.context = FND_API.G_MISS_CHAR
1465 THEN
1466
1467 Get_Flex_So_Price_List_Lines;
1468
1469 END IF;
1470
1471 IF g_PRICE_LIST_LINE_rec.pricing_attribute1 = FND_API.G_MISS_CHAR
1472 OR g_PRICE_LIST_LINE_rec.pricing_attribute10 = FND_API.G_MISS_CHAR
1473 OR g_PRICE_LIST_LINE_rec.pricing_attribute11 = FND_API.G_MISS_CHAR
1474 OR g_PRICE_LIST_LINE_rec.pricing_attribute12 = FND_API.G_MISS_CHAR
1475 OR g_PRICE_LIST_LINE_rec.pricing_attribute13 = FND_API.G_MISS_CHAR
1476 OR g_PRICE_LIST_LINE_rec.pricing_attribute14 = FND_API.G_MISS_CHAR
1477 OR g_PRICE_LIST_LINE_rec.pricing_attribute15 = FND_API.G_MISS_CHAR
1478 OR g_PRICE_LIST_LINE_rec.pricing_attribute2 = FND_API.G_MISS_CHAR
1479 OR g_PRICE_LIST_LINE_rec.pricing_attribute3 = FND_API.G_MISS_CHAR
1480 OR g_PRICE_LIST_LINE_rec.pricing_attribute4 = FND_API.G_MISS_CHAR
1481 OR g_PRICE_LIST_LINE_rec.pricing_attribute5 = FND_API.G_MISS_CHAR
1482 OR g_PRICE_LIST_LINE_rec.pricing_attribute6 = FND_API.G_MISS_CHAR
1483 OR g_PRICE_LIST_LINE_rec.pricing_attribute7 = FND_API.G_MISS_CHAR
1484 OR g_PRICE_LIST_LINE_rec.pricing_attribute8 = FND_API.G_MISS_CHAR
1485 OR g_PRICE_LIST_LINE_rec.pricing_attribute9 = FND_API.G_MISS_CHAR
1486 OR g_PRICE_LIST_LINE_rec.pricing_context = FND_API.G_MISS_CHAR
1487 THEN
1488
1489 Get_Flex_Pricing_Attributes;
1490
1491 END IF;
1492
1493 IF g_PRICE_LIST_LINE_rec.created_by = FND_API.G_MISS_NUM THEN
1494
1495 g_PRICE_LIST_LINE_rec.created_by := NULL;
1496
1497 END IF;
1498
1499 IF g_PRICE_LIST_LINE_rec.creation_date = FND_API.G_MISS_DATE THEN
1500
1501 g_Price_LIST_LINE_rec.creation_date := Get_Start_Date_Active;
1502
1503 IF g_Price_LIST_LINE_rec.creation_date IS NOT NULL THEN
1504
1505 IF OE_Validate_Attr.Start_Date_Active(g_Price_LIST_LINE_rec.creation_date)
1506 THEN
1507 OE_Price_LIST_LINE_Util.Clear_Dependent_Attr
1508 ( p_attr_id => OE_Price_LIST_LINE_Util.G_CREATION_DATE
1509 , p_Price_LIST_LINE_rec => g_Price_LIST_LINE_rec
1510 , x_Price_LIST_LINE_rec => g_Price_LIST_LINE_rec
1511 );
1512 ELSE
1513 g_Price_LIST_LINE_rec.creation_date := NULL;
1514 END IF;
1515 end if;
1516
1517 -- g_PRICE_LIST_LINE_rec.creation_date := NULL;
1518
1519 END IF;
1520
1521 IF g_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1522
1523 g_PRICE_LIST_LINE_rec.last_updated_by := NULL;
1524
1525 END IF;
1526
1527 IF g_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN
1528
1529 g_PRICE_LIST_LINE_rec.last_update_date := NULL;
1530
1531 END IF;
1532
1533 IF g_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN
1534
1535 g_PRICE_LIST_LINE_rec.last_update_login := NULL;
1536
1537 END IF;
1538
1539 IF g_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM THEN
1540
1541 g_PRICE_LIST_LINE_rec.program_application_id := NULL;
1542
1543 END IF;
1544
1545 IF g_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM THEN
1546
1547 g_PRICE_LIST_LINE_rec.program_id := NULL;
1548
1549 END IF;
1550
1551 IF g_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN
1552
1553 g_PRICE_LIST_LINE_rec.program_update_date := NULL;
1554
1555 END IF;
1556
1557 IF g_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM THEN
1558
1559 g_PRICE_LIST_LINE_rec.request_id := NULL;
1560
1561 END IF;
1562
1563 -- Redefault if there are any missing attributes.
1564
1565 IF g_PRICE_LIST_LINE_rec.attribute1 = FND_API.G_MISS_CHAR
1566 OR g_PRICE_LIST_LINE_rec.attribute10 = FND_API.G_MISS_CHAR
1567 OR g_PRICE_LIST_LINE_rec.attribute11 = FND_API.G_MISS_CHAR
1568 OR g_PRICE_LIST_LINE_rec.attribute12 = FND_API.G_MISS_CHAR
1569 OR g_PRICE_LIST_LINE_rec.attribute13 = FND_API.G_MISS_CHAR
1570 OR g_PRICE_LIST_LINE_rec.attribute14 = FND_API.G_MISS_CHAR
1571 OR g_PRICE_LIST_LINE_rec.attribute15 = FND_API.G_MISS_CHAR
1572 OR g_PRICE_LIST_LINE_rec.attribute2 = FND_API.G_MISS_CHAR
1573 OR g_PRICE_LIST_LINE_rec.attribute3 = FND_API.G_MISS_CHAR
1574 OR g_PRICE_LIST_LINE_rec.attribute4 = FND_API.G_MISS_CHAR
1575 OR g_PRICE_LIST_LINE_rec.attribute5 = FND_API.G_MISS_CHAR
1576 OR g_PRICE_LIST_LINE_rec.attribute6 = FND_API.G_MISS_CHAR
1577 OR g_PRICE_LIST_LINE_rec.attribute7 = FND_API.G_MISS_CHAR
1578 OR g_PRICE_LIST_LINE_rec.attribute8 = FND_API.G_MISS_CHAR
1579 OR g_PRICE_LIST_LINE_rec.attribute9 = FND_API.G_MISS_CHAR
1580 OR g_PRICE_LIST_LINE_rec.comments = FND_API.G_MISS_CHAR
1581 OR g_PRICE_LIST_LINE_rec.context = FND_API.G_MISS_CHAR
1582 OR g_PRICE_LIST_LINE_rec.created_by = FND_API.G_MISS_NUM
1586 OR g_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM
1583 OR g_PRICE_LIST_LINE_rec.creation_date = FND_API.G_MISS_DATE
1584 OR g_PRICE_LIST_LINE_rec.customer_item_id = FND_API.G_MISS_NUM
1585 OR g_PRICE_LIST_LINE_rec.end_date_active = FND_API.G_MISS_DATE
1587 OR g_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM
1588 OR g_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE
1589 OR g_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM
1590 OR g_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM
1591 OR g_PRICE_LIST_LINE_rec.method_code = FND_API.G_MISS_CHAR
1592 OR g_PRICE_LIST_LINE_rec.price_list_id = FND_API.G_MISS_NUM
1593 OR g_PRICE_LIST_LINE_rec.price_list_line_id = FND_API.G_MISS_NUM
1594 OR g_PRICE_LIST_LINE_rec.pricing_attribute1 = FND_API.G_MISS_CHAR
1595 OR g_PRICE_LIST_LINE_rec.pricing_attribute10 = FND_API.G_MISS_CHAR
1596 OR g_PRICE_LIST_LINE_rec.pricing_attribute11 = FND_API.G_MISS_CHAR
1597 OR g_PRICE_LIST_LINE_rec.pricing_attribute12 = FND_API.G_MISS_CHAR
1598 OR g_PRICE_LIST_LINE_rec.pricing_attribute13 = FND_API.G_MISS_CHAR
1599 OR g_PRICE_LIST_LINE_rec.pricing_attribute14 = FND_API.G_MISS_CHAR
1600 OR g_PRICE_LIST_LINE_rec.pricing_attribute15 = FND_API.G_MISS_CHAR
1601 OR g_PRICE_LIST_LINE_rec.pricing_attribute2 = FND_API.G_MISS_CHAR
1602 OR g_PRICE_LIST_LINE_rec.pricing_attribute3 = FND_API.G_MISS_CHAR
1603 OR g_PRICE_LIST_LINE_rec.pricing_attribute4 = FND_API.G_MISS_CHAR
1604 OR g_PRICE_LIST_LINE_rec.pricing_attribute5 = FND_API.G_MISS_CHAR
1605 OR g_PRICE_LIST_LINE_rec.pricing_attribute6 = FND_API.G_MISS_CHAR
1606 OR g_PRICE_LIST_LINE_rec.pricing_attribute7 = FND_API.G_MISS_CHAR
1607 OR g_PRICE_LIST_LINE_rec.pricing_attribute8 = FND_API.G_MISS_CHAR
1608 OR g_PRICE_LIST_LINE_rec.pricing_attribute9 = FND_API.G_MISS_CHAR
1609 OR g_PRICE_LIST_LINE_rec.pricing_context = FND_API.G_MISS_CHAR
1610 OR g_PRICE_LIST_LINE_rec.pricing_rule_id = FND_API.G_MISS_NUM
1611 OR g_PRICE_LIST_LINE_rec.primary = FND_API.G_MISS_CHAR
1612 OR g_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM
1613 OR g_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM
1614 OR g_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE
1615 OR g_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR
1616 OR g_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM
1617 OR g_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR
1618 OR g_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE
1619 OR g_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR
1620 OR g_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE
1621 OR g_PRICE_LIST_LINE_rec.unit_code = FND_API.G_MISS_CHAR
1622 OR g_PRICE_LIST_LINE_rec.list_line_type_code = FND_API.G_MISS_CHAR
1623 THEN
1624
1625 OE_Default_Price_List_Line.Attributes
1626 ( p_PRICE_LIST_LINE_rec => g_PRICE_LIST_LINE_rec
1627 , p_iteration => p_iteration + 1
1628 , x_PRICE_LIST_LINE_rec => x_PRICE_LIST_LINE_rec
1629 );
1630
1631 ELSE
1632
1633 -- Done defaulting attributes
1634
1635 x_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec;
1636
1637 END IF;
1638
1639 END Attributes;
1640
1641
1642
1643 END OE_Default_Price_List_Line;