470:
471: -- Load display out parameters if any
472:
473:
474: l_Line_Adj_val_rec := OE_Line_Adj_Util.Get_Values
475: ( p_Line_Adj_rec => l_x_Line_Adj_rec
476: );
477: x_discount := l_Line_Adj_val_rec.discount;
478:
845: );
846:
847: l_x_old_Line_Adj_rec := l_x_Line_Adj_rec;
848:
849: IF p_attr_id = OE_Line_Adj_Util.G_PRICE_ADJUSTMENT THEN
850: l_x_Line_Adj_rec.price_adjustment_id := TO_NUMBER(p_attr_value1);
851: ELSIF p_attr_id = OE_Line_Adj_Util.G_HEADER THEN
852: l_x_Line_Adj_rec.header_id := TO_NUMBER(p_attr_value1);
853:
847: l_x_old_Line_Adj_rec := l_x_Line_Adj_rec;
848:
849: IF p_attr_id = OE_Line_Adj_Util.G_PRICE_ADJUSTMENT THEN
850: l_x_Line_Adj_rec.price_adjustment_id := TO_NUMBER(p_attr_value1);
851: ELSIF p_attr_id = OE_Line_Adj_Util.G_HEADER THEN
852: l_x_Line_Adj_rec.header_id := TO_NUMBER(p_attr_value1);
853:
854:
855: -- The following has been done because a discount can only
859: --
860: -- It ATTR_ID is discount_id then
861: -- ATTR_VALUE1 is discount_id
862: -- ATTR_VALUE2 is discount_line_id
863: ELSIF p_attr_id = OE_Line_Adj_Util.G_DISCOUNT THEN
864: l_x_Line_Adj_rec.discount_id := TO_NUMBER(p_attr_value1);
865: l_x_Line_Adj_rec.discount_line_id := TO_NUMBER(p_attr_value2);
866:
867: -- It ATTR_ID is discount_line_id then
866:
867: -- It ATTR_ID is discount_line_id then
868: -- ATTR_VALUE1 is discount_line_id
869: -- ATTR_VALUE2 is discount_id
870: ELSIF p_attr_id = OE_Line_Adj_Util.G_DISCOUNT_LINE THEN
871: l_x_Line_Adj_rec.discount_line_id := TO_NUMBER(p_attr_value1);
872: l_x_Line_Adj_rec.discount_id := TO_NUMBER(p_attr_value2);
873:
874: -- New column changes
872: l_x_Line_Adj_rec.discount_id := TO_NUMBER(p_attr_value2);
873:
874: -- New column changes
875: -- New code Added :: Column Changes
876: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_HEADER_ID then
877: l_x_Line_Adj_rec.list_header_id := to_number(p_attr_value1) ;
878: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_LINE_ID then
879: l_x_Line_Adj_rec.list_line_id := to_number(p_attr_value1) ;
880: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_LINE_TYPE_CODE then
874: -- New column changes
875: -- New code Added :: Column Changes
876: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_HEADER_ID then
877: l_x_Line_Adj_rec.list_header_id := to_number(p_attr_value1) ;
878: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_LINE_ID then
879: l_x_Line_Adj_rec.list_line_id := to_number(p_attr_value1) ;
880: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_LINE_TYPE_CODE then
881: l_x_Line_Adj_rec.list_line_type_code := p_attr_value1 ;
882:
876: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_HEADER_ID then
877: l_x_Line_Adj_rec.list_header_id := to_number(p_attr_value1) ;
878: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_LINE_ID then
879: l_x_Line_Adj_rec.list_line_id := to_number(p_attr_value1) ;
880: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_LINE_TYPE_CODE then
881: l_x_Line_Adj_rec.list_line_type_code := p_attr_value1 ;
882:
883: IF l_x_Line_Adj_rec.list_line_type_code = 'PBH'
884: AND nvl(l_x_Line_Adj_rec.list_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
897: oe_debug_pub.add( ' IN OE_OE_FORM_LINE_ADJ:'||SQLERRM ) ;
898: END IF;
899: END;
900: END IF;
901: ELSIF p_attr_id = OE_Line_Adj_Util.G_MODIFIER_MECHANISM_TYPE_CODE then
902: l_x_Line_Adj_rec.modifier_mechanism_type_code := p_attr_value1 ;
903: ELSIF p_attr_id = OE_Line_Adj_Util.G_MODIFIED_FROM then
904: l_x_Line_Adj_rec.modified_from := p_attr_value1;
905: ELSIF p_attr_id = OE_Line_Adj_Util.G_MODIFIED_TO then
899: END;
900: END IF;
901: ELSIF p_attr_id = OE_Line_Adj_Util.G_MODIFIER_MECHANISM_TYPE_CODE then
902: l_x_Line_Adj_rec.modifier_mechanism_type_code := p_attr_value1 ;
903: ELSIF p_attr_id = OE_Line_Adj_Util.G_MODIFIED_FROM then
904: l_x_Line_Adj_rec.modified_from := p_attr_value1;
905: ELSIF p_attr_id = OE_Line_Adj_Util.G_MODIFIED_TO then
906: l_x_Line_Adj_rec.modified_to := p_attr_value1;
907: ELSIF p_attr_id = OE_Line_Adj_Util.G_UPDATE_ALLOWED then
901: ELSIF p_attr_id = OE_Line_Adj_Util.G_MODIFIER_MECHANISM_TYPE_CODE then
902: l_x_Line_Adj_rec.modifier_mechanism_type_code := p_attr_value1 ;
903: ELSIF p_attr_id = OE_Line_Adj_Util.G_MODIFIED_FROM then
904: l_x_Line_Adj_rec.modified_from := p_attr_value1;
905: ELSIF p_attr_id = OE_Line_Adj_Util.G_MODIFIED_TO then
906: l_x_Line_Adj_rec.modified_to := p_attr_value1;
907: ELSIF p_attr_id = OE_Line_Adj_Util.G_UPDATE_ALLOWED then
908: l_x_Line_Adj_rec.update_allowed := p_attr_value1 ;
909: ELSIF p_attr_id = OE_Line_Adj_Util.G_UPDATED_FLAG then
903: ELSIF p_attr_id = OE_Line_Adj_Util.G_MODIFIED_FROM then
904: l_x_Line_Adj_rec.modified_from := p_attr_value1;
905: ELSIF p_attr_id = OE_Line_Adj_Util.G_MODIFIED_TO then
906: l_x_Line_Adj_rec.modified_to := p_attr_value1;
907: ELSIF p_attr_id = OE_Line_Adj_Util.G_UPDATE_ALLOWED then
908: l_x_Line_Adj_rec.update_allowed := p_attr_value1 ;
909: ELSIF p_attr_id = OE_Line_Adj_Util.G_UPDATED_FLAG then
910: l_x_Line_Adj_rec.updated_flag := p_attr_value1 ;
911: ELSIF p_attr_id = OE_Line_Adj_Util.G_APPLIED_FLAG then
905: ELSIF p_attr_id = OE_Line_Adj_Util.G_MODIFIED_TO then
906: l_x_Line_Adj_rec.modified_to := p_attr_value1;
907: ELSIF p_attr_id = OE_Line_Adj_Util.G_UPDATE_ALLOWED then
908: l_x_Line_Adj_rec.update_allowed := p_attr_value1 ;
909: ELSIF p_attr_id = OE_Line_Adj_Util.G_UPDATED_FLAG then
910: l_x_Line_Adj_rec.updated_flag := p_attr_value1 ;
911: ELSIF p_attr_id = OE_Line_Adj_Util.G_APPLIED_FLAG then
912: l_x_Line_Adj_rec.applied_flag := p_attr_value1 ;
913: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_CODE then
907: ELSIF p_attr_id = OE_Line_Adj_Util.G_UPDATE_ALLOWED then
908: l_x_Line_Adj_rec.update_allowed := p_attr_value1 ;
909: ELSIF p_attr_id = OE_Line_Adj_Util.G_UPDATED_FLAG then
910: l_x_Line_Adj_rec.updated_flag := p_attr_value1 ;
911: ELSIF p_attr_id = OE_Line_Adj_Util.G_APPLIED_FLAG then
912: l_x_Line_Adj_rec.applied_flag := p_attr_value1 ;
913: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_CODE then
914: l_x_Line_Adj_rec.change_reason_code := p_attr_value1 ;
915: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_TEXT then
909: ELSIF p_attr_id = OE_Line_Adj_Util.G_UPDATED_FLAG then
910: l_x_Line_Adj_rec.updated_flag := p_attr_value1 ;
911: ELSIF p_attr_id = OE_Line_Adj_Util.G_APPLIED_FLAG then
912: l_x_Line_Adj_rec.applied_flag := p_attr_value1 ;
913: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_CODE then
914: l_x_Line_Adj_rec.change_reason_code := p_attr_value1 ;
915: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_TEXT then
916: l_x_Line_Adj_rec.change_reason_text := p_attr_value1 ;
917: ELSIF p_attr_id = OE_Line_Adj_Util.G_OPERAND then
911: ELSIF p_attr_id = OE_Line_Adj_Util.G_APPLIED_FLAG then
912: l_x_Line_Adj_rec.applied_flag := p_attr_value1 ;
913: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_CODE then
914: l_x_Line_Adj_rec.change_reason_code := p_attr_value1 ;
915: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_TEXT then
916: l_x_Line_Adj_rec.change_reason_text := p_attr_value1 ;
917: ELSIF p_attr_id = OE_Line_Adj_Util.G_OPERAND then
918: l_x_Line_Adj_rec.operand := p_attr_value1 ;
919: ELSIF p_attr_id = OE_Line_Adj_Util.G_pricing_group_sequence THEN --bug 12895497
913: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_CODE then
914: l_x_Line_Adj_rec.change_reason_code := p_attr_value1 ;
915: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_TEXT then
916: l_x_Line_Adj_rec.change_reason_text := p_attr_value1 ;
917: ELSIF p_attr_id = OE_Line_Adj_Util.G_OPERAND then
918: l_x_Line_Adj_rec.operand := p_attr_value1 ;
919: ELSIF p_attr_id = OE_Line_Adj_Util.G_pricing_group_sequence THEN --bug 12895497
920: l_x_Line_Adj_rec.pricing_group_sequence := p_attr_value1; --bug 12895497
921: ELSIF p_attr_id = OE_Line_Adj_Util.G_ARITHMETIC_OPERATOR then
915: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_TEXT then
916: l_x_Line_Adj_rec.change_reason_text := p_attr_value1 ;
917: ELSIF p_attr_id = OE_Line_Adj_Util.G_OPERAND then
918: l_x_Line_Adj_rec.operand := p_attr_value1 ;
919: ELSIF p_attr_id = OE_Line_Adj_Util.G_pricing_group_sequence THEN --bug 12895497
920: l_x_Line_Adj_rec.pricing_group_sequence := p_attr_value1; --bug 12895497
921: ELSIF p_attr_id = OE_Line_Adj_Util.G_ARITHMETIC_OPERATOR then
922: l_x_Line_Adj_rec.arithmetic_operator := p_attr_value1 ;
923:
917: ELSIF p_attr_id = OE_Line_Adj_Util.G_OPERAND then
918: l_x_Line_Adj_rec.operand := p_attr_value1 ;
919: ELSIF p_attr_id = OE_Line_Adj_Util.G_pricing_group_sequence THEN --bug 12895497
920: l_x_Line_Adj_rec.pricing_group_sequence := p_attr_value1; --bug 12895497
921: ELSIF p_attr_id = OE_Line_Adj_Util.G_ARITHMETIC_OPERATOR then
922: l_x_Line_Adj_rec.arithmetic_operator := p_attr_value1 ;
923:
924: ELSIF p_attr_id = OE_Line_Adj_Util.G_ADJUSTED_AMOUNT then
925: l_x_Line_Adj_rec.adjusted_amount := p_attr_value1 ;
920: l_x_Line_Adj_rec.pricing_group_sequence := p_attr_value1; --bug 12895497
921: ELSIF p_attr_id = OE_Line_Adj_Util.G_ARITHMETIC_OPERATOR then
922: l_x_Line_Adj_rec.arithmetic_operator := p_attr_value1 ;
923:
924: ELSIF p_attr_id = OE_Line_Adj_Util.G_ADJUSTED_AMOUNT then
925: l_x_Line_Adj_rec.adjusted_amount := p_attr_value1 ;
926: ELSIF p_attr_id = OE_Line_Adj_Util.G_PRICING_PHASE_ID then
927: l_x_Line_Adj_rec.pricing_phase_id := p_attr_value1 ;
928: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_LINE_NO then
922: l_x_Line_Adj_rec.arithmetic_operator := p_attr_value1 ;
923:
924: ELSIF p_attr_id = OE_Line_Adj_Util.G_ADJUSTED_AMOUNT then
925: l_x_Line_Adj_rec.adjusted_amount := p_attr_value1 ;
926: ELSIF p_attr_id = OE_Line_Adj_Util.G_PRICING_PHASE_ID then
927: l_x_Line_Adj_rec.pricing_phase_id := p_attr_value1 ;
928: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_LINE_NO then
929: l_x_Line_Adj_rec.list_line_no := p_attr_value1 ;
930: ELSIF p_attr_id = OE_Line_Adj_Util.G_SOURCE_SYSTEM_CODE then
924: ELSIF p_attr_id = OE_Line_Adj_Util.G_ADJUSTED_AMOUNT then
925: l_x_Line_Adj_rec.adjusted_amount := p_attr_value1 ;
926: ELSIF p_attr_id = OE_Line_Adj_Util.G_PRICING_PHASE_ID then
927: l_x_Line_Adj_rec.pricing_phase_id := p_attr_value1 ;
928: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_LINE_NO then
929: l_x_Line_Adj_rec.list_line_no := p_attr_value1 ;
930: ELSIF p_attr_id = OE_Line_Adj_Util.G_SOURCE_SYSTEM_CODE then
931: l_x_Line_Adj_rec.source_system_code := p_attr_value1;
932: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_QTY then
926: ELSIF p_attr_id = OE_Line_Adj_Util.G_PRICING_PHASE_ID then
927: l_x_Line_Adj_rec.pricing_phase_id := p_attr_value1 ;
928: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_LINE_NO then
929: l_x_Line_Adj_rec.list_line_no := p_attr_value1 ;
930: ELSIF p_attr_id = OE_Line_Adj_Util.G_SOURCE_SYSTEM_CODE then
931: l_x_Line_Adj_rec.source_system_code := p_attr_value1;
932: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_QTY then
933: l_x_Line_Adj_rec.benefit_qty := TO_NUMBER(p_attr_value1);
934: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_UOM_CODE then
928: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_LINE_NO then
929: l_x_Line_Adj_rec.list_line_no := p_attr_value1 ;
930: ELSIF p_attr_id = OE_Line_Adj_Util.G_SOURCE_SYSTEM_CODE then
931: l_x_Line_Adj_rec.source_system_code := p_attr_value1;
932: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_QTY then
933: l_x_Line_Adj_rec.benefit_qty := TO_NUMBER(p_attr_value1);
934: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_UOM_CODE then
935: l_x_Line_Adj_rec.benefit_uom_code := p_attr_value1;
936: ELSIF p_attr_id = OE_Line_Adj_Util.G_PRINT_ON_INVOICE_FLAG then
930: ELSIF p_attr_id = OE_Line_Adj_Util.G_SOURCE_SYSTEM_CODE then
931: l_x_Line_Adj_rec.source_system_code := p_attr_value1;
932: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_QTY then
933: l_x_Line_Adj_rec.benefit_qty := TO_NUMBER(p_attr_value1);
934: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_UOM_CODE then
935: l_x_Line_Adj_rec.benefit_uom_code := p_attr_value1;
936: ELSIF p_attr_id = OE_Line_Adj_Util.G_PRINT_ON_INVOICE_FLAG then
937: l_x_Line_Adj_rec.print_on_invoice_flag := p_attr_value1;
938: ELSIF p_attr_id = OE_Line_Adj_Util.G_EXPIRATION_DATE then
932: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_QTY then
933: l_x_Line_Adj_rec.benefit_qty := TO_NUMBER(p_attr_value1);
934: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_UOM_CODE then
935: l_x_Line_Adj_rec.benefit_uom_code := p_attr_value1;
936: ELSIF p_attr_id = OE_Line_Adj_Util.G_PRINT_ON_INVOICE_FLAG then
937: l_x_Line_Adj_rec.print_on_invoice_flag := p_attr_value1;
938: ELSIF p_attr_id = OE_Line_Adj_Util.G_EXPIRATION_DATE then
939: -- l_x_Line_Adj_rec.expiration_date := TO_DATE(p_attr_value1, l_date_format);
940: l_x_Line_Adj_rec.expiration_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396
934: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_UOM_CODE then
935: l_x_Line_Adj_rec.benefit_uom_code := p_attr_value1;
936: ELSIF p_attr_id = OE_Line_Adj_Util.G_PRINT_ON_INVOICE_FLAG then
937: l_x_Line_Adj_rec.print_on_invoice_flag := p_attr_value1;
938: ELSIF p_attr_id = OE_Line_Adj_Util.G_EXPIRATION_DATE then
939: -- l_x_Line_Adj_rec.expiration_date := TO_DATE(p_attr_value1, l_date_format);
940: l_x_Line_Adj_rec.expiration_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396
941: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_TRANSACTION_TYPE_CODE then
942: l_x_Line_Adj_rec.rebate_transaction_type_code := p_attr_value1;
937: l_x_Line_Adj_rec.print_on_invoice_flag := p_attr_value1;
938: ELSIF p_attr_id = OE_Line_Adj_Util.G_EXPIRATION_DATE then
939: -- l_x_Line_Adj_rec.expiration_date := TO_DATE(p_attr_value1, l_date_format);
940: l_x_Line_Adj_rec.expiration_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396
941: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_TRANSACTION_TYPE_CODE then
942: l_x_Line_Adj_rec.rebate_transaction_type_code := p_attr_value1;
943: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_TRANSACTION_REFERENCE then
944: l_x_Line_Adj_rec.rebate_transaction_reference := p_attr_value1;
945: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_PAYMENT_SYSTEM_CODE then
939: -- l_x_Line_Adj_rec.expiration_date := TO_DATE(p_attr_value1, l_date_format);
940: l_x_Line_Adj_rec.expiration_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396
941: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_TRANSACTION_TYPE_CODE then
942: l_x_Line_Adj_rec.rebate_transaction_type_code := p_attr_value1;
943: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_TRANSACTION_REFERENCE then
944: l_x_Line_Adj_rec.rebate_transaction_reference := p_attr_value1;
945: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_PAYMENT_SYSTEM_CODE then
946: l_x_Line_Adj_rec.rebate_payment_system_code := p_attr_value1;
947: ELSIF p_attr_id = OE_Line_Adj_Util.G_REDEEMED_DATE then
941: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_TRANSACTION_TYPE_CODE then
942: l_x_Line_Adj_rec.rebate_transaction_type_code := p_attr_value1;
943: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_TRANSACTION_REFERENCE then
944: l_x_Line_Adj_rec.rebate_transaction_reference := p_attr_value1;
945: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_PAYMENT_SYSTEM_CODE then
946: l_x_Line_Adj_rec.rebate_payment_system_code := p_attr_value1;
947: ELSIF p_attr_id = OE_Line_Adj_Util.G_REDEEMED_DATE then
948: -- l_x_Line_Adj_rec.redeemed_date := TO_DATE(p_attr_value1, l_date_format);
949: l_x_Line_Adj_rec.redeemed_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396
943: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_TRANSACTION_REFERENCE then
944: l_x_Line_Adj_rec.rebate_transaction_reference := p_attr_value1;
945: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_PAYMENT_SYSTEM_CODE then
946: l_x_Line_Adj_rec.rebate_payment_system_code := p_attr_value1;
947: ELSIF p_attr_id = OE_Line_Adj_Util.G_REDEEMED_DATE then
948: -- l_x_Line_Adj_rec.redeemed_date := TO_DATE(p_attr_value1, l_date_format);
949: l_x_Line_Adj_rec.redeemed_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396
950: ELSIF p_attr_id = OE_Line_Adj_Util.G_REDEEMED_FLAG then
951: l_x_Line_Adj_rec.redeemed_flag := p_attr_value1;
946: l_x_Line_Adj_rec.rebate_payment_system_code := p_attr_value1;
947: ELSIF p_attr_id = OE_Line_Adj_Util.G_REDEEMED_DATE then
948: -- l_x_Line_Adj_rec.redeemed_date := TO_DATE(p_attr_value1, l_date_format);
949: l_x_Line_Adj_rec.redeemed_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396
950: ELSIF p_attr_id = OE_Line_Adj_Util.G_REDEEMED_FLAG then
951: l_x_Line_Adj_rec.redeemed_flag := p_attr_value1;
952: ELSIF p_attr_id = OE_Line_Adj_Util.G_ACCRUAL_FLAG then
953: l_x_Line_Adj_rec.accrual_flag := p_attr_value1;
954: ELSIF p_attr_id = OE_Line_Adj_Util.G_AUTOMATIC THEN
948: -- l_x_Line_Adj_rec.redeemed_date := TO_DATE(p_attr_value1, l_date_format);
949: l_x_Line_Adj_rec.redeemed_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396
950: ELSIF p_attr_id = OE_Line_Adj_Util.G_REDEEMED_FLAG then
951: l_x_Line_Adj_rec.redeemed_flag := p_attr_value1;
952: ELSIF p_attr_id = OE_Line_Adj_Util.G_ACCRUAL_FLAG then
953: l_x_Line_Adj_rec.accrual_flag := p_attr_value1;
954: ELSIF p_attr_id = OE_Line_Adj_Util.G_AUTOMATIC THEN
955: l_x_Line_Adj_rec.automatic_flag := p_attr_value1;
956: ELSIF p_attr_id = OE_Line_Adj_Util.G_PERCENT THEN
950: ELSIF p_attr_id = OE_Line_Adj_Util.G_REDEEMED_FLAG then
951: l_x_Line_Adj_rec.redeemed_flag := p_attr_value1;
952: ELSIF p_attr_id = OE_Line_Adj_Util.G_ACCRUAL_FLAG then
953: l_x_Line_Adj_rec.accrual_flag := p_attr_value1;
954: ELSIF p_attr_id = OE_Line_Adj_Util.G_AUTOMATIC THEN
955: l_x_Line_Adj_rec.automatic_flag := p_attr_value1;
956: ELSIF p_attr_id = OE_Line_Adj_Util.G_PERCENT THEN
957: l_x_Line_Adj_rec.percent := TO_NUMBER(p_attr_value1);
958: --Manual Begin
952: ELSIF p_attr_id = OE_Line_Adj_Util.G_ACCRUAL_FLAG then
953: l_x_Line_Adj_rec.accrual_flag := p_attr_value1;
954: ELSIF p_attr_id = OE_Line_Adj_Util.G_AUTOMATIC THEN
955: l_x_Line_Adj_rec.automatic_flag := p_attr_value1;
956: ELSIF p_attr_id = OE_Line_Adj_Util.G_PERCENT THEN
957: l_x_Line_Adj_rec.percent := TO_NUMBER(p_attr_value1);
958: --Manual Begin
959: ELSIF p_attr_id = OE_Line_Adj_Util.G_LINE THEN
960: If p_attr_value1 Is Not Null Then
955: l_x_Line_Adj_rec.automatic_flag := p_attr_value1;
956: ELSIF p_attr_id = OE_Line_Adj_Util.G_PERCENT THEN
957: l_x_Line_Adj_rec.percent := TO_NUMBER(p_attr_value1);
958: --Manual Begin
959: ELSIF p_attr_id = OE_Line_Adj_Util.G_LINE THEN
960: If p_attr_value1 Is Not Null Then
961: l_x_Line_Adj_rec.line_id := TO_NUMBER(p_attr_value1);
962: Else
963: l_x_Line_Adj_rec.line_id := NULL;
962: Else
963: l_x_Line_Adj_rec.line_id := NULL;
964: End If;
965: --Manual End
966: ELSIF p_attr_id = OE_Line_Adj_Util.G_ESTIMATED_FLAG THEN
967: l_x_Line_Adj_rec.estimated_flag := p_attr_value1;
968: ELSIF p_attr_id = OE_Line_Adj_Util.G_INVOICED_FLAG THEN
969: l_x_Line_Adj_rec.INVOICED_FLAG := p_attr_value1;
970: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHARGE_TYPE_CODE THEN
964: End If;
965: --Manual End
966: ELSIF p_attr_id = OE_Line_Adj_Util.G_ESTIMATED_FLAG THEN
967: l_x_Line_Adj_rec.estimated_flag := p_attr_value1;
968: ELSIF p_attr_id = OE_Line_Adj_Util.G_INVOICED_FLAG THEN
969: l_x_Line_Adj_rec.INVOICED_FLAG := p_attr_value1;
970: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHARGE_TYPE_CODE THEN
971: l_x_Line_Adj_rec.CHARGE_TYPE_CODE := p_attr_value1;
972: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHARGE_SUBTYPE_CODE THEN
966: ELSIF p_attr_id = OE_Line_Adj_Util.G_ESTIMATED_FLAG THEN
967: l_x_Line_Adj_rec.estimated_flag := p_attr_value1;
968: ELSIF p_attr_id = OE_Line_Adj_Util.G_INVOICED_FLAG THEN
969: l_x_Line_Adj_rec.INVOICED_FLAG := p_attr_value1;
970: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHARGE_TYPE_CODE THEN
971: l_x_Line_Adj_rec.CHARGE_TYPE_CODE := p_attr_value1;
972: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHARGE_SUBTYPE_CODE THEN
973: l_x_Line_Adj_rec.CHARGE_SUBTYPE_CODE := p_attr_value1;
974: ELSIF p_attr_id = OE_Line_Adj_Util.G_CREDIT_OR_CHARGE_FLAG THEN
968: ELSIF p_attr_id = OE_Line_Adj_Util.G_INVOICED_FLAG THEN
969: l_x_Line_Adj_rec.INVOICED_FLAG := p_attr_value1;
970: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHARGE_TYPE_CODE THEN
971: l_x_Line_Adj_rec.CHARGE_TYPE_CODE := p_attr_value1;
972: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHARGE_SUBTYPE_CODE THEN
973: l_x_Line_Adj_rec.CHARGE_SUBTYPE_CODE := p_attr_value1;
974: ELSIF p_attr_id = OE_Line_Adj_Util.G_CREDIT_OR_CHARGE_FLAG THEN
975: l_x_Line_Adj_rec.CREDIT_OR_CHARGE_FLAG := p_attr_value1;
976: ELSIF p_attr_id = OE_Line_Adj_Util.G_INCLUDE_ON_RETURNS_FLAG THEN
970: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHARGE_TYPE_CODE THEN
971: l_x_Line_Adj_rec.CHARGE_TYPE_CODE := p_attr_value1;
972: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHARGE_SUBTYPE_CODE THEN
973: l_x_Line_Adj_rec.CHARGE_SUBTYPE_CODE := p_attr_value1;
974: ELSIF p_attr_id = OE_Line_Adj_Util.G_CREDIT_OR_CHARGE_FLAG THEN
975: l_x_Line_Adj_rec.CREDIT_OR_CHARGE_FLAG := p_attr_value1;
976: ELSIF p_attr_id = OE_Line_Adj_Util.G_INCLUDE_ON_RETURNS_FLAG THEN
977: l_x_Line_Adj_rec.INCLUDE_ON_RETURNS_FLAG := p_attr_value1;
978: --Manual Begin
972: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHARGE_SUBTYPE_CODE THEN
973: l_x_Line_Adj_rec.CHARGE_SUBTYPE_CODE := p_attr_value1;
974: ELSIF p_attr_id = OE_Line_Adj_Util.G_CREDIT_OR_CHARGE_FLAG THEN
975: l_x_Line_Adj_rec.CREDIT_OR_CHARGE_FLAG := p_attr_value1;
976: ELSIF p_attr_id = OE_Line_Adj_Util.G_INCLUDE_ON_RETURNS_FLAG THEN
977: l_x_Line_Adj_rec.INCLUDE_ON_RETURNS_FLAG := p_attr_value1;
978: --Manual Begin
979: ELSIF p_attr_id = OE_LINE_Adj_Util.G_modifier_level_code Then
980: l_x_Line_Adj_rec.modifier_level_code := p_attr_value1;
975: l_x_Line_Adj_rec.CREDIT_OR_CHARGE_FLAG := p_attr_value1;
976: ELSIF p_attr_id = OE_Line_Adj_Util.G_INCLUDE_ON_RETURNS_FLAG THEN
977: l_x_Line_Adj_rec.INCLUDE_ON_RETURNS_FLAG := p_attr_value1;
978: --Manual Begin
979: ELSIF p_attr_id = OE_LINE_Adj_Util.G_modifier_level_code Then
980: l_x_Line_Adj_rec.modifier_level_code := p_attr_value1;
981: ELSIF p_attr_id = OE_LINE_Adj_Util.G_OVERRIDE_ALLOWED_FLAG Then
982: l_x_Line_Adj_rec.update_allowed:= p_attr_value1;
983: --Manual end
977: l_x_Line_Adj_rec.INCLUDE_ON_RETURNS_FLAG := p_attr_value1;
978: --Manual Begin
979: ELSIF p_attr_id = OE_LINE_Adj_Util.G_modifier_level_code Then
980: l_x_Line_Adj_rec.modifier_level_code := p_attr_value1;
981: ELSIF p_attr_id = OE_LINE_Adj_Util.G_OVERRIDE_ALLOWED_FLAG Then
982: l_x_Line_Adj_rec.update_allowed:= p_attr_value1;
983: --Manual end
984: --uom begin
985: ELSIF p_attr_id = OE_Line_Adj_Util.G_OPERAND_PER_PQTY THEN
981: ELSIF p_attr_id = OE_LINE_Adj_Util.G_OVERRIDE_ALLOWED_FLAG Then
982: l_x_Line_Adj_rec.update_allowed:= p_attr_value1;
983: --Manual end
984: --uom begin
985: ELSIF p_attr_id = OE_Line_Adj_Util.G_OPERAND_PER_PQTY THEN
986: l_x_Line_Adj_rec.OPERAND_PER_PQTY := p_attr_value1;
987: ELSIF p_attr_id = OE_Line_Adj_Util.G_ADJUSTED_AMOUNT_PER_PQTY THEN
988: l_x_Line_Adj_rec.ADJUSTED_AMOUNT_PER_PQTY := p_attr_value1;
989: --uom end
983: --Manual end
984: --uom begin
985: ELSIF p_attr_id = OE_Line_Adj_Util.G_OPERAND_PER_PQTY THEN
986: l_x_Line_Adj_rec.OPERAND_PER_PQTY := p_attr_value1;
987: ELSIF p_attr_id = OE_Line_Adj_Util.G_ADJUSTED_AMOUNT_PER_PQTY THEN
988: l_x_Line_Adj_rec.ADJUSTED_AMOUNT_PER_PQTY := p_attr_value1;
989: --uom end
990: ELSIF p_attr_id = OE_LINE_Adj_Util.G_RANGE_BREAK_QUANTITY THEN
991: l_x_Line_Adj_rec.range_break_quantity := p_attr_value1;
986: l_x_Line_Adj_rec.OPERAND_PER_PQTY := p_attr_value1;
987: ELSIF p_attr_id = OE_Line_Adj_Util.G_ADJUSTED_AMOUNT_PER_PQTY THEN
988: l_x_Line_Adj_rec.ADJUSTED_AMOUNT_PER_PQTY := p_attr_value1;
989: --uom end
990: ELSIF p_attr_id = OE_LINE_Adj_Util.G_RANGE_BREAK_QUANTITY THEN
991: l_x_Line_Adj_rec.range_break_quantity := p_attr_value1;
992: ELSIF p_attr_id = OE_Line_Adj_Util.G_CONTEXT
993: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE1
994: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE2
988: l_x_Line_Adj_rec.ADJUSTED_AMOUNT_PER_PQTY := p_attr_value1;
989: --uom end
990: ELSIF p_attr_id = OE_LINE_Adj_Util.G_RANGE_BREAK_QUANTITY THEN
991: l_x_Line_Adj_rec.range_break_quantity := p_attr_value1;
992: ELSIF p_attr_id = OE_Line_Adj_Util.G_CONTEXT
993: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE1
994: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE2
995: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE3
996: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE4
989: --uom end
990: ELSIF p_attr_id = OE_LINE_Adj_Util.G_RANGE_BREAK_QUANTITY THEN
991: l_x_Line_Adj_rec.range_break_quantity := p_attr_value1;
992: ELSIF p_attr_id = OE_Line_Adj_Util.G_CONTEXT
993: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE1
994: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE2
995: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE3
996: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE4
997: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE5
990: ELSIF p_attr_id = OE_LINE_Adj_Util.G_RANGE_BREAK_QUANTITY THEN
991: l_x_Line_Adj_rec.range_break_quantity := p_attr_value1;
992: ELSIF p_attr_id = OE_Line_Adj_Util.G_CONTEXT
993: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE1
994: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE2
995: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE3
996: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE4
997: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE5
998: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE6
991: l_x_Line_Adj_rec.range_break_quantity := p_attr_value1;
992: ELSIF p_attr_id = OE_Line_Adj_Util.G_CONTEXT
993: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE1
994: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE2
995: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE3
996: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE4
997: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE5
998: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE6
999: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE7
992: ELSIF p_attr_id = OE_Line_Adj_Util.G_CONTEXT
993: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE1
994: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE2
995: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE3
996: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE4
997: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE5
998: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE6
999: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE7
1000: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE8
993: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE1
994: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE2
995: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE3
996: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE4
997: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE5
998: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE6
999: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE7
1000: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE8
1001: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE9
994: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE2
995: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE3
996: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE4
997: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE5
998: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE6
999: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE7
1000: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE8
1001: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE9
1002: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE10
995: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE3
996: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE4
997: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE5
998: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE6
999: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE7
1000: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE8
1001: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE9
1002: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE10
1003: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE11
996: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE4
997: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE5
998: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE6
999: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE7
1000: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE8
1001: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE9
1002: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE10
1003: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE11
1004: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE12
997: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE5
998: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE6
999: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE7
1000: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE8
1001: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE9
1002: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE10
1003: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE11
1004: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE12
1005: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE13
998: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE6
999: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE7
1000: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE8
1001: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE9
1002: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE10
1003: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE11
1004: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE12
1005: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE13
1006: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE14
999: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE7
1000: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE8
1001: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE9
1002: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE10
1003: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE11
1004: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE12
1005: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE13
1006: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE14
1007: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE15
1000: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE8
1001: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE9
1002: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE10
1003: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE11
1004: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE12
1005: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE13
1006: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE14
1007: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE15
1008: THEN
1001: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE9
1002: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE10
1003: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE11
1004: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE12
1005: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE13
1006: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE14
1007: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE15
1008: THEN
1009:
1002: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE10
1003: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE11
1004: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE12
1005: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE13
1006: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE14
1007: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE15
1008: THEN
1009:
1010: l_x_Line_Adj_rec.context := p_context;
1003: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE11
1004: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE12
1005: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE13
1006: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE14
1007: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE15
1008: THEN
1009:
1010: l_x_Line_Adj_rec.context := p_context;
1011: l_x_Line_Adj_rec.attribute1 := p_attribute1;
1022: l_x_Line_Adj_rec.attribute12 := p_attribute12;
1023: l_x_Line_Adj_rec.attribute13 := p_attribute13;
1024: l_x_Line_Adj_rec.attribute14 := p_attribute14;
1025: l_x_Line_Adj_rec.attribute15 := p_attribute15;
1026: ELSIF p_attr_id = OE_Line_Adj_Util.G_AC_CONTEXT
1027: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE1
1028: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE2
1029: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE3
1030: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE4
1023: l_x_Line_Adj_rec.attribute13 := p_attribute13;
1024: l_x_Line_Adj_rec.attribute14 := p_attribute14;
1025: l_x_Line_Adj_rec.attribute15 := p_attribute15;
1026: ELSIF p_attr_id = OE_Line_Adj_Util.G_AC_CONTEXT
1027: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE1
1028: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE2
1029: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE3
1030: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE4
1031: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE5
1024: l_x_Line_Adj_rec.attribute14 := p_attribute14;
1025: l_x_Line_Adj_rec.attribute15 := p_attribute15;
1026: ELSIF p_attr_id = OE_Line_Adj_Util.G_AC_CONTEXT
1027: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE1
1028: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE2
1029: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE3
1030: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE4
1031: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE5
1032: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE6
1025: l_x_Line_Adj_rec.attribute15 := p_attribute15;
1026: ELSIF p_attr_id = OE_Line_Adj_Util.G_AC_CONTEXT
1027: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE1
1028: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE2
1029: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE3
1030: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE4
1031: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE5
1032: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE6
1033: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE7
1026: ELSIF p_attr_id = OE_Line_Adj_Util.G_AC_CONTEXT
1027: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE1
1028: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE2
1029: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE3
1030: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE4
1031: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE5
1032: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE6
1033: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE7
1034: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE8
1027: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE1
1028: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE2
1029: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE3
1030: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE4
1031: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE5
1032: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE6
1033: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE7
1034: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE8
1035: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE9
1028: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE2
1029: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE3
1030: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE4
1031: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE5
1032: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE6
1033: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE7
1034: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE8
1035: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE9
1036: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE10
1029: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE3
1030: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE4
1031: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE5
1032: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE6
1033: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE7
1034: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE8
1035: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE9
1036: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE10
1037: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE11
1030: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE4
1031: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE5
1032: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE6
1033: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE7
1034: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE8
1035: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE9
1036: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE10
1037: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE11
1038: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE12
1031: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE5
1032: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE6
1033: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE7
1034: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE8
1035: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE9
1036: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE10
1037: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE11
1038: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE12
1039: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE13
1032: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE6
1033: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE7
1034: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE8
1035: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE9
1036: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE10
1037: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE11
1038: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE12
1039: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE13
1040: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE14
1033: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE7
1034: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE8
1035: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE9
1036: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE10
1037: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE11
1038: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE12
1039: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE13
1040: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE14
1041: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE15
1034: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE8
1035: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE9
1036: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE10
1037: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE11
1038: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE12
1039: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE13
1040: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE14
1041: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE15
1042: THEN
1035: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE9
1036: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE10
1037: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE11
1038: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE12
1039: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE13
1040: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE14
1041: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE15
1042: THEN
1043:
1036: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE10
1037: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE11
1038: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE12
1039: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE13
1040: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE14
1041: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE15
1042: THEN
1043:
1044: l_x_Line_Adj_rec.ac_context := p_ac_context;
1037: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE11
1038: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE12
1039: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE13
1040: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE14
1041: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE15
1042: THEN
1043:
1044: l_x_Line_Adj_rec.ac_context := p_ac_context;
1045: l_x_Line_Adj_rec.ac_attribute1 := p_ac_attribute1;
1125: IF l_debug_level > 0 THEN
1126: oe_debug_pub.add( ' P_ATTR_ID:'|| P_ATTR_ID ) ;
1127: END IF;
1128: IF l_debug_level > 0 THEN
1129: oe_debug_pub.add( ' G_OPERAND_PER_PQTY:'||OE_LINE_ADJ_UTIL.G_OPERAND_PER_PQTY ) ;
1130: END IF;
1131:
1132:
1133: If (l_x_line_adj_rec.arithmetic_operator = '%' and
1130: END IF;
1131:
1132:
1133: If (l_x_line_adj_rec.arithmetic_operator = '%' and
1134: p_attr_id = OE_Line_Adj_Util.G_OPERAND_PER_PQTY)
1135: or p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_CODE
1136: Then
1137: IF l_debug_level > 0 THEN
1138: oe_debug_pub.add( ' CS BEFORE GETTING LINE' ) ;
1131:
1132:
1133: If (l_x_line_adj_rec.arithmetic_operator = '%' and
1134: p_attr_id = OE_Line_Adj_Util.G_OPERAND_PER_PQTY)
1135: or p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_CODE
1136: Then
1137: IF l_debug_level > 0 THEN
1138: oe_debug_pub.add( ' CS BEFORE GETTING LINE' ) ;
1139: END IF;
1210:
1211: End If;
1212:
1213: --we will need to cascade change reason code too, if it got changed
1214: If p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_CODE Then
1215:
1216: --If no line queried, requery again else just use this to
1217: If nvl(l_line_rec.line_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM Then
1218: Oe_Oe_Form_Line.Get_Line(p_line_id=>l_x_line_adj_rec.line_id,
1419: --uom end
1420:
1421: -- Load display out parameters if any
1422:
1423: l_Line_Adj_val_rec := OE_Line_Adj_Util.Get_Values
1424: ( p_Line_Adj_rec =>l_x_Line_Adj_rec
1425: , p_old_Line_Adj_rec => l_Line_Adj_rec
1426: );
1427:
3133: l_x_Line_Adj_rec.operation := OE_GLOBALS.G_OPR_LOCK;
3134: l_x_Line_Adj_rec.lock_control := p_lock_control;
3135: l_x_Line_Adj_rec.price_adjustment_id := p_price_adjustment_id;
3136:
3137: OE_Line_Adj_Util.Lock_Row
3138: ( x_return_status => l_return_status
3139: , p_x_line_adj_rec => l_x_line_adj_rec
3140: );
3141:
3243: THEN
3244:
3245: -- Query row from DB
3246:
3247: OE_Line_Adj_Util.Query_Row
3248: ( p_price_adjustment_id => p_price_adjustment_id
3249: , x_Line_Adj_rec => g_Line_Adj_rec
3250: );
3251: