5: procedure cartSearch is
6: ------------------------------------------------------
7: c_language varchar2(30);
8: begin
9: c_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
10:
11:
12: -- Check if session is valid
13: if (icx_sec.validatesession('ICX_UPDATE_SAVED_CARTS')) then
9: c_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
10:
11:
12: -- Check if session is valid
13: if (icx_sec.validatesession('ICX_UPDATE_SAVED_CARTS')) then
14:
15:
16: icx_on_utilities.FindPage(p_region_appl_id => 601,
17: p_region_code => 'ICX_SAVED_CARTS_R',
76: v_index number;
77:
78: begin
79:
80: if icx_sec.validateSession('ICX_UPDATE_SAVED_CARTS') then
81:
82: sess_web_user := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
83: c_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
84:
78: begin
79:
80: if icx_sec.validateSession('ICX_UPDATE_SAVED_CARTS') then
81:
82: sess_web_user := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
83: c_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
84:
85: icx_util.getPrompts(601,'ICX_SAVED_CARTS_R',c_title,c_prompts);
86: icx_util.error_page_setup;
79:
80: if icx_sec.validateSession('ICX_UPDATE_SAVED_CARTS') then
81:
82: sess_web_user := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
83: c_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
84:
85: icx_util.getPrompts(601,'ICX_SAVED_CARTS_R',c_title,c_prompts);
86: icx_util.error_page_setup;
87:
179: end if;
180:
181: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
182: P_PARENT_REGION_CODE => 'ICX_SAVED_CARTS_R',
183: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
184: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
185: -- P_WHERE_CLAUSE => where_clause,
186: P_WHERE_CLAUSE => l_where_clause,
187: P_RETURN_PARENTS => 'T',
180:
181: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
182: P_PARENT_REGION_CODE => 'ICX_SAVED_CARTS_R',
183: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
184: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
185: -- P_WHERE_CLAUSE => where_clause,
186: P_WHERE_CLAUSE => l_where_clause,
187: P_RETURN_PARENTS => 'T',
188: P_RETURN_CHILDREN => 'F',
350: params icx_on_utilities.v80_table;
351:
352: Begin
353:
354: if icx_sec.validateSession('ICX_UPDATE_SAVED_CARTS') then
355:
356: Y := icx_call.decrypt2(condensed_params);
357: icx_on_utilities.unpack_parameters(Y, params);
358: