eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_UMS_ANALYSIS_ENGINE dependencies on FND_UMS_BUGFIXES

Line 120: type BUGFIX_GUID_ARRAY is table of fnd_ums_bugfixes.bugfix_guid%TYPE index by binary_integer;

116: type VARCHAR2_ARRAY is table of varchar2(32000) index by binary_integer;
117:
118: -- Arrays for bulk fetching
119:
120: type BUGFIX_GUID_ARRAY is table of fnd_ums_bugfixes.bugfix_guid%TYPE index by binary_integer;
121: type RELATION_TYPE_ARRAY is table of fnd_ums_bugfix_relationships.relation_type%TYPE index by binary_integer;
122:
123: -- a bugfix in the dependency graph
124:

Line 129: -- attributes from FND_UMS_BUGFIXES

125: type bugfix is record
126: (-- primary key
127: bugfix_index binary_integer,
128:
129: -- attributes from FND_UMS_BUGFIXES
130: bugfix_guid fnd_ums_bugfixes.bugfix_guid%type,
131: release_name fnd_ums_bugfixes.release_name%type,
132: bug_number fnd_ums_bugfixes.bug_number%type,
133: download_mode fnd_ums_bugfixes.download_mode%type,

Line 130: bugfix_guid fnd_ums_bugfixes.bugfix_guid%type,

126: (-- primary key
127: bugfix_index binary_integer,
128:
129: -- attributes from FND_UMS_BUGFIXES
130: bugfix_guid fnd_ums_bugfixes.bugfix_guid%type,
131: release_name fnd_ums_bugfixes.release_name%type,
132: bug_number fnd_ums_bugfixes.bug_number%type,
133: download_mode fnd_ums_bugfixes.download_mode%type,
134: application_short_name fnd_ums_bugfixes.application_short_name%type,

Line 131: release_name fnd_ums_bugfixes.release_name%type,

127: bugfix_index binary_integer,
128:
129: -- attributes from FND_UMS_BUGFIXES
130: bugfix_guid fnd_ums_bugfixes.bugfix_guid%type,
131: release_name fnd_ums_bugfixes.release_name%type,
132: bug_number fnd_ums_bugfixes.bug_number%type,
133: download_mode fnd_ums_bugfixes.download_mode%type,
134: application_short_name fnd_ums_bugfixes.application_short_name%type,
135: release_status fnd_ums_bugfixes.release_status%type,

Line 132: bug_number fnd_ums_bugfixes.bug_number%type,

128:
129: -- attributes from FND_UMS_BUGFIXES
130: bugfix_guid fnd_ums_bugfixes.bugfix_guid%type,
131: release_name fnd_ums_bugfixes.release_name%type,
132: bug_number fnd_ums_bugfixes.bug_number%type,
133: download_mode fnd_ums_bugfixes.download_mode%type,
134: application_short_name fnd_ums_bugfixes.application_short_name%type,
135: release_status fnd_ums_bugfixes.release_status%type,
136: type fnd_ums_bugfixes.type%type,

Line 133: download_mode fnd_ums_bugfixes.download_mode%type,

129: -- attributes from FND_UMS_BUGFIXES
130: bugfix_guid fnd_ums_bugfixes.bugfix_guid%type,
131: release_name fnd_ums_bugfixes.release_name%type,
132: bug_number fnd_ums_bugfixes.bug_number%type,
133: download_mode fnd_ums_bugfixes.download_mode%type,
134: application_short_name fnd_ums_bugfixes.application_short_name%type,
135: release_status fnd_ums_bugfixes.release_status%type,
136: type fnd_ums_bugfixes.type%type,
137: abstract fnd_ums_bugfixes.abstract%type,

Line 134: application_short_name fnd_ums_bugfixes.application_short_name%type,

130: bugfix_guid fnd_ums_bugfixes.bugfix_guid%type,
131: release_name fnd_ums_bugfixes.release_name%type,
132: bug_number fnd_ums_bugfixes.bug_number%type,
133: download_mode fnd_ums_bugfixes.download_mode%type,
134: application_short_name fnd_ums_bugfixes.application_short_name%type,
135: release_status fnd_ums_bugfixes.release_status%type,
136: type fnd_ums_bugfixes.type%type,
137: abstract fnd_ums_bugfixes.abstract%type,
138:

Line 135: release_status fnd_ums_bugfixes.release_status%type,

131: release_name fnd_ums_bugfixes.release_name%type,
132: bug_number fnd_ums_bugfixes.bug_number%type,
133: download_mode fnd_ums_bugfixes.download_mode%type,
134: application_short_name fnd_ums_bugfixes.application_short_name%type,
135: release_status fnd_ums_bugfixes.release_status%type,
136: type fnd_ums_bugfixes.type%type,
137: abstract fnd_ums_bugfixes.abstract%type,
138:
139: -- attributes passed in

Line 136: type fnd_ums_bugfixes.type%type,

132: bug_number fnd_ums_bugfixes.bug_number%type,
133: download_mode fnd_ums_bugfixes.download_mode%type,
134: application_short_name fnd_ums_bugfixes.application_short_name%type,
135: release_status fnd_ums_bugfixes.release_status%type,
136: type fnd_ums_bugfixes.type%type,
137: abstract fnd_ums_bugfixes.abstract%type,
138:
139: -- attributes passed in
140: language_code varchar2(30),

Line 137: abstract fnd_ums_bugfixes.abstract%type,

133: download_mode fnd_ums_bugfixes.download_mode%type,
134: application_short_name fnd_ums_bugfixes.application_short_name%type,
135: release_status fnd_ums_bugfixes.release_status%type,
136: type fnd_ums_bugfixes.type%type,
137: abstract fnd_ums_bugfixes.abstract%type,
138:
139: -- attributes passed in
140: language_code varchar2(30),
141:

Line 758: from fnd_ums_bugfixes

754: l_bugfix.application_short_name,
755: l_bugfix.release_status,
756: l_bugfix.type,
757: l_bugfix.abstract
758: from fnd_ums_bugfixes
759: where release_name = p_release_name
760: and bug_number = p_bug_number
761: and download_mode <> fnd_ums_loader.DL_MODE_NONE;
762:

Line 910: function get_bugfix(p_bugfix_guid in fnd_ums_bugfixes.bugfix_guid%type)

906: -- p_bugfix_guid - the bugfix guid
907: --
908: -- return: the bugfix
909: --------------------------------------------------------------------------------
910: function get_bugfix(p_bugfix_guid in fnd_ums_bugfixes.bugfix_guid%type)
911: return bugfix
912: is
913: l_release_name fnd_ums_bugfixes.release_name%type;
914: l_bug_number fnd_ums_bugfixes.bug_number%type;

Line 913: l_release_name fnd_ums_bugfixes.release_name%type;

909: --------------------------------------------------------------------------------
910: function get_bugfix(p_bugfix_guid in fnd_ums_bugfixes.bugfix_guid%type)
911: return bugfix
912: is
913: l_release_name fnd_ums_bugfixes.release_name%type;
914: l_bug_number fnd_ums_bugfixes.bug_number%type;
915: l_bugfix_index binary_integer;
916: l_bugfix bugfix;
917: l_found boolean;

Line 914: l_bug_number fnd_ums_bugfixes.bug_number%type;

910: function get_bugfix(p_bugfix_guid in fnd_ums_bugfixes.bugfix_guid%type)
911: return bugfix
912: is
913: l_release_name fnd_ums_bugfixes.release_name%type;
914: l_bug_number fnd_ums_bugfixes.bug_number%type;
915: l_bugfix_index binary_integer;
916: l_bugfix bugfix;
917: l_found boolean;
918: begin

Line 939: from fnd_ums_bugfixes

935: bug_number
936: into g_arcs_revision,
937: l_release_name,
938: l_bug_number
939: from fnd_ums_bugfixes
940: where bugfix_guid = p_bugfix_guid;
941: exception
942: when no_data_found then
943: raise_formatted_error(ERROR_UMS_MISSING_DATA,

Line 944: get_formatted_error('No data found in FND_UMS_BUGFIXES',

940: where bugfix_guid = p_bugfix_guid;
941: exception
942: when no_data_found then
943: raise_formatted_error(ERROR_UMS_MISSING_DATA,
944: get_formatted_error('No data found in FND_UMS_BUGFIXES',
945: 'for bugfix guid ' || p_bugfix_guid));
946: end;
947:
948: l_bugfix_index := create_bugfix(l_release_name,

Line 1020: function get_replacement_bugfix_guid(p_bugfix_guid in fnd_ums_bugfixes.bugfix_guid%type)

1016: -- p_bugfix_guid - the bugfix guid
1017: --
1018: -- return: the replacement bugfix guid or null if there is no replacement
1019: --------------------------------------------------------------------------------
1020: function get_replacement_bugfix_guid(p_bugfix_guid in fnd_ums_bugfixes.bugfix_guid%type)
1021: return fnd_ums_bugfixes.bugfix_guid%type
1022: is
1023: l_replacement_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;
1024: begin

Line 1021: return fnd_ums_bugfixes.bugfix_guid%type

1017: --
1018: -- return: the replacement bugfix guid or null if there is no replacement
1019: --------------------------------------------------------------------------------
1020: function get_replacement_bugfix_guid(p_bugfix_guid in fnd_ums_bugfixes.bugfix_guid%type)
1021: return fnd_ums_bugfixes.bugfix_guid%type
1022: is
1023: l_replacement_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;
1024: begin
1025: begin

Line 1023: l_replacement_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;

1019: --------------------------------------------------------------------------------
1020: function get_replacement_bugfix_guid(p_bugfix_guid in fnd_ums_bugfixes.bugfix_guid%type)
1021: return fnd_ums_bugfixes.bugfix_guid%type
1022: is
1023: l_replacement_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;
1024: begin
1025: begin
1026: select 'AFUMSAEB.pls : $Revision: 120.1 $ : get_replacement_bugfix_guid' arcs_revision,
1027: related_bugfix_guid

Line 1059: l_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;

1055: procedure get_full_replacement_chain(p_bugfix_index in binary_integer,
1056: px_replacement_chain in out nocopy replacement_chain)
1057: is
1058: l_bugfix bugfix;
1059: l_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;
1060: begin
1061: px_replacement_chain.bugfix_count := 0;
1062:
1063: g_globals.replacement_chain_tag_counter := g_globals.replacement_chain_tag_counter + 1;

Line 1135: function get_replacement_bugfix_guid(p_bugfix_guid in fnd_ums_bugfixes.bugfix_guid%type,

1131: -- A4obs REPLACEMENT_FIRST_NON_OBSOLETE null
1132: -- A4obs REPLACEMENT_LAST_NON_OBSOLETE null
1133: --
1134: --------------------------------------------------------------------------------
1135: function get_replacement_bugfix_guid(p_bugfix_guid in fnd_ums_bugfixes.bugfix_guid%type,
1136: p_replacement_type in varchar2)
1137: return fnd_ums_bugfixes.bugfix_guid%type
1138: is
1139: l_replacement_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;

Line 1137: return fnd_ums_bugfixes.bugfix_guid%type

1133: --
1134: --------------------------------------------------------------------------------
1135: function get_replacement_bugfix_guid(p_bugfix_guid in fnd_ums_bugfixes.bugfix_guid%type,
1136: p_replacement_type in varchar2)
1137: return fnd_ums_bugfixes.bugfix_guid%type
1138: is
1139: l_replacement_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;
1140: l_bugfix bugfix;
1141: l_replacement_chain replacement_chain;

Line 1139: l_replacement_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;

1135: function get_replacement_bugfix_guid(p_bugfix_guid in fnd_ums_bugfixes.bugfix_guid%type,
1136: p_replacement_type in varchar2)
1137: return fnd_ums_bugfixes.bugfix_guid%type
1138: is
1139: l_replacement_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;
1140: l_bugfix bugfix;
1141: l_replacement_chain replacement_chain;
1142: begin
1143: l_replacement_bugfix_guid := null;

Line 1248: cursor l_prereqs(p_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type) is

1244: is
1245: --
1246: -- order by is added to get reproducible results in RT.
1247: --
1248: cursor l_prereqs(p_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type) is
1249: select 'AFUMSAEB.pls : $Revision: 120.1 $ : check_bugfix_prereqs' arcs_revision,
1250: fubr.related_bugfix_guid,
1251: fubr.relation_type
1252: from fnd_ums_bugfix_relationships fubr,

Line 1253: fnd_ums_bugfixes fub

1249: select 'AFUMSAEB.pls : $Revision: 120.1 $ : check_bugfix_prereqs' arcs_revision,
1250: fubr.related_bugfix_guid,
1251: fubr.relation_type
1252: from fnd_ums_bugfix_relationships fubr,
1253: fnd_ums_bugfixes fub
1254: where fubr.bugfix_guid = p_bugfix_guid
1255: --
1256: -- - Direct/Indirect Prereq links are followed
1257: --

Line 1359: cursor l_equivalents(p_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type) is

1355: function get_equivalency_result(p_bugfix_index in binary_integer,
1356: p_incoming_path in varchar2)
1357: return varchar2
1358: is
1359: cursor l_equivalents(p_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type) is
1360: select alias_bugfix_guid,
1361: alias_relation_type
1362: from (select fubr.related_bugfix_guid alias_bugfix_guid,
1363: fubr.relation_type alias_relation_type

Line 1374: fnd_ums_bugfixes fub

1370: from fnd_ums_bugfix_relationships fubr
1371: where fubr.related_bugfix_guid = p_bugfix_guid
1372: and fubr.relation_type in (fnd_ums_loader.REL_TYPE_INCLUDES,
1373: fnd_ums_loader.REL_TYPE_INDIRECTLY_INCLUDES)) rels,
1374: fnd_ums_bugfixes fub
1375: where 'AFUMSAEB.pls : $Revision: 120.1 $ : get_equivalency_result' is not null
1376: and rels.alias_bugfix_guid = fub.bugfix_guid
1377: order by decode(alias_relation_type,
1378: fnd_ums_loader.REL_TYPE_REPLACED_BY, 1,

Line 1807: l_replacement_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;

1803: procedure report_one_bugfix(p_symbol in varchar2,
1804: p_bugfix_index in binary_integer)
1805: is
1806: l_bugfix bugfix;
1807: l_replacement_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;
1808: l_replacement_bugfix bugfix;
1809: begin
1810: l_bugfix := g_bugfixes(p_bugfix_index);
1811:

Line 2193: l_replacement_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;

2189: px_replacement_bugfix_index in out nocopy binary_integer)
2190: is
2191: l_bugfix bugfix;
2192: l_replacement_bugfix bugfix;
2193: l_replacement_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;
2194: begin
2195: px_obs_required_bugfix_index := null;
2196: px_replacement_bugfix_index := null;
2197: