Translate

Wednesday, May 5, 2021

How to disable of the Add New Record Button, Clear Button and Delete Button from the Oracle apps Custom Form EBS R12.

How to disable of the Add New Record Button, Clear Button and Delete Button from the Oracle apps Custom Form EBS R12.

    

Write the code in the Form Level Trigger (WHEN-NEW-BLOCK-INSTANCE)
-- New Record Bottom, Clear Record Button and Delete Button is disable in the Oracle apps Form. --



       IF :XXBEX_PRO_BUDGET_HEADER_V.PROJECT_STATUS IN ('PROJECT APPROVED') THEN
           
               APP_SPECIAL.ENABLE('FILE.NEW', PROPERTY_OFF);                       
               APP_SPECIAL.ENABLE('EDIT.CLEAR', PROPERTY_OFF);
               APP_SPECIAL.ENABLE('EDIT.DELETE',PROPERTY_OFF);
        ELSE
               APP_SPECIAL.ENABLE('FILE.NEW', PROPERTY_ON);                       
               APP_SPECIAL.ENABLE('EDIT.CLEAR', PROPERTY_ON);
               APP_SPECIAL.ENABLE('EDIT.DELETE',PROPERTY_ON);

        END IF;





No comments:

Post a Comment

Text Message

WIP TABLES in Oracle Apps R12

  WIP TABLES Oracle Apps WIP KEY Tables   WIP_LINES   WIP_LINES stores production line information. Each row includes a line name, maximum a...