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_WEB dependencies on HTP

Line 15: htp.htmlOpen;

11: is
12: val varchar2(2000);
13: begin
14: -- Set page title
15: htp.htmlOpen;
16: htp.headOpen;
17: htp.title('FND_WEB.PING');
18: htp.headClose;
19:

Line 16: htp.headOpen;

12: val varchar2(2000);
13: begin
14: -- Set page title
15: htp.htmlOpen;
16: htp.headOpen;
17: htp.title('FND_WEB.PING');
18: htp.headClose;
19:
20: htp.bodyOpen;

Line 17: htp.title('FND_WEB.PING');

13: begin
14: -- Set page title
15: htp.htmlOpen;
16: htp.headOpen;
17: htp.title('FND_WEB.PING');
18: htp.headClose;
19:
20: htp.bodyOpen;
21: htp.p('FND_WEB.PING');

Line 18: htp.headClose;

14: -- Set page title
15: htp.htmlOpen;
16: htp.headOpen;
17: htp.title('FND_WEB.PING');
18: htp.headClose;
19:
20: htp.bodyOpen;
21: htp.p('FND_WEB.PING');
22: htp.tableOpen('border=1 cellpadding=3');

Line 20: htp.bodyOpen;

16: htp.headOpen;
17: htp.title('FND_WEB.PING');
18: htp.headClose;
19:
20: htp.bodyOpen;
21: htp.p('FND_WEB.PING');
22: htp.tableOpen('border=1 cellpadding=3');
23:
24: select to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') into val from dual;

Line 21: htp.p('FND_WEB.PING');

17: htp.title('FND_WEB.PING');
18: htp.headClose;
19:
20: htp.bodyOpen;
21: htp.p('FND_WEB.PING');
22: htp.tableOpen('border=1 cellpadding=3');
23:
24: select to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') into val from dual;
25: htp.tableRowOpen;

Line 22: htp.tableOpen('border=1 cellpadding=3');

18: htp.headClose;
19:
20: htp.bodyOpen;
21: htp.p('FND_WEB.PING');
22: htp.tableOpen('border=1 cellpadding=3');
23:
24: select to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') into val from dual;
25: htp.tableRowOpen;
26: htp.tableData('SYSDATE', 'Left');

Line 25: htp.tableRowOpen;

21: htp.p('FND_WEB.PING');
22: htp.tableOpen('border=1 cellpadding=3');
23:
24: select to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') into val from dual;
25: htp.tableRowOpen;
26: htp.tableData('SYSDATE', 'Left');
27: htp.tableData(val, 'Left');
28: htp.tableRowClose;
29:

Line 26: htp.tableData('SYSDATE', 'Left');

22: htp.tableOpen('border=1 cellpadding=3');
23:
24: select to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') into val from dual;
25: htp.tableRowOpen;
26: htp.tableData('SYSDATE', 'Left');
27: htp.tableData(val, 'Left');
28: htp.tableRowClose;
29:
30: select banner into val from v$version where rownum=1;

Line 27: htp.tableData(val, 'Left');

23:
24: select to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') into val from dual;
25: htp.tableRowOpen;
26: htp.tableData('SYSDATE', 'Left');
27: htp.tableData(val, 'Left');
28: htp.tableRowClose;
29:
30: select banner into val from v$version where rownum=1;
31: htp.tableRowOpen;

Line 28: htp.tableRowClose;

24: select to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') into val from dual;
25: htp.tableRowOpen;
26: htp.tableData('SYSDATE', 'Left');
27: htp.tableData(val, 'Left');
28: htp.tableRowClose;
29:
30: select banner into val from v$version where rownum=1;
31: htp.tableRowOpen;
32: htp.tableData('DATABASE_VERSION', 'Left');

Line 31: htp.tableRowOpen;

27: htp.tableData(val, 'Left');
28: htp.tableRowClose;
29:
30: select banner into val from v$version where rownum=1;
31: htp.tableRowOpen;
32: htp.tableData('DATABASE_VERSION', 'Left');
33: htp.tableData(val, 'Left');
34: htp.tableRowClose;
35:

Line 32: htp.tableData('DATABASE_VERSION', 'Left');

