EBS: API导入GL科目交叉验证规则要素

declare cursor c1 is 
 select tmp.application_id,
        tmp.id_flex_code,
        tmp.id_flex_num,
        tmp.id_flex_structure_code,
        tmp.flex_validation_rule_name,
        tmp.include_exclude_indicator,
        tmp.concatenated_segments_low,
        tmp.concatenated_segments_high,
        tmp.enabled_flag,
        tmp.description 
  from  CUX.CUX_KFF_CVR_LINE_TMP tmp
 where 1=1 ;
begin

  for r1 in c1 loop
     FND_FLEX_LOADER_APIS.up_kff_cvr_line(
       p_upload_phase                =>'BEGIN', -- IN VARCHAR2 DEFAULT NULL,
       p_upload_mode                 =>'', -- IN VARCHAR2,
       p_custom_mode                 =>'FORCE', -- IN VARCHAR2 DEFAULT NULL,
       p_application_short_name      =>'SQLGL', -- IN VARCHAR2,
       p_id_flex_code                =>'GL#', -- IN VARCHAR2,
       p_id_flex_structure_code      =>'CUX_COA', -- IN VARCHAR2,
       p_flex_validation_rule_name   =>r1.flex_validation_rule_name, -- IN VARCHAR2,
       p_include_exclude_indicator   =>r1.include_exclude_indicator, -- IN VARCHAR2,
       p_concatenated_segments_low   =>r1.concatenated_segments_low, -- IN VARCHAR2,
       p_concatenated_segments_high  =>r1.concatenated_segments_high, -- IN VARCHAR2,
       p_owner                       =>'IT-CUX', -- IN VARCHAR2,
       p_last_update_date            => TO_CHAR(SYSDATE,'YYYY/MM/DD'), -- IN VARCHAR2 DEFAULT NULL,
       p_enabled_flag                =>'Y', -- IN VARCHAR2,
       p_description                 => r1.description -- IN VARCHAR2
       ); 
     

  end loop;
end; 
 
 w例子　

如下图例子