Within APEX, there are a multitude of things you can use Check Boxes for, and many ways they
can be used to improve your application. This tutorial will focus on some of the things you can
use them for, as well as how to set their properties to make them work for you, not against you.
We recommend you review our article APEX Tutorial Preparation and OEHR Sample Data Install if
you haven’t already, as this tutorial requires the OEHR Sample Data to work properly.
Part 1 – Base Application, Form Editing and Display Changes
High Level Steps
1) Create and Test base Application. (0:35)
2) Edit the Update Form (3:15)
3) Change Report Display. (8:04)
Times in parenthesis are the approximate start times for those steps
Notes and Resources
The built in ‘DUAL’ table is a generic dummy table that allows you to perform set mathmatical
functions, or direct assignment of values using a SQL call. In this case we are force selecting
Y anywhere the values of the List and Min price meet the conditions in the WHERE clause.
Code and Entered Text
New Item Name, it’s LOV, Attribute Label and Source SQL Query
SELECT 'Y' FROM DUAL WHERE :P2_LIST_PRICE*0.75=:P2_MIN_PRICE
Process Name, SQL code, Success, Failure Messages, and Conditions.
Product successfully updated.
Unable to update this product. Contact your system administrator.
Label and LOV for P2_SET_MIN_PRICE
STATIC: <b> Set Minimum Price</b>
(25% Discount on List Price);Y