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_UTILITIES dependencies on ICX_ON

Line 1: package body icx_on_utilities as

1: package body icx_on_utilities as
2: /* $Header: ICXONUB.pls 120.1 2005/10/07 13:45:07 gjimenez noship $ */
3:
4: procedure findPage(p_flow_appl_id in number,
5: p_flow_code in varchar2,

Line 196: l_flex_definition icx_on_utilities.v80_table;

192: l_region_code varchar2(30);
193: l_data_type varchar2(1);
194: l_data_type1 varchar2(1);
195: l_column_name varchar2(30);
196: l_flex_definition icx_on_utilities.v80_table;
197: l_segment_column varchar2(30);
198: l_context_column varchar2(40);
199: c_attributes v2000_table;
200: c_condition v2000_table;

Line 295: icx_on_utilities.unpack_parameters(f.icx_custom_call,l_flex_definition);

291: l_data_type1 := l_data_type;
292: end if;
293: if substr(nvl(f.icx_custom_call,'XXXX'),1,4) = 'FLEX'
294: then
295: icx_on_utilities.unpack_parameters(f.icx_custom_call,l_flex_definition);
296: if fnd_flex_apis.get_segment_column
297: (x_application_id => l_flex_definition(2),
298: x_id_flex_code => l_flex_definition(3),
299: x_id_flex_num => l_flex_definition(4),

Line 867: htp.p(i||' = '||nvl(icx_on_utilities.g_on_parameters(i),'NULL'));

863: -- select HSECS into l_timer from v$timer;htp.p('begin getRegions @ '||l_timer);htp.nl;
864:
865: /*
866: for i in 1..22 loop
867: htp.p(i||' = '||nvl(icx_on_utilities.g_on_parameters(i),'NULL'));
868: htp.nl;
869: end loop;
870: */
871:

Line 872: c_type := icx_on_utilities.g_on_parameters(1);

868: htp.nl;
869: end loop;
870: */
871:
872: c_type := icx_on_utilities.g_on_parameters(1);
873:
874: c_continue := TRUE;
875: c_table_count := 1;
876:

Line 880: l_flow_appl_id := icx_on_utilities.g_on_parameters(2);

876:
877: if c_type = 'DQ'
878: then
879:
880: l_flow_appl_id := icx_on_utilities.g_on_parameters(2);
881: l_flow_code := icx_on_utilities.g_on_parameters(3);
882: c_to_page_appl_id := icx_on_utilities.g_on_parameters(4);
883: c_to_page_code := icx_on_utilities.g_on_parameters(5);
884: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);

Line 881: l_flow_code := icx_on_utilities.g_on_parameters(3);

877: if c_type = 'DQ'
878: then
879:
880: l_flow_appl_id := icx_on_utilities.g_on_parameters(2);
881: l_flow_code := icx_on_utilities.g_on_parameters(3);
882: c_to_page_appl_id := icx_on_utilities.g_on_parameters(4);
883: c_to_page_code := icx_on_utilities.g_on_parameters(5);
884: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);
885: l_end := icx_on_utilities.g_on_parameters(7);

Line 882: c_to_page_appl_id := icx_on_utilities.g_on_parameters(4);

878: then
879:
880: l_flow_appl_id := icx_on_utilities.g_on_parameters(2);
881: l_flow_code := icx_on_utilities.g_on_parameters(3);
882: c_to_page_appl_id := icx_on_utilities.g_on_parameters(4);
883: c_to_page_code := icx_on_utilities.g_on_parameters(5);
884: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);
885: l_end := icx_on_utilities.g_on_parameters(7);
886: l_start_region := icx_on_utilities.g_on_parameters(8);

Line 883: c_to_page_code := icx_on_utilities.g_on_parameters(5);

879:
880: l_flow_appl_id := icx_on_utilities.g_on_parameters(2);
881: l_flow_code := icx_on_utilities.g_on_parameters(3);
882: c_to_page_appl_id := icx_on_utilities.g_on_parameters(4);
883: c_to_page_code := icx_on_utilities.g_on_parameters(5);
884: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);
885: l_end := icx_on_utilities.g_on_parameters(7);
886: l_start_region := icx_on_utilities.g_on_parameters(8);
887: c_encrypted_where := icx_on_utilities.g_on_parameters(9);

Line 884: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);

880: l_flow_appl_id := icx_on_utilities.g_on_parameters(2);
881: l_flow_code := icx_on_utilities.g_on_parameters(3);
882: c_to_page_appl_id := icx_on_utilities.g_on_parameters(4);
883: c_to_page_code := icx_on_utilities.g_on_parameters(5);
884: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);
885: l_end := icx_on_utilities.g_on_parameters(7);
886: l_start_region := icx_on_utilities.g_on_parameters(8);
887: c_encrypted_where := icx_on_utilities.g_on_parameters(9);
888:

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

881: l_flow_code := icx_on_utilities.g_on_parameters(3);
882: c_to_page_appl_id := icx_on_utilities.g_on_parameters(4);
883: c_to_page_code := icx_on_utilities.g_on_parameters(5);
884: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);
885: l_end := icx_on_utilities.g_on_parameters(7);
886: l_start_region := icx_on_utilities.g_on_parameters(8);
887: c_encrypted_where := icx_on_utilities.g_on_parameters(9);
888:
889: elsif c_type = 'W'

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

882: c_to_page_appl_id := icx_on_utilities.g_on_parameters(4);
883: c_to_page_code := icx_on_utilities.g_on_parameters(5);
884: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);
885: l_end := icx_on_utilities.g_on_parameters(7);
886: l_start_region := icx_on_utilities.g_on_parameters(8);
887: c_encrypted_where := icx_on_utilities.g_on_parameters(9);
888:
889: elsif c_type = 'W'
890: then

Line 887: c_encrypted_where := icx_on_utilities.g_on_parameters(9);

883: c_to_page_code := icx_on_utilities.g_on_parameters(5);
884: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);
885: l_end := icx_on_utilities.g_on_parameters(7);
886: l_start_region := icx_on_utilities.g_on_parameters(8);
887: c_encrypted_where := icx_on_utilities.g_on_parameters(9);
888:
889: elsif c_type = 'W'
890: then
891:

Line 892: l_flow_appl_id := icx_on_utilities.g_on_parameters(2);

888:
889: elsif c_type = 'W'
890: then
891:
892: l_flow_appl_id := icx_on_utilities.g_on_parameters(2);
893: l_flow_code := icx_on_utilities.g_on_parameters(3);
894: c_to_page_appl_id := icx_on_utilities.g_on_parameters(4);
895: c_to_page_code := icx_on_utilities.g_on_parameters(5);
896: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);

Line 893: l_flow_code := icx_on_utilities.g_on_parameters(3);

