DBA Data[Home] [Help]

APPS.GMD_SS_TIMEPOINT_WF_PKG dependencies on FND_USER

Line 198: select user_name into l_user from fnd_user

194:
195: if(Approver.user_id is null and Approver.person_id is null) then
196: /* No Approval Required so we will default to the owner*/
197: /* P_resultout:='COMPLETE:N'; */
198: select user_name into l_user from fnd_user
199: where user_id = l_owner;
200: l_owner_used := 1;
201: end if ;
202:

Line 205: select user_name into l_user from fnd_user

201: end if ;
202:
203: if (l_user is null) then
204: if(Approver.person_id is null) then
205: select user_name into l_user from fnd_user
206: where user_id=Approver.user_id;
207: else
208: select user_name into l_user from fnd_user
209: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);

Line 208: select user_name into l_user from fnd_user

204: if(Approver.person_id is null) then
205: select user_name into l_user from fnd_user
206: where user_id=Approver.user_id;
207: else
208: select user_name into l_user from fnd_user
209: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
210: end if;
211: end if;
212:

Line 394: select user_name into l_user from fnd_user

390: /* No Approval Required */
391: P_resultout:='COMPLETE:N';
392: else
393: if(Approver.person_id is null) then
394: select user_name into l_user from fnd_user
395: where user_id=Approver.user_id;
396: else
397: select user_name into l_user from fnd_user
398: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);

Line 397: select user_name into l_user from fnd_user

393: if(Approver.person_id is null) then
394: select user_name into l_user from fnd_user
395: where user_id=Approver.user_id;
396: else
397: select user_name into l_user from fnd_user
398: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
399: end if;
400:
401: /* Set the User Attribute */