[Home] [Help]
1396: max(afv.version_segment9), max(afv.version_segment10),
1397: max(afv.translation_level), max(prba.dest_file_id),
1398: max(prba.file_type_flag)
1399: from ad_patch_hist_snaps_temp t, ad_patch_runs pr,
1400: ad_patch_run_bugs prb, ad_patch_run_bug_actions prba,
1401: ad_patch_common_actions pca, ad_file_versions afv, ad_files f
1402: where pr.patch_run_id = t.patch_run_id
1403: and pr.appl_top_id = :at_id
1404: and t.action_code = :pr_id_act_cd
1470: afv.version_segment7 desc, afv.version_segment8 desc,
1471: afv.version_segment9 desc, afv.version_segment10 desc,
1472: afv.translation_level desc nulls last) as r1
1473: from ad_patch_hist_snaps_temp t, ad_patch_runs pr,
1474: ad_patch_run_bugs prb, ad_patch_run_bug_actions prba,
1475: ad_patch_common_actions pca, ad_file_versions afv, ad_files f
1476: where pr.patch_run_id = t.patch_run_id
1477: and pr.appl_top_id = :at_id
1478: and t.action_code = :pr_id_act_cd
1495: set t.action_code = :none_cd
1496: where t.action_code = :clib_cd
1497: and not exists (select
1498: 'libin action exists for this .o (ie. its archived)'
1499: from ad_patch_run_bug_actions prba,
1500: ad_patch_run_bugs prb,
1501: ad_patch_common_actions pca
1502: where prba.file_id = t.file_id
1503: and prba.patch_run_bug_id = prb.patch_run_bug_id
1522: l_hint := ' ';
1523:
1524: l_from_where :=
1525: 'from ad_patch_hist_snaps_temp t, ad_patch_runs pr, '||
1526: 'ad_patch_run_bugs prb, ad_patch_run_bug_actions prba, '||
1527: 'ad_patch_common_actions pca, ad_file_versions afv, ad_files f '||
1528: 'where pr.patch_run_id = t.patch_run_id '||
1529: 'and pr.appl_top_id = :at_id '||
1530: 'and t.action_code = :pr_id_act_cd '||
1672: set t.action_code = L_ARCH_NONE_ACT_CD
1673: where t.action_code = L_ARCH_CLIB_ACT_CD
1674: and not exists (select
1675: 'libin action exists for this .o (ie. its archived)'
1676: from ad_patch_run_bug_actions prba,
1677: ad_patch_run_bugs prb,
1678: ad_patch_common_actions pca
1679: where prba.file_id = t.file_id
1680: and prba.patch_run_bug_id = prb.patch_run_bug_id
1954: commit;
1955:
1956:
1957: /* Now Deleting the class files that are not part of apps.zip
1958: ie. All the entries in ad_patch_run_bug_actions for which
1959: action_code is RU_Delete */
1960:
1961: /* Bug#3483080/3419891:
1962: We KNOW that RU_Delete actions will be very, very few.
1972: index(pca ad_patch_common_actions_n1) */
1973: distinct prba.file_id
1974: bulk collect into l_deleted_ru_file_ids
1975: from ad_patch_common_actions pca,
1976: ad_patch_run_bug_actions prba,
1977: ad_patch_run_bugs prb,
1978: ad_patch_runs pr,
1979: ad_patch_hist_snaps_temp t
1980: where pr.patch_run_id = t.patch_run_id and