APPS.GMI_MOVE_ORDER_LINE_UTIL dependencies on INV_MO_LINE_DETAIL_UTIL

Line 2066: l_mold_tbl INV_MO_LINE_DETAIL_UTIL.g_mmtt_tbl_type;

2062: l_default_lot_index NUMBER;
2063:
2064: l_pick_release_status INV_PICK_RELEASE_PUB.INV_RELEASE_STATUS_Tbl_Type;
2065: l_return_status VARCHAR2(1);
2066: l_mold_tbl INV_MO_LINE_DETAIL_UTIL.g_mmtt_tbl_type;
2067: l_mold_tbl_temp INV_MO_LINE_DETAIL_UTIL.g_mmtt_tbl_type;
2068: l_message VARCHAR2(2000);
2069: l_count NUMBER;
2070: l_from_serial_number VARCHAR2(30);

Line 2067: l_mold_tbl_temp INV_MO_LINE_DETAIL_UTIL.g_mmtt_tbl_type;

2063:
2064: l_pick_release_status INV_PICK_RELEASE_PUB.INV_RELEASE_STATUS_Tbl_Type;
2065: l_return_status VARCHAR2(1);
2066: l_mold_tbl INV_MO_LINE_DETAIL_UTIL.g_mmtt_tbl_type;
2067: l_mold_tbl_temp INV_MO_LINE_DETAIL_UTIL.g_mmtt_tbl_type;
2068: l_message VARCHAR2(2000);
2069: l_count NUMBER;
2070: l_from_serial_number VARCHAR2(30);
2071: l_to_serial_number VARCHAR2(30);

Line 2260: l_mold_tbl := INV_MO_LINE_DETAIL_UTIL.query_rows(

2256:
2257: /* odab Keep this for the Pick Slip
2258: for l_index in 1..l_trolin_tbl.count LOOP
2259: GMI_Reservation_Util.PrintLn('get mold');
2260: l_mold_tbl := INV_MO_LINE_DETAIL_UTIL.query_rows(
2261: p_line_id => l_trolin_tbl(l_index).line_id);
2262: l_mold_tbl_temp := l_mold_tbl;
2263: if( l_mold_tbl.count = 0 ) then
2264: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;