APPS.ICX_REQ_CATEGORIES dependencies on ICX_CALL

Line 135: p_where := icx_call.encrypt2(v_node_id || '*' || v_org_id || '*' || v_name || '**]');

131:
132: v_node_id := ak_query_pkg.g_results_table(i).value2; -- Category id
133: v_name := ak_query_pkg.g_results_table(i).value4; -- Category name
134:
135: p_where := icx_call.encrypt2(v_node_id || '*' || v_org_id || '*' || v_name || '**]');
136:
137:
138: select count(-1) into v_no_of_children
139: from icx_related_categories_val_v

Line 176: p_where := icx_call.encrypt2(v_node_id || '*' || v_org_id || '*' || v_name || '**]');

172:
173: v_node_id := ak_query_pkg.g_results_table(i).value3; -- Category id
174: v_name := ak_query_pkg.g_results_table(i).value1; -- Category name
175:
176: p_where := icx_call.encrypt2(v_node_id || '*' || v_org_id || '*' || v_name || '**]');
177:
178:
179: v_children_loaded := 'true';
180: htp.p('TOP_CATEGORIES[' || counter || ']= new node(' || v_node_id || ',"' ||

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

296: if (icx_sec.validatesession('ICX_REQS')) then
297:
298: --decrypt2 p_where
299: if p_where is not null then
300: icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_where), params);
301: --cat_id := params(1);
302: v_org := params(2);
303: end if;
304:

Line 348: v_p_where := icx_call.encrypt2(v_node_id || '*' || v_org || '*' || v_name || '**]');

344:
345: v_node_id := ak_query_pkg.g_results_table(i).value3; -- Related Category id
346: v_name := ak_query_pkg.g_results_table(i).value4; -- Related Category name
347:
348: v_p_where := icx_call.encrypt2(v_node_id || '*' || v_org || '*' || v_name || '**]');
349:
350: select count(-1) into v_no_of_children
351: from icx_related_categories_val_v
352: where CATEGORY_ID = v_node_id

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

565: l_num_rows := Quantity.COUNT;
566: l_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
567: -- l_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);
568: if p_where is not NULL then
569: icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_where),params);
570: l_org_id := params(2);
571: end if;
572:
573: l_cart_id := icx_call.decrypt2(cartId);

Line 573: l_cart_id := icx_call.decrypt2(cartId);

569: icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_where),params);
570: l_org_id := params(2);
571: end if;
572:
573: l_cart_id := icx_call.decrypt2(cartId);
574: l_emergency := icx_call.decrypt2(p_emergency);
575:
576: if l_cart_id is not NULL then
577: open get_cart_header_info(l_cart_id);

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

570: l_org_id := params(2);
571: end if;
572:
573: l_cart_id := icx_call.decrypt2(cartId);
574: l_emergency := icx_call.decrypt2(p_emergency);
575:
576: if l_cart_id is not NULL then
577: open get_cart_header_info(l_cart_id);
578: fetch get_cart_header_info into l_need_by_date, l_emp_id,

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

876:
877:
878: --decrypt2 p_where
879: if p_where is not null then
880: icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_where), params);
881: v_cat_id := params(1);
882: v_org := params(2);
883: v_cat_name := params(3);
884: end if;