18.2.1 Setting Up Context After Submit

Set hidden page items after submit so later processing steps can use the selected employee context.

When a user clicks the (Process) button to submit the page, an After Submit process Get Employee Name and Email retrieves the employee's name and email into two hidden page items using the selected employee id with the query:

select ename, :G_DEMO_EMAIL
  into :P34_EMPLOYEE_ENAME, :P34_EMPLOYEE_EMAIL
  from eba_demo_emp
 where empno = :P34_EMPLOYEE_EMPNO

Various steps of the page processing logic below reference these hidden page item values, along with the value of the P34_EMPLOYEE_EMPNO Select One page item the user uses to pick an employee to process.