APPS.PO_WF_REQ_NOTIFICATION dependencies on FND_RELEASE

Line 2042: if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )

2038:
2039: l_document_hist := l_document_hist || '' ||
2040: nvl(l_history.action, ' ') || '' || NL;
2041: /*Modified as part of bug 7554321 changing date format*/
2042: if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )
2043: or (FND_RELEASE.MAJOR_VERSION > 12) then
2044: l_date_text := nvl(to_char(l_history.action_date,
2045: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2046: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),' ') ;

Line 2043: or (FND_RELEASE.MAJOR_VERSION > 12) then

2039: l_document_hist := l_document_hist || '' ||
2040: nvl(l_history.action, ' ') || '' || NL;
2041: /*Modified as part of bug 7554321 changing date format*/
2042: if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )
2043: or (FND_RELEASE.MAJOR_VERSION > 12) then
2044: l_date_text := nvl(to_char(l_history.action_date,
2045: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2046: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),' ') ;
2047: else

Line 2094: if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )

2090: l_document_hist := l_document_hist || '' ||
2091: nvl(l_history.action, ' ') || '' || NL;
2092:
2093: /*Modified as part of bug 7554321 changing date format*/
2094: if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )
2095: or (FND_RELEASE.MAJOR_VERSION > 12) then
2096: l_date_text := nvl(to_char(l_history.action_date,
2097: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2098: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),' ') ;

Line 2095: or (FND_RELEASE.MAJOR_VERSION > 12) then

2091: nvl(l_history.action, ' ') || '' || NL;
2092:
2093: /*Modified as part of bug 7554321 changing date format*/
2094: if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )
2095: or (FND_RELEASE.MAJOR_VERSION > 12) then
2096: l_date_text := nvl(to_char(l_history.action_date,
2097: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2098: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),' ') ;
2099: else