4821: --l_effective_date := TRUNC (TO_DATE (p_effective_date, 'YYYY/MM/DD HH24:MI:SS'));
4822: write_m ('l_effective_date is ' || l_effective_date);
4823: g_actn := 'Put row in fnd_sessions...';
4824: WRITE (g_actn);
4825: write_h ('dt_fndate.change_ses_date with ' || l_effective_date);
4826: dt_fndate.change_ses_date (p_ses_date => l_effective_date, p_commit => l_commit);
4827:
4828: IF (l_commit = 1)
4829: THEN
4822: write_m ('l_effective_date is ' || l_effective_date);
4823: g_actn := 'Put row in fnd_sessions...';
4824: WRITE (g_actn);
4825: write_h ('dt_fndate.change_ses_date with ' || l_effective_date);
4826: dt_fndate.change_ses_date (p_ses_date => l_effective_date, p_commit => l_commit);
4827:
4828: IF (l_commit = 1)
4829: THEN
4830: write_h ('The session date is committed...');
5075: write_h ('================================================');
5076: write_m ('l_effective_date is ' || l_effective_date);
5077: g_actn := 'Put row in fnd_sessions...';
5078: WRITE (g_actn);
5079: write_h ('dt_fndate.change_ses_date with ' || l_effective_date);
5080: dt_fndate.change_ses_date (p_ses_date => l_effective_date, p_commit => l_commit);
5081: write_h ('Commit value for dt_fndate is ' || l_commit);
5082:
5083: IF (l_commit = 1)
5076: write_m ('l_effective_date is ' || l_effective_date);
5077: g_actn := 'Put row in fnd_sessions...';
5078: WRITE (g_actn);
5079: write_h ('dt_fndate.change_ses_date with ' || l_effective_date);
5080: dt_fndate.change_ses_date (p_ses_date => l_effective_date, p_commit => l_commit);
5081: write_h ('Commit value for dt_fndate is ' || l_commit);
5082:
5083: IF (l_commit = 1)
5084: THEN
5077: g_actn := 'Put row in fnd_sessions...';
5078: WRITE (g_actn);
5079: write_h ('dt_fndate.change_ses_date with ' || l_effective_date);
5080: dt_fndate.change_ses_date (p_ses_date => l_effective_date, p_commit => l_commit);
5081: write_h ('Commit value for dt_fndate is ' || l_commit);
5082:
5083: IF (l_commit = 1)
5084: THEN
5085: write_h ('The session date is committed...');