232: OR (FND_RELEASE.MAJOR_VERSION > 12)
233: )
234: THEN
235: l_action_date_text := ''
236: || to_char(hrec.Action_Date,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),'NLS_CALENDAR = '''
237: || nvl ( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id) , 'GREGORIAN' ) || '''')
238: || '';
239:
240: ELSE
233: )
234: THEN
235: l_action_date_text := ''
236: || to_char(hrec.Action_Date,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),'NLS_CALENDAR = '''
237: || nvl ( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id) , 'GREGORIAN' ) || '''')
238: || '';
239:
240: ELSE
241: l_action_date_text := fnd_date.date_to_displaydate(hrec.Action_Date,2);