APPS.AD_FILE_SYS_SNAPSHOTS_PKG dependencies on AD_PATCH_RUNS

Line 300: from ad_patch_runs

296: patch_run_id, action_code
297: )
298: select
299: patch_run_id, G_PR_ID_ACT_CD2
300: from ad_patch_runs
301: where appl_top_id = l_appl_top_id
302: and patch_run_id not in (select patch_run_id
303: from ad_patch_hist_snaps_temp
304: where action_code in (G_PR_ID_ACT_CD,

Line 942: from ad_patch_runs pr

938:
939: if p_appl_top_id is null then
940: select pr.appl_top_id
941: into l_at_id
942: from ad_patch_runs pr
943: where pr.patch_run_id = p_patch_run_id;
944: else
945: -- make sure the 2 are consistent
946: select pr.appl_top_id

Line 948: from ad_patch_runs pr

944: else
945: -- make sure the 2 are consistent
946: select pr.appl_top_id
947: into l_at_id
948: from ad_patch_runs pr
949: where pr.patch_run_id = p_patch_run_id
950: and pr.appl_top_id = p_appl_top_id;
951: end if;
952:

Line 964: from ad_patch_runs pr

960: (
961: action_code, patch_run_id
962: )
963: select G_PR_ID_ACT_CD, pr.patch_run_id
964: from ad_patch_runs pr
965: where pr.patch_run_id = p_patch_run_id;
966:
967: if G_DEBUG then
968: put_line('Inserted '||to_char(sql%rowcount)||' PR-ID rows');

Line 1068: from ad_patch_runs

1064: patch_run_id, action_code
1065: )
1066: select
1067: patch_run_id, G_PR_ID_ACT_CD
1068: from ad_patch_runs
1069: where appl_top_id = p_appl_top_id
1070: and patch_run_id not in (select patch_run_id
1071: from ad_patch_hist_snaps_temp
1072: where action_code = G_PR_ID_ACT_CD);

Line 1110: ad_patch_runs pr,

1106: begin
1107: select 1
1108: into l_count
1109: from ad_patch_hist_snaps_temp t,
1110: ad_patch_runs pr,
1111: ad_patch_drivers pd
1112: where t.patch_run_id = pr.patch_run_id
1113: and pr.patch_driver_id = pd.patch_driver_id
1114: and pd.driver_type_c_flag = 'Y'

Line 1399: from ad_patch_hist_snaps_temp t, ad_patch_runs pr,

1395: max(afv.version_segment7), max(afv.version_segment8),
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

Line 1473: from ad_patch_hist_snaps_temp t, ad_patch_runs pr,

1469: afv.version_segment5 desc, afv.version_segment6 desc,
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

Line 1525: 'from ad_patch_hist_snaps_temp t, ad_patch_runs pr, '||

1521:
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 '||

Line 1978: ad_patch_runs pr,

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
1982: t.action_code = G_PR_ID_ACT_CD and