28: htp.tableRowClose;
29:
30: select banner into val from v$version where rownum=1;
31: htp.tableRowOpen;
32: htp.tableData('DATABASE_VERSION', 'Left');
33: htp.tableData(val, 'Left');
34: htp.tableRowClose;
35:
36: --bug#4115696: GJIMENEZ: Use the correct API to determine

Line 33: htp.tableData(val, 'Left');

29:
30: select banner into val from v$version where rownum=1;
31: htp.tableRowOpen;
32: htp.tableData('DATABASE_VERSION', 'Left');
33: htp.tableData(val, 'Left');
34: htp.tableRowClose;
35:
36: --bug#4115696: GJIMENEZ: Use the correct API to determine
37: --the database ID instead of the

Line 34: htp.tableRowClose;

30: select banner into val from v$version where rownum=1;
31: htp.tableRowOpen;
32: htp.tableData('DATABASE_VERSION', 'Left');
33: htp.tableData(val, 'Left');
34: htp.tableRowClose;
35:
36: --bug#4115696: GJIMENEZ: Use the correct API to determine
37: --the database ID instead of the
38: --below select statement:

Line 44: htp.tableRowOpen;

40: --into val
41: --from v$instance;
42: val := fnd_web_config.database_id;
43:
44: htp.tableRowOpen;
45: htp.tableData('DATABASE_ID', 'Left');
46: htp.tableData(val, 'Left');
47: htp.tableRowClose;
48:

Line 45: htp.tableData('DATABASE_ID', 'Left');

41: --from v$instance;
42: val := fnd_web_config.database_id;
43:
44: htp.tableRowOpen;
45: htp.tableData('DATABASE_ID', 'Left');
46: htp.tableData(val, 'Left');
47: htp.tableRowClose;
48:
49: select user into val from dual;

Line 46: htp.tableData(val, 'Left');

42: val := fnd_web_config.database_id;
43:
44: htp.tableRowOpen;
45: htp.tableData('DATABASE_ID', 'Left');
46: htp.tableData(val, 'Left');
47: htp.tableRowClose;
48:
49: select user into val from dual;
50: htp.tableRowOpen;

Line 47: htp.tableRowClose;

43:
44: htp.tableRowOpen;
45: htp.tableData('DATABASE_ID', 'Left');
46: htp.tableData(val, 'Left');
47: htp.tableRowClose;
48:
49: select user into val from dual;
50: htp.tableRowOpen;
51: htp.tableData('SCHEMA_NAME', 'Left');

Line 50: htp.tableRowOpen;

46: htp.tableData(val, 'Left');
47: htp.tableRowClose;
48:
49: select user into val from dual;
50: htp.tableRowOpen;
51: htp.tableData('SCHEMA_NAME', 'Left');
52: htp.tableData(val, 'Left');
53: htp.tableRowClose;
54:

Line 51: htp.tableData('SCHEMA_NAME', 'Left');

47: htp.tableRowClose;
48:
49: select user into val from dual;
50: htp.tableRowOpen;
51: htp.tableData('SCHEMA_NAME', 'Left');
52: htp.tableData(val, 'Left');
53: htp.tableRowClose;
54:
55: select product_version into val

Line 52: htp.tableData(val, 'Left');

48:
49: select user into val from dual;
50: htp.tableRowOpen;
51: htp.tableData('SCHEMA_NAME', 'Left');
52: htp.tableData(val, 'Left');
53: htp.tableRowClose;
54:
55: select product_version into val
56: from fnd_product_installations

Line 53: htp.tableRowClose;

49: select user into val from dual;
50: htp.tableRowOpen;
51: htp.tableData('SCHEMA_NAME', 'Left');
52: htp.tableData(val, 'Left');
53: htp.tableRowClose;
54:
55: select product_version into val
56: from fnd_product_installations
57: where application_id=0;

Line 58: htp.tableRowOpen;

54:
55: select product_version into val
56: from fnd_product_installations
57: where application_id=0;
58: htp.tableRowOpen;
59: htp.tableData('AOL_VERSION', 'Left');
60: htp.tableData(val, 'Left');
61: htp.tableRowClose;
62:

