APPS.FND_HELP dependencies on FND_HELP_TARGETS

Line 163: from fnd_help_targets ht,

159: l.description longlang,
160: hd.language lang,
161: hd.title title,
162: hd.file_name fn
163: from fnd_help_targets ht,
164: fnd_help_documents hd,
165: fnd_languages_vl l
166: where ht.file_id = hd.file_id
167: and ht.target_name = target

Line 174: from fnd_help_targets ht,

170: order by l.description;
171:
172: cursor current_language is
173: select hd.file_id
174: from fnd_help_targets ht,
175: fnd_help_documents hd
176: where ht.file_id = hd.file_id
177: and ht.target_name = target
178: and hd.language = langcode

Line 183: fnd_help_targets ht2

179: and hd.application = app
180: and hd.custom_level =
181: (select max(hd2.custom_level)
182: from fnd_help_documents hd2,
183: fnd_help_targets ht2
184: where ht2.target_name = ht.target_name
185: and ht2.file_id = hd2.file_id
186: and hd2.language = hd.language
187: and hd2.application = hd.application)

Line 664: insert into fnd_help_targets (file_id, target_name)

660: x_file_id in varchar2,
661: x_target_name in varchar2 ) is
662: num_file_id number := to_number(x_file_id);
663: begin
664: insert into fnd_help_targets (file_id, target_name)
665: values (num_file_id, upper(translate(x_target_name,'.','_')));
666:
667: exception
668: when dup_val_on_index then

Line 675: -- fnd_help_targets (called by FNDGFH and FNDGFU)

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
679: -- to remove the obsolete records to avoid querying and storing them.

Line 708: delete from fnd_help_targets where file_id = f.file_id;

704: and custom_level = num_custom_level
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: -----------------------------------------------

Line 715: delete from fnd_help_targets where file_id = x_file_id;

711: end loop;
712: -----------------------------------------------
713: -- Remove ALL help targets for this document --
714: -----------------------------------------------
715: delete from fnd_help_targets where file_id = x_file_id;
716: end cull_row;
717:
718: -----------------------------------------------------------------------------
719: -- delete_doc

Line 746: delete from fnd_help_targets fht

742: begin
743:
744: for f in fileid_cursor loop
745: -- Delete all help targets
746: delete from fnd_help_targets fht
747: where fht.file_id = f.file_id;
748:
749: -- Help documents...
750: delete from fnd_help_documents fhd