236: null ;
237: else /* No approvers */
238:
239: if(Approver.person_id is null) then
240: select user_name into l_user from fnd_user where user_id=Approver.user_id;
241: else
242: select user_name into l_user from fnd_user where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
243: end if;
244:
238:
239: if(Approver.person_id is null) then
240: select user_name into l_user from fnd_user where user_id=Approver.user_id;
241: else
242: select user_name into l_user from fnd_user where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
243: end if;
244:
245: IF (l_debug = 'Y') THEN
246: gmd_debug.put_line('Found approvers ');
422: /* No Approval Required */
423: P_resultout:='COMPLETE:N';
424: else
425: if(Approver.person_id is null) then
426: select user_name into l_user from fnd_user
427: where user_id=Approver.user_id;
428: else
429: select user_name into l_user from fnd_user
430: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
425: if(Approver.person_id is null) then
426: select user_name into l_user from fnd_user
427: where user_id=Approver.user_id;
428: else
429: select user_name into l_user from fnd_user
430: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
431: end if;
432:
433: /* Set the User Attribute */