How to enable/disable certain DFF fields based on the responsibility
Hello everyone,
I have a DFF which has 5 fields and all 5 fields are free text (50 characters) , user can enter any value.
Here my requirement is out of 5 fields, 4 fileds should be disabled for other than the Manager responsibilities.
For Manager responsibilities all 5 fields should be enabled.
For this I have created one lookup to keep the List of manager responsibilities
and based on the this created the special value set.
Following is the code in the Special Valuset,
FND SQL "DECLARE
ln_cnt NUMBER := 0;
ln_resp_id NUMBER := fnd_profile.value('RESP_ID');
ls_resp_key VARCHAR2 (100);
BEGIN
SELECT responsibility_key