APPS.UMX_LOGIN_HELP_PVT SQL Statements

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

Line: 30

   SELECT person_party_id
   FROM fnd_user
   where user_name = username;

Line: 123

    select count(*) into l_no from
    (
       SELECT WorkflowItemEO.ITEM_TYPE,
            WorkflowItemEO.ITEM_KEY,
            wf_fwkmon.getitemstatus(WorkflowItemEO.ITEM_TYPE, WorkflowItemEO.ITEM_KEY, WorkflowItemEO.END_DATE,
            WorkflowItemEO.ROOT_ACTIVITY, WorkflowItemEO.ROOT_ACTIVITY_VERSION)  STATUS_CODE
        FROM    WF_ITEMS WorkflowItemEO,
            WF_ITEM_TYPES_VL WorkflowItemTypeEO,
            WF_ACTIVITIES_VL ActivityEO,
            WF_ITEM_ATTRIBUTE_VALUES attrib
        WHERE WorkflowItemEO.ITEM_TYPE = WorkflowItemTypeEO.NAME
            AND  ActivityEO.ITEM_TYPE = WorkflowItemEO.ITEM_TYPE
            AND  ActivityEO.NAME = WorkflowItemEO.ROOT_ACTIVITY
            AND  ActivityEO.VERSION = WorkflowItemEO.ROOT_ACTIVITY_VERSION
            AND attrib.item_type = WorkflowItemEO.ITEM_TYPE
            AND attrib.item_key =  WorkflowItemEO.ITEM_KEY
            AND attrib.name = 'USER_NAME'
            AND attrib.text_value = l_user_name
    ) QRSLT
    where
        item_type = 'UMXLHELP'
        AND status_code = 'ACTIVE';

Line: 153

    cursor MaxNoRequest is SELECT attr.text_value into l_max_no
    From WF_ITEMS item, WF_ITEM_ATTRIBUTE_VALUES attr
    Where
        item.item_type = attr.item_type
        And
        item.item_key = attr.item_key
        And
        item.item_type = g_itemtype
        And
        attr.name = 'MAX_NO_PERSISTENT_REQ'
        AND
        rownum <= 1;

Line: 207

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

Line: 214

      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: 284

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

Line: 290

        SELECT fu.user_name
        FROM hz_parties p, fnd_user fu
        WHERE p.party_id = fu.person_party_id
        AND p.email_address = p_email_address;

Line: 358

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

Line: 364

        SELECT fu.user_name
        FROM hz_parties p, fnd_user fu
        WHERE p.party_id = fu.person_party_id
        AND UPPER(p.email_address) = UPPER(p_email_address);

Line: 427

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

Line: 1227

    l_updatePwdFailedException exception;

Line: 1269

            FND_USER_PKG.UpdateUserParty (
                  x_user_name            => l_user_name,
                  x_owner                => l_user_name,
                  x_unencrypted_password => l_password,
                  x_password_date        => sysdate);

Line: 1280

                          'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.FND_USER_PKG.UpdateUserParty',
                          'x_no_attempts: ' || x_no_attempts ||
                          'x_return_status: ' || x_return_status ||
                          ' | x_message_name: ' || x_message_name );