458: x_adjusted_amount_per_pqty := l_x_Header_Adj_rec.adjusted_amount_per_pqty;
459: --uom end
460: -- Load display out parameters if any
461:
462: l_Header_Adj_val_rec := OE_Header_Adj_Util.Get_Values
463: ( p_Header_Adj_rec => l_x_Header_Adj_rec
464: );
465: x_discount := l_Header_Adj_val_rec.discount;
466:
822:
823: l_x_old_Header_Adj_rec := l_x_Header_Adj_rec;
824:
825:
826: IF p_attr_id = OE_Header_Adj_Util.G_PRICE_ADJUSTMENT THEN
827: l_x_Header_Adj_rec.price_adjustment_id := TO_NUMBER(p_attr_value1);
828: ELSIF p_attr_id = OE_Header_Adj_Util.G_HEADER THEN
829: l_x_Header_Adj_rec.header_id := TO_NUMBER(p_attr_value1);
830:
824:
825:
826: IF p_attr_id = OE_Header_Adj_Util.G_PRICE_ADJUSTMENT THEN
827: l_x_Header_Adj_rec.price_adjustment_id := TO_NUMBER(p_attr_value1);
828: ELSIF p_attr_id = OE_Header_Adj_Util.G_HEADER THEN
829: l_x_Header_Adj_rec.header_id := TO_NUMBER(p_attr_value1);
830:
831: -- The following has been done because a discount can only
832: -- be uniquely identified with a discount_id and discount_line_id
835: --
836: -- It ATTR_ID is discount_id then
837: -- ATTR_VALUE1 is discount_id
838: -- ATTR_VALUE2 is discount_line_id
839: ELSIF p_attr_id = OE_Header_Adj_Util.G_DISCOUNT THEN
840: l_x_Header_Adj_rec.discount_id := TO_NUMBER(p_attr_value1);
841: l_x_Header_Adj_rec.discount_line_id := TO_NUMBER(p_attr_value2);
842:
843: -- It ATTR_ID is discount_line_id then
842:
843: -- It ATTR_ID is discount_line_id then
844: -- ATTR_VALUE1 is discount_line_id
845: -- ATTR_VALUE2 is discount_id
846: ELSIF p_attr_id = OE_Header_Adj_Util.G_DISCOUNT_LINE THEN
847: l_x_Header_Adj_rec.discount_line_id := TO_NUMBER(p_attr_value1);
848: l_x_Header_Adj_rec.discount_id := TO_NUMBER(p_attr_value2);
849:
850: -- New code Added :: Column Changes
847: l_x_Header_Adj_rec.discount_line_id := TO_NUMBER(p_attr_value1);
848: l_x_Header_Adj_rec.discount_id := TO_NUMBER(p_attr_value2);
849:
850: -- New code Added :: Column Changes
851: ELSIF p_attr_id = OE_Header_Adj_Util.G_LIST_HEADER_ID then
852: l_x_Header_Adj_rec.list_header_id := to_number(p_attr_value1) ;
853: ELSIF p_attr_id = OE_Header_Adj_Util.G_LIST_LINE_ID then
854: l_x_Header_Adj_rec.list_line_id := to_number(p_attr_value1) ;
855: ELSIF p_attr_id = OE_Header_Adj_Util.G_LIST_LINE_TYPE_CODE then
849:
850: -- New code Added :: Column Changes
851: ELSIF p_attr_id = OE_Header_Adj_Util.G_LIST_HEADER_ID then
852: l_x_Header_Adj_rec.list_header_id := to_number(p_attr_value1) ;
853: ELSIF p_attr_id = OE_Header_Adj_Util.G_LIST_LINE_ID then
854: l_x_Header_Adj_rec.list_line_id := to_number(p_attr_value1) ;
855: ELSIF p_attr_id = OE_Header_Adj_Util.G_LIST_LINE_TYPE_CODE then
856: l_x_Header_Adj_rec.list_line_type_code := p_attr_value1 ;
857: ELSIF p_attr_id = OE_Header_Adj_Util.G_MODIFIER_MECHANISM_TYPE_CODE then
851: ELSIF p_attr_id = OE_Header_Adj_Util.G_LIST_HEADER_ID then
852: l_x_Header_Adj_rec.list_header_id := to_number(p_attr_value1) ;
853: ELSIF p_attr_id = OE_Header_Adj_Util.G_LIST_LINE_ID then
854: l_x_Header_Adj_rec.list_line_id := to_number(p_attr_value1) ;
855: ELSIF p_attr_id = OE_Header_Adj_Util.G_LIST_LINE_TYPE_CODE then
856: l_x_Header_Adj_rec.list_line_type_code := p_attr_value1 ;
857: ELSIF p_attr_id = OE_Header_Adj_Util.G_MODIFIER_MECHANISM_TYPE_CODE then
858: l_x_Header_Adj_rec.modifier_mechanism_type_code := p_attr_value1 ;
859: ELSIF p_attr_id = OE_Header_Adj_Util.G_MODIFIED_FROM then
853: ELSIF p_attr_id = OE_Header_Adj_Util.G_LIST_LINE_ID then
854: l_x_Header_Adj_rec.list_line_id := to_number(p_attr_value1) ;
855: ELSIF p_attr_id = OE_Header_Adj_Util.G_LIST_LINE_TYPE_CODE then
856: l_x_Header_Adj_rec.list_line_type_code := p_attr_value1 ;
857: ELSIF p_attr_id = OE_Header_Adj_Util.G_MODIFIER_MECHANISM_TYPE_CODE then
858: l_x_Header_Adj_rec.modifier_mechanism_type_code := p_attr_value1 ;
859: ELSIF p_attr_id = OE_Header_Adj_Util.G_MODIFIED_FROM then
860: l_x_Header_Adj_rec.modified_from := p_attr_value1;
861: ELSIF p_attr_id = OE_Header_Adj_Util.G_MODIFIED_TO then
855: ELSIF p_attr_id = OE_Header_Adj_Util.G_LIST_LINE_TYPE_CODE then
856: l_x_Header_Adj_rec.list_line_type_code := p_attr_value1 ;
857: ELSIF p_attr_id = OE_Header_Adj_Util.G_MODIFIER_MECHANISM_TYPE_CODE then
858: l_x_Header_Adj_rec.modifier_mechanism_type_code := p_attr_value1 ;
859: ELSIF p_attr_id = OE_Header_Adj_Util.G_MODIFIED_FROM then
860: l_x_Header_Adj_rec.modified_from := p_attr_value1;
861: ELSIF p_attr_id = OE_Header_Adj_Util.G_MODIFIED_TO then
862: l_x_Header_Adj_rec.modified_to := p_attr_value1;
863: ELSIF p_attr_id = OE_Header_Adj_Util.G_UPDATE_ALLOWED then
857: ELSIF p_attr_id = OE_Header_Adj_Util.G_MODIFIER_MECHANISM_TYPE_CODE then
858: l_x_Header_Adj_rec.modifier_mechanism_type_code := p_attr_value1 ;
859: ELSIF p_attr_id = OE_Header_Adj_Util.G_MODIFIED_FROM then
860: l_x_Header_Adj_rec.modified_from := p_attr_value1;
861: ELSIF p_attr_id = OE_Header_Adj_Util.G_MODIFIED_TO then
862: l_x_Header_Adj_rec.modified_to := p_attr_value1;
863: ELSIF p_attr_id = OE_Header_Adj_Util.G_UPDATE_ALLOWED then
864: l_x_Header_Adj_rec.update_allowed := p_attr_value1 ;
865: ELSIF p_attr_id = OE_Header_Adj_Util.G_UPDATED_FLAG then
859: ELSIF p_attr_id = OE_Header_Adj_Util.G_MODIFIED_FROM then
860: l_x_Header_Adj_rec.modified_from := p_attr_value1;
861: ELSIF p_attr_id = OE_Header_Adj_Util.G_MODIFIED_TO then
862: l_x_Header_Adj_rec.modified_to := p_attr_value1;
863: ELSIF p_attr_id = OE_Header_Adj_Util.G_UPDATE_ALLOWED then
864: l_x_Header_Adj_rec.update_allowed := p_attr_value1 ;
865: ELSIF p_attr_id = OE_Header_Adj_Util.G_UPDATED_FLAG then
866: l_x_Header_Adj_rec.updated_flag := p_attr_value1 ;
867: ELSIF p_attr_id = OE_Header_Adj_Util.G_APPLIED_FLAG then
861: ELSIF p_attr_id = OE_Header_Adj_Util.G_MODIFIED_TO then
862: l_x_Header_Adj_rec.modified_to := p_attr_value1;
863: ELSIF p_attr_id = OE_Header_Adj_Util.G_UPDATE_ALLOWED then
864: l_x_Header_Adj_rec.update_allowed := p_attr_value1 ;
865: ELSIF p_attr_id = OE_Header_Adj_Util.G_UPDATED_FLAG then
866: l_x_Header_Adj_rec.updated_flag := p_attr_value1 ;
867: ELSIF p_attr_id = OE_Header_Adj_Util.G_APPLIED_FLAG then
868: l_x_Header_Adj_rec.applied_flag := p_attr_value1 ;
869: ELSIF p_attr_id = OE_Header_Adj_Util.G_CHANGE_REASON_CODE then
863: ELSIF p_attr_id = OE_Header_Adj_Util.G_UPDATE_ALLOWED then
864: l_x_Header_Adj_rec.update_allowed := p_attr_value1 ;
865: ELSIF p_attr_id = OE_Header_Adj_Util.G_UPDATED_FLAG then
866: l_x_Header_Adj_rec.updated_flag := p_attr_value1 ;
867: ELSIF p_attr_id = OE_Header_Adj_Util.G_APPLIED_FLAG then
868: l_x_Header_Adj_rec.applied_flag := p_attr_value1 ;
869: ELSIF p_attr_id = OE_Header_Adj_Util.G_CHANGE_REASON_CODE then
870: l_x_Header_Adj_rec.change_reason_code := p_attr_value1 ;
871: ELSIF p_attr_id = OE_Header_Adj_Util.G_CHANGE_REASON_TEXT then
865: ELSIF p_attr_id = OE_Header_Adj_Util.G_UPDATED_FLAG then
866: l_x_Header_Adj_rec.updated_flag := p_attr_value1 ;
867: ELSIF p_attr_id = OE_Header_Adj_Util.G_APPLIED_FLAG then
868: l_x_Header_Adj_rec.applied_flag := p_attr_value1 ;
869: ELSIF p_attr_id = OE_Header_Adj_Util.G_CHANGE_REASON_CODE then
870: l_x_Header_Adj_rec.change_reason_code := p_attr_value1 ;
871: ELSIF p_attr_id = OE_Header_Adj_Util.G_CHANGE_REASON_TEXT then
872: l_x_Header_Adj_rec.change_reason_text := p_attr_value1 ;
873: ELSIF p_attr_id = OE_Header_Adj_Util.G_OPERAND then
867: ELSIF p_attr_id = OE_Header_Adj_Util.G_APPLIED_FLAG then
868: l_x_Header_Adj_rec.applied_flag := p_attr_value1 ;
869: ELSIF p_attr_id = OE_Header_Adj_Util.G_CHANGE_REASON_CODE then
870: l_x_Header_Adj_rec.change_reason_code := p_attr_value1 ;
871: ELSIF p_attr_id = OE_Header_Adj_Util.G_CHANGE_REASON_TEXT then
872: l_x_Header_Adj_rec.change_reason_text := p_attr_value1 ;
873: ELSIF p_attr_id = OE_Header_Adj_Util.G_OPERAND then
874: l_x_Header_Adj_rec.operand := p_attr_value1 ;
875: ELSIF p_attr_id = OE_Header_Adj_Util.G_ARITHMETIC_OPERATOR then
869: ELSIF p_attr_id = OE_Header_Adj_Util.G_CHANGE_REASON_CODE then
870: l_x_Header_Adj_rec.change_reason_code := p_attr_value1 ;
871: ELSIF p_attr_id = OE_Header_Adj_Util.G_CHANGE_REASON_TEXT then
872: l_x_Header_Adj_rec.change_reason_text := p_attr_value1 ;
873: ELSIF p_attr_id = OE_Header_Adj_Util.G_OPERAND then
874: l_x_Header_Adj_rec.operand := p_attr_value1 ;
875: ELSIF p_attr_id = OE_Header_Adj_Util.G_ARITHMETIC_OPERATOR then
876: l_x_Header_Adj_rec.arithmetic_operator := p_attr_value1 ;
877:
871: ELSIF p_attr_id = OE_Header_Adj_Util.G_CHANGE_REASON_TEXT then
872: l_x_Header_Adj_rec.change_reason_text := p_attr_value1 ;
873: ELSIF p_attr_id = OE_Header_Adj_Util.G_OPERAND then
874: l_x_Header_Adj_rec.operand := p_attr_value1 ;
875: ELSIF p_attr_id = OE_Header_Adj_Util.G_ARITHMETIC_OPERATOR then
876: l_x_Header_Adj_rec.arithmetic_operator := p_attr_value1 ;
877:
878: ELSIF p_attr_id = OE_Header_Adj_Util.G_ADJUSTED_AMOUNT then
879: l_x_Header_Adj_rec.adjusted_amount := p_attr_value1 ;
874: l_x_Header_Adj_rec.operand := p_attr_value1 ;
875: ELSIF p_attr_id = OE_Header_Adj_Util.G_ARITHMETIC_OPERATOR then
876: l_x_Header_Adj_rec.arithmetic_operator := p_attr_value1 ;
877:
878: ELSIF p_attr_id = OE_Header_Adj_Util.G_ADJUSTED_AMOUNT then
879: l_x_Header_Adj_rec.adjusted_amount := p_attr_value1 ;
880: ELSIF p_attr_id = OE_Header_Adj_Util.G_PRICING_PHASE_ID then
881: l_x_Header_Adj_rec.pricing_phase_id := p_attr_value1 ;
882: ELSIF p_attr_id = OE_Header_Adj_Util.G_LIST_LINE_NO then
876: l_x_Header_Adj_rec.arithmetic_operator := p_attr_value1 ;
877:
878: ELSIF p_attr_id = OE_Header_Adj_Util.G_ADJUSTED_AMOUNT then
879: l_x_Header_Adj_rec.adjusted_amount := p_attr_value1 ;
880: ELSIF p_attr_id = OE_Header_Adj_Util.G_PRICING_PHASE_ID then
881: l_x_Header_Adj_rec.pricing_phase_id := p_attr_value1 ;
882: ELSIF p_attr_id = OE_Header_Adj_Util.G_LIST_LINE_NO then
883: l_x_Header_Adj_rec.list_line_no := p_attr_value1 ;
884: ELSIF p_attr_id = OE_Header_Adj_Util.G_SOURCE_SYSTEM_CODE then
878: ELSIF p_attr_id = OE_Header_Adj_Util.G_ADJUSTED_AMOUNT then
879: l_x_Header_Adj_rec.adjusted_amount := p_attr_value1 ;
880: ELSIF p_attr_id = OE_Header_Adj_Util.G_PRICING_PHASE_ID then
881: l_x_Header_Adj_rec.pricing_phase_id := p_attr_value1 ;
882: ELSIF p_attr_id = OE_Header_Adj_Util.G_LIST_LINE_NO then
883: l_x_Header_Adj_rec.list_line_no := p_attr_value1 ;
884: ELSIF p_attr_id = OE_Header_Adj_Util.G_SOURCE_SYSTEM_CODE then
885: l_x_Header_Adj_rec.source_system_code := p_attr_value1;
886: ELSIF p_attr_id = OE_Header_Adj_Util.G_BENEFIT_QTY then
880: ELSIF p_attr_id = OE_Header_Adj_Util.G_PRICING_PHASE_ID then
881: l_x_Header_Adj_rec.pricing_phase_id := p_attr_value1 ;
882: ELSIF p_attr_id = OE_Header_Adj_Util.G_LIST_LINE_NO then
883: l_x_Header_Adj_rec.list_line_no := p_attr_value1 ;
884: ELSIF p_attr_id = OE_Header_Adj_Util.G_SOURCE_SYSTEM_CODE then
885: l_x_Header_Adj_rec.source_system_code := p_attr_value1;
886: ELSIF p_attr_id = OE_Header_Adj_Util.G_BENEFIT_QTY then
887: l_x_Header_Adj_rec.benefit_qty := TO_NUMBER(p_attr_value1);
888: ELSIF p_attr_id = OE_Header_Adj_Util.G_BENEFIT_UOM_CODE then
882: ELSIF p_attr_id = OE_Header_Adj_Util.G_LIST_LINE_NO then
883: l_x_Header_Adj_rec.list_line_no := p_attr_value1 ;
884: ELSIF p_attr_id = OE_Header_Adj_Util.G_SOURCE_SYSTEM_CODE then
885: l_x_Header_Adj_rec.source_system_code := p_attr_value1;
886: ELSIF p_attr_id = OE_Header_Adj_Util.G_BENEFIT_QTY then
887: l_x_Header_Adj_rec.benefit_qty := TO_NUMBER(p_attr_value1);
888: ELSIF p_attr_id = OE_Header_Adj_Util.G_BENEFIT_UOM_CODE then
889: l_x_Header_Adj_rec.benefit_uom_code := p_attr_value1;
890: ELSIF p_attr_id = OE_Header_Adj_Util.G_PRINT_ON_INVOICE_FLAG then
884: ELSIF p_attr_id = OE_Header_Adj_Util.G_SOURCE_SYSTEM_CODE then
885: l_x_Header_Adj_rec.source_system_code := p_attr_value1;
886: ELSIF p_attr_id = OE_Header_Adj_Util.G_BENEFIT_QTY then
887: l_x_Header_Adj_rec.benefit_qty := TO_NUMBER(p_attr_value1);
888: ELSIF p_attr_id = OE_Header_Adj_Util.G_BENEFIT_UOM_CODE then
889: l_x_Header_Adj_rec.benefit_uom_code := p_attr_value1;
890: ELSIF p_attr_id = OE_Header_Adj_Util.G_PRINT_ON_INVOICE_FLAG then
891: l_x_Header_Adj_rec.print_on_invoice_flag := p_attr_value1;
892: ELSIF p_attr_id = OE_Header_Adj_Util.G_EXPIRATION_DATE then
886: ELSIF p_attr_id = OE_Header_Adj_Util.G_BENEFIT_QTY then
887: l_x_Header_Adj_rec.benefit_qty := TO_NUMBER(p_attr_value1);
888: ELSIF p_attr_id = OE_Header_Adj_Util.G_BENEFIT_UOM_CODE then
889: l_x_Header_Adj_rec.benefit_uom_code := p_attr_value1;
890: ELSIF p_attr_id = OE_Header_Adj_Util.G_PRINT_ON_INVOICE_FLAG then
891: l_x_Header_Adj_rec.print_on_invoice_flag := p_attr_value1;
892: ELSIF p_attr_id = OE_Header_Adj_Util.G_EXPIRATION_DATE then
893: --l_x_Header_Adj_rec.expiration_date := TO_DATE(p_attr_value1, l_date_format);
894: l_x_Header_Adj_rec.expiration_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396
888: ELSIF p_attr_id = OE_Header_Adj_Util.G_BENEFIT_UOM_CODE then
889: l_x_Header_Adj_rec.benefit_uom_code := p_attr_value1;
890: ELSIF p_attr_id = OE_Header_Adj_Util.G_PRINT_ON_INVOICE_FLAG then
891: l_x_Header_Adj_rec.print_on_invoice_flag := p_attr_value1;
892: ELSIF p_attr_id = OE_Header_Adj_Util.G_EXPIRATION_DATE then
893: --l_x_Header_Adj_rec.expiration_date := TO_DATE(p_attr_value1, l_date_format);
894: l_x_Header_Adj_rec.expiration_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396
895: ELSIF p_attr_id = OE_Header_Adj_Util.G_REBATE_TRANSACTION_TYPE_CODE then
896: l_x_Header_Adj_rec.rebate_transaction_type_code := p_attr_value1;
891: l_x_Header_Adj_rec.print_on_invoice_flag := p_attr_value1;
892: ELSIF p_attr_id = OE_Header_Adj_Util.G_EXPIRATION_DATE then
893: --l_x_Header_Adj_rec.expiration_date := TO_DATE(p_attr_value1, l_date_format);
894: l_x_Header_Adj_rec.expiration_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396
895: ELSIF p_attr_id = OE_Header_Adj_Util.G_REBATE_TRANSACTION_TYPE_CODE then
896: l_x_Header_Adj_rec.rebate_transaction_type_code := p_attr_value1;
897: ELSIF p_attr_id = OE_Header_Adj_Util.G_REBATE_TRANSACTION_REFERENCE then
898: l_x_Header_Adj_rec.rebate_transaction_reference := p_attr_value1;
899: ELSIF p_attr_id = OE_Header_Adj_Util.G_REBATE_PAYMENT_SYSTEM_CODE then
893: --l_x_Header_Adj_rec.expiration_date := TO_DATE(p_attr_value1, l_date_format);
894: l_x_Header_Adj_rec.expiration_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396
895: ELSIF p_attr_id = OE_Header_Adj_Util.G_REBATE_TRANSACTION_TYPE_CODE then
896: l_x_Header_Adj_rec.rebate_transaction_type_code := p_attr_value1;
897: ELSIF p_attr_id = OE_Header_Adj_Util.G_REBATE_TRANSACTION_REFERENCE then
898: l_x_Header_Adj_rec.rebate_transaction_reference := p_attr_value1;
899: ELSIF p_attr_id = OE_Header_Adj_Util.G_REBATE_PAYMENT_SYSTEM_CODE then
900: l_x_Header_Adj_rec.rebate_payment_system_code := p_attr_value1;
901: ELSIF p_attr_id = OE_Header_Adj_Util.G_REDEEMED_DATE then
895: ELSIF p_attr_id = OE_Header_Adj_Util.G_REBATE_TRANSACTION_TYPE_CODE then
896: l_x_Header_Adj_rec.rebate_transaction_type_code := p_attr_value1;
897: ELSIF p_attr_id = OE_Header_Adj_Util.G_REBATE_TRANSACTION_REFERENCE then
898: l_x_Header_Adj_rec.rebate_transaction_reference := p_attr_value1;
899: ELSIF p_attr_id = OE_Header_Adj_Util.G_REBATE_PAYMENT_SYSTEM_CODE then
900: l_x_Header_Adj_rec.rebate_payment_system_code := p_attr_value1;
901: ELSIF p_attr_id = OE_Header_Adj_Util.G_REDEEMED_DATE then
902: --l_x_Header_Adj_rec.redeemed_date := TO_DATE(p_attr_value1, l_date_format);
903: l_x_Header_Adj_rec.redeemed_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396
897: ELSIF p_attr_id = OE_Header_Adj_Util.G_REBATE_TRANSACTION_REFERENCE then
898: l_x_Header_Adj_rec.rebate_transaction_reference := p_attr_value1;
899: ELSIF p_attr_id = OE_Header_Adj_Util.G_REBATE_PAYMENT_SYSTEM_CODE then
900: l_x_Header_Adj_rec.rebate_payment_system_code := p_attr_value1;
901: ELSIF p_attr_id = OE_Header_Adj_Util.G_REDEEMED_DATE then
902: --l_x_Header_Adj_rec.redeemed_date := TO_DATE(p_attr_value1, l_date_format);
903: l_x_Header_Adj_rec.redeemed_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396
904: ELSIF p_attr_id = OE_Header_Adj_Util.G_REDEEMED_FLAG then
905: l_x_Header_Adj_rec.redeemed_flag := p_attr_value1;
900: l_x_Header_Adj_rec.rebate_payment_system_code := p_attr_value1;
901: ELSIF p_attr_id = OE_Header_Adj_Util.G_REDEEMED_DATE then
902: --l_x_Header_Adj_rec.redeemed_date := TO_DATE(p_attr_value1, l_date_format);
903: l_x_Header_Adj_rec.redeemed_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396
904: ELSIF p_attr_id = OE_Header_Adj_Util.G_REDEEMED_FLAG then
905: l_x_Header_Adj_rec.redeemed_flag := p_attr_value1;
906: ELSIF p_attr_id = OE_Header_Adj_Util.G_ACCRUAL_FLAG then
907: l_x_Header_Adj_rec.accrual_flag := p_attr_value1;
908:
902: --l_x_Header_Adj_rec.redeemed_date := TO_DATE(p_attr_value1, l_date_format);
903: l_x_Header_Adj_rec.redeemed_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396
904: ELSIF p_attr_id = OE_Header_Adj_Util.G_REDEEMED_FLAG then
905: l_x_Header_Adj_rec.redeemed_flag := p_attr_value1;
906: ELSIF p_attr_id = OE_Header_Adj_Util.G_ACCRUAL_FLAG then
907: l_x_Header_Adj_rec.accrual_flag := p_attr_value1;
908:
909: ELSIF p_attr_id = OE_Header_Adj_Util.G_AUTOMATIC THEN
910: l_x_Header_Adj_rec.automatic_flag := p_attr_value1;
905: l_x_Header_Adj_rec.redeemed_flag := p_attr_value1;
906: ELSIF p_attr_id = OE_Header_Adj_Util.G_ACCRUAL_FLAG then
907: l_x_Header_Adj_rec.accrual_flag := p_attr_value1;
908:
909: ELSIF p_attr_id = OE_Header_Adj_Util.G_AUTOMATIC THEN
910: l_x_Header_Adj_rec.automatic_flag := p_attr_value1;
911: ELSIF p_attr_id = OE_Header_Adj_Util.G_PERCENT THEN
912: l_x_Header_Adj_rec.percent := TO_NUMBER(p_attr_value1);
913: --Manual begin
907: l_x_Header_Adj_rec.accrual_flag := p_attr_value1;
908:
909: ELSIF p_attr_id = OE_Header_Adj_Util.G_AUTOMATIC THEN
910: l_x_Header_Adj_rec.automatic_flag := p_attr_value1;
911: ELSIF p_attr_id = OE_Header_Adj_Util.G_PERCENT THEN
912: l_x_Header_Adj_rec.percent := TO_NUMBER(p_attr_value1);
913: --Manual begin
914: ELSIF p_attr_id = OE_Header_Adj_Util.G_LINE THEN
915: If p_attr_value1 is Not Null Then
910: l_x_Header_Adj_rec.automatic_flag := p_attr_value1;
911: ELSIF p_attr_id = OE_Header_Adj_Util.G_PERCENT THEN
912: l_x_Header_Adj_rec.percent := TO_NUMBER(p_attr_value1);
913: --Manual begin
914: ELSIF p_attr_id = OE_Header_Adj_Util.G_LINE THEN
915: If p_attr_value1 is Not Null Then
916: l_x_Header_Adj_rec.line_id := TO_NUMBER(p_attr_value1);
917: Else
918: l_x_Header_Adj_rec.line_id := NULL;
917: Else
918: l_x_Header_Adj_rec.line_id := NULL;
919: End If;
920: --Manual end
921: ELSIF p_attr_id = OE_Header_Adj_Util.G_ESTIMATED_FLAG THEN
922: l_x_Header_Adj_rec.estimated_flag := p_attr_value1;
923: ELSIF p_attr_id = OE_Header_Adj_Util.G_INVOICED_FLAG THEN
924: l_x_Header_Adj_rec.INVOICED_FLAG := p_attr_value1;
925: ELSIF p_attr_id = OE_Header_Adj_Util.G_credit_or_charge_flag THEN
919: End If;
920: --Manual end
921: ELSIF p_attr_id = OE_Header_Adj_Util.G_ESTIMATED_FLAG THEN
922: l_x_Header_Adj_rec.estimated_flag := p_attr_value1;
923: ELSIF p_attr_id = OE_Header_Adj_Util.G_INVOICED_FLAG THEN
924: l_x_Header_Adj_rec.INVOICED_FLAG := p_attr_value1;
925: ELSIF p_attr_id = OE_Header_Adj_Util.G_credit_or_charge_flag THEN
926: l_x_Header_Adj_rec.credit_or_charge_flag := p_attr_value1;
927: ELSIF p_attr_id = OE_Header_Adj_Util.G_include_on_returns_flag THEN
921: ELSIF p_attr_id = OE_Header_Adj_Util.G_ESTIMATED_FLAG THEN
922: l_x_Header_Adj_rec.estimated_flag := p_attr_value1;
923: ELSIF p_attr_id = OE_Header_Adj_Util.G_INVOICED_FLAG THEN
924: l_x_Header_Adj_rec.INVOICED_FLAG := p_attr_value1;
925: ELSIF p_attr_id = OE_Header_Adj_Util.G_credit_or_charge_flag THEN
926: l_x_Header_Adj_rec.credit_or_charge_flag := p_attr_value1;
927: ELSIF p_attr_id = OE_Header_Adj_Util.G_include_on_returns_flag THEN
928: l_x_Header_Adj_rec.include_on_returns_flag := p_attr_value1;
929: ELSIF p_attr_id = OE_Header_Adj_Util.G_charge_type_code THEN
923: ELSIF p_attr_id = OE_Header_Adj_Util.G_INVOICED_FLAG THEN
924: l_x_Header_Adj_rec.INVOICED_FLAG := p_attr_value1;
925: ELSIF p_attr_id = OE_Header_Adj_Util.G_credit_or_charge_flag THEN
926: l_x_Header_Adj_rec.credit_or_charge_flag := p_attr_value1;
927: ELSIF p_attr_id = OE_Header_Adj_Util.G_include_on_returns_flag THEN
928: l_x_Header_Adj_rec.include_on_returns_flag := p_attr_value1;
929: ELSIF p_attr_id = OE_Header_Adj_Util.G_charge_type_code THEN
930: l_x_Header_Adj_rec.charge_type_code := p_attr_value1;
931: ELSIF p_attr_id = OE_Header_Adj_Util.G_charge_subtype_code THEN
925: ELSIF p_attr_id = OE_Header_Adj_Util.G_credit_or_charge_flag THEN
926: l_x_Header_Adj_rec.credit_or_charge_flag := p_attr_value1;
927: ELSIF p_attr_id = OE_Header_Adj_Util.G_include_on_returns_flag THEN
928: l_x_Header_Adj_rec.include_on_returns_flag := p_attr_value1;
929: ELSIF p_attr_id = OE_Header_Adj_Util.G_charge_type_code THEN
930: l_x_Header_Adj_rec.charge_type_code := p_attr_value1;
931: ELSIF p_attr_id = OE_Header_Adj_Util.G_charge_subtype_code THEN
932: l_x_Header_Adj_rec.charge_subtype_code := p_attr_value1;
933: --uom begin
927: ELSIF p_attr_id = OE_Header_Adj_Util.G_include_on_returns_flag THEN
928: l_x_Header_Adj_rec.include_on_returns_flag := p_attr_value1;
929: ELSIF p_attr_id = OE_Header_Adj_Util.G_charge_type_code THEN
930: l_x_Header_Adj_rec.charge_type_code := p_attr_value1;
931: ELSIF p_attr_id = OE_Header_Adj_Util.G_charge_subtype_code THEN
932: l_x_Header_Adj_rec.charge_subtype_code := p_attr_value1;
933: --uom begin
934: ELSIF p_attr_id = OE_Header_Adj_Util.G_operand_per_pqty Then
935: l_x_Header_Adj_rec.operand_per_pqty := to_number(p_attr_value1);
930: l_x_Header_Adj_rec.charge_type_code := p_attr_value1;
931: ELSIF p_attr_id = OE_Header_Adj_Util.G_charge_subtype_code THEN
932: l_x_Header_Adj_rec.charge_subtype_code := p_attr_value1;
933: --uom begin
934: ELSIF p_attr_id = OE_Header_Adj_Util.G_operand_per_pqty Then
935: l_x_Header_Adj_rec.operand_per_pqty := to_number(p_attr_value1);
936: ELSIF p_attr_id = OE_Header_Adj_Util.G_adjusted_amount_per_pqty Then
937: l_x_Header_Adj_rec.adjusted_amount_per_pqty := to_number(p_attr_value1);
938: --uom end
932: l_x_Header_Adj_rec.charge_subtype_code := p_attr_value1;
933: --uom begin
934: ELSIF p_attr_id = OE_Header_Adj_Util.G_operand_per_pqty Then
935: l_x_Header_Adj_rec.operand_per_pqty := to_number(p_attr_value1);
936: ELSIF p_attr_id = OE_Header_Adj_Util.G_adjusted_amount_per_pqty Then
937: l_x_Header_Adj_rec.adjusted_amount_per_pqty := to_number(p_attr_value1);
938: --uom end
939: --Manual begin
940: ELSIF p_attr_id = OE_Header_Adj_Util.G_modifier_level_code Then
936: ELSIF p_attr_id = OE_Header_Adj_Util.G_adjusted_amount_per_pqty Then
937: l_x_Header_Adj_rec.adjusted_amount_per_pqty := to_number(p_attr_value1);
938: --uom end
939: --Manual begin
940: ELSIF p_attr_id = OE_Header_Adj_Util.G_modifier_level_code Then
941: l_x_Header_Adj_rec.modifier_level_code := p_attr_value1;
942: ELSIF p_attr_id = OE_Header_Adj_Util.G_OVERRIDE_ALLOWED_FLAG Then
943: l_x_Header_Adj_rec.update_allowed:= p_attr_value1;
944: --Manual end
938: --uom end
939: --Manual begin
940: ELSIF p_attr_id = OE_Header_Adj_Util.G_modifier_level_code Then
941: l_x_Header_Adj_rec.modifier_level_code := p_attr_value1;
942: ELSIF p_attr_id = OE_Header_Adj_Util.G_OVERRIDE_ALLOWED_FLAG Then
943: l_x_Header_Adj_rec.update_allowed:= p_attr_value1;
944: --Manual end
945: ELSIF p_attr_id = OE_Header_Adj_Util.G_CONTEXT
946: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE1
941: l_x_Header_Adj_rec.modifier_level_code := p_attr_value1;
942: ELSIF p_attr_id = OE_Header_Adj_Util.G_OVERRIDE_ALLOWED_FLAG Then
943: l_x_Header_Adj_rec.update_allowed:= p_attr_value1;
944: --Manual end
945: ELSIF p_attr_id = OE_Header_Adj_Util.G_CONTEXT
946: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE1
947: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE2
948: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE3
949: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE4
942: ELSIF p_attr_id = OE_Header_Adj_Util.G_OVERRIDE_ALLOWED_FLAG Then
943: l_x_Header_Adj_rec.update_allowed:= p_attr_value1;
944: --Manual end
945: ELSIF p_attr_id = OE_Header_Adj_Util.G_CONTEXT
946: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE1
947: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE2
948: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE3
949: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE4
950: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE5
943: l_x_Header_Adj_rec.update_allowed:= p_attr_value1;
944: --Manual end
945: ELSIF p_attr_id = OE_Header_Adj_Util.G_CONTEXT
946: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE1
947: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE2
948: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE3
949: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE4
950: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE5
951: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE6
944: --Manual end
945: ELSIF p_attr_id = OE_Header_Adj_Util.G_CONTEXT
946: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE1
947: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE2
948: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE3
949: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE4
950: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE5
951: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE6
952: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE7
945: ELSIF p_attr_id = OE_Header_Adj_Util.G_CONTEXT
946: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE1
947: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE2
948: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE3
949: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE4
950: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE5
951: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE6
952: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE7
953: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE8
946: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE1
947: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE2
948: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE3
949: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE4
950: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE5
951: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE6
952: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE7
953: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE8
954: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE9
947: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE2
948: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE3
949: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE4
950: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE5
951: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE6
952: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE7
953: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE8
954: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE9
955: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE10
948: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE3
949: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE4
950: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE5
951: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE6
952: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE7
953: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE8
954: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE9
955: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE10
956: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE11
949: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE4
950: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE5
951: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE6
952: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE7
953: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE8
954: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE9
955: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE10
956: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE11
957: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE12
950: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE5
951: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE6
952: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE7
953: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE8
954: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE9
955: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE10
956: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE11
957: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE12
958: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE13
951: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE6
952: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE7
953: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE8
954: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE9
955: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE10
956: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE11
957: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE12
958: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE13
959: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE14
952: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE7
953: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE8
954: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE9
955: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE10
956: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE11
957: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE12
958: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE13
959: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE14
960: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE15
953: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE8
954: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE9
955: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE10
956: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE11
957: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE12
958: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE13
959: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE14
960: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE15
961: THEN
954: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE9
955: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE10
956: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE11
957: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE12
958: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE13
959: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE14
960: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE15
961: THEN
962:
955: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE10
956: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE11
957: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE12
958: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE13
959: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE14
960: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE15
961: THEN
962:
963: l_x_Header_Adj_rec.context := p_context;
956: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE11
957: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE12
958: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE13
959: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE14
960: OR p_attr_id = OE_Header_Adj_Util.G_ATTRIBUTE15
961: THEN
962:
963: l_x_Header_Adj_rec.context := p_context;
964: l_x_Header_Adj_rec.attribute1 := p_attribute1;
975: l_x_Header_Adj_rec.attribute12 := p_attribute12;
976: l_x_Header_Adj_rec.attribute13 := p_attribute13;
977: l_x_Header_Adj_rec.attribute14 := p_attribute14;
978: l_x_Header_Adj_rec.attribute15 := p_attribute15;
979: ELSIF p_attr_id = OE_Header_Adj_Util.G_AC_CONTEXT
980: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE1
981: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE2
982: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE3
983: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE4
976: l_x_Header_Adj_rec.attribute13 := p_attribute13;
977: l_x_Header_Adj_rec.attribute14 := p_attribute14;
978: l_x_Header_Adj_rec.attribute15 := p_attribute15;
979: ELSIF p_attr_id = OE_Header_Adj_Util.G_AC_CONTEXT
980: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE1
981: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE2
982: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE3
983: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE4
984: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE5
977: l_x_Header_Adj_rec.attribute14 := p_attribute14;
978: l_x_Header_Adj_rec.attribute15 := p_attribute15;
979: ELSIF p_attr_id = OE_Header_Adj_Util.G_AC_CONTEXT
980: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE1
981: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE2
982: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE3
983: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE4
984: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE5
985: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE6
978: l_x_Header_Adj_rec.attribute15 := p_attribute15;
979: ELSIF p_attr_id = OE_Header_Adj_Util.G_AC_CONTEXT
980: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE1
981: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE2
982: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE3
983: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE4
984: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE5
985: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE6
986: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE7
979: ELSIF p_attr_id = OE_Header_Adj_Util.G_AC_CONTEXT
980: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE1
981: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE2
982: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE3
983: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE4
984: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE5
985: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE6
986: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE7
987: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE8
980: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE1
981: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE2
982: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE3
983: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE4
984: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE5
985: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE6
986: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE7
987: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE8
988: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE9
981: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE2
982: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE3
983: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE4
984: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE5
985: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE6
986: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE7
987: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE8
988: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE9
989: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE10
982: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE3
983: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE4
984: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE5
985: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE6
986: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE7
987: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE8
988: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE9
989: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE10
990: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE11
983: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE4
984: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE5
985: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE6
986: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE7
987: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE8
988: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE9
989: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE10
990: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE11
991: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE12
984: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE5
985: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE6
986: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE7
987: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE8
988: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE9
989: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE10
990: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE11
991: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE12
992: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE13
985: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE6
986: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE7
987: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE8
988: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE9
989: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE10
990: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE11
991: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE12
992: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE13
993: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE14
986: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE7
987: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE8
988: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE9
989: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE10
990: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE11
991: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE12
992: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE13
993: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE14
994: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE15
987: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE8
988: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE9
989: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE10
990: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE11
991: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE12
992: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE13
993: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE14
994: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE15
995: THEN
988: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE9
989: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE10
990: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE11
991: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE12
992: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE13
993: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE14
994: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE15
995: THEN
996:
989: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE10
990: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE11
991: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE12
992: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE13
993: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE14
994: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE15
995: THEN
996:
997: l_x_Header_Adj_rec.ac_context := p_ac_context;
990: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE11
991: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE12
992: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE13
993: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE14
994: OR p_attr_id = OE_Header_Adj_Util.G_AC_ATTRIBUTE15
995: THEN
996:
997: l_x_Header_Adj_rec.ac_context := p_ac_context;
998: l_x_Header_Adj_rec.ac_attribute1 := p_ac_attribute1;
1038:
1039:
1040: -- Request execution of delayed request on if a discount is
1041: -- applied
1042: /* IF p_attr_id = OE_Header_Adj_Util.G_DISCOUNT_LINE
1043: OR
1044: p_attr_id = OE_Header_Adj_Util.G_DISCOUNT
1045: THEN
1046:
1040: -- Request execution of delayed request on if a discount is
1041: -- applied
1042: /* IF p_attr_id = OE_Header_Adj_Util.G_DISCOUNT_LINE
1043: OR
1044: p_attr_id = OE_Header_Adj_Util.G_DISCOUNT
1045: THEN
1046:
1047: -- Assign requests that are to be executed
1048: l_request_rec.entity_code:= OE_GLOBALS.G_ENTITY_HEADER_ADJ;
1194: --uom end
1195:
1196: -- Load display out parameters if any
1197: stmt:=40;
1198: l_Header_Adj_val_rec := OE_Header_Adj_Util.Get_Values
1199: ( p_Header_Adj_rec => l_x_Header_Adj_rec
1200: , p_old_Header_Adj_rec => l_Header_Adj_rec
1201: );
1202: stmt:=45;
2592:
2593: l_x_Header_Adj_rec.lock_control := p_lock_control;
2594: l_x_Header_Adj_rec.price_adjustment_id := p_price_adjustment_id;
2595:
2596: OE_Header_Adj_Util.Lock_Row
2597: ( x_return_status => l_return_status
2598: , p_x_header_adj_rec => l_x_header_adj_rec
2599: );
2600:
2700: THEN
2701:
2702: -- Query row from DB
2703:
2704: OE_Header_Adj_Util.Query_Row
2705: ( p_price_adjustment_id => p_price_adjustment_id
2706: , x_Header_Adj_rec => g_Header_Adj_rec
2707: );
2708: