APPS.PER_PCE_UPD SQL Statements

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

Line: 54

PROCEDURE update_dml
  (p_rec IN OUT NOCOPY per_pce_shd.g_rec_type
  ) IS
--
  l_proc  VARCHAR2(72) := g_package||'update_dml';

Line: 70

  update per_cagr_entitlements
    set
     cagr_entitlement_id             = p_rec.cagr_entitlement_id
    ,cagr_entitlement_item_id        = p_rec.cagr_entitlement_item_id
    ,collective_agreement_id         = p_rec.collective_agreement_id
    ,status                          = p_rec.status
	,end_date                        = p_rec.end_date
    ,formula_criteria                = p_rec.formula_criteria
    ,formula_id                      = p_rec.formula_id
    ,units_of_measure                = p_rec.units_of_measure
	,message_level                   = p_rec.message_level
    ,object_version_number           = p_rec.object_version_number
    where cagr_entitlement_id = p_rec.cagr_entitlement_id;

Line: 107

END update_dml;

Line: 141

PROCEDURE pre_update
  (p_rec IN per_pce_shd.g_rec_type
  ) IS
--
  l_proc  VARCHAR2(72) := g_package||'pre_update';

Line: 151

END pre_update;

Line: 185

PROCEDURE post_update
  (p_effective_date               IN DATE
  ,p_rec                          IN per_pce_shd.g_rec_type
  ) IS
--
  l_proc  VARCHAR2(72) := g_package||'post_update';

Line: 196

    per_pce_rku.after_update
      (p_effective_date              => p_effective_date
      ,p_cagr_entitlement_id         => p_rec.cagr_entitlement_id
      ,p_cagr_entitlement_item_id    => p_rec.cagr_entitlement_item_id
      ,p_collective_agreement_id     => p_rec.collective_agreement_id
      ,p_start_date                  => p_rec.start_date
      ,p_end_date                    => p_rec.end_date
      ,p_status                      => p_rec.status
      ,p_formula_criteria            => p_rec.formula_criteria
      ,p_formula_id                  => p_rec.formula_id
      ,p_units_of_measure            => p_rec.units_of_measure
	  ,p_message_level               => p_rec.message_level
      ,p_object_version_number       => p_rec.object_version_number
      ,p_cagr_entitlement_item_id_o  => per_pce_shd.g_old_rec.cagr_entitlement_item_id
      ,p_collective_agreement_id_o   => per_pce_shd.g_old_rec.collective_agreement_id
      ,p_start_date_o                => per_pce_shd.g_old_rec.start_date
      ,p_end_date_o                  => per_pce_shd.g_old_rec.end_date
      ,p_status_o                    => per_pce_shd.g_old_rec.status
      ,p_formula_criteria_o          => per_pce_shd.g_old_rec.formula_criteria
      ,p_formula_id_o                => per_pce_shd.g_old_rec.formula_id
      ,p_units_of_measure_o          => per_pce_shd.g_old_rec.units_of_measure
	  ,p_message_level_o             => per_pce_shd.g_old_rec.message_level
      ,p_object_version_number_o     => per_pce_shd.g_old_rec.object_version_number
      );

Line: 232

END post_update;

Line: 354

  per_pce_bus.update_validate
     (p_effective_date
     ,p_rec
     );

Line: 361

  per_pce_upd.pre_update(p_rec);

Line: 365

  per_pce_upd.update_dml(p_rec);

Line: 369

  per_pce_upd.post_update
     (p_effective_date
     ,p_rec
     );