Oracle EBS AP Invoice APIs
Oracle EBS AP Invoice APIs
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 |
-- 刘轶鹤转