DBA Data[Home] [Help]

APPS.HR_PERIODS_OF_SERVICE_API dependencies on PER_PDS_SHD

Line 453: l_old_final_process_date := per_pds_shd.g_old_rec.final_process_date;

449: --
450: --
451: -- Retain old value of FPD
452: --
453: l_old_final_process_date := per_pds_shd.g_old_rec.final_process_date;
454: --
455: -- Handle maintenance of records linked to PDS
456: --
457: move_term_assignments(p_period_of_service_id => p_period_of_service_id

Line 468: if per_pds_shd.g_old_rec.actual_termination_date is not null

464: --
465: -- 115.9 (END)
466: --
467:
468: if per_pds_shd.g_old_rec.actual_termination_date is not null
469: then
470: --
471: -- Fix for bug 3882918. check with nvl for the leaving_reason.
472: --

Line 475: if nvl(per_pds_shd.g_old_rec.leaving_reason, hr_api.g_varchar2)

471: -- Fix for bug 3882918. check with nvl for the leaving_reason.
472: --
473: hr_utility.set_location('Update_pds_details ',800);
474: --
475: if nvl(per_pds_shd.g_old_rec.leaving_reason, hr_api.g_varchar2)
476: <> nvl(p_leaving_reason,hr_api.g_varchar2)
477: then
478: --
479: -- Fix for bug 3882918. If this proc is called without leaving_reason parameter

Line 489: (per_pds_shd.g_old_rec.actual_termination_date > SYSDATE) THEN

485: -- Bug number 4900409 - validating actual termination date cannot be future date
486: -- if leaving reason is 'D' Deceased
487:
488: IF nvl(p_leaving_reason,hr_api.g_varchar2)='D' AND
489: (per_pds_shd.g_old_rec.actual_termination_date > SYSDATE) THEN
490:
491: hr_utility.set_location('Update_pds_details ',812);
492: fnd_message.set_name('PER','PER_449766_NO_FUT_ACTUAL_TERM');
493: fnd_message.raise_error;

Line 506: nvl(per_pds_shd.g_old_rec.leaving_reason, hr_api.g_varchar2) <> 'R' )

502: --
503: hr_utility.set_location('Update_pds_details ',820);
504: --
505: if (nvl(p_leaving_reason, hr_api.g_varchar2) = 'R' and
506: nvl(per_pds_shd.g_old_rec.leaving_reason, hr_api.g_varchar2) <> 'R' )
507: then
508:
509: hr_utility.set_location('Update_pds_details ',900);
510:

Line 512: (p_person_id => per_pds_shd.g_old_rec.person_id

508:
509: hr_utility.set_location('Update_pds_details ',900);
510:
511: hr_per_type_usage_internal.create_person_type_usage
512: (p_person_id => per_pds_shd.g_old_rec.person_id
513: ,p_person_type_id =>
514: hr_person_type_usage_info.get_default_person_type_id
515: (p_business_group_id => per_pds_shd.g_old_rec.business_group_id
516: ,p_system_person_type => 'RETIREE')

Line 515: (p_business_group_id => per_pds_shd.g_old_rec.business_group_id

511: hr_per_type_usage_internal.create_person_type_usage
512: (p_person_id => per_pds_shd.g_old_rec.person_id
513: ,p_person_type_id =>
514: hr_person_type_usage_info.get_default_person_type_id
515: (p_business_group_id => per_pds_shd.g_old_rec.business_group_id
516: ,p_system_person_type => 'RETIREE')
517: ,p_effective_date => per_pds_shd.g_old_rec.actual_termination_date+1
518: ,p_person_type_usage_id => l_person_type_usage_id
519: ,p_object_version_number=> l_ptu_object_version_number

Line 517: ,p_effective_date => per_pds_shd.g_old_rec.actual_termination_date+1

513: ,p_person_type_id =>
514: hr_person_type_usage_info.get_default_person_type_id
515: (p_business_group_id => per_pds_shd.g_old_rec.business_group_id
516: ,p_system_person_type => 'RETIREE')
517: ,p_effective_date => per_pds_shd.g_old_rec.actual_termination_date+1
518: ,p_person_type_usage_id => l_person_type_usage_id
519: ,p_object_version_number=> l_ptu_object_version_number
520: ,p_effective_start_date => l_effective_start_date
521: ,p_effective_end_date => l_effective_end_date);

Line 524: nvl(per_pds_shd.g_old_rec.leaving_reason,hr_api.g_varchar2) = 'R' )

520: ,p_effective_start_date => l_effective_start_date
521: ,p_effective_end_date => l_effective_end_date);
522:
523: elsif (nvl(p_leaving_reason, hr_api.g_varchar2) <> 'R' and
524: nvl(per_pds_shd.g_old_rec.leaving_reason,hr_api.g_varchar2) = 'R' )
525: then
526:
527: hr_utility.set_location('Update_pds_details ',910);
528:

Line 530: (p_effective_date => per_pds_shd.g_old_rec.actual_termination_date+1

526:
527: hr_utility.set_location('Update_pds_details ',910);
528:
529: hr_per_type_usage_internal.maintain_person_type_usage
530: (p_effective_date => per_pds_shd.g_old_rec.actual_termination_date+1
531: ,p_person_id => per_pds_shd.g_old_rec.person_id
532: ,p_person_type_id =>
533: hr_person_type_usage_info.get_default_person_type_id
534: (p_business_group_id => per_pds_shd.g_old_rec.business_group_id

Line 531: ,p_person_id => per_pds_shd.g_old_rec.person_id

527: hr_utility.set_location('Update_pds_details ',910);
528:
529: hr_per_type_usage_internal.maintain_person_type_usage
530: (p_effective_date => per_pds_shd.g_old_rec.actual_termination_date+1
531: ,p_person_id => per_pds_shd.g_old_rec.person_id
532: ,p_person_type_id =>
533: hr_person_type_usage_info.get_default_person_type_id
534: (p_business_group_id => per_pds_shd.g_old_rec.business_group_id
535: ,p_system_person_type => 'RETIREE')

Line 534: (p_business_group_id => per_pds_shd.g_old_rec.business_group_id

530: (p_effective_date => per_pds_shd.g_old_rec.actual_termination_date+1
531: ,p_person_id => per_pds_shd.g_old_rec.person_id
532: ,p_person_type_id =>
533: hr_person_type_usage_info.get_default_person_type_id
534: (p_business_group_id => per_pds_shd.g_old_rec.business_group_id
535: ,p_system_person_type => 'RETIREE')
536: ,p_datetrack_delete_mode => 'ZAP');
537:
538: -- Fix for Bug 5152193 Starts here