[Home] [Help]
1676: -- Process Logic
1677: --
1678: -- Get default details.
1679: --
1680: hr_api.mandatory_arg_error
1681: (p_api_name => l_proc,
1682: p_argument => 'business_group_id',
1683: p_argument_value => p_business_group_id);
1684: --
2742: hr_utility.set_location(l_proc,30);
2743: --
2744: hr_sp_placement_api.delete_spp
2745: (p_effective_date => c_spp_record.effective_start_date
2746: ,p_datetrack_mode => hr_api.g_zap
2747: ,p_placement_id => c_spp_record.placement_id
2748: ,p_object_version_number => c_spp_record.object_version_number
2749: ,p_effective_start_date => l_effective_start_date
2750: ,p_effective_end_date => l_effective_end_date);
2855: l_object_version_number := c1_rec.object_version_number;
2856: --
2857: hr_sp_placement_api.delete_spp
2858: (p_effective_date => c1_rec.effective_start_date
2859: ,p_datetrack_mode => hr_api.g_delete_next_change
2860: ,p_placement_id => p_placement_id
2861: ,p_object_version_number => l_object_version_number
2862: ,p_effective_start_date => l_effective_start_date
2863: ,p_effective_end_date => l_effective_end_date);
3105: -- validation_start_date and effective_end_date is greater than the
3106: -- validation_end_date, such cases we cannot perform delete next change,
3107: -- should display an error message and user needs to delete that SPP record
3108: -- through Placement form, if he wants to proceed.
3109: if p_datetrack_mode = hr_api.g_delete_next_change then
3110: --
3111: open csr_asg_spp_error(csr_asg_rec.effective_start_date,
3112: csr_asg_rec.effective_end_date);
3113: fetch csr_asg_spp_error into l_old_grade_id;
3111: open csr_asg_spp_error(csr_asg_rec.effective_start_date,
3112: csr_asg_rec.effective_end_date);
3113: fetch csr_asg_spp_error into l_old_grade_id;
3114: if csr_asg_spp_error%found and
3115: nvl(l_old_grade_id, hr_api.g_number) <>
3116: nvl(csr_asg_rec.grade_id, hr_api.g_number) then
3117: --
3118: close csr_asg_spp_error;
3119: --
3112: csr_asg_rec.effective_end_date);
3113: fetch csr_asg_spp_error into l_old_grade_id;
3114: if csr_asg_spp_error%found and
3115: nvl(l_old_grade_id, hr_api.g_number) <>
3116: nvl(csr_asg_rec.grade_id, hr_api.g_number) then
3117: --
3118: close csr_asg_spp_error;
3119: --
3120: hr_utility.set_message(800, 'HR_289771_SPP_MIN_START_DATE');
3128: --
3129: end if;
3130: --
3131: end loop;
3132: if p_datetrack_mode in (hr_api.g_correction,
3133: hr_api.g_update_change_insert) then
3134: --
3135: for spp_rec in csr_spp_records loop
3136: --
3129: end if;
3130: --
3131: end loop;
3132: if p_datetrack_mode in (hr_api.g_correction,
3133: hr_api.g_update_change_insert) then
3134: --
3135: for spp_rec in csr_spp_records loop
3136: --
3137: delete from per_spinal_point_placements_f spp
3248: ,l_effective_end_date,l_object_version_number;
3249: if csr_ved_continues_spp%found then
3250: --
3251: --
3252: l_datetrack_mode := hr_api.g_update;
3253: --
3254: open csr_future_spp_exists(p_validation_end_date,l_placement_id);
3255: fetch csr_future_spp_exists into l_exists;
3256: if csr_future_spp_exists%found then
3254: open csr_future_spp_exists(p_validation_end_date,l_placement_id);
3255: fetch csr_future_spp_exists into l_exists;
3256: if csr_future_spp_exists%found then
3257: --
3258: l_datetrack_mode := hr_api.g_update_change_insert;
3259: --
3260: end if;
3261: --
3262: close csr_future_spp_exists;
3290: hr_utility.set_location(l_proc||'/'||csr_rec.placement_id, 60);
3291: end if;
3292: --
3293: if p_validation_end_date > csr_rec.effective_end_date and
3294: csr_rec.effective_end_date <> hr_api.g_eot then
3295: --
3296: l_object_version_number := csr_rec.object_version_number;
3297: hr_sp_placement_api.delete_spp(
3298: p_effective_date => csr_rec.effective_start_date
3295: --
3296: l_object_version_number := csr_rec.object_version_number;
3297: hr_sp_placement_api.delete_spp(
3298: p_effective_date => csr_rec.effective_start_date
3299: ,p_datetrack_mode => hr_api.g_delete_next_change
3300: ,p_placement_id => csr_rec.placement_id
3301: ,p_object_version_number => l_object_version_number
3302: ,p_effective_start_date => l_effective_start_date
3303: ,p_effective_end_date => l_effective_end_date);
3385: -- a) Current effective records effective_end_date is NOT EOT and
3386: -- b) p_validation_end_date is NOT less than or equal to current
3387: -- effective_end_date of SPP record.
3388: if csr_spp_details%found and
3389: l_spp_eff_end_date <> hr_api.g_eot then
3390: --
3391: hr_sp_placement_api.delete_spp(
3392: p_effective_date => l_spp_eff_start_date
3393: ,p_datetrack_mode => p_datetrack_mode
3546: -- As there is no future records are existing.
3547: -- We need to end date the current record and create a new DT record
3548: -- with the new Grade
3549: -- Performing a DT UPDATE
3550: l_datetrack_mode := hr_api.g_update;
3551: if g_debug then
3552: hr_utility.set_location(l_proc||' /l_datetrack_mode '||l_datetrack_mode, 50);
3553: hr_utility.set_location(l_proc, 60);
3554: end if;
3600: end if;
3601: l_object_version_number := csr_rec.object_version_number;
3602: hr_sp_placement_api.delete_spp(
3603: p_effective_date => csr_rec.effective_start_date
3604: ,p_datetrack_mode => hr_api.g_delete_next_change
3605: ,p_placement_id => p_placement_id
3606: ,p_object_version_number => l_object_version_number
3607: ,p_effective_start_date => l_effective_start_date
3608: ,p_effective_end_date => l_effective_end_date);
3640: -- placement will be repeating twice with a different datetrack period
3641: -- We need to combine these records.
3642: for rec_past_spp in csr_past_spp_details(l_placement_id => p_placement_id) loop
3643: --
3644: if rec_past_spp.effective_end_date <> hr_api.g_eot then
3645: l_object_version_number := rec_past_spp.object_version_number;
3646: hr_sp_placement_api.delete_spp(
3647: p_effective_date => p_validation_start_date - 1
3648: ,p_datetrack_mode => hr_api.g_delete_next_change
3644: if rec_past_spp.effective_end_date <> hr_api.g_eot then
3645: l_object_version_number := rec_past_spp.object_version_number;
3646: hr_sp_placement_api.delete_spp(
3647: p_effective_date => p_validation_start_date - 1
3648: ,p_datetrack_mode => hr_api.g_delete_next_change
3649: ,p_placement_id => p_placement_id
3650: ,p_object_version_number => l_object_version_number
3651: ,p_effective_start_date => l_effective_start_date
3652: ,p_effective_end_date => l_effective_end_date);
3681: hr_utility.set_location(l_proc||' ovn ='||l_previous_ovn, 150);
3682: end if;
3683: hr_sp_placement_api.delete_spp(
3684: p_effective_date => p_validation_start_date - 1
3685: ,p_datetrack_mode => hr_api.g_delete
3686: ,p_placement_id => p_placement_id
3687: ,p_object_version_number => l_previous_ovn
3688: ,p_effective_start_date => l_effective_start_date
3689: ,p_effective_end_date => l_effective_end_date);
3775: -- If the future SPP changes are existing after the validation_start_date
3776: -- then we need to delete all future changes
3777: hr_sp_placement_api.delete_spp(
3778: p_effective_date => p_validation_start_date
3779: ,p_datetrack_mode => hr_api.g_future_change
3780: ,p_placement_id => p_placement_id
3781: ,p_object_version_number => l_object_version_number
3782: ,p_effective_start_date => l_effective_start_date
3783: ,p_effective_end_date => l_effective_end_date);
3802: end if;
3803: --
3804: hr_sp_placement_api.delete_spp(
3805: p_effective_date => p_validation_start_date - 1
3806: ,p_datetrack_mode => hr_api.g_delete
3807: ,p_placement_id => p_placement_id
3808: ,p_object_version_number => l_object_version_number
3809: ,p_effective_start_date => l_effective_start_date
3810: ,p_effective_end_date => l_effective_end_date);
3922: ,l_effective_end_date,l_object_version_number;
3923: if csr_ved_continues_spp%found then
3924: --
3925: --
3926: l_datetrack_mode := hr_api.g_update;
3927: --
3928: open csr_future_spp_exists(p_validation_end_date);
3929: fetch csr_future_spp_exists into l_exists;
3930: if csr_future_spp_exists%found then
3928: open csr_future_spp_exists(p_validation_end_date);
3929: fetch csr_future_spp_exists into l_exists;
3930: if csr_future_spp_exists%found then
3931: --
3932: l_datetrack_mode := hr_api.g_update_change_insert;
3933: --
3934: end if;
3935: --
3936: close csr_future_spp_exists;
3960: ,l_effective_end_date,l_object_version_number;
3961: if csr_vsd_continues_spp%found then
3962: --
3963: --
3964: l_datetrack_mode := hr_api.g_update;
3965: --
3966: open csr_future_spp_exists(p_validation_start_date);
3967: fetch csr_future_spp_exists into l_exists;
3968: if csr_future_spp_exists%found then
3966: open csr_future_spp_exists(p_validation_start_date);
3967: fetch csr_future_spp_exists into l_exists;
3968: if csr_future_spp_exists%found then
3969: --
3970: l_datetrack_mode := hr_api.g_update_change_insert;
3971: --
3972: end if;
3973: --
3974: close csr_future_spp_exists;
4045: --
4046: l_effective_date := l_effective_start_date;
4047: hr_sp_placement_api.delete_spp(
4048: p_effective_date => l_effective_date
4049: ,p_datetrack_mode => hr_api.g_delete_next_change
4050: ,p_placement_id => l_placement_id
4051: ,p_object_version_number => l_object_version_number
4052: ,p_effective_start_date => l_effective_start_date
4053: ,p_effective_end_date => l_effective_end_date);
4069: -- added the following if condition.
4070: if (l_placement_id is not null ) then
4071: hr_sp_placement_api.update_spp(
4072: p_effective_date => p_validation_start_date
4073: ,p_datetrack_mode => hr_api.g_correction
4074: ,p_placement_id => l_placement_id
4075: ,p_step_id => l_min_step_id
4076: ,p_object_version_number => l_object_version_number
4077: ,p_effective_start_date => l_effective_start_date
4140: BEGIN
4141: --
4142: hr_utility.set_location('Entering : '||l_proc, 10);
4143: --
4144: IF p_datetrack_mode = hr_api.g_correction THEN
4145: --
4146: hr_utility.set_location(l_proc, 20);
4147: --
4148: -- Check for previous SPP records
4160: l_object_version_number := p_object_version_number;
4161: --
4162: hr_sp_placement_api.delete_spp
4163: (p_effective_date => p_effective_date
4164: ,p_datetrack_mode => hr_api.g_zap
4165: ,p_placement_id => p_placement_id
4166: ,p_object_version_number => l_object_version_number
4167: ,p_effective_start_date => l_effective_start_date
4168: ,p_effective_end_date => l_effective_end_date);
4183: hr_utility.set_location(l_proc||l_previous_ovn||'/'||l_previous_end_date, 50);
4184: --
4185: hr_sp_placement_api.delete_spp
4186: (p_effective_date => l_previous_end_date
4187: ,p_datetrack_mode => hr_api.g_delete
4188: ,p_placement_id => p_placement_id
4189: ,p_object_version_number => l_previous_ovn
4190: ,p_effective_start_date => l_effective_start_date
4191: ,p_effective_end_date => l_effective_end_date);
4201: l_object_version_number := p_object_version_number;
4202: --
4203: hr_sp_placement_api.delete_spp
4204: (p_effective_date => p_effective_date -1
4205: ,p_datetrack_mode => hr_api.g_delete
4206: ,p_placement_id => p_placement_id
4207: ,p_object_version_number => l_object_version_number
4208: ,p_effective_start_date => l_effective_start_date
4209: ,p_effective_end_date => l_effective_end_date);
4235: l_object_version_number := c_future_spp.object_version_number;
4236: --
4237: hr_sp_placement_api.delete_spp
4238: (p_effective_date => c_future_spp.effective_start_date
4239: ,p_datetrack_mode => hr_api.g_zap
4240: ,p_placement_id => c_future_spp.placement_id
4241: ,p_object_version_number => l_object_version_number
4242: ,p_effective_start_date => l_effective_start_date
4243: ,p_effective_end_date => l_effective_end_date);
4350: hr_utility.set_location('Entering:'|| l_proc, 10);
4351: end if;
4352: -- Validation in addition to Table Handlers
4353: -- Check that all mandatory arguments are not null.
4354: hr_api.mandatory_arg_error
4355: (p_api_name => l_proc,
4356: p_argument => 'assignment_id',
4357: p_argument_value => p_assignment_id);
4358: --
4355: (p_api_name => l_proc,
4356: p_argument => 'assignment_id',
4357: p_argument_value => p_assignment_id);
4358: --
4359: hr_api.mandatory_arg_error
4360: (p_api_name => l_proc,
4361: p_argument => 'datetrack_mode',
4362: p_argument_value => p_datetrack_mode);
4363: --
4360: (p_api_name => l_proc,
4361: p_argument => 'datetrack_mode',
4362: p_argument_value => p_datetrack_mode);
4363: --
4364: hr_api.mandatory_arg_error
4365: (p_api_name => l_proc,
4366: p_argument => 'validation_start_date',
4367: p_argument_value => p_validation_start_date);
4368: --
4365: (p_api_name => l_proc,
4366: p_argument => 'validation_start_date',
4367: p_argument_value => p_validation_start_date);
4368: --
4369: hr_api.mandatory_arg_error
4370: (p_api_name => l_proc,
4371: p_argument => 'validation_end_date',
4372: p_argument_value => p_validation_end_date);
4373: -- Process Logic
4396: -- check may not be valid for all the case.
4397: -- If the datetrack mode is ZAP,(This DT mode is allowed only for
4398: -- secondary assignment) then removing all the SPP records pertaining
4399: -- to this assignment from the database.
4400: if p_datetrack_mode = hr_api.g_zap then
4401: --
4402: if g_debug then
4403: hr_utility.set_location(l_proc, 30);
4404: hr_utility.set_location(l_proc||' DT Mode = '||p_datetrack_mode, 31);
4444: -- spinal point information.
4445: if l_current_spp_exist or l_future_spp_exist then
4446: -- Checking the datetarck mode selected by the user, and performing
4447: -- the process accordingly
4448: if p_datetrack_mode = hr_api.g_delete_next_change then
4449: --
4450: delete_next_change_spp(
4451: p_assignment_id => p_assignment_id
4452: ,p_placement_id => l_placement_id
4458: if g_debug then
4459: hr_utility.set_location(l_proc, 60);
4460: end if;
4461: --
4462: elsif p_datetrack_mode = hr_api.g_future_change then
4463: --
4464: future_change_spp(
4465: p_assignment_id => p_assignment_id
4466: ,p_placement_id => l_placement_id
4514: close csr_grade_pay_scale_defined;
4515: --
4516: End if;
4517: --
4518: if p_datetrack_mode = hr_api.g_update_override then
4519: --
4520: update_override_spp(
4521: p_assignment_id => p_assignment_id
4522: ,p_placement_id => l_placement_id
4530: ,p_current_spp_exist => l_current_spp_exist
4531: ,p_pay_scale_defined => l_pay_scale_defined
4532: ,p_del_end_future_spp => l_del_end_future_spp);
4533: --
4534: elsif p_datetrack_mode in (hr_api.g_correction,
4535: hr_api.g_update_change_insert) then
4536: --
4537: If p_grade_id is not null then
4538: --
4531: ,p_pay_scale_defined => l_pay_scale_defined
4532: ,p_del_end_future_spp => l_del_end_future_spp);
4533: --
4534: elsif p_datetrack_mode in (hr_api.g_correction,
4535: hr_api.g_update_change_insert) then
4536: --
4537: If p_grade_id is not null then
4538: --
4539: correction_spp(
4552: hr_utility.set_message(800, 'HR_50426_REM_STEP_BEF_REM_GRD');
4553: hr_utility.raise_error;
4554: End if;
4555: --
4556: elsif p_datetrack_mode = hr_api.g_update then
4557: -- Check for future records SPP records if any for the same
4558: -- placement id
4559: open csr_spp_future_records(l_placement_id);
4560: fetch csr_spp_future_records into l_dummy_id;
4569: -- effective_start_date, then we need to delete
4570: -- all future changes
4571: hr_sp_placement_api.delete_spp(
4572: p_effective_date => p_validation_start_date
4573: ,p_datetrack_mode => hr_api.g_future_change
4574: ,p_placement_id => l_placement_id
4575: ,p_object_version_number => l_object_version_number
4576: ,p_effective_start_date => l_effective_start_date
4577: ,p_effective_end_date => l_effective_end_date);
4580: --
4581: if g_debug then
4582: hr_utility.set_location(l_proc, 275);
4583: end if;
4584: l_datetrack_mode := hr_api.g_correction;
4585: --
4586: else
4587: --
4588: l_datetrack_mode := hr_api.g_update_override;
4584: l_datetrack_mode := hr_api.g_correction;
4585: --
4586: else
4587: --
4588: l_datetrack_mode := hr_api.g_update_override;
4589: --
4590: end if;
4591: -- There are no future SPP records existing
4592: else
4597: --
4598: if g_debug then
4599: hr_utility.set_location(l_proc, 300);
4600: end if;
4601: l_datetrack_mode := hr_api.g_correction;
4602: --
4603: else
4604: --
4605: if g_debug then
4604: --
4605: if g_debug then
4606: hr_utility.set_location(l_proc, 310);
4607: end if;
4608: l_datetrack_mode := hr_api.g_update;
4609: --
4610: end if;
4611: --
4612: end if;
4616: if g_debug then
4617: hr_utility.set_location(l_proc||' DT Mode = '||l_datetrack_mode, 320);
4618: end if;
4619: --
4620: elsif p_datetrack_mode = hr_api.g_delete then
4621: --
4622: l_datetrack_mode := hr_api.g_delete;
4623: --
4624: end if;
4618: end if;
4619: --
4620: elsif p_datetrack_mode = hr_api.g_delete then
4621: --
4622: l_datetrack_mode := hr_api.g_delete;
4623: --
4624: end if;
4625: --
4626: if p_datetrack_mode in (hr_api.g_update, hr_api.g_delete) then
4622: l_datetrack_mode := hr_api.g_delete;
4623: --
4624: end if;
4625: --
4626: if p_datetrack_mode in (hr_api.g_update, hr_api.g_delete) then
4627: -- Check that the effective date of the process is not less than the min
4628: -- effective start date for the spp record for the assignment
4629: -- If it is then the process will not be able to update the current step
4630: -- as there is none so raise an error
4646: -- a grade attached and updating the primary assignment. As a result
4647: -- primary assignment will get end dated and the new primary assignment
4648: -- (created from applicant assignment) will not be having a grade.
4649: -- In such case the previous grade step placement should get end dated.
4650: if not l_pay_scale_defined and p_datetrack_mode = hr_api.g_update then
4651: --
4652: close_spp_records(
4653: p_assignment_id => p_assignment_id
4654: ,p_placement_id => l_placement_id
4716: procedure update_status_type_cwk_asg
4717: (p_effective_date in date
4718: ,p_datetrack_update_mode in varchar2
4719: ,p_assignment_id in number
4720: ,p_change_reason in varchar2 default hr_api.g_varchar2
4721: --
4722: ,p_object_version_number in out nocopy number
4723: ,p_expected_system_status in varchar2
4724: ,p_assignment_status_type_id in number default hr_api.g_number
4720: ,p_change_reason in varchar2 default hr_api.g_varchar2
4721: --
4722: ,p_object_version_number in out nocopy number
4723: ,p_expected_system_status in varchar2
4724: ,p_assignment_status_type_id in number default hr_api.g_number
4725: ,p_effective_start_date out nocopy date
4726: ,p_effective_end_date out nocopy date
4727: ) is
4728: --
4782: hr_utility.set_location(l_proc, 20);
4783: --
4784: -- Get assignment details.
4785: --
4786: hr_api.mandatory_arg_error
4787: (p_api_name => l_proc,
4788: p_argument => 'assignment_id',
4789: p_argument_value => p_assignment_id);
4790: --
4787: (p_api_name => l_proc,
4788: p_argument => 'assignment_id',
4789: p_argument_value => p_assignment_id);
4790: --
4791: hr_api.mandatory_arg_error
4792: (p_api_name => l_proc,
4793: p_argument => 'effective_date',
4794: p_argument_value => p_effective_date);
4795: --
4881: procedure update_status_type_emp_asg
4882: (p_effective_date in date
4883: ,p_datetrack_update_mode in varchar2
4884: ,p_assignment_id in number
4885: ,p_change_reason in varchar2 default hr_api.g_varchar2
4886: --
4887: ,p_object_version_number in out nocopy number
4888: ,p_expected_system_status in varchar2
4889: ,p_assignment_status_type_id in number default hr_api.g_number
4885: ,p_change_reason in varchar2 default hr_api.g_varchar2
4886: --
4887: ,p_object_version_number in out nocopy number
4888: ,p_expected_system_status in varchar2
4889: ,p_assignment_status_type_id in number default hr_api.g_number
4890: ,p_effective_start_date out nocopy date
4891: ,p_effective_end_date out nocopy date
4892: ) is
4893: --
4947: hr_utility.set_location(l_proc, 20);
4948: --
4949: -- Get assignment details.
4950: --
4951: hr_api.mandatory_arg_error
4952: (p_api_name => l_proc,
4953: p_argument => 'assignment_id',
4954: p_argument_value => p_assignment_id);
4955: --
4952: (p_api_name => l_proc,
4953: p_argument => 'assignment_id',
4954: p_argument_value => p_assignment_id);
4955: --
4956: hr_api.mandatory_arg_error
4957: (p_api_name => l_proc,
4958: p_argument => 'effective_date',
4959: p_argument_value => p_effective_date);
4960: --
5412: -- Process Logic
5413: --
5414: -- Get default details.
5415: --
5416: hr_api.mandatory_arg_error
5417: (p_api_name => l_proc,
5418: p_argument => 'business_group_id',
5419: p_argument_value => p_business_group_id);
5420: --
5752: select location_id,people_group_id,recruiter_id,job_id,position_id,grade_id,organization_id
5753: from PER_ALL_VACANCIES
5754: where vacancy_id = p_vacancy_id
5755: and p_effective_date between date_from
5756: and nvl(date_to, hr_api.g_eot);
5757: -- Bug 4325900 Ends
5758: --
5759: begin
5760: hr_utility.set_location('Entering:'|| l_proc, 10);
5847: ,p_datetrack_update_mode in varchar2
5848: ,p_assignment_id in number
5849: ,p_object_version_number in out nocopy number
5850: ,p_expected_system_status in varchar2
5851: ,p_assignment_status_type_id in number default hr_api.g_number
5852: ,p_change_reason in varchar2 default hr_api.g_varchar2
5853: ,p_effective_start_date out nocopy date
5854: ,p_effective_end_date out nocopy date
5855: ) is
5848: ,p_assignment_id in number
5849: ,p_object_version_number in out nocopy number
5850: ,p_expected_system_status in varchar2
5851: ,p_assignment_status_type_id in number default hr_api.g_number
5852: ,p_change_reason in varchar2 default hr_api.g_varchar2
5853: ,p_effective_start_date out nocopy date
5854: ,p_effective_end_date out nocopy date
5855: ) is
5856: Cursor csr_vacancy_id is
5967:
5968: hr_utility.set_location('l_perinfo1 enthn pkg :'||l_per_info1,262);
5969:
5970: hr_utility.set_location('p_expected_system_status :'||p_expected_system_status,262);
5971: hr_utility.set_location('hr_api.return_legislation_code (l_bgid):'||hr_api.return_legislation_code (l_bgid),262);
5972:
5973: open csr_asg_status_type;
5974: fetch csr_asg_status_type into l_asg_status;
5975: close csr_asg_status_type;
5976:
5977: hr_utility.set_location(' l_asg_status :'|| l_asg_status,262);
5978: hr_utility.set_location(' p_assignment_status_type_id :'|| p_assignment_status_type_id,262);
5979:
5980: if hr_api.return_legislation_code (l_bgid) ='US' and l_per_info1 is not null
5981: and l_asg_status = 'ACCEPTED' then
5982:
5983: hr_utility.set_location('now check if an emp enthn pkg :'||l_per_info1,262);
5984: open csr_is_emp;
6030: hr_utility.set_location(l_proc, 30);
6031: --
6032: -- Process Logic
6033: --
6034: -- If p_assignment_status_type_id is hr_api.g_number then derive it's default
6035: -- value, otherwise validate it.
6036: --
6037: l_assignment_status_type_id := p_assignment_status_type_id;
6038: --
6656: end if;
6657: --
6658: if ( p_datetrack_mode in ('FUTURE_CHANGE','DELETE_NEXT_CHANGE' ) ) then
6659: if ( p_appl_asg_new_end_date is null ) then
6660: if ( p_validation_end_date = hr_api.g_eot ) then
6661: hr_assignment.tidy_up_ref_int ( p_rec.assignment_id, -- p_assignment_id,
6662: 'FUTURE',
6663: p_validation_end_date, -- p_validation_end_date,
6664: per_asg_shd.g_old_rec.effective_end_date, -- p_effective_end_date,
6718: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6719: p_datetrack_mode, -- p_del_mode,
6720: p_validation_start_date, -- p_val_st_date,
6721: p_new_primary_flag, -- from pre_del()
6722: hr_api.g_eot, -- p_eot,
6723: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,
6724: l_new_prim_ass_id, -- l_new_prim_ass_id,
6725: l_prim_change_flag, -- l_prim_change_flag,
6726: l_sys_status_type, -- p_per_sys_st,