DBA Data[Home] [Help]

APPS.POS_ASN_NOTIF dependencies on FND_RELEASE

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

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

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

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: */

Line 491: IF ( fnd_release.major_version = 12

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 )

Line 492: AND fnd_release.minor_version = 1

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

Line 493: AND fnd_release.point_version >= 1 )

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:

Line 494: OR ( fnd_release.major_version = 12

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,

Line 495: AND fnd_release.minor_version >= 2 )

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,

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

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,

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

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

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

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: */

Line 704: IF ( fnd_release.major_version = 12

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 )

Line 705: AND fnd_release.minor_version = 1

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

Line 706: AND fnd_release.point_version >= 1 )

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

Line 707: OR ( fnd_release.major_version = 12

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 || '' ||
711: x_invoice_ts || '
' ;

Line 708: AND fnd_release.minor_version >= 2 )

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 || '' ||
711: x_invoice_ts || '
' ;
712: else

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

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 || '' ||
711: x_invoice_ts || '
' ;
712: else
713: l_document1 := l_document1 || '' ||