eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_OE_FORM_LINE_ADJ dependencies on OE_LINE_ADJ_UTIL

Line 474: l_Line_Adj_val_rec := OE_Line_Adj_Util.Get_Values

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:

Line 849: IF p_attr_id = OE_Line_Adj_Util.G_PRICE_ADJUSTMENT THEN

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:

Line 851: ELSIF p_attr_id = OE_Line_Adj_Util.G_HEADER THEN

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

Line 863: ELSIF p_attr_id = OE_Line_Adj_Util.G_DISCOUNT THEN

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

Line 870: ELSIF p_attr_id = OE_Line_Adj_Util.G_DISCOUNT_LINE 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

Line 876: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_HEADER_ID then

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

Line 878: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_LINE_ID 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:

Line 880: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_LINE_TYPE_CODE then

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

Line 901: ELSIF p_attr_id = OE_Line_Adj_Util.G_MODIFIER_MECHANISM_TYPE_CODE 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

Line 903: ELSIF p_attr_id = OE_Line_Adj_Util.G_MODIFIED_FROM 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

Line 905: ELSIF p_attr_id = OE_Line_Adj_Util.G_MODIFIED_TO 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

Line 907: ELSIF p_attr_id = OE_Line_Adj_Util.G_UPDATE_ALLOWED 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

Line 909: ELSIF p_attr_id = OE_Line_Adj_Util.G_UPDATED_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

Line 911: ELSIF p_attr_id = OE_Line_Adj_Util.G_APPLIED_FLAG 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

Line 913: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_CODE 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

Line 915: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_TEXT 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_ARITHMETIC_OPERATOR then

Line 917: ELSIF p_attr_id = OE_Line_Adj_Util.G_OPERAND then

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_ARITHMETIC_OPERATOR then
920: l_x_Line_Adj_rec.arithmetic_operator := p_attr_value1 ;
921:

Line 919: 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_ARITHMETIC_OPERATOR then
920: l_x_Line_Adj_rec.arithmetic_operator := p_attr_value1 ;
921:
922: ELSIF p_attr_id = OE_Line_Adj_Util.G_ADJUSTED_AMOUNT then
923: l_x_Line_Adj_rec.adjusted_amount := p_attr_value1 ;

Line 922: ELSIF p_attr_id = OE_Line_Adj_Util.G_ADJUSTED_AMOUNT then

918: l_x_Line_Adj_rec.operand := p_attr_value1 ;
919: ELSIF p_attr_id = OE_Line_Adj_Util.G_ARITHMETIC_OPERATOR then
920: l_x_Line_Adj_rec.arithmetic_operator := p_attr_value1 ;
921:
922: ELSIF p_attr_id = OE_Line_Adj_Util.G_ADJUSTED_AMOUNT then
923: l_x_Line_Adj_rec.adjusted_amount := p_attr_value1 ;
924: ELSIF p_attr_id = OE_Line_Adj_Util.G_PRICING_PHASE_ID then
925: l_x_Line_Adj_rec.pricing_phase_id := p_attr_value1 ;
926: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_LINE_NO then

Line 924: ELSIF p_attr_id = OE_Line_Adj_Util.G_PRICING_PHASE_ID then

920: l_x_Line_Adj_rec.arithmetic_operator := p_attr_value1 ;
921:
922: ELSIF p_attr_id = OE_Line_Adj_Util.G_ADJUSTED_AMOUNT then
923: l_x_Line_Adj_rec.adjusted_amount := p_attr_value1 ;
924: ELSIF p_attr_id = OE_Line_Adj_Util.G_PRICING_PHASE_ID then
925: l_x_Line_Adj_rec.pricing_phase_id := p_attr_value1 ;
926: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_LINE_NO then
927: l_x_Line_Adj_rec.list_line_no := p_attr_value1 ;
928: ELSIF p_attr_id = OE_Line_Adj_Util.G_SOURCE_SYSTEM_CODE then

Line 926: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_LINE_NO then

922: ELSIF p_attr_id = OE_Line_Adj_Util.G_ADJUSTED_AMOUNT then
923: l_x_Line_Adj_rec.adjusted_amount := p_attr_value1 ;
924: ELSIF p_attr_id = OE_Line_Adj_Util.G_PRICING_PHASE_ID then
925: l_x_Line_Adj_rec.pricing_phase_id := p_attr_value1 ;
926: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_LINE_NO then
927: l_x_Line_Adj_rec.list_line_no := p_attr_value1 ;
928: ELSIF p_attr_id = OE_Line_Adj_Util.G_SOURCE_SYSTEM_CODE then
929: l_x_Line_Adj_rec.source_system_code := p_attr_value1;
930: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_QTY then

Line 928: ELSIF p_attr_id = OE_Line_Adj_Util.G_SOURCE_SYSTEM_CODE then

924: ELSIF p_attr_id = OE_Line_Adj_Util.G_PRICING_PHASE_ID then
925: l_x_Line_Adj_rec.pricing_phase_id := p_attr_value1 ;
926: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_LINE_NO then
927: l_x_Line_Adj_rec.list_line_no := p_attr_value1 ;
928: ELSIF p_attr_id = OE_Line_Adj_Util.G_SOURCE_SYSTEM_CODE then
929: l_x_Line_Adj_rec.source_system_code := p_attr_value1;
930: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_QTY then
931: l_x_Line_Adj_rec.benefit_qty := TO_NUMBER(p_attr_value1);
932: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_UOM_CODE then

Line 930: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_QTY then

926: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_LINE_NO then
927: l_x_Line_Adj_rec.list_line_no := p_attr_value1 ;
928: ELSIF p_attr_id = OE_Line_Adj_Util.G_SOURCE_SYSTEM_CODE then
929: l_x_Line_Adj_rec.source_system_code := p_attr_value1;
930: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_QTY then
931: l_x_Line_Adj_rec.benefit_qty := TO_NUMBER(p_attr_value1);
932: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_UOM_CODE then
933: l_x_Line_Adj_rec.benefit_uom_code := p_attr_value1;
934: ELSIF p_attr_id = OE_Line_Adj_Util.G_PRINT_ON_INVOICE_FLAG then

Line 932: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_UOM_CODE then

928: ELSIF p_attr_id = OE_Line_Adj_Util.G_SOURCE_SYSTEM_CODE then
929: l_x_Line_Adj_rec.source_system_code := p_attr_value1;
930: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_QTY then
931: l_x_Line_Adj_rec.benefit_qty := TO_NUMBER(p_attr_value1);
932: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_UOM_CODE then
933: l_x_Line_Adj_rec.benefit_uom_code := p_attr_value1;
934: ELSIF p_attr_id = OE_Line_Adj_Util.G_PRINT_ON_INVOICE_FLAG then
935: l_x_Line_Adj_rec.print_on_invoice_flag := p_attr_value1;
936: ELSIF p_attr_id = OE_Line_Adj_Util.G_EXPIRATION_DATE then

Line 934: ELSIF p_attr_id = OE_Line_Adj_Util.G_PRINT_ON_INVOICE_FLAG then

930: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_QTY then
931: l_x_Line_Adj_rec.benefit_qty := TO_NUMBER(p_attr_value1);
932: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_UOM_CODE then
933: l_x_Line_Adj_rec.benefit_uom_code := p_attr_value1;
934: ELSIF p_attr_id = OE_Line_Adj_Util.G_PRINT_ON_INVOICE_FLAG then
935: l_x_Line_Adj_rec.print_on_invoice_flag := p_attr_value1;
936: ELSIF p_attr_id = OE_Line_Adj_Util.G_EXPIRATION_DATE then
937: -- l_x_Line_Adj_rec.expiration_date := TO_DATE(p_attr_value1, l_date_format);
938: l_x_Line_Adj_rec.expiration_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396

Line 936: ELSIF p_attr_id = OE_Line_Adj_Util.G_EXPIRATION_DATE then

932: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_UOM_CODE then
933: l_x_Line_Adj_rec.benefit_uom_code := p_attr_value1;
934: ELSIF p_attr_id = OE_Line_Adj_Util.G_PRINT_ON_INVOICE_FLAG then
935: l_x_Line_Adj_rec.print_on_invoice_flag := p_attr_value1;
936: ELSIF p_attr_id = OE_Line_Adj_Util.G_EXPIRATION_DATE then
937: -- l_x_Line_Adj_rec.expiration_date := TO_DATE(p_attr_value1, l_date_format);
938: l_x_Line_Adj_rec.expiration_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396
939: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_TRANSACTION_TYPE_CODE then
940: l_x_Line_Adj_rec.rebate_transaction_type_code := p_attr_value1;

Line 939: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_TRANSACTION_TYPE_CODE then

935: l_x_Line_Adj_rec.print_on_invoice_flag := p_attr_value1;
936: ELSIF p_attr_id = OE_Line_Adj_Util.G_EXPIRATION_DATE then
937: -- l_x_Line_Adj_rec.expiration_date := TO_DATE(p_attr_value1, l_date_format);
938: l_x_Line_Adj_rec.expiration_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396
939: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_TRANSACTION_TYPE_CODE then
940: l_x_Line_Adj_rec.rebate_transaction_type_code := p_attr_value1;
941: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_TRANSACTION_REFERENCE then
942: l_x_Line_Adj_rec.rebate_transaction_reference := p_attr_value1;
943: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_PAYMENT_SYSTEM_CODE then

