APPS.WF_XML dependencies on WF_NOTIFICATION_UTIL

Line 74: -- when calling WF_NOTIFICATION_UTIL.set/getNLSContext to retrieve

70:
71: -- << sstomar>> : Initialization can be done by using
72: -- variables from wf_core.nls_date_format,
73: -- wf_core.nls_date_language etc. but since
74: -- when calling WF_NOTIFICATION_UTIL.set/getNLSContext to retrieve
75: -- defaul NLS Language etc. we can define vars. here also.
76: g_base_nlsDateFormat v$nls_parameters.value%TYPE := wf_core.nls_date_format;
77: g_base_nlsDateLanguage v$nls_parameters.value%TYPE := wf_core.nls_date_language;
78: g_base_nlsCalendar v$nls_parameters.value%TYPE := wf_core.nls_calendar;

Line 3459: WF_NOTIFICATION_UTIL.SetNLSContext(nid,

3455: nvl(l_nlsSort, wf_core.nls_sort) <> g_base_nlsSort ) then
3456:
3457: -- nid, l_nlsCalendar, just set here only.
3458: -- at other places pass value as null.
3459: WF_NOTIFICATION_UTIL.SetNLSContext(nid,
3460: l_nlsLanguage ,
3461: l_nlsTerritory ,
3462: l_nlsDateFormat ,
3463: l_nlsDateLanguage ,

Line 3472: -- are being used in WF_NOTIFICATION_UTIL.GetCalendarDate

3468: l_context_changed := true;
3469: else
3470:
3471: -- No need to SET context but set NID, Calendar as these two parameters
3472: -- are being used in WF_NOTIFICATION_UTIL.GetCalendarDate
3473: WF_NOTIFICATION_UTIL.setCurrentNID(nid);
3474: WF_NOTIFICATION_UTIL.setCurrentCalendar(l_nlsCalendar);
3475:
3476: END if;

Line 3473: WF_NOTIFICATION_UTIL.setCurrentNID(nid);

3469: else
3470:
3471: -- No need to SET context but set NID, Calendar as these two parameters
3472: -- are being used in WF_NOTIFICATION_UTIL.GetCalendarDate
3473: WF_NOTIFICATION_UTIL.setCurrentNID(nid);
3474: WF_NOTIFICATION_UTIL.setCurrentCalendar(l_nlsCalendar);
3475:
3476: END if;
3477:

Line 3474: WF_NOTIFICATION_UTIL.setCurrentCalendar(l_nlsCalendar);

3470:
3471: -- No need to SET context but set NID, Calendar as these two parameters
3472: -- are being used in WF_NOTIFICATION_UTIL.GetCalendarDate
3473: WF_NOTIFICATION_UTIL.setCurrentNID(nid);
3474: WF_NOTIFICATION_UTIL.setCurrentCalendar(l_nlsCalendar);
3475:
3476: END if;
3477:
3478:

Line 3539: -- <> : keep WF_NOTIFICATION_UTIL.g_nid and g_calendar in global variable

3535: -- TODO : need to check above case.
3536: if(l_context_changed ) then
3537:
3538: -- set nid, calendar once only.
3539: -- <> : keep WF_NOTIFICATION_UTIL.g_nid and g_calendar in global variable
3540: -- during life-life cycle of this API.
3541: WF_NOTIFICATION_UTIL.SetNLSContext(
3542: nid,
3543: g_base_language ,

Line 3541: WF_NOTIFICATION_UTIL.SetNLSContext(

3537:
3538: -- set nid, calendar once only.
3539: -- <> : keep WF_NOTIFICATION_UTIL.g_nid and g_calendar in global variable
3540: -- during life-life cycle of this API.
3541: WF_NOTIFICATION_UTIL.SetNLSContext(
3542: nid,
3543: g_base_language ,
3544: g_base_territory ,
3545: g_base_nlsDateFormat ,

Line 3572: if(WF_NOTIFICATION_UTIL.isLanguageInstalled(l_nlsDateLanguage)) then

3568: -- <> : NLS changes, bug 7578922
3569: AddElementAttribute('nlsDateformat', l_nlsDateFormat, attrlist);
3570:
3571: -- << REMOVE validation later> we can validate if date_language is installed or not.
3572: if(WF_NOTIFICATION_UTIL.isLanguageInstalled(l_nlsDateLanguage)) then
3573: AddElementAttribute('nlsDateLanguage', l_nlsDateLanguage, attrlist);
3574: else
3575: AddElementAttribute('nlsDateLanguage', l_nlsLanguage, attrlist);
3576: end if;

Line 3957: WF_NOTIFICATION_UTIL.SetNLSContext(

3953: -- SetNLS(l_nlsLanguage, l_nlsTerritory);
3954: if(l_context_changed ) then
3955:
3956: -- l_nlsCalendar only will be stored in global variable
3957: WF_NOTIFICATION_UTIL.SetNLSContext(
3958: nid,
3959: l_nlsLanguage ,
3960: l_nlsTerritory ,
3961: l_nlsDateFormat ,

Line 4008: WF_NOTIFICATION_UTIL.SetNLSContext

4004: -- SetNLS(g_base_language, g_base_territory);
4005: -- Reset base language
4006: if( l_context_changed ) then
4007:
4008: WF_NOTIFICATION_UTIL.SetNLSContext
4009: (null, -- Resetting null for Nid is fine.
4010: g_base_language ,
4011: g_base_territory ,
4012: g_base_nlsDateFormat ,

Line 4051: WF_NOTIFICATION_UTIL.SetNLSContext(

4047:
4048: -- Reset base language, in case of exception.
4049: -- SetNLS(g_base_language, g_base_territory);
4050: -- Reset base language
4051: WF_NOTIFICATION_UTIL.SetNLSContext(
4052: null,
4053: g_base_language ,
4054: g_base_territory ,
4055: g_base_nlsDateFormat ,

Line 4610: WF_NOTIFICATION_UTIL.SetNLSContext(0,

4606: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> g_base_nlsNumericCharacters or
4607: nvl(l_nlsSort, wf_core.nls_sort) <> g_base_nlsSort ) then
4608:
4609:
4610: WF_NOTIFICATION_UTIL.SetNLSContext(0,
4611: l_nlsLanguage ,
4612: l_nlsTerritory ,
4613: l_nlsDateFormat ,
4614: l_nlsDateLanguage ,

Line 4650: WF_NOTIFICATION_UTIL.SetNLSContext(

4646:
4647: -- Reset base NLS Context
4648: if( l_context_changed ) then
4649:
4650: WF_NOTIFICATION_UTIL.SetNLSContext(
4651: null,
4652: g_base_language ,
4653: g_base_territory ,
4654: g_base_nlsDateFormat ,

Line 4818: WF_NOTIFICATION_UTIL.SetNLSContext(

4814: wf_temp_lob.releaseLob(g_LOBTable, messageIdx);
4815: end if;
4816:
4817: -- Reset base NLS Context in case of any EXCEPTION
4818: WF_NOTIFICATION_UTIL.SetNLSContext(
4819: null,
4820: g_base_language ,
4821: g_base_territory ,
4822: g_base_nlsDateFormat ,

Line 5068: WF_NOTIFICATION_UTIL.getNLSContext(

5064: g_base_nlsNumericCharacters is NULL OR
5065: g_base_nlsSort is NULL
5066: ) then
5067:
5068: WF_NOTIFICATION_UTIL.getNLSContext(
5069: g_base_language ,
5070: g_base_territory ,
5071: g_base_codeset ,
5072: g_base_nlsDateFormat ,

Line 5104: WF_NOTIFICATION_UTIL.SetNLSContext(null,

5100: when others then
5101: wf_core.context('WF_XML','Generate',p_event_name, p_event_key);
5102:
5103: -- RESET BASSE LANGUAGE
5104: WF_NOTIFICATION_UTIL.SetNLSContext(null,
5105: g_base_language ,
5106: g_base_territory ,
5107: g_base_nlsDateFormat ,
5108: g_base_nlsDateLanguage ,