DBA Data[Home] [Help]

APPS.WSH_USA_CATEGORIES_PVT dependencies on WSH_USA_INV_PVT

Line 1847: WSH_USA_INV_PVT.query_reservations(

1843: -- when this flag is Y either l_delete_dds is populated or cancel_MOL api is called
1844: -- As stated above, this call is made primarily to delete_reservations
1845: -- Above, we have call to INV_MO_Cancel_PVT.Cancel_Move_Order_Line for released_status of 'S'
1846: -- this takes care of the reservations, hence pass null for delivery_detail_id
1847: WSH_USA_INV_PVT.query_reservations(
1848: p_source_code => p_source_code,
1849: p_source_header_id => p_attributes_rec.source_header_id,
1850: p_source_line_id => p_attributes_rec.source_line_id,
1851: p_organization_id => g_cache_detail_rec.organization_id,

Line 1893: WSH_USA_INV_PVT.delete_reservation (

1889: --bug#6407943. end
1890: --
1891: FOR i IN 1.. l_count LOOP
1892:
1893: WSH_USA_INV_PVT.delete_reservation (
1894: p_query_input => l_resv_tbl(i),
1895: x_return_status => x_return_status);
1896:
1897: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

Line 2006: WSH_USA_INV_PVT.create_reservation (

2002: l_resv_tbl(i).subinventory_code);
2003: END IF;
2004: --
2005: -- HW OPMCONV. Pass a new parameter p_qty2
2006: WSH_USA_INV_PVT.create_reservation (
2007: p_query_input => l_resv_tbl(i),
2008: p_qty2 => p_attributes_rec.ordered_quantity2,
2009: x_reservation_id => l_reservation_id,
2010: x_qty_reserved => l_qty_reserved,