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.ORACLEON dependencies on ICX_ON_UTILITIES

Line 32: l_attributes icx_on_utilities.v80_table;

28: p_end_row in varchar2,
29: p_where in varchar2,
30: p_hidden in varchar2) is
31:
32: l_attributes icx_on_utilities.v80_table;
33: l_conditions icx_on_utilities.v80_table;
34: l_inputs icx_on_utilities.v80_table;
35:
36: l_message varchar2(2000);

Line 33: l_conditions icx_on_utilities.v80_table;

29: p_where in varchar2,
30: p_hidden in varchar2) is
31:
32: l_attributes icx_on_utilities.v80_table;
33: l_conditions icx_on_utilities.v80_table;
34: l_inputs icx_on_utilities.v80_table;
35:
36: l_message varchar2(2000);
37: l_err_mesg varchar2(240);

Line 34: l_inputs icx_on_utilities.v80_table;

30: p_hidden in varchar2) is
31:
32: l_attributes icx_on_utilities.v80_table;
33: l_conditions icx_on_utilities.v80_table;
34: l_inputs icx_on_utilities.v80_table;
35:
36: l_message varchar2(2000);
37: l_err_mesg varchar2(240);
38: l_err_num number;

Line 51: icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_hidden),icx_on_utilities.g_on_parameters);

47: -- dbms_session.set_sql_trace(TRUE);
48:
49: if Y is null
50: then
51: icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_hidden),icx_on_utilities.g_on_parameters);
52: icx_on_utilities.g_on_parameters(6) := p_start_row;
53: icx_on_utilities.g_on_parameters(7) := p_end_row;
54: icx_on_utilities.g_on_parameters(9) := p_where;
55: else

Line 52: icx_on_utilities.g_on_parameters(6) := p_start_row;

48:
49: if Y is null
50: then
51: icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_hidden),icx_on_utilities.g_on_parameters);
52: icx_on_utilities.g_on_parameters(6) := p_start_row;
53: icx_on_utilities.g_on_parameters(7) := p_end_row;
54: icx_on_utilities.g_on_parameters(9) := p_where;
55: else
56: icx_on_utilities.unpack_parameters(icx_call.decrypt2(Y),icx_on_utilities.g_on_parameters);

Line 53: icx_on_utilities.g_on_parameters(7) := p_end_row;

49: if Y is null
50: then
51: icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_hidden),icx_on_utilities.g_on_parameters);
52: icx_on_utilities.g_on_parameters(6) := p_start_row;
53: icx_on_utilities.g_on_parameters(7) := p_end_row;
54: icx_on_utilities.g_on_parameters(9) := p_where;
55: else
56: icx_on_utilities.unpack_parameters(icx_call.decrypt2(Y),icx_on_utilities.g_on_parameters);
57: end if;

Line 54: icx_on_utilities.g_on_parameters(9) := p_where;

50: then
51: icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_hidden),icx_on_utilities.g_on_parameters);
52: icx_on_utilities.g_on_parameters(6) := p_start_row;
53: icx_on_utilities.g_on_parameters(7) := p_end_row;
54: icx_on_utilities.g_on_parameters(9) := p_where;
55: else
56: icx_on_utilities.unpack_parameters(icx_call.decrypt2(Y),icx_on_utilities.g_on_parameters);
57: end if;
58:

Line 56: icx_on_utilities.unpack_parameters(icx_call.decrypt2(Y),icx_on_utilities.g_on_parameters);

52: icx_on_utilities.g_on_parameters(6) := p_start_row;
53: icx_on_utilities.g_on_parameters(7) := p_end_row;
54: icx_on_utilities.g_on_parameters(9) := p_where;
55: else
56: icx_on_utilities.unpack_parameters(icx_call.decrypt2(Y),icx_on_utilities.g_on_parameters);
57: end if;
58:
59: for i in icx_on_utilities.g_on_parameters.count..22 loop
60: icx_on_utilities.g_on_parameters(i) := '';

Line 59: for i in icx_on_utilities.g_on_parameters.count..22 loop

