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_ON dependencies on AK_QUERY_PKG

Line 138: if ak_query_pkg.g_regions_table(0).flow_application_id > 0

134: else
135: icx_on_utilities.getRegions;
136: end if;
137:
138: if ak_query_pkg.g_regions_table(0).flow_application_id > 0
139: then
140: if ( substr(icx_sec.g_mode_code,1,3) = '115' or
141: icx_sec.g_mode_code = 'SLAVE')
142: then

Line 218: l_query_binds ak_query_pkg.bind_tab;

214: l_count2 number;
215: l_message varchar2(2000);
216:
217: l_where_clause varchar2(2000);
218: l_query_binds ak_query_pkg.bind_tab;
219:
220: -- Bug 3460155
221: c_labels1 varchar2(4000);
222: c_data1 varchar2(4000);

Line 259: ak_query_pkg.exec_query(

255: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
256:
257: icx_on_utilities.unpack_whereSegment(l_where,l_where_clause,l_query_binds);
258:
259: ak_query_pkg.exec_query(
260: P_FLOW_APPL_ID => l_flow_appl_id,
261: P_FLOW_CODE => l_flow_code,
262: P_PARENT_PAGE_APPL_ID => l_page_appl_id,
263: P_PARENT_PAGE_CODE => l_page_code,

Line 306: ak_query_pkg.exec_query(

302:
303: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
304: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
305:
306: ak_query_pkg.exec_query(
307: P_FLOW_APPL_ID => l_flow_appl_id,
308: P_FLOW_CODE => l_flow_code,
309: P_PARENT_PAGE_APPL_ID => c_from_page_appl_id,
310: P_PARENT_PAGE_CODE => c_from_page_code,

Line 338: if ak_query_pkg.g_results_table.COUNT = 0

334: owa_util.mime_header('application/x-excel', TRUE);
335:
336: -- icx_on_utilities2.printPLSQLtables;
337:
338: if ak_query_pkg.g_results_table.COUNT = 0
339: then
340: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
341: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
342: l_message := fnd_message.get;

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

337:
338: if ak_query_pkg.g_results_table.COUNT = 0
339: then
340: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
341: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
342: l_message := fnd_message.get;
343:
344: htp.p(l_message);
345: else

Line 347: for r in ak_query_pkg.g_regions_table.FIRST..ak_query_pkg.g_regions_table.LAST loop

343:
344: htp.p(l_message);
345: else
346:
347: for r in ak_query_pkg.g_regions_table.FIRST..ak_query_pkg.g_regions_table.LAST loop
348:
349: if ak_query_pkg.g_regions_table(r).total_result_count > 0
350: then
351:

Line 349: if ak_query_pkg.g_regions_table(r).total_result_count > 0

345: else
346:
347: for r in ak_query_pkg.g_regions_table.FIRST..ak_query_pkg.g_regions_table.LAST loop
348:
349: if ak_query_pkg.g_regions_table(r).total_result_count > 0
350: then
351:
352: if ak_query_pkg.g_regions_table(r).region_style = 'FORM'
353: then

Line 352: if ak_query_pkg.g_regions_table(r).region_style = 'FORM'

348:
349: if ak_query_pkg.g_regions_table(r).total_result_count > 0
350: then
351:
352: if ak_query_pkg.g_regions_table(r).region_style = 'FORM'
353: then
354:
355: l_count1 := 0;
356:

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

353: then
354:
355: l_count1 := 0;
356:
357: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
358:
359: if ak_query_pkg.g_items_table(i).region_rec_id = ak_query_pkg.g_regions_table(r).region_rec_id
360: and ak_query_pkg.g_items_table(i).secured_column = 'F'
361: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

Line 359: if ak_query_pkg.g_items_table(i).region_rec_id = ak_query_pkg.g_regions_table(r).region_rec_id

355: l_count1 := 0;
356:
357: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
358:
359: if ak_query_pkg.g_items_table(i).region_rec_id = ak_query_pkg.g_regions_table(r).region_rec_id
360: and ak_query_pkg.g_items_table(i).secured_column = 'F'
361: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
362: and ak_query_pkg.g_items_table(i).item_style = 'TEXT'
363: then

Line 360: and ak_query_pkg.g_items_table(i).secured_column = 'F'

356:
357: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
358:
359: if ak_query_pkg.g_items_table(i).region_rec_id = ak_query_pkg.g_regions_table(r).region_rec_id
360: and ak_query_pkg.g_items_table(i).secured_column = 'F'
361: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
362: and ak_query_pkg.g_items_table(i).item_style = 'TEXT'
363: then
364:

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

357: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
358:
359: if ak_query_pkg.g_items_table(i).region_rec_id = ak_query_pkg.g_regions_table(r).region_rec_id
360: and ak_query_pkg.g_items_table(i).secured_column = 'F'
361: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
362: and ak_query_pkg.g_items_table(i).item_style = 'TEXT'
363: then
364:
365: for v in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop

Line 362: and ak_query_pkg.g_items_table(i).item_style = 'TEXT'

358:
359: if ak_query_pkg.g_items_table(i).region_rec_id = ak_query_pkg.g_regions_table(r).region_rec_id
360: and ak_query_pkg.g_items_table(i).secured_column = 'F'
361: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
362: and ak_query_pkg.g_items_table(i).item_style = 'TEXT'
363: then
364:
365: for v in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop
366:

Line 365: for v in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop

361: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
362: and ak_query_pkg.g_items_table(i).item_style = 'TEXT'
363: then
364:
365: for v in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop
366:
367: if ak_query_pkg.g_results_table(v).region_rec_id = ak_query_pkg.g_results_table(r).region_rec_id
368: then
369:

Line 367: if ak_query_pkg.g_results_table(v).region_rec_id = ak_query_pkg.g_results_table(r).region_rec_id

363: then
364:
365: for v in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop
366:
367: if ak_query_pkg.g_results_table(v).region_rec_id = ak_query_pkg.g_results_table(r).region_rec_id
368: then
369:
370: if l_count1 = ak_query_pkg.g_regions_table(r).number_of_format_columns
371: then

Line 370: if l_count1 = ak_query_pkg.g_regions_table(r).number_of_format_columns

366:
367: if ak_query_pkg.g_results_table(v).region_rec_id = ak_query_pkg.g_results_table(r).region_rec_id
368: then
369:
370: if l_count1 = ak_query_pkg.g_regions_table(r).number_of_format_columns
371: then
372: htp.p;
373: l_count1 := 0;
374: end if;

Line 376: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(v),l_values_table);

372: htp.p;
373: l_count1 := 0;
374: end if;
375:
376: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(v),l_values_table);
377:
378: if ak_query_pkg.g_items_table(i).value_id is null
379: then
380: l_value := '';

Line 378: if ak_query_pkg.g_items_table(i).value_id is null

374: end if;
375:
376: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(v),l_values_table);
377:
378: if ak_query_pkg.g_items_table(i).value_id is null
379: then
380: l_value := '';
381: else
382: l_value := replace(l_values_table(ak_query_pkg.g_items_table(i).value_id),','

Line 382: l_value := replace(l_values_table(ak_query_pkg.g_items_table(i).value_id),','

378: if ak_query_pkg.g_items_table(i).value_id is null
379: then
380: l_value := '';
381: else
382: l_value := replace(l_values_table(ak_query_pkg.g_items_table(i).value_id),','
383: ,'');
384: end if;
385: if ak_query_pkg.g_items_table(i).attribute_label_long is null and l_value is null
386: then

Line 385: if ak_query_pkg.g_items_table(i).attribute_label_long is null and l_value is null

381: else
382: l_value := replace(l_values_table(ak_query_pkg.g_items_table(i).value_id),','
383: ,'');
384: end if;
385: if ak_query_pkg.g_items_table(i).attribute_label_long is null and l_value is null
386: then
387: l_value := l_value;
388: else
389: htp.prn(ak_query_pkg.g_items_table(i).attribute_label_long||c_delimiter||l_value||c_delimiter);

Line 389: htp.prn(ak_query_pkg.g_items_table(i).attribute_label_long||c_delimiter||l_value||c_delimiter);

385: if ak_query_pkg.g_items_table(i).attribute_label_long is null and l_value is null
386: then
387: l_value := l_value;
388: else
389: htp.prn(ak_query_pkg.g_items_table(i).attribute_label_long||c_delimiter||l_value||c_delimiter);
390: l_count1 := l_count1 + 1;
391: end if;
392:
393: end if; -- region result

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

403:
404: else
405:
406: c_labels := '';
407: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
408:
409: if ak_query_pkg.g_items_table(i).region_rec_id = ak_query_pkg.g_regions_table(r).region_rec_id
410: and ak_query_pkg.g_items_table(i).secured_column = 'F'
411: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

Line 409: if ak_query_pkg.g_items_table(i).region_rec_id = ak_query_pkg.g_regions_table(r).region_rec_id

405:
406: c_labels := '';
407: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
408:
409: if ak_query_pkg.g_items_table(i).region_rec_id = ak_query_pkg.g_regions_table(r).region_rec_id
410: and ak_query_pkg.g_items_table(i).secured_column = 'F'
411: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
412: and ak_query_pkg.g_items_table(i).item_style = 'TEXT'
413: then

Line 410: and ak_query_pkg.g_items_table(i).secured_column = 'F'

406: c_labels := '';
407: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
408:
409: if ak_query_pkg.g_items_table(i).region_rec_id = ak_query_pkg.g_regions_table(r).region_rec_id
410: and ak_query_pkg.g_items_table(i).secured_column = 'F'
411: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
412: and ak_query_pkg.g_items_table(i).item_style = 'TEXT'
413: then
414: c_labels := c_labels||ak_query_pkg.g_items_table(i).attribute_label_long||c_delimiter;

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

407: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
408:
409: if ak_query_pkg.g_items_table(i).region_rec_id = ak_query_pkg.g_regions_table(r).region_rec_id
410: and ak_query_pkg.g_items_table(i).secured_column = 'F'
411: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
412: and ak_query_pkg.g_items_table(i).item_style = 'TEXT'
413: then
414: c_labels := c_labels||ak_query_pkg.g_items_table(i).attribute_label_long||c_delimiter;
415:

Line 412: and ak_query_pkg.g_items_table(i).item_style = 'TEXT'

408:
409: if ak_query_pkg.g_items_table(i).region_rec_id = ak_query_pkg.g_regions_table(r).region_rec_id
410: and ak_query_pkg.g_items_table(i).secured_column = 'F'
411: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
412: and ak_query_pkg.g_items_table(i).item_style = 'TEXT'
413: then
414: c_labels := c_labels||ak_query_pkg.g_items_table(i).attribute_label_long||c_delimiter;
415:
416: end if;

Line 414: c_labels := c_labels||ak_query_pkg.g_items_table(i).attribute_label_long||c_delimiter;

410: and ak_query_pkg.g_items_table(i).secured_column = 'F'
411: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
412: and ak_query_pkg.g_items_table(i).item_style = 'TEXT'
413: then
414: c_labels := c_labels||ak_query_pkg.g_items_table(i).attribute_label_long||c_delimiter;
415:
416: end if;
417:
418: end loop; -- items

Line 436: for v in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop

432:
433: --- End Bug3460155
434:
435:
436: for v in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop
437:
438: if ak_query_pkg.g_results_table(v).region_rec_id = ak_query_pkg.g_regions_table(r).region_rec_id
439: then
440:

Line 438: if ak_query_pkg.g_results_table(v).region_rec_id = ak_query_pkg.g_regions_table(r).region_rec_id

434:
435:
436: for v in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop
437:
438: if ak_query_pkg.g_results_table(v).region_rec_id = ak_query_pkg.g_regions_table(r).region_rec_id
439: then
440:
441: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(v),l_values_table);
442:

Line 441: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(v),l_values_table);

437:
438: if ak_query_pkg.g_results_table(v).region_rec_id = ak_query_pkg.g_regions_table(r).region_rec_id
439: then
440:
441: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(v),l_values_table);
442:
443: c_data := '';
444: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
445:

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

