Featured

Oracle APEX 21.2 | Create Setup Form | Employee | Part 2



Published
Today we learn how to create "Employee Setup Page/Form" in an Oracle APEX 21.2 InshaAllah. part 2

Thought # 4

Patreon: https://www.patreon.com/OmarBaig

1. Create Alert
a. Click on "CANCEL" button, scroll down till we find "Behavior", select "Defined by Dynamic Action" from "Action" drop down.
b. Right Click on "CANCEL" button & select "Create Dynamic Action", name it (Alert) under "Dynamic Action"
c. Select "Click" from "Event" drop down under "When"
d. Expand "Alert", "True" option, click on "Show", select "Execute JavaScript Code" from "Action" drop down under "Identification"
e. Provide code on "Code" area under "Settings"
apex.confirm("Are you sure you want to Exit?", "CANCEL");
f. Click on "Processing" tab, right click on "After Submit" & select "Create Branch", name it (Go To Page # 4)
g. Click on "No Link Defined" along with "Target" area under "Behavior", Select "4" from "Page" under "Target" & hit "OK" button.
h. Select "CANCEL" from "When Button Pressed" drop down, "Type" is "Request = Value", & "Value" is "CANCEL" under "Server-side Condition"

2. Create LOV
JOB
a. Come to "Shared Components" tab.
b. Right Click on "Lists of Values" under "Navigation Bar" & select "Create..." option.
c. "From Scratch" hit "Next" button.
d. Define name from your choice (JOB)
e. "Type:" is "Dynamic", hit "Next" button.
f. Data Source, & Source Type is "Local Database", and "Table" respectively. (you can select "SQL Query" as well)
g. "Table / View Owner" is HR (it is schema owner)
h. Select "JOBS" from "Table / View Name" drop down, hit "Next" button.
i. Select "JOB_ID" from "Return Column" & "JOB_TITLE" from "Display Column" drop down, hit "Create" button.
j. Come to "Rendering" tab.
k. Click on "P5_JOB_ID" & select "Popup LOV" from "Type" drop down.
l. "Search as You Type" is "On", "Green Colour" indicate it is "On".
m. Define "Title" from your choice (Designation) under "Settings"
n. Select "Shared Components" from "Type", & "JOB" from "List of Values" drop down.
o. "Display Extra Values" is "Off", "Gray Colour" indicate it is "Off"
p. Define "- Select Designation -" to "Null Display Value" under "List of Values", hit "SAVE" button.

MANAGER
q. Repeat point "a-c" and "e"
r. Define name from your choice (MANAGER)
s. Data Source, & Source Type is "Local Database", & "SQL Query" respectively.
SELECT DISTINCT e.manager_id, m.last_name
FROM employees e, employees m
WHERE m.employee_id = e.manager_id
hit "Next" button.
t. Select "MANAGER_ID" from "Return Column" & "LAST_NAME" from "Display Column" drop down, hit "Create" button.
u. Repeat point "j, l, o"
v. Click on "P5_MANAGER_ID" & select "Popup LOV" from "Type" drop down.
w. Define "Title" from your choice (Manager) under "Settings"
x. Select "Shared Components" from "Type", & "MANAGER" from "List of Values" drop down.
y. Define "- Select Manager -" to "Null Display Value" under "List of Values", hit "SAVE" button.

DEPARTMENT
z. Repeat point "a-c" and "e-g"
za. Define name from your choice (DEPARTMENT)
zb. Select "DEPARTMENTS" from "Table / View Name" drop down, hit "Next" button.
zc. Select "DEPARTMENT_ID" from "Return Column" & "DEPARTMENT_NAME" from "Display Column" drop down, hit "Create" button.
zd. Repeat point "j, l, o"
ze. Click on "P5_DEPARTMENT_ID" & select "Popup LOV" from "Type" drop down.
zf. Define "Title" from your choice (Department) under "Settings"
zg. Select "Shared Components" from "Type", & "DEPARTMENT" from "List of Values" drop down.
zh. Define "- Select Department -" to "Null Display Value" under "List of Values"
zi. Press "Save and Run Page (Alt+F8)"
Category
Job
Be the first to comment