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.ICX_ADMIN_UTILS dependencies on AK_QUERY_PKG

Line 131: ak_query_pkg.exec_query(

127: else
128: l_end_row := p_end_row;
129: end if;
130:
131: ak_query_pkg.exec_query(
132: p_parent_region_appl_id => l_region_application_id,
133: p_parent_region_code => l_region_code,
134: p_where_clause => l_where_clause,
135: p_responsibility_id => l_resp_id,

Line 148: l_total_rows := ak_query_pkg.g_regions_table(0).total_result_count;

144:
145: /* get number of total rows returned by lov to be used to determine if
146: we need to display the next/previous buttons */
147:
148: l_total_rows := ak_query_pkg.g_regions_table(0).total_result_count;
149:
150: if l_total_rows = 0 then
151:
152: htp.htmlOpen;

Line 158: htp.title(ak_query_pkg.g_regions_table(0).name);

154: icx_util.copyright;
155: js.scriptOpen;
156: icx_admin_sig.help_win_script(l_help_url, l_language_code);
157: js.scriptClose;
158: htp.title(ak_query_pkg.g_regions_table(0).name);
159: htp.headClose;
160:
161: icx_admin_sig.toolbar(language_code => l_language_code,
162: disp_find => l_find_proc);

Line 165: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);

161: icx_admin_sig.toolbar(language_code => l_language_code,
162: disp_find => l_find_proc);
163:
164: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
165: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
166: htp.br;
167: htp.tableOpen('BORDER=0');
168: htp.tableRowOpen;
169: htp.tableData(cvalue => ''||fnd_message.get||'',cattributes => 'VALIGN="MIDDLE"');

Line 187: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop

183: elsif l_total_rows = 1 then
184:
185: l_count := 0;
186: while l_key_attributes(l_count+1) is not null loop
187: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
188: if ak_query_pkg.g_items_table(i).attribute_code = l_key_attributes(l_count+1)
189: then
190: l_key_value_ids(l_count+1) := ak_query_pkg.g_items_table(i).value_id;
191: end if;

Line 188: if ak_query_pkg.g_items_table(i).attribute_code = l_key_attributes(l_count+1)

184:
185: l_count := 0;
186: while l_key_attributes(l_count+1) is not null loop
187: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
188: if ak_query_pkg.g_items_table(i).attribute_code = l_key_attributes(l_count+1)
189: then
190: l_key_value_ids(l_count+1) := ak_query_pkg.g_items_table(i).value_id;
191: end if;
192: end loop;

Line 190: l_key_value_ids(l_count+1) := ak_query_pkg.g_items_table(i).value_id;

186: while l_key_attributes(l_count+1) is not null loop
187: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
188: if ak_query_pkg.g_items_table(i).attribute_code = l_key_attributes(l_count+1)
189: then
190: l_key_value_ids(l_count+1) := ak_query_pkg.g_items_table(i).value_id;
191: end if;
192: end loop;
193: l_count := l_count + 1;
194: end loop;

Line 195: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(0),l_values_table);

191: end if;
192: end loop;
193: l_count := l_count + 1;
194: end loop;
195: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(0),l_values_table);
196:
197: for i in 1..l_count loop
198: l_X := l_X||l_values_table(l_key_value_ids(i))||'*';
199: end loop;

Line 224: htp.title(ak_query_pkg.g_regions_table(0).name);

220: }
221: }');
222:
223: js.scriptClose;
224: htp.title(ak_query_pkg.g_regions_table(0).name);
225: htp.headClose;
226:
227: icx_admin_sig.toolbar(language_code => l_language_code,
228: disp_find => l_find_proc);

Line 238: htp.tableData(cvalue => ''||ak_query_pkg.g_regions_table(0).name||'',cattributes => 'VALIGN="MIDDLE"');

