2721:
2722: -- Bug # 3413372
2723: -- Initilize global variable /Tables used by get_itemobhand(),
2724: -- get_project_attribute() in WMS_PARAMETERS_PVT
2725: wms_parameter_pvt.g_GetItemOnhq_IsRuleCached := 'N';
2726: wms_parameter_pvt.g_GetProjAttr_IsRuleCached := 'N';
2727:
2728: wms_parameter_pvt.g_locator_item_quantity.DELETE;
2729: wms_parameter_pvt.g_bulkCollect_Locator.DELETE;
2722: -- Bug # 3413372
2723: -- Initilize global variable /Tables used by get_itemobhand(),
2724: -- get_project_attribute() in WMS_PARAMETERS_PVT
2725: wms_parameter_pvt.g_GetItemOnhq_IsRuleCached := 'N';
2726: wms_parameter_pvt.g_GetProjAttr_IsRuleCached := 'N';
2727:
2728: wms_parameter_pvt.g_locator_item_quantity.DELETE;
2729: wms_parameter_pvt.g_bulkCollect_Locator.DELETE;
2730: wms_parameter_pvt.g_bulkCollect_quantity.DELETE;
2724: -- get_project_attribute() in WMS_PARAMETERS_PVT
2725: wms_parameter_pvt.g_GetItemOnhq_IsRuleCached := 'N';
2726: wms_parameter_pvt.g_GetProjAttr_IsRuleCached := 'N';
2727:
2728: wms_parameter_pvt.g_locator_item_quantity.DELETE;
2729: wms_parameter_pvt.g_bulkCollect_Locator.DELETE;
2730: wms_parameter_pvt.g_bulkCollect_quantity.DELETE;
2731: -- end of Bug# 3413372
2732: END IF;
2725: wms_parameter_pvt.g_GetItemOnhq_IsRuleCached := 'N';
2726: wms_parameter_pvt.g_GetProjAttr_IsRuleCached := 'N';
2727:
2728: wms_parameter_pvt.g_locator_item_quantity.DELETE;
2729: wms_parameter_pvt.g_bulkCollect_Locator.DELETE;
2730: wms_parameter_pvt.g_bulkCollect_quantity.DELETE;
2731: -- end of Bug# 3413372
2732: END IF;
2733: if x_return_status = fnd_api.g_ret_sts_unexp_error then
2726: wms_parameter_pvt.g_GetProjAttr_IsRuleCached := 'N';
2727:
2728: wms_parameter_pvt.g_locator_item_quantity.DELETE;
2729: wms_parameter_pvt.g_bulkCollect_Locator.DELETE;
2730: wms_parameter_pvt.g_bulkCollect_quantity.DELETE;
2731: -- end of Bug# 3413372
2732: END IF;
2733: if x_return_status = fnd_api.g_ret_sts_unexp_error then
2734: raise fnd_api.g_exc_unexpected_error;