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 593: l_header_acks_rec.order_type := Oe_Id_To_Value.Order_Type

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

Line 597: l_header_acks_rec.price_list := Oe_Id_To_Value.Price_List

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

Line 601: l_header_acks_rec.payment_term := Oe_Id_To_Value.Payment_Term

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

Line 605: l_header_acks_rec.salesrep := Oe_Id_To_Value.Salesrep

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

Line 609: l_header_acks_rec.fob_point := Oe_Id_To_Value.Fob_Point

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

Line 613: l_header_acks_rec.freight_terms := Oe_Id_To_Value.Freight_Terms

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

Line 617: l_header_acks_rec.agreement := Oe_Id_To_Value.Agreement

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

Line 621: l_header_acks_rec.conversion_type := Oe_Id_To_Value.Conversion_Type

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

Line 625: l_header_acks_rec.tax_exempt_reason := Oe_Id_To_Value.Tax_Exempt_Reason

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

Line 629: l_header_acks_rec.tax_point := Oe_Id_To_Value.Tax_Point

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

Line 633: l_header_acks_rec.invoicing_rule := Oe_Id_To_Value.Invoicing_Rule

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

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

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

Line 656: 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);

652: Oe_Debug_Pub.Add('Before end customer derivation for header2');
653: End If;
654:
655: If l_header_acks_rec.end_customer_contact_id Is Not Null Then
656: 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);
657: End If;
658:
659:
660:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 857: 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));

853: Oe_Debug_Pub.Add('Before end customer derivation for lines2');
854: End If;
855:
856:
857: 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));
858:
859:
860: If l_debug_level > 0 Then
861: Oe_Debug_Pub.Add('Before end customer derivation for lines3');

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

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