DBA Data[Home] [Help]

APPS.OE_OE_FORM_PRICE_BREAK dependencies on OE_GLOBALS

Line 82: l_control_rec OE_GLOBALS.Control_Rec_Type;

78: IS
79: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
80: l_Price_Break_val_rec OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type;
81: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
82: l_control_rec OE_GLOBALS.Control_Rec_Type;
83: l_return_status VARCHAR2(1);
84: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
85: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
86: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

Line 145: l_Price_Break_rec.operation := OE_GLOBALS.G_OPR_CREATE;

141: l_Price_Break_rec.context := 'NULL';
142:
143: -- Set Operation to Create
144:
145: l_Price_Break_rec.operation := OE_GLOBALS.G_OPR_CREATE;
146:
147: -- Populate Price_Break table
148:
149: l_Price_Break_tbl(1) := l_Price_Break_rec;

Line 360: l_control_rec OE_GLOBALS.Control_Rec_Type;

356: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
357: l_Price_Break_val_rec OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type;
358: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
359: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
360: l_control_rec OE_GLOBALS.Control_Rec_Type;
361: l_return_status VARCHAR2(1);
362: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
363: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
364: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

Line 476: l_Price_Break_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

472:
473: -- Set Operation.
474:
475: IF FND_API.To_Boolean(l_Price_Break_rec.db_flag) THEN
476: l_Price_Break_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
477: ELSE
478: l_Price_Break_rec.operation := OE_GLOBALS.G_OPR_CREATE;
479: END IF;
480:

Line 478: l_Price_Break_rec.operation := OE_GLOBALS.G_OPR_CREATE;

474:
475: IF FND_API.To_Boolean(l_Price_Break_rec.db_flag) THEN
476: l_Price_Break_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
477: ELSE
478: l_Price_Break_rec.operation := OE_GLOBALS.G_OPR_CREATE;
479: END IF;
480:
481: -- Populate Price_Break table
482:

Line 560: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.amount,

556: );
557:
558: -- Return changed attributes.
559:
560: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.amount,
561: l_Price_Break_rec.amount)
562: THEN
563: x_amount := l_x_Price_Break_rec.amount;
564: END IF;

Line 566: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute1,

562: THEN
563: x_amount := l_x_Price_Break_rec.amount;
564: END IF;
565:
566: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute1,
567: l_Price_Break_rec.attribute1)
568: THEN
569: x_attribute1 := l_x_Price_Break_rec.attribute1;
570: END IF;

Line 572: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute10,

568: THEN
569: x_attribute1 := l_x_Price_Break_rec.attribute1;
570: END IF;
571:
572: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute10,
573: l_Price_Break_rec.attribute10)
574: THEN
575: x_attribute10 := l_x_Price_Break_rec.attribute10;
576: END IF;

Line 578: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute11,

574: THEN
575: x_attribute10 := l_x_Price_Break_rec.attribute10;
576: END IF;
577:
578: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute11,
579: l_Price_Break_rec.attribute11)
580: THEN
581: x_attribute11 := l_x_Price_Break_rec.attribute11;
582: END IF;

Line 584: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute12,

580: THEN
581: x_attribute11 := l_x_Price_Break_rec.attribute11;
582: END IF;
583:
584: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute12,
585: l_Price_Break_rec.attribute12)
586: THEN
587: x_attribute12 := l_x_Price_Break_rec.attribute12;
588: END IF;

Line 590: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute13,

586: THEN
587: x_attribute12 := l_x_Price_Break_rec.attribute12;
588: END IF;
589:
590: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute13,
591: l_Price_Break_rec.attribute13)
592: THEN
593: x_attribute13 := l_x_Price_Break_rec.attribute13;
594: END IF;

Line 596: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute14,

592: THEN
593: x_attribute13 := l_x_Price_Break_rec.attribute13;
594: END IF;
595:
596: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute14,
597: l_Price_Break_rec.attribute14)
598: THEN
599: x_attribute14 := l_x_Price_Break_rec.attribute14;
600: END IF;

Line 602: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute15,

598: THEN
599: x_attribute14 := l_x_Price_Break_rec.attribute14;
600: END IF;
601:
602: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute15,
603: l_Price_Break_rec.attribute15)
604: THEN
605: x_attribute15 := l_x_Price_Break_rec.attribute15;
606: END IF;

Line 608: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute2,

604: THEN
605: x_attribute15 := l_x_Price_Break_rec.attribute15;
606: END IF;
607:
608: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute2,
609: l_Price_Break_rec.attribute2)
610: THEN
611: x_attribute2 := l_x_Price_Break_rec.attribute2;
612: END IF;

Line 614: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute3,

610: THEN
611: x_attribute2 := l_x_Price_Break_rec.attribute2;
612: END IF;
613:
614: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute3,
615: l_Price_Break_rec.attribute3)
616: THEN
617: x_attribute3 := l_x_Price_Break_rec.attribute3;
618: END IF;

Line 620: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute4,

616: THEN
617: x_attribute3 := l_x_Price_Break_rec.attribute3;
618: END IF;
619:
620: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute4,
621: l_Price_Break_rec.attribute4)
622: THEN
623: x_attribute4 := l_x_Price_Break_rec.attribute4;
624: END IF;

Line 626: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute5,

622: THEN
623: x_attribute4 := l_x_Price_Break_rec.attribute4;
624: END IF;
625:
626: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute5,
627: l_Price_Break_rec.attribute5)
628: THEN
629: x_attribute5 := l_x_Price_Break_rec.attribute5;
630: END IF;

Line 632: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute6,

628: THEN
629: x_attribute5 := l_x_Price_Break_rec.attribute5;
630: END IF;
631:
632: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute6,
633: l_Price_Break_rec.attribute6)
634: THEN
635: x_attribute6 := l_x_Price_Break_rec.attribute6;
636: END IF;

Line 638: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute7,

634: THEN
635: x_attribute6 := l_x_Price_Break_rec.attribute6;
636: END IF;
637:
638: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute7,
639: l_Price_Break_rec.attribute7)
640: THEN
641: x_attribute7 := l_x_Price_Break_rec.attribute7;
642: END IF;

Line 644: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute8,

640: THEN
641: x_attribute7 := l_x_Price_Break_rec.attribute7;
642: END IF;
643:
644: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute8,
645: l_Price_Break_rec.attribute8)
646: THEN
647: x_attribute8 := l_x_Price_Break_rec.attribute8;
648: END IF;

Line 650: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute9,

646: THEN
647: x_attribute8 := l_x_Price_Break_rec.attribute8;
648: END IF;
649:
650: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.attribute9,
651: l_Price_Break_rec.attribute9)
652: THEN
653: x_attribute9 := l_x_Price_Break_rec.attribute9;
654: END IF;

Line 656: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.context,

652: THEN
653: x_attribute9 := l_x_Price_Break_rec.attribute9;
654: END IF;
655:
656: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.context,
657: l_Price_Break_rec.context)
658: THEN
659: x_context := l_x_Price_Break_rec.context;
660: END IF;

Line 662: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.discount_line_id,

658: THEN
659: x_context := l_x_Price_Break_rec.context;
660: END IF;
661:
662: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.discount_line_id,
663: l_Price_Break_rec.discount_line_id)
664: THEN
665: x_discount_line_id := l_x_Price_Break_rec.discount_line_id;
666: x_discount_line := l_Price_Break_val_rec.discount_line;

Line 669: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.end_date_active,

665: x_discount_line_id := l_x_Price_Break_rec.discount_line_id;
666: x_discount_line := l_Price_Break_val_rec.discount_line;
667: END IF;
668:
669: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.end_date_active,
670: l_Price_Break_rec.end_date_active)
671: THEN
672: x_end_date_active := l_x_Price_Break_rec.end_date_active;
673: END IF;

Line 675: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.method_type_code,

671: THEN
672: x_end_date_active := l_x_Price_Break_rec.end_date_active;
673: END IF;
674:
675: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.method_type_code,
676: l_Price_Break_rec.method_type_code)
677: THEN
678: x_method_type_code := l_x_Price_Break_rec.method_type_code;
679: x_method_type := l_Price_Break_val_rec.method_type;

