APPS.WF_ENTITY_MGR SQL Statements

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

Line: 12

  insert into wf_attribute_cache (
  entity_type,
  entity_key_value,
  attribute_name,
  attribute_value,
  last_update_date,
  change_number)
 values
  (p_entity_type,
   upper(p_entity_key_value),
   'CACHE_CHANGED',
   'PENDING',
   sysdate,
   NULL);

Line: 66

      update wf_attribute_cache
      set    attribute_value = 'YES'
      where  entity_type = p_entity_type
      and    entity_key_value = upper(p_entity_key_value)
      and    attribute_name = 'CACHE_CHANGED';

Line: 84

  update wf_attribute_cache
  set    attribute_value = nvl(p_value, '*NULL*'),
         last_update_date = sysdate,
         change_number = nvl(p_change_number, change_number)
  where  entity_type = p_entity_type
  and    entity_key_value = upper(p_entity_key_value)
  and    attribute_name = upper(p_att);

Line: 95

    insert into wf_attribute_cache (
      entity_type,
      entity_key_value,
      attribute_name,
      attribute_value,
      last_update_date,
      change_number)
        values
     (p_entity_type,
      upper(p_entity_key_value),
      upper(p_att),
      nvl(p_value, '*NULL*'),
      sysdate,
      p_change_number);

Line: 197

  select attribute_value into my_att_val
  from   wf_attribute_cache
  where  entity_type = upper(p_entity_type)
  and    entity_key_value = upper(p_entity_key_value)
  and    attribute_name = upper(p_attribute);

Line: 255

    null;  -- means "do not update" like for fndload --

Line: 292

    delete from wf_attribute_cache
    where  entity_type = upper(p_entity_type)
    and    entity_key_value = upper(p_entity_key_value);

Line: 296

    delete from wf_attribute_cache
    where  ((entity_type is NULL) or (entity_type = upper(p_entity_type)))
    and    ((entity_key_value is NULL) or
            (entity_key_value = upper(p_entity_key_value)));

Line: 334

    select attribute_name aname,
           attribute_value avalue
    from   wf_attribute_cache
    where  entity_type = my_ent_type
    and    entity_key_value = upper(p_event_key)
    and    attribute_name <> 'CACHE_CHANGED';

Line: 383

  delete from WF_ATTRIBUTE_CACHE
  where LAST_UPDATE_DATE <= p_enddate;