DBA Data[Home] [Help]

APPS.ICX_REQ_ACCT_DIST dependencies on ICX_REQ_CART_ERRORS

Line 1394: FROM icx_req_cart_errors

1390: v_error_text VARCHAR2(200) := NULL;
1391:
1392: CURSOR distribution_errors(l_cart_id NUMBER, l_cart_line_id NUMBER) IS
1393: SELECT COUNT(distribution_num)
1394: FROM icx_req_cart_errors
1395: WHERE cart_id = l_cart_id
1396: AND cart_line_id = l_cart_line_id
1397: AND distribution_num IS NOT NULL;
1398:

Line 1784: DELETE FROM icx_req_cart_errors

1780: RETURN;
1781: END IF; /* IF v_percenet_total */
1782:
1783: -- Delete the error messages for the distribution
1784: DELETE FROM icx_req_cart_errors
1785: WHERE cart_id = v_cart_id
1786: AND cart_line_id = v_cart_line_id
1787: AND distribution_num IS NOT NULL;
1788:

Line 2203: FROM icx_req_cart_errors

2199: v_cart_line_id IN NUMBER) IS
2200:
2201: CURSOR get_errors(l_cart_id NUMBER) IS
2202: SELECT error_text
2203: FROM icx_req_cart_errors
2204: WHERE cart_id = v_cart_id
2205: AND cart_line_id = v_cart_line_id
2206: AND distribution_num IS NOT NULL;
2207: