DBA Data[Home] [Help]

APPS.WFA_HTML_UTIL SQL Statements

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

Line: 114

    ** user can see what they've selected.
    */

    if (type = 'DOCUMENT') THEN

       htp.formhidden ('h_fvalues', dvalue);
Line: 263

    select MEANING, LOOKUP_CODE
    from   WF_LOOKUPS
    where  LOOKUP_TYPE = p_lookup_type
    order by MEANING;
Line: 274

              htf.formSelectOpen('h_fvalues');
Line: 281

            htf.formSelectOption(i.meaning, 'SELECTED','VALUE="'||i.lookup_code||'"');
Line: 284

            htf.formSelectOption(i.meaning,null,'VALUE="'||i.lookup_code||'"');
Line: 287

  template := template||wf_core.newline||htf.formSelectClose;
Line: 334

    select MEANING, LOOKUP_CODE
    from   WF_LOOKUPS
    where  LOOKUP_TYPE = p_lookup_type
    order by MEANING;
Line: 341

    select count(1)
    into respcnt
    from WF_LOOKUPS
    where LOOKUP_TYPE = format;
Line: 434

    ** user that was selected.  Since this could be a display name
    ** or an internal name, make sure to get the unique internal name
    */
    l_attr_value := attr_value;
Line: 486

  select WL.MEANING
  into meaning
  from WF_LOOKUPS WL
  where WL.LOOKUP_TYPE = GetLookupMeaning.ltype
  and WL.LOOKUP_CODE = GetLookupMeaning.lcode;
Line: 516

  select count(1),max(NA.TEXT_VALUE)
  into   urlcnt, urlstrg
  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 = 'URL';
Line: 550

  select text_value
  into buf
  from WF_NOTIFICATION_ATTRIBUTES NA,
       WF_MESSAGE_ATTRIBUTES_VL 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 = 'URL'
  and ROWNUM = 1;
Line: 648

    select FROM_USER, TO_USER, SUBJECT
      into from_user, to_user, subject
      from WF_NOTIFICATIONS
     where NOTIFICATION_ID = nid;