1. Log in to Oracle with the Application Developer responsibility.

2. Navigate to Application | Validation | Set and the Values Sets window will open.

3. Enter the details as shown in the following table:

4. Click on the Edit Information button and the Validation Table Information window will open.

5. Enter the details as shown in the following table:

6. Click the Save button in the toolbar (or Ctrl + S) to save the record.

7. Click on the Test button to test the code entered.

1. Log in to Oracle with the Application Developer responsibility.

2. Navigate to Concurrent | Program and the Concurrent Programs window will open.

3. Press the F11 key to enter a query.

4. Query back the XXHR First Concurrent Program concurrent program and click the parameters button.

5. Add a new parameter with the following details:

Item name	Value
Seq	30
Parameter	P_PERSON_ID
Description	Person ID
Enabled
Value Set	XXHR_PERSON_DEP_VS
Default Type
Required
Display
Display Size	20
Description Size	50
Concatenated Description Size	25
Prompt	Person

1. Open SQL Developer and connect to the apps user.

2. Navigate to Packages and select the XXHREEBS package.

3. Now edit the package specification.

4. Scroll down the package specification until you reach the First_Concurrent_Program procedure definition.

5. Now add the parameter to the code AFTER the p_org_id parameter. The program definition will look like the following:

PROCEDURE First_Concurrent_Program (errbuf OUT VARCHAR2,
retcode OUT NUMBER,
p_run_date IN VARCHAR2,
p_org_id IN VARCHAR2,
p_person_id IN NUMBER);

6. Compile the package specification.

7. Open the package body to add the p_person_id parameter to the body.

8. Scroll down to the First_Concurrent_Program procedure definition and add p_person_id to the list of parameters, as shown in the following code:

PROCEDURE First_Concurrent_Program (errbuf OUT VARCHAR2,
retcode OUT NUMBER,
p_run_date IN VARCHAR2,
p_org_id IN VARCHAR2,
p_person_id IN NUMBER) IS

9. Compile the First_Concurrent_Program package body.

1. Log in to Oracle with the XXEBS Extending e-Business Suite responsibility.

2. Navigate to Submit Requests and submit a single request.

3. Select the XXHR First Concurrent Program concurrent program and leave the Run Date parameter set to the default date (which is the current date).

4. Select an organization from the list of values for the Organization parameter and then click OK. (If using a Vision instance select 'Vision Corporation', for example.)

5. Select an employee record from the list of values for the Person parameter and then click OK.

6. Click on the Submit button and when prompted to submit a new request select No and the form will close down.

7. Navigate to View Requests and click on the find button (to find all requests).

8. You should see that the concurrent program we just submitted has completed successfully. (If it is still Pending then click the refresh button until the status is Completed).