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,
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;
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),
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:
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:
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);
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);
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);
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);
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:
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'
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
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:
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);
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);
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);
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);
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:
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
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:
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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:
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,
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
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,
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;
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;
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;
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)||'**]';
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:
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'
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
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
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,
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:
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;
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) := '';
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) := '';
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';
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) := '';
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) := '';
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) := '';
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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';
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:
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,'','');
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:
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;
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,
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;
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;
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;
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) := '';
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) := '';
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) := '';
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) := '';
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) := '';
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) := '';
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) := '';
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) := '';
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) := '';
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) := '';
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) := '';
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) := '';
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) := '';
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) := '';
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) := '';
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';
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:
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,'','');
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:
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;
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:
2253:
2254: end;
2255:
2256:
2257: end icx_on_utilities;