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 794: , mmtt.last_updated_by = FND_GLOBAL.USER_ID

790: , mmtt.locator_id = l_parent_loc_id
791: , mmtt.transaction_uom = mmtt.item_primary_uom_code
792: , mmtt.transaction_quantity = mmtt.primary_quantity
793: , mmtt.last_update_date = SYSDATE
794: , mmtt.last_updated_by = FND_GLOBAL.USER_ID
795: , mmtt.posting_flag = 'Y' -- Bug# 4185621: make sure child line mmtt is now posting
796: , mmtt.wms_task_status = l_g_task_loaded -- Bug# 4185621: make sure child line mmtt task status is loaded
797: WHERE mmtt.transaction_temp_id = p_child_temp_id;
798: ELSE

Line 813: , mmtt.last_updated_by = FND_GLOBAL.USER_ID

809: , mmtt.locator_id = l_parent_loc_id
810: , mmtt.transaction_uom = mmtt.item_primary_uom_code
811: , mmtt.transaction_quantity = mmtt.primary_quantity
812: , mmtt.last_update_date = SYSDATE
813: , mmtt.last_updated_by = FND_GLOBAL.USER_ID
814: , mmtt.posting_flag = 'Y' -- Bug# 4185621: make sure child line mmtt is now posting
815: , mmtt.wms_task_status = l_g_task_loaded -- Bug# 4185621: make sure child line mmtt task status is loaded
816: WHERE mmtt.transaction_temp_id <> p_parent_temp_id
817: and mmtt.parent_line_id = p_parent_temp_id;