DBA Data[Home] [Help]

APPS.JTF_DIAGNOSTIC_COREAPI dependencies on FND_PRODUCT_GROUPS

Line 1669: -- The version of applications from fnd_product_groups

1665: -- Usage:
1666: -- a_varchar := Get_DB_Apps_Version;
1667: --
1668: -- Returns:
1669: -- The version of applications from fnd_product_groups
1670: -- Also sets the variable g_appl_version to '10.7','11.0', or '11.5'
1671: -- as appropriate.
1672: --
1673: -- Examples:

Line 1681: l_appsver fnd_product_groups.release_name%type := null;

1677: -- apps_ver := Get_DB_Apps_Version;
1678: -- end;
1679: --
1680: function Get_DB_Apps_Version_html return varchar2 is
1681: l_appsver fnd_product_groups.release_name%type := null;
1682: begin
1683: select release_name into l_appsver from fnd_product_groups;
1684: g_appl_version := substr(l_appsver,1,4);
1685: return(l_appsver);

Line 1683: select release_name into l_appsver from fnd_product_groups;

1679: --
1680: function Get_DB_Apps_Version_html return varchar2 is
1681: l_appsver fnd_product_groups.release_name%type := null;
1682: begin
1683: select release_name into l_appsver from fnd_product_groups;
1684: g_appl_version := substr(l_appsver,1,4);
1685: return(l_appsver);
1686: end;
1687:

Line 2058: l_appl_vers fnd_product_groups.release_name%type;

2054: l_user_name fnd_user.user_name%type;
2055: l_user_id number;
2056: l_app_id number;
2057: l_counter integer;
2058: l_appl_vers fnd_product_groups.release_name%type;
2059: sqltxt varchar2(2000);
2060: inv_user exception;
2061: inv_resp exception;
2062: inv_app exception;

Line 3811: l_appsver fnd_product_groups.release_name%type := null;

3807: -- Tab0Print('Applications Version: '||Get_DB_Apps_Version);
3808: -- end;
3809:
3810: function Get_DB_Apps_Version_text return varchar2 is
3811: l_appsver fnd_product_groups.release_name%type := null;
3812: begin
3813: select release_name into l_appsver from fnd_product_groups;
3814: g_appl_version := substr(l_appsver,1,4);
3815: return(l_appsver);

Line 3813: select release_name into l_appsver from fnd_product_groups;

3809:
3810: function Get_DB_Apps_Version_text return varchar2 is
3811: l_appsver fnd_product_groups.release_name%type := null;
3812: begin
3813: select release_name into l_appsver from fnd_product_groups;
3814: g_appl_version := substr(l_appsver,1,4);
3815: return(l_appsver);
3816: end;
3817:

Line 4225: l_appl_vers fnd_product_groups.release_name%type;

4221: l_user_name fnd_user.user_name%type;
4222: l_user_id number;
4223: l_app_id number;
4224: l_counter integer;
4225: l_appl_vers fnd_product_groups.release_name%type;
4226: sqltxt varchar2(2000);
4227: inv_user exception;
4228: inv_resp exception;
4229: inv_app exception;

Line 4387: l_appl_version fnd_product_groups.release_name%type;

4383: p_heading varchar2 default 'AD_BUGS'
4384: , p_app_short_name varchar2 default '%'
4385: , p_bug_number varchar2 default '%'
4386: , p_start_date date default to_date(olddate,'MM-DD-YYYY')) is
4387: l_appl_version fnd_product_groups.release_name%type;
4388: l_disp_lengths lengths;
4389: l_headers headers;
4390: l_counter integer;
4391: sqltxt varchar2(32767);