APPS.PER_ENV_DEL SQL Statements

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

Line: 51

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

Line: 64

  delete from per_cal_entry_values
  where cal_entry_value_id = p_rec.cal_entry_value_id;

Line: 80

End delete_dml;

Line: 114

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

Line: 122

End pre_delete;

Line: 156

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

Line: 164

    per_env_rkd.after_delete
      (p_cal_entry_value_id => p_rec.cal_entry_value_id
      ,p_calendar_entry_id_o => per_env_shd.g_old_rec.calendar_entry_id
      ,p_hierarchy_node_id_o => per_env_shd.g_old_rec.hierarchy_node_id
      ,p_value_o => per_env_shd.g_old_rec.value
      ,p_org_structure_element_id_o => per_env_shd.g_old_rec.org_structure_element_id
      ,p_organization_id_o => per_env_shd.g_old_rec.organization_id
      ,p_override_name_o => per_env_shd.g_old_rec.override_name
      ,p_override_type_o => per_env_shd.g_old_rec.override_type
      ,p_parent_entry_value_id_o => per_env_shd.g_old_rec.parent_entry_value_id
      ,p_usage_flag_o => per_env_shd.g_old_rec.usage_flag
      ,p_object_version_number_o => per_env_shd.g_old_rec.object_version_number
      );

Line: 189

End post_delete;

Line: 212

  per_env_bus.delete_validate(p_rec);

Line: 219

  per_env_del.pre_delete(p_rec);

Line: 223

  per_env_del.delete_dml(p_rec);

Line: 227

  per_env_del.post_delete(p_rec);