APPS.ICX_REQ_UPDATE_SAVED_CARTS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 13

 if (icx_sec.validatesession('ICX_UPDATE_SAVED_CARTS')) then


   icx_on_utilities.FindPage(p_region_appl_id => 601,
                             p_region_code    => 'ICX_SAVED_CARTS_R',
                             p_goto_url       => 'ICX_REQ_UPDATE_SAVED_CARTS.displaySavedCarts',
                             p_lines_now      => 1,
                             p_lines_next     => 5,
                             p_new_url        => 'ICX_REQ_NAVIGATION.ic_parent?cart_id=' || icx_call.encrypt2('0'),
                             p_help_url => '/OA_DOC/' || c_language || '/awe' || '/icxhlprq.htm'
                            );

Line: 80

if icx_sec.validateSession('ICX_UPDATE_SAVED_CARTS') then

        sess_web_user := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

Line: 106

            htp.p('function delete_saved_cart(delete_name, condensed_params) {
                //if (confirm("' || FND_MESSAGE.GET || '") ) {
                //if (confirm("Are you sure you want to delete requisition # "+delete_name+"?"))      {
		    if (confirm(delete_name))      {
                     parent.location="ICX_REQ_UPDATE_SAVED_CARTS.deleteSavedCarts?condensed_params=" + condensed_params
                }
            }');

Line: 118

        select QUERY_SET into c_query_size
        from ICX_PARAMETERS;

Line: 204

                              disp_find => 'icx_req_update_saved_carts.cartSearch');

Line: 205

        htp.formOpen('ICX_REQ_UPDATE_SAVED_CARTS.displaySavedCarts','POST','','','NAME="DISPLAY_SAVED_CARTS"');

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

Line: 291

                elsif (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELETE') then
                              condensed_params := icx_call.encrypt2( y_table(l_cart_id_value_id) ||'*'|| p_start_row||'*'||end_row||'*'||l_encrypted_where||'**]');

Line: 298

                    FND_MESSAGE.SET_NAME('ICX', 'ICX_DELETE_OBJECT');

Line: 299

                    FND_MESSAGE.SET_TOKEN('OBJECT_TO_DELETE_TOKEN', y_table(l_cart_name_value_id));

Line: 302

                              htp.tableData(htf.anchor('javascript:delete_saved_cart('''||icx_util.replace_quotes(FND_MESSAGE.GET) ||''','''||condensed_params||''')',
htf.img('/OA_MEDIA/'||c_language||'/FNDIDELR.gif','CENTER','','','border=no width=17 height=16'),'','onMouseOver="return true"'));

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

Line: 339

        select substr(c_message,12,512) into err_mesg from dual;

Line: 346

procedure deleteSavedCarts(condensed_params in number default null) is
------------------------------------------------------
v_cart_id   number;

Line: 354

   if icx_sec.validateSession('ICX_UPDATE_SAVED_CARTS') then

            Y := icx_call.decrypt2(condensed_params);

Line: 361

            /* Delete all cart lines */
            delete from icx_shopping_cart_lines
            Where cart_id = v_cart_id;

Line: 365

            /* Delete cart header */
            delete from icx_shopping_carts
            where cart_id = v_cart_id;

Line: 369

	    delete icx_cart_line_distributions
	    where cart_id = v_cart_id;

Line: 372

	    delete icx_cart_distributions
	    where cart_id = v_cart_id;

Line: 375

            ICX_REQ_UPDATE_SAVED_CARTS.displaySavedCarts(p_start_row => params(2),
                                                         p_end_row => params(3),
                                                         p_where => params(4));