DBA Data[Home] [Help]

APPS.BOM_TEST_SUBSCR_PKG dependencies on V$PARAMETER

Line 45: SELECT VALUE INTO l_debug_file_dir FROM V$PARAMETER WHERE NAME = 'utl_file_dir';

41: l_errbuff VARCHAR2(3000);
42: l_error VARCHAR2(30);
43:
44: BEGIN
45: SELECT VALUE INTO l_debug_file_dir FROM V$PARAMETER WHERE NAME = 'utl_file_dir';
46: IF INSTR(l_debug_file_dir,',') <> 0 THEN
47: l_debug_file_dir := SUBSTR(l_debug_file_dir, 1, INSTR(l_debug_file_dir, ',') - 1);
48: END IF;
49: l_log_file := 'BOM_TEST_SUBSCR'||'_'||TO_CHAR(SYSDATE, 'DDMONYYYY_HH24MISS')||'.err';