AP Table Handler 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!).

1] AP_AI_TABLE_HANDLER_PKG:

• Procedure Insert_Row:  Inserts a row in AP_INVOICES_ALL table.
• Procedure Update_Row:  Updates a row in AP_INVOICES_ALL table.
• Procedure 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.

2] AP_AIL_TABLE_HANDLER_PKG:

• Procedure CHECK_UNIQUE: Check the Uniqueness of a Row.
• Procedure Insert_Row:  Inserts a row in AP_INVOICE_LINES_ALL table.
• Procedure Update_Row:  Updates a row in AP_INVOICE_LINES_ALL table.
• Procedure Delete_Row:  Deletes a row in AP_INVOICE_LINES_ALL table. Also subsequently delete rows in the related tables like AP_INVOICE_DISTRIBUTIONS_ALL.

3] AP_AID_TABLE_HANDLER_PKG:

• Procedure CHECK_UNIQUE: Check the Uniqueness of a Row.
• Procedure Insert_Row:  Inserts a row in AP_INVOICE_DISTRIBUTIONS table.
• Procedure Update_Row:  Updates a row in AP_INVOICE_DISTRIBUTIONS table.
• Procedure Delete_Row:  Deletes a row in AP_INVOICE_DISTRIBUTIONS table.

4] AP_AIP_TABLE_HANDLER_PKG:

• Procedure Insert_Row:  Inserts a row in AP_INVOICE_PAYMENTS table.
• Procedure Update_Amounts: Update amounts in AP_INVOICE_PAYMENTS table.

5] AP_AC_TABLE_HANDLER_PKG:

• Procedure Insert_Row:  Inserts a row in AP_CHECKS_ALL table.
• Procedure Update_Row:  Updates a row in AP_CHECKS table.
• Procedure Delete_Row:  Deletes a row in AP_CHECKS table.
• Procedure Update_Amounts: Update amounts in AP_CHECKS table.