APPS.INV_PICK_WAVE_PICK_CONFIRM_PUB dependencies on INV_MO_LINE_DETAIL_UTIL

Line 26: , p_mold_tbl IN INV_MO_LINE_DETAIL_UTIL.g_mmtt_tbl_type

22: , x_msg_data OUT NOCOPY VARCHAR2
23: , p_move_order_type IN NUMBER
24: , p_transaction_mode IN NUMBER
25: , p_trolin_tbl IN INV_Move_Order_PUB.Trolin_Tbl_Type
26: , p_mold_tbl IN INV_MO_LINE_DETAIL_UTIL.g_mmtt_tbl_type
27: , x_mmtt_tbl IN OUT NOCOPY INV_MO_LINE_DETAIL_UTIL.g_mmtt_tbl_type
28: , x_trolin_tbl IN OUT NOCOPY INV_Move_Order_PUB.Trolin_Tbl_Type
29: , p_transaction_date IN DATE DEFAULT NULL
30: ) IS

Line 27: , x_mmtt_tbl IN OUT NOCOPY INV_MO_LINE_DETAIL_UTIL.g_mmtt_tbl_type

23: , p_move_order_type IN NUMBER
24: , p_transaction_mode IN NUMBER
25: , p_trolin_tbl IN INV_Move_Order_PUB.Trolin_Tbl_Type
26: , p_mold_tbl IN INV_MO_LINE_DETAIL_UTIL.g_mmtt_tbl_type
27: , x_mmtt_tbl IN OUT NOCOPY INV_MO_LINE_DETAIL_UTIL.g_mmtt_tbl_type
28: , x_trolin_tbl IN OUT NOCOPY INV_Move_Order_PUB.Trolin_Tbl_Type
29: , p_transaction_date IN DATE DEFAULT NULL
30: ) IS
31: l_api_version_number NUMBER := 1.0;

Line 36: l_mold_tbl INV_MO_Line_Detail_Util.g_mmtt_Tbl_type := p_mold_tbl;

32: l_api_name VARCHAR2(80) := 'INV_PICK_WAVE_PICK_CONFIRM_PUB';
33: l_move_order_type NUMBER := p_move_order_type;
34: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type := p_trolin_tbl;
35: l_trolin_rec INV_Move_Order_PUB.Trolin_Rec_Type;
36: l_mold_tbl INV_MO_Line_Detail_Util.g_mmtt_Tbl_type := p_mold_tbl;
37: l_return_status VARCHAR2(1);
38: l_sum_trx_qty NUMBER := 0;
39: l_qty_delivered NUMBER := 0;
40: l_qty_detailed NUMBER := 0;

Line 151: l_mold_tbl := INV_MO_LINE_DETAIL_UTIL.Query_Rows( p_line_id => l_trolin_tbl(i).line_id);

147: FND_MSG_PUB.ADD;
148: --rollback to TO_TRX_LINE_SAVE;
149: --raise FND_API.G_EXC_ERROR;
150: else
151: l_mold_tbl := INV_MO_LINE_DETAIL_UTIL.Query_Rows( p_line_id => l_trolin_tbl(i).line_id);
152: IF (l_debug = 1) THEN
153: TraceLog('mold records = ' || l_mold_tbl.count, 'Pick_Confirm');
154: END IF;
155: --end if;

Line 222: inv_mo_line_detail_util.update_row(l_return_status, l_mold_tbl(j));

218: end if;
219: IF (l_debug = 1) THEN
220: TraceLog('mold pick slip number is ' || l_mold_tbl(j).pick_slip_number, 'Pick_Confirm');
221: END IF;
222: inv_mo_line_detail_util.update_row(l_return_status, l_mold_tbl(j));
223: IF (l_debug = 1) THEN
224: TraceLog('after update transaction_status = 3', 'Pick_Confirm');
225: END IF;
226: if( l_return_status = FND_API.G_RET_STS_ERROR ) then

Line 339: inv_mo_line_detail_util.update_row(l_return_status, l_mold_tbl(j));

335:
336: l_mold_tbl(j).acct_period_id := l_period_id;
337: -- End Bug 1992880;
338:
339: inv_mo_line_detail_util.update_row(l_return_status, l_mold_tbl(j));
340: IF (l_debug = 1) THEN
341: TraceLog('after update transaction_status = 3', 'Pick_Confirm');
342: END IF;
343: if( l_return_status = FND_API.G_RET_STS_ERROR ) then