Custom.pll DFF read only

Custom.pll example to make DFF read only

Custom.pll can be used for a wide range of customizations. For example, it can be used to make the DFF read only based on a condition(s). In this example, I will do a customization wherein the Additional Absence Details DFF will be read only for the responsibilities ‘Vision HR Manager' and 'XYZ HR Manager' and for others it will be editable.

Before the customization, the DFF was editable for the above mentioned responsibilities.

Open custom.pll and add the following code:

/* *************************** Code to make DFF Read Only ****************** */

IF (event_name = 'WHEN-NEW-BLOCK-INSTANCE' AND form_name = 'PERWSEAD' AND block_name = 'ABA') THEN
IF (FND_PROFILE.VALUE('RESP_NAME')IN ('Vision HR Manager' ,'XYZ HR Manager')) THEN
fnd_descr_flex.update_definition
(
BLOCK => 'ABA'
,FIELD => 'DF'
,READ_ONLY => 'Y' );
END IF;
END IF;
/* *************************** End of The Code ************************* */

Compile and generate the .plx file.

As custom.pll is loaded every time we login to the applications, we need to logout to see the changes. This is mandatory. Once it’s compiled successfully and the .plx file is generated, the DFF will be read only for the above mentioned responsibilities.

This is only a small example of custom.pll. It can perform much more complex requirements :-)