DBA Data[Home] [Help]

APPS.WSH_RCV_CORR_RTV_TXN_PKG dependencies on WSH_DELIVERY_DETAILS_PKG

Line 1911: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DETAIL_NO_COMPARE',WSH_DEBUG_SV.C_PROC_LEVEL);

1907: --
1908: -- Debug Statements
1909: --
1910: IF l_debug_on THEN
1911: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DETAIL_NO_COMPARE',WSH_DEBUG_SV.C_PROC_LEVEL);
1912: END IF;
1913: --
1914: wsh_delivery_details_pkg.Lock_Detail_No_Compare(
1915: p_delivery_detail_id => l_update_rec.del_det_id_tab(i));

Line 1914: wsh_delivery_details_pkg.Lock_Detail_No_Compare(

1910: IF l_debug_on THEN
1911: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DETAIL_NO_COMPARE',WSH_DEBUG_SV.C_PROC_LEVEL);
1912: END IF;
1913: --
1914: wsh_delivery_details_pkg.Lock_Detail_No_Compare(
1915: p_delivery_detail_id => l_update_rec.del_det_id_tab(i));
1916:
1917: IF l_debug_on THEN
1918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

1914: wsh_delivery_details_pkg.Lock_Detail_No_Compare(
1915: p_delivery_detail_id => l_update_rec.del_det_id_tab(i));
1916:
1917: IF l_debug_on THEN
1918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
1919: END IF;
1920:
1921: wsh_delivery_details_pkg.delete_delivery_details(
1922: p_delivery_detail_id => l_update_rec.del_det_id_tab(i),

Line 1921: wsh_delivery_details_pkg.delete_delivery_details(

1917: IF l_debug_on THEN
1918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
1919: END IF;
1920:
1921: wsh_delivery_details_pkg.delete_delivery_details(
1922: p_delivery_detail_id => l_update_rec.del_det_id_tab(i),
1923: x_return_status => l_return_status);
1924: --
1925: -- Debug Statements

Line 1973: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DETAIL_NO_COMPARE',WSH_DEBUG_SV.C_PROC_LEVEL);

1969:
1970: IF l_update_del_det_id IS NOT NULL THEN
1971: --{
1972: IF l_debug_on THEN
1973: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DETAIL_NO_COMPARE',WSH_DEBUG_SV.C_PROC_LEVEL);
1974: END IF;
1975: --
1976: wsh_delivery_details_pkg.Lock_Detail_No_Compare(
1977: p_delivery_detail_id => l_update_del_det_id);

Line 1976: wsh_delivery_details_pkg.Lock_Detail_No_Compare(

1972: IF l_debug_on THEN
1973: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DETAIL_NO_COMPARE',WSH_DEBUG_SV.C_PROC_LEVEL);
1974: END IF;
1975: --
1976: wsh_delivery_details_pkg.Lock_Detail_No_Compare(
1977: p_delivery_detail_id => l_update_del_det_id);
1978: -- we need to update atmost one record.
1979: update wsh_delivery_details
1980: set requested_quantity = l_update_del_det_req_qty,