APPS.ICX_REQ_SEARCH dependencies on ICX_SHOPPING_CARTS

Line 822: from icx_shopping_carts

818: deliver_to_location_id,
819: destination_organization_id,
820: deliver_to_location,
821: org_id
822: from icx_shopping_carts
823: where cart_id = v_cart_id;
824: -- and nvl(org_id,-9999) = nvl(v_org_id,-9999);
825:
826:

Line 885: from icx_shopping_carts

881: l_line_id := Line_Id(i);
882:
883: /* semaphore for getting max line number */
884: select 1 into l_dummy
885: from icx_shopping_carts
886: where cart_id = l_cart_id
887: for update;
888:
889: l_cart_line_number := NULL;

Line 900: update icx_shopping_carts

896: else
897: l_cart_line_number := l_cart_line_number + 1;
898: end if;
899:
900: update icx_shopping_carts
901: set last_update_date = sysdate
902: where cart_id = l_cart_id;
903:
904: commit;