55: else
56: icx_on_utilities.unpack_parameters(icx_call.decrypt2(Y),icx_on_utilities.g_on_parameters);
57: end if;
58:
59: for i in icx_on_utilities.g_on_parameters.count..22 loop
60: icx_on_utilities.g_on_parameters(i) := '';
61: end loop;
62:
63: if icx_on_utilities.g_on_parameters(22) is null

Line 60: icx_on_utilities.g_on_parameters(i) := '';

56: icx_on_utilities.unpack_parameters(icx_call.decrypt2(Y),icx_on_utilities.g_on_parameters);
57: end if;
58:
59: for i in icx_on_utilities.g_on_parameters.count..22 loop
60: icx_on_utilities.g_on_parameters(i) := '';
61: end loop;
62:
63: if icx_on_utilities.g_on_parameters(22) is null
64: then

Line 63: if icx_on_utilities.g_on_parameters(22) is null

59: for i in icx_on_utilities.g_on_parameters.count..22 loop
60: icx_on_utilities.g_on_parameters(i) := '';
61: end loop;
62:
63: if icx_on_utilities.g_on_parameters(22) is null
64: then
65: -- Set display HTML headers and footers
66: icx_on_utilities.g_on_parameters(22) := 'Y';
67: end if;

Line 66: icx_on_utilities.g_on_parameters(22) := 'Y';

62:
63: if icx_on_utilities.g_on_parameters(22) is null
64: then
65: -- Set display HTML headers and footers
66: icx_on_utilities.g_on_parameters(22) := 'Y';
67: end if;
68:
69: /*
70: for i in 1..22 loop

Line 71: htp.p(i||' = '||nvl(icx_on_utilities.g_on_parameters(i),'NULL'));htp.nl;

67: end if;
68:
69: /*
70: for i in 1..22 loop
71: htp.p(i||' = '||nvl(icx_on_utilities.g_on_parameters(i),'NULL'));htp.nl;
72: end loop;
73: */
74:
75: if icx_sec.validateSession

Line 133: icx_on_utilities.unpack_parameters(icx_call.decrypt2(X),icx_on_utilities.g_on_parameters);

129:
130: if icx_sec.validateSession
131: then
132:
133: icx_on_utilities.unpack_parameters(icx_call.decrypt2(X),icx_on_utilities.g_on_parameters);
134:
135: icx_on_utilities.FindPage(icx_on_utilities.g_on_parameters(13),icx_on_utilities.g_on_parameters(14),icx_on_utilities.g_on_parameters(15),icx_on_utilities.g_on_parameters(16),
136: icx_on_utilities.g_on_parameters(1),icx_on_utilities.g_on_parameters(2),icx_on_utilities.g_on_parameters(3),icx_on_utilities.g_on_parameters(4),icx_on_utilities.g_on_parameters(5),
137: icx_on_utilities.g_on_parameters(6),icx_on_utilities.g_on_parameters(7),icx_on_utilities.g_on_parameters(8),icx_on_utilities.g_on_parameters(9),icx_on_utilities.g_on_parameters(10));

