Oracle E-Business Suite R12 Core Development and Extension Cookbook

Adding a function

We are now going to go back to our workflow and create a function to call a database procedure. The procedure will store the XML in a table, validate the structure of the XML, and store the XML values in attributes in the workflow. The first thing we need to do is create the attributes in the workflow that will store the XML attributes. We will then add the function to the workflow that will parse the XML and store the attributes.

The following are the tasks required to add a function to the workflow:

• Updating an employee record for testing
• Adding attributes
• Adding a function
• Testing the workflow

Updating an employee record for testing

Before we get going we need to create a test employee record. I used an existing employee in the ...