[Home] [Help]
4162: l_employee_api_update_criteria := 'Y';
4163: End if;
4164:
4165: --
4166: -- calling hr_assignment_api.update_emp_asg_criteria
4167: --
4168: If l_employee_api_update_criteria = 'Y' or l_update_gre = 'Y' then
4169: -- Function to determine update_mode
4170: l_update_mode := return_update_mode
4190:
4191: hr_utility.set_location(l_proc,92);
4192: begin
4193: savepoint update_emp_asg;
4194: hr_assignment_api.update_us_emp_asg
4195: (p_assignment_id => p_pa_request_rec.employee_assignment_id,
4196: p_object_version_number => l_asg_object_version_number,
4197: p_effective_date => g_effective_date,
4198: p_datetrack_update_mode => l_update_mode,
4216: If l_employee_api_update_criteria = 'Y' then
4217: hr_utility.set_location('Before update_emp_asg_criteria ',94);
4218: hr_utility.set_location('checking how correction updates the record',500);
4219: hr_utility.set_location('the to position id passed',500);
4220: hr_assignment_api.update_emp_asg_criteria
4221: (p_effective_date => g_effective_date
4222: ,p_datetrack_update_mode => l_update_mode
4223: ,p_assignment_id => l_assignment_id
4224: ,p_object_version_number => l_asg_object_version_number
4252: );
4253: Begin
4254: savepoint activate;
4255:
4256: hr_assignment_api.activate_emp_asg
4257: (p_effective_date => g_effective_date
4258: ,p_datetrack_update_mode => l_update_mode
4259: ,p_assignment_id => l_assignment_id
4260: ,p_assignment_status_type_id => l_asg_status_type_id
4275: p_table_name => 'PER_ASSIGNMENTS_F'
4276: );
4277: Begin
4278: savepoint suspend;
4279: hr_assignment_api.suspend_emp_asg
4280: (p_effective_date => g_effective_date
4281: ,p_datetrack_update_mode => l_update_mode
4282: ,p_assignment_id => l_assignment_id
4283: ,p_object_version_number => l_asg_object_version_number
5205: hr_utility.trace('l_sb_ovn:'||l_SB_ovn);
5206: hr_utility.trace('l_payroll_id:'||l_payroll_id);
5207: hr_utility.trace('l_sal_basis_id:'||l_sal_basis_id);
5208:
5209: hr_assignment_api.update_emp_asg_criteria
5210: (p_effective_date => l_effective_date
5211: ,p_datetrack_update_mode => l_dt_mode
5212: ,p_assignment_id => p_pa_request_rec.employee_assignment_id
5213: ,p_object_version_number => l_SB_ovn