APPS.ICX_UTIL dependencies on ICX_ON_UTILITIES

Line 1357: where_clause := icx_on_utilities.whereSegment

1353: -- Perform Object Navigator query
1354:
1355: -- Call whereSegment to construct where clause
1356: if case_sensitive = 'on' then
1357: where_clause := icx_on_utilities.whereSegment
1358: (a_1 => a_1,
1359: c_1 => c_1,
1360: i_1 => i_1,
1361: a_2 => a_2,

Line 1375: where_clause := icx_on_utilities.whereSegment

1371: c_5 => c_5,
1372: i_5 => i_5,
1373: m => case_sensitive);
1374: else
1375: where_clause := icx_on_utilities.whereSegment
1376: (a_1 => a_1,
1377: c_1 => c_1,
1378: i_1 => i_1,
1379: a_2 => a_2,

Line 1396: icx_on_utilities.unpack_whereSegment(where_clause,l_where_clause,l_query_binds);

1392:
1393:
1394:
1395: -- unpack where clause to use bind variables
1396: icx_on_utilities.unpack_whereSegment(where_clause,l_where_clause,l_query_binds);
1397:
1398: l_where_temp:= icx_call.decrypt2(c_where_clause); --mputman added
1399:
1400: IF substrb(l_where_temp,1,2)='@@'THEN

Line 1424: icx_on_utilities.unpack_whereSegment(c_where_bind_vals,l_query_binds,l_query_binds_index);

1420: end if; --c_where_clause
1421:
1422: IF c_where_bind_vals IS NOT NULL THEN
1423: l_query_binds_index:=l_query_binds.COUNT;
1424: icx_on_utilities.unpack_whereSegment(c_where_bind_vals,l_query_binds,l_query_binds_index);
1425: END IF;
1426:
1427:
1428:

Line 1809: htp.p(icx_on_utilities.formatData(htf.anchor('javascript:clicked('||l_clicked_vars||')',

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),
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),

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 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;