cursor c_partition_drop_list                                  --cursor to partition will be droped
        is
           select
                  table_owner,
                  table_name,
                  deal_cycle,
                  last_day_type_id,
                  partition_name,
                  max_delete_date
             from LBI_SYS_VDF.t_s_tab_partition_del_mid;
    l_partition_drop_list c_partition_drop_list%rowtype;

begin

    /**
      * @description initialize variable
      * @field-mapping vd_begin_date = (sysdate)
      * @field-mapping vv_procedure_name = ('prc_sys_maintain_partition')
      * @field-mapping vd_deal_date = ( to_date(iv_date,'yyyymmdd') )
      * @field-mapping vv_table_name = ('t_s_tab_partitions')
      */
 select sysdate into vd_begin_date from dual;            --get start time
 vv_procedure_name := 'prc_sys_maintain_partition';
    vd_deal_date  := to_date(iv_date,'yyyymmdd');
    vv_table_name := 't_s_tab_partition';
    on_statuscode := 0;