APPS.WFA_SEC SQL Statements

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

Line: 105

         ** Do not update the icx_sessions table.  If you get a long
         ** running worklist or any other workflow api, you'll get a
         ** lock on the sessions table that will lead to db enqueue contention
         ** across the db.
         */
         res := ICX_SEC.ValidateSession( c_validate_only => 'Y',
                                         c_update => FALSE);

Line: 115

         res := ICX_SEC.ValidateSession(c_update => FALSE);

Line: 260

        select USER_ID into l_user_id
          from FND_USER
         where USER_NAME = PseudoSession.user_name
           and rownum < 2;

Line: 394

      select NAME,
             DISPLAY_NAME,
             DESCRIPTION,
             EMAIL_ADDRESS,
             NOTIFICATION_PREFERENCE,
             LANGUAGE,
             TERRITORY,
             ORIG_SYSTEM,
             ORIG_SYSTEM_ID,
             FAX,
             STATUS,
             EXPIRATION_DATE
      into   name,
             display_name,
             description,
             email_address,
             notification_preference,
             language,
             territory,
             orig_system,
             orig_system_id,
             FAX,
             STATUS,
             EXPIRATION_DATE
      from   WF_LOCAL_ROLES PARTITION (POS)
      where  ORIG_SYSTEM = prefix
      and    ORIG_SYSTEM_ID = to_number(roleid)
      and    nvl(EXPIRATION_DATE, sysdate+1) > sysdate;

Line: 424

      SELECT NAME,
             DISPLAY_NAME,
             DESCRIPTION,
             EMAIL_ADDRESS,
             NOTIFICATION_PREFERENCE,
             LANGUAGE,
             TERRITORY,
             ORIG_SYSTEM,
             ORIG_SYSTEM_ID,
             FAX,
             STATUS,
             EXPIRATION_DATE
      into   name,
             display_name,
             description,
             email_address,
             notification_preference,
             language,
             territory,
             orig_system,
             orig_system_id,
             FAX,
             STATUS,
             EXPIRATION_DATE
      from   WF_LOCAL_ROLES PARTITION (ENG_LIST)
      where  ORIG_SYSTEM = prefix
      and    ORIG_SYSTEM_ID = to_number(roleid)
      and    nvl(EXPIRATION_DATE, sysdate+1) > sysdate;

Line: 456

      SELECT  NAME,
              DISPLAY_NAME,
              DESCRIPTION,
              EMAIL_ADDRESS,
              NOTIFICATION_PREFERENCE,
              LANGUAGE,
              TERRITORY,
              ORIG_SYSTEM,
              ORIG_SYSTEM_ID,
              FAX,
              STATUS,
              EXPIRATION_DATE
       into   name,
              display_name,
              description,
              email_address,
              notification_preference,
              language,
              territory,
              orig_system,
              orig_system_id,
              FAX,
              STATUS,
              EXPIRATION_DATE
       from   WF_LOCAL_ROLES PARTITION (FND_RESP)
       where  ORIG_SYSTEM = prefix
       and    ORIG_SYSTEM_ID = to_number(roleid)
       and    nvl(EXPIRATION_DATE, sysdate+1) > sysdate;

Line: 485

       select NAME,
              DISPLAY_NAME,
              DESCRIPTION,
              EMAIL_ADDRESS,
              NOTIFICATION_PREFERENCE,
              LANGUAGE,
              TERRITORY,
              ORIG_SYSTEM,
              ORIG_SYSTEM_ID,
              FAX,
              STATUS,
              EXPIRATION_DATE
       into   name,
              display_name,
              description,
              email_address,
              notification_preference,
              language,
              territory,
              orig_system,
              orig_system_id,
              FAX,
              STATUS,
              EXPIRATION_DATE
        from  WF_LOCAL_ROLES PARTITION (AMV_CHN)
        where ORIG_SYSTEM = prefix
        and   ORIG_SYSTEM_ID = to_number(roleid)
        and   nvl(EXPIRATION_DATE, sysdate+1) > sysdate;

