35:
36:
37: Cursor Get_owner_id IS
38: SELECT item_owner_id
39: FROM ams_item_attributes
40: WHERE inventory_item_id = p_inventory_item_id
41: AND organization_id = p_organization_id;
42:
43: l_return_status_cue VARCHAR2(1);
146: AND inventory_item_id = p_inventory_item_id;
147:
148: Cursor Get_owner_id IS
149: SELECT item_owner_id
150: FROM ams_item_attributes
151: WHERE inventory_item_id = p_inventory_item_id
152: AND organization_id = p_organization_id;
153:
154: l_return_status_cue VARCHAR2(1);