APPS.ICX_REQ_ORDER dependencies on ICX_SHOPPING_CARTS

Line 1819: from icx_shopping_carts

1815: if l_cart_line_number is not NULL and l_cart_line_number > 0 then
1816:
1817: /* semaphore for getting max line number */
1818: select 1 into l_dummy
1819: from icx_shopping_carts
1820: where cart_id = l_cart_id
1821: for update;
1822:
1823: update icx_shopping_cart_lines

Line 1973: update icx_shopping_carts

1969: prec.charge_account_segment30);
1970: end loop;
1971:
1972:
1973: update icx_shopping_carts
1974: set last_update_date = sysdate
1975: where cart_id = l_cart_id;
1976: /* close semaphore */
1977:

Line 2013: from icx_shopping_carts

2009: if l_cart_line_number is not NULL and l_cart_line_number > 0 then
2010:
2011: /* semaphore for getting max line number */
2012: select 1 into l_dummy
2013: from icx_shopping_carts
2014: where cart_id = l_cart_id
2015: for update;
2016:
2017: delete from icx_shopping_cart_lines

Line 2031: update icx_shopping_carts

2027: set cart_line_number = cart_line_number - 1
2028: where cart_id = l_cart_id
2029: and cart_line_number > l_cart_line_number;
2030:
2031: update icx_shopping_carts
2032: set last_update_date = sysdate
2033: where cart_id = l_cart_id;
2034: /* close semaphore */
2035:

Line 2571: update icx_shopping_carts

2567:
2568:
2569: l_po_num := reserved_po_num;
2570: if l_po_num is not NULL then
2571: update icx_shopping_carts
2572: set reserved_po_num = l_po_num
2573: where cart_id = l_cart_id;
2574: end if;
2575: commit;