APPS.PER_PYP_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_pyp_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_dml';

Line: 69

  update per_pay_proposals
  set
  pay_proposal_id                   = p_rec.pay_proposal_id,
  event_id                          = null,
  change_date                       = p_rec.change_date,
  comments                          = p_rec.comments,
  next_perf_review_date             = null,
  next_sal_review_date              = p_rec.next_sal_review_date,
  performance_rating                = null,
  proposal_reason                   = p_rec.proposal_reason,
  proposed_salary_n                 = p_rec.proposed_salary_n,
  review_date                       = null,
  forced_ranking                    = p_rec.forced_ranking,
  date_to         = p_rec.date_to,
  performance_review_id             = p_rec.performance_review_id,
  attribute_category                = p_rec.attribute_category,
  attribute1                        = p_rec.attribute1,
  attribute2                        = p_rec.attribute2,
  attribute3                        = p_rec.attribute3,
  attribute4                        = p_rec.attribute4,
  attribute5                        = p_rec.attribute5,
  attribute6                        = p_rec.attribute6,
  attribute7                        = p_rec.attribute7,
  attribute8                        = p_rec.attribute8,
  attribute9                        = p_rec.attribute9,
  attribute10                       = p_rec.attribute10,
  attribute11                       = p_rec.attribute11,
  attribute12                       = p_rec.attribute12,
  attribute13                       = p_rec.attribute13,
  attribute14                       = p_rec.attribute14,
  attribute15                       = p_rec.attribute15,
  attribute16                       = p_rec.attribute16,
  attribute17                       = p_rec.attribute17,
  attribute18                       = p_rec.attribute18,
  attribute19                       = p_rec.attribute19,
  attribute20                       = p_rec.attribute20,
  object_version_number             = p_rec.object_version_number,
  multiple_components               = p_rec.multiple_components,
  approved                          = p_rec.approved
  where pay_proposal_id = p_rec.pay_proposal_id;

Line: 133

End update_dml;

Line: 167

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

Line: 175

End pre_update;

Line: 209

Procedure post_update
  (p_rec        in per_pyp_shd.g_rec_type
        ,p_inv_next_sal_date_warning    in  boolean
        ,p_proposed_salary_warning      in  boolean
        ,p_approved_warning             in  boolean
        ,p_payroll_warning              in  boolean
) is
--
  l_proc  varchar2(72) := g_package||'post_update';

Line: 334

          select proposed_salary_n into l_old_salary from per_pay_proposals
          where assignment_id = p_rec.ASSIGNMENT_ID and
              change_date   = (select max(change_date) from per_pay_proposals where
          change_date < p_rec.change_date and assignment_id = p_rec.ASSIGNMENT_ID );

Line: 414

     l_event                             := 'UPDATE' ;

Line: 416

        l_ext_new_rec.update_mode := 'CORRECTION';

Line: 417

        l_ext_old_rec.update_mode := 'CORRECTION';

Line: 419

        l_ext_new_rec.update_mode := 'UPDATE';

Line: 420

        l_ext_old_rec.update_mode := 'UPDATE';

