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

Line 508: ak_query_pkg.exec_query (

504: l_order_by_clause := '1';
505:
506: -- Call to Object Navigator to execute query and return data
507: -- as well as object and region structures
508: ak_query_pkg.exec_query (
509: P_PARENT_REGION_APPL_ID => p_LOV_region_id ,
510: P_PARENT_REGION_CODE => p_LOV_region ,
511: P_WHERE_CLAUSE => l_where_clause ,
512: P_ORDER_BY_CLAUSE => l_order_by_clause ,

Line 520: htp.p(ak_query_pkg.g_items_table.COUNT);

516: P_RETURN_CHILDREN => 'F');
517:
518:
519: -- write out the number of columns returned by the ak query
520: htp.p(ak_query_pkg.g_items_table.COUNT);
521:
522: -- write out the number of rows returned by the ak query
523: htp.p(ak_query_pkg.g_results_table.COUNT);
524:

Line 523: htp.p(ak_query_pkg.g_results_table.COUNT);

519: -- write out the number of columns returned by the ak query
520: htp.p(ak_query_pkg.g_items_table.COUNT);
521:
522: -- write out the number of rows returned by the ak query
523: htp.p(ak_query_pkg.g_results_table.COUNT);
524:
525:
526: -- write out the column header information
527: l_total_width := 0;

Line 528: if ak_query_pkg.g_items_table.COUNT > 0 then

524:
525:
526: -- write out the column header information
527: l_total_width := 0;
528: if ak_query_pkg.g_items_table.COUNT > 0 then
529: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
530: if ak_query_pkg.g_items_table(i).secured_column = 'F' and
531: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' then
532: l_total_width := l_total_width + ak_query_pkg.g_items_table(i).display_value_length;

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

525:
526: -- write out the column header information
527: l_total_width := 0;
528: if ak_query_pkg.g_items_table.COUNT > 0 then
529: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
530: if ak_query_pkg.g_items_table(i).secured_column = 'F' and
531: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' then
532: l_total_width := l_total_width + ak_query_pkg.g_items_table(i).display_value_length;
533: end if;

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

526: -- write out the column header information
527: l_total_width := 0;
528: if ak_query_pkg.g_items_table.COUNT > 0 then
529: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
530: if ak_query_pkg.g_items_table(i).secured_column = 'F' and
531: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' then
532: l_total_width := l_total_width + ak_query_pkg.g_items_table(i).display_value_length;
533: end if;
534: end loop;

Line 531: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' then

527: l_total_width := 0;
528: if ak_query_pkg.g_items_table.COUNT > 0 then
529: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
530: if ak_query_pkg.g_items_table(i).secured_column = 'F' and
531: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' then
532: l_total_width := l_total_width + ak_query_pkg.g_items_table(i).display_value_length;
533: end if;
534: end loop;
535:

Line 532: l_total_width := l_total_width + ak_query_pkg.g_items_table(i).display_value_length;

528: if ak_query_pkg.g_items_table.COUNT > 0 then
529: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
530: if ak_query_pkg.g_items_table(i).secured_column = 'F' and
531: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' then
532: l_total_width := l_total_width + ak_query_pkg.g_items_table(i).display_value_length;
533: end if;
534: end loop;
535:
536:

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

533: end if;
534: end loop;
535:
536:
537: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
538: if ak_query_pkg.g_items_table(i).secured_column = 'F' then
539: htp.p(ak_query_pkg.g_items_table(i).attribute_label_long);
540: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y' then
541: htp.p(round((ak_query_pkg.g_items_table(i).display_value_length/l_total_width) * 100));

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

534: end loop;
535:
536:
537: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
538: if ak_query_pkg.g_items_table(i).secured_column = 'F' then
539: htp.p(ak_query_pkg.g_items_table(i).attribute_label_long);
540: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y' then
541: htp.p(round((ak_query_pkg.g_items_table(i).display_value_length/l_total_width) * 100));
542: else

Line 539: htp.p(ak_query_pkg.g_items_table(i).attribute_label_long);

535:
536:
537: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
538: if ak_query_pkg.g_items_table(i).secured_column = 'F' then
539: htp.p(ak_query_pkg.g_items_table(i).attribute_label_long);
540: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y' then
541: htp.p(round((ak_query_pkg.g_items_table(i).display_value_length/l_total_width) * 100));
542: else
543: htp.p('0');

Line 540: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y' then

536:
537: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
538: if ak_query_pkg.g_items_table(i).secured_column = 'F' then
539: htp.p(ak_query_pkg.g_items_table(i).attribute_label_long);
540: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y' then
541: htp.p(round((ak_query_pkg.g_items_table(i).display_value_length/l_total_width) * 100));
542: else
543: htp.p('0');
544: end if;

Line 541: htp.p(round((ak_query_pkg.g_items_table(i).display_value_length/l_total_width) * 100));

537: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
538: if ak_query_pkg.g_items_table(i).secured_column = 'F' then
539: htp.p(ak_query_pkg.g_items_table(i).attribute_label_long);
540: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y' then
541: htp.p(round((ak_query_pkg.g_items_table(i).display_value_length/l_total_width) * 100));
542: else
543: htp.p('0');
544: end if;
545: end if;

Line 552: if ak_query_pkg.g_results_table.COUNT > 0 then

548:
549:
550: -- write out the row data
551: if p_titles_only <> 'Y' then
552: if ak_query_pkg.g_results_table.COUNT > 0 then
553: for i in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop
554: -- load data for current row into temp pl/sql table
555: transfer_Row_To_Column(ak_query_pkg.g_results_table(i), l_result_row_table);
556: for j in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop

Line 553: for i in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop

549:
550: -- write out the row data
551: if p_titles_only <> 'Y' then
552: if ak_query_pkg.g_results_table.COUNT > 0 then
553: for i in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop
554: -- load data for current row into temp pl/sql table
555: transfer_Row_To_Column(ak_query_pkg.g_results_table(i), l_result_row_table);
556: for j in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
557: htp.p(l_result_row_table(ak_query_pkg.g_items_table(j).value_id));

Line 555: transfer_Row_To_Column(ak_query_pkg.g_results_table(i), l_result_row_table);

551: if p_titles_only <> 'Y' then
552: if ak_query_pkg.g_results_table.COUNT > 0 then
553: for i in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop
554: -- load data for current row into temp pl/sql table
555: transfer_Row_To_Column(ak_query_pkg.g_results_table(i), l_result_row_table);
556: for j in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
557: htp.p(l_result_row_table(ak_query_pkg.g_items_table(j).value_id));
558: end loop;
559: end loop;

Line 556: for j in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop

552: if ak_query_pkg.g_results_table.COUNT > 0 then
553: for i in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop
554: -- load data for current row into temp pl/sql table
555: transfer_Row_To_Column(ak_query_pkg.g_results_table(i), l_result_row_table);
556: for j in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
557: htp.p(l_result_row_table(ak_query_pkg.g_items_table(j).value_id));
558: end loop;
559: end loop;
560: end if;

Line 557: htp.p(l_result_row_table(ak_query_pkg.g_items_table(j).value_id));

553: for i in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop
554: -- load data for current row into temp pl/sql table
555: transfer_Row_To_Column(ak_query_pkg.g_results_table(i), l_result_row_table);
556: for j in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
557: htp.p(l_result_row_table(ak_query_pkg.g_items_table(j).value_id));
558: end loop;
559: end loop;
560: end if;
561: end if;

Line 1332: l_query_binds ak_query_pkg.bind_tab;

1328: l_clicked_vars varchar2(2000);
1329: l_attribute_name varchar2(240);
1330: l_js_proc_text varchar2(2000);
1331: l_where_clause varchar2(2000);
1332: l_query_binds ak_query_pkg.bind_tab;
1333: l_error boolean;
1334: l_where_temp VARCHAR2(2000); -- mputman added
1335: c_where_bind_vals VARCHAR2(2000); -- mputman added
1336: l_query_binds_index NUMBER;

Line 1457: ak_query_pkg.exec_query (

1453: end if;
1454:
1455: -- Call to Object Navigator to execute query and return data
1456: -- as well as object and region structures
1457: ak_query_pkg.exec_query (
1458: P_PARENT_REGION_APPL_ID => p_LOV_region_id ,
1459: P_PARENT_REGION_CODE => p_LOV_region ,
1460: P_WHERE_CLAUSE => l_where_clause ,
1461: P_WHERE_BINDS => l_query_binds ,

Line 1471: if ak_query_pkg.g_regions_table(0).total_result_count = l_max_rows then

1467: P_RANGE_LOW => start_row ,
1468: P_RANGE_HIGH => end_row ,
1469: P_MAX_ROWS => l_max_rows);
1470:
1471: if ak_query_pkg.g_regions_table(0).total_result_count = l_max_rows then
1472: l_error := TRUE;
1473: end if;
1474:
1475: end if; -- Do Object Navigator query

Line 1686: total_rows := ak_query_pkg.g_regions_table(0).total_result_count;

1682:
1683:
1684: -- get number of total rows returned by lov to be used to
1685: -- determine if we need to display the next/previous buttons
1686: total_rows := ak_query_pkg.g_regions_table(0).total_result_count;
1687:
1688: if end_row > total_rows then
1689: end_row := total_rows;
1690: end if;

Line 1695: for i in 1..ak_query_pkg.g_results_table.COUNT loop

1691:
1692:
1693: -- display LOV data and CD buttons if necessary
1694: j := 0;
1695: for i in 1..ak_query_pkg.g_results_table.COUNT loop
1696: j := j + 1;
1697:
1698: -- If this is the first iteration of the loop then
1699: -- display next/previous set buttons if list of values returns

Line 1717: P_OBJECT_DISP_NAME => ak_query_pkg.g_items_table(1).attribute_label_long);

1713: p_hidden => '',
1714: p_update => FALSE,
1715: p_target => '',
1716: P_LIST_COUNT => TRUE,
1717: P_OBJECT_DISP_NAME => ak_query_pkg.g_items_table(1).attribute_label_long);
1718:
1719: -- display table header of LOV
1720: htp.p('');
1721: htp.p('
');

Line 1724: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop

1720: htp.p('');
1721: htp.p('
');
1722: htp.p('');
1723: htp.p('');
1724: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
1725: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
1726: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then
1727:
1728: /*
Line 1725: if ak_query_pkg.g_items_table(k).secured_column = 'F' and

1721: htp.p('

');
1722: htp.p('');
1723: htp.p('');
1724: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
1725: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
1726: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then
1727:
1728: /*
1729: htp.p('
'||

Line 1726: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then

1722: htp.p('');
1723: htp.p('');
1724: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
1725: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
1726: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then
1727:
1728: /*
1729: htp.p('');
1801: end if;
1802:
1803: l := 0;
1804: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
1805: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
1806: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then
1807: l := l + 1;
1808: if l = 1 then
Line 1805: if ak_query_pkg.g_items_table(k).secured_column = 'F' and

1801: end if;
1802:
1803: l := 0;
1804: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
1805: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
1806: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then
1807: l := l + 1;
1808: if l = 1 then
1809: htp.p(icx_on_utilities.formatData(htf.anchor('javascript:clicked('||l_clicked_vars||')',

Line 1806: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then

1802:
1803: l := 0;
1804: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
1805: if ak_query_pkg.g_items_table(k).secured_column = 'F' and
1806: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then
1807: l := l + 1;
1808: if l = 1 then
1809: htp.p(icx_on_utilities.formatData(htf.anchor('javascript:clicked('||l_clicked_vars||')',
1810: icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),

Line 1810: icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),

1806: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then
1807: l := l + 1;
1808: if l = 1 then
1809: htp.p(icx_on_utilities.formatData(htf.anchor('javascript:clicked('||l_clicked_vars||')',
1810: icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),
1811: ak_query_pkg.g_items_table(k).bold,ak_query_pkg.g_items_table(k).italic)),ak_query_pkg.g_items_table(k).horizontal_alignment,ak_query_pkg.g_items_table(k).vertical_alignment));
1812: else
1813: htp.p(icx_on_utilities.formatData(icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),
1814: ak_query_pkg.g_items_table(k).bold,ak_query_pkg.g_items_table(k).italic),ak_query_pkg.g_items_table(k).horizontal_alignment,ak_query_pkg.g_items_table(k).vertical_alignment));

Line 1811: ak_query_pkg.g_items_table(k).bold,ak_query_pkg.g_items_table(k).italic)),ak_query_pkg.g_items_table(k).horizontal_alignment,ak_query_pkg.g_items_table(k).vertical_alignment));

1807: l := l + 1;
1808: if l = 1 then
1809: htp.p(icx_on_utilities.formatData(htf.anchor('javascript:clicked('||l_clicked_vars||')',
1810: icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),
1811: ak_query_pkg.g_items_table(k).bold,ak_query_pkg.g_items_table(k).italic)),ak_query_pkg.g_items_table(k).horizontal_alignment,ak_query_pkg.g_items_table(k).vertical_alignment));
1812: else
1813: htp.p(icx_on_utilities.formatData(icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),
1814: ak_query_pkg.g_items_table(k).bold,ak_query_pkg.g_items_table(k).italic),ak_query_pkg.g_items_table(k).horizontal_alignment,ak_query_pkg.g_items_table(k).vertical_alignment));
1815: end if;

Line 1813: htp.p(icx_on_utilities.formatData(icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),

1809: htp.p(icx_on_utilities.formatData(htf.anchor('javascript:clicked('||l_clicked_vars||')',
1810: icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),
1811: ak_query_pkg.g_items_table(k).bold,ak_query_pkg.g_items_table(k).italic)),ak_query_pkg.g_items_table(k).horizontal_alignment,ak_query_pkg.g_items_table(k).vertical_alignment));
1812: else
1813: htp.p(icx_on_utilities.formatData(icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),
1814: ak_query_pkg.g_items_table(k).bold,ak_query_pkg.g_items_table(k).italic),ak_query_pkg.g_items_table(k).horizontal_alignment,ak_query_pkg.g_items_table(k).vertical_alignment));
1815: end if;
1816: end if;
1817: end loop;

Line 1814: ak_query_pkg.g_items_table(k).bold,ak_query_pkg.g_items_table(k).italic),ak_query_pkg.g_items_table(k).horizontal_alignment,ak_query_pkg.g_items_table(k).vertical_alignment));

1810: icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),
1811: ak_query_pkg.g_items_table(k).bold,ak_query_pkg.g_items_table(k).italic)),ak_query_pkg.g_items_table(k).horizontal_alignment,ak_query_pkg.g_items_table(k).vertical_alignment));
1812: else
1813: htp.p(icx_on_utilities.formatData(icx_on_utilities.formatText(l_result_row_table(ak_query_pkg.g_items_table(k).value_id),
1814: ak_query_pkg.g_items_table(k).bold,ak_query_pkg.g_items_table(k).italic),ak_query_pkg.g_items_table(k).horizontal_alignment,ak_query_pkg.g_items_table(k).vertical_alignment));
1815: end if;
1816: end if;
1817: end loop;
1818:

Line 1850: P_OBJECT_DISP_NAME => ak_query_pkg.g_items_table(1).attribute_label_long);

1846: p_hidden => '',
1847: p_update => FALSE,
1848: p_target => '',
1849: P_LIST_COUNT => FALSE,
1850: P_OBJECT_DISP_NAME => ak_query_pkg.g_items_table(1).attribute_label_long);
1851:
1852: end if;
1853:
1854:

Line 2222: procedure transfer_Row_To_Column(result_record in ak_query_pkg.result_rec,

2218:
2219:
2220: -- The transfer_Row_To_Column utility takes one record returned by an
2221: -- Object Navigator query and changes the record into a pl/sql table
2222: procedure transfer_Row_To_Column(result_record in ak_query_pkg.result_rec,
2223: result_table out NOCOPY icx_util.char240_table) is
2224:
2225: begin
2226:

Line 2330: procedure transfer_Row_To_Column(result_record in ak_query_pkg.result_rec,

2326: result_table(100) := substr(result_record.value100,1,240);
2327:
2328: end transfer_Row_To_Column;
2329:
2330: procedure transfer_Row_To_Column(result_record in ak_query_pkg.result_rec,
2331: result_table out NOCOPY icx_util.char4000_table) is
2332:
2333: begin
2334: result_table(1) := result_record.value1;

'||
1730: ''||

Line 1731: ak_query_pkg.g_items_table(k).attribute_label_long||

1727:
1728: /*
1729: htp.p('
'||
1730: ''||
1731: ak_query_pkg.g_items_table(k).attribute_label_long||
1732: '');
1733: */
1734: htp.p(' '||
1735: ''||

Line 1736: ak_query_pkg.g_items_table(k).attribute_label_long||

1732: '');
1733: */
1734: htp.p('
'||
1735: ''||
1736: ak_query_pkg.g_items_table(k).attribute_label_long||
1737: '');
1738:
1739:
1740: end if;

Line 1754: transfer_Row_To_Column(ak_query_pkg.g_results_table(i-1), l_result_row_table);

1750: -- end bug 1853315
1751:
1752:
1753: -- load data for current row into temp pl/sql table
1754: transfer_Row_To_Column(ak_query_pkg.g_results_table(i-1), l_result_row_table);
1755:
1756:
1757: -- build variables to send to clicked javascript function
1758: -- regular out variables

Line 1765: for l in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop

1761: loop
1762: fetch lov_out_attributes into base_region_attr, LOV_region_attr;
1763: exit when lov_out_attributes%NOTFOUND;
1764: k := k + 1;
1765: for l in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
1766: if LOV_region_attr = ak_query_pkg.g_items_table(l).attribute_code then
1767: if (k = 1) then
1768: l_clicked_vars := ''''||replace_onMouseOver_quotes(l_result_row_table(ak_query_pkg.g_items_table(l).value_id))||'''';
1769: else

Line 1766: if LOV_region_attr = ak_query_pkg.g_items_table(l).attribute_code then

1762: fetch lov_out_attributes into base_region_attr, LOV_region_attr;
1763: exit when lov_out_attributes%NOTFOUND;
1764: k := k + 1;
1765: for l in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
1766: if LOV_region_attr = ak_query_pkg.g_items_table(l).attribute_code then
1767: if (k = 1) then
1768: l_clicked_vars := ''''||replace_onMouseOver_quotes(l_result_row_table(ak_query_pkg.g_items_table(l).value_id))||'''';
1769: else
1770: l_clicked_vars := l_clicked_vars||','''||replace_onMouseOver_quotes(l_result_row_table(ak_query_pkg.g_items_table(l).value_id))||'''';

Line 1768: l_clicked_vars := ''''||replace_onMouseOver_quotes(l_result_row_table(ak_query_pkg.g_items_table(l).value_id))||'''';

1764: k := k + 1;
1765: for l in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
1766: if LOV_region_attr = ak_query_pkg.g_items_table(l).attribute_code then
1767: if (k = 1) then
1768: l_clicked_vars := ''''||replace_onMouseOver_quotes(l_result_row_table(ak_query_pkg.g_items_table(l).value_id))||'''';
1769: else
1770: l_clicked_vars := l_clicked_vars||','''||replace_onMouseOver_quotes(l_result_row_table(ak_query_pkg.g_items_table(l).value_id))||'''';
1771: end if;
1772: end if;

Line 1770: l_clicked_vars := l_clicked_vars||','''||replace_onMouseOver_quotes(l_result_row_table(ak_query_pkg.g_items_table(l).value_id))||'''';

1766: if LOV_region_attr = ak_query_pkg.g_items_table(l).attribute_code then
1767: if (k = 1) then
1768: l_clicked_vars := ''''||replace_onMouseOver_quotes(l_result_row_table(ak_query_pkg.g_items_table(l).value_id))||'''';
1769: else
1770: l_clicked_vars := l_clicked_vars||','''||replace_onMouseOver_quotes(l_result_row_table(ak_query_pkg.g_items_table(l).value_id))||'''';
1771: end if;
1772: end if;
1773: end loop;
1774: end loop;

Line 1783: for l in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop

1779: loop
1780: fetch js_out_attributes into base_region_attr, LOV_region_attr, js_proc_name;
1781: exit when js_out_attributes%NOTFOUND;
1782: k := k + 1;
1783: for l in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
1784: if LOV_region_attr = ak_query_pkg.g_items_table(l).attribute_code then
1785: if (k = 1) then
1786: l_clicked_vars := ''''||replace_onMouseOver_quotes(l_result_row_table(ak_query_pkg.g_items_table(l).value_id))||'''';
1787: else

Line 1784: if LOV_region_attr = ak_query_pkg.g_items_table(l).attribute_code then

1780: fetch js_out_attributes into base_region_attr, LOV_region_attr, js_proc_name;
1781: exit when js_out_attributes%NOTFOUND;
1782: k := k + 1;
1783: for l in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
1784: if LOV_region_attr = ak_query_pkg.g_items_table(l).attribute_code then
1785: if (k = 1) then
1786: l_clicked_vars := ''''||replace_onMouseOver_quotes(l_result_row_table(ak_query_pkg.g_items_table(l).value_id))||'''';
1787: else
1788: l_clicked_vars := l_clicked_vars||','''||replace_onMouseOver_quotes(l_result_row_table(ak_query_pkg.g_items_table(l).value_id))||'''';

Line 1786: l_clicked_vars := ''''||replace_onMouseOver_quotes(l_result_row_table(ak_query_pkg.g_items_table(l).value_id))||'''';

1782: k := k + 1;
1783: for l in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
1784: if LOV_region_attr = ak_query_pkg.g_items_table(l).attribute_code then
1785: if (k = 1) then
1786: l_clicked_vars := ''''||replace_onMouseOver_quotes(l_result_row_table(ak_query_pkg.g_items_table(l).value_id))||'''';
1787: else
1788: l_clicked_vars := l_clicked_vars||','''||replace_onMouseOver_quotes(l_result_row_table(ak_query_pkg.g_items_table(l).value_id))||'''';
1789: end if;
1790: end if;

Line 1788: l_clicked_vars := l_clicked_vars||','''||replace_onMouseOver_quotes(l_result_row_table(ak_query_pkg.g_items_table(l).value_id))||'''';

1784: if LOV_region_attr = ak_query_pkg.g_items_table(l).attribute_code then
1785: if (k = 1) then
1786: l_clicked_vars := ''''||replace_onMouseOver_quotes(l_result_row_table(ak_query_pkg.g_items_table(l).value_id))||'''';
1787: else
1788: l_clicked_vars := l_clicked_vars||','''||replace_onMouseOver_quotes(l_result_row_table(ak_query_pkg.g_items_table(l).value_id))||'''';
1789: end if;
1790: end if;
1791: end loop;
1792: end loop;

Line 1804: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop

1800: htp.p('