These APIs are handful when you want to do Insert, Update or Deleteprogrammatically 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 |
转自http://www.unitask.com/oracledaily/2012/08/15/oracle-ap-invoice-apis/
762
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