Line: 425

  per_pyp_rku.after_update
    (
     p_pay_proposal_id              => p_rec.pay_proposal_id,
     p_change_date                  => p_rec.change_date,
     p_comments                     => p_rec.comments,
     p_next_sal_review_date         => p_rec.next_sal_review_date,
     p_proposal_reason              => p_rec.proposal_reason,
     p_proposed_salary_n            => p_rec.proposed_salary_n,
     p_forced_ranking               => p_rec.forced_ranking,
     p_date_to          => p_rec.date_to,
     p_performance_review_id        => p_rec.performance_review_id,
     p_attribute_category           => p_rec.attribute_category,
     p_attribute1                   => p_rec.attribute1,
     p_attribute2                   => p_rec.attribute2,
     p_attribute3                   => p_rec.attribute3,
     p_attribute4                   => p_rec.attribute4,
     p_attribute5                   => p_rec.attribute5,
     p_attribute6                   => p_rec.attribute6,
     p_attribute7                   => p_rec.attribute7,
     p_attribute8                   => p_rec.attribute8,
     p_attribute9                   => p_rec.attribute9,
     p_attribute10                  => p_rec.attribute10,
     p_attribute11                  => p_rec.attribute11,
     p_attribute12                  => p_rec.attribute12,
     p_attribute13                  => p_rec.attribute13,
     p_attribute14                  => p_rec.attribute14,
     p_attribute15                  => p_rec.attribute15,
     p_attribute16                  => p_rec.attribute16,
     p_attribute17                  => p_rec.attribute17,
     p_attribute18                  => p_rec.attribute18,
     p_attribute19                  => p_rec.attribute19,
     p_attribute20                  => p_rec.attribute20,
     p_object_version_number        => p_rec.object_version_number,
     p_multiple_components          => p_rec.multiple_components,
     p_approved                     => p_rec.approved,
     p_inv_next_sal_date_warning    => p_inv_next_sal_date_warning,
     p_proposed_salary_warning      => p_proposed_salary_warning,
     p_approved_warning             => p_approved_warning,
     p_payroll_warning              => p_payroll_warning,
     p_assignment_id_o              => per_pyp_shd.g_old_rec.assignment_id,
     p_business_group_id_o          => per_pyp_shd.g_old_rec.business_group_id,
     p_change_date_o                => per_pyp_shd.g_old_rec.change_date,
     p_comments_o                   => per_pyp_shd.g_old_rec.comments,
     p_next_sal_review_date_o       => per_pyp_shd.g_old_rec.next_sal_review_date,
     p_proposal_reason_o            => per_pyp_shd.g_old_rec.proposal_reason,
     p_proposed_salary_n_o          => per_pyp_shd.g_old_rec.proposed_salary_n,
     p_forced_ranking_o             => per_pyp_shd.g_old_rec.forced_ranking,
     p_date_to_o        => per_pyp_shd.g_old_rec.date_to,
     p_performance_review_id_o      => per_pyp_shd.g_old_rec.performance_review_id,
     p_attribute_category_o         => per_pyp_shd.g_old_rec.attribute_category,
     p_attribute1_o                 => per_pyp_shd.g_old_rec.attribute1,
     p_attribute2_o                 => per_pyp_shd.g_old_rec.attribute2,
     p_attribute3_o                 => per_pyp_shd.g_old_rec.attribute3,
     p_attribute4_o                 => per_pyp_shd.g_old_rec.attribute4,
     p_attribute5_o                 => per_pyp_shd.g_old_rec.attribute5,
     p_attribute6_o                 => per_pyp_shd.g_old_rec.attribute6,
     p_attribute7_o                 => per_pyp_shd.g_old_rec.attribute7,
     p_attribute8_o                 => per_pyp_shd.g_old_rec.attribute8,
     p_attribute9_o                 => per_pyp_shd.g_old_rec.attribute9,
     p_attribute10_o                => per_pyp_shd.g_old_rec.attribute10,
     p_attribute11_o                => per_pyp_shd.g_old_rec.attribute11,
     p_attribute12_o                => per_pyp_shd.g_old_rec.attribute12,
     p_attribute13_o                => per_pyp_shd.g_old_rec.attribute13,
     p_attribute14_o                => per_pyp_shd.g_old_rec.attribute14,
     p_attribute15_o                => per_pyp_shd.g_old_rec.attribute15,
     p_attribute16_o                => per_pyp_shd.g_old_rec.attribute16,
     p_attribute17_o                => per_pyp_shd.g_old_rec.attribute17,
     p_attribute18_o                => per_pyp_shd.g_old_rec.attribute18,
     p_attribute19_o                => per_pyp_shd.g_old_rec.attribute19,
     p_attribute20_o                => per_pyp_shd.g_old_rec.attribute20,
     p_object_version_number_o      => per_pyp_shd.g_old_rec.object_version_number,
     p_multiple_components_o        => per_pyp_shd.g_old_rec.multiple_components,
     p_approved_o                   => per_pyp_shd.g_old_rec.approved
    );

Line: 533

End post_update;

Line: 780

per_pyp_bus.update_validate
        (p_rec                         => p_rec
        ,p_inv_next_sal_date_warning   => l_inv_next_sal_date_warning
        ,p_proposed_salary_warning     => l_proposed_salary_warning
        ,p_approved_warning            => l_approved_warning
        ,p_payroll_warning             => l_payroll_warning
        );

Line: 790

  pre_update(p_rec);

Line: 794

update_dml(p_rec);

Line: 798

  post_update(p_rec         => p_rec
       ,p_inv_next_sal_date_warning   => l_inv_next_sal_date_warning
             ,p_proposed_salary_warning     => l_proposed_salary_warning
             ,p_approved_warning            => l_approved_warning
             ,p_payroll_warning             => l_payroll_warning
           );