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_FILE_UTIL

Line 1: package body ad_file_util as

1: package body ad_file_util as
2: /* $Header: adfilutb.pls 120.17.12020000.6 2013/06/10 07:37:57 mkumandu ship $ */
3:
4: procedure lock_infrastructure is
5: l_lockhandle varchar2(128);

Line 9: ad_file_util.error_buf := 'lock_infrastructure()';

5: l_lockhandle varchar2(128);
6: l_status number := 100;
7: l_exit_loop boolean := FALSE;
8: begin
9: ad_file_util.error_buf := 'lock_infrastructure()';
10:
11: dbms_lock.allocate_unique('ORA_APPS_AD_CHKFILTMP', l_lockhandle);
12:
13: l_exit_loop := FALSE;

Line 43: ad_file_util.error_buf := 'unlock_infrastructure()';

39: procedure unlock_infrastructure is
40: l_lockhandle varchar2(128);
41: l_status number := 100;
42: begin
43: ad_file_util.error_buf := 'unlock_infrastructure()';
44:
45: dbms_lock.allocate_unique('ORA_APPS_AD_CHKFILTMP', l_lockhandle);
46:
47: l_status := dbms_lock.release(l_lockhandle);

Line 100: ad_file_util.error_buf := 'truncate ad_check_file_temp';

96: (p_un_fnd varchar2) is
97: begin
98: lock_infrastructure;
99:
100: ad_file_util.error_buf := 'truncate ad_check_file_temp';
101:
102: execute immediate 'truncate table '||p_un_fnd||'.ad_check_file_temp';
103:
104: exception when others then

Line 105: ad_file_util.error_buf := 'lock_and_empty_temp_table('||

101:
102: execute immediate 'truncate table '||p_un_fnd||'.ad_check_file_temp';
103:
104: exception when others then
105: ad_file_util.error_buf := 'lock_and_empty_temp_table('||
106: ad_file_util.error_buf||
107: ')';
108:
109: raise;

Line 106: ad_file_util.error_buf||

102: execute immediate 'truncate table '||p_un_fnd||'.ad_check_file_temp';
103:
104: exception when others then
105: ad_file_util.error_buf := 'lock_and_empty_temp_table('||
106: ad_file_util.error_buf||
107: ')';
108:
109: raise;
110: end lock_and_empty_temp_table;

Line 153: ad_file_util.error_buf := 'load_file_info('||

149: -- get file_id from ad_files
150: --
151: -- set junk to null to free up space in row and avoid row chaining
152: --
153: ad_file_util.error_buf := 'load_file_info('||
154: ' update ad_check_file_temp t '||
155: 'set t.file_id = (select f.file_id '||
156: 'from ad_files f '||
157: 'where f.app_short_name = t.app_short_name '||

Line 175: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

171: where nvl(t.active_flag,'N') = 'Y';
172:
173: exception
174: when others then
175: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
176: raise;
177: end;
178: --
179: -- add new entries in ad_files

Line 181: ad_file_util.error_buf := 'load_file_info('||

177: end;
178: --
179: -- add new entries in ad_files
180: --
181: ad_file_util.error_buf := 'load_file_info('||
182: 'insert into ad_files '||
183: '(file_id, app_short_name, subdir, filename, '||
184: 'creation_date, created_by, last_update_date, '||
185: 'last_updated_by) select ad_files_s.nextval, '||

Line 212: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

208: where t.file_id is null
209: and nvl(t.active_flag,'N') = 'Y') temp;
210: exception
211: when others then
212: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
213: raise;
214: end;
215:
216: --

Line 219: ad_file_util.error_buf := 'load_file_info('||

215:
216: --
217: -- add file_id for new entries
218: --
219: ad_file_util.error_buf := 'load_file_info('||
220: 'update ad_check_file_temp t set t.file_id = '||
221: '(select f.file_id from ad_files f '||
222: 'where f.app_short_name = t.app_short_name '||
223: 'and f.subdir = t.subdir '||

Line 240: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

236: where t.file_id is null
237: and nvl(t.active_flag,'N') = 'Y';
238: exception
239: when others then
240: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
241: raise;
242: end;
243:
244: --

Line 254: ad_file_util.error_buf := 'load_file_info('||

