2492:
2493: -- Bug # 3413372
2494: -- Initilize global variable /Tables used by get_itemobhand(),
2495: -- get_project_attribute() in WMS_PARAMETERS_PVT
2496: wms_parameter_pvt.g_GetItemOnhq_IsRuleCached := 'N';
2497: wms_parameter_pvt.g_GetProjAttr_IsRuleCached := 'N';
2498:
2499: wms_parameter_pvt.g_locator_item_quantity.DELETE;
2500: wms_parameter_pvt.g_bulkCollect_Locator.DELETE;
2493: -- Bug # 3413372
2494: -- Initilize global variable /Tables used by get_itemobhand(),
2495: -- get_project_attribute() in WMS_PARAMETERS_PVT
2496: wms_parameter_pvt.g_GetItemOnhq_IsRuleCached := 'N';
2497: wms_parameter_pvt.g_GetProjAttr_IsRuleCached := 'N';
2498:
2499: wms_parameter_pvt.g_locator_item_quantity.DELETE;
2500: wms_parameter_pvt.g_bulkCollect_Locator.DELETE;
2501: wms_parameter_pvt.g_bulkCollect_quantity.DELETE;
2495: -- get_project_attribute() in WMS_PARAMETERS_PVT
2496: wms_parameter_pvt.g_GetItemOnhq_IsRuleCached := 'N';
2497: wms_parameter_pvt.g_GetProjAttr_IsRuleCached := 'N';
2498:
2499: wms_parameter_pvt.g_locator_item_quantity.DELETE;
2500: wms_parameter_pvt.g_bulkCollect_Locator.DELETE;
2501: wms_parameter_pvt.g_bulkCollect_quantity.DELETE;
2502: -- end of Bug# 3413372
2503: END IF;
2496: wms_parameter_pvt.g_GetItemOnhq_IsRuleCached := 'N';
2497: wms_parameter_pvt.g_GetProjAttr_IsRuleCached := 'N';
2498:
2499: wms_parameter_pvt.g_locator_item_quantity.DELETE;
2500: wms_parameter_pvt.g_bulkCollect_Locator.DELETE;
2501: wms_parameter_pvt.g_bulkCollect_quantity.DELETE;
2502: -- end of Bug# 3413372
2503: END IF;
2504: if x_return_status = fnd_api.g_ret_sts_unexp_error then
2497: wms_parameter_pvt.g_GetProjAttr_IsRuleCached := 'N';
2498:
2499: wms_parameter_pvt.g_locator_item_quantity.DELETE;
2500: wms_parameter_pvt.g_bulkCollect_Locator.DELETE;
2501: wms_parameter_pvt.g_bulkCollect_quantity.DELETE;
2502: -- end of Bug# 3413372
2503: END IF;
2504: if x_return_status = fnd_api.g_ret_sts_unexp_error then
2505: raise fnd_api.g_exc_unexpected_error;