APPS.PQH_STS_DEL SQL Statements

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

Line: 52

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

Line: 70

  delete from pqh_fr_stat_situations
  where statutory_situation_id = p_rec.statutory_situation_id;

Line: 90

End delete_dml;

Line: 124

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

Line: 137

End pre_delete;

Line: 171

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

Line: 186

    pqh_sts_rkd.after_delete
      (p_statutory_situation_id
      => p_rec.statutory_situation_id
      ,p_business_group_id_o
      => pqh_sts_shd.g_old_rec.business_group_id
      ,p_situation_name_o
      => pqh_sts_shd.g_old_rec.situation_name
      ,p_type_of_ps_o
      => pqh_sts_shd.g_old_rec.type_of_ps
      ,p_situation_type_o
      => pqh_sts_shd.g_old_rec.situation_type
      ,p_sub_type_o
      => pqh_sts_shd.g_old_rec.sub_type
      ,p_source_o
      => pqh_sts_shd.g_old_rec.source
      ,p_location_o
      => pqh_sts_shd.g_old_rec.location
      ,p_reason_o
      => pqh_sts_shd.g_old_rec.reason
      ,p_is_default_o
      => pqh_sts_shd.g_old_rec.is_default
      ,p_date_from_o
      => pqh_sts_shd.g_old_rec.date_from
      ,p_date_to_o
      => pqh_sts_shd.g_old_rec.date_to
      ,p_request_type_o
      => pqh_sts_shd.g_old_rec.request_type
      ,p_employee_agreement_needed_o
      => pqh_sts_shd.g_old_rec.employee_agreement_needed
      ,p_manager_agreement_needed_o
      => pqh_sts_shd.g_old_rec.manager_agreement_needed
      ,p_print_arrette_o
      => pqh_sts_shd.g_old_rec.print_arrette
      ,p_reserve_position_o
      => pqh_sts_shd.g_old_rec.reserve_position
      ,p_allow_progressions_o
      => pqh_sts_shd.g_old_rec.allow_progressions
      ,p_extend_probation_period_o
      => pqh_sts_shd.g_old_rec.extend_probation_period
      ,p_remuneration_paid_o
      => pqh_sts_shd.g_old_rec.remuneration_paid
      ,p_pay_share_o
      => pqh_sts_shd.g_old_rec.pay_share
      ,p_pay_periods_o
      => pqh_sts_shd.g_old_rec.pay_periods
      ,p_frequency_o
      => pqh_sts_shd.g_old_rec.frequency
      ,p_first_period_max_duration_o
      => pqh_sts_shd.g_old_rec.first_period_max_duration
      ,p_min_duration_per_request_o
      => pqh_sts_shd.g_old_rec.min_duration_per_request
      ,p_max_duration_per_request_o
      => pqh_sts_shd.g_old_rec.max_duration_per_request
      ,p_max_duration_whole_career_o
      => pqh_sts_shd.g_old_rec.max_duration_whole_career
      ,p_renewable_allowed_o
      => pqh_sts_shd.g_old_rec.renewable_allowed
      ,p_max_no_of_renewals_o
      => pqh_sts_shd.g_old_rec.max_no_of_renewals
      ,p_max_duration_per_renewal_o
      => pqh_sts_shd.g_old_rec.max_duration_per_renewal
      ,p_max_tot_continuous_duratio_o
      => pqh_sts_shd.g_old_rec.max_tot_continuous_duration
      ,p_object_version_number_o
      => pqh_sts_shd.g_old_rec.object_version_number
      ,p_remunerate_assign_stat_id_o
      => pqh_sts_shd.g_old_rec.remunerate_assign_status_id
      );

Line: 270

End post_delete;

Line: 297

  pqh_sts_bus.delete_validate(p_rec);

Line: 304

  pqh_sts_del.pre_delete(p_rec);

Line: 308

  pqh_sts_del.delete_dml(p_rec);

Line: 312

  pqh_sts_del.post_delete(p_rec);