Column Actions

Link Text: #ENAME#
Target: URL
URL: javascript:$.event.trigger('DAEvent','#EMPNO#');

When:

Event: Custom
Custom Event: DAEvent
Selection Type: DOM Object
DOM Object: document
Condition: - No Condition -

True Actions:

Sequence: 20
Action: Set Value
Set Type: JavaScript Expression
JavaScript Expression: this.data
Selection Type: Item(s)
Item(s): P82_EMPNO

Sequence:30
Action:Execute PL/SQL Code
PL/SQL Code:

SELECT e.ename,d,dname, e.sal
  INTO :P82_ENAME, :P82_DEPT, :P82_SAL
  FROM emp e, dept d
 WHERE e.deptno = d.deptno
   AND empno = :P82_EMPNO;

Page Items to Submit: P82_EMPNO
Page Items to Return: P82_ENAME,P82_DEPT,P82_SAL

Sequence: 40
Action: Show
Selection type: Region
Region: Emp Detail

Sequence: 50 Action: Hide
Selection type: Region
Region: Employees

When:

Event: Click
Selection Type: Button
Button: P82_UPDATE_SAL
Condition: - No Condition -

True Actions:

Sequence: 10
Action:Execute PL/SQL Code
PL/SQL Code:

UPDATE emp
  SET sal = :P82_SAL
 WHERE empno = :P82_EMPNO;

Page Items to Submit: P82_EMPNO,P82_SAL

Sequence: 20
Action: Alert
Text: Sal Updated

When:

Event: Click
Selection Type: Button
Button: BACK_TO_REPORT
Condition: - No Condition -

True Actions:

Sequence: 10
Action:Show
Selection Type: Region
Region: Employees

Sequence: 20
Action: Hide
Selection Type: Region
Fire On Page Load: [checked] (Hide the region when the page first loads)
Region: Emp Detail

Sequence: 30
Action: Refresh
Selection Type: Region
Region: Employees