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