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_LOADER

Line 260: if (p_relation_type = fnd_ums_loader.REL_TYPE_PREREQS) then

256: return varchar2
257: is
258: l_text varchar2(30);
259: begin
260: if (p_relation_type = fnd_ums_loader.REL_TYPE_PREREQS) then
261: l_text := 'Prereqs';
262: elsif (p_relation_type = fnd_ums_loader.REL_TYPE_INDIRECTLY_PREREQS) then
263: l_text := 'Indirectly Prereqs';
264: elsif (p_relation_type = fnd_ums_loader.REL_TYPE_INCLUDES) then

Line 262: elsif (p_relation_type = fnd_ums_loader.REL_TYPE_INDIRECTLY_PREREQS) then

258: l_text varchar2(30);
259: begin
260: if (p_relation_type = fnd_ums_loader.REL_TYPE_PREREQS) then
261: l_text := 'Prereqs';
262: elsif (p_relation_type = fnd_ums_loader.REL_TYPE_INDIRECTLY_PREREQS) then
263: l_text := 'Indirectly Prereqs';
264: elsif (p_relation_type = fnd_ums_loader.REL_TYPE_INCLUDES) then
265: l_text := 'Includes';
266: elsif (p_relation_type = fnd_ums_loader.REL_TYPE_INDIRECTLY_INCLUDES) then

Line 264: elsif (p_relation_type = fnd_ums_loader.REL_TYPE_INCLUDES) then

260: if (p_relation_type = fnd_ums_loader.REL_TYPE_PREREQS) then
261: l_text := 'Prereqs';
262: elsif (p_relation_type = fnd_ums_loader.REL_TYPE_INDIRECTLY_PREREQS) then
263: l_text := 'Indirectly Prereqs';
264: elsif (p_relation_type = fnd_ums_loader.REL_TYPE_INCLUDES) then
265: l_text := 'Includes';
266: elsif (p_relation_type = fnd_ums_loader.REL_TYPE_INDIRECTLY_INCLUDES) then
267: l_text := 'Indirectly Includes';
268: elsif (p_relation_type = fnd_ums_loader.REL_TYPE_REPLACED_BY) then

Line 266: elsif (p_relation_type = fnd_ums_loader.REL_TYPE_INDIRECTLY_INCLUDES) then

262: elsif (p_relation_type = fnd_ums_loader.REL_TYPE_INDIRECTLY_PREREQS) then
263: l_text := 'Indirectly Prereqs';
264: elsif (p_relation_type = fnd_ums_loader.REL_TYPE_INCLUDES) then
265: l_text := 'Includes';
266: elsif (p_relation_type = fnd_ums_loader.REL_TYPE_INDIRECTLY_INCLUDES) then
267: l_text := 'Indirectly Includes';
268: elsif (p_relation_type = fnd_ums_loader.REL_TYPE_REPLACED_BY) then
269: l_text := 'Replaced by';
270: else

Line 268: elsif (p_relation_type = fnd_ums_loader.REL_TYPE_REPLACED_BY) then

264: elsif (p_relation_type = fnd_ums_loader.REL_TYPE_INCLUDES) then
265: l_text := 'Includes';
266: elsif (p_relation_type = fnd_ums_loader.REL_TYPE_INDIRECTLY_INCLUDES) then
267: l_text := 'Indirectly Includes';
268: elsif (p_relation_type = fnd_ums_loader.REL_TYPE_REPLACED_BY) then
269: l_text := 'Replaced by';
270: else
271: l_text := p_relation_type;
272: end if;

Line 719: l_bugfix.download_mode := fnd_ums_loader.DL_MODE_NONE;

715:
716: l_bugfix.bugfix_guid := null;
717: l_bugfix.release_name := p_release_name;
718: l_bugfix.bug_number := p_bug_number;
719: l_bugfix.download_mode := fnd_ums_loader.DL_MODE_NONE;
720: l_bugfix.application_short_name := null;
721: l_bugfix.release_status := RSTATUS_RELEASED;
722: l_bugfix.type := fnd_ums_loader.BUGFIX_TYPE_BUGFIX;
723: l_bugfix.bugfix_id := p_bug_number || ':' || p_language_code;

Line 722: l_bugfix.type := fnd_ums_loader.BUGFIX_TYPE_BUGFIX;

718: l_bugfix.bug_number := p_bug_number;
719: l_bugfix.download_mode := fnd_ums_loader.DL_MODE_NONE;
720: l_bugfix.application_short_name := null;
721: l_bugfix.release_status := RSTATUS_RELEASED;
722: l_bugfix.type := fnd_ums_loader.BUGFIX_TYPE_BUGFIX;
723: l_bugfix.bugfix_id := p_bug_number || ':' || p_language_code;
724:
725: if (p_language_code like 'NLS_%') then
726: l_bugfix.patch_type := PATCH_TYPE_NLS_BUGFIX;

