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_CHECK_FILES

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 590: -- already exist. In ad_check_files, it creates rows that don't already

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: --
594: -- Processes all rows in ad_check_file_temp with active_flag='Y'.

Line 592: -- than the current version in 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: --
594: -- Processes all rows in ad_check_file_temp with active_flag='Y'.
595: --
596: -- To handle batch sizes:

Line 611: -- rows that were already in ad_check_files point to the check_file_id

607: --
608: -- Calls load_file_version_info
609: --
610: -- Updates the check_file_id column of ad_check_file_temp so that any
611: -- rows that were already in ad_check_files point to the check_file_id
612: -- of the (file, distinguisher) referenced in the row. Rows in
613: -- ad_check_file_temp that did not already have corresponding rows in
614: -- ad_check_files still have null values for check_file_id
615: -- (assuming they started out as null)

Line 614: -- ad_check_files still have null values for check_file_id

610: -- Updates the check_file_id column of ad_check_file_temp so that any
611: -- rows that were already in ad_check_files point to the check_file_id
612: -- of the (file, distinguisher) referenced in the row. Rows in
613: -- ad_check_file_temp that did not already have corresponding rows in
614: -- ad_check_files still have null values for check_file_id
615: -- (assuming they started out as null)
616: --
617: -- Arguments
618: -- none

Line 636: -- process ad_check_files

632: ad_file_util.error_buf||sqlerrm||')';
633: raise;
634: end;
635: --
636: -- process ad_check_files
637: --
638:
639: --
640: -- get check_file_id and manifest_vers_higher

Line 646: 'from ad_check_files cf '||

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 '||
647: 'where cf.file_id = t.file_id '||
648: 'and nvl(cf.distinguisher,''*null*'') ='||
649: ' nvl(t.distinguisher,''*null*'')), '||
650: 't.manifest_vers_higher =.....);):(';

Line 655: (select /+ INDEX(CF AD_CHECK_FILES_U2) / cf.check_file_id

651:
652: begin
653: update ad_check_file_temp t
654: set t.check_file_id =
655: (select /*+ INDEX(CF AD_CHECK_FILES_U2) */ cf.check_file_id
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 =

Line 656: from ad_check_files cf

652: begin
653: update ad_check_file_temp t
654: set t.check_file_id =
655: (select /*+ INDEX(CF AD_CHECK_FILES_U2) */ cf.check_file_id
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)

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 698: -- add new entries into ad_check_files

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
699: --
700: ad_file_util.error_buf := 'load_checkfile_info('||
701: 'insert into ad_check_files '||
702: '(check_file_id, file_id, distinguisher, '||

Line 701: 'insert into ad_check_files '||

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, '||
705: 'temp.f_id, temp.dist, temp.fv_id, '||

Line 704: 'select ad_check_files_s.nextval, '||

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, '||
705: 'temp.f_id, temp.dist, temp.fv_id, '||
706: 'temp.edate from (select distinct '||
707: 't.file_id f_id, t.distinguisher dist, '||
708: 't.file_version_id fv_id, '||

Line 715: insert into ad_check_files

711: 'is null and nvl(t.active_flag,''N'') = '||
712: '''Y'') temp;):(';
713:
714: begin
715: insert into ad_check_files
716: (check_file_id, file_id, distinguisher,
717: file_version_id, creation_date)
718: select ad_check_files_s.nextval,
719: temp.f_id, temp.dist, temp.fv_id, temp.edate

Line 718: select ad_check_files_s.nextval,

714: begin
715: insert into ad_check_files
716: (check_file_id, file_id, distinguisher,
717: file_version_id, creation_date)
718: select ad_check_files_s.nextval,
719: temp.f_id, temp.dist, temp.fv_id, temp.edate
720: from
721: (select distinct
722: t.file_id f_id,

Line 746: 'from ad_check_files acf, ad_check_file_temp acft ' ||

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 ' ||
747: ' where acft.check_file_id is null ' ||
748: ' and nvl(acft.active_flag,''N'') = ''Y'' ' ||
749: ' and acf.file_id=acft.file_id ' ||
750: ' and nvl(acf.distinguisher, ''x'')=nvl(acft.distinguisher, ''x''))';

Line 756: from ad_check_files acf, ad_check_file_temp acft

752: begin
753: insert into ad_check_file_history
754: (CHECK_FILE_ID, FILE_VERSION_ID, PATCH_RUN_ID, CREATION_DATE)
755: select distinct acf.check_file_id, acf.file_version_id, -1, sysdate
756: from ad_check_files acf, ad_check_file_temp acft
757: where acft.check_file_id is null
758: and nvl(acft.active_flag,'N') = 'Y'
759: and acf.file_id=acft.file_id
760: and nvl(acf.distinguisher, 'x')=nvl(acft.distinguisher, 'x');

Line 770: -- delete from ad_check_files where versions lower than manifest

766: end;
767: end if;
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 '||

Line 773: 'delete from ad_check_files kf '||

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 '||
777: 'where t.manifest_vers_higher = ''Y'' '||

Line 781: delete /+ INDEX(CF AD_CHECK_FILES_U1) / from ad_check_files cf

777: 'where t.manifest_vers_higher = ''Y'' '||
778: 'and nvl(t.active_flag,''N'') = ''Y'');):(';
779:
780: begin
781: delete /*+ INDEX(CF AD_CHECK_FILES_U1) */ from ad_check_files cf
782: where cf.check_file_id in
783: (select t.check_file_id
784: from ad_check_file_temp t
785: where t.manifest_vers_higher = 'Y'

Line 793: -- insert into ad_check_files where versions lower than manifest

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
794: --
795: ad_file_util.error_buf := 'load_checkfile_info('||
796: ' insert into ad_check_files '||
797: '(check_file_id, file_id, distinguisher, '||

Line 796: ' insert into ad_check_files '||

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, '||
800: 'temp.f_id, temp.dist, temp.fv_id, temp.edate '||

Line 812: insert into ad_check_files

808: 'where t.manifest_vers_higher = ''Y'' '||
809: 'and nvl(t.active_flag,''N'') = ''Y'') temp;):(';
810:
811: begin
812: insert into ad_check_files
813: (check_file_id, file_id, distinguisher,
814: file_version_id, creation_date)
815: select temp.cf_id,
816: temp.f_id, temp.dist, temp.fv_id, temp.edate

Line 843: ' from ad_check_files acf, ad_check_file_temp acft ' ||

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 ' ||
844: ' where acft.manifest_vers_higher = ''Y'' ' ||
845: ' and nvl(acft.active_flag,''N'') = ''Y'' ' ||
846: ' and acf.file_id=acft.file_id ' ||
847: ' and acf.distinguisher=acft.distinguisher)';

Line 853: from ad_check_files acf, ad_check_file_temp acft

849: begin
850: insert into ad_check_file_history
851: (CHECK_FILE_ID, FILE_VERSION_ID, PATCH_RUN_ID, CREATION_DATE)
852: select distinct acf.check_file_id, acf.file_version_id, -1, sysdate
853: from ad_check_files acf, ad_check_file_temp acft
854: where acft.manifest_vers_higher = 'Y'
855: and nvl(acft.active_flag,'N') = 'Y'
856: and acf.file_id=acft.file_id
857: and nvl(acf.distinguisher, 'x')=nvl(acft.distinguisher, 'x');

Line 866: -- done processing ad_check_files

862: raise;
863: end;
864: end if;
865: --
866: -- done processing ad_check_files
867: --
868:
869: end load_checkfile_info;
870: