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_XML dependencies on WF_NOTIFICATION_UTIL

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

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

Line 3438: -- Bug 11684796: Comparing user NLS parameters with the NLS parameters in WF_NOTIFICATION_UTIL

3434:
3435: -- set user's language and territory : charset we can not chage for a session at DB layer.
3436: -- setNLS(l_nlsLanguage, l_nlsTerritory);
3437:
3438: -- Bug 11684796: Comparing user NLS parameters with the NLS parameters in WF_NOTIFICATION_UTIL
3439: -- package as WF_NOTIFICATION_UTIL.SetNLSContext() API sets these parameter values only
3440: if( ( WF_NOTIFICATION_UTIL.g_nls_language is null or
3441: nvl(l_nlsLanguage, 'AMERICAN') <> WF_NOTIFICATION_UTIL.g_nls_language) or
3442: ( WF_NOTIFICATION_UTIL.g_nls_territory is null or

Line 3439: -- package as WF_NOTIFICATION_UTIL.SetNLSContext() API sets these parameter values only

3435: -- set user's language and territory : charset we can not chage for a session at DB layer.
3436: -- setNLS(l_nlsLanguage, l_nlsTerritory);
3437:
3438: -- Bug 11684796: Comparing user NLS parameters with the NLS parameters in WF_NOTIFICATION_UTIL
3439: -- package as WF_NOTIFICATION_UTIL.SetNLSContext() API sets these parameter values only
3440: if( ( WF_NOTIFICATION_UTIL.g_nls_language is null or
3441: nvl(l_nlsLanguage, 'AMERICAN') <> WF_NOTIFICATION_UTIL.g_nls_language) or
3442: ( WF_NOTIFICATION_UTIL.g_nls_territory is null or
3443: nvl( l_nlsTerritory, 'AMERICA') <> WF_NOTIFICATION_UTIL.g_nls_territory) or

Line 3440: if( ( WF_NOTIFICATION_UTIL.g_nls_language is null or

3436: -- setNLS(l_nlsLanguage, l_nlsTerritory);
3437:
3438: -- Bug 11684796: Comparing user NLS parameters with the NLS parameters in WF_NOTIFICATION_UTIL
3439: -- package as WF_NOTIFICATION_UTIL.SetNLSContext() API sets these parameter values only
3440: if( ( WF_NOTIFICATION_UTIL.g_nls_language is null or
3441: nvl(l_nlsLanguage, 'AMERICAN') <> WF_NOTIFICATION_UTIL.g_nls_language) or
3442: ( WF_NOTIFICATION_UTIL.g_nls_territory is null or
3443: nvl( l_nlsTerritory, 'AMERICA') <> WF_NOTIFICATION_UTIL.g_nls_territory) or
3444: ( WF_NOTIFICATION_UTIL.g_nls_date_format is null or

Line 3441: nvl(l_nlsLanguage, 'AMERICAN') <> WF_NOTIFICATION_UTIL.g_nls_language) or

3437:
3438: -- Bug 11684796: Comparing user NLS parameters with the NLS parameters in WF_NOTIFICATION_UTIL
3439: -- package as WF_NOTIFICATION_UTIL.SetNLSContext() API sets these parameter values only
3440: if( ( WF_NOTIFICATION_UTIL.g_nls_language is null or
3441: nvl(l_nlsLanguage, 'AMERICAN') <> WF_NOTIFICATION_UTIL.g_nls_language) or
3442: ( WF_NOTIFICATION_UTIL.g_nls_territory is null or
3443: nvl( l_nlsTerritory, 'AMERICA') <> WF_NOTIFICATION_UTIL.g_nls_territory) or
3444: ( WF_NOTIFICATION_UTIL.g_nls_date_format is null or
3445: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> WF_NOTIFICATION_UTIL.g_nls_date_format) or

Line 3442: ( WF_NOTIFICATION_UTIL.g_nls_territory is null or

3438: -- Bug 11684796: Comparing user NLS parameters with the NLS parameters in WF_NOTIFICATION_UTIL
3439: -- package as WF_NOTIFICATION_UTIL.SetNLSContext() API sets these parameter values only
3440: if( ( WF_NOTIFICATION_UTIL.g_nls_language is null or
3441: nvl(l_nlsLanguage, 'AMERICAN') <> WF_NOTIFICATION_UTIL.g_nls_language) or
3442: ( WF_NOTIFICATION_UTIL.g_nls_territory is null or
3443: nvl( l_nlsTerritory, 'AMERICA') <> WF_NOTIFICATION_UTIL.g_nls_territory) or
3444: ( WF_NOTIFICATION_UTIL.g_nls_date_format is null or
3445: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> WF_NOTIFICATION_UTIL.g_nls_date_format) or
3446: ( WF_NOTIFICATION_UTIL.g_nls_Date_Language is null or

Line 3443: nvl( l_nlsTerritory, 'AMERICA') <> WF_NOTIFICATION_UTIL.g_nls_territory) or

3439: -- package as WF_NOTIFICATION_UTIL.SetNLSContext() API sets these parameter values only
3440: if( ( WF_NOTIFICATION_UTIL.g_nls_language is null or
3441: nvl(l_nlsLanguage, 'AMERICAN') <> WF_NOTIFICATION_UTIL.g_nls_language) or
3442: ( WF_NOTIFICATION_UTIL.g_nls_territory is null or
3443: nvl( l_nlsTerritory, 'AMERICA') <> WF_NOTIFICATION_UTIL.g_nls_territory) or
3444: ( WF_NOTIFICATION_UTIL.g_nls_date_format is null or
3445: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> WF_NOTIFICATION_UTIL.g_nls_date_format) or
3446: ( WF_NOTIFICATION_UTIL.g_nls_Date_Language is null or
3447: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> WF_NOTIFICATION_UTIL.g_nls_Date_Language) or

Line 3444: ( WF_NOTIFICATION_UTIL.g_nls_date_format is null or

3440: if( ( WF_NOTIFICATION_UTIL.g_nls_language is null or
3441: nvl(l_nlsLanguage, 'AMERICAN') <> WF_NOTIFICATION_UTIL.g_nls_language) or
3442: ( WF_NOTIFICATION_UTIL.g_nls_territory is null or
3443: nvl( l_nlsTerritory, 'AMERICA') <> WF_NOTIFICATION_UTIL.g_nls_territory) or
3444: ( WF_NOTIFICATION_UTIL.g_nls_date_format is null or
3445: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> WF_NOTIFICATION_UTIL.g_nls_date_format) or
3446: ( WF_NOTIFICATION_UTIL.g_nls_Date_Language is null or
3447: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> WF_NOTIFICATION_UTIL.g_nls_Date_Language) or
3448: ( WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters is null or

Line 3445: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> WF_NOTIFICATION_UTIL.g_nls_date_format) or

3441: nvl(l_nlsLanguage, 'AMERICAN') <> WF_NOTIFICATION_UTIL.g_nls_language) or
3442: ( WF_NOTIFICATION_UTIL.g_nls_territory is null or
3443: nvl( l_nlsTerritory, 'AMERICA') <> WF_NOTIFICATION_UTIL.g_nls_territory) or
3444: ( WF_NOTIFICATION_UTIL.g_nls_date_format is null or
3445: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> WF_NOTIFICATION_UTIL.g_nls_date_format) or
3446: ( WF_NOTIFICATION_UTIL.g_nls_Date_Language is null or
3447: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> WF_NOTIFICATION_UTIL.g_nls_Date_Language) or
3448: ( WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters is null or
3449: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters) or

Line 3446: ( WF_NOTIFICATION_UTIL.g_nls_Date_Language is null or

3442: ( WF_NOTIFICATION_UTIL.g_nls_territory is null or
3443: nvl( l_nlsTerritory, 'AMERICA') <> WF_NOTIFICATION_UTIL.g_nls_territory) or
3444: ( WF_NOTIFICATION_UTIL.g_nls_date_format is null or
3445: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> WF_NOTIFICATION_UTIL.g_nls_date_format) or
3446: ( WF_NOTIFICATION_UTIL.g_nls_Date_Language is null or
3447: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> WF_NOTIFICATION_UTIL.g_nls_Date_Language) or
3448: ( WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters is null or
3449: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters) or
3450: ( WF_NOTIFICATION_UTIL.g_nls_Sort is null or

Line 3447: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> WF_NOTIFICATION_UTIL.g_nls_Date_Language) or

3443: nvl( l_nlsTerritory, 'AMERICA') <> WF_NOTIFICATION_UTIL.g_nls_territory) or
3444: ( WF_NOTIFICATION_UTIL.g_nls_date_format is null or
3445: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> WF_NOTIFICATION_UTIL.g_nls_date_format) or
3446: ( WF_NOTIFICATION_UTIL.g_nls_Date_Language is null or
3447: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> WF_NOTIFICATION_UTIL.g_nls_Date_Language) or
3448: ( WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters is null or
3449: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters) or
3450: ( WF_NOTIFICATION_UTIL.g_nls_Sort is null or
3451: nvl(l_nlsSort, wf_core.nls_sort) <> WF_NOTIFICATION_UTIL.g_nls_Sort) ) then

Line 3448: ( WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters is null or

3444: ( WF_NOTIFICATION_UTIL.g_nls_date_format is null or
3445: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> WF_NOTIFICATION_UTIL.g_nls_date_format) or
3446: ( WF_NOTIFICATION_UTIL.g_nls_Date_Language is null or
3447: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> WF_NOTIFICATION_UTIL.g_nls_Date_Language) or
3448: ( WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters is null or
3449: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters) or
3450: ( WF_NOTIFICATION_UTIL.g_nls_Sort is null or
3451: nvl(l_nlsSort, wf_core.nls_sort) <> WF_NOTIFICATION_UTIL.g_nls_Sort) ) then
3452:

Line 3449: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters) or

3445: nvl(l_nlsDateFormat , wf_core.nls_date_format) <> WF_NOTIFICATION_UTIL.g_nls_date_format) or
3446: ( WF_NOTIFICATION_UTIL.g_nls_Date_Language is null or
3447: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> WF_NOTIFICATION_UTIL.g_nls_Date_Language) or
3448: ( WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters is null or
3449: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters) or
3450: ( WF_NOTIFICATION_UTIL.g_nls_Sort is null or
3451: nvl(l_nlsSort, wf_core.nls_sort) <> WF_NOTIFICATION_UTIL.g_nls_Sort) ) then
3452:
3453: -- nid, l_nlsCalendar, just set here only.

Line 3450: ( WF_NOTIFICATION_UTIL.g_nls_Sort is null or

3446: ( WF_NOTIFICATION_UTIL.g_nls_Date_Language is null or
3447: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> WF_NOTIFICATION_UTIL.g_nls_Date_Language) or
3448: ( WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters is null or
3449: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters) or
3450: ( WF_NOTIFICATION_UTIL.g_nls_Sort is null or
3451: nvl(l_nlsSort, wf_core.nls_sort) <> WF_NOTIFICATION_UTIL.g_nls_Sort) ) then
3452:
3453: -- nid, l_nlsCalendar, just set here only.
3454: -- at other places pass value as null.

Line 3451: nvl(l_nlsSort, wf_core.nls_sort) <> WF_NOTIFICATION_UTIL.g_nls_Sort) ) then

3447: nvl(l_nlsDateLanguage, wf_core.nls_date_language) <> WF_NOTIFICATION_UTIL.g_nls_Date_Language) or
3448: ( WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters is null or
3449: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> WF_NOTIFICATION_UTIL.g_nls_Numeric_Characters) or
3450: ( WF_NOTIFICATION_UTIL.g_nls_Sort is null or
3451: nvl(l_nlsSort, wf_core.nls_sort) <> WF_NOTIFICATION_UTIL.g_nls_Sort) ) then
3452:
3453: -- nid, l_nlsCalendar, just set here only.
3454: -- at other places pass value as null.
3455: WF_NOTIFICATION_UTIL.SetNLSContext(nid,

Line 3455: WF_NOTIFICATION_UTIL.SetNLSContext(nid,

3451: nvl(l_nlsSort, wf_core.nls_sort) <> WF_NOTIFICATION_UTIL.g_nls_Sort) ) then
3452:
3453: -- nid, l_nlsCalendar, just set here only.
3454: -- at other places pass value as null.
3455: WF_NOTIFICATION_UTIL.SetNLSContext(nid,
3456: l_nlsLanguage ,
3457: l_nlsTerritory ,
3458: l_nlsDateFormat ,
3459: l_nlsDateLanguage ,

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

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

Line 3469: WF_NOTIFICATION_UTIL.setCurrentNID(nid);

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

Line 3470: WF_NOTIFICATION_UTIL.setCurrentCalendar(l_nlsCalendar);

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

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

3544: -- TODO : need to check above case.
3545: if(l_context_changed ) then
3546:
3547: -- set nid, calendar once only.
3548: -- <> : keep WF_NOTIFICATION_UTIL.g_nid and g_calendar in global variable
3549: -- during life-life cycle of this API.
3550: WF_NOTIFICATION_UTIL.SetNLSContext(
3551: nid,
3552: g_base_language ,

Line 3550: WF_NOTIFICATION_UTIL.SetNLSContext(

3546:
3547: -- set nid, calendar once only.
3548: -- <> : keep WF_NOTIFICATION_UTIL.g_nid and g_calendar in global variable
3549: -- during life-life cycle of this API.
3550: WF_NOTIFICATION_UTIL.SetNLSContext(
3551: nid,
3552: g_base_language ,
3553: g_base_territory ,
3554: g_base_nlsDateFormat ,

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

3581: -- <> : NLS changes, bug 7578922
3582: AddElementAttribute('nlsDateformat', l_nlsDateFormat, attrlist);
3583:
3584: -- << REMOVE validation later> we can validate if date_language is installed or not.
3585: if(WF_NOTIFICATION_UTIL.isLanguageInstalled(l_nlsDateLanguage)) then
3586: AddElementAttribute('nlsDateLanguage', l_nlsDateLanguage, attrlist);
3587: else
3588: AddElementAttribute('nlsDateLanguage', l_nlsLanguage, attrlist);
3589: end if;

Line 3973: WF_NOTIFICATION_UTIL.SetNLSContext(

3969: -- SetNLS(l_nlsLanguage, l_nlsTerritory);
3970: if(l_context_changed ) then
3971:
3972: -- l_nlsCalendar only will be stored in global variable
3973: WF_NOTIFICATION_UTIL.SetNLSContext(
3974: nid,
3975: l_nlsLanguage ,
3976: l_nlsTerritory ,
3977: l_nlsDateFormat ,

Line 4024: WF_NOTIFICATION_UTIL.SetNLSContext

4020: -- SetNLS(g_base_language, g_base_territory);
4021: -- Reset base language
4022: if( l_context_changed ) then
4023:
4024: WF_NOTIFICATION_UTIL.SetNLSContext
4025: (null, -- Resetting null for Nid is fine.
4026: g_base_language ,
4027: g_base_territory ,
4028: g_base_nlsDateFormat ,

Line 4067: WF_NOTIFICATION_UTIL.SetNLSContext(

4063:
4064: -- Reset base language, in case of exception.
4065: -- SetNLS(g_base_language, g_base_territory);
4066: -- Reset base language
4067: WF_NOTIFICATION_UTIL.SetNLSContext(
4068: null,
4069: g_base_language ,
4070: g_base_territory ,
4071: g_base_nlsDateFormat ,

Line 4509: WF_NOTIFICATION_UTIL.SetNLSContext(0,

4505: nvl(l_nlsNumericCharacters, wf_core.nls_numeric_characters) <> g_base_nlsNumericCharacters or
4506: nvl(l_nlsSort, wf_core.nls_sort) <> g_base_nlsSort ) then
4507:
4508:
4509: WF_NOTIFICATION_UTIL.SetNLSContext(0,
4510: l_nlsLanguage ,
4511: l_nlsTerritory ,
4512: l_nlsDateFormat ,
4513: l_nlsDateLanguage ,

Line 4549: WF_NOTIFICATION_UTIL.SetNLSContext(

4545:
4546: -- Reset base NLS Context
4547: if( l_context_changed ) then
4548:
4549: WF_NOTIFICATION_UTIL.SetNLSContext(
4550: null,
4551: g_base_language ,
4552: g_base_territory ,
4553: g_base_nlsDateFormat ,

Line 4728: WF_NOTIFICATION_UTIL.SetNLSContext(

4724: wf_temp_lob.releaseLob(g_LOBTable, messageIdx);
4725: end if;
4726:
4727: -- Reset base NLS Context in case of any EXCEPTION
4728: WF_NOTIFICATION_UTIL.SetNLSContext(
4729: null,
4730: g_base_language ,
4731: g_base_territory ,
4732: g_base_nlsDateFormat ,

Line 4955: WF_NOTIFICATION_UTIL.getNLSContext(

4951: g_base_nlsNumericCharacters is NULL OR
4952: g_base_nlsSort is NULL
4953: ) then
4954:
4955: WF_NOTIFICATION_UTIL.getNLSContext(
4956: g_base_language ,
4957: g_base_territory ,
4958: g_base_codeset ,
4959: g_base_nlsDateFormat ,

Line 4991: WF_NOTIFICATION_UTIL.SetNLSContext(null,

4987: when others then
4988: wf_core.context('WF_XML','Generate',p_event_name, p_event_key);
4989:
4990: -- RESET BASSE LANGUAGE
4991: WF_NOTIFICATION_UTIL.SetNLSContext(null,
4992: g_base_language ,
4993: g_base_territory ,
4994: g_base_nlsDateFormat ,
4995: g_base_nlsDateLanguage ,