APPS.OZF_WEBADI_INTERFACE_PVT dependencies on V$PARAMETER

Line 904: FROM v$parameter

900:
901: CURSOR C
902: IS
903: SELECT value
904: FROM v$parameter
905: WHERE name = 'utl_file_dir';
906:
907: CURSOR csr_get_party_site_id(cv_site_number IN VARCHAR2) IS
908: SELECT party_site_id

Line 1188: FROM v$parameter

1184: EXCEPTION
1185: WHEN UTL_FILE.INVALID_PATH THEN
1186: SELECT decode(instr(value,',',1,1), 0, value, substr(value,1,instr(value,',',1,1)-1))
1187: INTO l_file_dir
1188: FROM v$parameter
1189: WHERE name = 'utl_file_dir';
1190: l_file := utl_file.fopen( l_file_dir, l_file_name, 'w' , 32000);
1191: END;
1192: END IF;