Wednesday Aug 15, 2012

Oracle AP Invoice APIs

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

 

Trading Community Architecture (TCA)

Trading Community Architecture (TCA) is an architecture concept designed to support complex trading communities. 

 

 

About

Welcome to My Oracle World Puneet Rajkumar

Search

Categories
Archives
« August 2012 »
SunMonTueWedThuFriSat
   
2
3
5
7
8
9
10
11
12
13
14
16
17
19
20
21
22
23
24
25
26
27
28
29
30
31
 
       
Today