The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure insert_dml(p_rec in out nocopy hr_trs_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'insert_dml';
insert into hr_api_transaction_steps
( transaction_step_id,
transaction_id,
api_name,
api_display_name,
processing_order,
item_type,
item_key,
activity_id,
creator_person_id,
update_person_id,
object_version_number,
object_type,
object_name,
object_identifier,
object_state,
pk1,
pk2,
pk3,
pk4,
pk5,
information_category,
information1,
information2,
information3,
information4,
information5,
information6,
information7,
information8,
information9,
information10,
information11,
information12,
information13,
information14,
information15,
information16,
information17,
information18,
information19,
information20,
information21,
information22,
information23,
information24,
information25,
information26,
information27,
information28,
information29,
information30
)
Values
( p_rec.transaction_step_id,
p_rec.transaction_id,
p_rec.api_name,
p_rec.api_display_name,
p_rec.processing_order,
p_rec.item_type,
p_rec.item_key,
p_rec.activity_id,
p_rec.creator_person_id,
p_rec.update_person_id,
p_rec.object_version_number,
p_rec.object_type,
p_rec.object_name,
p_rec.object_identifier,
p_rec.object_state,
p_rec.pk1,
p_rec.pk2,
p_rec.pk3,
p_rec.pk4,
p_rec.pk5,
p_rec.information_category,
p_rec.information1,
p_rec.information2,
p_rec.information3,
p_rec.information4,
p_rec.information5,
p_rec.information6,
p_rec.information7,
p_rec.information8,
p_rec.information9,
p_rec.information10,
p_rec.information11,
p_rec.information12,
p_rec.information13,
p_rec.information14,
p_rec.information15,
p_rec.information16,
p_rec.information17,
p_rec.information18,
p_rec.information19,
p_rec.information20,
p_rec.information21,
p_rec.information22,
p_rec.information23,
p_rec.information24,
p_rec.information25,
p_rec.information26,
p_rec.information27,
p_rec.information28,
p_rec.information29,
p_rec.information30
);
End insert_dml;
Procedure pre_insert(p_rec in out nocopy hr_trs_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_insert';
Cursor C_Sel1 is select hr_api_transaction_steps_s.nextval from sys.dual;
select null
from hr_api_transaction_steps
where transaction_step_id = hr_trs_ins.g_transaction_step_id_i;
End pre_insert;
Procedure post_insert(p_rec in hr_trs_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_insert';
End post_insert;
hr_trs_bus.insert_validate(p_rec);
pre_insert(p_rec);
insert_dml(p_rec);
post_insert(p_rec);
p_update_person_id in number default null,
p_object_version_number out nocopy number,
p_validate in boolean default false,
p_OBJECT_TYPE in VARCHAR2 default null,
p_OBJECT_NAME in VARCHAR2 default null,
p_OBJECT_IDENTIFIER in VARCHAR2 default null,
p_OBJECT_STATE in VARCHAR2 default null,
p_PK1 in VARCHAR2 default null,
p_PK2 in VARCHAR2 default null,
p_PK3 in VARCHAR2 default null,
p_PK4 in VARCHAR2 default null,
p_PK5 in VARCHAR2 default null,
p_information_category in VARCHAR2 default null,
p_information1 in VARCHAR2 default null,
p_information2 in VARCHAR2 default null,
p_information3 in VARCHAR2 default null,
p_information4 in VARCHAR2 default null,
p_information5 in VARCHAR2 default null,
p_information6 in VARCHAR2 default null,
p_information7 in VARCHAR2 default null,
p_information8 in VARCHAR2 default null,
p_information9 in VARCHAR2 default null,
p_information10 in VARCHAR2 default null,
p_information11 in VARCHAR2 default null,
p_information12 in VARCHAR2 default null,
p_information13 in VARCHAR2 default null,
p_information14 in VARCHAR2 default null,
p_information15 in VARCHAR2 default null,
p_information16 in VARCHAR2 default null,
p_information17 in VARCHAR2 default null,
p_information18 in VARCHAR2 default null,
p_information19 in VARCHAR2 default null,
p_information20 in VARCHAR2 default null,
p_information21 in VARCHAR2 default null,
p_information22 in VARCHAR2 default null,
p_information23 in VARCHAR2 default null,
p_information24 in VARCHAR2 default null,
p_information25 in VARCHAR2 default null,
p_information26 in VARCHAR2 default null,
p_information27 in VARCHAR2 default null,
p_information28 in VARCHAR2 default null,
p_information29 in VARCHAR2 default null,
p_information30 in VARCHAR2 default null
) is
--
l_rec hr_trs_shd.g_rec_type;
p_update_person_id,
null,
p_object_type,
p_object_name,
p_object_identifier,
p_object_state,
p_pk1,
p_pk2,
p_pk3,
p_pk4,
p_pk5,
p_information_category,
p_information1,
p_information2,
p_information3,
p_information4,
p_information5,
p_information6,
p_information7,
p_information8,
p_information9,
p_information10,
p_information11,
p_information12,
p_information13,
p_information14,
p_information15,
p_information16,
p_information17,
p_information18,
p_information19,
p_information20,
p_information21,
p_information22,
p_information23,
p_information24,
p_information25,
p_information26,
p_information27,
p_information28,
p_information29,
p_information30
);