[Home] [Help]
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
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
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)
677: num_file_id number := to_number(x_file_id);
678: begin
679:
680: -- Bug 13689517 Adding PREPARE calls for Online patching for seed tables
681: AD_ZD_SEED.PREPARE('FND_HELP_TARGETS');
682:
683: insert into fnd_help_targets (file_id, target_name)
684: values (num_file_id, upper(translate(x_target_name,'.','_')));
685:
679:
680: -- Bug 13689517 Adding PREPARE calls for Online patching for seed tables
681: AD_ZD_SEED.PREPARE('FND_HELP_TARGETS');
682:
683: insert into fnd_help_targets (file_id, target_name)
684: values (num_file_id, upper(translate(x_target_name,'.','_')));
685:
686: exception
687: when dup_val_on_index then
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
698: -- to remove the obsolete records to avoid querying and storing them.
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
732: delete from fnd_help_targets where file_id = f.file_id;
728: AD_ZD_SEED.PREPARE('FND_HELP_TARGETS');
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: -----------------------------------------------
735: end loop;
736: -----------------------------------------------
737: -- Remove ALL help targets for this document --
738: -----------------------------------------------
739: delete from fnd_help_targets where file_id = x_file_id;
740: end cull_row;
741:
742: -----------------------------------------------------------------------------
743: -- delete_doc
767:
768:
769: for f in fileid_cursor loop
770: -- Delete all help targets
771: delete from fnd_help_targets fht
772: where fht.file_id = f.file_id;
773:
774: -- Help documents...
775: delete from fnd_help_documents fhd