DBA Data[Home] [Help]

APPS.WMS_BULK_PICK dependencies on FND_GLOBAL

Line 12: g_newline CONSTANT VARCHAR2(10) := fnd_global.newline;

8: -- Notes :
9: -- Modified : 07/30/2003 jali created
10: g_pkg_name CONSTANT VARCHAR2(30) := 'wms_bulk_pick';
11: g_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
12: g_newline CONSTANT VARCHAR2(10) := fnd_global.newline;
13:
14: -- Bug# 4185621: added global variable to be used later
15: l_g_task_loaded CONSTANT NUMBER := 4;
16:

Line 831: , mmtt.last_updated_by = FND_GLOBAL.USER_ID

827: , mmtt.locator_id = l_parent_loc_id
828: , mmtt.transaction_uom = mmtt.item_primary_uom_code
829: , mmtt.transaction_quantity = mmtt.primary_quantity
830: , mmtt.last_update_date = SYSDATE
831: , mmtt.last_updated_by = FND_GLOBAL.USER_ID
832: , mmtt.posting_flag = 'Y' -- Bug# 4185621: make sure child line mmtt is now posting
833: , mmtt.wms_task_status = l_g_task_loaded -- Bug# 4185621: make sure child line mmtt task status is loaded
834: WHERE mmtt.transaction_temp_id = p_child_temp_id;
835: ELSE

Line 850: , mmtt.last_updated_by = FND_GLOBAL.USER_ID

846: , mmtt.locator_id = l_parent_loc_id
847: , mmtt.transaction_uom = mmtt.item_primary_uom_code
848: , mmtt.transaction_quantity = mmtt.primary_quantity
849: , mmtt.last_update_date = SYSDATE
850: , mmtt.last_updated_by = FND_GLOBAL.USER_ID
851: , mmtt.posting_flag = 'Y' -- Bug# 4185621: make sure child line mmtt is now posting
852: , mmtt.wms_task_status = l_g_task_loaded -- Bug# 4185621: make sure child line mmtt task status is loaded
853: WHERE mmtt.transaction_temp_id <> p_parent_temp_id
854: and mmtt.parent_line_id = p_parent_temp_id;