DBA Data[Home] [Help]

APPS.BIS_UTILITIES_PVT dependencies on V$PARAMETER

Line 5291: l_default_dir_name VARCHAR2(512); -- v$parameter%VALUE; --

5287:
5288: FUNCTION get_default_dir_name -- 2694978
5289: RETURN VARCHAR2
5290: IS
5291: l_default_dir_name VARCHAR2(512); -- v$parameter%VALUE; --
5292: BEGIN
5293:
5294: SELECT vp.value
5295: INTO l_default_dir_name

Line 5296: FROM v$parameter vp

5292: BEGIN
5293:
5294: SELECT vp.value
5295: INTO l_default_dir_name
5296: FROM v$parameter vp
5297: WHERE vp.name = BIS_UTILITIES_PUB.G_UTL_FILE_DIR; -- 'utl_file_dir';
5298:
5299: IF (LENGTH(l_default_dir_name) > 0) THEN
5300: IF (INSTR(l_default_dir_name,',', 1, 1) > 0) THEN

Line 5352: l_default_dir_name VARCHAR2(512); -- v$parameter%VALUE;

5348: p_dir_name IN VARCHAR2,
5349: x_return_status OUT NOCOPY VARCHAR2,
5350: x_return_msg OUT NOCOPY VARCHAR2)
5351: IS
5352: l_default_dir_name VARCHAR2(512); -- v$parameter%VALUE;
5353: l_default_log_name VARCHAR2(512); -- v$parameter%VALUE;
5354:
5355: BEGIN
5356: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5353: l_default_log_name VARCHAR2(512); -- v$parameter%VALUE;

5349: x_return_status OUT NOCOPY VARCHAR2,
5350: x_return_msg OUT NOCOPY VARCHAR2)
5351: IS
5352: l_default_dir_name VARCHAR2(512); -- v$parameter%VALUE;
5353: l_default_log_name VARCHAR2(512); -- v$parameter%VALUE;
5354:
5355: BEGIN
5356: x_return_status := FND_API.G_RET_STS_SUCCESS;
5357: x_return_msg := NULL;