APPS.AD_FILE_UTIL dependencies on AD_SNAPSHOT_FILES_S

Line 1359: ad_snapshot_files snap

1355: --
1356: --
1357: FORALL j IN fl_id_list.FIRST.. fl_id_list.LAST
1358: update /*+ INDEX(SNAP AD_SNAPSHOT_FILES_U2) */
1359: ad_snapshot_files snap
1360: set
1361: snap.file_version_id = vers_id_list(j),
1362: snap.file_size = fl_size_list(j),
1363: snap.checksum = chk_sum_list(j),

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

1412: 'update_type,creation_date,last_update_date,' ||
1413: 'last_updated_by,created_by,' ||
1414: 'appl_top_id, inconsistent_flag, '||
1415: 'dest_file_id, file_type_flag) '||
1416: 'select ad_snapshot_files_s.nextval,'||
1417: 'snp_id,t.file_id, t.check_file_id,'||
1418: 't.file_size,t.check_sum, t.file_version_id,'||
1419: 'snp_id,''U'',sysdate,sysdate, 5,5,' ||
1420: 't.appl_top_id, t.inconsistent_flag, '||

Line 1424: 'from ad_snapshot_files sf2 '||

1420: 't.appl_top_id, t.inconsistent_flag, '||
1421: 't.dest_file_id, t.file_type_flag '||
1422: 'from ad_check_file_temp t where not exists '||
1423: '(select ''already present'' '||
1424: 'from ad_snapshot_files sf2 '||
1425: 'where sf2.snapshot_id = snp_id '||
1426: 'and sf2.file_id = t.file_id '||
1427: 'and nvl(sf2.containing_file_id,-1) = '||
1428: 'nvl(t.check_file_id,-1)):(';

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

1435: update_source_id, update_type,creation_date,last_update_date,
1436: last_updated_by,created_by, appl_top_id, inconsistent_flag,
1437: dest_file_id, file_type_flag, irep_gathered_flag,last_patched_date)
1438: select
1439: ad_snapshot_files_s.nextval,snp_id,t.file_id,
1440: t.check_file_id,t.file_size,t.check_sum,
1441: t.file_version_id,snp_id,'U',sysdate,sysdate,
1442: 5,5, t.appl_top_id, t.inconsistent_flag,
1443: t.dest_file_id, t.file_type_flag,

Line 1448: from ad_snapshot_files sf2

1444: t.manifest_vers_higher, t.effective_date
1445: from ad_check_file_temp t
1446: where not exists
1447: (select /*+ INDEX(SF2 AD_SNAPSHOT_FILES_U2) */ 'already present'
1448: from ad_snapshot_files sf2
1449: where sf2.snapshot_id = snp_id
1450: and sf2.file_id = t.file_id
1451: and nvl(sf2.containing_file_id,-1) = nvl(t.check_file_id,-1)
1452: );

Line 2544: ad_snapshot_files_s.nextval,v_global_snapshot_id,

2540: appl_top_id, inconsistent_flag, dest_file_id,file_type_flag,
2541: creation_date,last_update_date,last_updated_by,created_by
2542: )
2543: select
2544: ad_snapshot_files_s.nextval,v_global_snapshot_id,
2545: file_id,file_version_id,containing_file_id,
2546: file_size,checksum,update_source_id,'S',
2547: appl_top_id, 'N', dest_file_id,file_type_flag,
2548: sysdate,sysdate,5,5

Line 2662: ad_snapshot_files_s.nextval,:v_global_snapshot_id,

2658: creation_date,last_update_date,last_updated_by,
2659: created_by
2660: )
2661: select
2662: ad_snapshot_files_s.nextval,:v_global_snapshot_id,
2663: file_id, patch_file_vers_id , onsite_file_vers_id,
2664: bug_id, patch_run_bug_id,db_file_vers_id,applied_flag,
2665: common_action_id, ''Y'', major_phase,action_executed_flag,
2666: sysdate,sysdate,5,5

Line 3020: ad_snapshot_files snap

3016: --
3017: --
3018: FORALL j IN fl_id_list.FIRST.. fl_id_list.LAST
3019: update
3020: ad_snapshot_files snap
3021: set
3022: snap.server_type_admin_flag = admin_server_flag_list(j),
3023: snap.server_type_forms_flag = forms_server_flag_list(j),
3024: snap.server_type_node_flag = node_server_flag_list(j),