APPS.ICX_REQ_TEMPLATES dependencies on ICX_CALL

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

178: v_def_is_top := 'Y';
179: end if;
180: end if;
181:
182: p_where := icx_call.encrypt2(v_node_id || '*' || v_org_id || '**]');
183:
184: select count(-1) into v_no_of_children
185: from icx_related_templates_val_v
186: where express_name = v_node_id

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

247: v_def_is_top := 'Y';
248: end if;
249: end if;
250:
251: p_where := icx_call.encrypt2(v_node_id || '*' || v_org_id || '**]');
252:
253: v_children_loaded := 'true';
254: htp.p('TOP_TEMPLATES[' || counter || ']= new node("' || v_node_id || '","' ||
255: v_name || '",' || v_children_loaded || ',"' ||

Line 279: p_where := icx_call.encrypt2(v_default_template || '*' || v_org_id || '**]');

275: /* allow it to be at children level and dispaly as such in Beta 2 */
276: if v_def_is_top = 'N' AND
277: v_default_template is not NULL then
278:
279: p_where := icx_call.encrypt2(v_default_template || '*' || v_org_id || '**]');
280:
281: select count(-1) into v_no_of_children
282: from icx_related_templates_val_v
283: where express_name = v_default_template

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

425:
426: --decrypt2 p_where
427:
428: if p_where is not null then
429: icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_where), params);
430: --template_id := params(1);
431:
432: -- if nodeId is null then
433: v_default_template_id := params(1);

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

544: v_node_id := ak_query_pkg.g_results_table(i).value2;
545: v_name := ak_query_pkg.g_results_table(i).value2;
546:
547:
548: v_p_where := icx_call.encrypt2(v_node_id || '*' || v_org || '**]');
549:
550: select count(-1) into v_no_of_children
551: from icx_related_templates_val_v
552: where express_name = v_node_id

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

763:
764: l_encrypted_where := p_where;
765:
766: IF p_where IS NOT NULL THEN
767: icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_where), params);
768: v_express_name := params(1);
769:
770: if length(v_express_name) > 5 then
771: if substr(v_express_name,1,5) = '(NEW)' then

Line 1175: l_cart_id := to_number(icx_call.decrypt2(cartId));

1171: IF icx_sec.validateSession THEN
1172:
1173: icx_util.error_page_setup;
1174:
1175: l_cart_id := to_number(icx_call.decrypt2(cartId));
1176: l_emergency := icx_call.decrypt2(p_emergency);
1177: l_rows_added := 0;
1178: l_rows_updated := 0;
1179: l_num_rows := Quantity.COUNT;

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

1172:
1173: icx_util.error_page_setup;
1174:
1175: l_cart_id := to_number(icx_call.decrypt2(cartId));
1176: l_emergency := icx_call.decrypt2(p_emergency);
1177: l_rows_added := 0;
1178: l_rows_updated := 0;
1179: l_num_rows := Quantity.COUNT;
1180: l_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

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

1180: l_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1181: -- l_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);
1182:
1183: IF p_where IS NOT NULL THEN
1184: icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_where), params);
1185: v_org := params(2);
1186: END IF;
1187:
1188: IF cartId IS NOT NULL THEN