DBA Data[Home] [Help]

APPS.FA_CUA_HR_REINSTATEMENTS_PKG dependencies on FND_PROFILE

Line 158: v_user:= nvl(TO_NUMBER(fnd_profile.value('USER_ID')),-1);

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

Line 159: v_last_update_login:= nvl(TO_NUMBER(fnd_profile.value('LOGIN_ID')),-1);

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