[Home] [Help]
1577: -- Process Logic
1578: --
1579: -- Get default details.
1580: --
1581: hr_api.mandatory_arg_error
1582: (p_api_name => l_proc,
1583: p_argument => 'business_group_id',
1584: p_argument_value => p_business_group_id);
1585: --
2609: hr_utility.set_location(l_proc,30);
2610: --
2611: hr_sp_placement_api.delete_spp
2612: (p_effective_date => c_spp_record.effective_start_date
2613: ,p_datetrack_mode => hr_api.g_zap
2614: ,p_placement_id => c_spp_record.placement_id
2615: ,p_object_version_number => c_spp_record.object_version_number
2616: ,p_effective_start_date => l_effective_start_date
2617: ,p_effective_end_date => l_effective_end_date);
2722: l_object_version_number := c1_rec.object_version_number;
2723: --
2724: hr_sp_placement_api.delete_spp
2725: (p_effective_date => c1_rec.effective_start_date
2726: ,p_datetrack_mode => hr_api.g_delete_next_change
2727: ,p_placement_id => p_placement_id
2728: ,p_object_version_number => l_object_version_number
2729: ,p_effective_start_date => l_effective_start_date
2730: ,p_effective_end_date => l_effective_end_date);
2972: -- validation_start_date and effective_end_date is greater than the
2973: -- validation_end_date, such cases we cannot perform delete next change,
2974: -- should display an error message and user needs to delete that SPP record
2975: -- through Placement form, if he wants to proceed.
2976: if p_datetrack_mode = hr_api.g_delete_next_change then
2977: --
2978: open csr_asg_spp_error(csr_asg_rec.effective_start_date,
2979: csr_asg_rec.effective_end_date);
2980: fetch csr_asg_spp_error into l_old_grade_id;
2978: open csr_asg_spp_error(csr_asg_rec.effective_start_date,
2979: csr_asg_rec.effective_end_date);
2980: fetch csr_asg_spp_error into l_old_grade_id;
2981: if csr_asg_spp_error%found and
2982: nvl(l_old_grade_id, hr_api.g_number) <>
2983: nvl(csr_asg_rec.grade_id, hr_api.g_number) then
2984: --
2985: close csr_asg_spp_error;
2986: --
2979: csr_asg_rec.effective_end_date);
2980: fetch csr_asg_spp_error into l_old_grade_id;
2981: if csr_asg_spp_error%found and
2982: nvl(l_old_grade_id, hr_api.g_number) <>
2983: nvl(csr_asg_rec.grade_id, hr_api.g_number) then
2984: --
2985: close csr_asg_spp_error;
2986: --
2987: hr_utility.set_message(800, 'HR_289771_SPP_MIN_START_DATE');
2995: --
2996: end if;
2997: --
2998: end loop;
2999: if p_datetrack_mode in (hr_api.g_correction,
3000: hr_api.g_update_change_insert) then
3001: --
3002: for spp_rec in csr_spp_records loop
3003: --
2996: end if;
2997: --
2998: end loop;
2999: if p_datetrack_mode in (hr_api.g_correction,
3000: hr_api.g_update_change_insert) then
3001: --
3002: for spp_rec in csr_spp_records loop
3003: --
3004: delete from per_spinal_point_placements_f spp
3115: ,l_effective_end_date,l_object_version_number;
3116: if csr_ved_continues_spp%found then
3117: --
3118: --
3119: l_datetrack_mode := hr_api.g_update;
3120: --
3121: open csr_future_spp_exists(p_validation_end_date,l_placement_id);
3122: fetch csr_future_spp_exists into l_exists;
3123: if csr_future_spp_exists%found then
3121: open csr_future_spp_exists(p_validation_end_date,l_placement_id);
3122: fetch csr_future_spp_exists into l_exists;
3123: if csr_future_spp_exists%found then
3124: --
3125: l_datetrack_mode := hr_api.g_update_change_insert;
3126: --
3127: end if;
3128: --
3129: close csr_future_spp_exists;
3157: hr_utility.set_location(l_proc||'/'||csr_rec.placement_id, 60);
3158: end if;
3159: --
3160: if p_validation_end_date > csr_rec.effective_end_date and
3161: csr_rec.effective_end_date <> hr_api.g_eot then
3162: --
3163: l_object_version_number := csr_rec.object_version_number;
3164: hr_sp_placement_api.delete_spp(
3165: p_effective_date => csr_rec.effective_start_date
3162: --
3163: l_object_version_number := csr_rec.object_version_number;
3164: hr_sp_placement_api.delete_spp(
3165: p_effective_date => csr_rec.effective_start_date
3166: ,p_datetrack_mode => hr_api.g_delete_next_change
3167: ,p_placement_id => csr_rec.placement_id
3168: ,p_object_version_number => l_object_version_number
3169: ,p_effective_start_date => l_effective_start_date
3170: ,p_effective_end_date => l_effective_end_date);
3252: -- a) Current effective records effective_end_date is NOT EOT and
3253: -- b) p_validation_end_date is NOT less than or equal to current
3254: -- effective_end_date of SPP record.
3255: if csr_spp_details%found and
3256: l_spp_eff_end_date <> hr_api.g_eot then
3257: --
3258: hr_sp_placement_api.delete_spp(
3259: p_effective_date => l_spp_eff_start_date
3260: ,p_datetrack_mode => p_datetrack_mode
3413: -- As there is no future records are existing.
3414: -- We need to end date the current record and create a new DT record
3415: -- with the new Grade
3416: -- Performing a DT UPDATE
3417: l_datetrack_mode := hr_api.g_update;
3418: if g_debug then
3419: hr_utility.set_location(l_proc||' /l_datetrack_mode '||l_datetrack_mode, 50);
3420: hr_utility.set_location(l_proc, 60);
3421: end if;
3467: end if;
3468: l_object_version_number := csr_rec.object_version_number;
3469: hr_sp_placement_api.delete_spp(
3470: p_effective_date => csr_rec.effective_start_date
3471: ,p_datetrack_mode => hr_api.g_delete_next_change
3472: ,p_placement_id => p_placement_id
3473: ,p_object_version_number => l_object_version_number
3474: ,p_effective_start_date => l_effective_start_date
3475: ,p_effective_end_date => l_effective_end_date);
3507: -- placement will be repeating twice with a different datetrack period
3508: -- We need to combine these records.
3509: for rec_past_spp in csr_past_spp_details(l_placement_id => p_placement_id) loop
3510: --
3511: if rec_past_spp.effective_end_date <> hr_api.g_eot then
3512: l_object_version_number := rec_past_spp.object_version_number;
3513: hr_sp_placement_api.delete_spp(
3514: p_effective_date => p_validation_start_date - 1
3515: ,p_datetrack_mode => hr_api.g_delete_next_change
3511: if rec_past_spp.effective_end_date <> hr_api.g_eot then
3512: l_object_version_number := rec_past_spp.object_version_number;
3513: hr_sp_placement_api.delete_spp(
3514: p_effective_date => p_validation_start_date - 1
3515: ,p_datetrack_mode => hr_api.g_delete_next_change
3516: ,p_placement_id => p_placement_id
3517: ,p_object_version_number => l_object_version_number
3518: ,p_effective_start_date => l_effective_start_date
3519: ,p_effective_end_date => l_effective_end_date);
3548: hr_utility.set_location(l_proc||' ovn ='||l_previous_ovn, 150);
3549: end if;
3550: hr_sp_placement_api.delete_spp(
3551: p_effective_date => p_validation_start_date - 1
3552: ,p_datetrack_mode => hr_api.g_delete
3553: ,p_placement_id => p_placement_id
3554: ,p_object_version_number => l_previous_ovn
3555: ,p_effective_start_date => l_effective_start_date
3556: ,p_effective_end_date => l_effective_end_date);
3642: -- If the future SPP changes are existing after the validation_start_date
3643: -- then we need to delete all future changes
3644: hr_sp_placement_api.delete_spp(
3645: p_effective_date => p_validation_start_date
3646: ,p_datetrack_mode => hr_api.g_future_change
3647: ,p_placement_id => p_placement_id
3648: ,p_object_version_number => l_object_version_number
3649: ,p_effective_start_date => l_effective_start_date
3650: ,p_effective_end_date => l_effective_end_date);
3669: end if;
3670: --
3671: hr_sp_placement_api.delete_spp(
3672: p_effective_date => p_validation_start_date - 1
3673: ,p_datetrack_mode => hr_api.g_delete
3674: ,p_placement_id => p_placement_id
3675: ,p_object_version_number => l_object_version_number
3676: ,p_effective_start_date => l_effective_start_date
3677: ,p_effective_end_date => l_effective_end_date);
3789: ,l_effective_end_date,l_object_version_number;
3790: if csr_ved_continues_spp%found then
3791: --
3792: --
3793: l_datetrack_mode := hr_api.g_update;
3794: --
3795: open csr_future_spp_exists(p_validation_end_date);
3796: fetch csr_future_spp_exists into l_exists;
3797: if csr_future_spp_exists%found then
3795: open csr_future_spp_exists(p_validation_end_date);
3796: fetch csr_future_spp_exists into l_exists;
3797: if csr_future_spp_exists%found then
3798: --
3799: l_datetrack_mode := hr_api.g_update_change_insert;
3800: --
3801: end if;
3802: --
3803: close csr_future_spp_exists;
3827: ,l_effective_end_date,l_object_version_number;
3828: if csr_vsd_continues_spp%found then
3829: --
3830: --
3831: l_datetrack_mode := hr_api.g_update;
3832: --
3833: open csr_future_spp_exists(p_validation_start_date);
3834: fetch csr_future_spp_exists into l_exists;
3835: if csr_future_spp_exists%found then
3833: open csr_future_spp_exists(p_validation_start_date);
3834: fetch csr_future_spp_exists into l_exists;
3835: if csr_future_spp_exists%found then
3836: --
3837: l_datetrack_mode := hr_api.g_update_change_insert;
3838: --
3839: end if;
3840: --
3841: close csr_future_spp_exists;
3912: --
3913: l_effective_date := l_effective_start_date;
3914: hr_sp_placement_api.delete_spp(
3915: p_effective_date => l_effective_date
3916: ,p_datetrack_mode => hr_api.g_delete_next_change
3917: ,p_placement_id => l_placement_id
3918: ,p_object_version_number => l_object_version_number
3919: ,p_effective_start_date => l_effective_start_date
3920: ,p_effective_end_date => l_effective_end_date);
3936: -- added the following if condition.
3937: if (l_placement_id is not null ) then
3938: hr_sp_placement_api.update_spp(
3939: p_effective_date => p_validation_start_date
3940: ,p_datetrack_mode => hr_api.g_correction
3941: ,p_placement_id => l_placement_id
3942: ,p_step_id => l_min_step_id
3943: ,p_object_version_number => l_object_version_number
3944: ,p_effective_start_date => l_effective_start_date
4007: BEGIN
4008: --
4009: hr_utility.set_location('Entering : '||l_proc, 10);
4010: --
4011: IF p_datetrack_mode = hr_api.g_correction THEN
4012: --
4013: hr_utility.set_location(l_proc, 20);
4014: --
4015: -- Check for previous SPP records
4027: l_object_version_number := p_object_version_number;
4028: --
4029: hr_sp_placement_api.delete_spp
4030: (p_effective_date => p_effective_date
4031: ,p_datetrack_mode => hr_api.g_zap
4032: ,p_placement_id => p_placement_id
4033: ,p_object_version_number => l_object_version_number
4034: ,p_effective_start_date => l_effective_start_date
4035: ,p_effective_end_date => l_effective_end_date);
4050: hr_utility.set_location(l_proc||l_previous_ovn||'/'||l_previous_end_date, 50);
4051: --
4052: hr_sp_placement_api.delete_spp
4053: (p_effective_date => l_previous_end_date
4054: ,p_datetrack_mode => hr_api.g_delete
4055: ,p_placement_id => p_placement_id
4056: ,p_object_version_number => l_previous_ovn
4057: ,p_effective_start_date => l_effective_start_date
4058: ,p_effective_end_date => l_effective_end_date);
4068: l_object_version_number := p_object_version_number;
4069: --
4070: hr_sp_placement_api.delete_spp
4071: (p_effective_date => p_effective_date -1
4072: ,p_datetrack_mode => hr_api.g_delete
4073: ,p_placement_id => p_placement_id
4074: ,p_object_version_number => l_object_version_number
4075: ,p_effective_start_date => l_effective_start_date
4076: ,p_effective_end_date => l_effective_end_date);
4102: l_object_version_number := c_future_spp.object_version_number;
4103: --
4104: hr_sp_placement_api.delete_spp
4105: (p_effective_date => c_future_spp.effective_start_date
4106: ,p_datetrack_mode => hr_api.g_zap
4107: ,p_placement_id => c_future_spp.placement_id
4108: ,p_object_version_number => l_object_version_number
4109: ,p_effective_start_date => l_effective_start_date
4110: ,p_effective_end_date => l_effective_end_date);
4217: hr_utility.set_location('Entering:'|| l_proc, 10);
4218: end if;
4219: -- Validation in addition to Table Handlers
4220: -- Check that all mandatory arguments are not null.
4221: hr_api.mandatory_arg_error
4222: (p_api_name => l_proc,
4223: p_argument => 'assignment_id',
4224: p_argument_value => p_assignment_id);
4225: --
4222: (p_api_name => l_proc,
4223: p_argument => 'assignment_id',
4224: p_argument_value => p_assignment_id);
4225: --
4226: hr_api.mandatory_arg_error
4227: (p_api_name => l_proc,
4228: p_argument => 'datetrack_mode',
4229: p_argument_value => p_datetrack_mode);
4230: --
4227: (p_api_name => l_proc,
4228: p_argument => 'datetrack_mode',
4229: p_argument_value => p_datetrack_mode);
4230: --
4231: hr_api.mandatory_arg_error
4232: (p_api_name => l_proc,
4233: p_argument => 'validation_start_date',
4234: p_argument_value => p_validation_start_date);
4235: --
4232: (p_api_name => l_proc,
4233: p_argument => 'validation_start_date',
4234: p_argument_value => p_validation_start_date);
4235: --
4236: hr_api.mandatory_arg_error
4237: (p_api_name => l_proc,
4238: p_argument => 'validation_end_date',
4239: p_argument_value => p_validation_end_date);
4240: -- Process Logic
4263: -- check may not be valid for all the case.
4264: -- If the datetrack mode is ZAP,(This DT mode is allowed only for
4265: -- secondary assignment) then removing all the SPP records pertaining
4266: -- to this assignment from the database.
4267: if p_datetrack_mode = hr_api.g_zap then
4268: --
4269: if g_debug then
4270: hr_utility.set_location(l_proc, 30);
4271: hr_utility.set_location(l_proc||' DT Mode = '||p_datetrack_mode, 31);
4311: -- spinal point information.
4312: if l_current_spp_exist or l_future_spp_exist then
4313: -- Checking the datetarck mode selected by the user, and performing
4314: -- the process accordingly
4315: if p_datetrack_mode = hr_api.g_delete_next_change then
4316: --
4317: delete_next_change_spp(
4318: p_assignment_id => p_assignment_id
4319: ,p_placement_id => l_placement_id
4325: if g_debug then
4326: hr_utility.set_location(l_proc, 60);
4327: end if;
4328: --
4329: elsif p_datetrack_mode = hr_api.g_future_change then
4330: --
4331: future_change_spp(
4332: p_assignment_id => p_assignment_id
4333: ,p_placement_id => l_placement_id
4381: close csr_grade_pay_scale_defined;
4382: --
4383: End if;
4384: --
4385: if p_datetrack_mode = hr_api.g_update_override then
4386: --
4387: update_override_spp(
4388: p_assignment_id => p_assignment_id
4389: ,p_placement_id => l_placement_id
4397: ,p_current_spp_exist => l_current_spp_exist
4398: ,p_pay_scale_defined => l_pay_scale_defined
4399: ,p_del_end_future_spp => l_del_end_future_spp);
4400: --
4401: elsif p_datetrack_mode in (hr_api.g_correction,
4402: hr_api.g_update_change_insert) then
4403: --
4404: If p_grade_id is not null then
4405: --
4398: ,p_pay_scale_defined => l_pay_scale_defined
4399: ,p_del_end_future_spp => l_del_end_future_spp);
4400: --
4401: elsif p_datetrack_mode in (hr_api.g_correction,
4402: hr_api.g_update_change_insert) then
4403: --
4404: If p_grade_id is not null then
4405: --
4406: correction_spp(
4419: hr_utility.set_message(800, 'HR_50426_REM_STEP_BEF_REM_GRD');
4420: hr_utility.raise_error;
4421: End if;
4422: --
4423: elsif p_datetrack_mode = hr_api.g_update then
4424: -- Check for future records SPP records if any for the same
4425: -- placement id
4426: open csr_spp_future_records(l_placement_id);
4427: fetch csr_spp_future_records into l_dummy_id;
4436: -- effective_start_date, then we need to delete
4437: -- all future changes
4438: hr_sp_placement_api.delete_spp(
4439: p_effective_date => p_validation_start_date
4440: ,p_datetrack_mode => hr_api.g_future_change
4441: ,p_placement_id => l_placement_id
4442: ,p_object_version_number => l_object_version_number
4443: ,p_effective_start_date => l_effective_start_date
4444: ,p_effective_end_date => l_effective_end_date);
4447: --
4448: if g_debug then
4449: hr_utility.set_location(l_proc, 275);
4450: end if;
4451: l_datetrack_mode := hr_api.g_correction;
4452: --
4453: else
4454: --
4455: l_datetrack_mode := hr_api.g_update_override;
4451: l_datetrack_mode := hr_api.g_correction;
4452: --
4453: else
4454: --
4455: l_datetrack_mode := hr_api.g_update_override;
4456: --
4457: end if;
4458: -- There are no future SPP records existing
4459: else
4464: --
4465: if g_debug then
4466: hr_utility.set_location(l_proc, 300);
4467: end if;
4468: l_datetrack_mode := hr_api.g_correction;
4469: --
4470: else
4471: --
4472: if g_debug then
4471: --
4472: if g_debug then
4473: hr_utility.set_location(l_proc, 310);
4474: end if;
4475: l_datetrack_mode := hr_api.g_update;
4476: --
4477: end if;
4478: --
4479: end if;
4483: if g_debug then
4484: hr_utility.set_location(l_proc||' DT Mode = '||l_datetrack_mode, 320);
4485: end if;
4486: --
4487: elsif p_datetrack_mode = hr_api.g_delete then
4488: --
4489: l_datetrack_mode := hr_api.g_delete;
4490: --
4491: end if;
4485: end if;
4486: --
4487: elsif p_datetrack_mode = hr_api.g_delete then
4488: --
4489: l_datetrack_mode := hr_api.g_delete;
4490: --
4491: end if;
4492: --
4493: if p_datetrack_mode in (hr_api.g_update, hr_api.g_delete) then
4489: l_datetrack_mode := hr_api.g_delete;
4490: --
4491: end if;
4492: --
4493: if p_datetrack_mode in (hr_api.g_update, hr_api.g_delete) then
4494: -- Check that the effective date of the process is not less than the min
4495: -- effective start date for the spp record for the assignment
4496: -- If it is then the process will not be able to update the current step
4497: -- as there is none so raise an error
4513: -- a grade attached and updating the primary assignment. As a result
4514: -- primary assignment will get end dated and the new primary assignment
4515: -- (created from applicant assignment) will not be having a grade.
4516: -- In such case the previous grade step placement should get end dated.
4517: if not l_pay_scale_defined and p_datetrack_mode = hr_api.g_update then
4518: --
4519: close_spp_records(
4520: p_assignment_id => p_assignment_id
4521: ,p_placement_id => l_placement_id
4583: procedure update_status_type_cwk_asg
4584: (p_effective_date in date
4585: ,p_datetrack_update_mode in varchar2
4586: ,p_assignment_id in number
4587: ,p_change_reason in varchar2 default hr_api.g_varchar2
4588: --
4589: ,p_object_version_number in out nocopy number
4590: ,p_expected_system_status in varchar2
4591: ,p_assignment_status_type_id in number default hr_api.g_number
4587: ,p_change_reason in varchar2 default hr_api.g_varchar2
4588: --
4589: ,p_object_version_number in out nocopy number
4590: ,p_expected_system_status in varchar2
4591: ,p_assignment_status_type_id in number default hr_api.g_number
4592: ,p_effective_start_date out nocopy date
4593: ,p_effective_end_date out nocopy date
4594: ) is
4595: --
4649: hr_utility.set_location(l_proc, 20);
4650: --
4651: -- Get assignment details.
4652: --
4653: hr_api.mandatory_arg_error
4654: (p_api_name => l_proc,
4655: p_argument => 'assignment_id',
4656: p_argument_value => p_assignment_id);
4657: --
4654: (p_api_name => l_proc,
4655: p_argument => 'assignment_id',
4656: p_argument_value => p_assignment_id);
4657: --
4658: hr_api.mandatory_arg_error
4659: (p_api_name => l_proc,
4660: p_argument => 'effective_date',
4661: p_argument_value => p_effective_date);
4662: --
4748: procedure update_status_type_emp_asg
4749: (p_effective_date in date
4750: ,p_datetrack_update_mode in varchar2
4751: ,p_assignment_id in number
4752: ,p_change_reason in varchar2 default hr_api.g_varchar2
4753: --
4754: ,p_object_version_number in out nocopy number
4755: ,p_expected_system_status in varchar2
4756: ,p_assignment_status_type_id in number default hr_api.g_number
4752: ,p_change_reason in varchar2 default hr_api.g_varchar2
4753: --
4754: ,p_object_version_number in out nocopy number
4755: ,p_expected_system_status in varchar2
4756: ,p_assignment_status_type_id in number default hr_api.g_number
4757: ,p_effective_start_date out nocopy date
4758: ,p_effective_end_date out nocopy date
4759: ) is
4760: --
4814: hr_utility.set_location(l_proc, 20);
4815: --
4816: -- Get assignment details.
4817: --
4818: hr_api.mandatory_arg_error
4819: (p_api_name => l_proc,
4820: p_argument => 'assignment_id',
4821: p_argument_value => p_assignment_id);
4822: --
4819: (p_api_name => l_proc,
4820: p_argument => 'assignment_id',
4821: p_argument_value => p_assignment_id);
4822: --
4823: hr_api.mandatory_arg_error
4824: (p_api_name => l_proc,
4825: p_argument => 'effective_date',
4826: p_argument_value => p_effective_date);
4827: --
5277: -- Process Logic
5278: --
5279: -- Get default details.
5280: --
5281: hr_api.mandatory_arg_error
5282: (p_api_name => l_proc,
5283: p_argument => 'business_group_id',
5284: p_argument_value => p_business_group_id);
5285: --
5617: select location_id,people_group_id,recruiter_id,job_id,position_id,grade_id,organization_id
5618: from PER_ALL_VACANCIES
5619: where vacancy_id = p_vacancy_id
5620: and p_effective_date between date_from
5621: and nvl(date_to, hr_api.g_eot);
5622: -- Bug 4325900 Ends
5623: --
5624: begin
5625: hr_utility.set_location('Entering:'|| l_proc, 10);
5712: ,p_datetrack_update_mode in varchar2
5713: ,p_assignment_id in number
5714: ,p_object_version_number in out nocopy number
5715: ,p_expected_system_status in varchar2
5716: ,p_assignment_status_type_id in number default hr_api.g_number
5717: ,p_change_reason in varchar2 default hr_api.g_varchar2
5718: ,p_effective_start_date out nocopy date
5719: ,p_effective_end_date out nocopy date
5720: ) is
5713: ,p_assignment_id in number
5714: ,p_object_version_number in out nocopy number
5715: ,p_expected_system_status in varchar2
5716: ,p_assignment_status_type_id in number default hr_api.g_number
5717: ,p_change_reason in varchar2 default hr_api.g_varchar2
5718: ,p_effective_start_date out nocopy date
5719: ,p_effective_end_date out nocopy date
5720: ) is
5721: Cursor csr_vacancy_id is
5819: hr_utility.set_location(l_proc, 30);
5820: --
5821: -- Process Logic
5822: --
5823: -- If p_assignment_status_type_id is hr_api.g_number then derive it's default
5824: -- value, otherwise validate it.
5825: --
5826: l_assignment_status_type_id := p_assignment_status_type_id;
5827: --
6438: end if;
6439: --
6440: if ( p_datetrack_mode in ('FUTURE_CHANGE','DELETE_NEXT_CHANGE' ) ) then
6441: if ( p_appl_asg_new_end_date is null ) then
6442: if ( p_validation_end_date = hr_api.g_eot ) then
6443: hr_assignment.tidy_up_ref_int ( p_rec.assignment_id, -- p_assignment_id,
6444: 'FUTURE',
6445: p_validation_end_date, -- p_validation_end_date,
6446: per_asg_shd.g_old_rec.effective_end_date, -- p_effective_end_date,
6500: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6501: p_datetrack_mode, -- p_del_mode,
6502: p_validation_start_date, -- p_val_st_date,
6503: p_new_primary_flag, -- from pre_del()
6504: hr_api.g_eot, -- p_eot,
6505: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,
6506: l_new_prim_ass_id, -- l_new_prim_ass_id,
6507: l_prim_change_flag, -- l_prim_change_flag,
6508: l_sys_status_type, -- p_per_sys_st,