4: g_pkg_body_ver CONSTANT VARCHAR2(100) := '$Header $';
5: g_newline CONSTANT VARCHAR2(10) := fnd_global.newline;
6: g_single_threaded CONSTANT BOOLEAN := FALSE;
7: g_bulk_fetch_limit CONSTANT NUMBER := 1000;
8: g_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'),0);
9: g_num_workers NUMBER := NVL(fnd_profile.value('WSH_PR_NUM_WORKERS'),1);
10:
11: g_assign_op_plans BOOLEAN := TRUE;
12: g_call_cartonization BOOLEAN := TRUE;
5: g_newline CONSTANT VARCHAR2(10) := fnd_global.newline;
6: g_single_threaded CONSTANT BOOLEAN := FALSE;
7: g_bulk_fetch_limit CONSTANT NUMBER := 1000;
8: g_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'),0);
9: g_num_workers NUMBER := NVL(fnd_profile.value('WSH_PR_NUM_WORKERS'),1);
10:
11: g_assign_op_plans BOOLEAN := TRUE;
12: g_call_cartonization BOOLEAN := TRUE;
13: g_consolidate_tasks BOOLEAN := TRUE;
1226: l_msg_data VARCHAR2(2000);
1227:
1228: l_api_return_status VARCHAR2(1);
1229: l_create_sub_batches VARCHAR2(1);
1230: l_do_post_alloc NUMBER := NVL(FND_PROFILE.VALUE('WMS_ASSIGN_TASK_TYPE'),1);
1231: l_sub_requests VARCHAR2(1) := 'N' ; --BUG10325405
1232:
1233:
1234: BEGIN