for c in (select column_value from table(f_split(V_FileID, ','))) loop

       --若没有填写资格开始结束时间，则填入

       select count(*)

         into numDataCount

         from ly_zg_jzfbt z

        where file_id = c.column_value

          and z.pt_valid_stime is null;

       if numDataCount > 0 then

         update ly_zg_jzfbt z

            set z.pt_valid_stime     = trunc(sysdate),

                z.pt_valid_etime     = add_months(trunc(sysdate), 12) - 1,

                z.fanaly_valid_etime = add_months(trunc(sysdate), 12) - 1

          where z.file_id = c.column_value;

         commit;

       end if;

       select l.CONTROL_ID

         into numControl

         from ly_zg_jzfbt l

        where file_id = c.column_value;

       varERRMSG := PK_JJZLFBTINFO.F_CheckStandard(c.column_value,

                                                   to_char(numControl));

       if varERRMSG is not null then

         raise_application_error('-20001', varERRMSG);

       end if;

       PK_FAMILYHOUSE.P_GetFamilyHouseInfoData(

                                               numControl,

                                               c.column_value,

                                               p_temp);

       if varERRMSG is not null then

         raise_application_error('-20001', varERRMSG);

       end if;

       PK_FAMILYINFO.P_GetFamilyInfo(

                                     c.column_value,

                                     p_temp);

       if varERRMSG is not null then

         raise_application_error('-20001', varERRMSG);

       end if;

       select l.is_over_certificate

         into doCeritify

         from ly_zg_jzfbt l

        where file_id = c.column_value;

       if doCeritify is null or doCeritify = 1 then

         update ly_zg_jzfbt l

            set l.do_certificate_time = sysdate, l.is_over_certificate = 0

          where file_id = c.column_value;

         commit;

       end if;

       --将out出的内容与file_id拼接在一起

       varIncomeAvg_All         := varIncomeAvg_All || c.column_value || ':' ||

                                   numIncomeAvg || ',';

       varIdentifiedArea_All    := varIdentifiedArea_All || c.column_value || ':' ||

                                   numIdentifiedArea || ',';

       varPerIdentifiedArea_All := varPerIdentifiedArea_All ||

                                   c.column_value || ':' ||

                                   numPerIdentifiedArea || ',';

     end loop;