[Home] [Help]
82: --rows from ad_patch_hist_snaps_temp
83:
84: insert into ad_patch_hist_snaps_temp (action_code, bug_id)
85: select distinct L_BUGSTAT_EXPL_ACT_CD, prb.bug_id
86: from ad_patch_run_bugs prb, ad_patch_hist_snaps_temp t
87: where prb.patch_run_id = t.patch_run_id
88: and t.action_code = p_action_code
89: and (prb.applied_flag = 'Y' or prb.reason_not_applied = L_ADPBNAAS);
90:
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
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
1504: and prb.patch_run_id = t.patch_run_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 '||
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
1681: and prb.patch_run_id = t.patch_run_id
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
1981: pr.appl_top_id = p_appl_top_id and