440:
441: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(v),l_values_table);
442:
443: c_data := '';
444: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
445:
446: if ak_query_pkg.g_items_table(i).region_rec_id = ak_query_pkg.g_regions_table(r).region_rec_id
447: and ak_query_pkg.g_items_table(i).secured_column = 'F'
448: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

Line 446: if ak_query_pkg.g_items_table(i).region_rec_id = ak_query_pkg.g_regions_table(r).region_rec_id

442:
443: c_data := '';
444: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
445:
446: if ak_query_pkg.g_items_table(i).region_rec_id = ak_query_pkg.g_regions_table(r).region_rec_id
447: and ak_query_pkg.g_items_table(i).secured_column = 'F'
448: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
449: and ak_query_pkg.g_items_table(i).item_style = 'TEXT'
450: then

Line 447: and ak_query_pkg.g_items_table(i).secured_column = 'F'

443: c_data := '';
444: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
445:
446: if ak_query_pkg.g_items_table(i).region_rec_id = ak_query_pkg.g_regions_table(r).region_rec_id
447: and ak_query_pkg.g_items_table(i).secured_column = 'F'
448: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
449: and ak_query_pkg.g_items_table(i).item_style = 'TEXT'
450: then
451: if ak_query_pkg.g_items_table(i).value_id is null

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

444: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
445:
446: if ak_query_pkg.g_items_table(i).region_rec_id = ak_query_pkg.g_regions_table(r).region_rec_id
447: and ak_query_pkg.g_items_table(i).secured_column = 'F'
448: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
449: and ak_query_pkg.g_items_table(i).item_style = 'TEXT'
450: then
451: if ak_query_pkg.g_items_table(i).value_id is null
452: then

Line 449: and ak_query_pkg.g_items_table(i).item_style = 'TEXT'

445:
446: if ak_query_pkg.g_items_table(i).region_rec_id = ak_query_pkg.g_regions_table(r).region_rec_id
447: and ak_query_pkg.g_items_table(i).secured_column = 'F'
448: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
449: and ak_query_pkg.g_items_table(i).item_style = 'TEXT'
450: then
451: if ak_query_pkg.g_items_table(i).value_id is null
452: then
453: l_value := '';

Line 451: if ak_query_pkg.g_items_table(i).value_id is null

447: and ak_query_pkg.g_items_table(i).secured_column = 'F'
448: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
449: and ak_query_pkg.g_items_table(i).item_style = 'TEXT'
450: then
451: if ak_query_pkg.g_items_table(i).value_id is null
452: then
453: l_value := '';
454: else
455: l_value := replace(l_values_table(ak_query_pkg.g_items_table(i).value_id),',','');

Line 455: l_value := replace(l_values_table(ak_query_pkg.g_items_table(i).value_id),',','');

451: if ak_query_pkg.g_items_table(i).value_id is null
452: then
453: l_value := '';
454: else
455: l_value := replace(l_values_table(ak_query_pkg.g_items_table(i).value_id),',','');
456: end if;
457: c_data := c_data||l_value||c_delimiter;
458: end if;
459:

Line 481: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(r).name);

477: end if; -- region style
478:
479: else
480: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
481: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(r).name);
482: l_message := fnd_message.get;
483: htp.p(l_message);
484:
485: end if; -- no row in region