APPS.WMS_LABEL_PUB dependencies on V$PARAMETER

Line 537: into v_st_position,v_end_position from v$parameter

533: v_w_position number(3);
534:
535: BEGIN
536: select INSTR(value,',',1,2),INSTR(value,',',1,3)
537: into v_st_position,v_end_position from v$parameter
538: where upper(name) = 'UTL_FILE_DIR';
539:
540: v_w_position := v_end_position - v_st_position - 1;
541:

Line 543: into v_log_name from v$parameter

539:
540: v_w_position := v_end_position - v_st_position - 1;
541:
542: select substr(value,v_st_position+1,v_w_position)
543: into v_log_name from v$parameter
544: where upper(name) = 'UTL_FILE_DIR';
545: v_log_name := ltrim(v_log_name);
546: FND_FILE.PUT_NAMES(v_log_name,v_log_name,v_log_name);
547: return v_log_name;