2017: -- cursor to check is inventory id is valid.
2018: --
2019: cursor csr_order_line is
2020: select null
2021: from oe_order_lines_all
2022: where inventory_item_id = p_inventory_item_id and
2023: org_id = p_organization_id;
2024:
2025: cursor csr_order_line_exist is
2023: org_id = p_organization_id;
2024:
2025: cursor csr_order_line_exist is
2026: select null
2027: from oe_order_lines_all
2028: where inventory_item_id = l_old_inventory_item_id and
2029: org_id = l_old_organization_id;
2030:
2031: