DBA Data[Home] [Help]

APPS.WF_XML dependencies on V$NLS_PARAMETERS

Line 65: g_base_language v$nls_parameters.value%TYPE ;

61: g_ntfDocText varchar2(30) := wf_notification.doc_text;
62: g_ntfDocHtml varchar2(30) := wf_notification.doc_html;
63:
64: -- < : nls changes
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

Line 66: g_base_territory v$nls_parameters.value%TYPE ;

62: g_ntfDocHtml varchar2(30) := wf_notification.doc_html;
63:
64: -- < : nls changes
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,

Line 67: g_base_codeset v$nls_parameters.value%TYPE ;

63:
64: -- < : nls changes
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

Line 74: g_base_nlsDateFormat v$nls_parameters.value%TYPE := wf_core.nls_date_format;

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;

Line 75: g_base_nlsDateLanguage v$nls_parameters.value%TYPE := wf_core.nls_date_language;

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:

Line 76: g_base_nlsCalendar v$nls_parameters.value%TYPE := wf_core.nls_calendar;

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);

Line 77: g_base_nlsSort v$nls_parameters.value%TYPE := wf_core.nls_sort ;

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:

Line 78: g_base_nlsNumericCharacters v$nls_parameters.value%TYPE := wf_core.nls_numeric_characters;

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