APPS.ICX_REQ_COPY_REQ dependencies on ICX_SHOPPING_CARTS

Line 563: -- SELECT icx_shopping_carts_s.NEXTVAL

559:
560: COMMIT; /* avoid locking problem (?!) */
561:
562: --changed by alex for attachment
563: -- SELECT icx_shopping_carts_s.NEXTVAL
564: -- INTO v_cart_id
565: -- FROM SYS.DUAL;
566: --new code:
567: SELECT PO_REQUISITION_HEADERS_S.NEXTVAL

Line 573: INSERT INTO icx_shopping_carts (

569: FROM SYS.DUAL;
570:
571: -- The reserve_po_num column is now updated to NULL from the earlier
572: -- value of attribute7.
573: INSERT INTO icx_shopping_carts (
574: cart_id,
575: last_update_date,
576: last_updated_by,
577: creation_date,