DBA Data[Home] [Help]

APPS.WF_ITEM_TYPES_VL_PUB SQL Statements

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

Line: 53

   SELECT rowid,
          name,
          protect_level,
          custom_level,
          wf_selector,
          read_role,
          write_role,
          execute_role,
          display_name,
          description
   INTO   p_wf_item_types_vl_tbl(1)
   FROM   wf_item_types_vl
   WHERE  name = p_name;
Line: 188

      ** Create the selector row in the table
      */
      wf_item_definition_util_pub.draw_detail_prompt_value_pair (
         wf_core.translate('WFITD_SELECTOR'),
         p_wf_item_types_vl_tbl(l_record_num).wf_selector);