Line 941: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_TRANSACTION_REFERENCE then

937: -- l_x_Line_Adj_rec.expiration_date := TO_DATE(p_attr_value1, l_date_format);
938: l_x_Line_Adj_rec.expiration_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396
939: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_TRANSACTION_TYPE_CODE then
940: l_x_Line_Adj_rec.rebate_transaction_type_code := p_attr_value1;
941: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_TRANSACTION_REFERENCE then
942: l_x_Line_Adj_rec.rebate_transaction_reference := p_attr_value1;
943: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_PAYMENT_SYSTEM_CODE then
944: l_x_Line_Adj_rec.rebate_payment_system_code := p_attr_value1;
945: ELSIF p_attr_id = OE_Line_Adj_Util.G_REDEEMED_DATE then

Line 943: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_PAYMENT_SYSTEM_CODE then

939: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_TRANSACTION_TYPE_CODE then
940: l_x_Line_Adj_rec.rebate_transaction_type_code := p_attr_value1;
941: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_TRANSACTION_REFERENCE then
942: l_x_Line_Adj_rec.rebate_transaction_reference := p_attr_value1;
943: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_PAYMENT_SYSTEM_CODE then
944: l_x_Line_Adj_rec.rebate_payment_system_code := p_attr_value1;
945: ELSIF p_attr_id = OE_Line_Adj_Util.G_REDEEMED_DATE then
946: -- l_x_Line_Adj_rec.redeemed_date := TO_DATE(p_attr_value1, l_date_format);
947: l_x_Line_Adj_rec.redeemed_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396

Line 945: ELSIF p_attr_id = OE_Line_Adj_Util.G_REDEEMED_DATE then

941: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_TRANSACTION_REFERENCE then
942: l_x_Line_Adj_rec.rebate_transaction_reference := p_attr_value1;
943: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_PAYMENT_SYSTEM_CODE then
944: l_x_Line_Adj_rec.rebate_payment_system_code := p_attr_value1;
945: ELSIF p_attr_id = OE_Line_Adj_Util.G_REDEEMED_DATE then
946: -- l_x_Line_Adj_rec.redeemed_date := TO_DATE(p_attr_value1, l_date_format);
947: l_x_Line_Adj_rec.redeemed_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396
948: ELSIF p_attr_id = OE_Line_Adj_Util.G_REDEEMED_FLAG then
949: l_x_Line_Adj_rec.redeemed_flag := p_attr_value1;

Line 948: ELSIF p_attr_id = OE_Line_Adj_Util.G_REDEEMED_FLAG then

944: l_x_Line_Adj_rec.rebate_payment_system_code := p_attr_value1;
945: ELSIF p_attr_id = OE_Line_Adj_Util.G_REDEEMED_DATE then
946: -- l_x_Line_Adj_rec.redeemed_date := TO_DATE(p_attr_value1, l_date_format);
947: l_x_Line_Adj_rec.redeemed_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396
948: ELSIF p_attr_id = OE_Line_Adj_Util.G_REDEEMED_FLAG then
949: l_x_Line_Adj_rec.redeemed_flag := p_attr_value1;
950: ELSIF p_attr_id = OE_Line_Adj_Util.G_ACCRUAL_FLAG then
951: l_x_Line_Adj_rec.accrual_flag := p_attr_value1;
952: ELSIF p_attr_id = OE_Line_Adj_Util.G_AUTOMATIC THEN

Line 950: ELSIF p_attr_id = OE_Line_Adj_Util.G_ACCRUAL_FLAG then

946: -- l_x_Line_Adj_rec.redeemed_date := TO_DATE(p_attr_value1, l_date_format);
947: l_x_Line_Adj_rec.redeemed_date := fnd_date.string_TO_DATE(p_attr_value1, l_date_format); --bug5402396
948: ELSIF p_attr_id = OE_Line_Adj_Util.G_REDEEMED_FLAG then
949: l_x_Line_Adj_rec.redeemed_flag := p_attr_value1;
950: ELSIF p_attr_id = OE_Line_Adj_Util.G_ACCRUAL_FLAG then
951: l_x_Line_Adj_rec.accrual_flag := p_attr_value1;
952: ELSIF p_attr_id = OE_Line_Adj_Util.G_AUTOMATIC THEN
953: l_x_Line_Adj_rec.automatic_flag := p_attr_value1;
954: ELSIF p_attr_id = OE_Line_Adj_Util.G_PERCENT THEN

Line 952: ELSIF p_attr_id = OE_Line_Adj_Util.G_AUTOMATIC THEN

