APPS.INV_TROLIN_UTIL dependencies on MTL_TXN_REQUEST_LINES

Line 1858: UPDATE mtl_txn_request_lines

1854: -- Procedure Update_Row
1855:
1856: PROCEDURE update_row(p_trolin_rec IN inv_move_order_pub.trolin_rec_type) IS
1857: BEGIN
1858: UPDATE mtl_txn_request_lines
1859: SET attribute1 = p_trolin_rec.attribute1
1860: , attribute10 = p_trolin_rec.attribute10
1861: , attribute11 = p_trolin_rec.attribute11
1862: , attribute12 = p_trolin_rec.attribute12

Line 1983: INSERT INTO mtl_txn_request_lines

1979: -- Procedure Insert_Row
1980:
1981: PROCEDURE insert_row(p_trolin_rec IN inv_move_order_pub.trolin_rec_type) IS
1982: BEGIN
1983: INSERT INTO mtl_txn_request_lines
1984: (
1985: attribute1
1986: , attribute10
1987: , attribute11

Line 2179: DELETE FROM mtl_txn_request_lines

2175: -- Procedure Delete_Row
2176:
2177: PROCEDURE delete_row(p_line_id IN NUMBER) IS
2178: BEGIN
2179: DELETE FROM mtl_txn_request_lines
2180: WHERE line_id = p_line_id;
2181: EXCEPTION
2182: WHEN OTHERS THEN
2183: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 2307: FROM mtl_txn_request_lines

2303: , secondary_uom_code
2304: , grade_code
2305: , secondary_required_quantity
2306: --INVCONV END;
2307: FROM mtl_txn_request_lines
2308: WHERE line_id = p_line_id;
2309:
2310: CURSOR l_trolin_csr_header IS
2311: SELECT attribute1

Line 2400: FROM mtl_txn_request_lines

2396: , secondary_uom_code
2397: , grade_code
2398: , secondary_required_quantity
2399: --INVCONV END;
2400: FROM mtl_txn_request_lines
2401: WHERE header_id = p_header_id;
2402: BEGIN
2403: /*inv_debug.message('TRO: line_id '||to_char(p_line_id)||' header_id '||to_char(p_header_id)); */
2404:

Line 2818: FROM mtl_txn_request_lines

2814: , l_trolin_rec.uom_code
2815: , l_trolin_rec.grade_code
2816: , l_trolin_rec.secondary_required_quantity
2817: --INVCONV END
2818: FROM mtl_txn_request_lines
2819: WHERE line_id = p_trolin_rec.line_id
2820: FOR UPDATE NOWAIT;
2821:
2822: -- Row locked. Compare IN attributes to DB attributes.

Line 3734: insert into mtl_txn_request_lines

3730: ,x_return_status IN OUT NOCOPY VARCHAR2) IS
3731:
3732: BEGIN
3733: FORALL i IN 1 .. p_new_trolin_tbl.COUNT
3734: insert into mtl_txn_request_lines
3735: values p_new_trolin_tbl(i);
3736:
3737: x_return_status := fnd_api.g_ret_sts_success;
3738: EXCEPTION