Rarely Used Account Payables APIs

These APIs are handful when you want to do Insert, Update or Delete in some AP Base tables

i.e. AP_INVOICES_ALL, AP_INVOICE_LINES_ALL, AP_INVOICE_DISTRIBUTIONS, AP_INVOICE_PAYMENTS and AP_CHECKS_ALL programmatically for some business requirements (rare cases!).

Package 

Procedure 

Comments 

AP_AI_TABLE_HANDLER_PKG Insert_Row Inserts a row in AP_INVOICES_ALL table
Update_Row  Updates a row in AP_INVOICES_ALL table
Delete_Row  Deletes a row in AP_INVOICES_ALL table. 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
AP_AIL_TABLE_HANDLER_PKG CHECK_UNIQUE Check the Uniqueness of a Row
Insert_Row Inserts a row in AP_INVOICE_LINES_ALL table
Update_Row Updates a row in AP_INVOICE_LINES_ALL table
Delete_Row Deletes a row in AP_INVOICE_LINES_ALL table. Also subsequently delete rows in the related tables like AP_INVOICE_DISTRIBUTIONS_ALL
AP_AID_TABLE_HANDLER_PKG CHECK_UNIQUE Check the Uniqueness of a Row
Insert_Row Inserts a row in AP_INVOICE_DISTRIBUTIONS table
Update_Row Updates a row in AP_INVOICE_DISTRIBUTIONS table
Delete_Row Deletes a row in AP_INVOICE_DISTRIBUTIONS table
AP_AIP_TABLE_HANDLER_PKG Insert_Row Inserts a row in AP_INVOICE_PAYMENTS table
Update_Amounts Update amounts in AP_INVOICE_PAYMENTS table
AP_AC_TABLE_HANDLER_PKG Insert_Row Inserts a row in AP_CHECKS_ALL table
Update_Row Updates a row in AP_CHECKS table
Delete_Row Deletes a row in AP_CHECKS table
Update_Amounts Update amounts in AP_CHECKS table

Leave a Reply

Your email address will not be published. Required fields are marked *