159: hr_utility.set_location ('Entering ' || l_proc, 10);
160: -- changing in date format
161: hr_utility.set_location ('Changing date formats ', 20);
162: l_effective_date :=
163: TRUNC (fnd_date.canonical_to_date (p_effective_date));
164: l_from_ocrd_date :=
165: TRUNC (fnd_date.canonical_to_date (p_from_ocrd_date));
166: --
167: -- Put row in fnd_sessions
161: hr_utility.set_location ('Changing date formats ', 20);
162: l_effective_date :=
163: TRUNC (fnd_date.canonical_to_date (p_effective_date));
164: l_from_ocrd_date :=
165: TRUNC (fnd_date.canonical_to_date (p_from_ocrd_date));
166: --
167: -- Put row in fnd_sessions
168: --
169: dt_fndate.change_ses_date (p_ses_date => l_effective_date,
663: --
664: BEGIN
665: hr_utility.set_location ('Entering ' || l_proc, 10);
666: l_effective_date :=
667: TRUNC (fnd_date.canonical_to_date (p_effective_date));
668: --
669: -- Put row in fnd_sessions
670: --
671: dt_fndate.change_ses_date (p_ses_date => l_effective_date,