Populate Order Import Interface Tables From Existing Sales Order

Posted by: Edi Yanto on: January 26, 2012

• In: Uncategorized
• Comment!

The script below is used to populate the order import interface tables using data from an existing sales order.
Interface Tables:

OE_HEADERS_IFACE_ALL
OE_LINES_IFACE_ALL
OE_PRICE_ADJS_IFACE_ALL
OE_PAYMENTS_INTERFACE
OE_CREDITS_IFACE_ALL
OE_LOTSERIALS_IFACE_ALL

Base Tables:

OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
OE_PRICE_ADJUSTMENTS
OE_PAYMENTS
OE_SALES_CREDITS
OE_LOT_SERIAL_NUMBERS

Script:

DECLARE
l_return_status       VARCHAR2 (1);
l_order_number_from   NUMBER;
l_order_source_id     NUMBER;
BEGIN
oe_debug_pub.debug_on;
oe_debug_pub.initialize;
oe_inf_populate_pub.populate_interface (p_api_version_number      => 1.0,
x_return_status           => l_return_status,
p_order_number_from       => :p_order_number,
p_order_source_id         => :p_order_source_id
);
END;