DBA Data[Home] [Help]

APPS.CSP_PICK_UTILS dependencies on INV_TROLIN_UTIL

Line 590: l_trolin_rec := INV_Trolin_util.Query_Row( mo_line_rec.line_id );

586:
587: IF (l_num_of_rows >= 1) THEN
588:
589: -- update mtl_txn_request_lines with the detailed quantity
590: l_trolin_rec := INV_Trolin_util.Query_Row( mo_line_rec.line_id );
591: l_trolin_rec.quantity_detailed := l_detailed_qty;
592: l_trolin_rec.last_update_date := SYSDATE;
593: l_trolin_rec.last_updated_by := FND_GLOBAL.USER_ID;
594: l_trolin_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line 596: INV_Trolin_Util.Update_Row(l_trolin_rec);

592: l_trolin_rec.last_update_date := SYSDATE;
593: l_trolin_rec.last_updated_by := FND_GLOBAL.USER_ID;
594: l_trolin_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
595:
596: INV_Trolin_Util.Update_Row(l_trolin_rec);
597:
598: /* update mtl_txn_request_lines
599: set quantity_detailed = l_detailed_qty
600: where line_id = mo_line_rec.line_id; */

Line 1787: l_trolin_rec := INV_Trolin_util.Query_Row( pickline_rec.line_id );

1783: LOOP
1784: FETCH pickline_cur INTO pickline_rec;
1785: EXIT WHEN pickline_cur%NOTFOUND;
1786:
1787: l_trolin_rec := INV_Trolin_util.Query_Row( pickline_rec.line_id );
1788: l_trolin_rec.quantity_detailed := pickline_rec.qty_det;
1789: l_trolin_rec.last_update_date := SYSDATE;
1790: l_trolin_rec.last_updated_by := FND_GLOBAL.USER_ID;
1791: l_trolin_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line 1793: INV_Trolin_Util.Update_Row(l_trolin_rec);

1789: l_trolin_rec.last_update_date := SYSDATE;
1790: l_trolin_rec.last_updated_by := FND_GLOBAL.USER_ID;
1791: l_trolin_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1792:
1793: INV_Trolin_Util.Update_Row(l_trolin_rec);
1794: commit;
1795:
1796: END LOOP;
1797: