DBA Data[Home] [Help]

APPS.POS_UPDATE_CAPACITY_PKG dependencies on FND_RELEASE

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

269: FETCH old_mfg_capacity INTO l_from, l_to, l_cap_per_day;
270: EXIT WHEN old_mfg_capacity%NOTFOUND;
271: /*
272: * Modified as part of bug 7524573 changing date format
273: * if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )
274: * or (FND_RELEASE.MAJOR_VERSION > 12) then
275: */
276: /*
277: * Commented above if condition and added below if condition as part of Bug #: 11824514

Line 274: * or (FND_RELEASE.MAJOR_VERSION > 12) then

270: EXIT WHEN old_mfg_capacity%NOTFOUND;
271: /*
272: * Modified as part of bug 7524573 changing date format
273: * if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )
274: * or (FND_RELEASE.MAJOR_VERSION > 12) then
275: */
276: /*
277: * Commented above if condition and added below if condition as part of Bug #: 11824514
278: */

Line 279: IF ( fnd_release.major_version = 12

275: */
276: /*
277: * Commented above if condition and added below if condition as part of Bug #: 11824514
278: */
279: IF ( fnd_release.major_version = 12
280: AND fnd_release.minor_version = 1
281: AND fnd_release.point_version >= 1 )
282: OR ( fnd_release.major_version = 12
283: AND fnd_release.minor_version >= 2 )

Line 280: AND fnd_release.minor_version = 1

276: /*
277: * Commented above if condition and added below if condition as part of Bug #: 11824514
278: */
279: IF ( fnd_release.major_version = 12
280: AND fnd_release.minor_version = 1
281: AND fnd_release.point_version >= 1 )
282: OR ( fnd_release.major_version = 12
283: AND fnd_release.minor_version >= 2 )
284: OR ( fnd_release.major_version > 12 ) THEN

Line 281: AND fnd_release.point_version >= 1 )

277: * Commented above if condition and added below if condition as part of Bug #: 11824514
278: */
279: IF ( fnd_release.major_version = 12
280: AND fnd_release.minor_version = 1
281: AND fnd_release.point_version >= 1 )
282: OR ( fnd_release.major_version = 12
283: AND fnd_release.minor_version >= 2 )
284: OR ( fnd_release.major_version > 12 ) THEN
285: l_from_date_text := to_char(l_from,

Line 282: OR ( fnd_release.major_version = 12

278: */
279: IF ( fnd_release.major_version = 12
280: AND fnd_release.minor_version = 1
281: AND fnd_release.point_version >= 1 )
282: OR ( fnd_release.major_version = 12
283: AND fnd_release.minor_version >= 2 )
284: OR ( fnd_release.major_version > 12 ) THEN
285: l_from_date_text := to_char(l_from,
286: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

Line 283: AND fnd_release.minor_version >= 2 )

279: IF ( fnd_release.major_version = 12
280: AND fnd_release.minor_version = 1
281: AND fnd_release.point_version >= 1 )
282: OR ( fnd_release.major_version = 12
283: AND fnd_release.minor_version >= 2 )
284: OR ( fnd_release.major_version > 12 ) THEN
285: l_from_date_text := to_char(l_from,
286: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
287: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');

Line 284: OR ( fnd_release.major_version > 12 ) THEN

280: AND fnd_release.minor_version = 1
281: AND fnd_release.point_version >= 1 )
282: OR ( fnd_release.major_version = 12
283: AND fnd_release.minor_version >= 2 )
284: OR ( fnd_release.major_version > 12 ) THEN
285: l_from_date_text := to_char(l_from,
286: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
287: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');
288: l_to_date_text := to_char(l_to,

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

354: EXIT WHEN new_mfg_capacity%NOTFOUND;
355: l_document := l_document || '';
356: /*
357: * Modified as part of bug 7524573 changing date format
358: * if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )
359: * or (FND_RELEASE.MAJOR_VERSION > 12) then
360: */
361: /*
362: * Commented above if condition and added below condition as part of Bug #: 11824514

Line 359: * or (FND_RELEASE.MAJOR_VERSION > 12) then

355: l_document := l_document || '';
356: /*
357: * Modified as part of bug 7524573 changing date format
358: * if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )
359: * or (FND_RELEASE.MAJOR_VERSION > 12) then
360: */
361: /*
362: * Commented above if condition and added below condition as part of Bug #: 11824514
363: */

Line 364: IF ( fnd_release.major_version = 12

360: */
361: /*
362: * Commented above if condition and added below condition as part of Bug #: 11824514
363: */
364: IF ( fnd_release.major_version = 12
365: AND fnd_release.minor_version = 1
366: AND fnd_release.point_version >= 1 )
367: OR ( fnd_release.major_version = 12
368: AND fnd_release.minor_version >= 2 )

Line 365: AND fnd_release.minor_version = 1

361: /*
362: * Commented above if condition and added below condition as part of Bug #: 11824514
363: */
364: IF ( fnd_release.major_version = 12
365: AND fnd_release.minor_version = 1
366: AND fnd_release.point_version >= 1 )
367: OR ( fnd_release.major_version = 12
368: AND fnd_release.minor_version >= 2 )
369: OR ( fnd_release.major_version > 12 ) THEN

Line 366: AND fnd_release.point_version >= 1 )

362: * Commented above if condition and added below condition as part of Bug #: 11824514
363: */
364: IF ( fnd_release.major_version = 12
365: AND fnd_release.minor_version = 1
366: AND fnd_release.point_version >= 1 )
367: OR ( fnd_release.major_version = 12
368: AND fnd_release.minor_version >= 2 )
369: OR ( fnd_release.major_version > 12 ) THEN
370: l_from_date_text := to_char(l_from,

Line 367: OR ( fnd_release.major_version = 12

363: */
364: IF ( fnd_release.major_version = 12
365: AND fnd_release.minor_version = 1
366: AND fnd_release.point_version >= 1 )
367: OR ( fnd_release.major_version = 12
368: AND fnd_release.minor_version >= 2 )
369: OR ( fnd_release.major_version > 12 ) THEN
370: l_from_date_text := to_char(l_from,
371: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

Line 368: AND fnd_release.minor_version >= 2 )

364: IF ( fnd_release.major_version = 12
365: AND fnd_release.minor_version = 1
366: AND fnd_release.point_version >= 1 )
367: OR ( fnd_release.major_version = 12
368: AND fnd_release.minor_version >= 2 )
369: OR ( fnd_release.major_version > 12 ) THEN
370: l_from_date_text := to_char(l_from,
371: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
372: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');

Line 369: OR ( fnd_release.major_version > 12 ) THEN

365: AND fnd_release.minor_version = 1
366: AND fnd_release.point_version >= 1 )
367: OR ( fnd_release.major_version = 12
368: AND fnd_release.minor_version >= 2 )
369: OR ( fnd_release.major_version > 12 ) THEN
370: l_from_date_text := to_char(l_from,
371: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
372: 'NLS_CALENDAR = ''' || nvl(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id), 'GREGORIAN') || '''');
373: l_to_date_text := to_char(l_to,