752: -- SECHAWLA 18-OCT-04 3924244 : new declarations
753: -- check if item already exists in inventory
754: CURSOR l_mtlsystemitems_csr(cp_inv_item_number IN VARCHAR2) IS
755: SELECT count(*)
756: FROM MTL_SYSTEM_ITEMS_B
757: WHERE segment1 = cp_inv_item_number;
758:
759: l_item_cnt NUMBER;
760:
1861:
1862: -- This cursor is used to make sure that the item exists in active state, before removing the item
1863: CURSOR l_mtlsysitems_csr(p_inventory_item_id NUMBER,p_organization_id NUMBER) IS
1864: SELECT 'x'
1865: FROM mtl_system_items_b
1866: WHERE inventory_item_id = p_inventory_item_id
1867: AND organization_id = p_organization_id
1868: AND end_date_active IS NULL;
1869: */