4898: --l_effective_date := TRUNC (TO_DATE (p_effective_date, 'YYYY/MM/DD HH24:MI:SS'));
4899: write_m ('l_effective_date is ' || l_effective_date);
4900: g_actn := 'Put row in fnd_sessions...';
4901: WRITE (g_actn);
4902: write_h ('dt_fndate.change_ses_date with ' || l_effective_date);
4903: dt_fndate.change_ses_date (p_ses_date => l_effective_date, p_commit => l_commit);
4904:
4905: IF (l_commit = 1)
4906: THEN
4899: write_m ('l_effective_date is ' || l_effective_date);
4900: g_actn := 'Put row in fnd_sessions...';
4901: WRITE (g_actn);
4902: write_h ('dt_fndate.change_ses_date with ' || l_effective_date);
4903: dt_fndate.change_ses_date (p_ses_date => l_effective_date, p_commit => l_commit);
4904:
4905: IF (l_commit = 1)
4906: THEN
4907: write_h ('The session date is committed...');
5152: write_h ('================================================');
5153: write_m ('l_effective_date is ' || l_effective_date);
5154: g_actn := 'Put row in fnd_sessions...';
5155: WRITE (g_actn);
5156: write_h ('dt_fndate.change_ses_date with ' || l_effective_date);
5157: dt_fndate.change_ses_date (p_ses_date => l_effective_date, p_commit => l_commit);
5158: write_h ('Commit value for dt_fndate is ' || l_commit);
5159:
5160: IF (l_commit = 1)
5153: write_m ('l_effective_date is ' || l_effective_date);
5154: g_actn := 'Put row in fnd_sessions...';
5155: WRITE (g_actn);
5156: write_h ('dt_fndate.change_ses_date with ' || l_effective_date);
5157: dt_fndate.change_ses_date (p_ses_date => l_effective_date, p_commit => l_commit);
5158: write_h ('Commit value for dt_fndate is ' || l_commit);
5159:
5160: IF (l_commit = 1)
5161: THEN
5154: g_actn := 'Put row in fnd_sessions...';
5155: WRITE (g_actn);
5156: write_h ('dt_fndate.change_ses_date with ' || l_effective_date);
5157: dt_fndate.change_ses_date (p_ses_date => l_effective_date, p_commit => l_commit);
5158: write_h ('Commit value for dt_fndate is ' || l_commit);
5159:
5160: IF (l_commit = 1)
5161: THEN
5162: write_h ('The session date is committed...');