889: elsif c_type = 'W'
890: then
891:
892: l_flow_appl_id := icx_on_utilities.g_on_parameters(2);
893: l_flow_code := icx_on_utilities.g_on_parameters(3);
894: c_to_page_appl_id := icx_on_utilities.g_on_parameters(4);
895: c_to_page_code := icx_on_utilities.g_on_parameters(5);
896: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);
897: l_end := icx_on_utilities.g_on_parameters(7);

Line 894: c_to_page_appl_id := icx_on_utilities.g_on_parameters(4);

890: then
891:
892: l_flow_appl_id := icx_on_utilities.g_on_parameters(2);
893: l_flow_code := icx_on_utilities.g_on_parameters(3);
894: c_to_page_appl_id := icx_on_utilities.g_on_parameters(4);
895: c_to_page_code := icx_on_utilities.g_on_parameters(5);
896: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);
897: l_end := icx_on_utilities.g_on_parameters(7);
898: l_start_region := icx_on_utilities.g_on_parameters(8);

Line 895: c_to_page_code := icx_on_utilities.g_on_parameters(5);

891:
892: l_flow_appl_id := icx_on_utilities.g_on_parameters(2);
893: l_flow_code := icx_on_utilities.g_on_parameters(3);
894: c_to_page_appl_id := icx_on_utilities.g_on_parameters(4);
895: c_to_page_code := icx_on_utilities.g_on_parameters(5);
896: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);
897: l_end := icx_on_utilities.g_on_parameters(7);
898: l_start_region := icx_on_utilities.g_on_parameters(8);
899: c_encrypted_where := icx_on_utilities.g_on_parameters(9);

Line 896: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);

892: l_flow_appl_id := icx_on_utilities.g_on_parameters(2);
893: l_flow_code := icx_on_utilities.g_on_parameters(3);
894: c_to_page_appl_id := icx_on_utilities.g_on_parameters(4);
895: c_to_page_code := icx_on_utilities.g_on_parameters(5);
896: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);
897: l_end := icx_on_utilities.g_on_parameters(7);
898: l_start_region := icx_on_utilities.g_on_parameters(8);
899: c_encrypted_where := icx_on_utilities.g_on_parameters(9);
900:

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

893: l_flow_code := icx_on_utilities.g_on_parameters(3);
894: c_to_page_appl_id := icx_on_utilities.g_on_parameters(4);
895: c_to_page_code := icx_on_utilities.g_on_parameters(5);
896: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);
897: l_end := icx_on_utilities.g_on_parameters(7);
898: l_start_region := icx_on_utilities.g_on_parameters(8);
899: c_encrypted_where := icx_on_utilities.g_on_parameters(9);
900:
901: else

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

894: c_to_page_appl_id := icx_on_utilities.g_on_parameters(4);
895: c_to_page_code := icx_on_utilities.g_on_parameters(5);
896: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);
897: l_end := icx_on_utilities.g_on_parameters(7);
898: l_start_region := icx_on_utilities.g_on_parameters(8);
899: c_encrypted_where := icx_on_utilities.g_on_parameters(9);
900:
901: else
902:

Line 899: c_encrypted_where := icx_on_utilities.g_on_parameters(9);

895: c_to_page_code := icx_on_utilities.g_on_parameters(5);
896: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);
897: l_end := icx_on_utilities.g_on_parameters(7);
898: l_start_region := icx_on_utilities.g_on_parameters(8);
899: c_encrypted_where := icx_on_utilities.g_on_parameters(9);
900:
901: else
902:
903: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);

Line 903: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);

899: c_encrypted_where := icx_on_utilities.g_on_parameters(9);
900:
901: else
902:
903: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);
904: l_end := icx_on_utilities.g_on_parameters(7);
905: l_start_region := icx_on_utilities.g_on_parameters(8);
906: c_rowid := icx_on_utilities.g_on_parameters(10);
907: c_unique_key_name := icx_on_utilities.g_on_parameters(11);

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

900:
901: else
902:
903: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);
904: l_end := icx_on_utilities.g_on_parameters(7);
905: l_start_region := icx_on_utilities.g_on_parameters(8);
906: c_rowid := icx_on_utilities.g_on_parameters(10);
907: c_unique_key_name := icx_on_utilities.g_on_parameters(11);
908: c_keys(1) := icx_on_utilities.g_on_parameters(12);

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

901: else
902:
903: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);
904: l_end := icx_on_utilities.g_on_parameters(7);
905: l_start_region := icx_on_utilities.g_on_parameters(8);
906: c_rowid := icx_on_utilities.g_on_parameters(10);
907: c_unique_key_name := icx_on_utilities.g_on_parameters(11);
908: c_keys(1) := icx_on_utilities.g_on_parameters(12);
909: c_keys(2) := icx_on_utilities.g_on_parameters(13);

Line 906: c_rowid := icx_on_utilities.g_on_parameters(10);

902:
903: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);
904: l_end := icx_on_utilities.g_on_parameters(7);
905: l_start_region := icx_on_utilities.g_on_parameters(8);
906: c_rowid := icx_on_utilities.g_on_parameters(10);
907: c_unique_key_name := icx_on_utilities.g_on_parameters(11);
908: c_keys(1) := icx_on_utilities.g_on_parameters(12);
909: c_keys(2) := icx_on_utilities.g_on_parameters(13);
910: c_keys(3) := icx_on_utilities.g_on_parameters(14);

Line 907: c_unique_key_name := icx_on_utilities.g_on_parameters(11);

903: l_start := nvl(icx_on_utilities.g_on_parameters(6),1);
904: l_end := icx_on_utilities.g_on_parameters(7);
905: l_start_region := icx_on_utilities.g_on_parameters(8);
906: c_rowid := icx_on_utilities.g_on_parameters(10);
907: c_unique_key_name := icx_on_utilities.g_on_parameters(11);
908: c_keys(1) := icx_on_utilities.g_on_parameters(12);
909: c_keys(2) := icx_on_utilities.g_on_parameters(13);
910: c_keys(3) := icx_on_utilities.g_on_parameters(14);
911: c_keys(4) := icx_on_utilities.g_on_parameters(15);

Line 908: c_keys(1) := icx_on_utilities.g_on_parameters(12);

904: l_end := icx_on_utilities.g_on_parameters(7);
905: l_start_region := icx_on_utilities.g_on_parameters(8);
906: c_rowid := icx_on_utilities.g_on_parameters(10);
907: c_unique_key_name := icx_on_utilities.g_on_parameters(11);
908: c_keys(1) := icx_on_utilities.g_on_parameters(12);
909: c_keys(2) := icx_on_utilities.g_on_parameters(13);
910: c_keys(3) := icx_on_utilities.g_on_parameters(14);
911: c_keys(4) := icx_on_utilities.g_on_parameters(15);
912: c_keys(5) := icx_on_utilities.g_on_parameters(16);

Line 909: c_keys(2) := icx_on_utilities.g_on_parameters(13);

