PO Interface Tables

If some customized system have the data and we want to Generate the interface of PO and to generate the PO directly in Oracle Purchasing; means we enter the data in our system and want a interface that directly generate the entry in PO tables, two interface tables are involved PO_HEADERS_INTERFACE and PO_LINES_INTERFACE:

INSERT INTO po.po_headers_interface
(interface_header_id, batch_id, process_code,
note_to_vendor, action, document_type_code,
currency_code, payment_terms,closed_code,
created_by, rate_type,  rate_date, rate,
agent_name, agent_id, vendor_id,  vendor_site_id,
ship_to_location_id, bill_to_location_id)
———-

INSERT INTO po.po_lines_interface
(interface_line_id,
interface_header_id, line_num,
line_type, item_id, item_description,
unit_of_measure, quantity,
unit_price, promised_date,
ship_to_organization_id,
ship_to_location_id,
closed_code,
created_by,
list_price_per_unit)
———–