Category Archives: API

The insert_row APIs – is UNSUPPORTED APIs

If you think you can use any API with a procedure named ‘insert_row’ – pls. check this before you use it. The insert_row procedure is made for Orace Forms insert procedures. The insert_row is not a supported API, it will … Continue reading

Posted in API, Applications development, SQL | Comments Off on The insert_row APIs – is UNSUPPORTED APIs

3 new Oracle API Excel loads

3 New Oracle API Excel loads: Load Approved Supplier List/4.0.1 Load ASL using the PO_ASL_API_PUB.CREATE_UPDATE_ASL API. Download: Load Approved Supplier List – posted 10-12-2014 Load Blanket Sales Agreements/4.0.1 Load BSA using the OE_BLANKET_PUB.PROCESS_BLANKET API. NB: This template handles 5 segments … Continue reading

Posted in API, Templates, Uncategorized | Comments Off on 3 new Oracle API Excel loads

R12 – Complete list of supported API’s

In R11 api’s was found in irep – in R12 api’s are found in the database. The “7417 Prototype scripts for API’s – R12” zip file is generated using the proto sql scripts from the sql4oracle.zip file. Extract was generated using … Continue reading

Posted in API, Applications development, Developer Scripts, News, R12, SQL | Comments Off on R12 – Complete list of supported API’s

R11 – Complete list of supported API’s

4566 is the number of supported API’s in oracle applications as of today (according to www.irep.oracle.com 20-apr-2011). Prototype scripts and xls4oracle template scripts is now available in 2 zip files. Pls. goto Prototypes and Scripts for xls4oracle templates For R12 … Continue reading

Posted in API, Applications development, Dataload, Developer Scripts, News, Templates, Templates Development, xls4oracle | Comments Off on R11 – Complete list of supported API’s

R11 – Complete list of supported API’s

NB: This info is related to Release 11 – for a complete list of R12 API’s goto R12 API In R11 you could get the list from http://irep.oracle.com/index.html – but that is gone now. These extracts where made based on the old info: … Continue reading

Posted in API, Applications development, Templates Development, Uncategorized | Comments Off on R11 – Complete list of supported API’s

QP_MODIFIERS_PUB.PROCESS_MODIFIERS – Qualifiers

Qualifiers on header level can be create in one API call but to create a qualifier on modifier level, you need to have a second API call, using the return values from the first API: DECLARE – copyright 2008 – … Continue reading

Posted in API, Templates Development | Comments Off on QP_MODIFIERS_PUB.PROCESS_MODIFIERS – Qualifiers

Updated template: Load Pricelist Modifiers

The Load Pricelist Modifiers template has been updated. The plsql will handle sheet value inputs – that will fill the ID’s for API. In order to load line qualifiers, the modifier line must exist, so a second API call was … Continue reading

Posted in API, Templates Development | Comments Off on Updated template: Load Pricelist Modifiers

Developing the Pricelist Modifiers Template

The template is calling the QP_MODIFIERS_PUB.PROCESS_MODIFIERS API. This API can create pricelist modifiers, modifier lines and qualifiers. The modifier header is a record structure, while the rest is plsql tables. The API works very much like the form interface, so … Continue reading

Posted in API, Templates Development | Comments Off on Developing the Pricelist Modifiers Template