eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AD_FILE_UTIL dependencies on AD_SNAPSHOT_FILES

Line 1246: -- 2.Updates rows in AD_SNAPSHOT_FILES from ad_check_file_temp

1242: -- Purpose
1243: -- Create Snapshot data by
1244: -- 1.Calls ad_file_versions and loads the file versions
1245: -- into the ad_check_file_temp table .
1246: -- 2.Updates rows in AD_SNAPSHOT_FILES from ad_check_file_temp
1247: -- which have the same file_id, snapshot_id and containing_file_id
1248: -- 3.Inserts those rows from ad_check_file_temp into AD_SNAPSHOT_FILES
1249: -- which exists in ad_check_file_temp but are not in AD_SNAPSHOT_FILES.
1250: -- for the given snapshot_id

Line 1248: -- 3.Inserts those rows from ad_check_file_temp into AD_SNAPSHOT_FILES

1244: -- 1.Calls ad_file_versions and loads the file versions
1245: -- into the ad_check_file_temp table .
1246: -- 2.Updates rows in AD_SNAPSHOT_FILES from ad_check_file_temp
1247: -- which have the same file_id, snapshot_id and containing_file_id
1248: -- 3.Inserts those rows from ad_check_file_temp into AD_SNAPSHOT_FILES
1249: -- which exists in ad_check_file_temp but are not in AD_SNAPSHOT_FILES.
1250: -- for the given snapshot_id
1251: -- 4.Delete those rows from AD_SNAPSHOT_FILES which exists
1252: -- in AD_SNAPSHOT_FILES but do not exist in ad_check_file_temp

Line 1249: -- which exists in ad_check_file_temp but are not in AD_SNAPSHOT_FILES.

1245: -- into the ad_check_file_temp table .
1246: -- 2.Updates rows in AD_SNAPSHOT_FILES from ad_check_file_temp
1247: -- which have the same file_id, snapshot_id and containing_file_id
1248: -- 3.Inserts those rows from ad_check_file_temp into AD_SNAPSHOT_FILES
1249: -- which exists in ad_check_file_temp but are not in AD_SNAPSHOT_FILES.
1250: -- for the given snapshot_id
1251: -- 4.Delete those rows from AD_SNAPSHOT_FILES which exists
1252: -- in AD_SNAPSHOT_FILES but do not exist in ad_check_file_temp
1253: -- for the given snapshot_id

Line 1251: -- 4.Delete those rows from AD_SNAPSHOT_FILES which exists

1247: -- which have the same file_id, snapshot_id and containing_file_id
1248: -- 3.Inserts those rows from ad_check_file_temp into AD_SNAPSHOT_FILES
1249: -- which exists in ad_check_file_temp but are not in AD_SNAPSHOT_FILES.
1250: -- for the given snapshot_id
1251: -- 4.Delete those rows from AD_SNAPSHOT_FILES which exists
1252: -- in AD_SNAPSHOT_FILES but do not exist in ad_check_file_temp
1253: -- for the given snapshot_id
1254: --
1255: -- Arguments

Line 1252: -- in AD_SNAPSHOT_FILES but do not exist in ad_check_file_temp

1248: -- 3.Inserts those rows from ad_check_file_temp into AD_SNAPSHOT_FILES
1249: -- which exists in ad_check_file_temp but are not in AD_SNAPSHOT_FILES.
1250: -- for the given snapshot_id
1251: -- 4.Delete those rows from AD_SNAPSHOT_FILES which exists
1252: -- in AD_SNAPSHOT_FILES but do not exist in ad_check_file_temp
1253: -- for the given snapshot_id
1254: --
1255: -- Arguments
1256: -- is_upload pass TRUE if it is an upload otherwise FALSE

Line 1358: update /+ INDEX(SNAP AD_SNAPSHOT_FILES_U2) /

1354: --
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),

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 1408: 'INSERT INTO ad_snapshot_files '||

1404: --
1405: --
1406: --
1407: ad_file_util.error_buf := 'load_snapshot_file_info('||
1408: 'INSERT INTO ad_snapshot_files '||
1409: '(snapshot_file_id,snapshot_id,file_id, '||
1410: 'containing_file_id,file_size,checksum,'||
1411: 'file_version_id, update_source_id, '||
1412: 'update_type,creation_date,last_update_date,' ||

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 1432: INSERT INTO ad_snapshot_files

