[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:
925:
926: if (g_uc.upload_prereqs_includes_links) then
927: -- delete prereqs, includes
928:
929: delete from fnd_ums_bugfix_relationships
930: where bugfix_guid = g_bugfix_guid
931: and relation_type in (REL_TYPE_PREREQS,
932: REL_TYPE_INDIRECTLY_PREREQS,
933: REL_TYPE_INCLUDES,
940:
941: if (g_uc.upload_bugfix_replacement) then
942: -- delete replacement
943:
944: delete from fnd_ums_bugfix_relationships
945: where bugfix_guid = g_bugfix_guid
946: and relation_type = REL_TYPE_REPLACED_BY;
947:
948: g_rc.bugfix_relationships := g_rc.bugfix_relationships + sql%rowcount;
1325: p_related_bugfix_release_name in varchar2,
1326: p_related_bugfix_bug_number in varchar2,
1327: p_related_bugfix_download_mode in varchar2)
1328: is
1329: l_related_bugfix_guid fnd_ums_bugfix_relationships.related_bugfix_guid%type;
1330: begin
1331: if (((g_uc.upload_prereqs_includes_links) and
1332: (p_relation_type in (REL_TYPE_PREREQS,
1333: REL_TYPE_INDIRECTLY_PREREQS,
1342: p_related_bugfix_bug_number);
1343:
1344: -- insert the relationship
1345:
1346: insert into fnd_ums_bugfix_relationships
1347: (bugfix_guid,
1348: relation_type,
1349: related_bugfix_guid)
1350: values