Line 135: icx_on_utilities.FindPage(icx_on_utilities.g_on_parameters(13),icx_on_utilities.g_on_parameters(14),icx_on_utilities.g_on_parameters(15),icx_on_utilities.g_on_parameters(16),

131: then
132:
133: icx_on_utilities.unpack_parameters(icx_call.decrypt2(X),icx_on_utilities.g_on_parameters);
134:
135: icx_on_utilities.FindPage(icx_on_utilities.g_on_parameters(13),icx_on_utilities.g_on_parameters(14),icx_on_utilities.g_on_parameters(15),icx_on_utilities.g_on_parameters(16),
136: icx_on_utilities.g_on_parameters(1),icx_on_utilities.g_on_parameters(2),icx_on_utilities.g_on_parameters(3),icx_on_utilities.g_on_parameters(4),icx_on_utilities.g_on_parameters(5),
137: icx_on_utilities.g_on_parameters(6),icx_on_utilities.g_on_parameters(7),icx_on_utilities.g_on_parameters(8),icx_on_utilities.g_on_parameters(9),icx_on_utilities.g_on_parameters(10));
138:
139: end if;

Line 136: icx_on_utilities.g_on_parameters(1),icx_on_utilities.g_on_parameters(2),icx_on_utilities.g_on_parameters(3),icx_on_utilities.g_on_parameters(4),icx_on_utilities.g_on_parameters(5),

132:
133: icx_on_utilities.unpack_parameters(icx_call.decrypt2(X),icx_on_utilities.g_on_parameters);
134:
135: icx_on_utilities.FindPage(icx_on_utilities.g_on_parameters(13),icx_on_utilities.g_on_parameters(14),icx_on_utilities.g_on_parameters(15),icx_on_utilities.g_on_parameters(16),
136: icx_on_utilities.g_on_parameters(1),icx_on_utilities.g_on_parameters(2),icx_on_utilities.g_on_parameters(3),icx_on_utilities.g_on_parameters(4),icx_on_utilities.g_on_parameters(5),
137: icx_on_utilities.g_on_parameters(6),icx_on_utilities.g_on_parameters(7),icx_on_utilities.g_on_parameters(8),icx_on_utilities.g_on_parameters(9),icx_on_utilities.g_on_parameters(10));
138:
139: end if;
140:

Line 137: icx_on_utilities.g_on_parameters(6),icx_on_utilities.g_on_parameters(7),icx_on_utilities.g_on_parameters(8),icx_on_utilities.g_on_parameters(9),icx_on_utilities.g_on_parameters(10));

133: icx_on_utilities.unpack_parameters(icx_call.decrypt2(X),icx_on_utilities.g_on_parameters);
134:
135: icx_on_utilities.FindPage(icx_on_utilities.g_on_parameters(13),icx_on_utilities.g_on_parameters(14),icx_on_utilities.g_on_parameters(15),icx_on_utilities.g_on_parameters(16),
136: icx_on_utilities.g_on_parameters(1),icx_on_utilities.g_on_parameters(2),icx_on_utilities.g_on_parameters(3),icx_on_utilities.g_on_parameters(4),icx_on_utilities.g_on_parameters(5),
137: icx_on_utilities.g_on_parameters(6),icx_on_utilities.g_on_parameters(7),icx_on_utilities.g_on_parameters(8),icx_on_utilities.g_on_parameters(9),icx_on_utilities.g_on_parameters(10));
138:
139: end if;
140:
141: exception

