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

Line 181: c_attributes icx_on_utilities.v2000_table;

177: l_lookup_meanings icx_util.g_lookup_meaning_table;
178:
179: c_count number;
180: l_data_type varchar2(1);
181: c_attributes icx_on_utilities.v2000_table;
182: c_condition icx_on_utilities.v2000_table;
183: c_input icx_on_utilities.v80_table;
184: l_categories varchar2(2000);
185: c_url varchar2(2000);

Line 182: c_condition icx_on_utilities.v2000_table;

178:
179: c_count number;
180: l_data_type varchar2(1);
181: c_attributes icx_on_utilities.v2000_table;
182: c_condition icx_on_utilities.v2000_table;
183: c_input icx_on_utilities.v80_table;
184: l_categories varchar2(2000);
185: c_url varchar2(2000);
186: c_buttons varchar2(2000);

Line 183: c_input icx_on_utilities.v80_table;

179: c_count number;
180: l_data_type varchar2(1);
181: c_attributes icx_on_utilities.v2000_table;
182: c_condition icx_on_utilities.v2000_table;
183: c_input icx_on_utilities.v80_table;
184: l_categories varchar2(2000);
185: c_url varchar2(2000);
186: c_buttons varchar2(2000);
187:

Line 223: l_parameters icx_on_utilities.v240_table;

219: v_validate_flag varchar2(1);
220: l_category_id number;
221: l_category_name number;
222: l_values icx_util.char240_table;
223: l_parameters icx_on_utilities.v240_table;
224: l_starts_with number;
225:
226: begin
227:

Line 232: icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_values), l_parameters);

228: /* XXXXXXXXXXXXXXXXGet condition title, prompts and conditions */
229: icx_util.getPrompts(178,'ICX_WEB_ON_QUERY',c_title,c_prompts);
230:
231: if p_values is not null then
232: icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_values), l_parameters);
233: for i in l_parameters.COUNT..20 loop
234: l_parameters(i) := '';
235: end loop;
236: else

Line 504: icx_on_utilities2.displaySetIcons(p_language_code => v_lang,

500: htp.p('');
501: htp.p('
');
502:
503: if (p_context = 'N') then
504: icx_on_utilities2.displaySetIcons(p_language_code => v_lang,
505: p_packproc => 'ICX_REQ_SEARCH.displayItem',
506: p_start_row => p_start_row,
507: p_stop_row => p_end_row,
508: p_encrypted_where => p_where,

Line 514: icx_on_utilities2.displaySetIcons(p_language_code => v_lang,

510: p_target => 'parent.frames[0]',
511: p_row_count => p_total_rows,
512: p_hidden => 'N');
513: else
514: icx_on_utilities2.displaySetIcons(p_language_code => v_lang,
515: p_packproc => 'ICX_REQ_SEARCH.displayItem',
516: p_start_row => p_start_row,
517: p_stop_row => p_end_row,
518: p_encrypted_where => p_where,

Line 552: l_search icx_on_utilities.v240_table;

548: paramX in varchar2 default null ) is
549: -------------------------------------------------------------------
550:
551: v_lines_url varchar2(256);
552: l_search icx_on_utilities.v240_table;
553: l_param icx_on_utilities.v240_table;
554: v_lines_now number;
555: v_lines_next number;
556: l_paramX number;

Line 553: l_param icx_on_utilities.v240_table;

549: -------------------------------------------------------------------
550:
551: v_lines_url varchar2(256);
552: l_search icx_on_utilities.v240_table;
553: l_param icx_on_utilities.v240_table;
554: v_lines_now number;
555: v_lines_next number;
556: l_paramX number;
557: l_language varchar2(30);

Line 570: icx_on_utilities.unpack_parameters(icx_call.decrypt2(paramX), l_param);

566:
567: l_paramX := paramX;
568: v_lines_url := 'ICX_REQ_SEARCH.itemsearch_display?searchX=';
569: if paramX is not null then
570: icx_on_utilities.unpack_parameters(icx_call.decrypt2(paramX), l_param);
571: if l_param(4) is null
572: and l_param(7) is null
573: and l_param(10) is null
574: and l_param(13) is null then

Line 586: icx_on_utilities.unpack_parameters(icx_call.decrypt2(searchX), l_search);

582: v_lines_now := 1;
583: v_lines_next := 5;
584: end if;
585: if searchX is not null then
586: icx_on_utilities.unpack_parameters(icx_call.decrypt2(searchX), l_search);
587: v_lines_now := l_search(5); -- p_lines_next
588: v_lines_next := l_search(8); -- p_lines_now
589: l_paramX := l_search(10); -- p_hidden_value
590: end if;

Line 602: icx_on_utilities.findForm(p_region_appl_id => 601,

598: htp.bodyOpen('', 'BGCOLOR="#CCCCFF" onLoad="parent.parent.winOpen(''nav'', ''item_search''); open(''/OA_HTML/' || l_language || '/ICXBLUE.htm'', ''k_buttons'')"' );
599:
600: fnd_message.set_name('ICX','ICX_REQS_FIND');
601: htp.p(htf.bold(FND_MESSAGE.GET));
602: icx_on_utilities.findForm(p_region_appl_id => 601,
603: p_region_code => 'ICX_PO_SUPPL_SEARCH_ITEMS_R',
604: p_goto_url => 'ICX_REQ_SEARCH.displayItem',
605: p_goto_target => 'data',
606: p_lines_now => v_lines_now,

Line 790: params icx_on_utilities.v80_table;

786: l_num_rows number;
787: l_cart_line_id number;
788: l_shopper_id number;
789: l_org_id number;
790: params icx_on_utilities.v80_table;
791: l_qty number;
792: l_error_id NUMBER;
793: l_err_num NUMBER;
794: l_error_message VARCHAR2(2000);

Line 845: -- icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_where),params);

841: l_num_rows := Quantity.COUNT;
842: l_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
843: -- l_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);
844: -- if p_where is not NULL then
845: -- icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_where),params);
846: -- l_org_id := params(2);
847: -- end if;
848: l_cart_id := icx_call.decrypt2(cartId);
849: l_emergency := icx_call.decrypt2(p_emergency);

