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 1312: -- 2.Updates rows in AD_SNAPSHOT_FILES from ad_check_file_temp

1308: -- Purpose
1309: -- Create Snapshot data by
1310: -- 1.Calls ad_file_versions and loads the file versions
1311: -- into the ad_check_file_temp table .
1312: -- 2.Updates rows in AD_SNAPSHOT_FILES from ad_check_file_temp
1313: -- which have the same file_id, snapshot_id and containing_file_id
1314: -- 3.Inserts those rows from ad_check_file_temp into AD_SNAPSHOT_FILES
1315: -- which exists in ad_check_file_temp but are not in AD_SNAPSHOT_FILES.
1316: -- for the given snapshot_id

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

1310: -- 1.Calls ad_file_versions and loads the file versions
1311: -- into the ad_check_file_temp table .
1312: -- 2.Updates rows in AD_SNAPSHOT_FILES from ad_check_file_temp
1313: -- which have the same file_id, snapshot_id and containing_file_id
1314: -- 3.Inserts those rows from ad_check_file_temp into AD_SNAPSHOT_FILES
1315: -- which exists in ad_check_file_temp but are not in AD_SNAPSHOT_FILES.
1316: -- for the given snapshot_id
1317: -- 4.Delete those rows from AD_SNAPSHOT_FILES which exists
1318: -- in AD_SNAPSHOT_FILES but do not exist in ad_check_file_temp

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

1311: -- into the ad_check_file_temp table .
1312: -- 2.Updates rows in AD_SNAPSHOT_FILES from ad_check_file_temp
1313: -- which have the same file_id, snapshot_id and containing_file_id
1314: -- 3.Inserts those rows from ad_check_file_temp into AD_SNAPSHOT_FILES
1315: -- which exists in ad_check_file_temp but are not in AD_SNAPSHOT_FILES.
1316: -- for the given snapshot_id
1317: -- 4.Delete those rows from AD_SNAPSHOT_FILES which exists
1318: -- in AD_SNAPSHOT_FILES but do not exist in ad_check_file_temp
1319: -- for the given snapshot_id

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

1313: -- which have the same file_id, snapshot_id and containing_file_id
1314: -- 3.Inserts those rows from ad_check_file_temp into AD_SNAPSHOT_FILES
1315: -- which exists in ad_check_file_temp but are not in AD_SNAPSHOT_FILES.
1316: -- for the given snapshot_id
1317: -- 4.Delete those rows from AD_SNAPSHOT_FILES which exists
1318: -- in AD_SNAPSHOT_FILES but do not exist in ad_check_file_temp
1319: -- for the given snapshot_id
1320: --
1321: -- Arguments

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

1314: -- 3.Inserts those rows from ad_check_file_temp into AD_SNAPSHOT_FILES
1315: -- which exists in ad_check_file_temp but are not in AD_SNAPSHOT_FILES.
1316: -- for the given snapshot_id
1317: -- 4.Delete those rows from AD_SNAPSHOT_FILES which exists
1318: -- in AD_SNAPSHOT_FILES but do not exist in ad_check_file_temp
1319: -- for the given snapshot_id
1320: --
1321: -- Arguments
1322: -- is_upload pass TRUE if it is an upload otherwise FALSE

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

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

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

1470: --
1471: --
1472: --
1473: ad_file_util.error_buf := 'load_snapshot_file_info('||
1474: 'INSERT INTO ad_snapshot_files '||
1475: '(snapshot_file_id,snapshot_id,file_id, '||
1476: 'containing_file_id,file_size,checksum,'||
1477: 'file_version_id, update_source_id, '||
1478: 'update_type,creation_date,last_update_date,' ||

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

