APPS.WF_ITEM_ATTRIBUTES_VL_PUB SQL Statements

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

Line: 42

                        You'll notice that we are selecting the attribute
                        display name twice.  The second occurrence is simply a
                        placeholder in the record so that I can fill in that column
                        with the lookup type display name if this attribute is
                        validated based on a lookup type.

  PARAMETERS:

        c_item_type IN  Internal name of the item type

============================================================================*/
CURSOR c_fetch_item_attributes (c_item_type IN VARCHAR2) IS
SELECT
 row_id,
 item_type,
 name,
 sequence,
 type,
 protect_level,
 custom_level,
 subtype,
 format,
 display_name lookup_type_display_name,
 display_name lookup_code_display_name,
 text_default,
 number_default,
 date_default,
 display_name,
 description
FROM   wf_item_attributes_vl
WHERE  item_type = c_item_type
ORDER  BY sequence;

Line: 96

          SELECT  row_id,
                  item_type,
                  name,
                  sequence,
                  type,
                  protect_level,
                  custom_level,
                  subtype,
                  format,
                  display_name lookup_type_display_name,
                  display_name lookup_code_display_name,
                  text_default,
                  number_default,
                  date_default,
                  display_name,
                  description
          INTO   p_wf_item_attributes_vl_tbl(1)
          FROM   wf_item_attributes_vl
          WHERE  item_type = p_item_type
          AND    name      = p_name;