Line 59: htp.tableData('AOL_VERSION', 'Left');

55: select product_version into val
56: from fnd_product_installations
57: where application_id=0;
58: htp.tableRowOpen;
59: htp.tableData('AOL_VERSION', 'Left');
60: htp.tableData(val, 'Left');
61: htp.tableRowClose;
62:
63: begin

Line 60: htp.tableData(val, 'Left');

56: from fnd_product_installations
57: where application_id=0;
58: htp.tableRowOpen;
59: htp.tableData('AOL_VERSION', 'Left');
60: htp.tableData(val, 'Left');
61: htp.tableRowClose;
62:
63: begin
64: select pov.profile_option_value

Line 61: htp.tableRowClose;

57: where application_id=0;
58: htp.tableRowOpen;
59: htp.tableData('AOL_VERSION', 'Left');
60: htp.tableData(val, 'Left');
61: htp.tableRowClose;
62:
63: begin
64: select pov.profile_option_value
65: into val

Line 72: htp.tableRowOpen;

68: where po.profile_option_name = 'APPS_WEB_AGENT'
69: and pov.application_id = po.application_id
70: and pov.profile_option_id = po.profile_option_id
71: and pov.level_id = 10001;
72: htp.tableRowOpen;
73: htp.tableData('APPS_WEB_AGENT', 'Left');
74: htp.tableData(val, 'Left');
75: htp.tableRowClose;
76: exception

Line 73: htp.tableData('APPS_WEB_AGENT', 'Left');

69: and pov.application_id = po.application_id
70: and pov.profile_option_id = po.profile_option_id
71: and pov.level_id = 10001;
72: htp.tableRowOpen;
73: htp.tableData('APPS_WEB_AGENT', 'Left');
74: htp.tableData(val, 'Left');
75: htp.tableRowClose;
76: exception
77: when others then null;

Line 74: htp.tableData(val, 'Left');

70: and pov.profile_option_id = po.profile_option_id
71: and pov.level_id = 10001;
72: htp.tableRowOpen;
73: htp.tableData('APPS_WEB_AGENT', 'Left');
74: htp.tableData(val, 'Left');
75: htp.tableRowClose;
76: exception
77: when others then null;
78: end;

Line 75: htp.tableRowClose;

71: and pov.level_id = 10001;
72: htp.tableRowOpen;
73: htp.tableData('APPS_WEB_AGENT', 'Left');
74: htp.tableData(val, 'Left');
75: htp.tableRowClose;
76: exception
77: when others then null;
78: end;
79:

Line 80: htp.tableClose;

76: exception
77: when others then null;
78: end;
79:
80: htp.tableClose;
81: htp.bodyClose;
82: htp.htmlClose;
83:
84: exception

Line 81: htp.bodyClose;

77: when others then null;
78: end;
79:
80: htp.tableClose;
81: htp.bodyClose;
82: htp.htmlClose;
83:
84: exception
85: when others then

Line 82: htp.htmlClose;

78: end;
79:
80: htp.tableClose;
81: htp.bodyClose;
82: htp.htmlClose;
83:
84: exception
85: when others then
86: htp.p('ERROR');

Line 86: htp.p('ERROR');

82: htp.htmlClose;
83:
84: exception
85: when others then
86: htp.p('ERROR');
87: htp.bodyClose;
88: htp.htmlClose;
89: end PING;
90:

Line 87: htp.bodyClose;

