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.3 2006/05/27 12:20:05 skghosh 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 523: ' fnd_help_documents hd '||

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

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

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

Line 533: ' from fnd_help_documents hd2 '||

529: ' and hd.file_name <> ''ATGRP.GIF'' '||
530: ' and hd.title is not null '||
531: ' and hd.custom_level = '||
532: ' (select /*+no_unnest*/ max(hd2.custom_level) '||
533: ' from fnd_help_documents hd2 '||
534: ' where hd2.file_name = hd.file_name '||
535: ' and hd2.language = hd.language '||
536: ' and hd2.application = hd.application) ';
537:

Line 623: update fnd_help_documents set

619: x_version in varchar2 ) is
620: num_file_id number := to_number(x_file_id);
621: num_custom_level number := to_number(x_custom_level);
622: begin
623: update fnd_help_documents set
624: title = x_title,
625: version = x_version
626: where file_id = num_file_id;
627:

Line 629: insert into fnd_help_documents (

625: version = x_version
626: where file_id = num_file_id;
627:
628: if SQL%NOTFOUND then
629: insert into fnd_help_documents (
630: file_id,
631: language,
632: application,
633: file_name,

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 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 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 700: select file_id from fnd_help_documents

696: is
697: num_file_id number := to_number(x_file_id);
698: num_custom_level number := to_number(x_custom_level);
699: cursor fileid_cursor is
700: select file_id from fnd_help_documents
701: where upper(language) = upper(x_language)
702: and upper(application) = upper(x_application)
703: and upper(file_name) = upper(x_file_name)
704: and custom_level = num_custom_level

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 710: delete from fnd_help_documents where file_id = f.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 --
714: -----------------------------------------------

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 736: from fnd_help_documents fhd

732: is
733: num_custom_level number := to_number(x_custom_level);
734: cursor fileid_cursor is
735: select fhd.file_id
736: from fnd_help_documents fhd
737: where upper(fhd.application) = upper(x_application)
738: and upper(fhd.file_name) = upper(x_file_name)
739: and upper(fhd.language) = upper(nvl(x_language, fhd.language))
740: and fhd.custom_level = nvl(num_custom_level,

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

Line 750: delete from fnd_help_documents fhd

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
751: where fhd.file_id = f.file_id;
752:
753: -- Lobs table...
754: delete from fnd_lobs

Line 761: end fnd_help;

757: end loop;
758:
759: end delete_doc;
760:
761: end fnd_help;