Line 161: icx_on_utilities.unpack_parameters(icx_call.decrypt2(X),icx_on_utilities

157:
158: if icx_sec.validateSession
159: then
160:
161: icx_on_utilities.unpack_parameters(icx_call.decrypt2(X),icx_on_utilities
162: .g_on_parameters);
163:
164: icx_on_cabo.FindForm(
165: p_flow_appl_id => icx_on_utilities.g_on_parameters(1),

Line 165: p_flow_appl_id => icx_on_utilities.g_on_parameters(1),

161: icx_on_utilities.unpack_parameters(icx_call.decrypt2(X),icx_on_utilities
162: .g_on_parameters);
163:
164: icx_on_cabo.FindForm(
165: p_flow_appl_id => icx_on_utilities.g_on_parameters(1),
166: p_flow_code => icx_on_utilities.g_on_parameters(2),
167: p_page_appl_id => icx_on_utilities.g_on_parameters(3),
168: p_page_code => icx_on_utilities.g_on_parameters(4),
169: p_region_appl_id => icx_on_utilities.g_on_parameters(5),

Line 166: p_flow_code => icx_on_utilities.g_on_parameters(2),

162: .g_on_parameters);
163:
164: icx_on_cabo.FindForm(
165: p_flow_appl_id => icx_on_utilities.g_on_parameters(1),
166: p_flow_code => icx_on_utilities.g_on_parameters(2),
167: p_page_appl_id => icx_on_utilities.g_on_parameters(3),
168: p_page_code => icx_on_utilities.g_on_parameters(4),
169: p_region_appl_id => icx_on_utilities.g_on_parameters(5),
170: p_region_code => icx_on_utilities.g_on_parameters(6),

Line 167: p_page_appl_id => icx_on_utilities.g_on_parameters(3),

163:
164: icx_on_cabo.FindForm(
165: p_flow_appl_id => icx_on_utilities.g_on_parameters(1),
166: p_flow_code => icx_on_utilities.g_on_parameters(2),
167: p_page_appl_id => icx_on_utilities.g_on_parameters(3),
168: p_page_code => icx_on_utilities.g_on_parameters(4),
169: p_region_appl_id => icx_on_utilities.g_on_parameters(5),
170: p_region_code => icx_on_utilities.g_on_parameters(6),
171: p_lines_now => icx_on_utilities.g_on_parameters(7),

Line 168: p_page_code => icx_on_utilities.g_on_parameters(4),

164: icx_on_cabo.FindForm(
165: p_flow_appl_id => icx_on_utilities.g_on_parameters(1),
166: p_flow_code => icx_on_utilities.g_on_parameters(2),
167: p_page_appl_id => icx_on_utilities.g_on_parameters(3),
168: p_page_code => icx_on_utilities.g_on_parameters(4),
169: p_region_appl_id => icx_on_utilities.g_on_parameters(5),
170: p_region_code => icx_on_utilities.g_on_parameters(6),
171: p_lines_now => icx_on_utilities.g_on_parameters(7),
172: p_lines_next => icx_on_utilities.g_on_parameters(8),

Line 169: p_region_appl_id => icx_on_utilities.g_on_parameters(5),

165: p_flow_appl_id => icx_on_utilities.g_on_parameters(1),
166: p_flow_code => icx_on_utilities.g_on_parameters(2),
167: p_page_appl_id => icx_on_utilities.g_on_parameters(3),
168: p_page_code => icx_on_utilities.g_on_parameters(4),
169: p_region_appl_id => icx_on_utilities.g_on_parameters(5),
170: p_region_code => icx_on_utilities.g_on_parameters(6),
171: p_lines_now => icx_on_utilities.g_on_parameters(7),
172: p_lines_next => icx_on_utilities.g_on_parameters(8),
173: p_hidden_name => icx_on_utilities.g_on_parameters(9),

Line 170: p_region_code => icx_on_utilities.g_on_parameters(6),

166: p_flow_code => icx_on_utilities.g_on_parameters(2),
167: p_page_appl_id => icx_on_utilities.g_on_parameters(3),
168: p_page_code => icx_on_utilities.g_on_parameters(4),
169: p_region_appl_id => icx_on_utilities.g_on_parameters(5),
170: p_region_code => icx_on_utilities.g_on_parameters(6),
171: p_lines_now => icx_on_utilities.g_on_parameters(7),
172: p_lines_next => icx_on_utilities.g_on_parameters(8),
173: p_hidden_name => icx_on_utilities.g_on_parameters(9),
174: p_hidden_value => icx_on_utilities.g_on_parameters(10),

Line 171: p_lines_now => icx_on_utilities.g_on_parameters(7),

167: p_page_appl_id => icx_on_utilities.g_on_parameters(3),
168: p_page_code => icx_on_utilities.g_on_parameters(4),
169: p_region_appl_id => icx_on_utilities.g_on_parameters(5),
170: p_region_code => icx_on_utilities.g_on_parameters(6),
171: p_lines_now => icx_on_utilities.g_on_parameters(7),
172: p_lines_next => icx_on_utilities.g_on_parameters(8),
173: p_hidden_name => icx_on_utilities.g_on_parameters(9),
174: p_hidden_value => icx_on_utilities.g_on_parameters(10),
175: p_help_url => icx_on_utilities.g_on_parameters(11));

Line 172: p_lines_next => icx_on_utilities.g_on_parameters(8),

168: p_page_code => icx_on_utilities.g_on_parameters(4),
169: p_region_appl_id => icx_on_utilities.g_on_parameters(5),
170: p_region_code => icx_on_utilities.g_on_parameters(6),
171: p_lines_now => icx_on_utilities.g_on_parameters(7),
172: p_lines_next => icx_on_utilities.g_on_parameters(8),
173: p_hidden_name => icx_on_utilities.g_on_parameters(9),
174: p_hidden_value => icx_on_utilities.g_on_parameters(10),
175: p_help_url => icx_on_utilities.g_on_parameters(11));
176:

Line 173: p_hidden_name => icx_on_utilities.g_on_parameters(9),

169: p_region_appl_id => icx_on_utilities.g_on_parameters(5),
170: p_region_code => icx_on_utilities.g_on_parameters(6),
171: p_lines_now => icx_on_utilities.g_on_parameters(7),
172: p_lines_next => icx_on_utilities.g_on_parameters(8),
173: p_hidden_name => icx_on_utilities.g_on_parameters(9),
174: p_hidden_value => icx_on_utilities.g_on_parameters(10),
175: p_help_url => icx_on_utilities.g_on_parameters(11));
176:
177: end if;

Line 174: p_hidden_value => icx_on_utilities.g_on_parameters(10),

170: p_region_code => icx_on_utilities.g_on_parameters(6),
171: p_lines_now => icx_on_utilities.g_on_parameters(7),
172: p_lines_next => icx_on_utilities.g_on_parameters(8),
173: p_hidden_name => icx_on_utilities.g_on_parameters(9),
174: p_hidden_value => icx_on_utilities.g_on_parameters(10),
175: p_help_url => icx_on_utilities.g_on_parameters(11));
176:
177: end if;
178:

Line 175: p_help_url => icx_on_utilities.g_on_parameters(11));

