APPS.HRI_OPL_WRKFC_EVT_TYPE SQL Statements

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

Line: 25

  INSERT INTO hri_cl_wevt_evtypcmb_ct
   (etcb_evtypcmb_pk
   ,etcb_evtypcmb_code
   ,etcb_assgnmnt_chng_flag_code
   ,etcb_salary_chng_flag_code
   ,etcb_prfrtng_chng_flag_code
   ,etcb_perfband_chng_flag_code
   ,etcb_powband_chng_flag_code
   ,etcb_hdc_gain_flag_code
   ,etcb_hdc_loss_flag_code
   ,etcb_hdc_chng_flag_code
   ,etcb_fte_gain_flag_code
   ,etcb_fte_loss_flag_code
   ,etcb_fte_chng_flag_code
   ,etcb_grd_chng_flag_code
   ,etcb_job_chng_flag_code
   ,etcb_pos_chng_flag_code
   ,etcb_loc_chng_flag_code
   ,etcb_org_chng_flag_code
   ,etcb_mgrh_chng_flag_code
   ,etcb_hire_flag_code
   ,etcb_asg_start_flag_code
   ,etcb_hire_or_start_flag_code
   ,etcb_term_or_end_flag_code
   ,etcb_term_vol_flag_code
   ,etcb_term_invol_flag_code
   ,etcb_term_flag_code
   ,etcb_asg_end_flag_code
   ,etcb_start_sspnsn_flag_code
   ,etcb_end_sspnsn_flag_code
   ,etcb_prmtn_flag_code)
    VALUES
     (-1
     ,'N-N-N-N-N-N-N-N-N-N-N-N-N-N-N-N-N-N-N-N-N-N-N-N-N-N-N-N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N'
     ,'N');

Line: 109

FUNCTION insert_evtypcmb(p_event_rec    IN evtypcmb_rec_type)
           RETURN NUMBER IS

  l_evtypcmb_fk    NUMBER;

Line: 117

  SELECT hri_cl_wevt_evtypcmb_ct_s.nextval
  INTO l_evtypcmb_fk
  FROM dual;

Line: 122

  INSERT INTO hri_cl_wevt_evtypcmb_ct
   (etcb_evtypcmb_pk
   ,etcb_evtypcmb_code
   ,etcb_assgnmnt_chng_flag_code
   ,etcb_salary_chng_flag_code
   ,etcb_prfrtng_chng_flag_code
   ,etcb_perfband_chng_flag_code
   ,etcb_powband_chng_flag_code
   ,etcb_hdc_gain_flag_code
   ,etcb_hdc_loss_flag_code
   ,etcb_hdc_chng_flag_code
   ,etcb_fte_gain_flag_code
   ,etcb_fte_loss_flag_code
   ,etcb_fte_chng_flag_code
   ,etcb_grd_chng_flag_code
   ,etcb_job_chng_flag_code
   ,etcb_pos_chng_flag_code
   ,etcb_loc_chng_flag_code
   ,etcb_org_chng_flag_code
   ,etcb_mgrh_chng_flag_code
   ,etcb_hire_flag_code
   ,etcb_asg_start_flag_code
   ,etcb_hire_or_start_flag_code
   ,etcb_term_or_end_flag_code
   ,etcb_term_vol_flag_code
   ,etcb_term_invol_flag_code
   ,etcb_term_flag_code
   ,etcb_asg_end_flag_code
   ,etcb_start_sspnsn_flag_code
   ,etcb_end_sspnsn_flag_code
   ,etcb_prmtn_flag_code)
    VALUES
     (l_evtypcmb_fk
     ,p_event_rec.evtypcmb_code
     ,p_event_rec.assgnmnt_chng_flag_code
     ,p_event_rec.salary_chng_flag_code
     ,p_event_rec.prfrtng_chng_flag_code
     ,p_event_rec.perfband_chng_flag_code
     ,p_event_rec.powband_chng_flag_code
     ,p_event_rec.hdc_gain_flag_code
     ,p_event_rec.hdc_loss_flag_code
     ,p_event_rec.hdc_chng_flag_code
     ,p_event_rec.fte_gain_flag_code
     ,p_event_rec.fte_loss_flag_code
     ,p_event_rec.fte_chng_flag_code
     ,p_event_rec.grd_chng_flag_code
     ,p_event_rec.job_chng_flag_code
     ,p_event_rec.pos_chng_flag_code
     ,p_event_rec.loc_chng_flag_code
     ,p_event_rec.org_chng_flag_code
     ,p_event_rec.mgrh_chng_flag_code
     ,p_event_rec.hire_flag_code
     ,p_event_rec.asg_start_flag_code
     ,p_event_rec.hire_or_start_flag_code
     ,p_event_rec.term_or_end_flag_code
     ,p_event_rec.term_vol_flag_code
     ,p_event_rec.term_invol_flag_code
     ,p_event_rec.term_flag_code
     ,p_event_rec.asg_end_flag_code
     ,p_event_rec.start_sspnsn_flag_code
     ,p_event_rec.end_sspnsn_flag_code
     ,p_event_rec.prmtn_flag_code);

Line: 185

END insert_evtypcmb;

Line: 240

  SELECT etcb_evtypcmb_pk
  FROM hri_cl_wevt_evtypcmb_ct
  WHERE etcb_evtypcmb_code = v_evtypcmb_code;

Line: 296

      l_evtypcmb_fk := insert_evtypcmb
                             (p_event_rec => p_event_rec);