DBA Data[Home] [Help]

APPS.PER_DATA_UPDATE_REPORT dependencies on V$PARAMETER

Line 692: FROM v$parameter

688: -- Getting the Util file directory name.mostly it'll be /sqlcom/outbound )
689: BEGIN
690: SELECT value
691: INTO l_audit_log_dir
692: FROM v$parameter
693: WHERE LOWER(name) = 'utl_file_dir';
694: -- Check whether more than one util file directory is found
695: IF INSTR(l_audit_log_dir,',') > 0 THEN
696: l_audit_log_dir := substr(l_audit_log_dir,1,instr(l_audit_log_dir,',')-1);