0 Replies Latest reply on Apr 20, 2017 12:28 PM by miro_feps

    Clear Block In custom form when list of value changed

    miro_feps

      i've a custom form contains 1 control block & 1 data block

       

      i need when i choose the list of value & go to the data block it populate the data

      i did so through the below

       

      in when new record instance of the data block i'm writing the below

       

      PACKAGE BODY XXBP_ANPVALS IS

       

       

      PROCEDURE POPULATE_ANP_VALS

      IS

        CURSOR ANP_SGMNTS_C

        IS

       

        SELECT ANP_TYPE_CODE

             ,TYPE_NAME

             ,DESCRIPTION

             ,SEQUENCE_NUM

             

        FROM XXBP_EAM_ANPSGMNTS

        WHERE NVL(ENABLED_FLAG,'Y') = 'Y'

        AND   ANP_ID = :XXBP_EAM_ANPVALS.ANP_ID ;

        

      BEGIN

       

        FOR i in ANP_SGMNTS_C

       

        LOOP

        :XXBP_EAM_ANPVALS.ANP_TYPE_CODE := INITCAP(i.ANP_TYPE_CODE) ;

        :XXBP_EAM_ANPVALS.TYPE_NAME     := i.TYPE_NAME ;

        :XXBP_EAM_ANPVALS.DESCRIPTION   := i.DESCRIPTION ;

       

        IF i.ANP_TYPE_CODE = 'MENU'

        THEN

        :XXBP_EAM_ANPVALS.MENU_SEQ_NUM := i.SEQUENCE_NUM ;

        ELSE

         :XXBP_EAM_ANPVALS.SUBMENU_SEQ_NUM := i.SEQUENCE_NUM ;

        END IF ;

        NEXT_RECORD ;

        END LOOP ;

       

      EXCEPTION WHEN OTHERS THEN NULL ;

      END;

      END;

       

      the problem is when i change the list of value data in the data block isn't change

      will you please advice