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_UPDATE_ACK_UTIL dependencies on OE_ID_TO_VALUE

Line 592: l_header_acks_rec.order_type := Oe_Id_To_Value.Order_Type

588: -- agreement, freight terms
589: Begin
590:
591: If l_header_acks_rec.order_type_id Is Not Null Then
592: l_header_acks_rec.order_type := Oe_Id_To_Value.Order_Type
593: (p_order_type_id => l_header_acks_rec.order_type_id);
594: End If;
595: If l_header_acks_rec.price_list_id Is Not Null Then
596: l_header_acks_rec.price_list := Oe_Id_To_Value.Price_List

Line 596: l_header_acks_rec.price_list := Oe_Id_To_Value.Price_List

592: l_header_acks_rec.order_type := Oe_Id_To_Value.Order_Type
593: (p_order_type_id => l_header_acks_rec.order_type_id);
594: End If;
595: If l_header_acks_rec.price_list_id Is Not Null Then
596: l_header_acks_rec.price_list := Oe_Id_To_Value.Price_List
597: (p_price_list_id => l_header_acks_rec.price_list_id);
598: End If;
599: If l_header_acks_rec.payment_term_id Is Not Null Then
600: l_header_acks_rec.payment_term := Oe_Id_To_Value.Payment_Term

Line 600: l_header_acks_rec.payment_term := Oe_Id_To_Value.Payment_Term

596: l_header_acks_rec.price_list := Oe_Id_To_Value.Price_List
597: (p_price_list_id => l_header_acks_rec.price_list_id);
598: End If;
599: If l_header_acks_rec.payment_term_id Is Not Null Then
600: l_header_acks_rec.payment_term := Oe_Id_To_Value.Payment_Term
601: (p_payment_term_id => l_header_acks_rec.payment_term_id);
602: End If;
603: If l_header_acks_rec.salesrep_id Is Not Null Then
604: l_header_acks_rec.salesrep := Oe_Id_To_Value.Salesrep

Line 604: l_header_acks_rec.salesrep := Oe_Id_To_Value.Salesrep

600: l_header_acks_rec.payment_term := Oe_Id_To_Value.Payment_Term
601: (p_payment_term_id => l_header_acks_rec.payment_term_id);
602: End If;
603: If l_header_acks_rec.salesrep_id Is Not Null Then
604: l_header_acks_rec.salesrep := Oe_Id_To_Value.Salesrep
605: (p_salesrep_id => l_header_acks_rec.salesrep_id);
606: End If;
607: If l_header_acks_rec.fob_point_code Is Not Null Then
608: l_header_acks_rec.fob_point := Oe_Id_To_Value.Fob_Point

Line 608: l_header_acks_rec.fob_point := Oe_Id_To_Value.Fob_Point

604: l_header_acks_rec.salesrep := Oe_Id_To_Value.Salesrep
605: (p_salesrep_id => l_header_acks_rec.salesrep_id);
606: End If;
607: If l_header_acks_rec.fob_point_code Is Not Null Then
608: l_header_acks_rec.fob_point := Oe_Id_To_Value.Fob_Point
609: (p_fob_point_code => l_header_acks_rec.fob_point_code);
610: End If;
611: If l_header_acks_rec.freight_terms_code Is Not Null Then
612: l_header_acks_rec.freight_terms := Oe_Id_To_Value.Freight_Terms

Line 612: l_header_acks_rec.freight_terms := Oe_Id_To_Value.Freight_Terms

608: l_header_acks_rec.fob_point := Oe_Id_To_Value.Fob_Point
609: (p_fob_point_code => l_header_acks_rec.fob_point_code);
610: End If;
611: If l_header_acks_rec.freight_terms_code Is Not Null Then
612: l_header_acks_rec.freight_terms := Oe_Id_To_Value.Freight_Terms
613: (p_freight_terms_code => l_header_acks_rec.freight_terms_code);
614: End If;
615: If l_header_acks_rec.agreement_id Is Not Null Then
616: l_header_acks_rec.agreement := Oe_Id_To_Value.Agreement

Line 616: l_header_acks_rec.agreement := Oe_Id_To_Value.Agreement

