APPS.OZF_WEBADI_INTERFACE_PVT dependencies on V$PARAMETER

Line 661: FROM v$parameter

657:
658: CURSOR C
659: IS
660: SELECT value
661: FROM v$parameter
662: WHERE name = 'utl_file_dir';
663:
664: CURSOR csr_get_party_site_id(cv_site_number IN VARCHAR2) IS
665: SELECT party_site_id

Line 842: FROM v$parameter

838: EXCEPTION
839: WHEN UTL_FILE.INVALID_PATH THEN
840: SELECT decode(instr(value,',',1,1), 0, value, substr(value,1,instr(value,',',1,1)-1))
841: INTO l_file_dir
842: FROM v$parameter
843: WHERE name = 'utl_file_dir';
844: l_file := utl_file.fopen( l_file_dir, l_file_name, 'w' , 32000);
845: END;
846: END IF;