Thursday, September 18, 2014

Disable DFF Attributes in OAF Page

Diable DFF Attributes in OAF Page

Create a raw text item and give below java script.  Add 

SCRIPT type="text/javascript"

     var elementInDocument = function (element) {         while (element = element.parentNode) {             alert('ele ' + element);             alert('doc ' + document);             if (element == document) {                 return true;             }         }         return false;     };     if (elementInDocument("xxswCACPageNewFlag") == false) { if (document.getElementById("salesChannel").value != '') { document.getElementById("salesChannel").disabled = true; }if (document.getElementById("ActFlexField1").value != '') {             document.getElementById("ActFlexField1").disabled = true;             document.getElementById("ActFlexField2").disabled = true;             document.getElementById("ActFlexField3").disabled = true;             var cacGroup = document.getElementById("ActFlexField1__xc_0");             var cacGroupImg = cacGroup.getElementsByTagName("a");             cacGroupImg[0].style.visibility = 'hidden';             cacGroupImg[0].onclick = function () {                 return false;             } ;  var cacCode = document.getElementById("ActFlexField2__xc_0");             var cacCodeImg = cacCode.getElementsByTagName("a");             cacCodeImg[0].style.visibility = 'hidden';             cacCodeImg[0].onclick = function () {                 return false;             }       }        } 

SCRIPT



Friday, September 5, 2014

Menu - Sub Menu - Function (as tree structure) for a given Menu

SELECT LPAD(' ', 6*(LEVEL-1)) || menu_entry.entry_sequence sequence
, LPAD(' ', 6*(LEVEL-1)) || menu.user_menu_name SubMenu_Description
, LPAD(' ', 6*(LEVEL-1)) || func.user_function_name Function_Description
, menu.menu_id
, func.function_id
, menu_entry.grant_flag Grant_Flag
, DECODE( menu_entry.sub_menu_id
, null, 'FUNCTION'
, DECODE( menu_entry.function_id
, null, 'SUBMENU'
, 'BOTH')
) Type
FROM fnd_menu_entries menu_entry,
fnd_menus_vl menu,
fnd_form_functions_vl func
WHERE menu_entry.sub_menu_id = menu.menu_id(+)
AND menu_entry.function_id = func.function_id(+)
AND grant_flag = 'Y'
START WITH menu_entry.menu_id = (SELECT menu_id
FROM fnd_menus_tl menu2
WHERE menu2.user_menu_name = :Parent_Menu_User_Name)
CONNECT BY menu_entry.menu_id = PRIOR menu_entry.sub_menu_id
ORDER SIBLINGS BY menu_entry.entry_sequence