APPS.PQP_EXR_UPD SQL Statements

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

Line: 54

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

Line: 74

  update pqp_exception_reports
    set
     exception_report_id             = p_rec.exception_report_id
    ,exception_report_name           = p_rec.exception_report_name
    ,legislation_code                = p_rec.legislation_code
    ,business_group_id               = p_rec.business_group_id
    ,currency_code                   = p_rec.currency_code
    ,balance_type_id                 = p_rec.balance_type_id
    ,balance_dimension_id            = p_rec.balance_dimension_id
    ,variance_type                   = p_rec.variance_type
    ,variance_value                  = p_rec.variance_value
    ,comparison_type                 = p_rec.comparison_type
    ,comparison_value                = p_rec.comparison_value
    ,object_version_number           = p_rec.object_version_number
    ,output_format                   = p_rec.output_format_type
    ,variance_operator               = p_rec.variance_operator
     where exception_report_id = p_rec.exception_report_id;

Line: 94

  update pqp_exception_reports
    set
     exception_report_id             = p_rec.exception_report_id
    ,exception_report_name           = p_rec.exception_report_name
    ,legislation_code                = p_rec.legislation_code
    ,business_group_id               = p_rec.business_group_id
    ,currency_code                   = p_rec.currency_code
    ,balance_type_id                 = p_rec.balance_type_id
    ,balance_dimension_id            = p_rec.balance_dimension_id
    ,variance_type                   = p_rec.variance_type
    ,variance_value                  = p_rec.variance_value
    ,comparison_type                 = p_rec.comparison_type
    ,comparison_value                = p_rec.comparison_value
    ,object_version_number           = p_rec.object_version_number
    ,output_format                   = p_rec.output_format_type
    ,variance_operator               = p_rec.variance_operator
    ,last_updated_by                 = 2
    ,last_update_date                = sysdate
     where exception_report_id = p_rec.exception_report_id;

Line: 139

End update_dml;

Line: 173

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

Line: 183

End pre_update;

Line: 217

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

Line: 227

    pqp_exr_rku.after_update (
      p_exception_report_id      => p_rec.exception_report_id
      ,p_exception_report_name   => p_rec.exception_report_name
        ,p_legislation_code      => p_rec.legislation_code
      ,p_business_group_id       => p_rec.business_group_id
      ,p_currency_code           => p_rec.currency_code
      ,p_balance_type_id         => p_rec.balance_type_id
      ,p_balance_dimension_id    => p_rec.balance_dimension_id
      ,p_variance_type           => p_rec.variance_type
      ,p_variance_value          => p_rec.variance_value
      ,p_comparison_type         => p_rec.comparison_type
      ,p_comparison_value        => p_rec.comparison_value
      ,p_object_version_number   => p_rec.object_version_number
      ,p_output_format_type      => p_rec.output_format_type
      ,p_variance_operator       => p_rec.variance_operator
      ,p_exception_report_name_o => pqp_exr_shd.g_old_rec.exception_report_name
      ,p_legislation_code_o      => pqp_exr_shd.g_old_rec.legislation_code
      ,p_business_group_id_o     => pqp_exr_shd.g_old_rec.business_group_id
      ,p_currency_code_o         => pqp_exr_shd.g_old_rec.currency_code
      ,p_balance_type_id_o       => pqp_exr_shd.g_old_rec.balance_type_id
      ,p_balance_dimension_id_o  => pqp_exr_shd.g_old_rec.balance_dimension_id
      ,p_variance_type_o         => pqp_exr_shd.g_old_rec.variance_type
      ,p_variance_value_o        => pqp_exr_shd.g_old_rec.variance_value
      ,p_comparison_type_o       => pqp_exr_shd.g_old_rec.comparison_type
      ,p_comparison_value_o      => pqp_exr_shd.g_old_rec.comparison_value
      ,p_object_version_number_o => pqp_exr_shd.g_old_rec.object_version_number
      ,p_output_format_type_o    => pqp_exr_shd.g_old_rec.output_format_type
      ,p_variance_operator_o     => pqp_exr_shd.g_old_rec.variance_operator
         );

Line: 268

End post_update;

Line: 401

  pqp_exr_bus.update_validate
     (p_rec
     );

Line: 409

  pqp_exr_upd.pre_update(p_rec);

Line: 413

  pqp_exr_upd.update_dml(p_rec);

Line: 417

  pqp_exr_upd.post_update
     (p_rec
     );