APPS.EDR_ERES_EVENT_PVT dependencies on FND_USER

Line 585: l_fnd_user varchar2(100);

581: l_rulenames edr_utilities.string_List;
582:
583: --Bug 2674799 : end
584:
585: l_fnd_user varchar2(100);
586: l_application_id NUMBER;
587: i NUMBER := 1;
588: l_ame_txn_type VARCHAR2(1000);
589: l_new_user VARCHAR2(100);

Line 621: from FND_USER

617: --Bug No 4912782- End
618:
619: CURSOR CUR_USER_NAME(l_cur_user_id number) is
620: select user_name
621: from FND_USER
622: where USER_ID = l_cur_user_id;
623:
624: BEGIN
625: --by default return 0 as the approver count

Line 726: l_fnd_user := l_approver_list(i).name;

722:
723: end if;
724:
725: --Bug 2674799 : start
726: l_fnd_user := l_approver_list(i).name;
727: --Bug 2674799 : end
728:
729: --find out if any overriding approver is defined in the workflow
730: --system for this user currently

Line 732: (P_ORIGINAL_RECIPIENT => l_fnd_user,

728:
729: --find out if any overriding approver is defined in the workflow
730: --system for this user currently
731: edr_standard.FIND_WF_NTF_RECIPIENT
732: (P_ORIGINAL_RECIPIENT => l_fnd_user,
733: P_MESSAGE_TYPE => null,
734: P_MESSAGE_NAME => null,
735: P_RECIPIENT => l_new_user,
736: P_NTF_ROUTING_COMMENTS => l_comments,

Line 746: x_approvers_name(i) := l_fnd_user;

742: x_approvers_name(i) := l_new_user;
743: x_approvers_role_name(i) := wf_directory.getroledisplayname(l_new_user);
744: x_overriding_details(i) := l_comments;
745: else
746: x_approvers_name(i) := l_fnd_user;
747: x_approvers_role_name(i) := wf_directory.getroledisplayname(l_fnd_user);
748: x_overriding_details(i) := null;
749: end if;
750:

Line 747: x_approvers_role_name(i) := wf_directory.getroledisplayname(l_fnd_user);

743: x_approvers_role_name(i) := wf_directory.getroledisplayname(l_new_user);
744: x_overriding_details(i) := l_comments;
745: else
746: x_approvers_name(i) := l_fnd_user;
747: x_approvers_role_name(i) := wf_directory.getroledisplayname(l_fnd_user);
748: x_overriding_details(i) := null;
749: end if;
750:
751: x_approvers_sequence(i) := l_approver_list(i).approver_order_number;