[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:
912:
913: if (g_uc.upload_prereqs_includes_links) then
914: -- delete prereqs, includes
915:
916: delete from fnd_ums_bugfix_relationships
917: where bugfix_guid = g_bugfix_guid
918: and relation_type in (REL_TYPE_PREREQS,
919: REL_TYPE_INDIRECTLY_PREREQS,
920: REL_TYPE_INCLUDES,
927:
928: if (g_uc.upload_bugfix_replacement) then
929: -- delete replacement
930:
931: delete from fnd_ums_bugfix_relationships
932: where bugfix_guid = g_bugfix_guid
933: and relation_type = REL_TYPE_REPLACED_BY;
934:
935: g_rc.bugfix_relationships := g_rc.bugfix_relationships + sql%rowcount;
1310: p_related_bugfix_release_name in varchar2,
1311: p_related_bugfix_bug_number in varchar2,
1312: p_related_bugfix_download_mode in varchar2)
1313: is
1314: l_related_bugfix_guid fnd_ums_bugfix_relationships.related_bugfix_guid%type;
1315: begin
1316: if (((g_uc.upload_prereqs_includes_links) and
1317: (p_relation_type in (REL_TYPE_PREREQS,
1318: REL_TYPE_INDIRECTLY_PREREQS,
1327: p_related_bugfix_bug_number);
1328:
1329: -- insert the relationship
1330:
1331: insert into fnd_ums_bugfix_relationships
1332: (bugfix_guid,
1333: relation_type,
1334: related_bugfix_guid)
1335: values