234: htp.formOpen('');
235:
236: htp.tableOpen('BORDER=0');
237: htp.tableRowOpen;
238: htp.tableData(cvalue => ''||ak_query_pkg.g_regions_table(0).name||'',cattributes => 'VALIGN="MIDDLE"');
239:
240: htp.p('');
241: icx_util.DynamicButton(P_ButtonText => l_new_prompt,
242: P_ImageFileName => 'FNDBNEW',

Line 256: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop

252: icx_on_utilities2.displaySetIcons(l_language_code,l_list_proc,p_start_row,l_end_row,l_encrypted_where,l_query_size,l_total_rows,TRUE,'',p_hidden);
253:
254: l_count := 0;
255: while l_key_attributes(l_count+1) is not null loop
256: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
257: if ak_query_pkg.g_items_table(i).attribute_code = l_key_attributes(l_count+1)
258: then
259: l_key_value_ids(l_count+1) := ak_query_pkg.g_items_table(i).value_id;
260: end if;

Line 257: if ak_query_pkg.g_items_table(i).attribute_code = l_key_attributes(l_count+1)

253:
254: l_count := 0;
255: while l_key_attributes(l_count+1) is not null loop
256: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
257: if ak_query_pkg.g_items_table(i).attribute_code = l_key_attributes(l_count+1)
258: then
259: l_key_value_ids(l_count+1) := ak_query_pkg.g_items_table(i).value_id;
260: end if;
261: end loop;

Line 259: l_key_value_ids(l_count+1) := ak_query_pkg.g_items_table(i).value_id;

255: while l_key_attributes(l_count+1) is not null loop
256: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
257: if ak_query_pkg.g_items_table(i).attribute_code = l_key_attributes(l_count+1)
258: then
259: l_key_value_ids(l_count+1) := ak_query_pkg.g_items_table(i).value_id;
260: end if;
261: end loop;
262: l_count := l_count + 1;
263: end loop;

Line 267: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop

263: end loop;
264:
265: htp.tableOpen('BORDER=4');
266: htp.p('');
267: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
268: if ak_query_pkg.g_items_table(i).secured_column = 'F'
269: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
270: then
271: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long);

Line 268: if ak_query_pkg.g_items_table(i).secured_column = 'F'

264:
265: htp.tableOpen('BORDER=4');
266: htp.p('');
267: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
268: if ak_query_pkg.g_items_table(i).secured_column = 'F'
269: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
270: then
271: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long);
272: if l_link_attribute = ak_query_pkg.g_items_table(i).attribute_code

Line 269: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

265: htp.tableOpen('BORDER=4');
266: htp.p('');
267: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
268: if ak_query_pkg.g_items_table(i).secured_column = 'F'
269: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
270: then
271: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long);
272: if l_link_attribute = ak_query_pkg.g_items_table(i).attribute_code
273: then

Line 271: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long);

267: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
268: if ak_query_pkg.g_items_table(i).secured_column = 'F'
269: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
270: then
271: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long);
272: if l_link_attribute = ak_query_pkg.g_items_table(i).attribute_code
273: then
274: l_link_value_id := ak_query_pkg.g_items_table(i).value_id;
275: end if;

Line 272: if l_link_attribute = ak_query_pkg.g_items_table(i).attribute_code

268: if ak_query_pkg.g_items_table(i).secured_column = 'F'
269: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
270: then
271: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long);
272: if l_link_attribute = ak_query_pkg.g_items_table(i).attribute_code
273: then
274: l_link_value_id := ak_query_pkg.g_items_table(i).value_id;
275: end if;
276: end if;

Line 274: l_link_value_id := ak_query_pkg.g_items_table(i).value_id;

270: then
271: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long);
272: if l_link_attribute = ak_query_pkg.g_items_table(i).attribute_code
273: then
274: l_link_value_id := ak_query_pkg.g_items_table(i).value_id;
275: end if;
276: end if;
277: end loop;
278: htp.tableData('');

Line 283: for r in 0..ak_query_pkg.g_results_table.COUNT-1 loop

