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_UTILITIES2 dependencies on ICX_ON_UTILITIES

Line 1: package body icx_on_utilities2 as

1: package body icx_on_utilities2 as
2: /* $Header: ICXONVB.pls 120.0 2005/10/07 12:16:53 gjimenez noship $ */
3:
4: procedure displaySetIcons(p_language_code in varchar2,
5: p_packproc in varchar2,

Line 270: l_display_value := icx_on_utilities.formatText(p_value,'Y',p_item_rec.italic);

266: begin
267:
268: if p_region_style = 'FORM'
269: then
270: l_display_value := icx_on_utilities.formatText(p_value,'Y',p_item_rec.italic);
271: l_data_background_color := ' bgcolor="#'||p_data_background_color||'"';
272: else
273: l_display_value := icx_on_utilities.formatText(p_value,p_item_rec.bold,p_item_rec.italic);
274: l_data_background_color := '';

Line 273: l_display_value := icx_on_utilities.formatText(p_value,p_item_rec.bold,p_item_rec.italic);

269: then
270: l_display_value := icx_on_utilities.formatText(p_value,'Y',p_item_rec.italic);
271: l_data_background_color := ' bgcolor="#'||p_data_background_color||'"';
272: else
273: l_display_value := icx_on_utilities.formatText(p_value,p_item_rec.bold,p_item_rec.italic);
274: l_data_background_color := '';
275: end if;
276:
277: -- nlbarlow disable ON form support

Line 338: htp.tableData(cvalue => icx_on_utilities.formatText(p_value,p_bold,p_italic), calign => p_halign, cattributes => 'VALIGN="'||p_valign||'"', crowspan => p_rowspan);

334: else
335: htp.tableData(cvalue => htf.formText(cname => 't', csize => p_value_length, cvalue => p_value, cattributes => 'onChange="'||l_input_check||'"'), crowspan => p_rowspan);
336: end if;
337: else
338: htp.tableData(cvalue => icx_on_utilities.formatText(p_value,p_bold,p_italic), calign => p_halign, cattributes => 'VALIGN="'||p_valign||'"', crowspan => p_rowspan);
339: end if;
340:
341: end;
342:

Line 489: -- icx_on_utilities2.printPLSQLtables;

485: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
486:
487: ak_query_pkg.exec_query('','','','',p_region_application_id,p_region_code,'','','','','','','','','','','','','','','',l_responsibility_id,l_user_id,'T','F','F','F');
488:
489: -- icx_on_utilities2.printPLSQLtables;
490:
491: if p_value_id is null
492: then
493:

Line 521: htp.tableData(cvalue => icx_on_utilities.formatText(p_value,p_bold,p_italic), calign => p_halign, cattributes => 'VALIGN="'||p_valign||'"', crowspan => p_rowspan);

517: htp.tableData(cvalue => l_poplist, crowspan => p_rowspan);
518:
519: else
520:
521: htp.tableData(cvalue => icx_on_utilities.formatText(p_value,p_bold,p_italic), calign => p_halign, cattributes => 'VALIGN="'||p_valign||'"', crowspan => p_rowspan);
522:
523: end if;
524: else
525:

Line 526: htp.tableData(cvalue => icx_on_utilities.formatText(p_value,p_bold,p_italic), calign => p_halign, cattributes => 'VALIGN="'||p_valign||'"', crowspan => p_rowspan);

522:
523: end if;
524: else
525:
526: htp.tableData(cvalue => icx_on_utilities.formatText(p_value,p_bold,p_italic), calign => p_halign, cattributes => 'VALIGN="'||p_valign||'"', crowspan => p_rowspan);
527:
528: end if;
529:
530: end;

Line 570: l_display_sequences icx_on_utilities.number_table;

566: l_header_text_color varchar2(30);
567: l_data_multirow_color varchar2(30);
568: l_data_singlerow_color varchar2(30);
569:
570: l_display_sequences icx_on_utilities.number_table;
571: l_update_counts icx_on_utilities.number_table;
572: l_value_id icx_on_utilities.number_table;
573: l_item_styles icx_on_utilities.v30_table;
574: l_data_types icx_on_utilities.v30_table;

Line 571: l_update_counts icx_on_utilities.number_table;

567: l_data_multirow_color varchar2(30);
568: l_data_singlerow_color varchar2(30);
569:
570: l_display_sequences icx_on_utilities.number_table;
571: l_update_counts icx_on_utilities.number_table;
572: l_value_id icx_on_utilities.number_table;
573: l_item_styles icx_on_utilities.v30_table;
574: l_data_types icx_on_utilities.v30_table;
575: l_rowids icx_on_utilities.rowid_table;

Line 572: l_value_id icx_on_utilities.number_table;

568: l_data_singlerow_color varchar2(30);
569:
570: l_display_sequences icx_on_utilities.number_table;
571: l_update_counts icx_on_utilities.number_table;
572: l_value_id icx_on_utilities.number_table;
573: l_item_styles icx_on_utilities.v30_table;
574: l_data_types icx_on_utilities.v30_table;
575: l_rowids icx_on_utilities.rowid_table;
576: l_url_display_sequence icx_on_utilities.number_table;

Line 573: l_item_styles icx_on_utilities.v30_table;

569:
570: l_display_sequences icx_on_utilities.number_table;
571: l_update_counts icx_on_utilities.number_table;
572: l_value_id icx_on_utilities.number_table;
573: l_item_styles icx_on_utilities.v30_table;
574: l_data_types icx_on_utilities.v30_table;
575: l_rowids icx_on_utilities.rowid_table;
576: l_url_display_sequence icx_on_utilities.number_table;
577: -- l_uk_column_tab ak_query_pkg.rel_key_tab;

Line 574: l_data_types icx_on_utilities.v30_table;

570: l_display_sequences icx_on_utilities.number_table;
571: l_update_counts icx_on_utilities.number_table;
572: l_value_id icx_on_utilities.number_table;
573: l_item_styles icx_on_utilities.v30_table;
574: l_data_types icx_on_utilities.v30_table;
575: l_rowids icx_on_utilities.rowid_table;
576: l_url_display_sequence icx_on_utilities.number_table;
577: -- l_uk_column_tab ak_query_pkg.rel_key_tab;
578:

Line 575: l_rowids icx_on_utilities.rowid_table;

571: l_update_counts icx_on_utilities.number_table;
572: l_value_id icx_on_utilities.number_table;
573: l_item_styles icx_on_utilities.v30_table;
574: l_data_types icx_on_utilities.v30_table;
575: l_rowids icx_on_utilities.rowid_table;
576: l_url_display_sequence icx_on_utilities.number_table;
577: -- l_uk_column_tab ak_query_pkg.rel_key_tab;
578:
579: l_continue boolean;

Line 576: l_url_display_sequence icx_on_utilities.number_table;

572: l_value_id icx_on_utilities.number_table;
573: l_item_styles icx_on_utilities.v30_table;
574: l_data_types icx_on_utilities.v30_table;
575: l_rowids icx_on_utilities.rowid_table;
576: l_url_display_sequence icx_on_utilities.number_table;
577: -- l_uk_column_tab ak_query_pkg.rel_key_tab;
578:
579: l_continue boolean;
580: l_update boolean;

Line 590: l_table_rows icx_on_utilities.v2000_table;

586: l_counter number;
587: l_values icx_util.char4000_table;
588: l_goto varchar2(2000);
589: l_table_row varchar2(2000);
590: l_table_rows icx_on_utilities.v2000_table;
591: l_X varchar2(2000);
592: l_Y varchar2(2000);
593: l_message varchar2(2000);
594: l_submit_string varchar2(2000);

Line 692: l_start := icx_on_utilities.g_on_parameters(6);

688:
689: if l_region_items_start >= 0 and l_region_results_start >= 0
690: then
691:
692: l_start := icx_on_utilities.g_on_parameters(6);
693: l_end := icx_on_utilities.g_on_parameters(7);
694: l_start_region := icx_on_utilities.g_on_parameters(8);
695: l_language_code := icx_sec.getID(icx_sec.pv_language_code);
696: l_session_id := icx_sec.getID(icx_sec.pv_session_id);

Line 693: l_end := icx_on_utilities.g_on_parameters(7);

689: if l_region_items_start >= 0 and l_region_results_start >= 0
690: then
691:
692: l_start := icx_on_utilities.g_on_parameters(6);
693: l_end := icx_on_utilities.g_on_parameters(7);
694: l_start_region := icx_on_utilities.g_on_parameters(8);
695: l_language_code := icx_sec.getID(icx_sec.pv_language_code);
696: l_session_id := icx_sec.getID(icx_sec.pv_session_id);
697:

Line 694: l_start_region := icx_on_utilities.g_on_parameters(8);

690: then
691:
692: l_start := icx_on_utilities.g_on_parameters(6);
693: l_end := icx_on_utilities.g_on_parameters(7);
694: l_start_region := icx_on_utilities.g_on_parameters(8);
695: l_language_code := icx_sec.getID(icx_sec.pv_language_code);
696: l_session_id := icx_sec.getID(icx_sec.pv_session_id);
697:
698: for i in l_region_items_start..l_region_items_end loop

Line 804: if icx_on_utilities.g_on_parameters(1) = 'W'

800: }
801: }
802: }');
803:
804: if icx_on_utilities.g_on_parameters(1) = 'W'
805: then
806: l_Y := 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)
807: ||'*'||icx_call.decrypt2(icx_on_utilities.g_on_parameters(9))||'**]';
808: else

Line 806: l_Y := 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)

802: }');
803:
804: if icx_on_utilities.g_on_parameters(1) = 'W'
805: then
806: l_Y := 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)
807: ||'*'||icx_call.decrypt2(icx_on_utilities.g_on_parameters(9))||'**]';
808: else
809: l_Y := 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)
810: ||'*'||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 807: ||'*'||icx_call.decrypt2(icx_on_utilities.g_on_parameters(9))||'**]';

803:
804: if icx_on_utilities.g_on_parameters(1) = 'W'
805: then
806: l_Y := 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)
807: ||'*'||icx_call.decrypt2(icx_on_utilities.g_on_parameters(9))||'**]';
808: else
809: l_Y := 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)
810: ||'*'||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)
811: ||'*'||icx_on_utilities.g_on_parameters(11)||'*'||icx_on_utilities.g_on_parameters(12)||'*'||icx_on_utilities.g_on_parameters(13)||'*'||icx_on_utilities.g_on_parameters(14)||'*'||icx_on_utilities.g_on_parameters(15)

Line 809: l_Y := 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)

805: then
806: l_Y := 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)
807: ||'*'||icx_call.decrypt2(icx_on_utilities.g_on_parameters(9))||'**]';
808: else
809: l_Y := 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)
810: ||'*'||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)
811: ||'*'||icx_on_utilities.g_on_parameters(11)||'*'||icx_on_utilities.g_on_parameters(12)||'*'||icx_on_utilities.g_on_parameters(13)||'*'||icx_on_utilities.g_on_parameters(14)||'*'||icx_on_utilities.g_on_parameters(15)
812: ||'*'||icx_on_utilities.g_on_parameters(16)||'*'||icx_on_utilities.g_on_parameters(17)||'*'||icx_on_utilities.g_on_parameters(18)||'*'||icx_on_utilities.g_on_parameters(19)||'*'||icx_on_utilities.g_on_parameters(20)
813: ||'*'||icx_on_utilities.g_on_parameters(21)||'**]';

