527: --
528: l_proc varchar2(72) := g_package||'.termination';
529: --
530: l_notice_period_start_date date :=
531: fnd_date.canonical_to_date(p_pds_information8);
532: l_notice_period_end_date date :=
533: fnd_date.canonical_to_date(p_pds_information9);
534: l_last_day_worked date :=
535: fnd_date.canonical_to_date(p_pds_information10);
529: --
530: l_notice_period_start_date date :=
531: fnd_date.canonical_to_date(p_pds_information8);
532: l_notice_period_end_date date :=
533: fnd_date.canonical_to_date(p_pds_information9);
534: l_last_day_worked date :=
535: fnd_date.canonical_to_date(p_pds_information10);
536: --
537: l_notice_period_start_date_o date :=
531: fnd_date.canonical_to_date(p_pds_information8);
532: l_notice_period_end_date date :=
533: fnd_date.canonical_to_date(p_pds_information9);
534: l_last_day_worked date :=
535: fnd_date.canonical_to_date(p_pds_information10);
536: --
537: l_notice_period_start_date_o date :=
538: fnd_date.canonical_to_date(p_pds_information8_o);
539: l_notice_period_end_date_o date :=
534: l_last_day_worked date :=
535: fnd_date.canonical_to_date(p_pds_information10);
536: --
537: l_notice_period_start_date_o date :=
538: fnd_date.canonical_to_date(p_pds_information8_o);
539: l_notice_period_end_date_o date :=
540: fnd_date.canonical_to_date(p_pds_information9_o);
541: l_last_day_worked_o date :=
542: fnd_date.canonical_to_date(p_pds_information10_o);
536: --
537: l_notice_period_start_date_o date :=
538: fnd_date.canonical_to_date(p_pds_information8_o);
539: l_notice_period_end_date_o date :=
540: fnd_date.canonical_to_date(p_pds_information9_o);
541: l_last_day_worked_o date :=
542: fnd_date.canonical_to_date(p_pds_information10_o);
543: --
544: l_object_version_number number;
538: fnd_date.canonical_to_date(p_pds_information8_o);
539: l_notice_period_end_date_o date :=
540: fnd_date.canonical_to_date(p_pds_information9_o);
541: l_last_day_worked_o date :=
542: fnd_date.canonical_to_date(p_pds_information10_o);
543: --
544: l_object_version_number number;
545: l_concatenated_segments varchar2(2000);
546: l_soft_coding_keyflex_id number;