[Home] [Help]
530:
531: mainc := ' hd.title title, '||
532: ' hd.application app, '||
533: ' hd.file_name fn '||
534: ' from fnd_lobs lob, '||
535: ' fnd_help_documents hd '||
536: ' where lob.program_name = ''FND_HELP'' '||
537: ' and upper(lob.file_format) = ''TEXT'' '||
538: ' and hd.file_id = lob.file_id '||
689: end load_target;
690:
691: -----------------------------------------------------------------------------
692: -- cull_row
693: -- Cleanup obsolete rows from fnd_lobs, fnd_help_documents, and
694: -- fnd_help_targets (called by FNDGFH and FNDGFU)
695: --
696: -- Usual case: a new version for this file_id, language, app, file_name
697: -- and custom level has been created. Therefore, it is desirable
723: and custom_level = num_custom_level
724: and file_id <> num_file_id;
725: begin
726: -- Bug 13689517 Adding PREPARE calls for Online patching for seed tables.
727: -- FND_LOBS has not been designated as a seed table so no PREPARE is needed.
728: AD_ZD_SEED.PREPARE('FND_HELP_TARGETS');
729: AD_ZD_SEED.PREPARE('FND_HELP_DOCUMENTS');
730:
731: for f in fileid_cursor loop
729: AD_ZD_SEED.PREPARE('FND_HELP_DOCUMENTS');
730:
731: for f in fileid_cursor loop
732: delete from fnd_help_targets where file_id = f.file_id;
733: delete from fnd_lobs where file_id = f.file_id;
734: delete from fnd_help_documents where file_id = f.file_id;
735: end loop;
736: -----------------------------------------------
737: -- Remove ALL help targets for this document --
775: delete from fnd_help_documents fhd
776: where fhd.file_id = f.file_id;
777:
778: -- Lobs table...
779: delete from fnd_lobs
780: where file_id = f.file_id;
781:
782: end loop;
783: