DBA Data[Home] [Help]

APPS.PAY_AMO_UPD SQL Statements

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

Line: 54

Procedure update_dml
  (p_rec in out nocopy pay_amo_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72);
Line: 61

  l_proc  := g_package||'update_dml';
Line: 72

  update pay_au_modules
    set
     module_id                       = p_rec.module_id
    ,name                            = p_rec.name
    ,enabled_flag                    = p_rec.enabled_flag
    ,module_type_id                  = p_rec.module_type_id
    ,business_group_id               = p_rec.business_group_id
    ,legislation_code                = p_rec.legislation_code
    ,description                     = p_rec.description
    ,package_name                    = p_rec.package_name
    ,procedure_function_name         = p_rec.procedure_function_name
    ,formula_name                    = p_rec.formula_name
    ,object_version_number           = p_rec.object_version_number
    where module_id = p_rec.module_id;
Line: 110

End update_dml;
Line: 144

Procedure pre_update
  (p_rec in pay_amo_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72);
Line: 151

  l_proc := g_package||'pre_update';
Line: 156

End pre_update;
Line: 190

Procedure post_update
  (p_rec                          in pay_amo_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72);
Line: 197

  l_proc  := g_package||'post_update';
Line: 202

End post_update;
Line: 325

  pay_amo_bus.update_validate
     (p_rec
     );
Line: 334

  pay_amo_upd.pre_update(p_rec);
Line: 338

  pay_amo_upd.update_dml(p_rec);
Line: 342

  pay_amo_upd.post_update
     (p_rec
     );