APPS.AD_FILE_UTIL dependencies on AD_SNAPSHOT_FILES_S

Line 1425: ad_snapshot_files snap

1421: --
1422: --
1423: FORALL j IN fl_id_list.FIRST.. fl_id_list.LAST
1424: update /*+ INDEX(SNAP AD_SNAPSHOT_FILES_U2) */
1425: ad_snapshot_files snap
1426: set
1427: snap.file_version_id = vers_id_list(j),
1428: snap.file_size = fl_size_list(j),
1429: snap.checksum = chk_sum_list(j),

Line 1482: 'select ad_snapshot_files_s.nextval,'||

1478: 'update_type,creation_date,last_update_date,' ||
1479: 'last_updated_by,created_by,' ||
1480: 'appl_top_id, inconsistent_flag, '||
1481: 'dest_file_id, file_type_flag) '||
1482: 'select ad_snapshot_files_s.nextval,'||
1483: 'snp_id,t.file_id, t.check_file_id,'||
1484: 't.file_size,t.check_sum, t.file_version_id,'||
1485: 'snp_id,''U'',sysdate,sysdate, 5,5,' ||
1486: 't.appl_top_id, t.inconsistent_flag, '||

Line 1490: 'from ad_snapshot_files sf2 '||

1486: 't.appl_top_id, t.inconsistent_flag, '||
1487: 't.dest_file_id, t.file_type_flag '||
1488: 'from ad_check_file_temp t where not exists '||
1489: '(select ''already present'' '||
1490: 'from ad_snapshot_files sf2 '||
1491: 'where sf2.snapshot_id = snp_id '||
1492: 'and sf2.file_id = t.file_id '||
1493: 'and nvl(sf2.containing_file_id,-1) = '||
1494: 'nvl(t.check_file_id,-1)):(';

Line 1505: ad_snapshot_files_s.nextval,snp_id,t.file_id,

1501: update_source_id, update_type,creation_date,last_update_date,
1502: last_updated_by,created_by, appl_top_id, inconsistent_flag,
1503: dest_file_id, file_type_flag, irep_gathered_flag,last_patched_date)
1504: select
1505: ad_snapshot_files_s.nextval,snp_id,t.file_id,
1506: t.check_file_id,t.file_size,t.check_sum,
1507: t.file_version_id,snp_id,'U',sysdate,sysdate,
1508: 5,5, t.appl_top_id, t.inconsistent_flag,
1509: t.dest_file_id, t.file_type_flag,

Line 1514: from ad_snapshot_files sf2

1510: t.manifest_vers_higher, t.effective_date
1511: from ad_check_file_temp t
1512: where not exists
1513: (select /*+ INDEX(SF2 AD_SNAPSHOT_FILES_U2) */ 'already present'
1514: from ad_snapshot_files sf2
1515: where sf2.snapshot_id = snp_id
1516: and sf2.file_id = t.file_id
1517: and nvl(sf2.containing_file_id,-1) = nvl(t.check_file_id,-1)
1518: );

Line 2641: ad_snapshot_files_s.nextval,v_global_snapshot_id,

2637: appl_top_id, inconsistent_flag, dest_file_id,file_type_flag,
2638: creation_date,last_update_date,last_updated_by,created_by
2639: )
2640: select
2641: ad_snapshot_files_s.nextval,v_global_snapshot_id,
2642: file_id,file_version_id,containing_file_id,
2643: file_size,checksum,update_source_id,'S',
2644: appl_top_id, 'N', dest_file_id,file_type_flag,
2645: sysdate,sysdate,5,5

Line 2759: ad_snapshot_files_s.nextval,:v_global_snapshot_id,

2755: creation_date,last_update_date,last_updated_by,
2756: created_by
2757: )
2758: select
2759: ad_snapshot_files_s.nextval,:v_global_snapshot_id,
2760: file_id, patch_file_vers_id , onsite_file_vers_id,
2761: bug_id, patch_run_bug_id,db_file_vers_id,applied_flag,
2762: common_action_id, ''Y'', major_phase,action_executed_flag,
2763: sysdate,sysdate,5,5

Line 3134: ad_snapshot_files snap

3130: --
3131: --
3132: FORALL j IN fl_id_list.FIRST.. fl_id_list.LAST
3133: update
3134: ad_snapshot_files snap
3135: set
3136: snap.server_type_admin_flag = admin_server_flag_list(j),
3137: snap.server_type_forms_flag = forms_server_flag_list(j),
3138: snap.server_type_node_flag = node_server_flag_list(j),