APPS.ICX_REQ_SEARCH dependencies on ICX_CALL

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 242: c_url := p_lines_url||icx_call.encrypt2(p_region_appl_id||'*'||p_region_code||'*'||p_goto_url||'*'||p_goto_target||'*'||p_lines_next||'*'||

238: l_parameters(i) := '';
239: end loop;
240: end if;
241:
242: c_url := p_lines_url||icx_call.encrypt2(p_region_appl_id||'*'||p_region_code||'*'||p_goto_url||'*'||p_goto_target||'*'||p_lines_next||'*'||
243: p_lines_url||'*'||p_lines_target||'*'||p_lines_now||'*'||p_hidden_name||'*'||p_hidden_value||'*'||p_help_url||'*'||p_new_url||'*'||p_LOV_mode||'*'||p_default_title||'**] NAME="'||p_lines_target||'"');
244:
245: icx_util.getLookups('ICX_CONDITIONS',l_lookup_codes,l_lookup_meanings);
246:

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 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 848: l_cart_id := icx_call.decrypt2(cartId);

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);
850: l_rows_added := 0;
851: l_rows_updated := 0;
852:

Line 849: l_emergency := icx_call.decrypt2(p_emergency);

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);
850: l_rows_added := 0;
851: l_rows_updated := 0;
852:
853: if l_cart_id is not NULL then

Line 1100: Y:=icx_call.decrypt2(p_where);

1096:
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);

Line 1124: parameters_pass := icx_call.encrypt2(a_1_code||'*'||c_1_code||'*'||i_1_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,
1123: m,o);
1124: parameters_pass := icx_call.encrypt2(a_1_code||'*'||c_1_code||'*'||i_1_code||'*'||
1125: a_2_code||'*'||c_2_code||'*'||i_2_code||'*'||
1126: a_3_code||'*'||c_3_code||'*'||i_3_code||'*'||
1127: a_4_code||'*'||c_4_code||'*'||i_4_code||'*'||
1128: a_5_code||'*'||c_5_code||'*'||i_5_code||'*'||l_cat||'**]');

Line 1133: parameters_pass := icx_call.encrypt2(a_1||'*'||c_1||'*'||i_1||'*'||

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||'*'||
1136: a_4||'*'||c_4||'*'||i_4||'*'||
1137: a_5||'*'||c_5||'*'||i_5||'*'||l_cat||'**]');