948: ELSIF p_attr_id = OE_Line_Adj_Util.G_REDEEMED_FLAG then
949: l_x_Line_Adj_rec.redeemed_flag := p_attr_value1;
950: ELSIF p_attr_id = OE_Line_Adj_Util.G_ACCRUAL_FLAG then
951: l_x_Line_Adj_rec.accrual_flag := p_attr_value1;
952: ELSIF p_attr_id = OE_Line_Adj_Util.G_AUTOMATIC THEN
953: l_x_Line_Adj_rec.automatic_flag := p_attr_value1;
954: ELSIF p_attr_id = OE_Line_Adj_Util.G_PERCENT THEN
955: l_x_Line_Adj_rec.percent := TO_NUMBER(p_attr_value1);
956: --Manual Begin

Line 954: ELSIF p_attr_id = OE_Line_Adj_Util.G_PERCENT THEN

950: ELSIF p_attr_id = OE_Line_Adj_Util.G_ACCRUAL_FLAG then
951: l_x_Line_Adj_rec.accrual_flag := p_attr_value1;
952: ELSIF p_attr_id = OE_Line_Adj_Util.G_AUTOMATIC THEN
953: l_x_Line_Adj_rec.automatic_flag := p_attr_value1;
954: ELSIF p_attr_id = OE_Line_Adj_Util.G_PERCENT THEN
955: l_x_Line_Adj_rec.percent := TO_NUMBER(p_attr_value1);
956: --Manual Begin
957: ELSIF p_attr_id = OE_Line_Adj_Util.G_LINE THEN
958: If p_attr_value1 Is Not Null Then

Line 957: ELSIF p_attr_id = OE_Line_Adj_Util.G_LINE THEN

953: l_x_Line_Adj_rec.automatic_flag := p_attr_value1;
954: ELSIF p_attr_id = OE_Line_Adj_Util.G_PERCENT THEN
955: l_x_Line_Adj_rec.percent := TO_NUMBER(p_attr_value1);
956: --Manual Begin
957: ELSIF p_attr_id = OE_Line_Adj_Util.G_LINE THEN
958: If p_attr_value1 Is Not Null Then
959: l_x_Line_Adj_rec.line_id := TO_NUMBER(p_attr_value1);
960: Else
961: l_x_Line_Adj_rec.line_id := NULL;

Line 964: ELSIF p_attr_id = OE_Line_Adj_Util.G_ESTIMATED_FLAG THEN

960: Else
961: l_x_Line_Adj_rec.line_id := NULL;
962: End If;
963: --Manual End
964: ELSIF p_attr_id = OE_Line_Adj_Util.G_ESTIMATED_FLAG THEN
965: l_x_Line_Adj_rec.estimated_flag := p_attr_value1;
966: ELSIF p_attr_id = OE_Line_Adj_Util.G_INVOICED_FLAG THEN
967: l_x_Line_Adj_rec.INVOICED_FLAG := p_attr_value1;
968: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHARGE_TYPE_CODE THEN

Line 966: ELSIF p_attr_id = OE_Line_Adj_Util.G_INVOICED_FLAG THEN

962: End If;
963: --Manual End
964: ELSIF p_attr_id = OE_Line_Adj_Util.G_ESTIMATED_FLAG THEN
965: l_x_Line_Adj_rec.estimated_flag := p_attr_value1;
966: ELSIF p_attr_id = OE_Line_Adj_Util.G_INVOICED_FLAG THEN
967: l_x_Line_Adj_rec.INVOICED_FLAG := p_attr_value1;
968: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHARGE_TYPE_CODE THEN
969: l_x_Line_Adj_rec.CHARGE_TYPE_CODE := p_attr_value1;
970: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHARGE_SUBTYPE_CODE THEN

Line 968: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHARGE_TYPE_CODE THEN

964: ELSIF p_attr_id = OE_Line_Adj_Util.G_ESTIMATED_FLAG THEN
965: l_x_Line_Adj_rec.estimated_flag := p_attr_value1;
966: ELSIF p_attr_id = OE_Line_Adj_Util.G_INVOICED_FLAG THEN
967: l_x_Line_Adj_rec.INVOICED_FLAG := p_attr_value1;
968: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHARGE_TYPE_CODE THEN
969: l_x_Line_Adj_rec.CHARGE_TYPE_CODE := p_attr_value1;
970: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHARGE_SUBTYPE_CODE THEN
971: l_x_Line_Adj_rec.CHARGE_SUBTYPE_CODE := p_attr_value1;
972: ELSIF p_attr_id = OE_Line_Adj_Util.G_CREDIT_OR_CHARGE_FLAG THEN

