DBA Data[Home] [Help]

APPS.INV_LOC_WMS_UTILS dependencies on FND_GLOBAL

Line 3784: last_updated_by = fnd_global.user_id,

3780: available_cubic_area = max_cubic_area,
3781: inventory_item_id = NULL,
3782: empty_flag = 'Y',
3783: mixed_items_flag = 'N',
3784: last_updated_by = fnd_global.user_id,
3785: last_update_date = SYSDATE
3786: WHERE organization_id = p_organization_id
3787: AND inventory_location_id = t_loc_id_emp(k);
3788:

Line 7546: --LAST_UPDATED_BY = fnd_global.user_id added to the update statment

7542: INV_TRX_UTIL_PUB.TRACE('The values of Item ID is '||l_item_id , 'LOC_EMPTY_MIXED_FLAG',10);
7543: END IF;
7544:
7545: --Fix for 8630843
7546: --LAST_UPDATED_BY = fnd_global.user_id added to the update statment
7547:
7548: UPDATE MTL_ITEM_LOCATIONS mil
7549: SET EMPTY_FLAG = nvl(l_empty_flag,mil.empty_flag)
7550: , MIXED_ITEMS_FLAG = nvl(l_mixed_flag,mil.mixed_items_flag)

Line 7553: ,LAST_UPDATED_BY = fnd_global.user_id

7549: SET EMPTY_FLAG = nvl(l_empty_flag,mil.empty_flag)
7550: , MIXED_ITEMS_FLAG = nvl(l_mixed_flag,mil.mixed_items_flag)
7551: , INVENTORY_ITEM_ID = nvl(l_item_id,mil.inventory_item_id)
7552: , LAST_UPDATE_DATE = sysdate /* Added for Bug 6363028 */
7553: ,LAST_UPDATED_BY = fnd_global.user_id
7554: WHERE INVENTORY_LOCATION_ID = l_des_inventory_location_id
7555: AND ORGANIZATION_ID = P_TRANSFER_ORGANIZATION;
7556:
7557: end if;

Line 7599: --LAST_UPDATED_BY = fnd_global.user_id added to the update statment

7595: --Bug#2756609. Should update empty_flag and mixed_items_flag only if
7596: --the values passed are not null.
7597:
7598: --Fix for 8630843
7599: --LAST_UPDATED_BY = fnd_global.user_id added to the update statment
7600:
7601: UPDATE MTL_ITEM_LOCATIONS MIL
7602: SET EMPTY_FLAG = NVL(l_empty_flag,MIL.empty_flag)
7603: , MIXED_ITEMS_FLAG = NVL(l_mixed_flag,MIL.mixed_items_flag)

Line 7606: , LAST_UPDATED_BY = fnd_global.user_id

7602: SET EMPTY_FLAG = NVL(l_empty_flag,MIL.empty_flag)
7603: , MIXED_ITEMS_FLAG = NVL(l_mixed_flag,MIL.mixed_items_flag)
7604: , INVENTORY_ITEM_ID = NVL(l_item_id,MIL.inventory_item_id)
7605: , LAST_UPDATE_DATE = sysdate /* Added for Bug 6363028 */
7606: , LAST_UPDATED_BY = fnd_global.user_id
7607: WHERE INVENTORY_LOCATION_ID = l_inventory_location_id
7608: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
7609:
7610: IF (l_debug = 1) THEN