Line: 515

       select NAME,
              DISPLAY_NAME,
              DESCRIPTION,
              EMAIL_ADDRESS,
              NOTIFICATION_PREFERENCE,
              LANGUAGE,
              TERRITORY,
              ORIG_SYSTEM,
              ORIG_SYSTEM_ID,
              FAX,
              STATUS,
              EXPIRATION_DATE
       into   name,
              display_name,
              description,
              email_address,
              notification_preference,
              language,
              territory,
              orig_system,
              orig_system_id,
              FAX,
              STATUS,
              EXPIRATION_DATE
       from   WF_LOCAL_ROLES PARTITION (HZ_PARTY)
       where  ORIG_SYSTEM = prefix
       and    ORIG_SYSTEM_ID = to_number(roleid)
       and    nvl(EXPIRATION_DATE, sysdate+1) > sysdate;

Line: 555

      select NAME,
             DISPLAY_NAME,
             DESCRIPTION,
             EMAIL_ADDRESS,
             NOTIFICATION_PREFERENCE,
             LANGUAGE,
             TERRITORY,
             ORIG_SYSTEM,
             ORIG_SYSTEM_ID,
             FAX,
             STATUS,
             EXPIRATION_DATE
      into   name,
             display_name,
             description,
             email_address,
             notification_preference,
             language,
             territory,
             orig_system,
             orig_system_id,
             FAX,
             STATUS,
             EXPIRATION_DATE
      from   WF_LOCAL_ROLES
      where  NAME = role
      and    partition_id in (1, 0, 5, 10, 13)
      and    nvl(EXPIRATION_DATE, sysdate+1) > sysdate
      and    rownum < 2;                    /* Bug 2728955 */

Line: 598

         SELECT USER_ID
         INTO   fndUserID
         FROM   FND_USER
         WHERE  USER_NAME = name;

Line: 717

         SELECT USER_ID
         INTO   l_fndUserID
         FROM   FND_USER
         WHERE  USER_NAME = p_role;

Line: 817

      SELECT USER_ID
      INTO   l_user_id
      FROM   FND_USER
      WHERE  user_name = Get_Profile_Value.user_name;

Line: 944

  select count(1) into cnt
    from WF_LOCAL_ROLES PARTITION (WF_LOCAL_ROLES)
   where NAME = role_name
     and ORIG_SYSTEM in ('WF_LOCAL_ROLES', 'WF_LOCAL_USERS')
     and ORIG_SYSTEM_ID = 0;

Line: 965

procedure DS_Update_Local_Role(
  OldName in varchar2,
  NewName in varchar2
)
is
begin
   update WF_LOCAL_ROLES PARTITION (WF_LOCAL_ROLES)
   set    NAME = NewName
   where  NAME = OldName
   and    ORIG_SYSTEM in ('WF_LOCAL_USERS', 'WF_LOCAL_ROLES')
   and    ORIG_SYSTEM_ID = 0;

Line: 978

   update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)
   set    USER_NAME = NewName
   where  USER_NAME = OldName
   and    USER_ORIG_SYSTEM = 'WF_LOCAL_USERS'
   and    USER_ORIG_SYSTEM_ID = 0;

Line: 984

   update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)
   set    ROLE_NAME = NewName
   where  ROLE_NAME = OldName
   and    ROLE_ORIG_SYSTEM = 'WF_LOCAL_USERS'
   and    ROLE_ORIG_SYSTEM_ID = 0;

Line: 990

   update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)
   set    ROLE_NAME = NewName
   where  ROLE_NAME = OldName
   and    ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
   and    ROLE_ORIG_SYSTEM_ID = 0;

Line: 1000

   WF_CORE.Context('WFA_SEC', 'DS_Update_Local_Role', OldName, NewName);

Line: 1002

end DS_Update_Local_Role;