DBA Data[Home] [Help]

APPS.CSP_MO_MTLTXNS_UTIL dependencies on INV_TROLIN_UTIL

Line 171: INV_Trolin_Util.Update_Row_Status

167: -- call a core apps api to update the line status.
168: -- Since the core apps api does not return a status, we have to catch the exception it may throw.
169: BEGIN
170:
171: INV_Trolin_Util.Update_Row_Status
172: ( p_line_id => p_move_order_line_id,
173: p_status => 5 -- update status to 5 = closed
174: );
175: /*

Line 1583: INV_Trolin_Util.Update_Row_Status

1579: -- Update order line status and order header status
1580: IF l_trolin_rec.quantity_delivered = l_trolin_rec.quantity
1581: OR (p_receiving_option = 3) THEN
1582:
1583: INV_Trolin_Util.Update_Row_Status
1584: ( p_line_id => l_move_order_line_id,
1585: p_status => 5 ); -- update status to 5 = closed
1586:
1587: INV_Trohdr_Util.Update_Row_Status

Line 1646: INV_Trolin_Util.Update_Row_Status

1642: END;
1643:
1644: -- update order line status and order header status
1645: IF l_trolin_rec.quantity_delivered = l_trolin_rec.quantity THEN
1646: INV_Trolin_Util.Update_Row_Status
1647: ( p_line_id => l_move_order_line_id,
1648: p_status => 5 ); -- update status to 5 = closed
1649:
1650: -- check whether all the line statuses of the order have been closed.

Line 2848: l_trolin_rec := INV_Trolin_util.Query_Row(l_csp_mtltxn_rec.move_order_line_id );

2844: END IF;
2845: /* 06/08/2000 klou: do not need to update the quantity delivered because this will mess up the move in quantity
2846: in the move order status form.
2847: -- Update the quantity_delivered to reflect the over-received quantity.
2848: l_trolin_rec := INV_Trolin_util.Query_Row(l_csp_mtltxn_rec.move_order_line_id );
2849: l_trolin_rec.quantity_delivered := nvl(l_trolin_rec.quantity_delivered,0) + p_discrepancy_qty;
2850: l_trolin_rec.last_update_date := SYSDATE;
2851: l_trolin_rec.last_updated_by := FND_GLOBAL.USER_ID;
2852: l_trolin_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line 2853: INV_Trolin_Util.Update_Row(l_trolin_rec);

2849: l_trolin_rec.quantity_delivered := nvl(l_trolin_rec.quantity_delivered,0) + p_discrepancy_qty;
2850: l_trolin_rec.last_update_date := SYSDATE;
2851: l_trolin_rec.last_updated_by := FND_GLOBAL.USER_ID;
2852: l_trolin_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
2853: INV_Trolin_Util.Update_Row(l_trolin_rec);
2854: */
2855:
2856: CSP_Material_Transactions_PVT.Update_material_transactions(
2857: P_Api_Version_Number => l_api_version_number,