APPS.JTF_UM_FORGOT_PASSWD SQL Statements

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

Line: 131

       SELECT user_id
       into l_user_id
       from fnd_user
       where user_name = upper(c_user_name);

Line: 137

      SELECT 'LDAP'
      INTO l_auth_mode
      FROM fnd_user
      WHERE l_user_id = icx_sec.g_user_id
      AND upper(encrypted_user_password)='EXTERNAL';

Line: 171

  select ICX_TEXT_S.Nextval into seq from dual;

Line: 238

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

  l_user_name varchar2(360);

Line: 251

      FND_USER_PKG.UpdateUser(
           x_user_name=> l_user_name,
           x_owner=>'CUST',
           x_unencrypted_password=>
             WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid,
                                                'X_UNENCRYPTED_PASSWORD',
                                                TRUE),
           -- setting password date to null for force passwd change for user
           x_password_date=> fnd_user_pkg.null_date,
           /*
           x_password_date=>
             WF_ENGINE.GetActivityAttrDate(itemtype, itemkey, actid,
                                                'X_PASSWORD_DATE', TRUE),
           */
           x_password_accesses_left=>
             WF_ENGINE.GetActivityAttrNumber(itemtype, itemkey, actid,
                                                'X_PASSWORD_ACCESSES_LEFT',
                                                TRUE),
         x_password_lifespan_accesses=>
            WF_ENGINE.GetActivityAttrNumber(itemtype, itemkey, actid,
                                                'X_PASSWORD_LIFESPAN_ACCESSES',
                                                TRUE),
           x_password_lifespan_days=>
             WF_ENGINE.GetActivityAttrNumber(itemtype, itemkey, actid,
                                                'X_PASSWORD_LIFESPAN_DAYS',
                                                TRUE));

Line: 284

        update fnd_user set
        password_date = null
        where user_name = l_user_name;

Line: 298

      Wf_Core.Context('FND_WF_STANDARD', 'UpdatePassword', itemtype, itemkey,
                      actid);

Line: 327

select email_address
from fnd_user
where user_name = l_user_name;

Line: 332

select hzp.email_address
from hz_parties hzp, fnd_user fu
where hzp.party_id = fu.customer_id
and fu.user_name = l_user_name;

Line: 466

select 'X'
from wf_items wfi, wf_item_attribute_values wfa
where wfi.item_type = wfa.item_type
and wfi.item_key = wfa.item_key
and wfi.item_type = 'JTFFPWD'
and wfi.end_date is NULL
and wfa.name = 'X_USER_NAME'
and wfa.text_value = p_name;

Line: 476

select hzp.email_address
from hz_parties hzp, fnd_user fu
where hzp.party_id = fu.customer_id
and fu.user_name = p_name;

Line: 501

  SELECT user_id,
         decode(upper(encrypted_user_password),'EXTERNAL','EXTERNAL','FND'),
         email_address
  into l_user_id, l_auth_mode, l_fnd_email_address
  from fnd_user
  where user_name = p_name
  and start_date <= sysdate
  and nvl(end_date, sysdate + 1) > sysdate;

Line: 539

       select JTF_UM_PSW_WF_S.Nextval into seq from dual;

Line: 633

select 'X'
from wf_items wfi, wf_item_attribute_values wfa
where wfi.item_type = wfa.item_type
and wfi.item_key = wfa.item_key
and wfi.item_type = 'JTFFPWD'
and wfi.end_date is NULL
and wfa.name = 'X_USER_NAME'
and wfa.text_value = p_name;

Line: 643

select hzp.email_address
from hz_parties hzp, fnd_user fu
where hzp.party_id = fu.customer_id
and fu.user_name = p_name;

Line: 661

  SELECT user_id,
         decode(upper(encrypted_user_password),'EXTERNAL','EXTERNAL','FND'),
         email_address
  into l_user_id, l_auth_mode, l_fnd_email_address
  from fnd_user
  where user_name = p_name
  and start_date <= sysdate
  and nvl(end_date, sysdate + 1) > sysdate;

Line: 688

       select JTF_UM_PSW_WF_S.Nextval into seq from dual;