DBA Data[Home] [Help]

APPS.WSH_USA_INV_PVT dependencies on INV_MO_LINE_DETAIL_UTIL

Line 3185: l_mmtt_tbl INV_MO_LINE_DETAIL_UTIL.g_mmtt_tbl_type;

3181: IS
3182:
3183: -- bug # 9410461: Begin
3184: l_new_rsv_id NUMBER;
3185: l_mmtt_tbl INV_MO_LINE_DETAIL_UTIL.g_mmtt_tbl_type;
3186: l_temp_transaction_quantity NUMBER;
3187: l_temp_transaction_quantity2 NUMBER;
3188: -- bug # 9410461: End
3189:

Line 3418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit inv_mo_line_detail_util.query_rows',WSH_DEBUG_SV.C_PROC_LEVEL);

3414: -- bug # 9410461: Get all mmtt records for the given move order line id.
3415: -- This is required as the reservation_id of MMTT needs to updated when
3416: -- original reservation got split and transferred to new line.
3417: IF l_debug_on THEN
3418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit inv_mo_line_detail_util.query_rows',WSH_DEBUG_SV.C_PROC_LEVEL);
3419: END IF;
3420: l_mmtt_tbl := inv_mo_line_detail_util.query_rows(p_line_id => p_delivery_detail_split_rec.move_order_line_id);
3421: --
3422: IF l_debug_on THEN

Line 3420: l_mmtt_tbl := inv_mo_line_detail_util.query_rows(p_line_id => p_delivery_detail_split_rec.move_order_line_id);

3416: -- original reservation got split and transferred to new line.
3417: IF l_debug_on THEN
3418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit inv_mo_line_detail_util.query_rows',WSH_DEBUG_SV.C_PROC_LEVEL);
3419: END IF;
3420: l_mmtt_tbl := inv_mo_line_detail_util.query_rows(p_line_id => p_delivery_detail_split_rec.move_order_line_id);
3421: --
3422: IF l_debug_on THEN
3423: WSH_DEBUG_SV.log(l_module_name,'l_mmtt_tbl count',l_mmtt_tbl.Count);
3424: END IF;

Line 3521: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit inv_mo_line_detail_util.update_row',WSH_DEBUG_SV.C_PROC_LEVEL);

3517: IF l_debug_on THEN
3518: WSH_DEBUG_SV.log(l_module_name,'new reservation Id ',l_mmtt_tbl(j).reservation_id);
3519: WSH_DEBUG_SV.log(l_module_name,' temp id ',l_mmtt_tbl(j).transaction_temp_id);
3520: WSH_DEBUG_SV.log(l_module_name,' move order line id ',l_mmtt_tbl(j).move_order_line_id);
3521: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit inv_mo_line_detail_util.update_row',WSH_DEBUG_SV.C_PROC_LEVEL);
3522: END IF;
3523: inv_mo_line_detail_util.update_row(
3524: p_mo_line_detail_rec => l_mmtt_tbl(j),
3525: x_return_status => x_return_status);

Line 3523: inv_mo_line_detail_util.update_row(

3519: WSH_DEBUG_SV.log(l_module_name,' temp id ',l_mmtt_tbl(j).transaction_temp_id);
3520: WSH_DEBUG_SV.log(l_module_name,' move order line id ',l_mmtt_tbl(j).move_order_line_id);
3521: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit inv_mo_line_detail_util.update_row',WSH_DEBUG_SV.C_PROC_LEVEL);
3522: END IF;
3523: inv_mo_line_detail_util.update_row(
3524: p_mo_line_detail_rec => l_mmtt_tbl(j),
3525: x_return_status => x_return_status);
3526: IF l_debug_on THEN
3527: WSH_DEBUG_SV.log(l_module_name, 'return_status',x_return_status);