APPS.FND_HELP dependencies on FND_LOBS

Line 522: ' from fnd_lobs lob, '||

518:
519: mainc := ' hd.title title, '||
520: ' hd.application app, '||
521: ' hd.file_name fn '||
522: ' from fnd_lobs lob, '||
523: ' fnd_help_documents hd '||
524: ' where lob.program_name = ''FND_HELP'' '||
525: ' and upper(lob.file_format) = ''TEXT'' '||
526: ' and hd.file_id = lob.file_id '||

Line 674: -- Cleanup obsolete rows from fnd_lobs, fnd_help_documents, and

670: end load_target;
671:
672: -----------------------------------------------------------------------------
673: -- cull_row
674: -- Cleanup obsolete rows from fnd_lobs, fnd_help_documents, and
675: -- fnd_help_targets (called by FNDGFH and FNDGFU)
676: --
677: -- Usual case: a new version for this file_id, language, app, file_name
678: -- and custom level has been created. Therefore, it is desirable

Line 709: delete from fnd_lobs where file_id = f.file_id;

705: and file_id <> num_file_id;
706: begin
707: for f in fileid_cursor loop
708: delete from fnd_help_targets where file_id = f.file_id;
709: delete from fnd_lobs where file_id = f.file_id;
710: delete from fnd_help_documents where file_id = f.file_id;
711: end loop;
712: -----------------------------------------------
713: -- Remove ALL help targets for this document --

Line 754: delete from fnd_lobs

750: delete from fnd_help_documents fhd
751: where fhd.file_id = f.file_id;
752:
753: -- Lobs table...
754: delete from fnd_lobs
755: where file_id = f.file_id;
756:
757: end loop;
758: