[Home] [Help]
193: l_found2 := False;
194: cnt := cnt +1;
195: J := p_line_adj_tbl.first;
196: While J Is Not Null Loop
197: If p_line_adj_tbl(J).price_adjustment_id = l_asso.rltd_price_adj_id AND p_line_adj_tbl(J).operation = OE_GLOBALS.G_OPR_CREATE Then
198: px_line_adj_assoc_tbl(cnt).rltd_adj_index := J;
199: l_found1 := True;
200: ElsIf p_line_adj_tbl(j).price_adjustment_id = l_asso.price_adjustment_id Then
201: px_line_adj_assoc_tbl(cnt).adj_index := J;
202: px_line_adj_assoc_tbl(cnt).price_adjustment_id := fnd_api.g_miss_num;
203: px_line_adj_assoc_tbl(cnt).price_adj_assoc_id := fnd_api.g_miss_num;
204: l_found2 := True;
205: End If;
206: px_line_adj_assoc_tbl(cnt).operation:=OE_GLOBALS.G_OPR_CREATE;
207: Exit When l_found1 and l_found2;
208: J:= p_line_adj_tbl.next(J);
209: End Loop;
210: End Loop;
468: -- , x_Line_Adj_rec OUT nocopy OE_AK_LINE_PRCADJS_V%ROWTYPE
469: )
470: IS
471: l_index NUMBER :=0;
472: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
473: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
474: --
475: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
476: --
469: )
470: IS
471: l_index NUMBER :=0;
472: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
473: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
474: --
475: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
476: --
477: BEGIN
487: END IF;
488: IF p_attr_id = FND_API.G_MISS_NUM THEN
489:
490:
491: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.adjusted_amount,p_old_Line_Adj_rec.adjusted_amount)
492: THEN
493: l_index := l_index + 1;
494: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ADJUSTED_AMOUNT;
495: END IF;
493: l_index := l_index + 1;
494: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ADJUSTED_AMOUNT;
495: END IF;
496:
497: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.pricing_phase_id,p_old_Line_Adj_rec.pricing_phase_id)
498: THEN
499: l_index := l_index + 1;
500: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_PRICING_PHASE_ID;
501: END IF;
501: END IF;
502:
503: -----
504:
505: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.price_adjustment_id,p_old_Line_Adj_rec.price_adjustment_id)
506: THEN
507: l_index := l_index + 1;
508: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_PRICE_ADJUSTMENT;
509: END IF;
507: l_index := l_index + 1;
508: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_PRICE_ADJUSTMENT;
509: END IF;
510:
511: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.creation_date,p_old_Line_Adj_rec.creation_date)
512: THEN
513: l_index := l_index + 1;
514: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_CREATION_DATE;
515: END IF;
513: l_index := l_index + 1;
514: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_CREATION_DATE;
515: END IF;
516:
517: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.created_by,p_old_Line_Adj_rec.created_by)
518: THEN
519: l_index := l_index + 1;
520: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_CREATED_BY;
521: END IF;
519: l_index := l_index + 1;
520: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_CREATED_BY;
521: END IF;
522:
523: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.last_update_date,p_old_Line_Adj_rec.last_update_date)
524: THEN
525: l_index := l_index + 1;
526: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_LAST_UPDATE_DATE;
527: END IF;
525: l_index := l_index + 1;
526: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_LAST_UPDATE_DATE;
527: END IF;
528:
529: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.last_updated_by,p_old_Line_Adj_rec.last_updated_by)
530: THEN
531: l_index := l_index + 1;
532: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_LAST_UPDATED_BY;
533: END IF;
531: l_index := l_index + 1;
532: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_LAST_UPDATED_BY;
533: END IF;
534:
535: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.last_update_login,p_old_Line_Adj_rec.last_update_login)
536: THEN
537: l_index := l_index + 1;
538: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_LAST_UPDATE_LOGIN;
539: END IF;
537: l_index := l_index + 1;
538: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_LAST_UPDATE_LOGIN;
539: END IF;
540:
541: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.program_application_id,p_old_Line_Adj_rec.program_application_id)
542: THEN
543: l_index := l_index + 1;
544: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_PROGRAM_APPLICATION;
545: END IF;
543: l_index := l_index + 1;
544: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_PROGRAM_APPLICATION;
545: END IF;
546:
547: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.program_id,p_old_Line_Adj_rec.program_id)
548: THEN
549: l_index := l_index + 1;
550: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_PROGRAM;
551: END IF;
549: l_index := l_index + 1;
550: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_PROGRAM;
551: END IF;
552:
553: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.program_update_date,p_old_Line_Adj_rec.program_update_date)
554: THEN
555: l_index := l_index + 1;
556: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_PROGRAM_UPDATE_DATE;
557: END IF;
555: l_index := l_index + 1;
556: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_PROGRAM_UPDATE_DATE;
557: END IF;
558:
559: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.request_id,p_old_Line_Adj_rec.request_id)
560: THEN
561: l_index := l_index + 1;
562: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_REQUEST;
563: END IF;
561: l_index := l_index + 1;
562: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_REQUEST;
563: END IF;
564:
565: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.header_id,p_old_Line_Adj_rec.header_id)
566: THEN
567: l_index := l_index + 1;
568: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_HEADER;
569: END IF;
567: l_index := l_index + 1;
568: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_HEADER;
569: END IF;
570:
571: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.discount_id,p_old_Line_Adj_rec.discount_id)
572: THEN
573: l_index := l_index + 1;
574: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_DISCOUNT;
575: END IF;
573: l_index := l_index + 1;
574: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_DISCOUNT;
575: END IF;
576:
577: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.discount_line_id,p_old_Line_Adj_rec.discount_line_id)
578: THEN
579: l_index := l_index + 1;
580: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_DISCOUNT_LINE;
581: END IF;
579: l_index := l_index + 1;
580: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_DISCOUNT_LINE;
581: END IF;
582:
583: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.automatic_flag,p_old_Line_Adj_rec.automatic_flag)
584: THEN
585: l_index := l_index + 1;
586: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_AUTOMATIC;
587: END IF;
585: l_index := l_index + 1;
586: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_AUTOMATIC;
587: END IF;
588:
589: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.percent,p_old_Line_Adj_rec.percent)
590: THEN
591: l_index := l_index + 1;
592: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_PERCENT;
593: END IF;
591: l_index := l_index + 1;
592: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_PERCENT;
593: END IF;
594:
595: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.line_id,p_old_Line_Adj_rec.line_id)
596: THEN
597: l_index := l_index + 1;
598: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_LINE;
599: END IF;
597: l_index := l_index + 1;
598: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_LINE;
599: END IF;
600:
601: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.context,p_old_Line_Adj_rec.context)
602: THEN
603: l_index := l_index + 1;
604: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_CONTEXT;
605: END IF;
603: l_index := l_index + 1;
604: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_CONTEXT;
605: END IF;
606:
607: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute1,p_old_Line_Adj_rec.attribute1)
608: THEN
609: l_index := l_index + 1;
610: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE1;
611: END IF;
609: l_index := l_index + 1;
610: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE1;
611: END IF;
612:
613: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute2,p_old_Line_Adj_rec.attribute2)
614: THEN
615: l_index := l_index + 1;
616: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE2;
617: END IF;
615: l_index := l_index + 1;
616: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE2;
617: END IF;
618:
619: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute3,p_old_Line_Adj_rec.attribute3)
620: THEN
621: l_index := l_index + 1;
622: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE3;
623: END IF;
621: l_index := l_index + 1;
622: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE3;
623: END IF;
624:
625: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute4,p_old_Line_Adj_rec.attribute4)
626: THEN
627: l_index := l_index + 1;
628: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE4;
629: END IF;
627: l_index := l_index + 1;
628: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE4;
629: END IF;
630:
631: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute5,p_old_Line_Adj_rec.attribute5)
632: THEN
633: l_index := l_index + 1;
634: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE5;
635: END IF;
633: l_index := l_index + 1;
634: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE5;
635: END IF;
636:
637: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute6,p_old_Line_Adj_rec.attribute6)
638: THEN
639: l_index := l_index + 1;
640: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE6;
641: END IF;
639: l_index := l_index + 1;
640: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE6;
641: END IF;
642:
643: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute7,p_old_Line_Adj_rec.attribute7)
644: THEN
645: l_index := l_index + 1;
646: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE7;
647: END IF;
645: l_index := l_index + 1;
646: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE7;
647: END IF;
648:
649: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute8,p_old_Line_Adj_rec.attribute8)
650: THEN
651: l_index := l_index + 1;
652: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE8;
653: END IF;
651: l_index := l_index + 1;
652: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE8;
653: END IF;
654:
655: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute9,p_old_Line_Adj_rec.attribute9)
656: THEN
657: l_index := l_index + 1;
658: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE9;
659: END IF;
657: l_index := l_index + 1;
658: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE9;
659: END IF;
660:
661: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute10,p_old_Line_Adj_rec.attribute10)
662: THEN
663: l_index := l_index + 1;
664: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE10;
665: END IF;
663: l_index := l_index + 1;
664: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE10;
665: END IF;
666:
667: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute11,p_old_Line_Adj_rec.attribute11)
668: THEN
669: l_index := l_index + 1;
670: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE11;
671: END IF;
669: l_index := l_index + 1;
670: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE11;
671: END IF;
672:
673: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute12,p_old_Line_Adj_rec.attribute12)
674: THEN
675: l_index := l_index + 1;
676: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE12;
677: END IF;
675: l_index := l_index + 1;
676: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE12;
677: END IF;
678:
679: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute13,p_old_Line_Adj_rec.attribute13)
680: THEN
681: l_index := l_index + 1;
682: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE13;
683: END IF;
681: l_index := l_index + 1;
682: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE13;
683: END IF;
684:
685: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute14,p_old_Line_Adj_rec.attribute14)
686: THEN
687: l_index := l_index + 1;
688: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE14;
689: END IF;
687: l_index := l_index + 1;
688: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE14;
689: END IF;
690:
691: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute15,p_old_Line_Adj_rec.attribute15)
692: THEN
693: l_index := l_index + 1;
694: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE15;
695: END IF;
693: l_index := l_index + 1;
694: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ATTRIBUTE15;
695: END IF;
696:
697: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.COST_ID, p_old_Line_Adj_rec.COST_ID)
698: THEN
699: l_index := l_index + 1;
700: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_COST_ID;
701: END IF;
699: l_index := l_index + 1;
700: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_COST_ID;
701: END IF;
702:
703: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.TAX_CODE, p_old_Line_Adj_rec.TAX_CODE)
704: THEN
705: l_index := l_index + 1;
706: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_TAX_CODE;
707: END IF;
705: l_index := l_index + 1;
706: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_TAX_CODE;
707: END IF;
708:
709: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.TAX_EXEMPT_FLAG, p_old_Line_Adj_rec.TAX_EXEMPT_FLAG)
710: THEN
711: l_index := l_index + 1;
712: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_TAX_EXEMPT_FLAG;
713: END IF;
711: l_index := l_index + 1;
712: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_TAX_EXEMPT_FLAG;
713: END IF;
714:
715: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.TAX_EXEMPT_NUMBER, p_old_Line_Adj_rec.TAX_EXEMPT_NUMBER)
716: THEN
717: l_index := l_index + 1;
718: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_TAX_EXEMPT_NUMBER;
719: END IF;
717: l_index := l_index + 1;
718: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_TAX_EXEMPT_NUMBER;
719: END IF;
720:
721: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.TAX_EXEMPT_REASON_CODE, p_old_Line_Adj_rec.TAX_EXEMPT_REASON_CODE)
722: THEN
723: l_index := l_index + 1;
724: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_TAX_EXEMPT_REASON_CODE;
725: END IF;
723: l_index := l_index + 1;
724: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_TAX_EXEMPT_REASON_CODE;
725: END IF;
726:
727: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.PARENT_ADJUSTMENT_ID, p_old_Line_Adj_rec.PARENT_ADJUSTMENT_ID)
728: THEN
729: l_index := l_index + 1;
730: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_PARENT_ADJUSTMENT_ID;
731: END IF;
729: l_index := l_index + 1;
730: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_PARENT_ADJUSTMENT_ID;
731: END IF;
732:
733: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.INVOICED_FLAG, p_old_Line_Adj_rec.INVOICED_FLAG)
734: THEN
735: l_index := l_index + 1;
736: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_INVOICED_FLAG;
737: END IF;
735: l_index := l_index + 1;
736: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_INVOICED_FLAG;
737: END IF;
738:
739: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.ESTIMATED_FLAG, p_old_Line_Adj_rec.ESTIMATED_FLAG)
740: THEN
741: l_index := l_index + 1;
742: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ESTIMATED_FLAG;
743: END IF;
741: l_index := l_index + 1;
742: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_ESTIMATED_FLAG;
743: END IF;
744:
745: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.INC_IN_SALES_PERFORMANCE, p_old_Line_Adj_rec.INC_IN_SALES_PERFORMANCE)
746: THEN
747: l_index := l_index + 1;
748: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_INC_IN_SALES_PERFORMANCE;
749: END IF;
747: l_index := l_index + 1;
748: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_INC_IN_SALES_PERFORMANCE;
749: END IF;
750:
751: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.SPLIT_ACTION_CODE, p_old_Line_Adj_rec.SPLIT_ACTION_CODE)
752: THEN
753: l_index := l_index + 1;
754: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_SPLIT_ACTION_CODE;
755: END IF;
753: l_index := l_index + 1;
754: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_SPLIT_ACTION_CODE;
755: END IF;
756:
757: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.CHARGE_TYPE_CODE, p_old_Line_Adj_rec.CHARGE_TYPE_CODE)
758: THEN
759: l_index := l_index + 1;
760: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_CHARGE_TYPE_CODE;
761: END IF;
759: l_index := l_index + 1;
760: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_CHARGE_TYPE_CODE;
761: END IF;
762:
763: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.CHARGE_SUBTYPE_CODE, p_old_Line_Adj_rec.CHARGE_SUBTYPE_CODE)
764: THEN
765: l_index := l_index + 1;
766: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_CHARGE_SUBTYPE_CODE;
767: END IF;
765: l_index := l_index + 1;
766: l_src_attr_tbl(l_index) := OE_LINE_ADJ_UTIL.G_CHARGE_SUBTYPE_CODE;
767: END IF;
768:
769: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.list_line_no, p_old_Line_Adj_rec.list_line_no)
770: THEN
771: l_index := l_index + 1;
772: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_LIST_LINE_NO;
773: END IF;
771: l_index := l_index + 1;
772: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_LIST_LINE_NO;
773: END IF;
774:
775: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.source_system_code, p_old_Line_Adj_rec.source_system_code)
776: THEN
777: l_index := l_index + 1;
778: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_SOURCE_SYSTEM_CODE;
779: END IF;
777: l_index := l_index + 1;
778: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_SOURCE_SYSTEM_CODE;
779: END IF;
780:
781: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.benefit_qty, p_old_Line_Adj_rec.benefit_qty)
782: THEN
783: l_index := l_index + 1;
784: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_BENEFIT_QTY;
785: END IF;
783: l_index := l_index + 1;
784: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_BENEFIT_QTY;
785: END IF;
786:
787: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.benefit_uom_code, p_old_Line_Adj_rec.benefit_uom_code)
788: THEN
789: l_index := l_index + 1;
790: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_BENEFIT_UOM_CODE;
791: END IF;
789: l_index := l_index + 1;
790: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_BENEFIT_UOM_CODE;
791: END IF;
792:
793: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.print_on_invoice_flag, p_old_Line_Adj_rec.print_on_invoice_flag)
794: THEN
795: l_index := l_index + 1;
796: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_PRINT_ON_INVOICE_FLAG;
797: END IF;
795: l_index := l_index + 1;
796: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_PRINT_ON_INVOICE_FLAG;
797: END IF;
798:
799: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.expiration_date, p_old_Line_Adj_rec.expiration_date)
800: THEN
801: l_index := l_index + 1;
802: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_EXPIRATION_DATE;
803: END IF;
801: l_index := l_index + 1;
802: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_EXPIRATION_DATE;
803: END IF;
804:
805: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.rebate_transaction_type_code, p_old_Line_Adj_rec.rebate_transaction_type_code)
806: THEN
807: l_index := l_index + 1;
808: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_REBATE_TRANSACTION_TYPE_CODE;
809: END IF;
807: l_index := l_index + 1;
808: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_REBATE_TRANSACTION_TYPE_CODE;
809: END IF;
810:
811: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.rebate_transaction_reference, p_old_Line_Adj_rec.rebate_transaction_reference)
812: THEN
813: l_index := l_index + 1;
814: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_REBATE_TRANSACTION_REFERENCE;
815: END IF;
813: l_index := l_index + 1;
814: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_REBATE_TRANSACTION_REFERENCE;
815: END IF;
816:
817: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.rebate_payment_system_code, p_old_Line_Adj_rec.rebate_payment_system_code)
818: THEN
819: l_index := l_index + 1;
820: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_REBATE_PAYMENT_SYSTEM_CODE;
821: END IF;
819: l_index := l_index + 1;
820: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_REBATE_PAYMENT_SYSTEM_CODE;
821: END IF;
822:
823: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.redeemed_date, p_old_Line_Adj_rec.redeemed_date)
824: THEN
825: l_index := l_index + 1;
826: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_REDEEMED_DATE;
827: END IF;
825: l_index := l_index + 1;
826: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_REDEEMED_DATE;
827: END IF;
828:
829: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.redeemed_flag, p_old_Line_Adj_rec.redeemed_flag)
830: THEN
831: l_index := l_index + 1;
832: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_REDEEMED_FLAG;
833: END IF;
831: l_index := l_index + 1;
832: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_REDEEMED_FLAG;
833: END IF;
834:
835: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.accrual_flag, p_old_Line_Adj_rec.accrual_flag)
836: THEN
837: l_index := l_index + 1;
838: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_ACCRUAL_FLAG;
839: END IF;
837: l_index := l_index + 1;
838: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_ACCRUAL_FLAG;
839: END IF;
840:
841: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.range_break_quantity, p_old_Line_Adj_rec.range_break_quantity)
842: THEN
843: l_index := l_index + 1;
844: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_range_break_quantity;
845: END IF;
843: l_index := l_index + 1;
844: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_range_break_quantity;
845: END IF;
846:
847: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.accrual_conversion_rate, p_old_Line_Adj_rec.accrual_conversion_rate)
848: THEN
849: l_index := l_index + 1;
850: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_accrual_conversion_rate;
851: END IF;
849: l_index := l_index + 1;
850: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_accrual_conversion_rate;
851: END IF;
852:
853: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.pricing_group_sequence, p_old_Line_Adj_rec.pricing_group_sequence)
854: THEN
855: l_index := l_index + 1;
856: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_pricing_group_sequence;
857: END IF;
855: l_index := l_index + 1;
856: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_pricing_group_sequence;
857: END IF;
858:
859: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.modifier_level_code, p_old_Line_Adj_rec.modifier_level_code)
860: THEN
861: l_index := l_index + 1;
862: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_modifier_level_code;
863: END IF;
861: l_index := l_index + 1;
862: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_modifier_level_code;
863: END IF;
864:
865: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.price_break_type_code, p_old_Line_Adj_rec.price_break_type_code)
866: THEN
867: l_index := l_index + 1;
868: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_price_break_type_code;
869: END IF;
867: l_index := l_index + 1;
868: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_price_break_type_code;
869: END IF;
870:
871: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.substitution_attribute, p_old_Line_Adj_rec.substitution_attribute)
872: THEN
873: l_index := l_index + 1;
874: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_substitution_attribute;
875: END IF;
873: l_index := l_index + 1;
874: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_substitution_attribute;
875: END IF;
876:
877: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.proration_type_code, p_old_Line_Adj_rec.proration_type_code)
878: THEN
879: l_index := l_index + 1;
880: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_proration_type_code;
881: END IF;
879: l_index := l_index + 1;
880: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_proration_type_code;
881: END IF;
882:
883: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.credit_or_charge_flag, p_old_Line_Adj_rec.credit_or_charge_flag)
884: THEN
885: l_index := l_index + 1;
886: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_credit_or_charge_flag;
887: END IF;
885: l_index := l_index + 1;
886: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_credit_or_charge_flag;
887: END IF;
888:
889: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.include_on_returns_flag, p_old_Line_Adj_rec.include_on_returns_flag)
890: THEN
891: l_index := l_index + 1;
892: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_include_on_returns_flag;
893: END IF;
891: l_index := l_index + 1;
892: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_include_on_returns_flag;
893: END IF;
894:
895: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.ac_context,p_old_Line_Adj_rec.ac_context)
896: THEN
897: l_index := l_index + 1;
898: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_CONTEXT;
899: END IF;
897: l_index := l_index + 1;
898: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_CONTEXT;
899: END IF;
900:
901: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.ac_attribute1,p_old_Line_Adj_rec.ac_attribute1)
902: THEN
903: l_index := l_index + 1;
904: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE1;
905: END IF;
903: l_index := l_index + 1;
904: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE1;
905: END IF;
906:
907: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.ac_attribute2,p_old_Line_Adj_rec.ac_attribute2)
908: THEN
909: l_index := l_index + 1;
910: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE2;
911: END IF;
909: l_index := l_index + 1;
910: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE2;
911: END IF;
912:
913: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.ac_attribute3,p_old_Line_Adj_rec.ac_attribute3)
914: THEN
915: l_index := l_index + 1;
916: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE3;
917: END IF;
915: l_index := l_index + 1;
916: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE3;
917: END IF;
918:
919: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.ac_attribute4,p_old_Line_Adj_rec.ac_attribute4)
920: THEN
921: l_index := l_index + 1;
922: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE4;
923: END IF;
921: l_index := l_index + 1;
922: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE4;
923: END IF;
924:
925: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.ac_attribute5,p_old_Line_Adj_rec.ac_attribute5)
926: THEN
927: l_index := l_index + 1;
928: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE5;
929: END IF;
927: l_index := l_index + 1;
928: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE5;
929: END IF;
930:
931: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.ac_attribute6,p_old_Line_Adj_rec.ac_attribute6)
932: THEN
933: l_index := l_index + 1;
934: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE6;
935: END IF;
933: l_index := l_index + 1;
934: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE6;
935: END IF;
936:
937: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.ac_attribute7,p_old_Line_Adj_rec.ac_attribute7)
938: THEN
939: l_index := l_index + 1;
940: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE7;
941: END IF;
939: l_index := l_index + 1;
940: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE7;
941: END IF;
942:
943: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.ac_attribute8,p_old_Line_Adj_rec.ac_attribute8)
944: THEN
945: l_index := l_index + 1;
946: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE8;
947: END IF;
945: l_index := l_index + 1;
946: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE8;
947: END IF;
948:
949: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.ac_attribute9,p_old_Line_Adj_rec.ac_attribute9)
950: THEN
951: l_index := l_index + 1;
952: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE9;
953: END IF;
951: l_index := l_index + 1;
952: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE9;
953: END IF;
954:
955: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.ac_attribute10,p_old_Line_Adj_rec.ac_attribute10)
956: THEN
957: l_index := l_index + 1;
958: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE10;
959: END IF;
957: l_index := l_index + 1;
958: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE10;
959: END IF;
960:
961: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.ac_attribute11,p_old_Line_Adj_rec.ac_attribute11)
962: THEN
963: l_index := l_index + 1;
964: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE11;
965: END IF;
963: l_index := l_index + 1;
964: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE11;
965: END IF;
966:
967: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.ac_attribute12,p_old_Line_Adj_rec.ac_attribute12)
968: THEN
969: l_index := l_index + 1;
970: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE12;
971: END IF;
969: l_index := l_index + 1;
970: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE12;
971: END IF;
972:
973: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.ac_attribute13,p_old_Line_Adj_rec.ac_attribute13)
974: THEN
975: l_index := l_index + 1;
976: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE13;
977: END IF;
975: l_index := l_index + 1;
976: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE13;
977: END IF;
978:
979: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.ac_attribute14,p_old_Line_Adj_rec.ac_attribute14)
980: THEN
981: l_index := l_index + 1;
982: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE14;
983: END IF;
981: l_index := l_index + 1;
982: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE14;
983: END IF;
984:
985: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.ac_attribute15,p_old_Line_Adj_rec.ac_attribute15)
986: THEN
987: l_index := l_index + 1;
988: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE15;
989: END IF;
988: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_AC_ATTRIBUTE15;
989: END IF;
990:
991: --uom begin
992: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.operand_per_pqty,p_old_Line_Adj_rec.operand_per_pqty)
993: THEN
994: l_index := l_index + 1;
995: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_OPERAND_PER_PQTY;
996: END IF;
994: l_index := l_index + 1;
995: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_OPERAND_PER_PQTY;
996: END IF;
997:
998: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.adjusted_amount_per_pqty,p_old_Line_Adj_rec.adjusted_amount_per_pqty)
999: THEN
1000: l_index := l_index + 1;
1001: l_src_attr_tbl(l_index) := OE_Line_ADJ_UTIL.G_ADJUSTED_AMOUNT_PER_PQTY;
1002: END IF;
1012:
1013: If l_src_attr_tbl.COUNT <> 0 THEN
1014:
1015: OE_Dependencies.Mark_Dependent
1016: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
1017: p_source_attr_tbl => l_src_attr_tbl,
1018: p_dep_attr_tbl => l_dep_attr_tbl);
1019:
1020: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
1277: --x_Line_Adj_rec := p_Line_Adj_rec;
1278: IF l_debug_level > 0 THEN
1279: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.APPLY ATTRIBUTE CHANGES' ) ;
1280: END IF;
1281: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.adjusted_amount,p_old_Line_Adj_rec.adjusted_amount)
1282: THEN
1283: NULL;
1284: END IF;
1285:
1282: THEN
1283: NULL;
1284: END IF;
1285:
1286: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.adjusted_amount_per_pqty,p_old_Line_Adj_rec.adjusted_amount_per_pqty)
1287: THEN
1288: NULL;
1289: END IF;
1290:
1287: THEN
1288: NULL;
1289: END IF;
1290:
1291: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.pricing_phase_id,p_old_Line_Adj_rec.pricing_phase_id)
1292: THEN
1293: l_price_flag := TRUE;
1294: END IF;
1295:
1292: THEN
1293: l_price_flag := TRUE;
1294: END IF;
1295:
1296: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.price_adjustment_id,p_old_Line_Adj_rec.price_adjustment_id)
1297: THEN
1298: NULL;
1299: END IF;
1300:
1297: THEN
1298: NULL;
1299: END IF;
1300:
1301: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.creation_date,p_old_Line_Adj_rec.creation_date)
1302: THEN
1303: NULL;
1304: END IF;
1305:
1302: THEN
1303: NULL;
1304: END IF;
1305:
1306: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.created_by,p_old_Line_Adj_rec.created_by)
1307: THEN
1308: NULL;
1309: END IF;
1310:
1307: THEN
1308: NULL;
1309: END IF;
1310:
1311: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.last_update_date,p_old_Line_Adj_rec.last_update_date)
1312: THEN
1313: NULL;
1314: END IF;
1315:
1312: THEN
1313: NULL;
1314: END IF;
1315:
1316: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.last_updated_by,p_old_Line_Adj_rec.last_updated_by)
1317: THEN
1318: NULL;
1319: END IF;
1320:
1317: THEN
1318: NULL;
1319: END IF;
1320:
1321: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.last_update_login,p_old_Line_Adj_rec.last_update_login)
1322: THEN
1323: NULL;
1324: END IF;
1325:
1322: THEN
1323: NULL;
1324: END IF;
1325:
1326: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.program_application_id,p_old_Line_Adj_rec.program_application_id)
1327: THEN
1328: NULL;
1329: END IF;
1330:
1327: THEN
1328: NULL;
1329: END IF;
1330:
1331: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.program_id,p_old_Line_Adj_rec.program_id)
1332: THEN
1333: NULL;
1334: END IF;
1335:
1332: THEN
1333: NULL;
1334: END IF;
1335:
1336: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.program_update_date,p_old_Line_Adj_rec.program_update_date)
1337: THEN
1338: NULL;
1339: END IF;
1340:
1337: THEN
1338: NULL;
1339: END IF;
1340:
1341: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.request_id,p_old_Line_Adj_rec.request_id)
1342: THEN
1343: NULL;
1344: END IF;
1345:
1342: THEN
1343: NULL;
1344: END IF;
1345:
1346: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.header_id,p_old_Line_Adj_rec.header_id)
1347: THEN
1348: NULL;
1349: END IF;
1350:
1348: NULL;
1349: END IF;
1350:
1351:
1352: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.discount_id,
1353: p_old_Line_Adj_rec.discount_id)
1354: THEN
1355: Null;
1356: END IF;
1354: THEN
1355: Null;
1356: END IF;
1357:
1358: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.discount_line_id,
1359: p_old_Line_Adj_rec.discount_line_id)
1360: THEN
1361: null;
1362: END IF;
1360: THEN
1361: null;
1362: END IF;
1363:
1364: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.automatic_flag,p_old_Line_Adj_rec.automatic_flag)
1365: THEN
1366: NULL;
1367: END IF;
1368:
1365: THEN
1366: NULL;
1367: END IF;
1368:
1369: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.percent,p_old_Line_Adj_rec.percent)
1370: THEN
1371: NULL;
1372: END IF;
1373:
1370: THEN
1371: NULL;
1372: END IF;
1373:
1374: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.line_id,p_old_Line_Adj_rec.line_id)
1375: THEN
1376: NULL;
1377: END IF;
1378:
1375: THEN
1376: NULL;
1377: END IF;
1378:
1379: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.context,p_old_Line_Adj_rec.context)
1380: THEN
1381: NULL;
1382: END IF;
1383:
1380: THEN
1381: NULL;
1382: END IF;
1383:
1384: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute1,p_old_Line_Adj_rec.attribute1)
1385: THEN
1386: NULL;
1387: END IF;
1388:
1385: THEN
1386: NULL;
1387: END IF;
1388:
1389: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute2,p_old_Line_Adj_rec.attribute2)
1390: THEN
1391: NULL;
1392: END IF;
1393:
1390: THEN
1391: NULL;
1392: END IF;
1393:
1394: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute3,p_old_Line_Adj_rec.attribute3)
1395: THEN
1396: NULL;
1397: END IF;
1398:
1395: THEN
1396: NULL;
1397: END IF;
1398:
1399: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute4,p_old_Line_Adj_rec.attribute4)
1400: THEN
1401: NULL;
1402: END IF;
1403:
1400: THEN
1401: NULL;
1402: END IF;
1403:
1404: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute5,p_old_Line_Adj_rec.attribute5)
1405: THEN
1406: NULL;
1407: END IF;
1408:
1405: THEN
1406: NULL;
1407: END IF;
1408:
1409: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute6,p_old_Line_Adj_rec.attribute6)
1410: THEN
1411: NULL;
1412: END IF;
1413:
1410: THEN
1411: NULL;
1412: END IF;
1413:
1414: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute7,p_old_Line_Adj_rec.attribute7)
1415: THEN
1416: NULL;
1417: END IF;
1418:
1415: THEN
1416: NULL;
1417: END IF;
1418:
1419: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute8,p_old_Line_Adj_rec.attribute8)
1420: THEN
1421: NULL;
1422: END IF;
1423:
1420: THEN
1421: NULL;
1422: END IF;
1423:
1424: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute9,p_old_Line_Adj_rec.attribute9)
1425: THEN
1426: NULL;
1427: END IF;
1428:
1425: THEN
1426: NULL;
1427: END IF;
1428:
1429: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute10,p_old_Line_Adj_rec.attribute10)
1430: THEN
1431: NULL;
1432: END IF;
1433:
1430: THEN
1431: NULL;
1432: END IF;
1433:
1434: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute11,p_old_Line_Adj_rec.attribute11)
1435: THEN
1436: NULL;
1437: END IF;
1438:
1435: THEN
1436: NULL;
1437: END IF;
1438:
1439: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute12,p_old_Line_Adj_rec.attribute12)
1440: THEN
1441: NULL;
1442: END IF;
1443:
1440: THEN
1441: NULL;
1442: END IF;
1443:
1444: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute13,p_old_Line_Adj_rec.attribute13)
1445: THEN
1446: NULL;
1447: END IF;
1448:
1445: THEN
1446: NULL;
1447: END IF;
1448:
1449: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute14,p_old_Line_Adj_rec.attribute14)
1450: THEN
1451: NULL;
1452: END IF;
1453:
1450: THEN
1451: NULL;
1452: END IF;
1453:
1454: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute15,p_old_Line_Adj_rec.attribute15)
1455: THEN
1456: NULL;
1457: END IF;
1458:
1455: THEN
1456: NULL;
1457: END IF;
1458:
1459: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.list_header_id,
1460: p_old_Line_Adj_rec.list_header_id)
1461: THEN
1462: NULL;
1463: END IF;
1461: THEN
1462: NULL;
1463: END IF;
1464:
1465: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.list_line_id,
1466: p_old_Line_Adj_rec.list_line_id)
1467: THEN
1468: NULL;
1469: END IF;
1467: THEN
1468: NULL;
1469: END IF;
1470:
1471: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.list_line_type_code,
1472: p_old_Line_Adj_rec.list_line_type_code)
1473: THEN
1474: NULL;
1475: END IF;
1473: THEN
1474: NULL;
1475: END IF;
1476:
1477: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.modifier_mechanism_type_code,
1478: p_old_Line_Adj_rec.modifier_mechanism_type_code)
1479: THEN
1480: NULL;
1481: END IF;
1479: THEN
1480: NULL;
1481: END IF;
1482:
1483: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.update_allowed,
1484: p_old_Line_Adj_rec.update_allowed)
1485: THEN
1486: NULL;
1487: END IF;
1485: THEN
1486: NULL;
1487: END IF;
1488:
1489: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.updated_flag,
1490: p_old_Line_Adj_rec.updated_flag)
1491: THEN
1492: l_price_flag := TRUE;
1493: IF p_x_line_Adj_rec.ESTIMATED_FLAG = 'Y' AND
1501: p_x_line_adj_rec.estimated_flag := 'Y';
1502: END IF;
1503: END IF;
1504:
1505: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.applied_flag,
1506: p_old_Line_Adj_rec.applied_flag)
1507: THEN
1508: l_price_flag := TRUE;
1509: --added by ksurendr
1529: null;
1530: END;
1531: END IF;
1532:
1533: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.modified_from,
1534: p_old_Line_Adj_rec.modified_from)
1535: THEN
1536: NULL;
1537: END IF;
1535: THEN
1536: NULL;
1537: END IF;
1538:
1539: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.modified_to,
1540: p_old_Line_Adj_rec.modified_to)
1541: THEN
1542: NULL;
1543: END IF;
1542: NULL;
1543: END IF;
1544:
1545:
1546: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.change_reason_code,
1547: p_old_Line_Adj_rec.change_reason_code)
1548: THEN
1549: NULL;
1550: END IF;
1548: THEN
1549: NULL;
1550: END IF;
1551:
1552: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.change_reason_text,
1553: p_old_Line_Adj_rec.change_reason_text)
1554: THEN
1555: NULL;
1556: END IF;
1554: THEN
1555: NULL;
1556: END IF;
1557:
1558: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.operand,
1559: p_old_Line_Adj_rec.operand)
1560: THEN
1561: l_price_flag := TRUE;
1562: l_calculate_commitment_flag := 'Y';
1570: l_verify_payment_flag := 'Y';
1571: END IF;
1572: END IF;
1573:
1574: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.operand_per_pqty,
1575: p_old_Line_Adj_rec.operand_per_pqty)
1576: THEN
1577: l_price_flag := TRUE;
1578: END IF;
1576: THEN
1577: l_price_flag := TRUE;
1578: END IF;
1579:
1580: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.arithmetic_operator,
1581: p_old_Line_Adj_rec.arithmetic_operator)
1582: THEN
1583: l_price_flag := TRUE;
1584: END IF;
1582: THEN
1583: l_price_flag := TRUE;
1584: END IF;
1585:
1586: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.COST_ID, p_old_Line_Adj_rec.COST_ID)
1587: THEN
1588: NULL;
1589: END IF;
1590:
1587: THEN
1588: NULL;
1589: END IF;
1590:
1591: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.TAX_CODE, p_old_Line_Adj_rec.TAX_CODE)
1592: THEN
1593: NULL;
1594: END IF;
1595:
1592: THEN
1593: NULL;
1594: END IF;
1595:
1596: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.TAX_EXEMPT_FLAG, p_old_Line_Adj_rec.TAX_EXEMPT_FLAG)
1597: THEN
1598: NULL;
1599: END IF;
1600:
1597: THEN
1598: NULL;
1599: END IF;
1600:
1601: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.TAX_EXEMPT_NUMBER, p_old_Line_Adj_rec.TAX_EXEMPT_NUMBER)
1602: THEN
1603: NULL;
1604: END IF;
1605:
1602: THEN
1603: NULL;
1604: END IF;
1605:
1606: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.TAX_EXEMPT_REASON_CODE, p_old_Line_Adj_rec.TAX_EXEMPT_REASON_CODE)
1607: THEN
1608: NULL;
1609: END IF;
1610:
1607: THEN
1608: NULL;
1609: END IF;
1610:
1611: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.PARENT_ADJUSTMENT_ID, p_old_Line_Adj_rec.PARENT_ADJUSTMENT_ID)
1612: THEN
1613: NULL;
1614: END IF;
1615:
1612: THEN
1613: NULL;
1614: END IF;
1615:
1616: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.INVOICED_FLAG, p_old_Line_Adj_rec.INVOICED_FLAG)
1617: THEN
1618: NULL;
1619: END IF;
1620:
1617: THEN
1618: NULL;
1619: END IF;
1620:
1621: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.ESTIMATED_FLAG, p_old_Line_Adj_rec.ESTIMATED_FLAG)
1622: THEN
1623: NULL;
1624: END IF;
1625:
1622: THEN
1623: NULL;
1624: END IF;
1625:
1626: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.INC_IN_SALES_PERFORMANCE, p_old_Line_Adj_rec.INC_IN_SALES_PERFORMANCE)
1627: THEN
1628: NULL;
1629: END IF;
1630:
1627: THEN
1628: NULL;
1629: END IF;
1630:
1631: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.SPLIT_ACTION_CODE, p_old_Line_Adj_rec.SPLIT_ACTION_CODE)
1632: THEN
1633: NULL;
1634: END IF;
1635:
1632: THEN
1633: NULL;
1634: END IF;
1635:
1636: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.CHARGE_TYPE_CODE, p_old_Line_Adj_rec.CHARGE_TYPE_CODE)
1637: THEN
1638: NULL;
1639: END IF;
1640:
1637: THEN
1638: NULL;
1639: END IF;
1640:
1641: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.CHARGE_SUBTYPE_CODE, p_old_Line_Adj_rec.CHARGE_SUBTYPE_CODE)
1642: THEN
1643: NULL;
1644: END IF;
1645:
1642: THEN
1643: NULL;
1644: END IF;
1645:
1646: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.list_line_no, p_old_Line_Adj_rec.list_line_no)
1647: THEN
1648: NULL;
1649: END IF;
1650:
1647: THEN
1648: NULL;
1649: END IF;
1650:
1651: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.source_system_code, p_old_Line_Adj_rec.source_system_code)
1652: THEN
1653: NULL;
1654: END IF;
1655:
1652: THEN
1653: NULL;
1654: END IF;
1655:
1656: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.benefit_qty, p_old_Line_Adj_rec.benefit_qty)
1657: THEN
1658: NULL;
1659: END IF;
1660:
1657: THEN
1658: NULL;
1659: END IF;
1660:
1661: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.benefit_uom_code, p_old_Line_Adj_rec.benefit_uom_code)
1662: THEN
1663: NULL;
1664: END IF;
1665:
1662: THEN
1663: NULL;
1664: END IF;
1665:
1666: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.print_on_invoice_flag, p_old_Line_Adj_rec.print_on_invoice_flag)
1667: THEN
1668: NULL;
1669: END IF;
1670:
1667: THEN
1668: NULL;
1669: END IF;
1670:
1671: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.expiration_date, p_old_Line_Adj_rec.expiration_date)
1672: THEN
1673: NULL;
1674: END IF;
1675:
1672: THEN
1673: NULL;
1674: END IF;
1675:
1676: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.rebate_transaction_type_code, p_old_Line_Adj_rec.rebate_transaction_type_code)
1677: THEN
1678: NULL;
1679: END IF;
1680:
1677: THEN
1678: NULL;
1679: END IF;
1680:
1681: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.rebate_transaction_reference, p_old_Line_Adj_rec.rebate_transaction_reference)
1682: THEN
1683: NULL;
1684: END IF;
1685:
1682: THEN
1683: NULL;
1684: END IF;
1685:
1686: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.rebate_payment_system_code, p_old_Line_Adj_rec.rebate_payment_system_code)
1687: THEN
1688: NULL;
1689: END IF;
1690:
1687: THEN
1688: NULL;
1689: END IF;
1690:
1691: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.redeemed_date, p_old_Line_Adj_rec.redeemed_date)
1692: THEN
1693: NULL;
1694: END IF;
1695:
1692: THEN
1693: NULL;
1694: END IF;
1695:
1696: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.redeemed_flag, p_old_Line_Adj_rec.redeemed_flag)
1697: THEN
1698: NULL;
1699: END IF;
1700:
1697: THEN
1698: NULL;
1699: END IF;
1700:
1701: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.accrual_flag, p_old_Line_Adj_rec.accrual_flag)
1702: THEN
1703: NULL;
1704: END IF;
1705:
1702: THEN
1703: NULL;
1704: END IF;
1705:
1706: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.range_break_quantity, p_old_Line_Adj_rec.range_break_quantity)
1707: THEN
1708: NULL;
1709: END IF;
1710:
1707: THEN
1708: NULL;
1709: END IF;
1710:
1711: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.accrual_conversion_rate, p_old_Line_Adj_rec.accrual_conversion_rate)
1712: THEN
1713: NULL;
1714: END IF;
1715:
1712: THEN
1713: NULL;
1714: END IF;
1715:
1716: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.pricing_group_sequence, p_old_Line_Adj_rec.pricing_group_sequence)
1717: THEN
1718: l_price_flag := TRUE;
1719: END IF;
1720:
1717: THEN
1718: l_price_flag := TRUE;
1719: END IF;
1720:
1721: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.modifier_level_code, p_old_Line_Adj_rec.modifier_level_code)
1722: THEN
1723: NULL;
1724: END IF;
1725:
1722: THEN
1723: NULL;
1724: END IF;
1725:
1726: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.price_break_type_code, p_old_Line_Adj_rec.price_break_type_code)
1727: THEN
1728: NULL;
1729: END IF;
1730:
1727: THEN
1728: NULL;
1729: END IF;
1730:
1731: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.substitution_attribute, p_old_Line_Adj_rec.substitution_attribute)
1732: THEN
1733: NULL;
1734: END IF;
1735:
1732: THEN
1733: NULL;
1734: END IF;
1735:
1736: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.proration_type_code, p_old_Line_Adj_rec.proration_type_code)
1737: THEN
1738: NULL;
1739: END IF;
1740:
1737: THEN
1738: NULL;
1739: END IF;
1740:
1741: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.credit_or_charge_flag, p_old_Line_Adj_rec.credit_or_charge_flag)
1742: THEN
1743: NULL;
1744: END IF;
1745:
1742: THEN
1743: NULL;
1744: END IF;
1745:
1746: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.include_on_returns_flag, p_old_Line_Adj_rec.include_on_returns_flag)
1747: THEN
1748: NULL;
1749: END IF;
1750:
1747: THEN
1748: NULL;
1749: END IF;
1750:
1751: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.INVOICED_AMOUNT, p_old_Line_Adj_rec.INVOICED_AMOUNT)
1752: THEN
1753: NULL;
1754: END IF;
1755:
1753: NULL;
1754: END IF;
1755:
1756: IF l_debug_level > 0 THEN
1757: oe_debug_pub.add( 'RECURSION_MODE'||OE_GLOBALS.G_RECURSION_MODE||' PRICING:'||OE_GLOBALS.G_PRICING_RECURSION , 1 ) ;
1758: oe_debug_pub.add( 'HEADER_ID'||P_X_LINE_ADJ_REC.HEADER_ID , 1 ) ;
1759: oe_debug_pub.add( 'LINE_ID'||P_X_LINE_ADJ_REC.LINE_ID , 1 ) ;
1760: END IF;
1761: if (l_price_flag) then
1768: END IF;
1769: end if;
1770:
1771: -- bug 2378843: don't log request when g_pricing_recursion is set
1772: IF l_price_flag and OE_Globals.G_RECURSION_MODE <> 'Y' AND
1773: OE_GLOBALS.G_PRICING_RECURSION <> 'Y' AND
1774: p_x_line_adj_rec.list_line_type_code NOT IN ('TAX','COST')
1775: Then
1776:
1769: end if;
1770:
1771: -- bug 2378843: don't log request when g_pricing_recursion is set
1772: IF l_price_flag and OE_Globals.G_RECURSION_MODE <> 'Y' AND
1773: OE_GLOBALS.G_PRICING_RECURSION <> 'Y' AND
1774: p_x_line_adj_rec.list_line_type_code NOT IN ('TAX','COST')
1775: Then
1776:
1777: IF (p_x_Line_adj_rec.line_id IS NOT NULL) THEN
1779: /* 1905650
1780: G_PRICE_ADJ request should be logged against LINE entity,
1781: not against LINE_ADJ entity
1782: */
1783: If OE_GLOBALS.G_UI_FLAG and nvl(p_x_Line_adj_rec.automatic_flag,'Y') = 'N' Then
1784: --we need to log different delayed request for manual adjustments.
1785: IF l_debug_level > 0 THEN
1786: oe_debug_pub.add( ' UI FLAG IS TRUE , LOGGING UI DELAYED REQUEST FOR ADJ' ) ;
1787: END IF;
1785: IF l_debug_level > 0 THEN
1786: oe_debug_pub.add( ' UI FLAG IS TRUE , LOGGING UI DELAYED REQUEST FOR ADJ' ) ;
1787: END IF;
1788: oe_delayed_requests_pvt.log_request(
1789: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1790: p_entity_id => p_x_Line_adj_rec.Line_id,
1791: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
1792: p_requesting_entity_id => p_x_Line_adj_rec.Line_id,
1793: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
1787: END IF;
1788: oe_delayed_requests_pvt.log_request(
1789: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1790: p_entity_id => p_x_Line_adj_rec.Line_id,
1791: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
1792: p_requesting_entity_id => p_x_Line_adj_rec.Line_id,
1793: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
1794: p_param1 => 'UI',
1795: x_return_status => l_return_status);
1789: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1790: p_entity_id => p_x_Line_adj_rec.Line_id,
1791: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
1792: p_requesting_entity_id => p_x_Line_adj_rec.Line_id,
1793: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
1794: p_param1 => 'UI',
1795: x_return_status => l_return_status);
1796: Else
1797: oe_delayed_requests_pvt.log_request(
1794: p_param1 => 'UI',
1795: x_return_status => l_return_status);
1796: Else
1797: oe_delayed_requests_pvt.log_request(
1798: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1799: p_entity_id => p_x_Line_adj_rec.Line_id,
1800: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
1801: p_requesting_entity_id => p_x_Line_adj_rec.Line_id,
1802: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
1796: Else
1797: oe_delayed_requests_pvt.log_request(
1798: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1799: p_entity_id => p_x_Line_adj_rec.Line_id,
1800: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
1801: p_requesting_entity_id => p_x_Line_adj_rec.Line_id,
1802: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
1803: x_return_status => l_return_status);
1804: End If;
1798: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1799: p_entity_id => p_x_Line_adj_rec.Line_id,
1800: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
1801: p_requesting_entity_id => p_x_Line_adj_rec.Line_id,
1802: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
1803: x_return_status => l_return_status);
1804: End If;
1805: ELSE
1806: oe_delayed_requests_pvt.log_request(
1803: x_return_status => l_return_status);
1804: End If;
1805: ELSE
1806: oe_delayed_requests_pvt.log_request(
1807: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1808: p_entity_id => p_x_Line_adj_rec.header_id,
1809: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
1810: p_requesting_entity_id => p_x_Line_adj_rec.header_id,
1811: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
1805: ELSE
1806: oe_delayed_requests_pvt.log_request(
1807: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1808: p_entity_id => p_x_Line_adj_rec.header_id,
1809: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
1810: p_requesting_entity_id => p_x_Line_adj_rec.header_id,
1811: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
1812: x_return_status => l_return_status);
1813: END IF;
1807: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1808: p_entity_id => p_x_Line_adj_rec.header_id,
1809: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
1810: p_requesting_entity_id => p_x_Line_adj_rec.header_id,
1811: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
1812: x_return_status => l_return_status);
1813: END IF;
1814: l_price_flag := FALSE;
1815: End If;
1830: END;
1831:
1832: IF l_commitment_id IS NOT NULL
1833: AND OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
1834: oe_globals.g_commitment_balance := ARP_BAL_UTIL.GET_COMMITMENT_BALANCE(
1835: l_commitment_id
1836: ,l_class
1837: ,l_so_source_code
1838: ,l_oe_installed_flag );
1837: ,l_so_source_code
1838: ,l_oe_installed_flag );
1839:
1840: OE_Delayed_Requests_Pvt.Log_Request(
1841: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1842: p_entity_id => p_x_line_adj_rec.line_id,
1843: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1844: p_requesting_entity_id => p_x_line_adj_rec.line_id,
1845: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,
1839:
1840: OE_Delayed_Requests_Pvt.Log_Request(
1841: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1842: p_entity_id => p_x_line_adj_rec.line_id,
1843: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1844: p_requesting_entity_id => p_x_line_adj_rec.line_id,
1845: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,
1846: x_return_status => l_return_status);
1847: END IF;
1841: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1842: p_entity_id => p_x_line_adj_rec.line_id,
1843: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1844: p_requesting_entity_id => p_x_line_adj_rec.line_id,
1845: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,
1846: x_return_status => l_return_status);
1847: END IF;
1848: END IF;
1849:
1936: END;
1937: IF l_line_category_code <> 'RETURN' THEN
1938: oe_debug_pub.ADD('OEXULADB: Logging delayed request for Verify Payment');
1939: OE_delayed_requests_Pvt.log_request
1940: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1941: p_entity_id => p_x_line_adj_rec.header_id,
1942: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1943: p_requesting_entity_id => p_x_line_adj_rec.line_id,
1944: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
1938: oe_debug_pub.ADD('OEXULADB: Logging delayed request for Verify Payment');
1939: OE_delayed_requests_Pvt.log_request
1940: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1941: p_entity_id => p_x_line_adj_rec.header_id,
1942: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1943: p_requesting_entity_id => p_x_line_adj_rec.line_id,
1944: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
1945: x_return_status => l_return_status);
1946: END IF;
1940: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1941: p_entity_id => p_x_line_adj_rec.header_id,
1942: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1943: p_requesting_entity_id => p_x_line_adj_rec.line_id,
1944: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
1945: x_return_status => l_return_status);
1946: END IF;
1947: END IF;
1948: END IF;
3407: IF l_debug_level > 0 THEN
3408: oe_debug_pub.add( 'JFC: IN DELETE ROW , PRICE_ADJUSTMENT_ID'||L_ADJ.PRICE_ADJUSTMENT_ID , 1 ) ;
3409: END IF;
3410: /* Set the operation on the record so that globals are updated as well */
3411: l_new_line_adj_rec.operation := OE_GLOBALS.G_OPR_DELETE;
3412: l_new_line_adj_rec.price_adjustment_id := l_adj.price_adjustment_id;
3413: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
3414: p_line_adj_rec =>l_new_line_adj_rec,
3415: p_line_adj_id => l_adj.price_adjustment_id,
3435: END IF; /*code_release_level*/
3436: -- end notification framework
3437:
3438: OE_Delayed_Requests_Pvt.Delete_Reqs_for_deleted_entity(
3439: p_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
3440: p_entity_id => l_adj.price_adjustment_id,
3441: x_return_status => l_return_status
3442: );
3443: OE_Line_Price_Aattr_Util.delete_row(
3463: IF l_debug_level > 0 THEN
3464: oe_debug_pub.add( 'JFC: IN DELETE ROW , LINE_ID IS G_MISS_NUM , PRICE_ADJUSTMENT_ID'||P_PRICE_ADJUSTMENT_ID , 1 ) ;
3465: END IF;
3466: /* Set the operation on the record so that globals are updated as well */
3467: l_new_line_adj_rec.operation := OE_GLOBALS.G_OPR_DELETE;
3468: l_new_line_adj_rec.price_adjustment_id := p_price_adjustment_id;
3469: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
3470: p_line_adj_rec =>l_new_line_adj_rec,
3471: p_line_adj_id => p_price_adjustment_id,
3490: END IF; /*code_release_level*/
3491: -- end notification framework
3492:
3493: OE_Delayed_Requests_Pvt.Delete_Reqs_for_deleted_entity
3494: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
3495: p_entity_id => p_price_adjustment_id,
3496: x_return_status => l_return_status
3497: );
3498:
4345: IF l_debug_level > 0 THEN
4346: oe_debug_pub.add( 'COMPARE ' , 1 ) ;
4347: END IF;
4348:
4349: IF OE_GLOBALS.Equal(p_x_line_adj_rec.lock_control,
4350: l_lock_control)
4351: THEN
4352:
4353: -- Row has not changed. Set out parameter.
4580: p_delete_flag)
4581: THEN
4582:
4583: /*
4584: oe_delayed_requests_pvt.log_request(p_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
4585: p_entity_id => p_adj_rec.line_id,
4586: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
4587: p_requesting_entity_id => p_adj_rec.price_adjustment_id,
4588: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
4582:
4583: /*
4584: oe_delayed_requests_pvt.log_request(p_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
4585: p_entity_id => p_adj_rec.line_id,
4586: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
4587: p_requesting_entity_id => p_adj_rec.price_adjustment_id,
4588: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
4589: x_return_status => x_return_status);
4590: */
4584: oe_delayed_requests_pvt.log_request(p_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
4585: p_entity_id => p_adj_rec.line_id,
4586: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
4587: p_requesting_entity_id => p_adj_rec.price_adjustment_id,
4588: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
4589: x_return_status => x_return_status);
4590: */
4591: null;
4592:
4606: BEGIN
4607:
4608: IF (p_Line_Adj_rec.discount_id IS NULL OR
4609: p_Line_Adj_rec.discount_id <> FND_API.G_MISS_NUM) AND
4610: NOT OE_GLOBALS.Equal(p_Line_Adj_rec.discount_id,
4611: p_old_Line_Adj_rec.discount_id)
4612: THEN
4613: l_Line_Adj_val_rec.discount := OE_Id_To_Value.Discount
4614: ( p_discount_id => p_Line_Adj_rec.discount_id
4808:
4809: i:= L_Line_Adj_Att_Tbl.First;
4810: While i is not null loop
4811:
4812: L_Line_Adj_Att_Tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
4813: L_Line_Adj_Att_Tbl(i).price_adjustment_id := fnd_api.g_miss_num;
4814: L_Line_Adj_Att_Tbl(i).adj_index := p_adj_index;
4815: L_Line_Adj_Att_Tbl(i).price_adj_attrib_id := fnd_api.g_miss_num;
4816:
4843: If px_line_adj_rec.operand = 0 or px_line_adj_rec.operand is null Then
4844: IF l_debug_level > 0 THEN
4845: oe_debug_pub.add( ' NOTHING TO PRORATE , OPERAND IS 0' ) ;
4846: END IF;
4847: x_copy_from_line_adj_rec.operation := OE_GLOBALS.G_OPR_NONE;
4848: Return;
4849: End If;
4850:
4851: IF (px_line_adj_rec.list_line_type_code='DIS') THEN
4869: oe_debug_pub.add( 'OPERAND'||PX_LINE_ADJ_REC.OPERAND ||'<>'||L_ORDERED_QUANTITY||'*'||PX_LINE_ADJ_REC.ADJUSTED_AMOUNT ) ;
4870: END IF;
4871:
4872: x_copy_from_line_adj_rec := px_line_adj_rec;
4873: x_copy_from_line_adj_rec.operation := oe_globals.g_opr_update;
4874: x_copy_from_line_adj_rec.operand := l_ordered_quantity
4875: * x_copy_from_line_adj_rec.adjusted_amount * l_sign;
4876:
4877:
4886: oe_debug_pub.add( ' PRORATED ADJUSTED_AMOUNT:'||X_COPY_FROM_LINE_ADJ_REC.ADJUSTED_AMOUNT ) ;
4887: END IF;
4888:
4889: ELSE
4890: x_copy_from_line_adj_rec.operation := OE_GLOBALS.G_OPR_NONE;
4891: END IF;
4892:
4893: -- Then correct the copy_to line adj record
4894: SELECT ordered_quantity
4982: -- Manish Changes
4983: if p_line_id is not null then
4984:
4985: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' and
4986: p_operation <> OE_GLOBALS.G_OPR_DELETE THEN
4987: --RT{
4988: --we need to retrieve the latest adjustments if it is a retrobilled line
4989: --call retrobill api to get the retrobill line id, if none l_line_id will
4990: --set to the same value as p_line_id
5020:
5021: else
5022: -- l_Line_Adj_Tbl := OE_Line_Adj_Util.Query_Rows(p_header_Id => p_header_id);
5023: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' and
5024: p_operation <> OE_GLOBALS.G_OPR_DELETE THEN
5025: --RT{
5026: Oe_Retrobill_Pvt.Get_Last_Retro_HdrID(p_header_id=>p_header_id,
5027: x_header_id=>l_header_id);
5028: if nvl(p_header_id,-1) <> nvl(l_header_id,-1) then
5050: i:= l_Line_Adj_Tbl.First;
5051: While i is not Null Loop
5052:
5053:
5054: If p_operation = OE_GLOBALS.G_OPR_DELETE then
5055:
5056: l_Line_Adj_Tbl(i).operation := p_operation;
5057: px_line_adj_tbl(px_line_adj_tbl.count+1) := L_Line_Adj_Tbl(i);
5058:
5112: p_to_line_id,
5113: l_copy_from_line_adj_rec);
5114:
5115: IF l_copy_from_line_adj_rec.operation
5116: = OE_GLOBALS.G_OPR_UPDATE THEN
5117: IF l_debug_level > 0 THEN
5118: oe_debug_pub.add( ' UPDATING OPERAND FOR LINE ID:'||L_COPY_FROM_LINE_ADJ_REC.LINE_ID ) ;
5119: END IF;
5120: px_line_adj_tbl(px_line_adj_tbl.count+1)
5274: px_line_adj_assoc_tbl => px_line_adj_assoc_tbl,
5275: p_pbh_tbl => l_pbh_tbl);
5276: End If;
5277:
5278: IF (p_operation = OE_GLOBALS.G_OPR_CREATE) and l_Line_Adj_Tbl.count > 0 THEN
5279: I:=px_line_adj_tbl.first;
5280: while I is not null loop
5281: IF (px_line_adj_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE) THEN
5282: px_line_adj_tbl(i).price_adjustment_id:=fnd_api.g_miss_num;
5277:
5278: IF (p_operation = OE_GLOBALS.G_OPR_CREATE) and l_Line_Adj_Tbl.count > 0 THEN
5279: I:=px_line_adj_tbl.first;
5280: while I is not null loop
5281: IF (px_line_adj_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE) THEN
5282: px_line_adj_tbl(i).price_adjustment_id:=fnd_api.g_miss_num;
5283: --RT{
5284: oe_debug_pub.add('operand:'||px_line_adj_tbl(i).operand);
5285: oe_debug_pub.add('operand per pqty:'||px_line_adj_tbl(i).operand_per_pqty);
5329: )
5330: is
5331: l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;
5332: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
5333: l_control_rec Oe_Globals.Control_rec_type;
5334: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5335: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5336: -- l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5337: l_header_rec OE_Order_PUB.Header_Rec_Type;
5366: END IF;
5367: -- Set the existing rows to delete
5368: Append_Adjustment_Lines(
5369: p_line_id => p_to_line_id
5370: ,p_operation => OE_GLOBALS.G_OPR_DELETE
5371: ,p_line_category_code => p_line_category_code
5372: ,px_Line_Adj_Att_Tbl => l_Line_Adj_Att_Tbl
5373: ,px_Line_Adj_Tbl => l_Line_Adj_tbl
5374: ,px_line_adj_assoc_tbl => l_line_adj_assoc_tbl);
5377: ,p_line_id => p_from_line_id
5378: ,p_to_line_id => p_to_line_id
5379: ,p_to_Header_id => p_to_Header_id
5380: ,p_line_category_code => p_line_category_code
5381: ,p_operation => OE_GLOBALS.G_OPR_CREATE
5382: ,p_split_by => p_split_by
5383: ,px_Line_Adj_Att_Tbl => l_Line_Adj_Att_Tbl
5384: ,px_Line_Adj_Tbl => l_Line_Adj_tbl
5385: ,px_line_adj_assoc_tbl => l_line_adj_assoc_tbl
5407: p_Header_id => p_from_Header_id
5408: ,p_to_line_id => p_to_line_id
5409: ,p_to_Header_id => p_to_Header_id
5410: ,p_line_category_code => p_line_category_code
5411: ,p_operation => OE_GLOBALS.G_OPR_CREATE
5412: ,px_Line_Adj_Att_Tbl => l_Line_Adj_Att_Tbl
5413: ,px_Line_Adj_Tbl => l_Line_Adj_tbl
5414: ,px_line_adj_assoc_tbl => l_line_adj_assoc_tbl
5415: --RT{
5423: p_Header_id => p_from_Header_id
5424: ,p_to_line_id => p_to_line_id
5425: ,p_to_Header_id => p_to_Header_id
5426: ,p_line_category_code => p_line_category_code
5427: ,p_operation => OE_GLOBALS.G_OPR_CREATE
5428: ,px_Line_Adj_Att_Tbl => l_Line_Adj_Att_Tbl
5429: ,px_Line_Adj_Tbl => l_Line_Adj_tbl
5430: ,px_line_adj_assoc_tbl => l_line_adj_assoc_tbl
5431: );
5457: IF l_debug_level > 0 THEN
5458: oe_debug_pub.add( 'BEFORE OE_ORDER_PVT.PROCESS_ORDER'||L_LINE_ADJ_TBL.COUNT , 1 ) ;
5459: END IF ;
5460:
5461: OE_Globals.G_PRICING_RECURSION := 'Y';
5462:
5463: OE_Order_PVT.Process_order
5464: ( p_api_version_number => 1.0
5465: , x_return_status => x_return_status
5492: , p_x_Lot_Serial_tbl => l_x_Lot_Serial_Tbl
5493: , p_x_action_request_tbl => l_x_Action_Request_tbl
5494: );
5495:
5496: OE_Globals.G_PRICING_RECURSION := 'N';
5497:
5498:
5499: End If;
5500:
5533: BEGIN
5534:
5535: --11.5.10 Versioning/Audit Trail updates
5536: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
5537: OE_GLOBALS.G_ROLL_VERSION <> 'N' AND
5538: NOT OE_GLOBALS.G_HEADER_CREATED THEN
5539: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
5540: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
5541: IF p_x_line_adj_rec.change_reason_code <> FND_API.G_MISS_CHAR THEN
5534:
5535: --11.5.10 Versioning/Audit Trail updates
5536: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
5537: OE_GLOBALS.G_ROLL_VERSION <> 'N' AND
5538: NOT OE_GLOBALS.G_HEADER_CREATED THEN
5539: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
5540: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
5541: IF p_x_line_adj_rec.change_reason_code <> FND_API.G_MISS_CHAR THEN
5542: OE_GLOBALS.G_REASON_TYPE := 'CHANGE_CODE';
5535: --11.5.10 Versioning/Audit Trail updates
5536: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
5537: OE_GLOBALS.G_ROLL_VERSION <> 'N' AND
5538: NOT OE_GLOBALS.G_HEADER_CREATED THEN
5539: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
5540: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
5541: IF p_x_line_adj_rec.change_reason_code <> FND_API.G_MISS_CHAR THEN
5542: OE_GLOBALS.G_REASON_TYPE := 'CHANGE_CODE';
5543: OE_GLOBALS.G_REASON_CODE := p_x_line_adj_rec.change_reason_code;
5536: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
5537: OE_GLOBALS.G_ROLL_VERSION <> 'N' AND
5538: NOT OE_GLOBALS.G_HEADER_CREATED THEN
5539: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
5540: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
5541: IF p_x_line_adj_rec.change_reason_code <> FND_API.G_MISS_CHAR THEN
5542: OE_GLOBALS.G_REASON_TYPE := 'CHANGE_CODE';
5543: OE_GLOBALS.G_REASON_CODE := p_x_line_adj_rec.change_reason_code;
5544: OE_GLOBALS.G_REASON_COMMENTS := p_x_line_adj_rec.change_reason_text;
5538: NOT OE_GLOBALS.G_HEADER_CREATED THEN
5539: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
5540: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
5541: IF p_x_line_adj_rec.change_reason_code <> FND_API.G_MISS_CHAR THEN
5542: OE_GLOBALS.G_REASON_TYPE := 'CHANGE_CODE';
5543: OE_GLOBALS.G_REASON_CODE := p_x_line_adj_rec.change_reason_code;
5544: OE_GLOBALS.G_REASON_COMMENTS := p_x_line_adj_rec.change_reason_text;
5545: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
5546: ELSE
5539: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
5540: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
5541: IF p_x_line_adj_rec.change_reason_code <> FND_API.G_MISS_CHAR THEN
5542: OE_GLOBALS.G_REASON_TYPE := 'CHANGE_CODE';
5543: OE_GLOBALS.G_REASON_CODE := p_x_line_adj_rec.change_reason_code;
5544: OE_GLOBALS.G_REASON_COMMENTS := p_x_line_adj_rec.change_reason_text;
5545: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
5546: ELSE
5547: if l_debug_level > 0 then
5540: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
5541: IF p_x_line_adj_rec.change_reason_code <> FND_API.G_MISS_CHAR THEN
5542: OE_GLOBALS.G_REASON_TYPE := 'CHANGE_CODE';
5543: OE_GLOBALS.G_REASON_CODE := p_x_line_adj_rec.change_reason_code;
5544: OE_GLOBALS.G_REASON_COMMENTS := p_x_line_adj_rec.change_reason_text;
5545: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
5546: ELSE
5547: if l_debug_level > 0 then
5548: OE_DEBUG_PUB.add('Reason code for versioning is missing or invalid', 1);
5541: IF p_x_line_adj_rec.change_reason_code <> FND_API.G_MISS_CHAR THEN
5542: OE_GLOBALS.G_REASON_TYPE := 'CHANGE_CODE';
5543: OE_GLOBALS.G_REASON_CODE := p_x_line_adj_rec.change_reason_code;
5544: OE_GLOBALS.G_REASON_COMMENTS := p_x_line_adj_rec.change_reason_text;
5545: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
5546: ELSE
5547: if l_debug_level > 0 then
5548: OE_DEBUG_PUB.add('Reason code for versioning is missing or invalid', 1);
5549: end if;
5547: if l_debug_level > 0 then
5548: OE_DEBUG_PUB.add('Reason code for versioning is missing or invalid', 1);
5549: end if;
5550: --bug 3775971
5551: if OE_GLOBALS.G_UI_FLAG AND
5552: (OE_GLOBALS.G_PRICING_RECURSION = 'Y' OR
5553: OE_GLOBALS.G_RECURSION_MODE = 'Y') then
5554: raise FND_API.G_EXC_ERROR;
5555: end if;
5548: OE_DEBUG_PUB.add('Reason code for versioning is missing or invalid', 1);
5549: end if;
5550: --bug 3775971
5551: if OE_GLOBALS.G_UI_FLAG AND
5552: (OE_GLOBALS.G_PRICING_RECURSION = 'Y' OR
5553: OE_GLOBALS.G_RECURSION_MODE = 'Y') then
5554: raise FND_API.G_EXC_ERROR;
5555: end if;
5556: END IF;
5549: end if;
5550: --bug 3775971
5551: if OE_GLOBALS.G_UI_FLAG AND
5552: (OE_GLOBALS.G_PRICING_RECURSION = 'Y' OR
5553: OE_GLOBALS.G_RECURSION_MODE = 'Y') then
5554: raise FND_API.G_EXC_ERROR;
5555: end if;
5556: END IF;
5557: END IF;
5557: END IF;
5558:
5559: --log delayed request
5560: oe_debug_pub.add('log versioning request',1);
5561: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5562: p_entity_id => p_x_line_adj_rec.header_id,
5563: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
5564: p_requesting_entity_id => p_x_line_adj_rec.price_adjustment_id,
5565: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
5559: --log delayed request
5560: oe_debug_pub.add('log versioning request',1);
5561: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5562: p_entity_id => p_x_line_adj_rec.header_id,
5563: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
5564: p_requesting_entity_id => p_x_line_adj_rec.price_adjustment_id,
5565: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
5566: x_return_status => l_return_status);
5567: END IF;
5561: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5562: p_entity_id => p_x_line_adj_rec.header_id,
5563: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
5564: p_requesting_entity_id => p_x_line_adj_rec.price_adjustment_id,
5565: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
5566: x_return_status => l_return_status);
5567: END IF;
5568:
5569: if (p_x_line_adj_rec.operation = OE_GLOBALS.G_OPR_UPDATE) then
5565: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
5566: x_return_status => l_return_status);
5567: END IF;
5568:
5569: if (p_x_line_adj_rec.operation = OE_GLOBALS.G_OPR_UPDATE) then
5570:
5571: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' OR
5572: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN
5573:
5567: END IF;
5568:
5569: if (p_x_line_adj_rec.operation = OE_GLOBALS.G_OPR_UPDATE) then
5570:
5571: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' OR
5572: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN
5573:
5574: IF l_debug_level > 0 THEN
5575: oe_debug_pub.add( 'CALL TO RECORD LINE PRICE ADJ HISTORY' , 5 ) ;
5568:
5569: if (p_x_line_adj_rec.operation = OE_GLOBALS.G_OPR_UPDATE) then
5570:
5571: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' OR
5572: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN
5573:
5574: IF l_debug_level > 0 THEN
5575: oe_debug_pub.add( 'CALL TO RECORD LINE PRICE ADJ HISTORY' , 5 ) ;
5576: END IF;
5574: IF l_debug_level > 0 THEN
5575: oe_debug_pub.add( 'CALL TO RECORD LINE PRICE ADJ HISTORY' , 5 ) ;
5576: END IF;
5577: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
5578: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
5579: p_entity_id => p_x_line_adj_rec.price_adjustment_id,
5580: p_hist_type_code => 'UPDATE');
5581: --log delayed request
5582: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5578: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
5579: p_entity_id => p_x_line_adj_rec.price_adjustment_id,
5580: p_hist_type_code => 'UPDATE');
5581: --log delayed request
5582: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5583: p_entity_id => p_x_line_adj_rec.header_id,
5584: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
5585: p_requesting_entity_id => p_x_line_adj_rec.price_adjustment_id,
5586: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
5580: p_hist_type_code => 'UPDATE');
5581: --log delayed request
5582: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5583: p_entity_id => p_x_line_adj_rec.header_id,
5584: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
5585: p_requesting_entity_id => p_x_line_adj_rec.price_adjustment_id,
5586: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
5587: x_return_status => l_return_status);
5588: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
5582: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5583: p_entity_id => p_x_line_adj_rec.header_id,
5584: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
5585: p_requesting_entity_id => p_x_line_adj_rec.price_adjustment_id,
5586: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
5587: x_return_status => l_return_status);
5588: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
5589: ELSE
5590: OE_CHG_ORDER_PVT.RecordLPAdjHist
5584: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
5585: p_requesting_entity_id => p_x_line_adj_rec.price_adjustment_id,
5586: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
5587: x_return_status => l_return_status);
5588: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
5589: ELSE
5590: OE_CHG_ORDER_PVT.RecordLPAdjHist
5591: ( p_line_adj_id => p_x_line_adj_rec.price_adjustment_id,
5592: p_line_adj_rec => null,
5623: IF l_debug_level > 0 THEN
5624: oe_debug_pub.add( ' Check if any pricing related changes has occured' ) ;
5625: END IF;
5626:
5627: IF NOT OE_GLOBALS.Equal(p_new_line_rec.agreement_id,p_old_line_rec.agreement_id)
5628: OR NOT OE_GLOBALS.Equal(p_new_line_rec.cust_po_number,p_old_line_rec.cust_po_number)
5629: OR NOT OE_GLOBALS.Equal(p_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
5630: OR NOT OE_GLOBALS.Equal(p_new_line_rec.invoice_to_org_id,p_old_line_rec.invoice_to_org_id)
5631: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item_id,p_old_line_rec.ordered_item_id)
5624: oe_debug_pub.add( ' Check if any pricing related changes has occured' ) ;
5625: END IF;
5626:
5627: IF NOT OE_GLOBALS.Equal(p_new_line_rec.agreement_id,p_old_line_rec.agreement_id)
5628: OR NOT OE_GLOBALS.Equal(p_new_line_rec.cust_po_number,p_old_line_rec.cust_po_number)
5629: OR NOT OE_GLOBALS.Equal(p_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
5630: OR NOT OE_GLOBALS.Equal(p_new_line_rec.invoice_to_org_id,p_old_line_rec.invoice_to_org_id)
5631: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item_id,p_old_line_rec.ordered_item_id)
5632: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item,p_old_line_rec.ordered_item)
5625: END IF;
5626:
5627: IF NOT OE_GLOBALS.Equal(p_new_line_rec.agreement_id,p_old_line_rec.agreement_id)
5628: OR NOT OE_GLOBALS.Equal(p_new_line_rec.cust_po_number,p_old_line_rec.cust_po_number)
5629: OR NOT OE_GLOBALS.Equal(p_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
5630: OR NOT OE_GLOBALS.Equal(p_new_line_rec.invoice_to_org_id,p_old_line_rec.invoice_to_org_id)
5631: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item_id,p_old_line_rec.ordered_item_id)
5632: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item,p_old_line_rec.ordered_item)
5633: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_category_code,p_old_line_rec.line_category_code)
5626:
5627: IF NOT OE_GLOBALS.Equal(p_new_line_rec.agreement_id,p_old_line_rec.agreement_id)
5628: OR NOT OE_GLOBALS.Equal(p_new_line_rec.cust_po_number,p_old_line_rec.cust_po_number)
5629: OR NOT OE_GLOBALS.Equal(p_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
5630: OR NOT OE_GLOBALS.Equal(p_new_line_rec.invoice_to_org_id,p_old_line_rec.invoice_to_org_id)
5631: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item_id,p_old_line_rec.ordered_item_id)
5632: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item,p_old_line_rec.ordered_item)
5633: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_category_code,p_old_line_rec.line_category_code)
5634: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_type_id,p_old_line_rec.line_type_id)
5627: IF NOT OE_GLOBALS.Equal(p_new_line_rec.agreement_id,p_old_line_rec.agreement_id)
5628: OR NOT OE_GLOBALS.Equal(p_new_line_rec.cust_po_number,p_old_line_rec.cust_po_number)
5629: OR NOT OE_GLOBALS.Equal(p_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
5630: OR NOT OE_GLOBALS.Equal(p_new_line_rec.invoice_to_org_id,p_old_line_rec.invoice_to_org_id)
5631: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item_id,p_old_line_rec.ordered_item_id)
5632: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item,p_old_line_rec.ordered_item)
5633: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_category_code,p_old_line_rec.line_category_code)
5634: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_type_id,p_old_line_rec.line_type_id)
5635: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity)
5628: OR NOT OE_GLOBALS.Equal(p_new_line_rec.cust_po_number,p_old_line_rec.cust_po_number)
5629: OR NOT OE_GLOBALS.Equal(p_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
5630: OR NOT OE_GLOBALS.Equal(p_new_line_rec.invoice_to_org_id,p_old_line_rec.invoice_to_org_id)
5631: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item_id,p_old_line_rec.ordered_item_id)
5632: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item,p_old_line_rec.ordered_item)
5633: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_category_code,p_old_line_rec.line_category_code)
5634: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_type_id,p_old_line_rec.line_type_id)
5635: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity)
5636: OR NOT OE_GLOBALS.Equal(p_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom)
5629: OR NOT OE_GLOBALS.Equal(p_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
5630: OR NOT OE_GLOBALS.Equal(p_new_line_rec.invoice_to_org_id,p_old_line_rec.invoice_to_org_id)
5631: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item_id,p_old_line_rec.ordered_item_id)
5632: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item,p_old_line_rec.ordered_item)
5633: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_category_code,p_old_line_rec.line_category_code)
5634: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_type_id,p_old_line_rec.line_type_id)
5635: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity)
5636: OR NOT OE_GLOBALS.Equal(p_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom)
5637: OR NOT OE_GLOBALS.Equal(p_new_line_rec.payment_term_id,p_old_line_rec.payment_term_id)
5630: OR NOT OE_GLOBALS.Equal(p_new_line_rec.invoice_to_org_id,p_old_line_rec.invoice_to_org_id)
5631: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item_id,p_old_line_rec.ordered_item_id)
5632: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item,p_old_line_rec.ordered_item)
5633: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_category_code,p_old_line_rec.line_category_code)
5634: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_type_id,p_old_line_rec.line_type_id)
5635: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity)
5636: OR NOT OE_GLOBALS.Equal(p_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom)
5637: OR NOT OE_GLOBALS.Equal(p_new_line_rec.payment_term_id,p_old_line_rec.payment_term_id)
5638: OR NOT OE_GLOBALS.Equal(p_new_line_rec.price_list_id,p_old_line_rec.price_list_id)
5631: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item_id,p_old_line_rec.ordered_item_id)
5632: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item,p_old_line_rec.ordered_item)
5633: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_category_code,p_old_line_rec.line_category_code)
5634: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_type_id,p_old_line_rec.line_type_id)
5635: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity)
5636: OR NOT OE_GLOBALS.Equal(p_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom)
5637: OR NOT OE_GLOBALS.Equal(p_new_line_rec.payment_term_id,p_old_line_rec.payment_term_id)
5638: OR NOT OE_GLOBALS.Equal(p_new_line_rec.price_list_id,p_old_line_rec.price_list_id)
5639: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
5632: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item,p_old_line_rec.ordered_item)
5633: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_category_code,p_old_line_rec.line_category_code)
5634: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_type_id,p_old_line_rec.line_type_id)
5635: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity)
5636: OR NOT OE_GLOBALS.Equal(p_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom)
5637: OR NOT OE_GLOBALS.Equal(p_new_line_rec.payment_term_id,p_old_line_rec.payment_term_id)
5638: OR NOT OE_GLOBALS.Equal(p_new_line_rec.price_list_id,p_old_line_rec.price_list_id)
5639: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
5640: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity,p_old_line_rec.pricing_quantity)
5633: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_category_code,p_old_line_rec.line_category_code)
5634: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_type_id,p_old_line_rec.line_type_id)
5635: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity)
5636: OR NOT OE_GLOBALS.Equal(p_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom)
5637: OR NOT OE_GLOBALS.Equal(p_new_line_rec.payment_term_id,p_old_line_rec.payment_term_id)
5638: OR NOT OE_GLOBALS.Equal(p_new_line_rec.price_list_id,p_old_line_rec.price_list_id)
5639: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
5640: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity,p_old_line_rec.pricing_quantity)
5641: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity_uom,p_old_line_rec.pricing_quantity_uom)
5634: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_type_id,p_old_line_rec.line_type_id)
5635: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity)
5636: OR NOT OE_GLOBALS.Equal(p_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom)
5637: OR NOT OE_GLOBALS.Equal(p_new_line_rec.payment_term_id,p_old_line_rec.payment_term_id)
5638: OR NOT OE_GLOBALS.Equal(p_new_line_rec.price_list_id,p_old_line_rec.price_list_id)
5639: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
5640: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity,p_old_line_rec.pricing_quantity)
5641: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity_uom,p_old_line_rec.pricing_quantity_uom)
5642: OR NOT OE_GLOBALS.Equal(p_new_line_rec.request_date,p_old_line_rec.request_date)
5635: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity)
5636: OR NOT OE_GLOBALS.Equal(p_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom)
5637: OR NOT OE_GLOBALS.Equal(p_new_line_rec.payment_term_id,p_old_line_rec.payment_term_id)
5638: OR NOT OE_GLOBALS.Equal(p_new_line_rec.price_list_id,p_old_line_rec.price_list_id)
5639: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
5640: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity,p_old_line_rec.pricing_quantity)
5641: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity_uom,p_old_line_rec.pricing_quantity_uom)
5642: OR NOT OE_GLOBALS.Equal(p_new_line_rec.request_date,p_old_line_rec.request_date)
5643: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id)
5636: OR NOT OE_GLOBALS.Equal(p_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom)
5637: OR NOT OE_GLOBALS.Equal(p_new_line_rec.payment_term_id,p_old_line_rec.payment_term_id)
5638: OR NOT OE_GLOBALS.Equal(p_new_line_rec.price_list_id,p_old_line_rec.price_list_id)
5639: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
5640: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity,p_old_line_rec.pricing_quantity)
5641: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity_uom,p_old_line_rec.pricing_quantity_uom)
5642: OR NOT OE_GLOBALS.Equal(p_new_line_rec.request_date,p_old_line_rec.request_date)
5643: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id)
5644: OR NOT OE_GLOBALS.Equal(p_new_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id)
5637: OR NOT OE_GLOBALS.Equal(p_new_line_rec.payment_term_id,p_old_line_rec.payment_term_id)
5638: OR NOT OE_GLOBALS.Equal(p_new_line_rec.price_list_id,p_old_line_rec.price_list_id)
5639: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
5640: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity,p_old_line_rec.pricing_quantity)
5641: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity_uom,p_old_line_rec.pricing_quantity_uom)
5642: OR NOT OE_GLOBALS.Equal(p_new_line_rec.request_date,p_old_line_rec.request_date)
5643: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id)
5644: OR NOT OE_GLOBALS.Equal(p_new_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id)
5645: OR NOT OE_GLOBALS.Equal(p_new_line_rec.unit_selling_price,p_old_line_rec.unit_selling_price)
5638: OR NOT OE_GLOBALS.Equal(p_new_line_rec.price_list_id,p_old_line_rec.price_list_id)
5639: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
5640: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity,p_old_line_rec.pricing_quantity)
5641: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity_uom,p_old_line_rec.pricing_quantity_uom)
5642: OR NOT OE_GLOBALS.Equal(p_new_line_rec.request_date,p_old_line_rec.request_date)
5643: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id)
5644: OR NOT OE_GLOBALS.Equal(p_new_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id)
5645: OR NOT OE_GLOBALS.Equal(p_new_line_rec.unit_selling_price,p_old_line_rec.unit_selling_price)
5646: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_start_date,p_old_line_rec.service_start_date)
5639: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
5640: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity,p_old_line_rec.pricing_quantity)
5641: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity_uom,p_old_line_rec.pricing_quantity_uom)
5642: OR NOT OE_GLOBALS.Equal(p_new_line_rec.request_date,p_old_line_rec.request_date)
5643: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id)
5644: OR NOT OE_GLOBALS.Equal(p_new_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id)
5645: OR NOT OE_GLOBALS.Equal(p_new_line_rec.unit_selling_price,p_old_line_rec.unit_selling_price)
5646: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_start_date,p_old_line_rec.service_start_date)
5647: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_end_date,p_old_line_rec.service_end_date)
5640: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity,p_old_line_rec.pricing_quantity)
5641: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity_uom,p_old_line_rec.pricing_quantity_uom)
5642: OR NOT OE_GLOBALS.Equal(p_new_line_rec.request_date,p_old_line_rec.request_date)
5643: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id)
5644: OR NOT OE_GLOBALS.Equal(p_new_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id)
5645: OR NOT OE_GLOBALS.Equal(p_new_line_rec.unit_selling_price,p_old_line_rec.unit_selling_price)
5646: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_start_date,p_old_line_rec.service_start_date)
5647: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_end_date,p_old_line_rec.service_end_date)
5648: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_duration,p_old_line_rec.service_duration)
5641: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity_uom,p_old_line_rec.pricing_quantity_uom)
5642: OR NOT OE_GLOBALS.Equal(p_new_line_rec.request_date,p_old_line_rec.request_date)
5643: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id)
5644: OR NOT OE_GLOBALS.Equal(p_new_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id)
5645: OR NOT OE_GLOBALS.Equal(p_new_line_rec.unit_selling_price,p_old_line_rec.unit_selling_price)
5646: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_start_date,p_old_line_rec.service_start_date)
5647: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_end_date,p_old_line_rec.service_end_date)
5648: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_duration,p_old_line_rec.service_duration)
5649: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_period,p_old_line_rec.service_period)
5642: OR NOT OE_GLOBALS.Equal(p_new_line_rec.request_date,p_old_line_rec.request_date)
5643: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id)
5644: OR NOT OE_GLOBALS.Equal(p_new_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id)
5645: OR NOT OE_GLOBALS.Equal(p_new_line_rec.unit_selling_price,p_old_line_rec.unit_selling_price)
5646: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_start_date,p_old_line_rec.service_start_date)
5647: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_end_date,p_old_line_rec.service_end_date)
5648: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_duration,p_old_line_rec.service_duration)
5649: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_period,p_old_line_rec.service_period)
5650: --Bug 4332307
5643: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id)
5644: OR NOT OE_GLOBALS.Equal(p_new_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id)
5645: OR NOT OE_GLOBALS.Equal(p_new_line_rec.unit_selling_price,p_old_line_rec.unit_selling_price)
5646: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_start_date,p_old_line_rec.service_start_date)
5647: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_end_date,p_old_line_rec.service_end_date)
5648: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_duration,p_old_line_rec.service_duration)
5649: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_period,p_old_line_rec.service_period)
5650: --Bug 4332307
5651: OR (
5644: OR NOT OE_GLOBALS.Equal(p_new_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id)
5645: OR NOT OE_GLOBALS.Equal(p_new_line_rec.unit_selling_price,p_old_line_rec.unit_selling_price)
5646: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_start_date,p_old_line_rec.service_start_date)
5647: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_end_date,p_old_line_rec.service_end_date)
5648: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_duration,p_old_line_rec.service_duration)
5649: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_period,p_old_line_rec.service_period)
5650: --Bug 4332307
5651: OR (
5652: ((p_new_line_rec.unit_list_price IS NOT NULL AND
5645: OR NOT OE_GLOBALS.Equal(p_new_line_rec.unit_selling_price,p_old_line_rec.unit_selling_price)
5646: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_start_date,p_old_line_rec.service_start_date)
5647: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_end_date,p_old_line_rec.service_end_date)
5648: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_duration,p_old_line_rec.service_duration)
5649: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_period,p_old_line_rec.service_period)
5650: --Bug 4332307
5651: OR (
5652: ((p_new_line_rec.unit_list_price IS NOT NULL AND
5653: p_new_line_rec.unit_list_price <> FND_API.G_MISS_NUM AND
5663: p_new_line_rec.order_quantity_uom is not null and
5664: p_new_line_rec.order_quantity_uom <> fnd_api.g_miss_char
5665: AND oe_code_control.code_release_level >= '110510'
5666: AND nvl(fnd_profile.value('ONT_LIST_PRICE_OVERRIDE_PRIV'), 'NONE') = 'UNLIMITED'
5667: AND OE_GLOBALS.G_UI_FLAG
5668: AND OE_Globals.G_PRICING_RECURSION = 'N'
5669: )
5670: --Bug 4332307
5671:
5664: p_new_line_rec.order_quantity_uom <> fnd_api.g_miss_char
5665: AND oe_code_control.code_release_level >= '110510'
5666: AND nvl(fnd_profile.value('ONT_LIST_PRICE_OVERRIDE_PRIV'), 'NONE') = 'UNLIMITED'
5667: AND OE_GLOBALS.G_UI_FLAG
5668: AND OE_Globals.G_PRICING_RECURSION = 'N'
5669: )
5670: --Bug 4332307
5671:
5672: Then
5710:
5711: /* Variables to call process order */
5712: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5713: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5714: l_control_rec OE_GLOBALS.Control_Rec_Type;
5715: l_line_rec OE_Order_PUB.Line_Rec_Type;
5716: x_return_status Varchar2(1);
5717: l_prg_line_id NUMBER;
5718: l_price_adj_id NUMBER;
5730: IF l_debug_level > 0 THEN
5731: oe_debug_pub.add( 'ENTERING OEXULADB.DELETE_PRG_LINES WITH LINE_ID = ' || P_LINE_ID ) ;
5732: END IF;
5733: if l_debug_level > 0 then
5734: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);
5735: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
5736: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5737: end if;
5738: l_reason_code := OE_GLOBALS.G_REASON_CODE;
5731: oe_debug_pub.add( 'ENTERING OEXULADB.DELETE_PRG_LINES WITH LINE_ID = ' || P_LINE_ID ) ;
5732: END IF;
5733: if l_debug_level > 0 then
5734: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);
5735: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
5736: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5737: end if;
5738: l_reason_code := OE_GLOBALS.G_REASON_CODE;
5739: l_reason_comments := OE_GLOBALS.G_REASON_COMMENTS;
5732: END IF;
5733: if l_debug_level > 0 then
5734: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);
5735: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
5736: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5737: end if;
5738: l_reason_code := OE_GLOBALS.G_REASON_CODE;
5739: l_reason_comments := OE_GLOBALS.G_REASON_COMMENTS;
5740: l_captured_reason := OE_GLOBALS.G_CAPTURED_REASON;
5734: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);
5735: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
5736: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5737: end if;
5738: l_reason_code := OE_GLOBALS.G_REASON_CODE;
5739: l_reason_comments := OE_GLOBALS.G_REASON_COMMENTS;
5740: l_captured_reason := OE_GLOBALS.G_CAPTURED_REASON;
5741: OPEN prg_lines;
5742: FETCH prg_lines into l_prg_line_id, l_rltd_price_adj_id;
5735: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
5736: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5737: end if;
5738: l_reason_code := OE_GLOBALS.G_REASON_CODE;
5739: l_reason_comments := OE_GLOBALS.G_REASON_COMMENTS;
5740: l_captured_reason := OE_GLOBALS.G_CAPTURED_REASON;
5741: OPEN prg_lines;
5742: FETCH prg_lines into l_prg_line_id, l_rltd_price_adj_id;
5743: WHILE prg_lines%FOUND Loop
5736: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5737: end if;
5738: l_reason_code := OE_GLOBALS.G_REASON_CODE;
5739: l_reason_comments := OE_GLOBALS.G_REASON_COMMENTS;
5740: l_captured_reason := OE_GLOBALS.G_CAPTURED_REASON;
5741: OPEN prg_lines;
5742: FETCH prg_lines into l_prg_line_id, l_rltd_price_adj_id;
5743: WHILE prg_lines%FOUND Loop
5744: IF l_debug_level > 0 THEN
5753:
5754: IF l_debug_level > 0 THEN
5755: oe_debug_pub.add( 'ORDER NOT BOOKED' ) ;
5756: END IF;
5757: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
5758:
5759: else
5760: if (l_line_rec.shipped_quantity is NULL) Then
5761: IF l_debug_level > 0 THEN
5760: if (l_line_rec.shipped_quantity is NULL) Then
5761: IF l_debug_level > 0 THEN
5762: oe_debug_pub.add( 'BOOKED ORDER , LINE NOT SHIPPED' ) ;
5763: END IF;
5764: if (p_operation = OE_GLOBALS.G_OPR_DELETE) Then
5765: -- bug 2756288, if buy line can be deleted, so can get line
5766: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
5767: else
5768: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
5762: oe_debug_pub.add( 'BOOKED ORDER , LINE NOT SHIPPED' ) ;
5763: END IF;
5764: if (p_operation = OE_GLOBALS.G_OPR_DELETE) Then
5765: -- bug 2756288, if buy line can be deleted, so can get line
5766: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
5767: else
5768: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
5769: l_line_rec.ordered_quantity := 0;
5770: l_line_rec.pricing_quantity := 0;
5764: if (p_operation = OE_GLOBALS.G_OPR_DELETE) Then
5765: -- bug 2756288, if buy line can be deleted, so can get line
5766: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
5767: else
5768: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
5769: l_line_rec.ordered_quantity := 0;
5770: l_line_rec.pricing_quantity := 0;
5771: end if;
5772: else
5772: else
5773: IF l_debug_level > 0 THEN
5774: oe_debug_pub.add( 'BOOKED ORDER , SHIPPED LINE' ) ;
5775: END IF;
5776: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
5777: l_line_rec.calculate_price_flag := 'Y';
5778: end if;
5779: end if;
5780: l_line_rec.change_reason := 'SYSTEM';
5822: , p_x_old_line_tbl => l_old_line_tbl
5823: , x_return_status => x_return_status
5824: );
5825:
5826: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
5827: END IF;
5828: FETCH prg_lines into l_prg_line_id, l_rltd_price_adj_id;
5829: End Loop;
5830: CLOSE prg_lines;
5828: FETCH prg_lines into l_prg_line_id, l_rltd_price_adj_id;
5829: End Loop;
5830: CLOSE prg_lines;
5831: if l_debug_level > 0 then
5832: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);
5833: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
5834: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5835: end if;
5836: OE_GLOBALS.G_REASON_CODE := l_reason_code;
5829: End Loop;
5830: CLOSE prg_lines;
5831: if l_debug_level > 0 then
5832: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);
5833: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
5834: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5835: end if;
5836: OE_GLOBALS.G_REASON_CODE := l_reason_code;
5837: OE_GLOBALS.G_REASON_COMMENTS := l_reason_comments;
5830: CLOSE prg_lines;
5831: if l_debug_level > 0 then
5832: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);
5833: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
5834: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5835: end if;
5836: OE_GLOBALS.G_REASON_CODE := l_reason_code;
5837: OE_GLOBALS.G_REASON_COMMENTS := l_reason_comments;
5838: OE_GLOBALS.G_CAPTURED_REASON := l_captured_reason;
5832: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);
5833: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
5834: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5835: end if;
5836: OE_GLOBALS.G_REASON_CODE := l_reason_code;
5837: OE_GLOBALS.G_REASON_COMMENTS := l_reason_comments;
5838: OE_GLOBALS.G_CAPTURED_REASON := l_captured_reason;
5839:
5840: IF l_debug_level > 0 THEN
5833: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
5834: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5835: end if;
5836: OE_GLOBALS.G_REASON_CODE := l_reason_code;
5837: OE_GLOBALS.G_REASON_COMMENTS := l_reason_comments;
5838: OE_GLOBALS.G_CAPTURED_REASON := l_captured_reason;
5839:
5840: IF l_debug_level > 0 THEN
5841: oe_debug_pub.add( 'EXITING OEXULADB.DELETE_PRG_LINES' ) ;
5834: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5835: end if;
5836: OE_GLOBALS.G_REASON_CODE := l_reason_code;
5837: OE_GLOBALS.G_REASON_COMMENTS := l_reason_comments;
5838: OE_GLOBALS.G_CAPTURED_REASON := l_captured_reason;
5839:
5840: IF l_debug_level > 0 THEN
5841: oe_debug_pub.add( 'EXITING OEXULADB.DELETE_PRG_LINES' ) ;
5842: END IF;
5854: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5855: --
5856: Begin
5857:
5858: IF p_new_line_rec.operation = OE_GLOBALS.G_OPR_DELETE OR NOT OE_GLOBALS.EQUAL(p_new_line_rec.ordered_quantity, p_old_line_rec.ordered_quantity) Then
5859: IF (nvl(p_new_line_rec.booked_flag, 'X') <> 'Y') Then
5860: IF (p_new_line_rec.operation = OE_GLOBALS.G_OPR_DELETE OR p_new_line_rec.ordered_quantity = 0) Then
5861: IF l_debug_level > 0 THEN
5862: oe_debug_pub.add( 'OPEN ORDER , ORDERED QTY CHANGED TO ZERO , DELETE ALL PRG LINES' ) ;
5856: Begin
5857:
5858: IF p_new_line_rec.operation = OE_GLOBALS.G_OPR_DELETE OR NOT OE_GLOBALS.EQUAL(p_new_line_rec.ordered_quantity, p_old_line_rec.ordered_quantity) Then
5859: IF (nvl(p_new_line_rec.booked_flag, 'X') <> 'Y') Then
5860: IF (p_new_line_rec.operation = OE_GLOBALS.G_OPR_DELETE OR p_new_line_rec.ordered_quantity = 0) Then
5861: IF l_debug_level > 0 THEN
5862: oe_debug_pub.add( 'OPEN ORDER , ORDERED QTY CHANGED TO ZERO , DELETE ALL PRG LINES' ) ;
5863: END IF;
5864: Delete_PRG_Lines(p_new_line_rec.line_id, p_new_line_rec.operation);
5866: ELSE
5867: IF (p_new_line_rec.ordered_quantity = 0 AND
5868: (p_new_line_rec.change_reason is NOT NULL OR
5869: p_new_line_rec.change_reason <> FND_API.G_MISS_CHAR))
5870: OR p_new_line_rec.operation = OE_GLOBALS.G_OPR_DELETE Then
5871: IF l_debug_level > 0 THEN
5872: oe_debug_pub.add( 'BOOKED ORDER , ORDERED QTY CHANGED TO ZERO , DELETE ALL PRG LINES' ) ;
5873: END IF;
5874: Delete_PRG_Lines(p_new_line_rec.line_id, p_new_line_rec.operation);
5904: IF l_debug_level > 0 THEN
5905: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.PROCESS_PRICING CALLED FROM ULINB' ) ;
5906: END IF;
5907:
5908: IF NOT OE_GLOBALS.Equal(p_x_new_line_rec.cancelled_quantity,p_old_line_rec.cancelled_quantity)
5909: and p_x_new_line_rec.cancelled_quantity > 0
5910: Then
5911: IF l_debug_level > 0 THEN
5912: oe_debug_pub.add( ' USER CANCELS LINE , CANCELLED QUANTITY:'||P_X_NEW_LINE_REC.CANCELLED_QUANTITY ) ;
5923: l_pricing_related_changes := True;
5924: End If;
5925:
5926:
5927: IF NOT OE_GLOBALS.Equal(p_x_new_line_rec.unit_cost,p_old_line_rec.unit_cost)
5928: Then
5929: IF l_debug_level > 0 THEN
5930: oe_debug_pub.add( ' BOOKED FLAG OR UNIT COST CHANGES' ) ;
5931: END IF;
5977: IF l_debug_level > 0 THEN
5978: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR MARGIN HOLD FOR BOOKED LINE_ID:'||P_X_NEW_LINE_REC.LINE_ID ) ;
5979: END IF;
5980: oe_delayed_requests_pvt.log_request(
5981: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5982: p_entity_id => p_x_new_line_rec.header_id,
5983:
5984: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5985: p_requesting_entity_id => p_x_new_line_rec.header_id,
5980: oe_delayed_requests_pvt.log_request(
5981: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5982: p_entity_id => p_x_new_line_rec.header_id,
5983:
5984: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5985: p_requesting_entity_id => p_x_new_line_rec.header_id,
5986:
5987: p_request_type => 'MARGIN_HOLD',
5988: x_return_status => l_return_status);
6009: oe_debug_pub.add( 'NEW PRICING_DATE = '||P_X_NEW_LINE_REC.PRICING_DATE , 1 ) ;
6010: oe_debug_pub.add( 'OLD PRICING_DATE = '||P_OLD_LINE_REC.PRICING_DATE , 1 ) ;
6011: END IF;
6012:
6013: IF NOT OE_GLOBALS.Equal(p_x_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
6014: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.ship_from_org_id,p_old_line_rec.ship_from_org_id)
6015: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.project_id,p_old_line_rec.project_id)
6016: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.actual_shipment_date,p_old_line_rec.actual_shipment_date)
6017: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.fulfillment_date,p_old_line_rec.fulfillment_date)
6010: oe_debug_pub.add( 'OLD PRICING_DATE = '||P_OLD_LINE_REC.PRICING_DATE , 1 ) ;
6011: END IF;
6012:
6013: IF NOT OE_GLOBALS.Equal(p_x_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
6014: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.ship_from_org_id,p_old_line_rec.ship_from_org_id)
6015: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.project_id,p_old_line_rec.project_id)
6016: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.actual_shipment_date,p_old_line_rec.actual_shipment_date)
6017: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.fulfillment_date,p_old_line_rec.fulfillment_date)
6018: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
6011: END IF;
6012:
6013: IF NOT OE_GLOBALS.Equal(p_x_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
6014: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.ship_from_org_id,p_old_line_rec.ship_from_org_id)
6015: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.project_id,p_old_line_rec.project_id)
6016: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.actual_shipment_date,p_old_line_rec.actual_shipment_date)
6017: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.fulfillment_date,p_old_line_rec.fulfillment_date)
6018: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
6019: THEN
6012:
6013: IF NOT OE_GLOBALS.Equal(p_x_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
6014: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.ship_from_org_id,p_old_line_rec.ship_from_org_id)
6015: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.project_id,p_old_line_rec.project_id)
6016: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.actual_shipment_date,p_old_line_rec.actual_shipment_date)
6017: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.fulfillment_date,p_old_line_rec.fulfillment_date)
6018: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
6019: THEN
6020: IF Oe_Sys_Parameters.Value('COMPUTE_MARGIN') <> 'N' Then
6013: IF NOT OE_GLOBALS.Equal(p_x_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
6014: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.ship_from_org_id,p_old_line_rec.ship_from_org_id)
6015: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.project_id,p_old_line_rec.project_id)
6016: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.actual_shipment_date,p_old_line_rec.actual_shipment_date)
6017: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.fulfillment_date,p_old_line_rec.fulfillment_date)
6018: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
6019: THEN
6020: IF Oe_Sys_Parameters.Value('COMPUTE_MARGIN') <> 'N' Then
6021: IF l_debug_level > 0 THEN
6014: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.ship_from_org_id,p_old_line_rec.ship_from_org_id)
6015: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.project_id,p_old_line_rec.project_id)
6016: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.actual_shipment_date,p_old_line_rec.actual_shipment_date)
6017: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.fulfillment_date,p_old_line_rec.fulfillment_date)
6018: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
6019: THEN
6020: IF Oe_Sys_Parameters.Value('COMPUTE_MARGIN') <> 'N' Then
6021: IF l_debug_level > 0 THEN
6022: oe_debug_pub.add( 'BEFORE OE_DELAYED_REQUESTS_PVT.LOG_REQUEST CALL' ) ;
6023: oe_debug_pub.add( 'IN PROCESS_PRICING OEXULADB.PLS' ) ;
6024: END IF;
6025:
6026: oe_delayed_requests_pvt.log_request(
6027: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6028: p_entity_id => p_x_new_line_rec.line_id,
6029: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6030:
6031: p_requesting_entity_id => p_x_new_line_rec.line_id,
6025:
6026: oe_delayed_requests_pvt.log_request(
6027: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6028: p_entity_id => p_x_new_line_rec.line_id,
6029: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6030:
6031: p_requesting_entity_id => p_x_new_line_rec.line_id,
6032: p_request_type => 'GET_COST',
6033: x_return_status => l_return_status);
6061: Begin
6062:
6063: IF p_price_flag = 'Y' and
6064: not p_no_price_flag and
6065: nvl(oe_globals.g_pricing_recursion,'N') <> 'Y' and
6066: p_x_new_line_rec.Ordered_Quantity <> fnd_api.g_miss_num and
6067: p_x_new_line_rec.order_quantity_uom is not null and
6068: p_x_new_line_rec.order_quantity_uom <> fnd_api.g_miss_char
6069: THEN
6076: END IF;
6077: If
6078: ( (p_x_new_line_rec.unit_list_price is null or
6079: p_x_new_line_rec.Unit_List_Price = fnd_api.g_miss_num or
6080: NOT OE_GLOBALS.Equal(p_x_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity) or
6081: NOT OE_GLOBALS.Equal(p_x_new_line_rec.cancelled_Quantity,p_old_line_rec.cancelled_Quantity) or
6082: NOT OE_GLOBALS.Equal(p_x_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom) or
6083: NOT OE_GLOBALS.Equal(p_x_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id) ) --fix bug 1388503 btea
6084: and p_x_new_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_SERVICE
6077: If
6078: ( (p_x_new_line_rec.unit_list_price is null or
6079: p_x_new_line_rec.Unit_List_Price = fnd_api.g_miss_num or
6080: NOT OE_GLOBALS.Equal(p_x_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity) or
6081: NOT OE_GLOBALS.Equal(p_x_new_line_rec.cancelled_Quantity,p_old_line_rec.cancelled_Quantity) or
6082: NOT OE_GLOBALS.Equal(p_x_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom) or
6083: NOT OE_GLOBALS.Equal(p_x_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id) ) --fix bug 1388503 btea
6084: and p_x_new_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_SERVICE
6085: )
6078: ( (p_x_new_line_rec.unit_list_price is null or
6079: p_x_new_line_rec.Unit_List_Price = fnd_api.g_miss_num or
6080: NOT OE_GLOBALS.Equal(p_x_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity) or
6081: NOT OE_GLOBALS.Equal(p_x_new_line_rec.cancelled_Quantity,p_old_line_rec.cancelled_Quantity) or
6082: NOT OE_GLOBALS.Equal(p_x_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom) or
6083: NOT OE_GLOBALS.Equal(p_x_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id) ) --fix bug 1388503 btea
6084: and p_x_new_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_SERVICE
6085: )
6086: then
6079: p_x_new_line_rec.Unit_List_Price = fnd_api.g_miss_num or
6080: NOT OE_GLOBALS.Equal(p_x_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity) or
6081: NOT OE_GLOBALS.Equal(p_x_new_line_rec.cancelled_Quantity,p_old_line_rec.cancelled_Quantity) or
6082: NOT OE_GLOBALS.Equal(p_x_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom) or
6083: NOT OE_GLOBALS.Equal(p_x_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id) ) --fix bug 1388503 btea
6084: and p_x_new_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_SERVICE
6085: )
6086: then
6087:
6080: NOT OE_GLOBALS.Equal(p_x_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity) or
6081: NOT OE_GLOBALS.Equal(p_x_new_line_rec.cancelled_Quantity,p_old_line_rec.cancelled_Quantity) or
6082: NOT OE_GLOBALS.Equal(p_x_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom) or
6083: NOT OE_GLOBALS.Equal(p_x_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id) ) --fix bug 1388503 btea
6084: and p_x_new_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_SERVICE
6085: )
6086: then
6087:
6088:
6085: )
6086: then
6087:
6088:
6089: IF ((OE_GLOBALS.G_UI_FLAG) and (nvl(Oe_Config_Pvt.oecfg_configuration_pricing,'N')='N'))
6090: THEN
6091:
6092: l_Price_Control_Rec.pricing_event := 'PRICE';
6093: l_Price_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
6118: IF l_debug_level > 0 THEN
6119: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR PRICING' ) ;
6120: END IF;
6121:
6122: IF ((OE_GLOBALS.G_UI_FLAG) and (nvl(Oe_Config_Pvt.oecfg_configuration_pricing,'N')='N')) OR
6123: p_x_new_line_rec.item_type_code = 'INCLUDED' THEN
6124: IF l_debug_level > 0 THEN
6125: oe_debug_pub.add( 'UI MODE OR CONFIG , INCLUDED ITEM'||P_X_NEW_LINE_REC.LINE_ID ) ;
6126: END IF;
6126: END IF;
6127: IF NOT l_zero_line_qty THEN
6128: --bsadri don't call this for a cancelled line
6129: OE_delayed_requests_Pvt.log_request(
6130: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6131: p_entity_id => p_x_new_line_rec.line_id,
6132: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6133: p_requesting_entity_id => p_x_new_line_rec.line_id,
6134: p_request_unique_key1 => 'LINE',
6128: --bsadri don't call this for a cancelled line
6129: OE_delayed_requests_Pvt.log_request(
6130: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6131: p_entity_id => p_x_new_line_rec.line_id,
6132: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6133: p_requesting_entity_id => p_x_new_line_rec.line_id,
6134: p_request_unique_key1 => 'LINE',
6135: p_param1 => p_x_new_line_rec.header_id,
6136: p_param2 => 'LINE',
6133: p_requesting_entity_id => p_x_new_line_rec.line_id,
6134: p_request_unique_key1 => 'LINE',
6135: p_param1 => p_x_new_line_rec.header_id,
6136: p_param2 => 'LINE',
6137: p_request_type => OE_GLOBALS.G_PRICE_LINE,
6138: x_return_status => l_return_status);
6139:
6140: END IF;
6141: IF p_x_new_line_rec.item_type_code <> 'INCLUDED' THEN
6139:
6140: END IF;
6141: IF p_x_new_line_rec.item_type_code <> 'INCLUDED' THEN
6142: OE_delayed_requests_Pvt.log_request(
6143: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6144: p_entity_id => p_x_new_line_rec.Header_Id,
6145: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6146: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6147: p_request_unique_key1 => 'ORDER',
6141: IF p_x_new_line_rec.item_type_code <> 'INCLUDED' THEN
6142: OE_delayed_requests_Pvt.log_request(
6143: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6144: p_entity_id => p_x_new_line_rec.Header_Id,
6145: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6146: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6147: p_request_unique_key1 => 'ORDER',
6148: p_param1 => p_x_new_line_rec.header_id,
6149: p_param2 => 'ORDER',
6146: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6147: p_request_unique_key1 => 'ORDER',
6148: p_param1 => p_x_new_line_rec.header_id,
6149: p_param2 => 'ORDER',
6150: p_request_type => OE_GLOBALS.G_PRICE_ORDER,
6151: x_return_status => l_return_status);
6152: END IF;
6153: ELSE
6154: IF l_debug_level > 0 THEN
6155: oe_debug_pub.add( 'BATCH MODE' ) ;
6156: END IF;
6157:
6158: OE_delayed_requests_Pvt.log_request(
6159: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6160: p_entity_id => p_x_new_line_rec.Header_Id,
6161: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6162: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6163: p_request_unique_key1 => 'BATCH',
6157:
6158: OE_delayed_requests_Pvt.log_request(
6159: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6160: p_entity_id => p_x_new_line_rec.Header_Id,
6161: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6162: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6163: p_request_unique_key1 => 'BATCH',
6164: p_param1 => p_x_new_line_rec.header_id,
6165: p_param2 => 'BATCH',
6162: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6163: p_request_unique_key1 => 'BATCH',
6164: p_param1 => p_x_new_line_rec.header_id,
6165: p_param2 => 'BATCH',
6166: p_request_type => OE_GLOBALS.G_PRICE_ORDER,
6167: x_return_status => l_return_status);
6168: END IF;
6169:
6170: If p_x_new_line_rec.booked_flag='Y' and p_x_new_line_rec.item_type_code <> 'INCLUDED' Then
6168: END IF;
6169:
6170: If p_x_new_line_rec.booked_flag='Y' and p_x_new_line_rec.item_type_code <> 'INCLUDED' Then
6171: OE_delayed_requests_Pvt.log_request(
6172: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6173: p_entity_id => p_x_new_line_rec.Header_Id,
6174: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6175: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6176: p_request_unique_key1 => 'BOOK',
6170: If p_x_new_line_rec.booked_flag='Y' and p_x_new_line_rec.item_type_code <> 'INCLUDED' Then
6171: OE_delayed_requests_Pvt.log_request(
6172: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6173: p_entity_id => p_x_new_line_rec.Header_Id,
6174: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6175: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6176: p_request_unique_key1 => 'BOOK',
6177: p_param1 => p_x_new_line_rec.header_id,
6178: p_param2 => 'BOOK',
6175: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6176: p_request_unique_key1 => 'BOOK',
6177: p_param1 => p_x_new_line_rec.header_id,
6178: p_param2 => 'BOOK',
6179: p_request_type => OE_GLOBALS.G_PRICE_ORDER,
6180: x_return_status => l_return_status);
6181: End If;
6182:
6183: END IF;
6191: */
6192:
6193: IF l_debug_level > 0 THEN
6194: oe_debug_pub.add( 'PRICE_FLAG = ' || P_PRICE_FLAG ) ;
6195: oe_debug_pub.add( 'G_PRICING_RECURSION = ' || OE_GLOBALS.G_PRICING_RECURSION ) ;
6196: oe_debug_pub.add( 'ORDERED QUANTITY = '|| TO_CHAR ( P_X_NEW_LINE_REC.ORDERED_QUANTITY ) ) ;
6197: oe_debug_pub.add( 'ORDERED QTY UOM = ' || P_X_NEW_LINE_REC.ORDER_QUANTITY_UOM ) ;
6198: oe_debug_pub.add( 'CALCULATE_PRICE_FLAG = '|| P_X_NEW_LINE_REC.CALCULATE_PRICE_FLAG ) ;
6199: END IF;
6200:
6201:
6202: if (p_price_flag = 'Y' and
6203: not p_no_price_flag and
6204: oe_globals.g_pricing_recursion = 'Y' and
6205: nvl(p_x_new_line_rec.ordered_quantity,0) <> 0 and
6206: p_x_new_line_rec.Ordered_Quantity <> fnd_api.g_miss_num and
6207: p_x_new_line_rec.order_quantity_uom is not null and
6208: p_x_new_line_rec.order_quantity_uom <> fnd_api.g_miss_char and
6217: IF l_debug_level > 0 THEN
6218: oe_debug_pub.add( 'LOGGING A REQUEST TO PRICE_LINE IN BATCH MODE' ) ;
6219: END IF;
6220: OE_delayed_requests_Pvt.log_request(
6221: p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
6222: p_entity_id => p_x_new_line_rec.line_Id,
6223: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6224: p_requesting_entity_id => p_x_new_line_rec.line_Id,
6225: p_request_unique_key1 => 'BATCH',
6219: END IF;
6220: OE_delayed_requests_Pvt.log_request(
6221: p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
6222: p_entity_id => p_x_new_line_rec.line_Id,
6223: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6224: p_requesting_entity_id => p_x_new_line_rec.line_Id,
6225: p_request_unique_key1 => 'BATCH',
6226: p_param1 => p_x_new_line_rec.header_id,
6227: p_param2 => 'BATCH',
6224: p_requesting_entity_id => p_x_new_line_rec.line_Id,
6225: p_request_unique_key1 => 'BATCH',
6226: p_param1 => p_x_new_line_rec.header_id,
6227: p_param2 => 'BATCH',
6228: p_request_type => OE_GLOBALS.G_PRICE_LINE,
6229: x_return_status => l_return_status);
6230:
6231: if (p_x_new_line_rec.booked_flag = 'Y')
6232: then
6233: IF l_debug_level > 0 THEN
6234: oe_debug_pub.add( 'BOOKED ORDER -- LOG A REQUEST TO PRICE LINE' ) ;
6235: END IF;
6236: OE_delayed_requests_Pvt.log_request(
6237: p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
6238: p_entity_id => p_x_new_line_rec.line_Id,
6239: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6240: p_requesting_entity_id => p_x_new_line_rec.line_Id,
6241: p_request_unique_key1 => 'BOOK',
6235: END IF;
6236: OE_delayed_requests_Pvt.log_request(
6237: p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
6238: p_entity_id => p_x_new_line_rec.line_Id,
6239: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6240: p_requesting_entity_id => p_x_new_line_rec.line_Id,
6241: p_request_unique_key1 => 'BOOK',
6242: p_param1 => p_x_new_line_rec.header_id,
6243: p_param2 => 'BOOK',
6240: p_requesting_entity_id => p_x_new_line_rec.line_Id,
6241: p_request_unique_key1 => 'BOOK',
6242: p_param1 => p_x_new_line_rec.header_id,
6243: p_param2 => 'BOOK',
6244: p_request_type => OE_GLOBALS.G_PRICE_LINE,
6245: x_return_status => l_return_status);
6246: end if; -- if order is BOOKED
6247:
6248: end if; -- if new line created by Promotional modifier needs to be re-priced.
6248: end if; -- if new line created by Promotional modifier needs to be re-priced.
6249:
6250: -- end of fix for bug 1729372
6251:
6252: If NOT OE_GLOBALS.Equal(p_x_new_line_rec.Shipped_Quantity,p_old_line_rec.Shipped_Quantity)
6253: Then
6254: --btea
6255: IF p_x_new_line_rec.line_category_code <> 'RETURN' Then
6256: OE_Shipping_Integration_PVT.Check_Shipment_Line(
6258: , p_shipped_quantity => p_x_new_line_rec.Shipped_Quantity
6259: , x_result_out => l_x_result_out
6260: );
6261:
6262: IF l_x_result_out = OE_GLOBALS.G_PARTIALLY_SHIPPED THEN
6263: -- This line will split, set the calculate_price_flag to 'P' if 'Y'
6264: IF (p_x_new_line_rec.calculate_price_flag = 'Y') THEN
6265: p_x_new_line_rec.calculate_price_flag := 'P';
6266: END IF;
6267:
6268:
6269: END IF;
6270:
6271: Elsif p_x_new_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
6272: and p_x_new_line_rec.split_by = 'SYSTEM'
6273: and p_x_new_line_rec.split_action_code = 'SPLIT'
6274: and p_x_new_line_rec.calculate_price_flag = 'Y' Then
6275: p_x_new_line_rec.calculate_price_flag :='P';
6275: p_x_new_line_rec.calculate_price_flag :='P';
6276: End If;
6277:
6278: OE_delayed_requests_Pvt.log_request(
6279: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6280: p_entity_id => p_x_new_line_rec.line_id,
6281: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6282: p_requesting_entity_id => p_x_new_line_rec.line_id,
6283: p_request_unique_key1 => 'SHIP',
6277:
6278: OE_delayed_requests_Pvt.log_request(
6279: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6280: p_entity_id => p_x_new_line_rec.line_id,
6281: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6282: p_requesting_entity_id => p_x_new_line_rec.line_id,
6283: p_request_unique_key1 => 'SHIP',
6284: p_param1 => p_x_new_line_rec.header_id,
6285: p_param2 => 'SHIP',
6282: p_requesting_entity_id => p_x_new_line_rec.line_id,
6283: p_request_unique_key1 => 'SHIP',
6284: p_param1 => p_x_new_line_rec.header_id,
6285: p_param2 => 'SHIP',
6286: p_request_type => OE_GLOBALS.G_PRICE_LINE,
6287: x_return_status => l_return_status);
6288: End If;
6289:
6290: End;
6327: ------------------------------------------------------
6328: --Special case, bypass regular pricing path
6329: --we log performant version of pricing delayed request
6330: ------------------------------------------------------
6331: OE_GLOBALS.G_PRICE_FLAG := 'N';
6332:
6333:
6334: QP_UTIL_PUB.Get_Order_Lines_Status('BATCH,BOOK',l_order_status_rec);
6335: ----------------------------------------------------------------------
6359: --FP bug 3335024 included summary line flag condition below
6360: If l_order_status_rec.ALL_LINES_FLAG = 'Y' or l_order_status_rec.summary_line_flag = 'Y' Then
6361: IF p_x_new_line_rec.item_type_code not in ('INCLUDED','CONFIG') THEN
6362: OE_delayed_requests_Pvt.log_request(
6363: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6364: p_entity_id => p_x_new_line_rec.Header_Id,
6365: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6366: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6367: p_request_unique_key1 => 'ORDER,BOOK',
6361: IF p_x_new_line_rec.item_type_code not in ('INCLUDED','CONFIG') THEN
6362: OE_delayed_requests_Pvt.log_request(
6363: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6364: p_entity_id => p_x_new_line_rec.Header_Id,
6365: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6366: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6367: p_request_unique_key1 => 'ORDER,BOOK',
6368: p_param1 => p_x_new_line_rec.header_id,
6369: p_param2 => l_event_str,
6366: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6367: p_request_unique_key1 => 'ORDER,BOOK',
6368: p_param1 => p_x_new_line_rec.header_id,
6369: p_param2 => l_event_str,
6370: p_request_type => OE_GLOBALS.G_PRICE_ORDER,
6371: x_return_status => l_return_status);
6372:
6373: End If;
6374: End If;
6376: IF l_debug_level > 0 THEN
6377: oe_debug_pub.add( 'LOG REVERSE_LIMITS DELAYED REQUEST FROM PROCESS_CANCELLED_LINES ' , 1 ) ;
6378: END IF;
6379: OE_delayed_requests_Pvt.log_request(
6380: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6381: p_entity_id => p_x_new_line_rec.line_id,
6382: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6383: p_requesting_entity_id => p_x_new_line_rec.line_id,
6384: p_request_unique_key1 => 'LINE',
6378: END IF;
6379: OE_delayed_requests_Pvt.log_request(
6380: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6381: p_entity_id => p_x_new_line_rec.line_id,
6382: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6383: p_requesting_entity_id => p_x_new_line_rec.line_id,
6384: p_request_unique_key1 => 'LINE',
6385: p_param1 => 'CANCEL',
6386: p_param2 => p_x_new_line_rec.price_request_code,
6387: p_param3 => NULL,
6388: p_param4 => NULL,
6389: p_param5 => NULL,
6390: p_param6 => NULL,
6391: p_request_type => OE_GLOBALS.G_REVERSE_LIMITS,
6392: x_return_status => l_return_status);
6393: IF l_debug_level > 0 THEN
6394: oe_debug_pub.add( 'REVERSE_LIMITS DELAYED REQUEST HAS BEEN LOGGED' , 1 ) ;
6395: END IF;
6415: --treat changed_lines as all_lines for now, will to
6416: --differential this 2 type in the future
6417: IF p_x_new_line_rec.item_type_code not in ('INCLUDED','CONFIG') THEN
6418: OE_delayed_requests_Pvt.log_request(
6419: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6420: p_entity_id => p_x_new_line_rec.Header_Id,
6421: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6422: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6423: p_request_unique_key1 => 'BATCH,BOOK',
6417: IF p_x_new_line_rec.item_type_code not in ('INCLUDED','CONFIG') THEN
6418: OE_delayed_requests_Pvt.log_request(
6419: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6420: p_entity_id => p_x_new_line_rec.Header_Id,
6421: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6422: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6423: p_request_unique_key1 => 'BATCH,BOOK',
6424: p_param1 => p_x_new_line_rec.header_id,
6425: p_param2 => l_event_str,
6422: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6423: p_request_unique_key1 => 'BATCH,BOOK',
6424: p_param1 => p_x_new_line_rec.header_id,
6425: p_param2 => l_event_str,
6426: p_request_type => OE_GLOBALS.G_PRICE_ORDER,
6427: x_return_status => l_return_status);
6428:
6429: End If; --not in ('INCLUDED','CONFIG')
6430: End If; --ALL_LINES or Change_lines flag
6436: PROCESS_CANCELLED_LINES FOR PARTIAL CANCEL CASE' , 1 ) ;
6437: END IF;
6438:
6439: OE_delayed_requests_Pvt.log_request(
6440: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6441: p_entity_id => p_x_new_line_rec.line_id,
6442: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6443: p_requesting_entity_id => p_x_new_line_rec.line_id,
6444: p_request_unique_key1 => 'LINE',
6438:
6439: OE_delayed_requests_Pvt.log_request(
6440: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6441: p_entity_id => p_x_new_line_rec.line_id,
6442: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6443: p_requesting_entity_id => p_x_new_line_rec.line_id,
6444: p_request_unique_key1 => 'LINE',
6445: p_param1 => 'AMEND',
6446: p_param2 => p_x_new_line_rec.price_request_code,
6447: p_param3 => p_ordered_quantity,
6448: p_param4 => p_x_new_line_rec.ordered_quantity,
6449: p_param5 => NULL,
6450: p_param6 => NULL,
6451: p_request_type =>OE_GLOBALS.G_REVERSE_LIMITS,
6452: x_return_status => l_return_status);
6453:
6454: IF l_debug_level > 0 THEN
6455: oe_debug_pub.add( 'REVERSE_LIMITS DELAYED REQUEST HAS BEEN LOGGED' , 1 ) ;
6490: IF l_debug_level > 0 THEN
6491: oe_debug_pub.add( ' LOGGING DELAYED REQUEST TO RESET G_CHANGED_LINE_TBL' ) ;
6492: END IF;
6493: oe_delayed_requests_pvt.log_request(
6494: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6495: p_entity_id => p_header_id,
6496: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6497: p_requesting_entity_id => p_header_id,
6498: p_request_type => OE_GLOBALS.G_DEL_CHG_LINES,
6492: END IF;
6493: oe_delayed_requests_pvt.log_request(
6494: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6495: p_entity_id => p_header_id,
6496: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6497: p_requesting_entity_id => p_header_id,
6498: p_request_type => OE_GLOBALS.G_DEL_CHG_LINES,
6499: x_return_status => l_return_status);
6500: IF l_debug_level > 0 THEN
6494: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6495: p_entity_id => p_header_id,
6496: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6497: p_requesting_entity_id => p_header_id,
6498: p_request_type => OE_GLOBALS.G_DEL_CHG_LINES,
6499: x_return_status => l_return_status);
6500: IF l_debug_level > 0 THEN
6501: oe_debug_pub.add( ' RETURN STATUS FROM THE DELAYED REQUEST:'||L_RETURN_STATUS ) ;
6502: END IF;
6501: oe_debug_pub.add( ' RETURN STATUS FROM THE DELAYED REQUEST:'||L_RETURN_STATUS ) ;
6502: END IF;
6503: End If;
6504:
6505: If p_operation In (OE_GLOBALS.G_OPR_CREATE,OE_GLOBALS.G_OPR_UPDATE) Then
6506: --bug 3020702 begin
6507: G_CHANGED_LINE_TBL(mod(p_line_id,G_BINARY_LIMIT)).line_id :=p_line_id;
6508: G_CHANGED_LINE_TBL(mod(p_line_id,G_BINARY_LIMIT)).header_id :=p_header_id;
6509: --bug 3020702 end
6506: --bug 3020702 begin
6507: G_CHANGED_LINE_TBL(mod(p_line_id,G_BINARY_LIMIT)).line_id :=p_line_id;
6508: G_CHANGED_LINE_TBL(mod(p_line_id,G_BINARY_LIMIT)).header_id :=p_header_id;
6509: --bug 3020702 end
6510: Elsif p_operation = OE_GLOBALS.G_OPR_DELETE Then
6511: If G_CHANGED_LINE_TBL.exists(mod(p_line_id,G_BINARY_LIMIT)) Then
6512: G_CHANGED_LINE_TBL.delete(mod(p_line_id,G_BINARY_LIMIT));
6513: End If;
6514: End If;