Forms and Reports—The Basics - Beginning Oracle Application Express 4.2 - page 111

In the Page Rendering section of the Application Builder, you have two items, P3_FROM and P3_BODY,
corresponding to your two form fields, From and Body. There are two buttons, CANCEL and SUBMIT.
In the Page Processing section are a process and a branch. However, the process is a different type—a PL/SQL
anonymous block. This powerful type of process executes the PL/SQL procedure specified in the Source element.
The PL/SQL procedure can be a stored PL/SQL procedure or an anonymous PL/SQL block, as long as the code is
syntactically correct between a BEGIN statement and an END statement. In this case, the process calls the CONTACT_US
procedure using the P3_FROM and P3_BODY item values as input parameters. The body of the CONTACT_US procedure
is what creates and sends an e-mail. Thus, the key difference between the form on a table and the form on a procedure
is in the Page Processing process that is executed on a click of the Create button. The APEX wizard has automatically
provided the process type required for the selected form type.
The Shared Components region contains the standard entries for the table, breadcrumb and page, tab, region,
label, and button templates, the same as for the form on a table. Again, it was nice of the form wizard to create all
these elements for you.

Master-Detail Report and Form
One of the most popular features in APEX is the Master Detail Form Wizard. With a single, simple wizard, you can
quickly create a report and corresponding forms to manage data stored in a master-detail fashion. Let's use this
wizard to create a report and forms for the TICKETS and TICKET_DETAILS tables.

Creating a Master-Detail Report and Form
First, you create the report and form on application pages 200, 210, and 220. Because you don't yet have those pages
created, the wizard does that for you.

■ earlier you created the Actions menu on the Global page and made it conditionally show only when the current
page number was less than 100. From now on, you'll assign numbers greater than 100 to all the pages so the Actions
menu doesn't appear.

Note

1.

Run any page in your application.

2.

Click Create on the Developer toolbar .

3.

Select New Page , and click Next .

4.

Select Form , and click Next .

5.

Select Master Detail Form , and click Next .

6.

See Figure 6-24 . Set Table/View Owner to your schema. Set Table/View Name to
TICKETS (table) . When the page refreshes, all the columns from the table are selected by
default. Click Next .