APPS.HR_EMP_ERROR_UTILITY SQL Statements

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

Line: 119

     select count(*)
     from   wf_item_attribute_values iav
     where  iav.item_type = p_item_type
     and    iav.item_key  = p_item_key
     and    iav.name like p_type||':%';

Line: 125

    select min(to_number(substr(iav.name
                               ,instr(iav.name,':',1,2) + 1)))
    from   wf_item_attribute_values iav
    where  iav.item_type = p_item_type
    and    iav.item_key  = p_item_key
    and    iav.name like p_type||':%'
    and    to_number(substr(iav.name
                           ,instr(iav.name,':') + 1
                           ,instr(iav.name,':',1,2)
                            - instr(iav.name,':') - 1))
           = p_transaction_step_id
    and    iav.text_value IS NULL;

Line: 248

  select iav.text_value
    from   hr_api_transaction_steps hats
          ,wf_item_attribute_values iav
    where iav.item_type = p_item_type
    and   iav.item_key = p_item_key
    and   iav.name like p_type||':%'
    and   hats.activity_id = p_actid
    and   hats.transaction_step_id =
            to_number(substr(iav.name
                     ,instr(iav.name,':') + 1
                     ,instr(iav.name,':',1,2) - instr(iav.name,':') - 1));

Line: 261

  /*  select iav.text_value
    from   hr_api_transaction_steps hats
          ,wf_item_attribute_values iav
    where hats.activity_id = p_actid
    and   hats.item_type = p_item_type
    and   hats.item_key = p_item_key
    and   iav.name like p_type||':%'
    and   hats.transaction_step_id =
            to_number(substr(iav.name
                     ,instr(iav.name,':') + 1
                     ,instr(iav.name,':',1,2) - instr(iav.name,':') - 1));

Line: 341

   select iav.text_value
    from   hr_api_transaction_steps hats
          ,wf_item_attribute_values iav
    where iav.item_type = p_item_type
    and   iav.item_key = p_item_key
    and   iav.name like p_type||':%'
    and   hats.activity_id = p_actid
    and   hats.transaction_step_id = p_transaction_step_id
    and   hats.transaction_step_id =
            to_number(substr(iav.name
                     ,instr(iav.name,':') + 1
                     ,instr(iav.name,':',1,2) - instr(iav.name,':') - 1));

Line: 355

    /*select iav.text_value
    from   hr_api_transaction_steps hats
          ,wf_item_attribute_values iav
    where hats.activity_id = p_actid
    and   hats.item_type = p_item_type
    and   hats.item_key = p_item_key
    and   iav.name like p_type||':%'
    and   hats.transaction_step_id = p_transaction_step_id
    and   hats.transaction_step_id =
            to_number(substr(iav.name
                     ,instr(iav.name,':') + 1
                     ,instr(iav.name,':',1,2) - instr(iav.name,':') - 1));

Line: 662

  SELECT iav.name
    FROM  wf_item_attribute_values iav,
          hr_api_transaction_steps hats
   WHERE  iav.item_type = hats.item_type
   AND    iav.item_key = hats.item_key
   AND  (iav.name LIKE 'ERROR_TEXT:%'
   OR    iav.name LIKE 'WARNING_TEXT:%')
   AND    TO_NUMBER(SUBSTR(iav.name,
              INSTR (iav.name, ':') + 1,
              INSTR (iav.name, ':', 1, 2) - INSTR (iav.name, ':') - 1)) =
         hats.transaction_step_id
   AND    hats.item_type = p_item_type
   AND    hats.item_key = p_item_key
   AND    hats.activity_id = p_actid;

Line: 678

    select iav.name
    from   wf_item_attribute_values iav
    where  iav.item_type = p_item_type
    and    iav.item_key  = p_item_key
    and    iav.name like 'ERROR_TEXT'||':%'
    or    iav.name like 'WARNING_TEXT'||':%'
    and    to_number(
             substr(iav.name
                   ,instr(iav.name,':') + 1
                   ,instr(iav.name,':',1,2) - instr(iav.name,':') - 1
             )
           ) in
    (select hats.transaction_step_id
     from   hr_api_transaction_steps hats
     where  hats.item_type = p_item_type
         and    hats.item_key  = p_item_key
     and    hats.activity_id   = p_actid);*/

Line: 729

  SELECT iav.name
    FROM  wf_item_attribute_values iav
   WHERE  iav.item_type = p_item_type
   AND    iav.item_key  = p_item_key
   AND  (iav.name LIKE 'ERROR_TEXT:%'
   OR    iav.name LIKE 'WARNING_TEXT:%')
   AND    TO_NUMBER(SUBSTR(iav.name,
        INSTR(iav.name, ':') + 1,
        INSTR(iav.name, ':', 1, 2) - INSTR(iav.name, ':') - 1)) =
      p_transaction_step_id;

Line: 741

    select iav.name
    from   wf_item_attribute_values iav
    where  iav.item_type = p_item_type
    and    iav.item_key  = p_item_key
    and    iav.name like 'ERROR_TEXT'||':%'
    or    iav.name like 'WARNING_TEXT'||':%'
    and    to_number(
             substr(iav.name
                   ,instr(iav.name,':') + 1
                   ,instr(iav.name,':',1,2) - instr(iav.name,':') - 1
             )
           ) = p_transaction_step_id; */