The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure insert_dml
(p_rec in out nocopy pay_aif_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'insert_dml';
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
);
End insert_dml;
Procedure pre_insert
(p_rec in out nocopy pay_aif_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'pre_insert';
Cursor C_Sel1 is select pay_action_information_s.nextval from sys.dual;
Select null
from pay_action_information
where action_information_id =
pay_aif_ins.g_action_information_id_i;
End pre_insert;
Procedure post_insert
(p_rec in pay_aif_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'post_insert';
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
);
End post_insert;
pay_aif_bus.insert_validate
(p_rec
);
pay_aif_ins.pre_insert(p_rec);
pay_aif_ins.insert_dml(p_rec);
pay_aif_ins.post_insert
(p_rec
);