BEGIN DBMS_OUTPUT.put_line (1);
    BEGIN DBMS_OUTPUT.put_line (1);
    DELETE FROM CMC_BSDL_DETAILS WHERE PDBC_PFX='CW6F';
    COMMIT;IF SQL%ROWCOUNT = 0 THEN RAISE_APPLICATION_ERROR (-20101, 'No
    record inserted');
      END IF;


      delete from CMC_BSTX_SUM_TEXT where PDBC_PFX='CW6F';
       COMMIT;IF SQL%ROWCOUNT = 0 THEN RAISE_APPLICATION_ERROR (-20101, 'No
       record inserted');
       END IF;


                insert into CMC_BSDL_DETAILS(PDBC_PFX, BSDL_TYPE,
              BSDL_NTWK_IND, BSDL_EFF_DT, BSDL_COPAY_AMT, BSDL_DEDE_AMT,
                BSDL_COIN_PCT, BSDL_LTLT_AMT, BSDL_TERM_DT, BSDL_LT_TYPE,
            BSDL_LT_PERIOD, BSDL_LT_COUNTER, BSDL_TIER, BSDL_COV_IND,
         BSDL_STOPLOSS_AMT, BSDL_STOPLOSS_TYPE, BSDL_BEG_MMDD,
              BSDL_USER_LABEL1, BSDL_USER_DATA1, BSDL_USER_LABEL2,
            BSDL_USER_DATA2, BSDL_USER_LABEL3, BSDL_USER_DATA3,
             BSDL_USER_LABEL4, BSDL_USER_DATA4, BSDL_USER_LABEL5,
            BSDL_USER_DATA5, BSDL_USER_LABEL6, BSDL_USER_DATA6,
       BSDL_LOCK_TOKEN, ATXR_SOURCE_ID, SYS_LAST_UPD_DTM, SYS_USUS_ID,
          SYS_DBUSER_ID) values ('CW6F','AAMB','A',to_timestamp('01/01/1990
            00:00:00','MM/DD/YYYY
            HH24:MI:SS.FF'),250.00,0.00,0.00,0.00,to_timestamp('12/31/9999
            00:00:00','MM/DD/YYYY HH24:MI:SS.FF'),' ',' ',' ',0,' ',0.00,'
             ',0,' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','
                ',1,to_timestamp('01/01/1753 00:00:00','MM/DD/YYYY
         HH24:MI:SS.FF'),to_timestamp('08/17/2017 16:15:10','MM/DD/YYYY
                 HH24:MI:SS.FF'),'Translator','Translator');
               COMMIT;

        END; Exception WHEN OTHERS THEN ROLLBACK; END;