APPS.ICX_REQ_NAVIGATION dependencies on ICX_SHOPPING_CART_LINES

Line 1327: icx_shopping_cart_lines b

1323:
1324: cursor get_item_number(v_cart_id number,v_cart_line_id number) is
1325: select concatenated_segments
1326: from mtl_system_items_kfv a,
1327: icx_shopping_cart_lines b
1328: where a.inventory_item_id = b.item_id
1329: and a.organization_id = b.destination_organization_id
1330: and b.cart_line_id = v_cart_line_id
1331: and b.cart_id = v_cart_id;

Line 1614: -- select icx_shopping_cart_lines_s.nextval into v_cart_line_id from dual;

1610:
1611: l_cart_line_number := l_cart_line_number + 1;
1612:
1613: --changed by alex for attachment
1614: -- select icx_shopping_cart_lines_s.nextval into v_cart_line_id from dual;
1615: -- new code:
1616: select PO_REQUISITION_LINES_S.nextval into v_cart_line_id from dual;
1617:
1618:

Line 1619: insert into icx_shopping_cart_lines (

1615: -- new code:
1616: select PO_REQUISITION_LINES_S.nextval into v_cart_line_id from dual;
1617:
1618:
1619: insert into icx_shopping_cart_lines (
1620: cart_line_id,
1621: cart_line_number,
1622: last_update_date,
1623: last_updated_by,

Line 1742: update icx_shopping_cart_lines

1738: close get_item_number;
1739:
1740: if l_item_number is not NULL then
1741:
1742: update icx_shopping_cart_lines
1743: set item_number = l_item_number
1744: where cart_id = v_cart_id
1745: and cart_line_id = v_cart_line_id;
1746:

Line 1800: -- This is required as the view of ICX_SHOPPING_CART_LINES_V has

1796: icx_req_acct2.update_account_by_id(v_cart_id,v_cart_line_id,v_org_id,v_line_dist_id,l_dist_num);
1797:
1798:
1799: -- Update the distribution num column in distributions table.
1800: -- This is required as the view of ICX_SHOPPING_CART_LINES_V has
1801: -- join condition as DISTRIBUTION_NUM = 1.
1802: -- The reqs from sources other than web reqs may not have populated
1803: -- the distribuion number.
1804: