273: '',
274: '',
275: '');
276: IF (X_output_option = 'Y') THEN
277: UPDATE FND_CONCURRENT_REQUESTS
278: SET OUTPUT_FILE_TYPE = 'XML'
279: WHERE REQUEST_ID = req_id;
280: END IF;
281: ELSE
311: TO_CHAR(X_SUBREQUEST_ID),
312: X_appl_deflt_name,
313: chr(0));
314: IF (X_output_option = 'Y') THEN
315: UPDATE FND_CONCURRENT_REQUESTS
316: SET OUTPUT_FILE_TYPE = 'XML'
317: WHERE REQUEST_ID = req_id;
318: END IF;
319: END IF;
630: SELECT APP.APPLICATION_ID
631: INTO l_template_appl
632: FROM FND_APPLICATION_VL APP,
633: FND_CONCURRENT_PROGRAMS FCP,
634: FND_CONCURRENT_REQUESTS R
635: WHERE FCP.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID
636: AND R.REQUEST_ID = l_fsg_request_id
637: AND APP.APPLICATION_ID = FCP.APPLICATION_ID;
638: --submit XML publisher concurrent program