481:
482: BEGIN
483: /*
484: * Modified as part of bug 7524698 changing date format
485: * if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )
486: * or (FND_RELEASE.MAJOR_VERSION > 12) then
487: */
488: /*
489: * Commented above if condition and added below if condition as part of Bug #: 11824503
482: BEGIN
483: /*
484: * Modified as part of bug 7524698 changing date format
485: * if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )
486: * or (FND_RELEASE.MAJOR_VERSION > 12) then
487: */
488: /*
489: * Commented above if condition and added below if condition as part of Bug #: 11824503
490: */
487: */
488: /*
489: * Commented above if condition and added below if condition as part of Bug #: 11824503
490: */
491: IF ( fnd_release.major_version = 12
492: AND fnd_release.minor_version = 1
493: AND fnd_release.point_version >= 1 )
494: OR ( fnd_release.major_version = 12
495: AND fnd_release.minor_version >= 2 )
488: /*
489: * Commented above if condition and added below if condition as part of Bug #: 11824503
490: */
491: IF ( fnd_release.major_version = 12
492: AND fnd_release.minor_version = 1
493: AND fnd_release.point_version >= 1 )
494: OR ( fnd_release.major_version = 12
495: AND fnd_release.minor_version >= 2 )
496: OR ( fnd_release.major_version > 12 ) THEN
489: * Commented above if condition and added below if condition as part of Bug #: 11824503
490: */
491: IF ( fnd_release.major_version = 12
492: AND fnd_release.minor_version = 1
493: AND fnd_release.point_version >= 1 )
494: OR ( fnd_release.major_version = 12
495: AND fnd_release.minor_version >= 2 )
496: OR ( fnd_release.major_version > 12 ) THEN
497:
490: */
491: IF ( fnd_release.major_version = 12
492: AND fnd_release.minor_version = 1
493: AND fnd_release.point_version >= 1 )
494: OR ( fnd_release.major_version = 12
495: AND fnd_release.minor_version >= 2 )
496: OR ( fnd_release.major_version > 12 ) THEN
497:
498: SELECT DISTINCT poh.shipment_num,
491: IF ( fnd_release.major_version = 12
492: AND fnd_release.minor_version = 1
493: AND fnd_release.point_version >= 1 )
494: OR ( fnd_release.major_version = 12
495: AND fnd_release.minor_version >= 2 )
496: OR ( fnd_release.major_version > 12 ) THEN
497:
498: SELECT DISTINCT poh.shipment_num,
499: pov.vendor_name,
492: AND fnd_release.minor_version = 1
493: AND fnd_release.point_version >= 1 )
494: OR ( fnd_release.major_version = 12
495: AND fnd_release.minor_version >= 2 )
496: OR ( fnd_release.major_version > 12 ) THEN
497:
498: SELECT DISTINCT poh.shipment_num,
499: pov.vendor_name,
500: poh.shipped_date,
694: l_document1 := l_document1 || '
695: fnd_message.get_string('POS', 'POS_ASN_NOTIF_INVOICE_DATE') || ' ' ;
696: /*
697: * Modified as part of bug 7524698 changing date format
698: * if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )
699: * or (FND_RELEASE.MAJOR_VERSION > 12) then
700: */
701: /*
702: * Commented above if condition and added below if condition as part of Bug #: 11824503
703: */
700: */
701: /*
702: * Commented above if condition and added below if condition as part of Bug #: 11824503
703: */
704: IF ( fnd_release.major_version = 12
705: AND fnd_release.minor_version = 1
706: AND fnd_release.point_version >= 1 )
707: OR ( fnd_release.major_version = 12
708: AND fnd_release.minor_version >= 2 )
701: /*
702: * Commented above if condition and added below if condition as part of Bug #: 11824503
703: */
704: IF ( fnd_release.major_version = 12
705: AND fnd_release.minor_version = 1
706: AND fnd_release.point_version >= 1 )
707: OR ( fnd_release.major_version = 12
708: AND fnd_release.minor_version >= 2 )
709: OR ( fnd_release.major_version > 12 ) THEN
702: * Commented above if condition and added below if condition as part of Bug #: 11824503
703: */
704: IF ( fnd_release.major_version = 12
705: AND fnd_release.minor_version = 1
706: AND fnd_release.point_version >= 1 )
707: OR ( fnd_release.major_version = 12
708: AND fnd_release.minor_version >= 2 )
709: OR ( fnd_release.major_version > 12 ) THEN
710: l_document1 := l_document1 || '
703: */
704: IF ( fnd_release.major_version = 12
705: AND fnd_release.minor_version = 1
706: AND fnd_release.point_version >= 1 )
707: OR ( fnd_release.major_version = 12
708: AND fnd_release.minor_version >= 2 )
709: OR ( fnd_release.major_version > 12 ) THEN
710: l_document1 := l_document1 || '
704: IF ( fnd_release.major_version = 12
705: AND fnd_release.minor_version = 1
706: AND fnd_release.point_version >= 1 )
707: OR ( fnd_release.major_version = 12
708: AND fnd_release.minor_version >= 2 )
709: OR ( fnd_release.major_version > 12 ) THEN
710: l_document1 := l_document1 || '
705: AND fnd_release.minor_version = 1
706: AND fnd_release.point_version >= 1 )
707: OR ( fnd_release.major_version = 12
708: AND fnd_release.minor_version >= 2 )
709: OR ( fnd_release.major_version > 12 ) THEN
710: l_document1 := l_document1 || '