The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure insert_dml(p_rec in out nocopy ota_nhs_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'insert_dml';
insert into ota_notrng_histories
( nota_history_id,
person_id,
contact_id,
trng_title,
provider,
type,
centre,
completion_date,
award,
rating,
duration,
duration_units,
activity_version_id,
status,
verified_by_id,
nth_information_category,
nth_information1,
nth_information2,
nth_information3,
nth_information4,
nth_information5,
nth_information6,
nth_information7,
nth_information8,
nth_information9,
nth_information10,
nth_information11,
nth_information12,
nth_information13,
nth_information15,
nth_information16,
nth_information17,
nth_information18,
nth_information19,
nth_information20,
org_id,
object_version_number,
business_group_id,
nth_information14,
customer_id,
organization_id
)
Values
( p_rec.nota_history_id,
p_rec.person_id,
p_rec.contact_id,
p_rec.trng_title,
p_rec.provider,
p_rec.type,
p_rec.centre,
p_rec.completion_date,
p_rec.award,
p_rec.rating,
p_rec.duration,
p_rec.duration_units,
p_rec.activity_version_id,
p_rec.status,
p_rec.verified_by_id,
p_rec.nth_information_category,
p_rec.nth_information1,
p_rec.nth_information2,
p_rec.nth_information3,
p_rec.nth_information4,
p_rec.nth_information5,
p_rec.nth_information6,
p_rec.nth_information7,
p_rec.nth_information8,
p_rec.nth_information9,
p_rec.nth_information10,
p_rec.nth_information11,
p_rec.nth_information12,
p_rec.nth_information13,
p_rec.nth_information15,
p_rec.nth_information16,
p_rec.nth_information17,
p_rec.nth_information18,
p_rec.nth_information19,
p_rec.nth_information20,
p_rec.org_id,
p_rec.object_version_number,
p_rec.business_group_id,
p_rec.nth_information14,
p_rec.customer_id,
p_rec.organization_id
);
End insert_dml;
Procedure pre_insert(p_rec in out nocopy ota_nhs_shd.g_rec_type) is
--
Cursor C_Sel1 is select ota_notrng_histories_s.nextval from sys.dual;
Select null
from ota_notrng_histories
where nota_history_id =
ota_nhs_ins.g_nota_history_id_i;
l_proc varchar2(72) := g_package||'pre_insert';
End pre_insert;
Procedure post_insert(p_effective_date in date,
p_rec in ota_nhs_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_insert';
ota_nhs_rki.after_insert
(p_effective_date => p_effective_date
,p_nota_history_id
=> p_rec.nota_history_id
,p_person_id
=> p_rec.person_id
,p_contact_id
=> p_rec.contact_id
,p_trng_title
=> p_rec.trng_title
,p_provider
=> p_rec.provider
,p_type
=> p_rec.type
,p_centre
=> p_rec.centre
,p_completion_date
=> p_rec.completion_date
,p_award
=> p_rec.award
,p_rating
=> p_rec.rating
,p_duration
=> p_rec.duration
,p_duration_units
=> p_rec.duration_units
,p_activity_version_id
=> p_rec.activity_version_id
,p_status
=> p_rec.status
,p_verified_by_id
=> p_rec.verified_by_id
,p_nth_information_category
=> p_rec.nth_information_category
,p_nth_information1
=> p_rec.nth_information1
,p_nth_information2
=> p_rec.nth_information2
,p_nth_information3
=> p_rec.nth_information3
,p_nth_information4
=> p_rec.nth_information4
,p_nth_information5
=> p_rec.nth_information5
,p_nth_information6
=> p_rec.nth_information6
,p_nth_information7
=> p_rec.nth_information7
,p_nth_information8
=> p_rec.nth_information8
,p_nth_information9
=> p_rec.nth_information9
,p_nth_information10
=> p_rec.nth_information10
,p_nth_information11
=> p_rec.nth_information11
,p_nth_information12
=> p_rec.nth_information12
,p_nth_information13
=> p_rec.nth_information13
,p_nth_information15
=> p_rec.nth_information15
,p_nth_information16
=> p_rec.nth_information16
,p_nth_information17
=> p_rec.nth_information17
,p_nth_information18
=> p_rec.nth_information18
,p_nth_information19
=> p_rec.nth_information19
,p_nth_information20
=> p_rec.nth_information20
,p_org_id
=> p_rec.org_id
,p_object_version_number
=> p_rec.object_version_number
,p_business_group_id
=> p_rec.business_group_id
,p_nth_information14
=> p_rec.nth_information14
,p_customer_id
=> p_rec.customer_id
,p_organization_id
=> p_rec.organization_id
);
End post_insert;
ota_nhs_bus.insert_validate(p_effective_date ,
p_rec);
pre_insert(p_rec);
insert_dml(p_rec);
post_insert(p_effective_date,
p_rec);