APPS.PQH_STS_INS SQL Statements

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

Line: 88

Procedure insert_dml
  (p_rec in out nocopy pqh_sts_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';

Line: 107

  insert into pqh_fr_stat_situations
      (statutory_situation_id
      ,business_group_id
      ,situation_name
      ,type_of_ps
      ,situation_type
      ,sub_type
      ,source
      ,location
      ,reason
      ,default_flag
      ,date_from
      ,date_to
      ,request_type
      ,employee_agreement_needed
      ,manager_agreement_needed
      ,print_arrette
      ,reserve_position
      ,allow_progression_flag
      ,extend_probation_period_flag
      ,remuneration_paid
      ,pay_share
      ,pay_periods
      ,frequency
      ,first_period_max_duration
      ,min_duration_per_request
      ,max_duration_per_request
      ,max_duration_whole_career
      ,renewable_allowed
      ,max_no_of_renewals
      ,max_duration_per_renewal
      ,max_tot_continuous_duration
      ,object_version_number
      ,remunerate_assign_status_id
      )
  Values
    (p_rec.statutory_situation_id
    ,p_rec.business_group_id
    ,p_rec.situation_name
    ,p_rec.type_of_ps
    ,p_rec.situation_type
    ,p_rec.sub_type
    ,p_rec.source
    ,p_rec.location
    ,p_rec.reason
    ,p_rec.is_default
    ,p_rec.date_from
    ,p_rec.date_to
    ,p_rec.request_type
    ,p_rec.employee_agreement_needed
    ,p_rec.manager_agreement_needed
    ,p_rec.print_arrette
    ,p_rec.reserve_position
    ,p_rec.allow_progressions
    ,p_rec.extend_probation_period
    ,p_rec.remuneration_paid
    ,p_rec.pay_share
    ,p_rec.pay_periods
    ,p_rec.frequency
    ,p_rec.first_period_max_duration
    ,p_rec.min_duration_per_request
    ,p_rec.max_duration_per_request
    ,p_rec.max_duration_whole_career
    ,p_rec.renewable_allowed
    ,p_rec.max_no_of_renewals
    ,p_rec.max_duration_per_renewal
    ,p_rec.max_tot_continuous_duration
    ,p_rec.object_version_number
    ,p_rec.remunerate_assign_status_id
    );

Line: 205

End insert_dml;

Line: 244

Procedure pre_insert
  (p_rec  in out nocopy pqh_sts_shd.g_rec_type
  ) is
--
  Cursor C_Sel1 is select pqh_fr_stat_situations_s.nextval from sys.dual;

Line: 251

    Select null
      from pqh_fr_stat_situations
     where statutory_situation_id =
             pqh_sts_ins.g_statutory_situation_id_i;

Line: 256

  l_proc   varchar2(72) := g_package||'pre_insert';

Line: 305

End pre_insert;

Line: 339

Procedure post_insert
  (p_effective_date               in date
  ,p_rec                          in pqh_sts_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'post_insert';

Line: 354

    pqh_sts_rki.after_insert
      (p_effective_date              => p_effective_date
      ,p_statutory_situation_id
      => p_rec.statutory_situation_id
      ,p_business_group_id
      => p_rec.business_group_id
      ,p_situation_name
      => p_rec.situation_name
      ,p_type_of_ps
      => p_rec.type_of_ps
      ,p_situation_type
      => p_rec.situation_type
      ,p_sub_type
      => p_rec.sub_type
      ,p_source
      => p_rec.source
      ,p_is_default
      => p_rec.is_default
      ,p_location
      => p_rec.location
      ,p_reason
      => p_rec.reason
      ,p_date_from
      => p_rec.date_from
      ,p_date_to
      => p_rec.date_to
      ,p_request_type
      => p_rec.request_type
      ,p_employee_agreement_needed
      => p_rec.employee_agreement_needed
      ,p_manager_agreement_needed
      => p_rec.manager_agreement_needed
      ,p_print_arrette
      => p_rec.print_arrette
      ,p_reserve_position
      => p_rec.reserve_position
      ,p_allow_progressions
      => p_rec.allow_progressions
      ,p_extend_probation_period
      => p_rec.extend_probation_period
      ,p_remuneration_paid
      => p_rec.remuneration_paid
      ,p_pay_share
      => p_rec.pay_share
      ,p_pay_periods
      => p_rec.pay_periods
      ,p_frequency
      => p_rec.frequency
      ,p_first_period_max_duration
      => p_rec.first_period_max_duration
      ,p_min_duration_per_request
      => p_rec.min_duration_per_request
      ,p_max_duration_per_request
      => p_rec.max_duration_per_request
      ,p_max_duration_whole_career
      => p_rec.max_duration_whole_career
      ,p_renewable_allowed
      => p_rec.renewable_allowed
      ,p_max_no_of_renewals
      => p_rec.max_no_of_renewals
      ,p_max_duration_per_renewal
      => p_rec.max_duration_per_renewal
      ,p_max_tot_continuous_duration
      => p_rec.max_tot_continuous_duration
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_remunerate_assign_status_id
      => p_rec.remunerate_assign_status_id
      );

Line: 439

End post_insert;

Line: 463

  pqh_sts_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 473

  pqh_sts_ins.pre_insert(p_rec);

Line: 477

  pqh_sts_ins.insert_dml(p_rec);

Line: 481

  pqh_sts_ins.post_insert
     (p_effective_date
     ,p_rec
     );