APPS.PAY_SIV_UPD SQL Statements

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

Line: 51

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

Line: 65

  update pay_shadow_input_values
  set
  input_value_id                    = p_rec.input_value_id,
  element_type_id                   = p_rec.element_type_id,
  display_sequence                  = p_rec.display_sequence,
  generate_db_items_flag            = p_rec.generate_db_items_flag,
  hot_default_flag                  = p_rec.hot_default_flag,
  mandatory_flag                    = p_rec.mandatory_flag,
  name                              = p_rec.name,
  uom                               = p_rec.uom,
  lookup_type                       = p_rec.lookup_type,
  default_value                     = p_rec.default_value,
  max_value                         = p_rec.max_value,
  min_value                         = p_rec.min_value,
  warning_or_error                  = p_rec.warning_or_error,
  default_value_column              = p_rec.default_value_column,
  exclusion_rule_id                 = p_rec.exclusion_rule_id,
  formula_id			    = p_rec.formula_id,
  input_validation_formula	    = p_rec.input_validation_formula,
  object_version_number             = p_rec.object_version_number
  where input_value_id = p_rec.input_value_id;

Line: 105

End update_dml;

Line: 139

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

Line: 147

End pre_update;

Line: 181

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

Line: 189

End post_update;

Line: 346

  pay_siv_bus.update_validate(p_effective_date, p_rec);

Line: 350

  pre_update(p_rec);

Line: 354

  update_dml(p_rec);

Line: 358

  post_update(p_rec);