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