[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_referral_info
(p_validate in boolean default false
,p_referral_info_id in number
,p_source_type in varchar2 default hr_api.g_varchar2
,p_source_name in varchar2 default hr_api.g_varchar2
,p_source_criteria1 in varchar2 default hr_api.g_varchar2
,p_source_value1 in varchar2 default hr_api.g_varchar2
,p_source_criteria2 in varchar2 default hr_api.g_varchar2
,p_source_value2 in varchar2 default hr_api.g_varchar2
,p_source_criteria3 in varchar2 default hr_api.g_varchar2
,p_source_value3 in varchar2 default hr_api.g_varchar2
,p_source_criteria4 in varchar2 default hr_api.g_varchar2
,p_source_value4 in varchar2 default hr_api.g_varchar2
,p_source_criteria5 in varchar2 default hr_api.g_varchar2
,p_source_value5 in varchar2 default hr_api.g_varchar2
,p_source_person_id in number default hr_api.g_number
,p_candidate_comment in varchar2 default hr_api.g_varchar2
,p_employee_comment in varchar2 default hr_api.g_varchar2
,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
,p_irf_information_category in varchar2 default hr_api.g_varchar2
,p_irf_information1 in varchar2 default hr_api.g_varchar2
,p_irf_information2 in varchar2 default hr_api.g_varchar2
,p_irf_information3 in varchar2 default hr_api.g_varchar2
,p_irf_information4 in varchar2 default hr_api.g_varchar2
,p_irf_information5 in varchar2 default hr_api.g_varchar2
,p_irf_information6 in varchar2 default hr_api.g_varchar2
,p_irf_information7 in varchar2 default hr_api.g_varchar2
,p_irf_information8 in varchar2 default hr_api.g_varchar2
,p_irf_information9 in varchar2 default hr_api.g_varchar2
,p_irf_information10 in varchar2 default hr_api.g_varchar2
,p_object_version_number in out nocopy number
,p_start_date out nocopy date
,p_end_date out nocopy date
) is
--
-- Declare cursors and local variables
--
l_object_version_number number;
l_proc varchar2(72) := g_package||'update_referral_info';
savepoint update_referral_info;
irc_referral_info_bk2.update_referral_info_b
(p_referral_info_id => p_referral_info_id
,p_source_type => p_source_type
,p_source_name => p_source_name
,p_source_criteria1 => p_source_criteria1
,p_source_value1 => p_source_value1
,p_source_criteria2 => p_source_criteria2
,p_source_value2 => p_source_value2
,p_source_criteria3 => p_source_criteria3
,p_source_value3 => p_source_value3
,p_source_criteria4 => p_source_criteria4
,p_source_value4 => p_source_value4
,p_source_criteria5 => p_source_criteria5
,p_source_value5 => p_source_value5
,p_source_person_id => p_source_person_id
,p_candidate_comment => p_candidate_comment
,p_employee_comment => p_employee_comment
,p_irf_attribute_category => p_irf_attribute_category
,p_irf_attribute1 => p_irf_attribute1
,p_irf_attribute2 => p_irf_attribute2
,p_irf_attribute3 => p_irf_attribute3
,p_irf_attribute4 => p_irf_attribute4
,p_irf_attribute5 => p_irf_attribute5
,p_irf_attribute6 => p_irf_attribute6
,p_irf_attribute7 => p_irf_attribute7
,p_irf_attribute8 => p_irf_attribute8
,p_irf_attribute9 => p_irf_attribute9
,p_irf_attribute10 => p_irf_attribute10
,p_irf_information_category => p_irf_information_category
,p_irf_information1 => p_irf_information1
,p_irf_information2 => p_irf_information2
,p_irf_information3 => p_irf_information3
,p_irf_information4 => p_irf_information4
,p_irf_information5 => p_irf_information5
,p_irf_information6 => p_irf_information6
,p_irf_information7 => p_irf_information7
,p_irf_information8 => p_irf_information8
,p_irf_information9 => p_irf_information9
,p_irf_information10 => p_irf_information10
,p_object_version_number => p_object_version_number
);
(p_module_name => 'update_referral_info'
,p_hook_type => 'BP'
);
,p_datetrack_mode => 'UPDATE'
,p_referral_info_id => p_referral_info_id
,p_object_version_number => l_object_version_number
,p_source_type => p_source_type
,p_source_name => p_source_name
,p_source_criteria1 => p_source_criteria1
,p_source_value1 => p_source_value1
,p_source_criteria2 => p_source_criteria2
,p_source_value2 => p_source_value2
,p_source_criteria3 => p_source_criteria3
,p_source_value3 => p_source_value3
,p_source_criteria4 => p_source_criteria4
,p_source_value4 => p_source_value4
,p_source_criteria5 => p_source_criteria5
,p_source_value5 => p_source_value5
,p_source_person_id => p_source_person_id
,p_candidate_comment => p_candidate_comment
,p_employee_comment => p_employee_comment
,p_irf_attribute_category => p_irf_attribute_category
,p_irf_attribute1 => p_irf_attribute1
,p_irf_attribute2 => p_irf_attribute2
,p_irf_attribute3 => p_irf_attribute3
,p_irf_attribute4 => p_irf_attribute4
,p_irf_attribute5 => p_irf_attribute5
,p_irf_attribute6 => p_irf_attribute6
,p_irf_attribute7 => p_irf_attribute7
,p_irf_attribute8 => p_irf_attribute8
,p_irf_attribute9 => p_irf_attribute9
,p_irf_attribute10 => p_irf_attribute10
,p_irf_information_category => p_irf_information_category
,p_irf_information1 => p_irf_information1
,p_irf_information2 => p_irf_information2
,p_irf_information3 => p_irf_information3
,p_irf_information4 => p_irf_information4
,p_irf_information5 => p_irf_information5
,p_irf_information6 => p_irf_information6
,p_irf_information7 => p_irf_information7
,p_irf_information8 => p_irf_information8
,p_irf_information9 => p_irf_information9
,p_irf_information10 => p_irf_information10
,p_start_date => l_start_date
,p_end_date => l_end_date
);
irc_referral_info_bk2.update_referral_info_a
(p_referral_info_id => p_referral_info_id
,p_source_type => p_source_type
,p_source_name => p_source_name
,p_source_criteria1 => p_source_criteria1
,p_source_value1 => p_source_value1
,p_source_criteria2 => p_source_criteria2
,p_source_value2 => p_source_value2
,p_source_criteria3 => p_source_criteria3
,p_source_value3 => p_source_value3
,p_source_criteria4 => p_source_criteria4
,p_source_value4 => p_source_value4
,p_source_criteria5 => p_source_criteria5
,p_source_value5 => p_source_value5
,p_source_person_id => p_source_person_id
,p_candidate_comment => p_candidate_comment
,p_employee_comment => p_employee_comment
,p_irf_attribute_category => p_irf_attribute_category
,p_irf_attribute1 => p_irf_attribute1
,p_irf_attribute2 => p_irf_attribute2
,p_irf_attribute3 => p_irf_attribute3
,p_irf_attribute4 => p_irf_attribute4
,p_irf_attribute5 => p_irf_attribute5
,p_irf_attribute6 => p_irf_attribute6
,p_irf_attribute7 => p_irf_attribute7
,p_irf_attribute8 => p_irf_attribute8
,p_irf_attribute9 => p_irf_attribute9
,p_irf_attribute10 => p_irf_attribute10
,p_irf_information_category => p_irf_information_category
,p_irf_information1 => p_irf_information1
,p_irf_information2 => p_irf_information2
,p_irf_information3 => p_irf_information3
,p_irf_information4 => p_irf_information4
,p_irf_information5 => p_irf_information5
,p_irf_information6 => p_irf_information6
,p_irf_information7 => p_irf_information7
,p_irf_information8 => p_irf_information8
,p_irf_information9 => p_irf_information9
,p_irf_information10 => p_irf_information10
,p_object_version_number => p_object_version_number
);
(p_module_name => 'update_referral_info'
,p_hook_type => 'AP'
);
rollback to update_referral_info;
rollback to update_referral_info;
end update_referral_info;
select *
from irc_referral_info
where object_id = p_source_assignment_id;
Cursor C_Sel1 is select irc_referral_info_s.nextval from sys.dual;
insert into irc_referral_info
(referral_info_id
,object_id
,object_type
,start_date
,end_date
,source_type
,source_name
,source_criteria1
,source_value1
,source_criteria2
,source_value2
,source_criteria3
,source_value3
,source_criteria4
,source_value4
,source_criteria5
,source_value5
,source_person_id
,candidate_comment
,employee_comment
,irf_attribute_category
,irf_attribute1
,irf_attribute2
,irf_attribute3
,irf_attribute4
,irf_attribute5
,irf_attribute6
,irf_attribute7
,irf_attribute8
,irf_attribute9
,irf_attribute10
,irf_information_category
,irf_information1
,irf_information2
,irf_information3
,irf_information4
,irf_information5
,irf_information6
,irf_information7
,irf_information8
,irf_information9
,irf_information10
,object_created_by
,object_version_number
)
Values
(l_referral_info_id
,p_target_assignment_id
,l_ref_rec.object_type
,l_ref_rec.start_date
,l_ref_rec.end_date
,l_ref_rec.source_type
,l_ref_rec.source_name
,l_ref_rec.source_criteria1
,l_ref_rec.source_value1
,l_ref_rec.source_criteria2
,l_ref_rec.source_value2
,l_ref_rec.source_criteria3
,l_ref_rec.source_value3
,l_ref_rec.source_criteria4
,l_ref_rec.source_value4
,l_ref_rec.source_criteria5
,l_ref_rec.source_value5
,l_ref_rec.source_person_id
,l_ref_rec.candidate_comment
,l_ref_rec.employee_comment
,l_ref_rec.irf_attribute_category
,l_ref_rec.irf_attribute1
,l_ref_rec.irf_attribute2
,l_ref_rec.irf_attribute3
,l_ref_rec.irf_attribute4
,l_ref_rec.irf_attribute5
,l_ref_rec.irf_attribute6
,l_ref_rec.irf_attribute7
,l_ref_rec.irf_attribute8
,l_ref_rec.irf_attribute9
,l_ref_rec.irf_attribute10
,l_ref_rec.irf_information_category
,l_ref_rec.irf_information1
,l_ref_rec.irf_information2
,l_ref_rec.irf_information3
,l_ref_rec.irf_information4
,l_ref_rec.irf_information5
,l_ref_rec.irf_information6
,l_ref_rec.irf_information7
,l_ref_rec.irf_information8
,l_ref_rec.irf_information9
,l_ref_rec.irf_information10
,l_ref_rec.object_created_by
,l_ref_rec.object_version_number
);