APPS.ICX_REQ_ORDER dependencies on ICX_CART_LINE_DISTRIBUTIONS

Line 1799: from icx_cart_line_distributions

1795: and cart_line_id = v_cart_line_id;
1796:
1797: cursor get_dist_number(v_cart_id number,v_cart_line_id number,v_org_id number) is
1798: select *
1799: from icx_cart_line_distributions
1800: where cart_id = v_cart_id
1801: and cart_line_id = v_cart_line_id
1802: and nvl(org_id,-9999) = nvl(v_org_id,-9999);
1803:

Line 1881: INSERT INTO icx_cart_line_distributions

1877:
1878:
1879: for prec in get_dist_number(l_cart_id,cartLineId,l_org_id) loop
1880:
1881: INSERT INTO icx_cart_line_distributions
1882: (cart_line_id,
1883: distribution_id,
1884: last_updated_by,
1885: last_update_date,

Line 1927: icx_cart_line_distributions_s.nextval,

1923: charge_account_segment28,
1924: charge_account_segment29,
1925: charge_account_segment30)
1926: VALUES (l_cart_line_id,
1927: icx_cart_line_distributions_s.nextval,
1928: prec.last_updated_by,
1929: sysdate,
1930: prec.last_updated_by,
1931: sysdate,

Line 2022: delete from icx_cart_line_distributions

2018: where cart_line_id = cartLineId
2019: and cart_id = l_cart_id;
2020: -- and nvl(org_id,-9999) = nvl(l_org_id,-9999);
2021:
2022: delete from icx_cart_line_distributions
2023: where cart_line_id = cartLineId
2024: and cart_id = l_cart_id;
2025:
2026: update icx_shopping_cart_lines