The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure insert_dml
(p_rec in out nocopy per_cnl_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'insert_dml';
insert into per_ri_config_locations
(configuration_code
,configuration_context
,location_id
,location_code
,description
,style
,address_line_1
,address_line_2
,address_line_3
,town_or_city
,country
,postal_code
,region_1
,region_2
,region_3
,telephone_number_1
,telephone_number_2
,telephone_number_3
,loc_information13
,loc_information14
,loc_information15
,loc_information16
,loc_information17
,loc_information18
,loc_information19
,loc_information20
,object_version_number
)
Values
(p_rec.configuration_code
,p_rec.configuration_context
,p_rec.location_id
,p_rec.location_code
,p_rec.description
,p_rec.style
,p_rec.address_line_1
,p_rec.address_line_2
,p_rec.address_line_3
,p_rec.town_or_city
,p_rec.country
,p_rec.postal_code
,p_rec.region_1
,p_rec.region_2
,p_rec.region_3
,p_rec.telephone_number_1
,p_rec.telephone_number_2
,p_rec.telephone_number_3
,p_rec.loc_information13
,p_rec.loc_information14
,p_rec.loc_information15
,p_rec.loc_information16
,p_rec.loc_information17
,p_rec.loc_information18
,p_rec.loc_information19
,p_rec.loc_information20
,p_rec.object_version_number
);
End insert_dml;
Procedure pre_insert
(p_rec in out nocopy per_cnl_shd.g_rec_type
) is
--
Cursor C_Sel1 is select per_ri_config_locations_s.nextval from sys.dual;
Select null
from per_ri_config_locations
where location_id =
per_cnl_ins.g_location_id_i;
l_proc varchar2(72) := g_package||'pre_insert';
End pre_insert;
Procedure post_insert
(p_effective_date in date
,p_rec in per_cnl_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'post_insert';
per_cnl_rki.after_insert
(p_effective_date => p_effective_date
,p_configuration_code => p_rec.configuration_code
,p_configuration_context => p_rec.configuration_context
,p_location_id => p_rec.location_id
,p_location_code => p_rec.location_code
,p_description => p_rec.description
,p_style => p_rec.style
,p_address_line_1 => p_rec.address_line_1
,p_address_line_2 => p_rec.address_line_2
,p_address_line_3 => p_rec.address_line_3
,p_town_or_city => p_rec.town_or_city
,p_country => p_rec.country
,p_postal_code => p_rec.postal_code
,p_region_1 => p_rec.region_1
,p_region_2 => p_rec.region_2
,p_region_3 => p_rec.region_3
,p_telephone_number_1 => p_rec.telephone_number_1
,p_telephone_number_2 => p_rec.telephone_number_2
,p_telephone_number_3 => p_rec.telephone_number_3
,p_loc_information13 => p_rec.loc_information13
,p_loc_information14 => p_rec.loc_information14
,p_loc_information15 => p_rec.loc_information15
,p_loc_information16 => p_rec.loc_information16
,p_loc_information17 => p_rec.loc_information17
,p_loc_information18 => p_rec.loc_information18
,p_loc_information19 => p_rec.loc_information19
,p_loc_information20 => p_rec.loc_information20
,p_object_version_number => p_rec.object_version_number
);
End post_insert;
per_cnl_bus.insert_validate
(p_effective_date
,p_rec
);
per_cnl_ins.pre_insert(p_rec);
per_cnl_ins.insert_dml(p_rec);
per_cnl_ins.post_insert
(p_effective_date ,p_rec );