APPS.PO_EDA_IDX_FILE_GEN dependencies on DUAL

Line 70: SELECT Trim(FND_PROFILE.VALUE('PO_EDA_FILES_LOCATION')) INTO v_out_dir FROM dual;

66: l_timestamp := To_Char(SYSDATE,'yyyyMMddHHmmssSSS');
67: END IF;
68:
69:
70: SELECT Trim(FND_PROFILE.VALUE('PO_EDA_FILES_LOCATION')) INTO v_out_dir FROM dual;
71: v_out_file := UTL_FILE.FOPEN(v_out_dir,p_clm_document_number||'_'||l_timestamp||'.idx', 'w',32000);
72:
73: fnd_file.put_line(FND_FILE.LOG,' ');
74: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);

Line 540: SELECT Trim(FND_PROFILE.VALUE('PO_EDA_FILES_LOCATION')) INTO v_out_dir FROM dual;

536: v_out_dir varchar2(2000);
537:
538: BEGIN
539: --CHECK whether the provided directory in the profile option PO_EDA_FILES_LOCATION is proper or not
540: SELECT Trim(FND_PROFILE.VALUE('PO_EDA_FILES_LOCATION')) INTO v_out_dir FROM dual;
541: v_tmp_file := UTL_FILE.FOPEN(v_out_dir,'t.tmp', 'w',32000);
542: UTL_FILE.FREMOVE(v_out_dir,'t.tmp');
543:
544: -- Check if the concurrent program is being restarted due to completion of child request

Line 546: SELECT FND_PROFILE.VALUE('PO_EDA_BATCH_SIZE') into l_max_doc_in_batch FROM dual;

542: UTL_FILE.FREMOVE(v_out_dir,'t.tmp');
543:
544: -- Check if the concurrent program is being restarted due to completion of child request
545: begin
546: SELECT FND_PROFILE.VALUE('PO_EDA_BATCH_SIZE') into l_max_doc_in_batch FROM dual;
547: exception
548: when others then
549: l_max_doc_in_batch := 5;
550: end;

Line 842: FROM dual where EXISTS(

838: --checking whether any child program has failed
839: l_warning_flag := 'N';
840: BEGIN
841: SELECT 'Y' into l_warning_flag
842: FROM dual where EXISTS(
843: SELECT 1
844: FROM FND_CONCURRENT_REQUESTS t WHERE PARENT_REQUEST_ID =FND_GLOBAL.CONC_REQUEST_ID AND ARGUMENT1 = 'N' AND NUMBER_OF_ARGUMENTS = 8
845: AND 3 > (SELECT Count(1) FROM FND_CONCURRENT_REQUESTS i WHERE i.ARGUMENT2 = t.ARGUMENT2 AND i.STATUS_CODE = 'C' AND
846: t.PARENT_REQUEST_ID = i.PARENT_REQUEST_ID));