Line 810: ||''||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)

806: l_Y := 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)
807: ||'*'||icx_call.decrypt2(icx_on_utilities.g_on_parameters(9))||'**]';
808: else
809: l_Y := 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)
810: ||'*'||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)
811: ||'*'||icx_on_utilities.g_on_parameters(11)||'*'||icx_on_utilities.g_on_parameters(12)||'*'||icx_on_utilities.g_on_parameters(13)||'*'||icx_on_utilities.g_on_parameters(14)||'*'||icx_on_utilities.g_on_parameters(15)
812: ||'*'||icx_on_utilities.g_on_parameters(16)||'*'||icx_on_utilities.g_on_parameters(17)||'*'||icx_on_utilities.g_on_parameters(18)||'*'||icx_on_utilities.g_on_parameters(19)||'*'||icx_on_utilities.g_on_parameters(20)
813: ||'*'||icx_on_utilities.g_on_parameters(21)||'**]';
814: end if;

Line 811: ||''||icx_on_utilities.g_on_parameters(11)||''||icx_on_utilities.g_on_parameters(12)||''||icx_on_utilities.g_on_parameters(13)||''||icx_on_utilities.g_on_parameters(14)||'*'||icx_on_utilities.g_on_parameters(15)

807: ||'*'||icx_call.decrypt2(icx_on_utilities.g_on_parameters(9))||'**]';
808: else
809: l_Y := 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)
810: ||'*'||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)
811: ||'*'||icx_on_utilities.g_on_parameters(11)||'*'||icx_on_utilities.g_on_parameters(12)||'*'||icx_on_utilities.g_on_parameters(13)||'*'||icx_on_utilities.g_on_parameters(14)||'*'||icx_on_utilities.g_on_parameters(15)
812: ||'*'||icx_on_utilities.g_on_parameters(16)||'*'||icx_on_utilities.g_on_parameters(17)||'*'||icx_on_utilities.g_on_parameters(18)||'*'||icx_on_utilities.g_on_parameters(19)||'*'||icx_on_utilities.g_on_parameters(20)
813: ||'*'||icx_on_utilities.g_on_parameters(21)||'**]';
814: end if;
815:

Line 812: ||''||icx_on_utilities.g_on_parameters(16)||''||icx_on_utilities.g_on_parameters(17)||''||icx_on_utilities.g_on_parameters(18)||''||icx_on_utilities.g_on_parameters(19)||'*'||icx_on_utilities.g_on_parameters(20)

808: else
809: l_Y := 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)
810: ||'*'||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)
811: ||'*'||icx_on_utilities.g_on_parameters(11)||'*'||icx_on_utilities.g_on_parameters(12)||'*'||icx_on_utilities.g_on_parameters(13)||'*'||icx_on_utilities.g_on_parameters(14)||'*'||icx_on_utilities.g_on_parameters(15)
812: ||'*'||icx_on_utilities.g_on_parameters(16)||'*'||icx_on_utilities.g_on_parameters(17)||'*'||icx_on_utilities.g_on_parameters(18)||'*'||icx_on_utilities.g_on_parameters(19)||'*'||icx_on_utilities.g_on_parameters(20)
813: ||'*'||icx_on_utilities.g_on_parameters(21)||'**]';
814: end if;
815:
816: l_X := icx_call.encrypt2(l_X||']');

Line 813: ||'*'||icx_on_utilities.g_on_parameters(21)||'**]';

809: l_Y := 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)
810: ||'*'||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)
811: ||'*'||icx_on_utilities.g_on_parameters(11)||'*'||icx_on_utilities.g_on_parameters(12)||'*'||icx_on_utilities.g_on_parameters(13)||'*'||icx_on_utilities.g_on_parameters(14)||'*'||icx_on_utilities.g_on_parameters(15)
812: ||'*'||icx_on_utilities.g_on_parameters(16)||'*'||icx_on_utilities.g_on_parameters(17)||'*'||icx_on_utilities.g_on_parameters(18)||'*'||icx_on_utilities.g_on_parameters(19)||'*'||icx_on_utilities.g_on_parameters(20)
813: ||'*'||icx_on_utilities.g_on_parameters(21)||'**]';
814: end if;
815:
816: l_X := icx_call.encrypt2(l_X||']');
817: l_Y := icx_call.encrypt2(l_Y);

Line 895: l_Y := 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)

891: end if;
892: l_region_results_start := l_region_results_start + l_start_row - 1;
893: end if;
894:
895: l_Y := 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)
896: ||'*'||icx_on_utilities.g_on_parameters(6)||'*'||icx_on_utilities.g_on_parameters(7)||'*'||l_region_code||'*'||'*'||icx_on_utilities.g_on_parameters(10)
897: ||'*'||icx_on_utilities.g_on_parameters(11)||'*'||icx_on_utilities.g_on_parameters(12)||'*'||icx_on_utilities.g_on_parameters(13)||'*'||icx_on_utilities.g_on_parameters(14)||'*'||icx_on_utilities.g_on_parameters(15)
898: ||'*'||icx_on_utilities.g_on_parameters(16)||'*'||icx_on_utilities.g_on_parameters(17)||'*'||icx_on_utilities.g_on_parameters(18)||'*'||icx_on_utilities.g_on_parameters(19)||'*'||icx_on_utilities.g_on_parameters(20)
899: ||'*'||icx_on_utilities.g_on_parameters(21)||'**]';

