[Home] [Help]
1473: max(afv.version_segment9), max(afv.version_segment10),
1474: max(afv.translation_level), max(prba.dest_file_id),
1475: max(prba.file_type_flag)
1476: from ad_patch_hist_snaps_temp t, ad_patch_runs pr,
1477: ad_patch_run_bugs prb, ad_patch_run_bug_actions prba,
1478: ad_patch_common_actions pca, ad_file_versions afv, ad_files f
1479: where pr.patch_run_id = t.patch_run_id
1480: and pr.appl_top_id = :at_id
1481: and t.action_code = :pr_id_act_cd
1547: afv.version_segment7 desc, afv.version_segment8 desc,
1548: afv.version_segment9 desc, afv.version_segment10 desc,
1549: afv.translation_level desc nulls last) as r1
1550: from ad_patch_hist_snaps_temp t, ad_patch_runs pr,
1551: ad_patch_run_bugs prb, ad_patch_run_bug_actions prba,
1552: ad_patch_common_actions pca, ad_file_versions afv, ad_files f
1553: where pr.patch_run_id = t.patch_run_id
1554: and pr.appl_top_id = :at_id
1555: and t.action_code = :pr_id_act_cd
1572: set t.action_code = :none_cd
1573: where t.action_code = :clib_cd
1574: and not exists (select
1575: 'libin action exists for this .o (ie. its archived)'
1576: from ad_patch_run_bug_actions prba,
1577: ad_patch_run_bugs prb,
1578: ad_patch_common_actions pca
1579: where prba.file_id = t.file_id
1580: and prba.patch_run_bug_id = prb.patch_run_bug_id
1599: l_hint := ' ';
1600:
1601: l_from_where :=
1602: 'from ad_patch_hist_snaps_temp t, ad_patch_runs pr, '||
1603: 'ad_patch_run_bugs prb, ad_patch_run_bug_actions prba, '||
1604: 'ad_patch_common_actions pca, ad_file_versions afv, ad_files f '||
1605: 'where pr.patch_run_id = t.patch_run_id '||
1606: 'and pr.appl_top_id = :at_id '||
1607: 'and t.action_code = :pr_id_act_cd '||
1749: set t.action_code = L_ARCH_NONE_ACT_CD
1750: where t.action_code = L_ARCH_CLIB_ACT_CD
1751: and not exists (select
1752: 'libin action exists for this .o (ie. its archived)'
1753: from ad_patch_run_bug_actions prba,
1754: ad_patch_run_bugs prb,
1755: ad_patch_common_actions pca
1756: where prba.file_id = t.file_id
1757: and prba.patch_run_bug_id = prb.patch_run_bug_id
2031: commit;
2032:
2033:
2034: /* Now Deleting the class files that are not part of apps.zip
2035: ie. All the entries in ad_patch_run_bug_actions for which
2036: action_code is RU_Delete */
2037:
2038: /* Bug#3483080/3419891:
2039: We KNOW that RU_Delete actions will be very, very few.
2049: index(pca ad_patch_common_actions_n1) */
2050: distinct prba.file_id
2051: bulk collect into l_deleted_ru_file_ids
2052: from ad_patch_common_actions pca,
2053: ad_patch_run_bug_actions prba,
2054: ad_patch_run_bugs prb,
2055: ad_patch_runs pr,
2056: ad_patch_hist_snaps_temp t
2057: where pr.patch_run_id = t.patch_run_id and