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: 84

  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: 191

End insert_dml;

Line: 230

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

Line: 236

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

Line: 249

End pre_insert;

Line: 283

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: 294

    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: 349

End post_insert;

Line: 366

  hr_cnp_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 373

  hr_cnp_ins.pre_insert(p_rec);

Line: 377

  hr_cnp_ins.insert_dml(p_rec);

Line: 381

  hr_cnp_ins.post_insert
     (p_effective_date
     ,p_rec
     );