612: l_header_acks_rec.freight_terms := Oe_Id_To_Value.Freight_Terms
613: (p_freight_terms_code => l_header_acks_rec.freight_terms_code);
614: End If;
615: If l_header_acks_rec.agreement_id Is Not Null Then
616: l_header_acks_rec.agreement := Oe_Id_To_Value.Agreement
617: (p_agreement_id => l_header_acks_rec.agreement_id);
618: End If;
619: If l_header_acks_rec.conversion_type_code Is Not Null Then
620: l_header_acks_rec.conversion_type := Oe_Id_To_Value.Conversion_Type

Line 620: l_header_acks_rec.conversion_type := Oe_Id_To_Value.Conversion_Type

616: l_header_acks_rec.agreement := Oe_Id_To_Value.Agreement
617: (p_agreement_id => l_header_acks_rec.agreement_id);
618: End If;
619: If l_header_acks_rec.conversion_type_code Is Not Null Then
620: l_header_acks_rec.conversion_type := Oe_Id_To_Value.Conversion_Type
621: (p_conversion_type_code => l_header_acks_rec.conversion_type_code);
622: End If;
623: If l_header_acks_rec.Tax_Exempt_Reason_code Is Not Null Then
624: l_header_acks_rec.tax_exempt_reason := Oe_Id_To_Value.Tax_Exempt_Reason

Line 624: l_header_acks_rec.tax_exempt_reason := Oe_Id_To_Value.Tax_Exempt_Reason

620: l_header_acks_rec.conversion_type := Oe_Id_To_Value.Conversion_Type
621: (p_conversion_type_code => l_header_acks_rec.conversion_type_code);
622: End If;
623: If l_header_acks_rec.Tax_Exempt_Reason_code Is Not Null Then
624: l_header_acks_rec.tax_exempt_reason := Oe_Id_To_Value.Tax_Exempt_Reason
625: (p_tax_exempt_reason_code => l_header_acks_rec.tax_exempt_reason_code);
626: End If;
627: If l_header_acks_rec.tax_point_code Is Not Null Then
628: l_header_acks_rec.tax_point := Oe_Id_To_Value.Tax_Point

Line 628: l_header_acks_rec.tax_point := Oe_Id_To_Value.Tax_Point

624: l_header_acks_rec.tax_exempt_reason := Oe_Id_To_Value.Tax_Exempt_Reason
625: (p_tax_exempt_reason_code => l_header_acks_rec.tax_exempt_reason_code);
626: End If;
627: If l_header_acks_rec.tax_point_code Is Not Null Then
628: l_header_acks_rec.tax_point := Oe_Id_To_Value.Tax_Point
629: (p_tax_point_code => l_header_acks_rec.tax_point_code);
630: End If;
631: If l_header_acks_rec.invoicing_rule_id Is Not Null Then
632: l_header_acks_rec.invoicing_rule := Oe_Id_To_Value.Invoicing_Rule

Line 632: l_header_acks_rec.invoicing_rule := Oe_Id_To_Value.Invoicing_Rule

628: l_header_acks_rec.tax_point := Oe_Id_To_Value.Tax_Point
629: (p_tax_point_code => l_header_acks_rec.tax_point_code);
630: End If;
631: If l_header_acks_rec.invoicing_rule_id Is Not Null Then
632: l_header_acks_rec.invoicing_rule := Oe_Id_To_Value.Invoicing_Rule
633: (p_invoicing_rule_id => l_header_acks_rec.invoicing_rule_id);
634: End If;
635: --added for bug 40344441 start
636: If l_debug_level > 0 Then

