2023: -- cursor to check is inventory id is valid.
2024: --
2025: cursor csr_order_line is
2026: select null
2027: from oe_order_lines_all
2028: where inventory_item_id = p_inventory_item_id and
2029: org_id = p_organization_id;
2030:
2031: cursor csr_order_line_exist is
2029: org_id = p_organization_id;
2030:
2031: cursor csr_order_line_exist is
2032: select null
2033: from oe_order_lines_all
2034: where inventory_item_id = l_old_inventory_item_id and
2035: org_id = l_old_organization_id;
2036:
2037: