3930: --l_effective_date := TRUNC (TO_DATE (p_effective_date, 'YYYY/MM/DD HH24:MI:SS'));
3931: write_m ('l_effective_date is ' || l_effective_date);
3932: g_actn := 'Put row in fnd_sessions...';
3933: WRITE (g_actn);
3934: write_h ('dt_fndate.change_ses_date with ' || l_effective_date);
3935: dt_fndate.change_ses_date (p_ses_date => l_effective_date, p_commit => l_commit);
3936:
3937: IF (l_commit = 1)
3938: THEN
3931: write_m ('l_effective_date is ' || l_effective_date);
3932: g_actn := 'Put row in fnd_sessions...';
3933: WRITE (g_actn);
3934: write_h ('dt_fndate.change_ses_date with ' || l_effective_date);
3935: dt_fndate.change_ses_date (p_ses_date => l_effective_date, p_commit => l_commit);
3936:
3937: IF (l_commit = 1)
3938: THEN
3939: write_h ('The session date is committed...');
4194: write_h ('================================================');
4195: write_m ('l_effective_date is ' || l_effective_date);
4196: g_actn := 'Put row in fnd_sessions...';
4197: WRITE (g_actn);
4198: write_h ('dt_fndate.change_ses_date with ' || l_effective_date);
4199: dt_fndate.change_ses_date (p_ses_date => l_effective_date, p_commit => l_commit);
4200: write_h ('Commit value for dt_fndate is ' || l_commit);
4201:
4202: IF (l_commit = 1)
4195: write_m ('l_effective_date is ' || l_effective_date);
4196: g_actn := 'Put row in fnd_sessions...';
4197: WRITE (g_actn);
4198: write_h ('dt_fndate.change_ses_date with ' || l_effective_date);
4199: dt_fndate.change_ses_date (p_ses_date => l_effective_date, p_commit => l_commit);
4200: write_h ('Commit value for dt_fndate is ' || l_commit);
4201:
4202: IF (l_commit = 1)
4203: THEN
4196: g_actn := 'Put row in fnd_sessions...';
4197: WRITE (g_actn);
4198: write_h ('dt_fndate.change_ses_date with ' || l_effective_date);
4199: dt_fndate.change_ses_date (p_ses_date => l_effective_date, p_commit => l_commit);
4200: write_h ('Commit value for dt_fndate is ' || l_commit);
4201:
4202: IF (l_commit = 1)
4203: THEN
4204: write_h ('The session date is committed...');