Line 970: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHARGE_SUBTYPE_CODE THEN

966: ELSIF p_attr_id = OE_Line_Adj_Util.G_INVOICED_FLAG THEN
967: l_x_Line_Adj_rec.INVOICED_FLAG := p_attr_value1;
968: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHARGE_TYPE_CODE THEN
969: l_x_Line_Adj_rec.CHARGE_TYPE_CODE := p_attr_value1;
970: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHARGE_SUBTYPE_CODE THEN
971: l_x_Line_Adj_rec.CHARGE_SUBTYPE_CODE := p_attr_value1;
972: ELSIF p_attr_id = OE_Line_Adj_Util.G_CREDIT_OR_CHARGE_FLAG THEN
973: l_x_Line_Adj_rec.CREDIT_OR_CHARGE_FLAG := p_attr_value1;
974: ELSIF p_attr_id = OE_Line_Adj_Util.G_INCLUDE_ON_RETURNS_FLAG THEN

Line 972: ELSIF p_attr_id = OE_Line_Adj_Util.G_CREDIT_OR_CHARGE_FLAG THEN

968: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHARGE_TYPE_CODE THEN
969: l_x_Line_Adj_rec.CHARGE_TYPE_CODE := p_attr_value1;
970: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHARGE_SUBTYPE_CODE THEN
971: l_x_Line_Adj_rec.CHARGE_SUBTYPE_CODE := p_attr_value1;
972: ELSIF p_attr_id = OE_Line_Adj_Util.G_CREDIT_OR_CHARGE_FLAG THEN
973: l_x_Line_Adj_rec.CREDIT_OR_CHARGE_FLAG := p_attr_value1;
974: ELSIF p_attr_id = OE_Line_Adj_Util.G_INCLUDE_ON_RETURNS_FLAG THEN
975: l_x_Line_Adj_rec.INCLUDE_ON_RETURNS_FLAG := p_attr_value1;
976: --Manual Begin

Line 974: 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_SUBTYPE_CODE THEN
971: l_x_Line_Adj_rec.CHARGE_SUBTYPE_CODE := p_attr_value1;
972: ELSIF p_attr_id = OE_Line_Adj_Util.G_CREDIT_OR_CHARGE_FLAG THEN
973: l_x_Line_Adj_rec.CREDIT_OR_CHARGE_FLAG := p_attr_value1;
974: ELSIF p_attr_id = OE_Line_Adj_Util.G_INCLUDE_ON_RETURNS_FLAG THEN
975: l_x_Line_Adj_rec.INCLUDE_ON_RETURNS_FLAG := p_attr_value1;
976: --Manual Begin
977: ELSIF p_attr_id = OE_LINE_Adj_Util.G_modifier_level_code Then
978: l_x_Line_Adj_rec.modifier_level_code := p_attr_value1;

Line 977: ELSIF p_attr_id = OE_LINE_Adj_Util.G_modifier_level_code Then

973: l_x_Line_Adj_rec.CREDIT_OR_CHARGE_FLAG := p_attr_value1;
974: ELSIF p_attr_id = OE_Line_Adj_Util.G_INCLUDE_ON_RETURNS_FLAG THEN
975: l_x_Line_Adj_rec.INCLUDE_ON_RETURNS_FLAG := p_attr_value1;
976: --Manual Begin
977: ELSIF p_attr_id = OE_LINE_Adj_Util.G_modifier_level_code Then
978: l_x_Line_Adj_rec.modifier_level_code := p_attr_value1;
979: ELSIF p_attr_id = OE_LINE_Adj_Util.G_OVERRIDE_ALLOWED_FLAG Then
980: l_x_Line_Adj_rec.update_allowed:= p_attr_value1;
981: --Manual end

Line 979: ELSIF p_attr_id = OE_LINE_Adj_Util.G_OVERRIDE_ALLOWED_FLAG Then

975: l_x_Line_Adj_rec.INCLUDE_ON_RETURNS_FLAG := p_attr_value1;
976: --Manual Begin
977: ELSIF p_attr_id = OE_LINE_Adj_Util.G_modifier_level_code Then
978: l_x_Line_Adj_rec.modifier_level_code := p_attr_value1;
979: ELSIF p_attr_id = OE_LINE_Adj_Util.G_OVERRIDE_ALLOWED_FLAG Then
980: l_x_Line_Adj_rec.update_allowed:= p_attr_value1;
981: --Manual end
982: --uom begin
983: ELSIF p_attr_id = OE_Line_Adj_Util.G_OPERAND_PER_PQTY THEN

Line 983: ELSIF p_attr_id = OE_Line_Adj_Util.G_OPERAND_PER_PQTY THEN

