DBA Data[Home] [Help]

APPS.INV_MO_ADMIN_PUB dependencies on MTL_TXN_REQUEST_HEADERS

Line 106: Update MTL_TXN_REQUEST_HEADERS

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

Line 174: l_request_number MTL_TXN_REQUEST_HEADERS.request_number%type := NULL;

170: l_hdr_status Number;
171: --l_request_number Varchar2(25) := NULL;
172: --Bug 9118049, Request_number column in MTRH is defined to accept 30 characters.
173: --Stretching the variable from 25 char to 30 chars.
174: l_request_number MTL_TXN_REQUEST_HEADERS.request_number%type := NULL;
175: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
176: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
177: l_line_status NUMBER := 0;
178:

Line 198: FROM mtl_txn_request_headers

194: -- API Body
195: BEGIN
196: SELECT header_status, request_number
197: INTO l_hdr_status, l_request_number
198: FROM mtl_txn_request_headers
199: WHERE Header_id = l_header_id;
200: EXCEPTION
201: WHEN No_Data_Found THEN
202: RAISE FND_API.G_EXC_ERROR;

Line 256: Update MTL_TXN_REQUEST_HEADERS

252:
253:
254: -- Updating the who columns for bug 3277406
255: -- Updating status date for bug 8563083
256: Update MTL_TXN_REQUEST_HEADERS
257: set header_status = 5,
258: last_updated_by = fnd_global.user_id,
259: last_update_login = fnd_global.login_id,
260: last_update_date = sysdate,

Line 324: l_request_number MTL_TXN_REQUEST_HEADERS.request_number%type := NULL;

320: l_hdr_status Number;
321: --l_request_number Varchar2(25) := NULL;
322: --Bug 9118049, Request_number column in MTRH is defined to accept 30 characters.
323: --Stretching the variable from 25 char to 30 chars.
324: l_request_number MTL_TXN_REQUEST_HEADERS.request_number%type := NULL;
325: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
326:
327: BEGIN
328:

Line 346: from mtl_txn_request_headers

342: -- API Body
343: Begin
344: Select header_status, request_number
345: into l_hdr_status, l_request_number
346: from mtl_txn_request_headers
347: where
348: Header_id = l_header_id;
349: Exception
350: When No_Data_Found Then

Line 371: Delete MTL_TXN_REQUEST_HEADERS

367: Delete MTL_TXN_REQUEST_LINES
368: where
369: header_id = l_header_id;
370:
371: Delete MTL_TXN_REQUEST_HEADERS
372: where
373: header_id = l_header_id;
374:
375: x_return_status := l_return_status;