Account Payable(AP) Invoice APIs -- Oracle Applications

These are handful in some cases only. When you are doing DML Operations (Insert, Update or Delete) programmatically for some business requirements. 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 API Name Procedure Name Description AP_AC_TABLE_HANDLER_PKG insert_row Inserts a row in AP_CHECKS_ALL update_row Updates a row in AP_CHECKS delete_row Deletes a row in AP_CHECKS update_amounts Update amounts in AP_CHECKS