Line 761: and download_mode <> fnd_ums_loader.DL_MODE_NONE;

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:
763: l_bugfix.patch_type := PATCH_TYPE_US_UMS;
764: exception
765: when no_data_found then

Line 774: l_bugfix.download_mode := fnd_ums_loader.DL_MODE_NONE;

770:
771: l_bugfix.bugfix_guid := null;
772: l_bugfix.release_name := p_release_name;
773: l_bugfix.bug_number := p_bug_number;
774: l_bugfix.download_mode := fnd_ums_loader.DL_MODE_NONE;
775: l_bugfix.application_short_name := null;
776: l_bugfix.release_status := RSTATUS_RELEASED;
777: l_bugfix.type := fnd_ums_loader.BUGFIX_TYPE_BUGFIX;
778: l_bugfix.abstract := '';

Line 777: l_bugfix.type := fnd_ums_loader.BUGFIX_TYPE_BUGFIX;

773: l_bugfix.bug_number := p_bug_number;
774: l_bugfix.download_mode := fnd_ums_loader.DL_MODE_NONE;
775: l_bugfix.application_short_name := null;
776: l_bugfix.release_status := RSTATUS_RELEASED;
777: l_bugfix.type := fnd_ums_loader.BUGFIX_TYPE_BUGFIX;
778: l_bugfix.abstract := '';
779: end;
780: end if;
781:

Line 1032: and relation_type = fnd_ums_loader.REL_TYPE_REPLACED_BY;

1028: into g_arcs_revision,
1029: l_replacement_bugfix_guid
1030: from fnd_ums_bugfix_relationships
1031: where bugfix_guid = p_bugfix_guid
1032: and relation_type = fnd_ums_loader.REL_TYPE_REPLACED_BY;
1033: exception
1034: when no_data_found then
1035: -- there is no replacement
1036:

Line 1266: and fubr.relation_type in (fnd_ums_loader.REL_TYPE_PREREQS,

1262: -- |
1263: -- |
1264: -- fubr.bugfix
1265: --
1266: and fubr.relation_type in (fnd_ums_loader.REL_TYPE_PREREQS,
1267: fnd_ums_loader.REL_TYPE_INDIRECTLY_PREREQS)
1268: and fub.bugfix_guid = fubr.related_bugfix_guid
1269: order by decode(fubr.relation_type,
1270: fnd_ums_loader.REL_TYPE_INDIRECTLY_PREREQS, 1,

Line 1267: fnd_ums_loader.REL_TYPE_INDIRECTLY_PREREQS)

1263: -- |
1264: -- fubr.bugfix
1265: --
1266: and fubr.relation_type in (fnd_ums_loader.REL_TYPE_PREREQS,
1267: fnd_ums_loader.REL_TYPE_INDIRECTLY_PREREQS)
1268: and fub.bugfix_guid = fubr.related_bugfix_guid
1269: order by decode(fubr.relation_type,
1270: fnd_ums_loader.REL_TYPE_INDIRECTLY_PREREQS, 1,
1271: fnd_ums_loader.REL_TYPE_PREREQS, 2,

Line 1270: fnd_ums_loader.REL_TYPE_INDIRECTLY_PREREQS, 1,

1266: and fubr.relation_type in (fnd_ums_loader.REL_TYPE_PREREQS,
1267: fnd_ums_loader.REL_TYPE_INDIRECTLY_PREREQS)
1268: and fub.bugfix_guid = fubr.related_bugfix_guid
1269: order by decode(fubr.relation_type,
1270: fnd_ums_loader.REL_TYPE_INDIRECTLY_PREREQS, 1,
1271: fnd_ums_loader.REL_TYPE_PREREQS, 2,
1272: 99),
1273: fub.bug_number;
1274:

Line 1271: fnd_ums_loader.REL_TYPE_PREREQS, 2,

1267: fnd_ums_loader.REL_TYPE_INDIRECTLY_PREREQS)
1268: and fub.bugfix_guid = fubr.related_bugfix_guid
1269: order by decode(fubr.relation_type,
1270: fnd_ums_loader.REL_TYPE_INDIRECTLY_PREREQS, 1,
1271: fnd_ums_loader.REL_TYPE_PREREQS, 2,
1272: 99),
1273: fub.bug_number;
1274:
1275: l_bugfix bugfix;

Line 1302: fnd_ums_loader.REL_TYPE_PREREQS,

1298: debug_to_report('NLS Patch: need to check US patch and its prereqs.');
1299: end if;
1300:
1301: check_bugfix_required(l_bugfix.bugfix_index,
1302: fnd_ums_loader.REL_TYPE_PREREQS,
1303: l_related_bugfix.bugfix_index);
1304:
1305: if (g_bugfixes(l_related_bugfix.bugfix_index).required) then
1306: check_bugfix_prereqs(l_related_bugfix.bugfix_index);

Line 1366: and fubr.relation_type = fnd_ums_loader.REL_TYPE_REPLACED_BY

1362: from (select fubr.related_bugfix_guid alias_bugfix_guid,
1363: fubr.relation_type alias_relation_type
1364: from fnd_ums_bugfix_relationships fubr
1365: where fubr.bugfix_guid = p_bugfix_guid
1366: and fubr.relation_type = fnd_ums_loader.REL_TYPE_REPLACED_BY
1367: union
1368: select fubr.bugfix_guid alias_bugfix_guid,
1369: fubr.relation_type alias_relation_type
1370: from fnd_ums_bugfix_relationships fubr

Line 1372: and fubr.relation_type in (fnd_ums_loader.REL_TYPE_INCLUDES,

1368: select fubr.bugfix_guid alias_bugfix_guid,
1369: fubr.relation_type alias_relation_type
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

Line 1373: fnd_ums_loader.REL_TYPE_INDIRECTLY_INCLUDES)) rels,

1369: fubr.relation_type alias_relation_type
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,

Line 1378: fnd_ums_loader.REL_TYPE_REPLACED_BY, 1,

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,
1379: fnd_ums_loader.REL_TYPE_INDIRECTLY_INCLUDES, 2,
1380: fnd_ums_loader.REL_TYPE_INCLUDES, 3,
1381: 99),
1382: fub.bug_number;

