156: BEGIN -- hr_Reinstate
157:
158: -- initializing parameters
159: v_sysdate:= sysdate;
160: v_user:= nvl(TO_NUMBER(fnd_profile.value('USER_ID')),-1);
161: v_last_update_login:= nvl(TO_NUMBER(fnd_profile.value('LOGIN_ID')),-1);
162:
163: -- use the concurrent request id as the mass reference.
164: LV_Mass_Reference_Id := x_Conc_Request_Id;
157:
158: -- initializing parameters
159: v_sysdate:= sysdate;
160: v_user:= nvl(TO_NUMBER(fnd_profile.value('USER_ID')),-1);
161: v_last_update_login:= nvl(TO_NUMBER(fnd_profile.value('LOGIN_ID')),-1);
162:
163: -- use the concurrent request id as the mass reference.
164: LV_Mass_Reference_Id := x_Conc_Request_Id;
165: