APPS.ICX_REQ_UPDATE_SAVED_CARTS dependencies on ICX_ON_UTILITIES

Line 16: icx_on_utilities.FindPage(p_region_appl_id => 601,

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',
18: p_goto_url => 'ICX_REQ_UPDATE_SAVED_CARTS.displaySavedCarts',
19: p_lines_now => 1,
20: p_lines_next => 5,

Line 123: icx_on_utilities.unpack_whereSegment(where_clause,l_where_clause,l_where_binds);

119: from ICX_PARAMETERS;
120:
121: if p_where is not null then
122: where_clause := icx_call.decrypt2(p_where);
123: icx_on_utilities.unpack_whereSegment(where_clause,l_where_clause,l_where_binds);
124: else
125: where_clause := icx_on_utilities.whereSegment(a_1,c_1,i_1,a_2,c_2,i_2,a_3,c_3,i_3,a_4,c_4,i_4,a_5,c_5,i_5);
126:
127: icx_on_utilities.unpack_whereSegment(where_clause, l_where_clause, l_where_binds);

Line 125: where_clause := icx_on_utilities.whereSegment(a_1,c_1,i_1,a_2,c_2,i_2,a_3,c_3,i_3,a_4,c_4,i_4,a_5,c_5,i_5);

121: if p_where is not null then
122: where_clause := icx_call.decrypt2(p_where);
123: icx_on_utilities.unpack_whereSegment(where_clause,l_where_clause,l_where_binds);
124: else
125: where_clause := icx_on_utilities.whereSegment(a_1,c_1,i_1,a_2,c_2,i_2,a_3,c_3,i_3,a_4,c_4,i_4,a_5,c_5,i_5);
126:
127: icx_on_utilities.unpack_whereSegment(where_clause, l_where_clause, l_where_binds);
128: -- if where_clause is not null then
129: if l_where_clause is not null then

Line 127: icx_on_utilities.unpack_whereSegment(where_clause, l_where_clause, l_where_binds);

123: icx_on_utilities.unpack_whereSegment(where_clause,l_where_clause,l_where_binds);
124: else
125: where_clause := icx_on_utilities.whereSegment(a_1,c_1,i_1,a_2,c_2,i_2,a_3,c_3,i_3,a_4,c_4,i_4,a_5,c_5,i_5);
126:
127: icx_on_utilities.unpack_whereSegment(where_clause, l_where_clause, l_where_binds);
128: -- if where_clause is not null then
129: if l_where_clause is not null then
130:
131: /* added to take care of Bind vars Bug **/

Line 218: icx_on_utilities2.displaySetIcons(c_language,'icx_req_update_saved_carts.displaySavedCarts',p_start_row,end_row,l_encrypted_where,c_query_size,total_rows);

214: htp.tableRowClose;
215: htp.tableClose;
216: if p_start_row <> 1 or end_row <> total_rows
217: then
218: icx_on_utilities2.displaySetIcons(c_language,'icx_req_update_saved_carts.displaySavedCarts',p_start_row,end_row,l_encrypted_where,c_query_size,total_rows);
219: end if;
220: end if;
221:
222:

Line 327: icx_on_utilities2.displaySetIcons(c_language,'icx_req_update_saved_carts.displaySavedCarts',p_start_row,end_row,l_encrypted_where,c_query_size,total_rows,FALSE);

323: end if;
324:
325: -- if p_start_row <> 1 or end_row <> total_rows
326: -- then
327: icx_on_utilities2.displaySetIcons(c_language,'icx_req_update_saved_carts.displaySavedCarts',p_start_row,end_row,l_encrypted_where,c_query_size,total_rows,FALSE);
328: -- end if;
329: htp.formClose;
330: icx_admin_sig.footer;
331: htp.htmlClose;

Line 350: params icx_on_utilities.v80_table;

346: procedure deleteSavedCarts(condensed_params in number default null) is
347: ------------------------------------------------------
348: v_cart_id number;
349: Y varchar2(2000);
350: params icx_on_utilities.v80_table;
351:
352: Begin
353:
354: if icx_sec.validateSession('ICX_UPDATE_SAVED_CARTS') then

Line 357: icx_on_utilities.unpack_parameters(Y, params);

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:
359: v_cart_id := params(1);
360:
361: /* Delete all cart lines */