15:
16: FUNCTION Get_List_Header(p_list_line_id IN NUMBER)
17: RETURN VARCHAR2
18: IS
19: l_list_header_id NUMBER := FND_API.G_MISS_NUM;
20: BEGIN
21:
22: /*
23: IF p_list_line_id <> FND_API.G_MISS_NUM THEN
19: l_list_header_id NUMBER := FND_API.G_MISS_NUM;
20: BEGIN
21:
22: /*
23: IF p_list_line_id <> FND_API.G_MISS_NUM THEN
24:
25: select list_header_id into l_list_header_id from qp_list_lines where list_line_id = p_list_line_id;
26:
27: RETURN l_list_header_id;
43:
44: FUNCTION Get_Pricing_Phase(p_list_line_id IN NUMBER)
45: RETURN VARCHAR2
46: IS
47: l_pricing_phase_id NUMBER := FND_API.G_MISS_NUM;
48: BEGIN
49:
50: /*
51: IF p_list_line_id <> FND_API.G_MISS_NUM THEN
47: l_pricing_phase_id NUMBER := FND_API.G_MISS_NUM;
48: BEGIN
49:
50: /*
51: IF p_list_line_id <> FND_API.G_MISS_NUM THEN
52:
53: select pricing_phase_id into l_pricing_phase_id from qp_list_lines where list_line_id = p_list_line_id;
54:
55: RETURN l_pricing_phase_id;
89:
90: FUNCTION Get_Attribute_Grouping_No
91: RETURN NUMBER
92: IS
93: l_attribute_grouping_no NUMBER := FND_API.G_MISS_NUM;
94: BEGIN
95:
96:
97: select QP_PRICING_ATTR_GROUP_NO_S.nextval
122:
123: FUNCTION Get_Pricing_Attribute
124: RETURN VARCHAR2
125: IS
126: l_pricing_attribute_id NUMBER := FND_API.G_MISS_NUM;
127: BEGIN
128:
129: select QP_PRICING_ATTRIBUTES_S.nextval
130: into l_pricing_attribute_id
300: oe_debug_pub.add('BEGIN Get_Flex_Pricing_Attr in QPXDPRAB');
301:
302: -- In the future call Flex APIs for defaults
303:
304: IF g_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN
305: g_PRICING_ATTR_rec.attribute1 := NULL;
306: END IF;
307:
308: IF g_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN
304: IF g_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN
305: g_PRICING_ATTR_rec.attribute1 := NULL;
306: END IF;
307:
308: IF g_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN
309: g_PRICING_ATTR_rec.attribute10 := NULL;
310: END IF;
311:
312: IF g_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN
308: IF g_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN
309: g_PRICING_ATTR_rec.attribute10 := NULL;
310: END IF;
311:
312: IF g_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN
313: g_PRICING_ATTR_rec.attribute11 := NULL;
314: END IF;
315:
316: IF g_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN
312: IF g_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN
313: g_PRICING_ATTR_rec.attribute11 := NULL;
314: END IF;
315:
316: IF g_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN
317: g_PRICING_ATTR_rec.attribute12 := NULL;
318: END IF;
319:
320: IF g_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN
316: IF g_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN
317: g_PRICING_ATTR_rec.attribute12 := NULL;
318: END IF;
319:
320: IF g_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN
321: g_PRICING_ATTR_rec.attribute13 := NULL;
322: END IF;
323:
324: IF g_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN
320: IF g_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN
321: g_PRICING_ATTR_rec.attribute13 := NULL;
322: END IF;
323:
324: IF g_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN
325: g_PRICING_ATTR_rec.attribute14 := NULL;
326: END IF;
327:
328: IF g_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN
324: IF g_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN
325: g_PRICING_ATTR_rec.attribute14 := NULL;
326: END IF;
327:
328: IF g_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN
329: g_PRICING_ATTR_rec.attribute15 := NULL;
330: END IF;
331:
332: IF g_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN
328: IF g_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN
329: g_PRICING_ATTR_rec.attribute15 := NULL;
330: END IF;
331:
332: IF g_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN
333: g_PRICING_ATTR_rec.attribute2 := NULL;
334: END IF;
335:
336: IF g_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN
332: IF g_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN
333: g_PRICING_ATTR_rec.attribute2 := NULL;
334: END IF;
335:
336: IF g_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN
337: g_PRICING_ATTR_rec.attribute3 := NULL;
338: END IF;
339:
340: IF g_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN
336: IF g_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN
337: g_PRICING_ATTR_rec.attribute3 := NULL;
338: END IF;
339:
340: IF g_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN
341: g_PRICING_ATTR_rec.attribute4 := NULL;
342: END IF;
343:
344: IF g_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN
340: IF g_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN
341: g_PRICING_ATTR_rec.attribute4 := NULL;
342: END IF;
343:
344: IF g_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN
345: g_PRICING_ATTR_rec.attribute5 := NULL;
346: END IF;
347:
348: IF g_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN
344: IF g_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN
345: g_PRICING_ATTR_rec.attribute5 := NULL;
346: END IF;
347:
348: IF g_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN
349: g_PRICING_ATTR_rec.attribute6 := NULL;
350: END IF;
351:
352: IF g_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN
348: IF g_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN
349: g_PRICING_ATTR_rec.attribute6 := NULL;
350: END IF;
351:
352: IF g_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN
353: g_PRICING_ATTR_rec.attribute7 := NULL;
354: END IF;
355:
356: IF g_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN
352: IF g_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN
353: g_PRICING_ATTR_rec.attribute7 := NULL;
354: END IF;
355:
356: IF g_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN
357: g_PRICING_ATTR_rec.attribute8 := NULL;
358: END IF;
359:
360: IF g_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN
356: IF g_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN
357: g_PRICING_ATTR_rec.attribute8 := NULL;
358: END IF;
359:
360: IF g_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN
361: g_PRICING_ATTR_rec.attribute9 := NULL;
362: END IF;
363:
364: IF g_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN
360: IF g_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN
361: g_PRICING_ATTR_rec.attribute9 := NULL;
362: END IF;
363:
364: IF g_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN
365: g_PRICING_ATTR_rec.context := NULL;
366: END IF;
367:
368: oe_debug_pub.add('END Get_Flex_Pricing_Attr in QPXDPRAB');
394: OE_MSG_PUB.Add;
395:
396: END IF;
397:
398: RAISE FND_API.G_EXC_ERROR;
399:
400: END IF;
401:
402: -- Initialize g_PRICING_ATTR_rec
404: g_PRICING_ATTR_rec := p_PRICING_ATTR_rec;
405:
406: -- Default missing attributes.
407:
408: IF g_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
409:
410: g_PRICING_ATTR_rec.accumulate_flag := Get_Accumulate;
411:
412: IF g_PRICING_ATTR_rec.accumulate_flag IS NOT NULL THEN
426: END IF;
427:
428: END IF;
429:
430: IF g_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN
431:
432: g_PRICING_ATTR_rec.attribute_grouping_no := Get_Attribute_Grouping_No;
433:
434: IF g_PRICING_ATTR_rec.attribute_grouping_no IS NOT NULL THEN
448: END IF;
449:
450: END IF;
451:
452: IF g_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
453:
454: g_PRICING_ATTR_rec.excluder_flag := Get_Excluder;
455:
456: IF g_PRICING_ATTR_rec.excluder_flag IS NOT NULL THEN
470: END IF;
471:
472: END IF;
473:
474: IF g_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM OR
475: g_PRICING_ATTR_rec.list_header_id IS NULL THEN
476:
477: g_PRICING_ATTR_rec.list_header_id := Get_List_Header(p_PRICING_ATTR_rec.list_line_id);
478:
493: END IF;
494:
495: END IF;
496:
497: IF g_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM OR
498: g_PRICING_ATTR_rec.list_header_id IS NULL THEN
499:
500: g_PRICING_ATTR_rec.pricing_phase_id := Get_Pricing_phase(p_PRICING_ATTR_rec.pricing_phase_id);
501:
516: END IF;
517:
518: END IF;
519:
520: IF g_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
521:
522: g_PRICING_ATTR_rec.list_line_id := Get_List_Line;
523:
524: IF g_PRICING_ATTR_rec.list_line_id IS NOT NULL THEN
538: END IF;
539:
540: END IF;
541:
542: IF g_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
543:
544: g_PRICING_ATTR_rec.pricing_attribute := NULL;
545:
546: IF g_PRICING_ATTR_rec.pricing_attribute IS NOT NULL THEN
560: END IF;
561:
562: END IF;
563:
564: IF g_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN
565:
566: g_PRICING_ATTR_rec.pricing_attribute_context := Get_Pricing_Attribute_Context;
567:
568: IF g_PRICING_ATTR_rec.pricing_attribute_context IS NOT NULL THEN
582: END IF;
583:
584: END IF;
585:
586: IF g_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
587:
588: g_PRICING_ATTR_rec.pricing_attribute_id := Get_Pricing_Attribute;
589:
590: IF g_PRICING_ATTR_rec.pricing_attribute_id IS NOT NULL THEN
604: END IF;
605:
606: END IF;
607:
608: IF g_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
609:
610: g_PRICING_ATTR_rec.pricing_attr_value_from := Get_Pricing_Attr_Value_From;
611:
612: IF g_PRICING_ATTR_rec.pricing_attr_value_from IS NOT NULL THEN
626: END IF;
627:
628: END IF;
629:
630: IF g_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
631:
632: g_PRICING_ATTR_rec.pricing_attr_value_to := Get_Pricing_Attr_Value_To;
633:
634: IF g_PRICING_ATTR_rec.pricing_attr_value_to IS NOT NULL THEN
648: END IF;
649:
650: END IF;
651:
652: IF g_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN
653:
654: g_PRICING_ATTR_rec.product_attribute := Get_Product_Attribute;
655:
656: IF g_PRICING_ATTR_rec.product_attribute IS NOT NULL THEN
670: END IF;
671:
672: END IF;
673:
674: IF g_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN
675:
676: g_PRICING_ATTR_rec.product_attribute_context := Get_Product_Attribute_Context;
677:
678: IF g_PRICING_ATTR_rec.product_attribute_context IS NOT NULL THEN
692: END IF;
693:
694: END IF;
695:
696: IF g_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN
697:
698: g_PRICING_ATTR_rec.product_attr_value := Get_Product_Attr_Value;
699:
700: IF g_PRICING_ATTR_rec.product_attr_value IS NOT NULL THEN
714: END IF;
715:
716: END IF;
717:
718: IF g_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
719:
720: g_PRICING_ATTR_rec.product_uom_code := Get_Product_Uom;
721:
722: IF g_PRICING_ATTR_rec.product_uom_code IS NOT NULL THEN
736: END IF;
737:
738: END IF;
739:
740: IF g_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN
741:
742: g_PRICING_ATTR_rec.product_attribute_datatype :=
743: Get_Product_Attribute_Datatype(p_PRICING_ATTR_rec.product_attribute_context,
744: p_PRICING_ATTR_rec.product_attribute,
761: END IF;
762:
763: END IF;
764:
765: IF g_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN
766:
767: g_PRICING_ATTR_rec.pricing_attribute_datatype :=
768: Get_Pricing_Attribute_Datatype(p_PRICING_ATTR_rec.pricing_attribute_context,
769: p_PRICING_ATTR_rec.pricing_attribute,
786: END IF;
787:
788: END IF;
789:
790: IF g_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
791:
792: g_PRICING_ATTR_rec.comparison_operator_code := Get_Comparison_Operator;
793:
794: IF g_PRICING_ATTR_rec.comparison_operator_code IS NOT NULL THEN
809:
810: END IF;
811:
812: OE_Debug_Pub.add('In if loop in Attributes QPXDPRAB.pls');
813: IF g_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR
814: OR g_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR
815: OR g_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR
816: OR g_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR
817: OR g_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR
810: END IF;
811:
812: OE_Debug_Pub.add('In if loop in Attributes QPXDPRAB.pls');
813: IF g_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR
814: OR g_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR
815: OR g_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR
816: OR g_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR
817: OR g_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR
818: OR g_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR
811:
812: OE_Debug_Pub.add('In if loop in Attributes QPXDPRAB.pls');
813: IF g_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR
814: OR g_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR
815: OR g_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR
816: OR g_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR
817: OR g_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR
818: OR g_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR
819: OR g_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR
812: OE_Debug_Pub.add('In if loop in Attributes QPXDPRAB.pls');
813: IF g_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR
814: OR g_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR
815: OR g_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR
816: OR g_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR
817: OR g_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR
818: OR g_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR
819: OR g_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR
820: OR g_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR
813: IF g_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR
814: OR g_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR
815: OR g_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR
816: OR g_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR
817: OR g_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR
818: OR g_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR
819: OR g_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR
820: OR g_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR
821: OR g_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR
814: OR g_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR
815: OR g_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR
816: OR g_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR
817: OR g_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR
818: OR g_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR
819: OR g_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR
820: OR g_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR
821: OR g_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR
822: OR g_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR
815: OR g_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR
816: OR g_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR
817: OR g_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR
818: OR g_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR
819: OR g_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR
820: OR g_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR
821: OR g_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR
822: OR g_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR
823: OR g_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR
816: OR g_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR
817: OR g_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR
818: OR g_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR
819: OR g_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR
820: OR g_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR
821: OR g_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR
822: OR g_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR
823: OR g_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR
824: OR g_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR
817: OR g_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR
818: OR g_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR
819: OR g_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR
820: OR g_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR
821: OR g_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR
822: OR g_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR
823: OR g_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR
824: OR g_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR
825: OR g_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR
818: OR g_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR
819: OR g_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR
820: OR g_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR
821: OR g_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR
822: OR g_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR
823: OR g_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR
824: OR g_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR
825: OR g_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR
826: OR g_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR
819: OR g_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR
820: OR g_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR
821: OR g_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR
822: OR g_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR
823: OR g_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR
824: OR g_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR
825: OR g_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR
826: OR g_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR
827: OR g_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR
820: OR g_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR
821: OR g_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR
822: OR g_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR
823: OR g_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR
824: OR g_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR
825: OR g_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR
826: OR g_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR
827: OR g_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR
828: OR g_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR
821: OR g_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR
822: OR g_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR
823: OR g_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR
824: OR g_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR
825: OR g_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR
826: OR g_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR
827: OR g_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR
828: OR g_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR
829: THEN
822: OR g_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR
823: OR g_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR
824: OR g_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR
825: OR g_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR
826: OR g_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR
827: OR g_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR
828: OR g_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR
829: THEN
830:
823: OR g_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR
824: OR g_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR
825: OR g_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR
826: OR g_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR
827: OR g_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR
828: OR g_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR
829: THEN
830:
831: Get_Flex_Pricing_Attr;
824: OR g_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR
825: OR g_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR
826: OR g_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR
827: OR g_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR
828: OR g_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR
829: THEN
830:
831: Get_Flex_Pricing_Attr;
832:
831: Get_Flex_Pricing_Attr;
832:
833: END IF;
834:
835: IF g_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN
836:
837: g_PRICING_ATTR_rec.created_by := NULL;
838:
839: END IF;
837: g_PRICING_ATTR_rec.created_by := NULL;
838:
839: END IF;
840:
841: IF g_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN
842:
843: g_PRICING_ATTR_rec.creation_date := NULL;
844:
845: END IF;
843: g_PRICING_ATTR_rec.creation_date := NULL;
844:
845: END IF;
846:
847: IF g_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN
848:
849: g_PRICING_ATTR_rec.last_updated_by := NULL;
850:
851: END IF;
849: g_PRICING_ATTR_rec.last_updated_by := NULL;
850:
851: END IF;
852:
853: IF g_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN
854:
855: g_PRICING_ATTR_rec.last_update_date := NULL;
856:
857: END IF;
855: g_PRICING_ATTR_rec.last_update_date := NULL;
856:
857: END IF;
858:
859: IF g_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN
860:
861: g_PRICING_ATTR_rec.last_update_login := NULL;
862:
863: END IF;
861: g_PRICING_ATTR_rec.last_update_login := NULL;
862:
863: END IF;
864:
865: IF g_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN
866:
867: g_PRICING_ATTR_rec.program_application_id := NULL;
868:
869: END IF;
867: g_PRICING_ATTR_rec.program_application_id := NULL;
868:
869: END IF;
870:
871: IF g_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN
872:
873: g_PRICING_ATTR_rec.program_id := NULL;
874:
875: END IF;
873: g_PRICING_ATTR_rec.program_id := NULL;
874:
875: END IF;
876:
877: IF g_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN
878:
879: g_PRICING_ATTR_rec.program_update_date := NULL;
880:
881: END IF;
879: g_PRICING_ATTR_rec.program_update_date := NULL;
880:
881: END IF;
882:
883: IF g_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN
884:
885: g_PRICING_ATTR_rec.request_id := NULL;
886:
887: END IF;
887: END IF;
888:
889: -- Redefault if there are any missing attributes.
890:
891: IF g_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR
892: OR g_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR
893: OR g_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR
894: OR g_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR
895: OR g_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR
888:
889: -- Redefault if there are any missing attributes.
890:
891: IF g_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR
892: OR g_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR
893: OR g_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR
894: OR g_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR
895: OR g_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR
896: OR g_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR
889: -- Redefault if there are any missing attributes.
890:
891: IF g_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR
892: OR g_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR
893: OR g_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR
894: OR g_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR
895: OR g_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR
896: OR g_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR
897: OR g_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR
890:
891: IF g_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR
892: OR g_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR
893: OR g_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR
894: OR g_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR
895: OR g_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR
896: OR g_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR
897: OR g_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR
898: OR g_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR
891: IF g_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR
892: OR g_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR
893: OR g_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR
894: OR g_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR
895: OR g_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR
896: OR g_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR
897: OR g_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR
898: OR g_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR
899: OR g_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR
892: OR g_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR
893: OR g_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR
894: OR g_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR
895: OR g_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR
896: OR g_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR
897: OR g_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR
898: OR g_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR
899: OR g_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR
900: OR g_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR
893: OR g_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR
894: OR g_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR
895: OR g_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR
896: OR g_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR
897: OR g_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR
898: OR g_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR
899: OR g_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR
900: OR g_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR
901: OR g_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR
894: OR g_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR
895: OR g_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR
896: OR g_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR
897: OR g_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR
898: OR g_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR
899: OR g_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR
900: OR g_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR
901: OR g_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR
902: OR g_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR
895: OR g_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR
896: OR g_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR
897: OR g_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR
898: OR g_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR
899: OR g_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR
900: OR g_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR
901: OR g_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR
902: OR g_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR
903: OR g_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR
896: OR g_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR
897: OR g_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR
898: OR g_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR
899: OR g_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR
900: OR g_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR
901: OR g_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR
902: OR g_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR
903: OR g_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR
904: OR g_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR
897: OR g_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR
898: OR g_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR
899: OR g_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR
900: OR g_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR
901: OR g_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR
902: OR g_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR
903: OR g_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR
904: OR g_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR
905: OR g_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR
898: OR g_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR
899: OR g_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR
900: OR g_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR
901: OR g_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR
902: OR g_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR
903: OR g_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR
904: OR g_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR
905: OR g_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR
906: OR g_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR
899: OR g_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR
900: OR g_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR
901: OR g_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR
902: OR g_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR
903: OR g_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR
904: OR g_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR
905: OR g_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR
906: OR g_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR
907: OR g_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM
900: OR g_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR
901: OR g_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR
902: OR g_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR
903: OR g_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR
904: OR g_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR
905: OR g_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR
906: OR g_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR
907: OR g_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM
908: OR g_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR
901: OR g_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR
902: OR g_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR
903: OR g_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR
904: OR g_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR
905: OR g_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR
906: OR g_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR
907: OR g_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM
908: OR g_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR
909: OR g_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM
902: OR g_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR
903: OR g_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR
904: OR g_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR
905: OR g_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR
906: OR g_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR
907: OR g_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM
908: OR g_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR
909: OR g_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM
910: OR g_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE
903: OR g_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR
904: OR g_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR
905: OR g_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR
906: OR g_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR
907: OR g_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM
908: OR g_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR
909: OR g_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM
910: OR g_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE
911: OR g_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR
904: OR g_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR
905: OR g_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR
906: OR g_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR
907: OR g_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM
908: OR g_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR
909: OR g_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM
910: OR g_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE
911: OR g_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR
912: OR g_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM
905: OR g_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR
906: OR g_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR
907: OR g_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM
908: OR g_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR
909: OR g_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM
910: OR g_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE
911: OR g_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR
912: OR g_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM
913: OR g_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE
906: OR g_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR
907: OR g_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM
908: OR g_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR
909: OR g_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM
910: OR g_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE
911: OR g_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR
912: OR g_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM
913: OR g_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE
914: OR g_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM
907: OR g_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM
908: OR g_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR
909: OR g_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM
910: OR g_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE
911: OR g_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR
912: OR g_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM
913: OR g_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE
914: OR g_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM
915: OR g_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM
908: OR g_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR
909: OR g_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM
910: OR g_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE
911: OR g_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR
912: OR g_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM
913: OR g_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE
914: OR g_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM
915: OR g_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM
916: OR g_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR
909: OR g_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM
910: OR g_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE
911: OR g_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR
912: OR g_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM
913: OR g_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE
914: OR g_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM
915: OR g_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM
916: OR g_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR
917: OR g_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR
910: OR g_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE
911: OR g_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR
912: OR g_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM
913: OR g_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE
914: OR g_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM
915: OR g_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM
916: OR g_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR
917: OR g_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR
918: OR g_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM
911: OR g_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR
912: OR g_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM
913: OR g_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE
914: OR g_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM
915: OR g_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM
916: OR g_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR
917: OR g_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR
918: OR g_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM
919: OR g_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR
912: OR g_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM
913: OR g_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE
914: OR g_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM
915: OR g_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM
916: OR g_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR
917: OR g_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR
918: OR g_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM
919: OR g_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR
920: OR g_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR
913: OR g_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE
914: OR g_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM
915: OR g_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM
916: OR g_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR
917: OR g_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR
918: OR g_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM
919: OR g_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR
920: OR g_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR
921: OR g_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR
914: OR g_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM
915: OR g_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM
916: OR g_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR
917: OR g_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR
918: OR g_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM
919: OR g_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR
920: OR g_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR
921: OR g_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR
922: OR g_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR
915: OR g_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM
916: OR g_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR
917: OR g_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR
918: OR g_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM
919: OR g_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR
920: OR g_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR
921: OR g_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR
922: OR g_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR
923: OR g_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR
916: OR g_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR
917: OR g_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR
918: OR g_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM
919: OR g_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR
920: OR g_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR
921: OR g_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR
922: OR g_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR
923: OR g_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR
924: OR g_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR
917: OR g_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR
918: OR g_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM
919: OR g_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR
920: OR g_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR
921: OR g_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR
922: OR g_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR
923: OR g_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR
924: OR g_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR
925: OR g_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR
918: OR g_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM
919: OR g_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR
920: OR g_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR
921: OR g_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR
922: OR g_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR
923: OR g_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR
924: OR g_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR
925: OR g_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR
926: OR g_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM
919: OR g_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR
920: OR g_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR
921: OR g_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR
922: OR g_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR
923: OR g_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR
924: OR g_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR
925: OR g_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR
926: OR g_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM
927: OR g_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM
920: OR g_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR
921: OR g_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR
922: OR g_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR
923: OR g_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR
924: OR g_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR
925: OR g_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR
926: OR g_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM
927: OR g_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM
928: OR g_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR
921: OR g_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR
922: OR g_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR
923: OR g_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR
924: OR g_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR
925: OR g_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR
926: OR g_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM
927: OR g_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM
928: OR g_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR
929: OR g_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR
922: OR g_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR
923: OR g_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR
924: OR g_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR
925: OR g_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR
926: OR g_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM
927: OR g_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM
928: OR g_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR
929: OR g_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR
930: OR g_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM
923: OR g_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR
924: OR g_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR
925: OR g_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR
926: OR g_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM
927: OR g_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM
928: OR g_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR
929: OR g_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR
930: OR g_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM
931: OR g_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM
924: OR g_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR
925: OR g_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR
926: OR g_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM
927: OR g_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM
928: OR g_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR
929: OR g_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR
930: OR g_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM
931: OR g_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM
932: OR g_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE
925: OR g_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR
926: OR g_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM
927: OR g_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM
928: OR g_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR
929: OR g_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR
930: OR g_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM
931: OR g_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM
932: OR g_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE
933: OR g_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM
926: OR g_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM
927: OR g_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM
928: OR g_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR
929: OR g_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR
930: OR g_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM
931: OR g_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM
932: OR g_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE
933: OR g_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM
934: THEN
927: OR g_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM
928: OR g_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR
929: OR g_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR
930: OR g_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM
931: OR g_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM
932: OR g_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE
933: OR g_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM
934: THEN
935:
928: OR g_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR
929: OR g_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR
930: OR g_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM
931: OR g_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM
932: OR g_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE
933: OR g_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM
934: THEN
935:
936: QP_Default_Pricing_Attr.Attributes
929: OR g_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR
930: OR g_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM
931: OR g_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM
932: OR g_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE
933: OR g_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM
934: THEN
935:
936: QP_Default_Pricing_Attr.Attributes
937: ( p_PRICING_ATTR_rec => g_PRICING_ATTR_rec