250: --
251: -- get dest_file_id from ad_files
252: --
253:
254: ad_file_util.error_buf := 'load_file_info('||
255: ' update ad_check_file_temp t '||
256: 'set t.dest_file_id = (select f.file_id '||
257: 'from ad_files f '||
258: 'where f.app_short_name = t.dest_apps_short_name '||

Line 273: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

269: and f.filename = t.dest_filename)
270: where nvl(t.active_flag,'N') = 'Y';
271: exception
272: when others then
273: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
274: raise;
275: end;
276:
277: --

Line 281: ad_file_util.error_buf := 'load_file_info('||

277: --
278: -- add new entries in ad_files
279: --
280:
281: ad_file_util.error_buf := 'load_file_info('||
282: 'insert into ad_files '||
283: '(file_id, app_short_name, subdir, filename, '||
284: 'creation_date, created_by, last_update_date, '||
285: 'last_updated_by) select ad_files_s.nextval, '||

Line 315: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

311: and t.dest_filename <> 'none'
312: and nvl(t.active_flag,'N') = 'Y') temp;
313: exception
314: when others then
315: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
316: raise;
317: end;
318:
319: --

Line 323: ad_file_util.error_buf := 'load_file_info('||

319: --
320: -- add dest_file_id for new entries
321: --
322:
323: ad_file_util.error_buf := 'load_file_info('||
324: 'update ad_check_file_temp t set t.dest_file_id ='||
325: '(select f.file_id from ad_files f '||
326: 'where f.app_short_name = t.dest_apps_short_name'||
327: 'and f.subdir = t.dest_subdir '||

Line 347: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

343: and t.dest_filename <> 'none'
344: and nvl(t.active_flag,'N') = 'Y';
345: exception
346: when others then
347: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
348: raise;
349: end;
350:
351: --

Line 397: ad_file_util.load_file_info;

393: --
394: -- process ad_files
395: --
396: begin
397: ad_file_util.load_file_info;
398: exception
399: when others then
400: ad_file_util.error_buf := 'load_file_version_info('||
401: ad_file_util.error_buf||

Line 400: ad_file_util.error_buf := 'load_file_version_info('||

396: begin
397: ad_file_util.load_file_info;
398: exception
399: when others then
400: ad_file_util.error_buf := 'load_file_version_info('||
401: ad_file_util.error_buf||
402: ')';
403: raise;
404: end;

Line 401: ad_file_util.error_buf||

397: ad_file_util.load_file_info;
398: exception
399: when others then
400: ad_file_util.error_buf := 'load_file_version_info('||
401: ad_file_util.error_buf||
402: ')';
403: raise;
404: end;
405: --

Line 412: ad_file_util.error_buf := 'load_file_version_info('||

408:
409: --
410: -- get file_version_id from ad_file_versions
411: --
412: ad_file_util.error_buf := 'load_file_version_info('||
413: 'update ad_check_file_temp t '||
414: 'set t.file_version_id = '||
415: '(select fv.file_version_id '||
416: 'from ad_file_versions fv '||

Line 435: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

431: where nvl(t.active_flag,'N') = 'Y'
432: and lower(t.manifest_vers)<>'none';
433: exception
434: when others then
435: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
436: raise;
437: end;
438:
439: --

Line 442: ad_file_util.error_buf := 'load_file_version_info('||

438:
439: --
440: -- add new entries to ad_file_versions
441: --
442: ad_file_util.error_buf := 'load_file_version_info('||
443: 'insert into ad_file_versions '||
444: '(file_version_id, file_id, version, '||
445: 'translation_level, '||
446: 'version_segment1, version_segment2, '||

Line 537: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

533: and nvl(t.active_flag,'N') = 'Y'
534: ) temp;
535: exception
536: when others then
537: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
538: raise;
539: end;
540:
541:

Line 545: ad_file_util.error_buf :='load_file_version_info('||

541:
542: --
543: -- get file_version_id for new entries
544: --
545: ad_file_util.error_buf :='load_file_version_info('||
546: 'update ad_check_file_temp t '||
547: 'set t.file_version_id = '||
548: '(select fv.file_version_id '||
549: 'from ad_file_versions fv '||

Line 571: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

567: and nvl(t.active_flag,'N') = 'Y'
568: and lower(t.manifest_vers)<>'none';
569: exception
570: when others then
571: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
572: raise;
573: end;
574:
575: --

Line 626: ad_file_util.error_buf := 'load_checkfile_info(';

622: begin
623: --
624: -- process ad_files and ad_file_versions
625: --
626: ad_file_util.error_buf := 'load_checkfile_info(';
627: begin
628: ad_file_util.load_file_version_info;
629: exception
630: when others then

Line 628: ad_file_util.load_file_version_info;

624: -- process ad_files and ad_file_versions
625: --
626: ad_file_util.error_buf := 'load_checkfile_info(';
627: begin
628: ad_file_util.load_file_version_info;
629: exception
630: when others then
631: ad_file_util.error_buf := 'load_checkfile_info('||
632: ad_file_util.error_buf||sqlerrm||')';

Line 631: ad_file_util.error_buf := 'load_checkfile_info('||

627: begin
628: ad_file_util.load_file_version_info;
629: exception
630: when others then
631: ad_file_util.error_buf := 'load_checkfile_info('||
632: ad_file_util.error_buf||sqlerrm||')';
633: raise;
634: end;
635: --

Line 632: ad_file_util.error_buf||sqlerrm||')';

628: ad_file_util.load_file_version_info;
629: exception
630: when others then
631: ad_file_util.error_buf := 'load_checkfile_info('||
632: ad_file_util.error_buf||sqlerrm||')';
633: raise;
634: end;
635: --
636: -- process ad_check_files

Line 642: ad_file_util.error_buf := 'load_checkfile_info('||

638:
639: --
640: -- get check_file_id and manifest_vers_higher
641: --
642: ad_file_util.error_buf := 'load_checkfile_info('||
643: 'update ad_check_file_temp t '||
644: 'set t.check_file_id = '||
645: '(select cf.check_file_id '||
646: 'from ad_check_files cf '||

Line 694: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

690: and cf.file_version_id = fv2.file_version_id)
691: where nvl(t.active_flag,'N') = 'Y';
692: exception
693: when others then
694: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
695: raise;
696: end;
697: --
698: -- add new entries into ad_check_files

Line 700: ad_file_util.error_buf := 'load_checkfile_info('||

696: end;
697: --
698: -- add new entries into ad_check_files
699: --
700: ad_file_util.error_buf := 'load_checkfile_info('||
701: 'insert into ad_check_files '||
702: '(check_file_id, file_id, distinguisher, '||
703: 'file_version_id, creation_date) '||
704: 'select ad_check_files_s.nextval, '||

Line 732: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

728: and nvl(t.active_flag,'N') = 'Y') temp;
729:
730: exception
731: when others then
732: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
733: raise;
734: end;
735:
736: if (p_ebr_flow = true)

Line 742: ad_file_util.error_buf := 'load_checkfile_info('||

738:
739: -- Insert new records. Insert all the records with patch_run_id -1
740: -- Later while updating patch history update patch_run_id
741:
742: ad_file_util.error_buf := 'load_checkfile_info('||
743: 'insert into ad_check_file_history ' ||
744: '(CHECK_FILE_ID, FILE_VERSION_ID, PATCH_RUN_ID, CREATION_DATE) ' ||
745: 'select distinct acf.check_file_id, acf.file_version_id, -1, sysdate ' ||
746: 'from ad_check_files acf, ad_check_file_temp acft ' ||

Line 764: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

760: and nvl(acf.distinguisher, 'x')=nvl(acft.distinguisher, 'x');
761:
762: exception
763: when others then
764: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
765: raise;
766: end;
767: end if;
768: --

Line 772: ad_file_util.error_buf := 'load_checkfile_info('||

768: --
769: --
770: -- delete from ad_check_files where versions lower than manifest
771: --
772: ad_file_util.error_buf := 'load_checkfile_info('||
773: 'delete from ad_check_files kf '||
774: 'where cf.check_file_id in '||
775: '(select t.check_file_id '||
776: 'from ad_check_file_temp t '||

Line 789: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

785: where t.manifest_vers_higher = 'Y'
786: and nvl(t.active_flag,'N') = 'Y');
787: exception
788: when others then
789: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
790: raise;
791: end;
792: --
793: -- insert into ad_check_files where versions lower than manifest

Line 795: ad_file_util.error_buf := 'load_checkfile_info('||

791: end;
792: --
793: -- insert into ad_check_files where versions lower than manifest
794: --
795: ad_file_util.error_buf := 'load_checkfile_info('||
796: ' insert into ad_check_files '||
797: '(check_file_id, file_id, distinguisher, '||
798: 'file_version_id, creation_date) '||
799: 'select temp.cf_id, '||

