Oracle AP Invoice APIs (Welcome to My Oracle World)

5/9/2014

Oracle AP Invoice APIs (Welcome to My Oracle World)

Oracle

Blogs Home Products & Services Downloads Support Partners Communities About Login Oracle Blog Welcome to My Oracle World Puneet Rajkumar

« Trading Community... | Community... | Main Main | | Compare Technical... » Technical... »

Oracle AP Invoice APIs By PRajkumar on Aug 15, 2012

These APIs are handful when you want to do Insert, Update or Delete programmatically for some business requirements (rare (rare cases!)

APII Name AP

AP_A _AII_TA TAB BLE_HANDLER_P _PK KG

API Name

Procedure Name

Description

insert_r _row ow

Inserts a row in AP_I _IN NVOICES_ALL

update_ e_rrow

Updates a row in in AP AP_INVOICES_A _ALLL

delete_row

Del ele etes a row in in AP_ AP_IINVOICES_AL ALLL. Al 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

Procedure Name

https://blogs.oracle.com/prajkumar/entry/oracle_ap_invoice_apis

Description

1/7

5/9/2014

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


2/7

5/9/2014


AP_CHECKS delete_row

Deletes a row in AP_CHECKS

update_amounts

Update amounts in AP_CHECKS

Category: Oracle Tags: oracle_ap_invoice_apis Permanent link to this entry « Trading Community... | Main | Compare Technical... » Comments: Post a Comment: Name: guest E-Mail: URL: Notify me by email of new comments Remember Information?

Your Comment: HTML Syntax: NOT allowed Please answer this simple math question 7 + 28 = Preview

Post

About


3/7

5/9/2014


Puneet Rajkumar Search

Enter search term: Search only this blog Recent Posts

Under Maintenance Oracle External Bank Payment APIs API to Create External Bank Branch API to Create Bank API to Create AP Supplier Site Oracle AP Supplier APIs API to Create AP Supplier OTBI Developer Guide OTBI vs. OBIA Oracle Application in DMZ (Demilitarized Zone) Top Tags

add_resp_to_fnd_user adf_developer_guide adf_helloworld_tutorial am_extension_in_oaf api_create_external_bank_branch api_create_supp_bank api_supplier_site api_to_create_ap_supplier api_to_create_fnd_user autocustomize_oaf_search_page bounce_apache_server call call_d2k_form_from_oaf_page clear_result_table_in_oaf commit_in_sql controller_extension_in_oaf cr_upd_emp_phone_detail cr_upd_emp_salary create_emp_payment_method create_employee_address create_employee_api create_employee_contact create_employee_element_entry create_lov_in_adf_application https://blogs.oracle.com/prajkumar/entry/oracle_ap_invoice_apis

4/7

5/9/2014


create_master_detail_form_in_oracle_adf create_oaf_search_page create_simple_search_form_in_oracle_adf create_state_tax_rule create_update_on_one_click d2k data_entry_form_in_adf delete_employee_element_entry delete_records_in_oaf_page dependent_lov_in_oaf deploy_oaf_page download_conc_prog_ldt_using_shell_script enable_diagnostics_in_oracle_apps enable_personalization_link_oaf end_date_resp_for_fnd_user entity_object_extension_in_oaf eo_based_vo_extension_oaf execute_parameterized_plsql_procedure external_bank_payment_apis form from host_name_url_of_oaf_page hrms_hire_into_job_api implement_poplist_in_oa_framework implement_train_in_oaf_page implementing_external_lov_in_oaf Categories

Oracle Personal Archives

« September 2014 Sun Mon Tue Wed Thu Fri Sat 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Today Bookmarks

Apps Tecnical Terms VS Real Time Oracle Technology Network Blog Techi Corner Technology Newsletters Trading Community Architecture (TCA) https://blogs.oracle.com/prajkumar/entry/oracle_ap_invoice_apis

5/7

5/9/2014


Developer Guides

ADF Developer Guide OAF Developer Guide OTBI Developer Guide Personalization/Extensions for OAF Oracle APIs

Oracle AP Invoice APIs Oracle AP Supplier APIs Oracle External Bank Payment APIs Oracle FND User APIs Oracle HRMS APIs New Blogs

Stay Connected

Menu

Blogs Home Weblog Login Feeds

RSS

All /Oracle /Personal Comments Atom

All /Oracle /Personal Comments https://blogs.oracle.com/prajkumar/entry/oracle_ap_invoice_apis

6/7

5/9/2014


The views expressed on this blog are those of the author and do not necessarily reflect the views of Oracle. Terms of Use | Your Privacy Rights | Cookie Preferences


7/7

Oracle AP Invoice APIs (Welcome to My Oracle World)

Recommend Documents