DBA Data[Home] [Help]

APPS.OE_UPDATE_ACK_UTIL dependencies on OE_XML_PROCESS_UTIL

Line 460: Oe_Xml_Process_Util.Get_Address_details

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

Line 477: Oe_Xml_Process_Util.Get_Contact_Details

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

Line 495: Oe_Xml_Process_Util.Get_Address_details

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

Line 512: Oe_Xml_Process_Util.Get_Contact_Details

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

Line 530: Oe_Xml_Process_Util.Get_Address_details

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

Line 547: Oe_Xml_Process_Util.Get_Contact_Details

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

Line 564: Oe_Xml_Process_Util.Get_Address_details

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

Line 885: Oe_Xml_Process_Util.Get_Address_details

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

Line 902: Oe_Xml_Process_Util.Get_Contact_Details

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

Line 921: Oe_Xml_Process_Util.Get_Address_details

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

Line 950: Oe_Xml_Process_Util.Get_Address_details

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