eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_MAIL dependencies on WF_NOTIFICATION_UTIL

Line 1304: -- <> : Due to boolean flag, wf_notification_util.GetCalendarDate can not be used.

1300: -- 'DATE', decode(WMA.FORMAT,
1301: -- '', to_char(WNA.DATE_VALUE),
1302: -- to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1303: --
1304: -- <> : Due to boolean flag, wf_notification_util.GetCalendarDate can not be used.
1305: --'DATE', wf_notification_util.GetCalendarDate(p_nid=>nid, p_date=>WNA.DATE_VALUE, p_date_format=>WMA.FORMAT),
1306: 'LOOKUP', WNA.TEXT_VALUE,
1307: WNA.TEXT_VALUE) VALUE,
1308: WNA.DATE_VALUE -- value is Date type <

Line 1305: --'DATE', wf_notification_util.GetCalendarDate(p_nid=>nid, p_date=>WNA.DATE_VALUE, p_date_format=>WMA.FORMAT),

1301: -- '', to_char(WNA.DATE_VALUE),
1302: -- to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1303: --
1304: -- <> : Due to boolean flag, wf_notification_util.GetCalendarDate can not be used.
1305: --'DATE', wf_notification_util.GetCalendarDate(p_nid=>nid, p_date=>WNA.DATE_VALUE, p_date_format=>WMA.FORMAT),
1306: 'LOOKUP', WNA.TEXT_VALUE,
1307: WNA.TEXT_VALUE) VALUE,
1308: WNA.DATE_VALUE -- value is Date type <
1309: from WF_NOTIFICATION_ATTRIBUTES WNA,

Line 1343: buffer := buffer || wf_notification_util.GetCalendarDate(nid, rec.DATE_VALUE, rec.format, false)

1339: wf_mail.g_close_text_delimiter || g_newLine ||
1340: GetLovList(rec.format);
1341: ELSIF (rec.type = 'DATE' AND rec.DATE_VALUE is not null) then
1342: -- < : use DATE_VALUE
1343: buffer := buffer || wf_notification_util.GetCalendarDate(nid, rec.DATE_VALUE, rec.format, false)
1344: || wf_mail.g_close_text_delimiter
1345: || g_newLine;
1346: else
1347: -- VARCHAR2, NUMBER, : use value directly.

Line 1382: -- 'DATE', wf_notification_util.GetCalendarDate(nid, WNA.DATE_VALUE, WMA.FORMAT, true),

1378: to_char(WNA.NUMBER_VALUE, WMA.FORMAT)),
1379: --'DATE', decode(WMA.FORMAT,
1380: -- '', to_char(WNA.DATE_VALUE),
1381: -- to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1382: -- 'DATE', wf_notification_util.GetCalendarDate(nid, WNA.DATE_VALUE, WMA.FORMAT, true),
1383: 'LOOKUP', WNA.TEXT_VALUE,
1384: WNA.TEXT_VALUE) VALUE,
1385: WNA.DATE_VALUE
1386: from WF_NOTIFICATION_ATTRIBUTES WNA,

Line 1985: -- 'DATE', wf_notification_util.GetCalendarDate(nid, WNA.DATE_VALUE, WMA.FORMAT, true),

1981: --'DATE', decode(WMA.FORMAT,
1982: -- '', to_char(WNA.DATE_VALUE),
1983: -- to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1984: -- <> bug 8430385
1985: -- 'DATE', wf_notification_util.GetCalendarDate(nid, WNA.DATE_VALUE, WMA.FORMAT, true),
1986: --
1987: 'LOOKUP', WNA.TEXT_VALUE,
1988: WNA.TEXT_VALUE) VALUE,
1989: WNA.DATE_VALUE -- << sstomar: bug8430385 >>

Line 2046: || wf_notification_util.GetCalendarDate(nid, rec.DATE_VALUE, rec.FORMAT, false)

2042:
2043: -- <> bug8430385
2044: elsif (rec.type = 'DATE' AND rec.DATE_VALUE is not null) THEN
2045: str_buffer := str_buffer
2046: || wf_notification_util.GetCalendarDate(nid, rec.DATE_VALUE, rec.FORMAT, false)
2047: || wf_mail.g_close_html_delimiter
2048: || g_newLine;
2049: else
2050: -- NOTE: <> we can handle DATE type Attr. here also, if required.

