The following lines contain the word 'select', 'insert', 'update' or 'delete':
-- for the update page when we rebuild the page after a
-- save for later
l_count := l_count + 1;
hr_transaction_ss.delete_transaction_steps(
p_item_type => p_item_type
,p_item_key => p_item_key
,p_actid => p_activity_id
,p_login_person_id => p_login_person_id
);
SELECT item_type,item_key
FROM hr_api_transaction_steps
WHERE transaction_step_id = c_txnStepId;
hr_util_misc_web.insert_session_row(to_date(p_effective_date, 'RRRR-MM-DD'));
hr_util_misc_web.insert_session_row(SYSDATE);
IF j = 1 AND l_eit_table(l_index).action = 'DELETE_ROW'
OR j = 2 and l_eit_table(l_index).action <> 'DELETE_ROW' THEN
IF l_eit_table(l_index).action = 'NEW_ROW' THEN
-- hr_utility.trace('l_eit_table(l_index).action=NEW ROW'||l_proc);
ELSIF l_eit_table(l_index).action = 'UPDATE_ROW' THEN
-- hr_utility.trace('l_eit_table(l_index).action=UPDATE_ROW'||l_proc);
update_eit
(p_validate => 0
,p_login_person_id => l_login_person_id
,p_eit_type => l_eit_type
,p_eit_type_id => l_eit_type_id
,p_person_id => l_person_id
,p_information_type => l_eit_table(l_index).information_type
,p_attribute_category => l_eit_table(l_index).attribute_category
,p_attribute1 => l_eit_table(l_index).attribute1
,p_attribute2 => l_eit_table(l_index).attribute2
,p_attribute3 => l_eit_table(l_index).attribute3
,p_attribute4 => l_eit_table(l_index).attribute4
,p_attribute5 => l_eit_table(l_index).attribute5
,p_attribute6 => l_eit_table(l_index).attribute6
,p_attribute7 => l_eit_table(l_index).attribute7
,p_attribute8 => l_eit_table(l_index).attribute8
,p_attribute9 => l_eit_table(l_index).attribute9
,p_attribute10 => l_eit_table(l_index).attribute10
,p_attribute11 => l_eit_table(l_index).attribute11
,p_attribute12 => l_eit_table(l_index).attribute12
,p_attribute13 => l_eit_table(l_index).attribute13
,p_attribute14 => l_eit_table(l_index).attribute14
,p_attribute15 => l_eit_table(l_index).attribute15
,p_attribute16 => l_eit_table(l_index).attribute16
,p_attribute17 => l_eit_table(l_index).attribute17
,p_attribute18 => l_eit_table(l_index).attribute18
,p_attribute19 => l_eit_table(l_index).attribute19
,p_attribute20 => l_eit_table(l_index).attribute20
,p_information_category => l_eit_table(l_index).information_category
,p_information1 => l_eit_table(l_index).information1
,p_information2 => l_eit_table(l_index).information2
,p_information3 => l_eit_table(l_index).information3
,p_information4 => l_eit_table(l_index).information4
,p_information5 => l_eit_table(l_index).information5
,p_information6 => l_eit_table(l_index).information6
,p_information7 => l_eit_table(l_index).information7
,p_information8 => l_eit_table(l_index).information8
,p_information9 => l_eit_table(l_index).information9
,p_information10 => l_eit_table(l_index).information10
,p_information11 => l_eit_table(l_index).information11
,p_information12 => l_eit_table(l_index).information12
,p_information13 => l_eit_table(l_index).information13
,p_information14 => l_eit_table(l_index).information14
,p_information15 => l_eit_table(l_index).information15
,p_information16 => l_eit_table(l_index).information16
,p_information17 => l_eit_table(l_index).information17
,p_information18 => l_eit_table(l_index).information18
,p_information19 => l_eit_table(l_index).information19
,p_information20 => l_eit_table(l_index).information20
,p_information21 => l_eit_table(l_index).information21
,p_information22 => l_eit_table(l_index).information22
,p_information23 => l_eit_table(l_index).information23
,p_information24 => l_eit_table(l_index).information24
,p_information25 => l_eit_table(l_index).information25
,p_information26 => l_eit_table(l_index).information26
,p_information27 => l_eit_table(l_index).information27
,p_information28 => l_eit_table(l_index).information28
,p_information29 => l_eit_table(l_index).information29
,p_information30 => l_eit_table(l_index).information30
,p_extra_info_id => l_eit_table(l_index).extra_info_id
,p_object_version_number => l_eit_table(l_index).object_version_number
-- EndRegistration
,p_item_type => l_item_type
,p_item_key => l_item_key
,p_activity_id => null
,p_action => null
,p_old_extra_info_id => null
,p_old_object_version_number => null
,p_save_mode => null
,p_error_message => l_error_message
);
ELSIF l_eit_table(l_index).action = 'DELETE_ROW' THEN
-- hr_utility.trace('l_eit_table(l_index).action=DELETE_ROW:'||l_proc);
delete_eit
(p_validate => 0
,p_login_person_id => l_login_person_id
,p_eit_type => l_eit_type
,p_eit_type_id => l_eit_type_id
,p_person_id => l_person_id
,p_information_type => l_eit_table(l_index).information_type
,p_extra_info_id => l_eit_table(l_index).extra_info_id
,p_object_version_number => l_eit_table(l_index).object_version_number
-- EndRegistration
,p_item_type => l_item_type
,p_item_key => l_item_key
,p_activity_id => null
,p_action => null
,p_old_extra_info_id => null
,p_old_object_version_number => null
,p_save_mode => null
,p_error_message => l_error_message
);
select assignment_id from per_all_assignments_f
where assignment_type = 'E'
and primary_flag = 'Y'
and person_id = p_person_id
order by effective_start_date desc;
|| PROCEDURE: update_eit
||---------------------------------------------------------------------------
||
|| Description:
|| This procedure will call the actual API -
||
||
|| Access Status:
|| Public.
||
||===========================================================================
*/
PROCEDURE update_eit
(p_validate in number default 0
,p_login_person_id in number default null
,p_eit_type in varchar2
,p_person_id in number
,p_information_type in varchar2
,p_attribute_category in varchar2 default null
,p_attribute1 in varchar2 default null
,p_attribute2 in varchar2 default null
,p_attribute3 in varchar2 default null
,p_attribute4 in varchar2 default null
,p_attribute5 in varchar2 default null
,p_attribute6 in varchar2 default null
,p_attribute7 in varchar2 default null
,p_attribute8 in varchar2 default null
,p_attribute9 in varchar2 default null
,p_attribute10 in varchar2 default null
,p_attribute11 in varchar2 default null
,p_attribute12 in varchar2 default null
,p_attribute13 in varchar2 default null
,p_attribute14 in varchar2 default null
,p_attribute15 in varchar2 default null
,p_attribute16 in varchar2 default null
,p_attribute17 in varchar2 default null
,p_attribute18 in varchar2 default null
,p_attribute19 in varchar2 default null
,p_attribute20 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
,p_extra_info_id in number
,p_object_version_number in out nocopy number
-- EndRegistration
,p_item_type in varchar2
,p_item_key in varchar2
,p_activity_id in number
,p_action in varchar2
,p_old_extra_info_id in number default null
,p_old_object_version_number in number default null
,p_save_mode in varchar2 default null
,p_error_message out nocopy long
,p_eit_type_id in number
)
IS
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'create_eit';
hr_person_extra_info_api.update_person_extra_info
(p_validate => hr_java_conv_util_ss.get_boolean (
p_number => p_validate)
,p_person_extra_info_id => p_extra_info_id
,p_object_version_number => p_object_version_number
,p_pei_attribute_category => p_attribute_category
,p_pei_attribute1 => p_attribute1
,p_pei_attribute2 => p_attribute2
,p_pei_attribute3 => p_attribute3
,p_pei_attribute4 => p_attribute4
,p_pei_attribute5 => p_attribute5
,p_pei_attribute6 => p_attribute6
,p_pei_attribute7 => p_attribute7
,p_pei_attribute8 => p_attribute8
,p_pei_attribute9 => p_attribute9
,p_pei_attribute10 => p_attribute10
,p_pei_attribute11 => p_attribute11
,p_pei_attribute12 => p_attribute12
,p_pei_attribute13 => p_attribute13
,p_pei_attribute14 => p_attribute14
,p_pei_attribute15 => p_attribute15
,p_pei_attribute16 => p_attribute16
,p_pei_attribute17 => p_attribute17
,p_pei_attribute18 => p_attribute18
,p_pei_attribute19 => p_attribute19
,p_pei_attribute20 => p_attribute20
,p_pei_information_category => p_information_category
,p_pei_information1 => p_information1
,p_pei_information2 => p_information2
,p_pei_information3 => p_information3
,p_pei_information4 => p_information4
,p_pei_information5 => p_information5
,p_pei_information6 => p_information6
,p_pei_information7 => p_information7
,p_pei_information8 => p_information8
,p_pei_information9 => p_information9
,p_pei_information10 => p_information10
,p_pei_information11 => p_information11
,p_pei_information12 => p_information12
,p_pei_information13 => p_information13
,p_pei_information14 => p_information14
,p_pei_information15 => p_information15
,p_pei_information16 => p_information16
,p_pei_information17 => p_information17
,p_pei_information18 => p_information18
,p_pei_information19 => p_information19
,p_pei_information20 => p_information20
,p_pei_information21 => p_information21
,p_pei_information22 => p_information22
,p_pei_information23 => p_information23
,p_pei_information24 => p_information24
,p_pei_information25 => p_information25
,p_pei_information26 => p_information26
,p_pei_information27 => p_information27
,p_pei_information28 => p_information28
,p_pei_information29 => p_information29
,p_pei_information30 => p_information30
);
hr_assignment_extra_info_api.update_assignment_extra_info
(p_validate => hr_java_conv_util_ss.get_boolean (
p_number => p_validate)
,p_assignment_extra_info_id => p_extra_info_id
,p_object_version_number => p_object_version_number
,p_aei_attribute_category => p_attribute_category
,p_aei_attribute1 => p_attribute1
,p_aei_attribute2 => p_attribute2
,p_aei_attribute3 => p_attribute3
,p_aei_attribute4 => p_attribute4
,p_aei_attribute5 => p_attribute5
,p_aei_attribute6 => p_attribute6
,p_aei_attribute7 => p_attribute7
,p_aei_attribute8 => p_attribute8
,p_aei_attribute9 => p_attribute9
,p_aei_attribute10 => p_attribute10
,p_aei_attribute11 => p_attribute11
,p_aei_attribute12 => p_attribute12
,p_aei_attribute13 => p_attribute13
,p_aei_attribute14 => p_attribute14
,p_aei_attribute15 => p_attribute15
,p_aei_attribute16 => p_attribute16
,p_aei_attribute17 => p_attribute17
,p_aei_attribute18 => p_attribute18
,p_aei_attribute19 => p_attribute19
,p_aei_attribute20 => p_attribute20
,p_aei_information_category => p_information_category
,p_aei_information1 => p_information1
,p_aei_information2 => p_information2
,p_aei_information3 => p_information3
,p_aei_information4 => p_information4
,p_aei_information5 => p_information5
,p_aei_information6 => p_information6
,p_aei_information7 => p_information7
,p_aei_information8 => p_information8
,p_aei_information9 => p_information9
,p_aei_information10 => p_information10
,p_aei_information11 => p_information11
,p_aei_information12 => p_information12
,p_aei_information13 => p_information13
,p_aei_information14 => p_information14
,p_aei_information15 => p_information15
,p_aei_information16 => p_information16
,p_aei_information17 => p_information17
,p_aei_information18 => p_information18
,p_aei_information19 => p_information19
,p_aei_information20 => p_information20
,p_aei_information21 => p_information21
,p_aei_information22 => p_information22
,p_aei_information23 => p_information23
,p_aei_information24 => p_information24
,p_aei_information25 => p_information25
,p_aei_information26 => p_information26
,p_aei_information27 => p_information27
,p_aei_information28 => p_information28
,p_aei_information29 => p_information29
,p_aei_information30 => p_information30
);
END update_eit;
procedure delete_eit
(p_validate in number default 0
,p_login_person_id in number default null
,p_eit_type in varchar2
,p_eit_type_id in number
,p_person_id in number
,p_information_type in varchar2
,p_extra_info_id in number
,p_object_version_number in number
-- EndRegistration
,p_item_type in varchar2
,p_item_key in varchar2
,p_activity_id in number
,p_action in varchar2
,p_old_extra_info_id in number default null
,p_old_object_version_number in number default null
,p_save_mode in varchar2 default null
,p_error_message out nocopy long
) IS
--
l_error_message long default null;
l_proc varchar2(72) := g_package||'delete_sit';
hr_person_extra_info_api.delete_person_extra_info
(p_validate => hr_java_conv_util_ss.get_boolean (
p_number => p_validate)
,p_person_extra_info_id => p_extra_info_id
,p_object_version_number => p_object_version_number
);
hr_assignment_extra_info_api.DELETE_ASSIGNMENT_EXTRA_INFO
(p_validate => hr_java_conv_util_ss.get_boolean (
p_number => p_validate)
,p_assignment_extra_info_id => p_extra_info_id
,p_object_version_number => p_object_version_number
);
END delete_eit;