279: htp.tableRowClose;
280:
281: l_multirow_color := icx_util.get_color('TABLE_DATA_MULTIROW');
282:
283: for r in 0..ak_query_pkg.g_results_table.COUNT-1 loop
284:
285: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values_table);
286:
287: l_X := '';

Line 285: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values_table);

281: l_multirow_color := icx_util.get_color('TABLE_DATA_MULTIROW');
282:
283: for r in 0..ak_query_pkg.g_results_table.COUNT-1 loop
284:
285: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values_table);
286:
287: l_X := '';
288: for i in 1..l_count loop
289: l_X := l_X||l_values_table(l_key_value_ids(i))||'*';

Line 293: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop

289: l_X := l_X||l_values_table(l_key_value_ids(i))||'*';
290: end loop;
291:
292: htp.tableRowOpen;
293: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
294:
295: if ak_query_pkg.g_items_table(i).secured_column = 'F'
296: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
297: then

Line 295: if ak_query_pkg.g_items_table(i).secured_column = 'F'

291:
292: htp.tableRowOpen;
293: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
294:
295: if ak_query_pkg.g_items_table(i).secured_column = 'F'
296: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
297: then
298: if ak_query_pkg.g_items_table(i).attribute_code = l_link_attribute
299: then

Line 296: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

292: htp.tableRowOpen;
293: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
294:
295: if ak_query_pkg.g_items_table(i).secured_column = 'F'
296: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
297: then
298: if ak_query_pkg.g_items_table(i).attribute_code = l_link_attribute
299: then
300: htp.tableData(htf.anchor(l_update_proc||'?X='||icx_call.encrypt2(l_X||'*]'),l_values_table(l_link_value_id),'','onMouseOver="return true"'));

Line 298: if ak_query_pkg.g_items_table(i).attribute_code = l_link_attribute

294:
295: if ak_query_pkg.g_items_table(i).secured_column = 'F'
296: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
297: then
298: if ak_query_pkg.g_items_table(i).attribute_code = l_link_attribute
299: then
300: htp.tableData(htf.anchor(l_update_proc||'?X='||icx_call.encrypt2(l_X||'*]'),l_values_table(l_link_value_id),'','onMouseOver="return true"'));
301: elsif ak_query_pkg.g_items_table(i).value_id is null
302: then

Line 301: elsif ak_query_pkg.g_items_table(i).value_id is null