905: l_start_region := icx_on_utilities.g_on_parameters(8);
906: c_rowid := icx_on_utilities.g_on_parameters(10);
907: c_unique_key_name := icx_on_utilities.g_on_parameters(11);
908: c_keys(1) := icx_on_utilities.g_on_parameters(12);
909: c_keys(2) := icx_on_utilities.g_on_parameters(13);
910: c_keys(3) := icx_on_utilities.g_on_parameters(14);
911: c_keys(4) := icx_on_utilities.g_on_parameters(15);
912: c_keys(5) := icx_on_utilities.g_on_parameters(16);
913: c_keys(6) := icx_on_utilities.g_on_parameters(17);

Line 910: c_keys(3) := icx_on_utilities.g_on_parameters(14);

906: c_rowid := icx_on_utilities.g_on_parameters(10);
907: c_unique_key_name := icx_on_utilities.g_on_parameters(11);
908: c_keys(1) := icx_on_utilities.g_on_parameters(12);
909: c_keys(2) := icx_on_utilities.g_on_parameters(13);
910: c_keys(3) := icx_on_utilities.g_on_parameters(14);
911: c_keys(4) := icx_on_utilities.g_on_parameters(15);
912: c_keys(5) := icx_on_utilities.g_on_parameters(16);
913: c_keys(6) := icx_on_utilities.g_on_parameters(17);
914: c_keys(7) := icx_on_utilities.g_on_parameters(18);

Line 911: c_keys(4) := icx_on_utilities.g_on_parameters(15);

907: c_unique_key_name := icx_on_utilities.g_on_parameters(11);
908: c_keys(1) := icx_on_utilities.g_on_parameters(12);
909: c_keys(2) := icx_on_utilities.g_on_parameters(13);
910: c_keys(3) := icx_on_utilities.g_on_parameters(14);
911: c_keys(4) := icx_on_utilities.g_on_parameters(15);
912: c_keys(5) := icx_on_utilities.g_on_parameters(16);
913: c_keys(6) := icx_on_utilities.g_on_parameters(17);
914: c_keys(7) := icx_on_utilities.g_on_parameters(18);
915: c_keys(8) := icx_on_utilities.g_on_parameters(19);

Line 912: c_keys(5) := icx_on_utilities.g_on_parameters(16);

908: c_keys(1) := icx_on_utilities.g_on_parameters(12);
909: c_keys(2) := icx_on_utilities.g_on_parameters(13);
910: c_keys(3) := icx_on_utilities.g_on_parameters(14);
911: c_keys(4) := icx_on_utilities.g_on_parameters(15);
912: c_keys(5) := icx_on_utilities.g_on_parameters(16);
913: c_keys(6) := icx_on_utilities.g_on_parameters(17);
914: c_keys(7) := icx_on_utilities.g_on_parameters(18);
915: c_keys(8) := icx_on_utilities.g_on_parameters(19);
916: c_keys(9) := icx_on_utilities.g_on_parameters(20);

Line 913: c_keys(6) := icx_on_utilities.g_on_parameters(17);

909: c_keys(2) := icx_on_utilities.g_on_parameters(13);
910: c_keys(3) := icx_on_utilities.g_on_parameters(14);
911: c_keys(4) := icx_on_utilities.g_on_parameters(15);
912: c_keys(5) := icx_on_utilities.g_on_parameters(16);
913: c_keys(6) := icx_on_utilities.g_on_parameters(17);
914: c_keys(7) := icx_on_utilities.g_on_parameters(18);
915: c_keys(8) := icx_on_utilities.g_on_parameters(19);
916: c_keys(9) := icx_on_utilities.g_on_parameters(20);
917: c_keys(10) := icx_on_utilities.g_on_parameters(21);

Line 914: c_keys(7) := icx_on_utilities.g_on_parameters(18);

910: c_keys(3) := icx_on_utilities.g_on_parameters(14);
911: c_keys(4) := icx_on_utilities.g_on_parameters(15);
912: c_keys(5) := icx_on_utilities.g_on_parameters(16);
913: c_keys(6) := icx_on_utilities.g_on_parameters(17);
914: c_keys(7) := icx_on_utilities.g_on_parameters(18);
915: c_keys(8) := icx_on_utilities.g_on_parameters(19);
916: c_keys(9) := icx_on_utilities.g_on_parameters(20);
917: c_keys(10) := icx_on_utilities.g_on_parameters(21);
918:

Line 915: c_keys(8) := icx_on_utilities.g_on_parameters(19);

911: c_keys(4) := icx_on_utilities.g_on_parameters(15);
912: c_keys(5) := icx_on_utilities.g_on_parameters(16);
913: c_keys(6) := icx_on_utilities.g_on_parameters(17);
914: c_keys(7) := icx_on_utilities.g_on_parameters(18);
915: c_keys(8) := icx_on_utilities.g_on_parameters(19);
916: c_keys(9) := icx_on_utilities.g_on_parameters(20);
917: c_keys(10) := icx_on_utilities.g_on_parameters(21);
918:
919: select FLOW_APPLICATION_ID,FLOW_CODE,

Line 916: c_keys(9) := icx_on_utilities.g_on_parameters(20);

912: c_keys(5) := icx_on_utilities.g_on_parameters(16);
913: c_keys(6) := icx_on_utilities.g_on_parameters(17);
914: c_keys(7) := icx_on_utilities.g_on_parameters(18);
915: c_keys(8) := icx_on_utilities.g_on_parameters(19);
916: c_keys(9) := icx_on_utilities.g_on_parameters(20);
917: c_keys(10) := icx_on_utilities.g_on_parameters(21);
918:
919: select FLOW_APPLICATION_ID,FLOW_CODE,
920: TO_PAGE_APPL_ID,TO_PAGE_CODE

Line 917: c_keys(10) := icx_on_utilities.g_on_parameters(21);

913: c_keys(6) := icx_on_utilities.g_on_parameters(17);
914: c_keys(7) := icx_on_utilities.g_on_parameters(18);
915: c_keys(8) := icx_on_utilities.g_on_parameters(19);
916: c_keys(9) := icx_on_utilities.g_on_parameters(20);
917: c_keys(10) := icx_on_utilities.g_on_parameters(21);
918:
919: select FLOW_APPLICATION_ID,FLOW_CODE,
920: TO_PAGE_APPL_ID,TO_PAGE_CODE
921: into l_flow_appl_id,l_flow_code,

Line 1121: -- icx_on_utilities2.printPLSQLtables;

1117: then
1118: raise e_max_rows;
1119: end if;
1120:
1121: -- icx_on_utilities2.printPLSQLtables;
1122:
1123: -- dbms_session.set_sql_trace(FALSE);
1124:
1125: -- select HSECS into l_timer from v$timer;htp.p('end exec_query LOV @ '||l_timer);htp.nl;

Line 1183: -- icx_on_utilities2.printPLSQLtables;

