DBA Data[Home] [Help]

APPS.ICX_REQ_CATEGORIES dependencies on ICX_ON_UTILITIES

Line 269: params icx_on_utilities.v80_table;

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:

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 510: params icx_on_utilities.v80_table;

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

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 783: icx_on_utilities2.displaySetIcons(p_language_code => v_lang,

779: htp.p('');
780:
781: htp.p('');
782: 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;

842: v_temp varchar2(240);
843: V_QUANTITY_LENGTH NUMBER :=10;
844: v_dcdName varchar2(1000);
845:
846: params icx_on_utilities.v80_table;
847: c_currency varchar2(15);
848: c_money_precision number;
849: c_money_fmt_mask varchar2(32);
850:

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;