APPS.AMS_ITEM_OWNER_PVT dependencies on FND_PROFILE

Line 598: l_can_update_inv_item := FND_PROFILE.value('AMS_ALLOW_INVENTORY_UPDATE');

594: /*** This code added by ABHOLA
595: id the item is OMO item , that is created by a marketing user
596: it can only be updated if AMS_ALLOW_INVENTORY_UPDATE profile is Y
597: ***/
598: l_can_update_inv_item := FND_PROFILE.value('AMS_ALLOW_INVENTORY_UPDATE');
599:
600: if (l_can_update_inv_item = 'N') AND (IS_OMO_ITEM = 'N') then
601: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
602: THEN

Line 1444: AND UOM_CLASS = Fnd_profile.value('TIME_UOM_CLASS');

1440: IS
1441: SELECT uom_code
1442: FROM mtl_all_primary_uoms_vv
1443: WHERE inventory_item_id = 0
1444: AND UOM_CLASS = Fnd_profile.value('TIME_UOM_CLASS');
1445: */
1446: CURSOR get_duration_period
1447: IS
1448: SELECT DISTINCT UOMT.uom_code

Line 1455: AND UOMT.UOM_CLASS = Fnd_profile.value('TIME_UOM_CLASS');

1451: AND CONV.UOM_CODE = UOMT.UOM_CODE
1452: AND UOMT.LANGUAGE = USERENV('LANG')
1453: AND NVL(UOMT.DISABLE_DATE, SYSDATE+1) > SYSDATE
1454: AND CONV.inventory_item_id = 0
1455: AND UOMT.UOM_CLASS = Fnd_profile.value('TIME_UOM_CLASS');
1456:
1457: l_duration_period get_duration_period%ROWTYPE;
1458:
1459: --bug 3544835 end