APPS.OE_UPDATE_ACK_UTIL dependencies on OE_XML_PROCESS_UTIL

Line 461: Oe_Xml_Process_Util.Get_Address_details

457: And b.site_use_code = 'SOLD_TO'
458: And b.primary_flag = 'Y'
459: And b.status = 'A';
460:
461: Oe_Xml_Process_Util.Get_Address_details
462: (p_site_use_id => l_sold_to_site_use_id,
463: p_site_use_code => 'SOLD_TO',
464: x_location => l_sold_to_location,
465: x_address1 => l_header_acks_rec.sold_to_address1,

Line 478: Oe_Xml_Process_Util.Get_Contact_Details

474: x_customer_name => l_header_acks_rec.sold_to_org,
475: x_return_status => l_return_status);
476:
477: If l_header_acks_rec.sold_to_contact_id Is Not Null Then
478: Oe_Xml_Process_Util.Get_Contact_Details
479: (p_contact_id => l_header_acks_rec.sold_to_contact_id,
480: p_cust_acct_id => l_header_acks_rec.sold_to_org_id,
481: x_first_name => l_header_acks_rec.sold_to_contact_first_name,
482: x_last_name => l_header_acks_rec.sold_to_contact_last_name,

Line 496: Oe_Xml_Process_Util.Get_Address_details

492:
493: -- Get Ship To info
494: Begin
495: If l_header_acks_rec.ship_to_org_id Is Not Null Then
496: Oe_Xml_Process_Util.Get_Address_details
497: (p_site_use_id => l_header_acks_rec.ship_to_org_id,
498: p_site_use_code => 'SHIP_TO',
499: x_location => l_header_acks_rec.ship_to_address_code,
500: x_address1 => l_header_acks_rec.ship_to_address_1,

Line 513: Oe_Xml_Process_Util.Get_Contact_Details

509: x_customer_name => l_header_acks_rec.ship_to_org,
510: x_return_status => l_return_status);
511: End If;
512: If l_header_acks_rec.ship_to_contact_id Is Not Null Then
513: Oe_Xml_Process_Util.Get_Contact_Details
514: (p_contact_id => l_header_acks_rec.ship_to_contact_id,
515: p_cust_acct_id => l_header_acks_rec.sold_to_org_id,
516: x_first_name => l_header_acks_rec.ship_to_contact_first_name,
517: x_last_name => l_header_acks_rec.ship_to_contact_last_name,

Line 531: Oe_Xml_Process_Util.Get_Address_details

527:
528: -- Get Invoice To info
529: Begin
530: If l_header_acks_rec.invoice_to_org_id Is Not Null Then
531: Oe_Xml_Process_Util.Get_Address_details
532: (p_site_use_id => l_header_acks_rec.invoice_to_org_id,
533: p_site_use_code => 'BILL_TO',
534: x_location => l_invoice_to_location,
535: x_address1 => l_header_acks_rec.invoice_address_1,

Line 548: Oe_Xml_Process_Util.Get_Contact_Details

544: x_customer_name => l_header_acks_rec.invoice_to_org,
545: x_return_status => l_return_status);
546: End If;
547: If l_header_acks_rec.invoice_to_contact_id Is Not Null Then
548: Oe_Xml_Process_Util.Get_Contact_Details
549: (p_contact_id => l_header_acks_rec.invoice_to_contact_id,
550: p_cust_acct_id => l_header_acks_rec.sold_to_org_id,
551: x_first_name => l_header_acks_rec.invoice_to_contact_first_name,
552: x_last_name => l_header_acks_rec.invoice_to_contact_last_name,

Line 565: Oe_Xml_Process_Util.Get_Address_details

561:
562: -- Get Ship From info
563: Begin
564: If l_header_acks_rec.ship_from_org_id Is Not Null Then
565: Oe_Xml_Process_Util.Get_Address_details
566: (p_site_use_id => l_header_acks_rec.ship_from_org_id,
567: p_site_use_code => 'SHIP_FROM',
568: x_location => l_ship_from_location,
569: x_address1 => l_header_acks_rec.ship_from_address_1,

Line 886: Oe_Xml_Process_Util.Get_Address_details

882:
883: -- Get Ship To info
884: Begin
885: If l_line_acks_rec.ship_to_org_id(i) Is Not Null Then
886: Oe_Xml_Process_Util.Get_Address_details
887: (p_site_use_id => l_line_acks_rec.ship_to_org_id(i),
888: p_site_use_code => 'SHIP_TO',
889: x_location => l_line_acks_rec.ship_to_address_code(i),
890: x_address1 => l_line_acks_rec.ship_to_address1(i),

Line 903: Oe_Xml_Process_Util.Get_Contact_Details

899: x_customer_name => l_line_acks_rec.ship_to_org(i),
900: x_return_status => l_return_status);
901: End If;
902: If l_line_acks_rec.ship_to_contact_id(I) Is Not Null Then
903: Oe_Xml_Process_Util.Get_Contact_Details
904: (p_contact_id => l_line_acks_rec.ship_to_contact_id(i),
905: p_cust_acct_id => l_sold_to_org_id,
906: x_first_name => l_line_acks_rec.ship_to_contact_first_name(i),
907: x_last_name => l_line_acks_rec.ship_to_contact_last_name(i),

Line 922: Oe_Xml_Process_Util.Get_Address_details

918: /*
919: -- Get Invoice To info
920: Begin
921: If l_line_acks_rec.invoice_to_org_id(i) Is Not Null Then
922: Oe_Xml_Process_Util.Get_Address_details
923: (p_site_use_id => l_line_acks_rec.invoice_to_org_id(i),
924: p_site_use_code => 'BILL_TO',
925: x_location => l_line_acks_rec.invoice_address_code(i),
926: x_address1 => l_line_acks_rec.invoice_to_address1(i),

Line 951: Oe_Xml_Process_Util.Get_Address_details

947:
948: -- Get Ship From info
949: Begin
950: If l_line_acks_rec.ship_from_org_id Is Not Null Then
951: Oe_Xml_Process_Util.Get_Address_details
952: (p_site_use_id => l_line_acks_rec.ship_from_org_id(i),
953: p_site_use_code => 'SHIP_FROM',
954: x_location => l_ship_from_location,
955: x_address1 => l_line_acks_rec.ship_from_address_1(i),