[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure insert_dml
(p_rec in out nocopy pay_aud_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'insert_dml';
insert into pay_stat_trans_audit
(stat_trans_audit_id
,transaction_type
,transaction_subtype
,transaction_date
,transaction_effective_date
,business_group_id
,person_id
,assignment_id
,source1
,source1_type
,source2
,source2_type
,source3
,source3_type
,source4
,source4_type
,source5
,source5_type
,transaction_parent_id
,audit_information_category
,audit_information1
,audit_information2
,audit_information3
,audit_information4
,audit_information5
,audit_information6
,audit_information7
,audit_information8
,audit_information9
,audit_information10
,audit_information11
,audit_information12
,audit_information13
,audit_information14
,audit_information15
,audit_information16
,audit_information17
,audit_information18
,audit_information19
,audit_information20
,audit_information21
,audit_information22
,audit_information23
,audit_information24
,audit_information25
,audit_information26
,audit_information27
,audit_information28
,audit_information29
,audit_information30
,title
,object_version_number
)
Values
(p_rec.stat_trans_audit_id
,p_rec.transaction_type
,p_rec.transaction_subtype
,p_rec.transaction_date
,p_rec.transaction_effective_date
,p_rec.business_group_id
,p_rec.person_id
,p_rec.assignment_id
,p_rec.source1
,p_rec.source1_type
,p_rec.source2
,p_rec.source2_type
,p_rec.source3
,p_rec.source3_type
,p_rec.source4
,p_rec.source4_type
,p_rec.source5
,p_rec.source5_type
,p_rec.transaction_parent_id
,p_rec.audit_information_category
,p_rec.audit_information1
,p_rec.audit_information2
,p_rec.audit_information3
,p_rec.audit_information4
,p_rec.audit_information5
,p_rec.audit_information6
,p_rec.audit_information7
,p_rec.audit_information8
,p_rec.audit_information9
,p_rec.audit_information10
,p_rec.audit_information11
,p_rec.audit_information12
,p_rec.audit_information13
,p_rec.audit_information14
,p_rec.audit_information15
,p_rec.audit_information16
,p_rec.audit_information17
,p_rec.audit_information18
,p_rec.audit_information19
,p_rec.audit_information20
,p_rec.audit_information21
,p_rec.audit_information22
,p_rec.audit_information23
,p_rec.audit_information24
,p_rec.audit_information25
,p_rec.audit_information26
,p_rec.audit_information27
,p_rec.audit_information28
,p_rec.audit_information29
,p_rec.audit_information30
,p_rec.title
,p_rec.object_version_number
);
End insert_dml;
Procedure pre_insert
(p_rec in out nocopy pay_aud_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'pre_insert';
Cursor C_Sel1 is select pay_stat_trans_audit_s.nextval from sys.dual;
End pre_insert;
Procedure post_insert
(p_effective_date in date
,p_rec in pay_aud_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'post_insert';
pay_aud_rki.after_insert
(p_effective_date => p_effective_date
,p_stat_trans_audit_id
=> p_rec.stat_trans_audit_id
,p_transaction_type
=> p_rec.transaction_type
,p_transaction_subtype
=> p_rec.transaction_subtype
,p_transaction_date
=> p_rec.transaction_date
,p_transaction_effective_date
=> p_rec.transaction_effective_date
,p_business_group_id
=> p_rec.business_group_id
,p_person_id
=> p_rec.person_id
,p_assignment_id
=> p_rec.assignment_id
,p_source1
=> p_rec.source1
,p_source1_type
=> p_rec.source1_type
,p_source2
=> p_rec.source2
,p_source2_type
=> p_rec.source2_type
,p_source3
=> p_rec.source3
,p_source3_type
=> p_rec.source3_type
,p_source4
=> p_rec.source4
,p_source4_type
=> p_rec.source4_type
,p_source5
=> p_rec.source5
,p_source5_type
=> p_rec.source5_type
,p_transaction_parent_id
=> p_rec.transaction_parent_id
,p_audit_information_category
=> p_rec.audit_information_category
,p_audit_information1
=> p_rec.audit_information1
,p_audit_information2
=> p_rec.audit_information2
,p_audit_information3
=> p_rec.audit_information3
,p_audit_information4
=> p_rec.audit_information4
,p_audit_information5
=> p_rec.audit_information5
,p_audit_information6
=> p_rec.audit_information6
,p_audit_information7
=> p_rec.audit_information7
,p_audit_information8
=> p_rec.audit_information8
,p_audit_information9
=> p_rec.audit_information9
,p_audit_information10
=> p_rec.audit_information10
,p_audit_information11
=> p_rec.audit_information11
,p_audit_information12
=> p_rec.audit_information12
,p_audit_information13
=> p_rec.audit_information13
,p_audit_information14
=> p_rec.audit_information14
,p_audit_information15
=> p_rec.audit_information15
,p_audit_information16
=> p_rec.audit_information16
,p_audit_information17
=> p_rec.audit_information17
,p_audit_information18
=> p_rec.audit_information18
,p_audit_information19
=> p_rec.audit_information19
,p_audit_information20
=> p_rec.audit_information20
,p_audit_information21
=> p_rec.audit_information21
,p_audit_information22
=> p_rec.audit_information22
,p_audit_information23
=> p_rec.audit_information23
,p_audit_information24
=> p_rec.audit_information24
,p_audit_information25
=> p_rec.audit_information25
,p_audit_information26
=> p_rec.audit_information26
,p_audit_information27
=> p_rec.audit_information27
,p_audit_information28
=> p_rec.audit_information28
,p_audit_information29
=> p_rec.audit_information29
,p_audit_information30
=> p_rec.audit_information30
,p_title
=> p_rec.title
,p_object_version_number
=> p_rec.object_version_number
);
End post_insert;
pay_aud_bus.insert_validate
(p_effective_date
,p_rec
);
pay_aud_ins.pre_insert(p_rec);
pay_aud_ins.insert_dml(p_rec);
pay_aud_ins.post_insert
(p_effective_date
,p_rec
);