APPS.ICX_REQ_NAVIGATION dependencies on ICX_CART_LINE_DISTRIBUTIONS

Line 1335: FROM icx_cart_line_distributions

1331: and b.cart_id = v_cart_id;
1332:
1333: cursor reqdistributions(v_cart_id number, v_cart_line_id number) IS
1334: SELECT distribution_id, charge_account_id
1335: FROM icx_cart_line_distributions
1336: WHERE cart_id = v_cart_id
1337: AND cart_line_id = v_cart_line_id;
1338:
1339: l_item_number varchar2(80);

Line 1749: select icx_cart_line_distributions_s.nextval into v_line_dist_id from dual;

1745: and cart_line_id = v_cart_line_id;
1746:
1747: end if;
1748:
1749: select icx_cart_line_distributions_s.nextval into v_line_dist_id from dual;
1750: l_dist_num := l_dist_num + 1;
1751:
1752: insert into icx_cart_line_distributions
1753: (cart_line_id,

Line 1752: insert into icx_cart_line_distributions

1748:
1749: select icx_cart_line_distributions_s.nextval into v_line_dist_id from dual;
1750: l_dist_num := l_dist_num + 1;
1751:
1752: insert into icx_cart_line_distributions
1753: (cart_line_id,
1754: cart_id,
1755: distribution_id,
1756: last_updated_by,

Line 1809: UPDATE icx_cart_line_distributions

1805: v_dist_num := 1;
1806:
1807: FOR distribution IN reqdistributions(v_cart_id, v_cart_line_id) LOOP
1808:
1809: UPDATE icx_cart_line_distributions
1810: SET distribution_num = v_dist_num
1811: WHERE cart_id = v_cart_id
1812: AND cart_line_id = v_cart_line_id
1813: AND distribution_id = distribution.distribution_id;