979: ELSIF p_attr_id = OE_LINE_Adj_Util.G_OVERRIDE_ALLOWED_FLAG Then
980: l_x_Line_Adj_rec.update_allowed:= p_attr_value1;
981: --Manual end
982: --uom begin
983: ELSIF p_attr_id = OE_Line_Adj_Util.G_OPERAND_PER_PQTY THEN
984: l_x_Line_Adj_rec.OPERAND_PER_PQTY := p_attr_value1;
985: ELSIF p_attr_id = OE_Line_Adj_Util.G_ADJUSTED_AMOUNT_PER_PQTY THEN
986: l_x_Line_Adj_rec.ADJUSTED_AMOUNT_PER_PQTY := p_attr_value1;
987: --uom end

Line 985: ELSIF p_attr_id = OE_Line_Adj_Util.G_ADJUSTED_AMOUNT_PER_PQTY THEN

981: --Manual end
982: --uom begin
983: ELSIF p_attr_id = OE_Line_Adj_Util.G_OPERAND_PER_PQTY THEN
984: l_x_Line_Adj_rec.OPERAND_PER_PQTY := p_attr_value1;
985: ELSIF p_attr_id = OE_Line_Adj_Util.G_ADJUSTED_AMOUNT_PER_PQTY THEN
986: l_x_Line_Adj_rec.ADJUSTED_AMOUNT_PER_PQTY := p_attr_value1;
987: --uom end
988: ELSIF p_attr_id = OE_LINE_Adj_Util.G_RANGE_BREAK_QUANTITY THEN
989: l_x_Line_Adj_rec.range_break_quantity := p_attr_value1;

Line 988: ELSIF p_attr_id = OE_LINE_Adj_Util.G_RANGE_BREAK_QUANTITY THEN

984: l_x_Line_Adj_rec.OPERAND_PER_PQTY := p_attr_value1;
985: ELSIF p_attr_id = OE_Line_Adj_Util.G_ADJUSTED_AMOUNT_PER_PQTY THEN
986: l_x_Line_Adj_rec.ADJUSTED_AMOUNT_PER_PQTY := p_attr_value1;
987: --uom end
988: ELSIF p_attr_id = OE_LINE_Adj_Util.G_RANGE_BREAK_QUANTITY THEN
989: l_x_Line_Adj_rec.range_break_quantity := p_attr_value1;
990: ELSIF p_attr_id = OE_Line_Adj_Util.G_CONTEXT
991: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE1
992: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE2

Line 990: ELSIF p_attr_id = OE_Line_Adj_Util.G_CONTEXT

986: l_x_Line_Adj_rec.ADJUSTED_AMOUNT_PER_PQTY := p_attr_value1;
987: --uom end
988: ELSIF p_attr_id = OE_LINE_Adj_Util.G_RANGE_BREAK_QUANTITY THEN
989: l_x_Line_Adj_rec.range_break_quantity := p_attr_value1;
990: ELSIF p_attr_id = OE_Line_Adj_Util.G_CONTEXT
991: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE1
992: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE2
993: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE3
994: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE4

Line 991: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE1

987: --uom end
988: ELSIF p_attr_id = OE_LINE_Adj_Util.G_RANGE_BREAK_QUANTITY THEN
989: l_x_Line_Adj_rec.range_break_quantity := p_attr_value1;
990: ELSIF p_attr_id = OE_Line_Adj_Util.G_CONTEXT
991: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE1
992: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE2
993: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE3
994: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE4
995: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE5

Line 992: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE2

988: ELSIF p_attr_id = OE_LINE_Adj_Util.G_RANGE_BREAK_QUANTITY THEN
989: l_x_Line_Adj_rec.range_break_quantity := p_attr_value1;
990: ELSIF p_attr_id = OE_Line_Adj_Util.G_CONTEXT
991: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE1
992: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE2
993: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE3
994: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE4
995: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE5
996: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE6

Line 993: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE3

989: l_x_Line_Adj_rec.range_break_quantity := p_attr_value1;
990: ELSIF p_attr_id = OE_Line_Adj_Util.G_CONTEXT
991: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE1
992: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE2
993: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE3
994: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE4
995: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE5
996: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE6
997: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE7

Line 994: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE4

990: ELSIF p_attr_id = OE_Line_Adj_Util.G_CONTEXT
991: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE1
992: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE2
993: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE3
994: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE4
995: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE5
996: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE6
997: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE7
998: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE8

Line 995: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE5

991: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE1
992: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE2
993: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE3
994: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE4
995: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE5
996: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE6
997: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE7
998: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE8
999: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE9

Line 996: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE6

992: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE2
993: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE3
994: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE4
995: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE5
996: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE6
997: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE7
998: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE8
999: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE9
1000: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE10

Line 997: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE7

993: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE3
994: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE4
995: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE5
996: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE6
997: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE7
998: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE8
999: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE9
1000: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE10
1001: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE11

Line 998: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE8

994: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE4
995: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE5
996: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE6
997: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE7
998: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE8
999: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE9
1000: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE10
1001: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE11
1002: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE12

Line 999: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE9

995: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE5
996: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE6
997: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE7
998: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE8
999: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE9
1000: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE10
1001: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE11
1002: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE12
1003: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE13

Line 1000: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE10

996: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE6
997: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE7
998: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE8
999: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE9
1000: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE10
1001: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE11
1002: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE12
1003: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE13
1004: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE14

Line 1001: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE11

997: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE7
998: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE8
999: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE9
1000: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE10
1001: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE11
1002: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE12
1003: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE13
1004: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE14
1005: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE15

Line 1002: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE12

998: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE8
999: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE9
1000: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE10
1001: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE11
1002: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE12
1003: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE13
1004: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE14
1005: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE15
1006: THEN

Line 1003: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE13

999: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE9
1000: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE10
1001: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE11
1002: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE12
1003: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE13
1004: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE14
1005: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE15
1006: THEN
1007:

Line 1004: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE14

1000: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE10
1001: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE11
1002: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE12
1003: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE13
1004: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE14
1005: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE15
1006: THEN
1007:
1008: l_x_Line_Adj_rec.context := p_context;

Line 1005: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE15

1001: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE11
1002: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE12
1003: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE13
1004: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE14
1005: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE15
1006: THEN
1007:
1008: l_x_Line_Adj_rec.context := p_context;
1009: l_x_Line_Adj_rec.attribute1 := p_attribute1;

Line 1024: ELSIF p_attr_id = OE_Line_Adj_Util.G_AC_CONTEXT

1020: l_x_Line_Adj_rec.attribute12 := p_attribute12;
1021: l_x_Line_Adj_rec.attribute13 := p_attribute13;
1022: l_x_Line_Adj_rec.attribute14 := p_attribute14;
1023: l_x_Line_Adj_rec.attribute15 := p_attribute15;
1024: ELSIF p_attr_id = OE_Line_Adj_Util.G_AC_CONTEXT
1025: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE1
1026: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE2
1027: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE3
1028: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE4

Line 1025: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE1

1021: l_x_Line_Adj_rec.attribute13 := p_attribute13;
1022: l_x_Line_Adj_rec.attribute14 := p_attribute14;
1023: l_x_Line_Adj_rec.attribute15 := p_attribute15;
1024: ELSIF p_attr_id = OE_Line_Adj_Util.G_AC_CONTEXT
1025: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE1
1026: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE2
1027: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE3
1028: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE4
1029: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE5

Line 1026: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE2

1022: l_x_Line_Adj_rec.attribute14 := p_attribute14;
1023: l_x_Line_Adj_rec.attribute15 := p_attribute15;
1024: ELSIF p_attr_id = OE_Line_Adj_Util.G_AC_CONTEXT
1025: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE1
1026: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE2
1027: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE3
1028: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE4
1029: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE5
1030: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE6

Line 1027: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE3

1023: l_x_Line_Adj_rec.attribute15 := p_attribute15;
1024: ELSIF p_attr_id = OE_Line_Adj_Util.G_AC_CONTEXT
1025: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE1
1026: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE2
1027: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE3
1028: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE4
1029: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE5
1030: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE6
1031: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE7

Line 1028: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE4

1024: ELSIF p_attr_id = OE_Line_Adj_Util.G_AC_CONTEXT
1025: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE1
1026: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE2
1027: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE3
1028: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE4
1029: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE5
1030: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE6
1031: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE7
1032: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE8

Line 1029: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE5

1025: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE1
1026: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE2
1027: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE3
1028: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE4
1029: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE5
1030: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE6
1031: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE7
1032: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE8
1033: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE9

Line 1030: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE6

1026: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE2
1027: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE3
1028: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE4
1029: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE5
1030: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE6
1031: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE7
1032: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE8
1033: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE9
1034: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE10

Line 1031: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE7

1027: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE3
1028: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE4
1029: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE5
1030: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE6
1031: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE7
1032: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE8
1033: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE9
1034: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE10
1035: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE11

Line 1032: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE8

1028: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE4
1029: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE5
1030: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE6
1031: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE7
1032: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE8
1033: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE9
1034: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE10
1035: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE11
1036: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE12

Line 1033: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE9

1029: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE5
1030: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE6
1031: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE7
1032: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE8
1033: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE9
1034: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE10
1035: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE11
1036: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE12
1037: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE13

