[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
1276: --x_Line_Adj_rec := p_Line_Adj_rec;
1277: IF l_debug_level > 0 THEN
1278: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.APPLY ATTRIBUTE CHANGES' ) ;
1279: END IF;
1280: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.adjusted_amount,p_old_Line_Adj_rec.adjusted_amount)
1281: THEN
1282: NULL;
1283: END IF;
1284:
1281: THEN
1282: NULL;
1283: END IF;
1284:
1285: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.adjusted_amount_per_pqty,p_old_Line_Adj_rec.adjusted_amount_per_pqty)
1286: THEN
1287: NULL;
1288: END IF;
1289:
1286: THEN
1287: NULL;
1288: END IF;
1289:
1290: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.pricing_phase_id,p_old_Line_Adj_rec.pricing_phase_id)
1291: THEN
1292: l_price_flag := TRUE;
1293: END IF;
1294:
1291: THEN
1292: l_price_flag := TRUE;
1293: END IF;
1294:
1295: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.price_adjustment_id,p_old_Line_Adj_rec.price_adjustment_id)
1296: THEN
1297: NULL;
1298: END IF;
1299:
1296: THEN
1297: NULL;
1298: END IF;
1299:
1300: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.creation_date,p_old_Line_Adj_rec.creation_date)
1301: THEN
1302: NULL;
1303: END IF;
1304:
1301: THEN
1302: NULL;
1303: END IF;
1304:
1305: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.created_by,p_old_Line_Adj_rec.created_by)
1306: THEN
1307: NULL;
1308: END IF;
1309:
1306: THEN
1307: NULL;
1308: END IF;
1309:
1310: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.last_update_date,p_old_Line_Adj_rec.last_update_date)
1311: THEN
1312: NULL;
1313: END IF;
1314:
1311: THEN
1312: NULL;
1313: END IF;
1314:
1315: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.last_updated_by,p_old_Line_Adj_rec.last_updated_by)
1316: THEN
1317: NULL;
1318: END IF;
1319:
1316: THEN
1317: NULL;
1318: END IF;
1319:
1320: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.last_update_login,p_old_Line_Adj_rec.last_update_login)
1321: THEN
1322: NULL;
1323: END IF;
1324:
1321: THEN
1322: NULL;
1323: END IF;
1324:
1325: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.program_application_id,p_old_Line_Adj_rec.program_application_id)
1326: THEN
1327: NULL;
1328: END IF;
1329:
1326: THEN
1327: NULL;
1328: END IF;
1329:
1330: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.program_id,p_old_Line_Adj_rec.program_id)
1331: THEN
1332: NULL;
1333: END IF;
1334:
1331: THEN
1332: NULL;
1333: END IF;
1334:
1335: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.program_update_date,p_old_Line_Adj_rec.program_update_date)
1336: THEN
1337: NULL;
1338: END IF;
1339:
1336: THEN
1337: NULL;
1338: END IF;
1339:
1340: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.request_id,p_old_Line_Adj_rec.request_id)
1341: THEN
1342: NULL;
1343: END IF;
1344:
1341: THEN
1342: NULL;
1343: END IF;
1344:
1345: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.header_id,p_old_Line_Adj_rec.header_id)
1346: THEN
1347: NULL;
1348: END IF;
1349:
1347: NULL;
1348: END IF;
1349:
1350:
1351: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.discount_id,
1352: p_old_Line_Adj_rec.discount_id)
1353: THEN
1354: Null;
1355: END IF;
1353: THEN
1354: Null;
1355: END IF;
1356:
1357: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.discount_line_id,
1358: p_old_Line_Adj_rec.discount_line_id)
1359: THEN
1360: null;
1361: END IF;
1359: THEN
1360: null;
1361: END IF;
1362:
1363: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.automatic_flag,p_old_Line_Adj_rec.automatic_flag)
1364: THEN
1365: NULL;
1366: END IF;
1367:
1364: THEN
1365: NULL;
1366: END IF;
1367:
1368: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.percent,p_old_Line_Adj_rec.percent)
1369: THEN
1370: NULL;
1371: END IF;
1372:
1369: THEN
1370: NULL;
1371: END IF;
1372:
1373: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.line_id,p_old_Line_Adj_rec.line_id)
1374: THEN
1375: NULL;
1376: END IF;
1377:
1374: THEN
1375: NULL;
1376: END IF;
1377:
1378: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.context,p_old_Line_Adj_rec.context)
1379: THEN
1380: NULL;
1381: END IF;
1382:
1379: THEN
1380: NULL;
1381: END IF;
1382:
1383: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute1,p_old_Line_Adj_rec.attribute1)
1384: THEN
1385: NULL;
1386: END IF;
1387:
1384: THEN
1385: NULL;
1386: END IF;
1387:
1388: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute2,p_old_Line_Adj_rec.attribute2)
1389: THEN
1390: NULL;
1391: END IF;
1392:
1389: THEN
1390: NULL;
1391: END IF;
1392:
1393: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute3,p_old_Line_Adj_rec.attribute3)
1394: THEN
1395: NULL;
1396: END IF;
1397:
1394: THEN
1395: NULL;
1396: END IF;
1397:
1398: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute4,p_old_Line_Adj_rec.attribute4)
1399: THEN
1400: NULL;
1401: END IF;
1402:
1399: THEN
1400: NULL;
1401: END IF;
1402:
1403: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute5,p_old_Line_Adj_rec.attribute5)
1404: THEN
1405: NULL;
1406: END IF;
1407:
1404: THEN
1405: NULL;
1406: END IF;
1407:
1408: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute6,p_old_Line_Adj_rec.attribute6)
1409: THEN
1410: NULL;
1411: END IF;
1412:
1409: THEN
1410: NULL;
1411: END IF;
1412:
1413: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute7,p_old_Line_Adj_rec.attribute7)
1414: THEN
1415: NULL;
1416: END IF;
1417:
1414: THEN
1415: NULL;
1416: END IF;
1417:
1418: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute8,p_old_Line_Adj_rec.attribute8)
1419: THEN
1420: NULL;
1421: END IF;
1422:
1419: THEN
1420: NULL;
1421: END IF;
1422:
1423: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute9,p_old_Line_Adj_rec.attribute9)
1424: THEN
1425: NULL;
1426: END IF;
1427:
1424: THEN
1425: NULL;
1426: END IF;
1427:
1428: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute10,p_old_Line_Adj_rec.attribute10)
1429: THEN
1430: NULL;
1431: END IF;
1432:
1429: THEN
1430: NULL;
1431: END IF;
1432:
1433: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute11,p_old_Line_Adj_rec.attribute11)
1434: THEN
1435: NULL;
1436: END IF;
1437:
1434: THEN
1435: NULL;
1436: END IF;
1437:
1438: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute12,p_old_Line_Adj_rec.attribute12)
1439: THEN
1440: NULL;
1441: END IF;
1442:
1439: THEN
1440: NULL;
1441: END IF;
1442:
1443: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute13,p_old_Line_Adj_rec.attribute13)
1444: THEN
1445: NULL;
1446: END IF;
1447:
1444: THEN
1445: NULL;
1446: END IF;
1447:
1448: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute14,p_old_Line_Adj_rec.attribute14)
1449: THEN
1450: NULL;
1451: END IF;
1452:
1449: THEN
1450: NULL;
1451: END IF;
1452:
1453: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.attribute15,p_old_Line_Adj_rec.attribute15)
1454: THEN
1455: NULL;
1456: END IF;
1457:
1454: THEN
1455: NULL;
1456: END IF;
1457:
1458: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.list_header_id,
1459: p_old_Line_Adj_rec.list_header_id)
1460: THEN
1461: NULL;
1462: END IF;
1460: THEN
1461: NULL;
1462: END IF;
1463:
1464: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.list_line_id,
1465: p_old_Line_Adj_rec.list_line_id)
1466: THEN
1467: NULL;
1468: END IF;
1466: THEN
1467: NULL;
1468: END IF;
1469:
1470: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.list_line_type_code,
1471: p_old_Line_Adj_rec.list_line_type_code)
1472: THEN
1473: NULL;
1474: END IF;
1472: THEN
1473: NULL;
1474: END IF;
1475:
1476: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.modifier_mechanism_type_code,
1477: p_old_Line_Adj_rec.modifier_mechanism_type_code)
1478: THEN
1479: NULL;
1480: END IF;
1478: THEN
1479: NULL;
1480: END IF;
1481:
1482: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.update_allowed,
1483: p_old_Line_Adj_rec.update_allowed)
1484: THEN
1485: NULL;
1486: END IF;
1484: THEN
1485: NULL;
1486: END IF;
1487:
1488: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.updated_flag,
1489: p_old_Line_Adj_rec.updated_flag)
1490: THEN
1491: l_price_flag := TRUE;
1492: IF p_x_line_Adj_rec.ESTIMATED_FLAG = 'Y' AND
1500: p_x_line_adj_rec.estimated_flag := 'Y';
1501: END IF;
1502: END IF;
1503:
1504: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.applied_flag,
1505: p_old_Line_Adj_rec.applied_flag)
1506: THEN
1507: l_price_flag := TRUE;
1508: --added by ksurendr
1528: null;
1529: END;
1530: END IF;
1531:
1532: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.modified_from,
1533: p_old_Line_Adj_rec.modified_from)
1534: THEN
1535: NULL;
1536: END IF;
1534: THEN
1535: NULL;
1536: END IF;
1537:
1538: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.modified_to,
1539: p_old_Line_Adj_rec.modified_to)
1540: THEN
1541: NULL;
1542: END IF;
1541: NULL;
1542: END IF;
1543:
1544:
1545: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.change_reason_code,
1546: p_old_Line_Adj_rec.change_reason_code)
1547: THEN
1548: NULL;
1549: END IF;
1547: THEN
1548: NULL;
1549: END IF;
1550:
1551: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.change_reason_text,
1552: p_old_Line_Adj_rec.change_reason_text)
1553: THEN
1554: NULL;
1555: END IF;
1553: THEN
1554: NULL;
1555: END IF;
1556:
1557: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.operand,
1558: p_old_Line_Adj_rec.operand)
1559: THEN
1560: l_price_flag := TRUE;
1561: l_calculate_commitment_flag := 'Y';
1569: l_verify_payment_flag := 'Y';
1570: END IF;
1571: END IF;
1572:
1573: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.operand_per_pqty,
1574: p_old_Line_Adj_rec.operand_per_pqty)
1575: THEN
1576: l_price_flag := TRUE;
1577: END IF;
1575: THEN
1576: l_price_flag := TRUE;
1577: END IF;
1578:
1579: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.arithmetic_operator,
1580: p_old_Line_Adj_rec.arithmetic_operator)
1581: THEN
1582: l_price_flag := TRUE;
1583: END IF;
1581: THEN
1582: l_price_flag := TRUE;
1583: END IF;
1584:
1585: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.COST_ID, p_old_Line_Adj_rec.COST_ID)
1586: THEN
1587: NULL;
1588: END IF;
1589:
1586: THEN
1587: NULL;
1588: END IF;
1589:
1590: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.TAX_CODE, p_old_Line_Adj_rec.TAX_CODE)
1591: THEN
1592: NULL;
1593: END IF;
1594:
1591: THEN
1592: NULL;
1593: END IF;
1594:
1595: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.TAX_EXEMPT_FLAG, p_old_Line_Adj_rec.TAX_EXEMPT_FLAG)
1596: THEN
1597: NULL;
1598: END IF;
1599:
1596: THEN
1597: NULL;
1598: END IF;
1599:
1600: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.TAX_EXEMPT_NUMBER, p_old_Line_Adj_rec.TAX_EXEMPT_NUMBER)
1601: THEN
1602: NULL;
1603: END IF;
1604:
1601: THEN
1602: NULL;
1603: END IF;
1604:
1605: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.TAX_EXEMPT_REASON_CODE, p_old_Line_Adj_rec.TAX_EXEMPT_REASON_CODE)
1606: THEN
1607: NULL;
1608: END IF;
1609:
1606: THEN
1607: NULL;
1608: END IF;
1609:
1610: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.PARENT_ADJUSTMENT_ID, p_old_Line_Adj_rec.PARENT_ADJUSTMENT_ID)
1611: THEN
1612: NULL;
1613: END IF;
1614:
1611: THEN
1612: NULL;
1613: END IF;
1614:
1615: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.INVOICED_FLAG, p_old_Line_Adj_rec.INVOICED_FLAG)
1616: THEN
1617: NULL;
1618: END IF;
1619:
1616: THEN
1617: NULL;
1618: END IF;
1619:
1620: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.ESTIMATED_FLAG, p_old_Line_Adj_rec.ESTIMATED_FLAG)
1621: THEN
1622: NULL;
1623: END IF;
1624:
1621: THEN
1622: NULL;
1623: END IF;
1624:
1625: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.INC_IN_SALES_PERFORMANCE, p_old_Line_Adj_rec.INC_IN_SALES_PERFORMANCE)
1626: THEN
1627: NULL;
1628: END IF;
1629:
1626: THEN
1627: NULL;
1628: END IF;
1629:
1630: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.SPLIT_ACTION_CODE, p_old_Line_Adj_rec.SPLIT_ACTION_CODE)
1631: THEN
1632: NULL;
1633: END IF;
1634:
1631: THEN
1632: NULL;
1633: END IF;
1634:
1635: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.CHARGE_TYPE_CODE, p_old_Line_Adj_rec.CHARGE_TYPE_CODE)
1636: THEN
1637: NULL;
1638: END IF;
1639:
1636: THEN
1637: NULL;
1638: END IF;
1639:
1640: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.CHARGE_SUBTYPE_CODE, p_old_Line_Adj_rec.CHARGE_SUBTYPE_CODE)
1641: THEN
1642: NULL;
1643: END IF;
1644:
1641: THEN
1642: NULL;
1643: END IF;
1644:
1645: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.list_line_no, p_old_Line_Adj_rec.list_line_no)
1646: THEN
1647: NULL;
1648: END IF;
1649:
1646: THEN
1647: NULL;
1648: END IF;
1649:
1650: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.source_system_code, p_old_Line_Adj_rec.source_system_code)
1651: THEN
1652: NULL;
1653: END IF;
1654:
1651: THEN
1652: NULL;
1653: END IF;
1654:
1655: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.benefit_qty, p_old_Line_Adj_rec.benefit_qty)
1656: THEN
1657: NULL;
1658: END IF;
1659:
1656: THEN
1657: NULL;
1658: END IF;
1659:
1660: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.benefit_uom_code, p_old_Line_Adj_rec.benefit_uom_code)
1661: THEN
1662: NULL;
1663: END IF;
1664:
1661: THEN
1662: NULL;
1663: END IF;
1664:
1665: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.print_on_invoice_flag, p_old_Line_Adj_rec.print_on_invoice_flag)
1666: THEN
1667: NULL;
1668: END IF;
1669:
1666: THEN
1667: NULL;
1668: END IF;
1669:
1670: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.expiration_date, p_old_Line_Adj_rec.expiration_date)
1671: THEN
1672: NULL;
1673: END IF;
1674:
1671: THEN
1672: NULL;
1673: END IF;
1674:
1675: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.rebate_transaction_type_code, p_old_Line_Adj_rec.rebate_transaction_type_code)
1676: THEN
1677: NULL;
1678: END IF;
1679:
1676: THEN
1677: NULL;
1678: END IF;
1679:
1680: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.rebate_transaction_reference, p_old_Line_Adj_rec.rebate_transaction_reference)
1681: THEN
1682: NULL;
1683: END IF;
1684:
1681: THEN
1682: NULL;
1683: END IF;
1684:
1685: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.rebate_payment_system_code, p_old_Line_Adj_rec.rebate_payment_system_code)
1686: THEN
1687: NULL;
1688: END IF;
1689:
1686: THEN
1687: NULL;
1688: END IF;
1689:
1690: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.redeemed_date, p_old_Line_Adj_rec.redeemed_date)
1691: THEN
1692: NULL;
1693: END IF;
1694:
1691: THEN
1692: NULL;
1693: END IF;
1694:
1695: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.redeemed_flag, p_old_Line_Adj_rec.redeemed_flag)
1696: THEN
1697: NULL;
1698: END IF;
1699:
1696: THEN
1697: NULL;
1698: END IF;
1699:
1700: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.accrual_flag, p_old_Line_Adj_rec.accrual_flag)
1701: THEN
1702: NULL;
1703: END IF;
1704:
1701: THEN
1702: NULL;
1703: END IF;
1704:
1705: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.range_break_quantity, p_old_Line_Adj_rec.range_break_quantity)
1706: THEN
1707: NULL;
1708: END IF;
1709:
1706: THEN
1707: NULL;
1708: END IF;
1709:
1710: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.accrual_conversion_rate, p_old_Line_Adj_rec.accrual_conversion_rate)
1711: THEN
1712: NULL;
1713: END IF;
1714:
1711: THEN
1712: NULL;
1713: END IF;
1714:
1715: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.pricing_group_sequence, p_old_Line_Adj_rec.pricing_group_sequence)
1716: THEN
1717: l_price_flag := TRUE;
1718: END IF;
1719:
1716: THEN
1717: l_price_flag := TRUE;
1718: END IF;
1719:
1720: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.modifier_level_code, p_old_Line_Adj_rec.modifier_level_code)
1721: THEN
1722: NULL;
1723: END IF;
1724:
1721: THEN
1722: NULL;
1723: END IF;
1724:
1725: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.price_break_type_code, p_old_Line_Adj_rec.price_break_type_code)
1726: THEN
1727: NULL;
1728: END IF;
1729:
1726: THEN
1727: NULL;
1728: END IF;
1729:
1730: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.substitution_attribute, p_old_Line_Adj_rec.substitution_attribute)
1731: THEN
1732: NULL;
1733: END IF;
1734:
1731: THEN
1732: NULL;
1733: END IF;
1734:
1735: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.proration_type_code, p_old_Line_Adj_rec.proration_type_code)
1736: THEN
1737: NULL;
1738: END IF;
1739:
1736: THEN
1737: NULL;
1738: END IF;
1739:
1740: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.credit_or_charge_flag, p_old_Line_Adj_rec.credit_or_charge_flag)
1741: THEN
1742: NULL;
1743: END IF;
1744:
1741: THEN
1742: NULL;
1743: END IF;
1744:
1745: IF NOT OE_GLOBALS.Equal(p_x_Line_Adj_rec.include_on_returns_flag, p_old_Line_Adj_rec.include_on_returns_flag)
1746: THEN
1747: NULL;
1748: END IF;
1749:
1746: THEN
1747: NULL;
1748: END IF;
1749:
1750: IF NOT OE_GLOBALS.Equal(p_x_line_Adj_rec.INVOICED_AMOUNT, p_old_Line_Adj_rec.INVOICED_AMOUNT)
1751: THEN
1752: NULL;
1753: END IF;
1754:
1752: NULL;
1753: END IF;
1754:
1755: IF l_debug_level > 0 THEN
1756: oe_debug_pub.add( 'RECURSION_MODE'||OE_GLOBALS.G_RECURSION_MODE||' PRICING:'||OE_GLOBALS.G_PRICING_RECURSION , 1 ) ;
1757: oe_debug_pub.add( 'HEADER_ID'||P_X_LINE_ADJ_REC.HEADER_ID , 1 ) ;
1758: oe_debug_pub.add( 'LINE_ID'||P_X_LINE_ADJ_REC.LINE_ID , 1 ) ;
1759: END IF;
1760: if (l_price_flag) then
1767: END IF;
1768: end if;
1769:
1770: -- bug 2378843: don't log request when g_pricing_recursion is set
1771: IF l_price_flag and OE_Globals.G_RECURSION_MODE <> 'Y' AND
1772: OE_GLOBALS.G_PRICING_RECURSION <> 'Y' AND
1773: p_x_line_adj_rec.list_line_type_code NOT IN ('TAX','COST')
1774: Then
1775:
1768: end if;
1769:
1770: -- bug 2378843: don't log request when g_pricing_recursion is set
1771: IF l_price_flag and OE_Globals.G_RECURSION_MODE <> 'Y' AND
1772: OE_GLOBALS.G_PRICING_RECURSION <> 'Y' AND
1773: p_x_line_adj_rec.list_line_type_code NOT IN ('TAX','COST')
1774: Then
1775:
1776: IF (p_x_Line_adj_rec.line_id IS NOT NULL) THEN
1778: /* 1905650
1779: G_PRICE_ADJ request should be logged against LINE entity,
1780: not against LINE_ADJ entity
1781: */
1782: If OE_GLOBALS.G_UI_FLAG and nvl(p_x_Line_adj_rec.automatic_flag,'Y') = 'N' Then
1783: --we need to log different delayed request for manual adjustments.
1784: IF l_debug_level > 0 THEN
1785: oe_debug_pub.add( ' UI FLAG IS TRUE , LOGGING UI DELAYED REQUEST FOR ADJ' ) ;
1786: END IF;
1784: IF l_debug_level > 0 THEN
1785: oe_debug_pub.add( ' UI FLAG IS TRUE , LOGGING UI DELAYED REQUEST FOR ADJ' ) ;
1786: END IF;
1787: oe_delayed_requests_pvt.log_request(
1788: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1789: p_entity_id => p_x_Line_adj_rec.Line_id,
1790: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
1791: p_requesting_entity_id => p_x_Line_adj_rec.Line_id,
1792: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
1786: END IF;
1787: oe_delayed_requests_pvt.log_request(
1788: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1789: p_entity_id => p_x_Line_adj_rec.Line_id,
1790: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
1791: p_requesting_entity_id => p_x_Line_adj_rec.Line_id,
1792: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
1793: p_param1 => 'UI',
1794: x_return_status => l_return_status);
1788: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1789: p_entity_id => p_x_Line_adj_rec.Line_id,
1790: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
1791: p_requesting_entity_id => p_x_Line_adj_rec.Line_id,
1792: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
1793: p_param1 => 'UI',
1794: x_return_status => l_return_status);
1795: Else
1796: oe_delayed_requests_pvt.log_request(
1793: p_param1 => 'UI',
1794: x_return_status => l_return_status);
1795: Else
1796: oe_delayed_requests_pvt.log_request(
1797: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1798: p_entity_id => p_x_Line_adj_rec.Line_id,
1799: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
1800: p_requesting_entity_id => p_x_Line_adj_rec.Line_id,
1801: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
1795: Else
1796: oe_delayed_requests_pvt.log_request(
1797: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1798: p_entity_id => p_x_Line_adj_rec.Line_id,
1799: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
1800: p_requesting_entity_id => p_x_Line_adj_rec.Line_id,
1801: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
1802: x_return_status => l_return_status);
1803: End If;
1797: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1798: p_entity_id => p_x_Line_adj_rec.Line_id,
1799: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
1800: p_requesting_entity_id => p_x_Line_adj_rec.Line_id,
1801: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
1802: x_return_status => l_return_status);
1803: End If;
1804: -- sol_ord_er #16014165
1805: oe_delayed_requests_pvt.log_request(
1802: x_return_status => l_return_status);
1803: End If;
1804: -- sol_ord_er #16014165
1805: oe_delayed_requests_pvt.log_request(
1806: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1807: p_entity_id => p_x_Line_adj_rec.line_id,
1808: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
1809: p_requesting_entity_id => p_x_Line_adj_rec.line_id,
1810: p_request_type => OE_GLOBALS.G_SERVICE_FIRST_PERIOD_BILL,
1804: -- sol_ord_er #16014165
1805: oe_delayed_requests_pvt.log_request(
1806: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1807: p_entity_id => p_x_Line_adj_rec.line_id,
1808: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
1809: p_requesting_entity_id => p_x_Line_adj_rec.line_id,
1810: p_request_type => OE_GLOBALS.G_SERVICE_FIRST_PERIOD_BILL,
1811: p_request_unique_key1 => 'LINE',
1812: p_param1 => p_x_Line_adj_rec.line_id,
1806: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1807: p_entity_id => p_x_Line_adj_rec.line_id,
1808: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
1809: p_requesting_entity_id => p_x_Line_adj_rec.line_id,
1810: p_request_type => OE_GLOBALS.G_SERVICE_FIRST_PERIOD_BILL,
1811: p_request_unique_key1 => 'LINE',
1812: p_param1 => p_x_Line_adj_rec.line_id,
1813: x_return_status => l_return_status);
1814: -- sol_ord_er #16014165 end
1813: x_return_status => l_return_status);
1814: -- sol_ord_er #16014165 end
1815: ELSE
1816: oe_delayed_requests_pvt.log_request(
1817: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1818: p_entity_id => p_x_Line_adj_rec.header_id,
1819: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
1820: p_requesting_entity_id => p_x_Line_adj_rec.header_id,
1821: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
1815: ELSE
1816: oe_delayed_requests_pvt.log_request(
1817: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1818: p_entity_id => p_x_Line_adj_rec.header_id,
1819: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
1820: p_requesting_entity_id => p_x_Line_adj_rec.header_id,
1821: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
1822: x_return_status => l_return_status);
1823: -- sol_ord_er #16014165
1817: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1818: p_entity_id => p_x_Line_adj_rec.header_id,
1819: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
1820: p_requesting_entity_id => p_x_Line_adj_rec.header_id,
1821: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
1822: x_return_status => l_return_status);
1823: -- sol_ord_er #16014165
1824: oe_delayed_requests_pvt.log_request(
1825: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1821: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
1822: x_return_status => l_return_status);
1823: -- sol_ord_er #16014165
1824: oe_delayed_requests_pvt.log_request(
1825: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1826: p_entity_id => p_x_Line_adj_rec.Header_Id,
1827: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
1828: p_requesting_entity_id => p_x_Line_adj_rec.Header_Id,
1829: p_request_type => OE_GLOBALS.G_SERVICE_FIRST_PERIOD_BILL,
1823: -- sol_ord_er #16014165
1824: oe_delayed_requests_pvt.log_request(
1825: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1826: p_entity_id => p_x_Line_adj_rec.Header_Id,
1827: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
1828: p_requesting_entity_id => p_x_Line_adj_rec.Header_Id,
1829: p_request_type => OE_GLOBALS.G_SERVICE_FIRST_PERIOD_BILL,
1830: p_request_unique_key1 => 'ORDER',
1831: p_param1 => p_x_Line_adj_rec.Header_Id,
1825: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1826: p_entity_id => p_x_Line_adj_rec.Header_Id,
1827: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
1828: p_requesting_entity_id => p_x_Line_adj_rec.Header_Id,
1829: p_request_type => OE_GLOBALS.G_SERVICE_FIRST_PERIOD_BILL,
1830: p_request_unique_key1 => 'ORDER',
1831: p_param1 => p_x_Line_adj_rec.Header_Id,
1832: x_return_status => l_return_status);
1833: -- sol_ord_er #16014165 end
1851: END;
1852:
1853: IF l_commitment_id IS NOT NULL
1854: AND OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
1855: oe_globals.g_commitment_balance := ARP_BAL_UTIL.GET_COMMITMENT_BALANCE(
1856: l_commitment_id
1857: ,l_class
1858: ,l_so_source_code
1859: ,l_oe_installed_flag );
1858: ,l_so_source_code
1859: ,l_oe_installed_flag );
1860:
1861: OE_Delayed_Requests_Pvt.Log_Request(
1862: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1863: p_entity_id => p_x_line_adj_rec.line_id,
1864: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1865: p_requesting_entity_id => p_x_line_adj_rec.line_id,
1866: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,
1860:
1861: OE_Delayed_Requests_Pvt.Log_Request(
1862: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1863: p_entity_id => p_x_line_adj_rec.line_id,
1864: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1865: p_requesting_entity_id => p_x_line_adj_rec.line_id,
1866: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,
1867: x_return_status => l_return_status);
1868: END IF;
1862: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1863: p_entity_id => p_x_line_adj_rec.line_id,
1864: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1865: p_requesting_entity_id => p_x_line_adj_rec.line_id,
1866: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,
1867: x_return_status => l_return_status);
1868: END IF;
1869: END IF;
1870:
1957: END;
1958: IF l_line_category_code <> 'RETURN' THEN
1959: oe_debug_pub.ADD('OEXULADB: Logging delayed request for Verify Payment');
1960: OE_delayed_requests_Pvt.log_request
1961: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1962: p_entity_id => p_x_line_adj_rec.header_id,
1963: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1964: p_requesting_entity_id => p_x_line_adj_rec.line_id,
1965: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
1959: oe_debug_pub.ADD('OEXULADB: Logging delayed request for Verify Payment');
1960: OE_delayed_requests_Pvt.log_request
1961: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1962: p_entity_id => p_x_line_adj_rec.header_id,
1963: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1964: p_requesting_entity_id => p_x_line_adj_rec.line_id,
1965: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
1966: x_return_status => l_return_status);
1967: END IF;
1961: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1962: p_entity_id => p_x_line_adj_rec.header_id,
1963: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1964: p_requesting_entity_id => p_x_line_adj_rec.line_id,
1965: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
1966: x_return_status => l_return_status);
1967: END IF;
1968: --CC Reversal ER#16014135 Start
1969: ELSIF OE_VERIFY_PAYMENT_PUB.Get_CC_Rev_Reauth_Code( p_x_line_adj_rec.header_id) IS NOT NULL THEN
1981: END IF;
1982: oe_verify_payment_pub.G_credit_check_flag := 'N' ;
1983:
1984: OE_delayed_requests_Pvt.log_request
1985: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1986: p_entity_id => p_x_line_adj_rec.header_id,
1987: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1988: p_requesting_entity_id => p_x_line_adj_rec.line_id,
1989: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
1983:
1984: OE_delayed_requests_Pvt.log_request
1985: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1986: p_entity_id => p_x_line_adj_rec.header_id,
1987: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1988: p_requesting_entity_id => p_x_line_adj_rec.line_id,
1989: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
1990: x_return_status => l_return_status);
1991: END IF;
1985: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1986: p_entity_id => p_x_line_adj_rec.header_id,
1987: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1988: p_requesting_entity_id => p_x_line_adj_rec.line_id,
1989: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
1990: x_return_status => l_return_status);
1991: END IF;
1992: --CC Reversal ER#16014135 End
1993: END IF;
2014: oe_debug_pub.ADD('OEXULADB: Logging delayed request for Verify Payment CC Reversal',5);
2015: END IF;
2016: oe_verify_payment_pub.G_credit_check_flag := 'N' ;
2017: OE_delayed_requests_Pvt.log_request
2018: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2019: p_entity_id => p_x_line_adj_rec.header_id,
2020: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2021: p_requesting_entity_id => p_x_line_adj_rec.line_id,
2022: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
2016: oe_verify_payment_pub.G_credit_check_flag := 'N' ;
2017: OE_delayed_requests_Pvt.log_request
2018: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2019: p_entity_id => p_x_line_adj_rec.header_id,
2020: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2021: p_requesting_entity_id => p_x_line_adj_rec.line_id,
2022: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
2023: x_return_status => l_return_status);
2024: END IF;
2018: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2019: p_entity_id => p_x_line_adj_rec.header_id,
2020: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2021: p_requesting_entity_id => p_x_line_adj_rec.line_id,
2022: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
2023: x_return_status => l_return_status);
2024: END IF;
2025: --CC Reversal ER#16014135 End
2026: END IF;
3485: IF l_debug_level > 0 THEN
3486: oe_debug_pub.add( 'JFC: IN DELETE ROW , PRICE_ADJUSTMENT_ID'||L_ADJ.PRICE_ADJUSTMENT_ID , 1 ) ;
3487: END IF;
3488: /* Set the operation on the record so that globals are updated as well */
3489: l_new_line_adj_rec.operation := OE_GLOBALS.G_OPR_DELETE;
3490: l_new_line_adj_rec.price_adjustment_id := l_adj.price_adjustment_id;
3491: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
3492: p_line_adj_rec =>l_new_line_adj_rec,
3493: p_line_adj_id => l_adj.price_adjustment_id,
3513: END IF; /*code_release_level*/
3514: -- end notification framework
3515:
3516: OE_Delayed_Requests_Pvt.Delete_Reqs_for_deleted_entity(
3517: p_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
3518: p_entity_id => l_adj.price_adjustment_id,
3519: x_return_status => l_return_status
3520: );
3521: OE_Line_Price_Aattr_Util.delete_row(
3541: IF l_debug_level > 0 THEN
3542: oe_debug_pub.add( 'JFC: IN DELETE ROW , LINE_ID IS G_MISS_NUM , PRICE_ADJUSTMENT_ID'||P_PRICE_ADJUSTMENT_ID , 1 ) ;
3543: END IF;
3544: /* Set the operation on the record so that globals are updated as well */
3545: l_new_line_adj_rec.operation := OE_GLOBALS.G_OPR_DELETE;
3546: l_new_line_adj_rec.price_adjustment_id := p_price_adjustment_id;
3547: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
3548: p_line_adj_rec =>l_new_line_adj_rec,
3549: p_line_adj_id => p_price_adjustment_id,
3568: END IF; /*code_release_level*/
3569: -- end notification framework
3570:
3571: OE_Delayed_Requests_Pvt.Delete_Reqs_for_deleted_entity
3572: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
3573: p_entity_id => p_price_adjustment_id,
3574: x_return_status => l_return_status
3575: );
3576:
4423: IF l_debug_level > 0 THEN
4424: oe_debug_pub.add( 'COMPARE ' , 1 ) ;
4425: END IF;
4426:
4427: IF OE_GLOBALS.Equal(p_x_line_adj_rec.lock_control,
4428: l_lock_control)
4429: THEN
4430:
4431: -- Row has not changed. Set out parameter.
4658: p_delete_flag)
4659: THEN
4660:
4661: /*
4662: oe_delayed_requests_pvt.log_request(p_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
4663: p_entity_id => p_adj_rec.line_id,
4664: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
4665: p_requesting_entity_id => p_adj_rec.price_adjustment_id,
4666: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
4660:
4661: /*
4662: oe_delayed_requests_pvt.log_request(p_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
4663: p_entity_id => p_adj_rec.line_id,
4664: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
4665: p_requesting_entity_id => p_adj_rec.price_adjustment_id,
4666: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
4667: x_return_status => x_return_status);
4668: */
4662: oe_delayed_requests_pvt.log_request(p_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
4663: p_entity_id => p_adj_rec.line_id,
4664: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
4665: p_requesting_entity_id => p_adj_rec.price_adjustment_id,
4666: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
4667: x_return_status => x_return_status);
4668: */
4669: null;
4670:
4684: BEGIN
4685:
4686: IF (p_Line_Adj_rec.discount_id IS NULL OR
4687: p_Line_Adj_rec.discount_id <> FND_API.G_MISS_NUM) AND
4688: NOT OE_GLOBALS.Equal(p_Line_Adj_rec.discount_id,
4689: p_old_Line_Adj_rec.discount_id)
4690: THEN
4691: l_Line_Adj_val_rec.discount := OE_Id_To_Value.Discount
4692: ( p_discount_id => p_Line_Adj_rec.discount_id
4886:
4887: i:= L_Line_Adj_Att_Tbl.First;
4888: While i is not null loop
4889:
4890: L_Line_Adj_Att_Tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
4891: L_Line_Adj_Att_Tbl(i).price_adjustment_id := fnd_api.g_miss_num;
4892: L_Line_Adj_Att_Tbl(i).adj_index := p_adj_index;
4893: L_Line_Adj_Att_Tbl(i).price_adj_attrib_id := fnd_api.g_miss_num;
4894:
4921: If px_line_adj_rec.operand = 0 or px_line_adj_rec.operand is null Then
4922: IF l_debug_level > 0 THEN
4923: oe_debug_pub.add( ' NOTHING TO PRORATE , OPERAND IS 0' ) ;
4924: END IF;
4925: x_copy_from_line_adj_rec.operation := OE_GLOBALS.G_OPR_NONE;
4926: Return;
4927: End If;
4928:
4929: IF (px_line_adj_rec.list_line_type_code='DIS') THEN
4947: oe_debug_pub.add( 'OPERAND'||PX_LINE_ADJ_REC.OPERAND ||'<>'||L_ORDERED_QUANTITY||'*'||PX_LINE_ADJ_REC.ADJUSTED_AMOUNT ) ;
4948: END IF;
4949:
4950: x_copy_from_line_adj_rec := px_line_adj_rec;
4951: x_copy_from_line_adj_rec.operation := oe_globals.g_opr_update;
4952: x_copy_from_line_adj_rec.operand := l_ordered_quantity
4953: * x_copy_from_line_adj_rec.adjusted_amount * l_sign;
4954:
4955:
4964: oe_debug_pub.add( ' PRORATED ADJUSTED_AMOUNT:'||X_COPY_FROM_LINE_ADJ_REC.ADJUSTED_AMOUNT ) ;
4965: END IF;
4966:
4967: ELSE
4968: x_copy_from_line_adj_rec.operation := OE_GLOBALS.G_OPR_NONE;
4969: END IF;
4970:
4971: -- Then correct the copy_to line adj record
4972: SELECT ordered_quantity
5061: -- Manish Changes
5062: if p_line_id is not null then
5063:
5064: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' and
5065: p_operation <> OE_GLOBALS.G_OPR_DELETE THEN
5066: --RT{
5067: --we need to retrieve the latest adjustments if it is a retrobilled line
5068: --call retrobill api to get the retrobill line id, if none l_line_id will
5069: --set to the same value as p_line_id
5099:
5100: else
5101: -- l_Line_Adj_Tbl := OE_Line_Adj_Util.Query_Rows(p_header_Id => p_header_id);
5102: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' and
5103: p_operation <> OE_GLOBALS.G_OPR_DELETE THEN
5104: --RT{
5105: Oe_Retrobill_Pvt.Get_Last_Retro_HdrID(p_header_id=>p_header_id,
5106: x_header_id=>l_header_id);
5107: if nvl(p_header_id,-1) <> nvl(l_header_id,-1) then
5129: i:= l_Line_Adj_Tbl.First;
5130: While i is not Null Loop
5131:
5132:
5133: If p_operation = OE_GLOBALS.G_OPR_DELETE then
5134:
5135: l_Line_Adj_Tbl(i).operation := p_operation;
5136: px_line_adj_tbl(px_line_adj_tbl.count+1) := L_Line_Adj_Tbl(i);
5137:
5217: p_to_line_id,
5218: l_copy_from_line_adj_rec);
5219:
5220: IF l_copy_from_line_adj_rec.operation
5221: = OE_GLOBALS.G_OPR_UPDATE THEN
5222: IF l_debug_level > 0 THEN
5223: oe_debug_pub.add( ' UPDATING OPERAND FOR LINE ID:'||L_COPY_FROM_LINE_ADJ_REC.LINE_ID ) ;
5224: END IF;
5225: px_line_adj_tbl(px_line_adj_tbl.count+1)
5379: px_line_adj_assoc_tbl => px_line_adj_assoc_tbl,
5380: p_pbh_tbl => l_pbh_tbl);
5381: End If;
5382:
5383: IF (p_operation = OE_GLOBALS.G_OPR_CREATE) and l_Line_Adj_Tbl.count > 0 THEN
5384: I:=px_line_adj_tbl.first;
5385: while I is not null loop
5386: IF (px_line_adj_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE) THEN
5387: px_line_adj_tbl(i).price_adjustment_id:=fnd_api.g_miss_num;
5382:
5383: IF (p_operation = OE_GLOBALS.G_OPR_CREATE) and l_Line_Adj_Tbl.count > 0 THEN
5384: I:=px_line_adj_tbl.first;
5385: while I is not null loop
5386: IF (px_line_adj_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE) THEN
5387: px_line_adj_tbl(i).price_adjustment_id:=fnd_api.g_miss_num;
5388: --RT{
5389: oe_debug_pub.add('operand:'||px_line_adj_tbl(i).operand);
5390: oe_debug_pub.add('operand per pqty:'||px_line_adj_tbl(i).operand_per_pqty);
5434: )
5435: is
5436: l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;
5437: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
5438: l_control_rec Oe_Globals.Control_rec_type;
5439: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5440: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5441: -- l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5442: l_header_rec OE_Order_PUB.Header_Rec_Type;
5471: END IF;
5472: -- Set the existing rows to delete
5473: Append_Adjustment_Lines(
5474: p_line_id => p_to_line_id
5475: ,p_operation => OE_GLOBALS.G_OPR_DELETE
5476: ,p_line_category_code => p_line_category_code
5477: ,px_Line_Adj_Att_Tbl => l_Line_Adj_Att_Tbl
5478: ,px_Line_Adj_Tbl => l_Line_Adj_tbl
5479: ,px_line_adj_assoc_tbl => l_line_adj_assoc_tbl);
5482: ,p_line_id => p_from_line_id
5483: ,p_to_line_id => p_to_line_id
5484: ,p_to_Header_id => p_to_Header_id
5485: ,p_line_category_code => p_line_category_code
5486: ,p_operation => OE_GLOBALS.G_OPR_CREATE
5487: ,p_split_by => p_split_by
5488: ,px_Line_Adj_Att_Tbl => l_Line_Adj_Att_Tbl
5489: ,px_Line_Adj_Tbl => l_Line_Adj_tbl
5490: ,px_line_adj_assoc_tbl => l_line_adj_assoc_tbl
5512: p_Header_id => p_from_Header_id
5513: ,p_to_line_id => p_to_line_id
5514: ,p_to_Header_id => p_to_Header_id
5515: ,p_line_category_code => p_line_category_code
5516: ,p_operation => OE_GLOBALS.G_OPR_CREATE
5517: ,px_Line_Adj_Att_Tbl => l_Line_Adj_Att_Tbl
5518: ,px_Line_Adj_Tbl => l_Line_Adj_tbl
5519: ,px_line_adj_assoc_tbl => l_line_adj_assoc_tbl
5520: --RT{
5528: p_Header_id => p_from_Header_id
5529: ,p_to_line_id => p_to_line_id
5530: ,p_to_Header_id => p_to_Header_id
5531: ,p_line_category_code => p_line_category_code
5532: ,p_operation => OE_GLOBALS.G_OPR_CREATE
5533: ,px_Line_Adj_Att_Tbl => l_Line_Adj_Att_Tbl
5534: ,px_Line_Adj_Tbl => l_Line_Adj_tbl
5535: ,px_line_adj_assoc_tbl => l_line_adj_assoc_tbl
5536: );
5562: IF l_debug_level > 0 THEN
5563: oe_debug_pub.add( 'BEFORE OE_ORDER_PVT.PROCESS_ORDER'||L_LINE_ADJ_TBL.COUNT , 1 ) ;
5564: END IF ;
5565:
5566: OE_Globals.G_PRICING_RECURSION := 'Y';
5567:
5568: OE_Order_PVT.Process_order
5569: ( p_api_version_number => 1.0
5570: , x_return_status => x_return_status
5597: , p_x_Lot_Serial_tbl => l_x_Lot_Serial_Tbl
5598: , p_x_action_request_tbl => l_x_Action_Request_tbl
5599: );
5600:
5601: OE_Globals.G_PRICING_RECURSION := 'N';
5602:
5603:
5604: End If;
5605:
5642: BEGIN
5643:
5644: --11.5.10 Versioning/Audit Trail updates
5645: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
5646: OE_GLOBALS.G_ROLL_VERSION <> 'N' AND
5647: NOT OE_GLOBALS.G_HEADER_CREATED THEN
5648: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
5649: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
5650: IF p_x_line_adj_rec.change_reason_code <> FND_API.G_MISS_CHAR THEN
5643:
5644: --11.5.10 Versioning/Audit Trail updates
5645: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
5646: OE_GLOBALS.G_ROLL_VERSION <> 'N' AND
5647: NOT OE_GLOBALS.G_HEADER_CREATED THEN
5648: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
5649: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
5650: IF p_x_line_adj_rec.change_reason_code <> FND_API.G_MISS_CHAR THEN
5651: Null; -- for bug 13343285
5644: --11.5.10 Versioning/Audit Trail updates
5645: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
5646: OE_GLOBALS.G_ROLL_VERSION <> 'N' AND
5647: NOT OE_GLOBALS.G_HEADER_CREATED THEN
5648: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
5649: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
5650: IF p_x_line_adj_rec.change_reason_code <> FND_API.G_MISS_CHAR THEN
5651: Null; -- for bug 13343285
5652: /* OE_GLOBALS.G_REASON_TYPE := 'CHANGE_CODE';
5645: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
5646: OE_GLOBALS.G_ROLL_VERSION <> 'N' AND
5647: NOT OE_GLOBALS.G_HEADER_CREATED THEN
5648: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
5649: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
5650: IF p_x_line_adj_rec.change_reason_code <> FND_API.G_MISS_CHAR THEN
5651: Null; -- for bug 13343285
5652: /* OE_GLOBALS.G_REASON_TYPE := 'CHANGE_CODE';
5653: OE_GLOBALS.G_REASON_CODE := p_x_line_adj_rec.change_reason_code;
5648: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
5649: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
5650: IF p_x_line_adj_rec.change_reason_code <> FND_API.G_MISS_CHAR THEN
5651: Null; -- for bug 13343285
5652: /* OE_GLOBALS.G_REASON_TYPE := 'CHANGE_CODE';
5653: OE_GLOBALS.G_REASON_CODE := p_x_line_adj_rec.change_reason_code;
5654: OE_GLOBALS.G_REASON_COMMENTS := p_x_line_adj_rec.change_reason_text;
5655: OE_GLOBALS.G_CAPTURED_REASON := 'Y';*/
5656: ELSE
5649: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
5650: IF p_x_line_adj_rec.change_reason_code <> FND_API.G_MISS_CHAR THEN
5651: Null; -- for bug 13343285
5652: /* OE_GLOBALS.G_REASON_TYPE := 'CHANGE_CODE';
5653: OE_GLOBALS.G_REASON_CODE := p_x_line_adj_rec.change_reason_code;
5654: OE_GLOBALS.G_REASON_COMMENTS := p_x_line_adj_rec.change_reason_text;
5655: OE_GLOBALS.G_CAPTURED_REASON := 'Y';*/
5656: ELSE
5657: if l_debug_level > 0 then
5650: IF p_x_line_adj_rec.change_reason_code <> FND_API.G_MISS_CHAR THEN
5651: Null; -- for bug 13343285
5652: /* OE_GLOBALS.G_REASON_TYPE := 'CHANGE_CODE';
5653: OE_GLOBALS.G_REASON_CODE := p_x_line_adj_rec.change_reason_code;
5654: OE_GLOBALS.G_REASON_COMMENTS := p_x_line_adj_rec.change_reason_text;
5655: OE_GLOBALS.G_CAPTURED_REASON := 'Y';*/
5656: ELSE
5657: if l_debug_level > 0 then
5658: OE_DEBUG_PUB.add('Reason code for versioning is missing or invalid', 1);
5651: Null; -- for bug 13343285
5652: /* OE_GLOBALS.G_REASON_TYPE := 'CHANGE_CODE';
5653: OE_GLOBALS.G_REASON_CODE := p_x_line_adj_rec.change_reason_code;
5654: OE_GLOBALS.G_REASON_COMMENTS := p_x_line_adj_rec.change_reason_text;
5655: OE_GLOBALS.G_CAPTURED_REASON := 'Y';*/
5656: ELSE
5657: if l_debug_level > 0 then
5658: OE_DEBUG_PUB.add('Reason code for versioning is missing or invalid', 1);
5659: end if;
5657: if l_debug_level > 0 then
5658: OE_DEBUG_PUB.add('Reason code for versioning is missing or invalid', 1);
5659: end if;
5660: --bug 3775971
5661: if OE_GLOBALS.G_UI_FLAG AND
5662: (OE_GLOBALS.G_PRICING_RECURSION = 'Y' OR
5663: OE_GLOBALS.G_RECURSION_MODE = 'Y') then
5664: raise FND_API.G_EXC_ERROR;
5665: end if;
5658: OE_DEBUG_PUB.add('Reason code for versioning is missing or invalid', 1);
5659: end if;
5660: --bug 3775971
5661: if OE_GLOBALS.G_UI_FLAG AND
5662: (OE_GLOBALS.G_PRICING_RECURSION = 'Y' OR
5663: OE_GLOBALS.G_RECURSION_MODE = 'Y') then
5664: raise FND_API.G_EXC_ERROR;
5665: end if;
5666: END IF;
5659: end if;
5660: --bug 3775971
5661: if OE_GLOBALS.G_UI_FLAG AND
5662: (OE_GLOBALS.G_PRICING_RECURSION = 'Y' OR
5663: OE_GLOBALS.G_RECURSION_MODE = 'Y') then
5664: raise FND_API.G_EXC_ERROR;
5665: end if;
5666: END IF;
5667: END IF;
5667: END IF;
5668:
5669: --log delayed request
5670: oe_debug_pub.add('log versioning request',1);
5671: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5672: p_entity_id => p_x_line_adj_rec.header_id,
5673: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
5674: p_requesting_entity_id => p_x_line_adj_rec.price_adjustment_id,
5675: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
5669: --log delayed request
5670: oe_debug_pub.add('log versioning request',1);
5671: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5672: p_entity_id => p_x_line_adj_rec.header_id,
5673: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
5674: p_requesting_entity_id => p_x_line_adj_rec.price_adjustment_id,
5675: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
5676: x_return_status => l_return_status);
5677: END IF;
5671: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5672: p_entity_id => p_x_line_adj_rec.header_id,
5673: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
5674: p_requesting_entity_id => p_x_line_adj_rec.price_adjustment_id,
5675: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
5676: x_return_status => l_return_status);
5677: END IF;
5678:
5679: if (p_x_line_adj_rec.operation = OE_GLOBALS.G_OPR_UPDATE) then
5675: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
5676: x_return_status => l_return_status);
5677: END IF;
5678:
5679: if (p_x_line_adj_rec.operation = OE_GLOBALS.G_OPR_UPDATE) then
5680:
5681: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' OR
5682: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN
5683:
5677: END IF;
5678:
5679: if (p_x_line_adj_rec.operation = OE_GLOBALS.G_OPR_UPDATE) then
5680:
5681: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' OR
5682: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN
5683:
5684: IF l_debug_level > 0 THEN
5685: oe_debug_pub.add( 'CALL TO RECORD LINE PRICE ADJ HISTORY' , 5 ) ;
5678:
5679: if (p_x_line_adj_rec.operation = OE_GLOBALS.G_OPR_UPDATE) then
5680:
5681: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' OR
5682: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN
5683:
5684: IF l_debug_level > 0 THEN
5685: oe_debug_pub.add( 'CALL TO RECORD LINE PRICE ADJ HISTORY' , 5 ) ;
5686: END IF;
5684: IF l_debug_level > 0 THEN
5685: oe_debug_pub.add( 'CALL TO RECORD LINE PRICE ADJ HISTORY' , 5 ) ;
5686: END IF;
5687: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
5688: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
5689: p_entity_id => p_x_line_adj_rec.price_adjustment_id,
5690: p_hist_type_code => 'UPDATE');
5691: --log delayed request
5692: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5688: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
5689: p_entity_id => p_x_line_adj_rec.price_adjustment_id,
5690: p_hist_type_code => 'UPDATE');
5691: --log delayed request
5692: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5693: p_entity_id => p_x_line_adj_rec.header_id,
5694: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
5695: p_requesting_entity_id => p_x_line_adj_rec.price_adjustment_id,
5696: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
5690: p_hist_type_code => 'UPDATE');
5691: --log delayed request
5692: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5693: p_entity_id => p_x_line_adj_rec.header_id,
5694: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
5695: p_requesting_entity_id => p_x_line_adj_rec.price_adjustment_id,
5696: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
5697: x_return_status => l_return_status);
5698: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
5692: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5693: p_entity_id => p_x_line_adj_rec.header_id,
5694: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
5695: p_requesting_entity_id => p_x_line_adj_rec.price_adjustment_id,
5696: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
5697: x_return_status => l_return_status);
5698: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
5699: ELSE
5700: OE_CHG_ORDER_PVT.RecordLPAdjHist
5694: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ,
5695: p_requesting_entity_id => p_x_line_adj_rec.price_adjustment_id,
5696: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
5697: x_return_status => l_return_status);
5698: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
5699: ELSE
5700: OE_CHG_ORDER_PVT.RecordLPAdjHist
5701: ( p_line_adj_id => p_x_line_adj_rec.price_adjustment_id,
5702: p_line_adj_rec => null,
5782: END IF;
5783:
5784: IF l_current_event >= l_tax_calculation_event_code THEN
5785:
5786: IF (OE_GLOBALS.G_UI_FLAG)
5787: AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N'
5788: THEN
5789: OE_delayed_requests_Pvt.log_request(
5790: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5786: IF (OE_GLOBALS.G_UI_FLAG)
5787: AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N'
5788: THEN
5789: OE_delayed_requests_Pvt.log_request(
5790: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5791: p_entity_id => p_x_line_adj_rec.line_id,
5792: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5793: p_requesting_entity_id => p_x_line_adj_rec.line_id,
5794: p_request_type => OE_GLOBALS.g_tax_line,
5788: THEN
5789: OE_delayed_requests_Pvt.log_request(
5790: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5791: p_entity_id => p_x_line_adj_rec.line_id,
5792: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5793: p_requesting_entity_id => p_x_line_adj_rec.line_id,
5794: p_request_type => OE_GLOBALS.g_tax_line,
5795: x_return_status => l_return_status);
5796: ELSE
5790: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5791: p_entity_id => p_x_line_adj_rec.line_id,
5792: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5793: p_requesting_entity_id => p_x_line_adj_rec.line_id,
5794: p_request_type => OE_GLOBALS.g_tax_line,
5795: x_return_status => l_return_status);
5796: ELSE
5797: OE_delayed_requests_Pvt.log_request(
5798: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5794: p_request_type => OE_GLOBALS.g_tax_line,
5795: x_return_status => l_return_status);
5796: ELSE
5797: OE_delayed_requests_Pvt.log_request(
5798: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5799: p_entity_id => p_x_line_adj_rec.line_id,
5800: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5801: p_requesting_entity_id => p_x_line_adj_rec.line_id,
5802: p_request_type => OE_GLOBALS.g_tax_line,
5796: ELSE
5797: OE_delayed_requests_Pvt.log_request(
5798: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5799: p_entity_id => p_x_line_adj_rec.line_id,
5800: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5801: p_requesting_entity_id => p_x_line_adj_rec.line_id,
5802: p_request_type => OE_GLOBALS.g_tax_line,
5803: p_param1 => NULL,
5804: x_return_status => l_return_status);
5798: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
5799: p_entity_id => p_x_line_adj_rec.line_id,
5800: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
5801: p_requesting_entity_id => p_x_line_adj_rec.line_id,
5802: p_request_type => OE_GLOBALS.g_tax_line,
5803: p_param1 => NULL,
5804: x_return_status => l_return_status);
5805: END IF;
5806: END IF;
5831: IF l_debug_level > 0 THEN
5832: oe_debug_pub.add( ' Check if any pricing related changes has occured' ) ;
5833: END IF;
5834:
5835: IF NOT OE_GLOBALS.Equal(p_new_line_rec.agreement_id,p_old_line_rec.agreement_id)
5836: OR NOT OE_GLOBALS.Equal(p_new_line_rec.cust_po_number,p_old_line_rec.cust_po_number)
5837: OR NOT OE_GLOBALS.Equal(p_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
5838: OR NOT OE_GLOBALS.Equal(p_new_line_rec.invoice_to_org_id,p_old_line_rec.invoice_to_org_id)
5839: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item_id,p_old_line_rec.ordered_item_id)
5832: oe_debug_pub.add( ' Check if any pricing related changes has occured' ) ;
5833: END IF;
5834:
5835: IF NOT OE_GLOBALS.Equal(p_new_line_rec.agreement_id,p_old_line_rec.agreement_id)
5836: OR NOT OE_GLOBALS.Equal(p_new_line_rec.cust_po_number,p_old_line_rec.cust_po_number)
5837: OR NOT OE_GLOBALS.Equal(p_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
5838: OR NOT OE_GLOBALS.Equal(p_new_line_rec.invoice_to_org_id,p_old_line_rec.invoice_to_org_id)
5839: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item_id,p_old_line_rec.ordered_item_id)
5840: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item,p_old_line_rec.ordered_item)
5833: END IF;
5834:
5835: IF NOT OE_GLOBALS.Equal(p_new_line_rec.agreement_id,p_old_line_rec.agreement_id)
5836: OR NOT OE_GLOBALS.Equal(p_new_line_rec.cust_po_number,p_old_line_rec.cust_po_number)
5837: OR NOT OE_GLOBALS.Equal(p_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
5838: OR NOT OE_GLOBALS.Equal(p_new_line_rec.invoice_to_org_id,p_old_line_rec.invoice_to_org_id)
5839: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item_id,p_old_line_rec.ordered_item_id)
5840: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item,p_old_line_rec.ordered_item)
5841: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_category_code,p_old_line_rec.line_category_code)
5834:
5835: IF NOT OE_GLOBALS.Equal(p_new_line_rec.agreement_id,p_old_line_rec.agreement_id)
5836: OR NOT OE_GLOBALS.Equal(p_new_line_rec.cust_po_number,p_old_line_rec.cust_po_number)
5837: OR NOT OE_GLOBALS.Equal(p_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
5838: OR NOT OE_GLOBALS.Equal(p_new_line_rec.invoice_to_org_id,p_old_line_rec.invoice_to_org_id)
5839: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item_id,p_old_line_rec.ordered_item_id)
5840: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item,p_old_line_rec.ordered_item)
5841: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_category_code,p_old_line_rec.line_category_code)
5842: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_type_id,p_old_line_rec.line_type_id)
5835: IF NOT OE_GLOBALS.Equal(p_new_line_rec.agreement_id,p_old_line_rec.agreement_id)
5836: OR NOT OE_GLOBALS.Equal(p_new_line_rec.cust_po_number,p_old_line_rec.cust_po_number)
5837: OR NOT OE_GLOBALS.Equal(p_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
5838: OR NOT OE_GLOBALS.Equal(p_new_line_rec.invoice_to_org_id,p_old_line_rec.invoice_to_org_id)
5839: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item_id,p_old_line_rec.ordered_item_id)
5840: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item,p_old_line_rec.ordered_item)
5841: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_category_code,p_old_line_rec.line_category_code)
5842: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_type_id,p_old_line_rec.line_type_id)
5843: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity)
5836: OR NOT OE_GLOBALS.Equal(p_new_line_rec.cust_po_number,p_old_line_rec.cust_po_number)
5837: OR NOT OE_GLOBALS.Equal(p_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
5838: OR NOT OE_GLOBALS.Equal(p_new_line_rec.invoice_to_org_id,p_old_line_rec.invoice_to_org_id)
5839: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item_id,p_old_line_rec.ordered_item_id)
5840: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item,p_old_line_rec.ordered_item)
5841: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_category_code,p_old_line_rec.line_category_code)
5842: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_type_id,p_old_line_rec.line_type_id)
5843: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity)
5844: OR NOT OE_GLOBALS.Equal(p_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom)
5837: OR NOT OE_GLOBALS.Equal(p_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
5838: OR NOT OE_GLOBALS.Equal(p_new_line_rec.invoice_to_org_id,p_old_line_rec.invoice_to_org_id)
5839: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item_id,p_old_line_rec.ordered_item_id)
5840: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item,p_old_line_rec.ordered_item)
5841: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_category_code,p_old_line_rec.line_category_code)
5842: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_type_id,p_old_line_rec.line_type_id)
5843: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity)
5844: OR NOT OE_GLOBALS.Equal(p_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom)
5845: OR NOT OE_GLOBALS.Equal(p_new_line_rec.payment_term_id,p_old_line_rec.payment_term_id)
5838: OR NOT OE_GLOBALS.Equal(p_new_line_rec.invoice_to_org_id,p_old_line_rec.invoice_to_org_id)
5839: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item_id,p_old_line_rec.ordered_item_id)
5840: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item,p_old_line_rec.ordered_item)
5841: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_category_code,p_old_line_rec.line_category_code)
5842: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_type_id,p_old_line_rec.line_type_id)
5843: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity)
5844: OR NOT OE_GLOBALS.Equal(p_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom)
5845: OR NOT OE_GLOBALS.Equal(p_new_line_rec.payment_term_id,p_old_line_rec.payment_term_id)
5846: OR NOT OE_GLOBALS.Equal(p_new_line_rec.price_list_id,p_old_line_rec.price_list_id)
5839: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item_id,p_old_line_rec.ordered_item_id)
5840: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item,p_old_line_rec.ordered_item)
5841: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_category_code,p_old_line_rec.line_category_code)
5842: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_type_id,p_old_line_rec.line_type_id)
5843: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity)
5844: OR NOT OE_GLOBALS.Equal(p_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom)
5845: OR NOT OE_GLOBALS.Equal(p_new_line_rec.payment_term_id,p_old_line_rec.payment_term_id)
5846: OR NOT OE_GLOBALS.Equal(p_new_line_rec.price_list_id,p_old_line_rec.price_list_id)
5847: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
5840: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_item,p_old_line_rec.ordered_item)
5841: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_category_code,p_old_line_rec.line_category_code)
5842: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_type_id,p_old_line_rec.line_type_id)
5843: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity)
5844: OR NOT OE_GLOBALS.Equal(p_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom)
5845: OR NOT OE_GLOBALS.Equal(p_new_line_rec.payment_term_id,p_old_line_rec.payment_term_id)
5846: OR NOT OE_GLOBALS.Equal(p_new_line_rec.price_list_id,p_old_line_rec.price_list_id)
5847: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
5848: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity,p_old_line_rec.pricing_quantity)
5841: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_category_code,p_old_line_rec.line_category_code)
5842: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_type_id,p_old_line_rec.line_type_id)
5843: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity)
5844: OR NOT OE_GLOBALS.Equal(p_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom)
5845: OR NOT OE_GLOBALS.Equal(p_new_line_rec.payment_term_id,p_old_line_rec.payment_term_id)
5846: OR NOT OE_GLOBALS.Equal(p_new_line_rec.price_list_id,p_old_line_rec.price_list_id)
5847: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
5848: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity,p_old_line_rec.pricing_quantity)
5849: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity_uom,p_old_line_rec.pricing_quantity_uom)
5842: OR NOT OE_GLOBALS.Equal(p_new_line_rec.line_type_id,p_old_line_rec.line_type_id)
5843: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity)
5844: OR NOT OE_GLOBALS.Equal(p_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom)
5845: OR NOT OE_GLOBALS.Equal(p_new_line_rec.payment_term_id,p_old_line_rec.payment_term_id)
5846: OR NOT OE_GLOBALS.Equal(p_new_line_rec.price_list_id,p_old_line_rec.price_list_id)
5847: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
5848: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity,p_old_line_rec.pricing_quantity)
5849: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity_uom,p_old_line_rec.pricing_quantity_uom)
5850: OR NOT OE_GLOBALS.Equal(p_new_line_rec.request_date,p_old_line_rec.request_date)
5843: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity)
5844: OR NOT OE_GLOBALS.Equal(p_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom)
5845: OR NOT OE_GLOBALS.Equal(p_new_line_rec.payment_term_id,p_old_line_rec.payment_term_id)
5846: OR NOT OE_GLOBALS.Equal(p_new_line_rec.price_list_id,p_old_line_rec.price_list_id)
5847: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
5848: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity,p_old_line_rec.pricing_quantity)
5849: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity_uom,p_old_line_rec.pricing_quantity_uom)
5850: OR NOT OE_GLOBALS.Equal(p_new_line_rec.request_date,p_old_line_rec.request_date)
5851: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id)
5844: OR NOT OE_GLOBALS.Equal(p_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom)
5845: OR NOT OE_GLOBALS.Equal(p_new_line_rec.payment_term_id,p_old_line_rec.payment_term_id)
5846: OR NOT OE_GLOBALS.Equal(p_new_line_rec.price_list_id,p_old_line_rec.price_list_id)
5847: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
5848: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity,p_old_line_rec.pricing_quantity)
5849: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity_uom,p_old_line_rec.pricing_quantity_uom)
5850: OR NOT OE_GLOBALS.Equal(p_new_line_rec.request_date,p_old_line_rec.request_date)
5851: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id)
5852: OR NOT OE_GLOBALS.Equal(p_new_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id)
5845: OR NOT OE_GLOBALS.Equal(p_new_line_rec.payment_term_id,p_old_line_rec.payment_term_id)
5846: OR NOT OE_GLOBALS.Equal(p_new_line_rec.price_list_id,p_old_line_rec.price_list_id)
5847: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
5848: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity,p_old_line_rec.pricing_quantity)
5849: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity_uom,p_old_line_rec.pricing_quantity_uom)
5850: OR NOT OE_GLOBALS.Equal(p_new_line_rec.request_date,p_old_line_rec.request_date)
5851: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id)
5852: OR NOT OE_GLOBALS.Equal(p_new_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id)
5853: OR NOT OE_GLOBALS.Equal(p_new_line_rec.unit_selling_price,p_old_line_rec.unit_selling_price)
5846: OR NOT OE_GLOBALS.Equal(p_new_line_rec.price_list_id,p_old_line_rec.price_list_id)
5847: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
5848: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity,p_old_line_rec.pricing_quantity)
5849: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity_uom,p_old_line_rec.pricing_quantity_uom)
5850: OR NOT OE_GLOBALS.Equal(p_new_line_rec.request_date,p_old_line_rec.request_date)
5851: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id)
5852: OR NOT OE_GLOBALS.Equal(p_new_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id)
5853: OR NOT OE_GLOBALS.Equal(p_new_line_rec.unit_selling_price,p_old_line_rec.unit_selling_price)
5854: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_start_date,p_old_line_rec.service_start_date)
5847: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
5848: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity,p_old_line_rec.pricing_quantity)
5849: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity_uom,p_old_line_rec.pricing_quantity_uom)
5850: OR NOT OE_GLOBALS.Equal(p_new_line_rec.request_date,p_old_line_rec.request_date)
5851: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id)
5852: OR NOT OE_GLOBALS.Equal(p_new_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id)
5853: OR NOT OE_GLOBALS.Equal(p_new_line_rec.unit_selling_price,p_old_line_rec.unit_selling_price)
5854: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_start_date,p_old_line_rec.service_start_date)
5855: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_end_date,p_old_line_rec.service_end_date)
5848: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity,p_old_line_rec.pricing_quantity)
5849: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity_uom,p_old_line_rec.pricing_quantity_uom)
5850: OR NOT OE_GLOBALS.Equal(p_new_line_rec.request_date,p_old_line_rec.request_date)
5851: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id)
5852: OR NOT OE_GLOBALS.Equal(p_new_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id)
5853: OR NOT OE_GLOBALS.Equal(p_new_line_rec.unit_selling_price,p_old_line_rec.unit_selling_price)
5854: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_start_date,p_old_line_rec.service_start_date)
5855: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_end_date,p_old_line_rec.service_end_date)
5856: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_duration,p_old_line_rec.service_duration)
5849: OR NOT OE_GLOBALS.Equal(p_new_line_rec.pricing_quantity_uom,p_old_line_rec.pricing_quantity_uom)
5850: OR NOT OE_GLOBALS.Equal(p_new_line_rec.request_date,p_old_line_rec.request_date)
5851: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id)
5852: OR NOT OE_GLOBALS.Equal(p_new_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id)
5853: OR NOT OE_GLOBALS.Equal(p_new_line_rec.unit_selling_price,p_old_line_rec.unit_selling_price)
5854: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_start_date,p_old_line_rec.service_start_date)
5855: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_end_date,p_old_line_rec.service_end_date)
5856: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_duration,p_old_line_rec.service_duration)
5857: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_period,p_old_line_rec.service_period)
5850: OR NOT OE_GLOBALS.Equal(p_new_line_rec.request_date,p_old_line_rec.request_date)
5851: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id)
5852: OR NOT OE_GLOBALS.Equal(p_new_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id)
5853: OR NOT OE_GLOBALS.Equal(p_new_line_rec.unit_selling_price,p_old_line_rec.unit_selling_price)
5854: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_start_date,p_old_line_rec.service_start_date)
5855: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_end_date,p_old_line_rec.service_end_date)
5856: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_duration,p_old_line_rec.service_duration)
5857: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_period,p_old_line_rec.service_period)
5858: --Bug 4332307
5851: OR NOT OE_GLOBALS.Equal(p_new_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id)
5852: OR NOT OE_GLOBALS.Equal(p_new_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id)
5853: OR NOT OE_GLOBALS.Equal(p_new_line_rec.unit_selling_price,p_old_line_rec.unit_selling_price)
5854: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_start_date,p_old_line_rec.service_start_date)
5855: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_end_date,p_old_line_rec.service_end_date)
5856: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_duration,p_old_line_rec.service_duration)
5857: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_period,p_old_line_rec.service_period)
5858: --Bug 4332307
5859: OR (
5852: OR NOT OE_GLOBALS.Equal(p_new_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id)
5853: OR NOT OE_GLOBALS.Equal(p_new_line_rec.unit_selling_price,p_old_line_rec.unit_selling_price)
5854: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_start_date,p_old_line_rec.service_start_date)
5855: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_end_date,p_old_line_rec.service_end_date)
5856: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_duration,p_old_line_rec.service_duration)
5857: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_period,p_old_line_rec.service_period)
5858: --Bug 4332307
5859: OR (
5860: ((p_new_line_rec.unit_list_price IS NOT NULL AND
5853: OR NOT OE_GLOBALS.Equal(p_new_line_rec.unit_selling_price,p_old_line_rec.unit_selling_price)
5854: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_start_date,p_old_line_rec.service_start_date)
5855: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_end_date,p_old_line_rec.service_end_date)
5856: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_duration,p_old_line_rec.service_duration)
5857: OR NOT OE_GLOBALS.Equal(p_new_line_rec.service_period,p_old_line_rec.service_period)
5858: --Bug 4332307
5859: OR (
5860: ((p_new_line_rec.unit_list_price IS NOT NULL AND
5861: p_new_line_rec.unit_list_price <> FND_API.G_MISS_NUM AND
5871: p_new_line_rec.order_quantity_uom is not null and
5872: p_new_line_rec.order_quantity_uom <> fnd_api.g_miss_char
5873: AND oe_code_control.code_release_level >= '110510'
5874: AND nvl(fnd_profile.value('ONT_LIST_PRICE_OVERRIDE_PRIV'), 'NONE') = 'UNLIMITED'
5875: AND OE_GLOBALS.G_UI_FLAG
5876: AND OE_Globals.G_PRICING_RECURSION = 'N'
5877: )
5878: --Bug 4332307
5879:
5872: p_new_line_rec.order_quantity_uom <> fnd_api.g_miss_char
5873: AND oe_code_control.code_release_level >= '110510'
5874: AND nvl(fnd_profile.value('ONT_LIST_PRICE_OVERRIDE_PRIV'), 'NONE') = 'UNLIMITED'
5875: AND OE_GLOBALS.G_UI_FLAG
5876: AND OE_Globals.G_PRICING_RECURSION = 'N'
5877: )
5878: --Bug 4332307
5879:
5880: Then
5918:
5919: /* Variables to call process order */
5920: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5921: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5922: l_control_rec OE_GLOBALS.Control_Rec_Type;
5923: l_line_rec OE_Order_PUB.Line_Rec_Type;
5924: x_return_status Varchar2(1);
5925: l_prg_line_id NUMBER;
5926: l_price_adj_id NUMBER;
5938: IF l_debug_level > 0 THEN
5939: oe_debug_pub.add( 'ENTERING OEXULADB.DELETE_PRG_LINES WITH LINE_ID = ' || P_LINE_ID ) ;
5940: END IF;
5941: if l_debug_level > 0 then
5942: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);
5943: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
5944: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5945: end if;
5946: l_reason_code := OE_GLOBALS.G_REASON_CODE;
5939: oe_debug_pub.add( 'ENTERING OEXULADB.DELETE_PRG_LINES WITH LINE_ID = ' || P_LINE_ID ) ;
5940: END IF;
5941: if l_debug_level > 0 then
5942: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);
5943: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
5944: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5945: end if;
5946: l_reason_code := OE_GLOBALS.G_REASON_CODE;
5947: l_reason_comments := OE_GLOBALS.G_REASON_COMMENTS;
5940: END IF;
5941: if l_debug_level > 0 then
5942: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);
5943: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
5944: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5945: end if;
5946: l_reason_code := OE_GLOBALS.G_REASON_CODE;
5947: l_reason_comments := OE_GLOBALS.G_REASON_COMMENTS;
5948: l_captured_reason := OE_GLOBALS.G_CAPTURED_REASON;
5942: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);
5943: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
5944: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5945: end if;
5946: l_reason_code := OE_GLOBALS.G_REASON_CODE;
5947: l_reason_comments := OE_GLOBALS.G_REASON_COMMENTS;
5948: l_captured_reason := OE_GLOBALS.G_CAPTURED_REASON;
5949: OPEN prg_lines;
5950: FETCH prg_lines into l_prg_line_id, l_rltd_price_adj_id;
5943: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
5944: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5945: end if;
5946: l_reason_code := OE_GLOBALS.G_REASON_CODE;
5947: l_reason_comments := OE_GLOBALS.G_REASON_COMMENTS;
5948: l_captured_reason := OE_GLOBALS.G_CAPTURED_REASON;
5949: OPEN prg_lines;
5950: FETCH prg_lines into l_prg_line_id, l_rltd_price_adj_id;
5951: WHILE prg_lines%FOUND Loop
5944: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
5945: end if;
5946: l_reason_code := OE_GLOBALS.G_REASON_CODE;
5947: l_reason_comments := OE_GLOBALS.G_REASON_COMMENTS;
5948: l_captured_reason := OE_GLOBALS.G_CAPTURED_REASON;
5949: OPEN prg_lines;
5950: FETCH prg_lines into l_prg_line_id, l_rltd_price_adj_id;
5951: WHILE prg_lines%FOUND Loop
5952: IF l_debug_level > 0 THEN
5961:
5962: IF l_debug_level > 0 THEN
5963: oe_debug_pub.add( 'ORDER NOT BOOKED' ) ;
5964: END IF;
5965: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
5966:
5967: else
5968: if (l_line_rec.shipped_quantity is NULL) Then
5969: IF l_debug_level > 0 THEN
5968: if (l_line_rec.shipped_quantity is NULL) Then
5969: IF l_debug_level > 0 THEN
5970: oe_debug_pub.add( 'BOOKED ORDER , LINE NOT SHIPPED' ) ;
5971: END IF;
5972: if (p_operation = OE_GLOBALS.G_OPR_DELETE) Then
5973: -- bug 2756288, if buy line can be deleted, so can get line
5974: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
5975: else
5976: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
5970: oe_debug_pub.add( 'BOOKED ORDER , LINE NOT SHIPPED' ) ;
5971: END IF;
5972: if (p_operation = OE_GLOBALS.G_OPR_DELETE) Then
5973: -- bug 2756288, if buy line can be deleted, so can get line
5974: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
5975: else
5976: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
5977: l_line_rec.ordered_quantity := 0;
5978: l_line_rec.pricing_quantity := 0;
5972: if (p_operation = OE_GLOBALS.G_OPR_DELETE) Then
5973: -- bug 2756288, if buy line can be deleted, so can get line
5974: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
5975: else
5976: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
5977: l_line_rec.ordered_quantity := 0;
5978: l_line_rec.pricing_quantity := 0;
5979: end if;
5980: else
5980: else
5981: IF l_debug_level > 0 THEN
5982: oe_debug_pub.add( 'BOOKED ORDER , SHIPPED LINE' ) ;
5983: END IF;
5984: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
5985: l_line_rec.calculate_price_flag := 'Y';
5986: end if;
5987: end if;
5988: l_line_rec.change_reason := 'SYSTEM';
6030: , p_x_old_line_tbl => l_old_line_tbl
6031: , x_return_status => x_return_status
6032: );
6033:
6034: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
6035: END IF;
6036: FETCH prg_lines into l_prg_line_id, l_rltd_price_adj_id;
6037: End Loop;
6038: CLOSE prg_lines;
6036: FETCH prg_lines into l_prg_line_id, l_rltd_price_adj_id;
6037: End Loop;
6038: CLOSE prg_lines;
6039: if l_debug_level > 0 then
6040: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);
6041: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
6042: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
6043: end if;
6044: OE_GLOBALS.G_REASON_CODE := l_reason_code;
6037: End Loop;
6038: CLOSE prg_lines;
6039: if l_debug_level > 0 then
6040: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);
6041: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
6042: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
6043: end if;
6044: OE_GLOBALS.G_REASON_CODE := l_reason_code;
6045: OE_GLOBALS.G_REASON_COMMENTS := l_reason_comments;
6038: CLOSE prg_lines;
6039: if l_debug_level > 0 then
6040: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);
6041: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
6042: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
6043: end if;
6044: OE_GLOBALS.G_REASON_CODE := l_reason_code;
6045: OE_GLOBALS.G_REASON_COMMENTS := l_reason_comments;
6046: OE_GLOBALS.G_CAPTURED_REASON := l_captured_reason;
6040: oe_debug_pub.add('reason:'||OE_GLOBALS.G_REASON_CODE,3);
6041: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
6042: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
6043: end if;
6044: OE_GLOBALS.G_REASON_CODE := l_reason_code;
6045: OE_GLOBALS.G_REASON_COMMENTS := l_reason_comments;
6046: OE_GLOBALS.G_CAPTURED_REASON := l_captured_reason;
6047:
6048: IF l_debug_level > 0 THEN
6041: oe_debug_pub.add('captured:'||OE_GLOBALS.G_captured_reason,3);
6042: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
6043: end if;
6044: OE_GLOBALS.G_REASON_CODE := l_reason_code;
6045: OE_GLOBALS.G_REASON_COMMENTS := l_reason_comments;
6046: OE_GLOBALS.G_CAPTURED_REASON := l_captured_reason;
6047:
6048: IF l_debug_level > 0 THEN
6049: oe_debug_pub.add( 'EXITING OEXULADB.DELETE_PRG_LINES' ) ;
6042: oe_debug_pub.add('audit:'||OE_GLOBALS.G_version_audit,3);
6043: end if;
6044: OE_GLOBALS.G_REASON_CODE := l_reason_code;
6045: OE_GLOBALS.G_REASON_COMMENTS := l_reason_comments;
6046: OE_GLOBALS.G_CAPTURED_REASON := l_captured_reason;
6047:
6048: IF l_debug_level > 0 THEN
6049: oe_debug_pub.add( 'EXITING OEXULADB.DELETE_PRG_LINES' ) ;
6050: END IF;
6062: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6063: --
6064: Begin
6065:
6066: 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
6067: IF (nvl(p_new_line_rec.booked_flag, 'X') <> 'Y') Then
6068: IF (p_new_line_rec.operation = OE_GLOBALS.G_OPR_DELETE OR p_new_line_rec.ordered_quantity = 0) Then
6069: IF l_debug_level > 0 THEN
6070: oe_debug_pub.add( 'OPEN ORDER , ORDERED QTY CHANGED TO ZERO , DELETE ALL PRG LINES' ) ;
6064: Begin
6065:
6066: 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
6067: IF (nvl(p_new_line_rec.booked_flag, 'X') <> 'Y') Then
6068: IF (p_new_line_rec.operation = OE_GLOBALS.G_OPR_DELETE OR p_new_line_rec.ordered_quantity = 0) Then
6069: IF l_debug_level > 0 THEN
6070: oe_debug_pub.add( 'OPEN ORDER , ORDERED QTY CHANGED TO ZERO , DELETE ALL PRG LINES' ) ;
6071: END IF;
6072: Delete_PRG_Lines(p_new_line_rec.line_id, p_new_line_rec.operation);
6074: ELSE
6075: IF (p_new_line_rec.ordered_quantity = 0 AND
6076: (p_new_line_rec.change_reason is NOT NULL OR
6077: p_new_line_rec.change_reason <> FND_API.G_MISS_CHAR))
6078: OR p_new_line_rec.operation = OE_GLOBALS.G_OPR_DELETE Then
6079: IF l_debug_level > 0 THEN
6080: oe_debug_pub.add( 'BOOKED ORDER , ORDERED QTY CHANGED TO ZERO , DELETE ALL PRG LINES' ) ;
6081: END IF;
6082: Delete_PRG_Lines(p_new_line_rec.line_id, p_new_line_rec.operation);
6112: IF l_debug_level > 0 THEN
6113: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.PROCESS_PRICING CALLED FROM ULINB' ) ;
6114: END IF;
6115:
6116: IF NOT OE_GLOBALS.Equal(p_x_new_line_rec.cancelled_quantity,p_old_line_rec.cancelled_quantity)
6117: and p_x_new_line_rec.cancelled_quantity > 0
6118: Then
6119: IF l_debug_level > 0 THEN
6120: oe_debug_pub.add( ' USER CANCELS LINE , CANCELLED QUANTITY:'||P_X_NEW_LINE_REC.CANCELLED_QUANTITY ) ;
6131: l_pricing_related_changes := True;
6132: End If;
6133:
6134:
6135: IF NOT OE_GLOBALS.Equal(p_x_new_line_rec.unit_cost,p_old_line_rec.unit_cost)
6136: Then
6137: IF l_debug_level > 0 THEN
6138: oe_debug_pub.add( ' BOOKED FLAG OR UNIT COST CHANGES' ) ;
6139: END IF;
6185: IF l_debug_level > 0 THEN
6186: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR MARGIN HOLD FOR BOOKED LINE_ID:'||P_X_NEW_LINE_REC.LINE_ID ) ;
6187: END IF;
6188: oe_delayed_requests_pvt.log_request(
6189: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6190: p_entity_id => p_x_new_line_rec.header_id,
6191:
6192: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6193: p_requesting_entity_id => p_x_new_line_rec.header_id,
6188: oe_delayed_requests_pvt.log_request(
6189: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6190: p_entity_id => p_x_new_line_rec.header_id,
6191:
6192: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6193: p_requesting_entity_id => p_x_new_line_rec.header_id,
6194:
6195: p_request_type => 'MARGIN_HOLD',
6196: x_return_status => l_return_status);
6217: oe_debug_pub.add( 'NEW PRICING_DATE = '||P_X_NEW_LINE_REC.PRICING_DATE , 1 ) ;
6218: oe_debug_pub.add( 'OLD PRICING_DATE = '||P_OLD_LINE_REC.PRICING_DATE , 1 ) ;
6219: END IF;
6220:
6221: IF NOT OE_GLOBALS.Equal(p_x_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
6222: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.ship_from_org_id,p_old_line_rec.ship_from_org_id)
6223: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.project_id,p_old_line_rec.project_id)
6224: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.actual_shipment_date,p_old_line_rec.actual_shipment_date)
6225: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.fulfillment_date,p_old_line_rec.fulfillment_date)
6218: oe_debug_pub.add( 'OLD PRICING_DATE = '||P_OLD_LINE_REC.PRICING_DATE , 1 ) ;
6219: END IF;
6220:
6221: IF NOT OE_GLOBALS.Equal(p_x_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
6222: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.ship_from_org_id,p_old_line_rec.ship_from_org_id)
6223: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.project_id,p_old_line_rec.project_id)
6224: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.actual_shipment_date,p_old_line_rec.actual_shipment_date)
6225: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.fulfillment_date,p_old_line_rec.fulfillment_date)
6226: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
6219: END IF;
6220:
6221: IF NOT OE_GLOBALS.Equal(p_x_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
6222: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.ship_from_org_id,p_old_line_rec.ship_from_org_id)
6223: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.project_id,p_old_line_rec.project_id)
6224: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.actual_shipment_date,p_old_line_rec.actual_shipment_date)
6225: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.fulfillment_date,p_old_line_rec.fulfillment_date)
6226: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
6227: THEN
6220:
6221: IF NOT OE_GLOBALS.Equal(p_x_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
6222: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.ship_from_org_id,p_old_line_rec.ship_from_org_id)
6223: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.project_id,p_old_line_rec.project_id)
6224: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.actual_shipment_date,p_old_line_rec.actual_shipment_date)
6225: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.fulfillment_date,p_old_line_rec.fulfillment_date)
6226: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
6227: THEN
6228: IF Oe_Sys_Parameters.Value('COMPUTE_MARGIN') <> 'N' Then
6221: IF NOT OE_GLOBALS.Equal(p_x_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id)
6222: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.ship_from_org_id,p_old_line_rec.ship_from_org_id)
6223: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.project_id,p_old_line_rec.project_id)
6224: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.actual_shipment_date,p_old_line_rec.actual_shipment_date)
6225: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.fulfillment_date,p_old_line_rec.fulfillment_date)
6226: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
6227: THEN
6228: IF Oe_Sys_Parameters.Value('COMPUTE_MARGIN') <> 'N' Then
6229: IF l_debug_level > 0 THEN
6222: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.ship_from_org_id,p_old_line_rec.ship_from_org_id)
6223: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.project_id,p_old_line_rec.project_id)
6224: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.actual_shipment_date,p_old_line_rec.actual_shipment_date)
6225: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.fulfillment_date,p_old_line_rec.fulfillment_date)
6226: OR NOT OE_GLOBALS.Equal(p_x_new_line_rec.pricing_date,p_old_line_rec.pricing_date)
6227: THEN
6228: IF Oe_Sys_Parameters.Value('COMPUTE_MARGIN') <> 'N' Then
6229: IF l_debug_level > 0 THEN
6230: oe_debug_pub.add( 'BEFORE OE_DELAYED_REQUESTS_PVT.LOG_REQUEST CALL' ) ;
6231: oe_debug_pub.add( 'IN PROCESS_PRICING OEXULADB.PLS' ) ;
6232: END IF;
6233:
6234: oe_delayed_requests_pvt.log_request(
6235: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6236: p_entity_id => p_x_new_line_rec.line_id,
6237: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6238:
6239: p_requesting_entity_id => p_x_new_line_rec.line_id,
6233:
6234: oe_delayed_requests_pvt.log_request(
6235: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6236: p_entity_id => p_x_new_line_rec.line_id,
6237: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6238:
6239: p_requesting_entity_id => p_x_new_line_rec.line_id,
6240: p_request_type => 'GET_COST',
6241: x_return_status => l_return_status);
6272: Begin
6273:
6274: IF p_price_flag = 'Y' and
6275: not p_no_price_flag and
6276: nvl(oe_globals.g_pricing_recursion,'N') <> 'Y' and
6277: p_x_new_line_rec.Ordered_Quantity <> fnd_api.g_miss_num and
6278: p_x_new_line_rec.order_quantity_uom is not null and
6279: p_x_new_line_rec.order_quantity_uom <> fnd_api.g_miss_char
6280: THEN
6287: END IF;
6288: If
6289: ( (p_x_new_line_rec.unit_list_price is null or
6290: p_x_new_line_rec.Unit_List_Price = fnd_api.g_miss_num or
6291: NOT OE_GLOBALS.Equal(p_x_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity) or
6292: NOT OE_GLOBALS.Equal(p_x_new_line_rec.cancelled_Quantity,p_old_line_rec.cancelled_Quantity) or
6293: NOT OE_GLOBALS.Equal(p_x_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom) or
6294: NOT OE_GLOBALS.Equal(p_x_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id) ) --fix bug 1388503 btea
6295: and p_x_new_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_SERVICE
6288: If
6289: ( (p_x_new_line_rec.unit_list_price is null or
6290: p_x_new_line_rec.Unit_List_Price = fnd_api.g_miss_num or
6291: NOT OE_GLOBALS.Equal(p_x_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity) or
6292: NOT OE_GLOBALS.Equal(p_x_new_line_rec.cancelled_Quantity,p_old_line_rec.cancelled_Quantity) or
6293: NOT OE_GLOBALS.Equal(p_x_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom) or
6294: NOT OE_GLOBALS.Equal(p_x_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id) ) --fix bug 1388503 btea
6295: and p_x_new_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_SERVICE
6296: )
6289: ( (p_x_new_line_rec.unit_list_price is null or
6290: p_x_new_line_rec.Unit_List_Price = fnd_api.g_miss_num or
6291: NOT OE_GLOBALS.Equal(p_x_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity) or
6292: NOT OE_GLOBALS.Equal(p_x_new_line_rec.cancelled_Quantity,p_old_line_rec.cancelled_Quantity) or
6293: NOT OE_GLOBALS.Equal(p_x_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom) or
6294: NOT OE_GLOBALS.Equal(p_x_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id) ) --fix bug 1388503 btea
6295: and p_x_new_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_SERVICE
6296: )
6297: then
6290: p_x_new_line_rec.Unit_List_Price = fnd_api.g_miss_num or
6291: NOT OE_GLOBALS.Equal(p_x_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity) or
6292: NOT OE_GLOBALS.Equal(p_x_new_line_rec.cancelled_Quantity,p_old_line_rec.cancelled_Quantity) or
6293: NOT OE_GLOBALS.Equal(p_x_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom) or
6294: NOT OE_GLOBALS.Equal(p_x_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id) ) --fix bug 1388503 btea
6295: and p_x_new_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_SERVICE
6296: )
6297: then
6298:
6291: NOT OE_GLOBALS.Equal(p_x_new_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity) or
6292: NOT OE_GLOBALS.Equal(p_x_new_line_rec.cancelled_Quantity,p_old_line_rec.cancelled_Quantity) or
6293: NOT OE_GLOBALS.Equal(p_x_new_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom) or
6294: NOT OE_GLOBALS.Equal(p_x_new_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id) ) --fix bug 1388503 btea
6295: and p_x_new_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_SERVICE
6296: )
6297: then
6298:
6299:
6296: )
6297: then
6298:
6299:
6300: IF ((OE_GLOBALS.G_UI_FLAG) and (nvl(Oe_Config_Pvt.oecfg_configuration_pricing,'N')='N'))
6301: THEN
6302:
6303: l_Price_Control_Rec.pricing_event := 'PRICE';
6304: l_Price_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
6329: IF l_debug_level > 0 THEN
6330: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR PRICING' ) ;
6331: END IF;
6332:
6333: IF ((OE_GLOBALS.G_UI_FLAG) and (nvl(Oe_Config_Pvt.oecfg_configuration_pricing,'N')='N')) OR
6334: p_x_new_line_rec.item_type_code = 'INCLUDED' THEN
6335: IF l_debug_level > 0 THEN
6336: oe_debug_pub.add( 'UI MODE OR CONFIG , INCLUDED ITEM'||P_X_NEW_LINE_REC.LINE_ID ) ;
6337: END IF;
6337: END IF;
6338: IF NOT l_zero_line_qty THEN
6339: --bsadri don't call this for a cancelled line
6340: OE_delayed_requests_Pvt.log_request(
6341: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6342: p_entity_id => p_x_new_line_rec.line_id,
6343: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6344: p_requesting_entity_id => p_x_new_line_rec.line_id,
6345: p_request_unique_key1 => 'LINE',
6339: --bsadri don't call this for a cancelled line
6340: OE_delayed_requests_Pvt.log_request(
6341: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6342: p_entity_id => p_x_new_line_rec.line_id,
6343: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6344: p_requesting_entity_id => p_x_new_line_rec.line_id,
6345: p_request_unique_key1 => 'LINE',
6346: p_param1 => p_x_new_line_rec.header_id,
6347: p_param2 => 'LINE',
6344: p_requesting_entity_id => p_x_new_line_rec.line_id,
6345: p_request_unique_key1 => 'LINE',
6346: p_param1 => p_x_new_line_rec.header_id,
6347: p_param2 => 'LINE',
6348: p_request_type => OE_GLOBALS.G_PRICE_LINE,
6349: x_return_status => l_return_status);
6350: l_cnt_lin_log := 1; -- sol_ord_er #16014165
6351:
6352: END IF;
6351:
6352: END IF;
6353: IF p_x_new_line_rec.item_type_code <> 'INCLUDED' THEN
6354: OE_delayed_requests_Pvt.log_request(
6355: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6356: p_entity_id => p_x_new_line_rec.Header_Id,
6357: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6358: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6359: p_request_unique_key1 => 'ORDER',
6353: IF p_x_new_line_rec.item_type_code <> 'INCLUDED' THEN
6354: OE_delayed_requests_Pvt.log_request(
6355: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6356: p_entity_id => p_x_new_line_rec.Header_Id,
6357: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6358: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6359: p_request_unique_key1 => 'ORDER',
6360: p_param1 => p_x_new_line_rec.header_id,
6361: p_param2 => 'ORDER',
6358: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6359: p_request_unique_key1 => 'ORDER',
6360: p_param1 => p_x_new_line_rec.header_id,
6361: p_param2 => 'ORDER',
6362: p_request_type => OE_GLOBALS.G_PRICE_ORDER,
6363: x_return_status => l_return_status);
6364: l_cnt_hdr_log := 1; -- sol_ord_er #16014165
6365: END IF;
6366: ELSE
6368: oe_debug_pub.add( 'BATCH MODE' ) ;
6369: END IF;
6370:
6371: OE_delayed_requests_Pvt.log_request(
6372: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6373: p_entity_id => p_x_new_line_rec.Header_Id,
6374: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6375: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6376: p_request_unique_key1 => 'BATCH',
6370:
6371: OE_delayed_requests_Pvt.log_request(
6372: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6373: p_entity_id => p_x_new_line_rec.Header_Id,
6374: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6375: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6376: p_request_unique_key1 => 'BATCH',
6377: p_param1 => p_x_new_line_rec.header_id,
6378: p_param2 => 'BATCH',
6375: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6376: p_request_unique_key1 => 'BATCH',
6377: p_param1 => p_x_new_line_rec.header_id,
6378: p_param2 => 'BATCH',
6379: p_request_type => OE_GLOBALS.G_PRICE_ORDER,
6380: x_return_status => l_return_status);
6381: l_cnt_hdr_log := 2; -- sol_ord_er #16014165
6382: END IF;
6383:
6382: END IF;
6383:
6384: If p_x_new_line_rec.booked_flag='Y' and p_x_new_line_rec.item_type_code <> 'INCLUDED' Then
6385: OE_delayed_requests_Pvt.log_request(
6386: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6387: p_entity_id => p_x_new_line_rec.Header_Id,
6388: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6389: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6390: p_request_unique_key1 => 'BOOK',
6384: If p_x_new_line_rec.booked_flag='Y' and p_x_new_line_rec.item_type_code <> 'INCLUDED' Then
6385: OE_delayed_requests_Pvt.log_request(
6386: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6387: p_entity_id => p_x_new_line_rec.Header_Id,
6388: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6389: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6390: p_request_unique_key1 => 'BOOK',
6391: p_param1 => p_x_new_line_rec.header_id,
6392: p_param2 => 'BOOK',
6389: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6390: p_request_unique_key1 => 'BOOK',
6391: p_param1 => p_x_new_line_rec.header_id,
6392: p_param2 => 'BOOK',
6393: p_request_type => OE_GLOBALS.G_PRICE_ORDER,
6394: x_return_status => l_return_status);
6395: l_cnt_hdr_log := 3; -- sol_ord_er #16014165
6396: End If;
6397:
6406: */
6407:
6408: IF l_debug_level > 0 THEN
6409: oe_debug_pub.add( 'PRICE_FLAG = ' || P_PRICE_FLAG ) ;
6410: oe_debug_pub.add( 'G_PRICING_RECURSION = ' || OE_GLOBALS.G_PRICING_RECURSION ) ;
6411: oe_debug_pub.add( 'ORDERED QUANTITY = '|| TO_CHAR ( P_X_NEW_LINE_REC.ORDERED_QUANTITY ) ) ;
6412: oe_debug_pub.add( 'ORDERED QTY UOM = ' || P_X_NEW_LINE_REC.ORDER_QUANTITY_UOM ) ;
6413: oe_debug_pub.add( 'CALCULATE_PRICE_FLAG = '|| P_X_NEW_LINE_REC.CALCULATE_PRICE_FLAG ) ;
6414: END IF;
6415:
6416:
6417: if (p_price_flag = 'Y' and
6418: not p_no_price_flag and
6419: oe_globals.g_pricing_recursion = 'Y' and
6420: nvl(p_x_new_line_rec.ordered_quantity,0) <> 0 and
6421: p_x_new_line_rec.Ordered_Quantity <> fnd_api.g_miss_num and
6422: p_x_new_line_rec.order_quantity_uom is not null and
6423: p_x_new_line_rec.order_quantity_uom <> fnd_api.g_miss_char and
6432: IF l_debug_level > 0 THEN
6433: oe_debug_pub.add( 'LOGGING A REQUEST TO PRICE_LINE IN BATCH MODE' ) ;
6434: END IF;
6435: OE_delayed_requests_Pvt.log_request(
6436: p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
6437: p_entity_id => p_x_new_line_rec.line_Id,
6438: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6439: p_requesting_entity_id => p_x_new_line_rec.line_Id,
6440: p_request_unique_key1 => 'BATCH',
6434: END IF;
6435: OE_delayed_requests_Pvt.log_request(
6436: p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
6437: p_entity_id => p_x_new_line_rec.line_Id,
6438: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6439: p_requesting_entity_id => p_x_new_line_rec.line_Id,
6440: p_request_unique_key1 => 'BATCH',
6441: p_param1 => p_x_new_line_rec.header_id,
6442: p_param2 => 'BATCH',
6439: p_requesting_entity_id => p_x_new_line_rec.line_Id,
6440: p_request_unique_key1 => 'BATCH',
6441: p_param1 => p_x_new_line_rec.header_id,
6442: p_param2 => 'BATCH',
6443: p_request_type => OE_GLOBALS.G_PRICE_LINE,
6444: x_return_status => l_return_status);
6445: l_cnt_lin_log := 2; -- sol_ord_er #16014165
6446:
6447: if (p_x_new_line_rec.booked_flag = 'Y')
6449: IF l_debug_level > 0 THEN
6450: oe_debug_pub.add( 'BOOKED ORDER -- LOG A REQUEST TO PRICE LINE' ) ;
6451: END IF;
6452: OE_delayed_requests_Pvt.log_request(
6453: p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
6454: p_entity_id => p_x_new_line_rec.line_Id,
6455: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6456: p_requesting_entity_id => p_x_new_line_rec.line_Id,
6457: p_request_unique_key1 => 'BOOK',
6451: END IF;
6452: OE_delayed_requests_Pvt.log_request(
6453: p_entity_code =>OE_GLOBALS.G_ENTITY_ALL,
6454: p_entity_id => p_x_new_line_rec.line_Id,
6455: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6456: p_requesting_entity_id => p_x_new_line_rec.line_Id,
6457: p_request_unique_key1 => 'BOOK',
6458: p_param1 => p_x_new_line_rec.header_id,
6459: p_param2 => 'BOOK',
6456: p_requesting_entity_id => p_x_new_line_rec.line_Id,
6457: p_request_unique_key1 => 'BOOK',
6458: p_param1 => p_x_new_line_rec.header_id,
6459: p_param2 => 'BOOK',
6460: p_request_type => OE_GLOBALS.G_PRICE_LINE,
6461: x_return_status => l_return_status);
6462: l_cnt_lin_log := 3; -- sol_ord_er #16014165
6463: end if; -- if order is BOOKED
6464:
6465: end if; -- if new line created by Promotional modifier needs to be re-priced.
6466:
6467: -- end of fix for bug 1729372
6468:
6469: If NOT OE_GLOBALS.Equal(p_x_new_line_rec.Shipped_Quantity,p_old_line_rec.Shipped_Quantity)
6470: Then
6471: --btea
6472: IF p_x_new_line_rec.line_category_code <> 'RETURN' Then
6473: OE_Shipping_Integration_PVT.Check_Shipment_Line(
6475: , p_shipped_quantity => p_x_new_line_rec.Shipped_Quantity
6476: , x_result_out => l_x_result_out
6477: );
6478:
6479: IF l_x_result_out = OE_GLOBALS.G_PARTIALLY_SHIPPED THEN
6480: -- This line will split, set the calculate_price_flag to 'P' if 'Y'
6481: IF (p_x_new_line_rec.calculate_price_flag = 'Y') THEN
6482: p_x_new_line_rec.calculate_price_flag := 'P';
6483: END IF;
6484:
6485:
6486: END IF;
6487:
6488: Elsif p_x_new_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
6489: and p_x_new_line_rec.split_by = 'SYSTEM'
6490: and p_x_new_line_rec.split_action_code = 'SPLIT'
6491: and p_x_new_line_rec.calculate_price_flag = 'Y' Then
6492: p_x_new_line_rec.calculate_price_flag :='P';
6492: p_x_new_line_rec.calculate_price_flag :='P';
6493: End If;
6494:
6495: OE_delayed_requests_Pvt.log_request(
6496: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6497: p_entity_id => p_x_new_line_rec.line_id,
6498: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6499: p_requesting_entity_id => p_x_new_line_rec.line_id,
6500: p_request_unique_key1 => 'SHIP',
6494:
6495: OE_delayed_requests_Pvt.log_request(
6496: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6497: p_entity_id => p_x_new_line_rec.line_id,
6498: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6499: p_requesting_entity_id => p_x_new_line_rec.line_id,
6500: p_request_unique_key1 => 'SHIP',
6501: p_param1 => p_x_new_line_rec.header_id,
6502: p_param2 => 'SHIP',
6499: p_requesting_entity_id => p_x_new_line_rec.line_id,
6500: p_request_unique_key1 => 'SHIP',
6501: p_param1 => p_x_new_line_rec.header_id,
6502: p_param2 => 'SHIP',
6503: p_request_type => OE_GLOBALS.G_PRICE_LINE,
6504: x_return_status => l_return_status);
6505: End If;
6506: -- sol_ord_er #16014165
6507: IF l_debug_level > 0 THEN
6514: oe_debug_pub.add('(1) Logging Line Level First Period Bill Amt Request, for line_id= '
6515: ||p_x_new_line_rec.line_id ) ;
6516: END IF;
6517: oe_delayed_requests_pvt.log_request(
6518: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6519: p_entity_id => p_x_new_line_rec.line_id,
6520: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6521: p_requesting_entity_id => p_x_new_line_rec.line_id,
6522: p_request_type => OE_GLOBALS.G_SERVICE_FIRST_PERIOD_BILL,
6516: END IF;
6517: oe_delayed_requests_pvt.log_request(
6518: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6519: p_entity_id => p_x_new_line_rec.line_id,
6520: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6521: p_requesting_entity_id => p_x_new_line_rec.line_id,
6522: p_request_type => OE_GLOBALS.G_SERVICE_FIRST_PERIOD_BILL,
6523: p_request_unique_key1 => 'LINE',
6524: p_param1 => p_x_new_line_rec.line_id,
6518: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6519: p_entity_id => p_x_new_line_rec.line_id,
6520: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6521: p_requesting_entity_id => p_x_new_line_rec.line_id,
6522: p_request_type => OE_GLOBALS.G_SERVICE_FIRST_PERIOD_BILL,
6523: p_request_unique_key1 => 'LINE',
6524: p_param1 => p_x_new_line_rec.line_id,
6525: x_return_status => l_return_status);
6526: End If;
6529: oe_debug_pub.add('(2) Logging Line Level First Period Bill Amt Request, for header_id= '
6530: ||p_x_new_line_rec.header_id ) ;
6531: END IF;
6532: oe_delayed_requests_pvt.log_request(
6533: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6534: p_entity_id => p_x_new_line_rec.header_id,
6535: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6536: p_requesting_entity_id => p_x_new_line_rec.header_id,
6537: p_request_type => OE_GLOBALS.G_SERVICE_FIRST_PERIOD_BILL,
6531: END IF;
6532: oe_delayed_requests_pvt.log_request(
6533: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6534: p_entity_id => p_x_new_line_rec.header_id,
6535: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6536: p_requesting_entity_id => p_x_new_line_rec.header_id,
6537: p_request_type => OE_GLOBALS.G_SERVICE_FIRST_PERIOD_BILL,
6538: p_request_unique_key1 => 'ORDER',
6539: p_param1 => p_x_new_line_rec.header_id,
6533: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6534: p_entity_id => p_x_new_line_rec.header_id,
6535: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6536: p_requesting_entity_id => p_x_new_line_rec.header_id,
6537: p_request_type => OE_GLOBALS.G_SERVICE_FIRST_PERIOD_BILL,
6538: p_request_unique_key1 => 'ORDER',
6539: p_param1 => p_x_new_line_rec.header_id,
6540: x_return_status => l_return_status);
6541: End If;
6581: ------------------------------------------------------
6582: --Special case, bypass regular pricing path
6583: --we log performant version of pricing delayed request
6584: ------------------------------------------------------
6585: OE_GLOBALS.G_PRICE_FLAG := 'N';
6586:
6587:
6588: -- bug 9728497 start
6589: -- modified below for p_x_new_line_rec.header_id and p_x_new_line_rec.line_id
6622: --FP bug 3335024 included summary line flag condition below
6623: If l_order_status_rec.ALL_LINES_FLAG = 'Y' or l_order_status_rec.summary_line_flag = 'Y' Then
6624: IF p_x_new_line_rec.item_type_code not in ('INCLUDED','CONFIG') THEN
6625: OE_delayed_requests_Pvt.log_request(
6626: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6627: p_entity_id => p_x_new_line_rec.Header_Id,
6628: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6629: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6630: p_request_unique_key1 => 'ORDER,BOOK',
6624: IF p_x_new_line_rec.item_type_code not in ('INCLUDED','CONFIG') THEN
6625: OE_delayed_requests_Pvt.log_request(
6626: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6627: p_entity_id => p_x_new_line_rec.Header_Id,
6628: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6629: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6630: p_request_unique_key1 => 'ORDER,BOOK',
6631: p_param1 => p_x_new_line_rec.header_id,
6632: p_param2 => l_event_str,
6629: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6630: p_request_unique_key1 => 'ORDER,BOOK',
6631: p_param1 => p_x_new_line_rec.header_id,
6632: p_param2 => l_event_str,
6633: p_request_type => OE_GLOBALS.G_PRICE_ORDER,
6634: x_return_status => l_return_status);
6635:
6636: End If;
6637: End If;
6639: IF l_debug_level > 0 THEN
6640: oe_debug_pub.add( 'LOG REVERSE_LIMITS DELAYED REQUEST FROM PROCESS_CANCELLED_LINES ' , 1 ) ;
6641: END IF;
6642: OE_delayed_requests_Pvt.log_request(
6643: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6644: p_entity_id => p_x_new_line_rec.line_id,
6645: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6646: p_requesting_entity_id => p_x_new_line_rec.line_id,
6647: p_request_unique_key1 => 'LINE',
6641: END IF;
6642: OE_delayed_requests_Pvt.log_request(
6643: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6644: p_entity_id => p_x_new_line_rec.line_id,
6645: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6646: p_requesting_entity_id => p_x_new_line_rec.line_id,
6647: p_request_unique_key1 => 'LINE',
6648: p_param1 => 'CANCEL',
6649: p_param2 => p_x_new_line_rec.price_request_code,
6650: p_param3 => NULL,
6651: p_param4 => NULL,
6652: p_param5 => NULL,
6653: p_param6 => NULL,
6654: p_request_type => OE_GLOBALS.G_REVERSE_LIMITS,
6655: x_return_status => l_return_status);
6656: IF l_debug_level > 0 THEN
6657: oe_debug_pub.add( 'REVERSE_LIMITS DELAYED REQUEST HAS BEEN LOGGED' , 1 ) ;
6658: END IF;
6678: --treat changed_lines as all_lines for now, will to
6679: --differential this 2 type in the future
6680: IF p_x_new_line_rec.item_type_code not in ('INCLUDED','CONFIG') THEN
6681: OE_delayed_requests_Pvt.log_request(
6682: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6683: p_entity_id => p_x_new_line_rec.Header_Id,
6684: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6685: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6686: p_request_unique_key1 => 'BATCH,BOOK',
6680: IF p_x_new_line_rec.item_type_code not in ('INCLUDED','CONFIG') THEN
6681: OE_delayed_requests_Pvt.log_request(
6682: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6683: p_entity_id => p_x_new_line_rec.Header_Id,
6684: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6685: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6686: p_request_unique_key1 => 'BATCH,BOOK',
6687: p_param1 => p_x_new_line_rec.header_id,
6688: p_param2 => l_event_str,
6685: p_requesting_entity_id => p_x_new_line_rec.Header_Id,
6686: p_request_unique_key1 => 'BATCH,BOOK',
6687: p_param1 => p_x_new_line_rec.header_id,
6688: p_param2 => l_event_str,
6689: p_request_type => OE_GLOBALS.G_PRICE_ORDER,
6690: x_return_status => l_return_status);
6691:
6692: End If; --not in ('INCLUDED','CONFIG')
6693: End If; --ALL_LINES or Change_lines flag
6699: PROCESS_CANCELLED_LINES FOR PARTIAL CANCEL CASE' , 1 ) ;
6700: END IF;
6701:
6702: OE_delayed_requests_Pvt.log_request(
6703: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6704: p_entity_id => p_x_new_line_rec.line_id,
6705: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6706: p_requesting_entity_id => p_x_new_line_rec.line_id,
6707: p_request_unique_key1 => 'LINE',
6701:
6702: OE_delayed_requests_Pvt.log_request(
6703: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6704: p_entity_id => p_x_new_line_rec.line_id,
6705: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6706: p_requesting_entity_id => p_x_new_line_rec.line_id,
6707: p_request_unique_key1 => 'LINE',
6708: p_param1 => 'AMEND',
6709: p_param2 => p_x_new_line_rec.price_request_code,
6710: p_param3 => p_ordered_quantity,
6711: p_param4 => p_x_new_line_rec.ordered_quantity,
6712: p_param5 => NULL,
6713: p_param6 => NULL,
6714: p_request_type =>OE_GLOBALS.G_REVERSE_LIMITS,
6715: x_return_status => l_return_status);
6716:
6717: IF l_debug_level > 0 THEN
6718: oe_debug_pub.add( 'REVERSE_LIMITS DELAYED REQUEST HAS BEEN LOGGED' , 1 ) ;
6753: IF l_debug_level > 0 THEN
6754: oe_debug_pub.add( ' LOGGING DELAYED REQUEST TO RESET G_CHANGED_LINE_TBL' ) ;
6755: END IF;
6756: oe_delayed_requests_pvt.log_request(
6757: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6758: p_entity_id => p_header_id,
6759: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6760: p_requesting_entity_id => p_header_id,
6761: p_request_type => OE_GLOBALS.G_DEL_CHG_LINES,
6755: END IF;
6756: oe_delayed_requests_pvt.log_request(
6757: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6758: p_entity_id => p_header_id,
6759: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6760: p_requesting_entity_id => p_header_id,
6761: p_request_type => OE_GLOBALS.G_DEL_CHG_LINES,
6762: x_return_status => l_return_status);
6763: IF l_debug_level > 0 THEN
6757: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6758: p_entity_id => p_header_id,
6759: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
6760: p_requesting_entity_id => p_header_id,
6761: p_request_type => OE_GLOBALS.G_DEL_CHG_LINES,
6762: x_return_status => l_return_status);
6763: IF l_debug_level > 0 THEN
6764: oe_debug_pub.add( ' RETURN STATUS FROM THE DELAYED REQUEST:'||L_RETURN_STATUS ) ;
6765: END IF;
6764: oe_debug_pub.add( ' RETURN STATUS FROM THE DELAYED REQUEST:'||L_RETURN_STATUS ) ;
6765: END IF;
6766: -- End If; -- Commented out for bug 12673852
6767:
6768: If p_operation In (OE_GLOBALS.G_OPR_CREATE,OE_GLOBALS.G_OPR_UPDATE) Then
6769: --bug 3020702 begin
6770: G_CHANGED_LINE_TBL(mod(p_line_id,G_BINARY_LIMIT)).line_id :=p_line_id;
6771: G_CHANGED_LINE_TBL(mod(p_line_id,G_BINARY_LIMIT)).header_id :=p_header_id;
6772: --bug 3020702 end
6769: --bug 3020702 begin
6770: G_CHANGED_LINE_TBL(mod(p_line_id,G_BINARY_LIMIT)).line_id :=p_line_id;
6771: G_CHANGED_LINE_TBL(mod(p_line_id,G_BINARY_LIMIT)).header_id :=p_header_id;
6772: --bug 3020702 end
6773: Elsif p_operation = OE_GLOBALS.G_OPR_DELETE Then
6774: If G_CHANGED_LINE_TBL.exists(mod(p_line_id,G_BINARY_LIMIT)) Then
6775: G_CHANGED_LINE_TBL.delete(mod(p_line_id,G_BINARY_LIMIT));
6776: End If;
6777: End If;