Line 830: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

826: and nvl(t.active_flag,'N') = 'Y') temp;
827:
828: exception
829: when others then
830: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
831: raise;
832: end;
833:
834: if (p_ebr_flow = true)

Line 839: ad_file_util.error_buf := 'load_checkfile_info('||

835: then
836: -- Insert new records. Insert all the records with patch_run_id -1
837: -- Later while updating patch history update patch_run_id
838:
839: ad_file_util.error_buf := 'load_checkfile_info('||
840: 'insert into ad_check_file_history ' ||
841: ' (CHECK_FILE_ID, FILE_VERSION_ID, PATCH_RUN_ID, CREATION_DATE) ' ||
842: 'select distinct acf.check_file_id, acf.file_version_id, -1, sysdate ' ||
843: ' from ad_check_files acf, ad_check_file_temp acft ' ||

Line 861: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

857: and nvl(acf.distinguisher, 'x')=nvl(acft.distinguisher, 'x');
858:
859: exception
860: when others then
861: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
862: raise;
863: end;
864: end if;
865: --

Line 901: ad_file_util.error_buf := 'update_timestamp(update ad_timestamps '||

897: begin
898: --
899: -- First try to update
900: --
901: ad_file_util.error_buf := 'update_timestamp(update ad_timestamps '||
902: 'set timestamp = '||in_timestamp||
903: 'where type = '||in_type||
904: 'and attribute = '||in_attribute||'):(';
905: begin

Line 912: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

908: where type = in_type
909: and attribute = in_attribute;
910: exception
911: when others then
912: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
913: raise;
914: end;
915:
916: if SQL%ROWCOUNT = 1 then

Line 922: ad_file_util.error_buf := 'update_timestamp('||

918: end if;
919: --
920: -- Insert if no rows updated
921: --
922: ad_file_util.error_buf := 'update_timestamp('||
923: 'insert into ad_timestamps'||
924: '(type, attribute, timestamp)'||
925: 'values ('||in_type||', '||in_attribute||
926: ', '||in_timestamp||'):(';

Line 934: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

930: (type, attribute, timestamp)
931: values (in_type, in_attribute, in_timestamp);
932: exception
933: when others then
934: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
935: raise;
936: end;
937:
938: end update_timestamp;

Line 999: ad_file_util.load_file_info;

995: --
996: -- process ad_files
997: --
998:
999: ad_file_util.load_file_info;
1000:
1001: --
1002: -- process ad_file_versons
1003: --

Line 1004: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||

1000:
1001: --
1002: -- process ad_file_versons
1003: --
1004: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||
1005: 'update ad_check_file_temp t '||
1006: 'set t.file_version_id = '||
1007: '(select fv.file_version_id '||
1008: 'from ad_file_versions fv '||

Line 1027: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

1023: where nvl(t.active_flag,'N') = 'Y'
1024: and nvl(t.manifest_vers,'NA')<>'NA';
1025: exception
1026: when others then
1027: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1028: raise;
1029: end;
1030: --
1031: -- add new entries to ad_file_versions

Line 1033: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||

1029: end;
1030: --
1031: -- add new entries to ad_file_versions
1032: --
1033: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||
1034: 'insert into ad_file_versions '||
1035: '(file_version_id, file_id, version, '||
1036: 'translation_level, version_segment1,'||
1037: 'version_segment2, version_segment3, '||

Line 1118: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

1114: and nvl(t.active_flag,'N') = 'Y'
1115: and nvl(t.manifest_vers,'NA')<>'NA') temp;
1116: exception
1117: when others then
1118: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1119: raise;
1120: end;
1121: --
1122: --

Line 1123: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||

1119: raise;
1120: end;
1121: --
1122: --
1123: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||
1124: 'update ad_check_file_temp t '||
1125: 'set t.file_version_id = '||
1126: '(select fv.file_version_id '||
1127: 'from ad_file_versions fv '||

Line 1147: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

1143: where nvl(t.active_flag,'N') = 'Y'
1144: and nvl(t.manifest_vers,'NA')<>'NA';
1145: exception
1146: when others then
1147: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1148: raise;
1149: end;
1150: --
1151: -- get file_version_id_2 from ad_file_versions

Line 1153: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||