Line 1034: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE10

1030: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE6
1031: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE7
1032: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE8
1033: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE9
1034: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE10
1035: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE11
1036: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE12
1037: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE13
1038: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE14

Line 1035: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE11

1031: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE7
1032: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE8
1033: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE9
1034: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE10
1035: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE11
1036: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE12
1037: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE13
1038: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE14
1039: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE15

Line 1036: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE12

1032: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE8
1033: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE9
1034: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE10
1035: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE11
1036: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE12
1037: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE13
1038: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE14
1039: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE15
1040: THEN

Line 1037: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE13

1033: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE9
1034: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE10
1035: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE11
1036: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE12
1037: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE13
1038: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE14
1039: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE15
1040: THEN
1041:

Line 1038: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE14

1034: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE10
1035: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE11
1036: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE12
1037: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE13
1038: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE14
1039: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE15
1040: THEN
1041:
1042: l_x_Line_Adj_rec.ac_context := p_ac_context;

Line 1039: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE15

1035: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE11
1036: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE12
1037: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE13
1038: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE14
1039: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE15
1040: THEN
1041:
1042: l_x_Line_Adj_rec.ac_context := p_ac_context;
1043: l_x_Line_Adj_rec.ac_attribute1 := p_ac_attribute1;

Line 1127: oe_debug_pub.add( ' G_OPERAND_PER_PQTY:'||OE_LINE_ADJ_UTIL.G_OPERAND_PER_PQTY ) ;

1123: IF l_debug_level > 0 THEN
1124: oe_debug_pub.add( ' P_ATTR_ID:'|| P_ATTR_ID ) ;
1125: END IF;
1126: IF l_debug_level > 0 THEN
1127: oe_debug_pub.add( ' G_OPERAND_PER_PQTY:'||OE_LINE_ADJ_UTIL.G_OPERAND_PER_PQTY ) ;
1128: END IF;
1129:
1130:
1131: If (l_x_line_adj_rec.arithmetic_operator = '%' and

Line 1132: p_attr_id = OE_Line_Adj_Util.G_OPERAND_PER_PQTY)

1128: END IF;
1129:
1130:
1131: If (l_x_line_adj_rec.arithmetic_operator = '%' and
1132: p_attr_id = OE_Line_Adj_Util.G_OPERAND_PER_PQTY)
1133: or p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_CODE
1134: Then
1135: IF l_debug_level > 0 THEN
1136: oe_debug_pub.add( ' CS BEFORE GETTING LINE' ) ;

Line 1133: or p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_CODE

1129:
1130:
1131: If (l_x_line_adj_rec.arithmetic_operator = '%' and
1132: p_attr_id = OE_Line_Adj_Util.G_OPERAND_PER_PQTY)
1133: or p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_CODE
1134: Then
1135: IF l_debug_level > 0 THEN
1136: oe_debug_pub.add( ' CS BEFORE GETTING LINE' ) ;
1137: END IF;

Line 1212: If p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_CODE Then

1208:
1209: End If;
1210:
1211: --we will need to cascade change reason code too, if it got changed
1212: If p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_CODE Then
1213:
1214: --If no line queried, requery again else just use this to
1215: If nvl(l_line_rec.line_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM Then
1216: Oe_Oe_Form_Line.Get_Line(p_line_id=>l_x_line_adj_rec.line_id,

Line 1421: l_Line_Adj_val_rec := OE_Line_Adj_Util.Get_Values

1417: --uom end
1418:
1419: -- Load display out parameters if any
1420:
1421: l_Line_Adj_val_rec := OE_Line_Adj_Util.Get_Values
1422: ( p_Line_Adj_rec =>l_x_Line_Adj_rec
1423: , p_old_Line_Adj_rec => l_Line_Adj_rec
1424: );
1425:

Line 3120: OE_Line_Adj_Util.Lock_Row

3116: l_x_Line_Adj_rec.operation := OE_GLOBALS.G_OPR_LOCK;
3117: l_x_Line_Adj_rec.lock_control := p_lock_control;
3118: l_x_Line_Adj_rec.price_adjustment_id := p_price_adjustment_id;
3119:
3120: OE_Line_Adj_Util.Lock_Row
3121: ( x_return_status => l_return_status
3122: , p_x_line_adj_rec => l_x_line_adj_rec
3123: );
3124:

Line 3230: OE_Line_Adj_Util.Query_Row

3226: THEN
3227:
3228: -- Query row from DB
3229:
3230: OE_Line_Adj_Util.Query_Row
3231: ( p_price_adjustment_id => p_price_adjustment_id
3232: , x_Line_Adj_rec => g_Line_Adj_rec
3233: );
3234: