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 2054: l_appl_vers fnd_product_groups.release_name%type;

2050: l_user_name fnd_user.user_name%type;
2051: l_user_id number;
2052: l_app_id number;
2053: l_counter integer;
2054: l_appl_vers fnd_product_groups.release_name%type;
2055: sqltxt varchar2(2000);
2056: inv_user exception;
2057: inv_resp exception;
2058: inv_app exception;

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

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

Line 3809: select release_name into l_appsver from fnd_product_groups;

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

Line 4217: l_appl_vers fnd_product_groups.release_name%type;

4213: l_user_name fnd_user.user_name%type;
4214: l_user_id number;
4215: l_app_id number;
4216: l_counter integer;
4217: l_appl_vers fnd_product_groups.release_name%type;
4218: sqltxt varchar2(2000);
4219: inv_user exception;
4220: inv_resp exception;
4221: inv_app exception;

Line 4379: l_appl_version fnd_product_groups.release_name%type;

4375: p_heading varchar2 default 'AD_BUGS'
4376: , p_app_short_name varchar2 default '%'
4377: , p_bug_number varchar2 default '%'
4378: , p_start_date date default to_date(olddate,'MM-DD-YYYY')) is
4379: l_appl_version fnd_product_groups.release_name%type;
4380: l_disp_lengths lengths;
4381: l_headers headers;
4382: l_counter integer;
4383: sqltxt varchar2(32767);