CREATE OR REPLACE Procedure due_ImportArrearsUser
(
p_policyId        In               ics001.user_push_times.policyid%Type,
p_result          Out              Integer
---  -1001,删除临时表中在白名单中存在的记录时出错
---  -1002,删除临时表中与due_user表中重复的记录出错
---  -1003,将临时表中的数据插入due_user表出错
---  -1004,临时表中在user_push_time表中已有的记录，更新出错
---  -1005,临时表中不存在于user_push_time表中的记录，插入出错
---  -1006,清空临时表数据出错
---   0,成功
)
Is
v_userCount Integer;

Begin
 
     -----删除临时表中在白名单中存在的记录------
     
     Delete From due_user_temp a
     Where Exists( Select 1 
                   From due_whiteuser b 
                   Where a.username = b.username And a.province = b.province And a.city = b.city );
                               
     
     
     -----删除临时表中与due_user表中重复的记录---
     Delete From due_user_temp a
     Where Exists( Select 1 
                   From due_user b 
                   Where a.username = b.username And a.province = b.province And a.city = b.city );
     
     -----将临时表中的数据插入due_user表----
     Insert Into due_user
     Select * From due_user_temp;
     
     
     ----根据临时表中的数据,update或insert ics001.user_push_times表---
     ----临时表中在user_push_time表中已有的记录，更新-----
     Update
       (Select push.validflag, push.pushtimes,push.pushdaytimes, push.lastpushedtime
       From ics001.user_push_times push, due_user_temp temp
       Where push.username = temp.username And push.policyid = p_policyId)
     Set validflag = 1, pushtimes = 0, pushdaytimes = 0, lastpushedtime = 0;
     
    
     ---临时表中不存在于user_push_time表中的记录，插入----
     INSERT INTO ics001.user_push_times(username,ip,policyid,pushtimes,pushdaytimes,validflag,fileId,createtime)
      Select temp.username, 0, p_policyId, 0, 0, 1, 999997, Sysdate 
      From ics001.user_push_times push, due_user_temp temp
      Where temp.username = push.username(+) And push.username Is Null;

     Select Count( * ) Into v_userCount From due_user_temp;
     If(v_userCount > 0 ) Then
         Begin
              Delete From due_user_temp;
              
              If Sql%Notfound Then
              p_result := -1006;
              Return;
              End If;
         End;
    End If;
       
    p_result := v_userCount;
    Return;
     
End due_importarrearsuser;