1179: P_RETURN_PARENTS => 'F',
1180: P_RETURN_CHILDREN => 'T',
1181: P_RETURN_NODE_DISPLAY_ONLY => 'T');
1182:
1183: -- icx_on_utilities2.printPLSQLtables;
1184:
1185: -- dbms_session.set_sql_trace(FALSE);
1186:
1187: -- select HSECS into l_timer from v$timer;htp.p('start exec_query PK @ '||l_timer);htp.nl;

Line 1249: if icx_on_utilities.g_on_parameters(22) = 'Y'

1245: and FLOW_APPLICATION_ID = l_flow_appl_id;
1246:
1247: l_cookie := owa_cookie.get('onquery');
1248:
1249: if icx_on_utilities.g_on_parameters(22) = 'Y'
1250: then
1251: htp.htmlOpen;
1252: htp.headOpen;
1253: icx_util.copyright;

Line 1274: l_S := 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)

1270: htp.p('// -->');
1271: htp.p('');
1272: end if;
1273:
1274: l_S := 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)
1275: ||'*'||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)
1276: ||'*'||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)
1277: ||'*'||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)
1278: ||'*'||icx_on_utilities.g_on_parameters(21)||'*'||icx_on_utilities.g_on_parameters(22)||'**]';

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

1271: htp.p('');
1272: end if;
1273:
1274: l_S := 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)
1275: ||'*'||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)
1276: ||'*'||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)
1277: ||'*'||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)
1278: ||'*'||icx_on_utilities.g_on_parameters(21)||'*'||icx_on_utilities.g_on_parameters(22)||'**]';
1279:

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

1272: end if;
1273:
1274: l_S := 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)
1275: ||'*'||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)
1276: ||'*'||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)
1277: ||'*'||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)
1278: ||'*'||icx_on_utilities.g_on_parameters(21)||'*'||icx_on_utilities.g_on_parameters(22)||'**]';
1279:
1280: if icx_on_utilities.g_on_parameters(22) = 'Y'

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

1273:
1274: l_S := 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)
1275: ||'*'||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)
1276: ||'*'||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)
1277: ||'*'||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)
1278: ||'*'||icx_on_utilities.g_on_parameters(21)||'*'||icx_on_utilities.g_on_parameters(22)||'**]';
1279:
1280: if icx_on_utilities.g_on_parameters(22) = 'Y'
1281: then

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

1274: l_S := 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)
1275: ||'*'||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)
1276: ||'*'||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)
1277: ||'*'||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)
1278: ||'*'||icx_on_utilities.g_on_parameters(21)||'*'||icx_on_utilities.g_on_parameters(22)||'**]';
1279:
1280: if icx_on_utilities.g_on_parameters(22) = 'Y'
1281: then
1282: if (l_cookie.num_vals > 0) then

Line 1280: if icx_on_utilities.g_on_parameters(22) = 'Y'

1276: ||'*'||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)
1277: ||'*'||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)
1278: ||'*'||icx_on_utilities.g_on_parameters(21)||'*'||icx_on_utilities.g_on_parameters(22)||'**]';
1279:
1280: if icx_on_utilities.g_on_parameters(22) = 'Y'
1281: then
1282: if (l_cookie.num_vals > 0) then
1283: icx_admin_sig.toolbar(language_code => l_language_code,
1284: disp_export => l_S,

Line 1379: icx_on_utilities2.displayRegion(ak_query_pkg.g_regions_table(r).region_rec_id);

1375:
1376: htp.strong(l_message);
1377: l_continue := FALSE;
1378: else
1379: icx_on_utilities2.displayRegion(ak_query_pkg.g_regions_table(r).region_rec_id);
1380: end if; -- total_result_count = 0
1381: end if; -- l_continue
1382: end if; -- display_sequence
1383:

Line 1389: if icx_on_utilities.g_on_parameters(22) = 'Y'

1385: end loop; -- regions c
1386:
1387: end if; -- COUNT = 0
1388:
1389: if icx_on_utilities.g_on_parameters(22) = 'Y'
1390: then
1391: icx_sig.footer;
1392: htp.htmlClose;
1393: end if;

Line 2191: l_dummy_table icx_on_utilities.v80_table;

2187: p7 in varchar2,
2188: p8 in varchar2,
2189: p9 in varchar2,
2190: p10 in varchar2) is
2191: l_dummy_table icx_on_utilities.v80_table;
2192: begin
2193:
2194: icx_on_utilities.g_on_parameters(1) := 'X';
2195: icx_on_utilities.g_on_parameters(2) := '';

Line 2194: icx_on_utilities.g_on_parameters(1) := 'X';

2190: p10 in varchar2) is
2191: l_dummy_table icx_on_utilities.v80_table;
2192: begin
2193:
2194: icx_on_utilities.g_on_parameters(1) := 'X';
2195: icx_on_utilities.g_on_parameters(2) := '';
2196: icx_on_utilities.g_on_parameters(3) := '';
2197: icx_on_utilities.g_on_parameters(4) := '';
2198: icx_on_utilities.g_on_parameters(5) := '';

Line 2195: icx_on_utilities.g_on_parameters(2) := '';

2191: l_dummy_table icx_on_utilities.v80_table;
2192: begin
2193:
2194: icx_on_utilities.g_on_parameters(1) := 'X';
2195: icx_on_utilities.g_on_parameters(2) := '';
2196: icx_on_utilities.g_on_parameters(3) := '';
2197: icx_on_utilities.g_on_parameters(4) := '';
2198: icx_on_utilities.g_on_parameters(5) := '';
2199: icx_on_utilities.g_on_parameters(6) := '1';

Line 2196: icx_on_utilities.g_on_parameters(3) := '';

2192: begin
2193:
2194: icx_on_utilities.g_on_parameters(1) := 'X';
2195: icx_on_utilities.g_on_parameters(2) := '';
2196: icx_on_utilities.g_on_parameters(3) := '';
2197: icx_on_utilities.g_on_parameters(4) := '';
2198: icx_on_utilities.g_on_parameters(5) := '';
2199: icx_on_utilities.g_on_parameters(6) := '1';
2200: icx_on_utilities.g_on_parameters(7) := '';

Line 2197: icx_on_utilities.g_on_parameters(4) := '';

2193:
2194: icx_on_utilities.g_on_parameters(1) := 'X';
2195: icx_on_utilities.g_on_parameters(2) := '';
2196: icx_on_utilities.g_on_parameters(3) := '';
2197: icx_on_utilities.g_on_parameters(4) := '';
2198: icx_on_utilities.g_on_parameters(5) := '';
2199: icx_on_utilities.g_on_parameters(6) := '1';
2200: icx_on_utilities.g_on_parameters(7) := '';
2201: icx_on_utilities.g_on_parameters(8) := '';

Line 2198: icx_on_utilities.g_on_parameters(5) := '';

