APPS.UMX_PASSWORD_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 23

      SELECT email_address
      FROM fnd_user
      WHERE user_name = p_user_name
      AND start_date <= sysdate
      AND nvl(end_date, sysdate + 1) > sysdate;

Line: 30

      SELECT hzp.email_address
      FROM hz_parties hzp, fnd_user fu
      WHERE hzp.party_id = fu.person_party_id
      AND fu.user_name = p_user_name;

Line: 84

      select user_name
      from   fnd_user
      where  user_id = p_user_id;

Line: 200

        select USER_ID into USER_ID from FND_USER  where  USER_NAME= P_USERNAME;

Line: 342

  Procedure UpdatePassword_WF(itemtype  in varchar2,
                              itemkey   in varchar2,
                              actid     in number,
                              funcmode  in varchar2,
                              resultout in out NOCOPY varchar2) is

  begin

    if (funcmode = 'RUN') then

      FND_USER_PKG.UpdateUserParty (
          x_user_name                  =>
              WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid,
                                            'USER_NAME', TRUE),
          x_owner                      => null,
          x_unencrypted_password       =>
              WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid,
                                            'PASSWORD', TRUE),
          x_password_date              => fnd_user_pkg.null_date);

Line: 368

      Wf_Core.Context('UMX_PASSWORD_PVT', 'UpdatePassword_WF', itemtype, itemkey,
                      actid);

Line: 378

   SELECT person_party_id
   FROM fnd_user
   where user_name = username;

Line: 482

    select to_char (UMX_PASSWORD_WF_S.Nextval) into x_itemkey from dual;

Line: 642

              FND_USER_PKG.UpdateUserParty (
                  x_user_name            => l_user_name,
                  x_owner                => null,
                  x_unencrypted_password => l_password,
                  x_password_date        => fnd_user_pkg.null_date);