265: v_node_id varchar2(240);
266: v_name varchar2(240);
267: v_no_of_children number;
268: v_org number;
269: params icx_on_utilities.v80_table;
270:
271: v_dcdName varchar2(240) := owa_util.get_cgi_env('SCRIPT_NAME');
272: v_first_time_flag varchar2(1);
273:
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:
506: l_num_rows number;
507: l_cart_line_id number;
508: l_shopper_id number;
509: l_org_id number;
510: params icx_on_utilities.v80_table;
511: l_qty number;
512: l_error_id NUMBER;
513: l_err_num NUMBER;
514: l_error_message VARCHAR2(2000);
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);
779: htp.p('
');'); 783: icx_on_utilities2.displaySetIcons(p_language_code => v_lang, 784: p_packproc => 'ICX_REQ_CATEGORIES.catalog_items', 785: p_start_row => p_start_row, 786: p_stop_row => p_end_row, 787: p_encrypted_where => p_where, Line 846: params icx_on_utilities.v80_table; |