4761: ,x_msg_count OUT NOCOPY NUMBER) IS
4762:
4763: cursor location_shipping_method_count(c_from_org_id number, c_to_location_id number) IS
4764: SELECT count(*)
4765: FROM MTL_INTERORG_SHIP_METHODS ISM,HR_ALL_ORGANIZATION_UNITS hao
4766: where hao.organization_id = c_from_org_id
4767: and ism.from_location_id = hao.location_id
4768: and ism.to_location_id = c_to_location_id;
4769:
7577: and lookup_code = l_item_type;
7578:
7579: CURSOR get_location_id(c_org_id NUMBER) IS
7580: select location_id
7581: from HR_ALL_ORGANIZATION_UNITS
7582: where organization_id = c_org_id;
7583:
7584: CURSOR get_item_number(c_item_id NUMBER, c_org_id NUMBER) IS
7585: select CONCATENATED_SEGMENTS