Line 1057: params icx_on_utilities.v80_table;

1053: i_4_code varchar2(80);
1054: i_5_code varchar2(80);
1055: l_cat number;
1056: Y varchar2(2000);
1057: params icx_on_utilities.v80_table;
1058: c_currency varchar2(15);
1059: c_money_precision number;
1060: c_money_fmt_mask varchar2(32);
1061:

Line 1101: icx_on_utilities.unpack_parameters(Y,params);

1097: icx_util.getPrompts(601,'ICX_PO_SUPPL_SEARCH_ITEMS_R',c_title,c_prompts);
1098: icx_util.error_page_setup;
1099: if p_where is not null then
1100: Y:=icx_call.decrypt2(p_where);
1101: icx_on_utilities.unpack_parameters(Y,params);
1102: a_1_code := params(1);
1103: c_1_code := params(2);
1104: i_1_code := params(3);
1105: a_2_code := params(4);

Line 1118: where_clause := icx_on_utilities.whereSegment(a_1_code,c_1_code,i_1_code,

1114: a_5_code := params(13);
1115: c_5_code := params(14);
1116: i_5_code := params(15);
1117: l_cat := params(16);
1118: where_clause := icx_on_utilities.whereSegment(a_1_code,c_1_code,i_1_code,
1119: a_2_code,c_2_code,i_2_code,
1120: a_3_code,c_3_code,i_3_code,
1121: a_4_code,c_4_code,i_4_code,
1122: a_5_code,c_5_code,i_5_code,

Line 1131: where_clause := icx_on_utilities.whereSegment(a_1,c_1,i_1,a_2,c_2,i_2,a_3,c_3,i_3,a_4,c_4,i_4,a_5,c_5,i_5,m,o);

1127: a_4_code||'*'||c_4_code||'*'||i_4_code||'*'||
1128: a_5_code||'*'||c_5_code||'*'||i_5_code||'*'||l_cat||'**]');
1129:
1130: else
1131: where_clause := icx_on_utilities.whereSegment(a_1,c_1,i_1,a_2,c_2,i_2,a_3,c_3,i_3,a_4,c_4,i_4,a_5,c_5,i_5,m,o);
1132: l_cat := p_cat;
1133: parameters_pass := icx_call.encrypt2(a_1||'*'||c_1||'*'||i_1||'*'||
1134: a_2||'*'||c_2||'*'||i_2||'*'||
1135: a_3||'*'||c_3||'*'||i_3||'*'||

Line 1161: icx_on_utilities.unpack_whereSegment(where_clause,l_where_clause,where_clause_binds);

1157: icx_util.copyright;
1158: js.scriptOpen;
1159: find_form_head_region(v_lines_now);
1160:
1161: icx_on_utilities.unpack_whereSegment(where_clause,l_where_clause,where_clause_binds);
1162:
1163: if (l_where_clause is not null ) then
1164: -- l_where_clause := l_where_clause || ' AND ';
1165: if (o is null and p_hidden is null) then

Line 1239: icx_on_utilities.findForm(p_region_appl_id => 601,

1235:
1236: fnd_message.set_name('ICX','ICX_REQS_FIND');
1237: htp.p(htf.bold(FND_MESSAGE.GET));
1238: -- htp.p('Debug findForm');
1239: icx_on_utilities.findForm(p_region_appl_id => 601,
1240: p_region_code => 'ICX_PO_SUPPL_SEARCH_ITEMS_R',
1241: p_goto_url => 'ICX_REQ_SEARCH.displayItem',
1242: p_goto_target => 'data',
1243: p_lines_now => v_lines_now,

Line 1297: icx_on_utilities.findForm(p_region_appl_id => 601,

1293:
1294: fnd_message.set_name('ICX','ICX_REQS_FIND');
1295: htp.p(htf.bold(FND_MESSAGE.GET));
1296:
1297: icx_on_utilities.findForm(p_region_appl_id => 601,
1298: p_region_code => 'ICX_PO_SUPPL_SEARCH_ITEMS_R',
1299: p_goto_url => 'ICX_REQ_SEARCH.displayItem',
1300: p_goto_target => 'data',
1301: p_lines_now => v_lines_now,