APPS.ICX_REQ_COPY_REQ dependencies on ICX_CART_LINE_DISTRIBUTIONS

Line 511: FROM icx_cart_line_distributions

507: ORDER BY line_num;
508:
509: cursor reqdistributions(l_cart_id number, l_cart_line_id number) IS
510: SELECT distribution_id, charge_account_id
511: FROM icx_cart_line_distributions
512: WHERE cart_id = l_cart_id
513: AND cart_line_id = l_cart_line_id;
514:
515:

Line 830: INSERT INTO icx_cart_line_distributions

826: '');
827:
828:
829: -- Create multiple line distributions
830: INSERT INTO icx_cart_line_distributions
831: (cart_line_id,
832: cart_id,
833: distribution_id,
834: last_updated_by,

Line 849: icx_cart_line_distributions_s.nextval,

845: allocation_value,
846: allocation_quantity)
847: SELECT v_cart_line_id,
848: v_cart_id,
849: icx_cart_line_distributions_s.nextval,
850: v_shopper_id,
851: sysdate,
852: v_shopper_id,
853: sysdate,

Line 880: UPDATE icx_cart_line_distributions

876: v_dist_num := 1;
877:
878: FOR distribution IN reqdistributions(v_cart_id, v_cart_line_id) LOOP
879:
880: UPDATE icx_cart_line_distributions
881: SET distribution_num = v_dist_num
882: WHERE cart_id = v_cart_id
883: AND cart_line_id = v_cart_line_id
884: AND distribution_id = distribution.distribution_id;