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

Item Rate Update for Stock In Trade - Returnable Receive/Return (Loan)

  Stock In Trade - Returnable Receive/Return (Loan)