APPS.INV_TROLIN_UTIL dependencies on MTL_TXN_REQUEST_LINES

Line 1872: FROM gme_material_details gmd,mtl_txn_request_lines mtrl

1868: SELECT 1
1869: INTO l_batch_exists
1870: FROM dual
1871: WHERE EXISTS (SELECT gmd.line_no
1872: FROM gme_material_details gmd,mtl_txn_request_lines mtrl
1873: WHERE gmd.material_detail_id=p_trolin_rec.txn_source_line_id
1874: AND mtrl.organization_id=p_trolin_rec.organization_id
1875: AND mtrl.txn_source_id=p_trolin_rec.txn_source_id
1876: AND mtrl.inventory_item_id=p_trolin_rec.inventory_item_id

Line 1890: UPDATE mtl_txn_request_lines

1886: ELSE
1887: l_tran_source_typ_id:=p_trolin_rec.transaction_source_type_id;
1888: END IF;
1889:
1890: UPDATE mtl_txn_request_lines
1891: SET attribute1 = p_trolin_rec.attribute1
1892: , attribute10 = p_trolin_rec.attribute10
1893: , attribute11 = p_trolin_rec.attribute11
1894: , attribute12 = p_trolin_rec.attribute12

Line 2018: INSERT INTO mtl_txn_request_lines

2014: -- Procedure Insert_Row
2015:
2016: PROCEDURE insert_row(p_trolin_rec IN inv_move_order_pub.trolin_rec_type) IS
2017: BEGIN
2018: INSERT INTO mtl_txn_request_lines
2019: (
2020: attribute1
2021: , attribute10
2022: , attribute11

Line 2214: DELETE FROM mtl_txn_request_lines

2210: -- Procedure Delete_Row
2211:
2212: PROCEDURE delete_row(p_line_id IN NUMBER) IS
2213: BEGIN
2214: DELETE FROM mtl_txn_request_lines
2215: WHERE line_id = p_line_id;
2216: EXCEPTION
2217: WHEN OTHERS THEN
2218: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 2342: FROM mtl_txn_request_lines

2338: , secondary_uom_code
2339: , grade_code
2340: , secondary_required_quantity
2341: --INVCONV END;
2342: FROM mtl_txn_request_lines
2343: WHERE line_id = p_line_id;
2344:
2345: CURSOR l_trolin_csr_header IS
2346: SELECT attribute1

Line 2435: FROM mtl_txn_request_lines

2431: , secondary_uom_code
2432: , grade_code
2433: , secondary_required_quantity
2434: --INVCONV END;
2435: FROM mtl_txn_request_lines
2436: WHERE header_id = p_header_id;
2437: BEGIN
2438: /*inv_debug.message('TRO: line_id '||to_char(p_line_id)||' header_id '||to_char(p_header_id)); */
2439:

Line 2853: FROM mtl_txn_request_lines

2849: , l_trolin_rec.uom_code
2850: , l_trolin_rec.grade_code
2851: , l_trolin_rec.secondary_required_quantity
2852: --INVCONV END
2853: FROM mtl_txn_request_lines
2854: WHERE line_id = p_trolin_rec.line_id
2855: FOR UPDATE NOWAIT;
2856:
2857: -- Row locked. Compare IN attributes to DB attributes.

Line 3769: insert into mtl_txn_request_lines

3765: ,x_return_status IN OUT NOCOPY VARCHAR2) IS
3766:
3767: BEGIN
3768: FORALL i IN 1 .. p_new_trolin_tbl.COUNT
3769: insert into mtl_txn_request_lines
3770: values p_new_trolin_tbl(i);
3771:
3772: x_return_status := fnd_api.g_ret_sts_success;
3773: EXCEPTION