The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select SHARED_TYPE_ID
from per_shared_types
where LOOKUP_TYPE = 'POSITION_AVAILABILITY_STATUS'
AND SYSTEM_TYPE_CD = 'ELIMINATED';
select object_version_number, position_definition_id, name
from hr_all_positions_f
where position_id = p_position_id
and p_effective_date between effective_start_date and effective_end_date;
hr_position_api.update_position
(p_position_id =>p_position_id
,p_effective_start_date =>l_effective_start_date
,p_effective_end_date =>l_effective_end_date
,p_position_definition_id =>l_position_definition_id
,p_valid_grades_changed_warning =>l_valid_grades_changed1
,p_name =>l_name
,p_availability_status_id =>l_availability_status_id
,p_object_version_number =>p_object_version_number
,p_effective_date =>p_effective_date
,p_datetrack_mode =>'UPDATE'
);
function delete_unused_per_pos_def(p_position_definition_id number)
return boolean is
--
cursor c_per_pos_def_used(p_position_definition_id number) is
SELECT 'x'
from dual
where exists (
select null
from hr_all_positions_f
where position_definition_id = p_position_definition_id)
or exists (
select null
from per_all_positions
where position_definition_id = p_position_definition_id)
or exists (
select null
from per_mm_positions
where new_position_definition_id = p_position_definition_id)
or exists (
select null
from pqh_position_transactions
where position_definition_id = p_position_definition_id);
delete from per_position_definitions
where position_definition_id = p_position_definition_id;
select business_group_id
from per_jobs
where job_id = p_job_id;
select segment1,
segment2,
segment3,
segment4,
segment5,
segment6,
segment7,
segment8,
segment9,
segment10,
segment11,
segment12,
segment13,
segment14,
segment15,
segment16,
segment17,
segment18,
segment19,
segment20,
segment21,
segment22,
segment23,
segment24,
segment25,
segment26,
segment27,
segment28,
segment29,
segment30
from per_position_definitions
where position_definition_id = l_position_definition_id;
cursor c1 is select object_version_number
from hr_all_positions_f
where position_id = p_position_id
and p_effective_date between effective_start_date
and effective_end_date ;
select system_type_cd
from per_shared_types
where shared_type_id = p_availability_status_id;
procedure delete_eliminated_rec(p_position_id number) is
l_system_availability_status varchar2(100);
l_deleted varchar2(10):='N';
select position_id, effective_start_date, effective_end_date, availability_status_id
from hr_all_Positions_f
where position_id = p_position_id
order by effective_start_date desc
for update;
l_proc := g_package||'delete_eliminated_rec' ;
delete hr_all_positions_f
where current of c2;
l_deleted := 'Y';
if l_deleted = 'Y' then
fetch c2 into r2;
update hr_all_positions_f
set effective_end_date = l_eot
where current of c2;
procedure update_position
(p_validate in boolean default false
,p_position_id in number
,p_object_version_number in out nocopy number
,p_language_code in varchar2 default hr_api.userenv_lang
,p_successor_position_id in number default hr_api.g_number
,p_relief_position_id in number default hr_api.g_number
,p_location_id in number default hr_api.g_number
,p_date_effective in date default hr_api.g_date
,p_comments in varchar2 default hr_api.g_varchar2
,p_date_end in date default hr_api.g_date
,p_frequency in varchar2 default hr_api.g_varchar2
,p_probation_period in number default hr_api.g_number
,p_probation_period_units in varchar2 default hr_api.g_varchar2
,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
,p_time_normal_finish in varchar2 default hr_api.g_varchar2
,p_time_normal_start in varchar2 default hr_api.g_varchar2
,p_status in varchar2 default hr_api.g_varchar2
,p_working_hours in number default hr_api.g_number
,p_attribute_category in varchar2 default hr_api.g_varchar2
,p_attribute1 in varchar2 default hr_api.g_varchar2
,p_attribute2 in varchar2 default hr_api.g_varchar2
,p_attribute3 in varchar2 default hr_api.g_varchar2
,p_attribute4 in varchar2 default hr_api.g_varchar2
,p_attribute5 in varchar2 default hr_api.g_varchar2
,p_attribute6 in varchar2 default hr_api.g_varchar2
,p_attribute7 in varchar2 default hr_api.g_varchar2
,p_attribute8 in varchar2 default hr_api.g_varchar2
,p_attribute9 in varchar2 default hr_api.g_varchar2
,p_attribute10 in varchar2 default hr_api.g_varchar2
,p_attribute11 in varchar2 default hr_api.g_varchar2
,p_attribute12 in varchar2 default hr_api.g_varchar2
,p_attribute13 in varchar2 default hr_api.g_varchar2
,p_attribute14 in varchar2 default hr_api.g_varchar2
,p_attribute15 in varchar2 default hr_api.g_varchar2
,p_attribute16 in varchar2 default hr_api.g_varchar2
,p_attribute17 in varchar2 default hr_api.g_varchar2
,p_attribute18 in varchar2 default hr_api.g_varchar2
,p_attribute19 in varchar2 default hr_api.g_varchar2
,p_attribute20 in varchar2 default hr_api.g_varchar2
,p_segment1 in varchar2 default hr_api.g_varchar2
,p_segment2 in varchar2 default hr_api.g_varchar2
,p_segment3 in varchar2 default hr_api.g_varchar2
,p_segment4 in varchar2 default hr_api.g_varchar2
,p_segment5 in varchar2 default hr_api.g_varchar2
,p_segment6 in varchar2 default hr_api.g_varchar2
,p_segment7 in varchar2 default hr_api.g_varchar2
,p_segment8 in varchar2 default hr_api.g_varchar2
,p_segment9 in varchar2 default hr_api.g_varchar2
,p_segment10 in varchar2 default hr_api.g_varchar2
,p_segment11 in varchar2 default hr_api.g_varchar2
,p_segment12 in varchar2 default hr_api.g_varchar2
,p_segment13 in varchar2 default hr_api.g_varchar2
,p_segment14 in varchar2 default hr_api.g_varchar2
,p_segment15 in varchar2 default hr_api.g_varchar2
,p_segment16 in varchar2 default hr_api.g_varchar2
,p_segment17 in varchar2 default hr_api.g_varchar2
,p_segment18 in varchar2 default hr_api.g_varchar2
,p_segment19 in varchar2 default hr_api.g_varchar2
,p_segment20 in varchar2 default hr_api.g_varchar2
,p_segment21 in varchar2 default hr_api.g_varchar2
,p_segment22 in varchar2 default hr_api.g_varchar2
,p_segment23 in varchar2 default hr_api.g_varchar2
,p_segment24 in varchar2 default hr_api.g_varchar2
,p_segment25 in varchar2 default hr_api.g_varchar2
,p_segment26 in varchar2 default hr_api.g_varchar2
,p_segment27 in varchar2 default hr_api.g_varchar2
,p_segment28 in varchar2 default hr_api.g_varchar2
,p_segment29 in varchar2 default hr_api.g_varchar2
,p_segment30 in varchar2 default hr_api.g_varchar2
,p_concat_segments in varchar2 default hr_api.g_varchar2
,p_position_definition_id in out nocopy number
,p_name in out nocopy varchar2
,p_valid_grades_changed_warning out nocopy boolean
) is
--
-- Declare cursors and local variables
--
-- bug 2271064 initialize l_position_definition_id and segment variables with
-- values where these are passed into program.
--
l_object_version_number per_positions.object_version_number%TYPE;
select pd.id_flex_num
from per_position_definitions pd
where pd.position_definition_id = l_position_definition_id;
select
max(effective_start_date)
from hr_all_positions_f
where position_id = p_position_id and
nvl(copied_to_old_table_flag, 'N') = 'Y';
select segment1,
segment2,
segment3,
segment4,
segment5,
segment6,
segment7,
segment8,
segment9,
segment10,
segment11,
segment12,
segment13,
segment14,
segment15,
segment16,
segment17,
segment18,
segment19,
segment20,
segment21,
segment22,
segment23,
segment24,
segment25,
segment26,
segment27,
segment28,
segment29,
segment30
from per_position_definitions
where position_definition_id = l_position_definition_id;
l_proc := g_package||'update_position';
savepoint update_position;
delete_eliminated_rec(p_position_id);
hr_position_api.update_position
(p_position_id => p_position_id
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_effective_date => l_effective_date
,p_successor_position_id => p_successor_position_id
,p_relief_position_id => p_relief_position_id
,p_location_id => p_location_id
,p_position_definition_id => l_position_definition_id
,p_date_effective => l_date_effective
,p_comments => p_comments
,p_date_end => null --l_date_end
,p_frequency => p_frequency
,p_name => l_name
,p_probation_period => p_probation_period
,p_probation_period_unit_cd => p_probation_period_units
,p_replacement_required_flag => p_replacement_required_flag
,p_time_normal_finish => p_time_normal_finish
,p_time_normal_start => p_time_normal_start
,p_status => p_status
,p_working_hours => p_working_hours
,p_attribute_category => p_attribute_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,p_attribute16 => p_attribute16
,p_attribute17 => p_attribute17
,p_attribute18 => p_attribute18
,p_attribute19 => p_attribute19
,p_attribute20 => p_attribute20
,p_segment1 => l_segment1
,p_segment2 => l_segment2
,p_segment3 => l_segment3
,p_segment4 => l_segment4
,p_segment5 => l_segment5
,p_segment6 => l_segment6
,p_segment7 => l_segment7
,p_segment8 => l_segment8
,p_segment9 => l_segment9
,p_segment10 => l_segment10
,p_segment11 => l_segment11
,p_segment12 => l_segment12
,p_segment13 => l_segment13
,p_segment14 => l_segment14
,p_segment15 => l_segment15
,p_segment16 => l_segment16
,p_segment17 => l_segment17
,p_segment18 => l_segment18
,p_segment19 => l_segment19
,p_segment20 => l_segment20
,p_segment21 => l_segment21
,p_segment22 => l_segment22
,p_segment23 => l_segment23
,p_segment24 => l_segment24
,p_segment25 => l_segment25
,p_segment26 => l_segment26
,p_segment27 => l_segment27
,p_segment28 => l_segment28
,p_segment29 => l_segment29
,p_segment30 => l_segment30
,p_concat_segments => p_concat_segments
,p_object_version_number => l_object_version_number
,p_valid_grades_changed_warning => l_valid_grades_changed1
--,p_maintain_valid_grade_warning => l_valid_grades_changed1
,p_datetrack_mode => 'CORRECTION'
,p_validate => p_validate
);
ROLLBACK TO update_position;
ROLLBACK TO update_position;
end update_position;
cursor c1 is select min(effective_start_date)
from hr_all_positions_f
where position_id = p_position_id;
procedure delete_position(
p_validate boolean default false,
p_position_id number,
p_object_version_number number) is
l_object_version_number number;
l_proc := g_package||'delete_position';
savepoint delete_position;
hr_position_api.delete_position
(
p_validate => p_validate
,p_position_id => p_position_id
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_object_version_number => l_object_version_number
,p_effective_date => l_effective_date
,p_datetrack_mode => 'ZAP'
);
ROLLBACK TO delete_position;
select
vgr.valid_grade_id valid_grade_id
,vgr.object_version_number object_version_number
,vgr.date_from date_from
,vgr.date_to date_to
from per_valid_grades vgr
where vgr.position_id = p_position_id;
select object_version_number
from per_all_positions
where position_id = p_position_id;
elsif p_datetrack_mode = hr_api.g_update or
p_datetrack_mode = hr_api.g_update_change_insert or
p_datetrack_mode = hr_api.g_correction or
p_datetrack_mode = hr_api.g_delete or
p_datetrack_mode = hr_api.g_delete_next_change or
p_datetrack_mode = hr_api.g_future_change or
p_datetrack_mode is null
then
--
-- update in per_all_positions table
--
begin
-- if l_effective_end_date <> hr_api.g_eot then
-- lock the position rows explicitly
if g_debug then
hr_utility.set_location(l_proc, 80);
update hr_all_positions_f
set copied_to_old_table_flag = 'N'
where position_id = p_position_id and
effective_end_date >
decode( p_datetrack_mode
,hr_api.g_update, p_effective_date
,hr_api.g_correction, p_effective_date
,hr_api.g_update_change_insert, p_effective_date
,hr_api.g_delete, p_effective_date - 1
,hr_api.g_delete_next_change, p_effective_date - 1
,hr_api.g_future_change, p_effective_date - 1
);
,p_update_source_cd in varchar2 default null
,p_working_hours in number default null
,p_works_council_approval_flag in varchar2 default null
,p_work_period_type_cd in varchar2 default null
,p_work_term_end_day_cd in varchar2 default null
,p_work_term_end_month_cd in varchar2 default null
,p_proposed_fte_for_layoff in number default null
,p_proposed_date_for_layoff in date default null
,p_pay_basis_id in number default null
,p_supervisor_id in number default null
--,p_copied_to_old_table_flag 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_information_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_attribute21 in varchar2 default null
,p_attribute22 in varchar2 default null
,p_attribute23 in varchar2 default null
,p_attribute24 in varchar2 default null
,p_attribute25 in varchar2 default null
,p_attribute26 in varchar2 default null
,p_attribute27 in varchar2 default null
,p_attribute28 in varchar2 default null
,p_attribute29 in varchar2 default null
,p_attribute30 in varchar2 default null
,p_attribute_category in varchar2 default null
,p_segment1 in varchar2 default null
,p_segment2 in varchar2 default null
,p_segment3 in varchar2 default null
,p_segment4 in varchar2 default null
,p_segment5 in varchar2 default null
,p_segment6 in varchar2 default null
,p_segment7 in varchar2 default null
,p_segment8 in varchar2 default null
,p_segment9 in varchar2 default null
,p_segment10 in varchar2 default null
,p_segment11 in varchar2 default null
,p_segment12 in varchar2 default null
,p_segment13 in varchar2 default null
,p_segment14 in varchar2 default null
,p_segment15 in varchar2 default null
,p_segment16 in varchar2 default null
,p_segment17 in varchar2 default null
,p_segment18 in varchar2 default null
,p_segment19 in varchar2 default null
,p_segment20 in varchar2 default null
,p_segment21 in varchar2 default null
,p_segment22 in varchar2 default null
,p_segment23 in varchar2 default null
,p_segment24 in varchar2 default null
,p_segment25 in varchar2 default null
,p_segment26 in varchar2 default null
,p_segment27 in varchar2 default null
,p_segment28 in varchar2 default null
,p_segment29 in varchar2 default null
,p_segment30 in varchar2 default null
,p_concat_segments in varchar2 default null
,p_request_id in number default null
,p_program_application_id in number default null
,p_program_id in number default null
,p_program_update_date in date default null
,p_security_profile_id in number default hr_security.get_security_profile
) is
--
-- Declare cursors and local variables
--
l_position_id hr_all_positions_f.position_id%TYPE;
select view_all_positions_flag
from per_security_profiles
where security_profile_id = p_security_profile_id;
select business_group_id
from per_jobs
where job_id = p_job_id;
select pbg.position_structure
from per_business_groups pbg
where pbg.business_group_id = l_business_group_id;
select pd.id_flex_num
from per_position_definitions pd
where pd.position_definition_id = l_position_definition_id;
select SHARED_TYPE_ID
from per_shared_types
where LOOKUP_TYPE = 'POSITION_AVAILABILITY_STATUS'
AND SYSTEM_TYPE_CD = 'ACTIVE'
and (business_group_id = p_business_group_id or business_group_id is null);
select object_version_number
from per_all_positions
where position_id = p_position_id;
select segment1,
segment2,
segment3,
segment4,
segment5,
segment6,
segment7,
segment8,
segment9,
segment10,
segment11,
segment12,
segment13,
segment14,
segment15,
segment16,
segment17,
segment18,
segment19,
segment20,
segment21,
segment22,
segment23,
segment24,
segment25,
segment26,
segment27,
segment28,
segment29,
segment30
from per_position_definitions
where position_definition_id = l_position_definition_id;
,p_update_source_cd => p_update_source_cd
,p_working_hours => p_working_hours
,p_works_council_approval_flag => p_works_council_approval_flag
,p_work_period_type_cd => p_work_period_type_cd
,p_work_term_end_day_cd => p_work_term_end_day_cd
,p_work_term_end_month_cd => p_work_term_end_month_cd
,p_proposed_fte_for_layoff => p_proposed_fte_for_layoff
,p_proposed_date_for_layoff => p_proposed_date_for_layoff
,p_pay_basis_id => p_pay_basis_id
,p_supervisor_id => p_supervisor_id
--,p_copied_to_old_table_flag => l_copied_to_old_table_flag
,p_information1 => p_information1
,p_information2 => p_information2
,p_information3 => p_information3
,p_information4 => p_information4
,p_information5 => p_information5
,p_information6 => p_information6
,p_information7 => p_information7
,p_information8 => p_information8
,p_information9 => p_information9
,p_information10 => p_information10
,p_information11 => p_information11
,p_information12 => p_information12
,p_information13 => p_information13
,p_information14 => p_information14
,p_information15 => p_information15
,p_information16 => p_information16
,p_information17 => p_information17
,p_information18 => p_information18
,p_information19 => p_information19
,p_information20 => p_information20
,p_information21 => p_information21
,p_information22 => p_information22
,p_information23 => p_information23
,p_information24 => p_information24
,p_information25 => p_information25
,p_information26 => p_information26
,p_information27 => p_information27
,p_information28 => p_information28
,p_information29 => p_information29
,p_information30 => p_information30
,p_information_category => p_information_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,p_attribute16 => p_attribute16
,p_attribute17 => p_attribute17
,p_attribute18 => p_attribute18
,p_attribute19 => p_attribute19
,p_attribute20 => p_attribute20
,p_attribute21 => p_attribute21
,p_attribute22 => p_attribute22
,p_attribute23 => p_attribute23
,p_attribute24 => p_attribute24
,p_attribute25 => p_attribute25
,p_attribute26 => p_attribute26
,p_attribute27 => p_attribute27
,p_attribute28 => p_attribute28
,p_attribute29 => p_attribute29
,p_attribute30 => p_attribute30
,p_attribute_category => p_attribute_category
,p_segment1 => l_segment1
,p_segment2 => l_segment2
,p_segment3 => l_segment3
,p_segment4 => l_segment4
,p_segment5 => l_segment5
,p_segment6 => l_segment6
,p_segment7 => l_segment7
,p_segment8 => l_segment8
,p_segment9 => l_segment9
,p_segment10 => l_segment10
,p_segment11 => l_segment11
,p_segment12 => l_segment12
,p_segment13 => l_segment13
,p_segment14 => l_segment14
,p_segment15 => l_segment15
,p_segment16 => l_segment16
,p_segment17 => l_segment17
,p_segment18 => l_segment18
,p_segment19 => l_segment19
,p_segment20 => l_segment20
,p_segment21 => l_segment21
,p_segment22 => l_segment22
,p_segment23 => l_segment23
,p_segment24 => l_segment24
,p_segment25 => l_segment25
,p_segment26 => l_segment26
,p_segment27 => l_segment27
,p_segment28 => l_segment28
,p_segment29 => l_segment29
,p_segment30 => l_segment30
,p_concat_segments => p_concat_segments
,p_request_id => p_request_id
,p_program_application_id => p_program_application_id
,p_program_id => p_program_id
,p_program_update_date => p_program_update_date
,p_effective_date => trunc(p_effective_date)
,p_language_code => l_language_code
);
,p_update_source_cd => p_update_source_cd
,p_working_hours => p_working_hours
,p_works_council_approval_flag => p_works_council_approval_flag
,p_work_period_type_cd => p_work_period_type_cd
,p_work_term_end_day_cd => p_work_term_end_day_cd
,p_work_term_end_month_cd => p_work_term_end_month_cd
,p_proposed_fte_for_layoff => p_proposed_fte_for_layoff
,p_proposed_date_for_layoff => p_proposed_date_for_layoff
,p_pay_basis_id => p_pay_basis_id
,p_supervisor_id => p_supervisor_id
,p_copied_to_old_table_flag => 'N'
,p_information1 => p_information1
,p_information2 => p_information2
,p_information3 => p_information3
,p_information4 => p_information4
,p_information5 => p_information5
,p_information6 => p_information6
,p_information7 => p_information7
,p_information8 => p_information8
,p_information9 => p_information9
,p_information10 => p_information10
,p_information11 => p_information11
,p_information12 => p_information12
,p_information13 => p_information13
,p_information14 => p_information14
,p_information15 => p_information15
,p_information16 => p_information16
,p_information17 => p_information17
,p_information18 => p_information18
,p_information19 => p_information19
,p_information20 => p_information20
,p_information21 => p_information21
,p_information22 => p_information22
,p_information23 => p_information23
,p_information24 => p_information24
,p_information25 => p_information25
,p_information26 => p_information26
,p_information27 => p_information27
,p_information28 => p_information28
,p_information29 => p_information29
,p_information30 => p_information30
,p_information_category => p_information_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,p_attribute16 => p_attribute16
,p_attribute17 => p_attribute17
,p_attribute18 => p_attribute18
,p_attribute19 => p_attribute19
,p_attribute20 => p_attribute20
,p_attribute21 => p_attribute21
,p_attribute22 => p_attribute22
,p_attribute23 => p_attribute23
,p_attribute24 => p_attribute24
,p_attribute25 => p_attribute25
,p_attribute26 => p_attribute26
,p_attribute27 => p_attribute27
,p_attribute28 => p_attribute28
,p_attribute29 => p_attribute29
,p_attribute30 => p_attribute30
,p_attribute_category => p_attribute_category
,p_request_id => p_request_id
,p_program_application_id => p_program_application_id
,p_program_id => p_program_id
,p_program_update_date => p_program_update_date
,p_object_version_number => l_object_version_number
,p_effective_date => trunc(p_effective_date)
,p_validate => p_validate
,p_security_profile_id => p_security_profile_id
);
,p_update_source_cd => p_update_source_cd
,p_working_hours => p_working_hours
,p_works_council_approval_flag => p_works_council_approval_flag
,p_work_period_type_cd => p_work_period_type_cd
,p_work_term_end_day_cd => p_work_term_end_day_cd
,p_work_term_end_month_cd => p_work_term_end_month_cd
,p_proposed_fte_for_layoff => p_proposed_fte_for_layoff
,p_proposed_date_for_layoff => p_proposed_date_for_layoff
,p_pay_basis_id => p_pay_basis_id
,p_supervisor_id => p_supervisor_id
--,p_copied_to_old_table_flag => p_copied_to_old_table_flag
,p_information1 => p_information1
,p_information2 => p_information2
,p_information3 => p_information3
,p_information4 => p_information4
,p_information5 => p_information5
,p_information6 => p_information6
,p_information7 => p_information7
,p_information8 => p_information8
,p_information9 => p_information9
,p_information10 => p_information10
,p_information11 => p_information11
,p_information12 => p_information12
,p_information13 => p_information13
,p_information14 => p_information14
,p_information15 => p_information15
,p_information16 => p_information16
,p_information17 => p_information17
,p_information18 => p_information18
,p_information19 => p_information19
,p_information20 => p_information20
,p_information21 => p_information21
,p_information22 => p_information22
,p_information23 => p_information23
,p_information24 => p_information24
,p_information25 => p_information25
,p_information26 => p_information26
,p_information27 => p_information27
,p_information28 => p_information28
,p_information29 => p_information29
,p_information30 => p_information30
,p_information_category => p_information_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,p_attribute16 => p_attribute16
,p_attribute17 => p_attribute17
,p_attribute18 => p_attribute18
,p_attribute19 => p_attribute19
,p_attribute20 => p_attribute20
,p_attribute21 => p_attribute21
,p_attribute22 => p_attribute22
,p_attribute23 => p_attribute23
,p_attribute24 => p_attribute24
,p_attribute25 => p_attribute25
,p_attribute26 => p_attribute26
,p_attribute27 => p_attribute27
,p_attribute28 => p_attribute28
,p_attribute29 => p_attribute29
,p_attribute30 => p_attribute30
,p_attribute_category => p_attribute_category
,p_segment1 => l_segment1
,p_segment2 => l_segment2
,p_segment3 => l_segment3
,p_segment4 => l_segment4
,p_segment5 => l_segment5
,p_segment6 => l_segment6
,p_segment7 => l_segment7
,p_segment8 => l_segment8
,p_segment9 => l_segment9
,p_segment10 => l_segment10
,p_segment11 => l_segment11
,p_segment12 => l_segment12
,p_segment13 => l_segment13
,p_segment14 => l_segment14
,p_segment15 => l_segment15
,p_segment16 => l_segment16
,p_segment17 => l_segment17
,p_segment18 => l_segment18
,p_segment19 => l_segment19
,p_segment20 => l_segment20
,p_segment21 => l_segment21
,p_segment22 => l_segment22
,p_segment23 => l_segment23
,p_segment24 => l_segment24
,p_segment25 => l_segment25
,p_segment26 => l_segment26
,p_segment27 => l_segment27
,p_segment28 => l_segment28
,p_segment29 => l_segment29
,p_segment30 => l_segment30
,p_concat_segments => p_concat_segments
,p_request_id => p_request_id
,p_program_application_id => p_program_application_id
,p_program_id => p_program_id
,p_program_update_date => p_program_update_date
,p_object_version_number => l_object_version_number
,p_effective_date => trunc(p_effective_date)
,p_language_code => l_language_code
);
procedure update_position
(p_validate in boolean default false
,p_position_id in number
,p_effective_start_date out nocopy date
,p_effective_end_date out nocopy date
,p_position_definition_id in out nocopy number
,p_valid_grades_changed_warning out nocopy boolean
,p_name in out nocopy varchar2
,p_language_code in varchar2 default hr_api.userenv_lang
,p_availability_status_id in number default hr_api.g_number
-- ,p_business_group_id in number default hr_api.g_number
,p_entry_step_id in number default hr_api.g_number
,p_entry_grade_rule_id in number default hr_api.g_number
-- ,p_job_id in number default hr_api.g_number
,p_location_id in number default hr_api.g_number
-- ,p_organization_id in number default hr_api.g_number
,p_pay_freq_payroll_id in number default hr_api.g_number
,p_position_transaction_id in number default hr_api.g_number
,p_prior_position_id in number default hr_api.g_number
,p_relief_position_id in number default hr_api.g_number
,p_entry_grade_id in number default hr_api.g_number
,p_successor_position_id in number default hr_api.g_number
,p_supervisor_position_id in number default hr_api.g_number
,p_amendment_date in date default hr_api.g_date
,p_amendment_recommendation in varchar2 default hr_api.g_varchar2
,p_amendment_ref_number in varchar2 default hr_api.g_varchar2
,p_bargaining_unit_cd in varchar2 default hr_api.g_varchar2
,p_comments in long default hr_api.g_varchar2
,p_current_job_prop_end_date in date default hr_api.g_date
,p_current_org_prop_end_date in date default hr_api.g_date
,p_avail_status_prop_end_date in date default hr_api.g_date
,p_date_effective in date default hr_api.g_date
,p_date_end in date default hr_api.g_date
,p_earliest_hire_date in date default hr_api.g_date
,p_fill_by_date in date default hr_api.g_date
,p_frequency in varchar2 default hr_api.g_varchar2
,p_fte in number default hr_api.g_number
,p_max_persons in number default hr_api.g_number
,p_overlap_period in number default hr_api.g_number
,p_overlap_unit_cd in varchar2 default hr_api.g_varchar2
,p_pay_term_end_day_cd in varchar2 default hr_api.g_varchar2
,p_pay_term_end_month_cd in varchar2 default hr_api.g_varchar2
,p_permanent_temporary_flag in varchar2 default hr_api.g_varchar2
,p_permit_recruitment_flag in varchar2 default hr_api.g_varchar2
,p_position_type in varchar2 default hr_api.g_varchar2
,p_posting_description in varchar2 default hr_api.g_varchar2
,p_probation_period in number default hr_api.g_number
,p_probation_period_unit_cd in varchar2 default hr_api.g_varchar2
,p_replacement_required_flag in varchar2 default hr_api.g_varchar2
,p_review_flag in varchar2 default hr_api.g_varchar2
,p_seasonal_flag in varchar2 default hr_api.g_varchar2
,p_security_requirements in varchar2 default hr_api.g_varchar2
,p_status in varchar2 default hr_api.g_varchar2
,p_term_start_day_cd in varchar2 default hr_api.g_varchar2
,p_term_start_month_cd in varchar2 default hr_api.g_varchar2
,p_time_normal_finish in varchar2 default hr_api.g_varchar2
,p_time_normal_start in varchar2 default hr_api.g_varchar2
,p_update_source_cd in varchar2 default hr_api.g_varchar2
,p_working_hours in number default hr_api.g_number
,p_works_council_approval_flag in varchar2 default hr_api.g_varchar2
,p_work_period_type_cd in varchar2 default hr_api.g_varchar2
,p_work_term_end_day_cd in varchar2 default hr_api.g_varchar2
,p_work_term_end_month_cd in varchar2 default hr_api.g_varchar2
,p_proposed_fte_for_layoff in number default hr_api.g_number
,p_proposed_date_for_layoff in date default hr_api.g_date
,p_pay_basis_id in number default hr_api.g_number
,p_supervisor_id in number default hr_api.g_number
--,p_copied_to_old_table_flag 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
,p_information_category in varchar2 default hr_api.g_varchar2
,p_attribute1 in varchar2 default hr_api.g_varchar2
,p_attribute2 in varchar2 default hr_api.g_varchar2
,p_attribute3 in varchar2 default hr_api.g_varchar2
,p_attribute4 in varchar2 default hr_api.g_varchar2
,p_attribute5 in varchar2 default hr_api.g_varchar2
,p_attribute6 in varchar2 default hr_api.g_varchar2
,p_attribute7 in varchar2 default hr_api.g_varchar2
,p_attribute8 in varchar2 default hr_api.g_varchar2
,p_attribute9 in varchar2 default hr_api.g_varchar2
,p_attribute10 in varchar2 default hr_api.g_varchar2
,p_attribute11 in varchar2 default hr_api.g_varchar2
,p_attribute12 in varchar2 default hr_api.g_varchar2
,p_attribute13 in varchar2 default hr_api.g_varchar2
,p_attribute14 in varchar2 default hr_api.g_varchar2
,p_attribute15 in varchar2 default hr_api.g_varchar2
,p_attribute16 in varchar2 default hr_api.g_varchar2
,p_attribute17 in varchar2 default hr_api.g_varchar2
,p_attribute18 in varchar2 default hr_api.g_varchar2
,p_attribute19 in varchar2 default hr_api.g_varchar2
,p_attribute20 in varchar2 default hr_api.g_varchar2
,p_attribute21 in varchar2 default hr_api.g_varchar2
,p_attribute22 in varchar2 default hr_api.g_varchar2
,p_attribute23 in varchar2 default hr_api.g_varchar2
,p_attribute24 in varchar2 default hr_api.g_varchar2
,p_attribute25 in varchar2 default hr_api.g_varchar2
,p_attribute26 in varchar2 default hr_api.g_varchar2
,p_attribute27 in varchar2 default hr_api.g_varchar2
,p_attribute28 in varchar2 default hr_api.g_varchar2
,p_attribute29 in varchar2 default hr_api.g_varchar2
,p_attribute30 in varchar2 default hr_api.g_varchar2
,p_attribute_category in varchar2 default hr_api.g_varchar2
,p_segment1 in varchar2 default hr_api.g_varchar2
,p_segment2 in varchar2 default hr_api.g_varchar2
,p_segment3 in varchar2 default hr_api.g_varchar2
,p_segment4 in varchar2 default hr_api.g_varchar2
,p_segment5 in varchar2 default hr_api.g_varchar2
,p_segment6 in varchar2 default hr_api.g_varchar2
,p_segment7 in varchar2 default hr_api.g_varchar2
,p_segment8 in varchar2 default hr_api.g_varchar2
,p_segment9 in varchar2 default hr_api.g_varchar2
,p_segment10 in varchar2 default hr_api.g_varchar2
,p_segment11 in varchar2 default hr_api.g_varchar2
,p_segment12 in varchar2 default hr_api.g_varchar2
,p_segment13 in varchar2 default hr_api.g_varchar2
,p_segment14 in varchar2 default hr_api.g_varchar2
,p_segment15 in varchar2 default hr_api.g_varchar2
,p_segment16 in varchar2 default hr_api.g_varchar2
,p_segment17 in varchar2 default hr_api.g_varchar2
,p_segment18 in varchar2 default hr_api.g_varchar2
,p_segment19 in varchar2 default hr_api.g_varchar2
,p_segment20 in varchar2 default hr_api.g_varchar2
,p_segment21 in varchar2 default hr_api.g_varchar2
,p_segment22 in varchar2 default hr_api.g_varchar2
,p_segment23 in varchar2 default hr_api.g_varchar2
,p_segment24 in varchar2 default hr_api.g_varchar2
,p_segment25 in varchar2 default hr_api.g_varchar2
,p_segment26 in varchar2 default hr_api.g_varchar2
,p_segment27 in varchar2 default hr_api.g_varchar2
,p_segment28 in varchar2 default hr_api.g_varchar2
,p_segment29 in varchar2 default hr_api.g_varchar2
,p_segment30 in varchar2 default hr_api.g_varchar2
,p_concat_segments in varchar2 default hr_api.g_varchar2
,p_request_id in number default hr_api.g_number
,p_program_application_id in number default hr_api.g_number
,p_program_id in number default hr_api.g_number
,p_program_update_date in date default hr_api.g_date
,p_object_version_number in out nocopy number
,p_effective_date in date
,p_datetrack_mode in varchar2
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) ;
select pd.id_flex_num
from per_position_definitions pd
where pd.position_definition_id = l_position_definition_id;
select min(effective_start_date)
from hr_all_positions_f
where position_id = p_position_id;
select segment1,
segment2,
segment3,
segment4,
segment5,
segment6,
segment7,
segment8,
segment9,
segment10,
segment11,
segment12,
segment13,
segment14,
segment15,
segment16,
segment17,
segment18,
segment19,
segment20,
segment21,
segment22,
segment23,
segment24,
segment25,
segment26,
segment27,
segment28,
segment29,
segment30
from per_position_definitions
where position_definition_id = l_position_definition_id;
l_proc := g_package||'update_position';
savepoint update_position;
hr_position_bk2.update_position_b
(
p_position_id => p_position_id
,p_availability_status_id => p_availability_status_id
-- ,p_business_group_id => p_business_group_id
,p_entry_step_id => p_entry_step_id
,p_entry_grade_rule_id => p_entry_grade_rule_id
-- ,p_job_id => p_job_id
,p_location_id => p_location_id
-- ,p_organization_id => p_organization_id
,p_pay_freq_payroll_id => p_pay_freq_payroll_id
,p_position_definition_id => p_position_definition_id
,p_position_transaction_id => p_position_transaction_id
,p_prior_position_id => p_prior_position_id
,p_relief_position_id => p_relief_position_id
,p_entry_grade_id => p_entry_grade_id
,p_successor_position_id => p_successor_position_id
,p_supervisor_position_id => p_supervisor_position_id
,p_amendment_date => p_amendment_date
,p_amendment_recommendation => p_amendment_recommendation
,p_amendment_ref_number => p_amendment_ref_number
,p_bargaining_unit_cd => p_bargaining_unit_cd
,p_comments => p_comments
,p_current_job_prop_end_date => p_current_job_prop_end_date
,p_current_org_prop_end_date => p_current_org_prop_end_date
,p_avail_status_prop_end_date => p_avail_status_prop_end_date
,p_date_effective => l_date_effective
,p_date_end => l_date_end
,p_earliest_hire_date => p_earliest_hire_date
,p_fill_by_date => p_fill_by_date
,p_frequency => p_frequency
,p_fte => p_fte
,p_max_persons => p_max_persons
,p_name => p_name
,p_overlap_period => p_overlap_period
,p_overlap_unit_cd => p_overlap_unit_cd
,p_pay_term_end_day_cd => p_pay_term_end_day_cd
,p_pay_term_end_month_cd => p_pay_term_end_month_cd
,p_permanent_temporary_flag => p_permanent_temporary_flag
,p_permit_recruitment_flag => p_permit_recruitment_flag
,p_position_type => p_position_type
,p_posting_description => p_posting_description
,p_probation_period => p_probation_period
,p_probation_period_unit_cd => p_probation_period_unit_cd
,p_replacement_required_flag => p_replacement_required_flag
,p_review_flag => p_review_flag
,p_seasonal_flag => p_seasonal_flag
,p_security_requirements => p_security_requirements
,p_status => p_status
,p_term_start_day_cd => p_term_start_day_cd
,p_term_start_month_cd => p_term_start_month_cd
,p_time_normal_finish => p_time_normal_finish
,p_time_normal_start => p_time_normal_start
,p_update_source_cd => p_update_source_cd
,p_working_hours => p_working_hours
,p_works_council_approval_flag => p_works_council_approval_flag
,p_work_period_type_cd => p_work_period_type_cd
,p_work_term_end_day_cd => p_work_term_end_day_cd
,p_work_term_end_month_cd => p_work_term_end_month_cd
,p_proposed_fte_for_layoff => p_proposed_fte_for_layoff
,p_proposed_date_for_layoff => p_proposed_date_for_layoff
,p_pay_basis_id => p_pay_basis_id
,p_supervisor_id => p_supervisor_id
-- ,p_copied_to_old_table_flag => p_copied_to_old_table_flag
,p_information1 => p_information1
,p_information2 => p_information2
,p_information3 => p_information3
,p_information4 => p_information4
,p_information5 => p_information5
,p_information6 => p_information6
,p_information7 => p_information7
,p_information8 => p_information8
,p_information9 => p_information9
,p_information10 => p_information10
,p_information11 => p_information11
,p_information12 => p_information12
,p_information13 => p_information13
,p_information14 => p_information14
,p_information15 => p_information15
,p_information16 => p_information16
,p_information17 => p_information17
,p_information18 => p_information18
,p_information19 => p_information19
,p_information20 => p_information20
,p_information21 => p_information21
,p_information22 => p_information22
,p_information23 => p_information23
,p_information24 => p_information24
,p_information25 => p_information25
,p_information26 => p_information26
,p_information27 => p_information27
,p_information28 => p_information28
,p_information29 => p_information29
,p_information30 => p_information30
,p_information_category => p_information_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,p_attribute16 => p_attribute16
,p_attribute17 => p_attribute17
,p_attribute18 => p_attribute18
,p_attribute19 => p_attribute19
,p_attribute20 => p_attribute20
,p_attribute21 => p_attribute21
,p_attribute22 => p_attribute22
,p_attribute23 => p_attribute23
,p_attribute24 => p_attribute24
,p_attribute25 => p_attribute25
,p_attribute26 => p_attribute26
,p_attribute27 => p_attribute27
,p_attribute28 => p_attribute28
,p_attribute29 => p_attribute29
,p_attribute30 => p_attribute30
,p_attribute_category => p_attribute_category
,p_segment1 => l_segment1
,p_segment2 => l_segment2
,p_segment3 => l_segment3
,p_segment4 => l_segment4
,p_segment5 => l_segment5
,p_segment6 => l_segment6
,p_segment7 => l_segment7
,p_segment8 => l_segment8
,p_segment9 => l_segment9
,p_segment10 => l_segment10
,p_segment11 => l_segment11
,p_segment12 => l_segment12
,p_segment13 => l_segment13
,p_segment14 => l_segment14
,p_segment15 => l_segment15
,p_segment16 => l_segment16
,p_segment17 => l_segment17
,p_segment18 => l_segment18
,p_segment19 => l_segment19
,p_segment20 => l_segment20
,p_segment21 => l_segment21
,p_segment22 => l_segment22
,p_segment23 => l_segment23
,p_segment24 => l_segment24
,p_segment25 => l_segment25
,p_segment26 => l_segment26
,p_segment27 => l_segment27
,p_segment28 => l_segment28
,p_segment29 => l_segment29
,p_segment30 => l_segment30
,p_concat_segments => p_concat_segments
,p_request_id => p_request_id
,p_program_application_id => p_program_application_id
,p_program_id => p_program_id
,p_program_update_date => p_program_update_date
,p_object_version_number => p_object_version_number
,p_effective_date => trunc(p_effective_date)
,p_datetrack_mode => p_datetrack_mode
,p_language_code => l_language_code
);
(p_module_name => 'UPDATE_POSITION'
,p_hook_type => 'BP'
);
,p_update_source_cd => p_update_source_cd
,p_working_hours => p_working_hours
,p_works_council_approval_flag => p_works_council_approval_flag
,p_work_period_type_cd => p_work_period_type_cd
,p_work_term_end_day_cd => p_work_term_end_day_cd
,p_work_term_end_month_cd => p_work_term_end_month_cd
,p_proposed_fte_for_layoff => p_proposed_fte_for_layoff
,p_proposed_date_for_layoff => p_proposed_date_for_layoff
,p_pay_basis_id => p_pay_basis_id
,p_supervisor_id => p_supervisor_id
,p_copied_to_old_table_flag => 'N'
,p_information1 => p_information1
,p_information2 => p_information2
,p_information3 => p_information3
,p_information4 => p_information4
,p_information5 => p_information5
,p_information6 => p_information6
,p_information7 => p_information7
,p_information8 => p_information8
,p_information9 => p_information9
,p_information10 => p_information10
,p_information11 => p_information11
,p_information12 => p_information12
,p_information13 => p_information13
,p_information14 => p_information14
,p_information15 => p_information15
,p_information16 => p_information16
,p_information17 => p_information17
,p_information18 => p_information18
,p_information19 => p_information19
,p_information20 => p_information20
,p_information21 => p_information21
,p_information22 => p_information22
,p_information23 => p_information23
,p_information24 => p_information24
,p_information25 => p_information25
,p_information26 => p_information26
,p_information27 => p_information27
,p_information28 => p_information28
,p_information29 => p_information29
,p_information30 => p_information30
,p_information_category => p_information_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,p_attribute16 => p_attribute16
,p_attribute17 => p_attribute17
,p_attribute18 => p_attribute18
,p_attribute19 => p_attribute19
,p_attribute20 => p_attribute20
,p_attribute21 => p_attribute21
,p_attribute22 => p_attribute22
,p_attribute23 => p_attribute23
,p_attribute24 => p_attribute24
,p_attribute25 => p_attribute25
,p_attribute26 => p_attribute26
,p_attribute27 => p_attribute27
,p_attribute28 => p_attribute28
,p_attribute29 => p_attribute29
,p_attribute30 => p_attribute30
,p_attribute_category => p_attribute_category
,p_request_id => p_request_id
,p_program_application_id => p_program_application_id
,p_program_id => p_program_id
,p_program_update_date => p_program_update_date
,p_object_version_number => l_object_version_number
,p_effective_date => trunc(p_effective_date)
,p_datetrack_mode => p_datetrack_mode
,p_validate => p_validate
);
hr_position_bk2.update_position_a
(
p_position_id => p_position_id
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_availability_status_id => p_availability_status_id
-- ,p_business_group_id => p_business_group_id
,p_entry_step_id => p_entry_step_id
,p_entry_grade_rule_id => p_entry_grade_rule_id
-- ,p_job_id => p_job_id
,p_location_id => p_location_id
-- ,p_organization_id => p_organization_id
,p_pay_freq_payroll_id => p_pay_freq_payroll_id
,p_position_definition_id => l_position_definition_id
,p_position_transaction_id => p_position_transaction_id
,p_prior_position_id => p_prior_position_id
,p_relief_position_id => p_relief_position_id
,p_entry_grade_id => p_entry_grade_id
,p_successor_position_id => p_successor_position_id
,p_supervisor_position_id => p_supervisor_position_id
,p_amendment_date => p_amendment_date
,p_amendment_recommendation => p_amendment_recommendation
,p_amendment_ref_number => p_amendment_ref_number
,p_bargaining_unit_cd => p_bargaining_unit_cd
,p_comments => p_comments
,p_current_job_prop_end_date => p_current_job_prop_end_date
,p_current_org_prop_end_date => p_current_org_prop_end_date
,p_avail_status_prop_end_date => p_avail_status_prop_end_date
,p_date_effective => l_date_effective
,p_date_end => l_date_end
,p_earliest_hire_date => p_earliest_hire_date
,p_fill_by_date => p_fill_by_date
,p_frequency => p_frequency
,p_fte => p_fte
,p_max_persons => p_max_persons
,p_name => p_name
,p_overlap_period => p_overlap_period
,p_overlap_unit_cd => p_overlap_unit_cd
,p_pay_term_end_day_cd => p_pay_term_end_day_cd
,p_pay_term_end_month_cd => p_pay_term_end_month_cd
,p_permanent_temporary_flag => p_permanent_temporary_flag
,p_permit_recruitment_flag => p_permit_recruitment_flag
,p_position_type => p_position_type
,p_posting_description => p_posting_description
,p_probation_period => p_probation_period
,p_probation_period_unit_cd => p_probation_period_unit_cd
,p_replacement_required_flag => p_replacement_required_flag
,p_review_flag => p_review_flag
,p_seasonal_flag => p_seasonal_flag
,p_security_requirements => p_security_requirements
,p_status => p_status
,p_term_start_day_cd => p_term_start_day_cd
,p_term_start_month_cd => p_term_start_month_cd
,p_time_normal_finish => p_time_normal_finish
,p_time_normal_start => p_time_normal_start
,p_update_source_cd => p_update_source_cd
,p_working_hours => p_working_hours
,p_works_council_approval_flag => p_works_council_approval_flag
,p_work_period_type_cd => p_work_period_type_cd
,p_work_term_end_day_cd => p_work_term_end_day_cd
,p_work_term_end_month_cd => p_work_term_end_month_cd
,p_proposed_fte_for_layoff => p_proposed_fte_for_layoff
,p_proposed_date_for_layoff => p_proposed_date_for_layoff
,p_pay_basis_id => p_pay_basis_id
,p_supervisor_id => p_supervisor_id
--,p_copied_to_old_table_flag => p_copied_to_old_table_flag
,p_information1 => p_information1
,p_information2 => p_information2
,p_information3 => p_information3
,p_information4 => p_information4
,p_information5 => p_information5
,p_information6 => p_information6
,p_information7 => p_information7
,p_information8 => p_information8
,p_information9 => p_information9
,p_information10 => p_information10
,p_information11 => p_information11
,p_information12 => p_information12
,p_information13 => p_information13
,p_information14 => p_information14
,p_information15 => p_information15
,p_information16 => p_information16
,p_information17 => p_information17
,p_information18 => p_information18
,p_information19 => p_information19
,p_information20 => p_information20
,p_information21 => p_information21
,p_information22 => p_information22
,p_information23 => p_information23
,p_information24 => p_information24
,p_information25 => p_information25
,p_information26 => p_information26
,p_information27 => p_information27
,p_information28 => p_information28
,p_information29 => p_information29
,p_information30 => p_information30
,p_information_category => p_information_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,p_attribute16 => p_attribute16
,p_attribute17 => p_attribute17
,p_attribute18 => p_attribute18
,p_attribute19 => p_attribute19
,p_attribute20 => p_attribute20
,p_attribute21 => p_attribute21
,p_attribute22 => p_attribute22
,p_attribute23 => p_attribute23
,p_attribute24 => p_attribute24
,p_attribute25 => p_attribute25
,p_attribute26 => p_attribute26
,p_attribute27 => p_attribute27
,p_attribute28 => p_attribute28
,p_attribute29 => p_attribute29
,p_attribute30 => p_attribute30
,p_attribute_category => p_attribute_category
,p_segment1 => l_segment1
,p_segment2 => l_segment2
,p_segment3 => l_segment3
,p_segment4 => l_segment4
,p_segment5 => l_segment5
,p_segment6 => l_segment6
,p_segment7 => l_segment7
,p_segment8 => l_segment8
,p_segment9 => l_segment9
,p_segment10 => l_segment10
,p_segment11 => l_segment11
,p_segment12 => l_segment12
,p_segment13 => l_segment13
,p_segment14 => l_segment14
,p_segment15 => l_segment15
,p_segment16 => l_segment16
,p_segment17 => l_segment17
,p_segment18 => l_segment18
,p_segment19 => l_segment19
,p_segment20 => l_segment20
,p_segment21 => l_segment21
,p_segment22 => l_segment22
,p_segment23 => l_segment23
,p_segment24 => l_segment24
,p_segment25 => l_segment25
,p_segment26 => l_segment26
,p_segment27 => l_segment27
,p_segment28 => l_segment28
,p_segment29 => l_segment29
,p_segment30 => l_segment30
,p_concat_segments => p_concat_segments
,p_request_id => p_request_id
,p_program_application_id => p_program_application_id
,p_program_id => p_program_id
,p_program_update_date => p_program_update_date
,p_object_version_number => l_object_version_number
,p_effective_date => trunc(p_effective_date)
,p_datetrack_mode => p_datetrack_mode
,p_language_code => l_language_code
);
(p_module_name => 'UPDATE_POSITION'
,p_hook_type => 'AP'
);
ROLLBACK TO update_position;
ROLLBACK TO update_position;
end update_position;
procedure delete_position
(p_validate in boolean default false
,p_position_id in number
,p_effective_start_date out nocopy date
,p_effective_end_date out nocopy date
,p_object_version_number in out nocopy number
,p_effective_date in date
,p_datetrack_mode in varchar2
,p_security_profile_id in number default hr_security.get_security_profile
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) ;
select view_all_positions_flag
from per_security_profiles
where security_profile_id = p_security_profile_id;
l_proc := g_package||'delete_position';
savepoint delete_position;
hr_position_bk3.delete_position_b
(
p_position_id => p_position_id
,p_object_version_number => p_object_version_number
,p_effective_date => trunc(p_effective_date)
,p_datetrack_mode => p_datetrack_mode
);
(p_module_name => 'DELETE_POSITION'
,p_hook_type => 'BP'
);
hr_security.delete_pos_from_list(p_position_Id);
select position_definition_id
from hr_all_positions_f
where position_id = p_position_id;
l_pos_def_deleted boolean;
l_pos_def_deleted := delete_unused_per_pos_def(l_position_definition_id);
hr_position_bk3.delete_position_a
(
p_position_id => p_position_id
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_object_version_number => l_object_version_number
,p_effective_date => trunc(p_effective_date)
,p_datetrack_mode => p_datetrack_mode
);
(p_module_name => 'DELETE_POSITION'
,p_hook_type => 'AP'
);
ROLLBACK TO delete_position;
ROLLBACK TO delete_position;
end delete_position;
select psf.effective_start_date, psf.position_definition_id,
psf.object_version_number, pd.id_flex_num
from hr_all_positions_f psf, per_position_definitions pd
where position_id = p_position_id
and psf.position_definition_id = pd.position_definition_id
and effective_end_date = hr_api.g_eot;
hr_position_api.update_position
(p_validate => false
,p_position_id => p_position_id
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_position_definition_id => l_position_definition_id
,p_valid_grades_changed_warning => l_valid_grades_changed_warning
,p_name => l_name
,p_object_version_number => l_object_version_number
,p_effective_date => l_effective_date
,p_datetrack_mode => 'CORRECTION'
);
select psf.position_id
from hr_all_positions_f psf
where psf.effective_end_date = hr_api.g_eot;
select psf.position_id
from hr_all_positions_f psf
where psf.business_group_id = p_business_group_id
and psf.effective_end_date = hr_api.g_eot;
select psf.position_id
from hr_all_positions_f psf
where psf.organization_id = p_organization_id
and psf.effective_end_date = hr_api.g_eot;