APPS.JA_CN_CFSSE_GENERATE_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 153: FROM fnd_concurrent_requests

149:
150: --Cursor to get request_id for CFS FSG xml output
151: CURSOR c_reqid_fsg_cfs IS
152: SELECT request_id
153: FROM fnd_concurrent_requests
154: WHERE parent_request_id = l_reqid_fsg;
155:
156: --Cursor to get functional currency code of current set of book
157: --this cursor is updated by lyb.

Line 250: UPDATE FND_CONCURRENT_REQUESTS

246: '', '', '', '', '', '', '', '', '', ''
247: );
248:
249: IF (p_OUTPUT_OPTION = 'Y') THEN
250: UPDATE FND_CONCURRENT_REQUESTS
251: SET
252: OUTPUT_FILE_TYPE = 'XML'
253: WHERE
254: REQUEST_ID = l_reqid_fsg;

Line 269: -- from the table 'fnd_concurrent_requests' for the FSG - CFS report.

265: END IF; --( g_stmt_level >= g_dbg_level)
266:
267: --Waiting for the 'Program - Run Financial Statement Generator' completed,
268: -- and then retrive the sub-request id
269: -- from the table 'fnd_concurrent_requests' for the FSG - CFS report.
270: IF l_reqid_fsg <> 0
271: THEN
272: IF FND_CONCURRENT.Wait_For_Request(request_id => l_reqid_fsg,
273: INTERVAL => 5,