APPS.CSP_MO_MTLTXNS_UTIL dependencies on MTL_TXN_REQUEST_LINES

Line 22: -- Purpose : This procedure updates the line status of a move order in the mtl_txn_request_lines table.

18: PROCEDURE Update_Order_Line_Status(
19: /* $Header: cspgtmub.pls 120.1 2006/07/20 05:39:33 hhaugeru noship $ */
20: -- Start of Comments
21: -- Procedure name : update_order_line_status
22: -- Purpose : This procedure updates the line status of a move order in the mtl_txn_request_lines table.
23: -- History :
24: -- Person Date Descriptions
25: -- ------ ---- --------------
26: -- klou 03-Jan-2000 Added options for NONE or FULL validations.

Line 176: update mtl_txn_request_lines

172: ( p_line_id => p_move_order_line_id,
173: p_status => 5 -- update status to 5 = closed
174: );
175: /*
176: update mtl_txn_request_lines
177: set line_status = 5
178: where line_id = p_move_order_line_id;
179:
180: IF fnd_api.to_boolean(p_commit) THEN

Line 267: FROM mtl_txn_request_lines

263: EXIT WHEN l_mo_header_csr%NOTFOUND;
264:
265: BEGIN
266: SELECT line_status INTO l_line_status
267: FROM mtl_txn_request_lines
268: WHERE line_id = l_line_id;
269:
270: IF l_line_status <> p_status_to_be_validated THEN
271: CLOSE l_mo_header_csr;

Line 984: FROM mtl_txn_request_lines

980: SELECT line_id, inventory_item_id, to_subinventory_code, to_locator_id, uom_code
981: INTO l_csp_mtltxn_rec.move_order_line_id, l_csp_mtltxn_rec.inventory_item_id,
982: l_csp_mtltxn_rec.transfer_subinventory, l_csp_mtltxn_rec.transfer_to_location,
983: l_csp_mtltxn_rec.transaction_uom
984: FROM mtl_txn_request_lines
985: WHERE line_id = (SELECT line_id FROM csp_packlist_lines WHERE packlist_line_id = p_packlist_line_id)
986: AND organization_id = p_organization_id;
987:
988: -- Find the serial control code, lot control code and item primary uom.

Line 1560: -- Update the mtl_txn_request_lines and mtl_txn_request_headers tables.

1556: -- messages have been set in the Under_Over_Receipt
1557: RAISE EXCP_USER_DEFINED;
1558: END IF;
1559:
1560: -- Update the mtl_txn_request_lines and mtl_txn_request_headers tables.
1561: BEGIN
1562: select nvl(quantity, 0) into l_trolin_rec.quantity
1563: from mtl_txn_request_lines
1564: where line_id = l_move_order_line_id;

Line 1563: from mtl_txn_request_lines

1559:
1560: -- Update the mtl_txn_request_lines and mtl_txn_request_headers tables.
1561: BEGIN
1562: select nvl(quantity, 0) into l_trolin_rec.quantity
1563: from mtl_txn_request_lines
1564: where line_id = l_move_order_line_id;
1565:
1566: select nvl(quantity_delivered,0) into l_trolin_rec.quantity_delivered
1567: from mtl_txn_request_lines

Line 1567: from mtl_txn_request_lines

1563: from mtl_txn_request_lines
1564: where line_id = l_move_order_line_id;
1565:
1566: select nvl(quantity_delivered,0) into l_trolin_rec.quantity_delivered
1567: from mtl_txn_request_lines
1568: where line_id = l_move_order_line_id;
1569:
1570: EXCEPTION
1571: WHEN OTHERS THEN

Line 1628: from mtl_txn_request_lines

1624: l_temp_id_to_be_processed := l_csp_mtltxn_rec.transaction_temp_id;
1625:
1626: BEGIN
1627: select nvl(quantity, 0) into l_trolin_rec.quantity
1628: from mtl_txn_request_lines
1629: where line_id = l_move_order_line_id;
1630:
1631: select nvl(quantity_delivered,0) into l_trolin_rec.quantity_delivered
1632: from mtl_txn_request_lines

Line 1632: from mtl_txn_request_lines

1628: from mtl_txn_request_lines
1629: where line_id = l_move_order_line_id;
1630:
1631: select nvl(quantity_delivered,0) into l_trolin_rec.quantity_delivered
1632: from mtl_txn_request_lines
1633: where line_id = l_move_order_line_id;
1634:
1635: EXCEPTION
1636: WHEN OTHERS THEN