Line 896: ||''||icx_on_utilities.g_on_parameters(6)||''||icx_on_utilities.g_on_parameters(7)||''||l_region_code||''||'*'||icx_on_utilities.g_on_parameters(10)

892: l_region_results_start := l_region_results_start + l_start_row - 1;
893: end if;
894:
895: l_Y := 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)
896: ||'*'||icx_on_utilities.g_on_parameters(6)||'*'||icx_on_utilities.g_on_parameters(7)||'*'||l_region_code||'*'||'*'||icx_on_utilities.g_on_parameters(10)
897: ||'*'||icx_on_utilities.g_on_parameters(11)||'*'||icx_on_utilities.g_on_parameters(12)||'*'||icx_on_utilities.g_on_parameters(13)||'*'||icx_on_utilities.g_on_parameters(14)||'*'||icx_on_utilities.g_on_parameters(15)
898: ||'*'||icx_on_utilities.g_on_parameters(16)||'*'||icx_on_utilities.g_on_parameters(17)||'*'||icx_on_utilities.g_on_parameters(18)||'*'||icx_on_utilities.g_on_parameters(19)||'*'||icx_on_utilities.g_on_parameters(20)
899: ||'*'||icx_on_utilities.g_on_parameters(21)||'**]';
900:

Line 897: ||''||icx_on_utilities.g_on_parameters(11)||''||icx_on_utilities.g_on_parameters(12)||''||icx_on_utilities.g_on_parameters(13)||''||icx_on_utilities.g_on_parameters(14)||'*'||icx_on_utilities.g_on_parameters(15)

893: end if;
894:
895: l_Y := 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)
896: ||'*'||icx_on_utilities.g_on_parameters(6)||'*'||icx_on_utilities.g_on_parameters(7)||'*'||l_region_code||'*'||'*'||icx_on_utilities.g_on_parameters(10)
897: ||'*'||icx_on_utilities.g_on_parameters(11)||'*'||icx_on_utilities.g_on_parameters(12)||'*'||icx_on_utilities.g_on_parameters(13)||'*'||icx_on_utilities.g_on_parameters(14)||'*'||icx_on_utilities.g_on_parameters(15)
898: ||'*'||icx_on_utilities.g_on_parameters(16)||'*'||icx_on_utilities.g_on_parameters(17)||'*'||icx_on_utilities.g_on_parameters(18)||'*'||icx_on_utilities.g_on_parameters(19)||'*'||icx_on_utilities.g_on_parameters(20)
899: ||'*'||icx_on_utilities.g_on_parameters(21)||'**]';
900:
901: if l_total_result_count > 5

Line 898: ||''||icx_on_utilities.g_on_parameters(16)||''||icx_on_utilities.g_on_parameters(17)||''||icx_on_utilities.g_on_parameters(18)||''||icx_on_utilities.g_on_parameters(19)||'*'||icx_on_utilities.g_on_parameters(20)

894:
895: l_Y := 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)
896: ||'*'||icx_on_utilities.g_on_parameters(6)||'*'||icx_on_utilities.g_on_parameters(7)||'*'||l_region_code||'*'||'*'||icx_on_utilities.g_on_parameters(10)
897: ||'*'||icx_on_utilities.g_on_parameters(11)||'*'||icx_on_utilities.g_on_parameters(12)||'*'||icx_on_utilities.g_on_parameters(13)||'*'||icx_on_utilities.g_on_parameters(14)||'*'||icx_on_utilities.g_on_parameters(15)
898: ||'*'||icx_on_utilities.g_on_parameters(16)||'*'||icx_on_utilities.g_on_parameters(17)||'*'||icx_on_utilities.g_on_parameters(18)||'*'||icx_on_utilities.g_on_parameters(19)||'*'||icx_on_utilities.g_on_parameters(20)
899: ||'*'||icx_on_utilities.g_on_parameters(21)||'**]';
900:
901: if l_total_result_count > 5
902: then

Line 899: ||'*'||icx_on_utilities.g_on_parameters(21)||'**]';

895: l_Y := 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)
896: ||'*'||icx_on_utilities.g_on_parameters(6)||'*'||icx_on_utilities.g_on_parameters(7)||'*'||l_region_code||'*'||'*'||icx_on_utilities.g_on_parameters(10)
897: ||'*'||icx_on_utilities.g_on_parameters(11)||'*'||icx_on_utilities.g_on_parameters(12)||'*'||icx_on_utilities.g_on_parameters(13)||'*'||icx_on_utilities.g_on_parameters(14)||'*'||icx_on_utilities.g_on_parameters(15)
898: ||'*'||icx_on_utilities.g_on_parameters(16)||'*'||icx_on_utilities.g_on_parameters(17)||'*'||icx_on_utilities.g_on_parameters(18)||'*'||icx_on_utilities.g_on_parameters(19)||'*'||icx_on_utilities.g_on_parameters(20)
899: ||'*'||icx_on_utilities.g_on_parameters(21)||'**]';
900:
901: if l_total_result_count > 5
902: then
903:

Line 904: icx_on_utilities2.displaySetIcons(l_language_code,icx_cabo.g_plsql_agent||'OracleON.IC',l_start_row,l_stop_row,icx_on_utilities.g_on_parameters(9),l_query_set,l_total_result_count,TRUE,'',icx_call.encrypt2(l_Y),l_update);

900:
901: if l_total_result_count > 5
902: then
903:
904: icx_on_utilities2.displaySetIcons(l_language_code,icx_cabo.g_plsql_agent||'OracleON.IC',l_start_row,l_stop_row,icx_on_utilities.g_on_parameters(9),l_query_set,l_total_result_count,TRUE,'',icx_call.encrypt2(l_Y),l_update);
905:
906: end if;
907:
908: htp.tableOpen(cborder => 'BORDER=2', cattributes => 'CELLPADDING=2');

Line 1089: ||icx_on_utilities.formatText(l_values(l_value_id(i)),ak_query_pkg.g_items_table(i).bold,ak_query_pkg.g_items_table(i).italic)

1085: '',
1086: l_rowspan);
1087: else
1088: htp.tableData(cvalue => ''
1089: ||icx_on_utilities.formatText(l_values(l_value_id(i)),ak_query_pkg.g_items_table(i).bold,ak_query_pkg.g_items_table(i).italic)
1090: ||'', calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"', crowspan => l_rowspan);
1091: end if;
1092: else
1093: printText( ak_query_pkg.g_items_table(i),

Line 1161: icx_on_utilities2.displaySetIcons(l_language_code,icx_cabo.g_plsql_agent||'OracleON.IC',l_start_row,l_stop_row,icx_on_utilities.g_on_parameters(9),l_query_set,l_total_result_count,FALSE,'',icx_call.encrypt2(l_Y),l_update);

1157:
1158: if l_total_result_count > 5
1159: then
1160:
1161: icx_on_utilities2.displaySetIcons(l_language_code,icx_cabo.g_plsql_agent||'OracleON.IC',l_start_row,l_stop_row,icx_on_utilities.g_on_parameters(9),l_query_set,l_total_result_count,FALSE,'',icx_call.encrypt2(l_Y),l_update);
1162:
1163: end if;
1164:
1165: elsif l_region_style = 'FORM'

Line 1338: ||icx_on_utilities.formatText(l_values(l_value_id(i)),'Y',ak_query_pkg.g_items_table(i).italic)

1334: else
1335: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');
1336: htp.tableData(' ');
1337: htp.tableData(cvalue => ''
1338: ||icx_on_utilities.formatText(l_values(l_value_id(i)),'Y',ak_query_pkg.g_items_table(i).italic)
1339: ||'', calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"', crowspan => l_rowspan);
1340: end if;
1341: else
1342: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long,'RIGHT','','','','','VALIGN=MIDDLE');

Line 1537: end icx_on_utilities2;

1533: end if;
1534:
1535: end;
1536:
1537: end icx_on_utilities2;