DBA Data[Home] [Help]

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_pricing_group_sequence THEN --bug 12895497

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_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

Line 919: ELSIF p_attr_id = OE_Line_Adj_Util.G_pricing_group_sequence THEN --bug 12895497

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:

Line 921: ELSIF p_attr_id = OE_Line_Adj_Util.G_ARITHMETIC_OPERATOR then

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 ;

Line 924: ELSIF p_attr_id = OE_Line_Adj_Util.G_ADJUSTED_AMOUNT then

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

Line 926: ELSIF p_attr_id = OE_Line_Adj_Util.G_PRICING_PHASE_ID 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

Line 928: ELSIF p_attr_id = OE_Line_Adj_Util.G_LIST_LINE_NO 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

Line 930: ELSIF p_attr_id = OE_Line_Adj_Util.G_SOURCE_SYSTEM_CODE 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

Line 932: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_QTY 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

Line 934: ELSIF p_attr_id = OE_Line_Adj_Util.G_BENEFIT_UOM_CODE 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

Line 936: ELSIF p_attr_id = OE_Line_Adj_Util.G_PRINT_ON_INVOICE_FLAG 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

Line 938: ELSIF p_attr_id = OE_Line_Adj_Util.G_EXPIRATION_DATE then

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;

Line 941: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_TRANSACTION_TYPE_CODE 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;
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

Line 943: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_TRANSACTION_REFERENCE 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

Line 945: ELSIF p_attr_id = OE_Line_Adj_Util.G_REBATE_PAYMENT_SYSTEM_CODE 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

Line 947: ELSIF p_attr_id = OE_Line_Adj_Util.G_REDEEMED_DATE then

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;

Line 950: ELSIF p_attr_id = OE_Line_Adj_Util.G_REDEEMED_FLAG 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;
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

Line 952: ELSIF p_attr_id = OE_Line_Adj_Util.G_ACCRUAL_FLAG 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

Line 954: ELSIF p_attr_id = OE_Line_Adj_Util.G_AUTOMATIC 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

Line 956: ELSIF p_attr_id = OE_Line_Adj_Util.G_PERCENT THEN

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

Line 959: ELSIF p_attr_id = OE_Line_Adj_Util.G_LINE 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;

Line 966: ELSIF p_attr_id = OE_Line_Adj_Util.G_ESTIMATED_FLAG THEN

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

Line 968: ELSIF p_attr_id = OE_Line_Adj_Util.G_INVOICED_FLAG 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

Line 970: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHARGE_TYPE_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

Line 972: ELSIF p_attr_id = OE_Line_Adj_Util.G_CHARGE_SUBTYPE_CODE 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

Line 974: ELSIF p_attr_id = OE_Line_Adj_Util.G_CREDIT_OR_CHARGE_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

Line 976: ELSIF p_attr_id = OE_Line_Adj_Util.G_INCLUDE_ON_RETURNS_FLAG THEN

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;

Line 979: ELSIF p_attr_id = OE_LINE_Adj_Util.G_modifier_level_code 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;
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

Line 981: ELSIF p_attr_id = OE_LINE_Adj_Util.G_OVERRIDE_ALLOWED_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
984: --uom begin
985: ELSIF p_attr_id = OE_Line_Adj_Util.G_OPERAND_PER_PQTY THEN

Line 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

Line 987: ELSIF p_attr_id = OE_Line_Adj_Util.G_ADJUSTED_AMOUNT_PER_PQTY THEN

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;

Line 990: ELSIF p_attr_id = OE_LINE_Adj_Util.G_RANGE_BREAK_QUANTITY 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;
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

Line 992: ELSIF p_attr_id = OE_Line_Adj_Util.G_CONTEXT

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

Line 993: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE1

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

Line 994: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE2

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

Line 995: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE3

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

Line 996: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE4

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

Line 997: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE5

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

Line 998: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE6

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

Line 999: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE7

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

Line 1000: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE8

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

Line 1001: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE9

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

Line 1002: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE10

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

Line 1003: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE11

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

Line 1004: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE12

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

Line 1005: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE13

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:

Line 1006: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE14

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;

Line 1007: OR p_attr_id = OE_Line_Adj_Util.G_ATTRIBUTE15

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;

Line 1026: ELSIF p_attr_id = OE_Line_Adj_Util.G_AC_CONTEXT

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

Line 1027: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE1

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

Line 1028: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE2

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

Line 1029: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE3

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

Line 1030: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE4

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

Line 1031: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE5

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

Line 1032: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE6

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

Line 1033: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE7

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

Line 1034: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE8

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

Line 1035: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE9

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

Line 1036: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE10

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

Line 1037: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE11

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

Line 1038: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE12

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

Line 1039: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE13

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:

Line 1040: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE14

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;

Line 1041: OR p_attr_id = OE_Line_Adj_Util.G_AC_ATTRIBUTE15

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;

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

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

Line 1134: p_attr_id = OE_Line_Adj_Util.G_OPERAND_PER_PQTY)

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' ) ;

Line 1135: or p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_CODE

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;

Line 1214: If p_attr_id = OE_Line_Adj_Util.G_CHANGE_REASON_CODE Then

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,

Line 1423: l_Line_Adj_val_rec := OE_Line_Adj_Util.Get_Values

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:

Line 3137: OE_Line_Adj_Util.Lock_Row

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:

Line 3247: OE_Line_Adj_Util.Query_Row

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: