[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_dml(p_rec in out nocopy hr_trs_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'update_dml';
update hr_api_transaction_steps
set
api_name = p_rec.api_name,
api_display_name = p_rec.api_display_name,
processing_order = p_rec.processing_order,
item_type = p_rec.item_type,
item_key = p_rec.item_key,
activity_id = p_rec.activity_id,
creator_person_id = p_rec.creator_person_id,
update_person_id = p_rec.update_person_id,
object_version_number = p_rec.object_version_number,
last_update_date = trunc(sysdate),
object_state = p_rec.object_state,
pk1 = p_rec.pk1,
pk2 = p_rec.pk2,
pk3 = p_rec.pk3,
pk4 = p_rec.pk4,
pk5 = p_rec.pk5,
information_category = p_rec.information_category,
information1 = p_rec.information1,
information2 = p_rec.information2,
information3 = p_rec.information3,
information4 = p_rec.information4,
information5 = p_rec.information5,
information6 = p_rec.information6,
information7 = p_rec.information7,
information8 = p_rec.information8,
information9 = p_rec.information9,
information10 = p_rec.information10,
information11 = p_rec.information11,
information12 = p_rec.information12,
information13 = p_rec.information13,
information14 = p_rec.information14,
information15 = p_rec.information15,
information16 = p_rec.information16,
information17 = p_rec.information17,
information18 = p_rec.information18,
information19 = p_rec.information19,
information20 = p_rec.information20,
information21 = p_rec.information21,
information22 = p_rec.information22,
information23 = p_rec.information23,
information24 = p_rec.information24,
information25 = p_rec.information25,
information26 = p_rec.information26,
information27 = p_rec.information27,
information28 = p_rec.information28,
information29 = p_rec.information29,
information30 = p_rec.information30
where transaction_step_id = p_rec.transaction_step_id;
End update_dml;
Procedure pre_update(p_rec in hr_trs_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_update';
End pre_update;
Procedure post_update(p_rec in hr_trs_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_update';
End post_update;
If (p_rec.update_person_id = hr_api.g_number) then
p_rec.update_person_id :=
hr_trs_shd.g_old_rec.update_person_id;
hr_trs_bus.update_validate(p_rec);
pre_update(p_rec);
update_dml(p_rec);
post_update(p_rec);
p_update_person_id in number default hr_api.g_number,
p_object_version_number in out nocopy number,
p_validate in boolean default false,
p_OBJECT_TYPE in VARCHAR2 default hr_api.g_varchar2,
p_OBJECT_NAME in VARCHAR2 default hr_api.g_varchar2,
p_OBJECT_IDENTIFIER in VARCHAR2 default hr_api.g_varchar2,
p_OBJECT_STATE in VARCHAR2 default hr_api.g_varchar2,
p_OBJECT_NAME_IDENTIFIER in VARCHAR2 default hr_api.g_varchar2,
p_PK1 in VARCHAR2 default hr_api.g_varchar2,
p_PK2 in VARCHAR2 default hr_api.g_varchar2,
p_PK3 in VARCHAR2 default hr_api.g_varchar2,
p_PK4 in VARCHAR2 default hr_api.g_varchar2,
p_PK5 in VARCHAR2 default hr_api.g_varchar2,
p_information_category in VARCHAR2 default hr_api.g_varchar2,
p_information1 in VARCHAR2 default hr_api.g_varchar2,
p_information2 in VARCHAR2 default hr_api.g_varchar2,
p_information3 in VARCHAR2 default hr_api.g_varchar2,
p_information4 in VARCHAR2 default hr_api.g_varchar2,
p_information5 in VARCHAR2 default hr_api.g_varchar2,
p_information6 in VARCHAR2 default hr_api.g_varchar2,
p_information7 in VARCHAR2 default hr_api.g_varchar2,
p_information8 in VARCHAR2 default hr_api.g_varchar2,
p_information9 in VARCHAR2 default hr_api.g_varchar2,
p_information10 in VARCHAR2 default hr_api.g_varchar2,
p_information11 in VARCHAR2 default hr_api.g_varchar2,
p_information12 in VARCHAR2 default hr_api.g_varchar2,
p_information13 in VARCHAR2 default hr_api.g_varchar2,
p_information14 in VARCHAR2 default hr_api.g_varchar2,
p_information15 in VARCHAR2 default hr_api.g_varchar2,
p_information16 in VARCHAR2 default hr_api.g_varchar2,
p_information17 in VARCHAR2 default hr_api.g_varchar2,
p_information18 in VARCHAR2 default hr_api.g_varchar2,
p_information19 in VARCHAR2 default hr_api.g_varchar2,
p_information20 in VARCHAR2 default hr_api.g_varchar2,
p_information21 in VARCHAR2 default hr_api.g_varchar2,
p_information22 in VARCHAR2 default hr_api.g_varchar2,
p_information23 in VARCHAR2 default hr_api.g_varchar2,
p_information24 in VARCHAR2 default hr_api.g_varchar2,
p_information25 in VARCHAR2 default hr_api.g_varchar2,
p_information26 in VARCHAR2 default hr_api.g_varchar2,
p_information27 in VARCHAR2 default hr_api.g_varchar2,
p_information28 in VARCHAR2 default hr_api.g_varchar2,
p_information29 in VARCHAR2 default hr_api.g_varchar2,
p_information30 in VARCHAR2 default hr_api.g_varchar2
) is
--
l_rec hr_trs_shd.g_rec_type;
p_update_person_id,
p_object_version_number,
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
);