APPS.ICX_REQ_SPECIAL_ORD dependencies on ICX_SHOPPING_CART_LINES

Line 780: -- SELECT icx_shopping_cart_lines_s.nextval INTO l_cart_line_id

776: FETCH cart_header_details INTO v_cart_header_rec;
777: CLOSE cart_header_details;
778:
779: --changed by alex for attachment
780: -- SELECT icx_shopping_cart_lines_s.nextval INTO l_cart_line_id
781: -- FROM DUAL;
782: --new code:
783: SELECT PO_REQUISITION_LINES_S.nextval INTO l_cart_line_id
784: FROM DUAL;

Line 789: FROM icx_shopping_cart_lines

785:
786:
787: /* Select the max of the cart_line_number for ordering */
788: SELECT max(cart_line_number) + 1 into v_cart_line_number
789: FROM icx_shopping_cart_lines
790: WHERE cart_id = v_cart_id;
791:
792: IF v_cart_line_number IS NULL THEN
793: /* This is the first one */

Line 797: INSERT INTO icx_shopping_cart_lines

793: /* This is the first one */
794: v_cart_line_number := 1;
795: END IF;
796:
797: INSERT INTO icx_shopping_cart_lines
798: (
799: CART_LINE_ID,
800: LAST_UPDATE_DATE,
801: LAST_UPDATED_BY,

Line 899: FROM icx_shopping_cart_lines

895:
896: /* get the order total; do this after custom defaults as it clould
897: modify the price or quantity */
898: SELECT SUM(quantity * unit_price) INTO l_order_total
899: FROM icx_shopping_cart_lines
900: WHERE cart_id = v_cart_id;
901:
902: icx_req_navigation.get_currency(v_cart_header_rec.destination_organization_id,
903: l_currency, l_precision, l_fmt_mask);