APPS.AD_ZD_ADOP dependencies on AD_CHECK_FILE_HISTORY

Line 1071: ' from ad_check_file_history acfh ' ||

1067: v_query :=
1068: 'delete ad_check_files acf ' ||
1069: 'where not exists ' ||
1070: ' (select ''x'' ' ||
1071: ' from ad_check_file_history acfh ' ||
1072: ' where acfh.check_file_id=acf.check_file_id ' ||
1073: ' and acfh.patch_run_id not in (:1, :2)) ';
1074:
1075: begin

Line 1095: 'from AD_CHECK_FILE_HISTORY ACFH1, ' ||

1091: begin
1092:
1093: v_query := 'select max(ACFH2.PATCH_RUN_ID) PRID, ' ||
1094: ' ACFH2.CHECK_FILE_ID CFID ' ||
1095: 'from AD_CHECK_FILE_HISTORY ACFH1, ' ||
1096: ' AD_CHECK_FILE_HISTORY ACFH2 ' ||
1097: 'where ACFH1.CHECK_FILE_ID=ACFH2.CHECK_FILE_ID ' ||
1098: 'and ACFH1.PATCH_RUN_ID in (:1, :2) ' ||
1099: 'and ACFH2.PATCH_RUN_ID not in (:3, :4) ' ||

Line 1096: ' AD_CHECK_FILE_HISTORY ACFH2 ' ||

1092:
1093: v_query := 'select max(ACFH2.PATCH_RUN_ID) PRID, ' ||
1094: ' ACFH2.CHECK_FILE_ID CFID ' ||
1095: 'from AD_CHECK_FILE_HISTORY ACFH1, ' ||
1096: ' AD_CHECK_FILE_HISTORY ACFH2 ' ||
1097: 'where ACFH1.CHECK_FILE_ID=ACFH2.CHECK_FILE_ID ' ||
1098: 'and ACFH1.PATCH_RUN_ID in (:1, :2) ' ||
1099: 'and ACFH2.PATCH_RUN_ID not in (:3, :4) ' ||
1100: 'group by ACFH2.CHECK_FILE_ID';

Line 1110: ' from ad_check_file_history acfh ' ||

1106:
1107: v_qry := 'update ad_check_files acf ' ||
1108: 'set acf.file_version_id=( ' ||
1109: ' select acfh.file_Version_id ' ||
1110: ' from ad_check_file_history acfh ' ||
1111: ' where acfh.patch_run_id=:1' ||
1112: ' and acfh.check_file_id=:2) ' ||
1113: 'where acf.check_file_id=:3';
1114: execute immediate v_qry using v_prid, v_cfid, v_cfid;

Line 1117: v_qry := 'delete ad_check_file_history acfh ' ||

1113: 'where acf.check_file_id=:3';
1114: execute immediate v_qry using v_prid, v_cfid, v_cfid;
1115: end loop;
1116:
1117: v_qry := 'delete ad_check_file_history acfh ' ||
1118: 'where acfh.patch_run_id in (:1, :2)';
1119:
1120: execute immediate v_qry using x_patch_run_id, -1;
1121: end;

Line 1134: FROM AD_CHECK_FILE_HISTORY ACFH,

1130: WHERE AASP.ADOP_SESSION_ID=x_session_id
1131: AND AASP.PATCHRUN_ID IS NOT NULL
1132: UNION
1133: SELECT ACFH.PATCH_RUN_ID
1134: FROM AD_CHECK_FILE_HISTORY ACFH,
1135: AD_ADOP_SESSION_PATCHES aasp
1136: WHERE ACFH.PATCH_RUN_ID>AASP.PATCHRUN_ID
1137: AND AASP.ADOP_SESSION_ID=x_session_id
1138: AND AASP.PATCHRUN_ID<>-1