Line 1379: fnd_ums_loader.REL_TYPE_INDIRECTLY_INCLUDES, 2,

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,
1379: fnd_ums_loader.REL_TYPE_INDIRECTLY_INCLUDES, 2,
1380: fnd_ums_loader.REL_TYPE_INCLUDES, 3,
1381: 99),
1382: fub.bug_number;
1383:

Line 1380: fnd_ums_loader.REL_TYPE_INCLUDES, 3,

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,
1379: fnd_ums_loader.REL_TYPE_INDIRECTLY_INCLUDES, 2,
1380: fnd_ums_loader.REL_TYPE_INCLUDES, 3,
1381: 99),
1382: fub.bug_number;
1383:
1384: l_bugfix_guids BUGFIX_GUID_ARRAY;

Line 1463: if (l_relation_types(i) = fnd_ums_loader.REL_TYPE_REPLACED_BY) then

1459:
1460: for i in 1 .. l_bugfix_guids.count loop
1461: l_equivalent_bugfix := get_bugfix(l_bugfix_guids(i));
1462:
1463: if (l_relation_types(i) = fnd_ums_loader.REL_TYPE_REPLACED_BY) then
1464: l_vc2 := ' -OR-> ';
1465: elsif (l_relation_types(i) = fnd_ums_loader.REL_TYPE_INCLUDES) then
1466: l_vc2 := ' <-I- ';
1467: elsif (l_relation_types(i) = fnd_ums_loader.REL_TYPE_INDIRECTLY_INCLUDES) then

Line 1465: elsif (l_relation_types(i) = fnd_ums_loader.REL_TYPE_INCLUDES) then

1461: l_equivalent_bugfix := get_bugfix(l_bugfix_guids(i));
1462:
1463: if (l_relation_types(i) = fnd_ums_loader.REL_TYPE_REPLACED_BY) then
1464: l_vc2 := ' -OR-> ';
1465: elsif (l_relation_types(i) = fnd_ums_loader.REL_TYPE_INCLUDES) then
1466: l_vc2 := ' <-I- ';
1467: elsif (l_relation_types(i) = fnd_ums_loader.REL_TYPE_INDIRECTLY_INCLUDES) then
1468: l_vc2 := ' <-I''- ';
1469: end if;

Line 1467: elsif (l_relation_types(i) = fnd_ums_loader.REL_TYPE_INDIRECTLY_INCLUDES) then

1463: if (l_relation_types(i) = fnd_ums_loader.REL_TYPE_REPLACED_BY) then
1464: l_vc2 := ' -OR-> ';
1465: elsif (l_relation_types(i) = fnd_ums_loader.REL_TYPE_INCLUDES) then
1466: l_vc2 := ' <-I- ';
1467: elsif (l_relation_types(i) = fnd_ums_loader.REL_TYPE_INDIRECTLY_INCLUDES) then
1468: l_vc2 := ' <-I''- ';
1469: end if;
1470: l_vc2 := l_vc2 || l_equivalent_bugfix.bug_number;
1471:

Line 2405: NEWLINE := fnd_ums_loader.newline();

2401: return g_globals.report(i);
2402: end get_report;
2403:
2404: begin
2405: NEWLINE := fnd_ums_loader.newline();
2406: g_globals.engine_mode := MODE_NOT_CALLED;
2407: end fnd_ums_analysis_engine;