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.FND_HELP dependencies on FND_HELP

Line 1: package body fnd_help as

1: package body fnd_help as
2: /* $Header: AFMLHLPB.pls 120.6 2012/02/28 15:59:49 ctilley ship $ */
3:
4: -----------------------------------------------------------------------------
5: -- GetLangCode (PRIVATE)

Line 67: from fnd_help_documents hd,

63: l.description longlang,
64: hd.language lang,
65: hd.title title,
66: hd.file_name fn
67: from fnd_help_documents hd,
68: fnd_languages_vl l
69: where hd.file_name = file
70: and hd.application = app
71: and l.language_code = hd.language

Line 83: from fnd_help_documents hd

79: -- First, look in current language --
80: -------------------------------------
81: begin
82: select hd.file_id into fid
83: from fnd_help_documents hd
84: where hd.application = app
85: and hd.file_name = file
86: and hd.language = langcode
87: and rownum=1

Line 90: from fnd_help_documents hd2

86: and hd.language = langcode
87: and rownum=1
88: and hd.custom_level =
89: (select max(hd2.custom_level)
90: from fnd_help_documents hd2
91: where hd2.file_name = hd.file_name
92: and hd2.language = hd.language
93: and hd2.application = hd.application);
94:

Line 112: from fnd_help_documents hd

108: ----------------------------------------------------------
109: if (langcode <> 'US' AND substr(file, -3) = 'GIF') then
110: begin
111: select hd.file_id into fid
112: from fnd_help_documents hd
113: where hd.application = app
114: and hd.file_name = file
115: and hd.language = 'US'
116: and rownum=1

Line 119: from fnd_help_documents hd2

115: and hd.language = 'US'
116: and rownum=1
117: and hd.custom_level =
118: (select max(hd2.custom_level)
119: from fnd_help_documents hd2
120: where hd2.file_name = hd.file_name
121: and hd2.language = hd.language
122: and hd2.application = hd.application);
123:

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 164: fnd_help_documents hd,

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
168: and hd.application = app

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 175: fnd_help_documents hd

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

Line 182: from fnd_help_documents hd2,

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

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 535: ' fnd_help_documents hd '||

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 '||
539: ' and hd.language = '''||langcode||''' '||

Line 536: ' where lob.program_name = ''FND_HELP'' '||

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 '||
539: ' and hd.language = '''||langcode||''' '||
540: appnameClause ||

Line 545: ' from fnd_help_documents hd2 '||

541: ' and hd.file_name <> ''ATGRP.GIF'' '||
542: ' and hd.title is not null '||
543: ' and hd.custom_level = '||
544: ' (select /*+no_unnest*/ max(hd2.custom_level) '||
545: ' from fnd_help_documents hd2 '||
546: ' where hd2.file_name = hd.file_name '||
547: ' and hd2.language = hd.language '||
548: ' and hd2.application = hd.application) ';
549:

Line 636: AD_ZD_SEED.PREPARE('FND_HELP_DOCUMENTS');

632: num_file_id number := to_number(x_file_id);
633: num_custom_level number := to_number(x_custom_level);
634: begin
635: -- Bug 13689517 Adding PREPARE calls for Online patching for seed tables.
636: AD_ZD_SEED.PREPARE('FND_HELP_DOCUMENTS');
637:
638: update fnd_help_documents set
639: title = x_title,
640: version = x_version

Line 638: update fnd_help_documents set

634: begin
635: -- Bug 13689517 Adding PREPARE calls for Online patching for seed tables.
636: AD_ZD_SEED.PREPARE('FND_HELP_DOCUMENTS');
637:
638: update fnd_help_documents set
639: title = x_title,
640: version = x_version
641: where file_id = num_file_id;
642:

Line 644: insert into fnd_help_documents (

640: version = x_version
641: where file_id = num_file_id;
642:
643: if SQL%NOTFOUND then
644: insert into fnd_help_documents (
645: file_id,
646: language,
647: application,
648: file_name,

Line 681: AD_ZD_SEED.PREPARE('FND_HELP_TARGETS');

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:

Line 683: insert into fnd_help_targets (file_id, target_name)

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

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

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

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

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.

Line 719: select file_id from fnd_help_documents

715: is
716: num_file_id number := to_number(x_file_id);
717: num_custom_level number := to_number(x_custom_level);
718: cursor fileid_cursor is
719: select file_id from fnd_help_documents
720: where upper(language) = upper(x_language)
721: and upper(application) = upper(x_application)
722: and upper(file_name) = upper(x_file_name)
723: and custom_level = num_custom_level

Line 728: AD_ZD_SEED.PREPARE('FND_HELP_TARGETS');

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;

Line 729: AD_ZD_SEED.PREPARE('FND_HELP_DOCUMENTS');

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;
733: delete from fnd_lobs where file_id = f.file_id;

Line 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: -----------------------------------------------

Line 734: delete from fnd_help_documents where file_id = f.file_id;

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 --
738: -----------------------------------------------

Line 739: delete from fnd_help_targets where file_id = x_file_id;

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

Line 760: from fnd_help_documents fhd

756: is
757: num_custom_level number := to_number(x_custom_level);
758: cursor fileid_cursor is
759: select fhd.file_id
760: from fnd_help_documents fhd
761: where upper(fhd.application) = upper(x_application)
762: and upper(fhd.file_name) = upper(x_file_name)
763: and upper(fhd.language) = upper(nvl(x_language, fhd.language))
764: and fhd.custom_level = nvl(num_custom_level,

Line 771: delete from fnd_help_targets fht

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

Line 775: delete from fnd_help_documents fhd

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
776: where fhd.file_id = f.file_id;
777:
778: -- Lobs table...
779: delete from fnd_lobs

Line 786: end fnd_help;

782: end loop;
783:
784: end delete_doc;
785:
786: end fnd_help;