APPS.PAY_AIF_INS SQL Statements

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

Line: 74

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

Line: 88

  insert into pay_action_information
      (action_information_id
      ,action_context_id
      ,action_context_type
      ,tax_unit_id
      ,jurisdiction_code
      ,source_id
      ,source_text
      ,tax_group
      ,object_version_number
      ,effective_date
      ,assignment_id
      ,action_information_category
      ,action_information1
      ,action_information2
      ,action_information3
      ,action_information4
      ,action_information5
      ,action_information6
      ,action_information7
      ,action_information8
      ,action_information9
      ,action_information10
      ,action_information11
      ,action_information12
      ,action_information13
      ,action_information14
      ,action_information15
      ,action_information16
      ,action_information17
      ,action_information18
      ,action_information19
      ,action_information20
      ,action_information21
      ,action_information22
      ,action_information23
      ,action_information24
      ,action_information25
      ,action_information26
      ,action_information27
      ,action_information28
      ,action_information29
      ,action_information30
      )
  Values
    (p_rec.action_information_id
    ,p_rec.action_context_id
    ,p_rec.action_context_type
    ,p_rec.tax_unit_id
    ,p_rec.jurisdiction_code
    ,p_rec.source_id
    ,p_rec.source_text
    ,p_rec.tax_group
    ,p_rec.object_version_number
    ,p_rec.effective_date
    ,p_rec.assignment_id
    ,p_rec.action_information_category
    ,p_rec.action_information1
    ,p_rec.action_information2
    ,p_rec.action_information3
    ,p_rec.action_information4
    ,p_rec.action_information5
    ,p_rec.action_information6
    ,p_rec.action_information7
    ,p_rec.action_information8
    ,p_rec.action_information9
    ,p_rec.action_information10
    ,p_rec.action_information11
    ,p_rec.action_information12
    ,p_rec.action_information13
    ,p_rec.action_information14
    ,p_rec.action_information15
    ,p_rec.action_information16
    ,p_rec.action_information17
    ,p_rec.action_information18
    ,p_rec.action_information19
    ,p_rec.action_information20
    ,p_rec.action_information21
    ,p_rec.action_information22
    ,p_rec.action_information23
    ,p_rec.action_information24
    ,p_rec.action_information25
    ,p_rec.action_information26
    ,p_rec.action_information27
    ,p_rec.action_information28
    ,p_rec.action_information29
    ,p_rec.action_information30
    );

Line: 199

End insert_dml;

Line: 238

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

Line: 245

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

Line: 248

    Select null
      from pay_action_information
     where action_information_id =
             pay_aif_ins.g_action_information_id_i;

Line: 290

End pre_insert;

Line: 324

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

Line: 334

    pay_aif_rki.after_insert
      (p_action_information_id
      => p_rec.action_information_id
      ,p_action_context_id
      => p_rec.action_context_id
      ,p_action_context_type
      => p_rec.action_context_type
      ,p_tax_unit_id
      => p_rec.tax_unit_id
      ,p_jurisdiction_code
      => p_rec.jurisdiction_code
      ,p_source_id
      => p_rec.source_id
      ,p_source_text
      => p_rec.source_text
      ,p_tax_group
      => p_rec.tax_group
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_effective_date
      => p_rec.effective_date
      ,p_assignment_id
      => p_rec.assignment_id
      ,p_action_information_category
      => p_rec.action_information_category
      ,p_action_information1
      => p_rec.action_information1
      ,p_action_information2
      => p_rec.action_information2
      ,p_action_information3
      => p_rec.action_information3
      ,p_action_information4
      => p_rec.action_information4
      ,p_action_information5
      => p_rec.action_information5
      ,p_action_information6
      => p_rec.action_information6
      ,p_action_information7
      => p_rec.action_information7
      ,p_action_information8
      => p_rec.action_information8
      ,p_action_information9
      => p_rec.action_information9
      ,p_action_information10
      => p_rec.action_information10
      ,p_action_information11
      => p_rec.action_information11
      ,p_action_information12
      => p_rec.action_information12
      ,p_action_information13
      => p_rec.action_information13
      ,p_action_information14
      => p_rec.action_information14
      ,p_action_information15
      => p_rec.action_information15
      ,p_action_information16
      => p_rec.action_information16
      ,p_action_information17
      => p_rec.action_information17
      ,p_action_information18
      => p_rec.action_information18
      ,p_action_information19
      => p_rec.action_information19
      ,p_action_information20
      => p_rec.action_information20
      ,p_action_information21
      => p_rec.action_information21
      ,p_action_information22
      => p_rec.action_information22
      ,p_action_information23
      => p_rec.action_information23
      ,p_action_information24
      => p_rec.action_information24
      ,p_action_information25
      => p_rec.action_information25
      ,p_action_information26
      => p_rec.action_information26
      ,p_action_information27
      => p_rec.action_information27
      ,p_action_information28
      => p_rec.action_information28
      ,p_action_information29
      => p_rec.action_information29
      ,p_action_information30
      => p_rec.action_information30
      );

Line: 432

End post_insert;

Line: 448

  pay_aif_bus.insert_validate
     (p_rec
     );

Line: 458

  pay_aif_ins.pre_insert(p_rec);

Line: 462

  pay_aif_ins.insert_dml(p_rec);

Line: 466

  pay_aif_ins.post_insert
     (p_rec
     );