APPS.ICX_REQ_CATEGORIES dependencies on ICX_SHOPPING_CARTS

Line 536: from icx_shopping_carts

532: deliver_to_location_id,
533: deliver_to_location,
534: destination_organization_id,
535: org_id
536: from icx_shopping_carts
537: where cart_id = v_cart_id;
538: -- and nvl(org_id,-9999) = nvl(v_org_id,-9999);
539:
540: cursor get_max_line_number(v_cart_id number) is

Line 608: from icx_shopping_carts

604: l_line_id := Line_Id(i);
605:
606: /* semaphore for getting max line number */
607: select 1 into l_dummy
608: from icx_shopping_carts
609: where cart_id = l_cart_id
610: for update;
611:
612: l_cart_line_number := NULL;

Line 623: update icx_shopping_carts

619: else
620: l_cart_line_number := l_cart_line_number + 1;
621: end if;
622:
623: update icx_shopping_carts
624: set last_update_date = sysdate
625: where cart_id = l_cart_id;
626:
627: commit;