APPS.JA_CN_FSG_XML_SUBMIT_PROG dependencies on FND_CONCURRENT_REQUESTS

Line 209: UPDATE FND_CONCURRENT_REQUESTS

205: '', '', '', '', '', '', '', '', '', '',
206: '', '', '', '', '', '', '', '', '', ''
207: );
208: IF (X_output_option = 'Y') THEN
209: UPDATE FND_CONCURRENT_REQUESTS
210: SET
211: OUTPUT_FILE_TYPE = 'XML'
212: WHERE
213: REQUEST_ID = req_id;

Line 257: UPDATE FND_CONCURRENT_REQUESTS

253: '', '', '', '', '', '', '', '', '', '',
254: '', '', '', '', '', '', '', '', ''
255: );
256: IF (X_output_option = 'Y') THEN
257: UPDATE FND_CONCURRENT_REQUESTS
258: SET
259: OUTPUT_FILE_TYPE = 'XML'
260: WHERE
261: REQUEST_ID = req_id;

Line 554: FND_CONCURRENT_REQUESTS R

550: SELECT APP.APPLICATION_ID
551: INTO l_template_appl
552: FROM FND_APPLICATION_VL APP,
553: FND_CONCURRENT_PROGRAMS FCP,
554: FND_CONCURRENT_REQUESTS R
555: WHERE FCP.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID
556: AND R.REQUEST_ID = l_fsg_request_id
557: AND APP.APPLICATION_ID = FCP.APPLICATION_ID;
558: --submit XML publisher concurrent program

Line 1359: UPDATE FND_CONCURRENT_REQUESTS

1355: '', '', '', '', '', '', '', '', '', ''
1356: );
1357:
1358: IF (pv_output_option = 'Y') THEN
1359: UPDATE FND_CONCURRENT_REQUESTS
1360: SET
1361: OUTPUT_FILE_TYPE = 'XML'
1362: WHERE
1363: REQUEST_ID = ln_reqid_fsg;

Line 1368: --sub-request id from the table 'fnd_concurrent_requests' for the FSG - CFS report.

1364: END IF;
1365: COMMIT;
1366:
1367: --(4.2)Waiting for the 'Cash Flow Statement - FSG' completed, and then retrive the
1368: --sub-request id from the table 'fnd_concurrent_requests' for the FSG - CFS report.
1369: IF ln_reqid_fsg<>0
1370: THEN
1371: IF FND_CONCURRENT.Wait_For_Request(request_id => ln_reqid_fsg
1372: ,interval => ln_waiting_interval

Line 2357: UPDATE FND_CONCURRENT_REQUESTS

2353: '', '', '', '', '', '', '', '', '', ''
2354: );
2355:
2356: IF (pv_output_option = 'Y') THEN
2357: UPDATE FND_CONCURRENT_REQUESTS
2358: SET
2359: OUTPUT_FILE_TYPE = 'XML'
2360: WHERE
2361: REQUEST_ID = ln_reqid_fsg;

Line 2366: --sub-request id from the table 'fnd_concurrent_requests' for the FSG - CFS report.

2362: END IF;
2363: COMMIT;
2364:
2365: --(4.2)Waiting for the 'Cash Flow Statement - FSG' completed, and then retrive the
2366: --sub-request id from the table 'fnd_concurrent_requests' for the FSG - CFS report.
2367: IF ln_reqid_fsg<>0
2368: THEN
2369: IF FND_CONCURRENT.Wait_For_Request(request_id => ln_reqid_fsg
2370: ,interval => ln_waiting_interval