These APIs are handful when you want to do Insert, Update or Delete programmatically for some business requirements (rare cases!)

API Name	Procedure Name	Description
AP_AI_TABLE_HANDLER_PKG	insert_row	Inserts a row in AP_INVOICES_ALL
	update_row	Updates a row in AP_INVOICES_ALL
	delete_row	Deletes a row in AP_INVOICES_ALL. Also subsequently delete rows in the related tables like AP_INVOICE_LINES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, AP_PAYMENT_SCHEDULES_ALL, AP_HOLDS_ALL and AP_SELF_ASSESSED_TAX_DIST_ALL

API Name	Procedure Name	Description
AP_AIL_TABLE_HANDLER_PKG	check_unique	Check the Uniqueness of a Row
	insert_row	Inserts a row in AP_INVOICE_LINES_ALL
	update_row	Updates a row in AP_INVOICE_LINES_ALL
	delete_row	Deletes a row in AP_INVOICE_LINES_ALL. Also subsequently delete rows in the related tables like AP_INVOICE_DISTRIBUTIONS_ALL

API Name	Procedure Name	Description
AP_AID_TABLE_HANDLER_PKG	check_unique	Check the Uniqueness of a Row
	insert_row	Inserts a row in AP_INVOICE_DISTRIBUTIONS
	update_row	Updates a row in AP_INVOICE_DISTRIBUTIONS
	delete_row	Deletes a row in AP_INVOICE_DISTRIBUTIONS

API Name	Procedure Name	Description
AP_AIP_TABLE_HANDLER_PKG	insert_row	Inserts a row in AP_INVOICE_PAYMENTS
	update_amounts	Update amounts in AP_INVOICE_PAYMENTS

ITPub博客

Oracle AP Invoice APIs