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:
125: type bugfix is record
1026: select 'AFUMSAEB.pls : $Revision: 120.1 $ : get_replacement_bugfix_guid' arcs_revision,
1027: related_bugfix_guid
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
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,
1253: fnd_ums_bugfixes fub
1254: where fubr.bugfix_guid = p_bugfix_guid
1255: --
1256: -- - Direct/Indirect Prereq links are followed
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
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,
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
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