1149: end;
1150: --
1151: -- get file_version_id_2 from ad_file_versions
1152: --
1153: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||
1154: 'update ad_check_file_temp t '||
1155: 'set t.file_version_id_2 = '||
1156: '(select fv.file_version_id '||
1157: 'from ad_file_versions fv '||

Line 1175: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

1171: where nvl(t.active_flag,'N') = 'Y' AND
1172: nvl(t.manifest_vers_2,'NA')<>'NA';
1173: exception
1174: when others then
1175: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1176: raise;
1177: end;
1178:
1179: --

Line 1182: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||

1178:
1179: --
1180: -- add new entries to ad_file_versions
1181: --
1182: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||
1183: 'insert into ad_file_versions '||
1184: '(file_version_id, file_id, version, '||
1185: 'translation_level, version_segment1,'||
1186: 'version_segment2, version_segment3, '||

Line 1268: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

1264: and nvl(t.active_flag,'N') = 'Y'
1265: and nvl(t.manifest_vers_2,'NA')<>'NA') temp;
1266: exception
1267: when others then
1268: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1269: raise;
1270: end;
1271: --
1272: -- get file_version_id_2 from ad_file_versions

Line 1274: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||

1270: end;
1271: --
1272: -- get file_version_id_2 from ad_file_versions
1273: --
1274: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||
1275: 'update ad_check_file_temp t '||
1276: 'set t.file_version_id_2 = '||
1277: '(select fv.file_version_id '||
1278: 'from ad_file_versions fv '||

Line 1294: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

1290: where nvl(t.active_flag,'N') = 'Y' AND
1291: nvl(t.manifest_vers_2,'NA')<>'NA';
1292: exception
1293: when others then
1294: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1295: raise;
1296: end;
1297: --
1298: -- done processing ad_file_versions

Line 1374: ad_file_util.load_file_version_info;

1370: --
1371: -- process ad_files and ad_file_versions
1372: --
1373: begin
1374: ad_file_util.load_file_version_info;
1375: exception
1376: when others then
1377: ad_file_util.error_buf := 'load_snapshot_file_info('||snp_id||'):('||
1378: ad_file_util.error_buf||sqlerrm||')';

Line 1377: ad_file_util.error_buf := 'load_snapshot_file_info('||snp_id||'):('||

1373: begin
1374: ad_file_util.load_file_version_info;
1375: exception
1376: when others then
1377: ad_file_util.error_buf := 'load_snapshot_file_info('||snp_id||'):('||
1378: ad_file_util.error_buf||sqlerrm||')';
1379: raise;
1380: end;
1381: --

Line 1378: ad_file_util.error_buf||sqlerrm||')';

1374: ad_file_util.load_file_version_info;
1375: exception
1376: when others then
1377: ad_file_util.error_buf := 'load_snapshot_file_info('||snp_id||'):('||
1378: ad_file_util.error_buf||sqlerrm||')';
1379: raise;
1380: end;
1381: --
1382: -- get contain_file_id from ad_files

Line 1391: ad_file_util.error_buf := 'load_snapshot_file_info(cursor: '||

1387: --
1388: -- done processing ad_files
1389: --
1390: --
1391: ad_file_util.error_buf := 'load_snapshot_file_info(cursor: '||
1392: 'select file_version_id,check_sum,file_size, '||
1393: 'file_id,check_file_id,dest_file_id, '||
1394: 'file_type_flag from '||
1395: 'ad_check_file_temp):(';

Line 1401: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

1397: begin
1398: OPEN c1;
1399: exception
1400: when others then
1401: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1402: raise;
1403: end;
1404: --
1405: --

Line 1467: ad_file_util.error_buf := 'load_snapshot_file_info(Close cursor):('||

1463: begin
1464: close c1;
1465: exception
1466: when others then
1467: ad_file_util.error_buf := 'load_snapshot_file_info(Close cursor):('||
1468: sqlerrm||')';
1469: end;
1470: --
1471: --

Line 1473: ad_file_util.error_buf := 'load_snapshot_file_info('||

1469: end;
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, '||

Line 1521: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

1517: and nvl(sf2.containing_file_id,-1) = nvl(t.check_file_id,-1)
1518: );
1519: exception
1520: when others then
1521: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1522: raise;
1523: end;
1524:
1525: update ad_snapshots set last_update_date = sysdate

Line 1558: ad_file_util.error_buf := 'load_preseeded_bugfixes('||

1554: --
1555: -- Get the bug_id from ad_bugs
1556: --
1557: -- Bug 5758908 - stangutu - 14 June, 2007
1558: ad_file_util.error_buf := 'load_preseeded_bugfixes('||
1559: 'SET t.file_id = (SELECT b.bug_id '||
1560: 'FROM ad_bugs b WHERE b.bug_number = t.filename '||
1561: 'AND b.aru_release_name = t.subdir '||
1562: 'AND b.trackable_entity_abbr=t.app_short_name '||

Line 1587: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

1583: t.junk = NULL
1584: WHERE NVL(t.active_flag,'N') = 'Y';
1585: exception
1586: when others then
1587: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1588: raise;
1589: end;
1590: --
1591: -- add new entries in ad_bugs

Line 1594: ad_file_util.error_buf := 'load_preseeded_bugfixes('||

1590: --
1591: -- add new entries in ad_bugs
1592: --
1593: -- Bug 5758908 - stangutu - 14 Jun, 2007 */
1594: ad_file_util.error_buf := 'load_preseeded_bugfixes('||
1595: 'INSERT INTO ad_bugs '||
1596: '(bug_id, bug_number,aru_release_name, '||
1597: 'creation_date, created_by, last_update_date, '||
1598: 'last_updated_by, baseline_name, generic_patch, '||

Line 1644: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

1640: WHERE t.file_id is null
1641: AND NVL(t.active_flag,'N') = 'Y') temp;
1642: exception
1643: when others then
1644: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1645: raise;
1646: end;
1647: --
1648: -- add bug_id for new entries

Line 1651: ad_file_util.error_buf := 'load_preseeded_bugfixes('||

1647: --
1648: -- add bug_id for new entries
1649: --
1650: -- Bug 5758908 - stangutu - 14 June, 2007
1651: ad_file_util.error_buf := 'load_preseeded_bugfixes('||
1652: 'UPDATE ad_check_file_temp t '||
1653: 'SET t.file_id = (SELECT b.bug_id '||
1654: 'FROM ad_bugs b WHERE b.bug_number = t.filename '||
1655: 'AND b.aru_release_name = t.subdir, '||

Line 1681: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

1677: t.junk = NULL
1678: WHERE NVL(t.active_flag,'N') = 'Y';
1679: exception
1680: when others then
1681: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1682: raise;
1683: end;
1684: --
1685: -- store the pre-seed the list of bug fixes included

Line 1688: ad_file_util.error_buf := 'load_preseeded_bugfixes('||

1684: --
1685: -- store the pre-seed the list of bug fixes included
1686: -- in that Maintenance Pack.
1687: --
1688: ad_file_util.error_buf := 'load_preseeded_bugfixes('||
1689: 'INSERT into ad_snapshot_bugfixes( '||
1690: 'snapshot_bug_id,snapshot_id, '||
1691: 'bugfix_id,bug_status,success_flag, '||
1692: 'creation_date,last_update_date, '||

Line 1720: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

1716: where b.BUGFIX_ID=t.file_id and
1717: b.SNAPSHOT_ID=t.file_version_id_2);
1718: exception
1719: when others then
1720: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1721: raise;
1722: end;
1723: end load_preseeded_bugfixes;
1724: --

Line 3102: ad_file_util.error_buf := 'load_snpst_file_server_info(cursor: '||

3098: --
3099: --
3100: begin
3101:
3102: ad_file_util.error_buf := 'load_snpst_file_server_info(cursor: '||
3103: 'select file_id,check_file_id,server_type_admin_flag, '||
3104: 'server_type_forms_flag, server_type_node_flag, '||
3105: 'server_type_web_flag from '||
3106: 'ad_check_file_temp):(';

Line 3112: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

3108: begin
3109: OPEN c1;
3110: exception
3111: when others then
3112: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
3113: raise;
3114: end;
3115: --
3116: --

Line 3162: ad_file_util.error_buf := 'load_snpst_file_server_info(Close cursor):('||

3158: begin
3159: close c1;
3160: exception
3161: when others then
3162: ad_file_util.error_buf := 'load_snpst_file_server_info(Close cursor):('||
3163: sqlerrm||')';
3164: end;
3165:
3166: --

Line 3173: end ad_file_util;

3169: end load_snpst_file_server_info;
3170: --
3171: --
3172:
3173: end ad_file_util;