DBA Data[Home] [Help]

APPS.MTL_LOT_NUMBERS_PKG dependencies on FND_PROFILE

Line 542: l_global_profile := NVL(FND_PROFILE.VALUE('INV_GLOBAL_LOT_ATTRIBUTES'),'N');--Global Lot ER

538: --Global Lot ER End
539:
540:
541: BEGIN
542: l_global_profile := NVL(FND_PROFILE.VALUE('INV_GLOBAL_LOT_ATTRIBUTES'),'N');--Global Lot ER
543:
544: /* WMS Material Status Enhancements
545: To maintain the Material Status History obtain the Status ID before
546: the record get updated with modified values. */

Line 1091: l_global_profile := NVL(FND_PROFILE.VALUE('INV_GLOBAL_LOT_ATTRIBUTES'),'N');--Global Lot ER

1087: l_default_status NUMBER; -- Bug 14399953
1088:
1089: BEGIN
1090: --Global Lot ER Start
1091: l_global_profile := NVL(FND_PROFILE.VALUE('INV_GLOBAL_LOT_ATTRIBUTES'),'N');--Global Lot ER
1092:
1093: IF l_global_profile = 'Y' THEN
1094: BEGIN
1095: SELECT 1,Expiration_Date,origination_date,maturity_date,retest_date,expiration_action_date,expiration_action_code,hold_date,grade_code