255: or (FND_RELEASE.MAJOR_VERSION > 12) then
256: if (display_type = wf_notification.doc_html) then
257: l_action_date := '' ||
258: to_char(rec.action_date ,
259: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
260: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || '''') /* Modified for Bug 8974192 */
261: || '';
262: else
263: l_action_date := to_char(rec.action_date ,
256: if (display_type = wf_notification.doc_html) then
257: l_action_date := '' ||
258: to_char(rec.action_date ,
259: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
260: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || '''') /* Modified for Bug 8974192 */
261: || '';
262: else
263: l_action_date := to_char(rec.action_date ,
264: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
260: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || '''') /* Modified for Bug 8974192 */
261: || '';
262: else
263: l_action_date := to_char(rec.action_date ,
264: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
265: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || ''''); /* Modified for Bug 8974192 */
266: end if;
267: else
268: l_action_date := to_char(rec.action_date);
261: || '';
262: else
263: l_action_date := to_char(rec.action_date ,
264: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
265: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || ''''); /* Modified for Bug 8974192 */
266: end if;
267: else
268: l_action_date := to_char(rec.action_date);
269: end if;
388: or (FND_RELEASE.MAJOR_VERSION > 12) then
389: if (display_type = wf_notification.doc_html) then
390: l_action_date := '' ||
391: to_char(rec.action_date ,
392: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
393: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || '''') /* Modified for Bug 8974192 */
394: || '';
395: else
396: l_action_date := to_char(rec.action_date ,
389: if (display_type = wf_notification.doc_html) then
390: l_action_date := '' ||
391: to_char(rec.action_date ,
392: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
393: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || '''') /* Modified for Bug 8974192 */
394: || '';
395: else
396: l_action_date := to_char(rec.action_date ,
397: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
393: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || '''') /* Modified for Bug 8974192 */
394: || '';
395: else
396: l_action_date := to_char(rec.action_date ,
397: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
398: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || ''''); /* Modified for Bug 8974192 */
399: end if;
400: else
401: l_action_date := to_char(rec.action_date);
394: || '';
395: else
396: l_action_date := to_char(rec.action_date ,
397: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
398: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || ''''); /* Modified for Bug 8974192 */
399: end if;
400: else
401: l_action_date := to_char(rec.action_date);
402: end if;
426: or (FND_RELEASE.MAJOR_VERSION > 12) then
427: if (display_type = wf_notification.doc_html) then
428: l_action_date := '' ||
429: to_char(rec.action_date ,
430: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
431: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || '''') /* Modified for Bug 8974192 */
432: || '';
433: else
434: l_action_date := to_char(rec.action_date ,
427: if (display_type = wf_notification.doc_html) then
428: l_action_date := '' ||
429: to_char(rec.action_date ,
430: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
431: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || '''') /* Modified for Bug 8974192 */
432: || '';
433: else
434: l_action_date := to_char(rec.action_date ,
435: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
431: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || '''') /* Modified for Bug 8974192 */
432: || '';
433: else
434: l_action_date := to_char(rec.action_date ,
435: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
436: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || ''''); /* Modified for Bug 8974192 */
437: end if;
438: else
439: l_action_date := to_char(rec.action_date);
432: || '';
433: else
434: l_action_date := to_char(rec.action_date ,
435: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', G_user_id),
436: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', G_user_id),'GREGORIAN') || ''''); /* Modified for Bug 8974192 */
437: end if;
438: else
439: l_action_date := to_char(rec.action_date);
440: end if;