DBA Data[Home] [Help]

APPS.JTF_DIAGNOSTIC_COREAPI dependencies on V$VERSION

Line 2267: -- Version of the Database from v$version

2263: -- Usage:
2264: -- Get_RDBMS_Header;
2265: --
2266: -- Returns:
2267: -- Version of the Database from v$version
2268: --
2269: -- Examples:
2270: -- declare
2271: -- RDBMS_Ver := v$version.banner%type;

Line 2271: -- RDBMS_Ver := v$version.banner%type;

2267: -- Version of the Database from v$version
2268: --
2269: -- Examples:
2270: -- declare
2271: -- RDBMS_Ver := v$version.banner%type;
2272: -- begin
2273: -- RDBMS_Ver := Get_RDBMS_Header;
2274: -- end;
2275: --

Line 2278: l_DB_Ver v$version.banner%type;

2274: -- end;
2275: --
2276: Function Get_RDBMS_Header_html return varchar2 is
2277: l_hold_name v$database.name%type;
2278: l_DB_Ver v$version.banner%type;
2279: begin
2280: begin
2281: select name
2282: into l_hold_name

Line 2291: from v$version

2287: end;
2288: begin
2289: select banner
2290: into l_DB_Ver
2291: from v$version
2292: where banner like 'Oracle%';
2293: exception
2294: when others then
2295: l_DB_Ver := 'Not Available';

Line 4437: -- Version of the Database from v$version

4433: -- Function Name: Get_RDBMS_Header
4434: -- Usage:
4435: -- Get_RDBMS_Header;
4436: -- Returns:
4437: -- Version of the Database from v$version
4438: -- Examples:
4439: -- declare
4440: -- RDBMS_Ver := v$version.banner%type;
4441: -- begin

Line 4440: -- RDBMS_Ver := v$version.banner%type;

4436: -- Returns:
4437: -- Version of the Database from v$version
4438: -- Examples:
4439: -- declare
4440: -- RDBMS_Ver := v$version.banner%type;
4441: -- begin
4442: -- RDBMS_Ver := Get_RDBMS_Header;
4443: -- end;
4444:

Line 4447: l_DB_Ver v$version.banner%type;

4443: -- end;
4444:
4445: Function Get_RDBMS_Header_text return varchar2 is
4446: l_hold_name v$database.name%type;
4447: l_DB_Ver v$version.banner%type;
4448: begin
4449: begin
4450: select name
4451: into l_hold_name

Line 4460: from v$version

4456: end;
4457: begin
4458: select banner
4459: into l_DB_Ver
4460: from v$version
4461: where banner like 'Oracle%';
4462: exception
4463: when others then
4464: l_DB_Ver := 'Not Available';