Line 2305: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);

2301:
2302: -- n_due_date_text := to_char(n_due_date, Wf_Notification.g_nls_date_mask);
2303: -- n_start_date_text := to_char(n_start_date, Wf_Notification.g_nls_date_mask);
2304: -- >: 7578922
2305: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);
2306: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);
2307:
2308: n_end_date_text := wf_notification_util.GetCalendarDate(n_nid, n_end_date, null, true);
2309:

Line 2306: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);

2302: -- n_due_date_text := to_char(n_due_date, Wf_Notification.g_nls_date_mask);
2303: -- n_start_date_text := to_char(n_start_date, Wf_Notification.g_nls_date_mask);
2304: -- >: 7578922
2305: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);
2306: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);
2307:
2308: n_end_date_text := wf_notification_util.GetCalendarDate(n_nid, n_end_date, null, true);
2309:
2310: if (n_priority > 66) then

Line 2308: n_end_date_text := wf_notification_util.GetCalendarDate(n_nid, n_end_date, null, true);

2304: -- >: 7578922
2305: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);
2306: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);
2307:
2308: n_end_date_text := wf_notification_util.GetCalendarDate(n_nid, n_end_date, null, true);
2309:
2310: if (n_priority > 66) then
2311: --Bug 2774891 fix - sacsharm
2312: --n_priority_text := wf_core.substitute('WFTKN', 'HIGH');

Line 3703: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);

3699: -- n_due_date_text := to_char(n_due_date, Wf_Notification.g_nls_date_mask);
3700: -- n_start_date_text := to_char(n_start_date, Wf_Notification.g_nls_date_mask);
3701:
3702: --<< sstomar>: NLS changes, bug 7578922
3703: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);
3704: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);
3705: n_end_date_text := wf_notification_util.GetCalendarDate(n_nid, n_end_date, null, true);
3706:
3707: if (n_priority > 66) then

Line 3704: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);

3700: -- n_start_date_text := to_char(n_start_date, Wf_Notification.g_nls_date_mask);
3701:
3702: --<< sstomar>: NLS changes, bug 7578922
3703: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);
3704: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);
3705: n_end_date_text := wf_notification_util.GetCalendarDate(n_nid, n_end_date, null, true);
3706:
3707: if (n_priority > 66) then
3708: --Bug 2774891 fix - sacsharm

Line 3705: n_end_date_text := wf_notification_util.GetCalendarDate(n_nid, n_end_date, null, true);

3701:
3702: --<< sstomar>: NLS changes, bug 7578922
3703: n_due_date_text := wf_notification_util.GetCalendarDate(n_nid, n_due_date, null, true);
3704: n_start_date_text := wf_notification_util.GetCalendarDate(n_nid, n_start_date, null, true);
3705: n_end_date_text := wf_notification_util.GetCalendarDate(n_nid, n_end_date, null, true);
3706:
3707: if (n_priority > 66) then
3708: --Bug 2774891 fix - sacsharm
3709: --n_priority_text := wf_core.substitute('WFTKN', 'HIGH');

Line 7779: WF_NOTIFICATION_UTIL.getNLSContext(

7775: -- <> :
7776: -- WF_MAIL.GetSessionLanguage(l_base_lang, l_base_terr, l_base_codeset);
7777: -- Note: we should AVOID to call below API here
7778: -- use global variables instead .
7779: WF_NOTIFICATION_UTIL.getNLSContext(
7780: l_base_lang ,
7781: l_base_terr ,
7782: l_base_codeset ,
7783: l_base_nlsDateFormat ,

Line 8357: -- wf_notification_util.setNLSContext / getNLSContext then we need to modify.

8353: -- << sstomar>: The content of this warning ntf emil
8354: -- are generated by Mailer, so other NLS parameters ( NLS_DATE_FORMAT etc.
8355: -- because we don;t have any such attributes in message body)
8356: -- are not required to SET/ RESET but if we want to use centralized API
8357: -- wf_notification_util.setNLSContext / getNLSContext then we need to modify.
8358: --
8359:
8360: -- getting the language for the session
8361: wf_notification.getnlslanguage(l_orig_lang, l_orig_terr, l_orig_chrs);