[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
,p_datetrack_update_mode IN VARCHAR2
,p_assignment_id IN NUMBER
,p_object_version_number IN OUT NOCOPY NUMBER
,p_grade_id IN NUMBER DEFAULT HR_API.G_NUMBER
,p_position_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_people_group_name OUT NOCOPY VARCHAR2
,p_effective_start_date OUT NOCOPY DATE
,p_effective_end_date OUT NOCOPY DATE
,p_people_group_id OUT NOCOPY NUMBER
,p_org_now_no_manager_warning OUT NOCOPY BOOLEAN
,p_other_manager_warning OUT NOCOPY BOOLEAN
,p_spp_delete_warning OUT NOCOPY BOOLEAN
,p_entries_changed_warning OUT NOCOPY VARCHAR2
,p_tax_district_changed_warning OUT NOCOPY BOOLEAN) IS
--
-- Declare Local Variables
--
l_proc VARCHAR2(72) := g_package||'upd_cwk_asg ';
l_spp_delete_warning BOOLEAN;
hr_assignment_api.update_cwk_asg_criteria
(p_validate => p_validate
,p_effective_date => p_effective_date
,p_datetrack_update_mode => p_datetrack_update_mode
,p_assignment_id => p_assignment_Id
,p_object_version_number => l_ovn
,p_grade_id => p_grade_id
,p_position_id => p_position_id
,p_job_id => p_job_id
,p_location_id => p_location_id
,p_organization_id => p_organization_id
,p_people_group_name => l_people_group_name
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_people_group_id => l_people_group_Id
,p_org_now_no_manager_warning => l_org_now_no_manager_warning
,p_other_manager_warning => l_other_manager_warning
,p_spp_delete_warning => l_spp_delete_warning
,p_entries_changed_warning => l_entries_changed_warning
,p_tax_district_changed_warning => l_tax_district_changed_warning);
p_spp_delete_warning := l_spp_delete_warning;
p_spp_delete_warning := FALSE;
,p_spp_delete_warning out nocopy boolean
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'move_emp_asg';
l_spp_delete_warning boolean;
l_scl_updated_flag boolean default FALSE;
select asg1.effective_start_date
, asg1.object_version_number
from per_assignments_f asg1
where asg1.assignment_id = p_assignment_id
and asg1.effective_start_date =
(select max(asg2.effective_start_date)
from per_assignments_f asg2
where asg1.assignment_id = asg2.assignment_id
and asg2.effective_start_date < p_effective_date);
hr_assignment_api.update_emp_asg_criteria
(p_validate => FALSE
,p_effective_date => p_effective_date
,p_datetrack_update_mode => 'UPDATE'
,p_assignment_id => p_assignment_id
,p_object_version_number => l_object_version_number
,p_position_id => p_position_id
,p_job_id => p_job_id
,p_location_id => p_location_id
,p_organization_id => p_organization_id
,p_grade_id => p_grade_id
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_special_ceiling_step_id => l_special_ceiling_step_id
,p_people_group_id => l_people_group_id
,p_group_name => l_group_name
,p_org_now_no_manager_warning => l_org_now_no_manager_warning
,p_other_manager_warning => l_other_manager_warning
,p_spp_delete_warning => l_spp_delete_warning
,p_entries_changed_warning => l_entries_changed_warning
,p_tax_district_changed_warning => l_tax_district_changed_warning
);
l_scl_updated_flag := TRUE;
l_scl_updated_flag := FALSE;
l_scl_updated_flag := TRUE;
l_scl_updated_flag := FALSE;
if ( l_scl_updated_flag
or ((nvl(p_frequency, hr_api.g_varchar2) <> hr_api.g_varchar2)
and nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>
nvl(p_frequency, hr_api.g_varchar2) )
or ((nvl(p_normal_hours, hr_api.g_number) <> hr_api.g_number)
and nvl(per_asg_shd.g_old_rec.normal_hours, hr_api.g_number) <>
nvl(p_normal_hours, hr_api.g_number) )
or ((nvl(p_time_normal_finish, hr_api.g_varchar2) <> hr_api.g_varchar2)
and nvl(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
nvl(p_time_normal_finish,hr_api.g_varchar2) )
or ((nvl(p_time_normal_start, hr_api.g_varchar2) <> hr_api.g_varchar2)
and nvl(per_asg_shd.g_old_rec.time_normal_start, hr_api.g_varchar2) <>
nvl(p_time_normal_start, hr_api.g_varchar2) )
) then
--
hr_utility.set_location( l_proc, 85 );
hr_assignment_api.update_emp_asg
(p_validate => FALSE
,p_effective_date => p_effective_date
,p_datetrack_update_mode => 'CORRECTION'
,p_assignment_id => p_assignment_id
,p_object_version_number => l_object_version_number
,p_frequency => p_frequency
,p_normal_hours => p_normal_hours
,p_time_normal_finish => p_time_normal_finish
,p_time_normal_start => p_time_normal_start
,p_segment1 => p_segment1
,p_segment2 => p_segment2
,p_segment3 => p_segment3
,p_segment4 => p_segment4
,p_segment5 => p_segment5
,p_segment6 => p_segment6
,p_segment7 => p_segment7
,p_segment8 => p_segment8
,p_segment9 => p_segment9
,p_segment10 => p_segment10
,p_segment11 => p_segment11
,p_segment12 => p_segment12
,p_segment13 => p_segment13
,p_segment14 => p_segment14
,p_segment15 => p_segment15
,p_segment16 => p_segment16
,p_segment17 => p_segment17
,p_segment18 => p_segment18
,p_segment19 => p_segment19
,p_segment20 => p_segment20
,p_segment21 => p_segment21
,p_segment22 => p_segment22
,p_segment23 => p_segment23
,p_segment24 => p_segment24
,p_segment25 => p_segment25
,p_segment26 => p_segment26
,p_segment27 => p_segment27
,p_segment28 => p_segment28
,p_segment29 => p_segment29
,p_segment30 => p_segment30
,p_soft_coding_keyflex_id => l_soft_coding_keyflex_id
,p_comment_id => l_comment_id
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_concatenated_segments => l_concatenated_segments
,p_no_managers_warning => l_no_managers_warning
,p_other_manager_warning => l_other_manager_warning );
p_spp_delete_warning := l_spp_delete_warning;
p_spp_delete_warning := l_spp_delete_warning;
p_spp_delete_warning := false;
p_update_source_cd varchar2(80);
select
position_definition_id
,name
,business_group_id
,successor_position_id
,relief_position_id
,comments
,probation_period
,probation_period_unit_cd
,replacement_required_flag
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
--,effective_date
,availability_status_id
,entry_step_id
,entry_grade_rule_id
,pay_freq_payroll_id
,position_transaction_id
,prior_position_id
,entry_grade_id
,p_supervisor_position_id
,amendment_date
,amendment_recommendation
,amendment_ref_number
,bargaining_unit_cd
,current_job_prop_end_date
,current_org_prop_end_date
,avail_status_prop_end_date
,earliest_hire_date
,fill_by_date
,fte
,max_persons
,overlap_period
,overlap_unit_cd
,pay_term_end_day_cd
,pay_term_end_month_cd
,permanent_temporary_flag
,permit_recruitment_flag
,position_type
,posting_description
,review_flag
,seasonal_flag
,security_requirements
,status
,term_start_day_cd
,term_start_month_cd
,update_source_cd
,works_council_approval_flag
,work_period_type_cd
,work_term_end_day_cd
,work_term_end_month_cd
,proposed_fte_for_layoff
,proposed_date_for_layoff
,pay_basis_id
,supervisor_id
--,copied_to_old_table_flag
from hr_positions_f
where position_id = p_position_id
and p_date_effective
between effective_start_date
and effective_end_date;
select position_id
,job_id
,object_version_number
,date_effective
,date_end
,organization_id
from hr_positions_f
where position_definition_id = l_position_definition_id
and business_group_id = l_business_group_id
and p_date_effective
between effective_start_date
and effective_end_date;
select pjr.analysis_criteria_id
,business_group_id
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,comments
,essential
,job_id
,position_id
,id_flex_num
,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_job_requirements pjr, per_analysis_criteria pac
where pjr.position_id = p_position_id
and pjr.analysis_criteria_id = pac.analysis_criteria_id
and not exists
(select 'x'
from per_job_requirements jbr2
where jbr2.analysis_criteria_id = pjr.analysis_criteria_id
and jbr2.position_id = l_new_position_id
and jbr2.business_group_id = l_business_group_id);
select mmvgr.target_grade_id
,mmvgr.position_id
,mmvgr.attribute_category
,mmvgr.attribute1
,mmvgr.attribute2
,mmvgr.attribute3
,mmvgr.attribute4
,mmvgr.attribute5
,mmvgr.attribute6
,mmvgr.attribute7
,mmvgr.attribute8
,mmvgr.attribute9
,mmvgr.attribute10
,mmvgr.attribute11
,mmvgr.attribute12
,mmvgr.attribute13
,mmvgr.attribute14
,mmvgr.attribute15
,mmvgr.attribute16
,mmvgr.attribute17
,mmvgr.attribute18
,mmvgr.attribute19
,mmvgr.attribute20
from per_mm_valid_grades mmvgr
where mmvgr.mass_move_id = p_mass_move_id
and mmvgr.position_id = p_position_id
and not exists
(select vgr.grade_id
from per_valid_grades vgr
where vgr.position_id = l_new_position_id
and vgr.grade_id = mmvgr.target_grade_id
and vgr.business_group_id = l_business_group_id);
select null
from per_job_evaluations jbe
where jbe.position_id = p_position_id;
select null
from per_vacancies vac
where vac.position_id = p_position_id
and p_date_effective between vac.date_from
and nvl(vac.date_to, hr_api.g_eot);
select pbg.position_structure
from per_business_groups pbg
where pbg.business_group_id = l_business_group_id;
select shared_type_id
from per_shared_types
where lookup_type = 'POSITION_AVAILABILITY_STATUS'
and system_type_cd = p_system_type_cd
and business_group_id IS NULL;
select pst.system_type_cd
from hr_positions_f hpf,
per_shared_types pst
where lookup_type = 'POSITION_AVAILABILITY_STATUS'
and pst.shared_type_id = hpf.availability_status_id
and hpf.position_id = p_position_id
and p_date_effective between hpf.effective_start_date
and hpf.effective_end_date;
select 'CORRECTION'
from hr_all_positions_f
where position_id = p_position_id
and p_effective_date = effective_start_date
and effective_end_date = hr_general.end_of_time;
,p_update_source_cd
,p_works_council_approval_flag
,p_work_period_type_cd
,p_work_term_end_day_cd
,p_work_term_end_month_cd
,p_proposed_fte_for_layoff
,p_proposed_date_for_layoff
,p_pay_basis_id
,p_supervisor_id;
,p_update_source_cd => p_update_source_cd
,p_working_hours => p_normal_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_information_category => l_information_category
,p_information1 => l_information1
,p_information2 => l_information2
,p_information3 => l_information3
,p_information4 => l_information4
,p_information5 => l_information5
,p_information6 => l_information6
,p_information7 => l_information7
,p_information8 => l_information8
,p_information9 => l_information9
,p_information10 => l_information10
,p_information11 => l_information11
,p_information12 => l_information12
,p_information13 => l_information13
,p_information14 => l_information14
,p_information15 => l_information15
,p_information16 => l_information16
,p_information17 => l_information17
,p_information18 => l_information18
,p_information19 => l_information19
,p_information20 => l_information20
,p_information21 => l_information21
,p_information22 => l_information22
,p_information23 => l_information23
,p_information24 => l_information24
,p_information25 => l_information25
,p_information26 => l_information26
,p_information27 => l_information27
,p_information28 => l_information28
,p_information29 => l_information29
,p_information30 => l_information30
*/
,p_attribute_category => l_attribute_category
,p_attribute1 => l_attribute1
,p_attribute2 => l_attribute2
,p_attribute3 => l_attribute3
,p_attribute4 => l_attribute4
,p_attribute5 => l_attribute5
,p_attribute6 => l_attribute6
,p_attribute7 => l_attribute7
,p_attribute8 => l_attribute8
,p_attribute9 => l_attribute9
,p_attribute10 => l_attribute10
,p_attribute11 => l_attribute11
,p_attribute12 => l_attribute12
,p_attribute13 => l_attribute13
,p_attribute14 => l_attribute14
,p_attribute15 => l_attribute15
,p_attribute16 => l_attribute16
,p_attribute17 => l_attribute17
,p_attribute18 => l_attribute18
,p_attribute19 => l_attribute19
,p_attribute20 => l_attribute20
/*
,p_attribute21 => l_attribute21
,p_attribute22 => l_attribute22
,p_attribute23 => l_attribute23
,p_attribute24 => l_attribute24
,p_attribute25 => l_attribute25
,p_attribute26 => l_attribute26
,p_attribute27 => l_attribute27
,p_attribute28 => l_attribute28
,p_attribute29 => l_attribute29
,p_attribute30 => l_attribute30
*/
,p_segment1 => p_segment1
,p_segment2 => p_segment2
,p_segment3 => p_segment3
,p_segment4 => p_segment4
,p_segment5 => p_segment5
,p_segment6 => p_segment6
,p_segment7 => p_segment7
,p_segment8 => p_segment8
,p_segment9 => p_segment9
,p_segment10 => p_segment10
,p_segment11 => p_segment11
,p_segment12 => p_segment12
,p_segment13 => p_segment13
,p_segment14 => p_segment14
,p_segment15 => p_segment15
,p_segment16 => p_segment16
,p_segment17 => p_segment17
,p_segment18 => p_segment18
,p_segment19 => p_segment19
,p_segment20 => p_segment20
,p_segment21 => p_segment21
,p_segment22 => p_segment22
,p_segment23 => p_segment23
,p_segment24 => p_segment24
,p_segment25 => p_segment25
,p_segment26 => p_segment26
,p_segment27 => p_segment27
,p_segment28 => p_segment28
,p_segment29 => p_segment29
,p_segment30 => p_segment30
,p_concat_segments => p_concat_segments
);
l_system_type_cd := 'DELETED';
l_pos_dt_mode := 'UPDATE';
hr_position_api.update_position
(p_position_id => p_position_id
,p_object_version_number => l_object_version_number
,p_effective_start_date =>l_effective_start_date
,p_effective_end_date =>l_effective_end_date
--,p_date_end => l_date_end
,p_position_definition_id => l_old_position_def
,p_name => l_old_name
,p_valid_grades_changed_warning => l_valid_grades_changed_warning
,p_availability_status_id => p_availability_status_id
,p_effective_date => p_date_effective --p_effective_date
,p_datetrack_mode => l_pos_dt_mode
);
hr_position_api.update_position
(p_position_id => p_position_id
,p_object_version_number => l_object_version_number
,p_date_end => l_date_end
,p_position_definition_id => l_old_position_def
,p_name => l_old_name
,p_valid_grades_changed_warning => l_valid_grades_changed_warning
);
l_spp_delete_warning BOOLEAN;
select null
from per_assignments_f asg,
per_mass_moves mm,
per_mm_assignments mmasg
where mmasg.assignment_id = l_mm_assignment_id
and asg.assignment_id = mmasg.assignment_id
and mmasg.mass_move_id = p_mass_move_id
and mmasg.mass_move_id = mm.mass_move_id
and mmasg.position_id = p_old_position_id
and asg.effective_start_date > p_effective_date;
select mm_asg.assignment_id,
mm_asg.default_from,
mm_asg.grade_id,
mm_asg.tax_unit_id,
asg.location_id,
asg.frequency,
asg.normal_hours,
asg.time_normal_start,
asg.time_normal_finish,
asg.assignment_type,
asg.object_version_number,
asg.vacancy_id,
per.full_name,
org.name orgname,
neworg.name neworgname
from per_mm_assignments mm_asg,
per_assignments_f asg,
per_people_f per,
per_organization_units org,
per_mass_moves mm,
per_organization_units neworg
where mm_asg.position_id = p_old_position_id
and mm_asg.assignment_id = asg.assignment_id
and mm_asg.mass_move_id = p_mass_move_id
and mm_asg.mass_move_id = mm.mass_move_id
and mm.new_organization_id = neworg.organization_id
and asg.organization_id = org.organization_id
and p_effective_date between asg.effective_start_date
and asg.effective_end_date
and p_effective_date between per.effective_start_date
and per.effective_end_date
and asg.person_id = per.person_id
and assignment_moved = 'N'
and select_assignment = 'Y';
hr_assignment_api.update_apl_asg
(p_validate => FALSE
,p_effective_date => p_effective_date
,p_datetrack_update_mode => 'UPDATE'
,p_assignment_id => mmasgrec.assignment_id
,p_object_version_number => mmasgrec.object_version_number
,p_grade_id => mmasgrec.grade_id
,p_position_id => p_new_position_id
,p_job_id => p_new_job_id
,p_organization_id => p_new_organization_id
,p_location_id => l_location_id
,p_frequency => l_frequency
,p_normal_hours => l_normal_hours
,p_time_normal_finish => l_time_normal_finish
,p_time_normal_start => l_time_normal_start
,p_comment_id => l_out_comment_id
,p_people_group_id => l_out_people_group_id
,p_group_name => l_out_group_name
,p_effective_start_date => l_out_effective_start_date
,p_cagr_concatenated_segments => l_cagr_concatenated_segments
,p_cagr_grade_def_id => l_cagr_grade_def_id
--
-- Bug 944911 Added out param into a dummy var
--
,p_concatenated_segments => l_out_concatenated_segments
,p_soft_coding_keyflex_id => l_out_soft_coding_keyflx_id
,p_effective_end_date => l_out_effective_end_date);
,p_datetrack_update_mode => 'UPDATE'
,p_assignment_id => mmasgrec.assignment_id
,p_object_version_number => mmasgrec.object_version_number
,p_grade_id => mmasgrec.grade_id
,p_position_id => p_new_position_id
,p_job_id => p_new_job_id
,p_location_id => l_location_id
,p_organization_id => p_new_organization_id
,p_people_group_name => l_people_group_name
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_people_group_id => l_people_group_id
,p_org_now_no_manager_warning => l_org_now_no_manager_warning
,p_other_manager_warning => l_other_manager_warning
,p_spp_delete_warning => l_spp_delete_warning
,p_entries_changed_warning => l_entries_changed_warning
,p_tax_district_changed_warning => l_tax_district_changed_warning);
,p_spp_delete_warning => l_spp_delete_warning); --out
if l_spp_delete_warning then
--
hr_utility.set_message(800,'HR_289826_SPP_DELETE_WARN_API');
update per_mm_assignments
set assignment_moved = 'Y'
where assignment_id = mmasgrec.assignment_id
and mass_move_id = p_mass_move_id;
l_apl_asg_updated_warning boolean;
select hr_api_batch_message_lines_s.nextval
from dual;
select null
from per_mass_moves
where mass_move_id = p_mass_move_id
for update nowait;
select null
from per_mm_positions
where mass_move_id = p_mass_move_id
for update nowait;
select null
from per_mm_assignments
where mass_move_id = p_mass_move_id
for update nowait;
select null
from per_mm_valid_grades
where mass_move_id = p_mass_move_id
for update nowait;
select null
from per_mm_job_requirements
where mass_move_id = p_mass_move_id
for update nowait;
select new_organization_id,
effective_date
from per_mass_moves
where mass_move_id = p_mass_move_id;
select business_group_id,
default_start_time,
default_end_time,
fnd_number.canonical_to_number(working_hours),
frequency,
location_id
from per_organization_units
where organization_id = l_new_organization_id;
select legislation_code,
default_start_time,
default_end_time,
fnd_number.canonical_to_number(working_hours),
frequency,
location_id
from per_business_groups
where business_group_id = l_business_group_id;
select pos.time_normal_start,
pos.time_normal_finish,
fnd_number.canonical_to_number(pos.working_hours),
pos.frequency,
pos.location_id
from hr_positions_f pos
where position_id = l_position_id
and l_effective_date
between effective_start_date
and effective_end_date;
select pos.time_normal_start,
pos.time_normal_finish,
fnd_number.canonical_to_number(pos.working_hours),
pos.frequency,
pos.location_id
from hr_positions_f pos
where position_id = l_new_position_id
and l_effective_date
between effective_start_date
and effective_end_date;
select mmvgr.position_id,
mmvgr.target_grade_id,
mmvgr.attribute_category,
mmvgr.attribute1,
mmvgr.attribute2,
mmvgr.attribute3,
mmvgr.attribute4,
mmvgr.attribute5,
mmvgr.attribute6,
mmvgr.attribute7,
mmvgr.attribute8,
mmvgr.attribute9,
mmvgr.attribute10,
mmvgr.attribute11,
mmvgr.attribute12,
mmvgr.attribute13,
mmvgr.attribute14,
mmvgr.attribute15,
mmvgr.attribute16,
mmvgr.attribute17,
mmvgr.attribute18,
mmvgr.attribute19,
mmvgr.attribute20
from per_mm_valid_grades mmvgr
where mmvgr.mass_move_id = p_mass_move_id;
select pos.name,
mmpos.position_id,
mmpos.object_version_number,
mmpos.deactivate_old_position,
mmpos.new_position_id,
mmpos.target_job_id,
mmpos.position_moved,
mmpos.default_from,
mmpos.segment1,
mmpos.segment2,
mmpos.segment3,
mmpos.segment4,
mmpos.segment5,
mmpos.segment6,
mmpos.segment7,
mmpos.segment8,
mmpos.segment9,
mmpos.segment10,
mmpos.segment11,
mmpos.segment12,
mmpos.segment13,
mmpos.segment14,
mmpos.segment15,
mmpos.segment16,
mmpos.segment17,
mmpos.segment18,
mmpos.segment19,
mmpos.segment20,
mmpos.segment21,
mmpos.segment22,
mmpos.segment23,
mmpos.segment24,
mmpos.segment25,
mmpos.segment26,
mmpos.segment27,
mmpos.segment28,
mmpos.segment29,
mmpos.segment30
from per_mm_positions mmpos,
hr_positions_f pos
where mmpos.mass_move_id = p_mass_move_id
and mmpos.position_id = pos.position_id
and mmpos.select_position = 'Y'
and l_effective_date BETWEEN pos.effective_start_date
AND pos.effective_end_date;
select 'Y'
from hr_api_batch_message_lines
where batch_run_number = l_batch_run_number
and status = 'F';
select 'Y'
from hr_api_batch_message_lines
where batch_run_number = l_batch_run_number
and status = 'S';
update per_mm_positions
set position_moved = 'Y',
target_job_id = l_new_job_id,
new_position_id = l_new_position_id
where position_id = mmposrec.position_id
and mass_move_id = p_mass_move_id;
update per_mass_moves
set batch_run_number = l_batch_run_number,
status = 'ER'
where mass_move_id = p_mass_move_id;
update per_mass_moves
set batch_run_number = l_batch_run_number,
status = 'WA'
where mass_move_id = p_mass_move_id;
update per_mass_moves
set batch_run_number = l_batch_run_number,
status = 'CO'
where mass_move_id = p_mass_move_id;
update per_mass_moves
set batch_run_number = l_batch_run_number,
status = 'ER'
where mass_move_id = p_mass_move_id;