APPS.WF_INITIATE SQL Statements

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

Line: 53

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

Line: 67

              htf.formSelectOpen('h_fvalues',
                                  cattributes=>'id="i_attr'||seq||'"');

Line: 74

                  htf.formSelectOption(cvalue=>i.meaning,
                                       cattributes=>'value='||i.lookup_code,
			               cselected=>'SELECTED');

Line: 79

                  htf.formSelectOption(cvalue=>i.meaning,
                                       cattributes=>'value='||i.lookup_code);

Line: 83

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

Line: 271

  select WL.MEANING
  from WF_LOOKUPS WL
  where WL.LOOKUP_TYPE = GetLookupMeaning.ltype
  and WL.LOOKUP_CODE = GetLookupMeaning.lcode;

Line: 363

  select name, display_name, nvl(description,' ') description

Line: 458

  select name, display_name, type, subtype, format,
         text_default, number_default, date_default
  from   wf_item_attributes_vl
  where  item_type = Process.itemtype
  order by sequence;

Line: 467

  select wfrp.process_name, wfrp.display_name
  from   wf_runnable_processes_v wfrp
  where  wfrp.item_type =  Process.itemtype
  order  by wfrp.display_name;

Line: 532

  select display_name
  into   l_ItemTypeDisp
  from   wf_item_types_vl
  where  name = Process.ItemType;

Line: 592

  htp.formSelectOpen(cname=>'Process',cattributes=>'id="i_process_name"');

Line: 595

  htp.formSelectOption(cvalue=>wf_core.translate('WFA_NULL_PROCESS')
			,cattributes=>'value='||'""');

Line: 598

	htp.formSelectOption(cvalue=>wfp.display_name
			,cattributes=>'value='||'"'||wfp.process_name||'"');

Line: 602

  htp.formSelectClose;

Line: 789

      ** 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;