[Home] [Help]
109: --rows from ad_patch_hist_snaps_temp
110:
111: insert into ad_patch_hist_snaps_temp (action_code, bug_id)
112: select distinct L_BUGSTAT_EXPL_ACT_CD, prb.bug_id
113: from ad_patch_run_bugs prb, ad_patch_hist_snaps_temp t
114: where prb.patch_run_id = t.patch_run_id
115: and t.action_code = p_action_code
116: and (prb.applied_flag = 'Y' or prb.reason_not_applied = L_ADPBNAAS);
117:
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
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
1581: and prb.patch_run_id = t.patch_run_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 '||
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
1758: and prb.patch_run_id = t.patch_run_id
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
2058: pr.appl_top_id = p_appl_top_id and