OracleAPInvoiceAPIs
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 updat
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 |