I know that Web ADI allows you to call API's instead of interface tables. If the Oracle API has a pl/sql table type as a parameter, is it possible to use that API with Web ADI? Below is the oracle API that I would like to use that has the pl/sql table in the parameter.
MTL_CROSS_REFERENCES_PUB.PROCESS_XREF (p_api_version => 1.0
,p_init_msg_list => FND_API.G_TRUE
,p_commit => FND_API.G_TRUE
,p_xref_tbl => l_xrefs_tbl
,x_return_status => l_api_return_status
,x_msg_count => l_msg_count
,x_message_list => l_msg_list --l_msg_data
If this is supported any examples available would be great. Thanks for your responses.
AFAIK, there should be no issue in calling an API from WebADI.
What is the issue you have (error you get)?
If you are looking for some examples to use this API, please see these docs.
11i Is there any API to edit and delete Customer Item Cross References? [ID 577259.1]
Business Event - Oracle.Apps.Ego.Item.Postxrefchange Event Is Not Raising After Item Cross Reference Is Updated [ID 1153437.1]
Item Cross References API was not honoring INV: GTIN Cross Reference Type profile option value to take uom_code and revision_id. [ID 1473897.1]
The oracle API has a parameter p_xref_tbl that is a pl/sql table. I have seen examples of passing values from the ADI excel sheet to a character or numeric parameter. I am not sure how to do this for a pl/sql table.