APPS.INV_PICK_WAVE_PICK_CONFIRM_PUB dependencies on INV_TROLIN_UTIL

Line 137: l_trolin_rec := INV_Trolin_Util.Query_Row(l_trolin_tbl(i).line_id);

133: IF (l_trolin_tbl(i).return_status <> FND_API.G_RET_STS_UNEXP_ERROR and
134: l_trolin_tbl(i).return_status <> FND_API.G_RET_STS_ERROR) THEN
135:
136: --if( l_trolin_tbl(i) is not null ) then
137: l_trolin_rec := INV_Trolin_Util.Query_Row(l_trolin_tbl(i).line_id);
138: l_trolin_tbl(i) := l_trolin_rec;
139: l_qty_detailed := l_trolin_tbl(i).quantity_detailed;
140: l_qty_delivered := nvl(l_trolin_tbl(i).quantity_delivered, 0);
141: IF (l_debug = 1) THEN

Line 271: inv_trolin_util.update_row(l_trolin_tbl(i));

267:
268: IF (l_debug = 1) THEN
269: TraceLog('calling update_row of trolin', 'Pick Confirm');
270: END IF;
271: inv_trolin_util.update_row(l_trolin_tbl(i));
272: IF (l_debug = 1) THEN
273: TraceLog('after calling update_row of trolin', 'Pick Confirm');
274: END IF;
275: end if;

Line 284: l_trolin_tbl(1) := inv_trolin_util.query_row(p_line_id => l_mold_tbl(j).move_order_line_id);

280: -- if only line detail records is passed
281: If( l_mold_tbl.count <> 0 ) then
282: for j in 1..l_mold_tbl.count LOOP
283: --if( l_mold_tbl(j) is not null ) then
284: l_trolin_tbl(1) := inv_trolin_util.query_row(p_line_id => l_mold_tbl(j).move_order_line_id);
285:
286: l_qty_detailed := l_trolin_tbl(1).quantity_detailed;
287: l_qtY_delivered := l_trolin_tbl(1).quantity_delivered;
288: if( l_qty_detailed = l_qty_delivered OR l_qty_detailed = 0 ) then

Line 379: inv_trolin_util.update_row(l_trolin_tbl(1));

375: l_trolin_tbl(1).program_update_date := SYSDATE;
376: l_trolin_tbl(1).request_id := fnd_global.conc_request_id;
377: l_trolin_tbl(1).program_application_id :=
378: fnd_global.prog_appl_id;
379: inv_trolin_util.update_row(l_trolin_tbl(1));
380: --end if;
381: end loop;
382: end if;
383: end if;