vi_task_id integer; -- task log id
vv_task_name varchar2(30); -- task name
vv_task_pos varchar2(200); -- task position
vv_table_name varchar2(30); -- table name
vi_err_code integer; -- error code
vv_err_msg varchar2(200); -- error message
vi_result integer; -- manipulated record number
exc_error exception; -- customized error exception variable in program processing
vd_date_temp date;
vd_date_year date;
vi_week_tsart_flag integer;
vv_week_format_value varchar2(30);
vv_date_format varchar2(30);
vv_month_format varchar2(30);
vv_week_format varchar2(30);
begin
execute immediate 'alter session enable parallel dml';
/**
* @description initialize variable
* @field-mapping vv_task_name = ('LBI_EDM_VDF.prc_s_yyyy_mm_ww_dd ')
* @field-mapping vv_table_name = ('LBI_EDM_VDF.t_s_yyyy_mm_ww_dd ')
*/
vv_task_name := 'prc_s_yyyy_mm_ww_dd';
vv_table_name := 't_s_yyyy_mm_ww_dd';