[Home] [Help]
366: )
367:
368: IS
369: l_index NUMBER :=0;
370: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
371: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
372: --
373: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
374: --
367:
368: IS
369: l_index NUMBER :=0;
370: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
371: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
372: --
373: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
374: --
375: BEGIN
386: -- every changed attribute clear its dependent fields.
387:
388: IF p_attr_id = FND_API.G_MISS_NUM THEN
389:
390: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.price_adjustment_id,p_old_Header_Adj_rec.price_adjustment_id)
391: THEN
392: l_index := l_index + 1;
393: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_PRICE_ADJUSTMENT;
394: END IF;
392: l_index := l_index + 1;
393: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_PRICE_ADJUSTMENT;
394: END IF;
395:
396: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.creation_date,p_old_Header_Adj_rec.creation_date)
397: THEN
398: l_index := l_index + 1;
399: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_CREATION_DATE;
400: END IF;
398: l_index := l_index + 1;
399: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_CREATION_DATE;
400: END IF;
401:
402: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.created_by,p_old_Header_Adj_rec.created_by)
403: THEN
404: l_index := l_index + 1;
405: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_CREATED_BY;
406: END IF;
404: l_index := l_index + 1;
405: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_CREATED_BY;
406: END IF;
407:
408: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.last_update_date,p_old_Header_Adj_rec.last_update_date)
409: THEN
410: l_index := l_index + 1;
411: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_LAST_UPDATE_DATE;
412: END IF;
410: l_index := l_index + 1;
411: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_LAST_UPDATE_DATE;
412: END IF;
413:
414: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.last_updated_by,p_old_Header_Adj_rec.last_updated_by)
415: THEN
416: l_index := l_index + 1;
417: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_LAST_UPDATED_BY;
418: END IF;
416: l_index := l_index + 1;
417: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_LAST_UPDATED_BY;
418: END IF;
419:
420: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.last_update_login,p_old_Header_Adj_rec.last_update_login)
421: THEN
422: l_index := l_index + 1;
423: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_LAST_UPDATE_LOGIN;
424: END IF;
422: l_index := l_index + 1;
423: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_LAST_UPDATE_LOGIN;
424: END IF;
425:
426: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.program_application_id,p_old_Header_Adj_rec.program_application_id)
427: THEN
428: l_index := l_index + 1;
429: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_PROGRAM_APPLICATION;
430: END IF;
428: l_index := l_index + 1;
429: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_PROGRAM_APPLICATION;
430: END IF;
431:
432: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.program_id,p_old_Header_Adj_rec.program_id)
433: THEN
434: l_index := l_index + 1;
435: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_PROGRAM;
436: END IF;
434: l_index := l_index + 1;
435: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_PROGRAM;
436: END IF;
437:
438: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.program_update_date,p_old_Header_Adj_rec.program_update_date)
439: THEN
440: l_index := l_index + 1;
441: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_PROGRAM_UPDATE_DATE;
442: END IF;
440: l_index := l_index + 1;
441: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_PROGRAM_UPDATE_DATE;
442: END IF;
443:
444: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.request_id,p_old_Header_Adj_rec.request_id)
445: THEN
446: l_index := l_index + 1;
447: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_REQUEST;
448: END IF;
446: l_index := l_index + 1;
447: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_REQUEST;
448: END IF;
449:
450: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.header_id,p_old_Header_Adj_rec.header_id)
451: THEN
452: l_index := l_index + 1;
453: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_HEADER;
454: END IF;
452: l_index := l_index + 1;
453: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_HEADER;
454: END IF;
455:
456: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.discount_id,p_old_Header_Adj_rec.discount_id)
457: THEN
458: l_index := l_index + 1;
459: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_DISCOUNT;
460: END IF;
458: l_index := l_index + 1;
459: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_DISCOUNT;
460: END IF;
461:
462: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.discount_line_id,p_old_Header_Adj_rec.discount_line_id)
463: THEN
464: l_index := l_index + 1;
465: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_DISCOUNT_LINE;
466: END IF;
464: l_index := l_index + 1;
465: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_DISCOUNT_LINE;
466: END IF;
467:
468: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.automatic_flag,p_old_Header_Adj_rec.automatic_flag)
469: THEN
470: l_index := l_index + 1;
471: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AUTOMATIC;
472: END IF;
470: l_index := l_index + 1;
471: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AUTOMATIC;
472: END IF;
473:
474: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.percent,p_old_Header_Adj_rec.percent)
475: THEN
476: l_index := l_index + 1;
477: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_PERCENT;
478: END IF;
476: l_index := l_index + 1;
477: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_PERCENT;
478: END IF;
479:
480: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.line_id,p_old_Header_Adj_rec.line_id)
481: THEN
482: l_index := l_index + 1;
483: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_LINE;
484: END IF;
482: l_index := l_index + 1;
483: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_LINE;
484: END IF;
485:
486: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.context,p_old_Header_Adj_rec.context)
487: THEN
488: l_index := l_index + 1;
489: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_CONTEXT;
490: END IF;
488: l_index := l_index + 1;
489: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_CONTEXT;
490: END IF;
491:
492: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute1,p_old_Header_Adj_rec.attribute1)
493: THEN
494: l_index := l_index + 1;
495: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE1;
496: END IF;
494: l_index := l_index + 1;
495: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE1;
496: END IF;
497:
498: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute2,p_old_Header_Adj_rec.attribute2)
499: THEN
500: l_index := l_index + 1;
501: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE2;
502: END IF;
500: l_index := l_index + 1;
501: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE2;
502: END IF;
503:
504: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute3,p_old_Header_Adj_rec.attribute3)
505: THEN
506: l_index := l_index + 1;
507: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE3;
508: END IF;
506: l_index := l_index + 1;
507: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE3;
508: END IF;
509:
510: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute4,p_old_Header_Adj_rec.attribute4)
511: THEN
512: l_index := l_index + 1;
513: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE4;
514: END IF;
512: l_index := l_index + 1;
513: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE4;
514: END IF;
515:
516: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute5,p_old_Header_Adj_rec.attribute5)
517: THEN
518: l_index := l_index + 1;
519: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE5;
520: END IF;
518: l_index := l_index + 1;
519: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE5;
520: END IF;
521:
522: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute6,p_old_Header_Adj_rec.attribute6)
523: THEN
524: l_index := l_index + 1;
525: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE6;
526: END IF;
524: l_index := l_index + 1;
525: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE6;
526: END IF;
527:
528: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute7,p_old_Header_Adj_rec.attribute7)
529: THEN
530: l_index := l_index + 1;
531: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE7;
532: END IF;
530: l_index := l_index + 1;
531: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE7;
532: END IF;
533:
534: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute8,p_old_Header_Adj_rec.attribute8)
535: THEN
536: l_index := l_index + 1;
537: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE8;
538: END IF;
536: l_index := l_index + 1;
537: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE8;
538: END IF;
539:
540: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute9,p_old_Header_Adj_rec.attribute9)
541: THEN
542: l_index := l_index + 1;
543: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE9;
544: END IF;
542: l_index := l_index + 1;
543: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE9;
544: END IF;
545:
546: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute10,p_old_Header_Adj_rec.attribute10)
547: THEN
548: l_index := l_index + 1;
549: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE10;
550: END IF;
548: l_index := l_index + 1;
549: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE10;
550: END IF;
551:
552: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute11,p_old_Header_Adj_rec.attribute11)
553: THEN
554: l_index := l_index + 1;
555: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE11;
556: END IF;
554: l_index := l_index + 1;
555: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE11;
556: END IF;
557:
558: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute12,p_old_Header_Adj_rec.attribute12)
559: THEN
560: l_index := l_index + 1;
561: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE12;
562: END IF;
560: l_index := l_index + 1;
561: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE12;
562: END IF;
563:
564: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute13,p_old_Header_Adj_rec.attribute13)
565: THEN
566: l_index := l_index + 1;
567: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE13;
568: END IF;
566: l_index := l_index + 1;
567: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE13;
568: END IF;
569:
570: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute14,p_old_Header_Adj_rec.attribute14)
571: THEN
572: l_index := l_index + 1;
573: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE14;
574: END IF;
572: l_index := l_index + 1;
573: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE14;
574: END IF;
575:
576: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute15,p_old_Header_Adj_rec.attribute15)
577: THEN
578: l_index := l_index + 1;
579: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE15;
580: END IF;
578: l_index := l_index + 1;
579: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ATTRIBUTE15;
580: END IF;
581:
582: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.COST_ID, p_old_Header_Adj_rec.COST_ID)
583: THEN
584: l_index := l_index + 1;
585: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_COST_ID;
586: END IF;
584: l_index := l_index + 1;
585: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_COST_ID;
586: END IF;
587:
588: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.TAX_CODE, p_old_Header_Adj_rec.TAX_CODE)
589: THEN
590: l_index := l_index + 1;
591: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_TAX_CODE;
592: END IF;
590: l_index := l_index + 1;
591: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_TAX_CODE;
592: END IF;
593:
594: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.TAX_EXEMPT_FLAG, p_old_Header_Adj_rec.TAX_EXEMPT_FLAG)
595: THEN
596: l_index := l_index + 1;
597: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_TAX_EXEMPT_FLAG;
598: END IF;
596: l_index := l_index + 1;
597: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_TAX_EXEMPT_FLAG;
598: END IF;
599:
600: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.TAX_EXEMPT_NUMBER, p_old_Header_Adj_rec.TAX_EXEMPT_NUMBER)
601: THEN
602: l_index := l_index + 1;
603: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_TAX_EXEMPT_NUMBER;
604: END IF;
602: l_index := l_index + 1;
603: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_TAX_EXEMPT_NUMBER;
604: END IF;
605:
606: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.TAX_EXEMPT_REASON_CODE, p_old_Header_Adj_rec.TAX_EXEMPT_REASON_CODE)
607: THEN
608: l_index := l_index + 1;
609: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_TAX_EXEMPT_REASON_CODE;
610: END IF;
608: l_index := l_index + 1;
609: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_TAX_EXEMPT_REASON_CODE;
610: END IF;
611:
612: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.PARENT_ADJUSTMENT_ID, p_old_Header_Adj_rec.PARENT_ADJUSTMENT_ID)
613: THEN
614: l_index := l_index + 1;
615: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_PARENT_ADJUSTMENT_ID;
616: END IF;
614: l_index := l_index + 1;
615: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_PARENT_ADJUSTMENT_ID;
616: END IF;
617:
618: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.INVOICED_FLAG, p_old_Header_Adj_rec.INVOICED_FLAG)
619: THEN
620: l_index := l_index + 1;
621: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_INVOICED_FLAG;
622: END IF;
620: l_index := l_index + 1;
621: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_INVOICED_FLAG;
622: END IF;
623:
624: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.ESTIMATED_FLAG, p_old_Header_Adj_rec.ESTIMATED_FLAG)
625: THEN
626: l_index := l_index + 1;
627: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_ESTIMATED_FLAG;
628: END IF;
626: l_index := l_index + 1;
627: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_ESTIMATED_FLAG;
628: END IF;
629:
630: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.INC_IN_SALES_PERFORMANCE, p_old_Header_Adj_rec.INC_IN_SALES_PERFORMANCE)
631: THEN
632: l_index := l_index + 1;
633: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_INC_IN_SALES_PERFORMANCE;
634: END IF;
632: l_index := l_index + 1;
633: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_INC_IN_SALES_PERFORMANCE;
634: END IF;
635:
636: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.SPLIT_ACTION_CODE, p_old_Header_Adj_rec.SPLIT_ACTION_CODE)
637: THEN
638: l_index := l_index + 1;
639: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_SPLIT_ACTION_CODE;
640: END IF;
638: l_index := l_index + 1;
639: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_SPLIT_ACTION_CODE;
640: END IF;
641:
642: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.charge_type_code, p_old_Header_Adj_rec.charge_type_code)
643: THEN
644: l_index := l_index + 1;
645: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_CHARGE_TYPE_CODE;
646: END IF;
644: l_index := l_index + 1;
645: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_CHARGE_TYPE_CODE;
646: END IF;
647:
648: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.charge_subtype_code, p_old_Header_Adj_rec.charge_subtype_code)
649: THEN
650: l_index := l_index + 1;
651: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_CHARGE_SUBTYPE_CODE;
652: END IF;
650: l_index := l_index + 1;
651: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_CHARGE_SUBTYPE_CODE;
652: END IF;
653:
654: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.list_line_no, p_old_Header_Adj_rec.list_line_no)
655: THEN
656: l_index := l_index + 1;
657: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_LIST_LINE_NO;
658: END IF;
656: l_index := l_index + 1;
657: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_LIST_LINE_NO;
658: END IF;
659:
660: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.source_system_code, p_old_Header_Adj_rec.source_system_code)
661: THEN
662: l_index := l_index + 1;
663: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_SOURCE_SYSTEM_CODE;
664: END IF;
662: l_index := l_index + 1;
663: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_SOURCE_SYSTEM_CODE;
664: END IF;
665:
666: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.benefit_qty, p_old_Header_Adj_rec.benefit_qty)
667: THEN
668: l_index := l_index + 1;
669: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_BENEFIT_QTY;
670: END IF;
668: l_index := l_index + 1;
669: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_BENEFIT_QTY;
670: END IF;
671:
672: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.benefit_uom_code, p_old_Header_Adj_rec.benefit_uom_code)
673: THEN
674: l_index := l_index + 1;
675: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_BENEFIT_UOM_CODE;
676: END IF;
674: l_index := l_index + 1;
675: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_BENEFIT_UOM_CODE;
676: END IF;
677:
678: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.print_on_invoice_flag, p_old_Header_Adj_rec.print_on_invoice_flag)
679: THEN
680: l_index := l_index + 1;
681: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_PRINT_ON_INVOICE_FLAG;
682: END IF;
680: l_index := l_index + 1;
681: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_PRINT_ON_INVOICE_FLAG;
682: END IF;
683:
684: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.expiration_date, p_old_Header_Adj_rec.expiration_date)
685: THEN
686: l_index := l_index + 1;
687: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_EXPIRATION_DATE;
688: END IF;
686: l_index := l_index + 1;
687: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_EXPIRATION_DATE;
688: END IF;
689:
690: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.rebate_transaction_type_code, p_old_Header_Adj_rec.rebate_transaction_type_code)
691: THEN
692: l_index := l_index + 1;
693: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_REBATE_TRANSACTION_TYPE_CODE;
694: END IF;
692: l_index := l_index + 1;
693: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_REBATE_TRANSACTION_TYPE_CODE;
694: END IF;
695:
696: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.rebate_transaction_reference, p_old_Header_Adj_rec.rebate_transaction_reference)
697: THEN
698: l_index := l_index + 1;
699: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_REBATE_TRANSACTION_REFERENCE;
700: END IF;
698: l_index := l_index + 1;
699: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_REBATE_TRANSACTION_REFERENCE;
700: END IF;
701:
702: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.rebate_payment_system_code, p_old_Header_Adj_rec.rebate_payment_system_code)
703: THEN
704: l_index := l_index + 1;
705: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_REBATE_PAYMENT_SYSTEM_CODE;
706: END IF;
704: l_index := l_index + 1;
705: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_REBATE_PAYMENT_SYSTEM_CODE;
706: END IF;
707:
708: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.redeemed_date, p_old_Header_Adj_rec.redeemed_date)
709: THEN
710: l_index := l_index + 1;
711: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_REDEEMED_DATE;
712: END IF;
710: l_index := l_index + 1;
711: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_REDEEMED_DATE;
712: END IF;
713:
714: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.redeemed_flag, p_old_Header_Adj_rec.redeemed_flag)
715: THEN
716: l_index := l_index + 1;
717: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_REDEEMED_FLAG;
718: END IF;
716: l_index := l_index + 1;
717: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_REDEEMED_FLAG;
718: END IF;
719:
720: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.accrual_flag, p_old_Header_Adj_rec.accrual_flag)
721: THEN
722: l_index := l_index + 1;
723: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_ACCRUAL_FLAG;
724: END IF;
722: l_index := l_index + 1;
723: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_ACCRUAL_FLAG;
724: END IF;
725:
726: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.range_break_quantity, p_old_Header_Adj_rec.range_break_quantity)
727: THEN
728: l_index := l_index + 1;
729: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_range_break_quantity;
730: END IF;
728: l_index := l_index + 1;
729: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_range_break_quantity;
730: END IF;
731:
732: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.accrual_conversion_rate, p_old_Header_Adj_rec.accrual_conversion_rate)
733: THEN
734: l_index := l_index + 1;
735: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_accrual_conversion_rate;
736: END IF;
734: l_index := l_index + 1;
735: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_accrual_conversion_rate;
736: END IF;
737:
738: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.pricing_group_sequence, p_old_Header_Adj_rec.pricing_group_sequence)
739: THEN
740: l_index := l_index + 1;
741: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_pricing_group_sequence;
742: END IF;
740: l_index := l_index + 1;
741: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_pricing_group_sequence;
742: END IF;
743:
744: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.modifier_level_code, p_old_Header_Adj_rec.modifier_level_code)
745: THEN
746: l_index := l_index + 1;
747: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_modifier_level_code;
748: END IF;
746: l_index := l_index + 1;
747: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_modifier_level_code;
748: END IF;
749:
750: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.price_break_type_code, p_old_Header_Adj_rec.price_break_type_code)
751: THEN
752: l_index := l_index + 1;
753: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_price_break_type_code;
754: END IF;
752: l_index := l_index + 1;
753: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_price_break_type_code;
754: END IF;
755:
756: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.substitution_attribute, p_old_Header_Adj_rec.substitution_attribute)
757: THEN
758: l_index := l_index + 1;
759: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_substitution_attribute;
760: END IF;
758: l_index := l_index + 1;
759: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_substitution_attribute;
760: END IF;
761:
762: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.proration_type_code, p_old_Header_Adj_rec.proration_type_code)
763: THEN
764: l_index := l_index + 1;
765: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_proration_type_code;
766: END IF;
764: l_index := l_index + 1;
765: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_proration_type_code;
766: END IF;
767:
768: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.credit_or_charge_flag, p_old_Header_Adj_rec.credit_or_charge_flag)
769: THEN
770: l_index := l_index + 1;
771: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_credit_or_charge_flag;
772: END IF;
770: l_index := l_index + 1;
771: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_credit_or_charge_flag;
772: END IF;
773:
774: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.include_on_returns_flag, p_old_Header_Adj_rec.include_on_returns_flag)
775: THEN
776: l_index := l_index + 1;
777: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_include_on_returns_flag;
778: END IF;
776: l_index := l_index + 1;
777: l_src_attr_tbl(l_index) := OE_Header_ADJ_UTIL.G_include_on_returns_flag;
778: END IF;
779:
780: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.ac_context,p_old_Header_Adj_rec.ac_context)
781: THEN
782: l_index := l_index + 1;
783: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_CONTEXT;
784: END IF;
782: l_index := l_index + 1;
783: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_CONTEXT;
784: END IF;
785:
786: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.ac_attribute1,p_old_Header_Adj_rec.ac_attribute1)
787: THEN
788: l_index := l_index + 1;
789: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE1;
790: END IF;
788: l_index := l_index + 1;
789: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE1;
790: END IF;
791:
792: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.ac_attribute2,p_old_Header_Adj_rec.ac_attribute2)
793: THEN
794: l_index := l_index + 1;
795: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE2;
796: END IF;
794: l_index := l_index + 1;
795: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE2;
796: END IF;
797:
798: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.ac_attribute3,p_old_Header_Adj_rec.ac_attribute3)
799: THEN
800: l_index := l_index + 1;
801: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE3;
802: END IF;
800: l_index := l_index + 1;
801: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE3;
802: END IF;
803:
804: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.ac_attribute4,p_old_Header_Adj_rec.ac_attribute4)
805: THEN
806: l_index := l_index + 1;
807: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE4;
808: END IF;
806: l_index := l_index + 1;
807: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE4;
808: END IF;
809:
810: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.ac_attribute5,p_old_Header_Adj_rec.ac_attribute5)
811: THEN
812: l_index := l_index + 1;
813: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE5;
814: END IF;
812: l_index := l_index + 1;
813: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE5;
814: END IF;
815:
816: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.ac_attribute6,p_old_Header_Adj_rec.ac_attribute6)
817: THEN
818: l_index := l_index + 1;
819: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE6;
820: END IF;
818: l_index := l_index + 1;
819: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE6;
820: END IF;
821:
822: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.ac_attribute7,p_old_Header_Adj_rec.ac_attribute7)
823: THEN
824: l_index := l_index + 1;
825: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE7;
826: END IF;
824: l_index := l_index + 1;
825: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE7;
826: END IF;
827:
828: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.ac_attribute8,p_old_Header_Adj_rec.ac_attribute8)
829: THEN
830: l_index := l_index + 1;
831: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE8;
832: END IF;
830: l_index := l_index + 1;
831: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE8;
832: END IF;
833:
834: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.ac_attribute9,p_old_Header_Adj_rec.ac_attribute9)
835: THEN
836: l_index := l_index + 1;
837: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE9;
838: END IF;
836: l_index := l_index + 1;
837: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE9;
838: END IF;
839:
840: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.ac_attribute10,p_old_Header_Adj_rec.ac_attribute10)
841: THEN
842: l_index := l_index + 1;
843: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE10;
844: END IF;
842: l_index := l_index + 1;
843: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE10;
844: END IF;
845:
846: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.ac_attribute11,p_old_Header_Adj_rec.ac_attribute11)
847: THEN
848: l_index := l_index + 1;
849: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE11;
850: END IF;
848: l_index := l_index + 1;
849: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE11;
850: END IF;
851:
852: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.ac_attribute12,p_old_Header_Adj_rec.ac_attribute12)
853: THEN
854: l_index := l_index + 1;
855: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE12;
856: END IF;
854: l_index := l_index + 1;
855: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE12;
856: END IF;
857:
858: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.ac_attribute13,p_old_Header_Adj_rec.ac_attribute13)
859: THEN
860: l_index := l_index + 1;
861: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE13;
862: END IF;
860: l_index := l_index + 1;
861: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE13;
862: END IF;
863:
864: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.ac_attribute14,p_old_Header_Adj_rec.ac_attribute14)
865: THEN
866: l_index := l_index + 1;
867: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE14;
868: END IF;
866: l_index := l_index + 1;
867: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE14;
868: END IF;
869:
870: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.ac_attribute15,p_old_Header_Adj_rec.ac_attribute15)
871: THEN
872: l_index := l_index + 1;
873: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE15;
874: END IF;
872: l_index := l_index + 1;
873: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_AC_ATTRIBUTE15;
874: END IF;
875:
876: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.operand,
877: p_old_Header_Adj_rec.operand)
878: THEN
879: l_index := l_index + 1;
880: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_OPERAND;
879: l_index := l_index + 1;
880: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_OPERAND;
881: END IF;
882:
883: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.adjusted_amount,
884: p_old_Header_Adj_rec.adjusted_amount)
885: THEN
886: l_index := l_index + 1;
887: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ADJUSTED_AMOUNT;
887: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ADJUSTED_AMOUNT;
888: END IF;
889:
890: --uom begin
891: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.operand_per_pqty,
892: p_old_Header_Adj_rec.operand_per_pqty)
893: THEN
894: l_index := l_index + 1;
895: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_OPERAND_PER_PQTY;
894: l_index := l_index + 1;
895: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_OPERAND_PER_PQTY;
896: END IF;
897:
898: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.adjusted_amount_per_pqty,
899: p_old_Header_Adj_rec.adjusted_amount_per_pqty)
900: THEN
901: l_index := l_index + 1;
902: l_src_attr_tbl(l_index) := OE_HEADER_ADJ_UTIL.G_ADJUSTED_AMOUNT_PER_PQTY;
912:
913: If l_src_attr_tbl.COUNT <> 0 THEN
914:
915: OE_Dependencies.Mark_Dependent
916: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
917: p_source_attr_tbl => l_src_attr_tbl,
918: p_dep_attr_tbl => l_dep_attr_tbl);
919:
920: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
1176: IF l_debug_level > 0 THEN
1177: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR MARGIN HOLD FOR BOOKED HEADER ID : '||p_header_id);
1178: END IF;
1179: oe_delayed_requests_pvt.log_request(
1180: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1181: p_entity_id => p_header_id,
1182: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1183: p_requesting_entity_id => p_header_id,
1184: p_request_type => 'MARGIN_HOLD',
1178: END IF;
1179: oe_delayed_requests_pvt.log_request(
1180: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1181: p_entity_id => p_header_id,
1182: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1183: p_requesting_entity_id => p_header_id,
1184: p_request_type => 'MARGIN_HOLD',
1185: x_return_status => l_return_status);
1186:
1225: -- Load out record
1226:
1227: --x_Header_Adj_rec := p_Header_Adj_rec;
1228:
1229: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.price_adjustment_id,p_old_Header_Adj_rec.price_adjustment_id)
1230: THEN
1231: NULL;
1232: END IF;
1233:
1230: THEN
1231: NULL;
1232: END IF;
1233:
1234: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.creation_date,p_old_Header_Adj_rec.creation_date)
1235: THEN
1236: NULL;
1237: END IF;
1238:
1235: THEN
1236: NULL;
1237: END IF;
1238:
1239: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.created_by,p_old_Header_Adj_rec.created_by)
1240: THEN
1241: NULL;
1242: END IF;
1243:
1240: THEN
1241: NULL;
1242: END IF;
1243:
1244: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.last_update_date,p_old_Header_Adj_rec.last_update_date)
1245: THEN
1246: NULL;
1247: END IF;
1248:
1245: THEN
1246: NULL;
1247: END IF;
1248:
1249: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.last_updated_by,p_old_Header_Adj_rec.last_updated_by)
1250: THEN
1251: NULL;
1252: END IF;
1253:
1250: THEN
1251: NULL;
1252: END IF;
1253:
1254: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.last_update_login,p_old_Header_Adj_rec.last_update_login)
1255: THEN
1256: NULL;
1257: END IF;
1258:
1255: THEN
1256: NULL;
1257: END IF;
1258:
1259: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.program_application_id,p_old_Header_Adj_rec.program_application_id)
1260: THEN
1261: NULL;
1262: END IF;
1263:
1260: THEN
1261: NULL;
1262: END IF;
1263:
1264: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.program_id,p_old_Header_Adj_rec.program_id)
1265: THEN
1266: NULL;
1267: END IF;
1268:
1265: THEN
1266: NULL;
1267: END IF;
1268:
1269: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.program_update_date,p_old_Header_Adj_rec.program_update_date)
1270: THEN
1271: NULL;
1272: END IF;
1273:
1270: THEN
1271: NULL;
1272: END IF;
1273:
1274: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.request_id,p_old_Header_Adj_rec.request_id)
1275: THEN
1276: NULL;
1277: END IF;
1278:
1275: THEN
1276: NULL;
1277: END IF;
1278:
1279: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.header_id,p_old_Header_Adj_rec.header_id)
1280: THEN
1281: NULL;
1282: END IF;
1283:
1281: NULL;
1282: END IF;
1283:
1284:
1285: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.discount_id,
1286: p_old_Header_Adj_rec.discount_id)
1287: THEN
1288: Null;
1289: END IF;
1287: THEN
1288: Null;
1289: END IF;
1290:
1291: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.discount_line_id,p_old_Header_Adj_rec.discount_line_id)
1292: THEN
1293: NULL;
1294: END IF;
1295:
1292: THEN
1293: NULL;
1294: END IF;
1295:
1296: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.automatic_flag,p_old_Header_Adj_rec.automatic_flag)
1297: THEN
1298: NULL;
1299: END IF;
1300:
1297: THEN
1298: NULL;
1299: END IF;
1300:
1301: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.percent,p_old_Header_Adj_rec.percent)
1302: THEN
1303: NULL;
1304: END IF;
1305:
1302: THEN
1303: NULL;
1304: END IF;
1305:
1306: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.line_id,p_old_Header_Adj_rec.line_id)
1307: THEN
1308: NULL;
1309: END IF;
1310:
1307: THEN
1308: NULL;
1309: END IF;
1310:
1311: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.context,p_old_Header_Adj_rec.context)
1312: THEN
1313: NULL;
1314: END IF;
1315:
1312: THEN
1313: NULL;
1314: END IF;
1315:
1316: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute1,p_old_Header_Adj_rec.attribute1)
1317: THEN
1318: NULL;
1319: END IF;
1320:
1317: THEN
1318: NULL;
1319: END IF;
1320:
1321: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute2,p_old_Header_Adj_rec.attribute2)
1322: THEN
1323: NULL;
1324: END IF;
1325:
1322: THEN
1323: NULL;
1324: END IF;
1325:
1326: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute3,p_old_Header_Adj_rec.attribute3)
1327: THEN
1328: NULL;
1329: END IF;
1330:
1327: THEN
1328: NULL;
1329: END IF;
1330:
1331: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute4,p_old_Header_Adj_rec.attribute4)
1332: THEN
1333: NULL;
1334: END IF;
1335:
1332: THEN
1333: NULL;
1334: END IF;
1335:
1336: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute5,p_old_Header_Adj_rec.attribute5)
1337: THEN
1338: NULL;
1339: END IF;
1340:
1337: THEN
1338: NULL;
1339: END IF;
1340:
1341: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute6,p_old_Header_Adj_rec.attribute6)
1342: THEN
1343: NULL;
1344: END IF;
1345:
1342: THEN
1343: NULL;
1344: END IF;
1345:
1346: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute7,p_old_Header_Adj_rec.attribute7)
1347: THEN
1348: NULL;
1349: END IF;
1350:
1347: THEN
1348: NULL;
1349: END IF;
1350:
1351: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute8,p_old_Header_Adj_rec.attribute8)
1352: THEN
1353: NULL;
1354: END IF;
1355:
1352: THEN
1353: NULL;
1354: END IF;
1355:
1356: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute9,p_old_Header_Adj_rec.attribute9)
1357: THEN
1358: NULL;
1359: END IF;
1360:
1357: THEN
1358: NULL;
1359: END IF;
1360:
1361: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute10,p_old_Header_Adj_rec.attribute10)
1362: THEN
1363: NULL;
1364: END IF;
1365:
1362: THEN
1363: NULL;
1364: END IF;
1365:
1366: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute11,p_old_Header_Adj_rec.attribute11)
1367: THEN
1368: NULL;
1369: END IF;
1370:
1367: THEN
1368: NULL;
1369: END IF;
1370:
1371: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute12,p_old_Header_Adj_rec.attribute12)
1372: THEN
1373: NULL;
1374: END IF;
1375:
1372: THEN
1373: NULL;
1374: END IF;
1375:
1376: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute13,p_old_Header_Adj_rec.attribute13)
1377: THEN
1378: NULL;
1379: END IF;
1380:
1377: THEN
1378: NULL;
1379: END IF;
1380:
1381: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute14,p_old_Header_Adj_rec.attribute14)
1382: THEN
1383: NULL;
1384: END IF;
1385:
1382: THEN
1383: NULL;
1384: END IF;
1385:
1386: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.attribute15,p_old_Header_Adj_rec.attribute15)
1387: THEN
1388: NULL;
1389: END IF;
1390:
1387: THEN
1388: NULL;
1389: END IF;
1390:
1391: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.list_header_id,p_old_Header_Adj_rec.list_header_id)
1392: THEN
1393: NULL;
1394: END IF;
1395:
1392: THEN
1393: NULL;
1394: END IF;
1395:
1396: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.list_line_id,p_old_Header_Adj_rec.list_line_id)
1397: THEN
1398: NULL;
1399: END IF;
1400:
1397: THEN
1398: NULL;
1399: END IF;
1400:
1401: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.list_line_type_code,p_old_Header_Adj_rec.list_line_type_code)
1402: THEN
1403: NULL;
1404: END IF;
1405:
1402: THEN
1403: NULL;
1404: END IF;
1405:
1406: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.modifier_mechanism_type_code,p_old_Header_Adj_rec.modifier_mechanism_type_code)
1407: THEN
1408: NULL;
1409: END IF;
1410:
1407: THEN
1408: NULL;
1409: END IF;
1410:
1411: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.update_allowed,p_old_Header_Adj_rec.update_allowed)
1412: THEN
1413: NULL;
1414: END IF;
1415:
1412: THEN
1413: NULL;
1414: END IF;
1415:
1416: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.updated_flag,p_old_Header_Adj_rec.updated_flag)
1417: THEN
1418: l_price_flag := TRUE;
1419: IF p_x_Header_Adj_rec.estimated_flag = 'Y' AND
1420: p_x_Header_Adj_rec.updated_flag = 'Y'
1427: p_x_Header_adj_rec.estimated_flag := 'Y';
1428: END IF;
1429: END IF;
1430:
1431: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.applied_flag,p_old_Header_Adj_rec.applied_flag)
1432: THEN
1433: l_price_flag := TRUE;
1434: --bug 4060297
1435: log_request_for_margin(p_x_Header_Adj_rec.header_id);
1452: null;
1453: END;
1454: END IF;
1455:
1456: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.operand,p_old_Header_Adj_rec.operand)
1457: THEN
1458: l_price_flag := TRUE;
1459: --bug 4060297
1460: log_request_for_margin(p_x_Header_Adj_rec.header_id);
1465: END IF;
1466: END IF;
1467:
1468:
1469: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.operand_per_pqty,p_old_Header_Adj_rec.operand_per_pqty)
1470: THEN
1471: l_price_flag := TRUE;
1472: END IF;
1473:
1470: THEN
1471: l_price_flag := TRUE;
1472: END IF;
1473:
1474: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.arithmetic_operator,p_old_Header_Adj_rec.arithmetic_operator)
1475: THEN
1476: l_price_flag := TRUE;
1477: END IF;
1478:
1475: THEN
1476: l_price_flag := TRUE;
1477: END IF;
1478:
1479: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.modified_from,p_old_Header_Adj_rec.modified_from)
1480: THEN
1481: NULL;
1482: END IF;
1483:
1480: THEN
1481: NULL;
1482: END IF;
1483:
1484: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.modified_to,p_old_Header_Adj_rec.modified_to)
1485: THEN
1486: NULL;
1487: END IF;
1488:
1485: THEN
1486: NULL;
1487: END IF;
1488:
1489: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.adjusted_amount,p_old_Header_Adj_rec.adjusted_amount)
1490: THEN
1491: NULL;
1492: END IF;
1493:
1490: THEN
1491: NULL;
1492: END IF;
1493:
1494: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.adjusted_amount_per_pqty,p_old_Header_Adj_rec.adjusted_amount_per_pqty)
1495: THEN
1496: NULL;
1497: END IF;
1498:
1495: THEN
1496: NULL;
1497: END IF;
1498:
1499: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.pricing_phase_id,p_old_Header_Adj_rec.pricing_phase_id)
1500: THEN
1501: l_price_flag := TRUE;
1502: END IF;
1503:
1500: THEN
1501: l_price_flag := TRUE;
1502: END IF;
1503:
1504: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.change_reason_code,p_old_Header_Adj_rec.change_reason_code)
1505: THEN
1506: NULL;
1507: END IF;
1508:
1505: THEN
1506: NULL;
1507: END IF;
1508:
1509: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.change_reason_text,p_old_Header_Adj_rec.change_reason_text)
1510: THEN
1511: NULL;
1512: END IF;
1513:
1510: THEN
1511: NULL;
1512: END IF;
1513:
1514: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.COST_ID, p_old_Header_Adj_rec.COST_ID)
1515: THEN
1516: NULL;
1517: END IF;
1518:
1515: THEN
1516: NULL;
1517: END IF;
1518:
1519: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.TAX_CODE, p_old_Header_Adj_rec.TAX_CODE)
1520: THEN
1521: NULL;
1522: END IF;
1523:
1520: THEN
1521: NULL;
1522: END IF;
1523:
1524: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.TAX_EXEMPT_FLAG, p_old_Header_Adj_rec.TAX_EXEMPT_FLAG)
1525: THEN
1526: NULL;
1527: END IF;
1528:
1525: THEN
1526: NULL;
1527: END IF;
1528:
1529: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.TAX_EXEMPT_NUMBER, p_old_Header_Adj_rec.TAX_EXEMPT_NUMBER)
1530: THEN
1531: NULL;
1532: END IF;
1533:
1530: THEN
1531: NULL;
1532: END IF;
1533:
1534: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.TAX_EXEMPT_REASON_CODE, p_old_Header_Adj_rec.TAX_EXEMPT_REASON_CODE)
1535: THEN
1536: NULL;
1537: END IF;
1538:
1535: THEN
1536: NULL;
1537: END IF;
1538:
1539: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.PARENT_ADJUSTMENT_ID, p_old_Header_Adj_rec.PARENT_ADJUSTMENT_ID)
1540: THEN
1541: NULL;
1542: END IF;
1543:
1540: THEN
1541: NULL;
1542: END IF;
1543:
1544: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.INVOICED_FLAG, p_old_Header_Adj_rec.INVOICED_FLAG)
1545: THEN
1546: NULL;
1547: END IF;
1548:
1545: THEN
1546: NULL;
1547: END IF;
1548:
1549: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.ESTIMATED_FLAG, p_old_Header_Adj_rec.ESTIMATED_FLAG)
1550: THEN
1551: NULL;
1552: END IF;
1553:
1550: THEN
1551: NULL;
1552: END IF;
1553:
1554: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.INC_IN_SALES_PERFORMANCE, p_old_Header_Adj_rec.INC_IN_SALES_PERFORMANCE)
1555: THEN
1556: NULL;
1557: END IF;
1558:
1555: THEN
1556: NULL;
1557: END IF;
1558:
1559: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.SPLIT_ACTION_CODE, p_old_Header_Adj_rec.SPLIT_ACTION_CODE)
1560: THEN
1561: NULL;
1562: END IF;
1563:
1560: THEN
1561: NULL;
1562: END IF;
1563:
1564: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.CHARGE_TYPE_CODE, p_old_Header_Adj_rec.CHARGE_TYPE_CODE)
1565: THEN
1566: NULL;
1567: END IF;
1568:
1565: THEN
1566: NULL;
1567: END IF;
1568:
1569: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.CHARGE_SUBTYPE_CODE, p_old_Header_Adj_rec.CHARGE_SUBTYPE_CODE)
1570: THEN
1571: NULL;
1572: END IF;
1573:
1570: THEN
1571: NULL;
1572: END IF;
1573:
1574: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.list_line_no, p_old_Header_Adj_rec.list_line_no)
1575: THEN
1576: NULL;
1577: END IF;
1578:
1575: THEN
1576: NULL;
1577: END IF;
1578:
1579: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.source_system_code, p_old_Header_Adj_rec.source_system_code)
1580: THEN
1581: NULL;
1582: END IF;
1583:
1580: THEN
1581: NULL;
1582: END IF;
1583:
1584: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.benefit_qty, p_old_Header_Adj_rec.benefit_qty)
1585: THEN
1586: NULL;
1587: END IF;
1588:
1585: THEN
1586: NULL;
1587: END IF;
1588:
1589: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.benefit_uom_code, p_old_Header_Adj_rec.benefit_uom_code)
1590: THEN
1591: NULL;
1592: END IF;
1593:
1590: THEN
1591: NULL;
1592: END IF;
1593:
1594: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.print_on_invoice_flag, p_old_Header_Adj_rec.print_on_invoice_flag)
1595: THEN
1596: NULL;
1597: END IF;
1598:
1595: THEN
1596: NULL;
1597: END IF;
1598:
1599: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.expiration_date, p_old_Header_Adj_rec.expiration_date)
1600: THEN
1601: NULL;
1602: END IF;
1603:
1600: THEN
1601: NULL;
1602: END IF;
1603:
1604: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.rebate_transaction_type_code, p_old_Header_Adj_rec.rebate_transaction_type_code)
1605: THEN
1606: NULL;
1607: END IF;
1608:
1605: THEN
1606: NULL;
1607: END IF;
1608:
1609: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.rebate_transaction_reference, p_old_Header_Adj_rec.rebate_transaction_reference)
1610: THEN
1611: NULL;
1612: END IF;
1613:
1610: THEN
1611: NULL;
1612: END IF;
1613:
1614: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.rebate_payment_system_code, p_old_Header_Adj_rec.rebate_payment_system_code)
1615: THEN
1616: NULL;
1617: END IF;
1618:
1615: THEN
1616: NULL;
1617: END IF;
1618:
1619: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.redeemed_date, p_old_Header_Adj_rec.redeemed_date)
1620: THEN
1621: NULL;
1622: END IF;
1623:
1620: THEN
1621: NULL;
1622: END IF;
1623:
1624: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.redeemed_flag, p_old_Header_Adj_rec.redeemed_flag)
1625: THEN
1626: NULL;
1627: END IF;
1628:
1625: THEN
1626: NULL;
1627: END IF;
1628:
1629: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.accrual_flag, p_old_Header_Adj_rec.accrual_flag)
1630: THEN
1631: NULL;
1632: END IF;
1633:
1630: THEN
1631: NULL;
1632: END IF;
1633:
1634: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.range_break_quantity, p_old_Header_Adj_rec.range_break_quantity)
1635: THEN
1636: NULL;
1637: END IF;
1638:
1635: THEN
1636: NULL;
1637: END IF;
1638:
1639: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.accrual_conversion_rate, p_old_Header_Adj_rec.accrual_conversion_rate)
1640: THEN
1641: NULL;
1642: END IF;
1643:
1640: THEN
1641: NULL;
1642: END IF;
1643:
1644: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.pricing_group_sequence, p_old_Header_Adj_rec.pricing_group_sequence)
1645: THEN
1646: l_price_flag := TRUE;
1647: END IF;
1648:
1645: THEN
1646: l_price_flag := TRUE;
1647: END IF;
1648:
1649: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.modifier_level_code, p_old_Header_Adj_rec.modifier_level_code)
1650: THEN
1651: NULL;
1652: END IF;
1653:
1650: THEN
1651: NULL;
1652: END IF;
1653:
1654: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.price_break_type_code, p_old_Header_Adj_rec.price_break_type_code)
1655: THEN
1656: NULL;
1657: END IF;
1658:
1655: THEN
1656: NULL;
1657: END IF;
1658:
1659: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.substitution_attribute, p_old_Header_Adj_rec.substitution_attribute)
1660: THEN
1661: NULL;
1662: END IF;
1663:
1660: THEN
1661: NULL;
1662: END IF;
1663:
1664: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.proration_type_code, p_old_Header_Adj_rec.proration_type_code)
1665: THEN
1666: NULL;
1667: END IF;
1668:
1665: THEN
1666: NULL;
1667: END IF;
1668:
1669: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.credit_or_charge_flag, p_old_Header_Adj_rec.credit_or_charge_flag)
1670: THEN
1671: NULL;
1672: END IF;
1673:
1670: THEN
1671: NULL;
1672: END IF;
1673:
1674: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.include_on_returns_flag, p_old_Header_Adj_rec.include_on_returns_flag)
1675: THEN
1676: NULL;
1677: END IF;
1678:
1675: THEN
1676: NULL;
1677: END IF;
1678:
1679: IF NOT OE_GLOBALS.Equal(p_x_Header_Adj_rec.invoiced_amount, p_old_Header_Adj_rec.invoiced_amount)
1680: THEN
1681: NULL;
1682: END IF;
1683:
1680: THEN
1681: NULL;
1682: END IF;
1683:
1684: IF l_price_flag and OE_Globals.G_RECURSION_MODE <> 'Y' AND
1685: p_x_Header_adj_rec.list_line_type_code NOT IN ('TAX','COST')
1686: THEN
1687:
1688: IF nvl(OE_ORDER_COPY_UTIL.G_COPY_REC.line_price_mode,-2) <> OE_ORDER_COPY_UTIL.G_CPY_ORIG_PRICE THEN
1687:
1688: IF nvl(OE_ORDER_COPY_UTIL.G_COPY_REC.line_price_mode,-2) <> OE_ORDER_COPY_UTIL.G_CPY_ORIG_PRICE THEN
1689: --no point to reprice all the line is user says copy with orig price, all lines
1690: --has calc price = 'N'
1691: oe_delayed_requests_pvt.log_request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1692: p_entity_id => p_x_header_adj_rec.Header_id,
1693: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
1694: p_requesting_entity_id => p_x_header_adj_rec.HEader_id,
1695: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
1689: --no point to reprice all the line is user says copy with orig price, all lines
1690: --has calc price = 'N'
1691: oe_delayed_requests_pvt.log_request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1692: p_entity_id => p_x_header_adj_rec.Header_id,
1693: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
1694: p_requesting_entity_id => p_x_header_adj_rec.HEader_id,
1695: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
1696: x_return_status => l_return_status);
1697: -- sol_ord_er #16014165
1691: oe_delayed_requests_pvt.log_request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1692: p_entity_id => p_x_header_adj_rec.Header_id,
1693: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
1694: p_requesting_entity_id => p_x_header_adj_rec.HEader_id,
1695: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
1696: x_return_status => l_return_status);
1697: -- sol_ord_er #16014165
1698: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1699: THEN
1699: THEN
1700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1701: END IF;
1702: oe_delayed_requests_pvt.log_request(
1703: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1704: p_entity_id => p_x_header_adj_rec.Header_Id,
1705: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1706: p_requesting_entity_id => p_x_header_adj_rec.Header_Id,
1707: p_request_type => OE_GLOBALS.G_SERVICE_FIRST_PERIOD_BILL,
1701: END IF;
1702: oe_delayed_requests_pvt.log_request(
1703: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1704: p_entity_id => p_x_header_adj_rec.Header_Id,
1705: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1706: p_requesting_entity_id => p_x_header_adj_rec.Header_Id,
1707: p_request_type => OE_GLOBALS.G_SERVICE_FIRST_PERIOD_BILL,
1708: p_request_unique_key1 => 'ORDER',
1709: p_param1 => p_x_header_adj_rec.Header_Id,
1703: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1704: p_entity_id => p_x_header_adj_rec.Header_Id,
1705: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1706: p_requesting_entity_id => p_x_header_adj_rec.Header_Id,
1707: p_request_type => OE_GLOBALS.G_SERVICE_FIRST_PERIOD_BILL,
1708: p_request_unique_key1 => 'ORDER',
1709: p_param1 => p_x_header_adj_rec.Header_Id,
1710: x_return_status => l_return_status);
1711: -- sol_ord_er #16014165 end
1800: IF NVL(l_credit_check_rule_rec.incl_freight_charges_flag,'N') = 'Y' THEN
1801: -- Log a request for Verify Payment
1802: oe_debug_pub.add('OEXUHADB: Logging Delayed Request for Verify Payment',3);
1803: OE_delayed_requests_Pvt.log_request
1804: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1805: p_entity_id => p_x_header_adj_rec.header_id,
1806: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1807: p_requesting_entity_id => p_x_header_adj_rec.header_id,
1808: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
1802: oe_debug_pub.add('OEXUHADB: Logging Delayed Request for Verify Payment',3);
1803: OE_delayed_requests_Pvt.log_request
1804: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1805: p_entity_id => p_x_header_adj_rec.header_id,
1806: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1807: p_requesting_entity_id => p_x_header_adj_rec.header_id,
1808: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
1809: x_return_status => l_return_status);
1810: --CC Reversal ER#16014135 Start
1804: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1805: p_entity_id => p_x_header_adj_rec.header_id,
1806: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1807: p_requesting_entity_id => p_x_header_adj_rec.header_id,
1808: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
1809: x_return_status => l_return_status);
1810: --CC Reversal ER#16014135 Start
1811: ELSIF OE_VERIFY_PAYMENT_PUB.Get_CC_Rev_Reauth_Code(p_x_header_adj_rec.header_id) IS NOT NULL THEN
1812: IF l_debug_level > 0 THEN
1813: oe_debug_pub.ADD('OEXUHADB: Logging delayed request for Verify Payment CC Reversal',5);
1814: END IF;
1815: oe_verify_payment_pub.G_credit_check_flag := 'N' ;
1816: OE_delayed_requests_Pvt.log_request
1817: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1818: p_entity_id => p_x_header_adj_rec.header_id,
1819: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1820: p_requesting_entity_id => p_x_header_adj_rec.header_id,
1821: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
1815: oe_verify_payment_pub.G_credit_check_flag := 'N' ;
1816: OE_delayed_requests_Pvt.log_request
1817: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1818: p_entity_id => p_x_header_adj_rec.header_id,
1819: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1820: p_requesting_entity_id => p_x_header_adj_rec.header_id,
1821: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
1822: x_return_status => l_return_status);
1823: --CC Reversal ER#16014135 End
1817: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1818: p_entity_id => p_x_header_adj_rec.header_id,
1819: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1820: p_requesting_entity_id => p_x_header_adj_rec.header_id,
1821: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
1822: x_return_status => l_return_status);
1823: --CC Reversal ER#16014135 End
1824: END IF;
1825: --CC Reversal ER#16014135 Start
1829: oe_debug_pub.ADD('OEXUHADB: Logging delayed request for Verify Payment CC Reversal when rule not exists',5);
1830: END IF;
1831: oe_verify_payment_pub.G_credit_check_flag := 'N' ;
1832: OE_delayed_requests_Pvt.log_request
1833: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1834: p_entity_id => p_x_header_adj_rec.header_id,
1835: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1836: p_requesting_entity_id => p_x_header_adj_rec.header_id,
1837: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
1831: oe_verify_payment_pub.G_credit_check_flag := 'N' ;
1832: OE_delayed_requests_Pvt.log_request
1833: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1834: p_entity_id => p_x_header_adj_rec.header_id,
1835: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1836: p_requesting_entity_id => p_x_header_adj_rec.header_id,
1837: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
1838: x_return_status => l_return_status);
1839: --CC Reversal ER#16014135 End
1833: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1834: p_entity_id => p_x_header_adj_rec.header_id,
1835: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1836: p_requesting_entity_id => p_x_header_adj_rec.header_id,
1837: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
1838: x_return_status => l_return_status);
1839: --CC Reversal ER#16014135 End
1840: END IF;
1841: --End bug#5961160
3300: oe_debug_pub.add( 'JFC: IN DELETE ROW , PRICE_ADJUSTMENT_ID= '|| L_ADJ.PRICE_ADJUSTMENT_ID ) ;
3301: END IF;
3302:
3303: /* Set the operation on the record so that globals are updated as well */
3304: l_new_header_adj_rec.operation := OE_GLOBALS.G_OPR_DELETE;
3305: l_new_header_adj_rec.price_adjustment_id := l_adj.price_adjustment_id;
3306:
3307: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
3308: p_Hdr_adj_rec =>l_new_header_adj_rec,
3335: -- notification framework end
3336:
3337:
3338: OE_Delayed_Requests_Pvt.Delete_Reqs_for_deleted_entity(
3339: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
3340: p_entity_id => l_adj.price_adjustment_id,
3341: x_return_status => l_return_status
3342: );
3343:
3363: oe_debug_pub.add( 'JFC:IN DELETE ROW , HEADER_ID IS G_MISS_NUM , PRICE_ADJUSTMENT_ID= '|| P_PRICE_ADJUSTMENT_ID , 1 ) ;
3364: END IF;
3365:
3366: /* Set the operation on the record so that globals are updated as well */
3367: l_new_header_adj_rec.operation := OE_GLOBALS.G_OPR_DELETE;
3368: l_new_header_adj_rec.price_adjustment_id := p_price_adjustment_id;
3369: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
3370: p_Hdr_adj_rec =>l_new_header_adj_rec,
3371: p_hdr_adj_id => p_price_adjustment_id,
3395: END IF; /*code_release_level*/
3396: -- notification framework end
3397:
3398: OE_Delayed_Requests_Pvt.Delete_Reqs_for_deleted_entity
3399: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
3400: p_entity_id => p_price_adjustment_id,
3401: x_return_status => l_return_status
3402: );
3403:
3992: IF l_debug_level > 0 THEN
3993: oe_debug_pub.add( 'COMPARE ' , 1 ) ;
3994: END IF;
3995:
3996: IF OE_GLOBALS.Equal(p_x_header_adj_rec.lock_control,
3997: l_lock_control)
3998: THEN
3999:
4000: -- Row has not changed. Set out parameter.
4233: p_delete_flag)
4234: THEN
4235:
4236: /*
4237: oe_delayed_requests_pvt.log_request(p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
4238: p_entity_id => p_adj_rec.header_id,
4239: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
4240: p_requesting_entity_id => p_adj_rec.
4241: price_adjustment_id,
4235:
4236: /*
4237: oe_delayed_requests_pvt.log_request(p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
4238: p_entity_id => p_adj_rec.header_id,
4239: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
4240: p_requesting_entity_id => p_adj_rec.
4241: price_adjustment_id,
4242: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
4243: x_return_status => x_return_status);
4238: p_entity_id => p_adj_rec.header_id,
4239: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
4240: p_requesting_entity_id => p_adj_rec.
4241: price_adjustment_id,
4242: p_request_type => OE_GLOBALS.G_PRICE_ADJ,
4243: x_return_status => x_return_status);
4244: */
4245: null;
4246: END IF;
4262: BEGIN
4263:
4264: IF (p_Header_Adj_rec.discount_id IS NULL OR
4265: p_Header_Adj_rec.discount_id <> FND_API.G_MISS_NUM) AND
4266: NOT OE_GLOBALS.Equal(p_Header_Adj_rec.discount_id,
4267: p_old_Header_Adj_rec.discount_id)
4268: THEN
4269: l_Header_Adj_val_rec.discount := OE_Id_To_Value.Discount
4270: ( p_discount_id => p_Header_Adj_rec.discount_id
4539: BEGIN
4540:
4541: --11.5.10 Versioning/Audit Trail updates
4542: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
4543: OE_GLOBALS.G_ROLL_VERSION <> 'N' AND
4544: NOT OE_GLOBALS.G_HEADER_CREATED THEN
4545: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
4546: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
4547: IF p_x_header_adj_rec.change_reason_code <> FND_API.G_MISS_CHAR THEN
4540:
4541: --11.5.10 Versioning/Audit Trail updates
4542: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
4543: OE_GLOBALS.G_ROLL_VERSION <> 'N' AND
4544: NOT OE_GLOBALS.G_HEADER_CREATED THEN
4545: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
4546: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
4547: IF p_x_header_adj_rec.change_reason_code <> FND_API.G_MISS_CHAR THEN
4548: OE_GLOBALS.G_REASON_TYPE := 'CHANGE_CODE';
4541: --11.5.10 Versioning/Audit Trail updates
4542: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
4543: OE_GLOBALS.G_ROLL_VERSION <> 'N' AND
4544: NOT OE_GLOBALS.G_HEADER_CREATED THEN
4545: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
4546: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
4547: IF p_x_header_adj_rec.change_reason_code <> FND_API.G_MISS_CHAR THEN
4548: OE_GLOBALS.G_REASON_TYPE := 'CHANGE_CODE';
4549: OE_GLOBALS.G_REASON_CODE := p_x_header_adj_rec.change_reason_code;
4542: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
4543: OE_GLOBALS.G_ROLL_VERSION <> 'N' AND
4544: NOT OE_GLOBALS.G_HEADER_CREATED THEN
4545: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
4546: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
4547: IF p_x_header_adj_rec.change_reason_code <> FND_API.G_MISS_CHAR THEN
4548: OE_GLOBALS.G_REASON_TYPE := 'CHANGE_CODE';
4549: OE_GLOBALS.G_REASON_CODE := p_x_header_adj_rec.change_reason_code;
4550: OE_GLOBALS.G_REASON_COMMENTS := p_x_header_adj_rec.change_reason_text;
4544: NOT OE_GLOBALS.G_HEADER_CREATED THEN
4545: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
4546: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
4547: IF p_x_header_adj_rec.change_reason_code <> FND_API.G_MISS_CHAR THEN
4548: OE_GLOBALS.G_REASON_TYPE := 'CHANGE_CODE';
4549: OE_GLOBALS.G_REASON_CODE := p_x_header_adj_rec.change_reason_code;
4550: OE_GLOBALS.G_REASON_COMMENTS := p_x_header_adj_rec.change_reason_text;
4551: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
4552: ELSE
4545: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
4546: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
4547: IF p_x_header_adj_rec.change_reason_code <> FND_API.G_MISS_CHAR THEN
4548: OE_GLOBALS.G_REASON_TYPE := 'CHANGE_CODE';
4549: OE_GLOBALS.G_REASON_CODE := p_x_header_adj_rec.change_reason_code;
4550: OE_GLOBALS.G_REASON_COMMENTS := p_x_header_adj_rec.change_reason_text;
4551: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
4552: ELSE
4553: IF l_debug_level > 0 THEN
4546: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
4547: IF p_x_header_adj_rec.change_reason_code <> FND_API.G_MISS_CHAR THEN
4548: OE_GLOBALS.G_REASON_TYPE := 'CHANGE_CODE';
4549: OE_GLOBALS.G_REASON_CODE := p_x_header_adj_rec.change_reason_code;
4550: OE_GLOBALS.G_REASON_COMMENTS := p_x_header_adj_rec.change_reason_text;
4551: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
4552: ELSE
4553: IF l_debug_level > 0 THEN
4554: OE_DEBUG_PUB.add('Reason code for versioning is missing', 1);
4547: IF p_x_header_adj_rec.change_reason_code <> FND_API.G_MISS_CHAR THEN
4548: OE_GLOBALS.G_REASON_TYPE := 'CHANGE_CODE';
4549: OE_GLOBALS.G_REASON_CODE := p_x_header_adj_rec.change_reason_code;
4550: OE_GLOBALS.G_REASON_COMMENTS := p_x_header_adj_rec.change_reason_text;
4551: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
4552: ELSE
4553: IF l_debug_level > 0 THEN
4554: OE_DEBUG_PUB.add('Reason code for versioning is missing', 1);
4555: END IF;
4552: ELSE
4553: IF l_debug_level > 0 THEN
4554: OE_DEBUG_PUB.add('Reason code for versioning is missing', 1);
4555: END IF;
4556: IF OE_GLOBALS.G_UI_FLAG THEN
4557: raise FND_API.G_EXC_ERROR;
4558: END IF;
4559: END IF;
4560: END IF;
4560: END IF;
4561:
4562: --log delayed request
4563: oe_debug_pub.add('log versioning request',1);
4564: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4565: p_entity_id => p_x_header_adj_rec.header_id,
4566: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
4567: p_requesting_entity_id => p_x_header_adj_rec.price_adjustment_id,
4568: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
4562: --log delayed request
4563: oe_debug_pub.add('log versioning request',1);
4564: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4565: p_entity_id => p_x_header_adj_rec.header_id,
4566: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
4567: p_requesting_entity_id => p_x_header_adj_rec.price_adjustment_id,
4568: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
4569: x_return_status => l_return_status);
4570: END IF;
4564: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4565: p_entity_id => p_x_header_adj_rec.header_id,
4566: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
4567: p_requesting_entity_id => p_x_header_adj_rec.price_adjustment_id,
4568: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
4569: x_return_status => l_return_status);
4570: END IF;
4571:
4572: if (p_x_header_adj_rec.operation = OE_GLOBALS.G_OPR_UPDATE) then
4568: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
4569: x_return_status => l_return_status);
4570: END IF;
4571:
4572: if (p_x_header_adj_rec.operation = OE_GLOBALS.G_OPR_UPDATE) then
4573:
4574: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' OR
4575: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN
4576:
4570: END IF;
4571:
4572: if (p_x_header_adj_rec.operation = OE_GLOBALS.G_OPR_UPDATE) then
4573:
4574: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' OR
4575: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN
4576:
4577: IF l_debug_level > 0 THEN
4578: oe_debug_pub.add( 'CALL TO RECORD HEADER PRICE ADJ HISTORY' , 5 ) ;
4571:
4572: if (p_x_header_adj_rec.operation = OE_GLOBALS.G_OPR_UPDATE) then
4573:
4574: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' OR
4575: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN
4576:
4577: IF l_debug_level > 0 THEN
4578: oe_debug_pub.add( 'CALL TO RECORD HEADER PRICE ADJ HISTORY' , 5 ) ;
4579: END IF;
4578: oe_debug_pub.add( 'CALL TO RECORD HEADER PRICE ADJ HISTORY' , 5 ) ;
4579: END IF;
4580: --11.5.10 Versioning/Audit Trail updates
4581: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
4582: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
4583: p_entity_id => p_x_header_adj_rec.price_adjustment_id,
4584: p_hist_type_code => 'UPDATE');
4585: --log delayed request
4586: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4582: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ,
4583: p_entity_id => p_x_header_adj_rec.price_adjustment_id,
4584: p_hist_type_code => 'UPDATE');
4585: --log delayed request
4586: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4587: p_entity_id => p_x_header_adj_rec.header_id,
4588: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
4589: p_requesting_entity_id => p_x_header_adj_rec.header_id,
4590: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
4584: p_hist_type_code => 'UPDATE');
4585: --log delayed request
4586: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4587: p_entity_id => p_x_header_adj_rec.header_id,
4588: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
4589: p_requesting_entity_id => p_x_header_adj_rec.header_id,
4590: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
4591: x_return_status => l_return_status);
4592: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
4586: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4587: p_entity_id => p_x_header_adj_rec.header_id,
4588: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
4589: p_requesting_entity_id => p_x_header_adj_rec.header_id,
4590: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
4591: x_return_status => l_return_status);
4592: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
4593: ELSE
4594: OE_CHG_ORDER_PVT.RecordHPAdjHist
4588: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
4589: p_requesting_entity_id => p_x_header_adj_rec.header_id,
4590: p_request_type => OE_GLOBALS.G_VERSION_AUDIT,
4591: x_return_status => l_return_status);
4592: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
4593: ELSE
4594: OE_CHG_ORDER_PVT.RecordHPAdjHist
4595: ( p_header_adj_id => p_x_header_adj_rec.price_adjustment_id,
4596: p_header_adj_rec => null,
4681:
4682:
4683: IF l_current_event >= l_tax_calculation_event_code THEN
4684:
4685: IF (OE_GLOBALS.G_UI_FLAG)
4686: AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N'
4687: THEN
4688: OE_delayed_requests_Pvt.log_request(
4689: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
4685: IF (OE_GLOBALS.G_UI_FLAG)
4686: AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N'
4687: THEN
4688: OE_delayed_requests_Pvt.log_request(
4689: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
4690: p_entity_id => p_x_header_adj_rec.header_id,
4691: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
4692: p_requesting_entity_id => p_x_header_adj_rec.header_id,
4693: p_request_type => OE_GLOBALS.g_tax_line,
4687: THEN
4688: OE_delayed_requests_Pvt.log_request(
4689: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
4690: p_entity_id => p_x_header_adj_rec.header_id,
4691: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
4692: p_requesting_entity_id => p_x_header_adj_rec.header_id,
4693: p_request_type => OE_GLOBALS.g_tax_line,
4694: x_return_status => l_return_status);
4695: ELSE
4689: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
4690: p_entity_id => p_x_header_adj_rec.header_id,
4691: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
4692: p_requesting_entity_id => p_x_header_adj_rec.header_id,
4693: p_request_type => OE_GLOBALS.g_tax_line,
4694: x_return_status => l_return_status);
4695: ELSE
4696: OE_delayed_requests_Pvt.log_request(
4697: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4693: p_request_type => OE_GLOBALS.g_tax_line,
4694: x_return_status => l_return_status);
4695: ELSE
4696: OE_delayed_requests_Pvt.log_request(
4697: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4698: p_entity_id => p_x_header_adj_rec.header_id,
4699: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
4700: p_requesting_entity_id => p_x_header_adj_rec.header_id,
4701: p_request_type => OE_GLOBALS.g_tax_line,
4695: ELSE
4696: OE_delayed_requests_Pvt.log_request(
4697: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4698: p_entity_id => p_x_header_adj_rec.header_id,
4699: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
4700: p_requesting_entity_id => p_x_header_adj_rec.header_id,
4701: p_request_type => OE_GLOBALS.g_tax_line,
4702: p_param1 => NULL,
4703: x_return_status => l_return_status);
4697: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
4698: p_entity_id => p_x_header_adj_rec.header_id,
4699: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
4700: p_requesting_entity_id => p_x_header_adj_rec.header_id,
4701: p_request_type => OE_GLOBALS.g_tax_line,
4702: p_param1 => NULL,
4703: x_return_status => l_return_status);
4704: END IF;
4705: END IF;
4727: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4728: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4729: i pls_integer;
4730: j pls_integer;
4731: l_control_rec OE_Globals.Control_rec_type;
4732: l_header_rec OE_Order_PUB.Header_Rec_Type;
4733: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4734: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4735: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4791:
4792: j := l_from_header_adj_att_tbl.First;
4793: While j is not null Loop
4794:
4795: l_from_header_adj_att_tbl(j).operation := OE_GLOBALS.G_OPR_CREATE;
4796: l_from_header_adj_att_tbl(j).price_adjustment_id := fnd_api.g_miss_num;
4797: l_from_header_adj_att_tbl(j).adj_index := l_header_adj_tbl.count+1;
4798: l_from_header_adj_att_tbl(j).price_adj_attrib_id := fnd_api.g_miss_num;
4799:
4802: j := l_from_header_adj_att_tbl.Next(j);
4803:
4804: End Loop;
4805:
4806: l_from_header_adj_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
4807: l_from_header_adj_tbl(i).header_id := p_to_header_id;
4808: l_from_header_adj_tbl(i).invoiced_flag := 'N';
4809: l_from_header_adj_tbl(i).price_adjustment_id := fnd_api.g_miss_num;
4810:
4831: l_control_rec.clear_api_requests := FALSE;
4832:
4833: oe_debug_pub.add('Before OE_Order_PVT.Process_order',3);
4834:
4835: -- OE_Globals.G_RECURSION_MODE := 'Y';
4836:
4837: -- Call OE_Order_PVT.Process_order
4838: OE_Order_PVT.Process_order
4839: ( p_api_version_number => 1.0
4856: , p_x_Lot_Serial_tbl => l_x_Lot_Serial_Tbl
4857: , p_x_action_request_tbl => l_x_Action_Request_tbl
4858: );
4859:
4860: -- OE_Globals.G_RECURSION_MODE := 'N';
4861:
4862: If x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
4863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4864: Elsif x_return_status = FND_API.G_RET_STS_ERROR Then
4908: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4909: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4910: i pls_integer;
4911: j pls_integer;
4912: l_control_rec OE_Globals.Control_rec_type;
4913: l_header_rec OE_Order_PUB.Header_Rec_Type;
4914: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4915: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4916: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5026:
5027: j := l_from_header_adj_att_tbl.First;
5028: While j is not null Loop
5029:
5030: l_from_header_adj_att_tbl(j).operation := OE_GLOBALS.G_OPR_CREATE;
5031: l_from_header_adj_att_tbl(j).price_adjustment_id := fnd_api.g_miss_num;
5032: l_from_header_adj_att_tbl(j).adj_index := l_header_adj_tbl.count+1;
5033: l_from_header_adj_att_tbl(j).price_adj_attrib_id := fnd_api.g_miss_num;
5034:
5037: j := l_from_header_adj_att_tbl.Next(j);
5038:
5039: End Loop;
5040:
5041: l_from_header_adj_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
5042: l_from_header_adj_tbl(i).header_id := p_to_header_id;
5043: l_from_header_adj_tbl(i).invoiced_flag := 'N';
5044: l_from_header_adj_tbl(i).invoiced_amount := NULL;
5045: l_from_header_adj_tbl(i).price_adjustment_id := fnd_api.g_miss_num;
5070: IF l_debug_level > 0 THEN
5071: oe_debug_pub.add( 'BEFORE OE_ORDER_PVT.PROCESS_ORDER' , 3 ) ;
5072: END IF;
5073:
5074: -- OE_Globals.G_RECURSION_MODE := 'Y';
5075:
5076: -- Call OE_Order_PVT.Process_order
5077: OE_Order_PVT.Process_order
5078: ( p_api_version_number => 1.0
5101: , p_x_Lot_Serial_tbl => l_x_Lot_Serial_Tbl
5102: , p_x_action_request_tbl => l_x_Action_Request_tbl
5103: );
5104:
5105: -- OE_Globals.G_RECURSION_MODE := 'N';
5106:
5107: If x_return_status = FND_API.G_RET_STS_UNEXP_ERROR Then
5108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5109: Elsif x_return_status = FND_API.G_RET_STS_ERROR Then