APPS.HR_CNP_INS SQL Statements

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

Line: 53

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

Line: 67

  insert into hr_canvas_properties
      (canvas_property_id
      ,object_version_number
      ,form_canvas_id
      ,template_canvas_id
      ,height
      ,visible
      ,width
      ,x_position
      ,y_position
      ,information_category
      ,information1
      ,information2
      ,information3
      ,information4
      ,information5
      ,information6
      ,information7
      ,information8
      ,information9
      ,information10
      ,information11
      ,information12
      ,information13
      ,information14
      ,information15
      ,information16
      ,information17
      ,information18
      ,information19
      ,information20
      ,information21
      ,information22
      ,information23
      ,information24
      ,information25
      ,information26
      ,information27
      ,information28
      ,information29
      ,information30
    )
  Values
    (p_rec.canvas_property_id
    ,p_rec.object_version_number
    ,p_rec.form_canvas_id
    ,p_rec.template_canvas_id
    ,p_rec.height
    ,p_rec.visible
    ,p_rec.width
    ,p_rec.x_position
    ,p_rec.y_position
    ,p_rec.information_category
    ,p_rec.information1
    ,p_rec.information2
    ,p_rec.information3
    ,p_rec.information4
    ,p_rec.information5
    ,p_rec.information6
    ,p_rec.information7
    ,p_rec.information8
    ,p_rec.information9
    ,p_rec.information10
    ,p_rec.information11
    ,p_rec.information12
    ,p_rec.information13
    ,p_rec.information14
    ,p_rec.information15
    ,p_rec.information16
    ,p_rec.information17
    ,p_rec.information18
    ,p_rec.information19
    ,p_rec.information20
    ,p_rec.information21
    ,p_rec.information22
    ,p_rec.information23
    ,p_rec.information24
    ,p_rec.information25
    ,p_rec.information26
    ,p_rec.information27
    ,p_rec.information28
    ,p_rec.information29
    ,p_rec.information30
    );

Line: 174

End insert_dml;

Line: 213

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

Line: 219

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

Line: 232

End pre_insert;

Line: 266

Procedure post_insert
  (p_effective_date               in date
  ,p_rec                          in hr_cnp_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'post_insert';

Line: 277

    hr_cnp_rki.after_insert
      (p_effective_date               => p_effective_date
      ,p_canvas_property_id           => p_rec.canvas_property_id
      ,p_object_version_number        => p_rec.object_version_number
      ,p_form_canvas_id               => p_rec.form_canvas_id
      ,p_template_canvas_id           => p_rec.template_canvas_id
      ,p_height                       => p_rec.height
      ,p_visible                      => p_rec.visible
      ,p_width                        => p_rec.width
      ,p_x_position                   => p_rec.x_position
      ,p_y_position                   => p_rec.y_position
      ,p_information_category         => p_rec.information_category
      ,p_information1                 => p_rec.information1
      ,p_information2                 => p_rec.information2
      ,p_information3                 => p_rec.information3
      ,p_information4                 => p_rec.information4
      ,p_information5                 => p_rec.information5
      ,p_information6                 => p_rec.information6
      ,p_information7                 => p_rec.information7
      ,p_information8                 => p_rec.information8
      ,p_information9                 => p_rec.information9
      ,p_information10                => p_rec.information10
      ,p_information11                => p_rec.information11
      ,p_information12                => p_rec.information12
      ,p_information13                => p_rec.information13
      ,p_information14                => p_rec.information14
      ,p_information15                => p_rec.information15
      ,p_information16                => p_rec.information16
      ,p_information17                => p_rec.information17
      ,p_information18                => p_rec.information18
      ,p_information19                => p_rec.information19
      ,p_information20                => p_rec.information20
      ,p_information21                => p_rec.information21
      ,p_information22                => p_rec.information22
      ,p_information23                => p_rec.information23
      ,p_information24                => p_rec.information24
      ,p_information25                => p_rec.information25
      ,p_information26                => p_rec.information26
      ,p_information27                => p_rec.information27
      ,p_information28                => p_rec.information28
      ,p_information29                => p_rec.information29
      ,p_information30                => p_rec.information30
      );

Line: 332

End post_insert;

Line: 349

  hr_cnp_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 356

  hr_cnp_ins.pre_insert(p_rec);

Line: 360

  hr_cnp_ins.insert_dml(p_rec);

Line: 364

  hr_cnp_ins.post_insert
     (p_effective_date
     ,p_rec
     );