[Home] [Help]
309:
310: l_ums_table_count := 0;
311:
312: add_table_details(l_ums_tables, l_ums_table_count, 'FND_UMS_BUGFIXES', g_rc.bugfixes);
313: add_table_details(l_ums_tables, l_ums_table_count, 'FND_UMS_BUGFIX_RELATIONSHIPS', g_rc.bugfix_relationships);
314: add_table_details(l_ums_tables, l_ums_table_count, 'FND_UMS_FILES', g_rc.files);
315: add_table_details(l_ums_tables, l_ums_table_count, 'FND_UMS_FILE_VERSIONS', g_rc.file_versions);
316: add_table_details(l_ums_tables, l_ums_table_count, 'FND_UMS_BUGFIX_FILE_VERSIONS', g_rc.bugfix_file_versions);
317:
919:
920: if (g_uc.upload_prereqs_includes_links) then
921: -- delete prereqs, includes
922:
923: delete from fnd_ums_bugfix_relationships
924: where bugfix_guid = g_bugfix_guid
925: and relation_type in (REL_TYPE_PREREQS,
926: REL_TYPE_INDIRECTLY_PREREQS,
927: REL_TYPE_INCLUDES,
934:
935: if (g_uc.upload_bugfix_replacement) then
936: -- delete replacement
937:
938: delete from fnd_ums_bugfix_relationships
939: where bugfix_guid = g_bugfix_guid
940: and relation_type = REL_TYPE_REPLACED_BY;
941:
942: g_rc.bugfix_relationships := g_rc.bugfix_relationships + sql%rowcount;
1319: p_related_bugfix_release_name in varchar2,
1320: p_related_bugfix_bug_number in varchar2,
1321: p_related_bugfix_download_mode in varchar2)
1322: is
1323: l_related_bugfix_guid fnd_ums_bugfix_relationships.related_bugfix_guid%type;
1324: begin
1325: if (((g_uc.upload_prereqs_includes_links) and
1326: (p_relation_type in (REL_TYPE_PREREQS,
1327: REL_TYPE_INDIRECTLY_PREREQS,
1336: p_related_bugfix_bug_number);
1337:
1338: -- insert the relationship
1339:
1340: insert into fnd_ums_bugfix_relationships
1341: (bugfix_guid,
1342: relation_type,
1343: related_bugfix_guid)
1344: values