PRC_S_MAINTAIN_PARTITION(17)

 else
                select count(*)
                  into vi_count
                  from LBI_SYS_VDF.t_s_tab_partition_add_mid
                 where table_owner = upper(l_table_list.owner)
                   and table_name = upper(l_table_list.table_name)
                   and partition_name = vv_partition_name_a;
                /** @description add partition if partition is not exist*/

                if vi_count = 0 then
                    vv_add_p_sql := vv_add_p_sql||l_table_list.owner||'.'||l_table_list.table_name||' ';
                    vv_add_p_sql := vv_add_p_sql||'add partition '||vv_partition_name_a||' ';
                    /** @description judge partition type and partition column's data type.0:date,1:char,2:number*/
                    if upper(l_table_list.partition_type_id) = 'L' then
                        if l_table_list.date_type_id = '0' then
                            vv_add_p_sql := vv_add_p_sql||'values (to_date('''||vv_etl_a||''',''yyyymmdd'')) tablespace ';
                        elsif l_table_list.date_type_id = '1' then
                            vv_add_p_sql := vv_add_p_sql||'values ('||vv_etl_a||') tablespace ';
                        elsif l_table_list.date_type_id = '2' then
                            vv_add_p_sql := vv_add_p_sql||'values '||'('||to_number(vv_etl_a)||')'||' tablespace ';
                        end if;