297: then
298: if ak_query_pkg.g_items_table(i).attribute_code = l_link_attribute
299: then
300: htp.tableData(htf.anchor(l_update_proc||'?X='||icx_call.encrypt2(l_X||'*]'),l_values_table(l_link_value_id),'','onMouseOver="return true"'));
301: elsif ak_query_pkg.g_items_table(i).value_id is null
302: then
303: htp.tableData('');
304: elsif ak_query_pkg.g_items_table(i).item_style = 'CHECKBOX'
305: and (l_values_table(ak_query_pkg.g_items_table(i).value_id) = 'T'

Line 304: elsif ak_query_pkg.g_items_table(i).item_style = 'CHECKBOX'

300: htp.tableData(htf.anchor(l_update_proc||'?X='||icx_call.encrypt2(l_X||'*]'),l_values_table(l_link_value_id),'','onMouseOver="return true"'));
301: elsif ak_query_pkg.g_items_table(i).value_id is null
302: then
303: htp.tableData('');
304: elsif ak_query_pkg.g_items_table(i).item_style = 'CHECKBOX'
305: and (l_values_table(ak_query_pkg.g_items_table(i).value_id) = 'T'
306: or l_values_table(ak_query_pkg.g_items_table(i).value_id) = 'Y')
307: then
308: htp.tableData('','CENTER');

Line 305: and (l_values_table(ak_query_pkg.g_items_table(i).value_id) = 'T'

301: elsif ak_query_pkg.g_items_table(i).value_id is null
302: then
303: htp.tableData('');
304: elsif ak_query_pkg.g_items_table(i).item_style = 'CHECKBOX'
305: and (l_values_table(ak_query_pkg.g_items_table(i).value_id) = 'T'
306: or l_values_table(ak_query_pkg.g_items_table(i).value_id) = 'Y')
307: then
308: htp.tableData('','CENTER');
309: elsif ak_query_pkg.g_items_table(i).item_style = 'CHECKBOX'

Line 306: or l_values_table(ak_query_pkg.g_items_table(i).value_id) = 'Y')

302: then
303: htp.tableData('');
304: elsif ak_query_pkg.g_items_table(i).item_style = 'CHECKBOX'
305: and (l_values_table(ak_query_pkg.g_items_table(i).value_id) = 'T'
306: or l_values_table(ak_query_pkg.g_items_table(i).value_id) = 'Y')
307: then
308: htp.tableData('','CENTER');
309: elsif ak_query_pkg.g_items_table(i).item_style = 'CHECKBOX'
310: then

Line 309: elsif ak_query_pkg.g_items_table(i).item_style = 'CHECKBOX'

305: and (l_values_table(ak_query_pkg.g_items_table(i).value_id) = 'T'
306: or l_values_table(ak_query_pkg.g_items_table(i).value_id) = 'Y')
307: then
308: htp.tableData('','CENTER');
309: elsif ak_query_pkg.g_items_table(i).item_style = 'CHECKBOX'
310: then
311: htp.tableData('');
312: else
313: htp.tableData(l_values_table(ak_query_pkg.g_items_table(i).value_id));

Line 313: htp.tableData(l_values_table(ak_query_pkg.g_items_table(i).value_id));

309: elsif ak_query_pkg.g_items_table(i).item_style = 'CHECKBOX'
310: then
311: htp.tableData('');
312: else
313: htp.tableData(l_values_table(ak_query_pkg.g_items_table(i).value_id));
314: end if;
315: end if;
316:
317: end loop; -- items

Line 374: left_regions_table ak_query_pkg.regions_table_type;

370:
371: l_responsibility_id number := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
372: l_user_id number := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
373:
374: left_regions_table ak_query_pkg.regions_table_type;
375: left_items_table ak_query_pkg.items_table_type;
376: left_results_table ak_query_pkg.results_table_type;
377:
378: right_regions_table ak_query_pkg.regions_table_type;

Line 375: left_items_table ak_query_pkg.items_table_type;

371: l_responsibility_id number := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
372: l_user_id number := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
373:
374: left_regions_table ak_query_pkg.regions_table_type;
375: left_items_table ak_query_pkg.items_table_type;
376: left_results_table ak_query_pkg.results_table_type;
377:
378: right_regions_table ak_query_pkg.regions_table_type;
379: right_items_table ak_query_pkg.items_table_type;

Line 376: left_results_table ak_query_pkg.results_table_type;

372: l_user_id number := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
373:
374: left_regions_table ak_query_pkg.regions_table_type;
375: left_items_table ak_query_pkg.items_table_type;
376: left_results_table ak_query_pkg.results_table_type;
377:
378: right_regions_table ak_query_pkg.regions_table_type;
379: right_items_table ak_query_pkg.items_table_type;
380: right_results_table ak_query_pkg.results_table_type;

Line 378: right_regions_table ak_query_pkg.regions_table_type;

374: left_regions_table ak_query_pkg.regions_table_type;
375: left_items_table ak_query_pkg.items_table_type;
376: left_results_table ak_query_pkg.results_table_type;
377:
378: right_regions_table ak_query_pkg.regions_table_type;
379: right_items_table ak_query_pkg.items_table_type;
380: right_results_table ak_query_pkg.results_table_type;
381:
382: begin

Line 379: right_items_table ak_query_pkg.items_table_type;

375: left_items_table ak_query_pkg.items_table_type;
376: left_results_table ak_query_pkg.results_table_type;
377:
378: right_regions_table ak_query_pkg.regions_table_type;
379: right_items_table ak_query_pkg.items_table_type;
380: right_results_table ak_query_pkg.results_table_type;
381:
382: begin
383:

Line 380: right_results_table ak_query_pkg.results_table_type;

376: left_results_table ak_query_pkg.results_table_type;
377:
378: right_regions_table ak_query_pkg.regions_table_type;
379: right_items_table ak_query_pkg.items_table_type;
380: right_results_table ak_query_pkg.results_table_type;
381:
382: begin
383:
384: -- query the rows for both selection lists --

Line 385: ak_query_pkg.exec_query(

381:
382: begin
383:
384: -- query the rows for both selection lists --
385: ak_query_pkg.exec_query(
386: p_parent_region_appl_id => p_left_region_appl_id,
387: p_parent_region_code => p_left_region_code,
388: p_where_clause => p_left_where,
389: p_responsibility_id => l_responsibility_id,

Line 394: left_regions_table := ak_query_pkg.g_regions_table;

390: p_user_id => l_user_id,
391: p_return_parents => 'T',
392: p_return_children => 'F');
393:
394: left_regions_table := ak_query_pkg.g_regions_table;
395: left_items_table := ak_query_pkg.g_items_table;
396: left_results_table := ak_query_pkg.g_results_table;
397:
398: ak_query_pkg.exec_query(

Line 395: left_items_table := ak_query_pkg.g_items_table;

391: p_return_parents => 'T',
392: p_return_children => 'F');
393:
394: left_regions_table := ak_query_pkg.g_regions_table;
395: left_items_table := ak_query_pkg.g_items_table;
396: left_results_table := ak_query_pkg.g_results_table;
397:
398: ak_query_pkg.exec_query(
399: p_parent_region_appl_id => p_right_region_appl_id,

Line 396: left_results_table := ak_query_pkg.g_results_table;

392: p_return_children => 'F');
393:
394: left_regions_table := ak_query_pkg.g_regions_table;
395: left_items_table := ak_query_pkg.g_items_table;
396: left_results_table := ak_query_pkg.g_results_table;
397:
398: ak_query_pkg.exec_query(
399: p_parent_region_appl_id => p_right_region_appl_id,
400: p_parent_region_code => p_right_region_code,

Line 398: ak_query_pkg.exec_query(

394: left_regions_table := ak_query_pkg.g_regions_table;
395: left_items_table := ak_query_pkg.g_items_table;
396: left_results_table := ak_query_pkg.g_results_table;
397:
398: ak_query_pkg.exec_query(
399: p_parent_region_appl_id => p_right_region_appl_id,
400: p_parent_region_code => p_right_region_code,
401: p_where_clause => p_right_where,
402: p_responsibility_id => l_responsibility_id,

Line 407: right_regions_table := ak_query_pkg.g_regions_table;

403: p_user_id => l_user_id,
404: p_return_parents => 'T',
405: p_return_children => 'F');
406:
407: right_regions_table := ak_query_pkg.g_regions_table;
408: right_items_table := ak_query_pkg.g_items_table;
409: right_results_table := ak_query_pkg.g_results_table;
410:
411: htp.formOpen(p_modify_url, 'POST', '','','NAME ="LISTform"');

Line 408: right_items_table := ak_query_pkg.g_items_table;

404: p_return_parents => 'T',
405: p_return_children => 'F');
406:
407: right_regions_table := ak_query_pkg.g_regions_table;
408: right_items_table := ak_query_pkg.g_items_table;
409: right_results_table := ak_query_pkg.g_results_table;
410:
411: htp.formOpen(p_modify_url, 'POST', '','','NAME ="LISTform"');
412:

Line 409: right_results_table := ak_query_pkg.g_results_table;

405: p_return_children => 'F');
406:
407: right_regions_table := ak_query_pkg.g_regions_table;
408: right_items_table := ak_query_pkg.g_items_table;
409: right_results_table := ak_query_pkg.g_results_table;
410:
411: htp.formOpen(p_modify_url, 'POST', '','','NAME ="LISTform"');
412:
413: -- customized hidden field --