Line 682: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.percent,

678: x_method_type_code := l_x_Price_Break_rec.method_type_code;
679: x_method_type := l_Price_Break_val_rec.method_type;
680: END IF;
681:
682: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.percent,
683: l_Price_Break_rec.percent)
684: THEN
685: x_percent := l_x_Price_Break_rec.percent;
686: END IF;

Line 688: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.price,

684: THEN
685: x_percent := l_x_Price_Break_rec.percent;
686: END IF;
687:
688: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.price,
689: l_Price_Break_rec.price)
690: THEN
691: x_price := l_x_Price_Break_rec.price;
692: END IF;

Line 694: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.price_break_high,

690: THEN
691: x_price := l_x_Price_Break_rec.price;
692: END IF;
693:
694: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.price_break_high,
695: l_Price_Break_rec.price_break_high)
696: THEN
697: x_price_break_high := l_x_Price_Break_rec.price_break_high;
698: END IF;

Line 700: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.price_break_low,

696: THEN
697: x_price_break_high := l_x_Price_Break_rec.price_break_high;
698: END IF;
699:
700: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.price_break_low,
701: l_Price_Break_rec.price_break_low)
702: THEN
703: x_price_break_low := l_x_Price_Break_rec.price_break_low;
704: END IF;

Line 706: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.start_date_active,

702: THEN
703: x_price_break_low := l_x_Price_Break_rec.price_break_low;
704: END IF;
705:
706: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.start_date_active,
707: l_Price_Break_rec.start_date_active)
708: THEN
709: x_start_date_active := l_x_Price_Break_rec.start_date_active;
710: END IF;

Line 712: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.unit_code,

708: THEN
709: x_start_date_active := l_x_Price_Break_rec.start_date_active;
710: END IF;
711:
712: IF NOT OE_GLOBALS.Equal(l_x_Price_Break_rec.unit_code,
713: l_Price_Break_rec.unit_code)
714: THEN
715: x_unit_code := l_x_Price_Break_rec.unit_code;
716: x_unit := l_Price_Break_val_rec.unit;

Line 807: l_control_rec OE_GLOBALS.Control_Rec_Type;

803: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
804: l_old_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
805: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
806: l_old_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
807: l_control_rec OE_GLOBALS.Control_Rec_Type;
808: l_return_status VARCHAR2(1);
809: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
810: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
811: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

Line 877: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_CREATE;

873: ---------------------------------------------
874: -- Load Price List Line records for price breaks
875: ---------------------------------------------
876:
877: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_CREATE;
878: l_Price_LLine_rec.db_flag := FND_API.G_FALSE;
879:
880: select sysdate into l_Price_LLine_rec.creation_date
881: from dual;

Line 1164: l_control_rec OE_GLOBALS.Control_Rec_Type;

1160: )
1161: IS
1162: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1163: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
1164: l_control_rec OE_GLOBALS.Control_Rec_Type;
1165: l_return_status VARCHAR2(1);
1166: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1167: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1168: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

Line 1207: l_Price_Break_rec.operation := OE_GLOBALS.G_OPR_DELETE;

1203: );
1204:
1205: -- Set Operation.
1206:
1207: l_Price_Break_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1208:
1209: -- Populate Price_Break table
1210:
1211: l_Price_Break_tbl(1) := l_Price_Break_rec;

Line 1310: l_control_rec OE_GLOBALS.Control_Rec_Type;

1306: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1307: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1308: )
1309: IS
1310: l_control_rec OE_GLOBALS.Control_Rec_Type;
1311: l_return_status VARCHAR2(1);
1312: l_x_Contract_rec OE_Pricing_Cont_PUB.Contract_Rec_Type;
1313: l_x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
1314: l_x_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

Line 1330: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_PRICE_BREAK;

1326: -- Set control flags.
1327:
1328: l_control_rec.controlled_operation := TRUE;
1329: l_control_rec.process := TRUE;
1330: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_PRICE_BREAK;
1331:
1332: l_control_rec.default_attributes := FALSE;
1333: l_control_rec.change_attributes := FALSE;
1334: l_control_rec.validate_entity := FALSE;