Line 641: Oe_Id_To_Value.End_Customer( p_end_customer_id => l_header_acks_rec.end_customer_id

637: Oe_Debug_Pub.Add('Before end customer derivation for header1');
638: End If;
639:
640: If l_header_acks_rec.end_customer_id Is Not Null Then
641: Oe_Id_To_Value.End_Customer( p_end_customer_id => l_header_acks_rec.end_customer_id
642: , x_end_customer_name => l_header_acks_rec.end_customer_name
643: , x_end_customer_number => l_header_acks_rec.end_customer_number
644: );
645: End If;

Line 655: l_header_acks_rec.end_customer_contact := Oe_Id_To_Value.End_Customer_Contact(p_end_customer_contact_id => l_header_acks_rec.end_customer_contact_id);

651: Oe_Debug_Pub.Add('Before end customer derivation for header2');
652: End If;
653:
654: If l_header_acks_rec.end_customer_contact_id Is Not Null Then
655: l_header_acks_rec.end_customer_contact := Oe_Id_To_Value.End_Customer_Contact(p_end_customer_contact_id => l_header_acks_rec.end_customer_contact_id);
656: End If;
657:
658:
659:

Line 668: OE_ID_TO_VALUE.End_Customer_Site_Use( p_end_customer_site_use_id => l_header_acks_rec.end_customer_site_use_id

664:
665:
666:
667: If l_header_acks_rec.end_customer_site_use_id Is Not Null Then
668: OE_ID_TO_VALUE.End_Customer_Site_Use( p_end_customer_site_use_id => l_header_acks_rec.end_customer_site_use_id
669: , x_end_customer_address1 => l_header_acks_rec.end_customer_address1
670: , x_end_customer_address2 => l_header_acks_rec.end_customer_address2
671: , x_end_customer_address3 => l_header_acks_rec.end_customer_address3
672: , x_end_customer_address4 => l_header_acks_rec.end_customer_address4

Line 689: OE_ID_TO_VALUE.Ship_To_Customer_Name(p_ship_to_org_id => l_header_acks_rec.ship_to_org_id,

685: Oe_Debug_Pub.Add('Before ship to customer name derviation for header');
686: End If;
687:
688: If l_header_acks_rec.ship_to_org_id Is Not Null Then
689: OE_ID_TO_VALUE.Ship_To_Customer_Name(p_ship_to_org_id => l_header_acks_rec.ship_to_org_id,
690: x_ship_to_customer_name => l_header_acks_rec.ship_to_customer);
691: End If;
692:
693: If l_debug_level > 0 Then

Line 698: OE_ID_TO_VALUE.Invoice_To_Customer_Name(p_invoice_to_org_id => l_header_acks_rec.invoice_to_org_id,

694: Oe_Debug_Pub.Add('Before invoice to customer name derviation for header');
695: End If;
696:
697: If l_header_acks_rec.invoice_to_org_id Is Not Null Then
698: OE_ID_TO_VALUE.Invoice_To_Customer_Name(p_invoice_to_org_id => l_header_acks_rec.invoice_to_org_id,
699: x_invoice_to_customer_name => l_header_acks_rec.invoice_customer);
700:
701: End If;
702: -- end of changes for bug 4489065

Line 819: l_line_acks_rec.line_type(i) := OE_Id_To_Value.Line_Type

815: If l_line_acks_rec.line_id.count > 0 Then
816:
817: For i In l_line_acks_rec.line_id.First..l_line_acks_rec.line_id.Last Loop
818: If nvl(l_line_acks_rec.error_flag(i),'N') = 'N' Then
819: l_line_acks_rec.line_type(i) := OE_Id_To_Value.Line_Type
820: (p_line_type_id => l_line_acks_rec.line_type_id(i));
821:
822: l_line_acks_rec.price_list(i) := OE_Id_To_Value.price_list
823: (p_price_list_id => l_line_acks_rec.price_list_id(i));

Line 822: l_line_acks_rec.price_list(i) := OE_Id_To_Value.price_list

818: If nvl(l_line_acks_rec.error_flag(i),'N') = 'N' Then
819: l_line_acks_rec.line_type(i) := OE_Id_To_Value.Line_Type
820: (p_line_type_id => l_line_acks_rec.line_type_id(i));
821:
822: l_line_acks_rec.price_list(i) := OE_Id_To_Value.price_list
823: (p_price_list_id => l_line_acks_rec.price_list_id(i));
824:
825: l_line_acks_rec.salesrep(i) := OE_Id_To_Value.salesrep
826: (p_salesrep_id => l_line_acks_rec.salesrep_id(i));

Line 825: l_line_acks_rec.salesrep(i) := OE_Id_To_Value.salesrep

821:
822: l_line_acks_rec.price_list(i) := OE_Id_To_Value.price_list
823: (p_price_list_id => l_line_acks_rec.price_list_id(i));
824:
825: l_line_acks_rec.salesrep(i) := OE_Id_To_Value.salesrep
826: (p_salesrep_id => l_line_acks_rec.salesrep_id(i));
827:
828: l_line_acks_rec.fob_point(i) := OE_Id_To_Value.Fob_Point
829: (p_Fob_Point_code => l_line_acks_rec.fob_point_code(i));

Line 828: l_line_acks_rec.fob_point(i) := OE_Id_To_Value.Fob_Point

824:
825: l_line_acks_rec.salesrep(i) := OE_Id_To_Value.salesrep
826: (p_salesrep_id => l_line_acks_rec.salesrep_id(i));
827:
828: l_line_acks_rec.fob_point(i) := OE_Id_To_Value.Fob_Point
829: (p_Fob_Point_code => l_line_acks_rec.fob_point_code(i));
830:
831: l_line_acks_rec.freight_terms(i) := OE_Id_To_Value.freight_terms
832: (p_freight_terms_code => l_line_acks_rec.freight_terms_code(i));

Line 831: l_line_acks_rec.freight_terms(i) := OE_Id_To_Value.freight_terms

827:
828: l_line_acks_rec.fob_point(i) := OE_Id_To_Value.Fob_Point
829: (p_Fob_Point_code => l_line_acks_rec.fob_point_code(i));
830:
831: l_line_acks_rec.freight_terms(i) := OE_Id_To_Value.freight_terms
832: (p_freight_terms_code => l_line_acks_rec.freight_terms_code(i));
833:
834: l_line_acks_rec.Agreement(i) := OE_Id_To_Value.Agreement
835: (p_agreement_id => l_line_acks_rec.agreement_id(i));

Line 834: l_line_acks_rec.Agreement(i) := OE_Id_To_Value.Agreement

830:
831: l_line_acks_rec.freight_terms(i) := OE_Id_To_Value.freight_terms
832: (p_freight_terms_code => l_line_acks_rec.freight_terms_code(i));
833:
834: l_line_acks_rec.Agreement(i) := OE_Id_To_Value.Agreement
835: (p_agreement_id => l_line_acks_rec.agreement_id(i));
836:
837: l_line_acks_rec.payment_term(i) := OE_Id_To_Value.payment_term
838: (p_payment_term_id => l_line_acks_rec.payment_term_id(i));

Line 837: l_line_acks_rec.payment_term(i) := OE_Id_To_Value.payment_term

833:
834: l_line_acks_rec.Agreement(i) := OE_Id_To_Value.Agreement
835: (p_agreement_id => l_line_acks_rec.agreement_id(i));
836:
837: l_line_acks_rec.payment_term(i) := OE_Id_To_Value.payment_term
838: (p_payment_term_id => l_line_acks_rec.payment_term_id(i));
839:
840: If l_debug_level > 0 Then
841: Oe_Debug_Pub.Add('Before end customer derivation for lines1');

Line 845: Oe_Id_To_Value.End_Customer( p_end_customer_id => l_line_acks_rec.end_customer_id(i)

841: Oe_Debug_Pub.Add('Before end customer derivation for lines1');
842: End If;
843:
844:
845: Oe_Id_To_Value.End_Customer( p_end_customer_id => l_line_acks_rec.end_customer_id(i)
846: , x_end_customer_name => l_line_acks_rec.end_customer_name(i)
847: , x_end_customer_number => l_line_acks_rec.end_customer_number(i)
848: );
849:

Line 856: l_line_acks_rec.end_customer_contact(i) := Oe_Id_To_Value.End_Customer_Contact(p_end_customer_contact_id => l_line_acks_rec.end_customer_contact_id(i));

852: Oe_Debug_Pub.Add('Before end customer derivation for lines2');
853: End If;
854:
855:
856: l_line_acks_rec.end_customer_contact(i) := Oe_Id_To_Value.End_Customer_Contact(p_end_customer_contact_id => l_line_acks_rec.end_customer_contact_id(i));
857:
858:
859: If l_debug_level > 0 Then
860: Oe_Debug_Pub.Add('Before end customer derivation for lines3');

Line 863: OE_ID_TO_VALUE.End_Customer_Site_Use( p_end_customer_site_use_id => l_line_acks_rec.end_customer_site_use_id(i)

859: If l_debug_level > 0 Then
860: Oe_Debug_Pub.Add('Before end customer derivation for lines3');
861: End If;
862:
863: OE_ID_TO_VALUE.End_Customer_Site_Use( p_end_customer_site_use_id => l_line_acks_rec.end_customer_site_use_id(i)
864: , x_end_customer_address1 => l_line_acks_rec.end_customer_address1(i)
865: , x_end_customer_address2 => l_line_acks_rec.end_customer_address2(i)
866: , x_end_customer_address3 => l_line_acks_rec.end_customer_address3(i)
867: , x_end_customer_address4 => l_line_acks_rec.end_customer_address4(i)