DBA Data[Home] [Help]

APPS.ICX_REQ_TEMPLATES dependencies on ICX_ON_UTILITIES

Line 383: params icx_on_utilities.v80_table;

379: v_node_id varchar2(240);
380: v_name varchar2(240);
381: v_no_of_children number;
382: v_org number;
383: params icx_on_utilities.v80_table;
384:
385: v_dcdName varchar2(240) := owa_util.get_cgi_env('SCRIPT_NAME');
386:
387: v_emergency varchar2(10);

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

666: htp.p('');
667:
668: htp.p('');
669: htp.p('
');
670: icx_on_utilities2.displaySetIcons(p_language_code => v_lang,
671: p_packproc => 'ICX_REQ_TEMPLATES.template_items',
672: p_start_row => p_start_row,
673: p_stop_row => p_end_row,
674: p_encrypted_where => p_where,

Line 728: params icx_on_utilities.v80_table;

724: y_table icx_util.char240_table;
725:
726: v_express_name varchar2(240) := NULL;
727: v_org number;
728: params icx_on_utilities.v80_table;
729:
730: counter number := 0;
731: V_QUANTITY_LENGTH NUMBER :=10;
732:

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

1115: l_shopper_id number;
1116: l_org_id number;
1117: l_qty number;
1118: v_org number;
1119: params icx_on_utilities.v80_table;
1120: l_pad number;
1121:
1122: -- temp variables used to query deliver-to-requestor-info
1123: v_requestor_id number;

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