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 |
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 |