APPS.HRI_BPL_CONC_LOG SQL Statements

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

Line: 480

PROCEDURE delete_process_log( p_process_code    IN VARCHAR2 ) IS
--
BEGIN
  --
  bis_collection_utilities.deleteLogForObject(p_object_name => p_process_code);

Line: 486

END delete_process_log;

Line: 579

  SELECT hri_adm_msg_log_s.nextval
  INTO   l_msg_log_id
  FROM   dual;

Line: 642

      INSERT INTO hri_adm_msg_log
             (msg_log_id
             ,mthd_action_id
             ,msg_type
             ,package_name
             ,effective_date
             ,person_id
             ,assignment_id
             ,job_id
             ,location_id
             ,event_id
             ,supervisor_id
             ,person_type_id
             ,formula_id
             ,other_ref_id
             ,other_ref_column
             ,msg_group
             ,msg_sub_group
             ,sql_err_code
             ,fnd_msg_name
             ,note
             )
      VALUES
             (g_msg_log_array(i).msg_log_id
             ,g_mthd_action_id
             ,g_msg_log_array(i).msg_type
             ,g_msg_log_array(i).package_name
             ,g_msg_log_array(i).effective_date
             ,g_msg_log_array(i).person_id
             ,g_msg_log_array(i).assignment_id
             ,g_msg_log_array(i).job_id
             ,g_msg_log_array(i).location_id
             ,g_msg_log_array(i).event_id
             ,g_msg_log_array(i).supervisor_id
             ,g_msg_log_array(i).person_type_id
             ,g_msg_log_array(i).formula_id
             ,g_msg_log_array(i).other_ref_id
             ,g_msg_log_array(i).other_ref_column
             ,g_msg_log_array(i).msg_group
             ,g_msg_log_array(i).msg_sub_group
             ,g_msg_log_array(i).sql_err_code
             ,g_msg_log_array(i).fnd_msg_name
             ,g_msg_log_array(i).note
             );

Line: 749

  SELECT 'Y'
  FROM dual
  WHERE EXISTS
   (SELECT null
    FROM hri_adm_msg_log
    WHERE mthd_action_id = v_mthd_action_id
    AND msg_type in ('ERROR','WARNING'));

Line: 826

  UPDATE hri_adm_mthd_actions
  SET    status              =  l_status,
         end_time            =  sysdate,
         collect_from_date   =  p_period_from,
         collect_to_date     =  p_period_to,
         process_type        =  p_process_type,
         program             =  p_package_name,
         full_refresh_flag   =  p_full_refresh,
         attribute1          =  p_attribute1,
         attribute2          =  p_attribute2,
         attribute3          =  p_attribute3,
         attribute4          =  p_attribute4,
         attribute5          =  p_attribute5,
         attribute6          =  p_attribute6,
         attribute7          =  p_attribute7,
         attribute8          =  p_attribute8,
         attribute9          =  p_attribute9,
         attribute10         =  p_attribute10,
         attribute11         =  p_attribute11,
         attribute12         =  p_attribute12,
         attribute13         =  p_attribute13,
         attribute14         =  p_attribute14,
         attribute15         =  p_attribute15,
         attribute16         =  p_attribute16,
         attribute17         =  p_attribute17,
         attribute18         =  p_attribute18,
         attribute19         =  p_attribute19,
         attribute20         =  p_attribute20
  WHERE mthd_action_id       =  g_mthd_action_id;