171: p_lines_now => icx_on_utilities.g_on_parameters(7),
172: p_lines_next => icx_on_utilities.g_on_parameters(8),
173: p_hidden_name => icx_on_utilities.g_on_parameters(9),
174: p_hidden_value => icx_on_utilities.g_on_parameters(10),
175: p_help_url => icx_on_utilities.g_on_parameters(11));
176:
177: end if;
178:
179: exception

Line 200: icx_on_utilities.unpack_parameters(icx_call.decrypt2(X),icx_on_utilities

196:
197: if icx_sec.validateSession
198: then
199:
200: icx_on_utilities.unpack_parameters(icx_call.decrypt2(X),icx_on_utilities
201: .g_on_parameters);
202:
203: for i in icx_on_utilities.g_on_parameters.count..22 loop
204: icx_on_utilities.g_on_parameters(i) := '';

Line 203: for i in icx_on_utilities.g_on_parameters.count..22 loop

199:
200: icx_on_utilities.unpack_parameters(icx_call.decrypt2(X),icx_on_utilities
201: .g_on_parameters);
202:
203: for i in icx_on_utilities.g_on_parameters.count..22 loop
204: icx_on_utilities.g_on_parameters(i) := '';
205: end loop;
206:
207: -- 2093780 nlbarlow, multiple region first page

Line 204: icx_on_utilities.g_on_parameters(i) := '';

200: icx_on_utilities.unpack_parameters(icx_call.decrypt2(X),icx_on_utilities
201: .g_on_parameters);
202:
203: for i in icx_on_utilities.g_on_parameters.count..22 loop
204: icx_on_utilities.g_on_parameters(i) := '';
205: end loop;
206:
207: -- 2093780 nlbarlow, multiple region first page
208: select count(*)

Line 211: where PAGE_CODE = icx_on_utilities.g_on_parameters(5)

207: -- 2093780 nlbarlow, multiple region first page
208: select count(*)
209: into l_count
210: from AK_FLOW_PAGE_REGIONS
211: where PAGE_CODE = icx_on_utilities.g_on_parameters(5)
212: and PAGE_APPLICATION_ID = icx_on_utilities.g_on_parameters(4)
213: and FLOW_CODE = icx_on_utilities.g_on_parameters(3)
214: and FLOW_APPLICATION_ID = icx_on_utilities.g_on_parameters(2);
215:

Line 212: and PAGE_APPLICATION_ID = icx_on_utilities.g_on_parameters(4)

208: select count(*)
209: into l_count
210: from AK_FLOW_PAGE_REGIONS
211: where PAGE_CODE = icx_on_utilities.g_on_parameters(5)
212: and PAGE_APPLICATION_ID = icx_on_utilities.g_on_parameters(4)
213: and FLOW_CODE = icx_on_utilities.g_on_parameters(3)
214: and FLOW_APPLICATION_ID = icx_on_utilities.g_on_parameters(2);
215:
216: if l_count > 1

Line 213: and FLOW_CODE = icx_on_utilities.g_on_parameters(3)

209: into l_count
210: from AK_FLOW_PAGE_REGIONS
211: where PAGE_CODE = icx_on_utilities.g_on_parameters(5)
212: and PAGE_APPLICATION_ID = icx_on_utilities.g_on_parameters(4)
213: and FLOW_CODE = icx_on_utilities.g_on_parameters(3)
214: and FLOW_APPLICATION_ID = icx_on_utilities.g_on_parameters(2);
215:
216: if l_count > 1
217: then

Line 214: and FLOW_APPLICATION_ID = icx_on_utilities.g_on_parameters(2);

210: from AK_FLOW_PAGE_REGIONS
211: where PAGE_CODE = icx_on_utilities.g_on_parameters(5)
212: and PAGE_APPLICATION_ID = icx_on_utilities.g_on_parameters(4)
213: and FLOW_CODE = icx_on_utilities.g_on_parameters(3)
214: and FLOW_APPLICATION_ID = icx_on_utilities.g_on_parameters(2);
215:
216: if l_count > 1
217: then
218: icx_on_utilities.g_on_parameters(1) := 'W';

Line 218: icx_on_utilities.g_on_parameters(1) := 'W';

214: and FLOW_APPLICATION_ID = icx_on_utilities.g_on_parameters(2);
215:
216: if l_count > 1
217: then
218: icx_on_utilities.g_on_parameters(1) := 'W';
219: else
220: icx_on_utilities.g_on_parameters(1) := 'DQ';
221: end if;
222:

Line 220: icx_on_utilities.g_on_parameters(1) := 'DQ';

216: if l_count > 1
217: then
218: icx_on_utilities.g_on_parameters(1) := 'W';
219: else
220: icx_on_utilities.g_on_parameters(1) := 'DQ';
221: end if;
222:
223: icx_on_utilities.g_on_parameters(21) := 'W';
224:

Line 223: icx_on_utilities.g_on_parameters(21) := 'W';

219: else
220: icx_on_utilities.g_on_parameters(1) := 'DQ';
221: end if;
222:
223: icx_on_utilities.g_on_parameters(21) := 'W';
224:
225: icx_on_utilities.getRegions(icx_call.decrypt2(icx_on_utilities.g_on_parameters(9),icx_sec.g_session_id));
226:
227: icx_on_cabo.displayPage;

Line 225: icx_on_utilities.getRegions(icx_call.decrypt2(icx_on_utilities.g_on_parameters(9),icx_sec.g_session_id));

221: end if;
222:
223: icx_on_utilities.g_on_parameters(21) := 'W';
224:
225: icx_on_utilities.getRegions(icx_call.decrypt2(icx_on_utilities.g_on_parameters(9),icx_sec.g_session_id));
226:
227: icx_on_cabo.displayPage;
228:
229: end if;

Line 247: l_parameters icx_on_utilities.v240_table;

243: c_flow_appl_id number;
244: c_flow_code varchar2(30);
245: c_page_appl_id number;
246: c_page_code varchar2(30);
247: l_parameters icx_on_utilities.v240_table;
248: c_level number;
249: c_displayed display;
250: l_message varchar2(2000);
251: l_language_code varchar2(30);

Line 257: icx_on_utilities.unpack_parameters(icx_call.decrypt2(X),l_parameters);

253: begin
254:
255: if icx_sec.validateSession
256: then
257: icx_on_utilities.unpack_parameters(icx_call.decrypt2(X),l_parameters);
258:
259: l_language_code := icx_sec.getID(icx_sec.pv_language_code);
260:
261: c_flow_appl_id := l_parameters(1);