DBA Data[Home] [Help]

APPS.INV_REPLENISH_DETAIL_PUB dependencies on INV_TROLIN_UTIL

Line 211: l_trolin_tbl(1) := inv_trolin_util.query_row(p_line_id);

207: l_honor_case_pick_count NUMBER := 0;
208: l_counter NUMBER := 1;
209:
210: BEGIN
211: l_trolin_tbl(1) := inv_trolin_util.query_row(p_line_id);
212: OPEN c_mtrh;
213: FETCH c_mtrh INTO l_request_number, l_grouping_rule_id;
214: CLOSE c_mtrh;
215:

Line 1332: l_trolin_tbl := inv_trolin_util.query_rows(p_line_id => l_line_id);

1328: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1329: BEGIN
1330: --inv_debug.message('auto pick confirm');
1331: --inv_debug.message('get trolin');
1332: l_trolin_tbl := inv_trolin_util.query_rows(p_line_id => l_line_id);
1333: --inv_debug.message('get mold');
1334: l_mold_tbl := inv_mo_line_detail_util.query_rows(p_line_id => l_line_id);
1335: --inv_debug.message('number of mold record is ' || l_mold_tbl.count);
1336: inv_pick_wave_pick_confirm_pub.pick_confirm(