61: g_ntfDocText varchar2(30) := wf_notification.doc_text;
62: g_ntfDocHtml varchar2(30) := wf_notification.doc_html;
63:
64: -- <
65: g_base_language v$nls_parameters.value%TYPE ;
66: g_base_territory v$nls_parameters.value%TYPE ;
67: g_base_codeset v$nls_parameters.value%TYPE ;
68:
69: -- << sstomar>> : Initialization can be done by using
62: g_ntfDocHtml varchar2(30) := wf_notification.doc_html;
63:
64: -- <
65: g_base_language v$nls_parameters.value%TYPE ;
66: g_base_territory v$nls_parameters.value%TYPE ;
67: g_base_codeset v$nls_parameters.value%TYPE ;
68:
69: -- << sstomar>> : Initialization can be done by using
70: -- variables from wf_core.nls_date_format,
63:
64: -- <
65: g_base_language v$nls_parameters.value%TYPE ;
66: g_base_territory v$nls_parameters.value%TYPE ;
67: g_base_codeset v$nls_parameters.value%TYPE ;
68:
69: -- << sstomar>> : Initialization can be done by using
70: -- variables from wf_core.nls_date_format,
71: -- wf_core.nls_date_language etc. but since
70: -- variables from wf_core.nls_date_format,
71: -- wf_core.nls_date_language etc. but since
72: -- when calling WF_NOTIFICATION_UTIL.set/getNLSContext to retrieve
73: -- defaul NLS Language etc. we can define vars. here also.
74: g_base_nlsDateFormat v$nls_parameters.value%TYPE := wf_core.nls_date_format;
75: g_base_nlsDateLanguage v$nls_parameters.value%TYPE := wf_core.nls_date_language;
76: g_base_nlsCalendar v$nls_parameters.value%TYPE := wf_core.nls_calendar;
77: g_base_nlsSort v$nls_parameters.value%TYPE := wf_core.nls_sort ;
78: g_base_nlsNumericCharacters v$nls_parameters.value%TYPE := wf_core.nls_numeric_characters;
71: -- wf_core.nls_date_language etc. but since
72: -- when calling WF_NOTIFICATION_UTIL.set/getNLSContext to retrieve
73: -- defaul NLS Language etc. we can define vars. here also.
74: g_base_nlsDateFormat v$nls_parameters.value%TYPE := wf_core.nls_date_format;
75: g_base_nlsDateLanguage v$nls_parameters.value%TYPE := wf_core.nls_date_language;
76: g_base_nlsCalendar v$nls_parameters.value%TYPE := wf_core.nls_calendar;
77: g_base_nlsSort v$nls_parameters.value%TYPE := wf_core.nls_sort ;
78: g_base_nlsNumericCharacters v$nls_parameters.value%TYPE := wf_core.nls_numeric_characters;
79:
72: -- when calling WF_NOTIFICATION_UTIL.set/getNLSContext to retrieve
73: -- defaul NLS Language etc. we can define vars. here also.
74: g_base_nlsDateFormat v$nls_parameters.value%TYPE := wf_core.nls_date_format;
75: g_base_nlsDateLanguage v$nls_parameters.value%TYPE := wf_core.nls_date_language;
76: g_base_nlsCalendar v$nls_parameters.value%TYPE := wf_core.nls_calendar;
77: g_base_nlsSort v$nls_parameters.value%TYPE := wf_core.nls_sort ;
78: g_base_nlsNumericCharacters v$nls_parameters.value%TYPE := wf_core.nls_numeric_characters;
79:
80: g_WebMail_PostScript_Msg varchar2(1024);
73: -- defaul NLS Language etc. we can define vars. here also.
74: g_base_nlsDateFormat v$nls_parameters.value%TYPE := wf_core.nls_date_format;
75: g_base_nlsDateLanguage v$nls_parameters.value%TYPE := wf_core.nls_date_language;
76: g_base_nlsCalendar v$nls_parameters.value%TYPE := wf_core.nls_calendar;
77: g_base_nlsSort v$nls_parameters.value%TYPE := wf_core.nls_sort ;
78: g_base_nlsNumericCharacters v$nls_parameters.value%TYPE := wf_core.nls_numeric_characters;
79:
80: g_WebMail_PostScript_Msg varchar2(1024);
81:
74: g_base_nlsDateFormat v$nls_parameters.value%TYPE := wf_core.nls_date_format;
75: g_base_nlsDateLanguage v$nls_parameters.value%TYPE := wf_core.nls_date_language;
76: g_base_nlsCalendar v$nls_parameters.value%TYPE := wf_core.nls_calendar;
77: g_base_nlsSort v$nls_parameters.value%TYPE := wf_core.nls_sort ;
78: g_base_nlsNumericCharacters v$nls_parameters.value%TYPE := wf_core.nls_numeric_characters;
79:
80: g_WebMail_PostScript_Msg varchar2(1024);
81:
82: -- Bug 10202313: global variables to store status, mail_status of WF_NOTIFICATIONS table