APPS.INV_MO_ADMIN_PUB dependencies on MTL_TXN_REQUEST_HEADERS

Line 105: Update MTL_TXN_REQUEST_HEADERS

101: end loop;
102:
103:
104: -- Updating the who columns for bug 3277406
105: Update MTL_TXN_REQUEST_HEADERS
106: set header_status = 6,
107: last_updated_by = fnd_global.user_id,
108: last_update_login = fnd_global.login_id,
109: last_update_date = sysdate

Line 193: FROM mtl_txn_request_headers

189: -- API Body
190: BEGIN
191: SELECT header_status, request_number
192: INTO l_hdr_status, l_request_number
193: FROM mtl_txn_request_headers
194: WHERE Header_id = l_header_id;
195: EXCEPTION
196: WHEN No_Data_Found THEN
197: RAISE FND_API.G_EXC_ERROR;

Line 250: Update MTL_TXN_REQUEST_HEADERS

246: End Loop;
247:
248:
249: -- Updating the who columns for bug 3277406
250: Update MTL_TXN_REQUEST_HEADERS
251: set header_status = 5,
252: last_updated_by = fnd_global.user_id,
253: last_update_login = fnd_global.login_id,
254: last_update_date = sysdate

Line 336: from mtl_txn_request_headers

332: -- API Body
333: Begin
334: Select header_status, request_number
335: into l_hdr_status, l_request_number
336: from mtl_txn_request_headers
337: where
338: Header_id = l_header_id;
339: Exception
340: When No_Data_Found Then

Line 361: Delete MTL_TXN_REQUEST_HEADERS

357: Delete MTL_TXN_REQUEST_LINES
358: where
359: header_id = l_header_id;
360:
361: Delete MTL_TXN_REQUEST_HEADERS
362: where
363: header_id = l_header_id;
364:
365: x_return_status := l_return_status;