2147:
2148: -- n_due_date_text := to_char(n_due_date, Wf_Notification.g_nls_date_mask);
2149: -- n_start_date_text := to_char(n_start_date, Wf_Notification.g_nls_date_mask);
2150: --
2151: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);
2152: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);
2153:
2154: n_end_date_text := wf_notification_util.GetCalendarDate(n_nid, n_end_date, null, true);
2155:
2148: -- n_due_date_text := to_char(n_due_date, Wf_Notification.g_nls_date_mask);
2149: -- n_start_date_text := to_char(n_start_date, Wf_Notification.g_nls_date_mask);
2150: --
2151: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);
2152: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);
2153:
2154: n_end_date_text := wf_notification_util.GetCalendarDate(n_nid, n_end_date, null, true);
2155:
2156: if (n_priority > 66) then
2150: --
2151: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);
2152: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);
2153:
2154: n_end_date_text := wf_notification_util.GetCalendarDate(n_nid, n_end_date, null, true);
2155:
2156: if (n_priority > 66) then
2157: --Bug 2774891 fix - sacsharm
2158: --n_priority_text := wf_core.substitute('WFTKN', 'HIGH');
3545: -- n_due_date_text := to_char(n_due_date, Wf_Notification.g_nls_date_mask);
3546: -- n_start_date_text := to_char(n_start_date, Wf_Notification.g_nls_date_mask);
3547:
3548: --<< sstomar>: NLS changes, bug 7578922
3549: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);
3550: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);
3551: n_end_date_text := wf_notification_util.GetCalendarDate(n_nid, n_end_date, null, true);
3552:
3553: if (n_priority > 66) then
3546: -- n_start_date_text := to_char(n_start_date, Wf_Notification.g_nls_date_mask);
3547:
3548: --<< sstomar>: NLS changes, bug 7578922
3549: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);
3550: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);
3551: n_end_date_text := wf_notification_util.GetCalendarDate(n_nid, n_end_date, null, true);
3552:
3553: if (n_priority > 66) then
3554: --Bug 2774891 fix - sacsharm
3547:
3548: --<< sstomar>: NLS changes, bug 7578922
3549: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);
3550: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);
3551: n_end_date_text := wf_notification_util.GetCalendarDate(n_nid, n_end_date, null, true);
3552:
3553: if (n_priority > 66) then
3554: --Bug 2774891 fix - sacsharm
3555: --n_priority_text := wf_core.substitute('WFTKN', 'HIGH');
7486: -- <
7487: -- WF_MAIL.GetSessionLanguage(l_base_lang, l_base_terr, l_base_codeset);
7488: -- Note: we should AVOID to call below API here
7489: -- use global variables instead .
7490: WF_NOTIFICATION_UTIL.getNLSContext(
7491: l_base_lang ,
7492: l_base_terr ,
7493: l_base_codeset ,
7494: l_base_nlsDateFormat ,
8034: -- << sstomar>: The content of this warning ntf emil
8035: -- are generated by Mailer, so other NLS parameters ( NLS_DATE_FORMAT etc.
8036: -- because we don;t have any such attributes in message body)
8037: -- are not required to SET/ RESET but if we want to use centralized API
8038: -- wf_notification_util.setNLSContext / getNLSContext then we need to modify.
8039: --
8040:
8041: -- getting the language for the session
8042: wf_notification.getnlslanguage(l_orig_lang, l_orig_terr, l_orig_chrs);