Apply Hold on invoice via API.

I am in a process of writing interface for vendor invoices to AP invoices.

Data comes in text file. (tsv)

VENDOR	Invoice Date	Invoice #	Vendor Part Number	Description	Qty Invoiced	Purchase Order	Unit Price	Order Line Amount	Unit	invoice amount
MINT	11/1/16	1234	Junior_Mint098	Creamy mints in Pure Chocolate	10	PO1234	0.50	5	EA	7.5
MINT	11/1/16	1234	Double_Mint765	double mint	10	PO1234	0.25	2.5	EA	7.5

I have successfully created pl/sql program to map and parse the file and load it into - ap_invoices_interface and ap_invoice_lines_interface tables.

But I have a requirement to check if the item is setup in Oracle Inventory. For this I have setup Vendor Item XREF for each vendor part number so that I can get to the PO LINE.