PRC_S_SYS_LOG(1)

is
    --add by l00233963 start
    oi_flag varchar2(32);
    --add by l00233963 end
begin

    /** @description  it execute difference process depand on task status*/
    if ( ii_task_status = 1 ) then
    /**
      * @description   get a new task id and insert a new record
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#log_month = (to_char(sysdate,'yyyymm'))
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#task_id = (oi_task_id)
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#task_name = (is_task_name)
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#table_name = (is_table_name)
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#task_sign = (is_task_sign)
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#start_time = current time(sysdate)
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#end_time = (null)
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#task_status = (1)
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#task_log = ('program processing')
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#task_pos = (null)
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#rowcount = (null)
      */

        select seq_sys_log.nextval into oi_task_id from dual;