[Home] [Help]
1370: l_work_at_home:=nvl (p_work_at_home,'N');--FIX FOR BUG 9215178
1371:
1372: hr_utility.set_location(l_proc, 110);
1373: --
1374: hr_assignment_api.update_emp_asg
1375: (p_effective_date => l_creation_date --p_effective_date
1376: ,p_datetrack_update_mode => 'CORRECTION'
1377: ,p_assignment_id => l_assignment_id
1378: ,p_object_version_number => l_asg_object_version_number
1489: --
1490: per_qh_maintain_update.p_qh_organization_id := NULL; --- Added For Bug # 6706502
1491: hr_utility.set_location('Insert Asg After:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);
1492:
1493: hr_assignment_api.update_emp_asg_criteria
1494: (p_effective_date => l_creation_date --p_effective_date
1495: ,p_datetrack_update_mode => 'CORRECTION'
1496: ,p_assignment_id => l_assignment_id
1497: ,p_object_version_number => l_asg_object_version_number
1573: ELSIF p_assignment_type='A' then
1574: --
1575: hr_utility.set_location(l_proc, 150);
1576: --
1577: hr_assignment_api.update_apl_asg
1578: (p_effective_date => l_creation_date --p_effective_date
1579: ,p_datetrack_update_mode => 'CORRECTION'
1580: ,p_assignment_id => l_assignment_id
1581: ,p_object_version_number => l_asg_object_version_number
1734: --
1735: hr_utility.set_location(l_proc, 162);
1736: hr_utility.set_location(to_char(p_projected_assignment_end,'DD-MON-YYYY'), 162);
1737:
1738: hr_assignment_api.update_cwk_asg
1739: (p_effective_date => l_creation_date --p_effective_date
1740: ,p_datetrack_update_mode => 'CORRECTION'
1741: ,p_assignment_id => l_assignment_id
1742: ,p_object_version_number => l_asg_object_version_number
1838: );
1839: --
1840: hr_utility.set_location(l_proc, 163);
1841: --
1842: hr_assignment_api.update_cwk_asg_criteria
1843: (p_effective_date => l_creation_date --p_effective_date
1844: ,p_datetrack_update_mode => 'CORRECTION'
1845: ,p_assignment_id => l_assignment_id
1846: ,p_object_version_number => l_asg_object_version_number
2666: );
2667:
2668: --start changes for bug 6598795
2669:
2670: hr_assignment.update_assgn_context_value (p_business_group_id,
2671: p_person_id,
2672: p_assignment_id,
2673: p_effective_date);
2674:
4624: hr_utility.set_location(l_proc, 110);
4625: --
4626: --
4627: -- Bug 3174130 Start here
4628: -- Description : Swapped the two assignment update procedures ' hr_assignment_api.update_emp_asg'
4629: -- and ' hr_assignment_api.update_emp_asg_criteria' so that consistency can be implemented
4630: -- with insert procedure. This will in turn resolve the updation problem on the assignment table.
4631: --
4632:
4625: --
4626: --
4627: -- Bug 3174130 Start here
4628: -- Description : Swapped the two assignment update procedures ' hr_assignment_api.update_emp_asg'
4629: -- and ' hr_assignment_api.update_emp_asg_criteria' so that consistency can be implemented
4630: -- with insert procedure. This will in turn resolve the updation problem on the assignment table.
4631: --
4632:
4633:
4661: l_add_struct_d(l_add_struct_d.count) := 'PER_ASSIGNMENTS';
4662:
4663: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);
4664: --
4665: hr_assignment_api.update_emp_asg_criteria
4666: (p_effective_date => p_effective_date
4667: ,p_datetrack_update_mode => l_asg_datetrack_update_mode
4668: ,p_assignment_id => l_assignment_id
4669: ,p_object_version_number => l_asg_object_version_number
4728: hr_dflex_utility.remove_ignore_df_validation;
4729: hr_kflex_utility.remove_ignore_kf_validation;
4730:
4731:
4732: hr_assignment_api.update_emp_asg
4733: (p_effective_date => p_effective_date
4734: ,p_datetrack_update_mode => 'CORRECTION'
4735: ,p_assignment_id => l_assignment_id
4736: ,p_object_version_number => l_asg_object_version_number
4870: ELSIF p_assignment_type = 'A' then
4871: --
4872: hr_utility.set_location(l_proc, 150);
4873: --
4874: hr_assignment_api.update_apl_asg
4875: (p_effective_date => p_effective_date
4876: ,p_datetrack_update_mode => l_asg_datetrack_update_mode
4877: ,p_assignment_id => l_assignment_id
4878: ,p_object_version_number => l_asg_object_version_number
5027: --
5028: hr_utility.set_location(l_proc, 160);
5029: --
5030: ELSIF p_assignment_type = 'C' then
5031: hr_assignment_api.update_cwk_asg_criteria
5032: (p_effective_date => p_effective_date
5033: ,p_datetrack_update_mode => l_asg_datetrack_update_mode
5034: ,p_assignment_id => l_assignment_id
5035: ,p_object_version_number => l_asg_object_version_number
5082: );
5083: --
5084: hr_utility.set_location(l_proc, 163);
5085: --
5086: hr_assignment_api.update_cwk_asg
5087: (p_effective_date => p_effective_date
5088: ,p_datetrack_update_mode => 'CORRECTION'
5089: ,p_assignment_id => l_assignment_id
5090: ,p_object_version_number => l_asg_object_version_number
5236: END IF;
5237: END IF;
5238: ELSE -- we are entering a secondary assignment.
5239: IF p_assignment_type='E' THEN
5240: hr_assignment_api.create_secondary_emp_asg
5241: (p_effective_date => p_effective_date
5242: ,p_person_id => p_person_id
5243: ,p_organization_id => p_organization_id
5244: ,p_grade_id => p_grade_id
5392: ,p_hourly_salaried_warning => l_hourly_salaried_warning
5393: ,p_gsp_post_process_warning => l_gsp_post_process_warning3 -- bug2999562
5394: );
5395: ELSIF p_assignment_type='A' THEN -- a secondary applicant assignment
5396: hr_assignment_api.create_secondary_apl_asg
5397: (p_effective_date => p_effective_date
5398: ,p_person_id => p_person_id
5399: ,p_organization_id => p_organization_id
5400: ,p_recruiter_id => p_recruiter_id
5547: ,p_effective_end_date => l_asg_effective_end_date
5548: ,p_assignment_sequence => l_assignment_sequence
5549: );
5550: ELSIF p_assignment_type = 'C' then
5551: hr_assignment_api.create_secondary_cwk_asg
5552: (p_effective_date => p_effective_date
5553: ,p_business_group_id => p_business_group_id
5554: ,p_person_id => p_person_id
5555: ,p_organization_id => p_organization_id