83:
84: exception
85: when others then
86: htp.p('ERROR');
87: htp.bodyClose;
88: htp.htmlClose;
89: end PING;
90:
91: /*

Line 88: htp.htmlClose;

84: exception
85: when others then
86: htp.p('ERROR');
87: htp.bodyClose;
88: htp.htmlClose;
89: end PING;
90:
91: /*
92: ** VERSION

Line 111: htp.htmlOpen;

107: order by 1, 2;
108:
109: begin
110: -- Set page title
111: htp.htmlOpen;
112: htp.headOpen;
113: htp.title('FND_WEB.VERSION');
114: htp.headClose;
115:

Line 112: htp.headOpen;

108:
109: begin
110: -- Set page title
111: htp.htmlOpen;
112: htp.headOpen;
113: htp.title('FND_WEB.VERSION');
114: htp.headClose;
115:
116: htp.bodyOpen;

Line 113: htp.title('FND_WEB.VERSION');

109: begin
110: -- Set page title
111: htp.htmlOpen;
112: htp.headOpen;
113: htp.title('FND_WEB.VERSION');
114: htp.headClose;
115:
116: htp.bodyOpen;
117: htp.p('FND_WEB.VERSION');

Line 114: htp.headClose;

110: -- Set page title
111: htp.htmlOpen;
112: htp.headOpen;
113: htp.title('FND_WEB.VERSION');
114: htp.headClose;
115:
116: htp.bodyOpen;
117: htp.p('FND_WEB.VERSION');
118:

Line 116: htp.bodyOpen;

112: htp.headOpen;
113: htp.title('FND_WEB.VERSION');
114: htp.headClose;
115:
116: htp.bodyOpen;
117: htp.p('FND_WEB.VERSION');
118:
119: htp.tableOpen('border=1 cellpadding=3');
120:

Line 117: htp.p('FND_WEB.VERSION');

113: htp.title('FND_WEB.VERSION');
114: htp.headClose;
115:
116: htp.bodyOpen;
117: htp.p('FND_WEB.VERSION');
118:
119: htp.tableOpen('border=1 cellpadding=3');
120:
121: for header_row in header_cursor(upper(filter)||'%') loop

Line 119: htp.tableOpen('border=1 cellpadding=3');

115:
116: htp.bodyOpen;
117: htp.p('FND_WEB.VERSION');
118:
119: htp.tableOpen('border=1 cellpadding=3');
120:
121: for header_row in header_cursor(upper(filter)||'%') loop
122: htp.tableRowOpen;
123: htp.tableData(header_row.name, 'Left');

Line 122: htp.tableRowOpen;

118:
119: htp.tableOpen('border=1 cellpadding=3');
120:
121: for header_row in header_cursor(upper(filter)||'%') loop
122: htp.tableRowOpen;
123: htp.tableData(header_row.name, 'Left');
124: htp.tableData(header_row.type, 'Left');
125: htp.tableData(header_row.version, 'Left');
126: htp.tableRowClose;

Line 123: htp.tableData(header_row.name, 'Left');

119: htp.tableOpen('border=1 cellpadding=3');
120:
121: for header_row in header_cursor(upper(filter)||'%') loop
122: htp.tableRowOpen;
123: htp.tableData(header_row.name, 'Left');
124: htp.tableData(header_row.type, 'Left');
125: htp.tableData(header_row.version, 'Left');
126: htp.tableRowClose;
127: end loop;

Line 124: htp.tableData(header_row.type, 'Left');

120:
121: for header_row in header_cursor(upper(filter)||'%') loop
122: htp.tableRowOpen;
123: htp.tableData(header_row.name, 'Left');
124: htp.tableData(header_row.type, 'Left');
125: htp.tableData(header_row.version, 'Left');
126: htp.tableRowClose;
127: end loop;
128:

Line 125: htp.tableData(header_row.version, 'Left');

121: for header_row in header_cursor(upper(filter)||'%') loop
122: htp.tableRowOpen;
123: htp.tableData(header_row.name, 'Left');
124: htp.tableData(header_row.type, 'Left');
125: htp.tableData(header_row.version, 'Left');
126: htp.tableRowClose;
127: end loop;
128:
129: htp.tableClose;

Line 126: htp.tableRowClose;

122: htp.tableRowOpen;
123: htp.tableData(header_row.name, 'Left');
124: htp.tableData(header_row.type, 'Left');
125: htp.tableData(header_row.version, 'Left');
126: htp.tableRowClose;
127: end loop;
128:
129: htp.tableClose;
130: htp.bodyClose;

Line 129: htp.tableClose;

125: htp.tableData(header_row.version, 'Left');
126: htp.tableRowClose;
127: end loop;
128:
129: htp.tableClose;
130: htp.bodyClose;
131: htp.htmlClose;
132:
133: exception

Line 130: htp.bodyClose;

126: htp.tableRowClose;
127: end loop;
128:
129: htp.tableClose;
130: htp.bodyClose;
131: htp.htmlClose;
132:
133: exception
134: when others then

Line 131: htp.htmlClose;

127: end loop;
128:
129: htp.tableClose;
130: htp.bodyClose;
131: htp.htmlClose;
132:
133: exception
134: when others then
135: htp.p('ERROR');

Line 135: htp.p('ERROR');

131: htp.htmlClose;
132:
133: exception
134: when others then
135: htp.p('ERROR');
136: htp.bodyClose;
137: htp.htmlClose;
138: end VERSION;
139:

Line 136: htp.bodyClose;

132:
133: exception
134: when others then
135: htp.p('ERROR');
136: htp.bodyClose;
137: htp.htmlClose;
138: end VERSION;
139:
140: /*

Line 137: htp.htmlClose;

133: exception
134: when others then
135: htp.p('ERROR');
136: htp.bodyClose;
137: htp.htmlClose;
138: end VERSION;
139:
140: /*
141: ** SHOWENV

Line 147: htp.htmlOpen;

143: procedure SHOWENV
144: is
145: begin
146: -- Set page title
147: htp.htmlOpen;
148: htp.headOpen;
149: htp.title('FND_WEB.SHOWENV');
150: htp.headClose;
151:

Line 148: htp.headOpen;

144: is
145: begin
146: -- Set page title
147: htp.htmlOpen;
148: htp.headOpen;
149: htp.title('FND_WEB.SHOWENV');
150: htp.headClose;
151:
152: htp.bodyOpen;

Line 149: htp.title('FND_WEB.SHOWENV');

145: begin
146: -- Set page title
147: htp.htmlOpen;
148: htp.headOpen;
149: htp.title('FND_WEB.SHOWENV');
150: htp.headClose;
151:
152: htp.bodyOpen;
153: htp.p('FND_WEB.SHOWENV');

Line 150: htp.headClose;

146: -- Set page title
147: htp.htmlOpen;
148: htp.headOpen;
149: htp.title('FND_WEB.SHOWENV');
150: htp.headClose;
151:
152: htp.bodyOpen;
153: htp.p('FND_WEB.SHOWENV');
154: htp.hr;

Line 152: htp.bodyOpen;

148: htp.headOpen;
149: htp.title('FND_WEB.SHOWENV');
150: htp.headClose;
151:
152: htp.bodyOpen;
153: htp.p('FND_WEB.SHOWENV');
154: htp.hr;
155:
156: owa_util.print_cgi_env;

Line 153: htp.p('FND_WEB.SHOWENV');

149: htp.title('FND_WEB.SHOWENV');
150: htp.headClose;
151:
152: htp.bodyOpen;
153: htp.p('FND_WEB.SHOWENV');
154: htp.hr;
155:
156: owa_util.print_cgi_env;
157:

Line 154: htp.hr;

150: htp.headClose;
151:
152: htp.bodyOpen;
153: htp.p('FND_WEB.SHOWENV');
154: htp.hr;
155:
156: owa_util.print_cgi_env;
157:
158: htp.bodyClose;

Line 158: htp.bodyClose;

154: htp.hr;
155:
156: owa_util.print_cgi_env;
157:
158: htp.bodyClose;
159: htp.htmlClose;
160:
161: exception
162: when others then

Line 159: htp.htmlClose;

155:
156: owa_util.print_cgi_env;
157:
158: htp.bodyClose;
159: htp.htmlClose;
160:
161: exception
162: when others then
163: htp.p('ERROR');

Line 163: htp.p('ERROR');

159: htp.htmlClose;
160:
161: exception
162: when others then
163: htp.p('ERROR');
164: htp.bodyClose;
165: htp.htmlClose;
166: end SHOWENV;
167:

Line 164: htp.bodyClose;

160:
161: exception
162: when others then
163: htp.p('ERROR');
164: htp.bodyClose;
165: htp.htmlClose;
166: end SHOWENV;
167:
168: end FND_WEB;

Line 165: htp.htmlClose;

161: exception
162: when others then
163: htp.p('ERROR');
164: htp.bodyClose;
165: htp.htmlClose;
166: end SHOWENV;
167:
168: end FND_WEB;