DBA Data[Home] [Help]

APPS.PO_EDA_IDX_FILE_GEN dependencies on FND_GLOBAL

Line 74: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);

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);
75: fnd_file.put_line(FND_FILE.LOG,'Output Directory: ' || v_out_dir);
76: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
77: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number '||p_clm_document_number);
78: fnd_file.put_line(FND_FILE.LOG,'Is Mod '||P_IS_MOD);

Line 587: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);

583:
584:
585:
586: fnd_file.put_line(FND_FILE.LOG,' ');
587: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
588: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
589: fnd_file.put_line(FND_FILE.LOG,'Is Mod '||P_IS_MOD);
590: fnd_file.put_line(FND_FILE.LOG,'CLM Document Number '||p_clm_document_number);
591: fnd_file.put_line(FND_FILE.LOG,' ');

Line 826: OPEN csr_req_stats(FND_GLOBAL.CONC_REQUEST_ID);

822: END IF;
823:
824: END IF;
825:
826: OPEN csr_req_stats(FND_GLOBAL.CONC_REQUEST_ID);
827: LOOP
828: FETCH csr_req_stats INTO l_doc_type,l_doc_number,l_timestamp;
829: EXIT WHEN csr_req_stats%NOTFOUND;
830: IF(l_doc_type = 'N') THEN

Line 844: FROM FND_CONCURRENT_REQUESTS t WHERE PARENT_REQUEST_ID =FND_GLOBAL.CONC_REQUEST_ID AND ARGUMENT1 = 'N' AND NUMBER_OF_ARGUMENTS = 8

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));
847: EXCEPTION
848: WHEN NO_DATA_FOUND THEN