1428: 'nvl(t.check_file_id,-1)):(';
1429:
1430: begin
1431:
1432: INSERT INTO ad_snapshot_files
1433: (snapshot_file_id,snapshot_id,file_id,
1434: containing_file_id,file_size,checksum,file_version_id,
1435: update_source_id, update_type,creation_date,last_update_date,
1436: last_updated_by,created_by, appl_top_id, inconsistent_flag,

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 1447: (select /+ INDEX(SF2 AD_SNAPSHOT_FILES_U2) / 'already present'

1443: t.dest_file_id, t.file_type_flag,
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)

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 2354: -- Pre-requiste: ad_snapshot_files_temp sholud have been populated

2350: -- Purpose
2351: -- Procedure to create Global View snapshot using exisiting
2352: -- current view snapshots for an applications system.
2353: -- Notes
2354: -- Pre-requiste: ad_snapshot_files_temp sholud have been populated
2355: -- before calling this API.
2356:
2357: procedure create_global_view(p_apps_system_name varchar2)
2358: is

Line 2486: -- processes the data and updates the ad_snapshot_files with negative

2482: --
2483: -- p_iteration - which iteration (1,2,etc)
2484: -- Purpose
2485: -- This procedure populates temp table with a range of file_ids
2486: -- processes the data and updates the ad_snapshot_files with negative
2487: -- global snapshot_id
2488: -- Notes
2489:
2490: procedure populate_snapshot_files_temp(p_applications_sys_name varchar2,p_min_file_id number,

Line 2500: execute immediate 'truncate table '|| p_un_fnd ||'.ad_snapshot_files_temp';

2496: v_global_appl_top_id number;
2497: begin
2498: --
2499: --
2500: execute immediate 'truncate table '|| p_un_fnd ||'.ad_snapshot_files_temp';
2501: execute immediate 'truncate table '|| p_un_fnd ||'.ad_patch_hist_temp';
2502: --
2503: --
2504: if (p_iteration = 1) then

Line 2535: insert into ad_snapshot_files

2531: --
2532: v_global_snapshot_id:=(-1*p_global_snapshot_id);
2533: --
2534: --
2535: insert into ad_snapshot_files
2536: (
2537: snapshot_file_id,snapshot_id,
2538: file_id, file_version_id, containing_file_id,
2539: file_size, checksum, update_source_id, update_type,

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 2565: ad_snapshot_files

2561: decode(max(decode(file_type_flag, 'M', 2, 1)), 2, 'M', 'N') file_type_flag,
2562: replace(max(decode(update_type, 'P', 'a', null)||
2563: to_char(update_source_id)), 'a', null) update_source_id
2564: from
2565: ad_snapshot_files
2566: where
2567: file_id >= p_min_file_id and
2568: file_id < p_max_file_id and
2569: snapshot_id in (select TRANSLATION_LEVEL from ad_check_file_temp)

Line 2602: ad_snapshot_files

2598: dest_file_id,
2599: file_type_flag,
2600: '1234567890123456789012345678901234567890123456789012345678901234567890'
2601: from
2602: ad_snapshot_files
2603: where
2604: file_id in
2605: ( select
2606: file_id from ad_snapshot_files

Line 2606: file_id from ad_snapshot_files

2602: ad_snapshot_files
2603: where
2604: file_id in
2605: ( select
2606: file_id from ad_snapshot_files
2607: where
2608: file_id >= p_min_file_id and
2609: file_id < p_max_file_id and
2610: snapshot_id in (select TRANSLATION_LEVEL from ad_check_file_temp)

Line 2652: execute immediate 'insert into ad_snapshot_files

2648: tmp.PATCH_VERSION_SEGMENT9=0, tmp.PATCH_VERSION_SEGMENT10=0,
2649: tmp.PATCH_FILE_VERS=null, tmp.PATCH_TRANS_LEVEL=null
2650: where tmp.PATCH_FILE_VERS_ID=0;
2651: --
2652: execute immediate 'insert into ad_snapshot_files
2653: (
2654: snapshot_file_id,snapshot_id,
2655: file_id, file_version_id, containing_file_id,
2656: file_size, checksum, update_source_id, update_type,

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 2691: FND_STATS.Gather_Table_Stats(p_un_fnd, 'AD_SNAPSHOT_FILES_TEMP');

2687: commit;
2688: --
2689: --
2690: if (p_iteration = 1) then
2691: FND_STATS.Gather_Table_Stats(p_un_fnd, 'AD_SNAPSHOT_FILES_TEMP');
2692: FND_STATS.Gather_Table_Stats(p_un_fnd, 'AD_CHECK_FILE_TEMP');
2693: FND_STATS.Gather_Table_Stats(p_un_fnd, 'AD_PATCH_HIST_TEMP');
2694: end if;
2695: --

Line 2859: FND_STATS.Gather_Table_Stats(p_un_fnd, 'AD_SNAPSHOT_FILES_TEMP');

2855: commit;
2856: --
2857: --
2858: if (p_iteration = 1) then
2859: FND_STATS.Gather_Table_Stats(p_un_fnd, 'AD_SNAPSHOT_FILES_TEMP');
2860: FND_STATS.Gather_Table_Stats(p_un_fnd, 'AD_CHECK_FILE_TEMP');
2861: FND_STATS.Gather_Table_Stats(p_un_fnd, 'AD_PATCH_HIST_TEMP');
2862: end if;
2863: --

Line 2945: -- updates the values of the server flags of the table ad_snapshot_files

2941: -- Procedure
2942: -- load_snpst_file_server_info
2943: --
2944: -- Purpose
2945: -- updates the values of the server flags of the table ad_snapshot_files
2946: -- as obtained from the temporary table ad_check_file_temp
2947: --
2948: -- Arguments
2949: -- snp_id - snapshot_id for which the rows are to be updated

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),