2194: icx_on_utilities.g_on_parameters(1) := 'X';
2195: icx_on_utilities.g_on_parameters(2) := '';
2196: icx_on_utilities.g_on_parameters(3) := '';
2197: icx_on_utilities.g_on_parameters(4) := '';
2198: icx_on_utilities.g_on_parameters(5) := '';
2199: icx_on_utilities.g_on_parameters(6) := '1';
2200: icx_on_utilities.g_on_parameters(7) := '';
2201: icx_on_utilities.g_on_parameters(8) := '';
2202: icx_on_utilities.g_on_parameters(9) := '';

Line 2199: icx_on_utilities.g_on_parameters(6) := '1';

2195: icx_on_utilities.g_on_parameters(2) := '';
2196: icx_on_utilities.g_on_parameters(3) := '';
2197: icx_on_utilities.g_on_parameters(4) := '';
2198: icx_on_utilities.g_on_parameters(5) := '';
2199: icx_on_utilities.g_on_parameters(6) := '1';
2200: icx_on_utilities.g_on_parameters(7) := '';
2201: icx_on_utilities.g_on_parameters(8) := '';
2202: icx_on_utilities.g_on_parameters(9) := '';
2203: icx_on_utilities.g_on_parameters(10) := p_rowid;

Line 2200: icx_on_utilities.g_on_parameters(7) := '';

2196: icx_on_utilities.g_on_parameters(3) := '';
2197: icx_on_utilities.g_on_parameters(4) := '';
2198: icx_on_utilities.g_on_parameters(5) := '';
2199: icx_on_utilities.g_on_parameters(6) := '1';
2200: icx_on_utilities.g_on_parameters(7) := '';
2201: icx_on_utilities.g_on_parameters(8) := '';
2202: icx_on_utilities.g_on_parameters(9) := '';
2203: icx_on_utilities.g_on_parameters(10) := p_rowid;
2204: icx_on_utilities.g_on_parameters(11) := p_primary_key;

Line 2201: icx_on_utilities.g_on_parameters(8) := '';

2197: icx_on_utilities.g_on_parameters(4) := '';
2198: icx_on_utilities.g_on_parameters(5) := '';
2199: icx_on_utilities.g_on_parameters(6) := '1';
2200: icx_on_utilities.g_on_parameters(7) := '';
2201: icx_on_utilities.g_on_parameters(8) := '';
2202: icx_on_utilities.g_on_parameters(9) := '';
2203: icx_on_utilities.g_on_parameters(10) := p_rowid;
2204: icx_on_utilities.g_on_parameters(11) := p_primary_key;
2205: icx_on_utilities.g_on_parameters(12) := p1;

Line 2202: icx_on_utilities.g_on_parameters(9) := '';

2198: icx_on_utilities.g_on_parameters(5) := '';
2199: icx_on_utilities.g_on_parameters(6) := '1';
2200: icx_on_utilities.g_on_parameters(7) := '';
2201: icx_on_utilities.g_on_parameters(8) := '';
2202: icx_on_utilities.g_on_parameters(9) := '';
2203: icx_on_utilities.g_on_parameters(10) := p_rowid;
2204: icx_on_utilities.g_on_parameters(11) := p_primary_key;
2205: icx_on_utilities.g_on_parameters(12) := p1;
2206: icx_on_utilities.g_on_parameters(13) := p2;

Line 2203: icx_on_utilities.g_on_parameters(10) := p_rowid;

2199: icx_on_utilities.g_on_parameters(6) := '1';
2200: icx_on_utilities.g_on_parameters(7) := '';
2201: icx_on_utilities.g_on_parameters(8) := '';
2202: icx_on_utilities.g_on_parameters(9) := '';
2203: icx_on_utilities.g_on_parameters(10) := p_rowid;
2204: icx_on_utilities.g_on_parameters(11) := p_primary_key;
2205: icx_on_utilities.g_on_parameters(12) := p1;
2206: icx_on_utilities.g_on_parameters(13) := p2;
2207: icx_on_utilities.g_on_parameters(14) := p3;

Line 2204: icx_on_utilities.g_on_parameters(11) := p_primary_key;

2200: icx_on_utilities.g_on_parameters(7) := '';
2201: icx_on_utilities.g_on_parameters(8) := '';
2202: icx_on_utilities.g_on_parameters(9) := '';
2203: icx_on_utilities.g_on_parameters(10) := p_rowid;
2204: icx_on_utilities.g_on_parameters(11) := p_primary_key;
2205: icx_on_utilities.g_on_parameters(12) := p1;
2206: icx_on_utilities.g_on_parameters(13) := p2;
2207: icx_on_utilities.g_on_parameters(14) := p3;
2208: icx_on_utilities.g_on_parameters(15) := p4;

Line 2205: icx_on_utilities.g_on_parameters(12) := p1;

2201: icx_on_utilities.g_on_parameters(8) := '';
2202: icx_on_utilities.g_on_parameters(9) := '';
2203: icx_on_utilities.g_on_parameters(10) := p_rowid;
2204: icx_on_utilities.g_on_parameters(11) := p_primary_key;
2205: icx_on_utilities.g_on_parameters(12) := p1;
2206: icx_on_utilities.g_on_parameters(13) := p2;
2207: icx_on_utilities.g_on_parameters(14) := p3;
2208: icx_on_utilities.g_on_parameters(15) := p4;
2209: icx_on_utilities.g_on_parameters(16) := p5;

Line 2206: icx_on_utilities.g_on_parameters(13) := p2;

2202: icx_on_utilities.g_on_parameters(9) := '';
2203: icx_on_utilities.g_on_parameters(10) := p_rowid;
2204: icx_on_utilities.g_on_parameters(11) := p_primary_key;
2205: icx_on_utilities.g_on_parameters(12) := p1;
2206: icx_on_utilities.g_on_parameters(13) := p2;
2207: icx_on_utilities.g_on_parameters(14) := p3;
2208: icx_on_utilities.g_on_parameters(15) := p4;
2209: icx_on_utilities.g_on_parameters(16) := p5;
2210: icx_on_utilities.g_on_parameters(17) := p6;

Line 2207: icx_on_utilities.g_on_parameters(14) := p3;

2203: icx_on_utilities.g_on_parameters(10) := p_rowid;
2204: icx_on_utilities.g_on_parameters(11) := p_primary_key;
2205: icx_on_utilities.g_on_parameters(12) := p1;
2206: icx_on_utilities.g_on_parameters(13) := p2;
2207: icx_on_utilities.g_on_parameters(14) := p3;
2208: icx_on_utilities.g_on_parameters(15) := p4;
2209: icx_on_utilities.g_on_parameters(16) := p5;
2210: icx_on_utilities.g_on_parameters(17) := p6;
2211: icx_on_utilities.g_on_parameters(18) := p7;

Line 2208: icx_on_utilities.g_on_parameters(15) := p4;

2204: icx_on_utilities.g_on_parameters(11) := p_primary_key;
2205: icx_on_utilities.g_on_parameters(12) := p1;
2206: icx_on_utilities.g_on_parameters(13) := p2;
2207: icx_on_utilities.g_on_parameters(14) := p3;
2208: icx_on_utilities.g_on_parameters(15) := p4;
2209: icx_on_utilities.g_on_parameters(16) := p5;
2210: icx_on_utilities.g_on_parameters(17) := p6;
2211: icx_on_utilities.g_on_parameters(18) := p7;
2212: icx_on_utilities.g_on_parameters(19) := p8;

Line 2209: icx_on_utilities.g_on_parameters(16) := p5;

2205: icx_on_utilities.g_on_parameters(12) := p1;
2206: icx_on_utilities.g_on_parameters(13) := p2;
2207: icx_on_utilities.g_on_parameters(14) := p3;
2208: icx_on_utilities.g_on_parameters(15) := p4;
2209: icx_on_utilities.g_on_parameters(16) := p5;
2210: icx_on_utilities.g_on_parameters(17) := p6;
2211: icx_on_utilities.g_on_parameters(18) := p7;
2212: icx_on_utilities.g_on_parameters(19) := p8;
2213: icx_on_utilities.g_on_parameters(20) := p9;

Line 2210: icx_on_utilities.g_on_parameters(17) := p6;

2206: icx_on_utilities.g_on_parameters(13) := p2;
2207: icx_on_utilities.g_on_parameters(14) := p3;
2208: icx_on_utilities.g_on_parameters(15) := p4;
2209: icx_on_utilities.g_on_parameters(16) := p5;
2210: icx_on_utilities.g_on_parameters(17) := p6;
2211: icx_on_utilities.g_on_parameters(18) := p7;
2212: icx_on_utilities.g_on_parameters(19) := p8;
2213: icx_on_utilities.g_on_parameters(20) := p9;
2214: icx_on_utilities.g_on_parameters(21) := p10;

Line 2211: icx_on_utilities.g_on_parameters(18) := p7;

2207: icx_on_utilities.g_on_parameters(14) := p3;
2208: icx_on_utilities.g_on_parameters(15) := p4;
2209: icx_on_utilities.g_on_parameters(16) := p5;
2210: icx_on_utilities.g_on_parameters(17) := p6;
2211: icx_on_utilities.g_on_parameters(18) := p7;
2212: icx_on_utilities.g_on_parameters(19) := p8;
2213: icx_on_utilities.g_on_parameters(20) := p9;
2214: icx_on_utilities.g_on_parameters(21) := p10;
2215: icx_on_utilities.g_on_parameters(22) := 'N';

Line 2212: icx_on_utilities.g_on_parameters(19) := p8;

2208: icx_on_utilities.g_on_parameters(15) := p4;
2209: icx_on_utilities.g_on_parameters(16) := p5;
2210: icx_on_utilities.g_on_parameters(17) := p6;
2211: icx_on_utilities.g_on_parameters(18) := p7;
2212: icx_on_utilities.g_on_parameters(19) := p8;
2213: icx_on_utilities.g_on_parameters(20) := p9;
2214: icx_on_utilities.g_on_parameters(21) := p10;
2215: icx_on_utilities.g_on_parameters(22) := 'N';
2216:

Line 2213: icx_on_utilities.g_on_parameters(20) := p9;

2209: icx_on_utilities.g_on_parameters(16) := p5;
2210: icx_on_utilities.g_on_parameters(17) := p6;
2211: icx_on_utilities.g_on_parameters(18) := p7;
2212: icx_on_utilities.g_on_parameters(19) := p8;
2213: icx_on_utilities.g_on_parameters(20) := p9;
2214: icx_on_utilities.g_on_parameters(21) := p10;
2215: icx_on_utilities.g_on_parameters(22) := 'N';
2216:
2217: icx_on.get_page(l_dummy_table,l_dummy_table,l_dummy_table,'','');

Line 2214: icx_on_utilities.g_on_parameters(21) := p10;

2210: icx_on_utilities.g_on_parameters(17) := p6;
2211: icx_on_utilities.g_on_parameters(18) := p7;
2212: icx_on_utilities.g_on_parameters(19) := p8;
2213: icx_on_utilities.g_on_parameters(20) := p9;
2214: icx_on_utilities.g_on_parameters(21) := p10;
2215: icx_on_utilities.g_on_parameters(22) := 'N';
2216:
2217: icx_on.get_page(l_dummy_table,l_dummy_table,l_dummy_table,'','');
2218:

Line 2215: icx_on_utilities.g_on_parameters(22) := 'N';

2211: icx_on_utilities.g_on_parameters(18) := p7;
2212: icx_on_utilities.g_on_parameters(19) := p8;
2213: icx_on_utilities.g_on_parameters(20) := p9;
2214: icx_on_utilities.g_on_parameters(21) := p10;
2215: icx_on_utilities.g_on_parameters(22) := 'N';
2216:
2217: icx_on.get_page(l_dummy_table,l_dummy_table,l_dummy_table,'','');
2218:
2219: end;

Line 2217: icx_on.get_page(l_dummy_table,l_dummy_table,l_dummy_table,'','');

2213: icx_on_utilities.g_on_parameters(20) := p9;
2214: icx_on_utilities.g_on_parameters(21) := p10;
2215: icx_on_utilities.g_on_parameters(22) := 'N';
2216:
2217: icx_on.get_page(l_dummy_table,l_dummy_table,l_dummy_table,'','');
2218:
2219: end;
2220:
2221: procedure printRegions2(p_flow_application_id in varchar2,

Line 2226: l_dummy_table icx_on_utilities.v80_table;

2222: p_flow_code in varchar2,
2223: p_page_application_id in varchar2,
2224: p_page_code in varchar2,
2225: p_where_segment in varchar2) is
2226: l_dummy_table icx_on_utilities.v80_table;
2227: begin
2228:
2229: icx_on_utilities.g_on_parameters(1) := 'W';
2230: icx_on_utilities.g_on_parameters(2) := p_flow_application_id;

Line 2229: icx_on_utilities.g_on_parameters(1) := 'W';

2225: p_where_segment in varchar2) is
2226: l_dummy_table icx_on_utilities.v80_table;
2227: begin
2228:
2229: icx_on_utilities.g_on_parameters(1) := 'W';
2230: icx_on_utilities.g_on_parameters(2) := p_flow_application_id;
2231: icx_on_utilities.g_on_parameters(3) := p_flow_code;
2232: icx_on_utilities.g_on_parameters(4) := p_page_application_id;
2233: icx_on_utilities.g_on_parameters(5) := p_page_code;

Line 2230: icx_on_utilities.g_on_parameters(2) := p_flow_application_id;

2226: l_dummy_table icx_on_utilities.v80_table;
2227: begin
2228:
2229: icx_on_utilities.g_on_parameters(1) := 'W';
2230: icx_on_utilities.g_on_parameters(2) := p_flow_application_id;
2231: icx_on_utilities.g_on_parameters(3) := p_flow_code;
2232: icx_on_utilities.g_on_parameters(4) := p_page_application_id;
2233: icx_on_utilities.g_on_parameters(5) := p_page_code;
2234: icx_on_utilities.g_on_parameters(6) := p_where_segment;

Line 2231: icx_on_utilities.g_on_parameters(3) := p_flow_code;

2227: begin
2228:
2229: icx_on_utilities.g_on_parameters(1) := 'W';
2230: icx_on_utilities.g_on_parameters(2) := p_flow_application_id;
2231: icx_on_utilities.g_on_parameters(3) := p_flow_code;
2232: icx_on_utilities.g_on_parameters(4) := p_page_application_id;
2233: icx_on_utilities.g_on_parameters(5) := p_page_code;
2234: icx_on_utilities.g_on_parameters(6) := p_where_segment;
2235: icx_on_utilities.g_on_parameters(7) := '';

Line 2232: icx_on_utilities.g_on_parameters(4) := p_page_application_id;

2228:
2229: icx_on_utilities.g_on_parameters(1) := 'W';
2230: icx_on_utilities.g_on_parameters(2) := p_flow_application_id;
2231: icx_on_utilities.g_on_parameters(3) := p_flow_code;
2232: icx_on_utilities.g_on_parameters(4) := p_page_application_id;
2233: icx_on_utilities.g_on_parameters(5) := p_page_code;
2234: icx_on_utilities.g_on_parameters(6) := p_where_segment;
2235: icx_on_utilities.g_on_parameters(7) := '';
2236: icx_on_utilities.g_on_parameters(8) := '';

Line 2233: icx_on_utilities.g_on_parameters(5) := p_page_code;

2229: icx_on_utilities.g_on_parameters(1) := 'W';
2230: icx_on_utilities.g_on_parameters(2) := p_flow_application_id;
2231: icx_on_utilities.g_on_parameters(3) := p_flow_code;
2232: icx_on_utilities.g_on_parameters(4) := p_page_application_id;
2233: icx_on_utilities.g_on_parameters(5) := p_page_code;
2234: icx_on_utilities.g_on_parameters(6) := p_where_segment;
2235: icx_on_utilities.g_on_parameters(7) := '';
2236: icx_on_utilities.g_on_parameters(8) := '';
2237: icx_on_utilities.g_on_parameters(9) := '';

Line 2234: icx_on_utilities.g_on_parameters(6) := p_where_segment;

2230: icx_on_utilities.g_on_parameters(2) := p_flow_application_id;
2231: icx_on_utilities.g_on_parameters(3) := p_flow_code;
2232: icx_on_utilities.g_on_parameters(4) := p_page_application_id;
2233: icx_on_utilities.g_on_parameters(5) := p_page_code;
2234: icx_on_utilities.g_on_parameters(6) := p_where_segment;
2235: icx_on_utilities.g_on_parameters(7) := '';
2236: icx_on_utilities.g_on_parameters(8) := '';
2237: icx_on_utilities.g_on_parameters(9) := '';
2238: icx_on_utilities.g_on_parameters(10) := '';

Line 2235: icx_on_utilities.g_on_parameters(7) := '';

2231: icx_on_utilities.g_on_parameters(3) := p_flow_code;
2232: icx_on_utilities.g_on_parameters(4) := p_page_application_id;
2233: icx_on_utilities.g_on_parameters(5) := p_page_code;
2234: icx_on_utilities.g_on_parameters(6) := p_where_segment;
2235: icx_on_utilities.g_on_parameters(7) := '';
2236: icx_on_utilities.g_on_parameters(8) := '';
2237: icx_on_utilities.g_on_parameters(9) := '';
2238: icx_on_utilities.g_on_parameters(10) := '';
2239: icx_on_utilities.g_on_parameters(11) := '';

Line 2236: icx_on_utilities.g_on_parameters(8) := '';

2232: icx_on_utilities.g_on_parameters(4) := p_page_application_id;
2233: icx_on_utilities.g_on_parameters(5) := p_page_code;
2234: icx_on_utilities.g_on_parameters(6) := p_where_segment;
2235: icx_on_utilities.g_on_parameters(7) := '';
2236: icx_on_utilities.g_on_parameters(8) := '';
2237: icx_on_utilities.g_on_parameters(9) := '';
2238: icx_on_utilities.g_on_parameters(10) := '';
2239: icx_on_utilities.g_on_parameters(11) := '';
2240: icx_on_utilities.g_on_parameters(12) := '';

Line 2237: icx_on_utilities.g_on_parameters(9) := '';

2233: icx_on_utilities.g_on_parameters(5) := p_page_code;
2234: icx_on_utilities.g_on_parameters(6) := p_where_segment;
2235: icx_on_utilities.g_on_parameters(7) := '';
2236: icx_on_utilities.g_on_parameters(8) := '';
2237: icx_on_utilities.g_on_parameters(9) := '';
2238: icx_on_utilities.g_on_parameters(10) := '';
2239: icx_on_utilities.g_on_parameters(11) := '';
2240: icx_on_utilities.g_on_parameters(12) := '';
2241: icx_on_utilities.g_on_parameters(13) := '';

Line 2238: icx_on_utilities.g_on_parameters(10) := '';

2234: icx_on_utilities.g_on_parameters(6) := p_where_segment;
2235: icx_on_utilities.g_on_parameters(7) := '';
2236: icx_on_utilities.g_on_parameters(8) := '';
2237: icx_on_utilities.g_on_parameters(9) := '';
2238: icx_on_utilities.g_on_parameters(10) := '';
2239: icx_on_utilities.g_on_parameters(11) := '';
2240: icx_on_utilities.g_on_parameters(12) := '';
2241: icx_on_utilities.g_on_parameters(13) := '';
2242: icx_on_utilities.g_on_parameters(14) := '';

Line 2239: icx_on_utilities.g_on_parameters(11) := '';

2235: icx_on_utilities.g_on_parameters(7) := '';
2236: icx_on_utilities.g_on_parameters(8) := '';
2237: icx_on_utilities.g_on_parameters(9) := '';
2238: icx_on_utilities.g_on_parameters(10) := '';
2239: icx_on_utilities.g_on_parameters(11) := '';
2240: icx_on_utilities.g_on_parameters(12) := '';
2241: icx_on_utilities.g_on_parameters(13) := '';
2242: icx_on_utilities.g_on_parameters(14) := '';
2243: icx_on_utilities.g_on_parameters(15) := '';

Line 2240: icx_on_utilities.g_on_parameters(12) := '';

2236: icx_on_utilities.g_on_parameters(8) := '';
2237: icx_on_utilities.g_on_parameters(9) := '';
2238: icx_on_utilities.g_on_parameters(10) := '';
2239: icx_on_utilities.g_on_parameters(11) := '';
2240: icx_on_utilities.g_on_parameters(12) := '';
2241: icx_on_utilities.g_on_parameters(13) := '';
2242: icx_on_utilities.g_on_parameters(14) := '';
2243: icx_on_utilities.g_on_parameters(15) := '';
2244: icx_on_utilities.g_on_parameters(16) := '';

Line 2241: icx_on_utilities.g_on_parameters(13) := '';

2237: icx_on_utilities.g_on_parameters(9) := '';
2238: icx_on_utilities.g_on_parameters(10) := '';
2239: icx_on_utilities.g_on_parameters(11) := '';
2240: icx_on_utilities.g_on_parameters(12) := '';
2241: icx_on_utilities.g_on_parameters(13) := '';
2242: icx_on_utilities.g_on_parameters(14) := '';
2243: icx_on_utilities.g_on_parameters(15) := '';
2244: icx_on_utilities.g_on_parameters(16) := '';
2245: icx_on_utilities.g_on_parameters(17) := '';

Line 2242: icx_on_utilities.g_on_parameters(14) := '';

2238: icx_on_utilities.g_on_parameters(10) := '';
2239: icx_on_utilities.g_on_parameters(11) := '';
2240: icx_on_utilities.g_on_parameters(12) := '';
2241: icx_on_utilities.g_on_parameters(13) := '';
2242: icx_on_utilities.g_on_parameters(14) := '';
2243: icx_on_utilities.g_on_parameters(15) := '';
2244: icx_on_utilities.g_on_parameters(16) := '';
2245: icx_on_utilities.g_on_parameters(17) := '';
2246: icx_on_utilities.g_on_parameters(18) := '';

Line 2243: icx_on_utilities.g_on_parameters(15) := '';

2239: icx_on_utilities.g_on_parameters(11) := '';
2240: icx_on_utilities.g_on_parameters(12) := '';
2241: icx_on_utilities.g_on_parameters(13) := '';
2242: icx_on_utilities.g_on_parameters(14) := '';
2243: icx_on_utilities.g_on_parameters(15) := '';
2244: icx_on_utilities.g_on_parameters(16) := '';
2245: icx_on_utilities.g_on_parameters(17) := '';
2246: icx_on_utilities.g_on_parameters(18) := '';
2247: icx_on_utilities.g_on_parameters(19) := '';

Line 2244: icx_on_utilities.g_on_parameters(16) := '';

2240: icx_on_utilities.g_on_parameters(12) := '';
2241: icx_on_utilities.g_on_parameters(13) := '';
2242: icx_on_utilities.g_on_parameters(14) := '';
2243: icx_on_utilities.g_on_parameters(15) := '';
2244: icx_on_utilities.g_on_parameters(16) := '';
2245: icx_on_utilities.g_on_parameters(17) := '';
2246: icx_on_utilities.g_on_parameters(18) := '';
2247: icx_on_utilities.g_on_parameters(19) := '';
2248: icx_on_utilities.g_on_parameters(20) := '';

Line 2245: icx_on_utilities.g_on_parameters(17) := '';

2241: icx_on_utilities.g_on_parameters(13) := '';
2242: icx_on_utilities.g_on_parameters(14) := '';
2243: icx_on_utilities.g_on_parameters(15) := '';
2244: icx_on_utilities.g_on_parameters(16) := '';
2245: icx_on_utilities.g_on_parameters(17) := '';
2246: icx_on_utilities.g_on_parameters(18) := '';
2247: icx_on_utilities.g_on_parameters(19) := '';
2248: icx_on_utilities.g_on_parameters(20) := '';
2249: icx_on_utilities.g_on_parameters(21) := '';

Line 2246: icx_on_utilities.g_on_parameters(18) := '';

2242: icx_on_utilities.g_on_parameters(14) := '';
2243: icx_on_utilities.g_on_parameters(15) := '';
2244: icx_on_utilities.g_on_parameters(16) := '';
2245: icx_on_utilities.g_on_parameters(17) := '';
2246: icx_on_utilities.g_on_parameters(18) := '';
2247: icx_on_utilities.g_on_parameters(19) := '';
2248: icx_on_utilities.g_on_parameters(20) := '';
2249: icx_on_utilities.g_on_parameters(21) := '';
2250: icx_on_utilities.g_on_parameters(22) := 'N';

Line 2247: icx_on_utilities.g_on_parameters(19) := '';

2243: icx_on_utilities.g_on_parameters(15) := '';
2244: icx_on_utilities.g_on_parameters(16) := '';
2245: icx_on_utilities.g_on_parameters(17) := '';
2246: icx_on_utilities.g_on_parameters(18) := '';
2247: icx_on_utilities.g_on_parameters(19) := '';
2248: icx_on_utilities.g_on_parameters(20) := '';
2249: icx_on_utilities.g_on_parameters(21) := '';
2250: icx_on_utilities.g_on_parameters(22) := 'N';
2251:

Line 2248: icx_on_utilities.g_on_parameters(20) := '';

2244: icx_on_utilities.g_on_parameters(16) := '';
2245: icx_on_utilities.g_on_parameters(17) := '';
2246: icx_on_utilities.g_on_parameters(18) := '';
2247: icx_on_utilities.g_on_parameters(19) := '';
2248: icx_on_utilities.g_on_parameters(20) := '';
2249: icx_on_utilities.g_on_parameters(21) := '';
2250: icx_on_utilities.g_on_parameters(22) := 'N';
2251:
2252: icx_on.get_page(l_dummy_table,l_dummy_table,l_dummy_table,'','');

Line 2249: icx_on_utilities.g_on_parameters(21) := '';

2245: icx_on_utilities.g_on_parameters(17) := '';
2246: icx_on_utilities.g_on_parameters(18) := '';
2247: icx_on_utilities.g_on_parameters(19) := '';
2248: icx_on_utilities.g_on_parameters(20) := '';
2249: icx_on_utilities.g_on_parameters(21) := '';
2250: icx_on_utilities.g_on_parameters(22) := 'N';
2251:
2252: icx_on.get_page(l_dummy_table,l_dummy_table,l_dummy_table,'','');
2253:

Line 2250: icx_on_utilities.g_on_parameters(22) := 'N';

2246: icx_on_utilities.g_on_parameters(18) := '';
2247: icx_on_utilities.g_on_parameters(19) := '';
2248: icx_on_utilities.g_on_parameters(20) := '';
2249: icx_on_utilities.g_on_parameters(21) := '';
2250: icx_on_utilities.g_on_parameters(22) := 'N';
2251:
2252: icx_on.get_page(l_dummy_table,l_dummy_table,l_dummy_table,'','');
2253:
2254: end;

Line 2252: icx_on.get_page(l_dummy_table,l_dummy_table,l_dummy_table,'','');

2248: icx_on_utilities.g_on_parameters(20) := '';
2249: icx_on_utilities.g_on_parameters(21) := '';
2250: icx_on_utilities.g_on_parameters(22) := 'N';
2251:
2252: icx_on.get_page(l_dummy_table,l_dummy_table,l_dummy_table,'','');
2253:
2254: end;
2255:
2256:

Line 2257: end icx_on_utilities;

2253:
2254: end;
2255:
2256:
2257: end icx_on_utilities;