Heim > Datenbank > MySQL-Tutorial > Oracle AP Invoice APIs

Oracle AP Invoice APIs

WBOY
Freigeben: 2016-06-07 15:01:46
Original
1449 Leute haben es durchsucht

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

Verwandte Etiketten:
Quelle:php.cn
Erklärung dieser Website
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn
Beliebte Tutorials
Mehr>
Neueste Downloads
Mehr>
Web-Effekte
Quellcode der Website
Website-Materialien
Frontend-Vorlage