APPS.AD_FILE_SYS_SNAPSHOTS_PKG dependencies on AD_PATCH_RUNS

Line 327: from ad_patch_runs

323: patch_run_id, action_code
324: )
325: select
326: patch_run_id, G_PR_ID_ACT_CD2
327: from ad_patch_runs
328: where appl_top_id = l_appl_top_id
329: and patch_run_id not in (select patch_run_id
330: from ad_patch_hist_snaps_temp
331: where action_code in (G_PR_ID_ACT_CD,

Line 1003: from ad_patch_runs pr

999:
1000: if p_appl_top_id is null then
1001: select pr.appl_top_id
1002: into l_at_id
1003: from ad_patch_runs pr
1004: where pr.patch_run_id = p_patch_run_id;
1005: else
1006: -- make sure the 2 are consistent
1007: select pr.appl_top_id

Line 1009: from ad_patch_runs pr

1005: else
1006: -- make sure the 2 are consistent
1007: select pr.appl_top_id
1008: into l_at_id
1009: from ad_patch_runs pr
1010: where pr.patch_run_id = p_patch_run_id
1011: and pr.appl_top_id = p_appl_top_id;
1012: end if;
1013:

Line 1025: from ad_patch_runs pr

1021: (
1022: action_code, patch_run_id
1023: )
1024: select G_PR_ID_ACT_CD, pr.patch_run_id
1025: from ad_patch_runs pr
1026: where pr.patch_run_id = p_patch_run_id;
1027:
1028: if G_DEBUG then
1029: put_line('Inserted '||to_char(sql%rowcount)||' PR-ID rows');

Line 1145: from ad_patch_runs

1141: patch_run_id, action_code
1142: )
1143: select
1144: patch_run_id, G_PR_ID_ACT_CD
1145: from ad_patch_runs
1146: where appl_top_id = p_appl_top_id
1147: and patch_run_id not in (select patch_run_id
1148: from ad_patch_hist_snaps_temp
1149: where action_code = G_PR_ID_ACT_CD);

Line 1187: ad_patch_runs pr,

1183: begin
1184: select 1
1185: into l_count
1186: from ad_patch_hist_snaps_temp t,
1187: ad_patch_runs pr,
1188: ad_patch_drivers pd
1189: where t.patch_run_id = pr.patch_run_id
1190: and pr.patch_driver_id = pd.patch_driver_id
1191: and pd.driver_type_c_flag = 'Y'

Line 1476: from ad_patch_hist_snaps_temp t, ad_patch_runs pr,

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

Line 1550: from ad_patch_hist_snaps_temp t, ad_patch_runs pr,

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

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

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

Line 2055: ad_patch_runs pr,

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