DBA Data[Home] [Help]

APPS.JTF_DIAGNOSTIC_COREAPI dependencies on V$VERSION

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

2259: -- Usage:
2260: -- Get_RDBMS_Header;
2261: --
2262: -- Returns:
2263: -- Version of the Database from v$version
2264: --
2265: -- Examples:
2266: -- declare
2267: -- RDBMS_Ver := v$version.banner%type;

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

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

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

2270: -- end;
2271: --
2272: Function Get_RDBMS_Header_html return varchar2 is
2273: l_hold_name v$database.name%type;
2274: l_DB_Ver v$version.banner%type;
2275: begin
2276: begin
2277: select name
2278: into l_hold_name

Line 2287: from v$version

2283: end;
2284: begin
2285: select banner
2286: into l_DB_Ver
2287: from v$version
2288: where banner like 'Oracle%';
2289: exception
2290: when others then
2291: l_DB_Ver := 'Not Available';

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

4425: -- Function Name: Get_RDBMS_Header
4426: -- Usage:
4427: -- Get_RDBMS_Header;
4428: -- Returns:
4429: -- Version of the Database from v$version
4430: -- Examples:
4431: -- declare
4432: -- RDBMS_Ver := v$version.banner%type;
4433: -- begin

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

4428: -- Returns:
4429: -- Version of the Database from v$version
4430: -- Examples:
4431: -- declare
4432: -- RDBMS_Ver := v$version.banner%type;
4433: -- begin
4434: -- RDBMS_Ver := Get_RDBMS_Header;
4435: -- end;
4436:

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

4435: -- end;
4436:
4437: Function Get_RDBMS_Header_text return varchar2 is
4438: l_hold_name v$database.name%type;
4439: l_DB_Ver v$version.banner%type;
4440: begin
4441: begin
4442: select name
4443: into l_hold_name

Line 4452: from v$version

4448: end;
4449: begin
4450: select banner
4451: into l_DB_Ver
4452: from v$version
4453: where banner like 'Oracle%';
4454: exception
4455: when others then
4456: l_DB_Ver := 'Not Available';