1494: 'nvl(t.check_file_id,-1)):(';
1495:
1496: begin
1497:
1498: INSERT INTO ad_snapshot_files
1499: (snapshot_file_id,snapshot_id,file_id,
1500: containing_file_id,file_size,checksum,file_version_id,
1501: update_source_id, update_type,creation_date,last_update_date,
1502: last_updated_by,created_by, appl_top_id, inconsistent_flag,

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

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

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

2418: -- Purpose
2419: -- Procedure to create Global View snapshot using exisiting
2420: -- current view snapshots for an applications system.
2421: -- Notes
2422: -- Pre-requiste: ad_snapshot_files_temp sholud have been populated
2423: -- before calling this API.
2424:
2425: procedure create_global_view(p_apps_system_name varchar2,
2426: p_is_run_flow boolean default true)

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

2562: --
2563: -- p_iteration - which iteration (1,2,etc)
2564: -- Purpose
2565: -- This procedure populates temp table with a range of file_ids
2566: -- processes the data and updates the ad_snapshot_files with negative
2567: -- global snapshot_id
2568: -- Notes
2569:
2570: procedure populate_snapshot_files_temp(p_applications_sys_name varchar2,p_min_file_id number,

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

2578: v_current_snapshot_type varchar2(1);
2579: begin
2580: --
2581: --
2582: execute immediate 'truncate table '|| p_un_fnd ||'.ad_snapshot_files_temp';
2583: execute immediate 'truncate table '|| p_un_fnd ||'.ad_patch_hist_temp';
2584: --
2585: --
2586: if (p_is_run_flow = TRUE)

Line 2632: insert into ad_snapshot_files

2628: --
2629: v_global_snapshot_id:=(-1*p_global_snapshot_id);
2630: --
2631: --
2632: insert into ad_snapshot_files
2633: (
2634: snapshot_file_id,snapshot_id,
2635: file_id, file_version_id, containing_file_id,
2636: file_size, checksum, update_source_id, update_type,

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

2658: decode(max(decode(file_type_flag, 'M', 2, 1)), 2, 'M', 'N') file_type_flag,
2659: replace(max(decode(update_type, 'P', 'a', null)||
2660: to_char(update_source_id)), 'a', null) update_source_id
2661: from
2662: ad_snapshot_files
2663: where
2664: file_id >= p_min_file_id and
2665: file_id < p_max_file_id and
2666: snapshot_id in (select TRANSLATION_LEVEL from ad_check_file_temp)

Line 2699: ad_snapshot_files

2695: dest_file_id,
2696: file_type_flag,
2697: '1234567890123456789012345678901234567890123456789012345678901234567890'
2698: from
2699: ad_snapshot_files
2700: where
2701: file_id in
2702: ( select
2703: file_id from ad_snapshot_files

Line 2703: file_id from ad_snapshot_files

2699: ad_snapshot_files
2700: where
2701: file_id in
2702: ( select
2703: file_id from ad_snapshot_files
2704: where
2705: file_id >= p_min_file_id and
2706: file_id < p_max_file_id and
2707: snapshot_id in (select TRANSLATION_LEVEL from ad_check_file_temp)

Line 2749: execute immediate 'insert into ad_snapshot_files

2745: tmp.PATCH_VERSION_SEGMENT9=0, tmp.PATCH_VERSION_SEGMENT10=0,
2746: tmp.PATCH_FILE_VERS=null, tmp.PATCH_TRANS_LEVEL=null
2747: where tmp.PATCH_FILE_VERS_ID=0;
2748: --
2749: execute immediate 'insert into ad_snapshot_files
2750: (
2751: snapshot_file_id,snapshot_id,
2752: file_id, file_version_id, containing_file_id,
2753: file_size, checksum, update_source_id, update_type,

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

2784: commit;
2785: --
2786: --
2787: if (p_iteration = 1) then
2788: FND_STATS.Gather_Table_Stats(p_un_fnd, 'AD_SNAPSHOT_FILES_TEMP');
2789: FND_STATS.Gather_Table_Stats(p_un_fnd, 'AD_CHECK_FILE_TEMP');
2790: FND_STATS.Gather_Table_Stats(p_un_fnd, 'AD_PATCH_HIST_TEMP');
2791: end if;
2792: --

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

2969: commit;
2970: --
2971: --
2972: if (p_iteration = 1) then
2973: FND_STATS.Gather_Table_Stats(p_un_fnd, 'AD_SNAPSHOT_FILES_TEMP');
2974: FND_STATS.Gather_Table_Stats(p_un_fnd, 'AD_CHECK_FILE_TEMP');
2975: FND_STATS.Gather_Table_Stats(p_un_fnd, 'AD_PATCH_HIST_TEMP');
2976: end if;
2977: --

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

3055: -- Procedure
3056: -- load_snpst_file_server_info
3057: --
3058: -- Purpose
3059: -- updates the values of the server flags of the table ad_snapshot_files
3060: -- as obtained from the temporary table ad_check_file_temp
3061: --
3062: -- Arguments
3063: -- snp_id - snapshot_id for which the rows are to be updated

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