APPS.PER_PYP_INS SQL Statements

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

Line: 74

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

Line: 86

  insert into per_pay_proposals
  (     pay_proposal_id,
        assignment_id,
        event_id,
        business_group_id,
        change_date,
        comments,
        last_change_date,
        next_perf_review_date,
        next_sal_review_date,
        performance_rating,
        proposal_reason,
        proposed_salary_n,
        review_date,
        forced_ranking,
  date_to,
        performance_review_id,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        attribute16,
        attribute17,
        attribute18,
        attribute19,
        attribute20,
        object_version_number,
        multiple_components,
        approved
  )
  Values
  (     p_rec.pay_proposal_id,
        p_rec.assignment_id,
        null,
        p_rec.business_group_id,
        p_rec.change_date,
        p_rec.comments,
        p_rec.last_change_date,
        null,
        p_rec.next_sal_review_date,
        null,
        p_rec.proposal_reason,
        p_rec.proposed_salary_n,
        null,
        p_rec.forced_ranking,
  p_rec.date_to,
        p_rec.performance_review_id,
  p_rec.attribute_category,
  p_rec.attribute1,
  p_rec.attribute2,
  p_rec.attribute3,
  p_rec.attribute4,
  p_rec.attribute5,
  p_rec.attribute6,
  p_rec.attribute7,
  p_rec.attribute8,
  p_rec.attribute9,
  p_rec.attribute10,
  p_rec.attribute11,
  p_rec.attribute12,
  p_rec.attribute13,
  p_rec.attribute14,
  p_rec.attribute15,
  p_rec.attribute16,
  p_rec.attribute17,
  p_rec.attribute18,
  p_rec.attribute19,
  p_rec.attribute20,
  p_rec.object_version_number,
  p_rec.multiple_components,
  p_rec.approved
  );

Line: 193

End insert_dml;

Line: 232

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

Line: 236

  Cursor C_Sel1 is select per_pay_proposals_s.nextval from sys.dual;

Line: 240

    select null
      from per_pay_proposals
     where pay_proposal_id =
             per_pyp_ins.g_pay_proposal_id_i;

Line: 290

End pre_insert;

Line: 324

Procedure post_insert
  (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_insert';

Line: 474

     l_ext_new_rec.update_mode           := 'UPDATE';

Line: 475

     l_event                             := 'INSERT' ;

Line: 477

  per_pyp_rki.after_insert
    (
     p_pay_proposal_id              => p_rec.pay_proposal_id,
     p_assignment_id                => p_rec.assignment_id,
     p_business_group_id            => p_rec.business_group_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
    );

Line: 552

End post_insert;

Line: 589

  per_pyp_bus.insert_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: 599

  pre_insert(p_rec);

Line: 603

  insert_dml(p_rec);

Line: 607

  post_insert(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
       );