APPS.INV_TROHDR_UTIL dependencies on MTL_TXN_REQUEST_HEADERS

Line 858: UPDATE mtl_txn_request_headers

854: -- Procedure Update_Row
855:
856: PROCEDURE update_row(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type) IS
857: BEGIN
858: UPDATE mtl_txn_request_headers
859: SET attribute1 = p_trohdr_rec.attribute1
860: , attribute10 = p_trohdr_rec.attribute10
861: , attribute11 = p_trohdr_rec.attribute11
862: , attribute12 = p_trohdr_rec.attribute12

Line 911: INSERT INTO mtl_txn_request_headers

907: -- Procedure Insert_Row
908:
909: PROCEDURE insert_row(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type) IS
910: BEGIN
911: INSERT INTO mtl_txn_request_headers
912: (
913: attribute1
914: , attribute10
915: , attribute11

Line 1007: DELETE FROM mtl_txn_request_headers

1003: -- Procedure Delete_Row
1004:
1005: PROCEDURE delete_row(p_header_id IN NUMBER) IS
1006: BEGIN
1007: DELETE FROM mtl_txn_request_headers
1008: WHERE header_id = p_header_id;
1009: EXCEPTION
1010: WHEN OTHERS THEN
1011: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1122: FROM mtl_txn_request_headers

1118: , l_trohdr_rec.move_order_type
1119: , l_trohdr_rec.transaction_type_id
1120: , l_trohdr_rec.grouping_rule_id
1121: , l_trohdr_rec.ship_to_location_id
1122: FROM mtl_txn_request_headers
1123: WHERE header_id = p_header_id;
1124:
1125: RETURN l_trohdr_rec;
1126: EXCEPTION

Line 1219: FROM mtl_txn_request_headers

1215: , l_trohdr_rec.move_order_type
1216: , l_trohdr_rec.transaction_type_id
1217: , l_trohdr_rec.grouping_rule_id
1218: , l_trohdr_rec.ship_to_location_id
1219: FROM mtl_txn_request_headers
1220: WHERE header_id = p_trohdr_rec.header_id
1221: FOR UPDATE NOWAIT;
1222:
1223: -- Row locked. Compare IN attributes to DB attributes.