APPS.WFA_HTML SQL Statements

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

Line: 379

      select RECIPIENT_ROLE, ORIGINAL_RECIPIENT
      into recipient, orig_recipient
      from WF_NOTIFICATIONS WN
      where WN.NOTIFICATION_ID = nid;

Line: 399

        select ORIG_SYSTEM, ORIG_SYSTEM_ID
          into uos, uosid
          from WF_USERS
         where NAME = username
           and ORIG_SYSTEM not in ('HZ_PARTY','CUST_CONT')
           and rownum < 2;

Line: 444

      select 1
        into dummy
        from sys.dual
       where exists (
         select null
           from WF_USER_ROLES
          where USER_ORIG_SYSTEM = uos
            and USER_ORIG_SYSTEM_ID = uosid
            and USER_NAME = username
            and ROLE_ORIG_SYSTEM = ros
            and ROLE_ORIG_SYSTEM_ID = rosid
            and ROLE_NAME = recipient
        union all
         select null
           from WF_USER_ROLES
          where USER_ORIG_SYSTEM = uos
            and USER_ORIG_SYSTEM_ID = uosid
            and USER_NAME = username
            and ROLE_ORIG_SYSTEM = oos
            and ROLE_ORIG_SYSTEM_ID = oosid
            and ROLE_NAME = orig_recipient
        );

Line: 610

  select count(1)
  into urlcnt
  from WF_MESSAGE_ATTRIBUTES MA,
       WF_NOTIFICATIONS N
  where N.NOTIFICATION_ID = nid
  and MA.MESSAGE_NAME = N.MESSAGE_NAME
  and MA.MESSAGE_TYPE = N.MESSAGE_TYPE
  and MA.SUBTYPE = 'RESPOND'
  and MA.TYPE = 'URL';

Line: 625

    select count(1)
    into respcnt
    from WF_NOTIFICATION_ATTRIBUTES NA,
         WF_MESSAGE_ATTRIBUTES MA,
         WF_NOTIFICATIONS N
    where N.NOTIFICATION_ID = nid
    and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
    and MA.MESSAGE_NAME = N.MESSAGE_NAME
    and MA.MESSAGE_TYPE = N.MESSAGE_TYPE
    and MA.NAME = NA.NAME
    and MA.SUBTYPE = 'RESPOND'
    and MA.TYPE <> 'FORM'
    and MA.NAME <> 'RESULT';

Line: 640

    select count(1)
    into longcnt
    from WF_NOTIFICATION_ATTRIBUTES NA,
         WF_MESSAGE_ATTRIBUTES MA,
         WF_NOTIFICATIONS N
    where N.NOTIFICATION_ID = nid
    and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
    and MA.MESSAGE_NAME = N.MESSAGE_NAME
    and MA.MESSAGE_TYPE = N.MESSAGE_TYPE
    and MA.NAME = NA.NAME
    and MA.SUBTYPE = 'RESPOND'
    and MA.TYPE = 'VARCHAR2'
    and decode(MA.TYPE, 'VARCHAR2', nvl(to_number(MA.FORMAT), 2000), 0) > 80;

Line: 1002

procedure SubmitSelectedResponse(
  nids         in Name_Array,
  close        in varchar2,
  forward      in varchar2,
  showto       in varchar2,
  nkey         in varchar2)
as
begin
  null;

Line: 1011

end SubmitSelectedResponse;

Line: 1046

    wf_core.raise('WFNTF_NO_SELECT');

Line: 1128

  SELECT USERENV('LANG')
  INTO l_lang
  FROM DUAL;

Line: 1760

SELECT
 name,
 display_name
FROM   wf_role_lov_vl
where  status <> 'INACTIVE'
and   (UPPER(display_name) LIKE UPPER(c_find_criteria)||'%')
order by display_name;

Line: 1797

   select count(*)
   into   l_total_rows
   FROM   wf_role_lov_vl
   where  status <> 'INACTIVE'
   and   (UPPER(display_name) LIKE UPPER(p_display_value)||'%');

Line: 1846

   ** If its more than 1 then check to see if they used the LOV to select
   ** the value
   */
   open c_user_lov (p_display_value);

Line: 1865

   **     entered so present a no rows found and use the lov icon to select
   **     value
   ** If ii=1 then one row is found then you've got the right value
   ** If ii=2 then more than one row was found so check to see if the display
   ** value taht was selected is not unique in the LOV (Person Name) and
   ** that the LOV was used so the Hidden value has been set to a unique
   ** value.  If it comes up with more than 1 in this case then present
   ** the please use lov icon to select value.
   */
   if (ii = 2) then

     -- copy logic from wf_directory.getroleinfo2
     colon := instr(p_display_value,':');

Line: 1879

       select count(*)
         into ii
         from WF_ROLES
        where NAME = p_display_value
          and ORIG_SYSTEM not in ('HZ_PARTY','POS','ENG_LIST','AMV_CHN',
                                  'HZ_GROUP','CUST_CONT');

Line: 1886

       select count(*)
         into ii
         from WF_ROLES
        where NAME = p_display_value
          and ORIG_SYSTEM    = substr(p_display_value, 1, colon-1)
          and ORIG_SYSTEM_ID = substr(p_display_value, colon+1);

Line: 1951

   ** used the LOV to select the name and then blanked out the display
   ** name then make sure here to blank out the insternal name and return
   */
   if (p_display_name is null) then

      p_user_name := NULL;

Line: 2010

      select count(1)
      into   l_names_count
      from   wf_role_lov_vl
      where  display_name = p_display_name;

Line: 2030

         select name
         into   l_name
         from   wf_role_lov_vl
         where  display_name = p_display_name;

Line: 2039

      ** used the lov to select the name in which case the combination
      ** of the display name and the user name should be unique
      */
      else

        -- copy logic from wf_directory.getroleinfo2
        l_colon := instr(p_user_name,':');

Line: 2048

          select count(1)
            into l_names_count
            from WF_ROLES
           where NAME = p_user_name
             and ORIG_SYSTEM not in ('HZ_PARTY','POS','ENG_LIST','AMV_CHN',
                                     'HZ_GROUP','CUST_CONT')
             and DISPLAY_NAME = p_display_name;

Line: 2068

          select count(1)
            into l_names_count
            from WF_ROLES
           where NAME = p_user_name
             and ORIG_SYSTEM    = substr(p_user_name, 1, l_colon-1)
             and ORIG_SYSTEM_ID = l_orig_system_id
             and DISPLAY_NAME = p_display_name;