DBA Data[Home] [Help]

APPS.MTL_CCEOI_CONC_PVT dependencies on V$PARAMETER

Line 29: into v_st_position,v_end_position from v$parameter

25: v_w_position number(3);
26:
27: begin
28: select INSTR(value,',',1,2),INSTR(value,',',1,3)
29: into v_st_position,v_end_position from v$parameter
30: where upper(name) = 'UTL_FILE_DIR';
31:
32: v_w_position := v_end_position - v_st_position - 1;
33:

Line 35: into v_log_name from v$parameter

31:
32: v_w_position := v_end_position - v_st_position - 1;
33:
34: select substr(value,v_st_position+1,v_w_position)
35: into v_log_name from v$parameter
36: where upper(name) = 'UTL_FILE_DIR';
37: v_log_name := ltrim(v_log_name);
38: FND_FILE.PUT_NAMES(v_log_name,v_log_name,v_log_name);
39: end;