APPS.ICX_REQ_SUBMIT dependencies on ICX_CART_LINE_DISTRIBUTIONS

Line 1936: update icx_cart_line_distributions

1932: where CART_ID = v_cart_id
1933: and CART_LINE_ID = icx_cart_line_ida(i);
1934: --end modification
1935:
1936: update icx_cart_line_distributions
1937: set LAST_UPDATE_DATE = sysdate,
1938: CHARGE_ACCOUNT_SEGMENT1 = decode(c_charge_acct_seg1a,
1939: 0, CHARGE_ACCOUNT_SEGMENT1,
1940: a_charge_acct_seg1a(i)),

Line 2157: update icx_cart_line_distributions

2153: v_budget_acct_id,
2154: v_accrual_acct_id,
2155: v_return_code);
2156:
2157: update icx_cart_line_distributions
2158: set CHARGE_ACCOUNT_ID = v_account_id,
2159: ACCRUAL_ACCOUNT_ID = v_accrual_acct_id,
2160: VARIANCE_ACCOUNT_ID = v_variance_acct_id,
2161: BUDGET_ACCOUNT_ID = v_budget_acct_id

Line 2179: delete icx_cart_line_distributions

2175: icx_req_custom.reqs_validate_line(emergency, v_cart_id);
2176:
2177: --empty lines
2178: for prec in line_ids(v_cart_id) loop
2179: delete icx_cart_line_distributions
2180: where cart_line_id = prec.cart_line_id;
2181: end loop;
2182: delete icx_shopping_cart_lines
2183: where (quantity is null

Line 2305: delete icx_cart_line_distributions

2301: delete icx_shopping_carts
2302: where cart_id = v_cart_id
2303: and shopper_id = v_shopper_id;
2304:
2305: delete icx_cart_line_distributions
2306: where cart_id = v_cart_id;
2307:
2308: delete icx_shopping_cart_lines
2309: where cart_id = v_cart_id;