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
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: */
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 )
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
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,
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),
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') || '''');
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,
354: EXIT WHEN new_mfg_capacity%NOTFOUND;
355: l_document := l_document || '
355: l_document := l_document || '
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 )
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
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,
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),
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') || '''');
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,