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_VERSIONS

Line 363: -- ad_file_versions.

359: -- load_file_version_info
360: --
361: -- Purpose
362: -- Imports file information from ad_check_file_temp to ad_files and
363: -- ad_file_versions.
364: --
365: -- Only creates rows that don't already exist.
366: --
367: -- Processes all rows in ad_check_file_temp with active_flag='Y'.

Line 410: -- get file_version_id from ad_file_versions

406: -- process ad_file_versons
407: --
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 = '||

Line 416: 'from ad_file_versions fv '||

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 '||
417: 'where fv.file_id = t.file_id '||
418: 'and fv.version = t.manifest_vers '||
419: 'and fv.translation_level = '||
420: 't.translation_level) '||

Line 426: (select /+ INDEX(FV AD_FILE_VERSIONS_U2) / fv.file_version_id

422: 'and lower(t.manifest_vers)<>''none'';):(';
423: begin
424: update ad_check_file_temp t
425: set t.file_version_id =
426: (select /*+ INDEX(FV AD_FILE_VERSIONS_U2) */ fv.file_version_id
427: from ad_file_versions fv
428: where fv.file_id = t.file_id
429: and fv.version = t.manifest_vers
430: and fv.translation_level = t.translation_level)

Line 427: from ad_file_versions fv

423: begin
424: update ad_check_file_temp t
425: set t.file_version_id =
426: (select /*+ INDEX(FV AD_FILE_VERSIONS_U2) */ fv.file_version_id
427: from ad_file_versions fv
428: where fv.file_id = t.file_id
429: and fv.version = t.manifest_vers
430: and fv.translation_level = t.translation_level)
431: where nvl(t.active_flag,'N') = 'Y'

Line 440: -- add new entries to ad_file_versions

436: raise;
437: end;
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, '||

Line 443: 'insert into ad_file_versions '||

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, '||
447: 'version_segment3, version_segment4, '||

Line 453: 'ad_file_versions_s.nextval, '||

449: 'version_segment7, version_segment8, '||
450: 'version_segment9, version_segment10, '||
451: 'creation_date, created_by, last_update_date, '||
452: 'last_updated_by) select '||
453: 'ad_file_versions_s.nextval, '||
454: 'temp.f_id, temp.vers, temp.trans_level, '||
455: 'temp.vs1, temp.vs2, temp.vs3, temp.vs4, '||
456: 'temp.vs5, temp.vs6, temp.vs7, temp.vs8, '||
457: 'temp.vs9, temp.vs10, temp.edate, 5, '||

Line 463: insert into ad_file_versions

459: 't.file_id f_id, t.manifest_vers vers, '||
460: 't.translation_level trans_level,....);):(';
461:
462: begin
463: insert into ad_file_versions
464: (file_version_id, file_id, version, translation_level,
465: version_segment1, version_segment2, version_segment3,
466: version_segment4, version_segment5, version_segment6,
467: version_segment7, version_segment8, version_segment9,

Line 470: select ad_file_versions_s.nextval,

466: version_segment4, version_segment5, version_segment6,
467: version_segment7, version_segment8, version_segment9,
468: version_segment10,
469: creation_date, created_by, last_update_date, last_updated_by)
470: select ad_file_versions_s.nextval,
471: temp.f_id, temp.vers, temp.trans_level,
472: temp.vs1, temp.vs2, temp.vs3, temp.vs4, temp.vs5,
473: temp.vs6, temp.vs7, temp.vs8, temp.vs9, temp.vs10,
474: temp.edate, 5, temp.edate, 5

Line 549: 'from ad_file_versions fv '||

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 '||
550: 'where fv.file_id = t.file_id '||
551: 'and fv.version = t.manifest_vers '||
552: 'and fv.translation_level = t.translation_level)'||
553: 'where t.file_version_id is null '||

Line 561: (select /+ INDEX(FV AD_FILE_VERSIONS_U2) / fv.file_version_id

557:
558: begin
559: update ad_check_file_temp t
560: set t.file_version_id =
561: (select /*+ INDEX(FV AD_FILE_VERSIONS_U2) */ fv.file_version_id
562: from ad_file_versions fv
563: where fv.file_id = t.file_id
564: and fv.version = t.manifest_vers
565: and fv.translation_level = t.translation_level)

Line 562: from ad_file_versions fv

558: begin
559: update ad_check_file_temp t
560: set t.file_version_id =
561: (select /*+ INDEX(FV AD_FILE_VERSIONS_U2) */ fv.file_version_id
562: from ad_file_versions fv
563: where fv.file_id = t.file_id
564: and fv.version = t.manifest_vers
565: and fv.translation_level = t.translation_level)
566: where t.file_version_id is null

Line 587: -- ad_file_versions, and ad_check_files.

583: -- load_checkfile_info
584: --
585: -- Purpose
586: -- Imports file information from ad_check_file_temp to ad_files,
587: -- ad_file_versions, and ad_check_files.
588: --
589: -- Only creates rows in ad_files and ad_file_versions that don't
590: -- already exist. In ad_check_files, it creates rows that don't already
591: -- exist and also updates existing rows if the version to load is higher

Line 589: -- Only creates rows in ad_files and ad_file_versions that don't

585: -- Purpose
586: -- Imports file information from ad_check_file_temp to ad_files,
587: -- ad_file_versions, and ad_check_files.
588: --
589: -- Only creates rows in ad_files and ad_file_versions that don't
590: -- already exist. In ad_check_files, it creates rows that don't already
591: -- exist and also updates existing rows if the version to load is higher
592: -- than the current version in ad_check_files.
593: --

Line 624: -- process ad_files and ad_file_versions

620: procedure load_checkfile_info(p_ebr_flow boolean default false)
621: is
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;

Line 660: (select /*+ ORDERED INDEX(FV1 AD_FILE_VERSIONS_U1)

656: from ad_check_files cf
657: where cf.file_id = t.file_id
658: and nvl(cf.distinguisher,'*null*') = nvl(t.distinguisher,'*null*')),
659: t.manifest_vers_higher =
660: (select /*+ ORDERED INDEX(FV1 AD_FILE_VERSIONS_U1)
661: INDEX(CF AD_CHECK_FILES_U2) INDEX(FV2 AD_FILE_VERSIONS_U1)
662: USE_NL(FV1 CF FV2) */
663: decode(
664: sign(nvl(fv1.version_segment1,0) - nvl(fv2.version_segment1,0)),

Line 661: INDEX(CF AD_CHECK_FILES_U2) INDEX(FV2 AD_FILE_VERSIONS_U1)

657: where cf.file_id = t.file_id
658: and nvl(cf.distinguisher,'*null*') = nvl(t.distinguisher,'*null*')),
659: t.manifest_vers_higher =
660: (select /*+ ORDERED INDEX(FV1 AD_FILE_VERSIONS_U1)
661: INDEX(CF AD_CHECK_FILES_U2) INDEX(FV2 AD_FILE_VERSIONS_U1)
662: USE_NL(FV1 CF FV2) */
663: decode(
664: sign(nvl(fv1.version_segment1,0) - nvl(fv2.version_segment1,0)),
665: -1, null, 1, 'Y', decode(

Line 686: from ad_file_versions fv1, ad_check_files cf, ad_file_versions fv2

682: sign(nvl(fv1.version_segment10,0) - nvl(fv2.version_segment10,0)),
683: -1, null, 1, 'Y', decode(
684: sign(fv1.translation_level - fv2.translation_level),
685: -1, null, 1, 'Y', null)))))))))))
686: from ad_file_versions fv1, ad_check_files cf, ad_file_versions fv2
687: where t.file_version_id = fv1.file_version_id
688: and t.file_id = cf.file_id
689: and nvl(t.distinguisher,'*null*') = nvl(cf.distinguisher,'*null*')
690: and cf.file_version_id = fv2.file_version_id)

Line 960: -- ad_file_versions.

956: -- load_patch_onsite_vers_info
957: --
958: -- Purpose
959: -- Imports file information from ad_check_file_temp to ad_files and
960: -- ad_file_versions.
961: --
962: -- Only creates rows that don't already exist.
963: --
964: -- Processes all rows in ad_check_file_temp with active_flag='Y'.

Line 984: -- Doesn't try to update ad_file_versions for rows in ad_check_file_temp

980: -- Updates the file_version_id and file_version_id_2 columns of
981: -- ad_check_file_temp so that all rows point to the file_version_id
982: -- of the file versions referenced in the row.
983: --
984: -- Doesn't try to update ad_file_versions for rows in ad_check_file_temp
985: -- with manifest_vers='NA' or manifest_vers_2='NA'. These values mean
986: -- "no version for this file", so no corresponding record should be
987: -- created in ad_file_versions.
988: --

Line 987: -- created in ad_file_versions.

983: --
984: -- Doesn't try to update ad_file_versions for rows in ad_check_file_temp
985: -- with manifest_vers='NA' or manifest_vers_2='NA'. These values mean
986: -- "no version for this file", so no corresponding record should be
987: -- created in ad_file_versions.
988: --
989: -- Arguments
990: -- none
991: --

Line 1008: 'from ad_file_versions fv '||

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 '||
1009: 'where fv.file_id = t.file_id '||
1010: 'and fv.version = t.manifest_vers '||
1011: 'and fv.translation_level = t.translation_level) '||
1012: 'where nvl(t.active_flag,''N'') = ''Y'' '||

Line 1018: (select /+ INDEX(FV AD_FILE_VERSIONS_U2) / fv.file_version_id

1014:
1015: begin
1016: update ad_check_file_temp t
1017: set t.file_version_id =
1018: (select /*+ INDEX(FV AD_FILE_VERSIONS_U2) */ fv.file_version_id
1019: from ad_file_versions fv
1020: where fv.file_id = t.file_id
1021: and fv.version = t.manifest_vers
1022: and fv.translation_level = t.translation_level)

Line 1019: from ad_file_versions fv

1015: begin
1016: update ad_check_file_temp t
1017: set t.file_version_id =
1018: (select /*+ INDEX(FV AD_FILE_VERSIONS_U2) */ fv.file_version_id
1019: from ad_file_versions fv
1020: where fv.file_id = t.file_id
1021: and fv.version = t.manifest_vers
1022: and fv.translation_level = t.translation_level)
1023: where nvl(t.active_flag,'N') = 'Y'

Line 1031: -- add new entries to ad_file_versions

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

Line 1034: 'insert into ad_file_versions '||

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, '||
1038: 'version_segment4, version_segment5, '||

Line 1045: insert into ad_file_versions

1041: 'version_segment10, creation_date, created_by, '||
1042: 'last_update_date, last_updated_by) '||
1043: '.....):(';
1044: begin
1045: insert into ad_file_versions
1046: (file_version_id, file_id, version, translation_level,
1047: version_segment1, version_segment2, version_segment3,
1048: version_segment4, version_segment5, version_segment6,
1049: version_segment7, version_segment8, version_segment9,

Line 1052: select ad_file_versions_s.nextval,

1048: version_segment4, version_segment5, version_segment6,
1049: version_segment7, version_segment8, version_segment9,
1050: version_segment10,
1051: creation_date, created_by, last_update_date, last_updated_by)
1052: select ad_file_versions_s.nextval,
1053: temp.f_id, temp.vers, temp.trans_level,
1054: temp.vs1, temp.vs2, temp.vs3, temp.vs4, temp.vs5,
1055: temp.vs6, temp.vs7, temp.vs8, temp.vs9, temp.vs10,
1056: temp.edate, 5, temp.edate, 5

Line 1127: 'from ad_file_versions fv '||

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 '||
1128: 'where fv.file_id = t.file_id '||
1129: 'and fv.version = t.manifest_vers '||
1130: 'and fv.translation_level = t.translation_level) '||
1131: 'where nvl(t.active_flag,''N'') = ''Y'' '||

Line 1138: (select /+ INDEX(FV AD_FILE_VERSIONS_U2) / fv.file_version_id

1134: --
1135: begin
1136: update ad_check_file_temp t
1137: set t.file_version_id =
1138: (select /*+ INDEX(FV AD_FILE_VERSIONS_U2) */ fv.file_version_id
1139: from ad_file_versions fv
1140: where fv.file_id = t.file_id
1141: and fv.version = t.manifest_vers
1142: and fv.translation_level = t.translation_level)

Line 1139: from ad_file_versions fv

1135: begin
1136: update ad_check_file_temp t
1137: set t.file_version_id =
1138: (select /*+ INDEX(FV AD_FILE_VERSIONS_U2) */ fv.file_version_id
1139: from ad_file_versions fv
1140: where fv.file_id = t.file_id
1141: and fv.version = t.manifest_vers
1142: and fv.translation_level = t.translation_level)
1143: where nvl(t.active_flag,'N') = 'Y'

Line 1151: -- get file_version_id_2 from ad_file_versions

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
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 = '||

Line 1157: 'from ad_file_versions fv '||

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 '||
1158: 'where fv.file_id = t.file_id '||
1159: 'and fv.version = t.manifest_vers_2 '||
1160: 'nvl(t.manifest_vers_2,''NA'')<>''NA''):(';
1161: --

Line 1166: (select /+ INDEX(FV AD_FILE_VERSIONS_U2) / fv.file_version_id

1162: --
1163: begin
1164: update ad_check_file_temp t
1165: set t.file_version_id_2 =
1166: (select /*+ INDEX(FV AD_FILE_VERSIONS_U2) */ fv.file_version_id
1167: from ad_file_versions fv
1168: where fv.file_id = t.file_id
1169: and fv.version = t.manifest_vers_2
1170: and fv.translation_level = t.translation_level)

Line 1167: from ad_file_versions fv

1163: begin
1164: update ad_check_file_temp t
1165: set t.file_version_id_2 =
1166: (select /*+ INDEX(FV AD_FILE_VERSIONS_U2) */ fv.file_version_id
1167: from ad_file_versions fv
1168: where fv.file_id = t.file_id
1169: and fv.version = t.manifest_vers_2
1170: and fv.translation_level = t.translation_level)
1171: where nvl(t.active_flag,'N') = 'Y' AND

Line 1180: -- add new entries to ad_file_versions

1176: raise;
1177: end;
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, '||

Line 1183: 'insert into ad_file_versions '||

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, '||
1187: 'version_segment4, version_segment5, '||

Line 1195: insert into ad_file_versions

1191: 'last_update_date, last_updated_by) '||
1192: '.....):(';
1193: --
1194: begin
1195: insert into ad_file_versions
1196: (file_version_id, file_id, version, translation_level,
1197: version_segment1, version_segment2, version_segment3,
1198: version_segment4, version_segment5, version_segment6,
1199: version_segment7, version_segment8, version_segment9,

Line 1202: select ad_file_versions_s.nextval,

1198: version_segment4, version_segment5, version_segment6,
1199: version_segment7, version_segment8, version_segment9,
1200: version_segment10,
1201: creation_date, created_by, last_update_date, last_updated_by)
1202: select ad_file_versions_s.nextval,
1203: temp.f_id, temp.vers, temp.trans_level,
1204: temp.vs1, temp.vs2, temp.vs3, temp.vs4, temp.vs5,
1205: temp.vs6, temp.vs7, temp.vs8, temp.vs9, temp.vs10,
1206: temp.edate, 5, temp.edate, 5

Line 1272: -- get file_version_id_2 from ad_file_versions

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
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 = '||

Line 1278: 'from ad_file_versions fv '||

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 '||
1279: 'where fv.file_id = t.file_id '||
1280: 'and fv.version = t.manifest_vers_2 '||
1281: 'nvl(t.manifest_vers_2,''NA'')<>''NA''):(';
1282: begin

Line 1285: (select /+ INDEX(FV AD_FILE_VERSIONS_U2) / fv.file_version_id

1281: 'nvl(t.manifest_vers_2,''NA'')<>''NA''):(';
1282: begin
1283: update ad_check_file_temp t
1284: set t.file_version_id_2 =
1285: (select /*+ INDEX(FV AD_FILE_VERSIONS_U2) */ fv.file_version_id
1286: from ad_file_versions fv
1287: where fv.file_id = t.file_id
1288: and fv.version = t.manifest_vers_2
1289: and fv.translation_level = t.translation_level)

Line 1286: from ad_file_versions fv

1282: begin
1283: update ad_check_file_temp t
1284: set t.file_version_id_2 =
1285: (select /*+ INDEX(FV AD_FILE_VERSIONS_U2) */ fv.file_version_id
1286: from ad_file_versions fv
1287: where fv.file_id = t.file_id
1288: and fv.version = t.manifest_vers_2
1289: and fv.translation_level = t.translation_level)
1290: where nvl(t.active_flag,'N') = 'Y' AND

Line 1298: -- done processing ad_file_versions

1294: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1295: raise;
1296: end;
1297: --
1298: -- done processing ad_file_versions
1299: --
1300: end load_patch_onsite_vers_info;
1301:
1302: --

Line 1310: -- 1.Calls ad_file_versions and loads the file versions

1306: -- load_snapshot_file_info
1307: --
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

Line 1371: -- process ad_files and ad_file_versions

1367: --
1368: --
1369: begin
1370: --
1371: -- process ad_files and ad_file_versions
1372: --
1373: begin
1374: ad_file_util.load_file_version_info;
1375: exception

Line 2025: -- Add new entries in the ad_file_versions

2021: --
2022: commit;
2023:
2024: --
2025: -- Add new entries in the ad_file_versions
2026: --
2027: INSERT into ad_file_versions
2028: (file_version_id, file_id, version, translation_level,
2029: version_segment1, version_segment2, version_segment3,

Line 2027: INSERT into ad_file_versions

2023:
2024: --
2025: -- Add new entries in the ad_file_versions
2026: --
2027: INSERT into ad_file_versions
2028: (file_version_id, file_id, version, translation_level,
2029: version_segment1, version_segment2, version_segment3,
2030: version_segment4, version_segment5, version_segment6,
2031: version_segment7, version_segment8, version_segment9,

Line 2035: ad_file_versions_s.nextval,

2031: version_segment7, version_segment8, version_segment9,
2032: version_segment10,
2033: creation_date, created_by, last_update_date, last_updated_by)
2034: select
2035: ad_file_versions_s.nextval,
2036: temp.f_id, temp.vers, temp.trans_level,
2037: temp.vs1, temp.vs2, temp.vs3, temp.vs4, temp.vs5,
2038: temp.vs6, temp.vs7, temp.vs8, temp.vs9, temp.vs10,
2039: sysdate, 5, sysdate, 5

Line 2066: ad_file_versions vers

2062: where not exists (
2063: select
2064: 'x'
2065: from
2066: ad_file_versions vers
2067: where
2068: vers.file_id = temp.f_id
2069: and vers.version = temp.vers
2070: and vers.translation_level = temp.trans_level);

Line 2072: -- Add new entries in the ad_file_versions

2068: vers.file_id = temp.f_id
2069: and vers.version = temp.vers
2070: and vers.translation_level = temp.trans_level);
2071: --
2072: -- Add new entries in the ad_file_versions
2073: --
2074: INSERT into ad_file_versions
2075: (file_version_id, file_id, version, translation_level,
2076: version_segment1, version_segment2, version_segment3,

Line 2074: INSERT into ad_file_versions

2070: and vers.translation_level = temp.trans_level);
2071: --
2072: -- Add new entries in the ad_file_versions
2073: --
2074: INSERT into ad_file_versions
2075: (file_version_id, file_id, version, translation_level,
2076: version_segment1, version_segment2, version_segment3,
2077: version_segment4, version_segment5, version_segment6,
2078: version_segment7, version_segment8, version_segment9,

Line 2082: ad_file_versions_s.nextval,

2078: version_segment7, version_segment8, version_segment9,
2079: version_segment10,
2080: creation_date, created_by, last_update_date, last_updated_by)
2081: select
2082: ad_file_versions_s.nextval,
2083: temp.f_id, temp.vers, temp.trans_level,
2084: temp.vs1, temp.vs2, temp.vs3, temp.vs4, temp.vs5,
2085: temp.vs6, temp.vs7, temp.vs8, temp.vs9, temp.vs10,
2086: sysdate, 5, sysdate, 5

Line 2112: ad_file_versions vers

2108: where not exists (
2109: select
2110: 'x'
2111: from
2112: ad_file_versions vers
2113: where
2114: vers.file_id = temp.f_id
2115: and vers.version = temp.vers
2116: and vers.translation_level = temp.trans_level);

Line 2118: -- Add new entries in the ad_file_versions

2114: vers.file_id = temp.f_id
2115: and vers.version = temp.vers
2116: and vers.translation_level = temp.trans_level);
2117: --
2118: -- Add new entries in the ad_file_versions
2119: --
2120: INSERT into ad_file_versions
2121: (file_version_id, file_id, version, translation_level,
2122: version_segment1, version_segment2, version_segment3,

Line 2120: INSERT into ad_file_versions

2116: and vers.translation_level = temp.trans_level);
2117: --
2118: -- Add new entries in the ad_file_versions
2119: --
2120: INSERT into ad_file_versions
2121: (file_version_id, file_id, version, translation_level,
2122: version_segment1, version_segment2, version_segment3,
2123: version_segment4, version_segment5, version_segment6,
2124: version_segment7, version_segment8, version_segment9,

Line 2128: ad_file_versions_s.nextval,

2124: version_segment7, version_segment8, version_segment9,
2125: version_segment10,
2126: creation_date, created_by, last_update_date, last_updated_by)
2127: select
2128: ad_file_versions_s.nextval,
2129: tmp.f_id,tmp.vers, tmp.trans_level,
2130: tmp.vs1, tmp.vs2, tmp.vs3, tmp.vs4,
2131: tmp.vs5, tmp.vs6, tmp.vs7, tmp.vs8,
2132: tmp.vs9, tmp.vs10,sysdate, 5, sysdate, 5

Line 2159: ad_file_versions vers

2155: where not exists (
2156: select
2157: 'x'
2158: from
2159: ad_file_versions vers
2160: where
2161: vers.file_id = tmp.f_id
2162: and vers.version = tmp.vers
2163: and vers.translation_level = tmp.trans_level);

Line 2178: ad_file_versions fv

2174: set t.PATCH_FILE_VERS_ID =
2175: (select
2176: fv.file_version_id
2177: from
2178: ad_file_versions fv
2179: where
2180: fv.file_id = t.file_id
2181: and fv.version = t.PATCH_FILE_VERS
2182: and fv.translation_level = t.PATCH_TRANS_LEVEL)

Line 2198: ad_file_versions fv

2194: set t.ONSITE_FILE_VERS_ID =
2195: (select
2196: fv.file_version_id
2197: from
2198: ad_file_versions fv
2199: where
2200: fv.file_id = t.file_id
2201: and fv.version = t.ONSITE_FILE_VERS
2202: and fv.translation_level = t.ONSITE_TRANS_LEVEL

Line 2217: ad_file_versions fv

2213: set t.DB_FILE_VERS_ID =
2214: (select
2215: fv.file_version_id
2216: from
2217: ad_file_versions fv
2218: where
2219: fv.file_id = t.file_id
2220: and fv.version = t.DB_FILE_VERS
2221: and fv.translation_level = t.DB_TRANS_LEVEL)

Line 2734: ad_file_versions v

2730: v.VERSION_SEGMENT7, v.VERSION_SEGMENT8,
2731: v.VERSION_SEGMENT9, v.VERSION_SEGMENT10,
2732: v.VERSION, v.TRANSLATION_LEVEL
2733: from
2734: ad_file_versions v
2735: where
2736: v.file_version_id = tmp.PATCH_FILE_VERS_ID),
2737: tmp.concat_attribs=null;
2738: --