17,089
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE PROCEDURE PS_OA_EMPLINFO_U_PRO
(emplid in varchar2,
mar_status in varchar2,
religion_cd in varchar2
--shengao in varchar2,wk_jjlx_name in varchar2,wk_jjlx_phone in varchar2,
--mobilephone in varchar2,jiaphone in varchar2,
--huji_address in varchar2,jia_address in varchar2
)
is
begin
update PS_PERS_DATA_EFFDT P set P.MAR_STATUS=mar_status where P.EMPLID=emplid;
update PS_DIVERS_RELIGION Z set Z.RELIGION_CD=religion_cd where Z.EMPLID=emplid;
--update Ps_Wk_Other set wk_jjlx_phone=wk_jjlx_phone,wk_shengao=shengao where emplid=emplid;
--update Ps_Wk_Other_Lang set wk_jjlx_name=wk_jjlx_name where emplid=emplid;
--update PS_PERSONAL_PHONE set phone=mobilephone where phone_type='MAIN' and emplid=emplid;
--update PS_PERSONAL_PHONE set phone=jiaphone where phone_type='HOME' and emplid=emplid;
--update PS_WK_ADDRESS_LANG set address1=huji_address where address_type='HUJI' and emplid=emplid;
--update PS_WK_ADDRESS_LANG set address1=jia_address where address_type='HOME' and emplid=emplid;
commit;
end PS_OA_EMPLINFO_U_PRO;
/