269: AND organization_id = pn_chk_organization_id;
270:
271: CURSOR chk_loc_cur IS
272: SELECT COUNT(location_id)
273: FROM jai_cmn_inventory_orgs
274: WHERE organization_id = pn_chk_organization_id
275: AND location_id = pn_chk_location_id;
276:
277: CURSOR chk_combination_cur IS
275: AND location_id = pn_chk_location_id;
276:
277: CURSOR chk_combination_cur IS
278: SELECT COUNT(b.organization_id)
279: FROM jai_cmn_inventory_orgs a
280: , org_organization_definitions b
281: WHERE b.operating_unit = pn_chk_org_id
282: AND a.organization_id = pn_chk_organization_id
283: AND a.location_id = pn_chk_location_id