1. Create a new Javascript function

<script language="JavaScript" type="text/javascript"> function make_existing_column_readonly() { if (document.wwv_flow.f02) { // Check to see at least one present var l = document.wwv_flow.f02.length; if (l == undefined) { // Have only one record var curr_id = document.wwv_flow.f02.id; $x(curr_id).readOnly = "readonly"; $x(curr_id).style.background = "silver"; } else { // Having multiple records for (var i = 0; i < l; i++) { var curr_id = document.wwv_flow.f02[i].id; if ($x(curr_id).value != "") { $x(curr_id).readOnly = "readonly"; $x(curr_id).style.background = "silver"; } } } } } </script>

Sample here is just to make one field (EName) read-only. Obviously more fields can be added if needed. To find out what number of wwv_flow.fxx is, please see Which Tabular Form Column is mapped to which Apex_Application.g_fxx array? by Patrick Wolf

The "silver" color is added to make it noticeable as read-only. More sample of attributes of document.wwv_flow.fxx can be found at Denes Kubieck's Demo under Code section.

2. Call this function from page's onload under the HTML Body Attribute.

onload="make_existing_column_readonly();"

No-Duplication Validation

Create a new page-level validation with PL/SQL and Function Returning Error Text.

BEGIN FOR i IN 1 .. apex_application.g_f02.COUNT-1 LOOP IF upper(apex_application.g_f02(i)) = upper(apex_application.g_f02(apex_application.g_f02.COUNT)) THEN RETURN 'Employee Name <b>' || apex_application.g_f02(apex_application.g_f02.COUNT) || '</b> already exists.'; END IF; END LOOP; RETURN NULL; END;

Please see above link about g_fxx.

Pop-up Help

1. Create the following Javascript functions.

function findPosX(obj) // Get full right offset { var curleft = 0; if (obj.offsetParent) { while (obj.offsetParent) { curleft += obj.offsetLeft obj = obj.offsetParent; } } else if (obj.x) curleft += obj.x; return curleft; } function findPosY(obj) // Get full top offset { var curtop = 0; if (obj.offsetParent) { while (obj.offsetParent) { curtop += obj.offsetTop obj = obj.offsetParent; } } else if (obj.y) curtop += obj.y; return curtop; } function ShowPopup(hv_item, hv_pop) { hp = document.getElementById(hv_pop); // Set position of hover-over popup hp.style.top = findPosY(hv_item) - 20; hp.style.left = findPosX(hv_item) + 120; // Set popup to visible hp.style.visibility = "Visible"; } function HidePopup(hv_pop) { hp = document.getElementById(hv_pop); hp.style.visibility = "Hidden"; }

2. Create the HTML div tag with a defined ID in any HTML region. This will be the help text information. Note that initially it is hidden.

<div id="hv_message" style="visibility:hidden; position:absolute;"> <table bgcolor="gray"> <tr> <td width=200 align="center"><font color="white">NOTE on ENAME column</font></td> </tr> <tr> <td width=200 align="center" bgcolor="white">This EName column is protected (modifiable by authorized users only). Duplicate employee name is not allowed.</td> </tr></table> </div>

3. Add the following Javascript events to the Element Attributes of the Ename column. Please note that the event will call for the HTML div ID created in the previous step.

onMouseOver="ShowPopup(this,'hv_message');" onMouseOut="HidePopup('hv_message');"